[Home] [Help]
PACKAGE: APPS.PA_PROJECT_INTEGRATION_PUB
Source
1 PACKAGE PA_PROJECT_INTEGRATION_PUB AUTHID DEFINER AS
2 /* $Header: PAPRJINTS.pls 120.4 2011/05/16 11:25:51 smijosep noship $ */
3
4
5 /* This variable will be referenced in ShortcutDropListCO.java to
6 conditionally execute the AIA integration code only if AIA patch is installed.*/
7 -- Bug 12551819: This file version included in AIA patch will have it initialized to 'Y'
8 AIA_INSTALLED VARCHAR2(1) := 'Y';
9
10 -- perf change added below declaration 8894180
11
12 TYPE g_VC_25 is table of varchar2(25) index by binary_integer;
13 TYPE g_VC_80 is table of varchar2(80) index by binary_integer;
14 TYPE g_num is table of number index by binary_integer;
15 TYPE g_date is table of date index by binary_integer;
16
17
18 -- perf change added below declaration 8894180
19
20 g_res_pm_project_reference g_vc_25;
21 g_res_pa_project_id g_num;
22 g_res_pa_struct_version_id g_num;
23 g_res_pa_task_number g_vc_25;
24 g_res_pm_task_reference g_vc_25;
25 g_res_pa_task_id g_num;
26 g_res_pa_task_elem_ver_id g_num;
27 g_res_pm_task_asgmt_reference g_vc_25;
28 g_res_pa_task_assignment_id g_num;
29 g_res_resource_alias g_vc_80;
30 g_res_resource_list_member_id g_num;
31 g_res_start_date g_date;
32 g_res_end_date g_date;
33 g_res_planned_quantity g_num;
34 g_res_planned_total_raw_cost g_num;
35 g_res_planned_total_bur_cost g_num;
36
37 /** per change 8894180
38
39 g_res_pm_project_reference PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) ;
40 g_res_pa_project_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
41 g_res_pa_struct_version_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
42 g_res_pa_task_number PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
43 g_res_pm_task_reference PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
44 g_res_pa_task_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
45 g_res_pa_task_elem_ver_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
46 g_res_pm_task_asgmt_reference PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
47 g_res_pa_task_assignment_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
48 g_res_resource_alias PA_VC_1000_80 := PA_VC_1000_80(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
49 g_res_resource_list_member_id PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
50 g_res_start_date PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE);
51 g_res_end_date PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE);
52 g_res_planned_quantity PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
53 g_res_planned_total_raw_cost PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
54 g_res_planned_total_bur_cost PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
55
56 **/
57
58 g_res_counter number := 1;
59
60
61
62 TYPE task_com_id_tbl_type IS TABLE OF VARCHAR2(240) index by binary_integer ;
63
64 TYPE task_id_ref_tbl_type IS TABLE OF INTEGER INDEX BY VARCHAR2(25);
65
66 TYPE g_num_tbl is table of number index by binary_integer;
67 TYPE g_var_tbl is table of varchar2(25) index by binary_integer;
68
69 g_res_com_id_tbl task_com_id_tbl_type ;
70 g_res_id_ref_tbl task_id_ref_tbl_type ;
71
72
73 PROCEDURE SYNC_BUDGETS(
74 X_budget_OUT OUT nocopy SYSTEM.budget_OUT_OBJ_TBL
75 ,X_RETURN_STATUS OUT NOCOPY VARCHAR2
76 ,P_SYNC_MODE IN CHAR := 'S'
77 ,P_budget_IN IN SYSTEM.budget_IN_OBJ_TBL
78 );
79
80 PROCEDURE SYNC_PROJECTS(
81 -- X_RETURN_STATUS_OBJ_TBL OUT PROJ_RET_STATUS_OBJ_TBL
82 X_CP_REQUEST_OBJ_TBL OUT nocopy SYSTEM.PROJ_CP_REQ_OBJ_TBL
83 ,X_PROJECTS_OUT OUT nocopy SYSTEM.PROJECT_OUT_OBJ_TBL
84 ,X_RETURN_STATUS OUT nocopy VARCHAR2
85 ,P_SYNC_MODE IN CHAR := 'S'
86 ,P_PROJECTS_IN IN SYSTEM.PROJECT_IN_OBJ_TBL
87 -- ,P_KEY_MEMBER_OBJ IN KEY_MEMBER_OBJ
88 );
89
90
91
92 PROCEDURE LOAD_PROJECT_IN_REC(
93 P_PROJECT_IN_OBJ IN SYSTEM.PROJECT_IN_OBJ ,
94 x_project_in_rec out nocopy pa_project_pub.project_in_rec_type,
95 x_task_in_tbl out nocopy pa_project_pub.task_in_tbl_type,
96 x_structure_in_rec out nocopy pa_project_pub.structure_in_rec_type,
97 x_task_com_id_tbl out nocopy task_com_id_tbl_type,
98 x_task_id_ref_tbl out nocopy task_id_ref_tbl_type,
99 x_res_com_id_tbl out nocopy task_com_id_tbl_type ,
100 x_res_id_ref_tbl out nocopy task_id_ref_tbl_type ,
101 x_delete_task_VER_id_tbl out nocopy g_num_tbl,
102 x_delete_task_id_tbl out nocopy g_num_tbl,
103 X_RETURN_STATUS out nocopy VARCHAR2,
104 x_RETURN_MESSAGE OUT nocopy VARCHAR2 ) ;
105
106 PROCEDURE WRITE_LOG (
107 p_module in varchar2,
108 p_msg in varchar2
109 ) ;
110
111 procedure wbs_order (
112 P_TASK_IN_OBJ_TABLE IN SYSTEM.TASK_IN_OBJ_TBL,
113 P_PROJECT_IN_REC IN PA_PROJECT_PUB.PROJECT_IN_REC_TYPE ,
114 P_STRUCTURE_IN_REC IN PA_PROJECT_PUB.STRUCTURE_IN_REC_TYPE,
115 X_TASK_IN_OBJ_TABLE OUT NOCOPY SYSTEM.TASK_IN_OBJ_TBL,
116 X_DELETE_TASK_VER_ID_TBL OUT NOCOPY G_NUM_TBL,
117 X_DELETE_TASK_ID_TBL OUT NOCOPY G_NUM_TBL
118 );
119
120 procedure DELETE_TASK_PVT(
121 p_project_in_rec IN pa_project_pub.project_in_rec_type,
122 p_structure_in_rec IN pa_project_pub.structure_in_rec_type,
123 p_delete_task_ver_id_tbl IN G_NUM_TBL,
124 p_delete_task_id_tbl IN G_NUM_TBL,
125 x_del_task_out_obj_tbl OUT NOCOPY SYSTEM.delete_TASK_OUT_obj_TBL,
126 x_del_task_status OUT NOCOPY varchar2,
127 x_del_task_msg_data OUT NOCOPY varchar2
128 );
129
130 procedure DELETE_RES_ASSGN_PVT (
131 p_project_in_rec IN pa_project_pub.project_in_rec_type,
132 p_structure_in_rec IN pa_project_pub.structure_in_rec_type,
133 p_res_pa_task_assignment_id IN g_num,
134 x_DEL_RES_ASGMT_OBJ_TBL OUT NOCOPY SYSTEM.delete_RES_ASGMT_OUT_OBJ_TBL,
135 x_DEL_RES_ASSGMT_STATUS OUT NOCOPY varchar2,
136 x_del_res_msg_data OUT NOCOPY varchar2
137 ) ;
138
139 PROCEDURE COPY_PROJECT_INT_OPTIONS ( P_ORIG_PROJECT_ID IN NUMBER,
140 P_PROJECT_ID IN NUMBER ,
141 X_RETURN_STATUS OUT NOCOPY VARCHAR2 ,
142 X_MSG_COUNT OUT NOCOPY NUMBER ,
143 X_MSG_DATA OUT NOCOPY VARCHAR2 );
144
145 PROCEDURE get_project_org_name (
146 X_org_name OUT NOCOPY VARCHAR2
147 ,x_return_status OUT NOCOPY varchar2
148 ,x_msg_data OUT NOCOPY varchar2
149 ,p_CREATED_FROM_PROJECT_NUMBER IN VARCHAR2
150 ,P_pa_project_id IN Number
151 );
152
153
154 END PA_PROJECT_INTEGRATION_PUB;
155