Package Name: Project Pub
Internal Name: PA_PROJECT_PUB
Description: This package contains the
public AMG APIs for project and task information
APIs (Functions and Procedures):
Name
|
Internal
Name
|
Description
|
Create Multiple
Projects-Clear Project
|
CLEAR_PROJECT
|
This API procedure is used
to clear the global structures setup during the load process In order to
execute this API the following list of API's should be executed in the order
of sequence.
|
Create Multiple
Projects-Execute Create Project
|
EXECUTE_CREATE_PROJECT
|
This Load Execute Fetch API
is used to create a project and its tasks using the data stored in the global
tables during the Load process In order to execute this API the following
list of API's should be executed in the order of sequence.
|
Create Multiple
Projects-Execute Update Project
|
EXECUTE_UPDATE_PROJECT
|
This API procedure is used
to update an existing project, including changing or adding project data,
adding new tasks, and updating existing tasks.
|
Create Multiple
Projects-Init Project
|
INIT_PROJECT
|
This API procedure is used
to the global data structures. Other Load-Execute-Fetch use the structures to
create a new project in Oracle Projects In order to execute this API the
following list of API's should be executed in the order of sequence.
|
Create Multiple
Projects-Load Class Category
|
LOAD_CLASS_CATEGORY
|
This Load Execute Fetch API
is used to load class categories to a global PL/SQL table.
|
Create Multiple
Projects-Load Key Member
|
LOAD_KEY_MEMBER
|
This Load Execute Fetch API
is used to use to load key members to a global PL/SQL table.
|
Create Multiple
Projects-Load Project
|
LOAD_PROJECT
|
This API is used to use to
load a project to a global PL/SQL record.
|
Create Multiple Tasks-Fetch
|
FETCH_TASK
|
This Load Execute Fetch API
is used to fetch output parameters related to tasks.
|
Create Multiple Tasks-Load
|
LOAD_TASK
|
This API is used to load a
task to a global PL/SQL table.
|
Create Project
|
CREATE_PROJECT
|
This API creates a project
in the Oracle Projects using a Template or existing project.
|
Create Task
|
ADD_TASK
|
This API is used to add new
subtasks to a task of a project in Oracle Projects.
|
Delete Project
|
DELETE_PROJECT
|
This API procedure is used
to delete a project and its tasks from Oracle Projects
|
Delete Task
|
DELETE_TASK
|
This API is used to delete
tasks of a project in Oracle Projects
|
Update Task
|
UPDATE_TASK
|
This API is used to update
existing tasks of a project in Oracle Projects.
|
Update project
|
UPDATE_PROJECT
|
This API procedure pushes
project and task information from your external system to Oracle Projects to
reflect any changes you have made in the external system
|
Validate Project Deletion
|
CHECK_DELETE_PROJECT_OK
|
This API is used to
determine if you can delete a project.
|
Validate Project
Organization Change
|
CHECK_CHANGE_PROJECT_ORG_OK
|
This API is used to
determine if you can change the CARRYING_OUT_ORGANIZATION_ID field for a
particular project or task.
|
Verify Parent Change
|
CHECK_CHANGE_PARENT_OK
|
This API is used to
determine if you can move a task from one parent task to another.
|
Verify Project Reference
Uniqueness
|
CHECK_UNIQUE_PROJECT_REFERENCE
|
This API is used to
determine if a new or changed project reference (PM_PROJECT_REFERENCE) is
unique.
|
Verify Subtask Addition
|
CHECK_ADD_SUBTASK_OK
|
This API is used to
determine if a subtask can be added to a parent task.
|
Verify Task Deletion
|
CHECK_DELETE_TASK_OK
|
This API is used to
determine if you can delete a task.
|
Verify Task Number Change
|
CHECK_TASK_NUMBER_CHANGE_OK
|
This API is used to
determine if you can change a tasks number.
|
Verify Task Number
Uniqueness
|
CHECK_UNIQUE_TASK_NUMBER
|
This API is used to
determine if a new or changed task number is unique within a project.
|
Verify Task Reference
Uniqueness
|
CHECK_UNIQUE_TASK_REFERENCE
|
This API is used to
determine if a new or changed task reference (PM_TASK_REFERENCE) is unique.
|