1 PACKAGE PA_ORG_CLIENT_EXTN AS
2 -- $Header: PAXORCES.pls 120.5 2006/07/05 10:45:13 sunkalya noship $
3 /*#
4 * The Verify Organization Change Extension enables you to build business rules to determine whether an organization change is allowed
5 * for a Project/Task Owning Organization, and to define the error messages that are used when the rules are violated.
6 * @rep:scope public
7 * @rep:product PA
8 * @rep:lifecycle active
9 * @rep:displayname Verify Organization Change.
10 * @rep:compatibility S
11 * @rep:category BUSINESS_ENTITY PA_PROJECT
12 * @rep:category BUSINESS_ENTITY PA_TASK
13 * @rep:doccd 120pjapi.pdf See the Oracle Projects API's, Client Extensions, and Open Interfaces Reference
14 */
15
16
17
18 /*#
19 * Oracle Projects provides this client extension to extend business rules for organization changes.
20 * @param X_insert_update_mode Flag indicating whether the project or task record is inserted or updated.
21 * Value = INSERT if the project or task record has not been saved in the database. Value = UPDATE if the
22 * record exists in the database.
23 * @rep:paraminfo {@rep:required}
24 * @param X_calling_module The calling module. The value is PAXPREPR if this extension is called from the
25 * Projects window. The value is PAXBAUPD if this extension is called from the Process Mass.
26 * @rep:paraminfo {@rep:required}
27 * @param X_project_id Identifier of the project to be updated
28 * @rep:paraminfo {@rep:required}
29 * @param X_task_id Identifier of the task to be updated. The value is NULL when the extension is called
30 * to verify a project organization change.
31 * @rep:paraminfo {@rep:required}
32 * @param X_old_organization_id Identifier of the current organization of the project or task
33 * @rep:paraminfo {@rep:required}
34 * @param X_new_organization_id Identifier of the new organization to be assigned to the project or task
35 * @rep:paraminfo {@rep:required}
36 * @param X_project_type Identifier of the project type of the project
37 * @rep:paraminfo {@rep:required}
38 * @param X_project_start_date Start date of the project
39 * @rep:paraminfo {@rep:required}
40 * @param X_project_end_date End date of the project
41 * @rep:paraminfo {@rep:required}
42 * @param X_public_sector_flag Public sector flag on the project
43 * @rep:paraminfo {@rep:required}
44 * @param X_task_manager_person_id Identifier of the manager of the task
45 * @rep:paraminfo {@rep:required}
46 * @param X_Service_type Service type code of the task
47 * @rep:paraminfo {@rep:required}
48 * @param X_task_start_date Start date of the task.
49 * @rep:paraminfo {@rep:required}
50 * @param X_task_end_date End date of the task
51 * @rep:paraminfo {@rep:required}
52 * @param X_entered_by_user_id Identifier of the user who entered the project or task
53 * @rep:paraminfo {@rep:required}
54 * @param X_attribute_category Descriptive flexfield category of the project or task
55 * @rep:paraminfo {@rep:required}
56 * @param X_attribute1 Descriptive flexfield segment
57 * @rep:paraminfo {@rep:required}
58 * @param X_attribute2 Descriptive flexfield segment
59 * @rep:paraminfo {@rep:required}
60 * @param X_attribute3 Descriptive flexfield segment
61 * @rep:paraminfo {@rep:required}
62 * @param X_attribute4 Descriptive flexfield segment
63 * @rep:paraminfo {@rep:required}
64 * @param X_attribute5 Descriptive flexfield segment
65 * @rep:paraminfo {@rep:required}
66 * @param X_attribute6 Descriptive flexfield segment
67 * @rep:paraminfo {@rep:required}
68 * @param X_attribute7 Descriptive flexfield segment
69 * @rep:paraminfo {@rep:required}
70 * @param X_attribute8 Descriptive flexfield segment
71 * @rep:paraminfo {@rep:required}
72 * @param X_attribute9 Descriptive flexfield segment
73 * @rep:paraminfo {@rep:required}
74 * @param X_attribute10 Descriptive flexfield segment
75 * @rep:paraminfo {@rep:required}
76 * @param X_pm_product_code Identifier of the external system from which the project was imported
77 * @rep:paraminfo {@rep:required}
78 * @param X_pm_project_reference The reference code that uniquely identifies the project in the external system
79 * @rep:paraminfo {@rep:required}
80 * @param X_pm_task_reference The reference code that identifies the task in the external system
81 * @rep:paraminfo {@rep:required}
82 * @param X_functional_security_flag Flag indicating whether the user is permitted to change the organization.
83 * The value is Y if the user's responsibility has the function Project: Org Update: Override Standard Checks.
84 * Otherwise, the value is N.
85 * @rep:paraminfo {@rep:required}
86 * @param X_outcome The message error code if a verification rule is violated or if there is a database error.
87 * @rep:paraminfo {@rep:required}
88 * @rep:scope public
89 * @rep:lifecycle active
90 * @rep:displayname Verify Organization Change
91 * @rep:compatibility S
92 */
93
94
95 PROCEDURE verify_org_change(X_insert_update_mode IN VARCHAR2
96 , X_calling_module IN VARCHAR2
97 , X_project_id IN NUMBER
98 , X_task_id IN NUMBER
99 , X_old_organization_id IN NUMBER
100 , X_new_organization_id IN NUMBER
101 , X_project_type IN VARCHAR2
102 , X_project_start_date IN DATE
103 , X_project_end_date IN DATE
104 , X_public_sector_flag IN VARCHAR2
105 , X_task_manager_person_id IN NUMBER
106 , X_Service_type IN VARCHAR2
107 , X_task_start_date IN DATE
108 , X_task_end_date IN DATE
109 , X_entered_by_user_id IN NUMBER
110 , X_attribute_category IN VARCHAR2
111 , X_attribute1 IN VARCHAR2
112 , X_attribute2 IN VARCHAR2
113 , X_attribute3 IN VARCHAR2
114 , X_attribute4 IN VARCHAR2
115 , X_attribute5 IN VARCHAR2
116 , X_attribute6 IN VARCHAR2
117 , X_attribute7 IN VARCHAR2
118 , X_attribute8 IN VARCHAR2
119 , X_attribute9 IN VARCHAR2
120 , X_attribute10 IN VARCHAR2
121 , X_pm_product_code IN VARCHAR2
122 , X_pm_project_reference IN VARCHAR2
123 , X_pm_task_reference IN VARCHAR2
124 , X_functional_security_flag IN VARCHAR2
125 , X_outcome OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
126
127 END PA_ORG_CLIENT_EXTN;
128