1 PACKAGE inv_project AS
2 /* $Header: INVPRJIS.pls 120.1 2005/08/01 11:29:32 janetli noship $ */
3
4 Procedure resolve_project_references(
5 source_project_id IN number,
6 source_project_number IN OUT NOCOPY varchar2,
7 source_task_id IN number,
8 source_task_number IN OUT NOCOPY varchar2,
9 p_project_id IN number,
10 p_project_number IN OUT NOCOPY varchar2,
11 t_task_id IN number,
12 t_task_number IN OUT NOCOPY varchar2,
13 to_project_id IN number,
14 to_project_number IN OUT NOCOPY varchar2,
15 to_task_id IN number,
16 to_task_number IN OUT NOCOPY varchar2,
17 pa_expenditure_org_id IN number,
18 pa_expenditure_org IN OUT NOCOPY varchar2,
19 success IN OUT NOCOPY boolean ) ;
20
21
22 Procedure org_project_parameters(
23 org_id IN number,
24 p_project_reference_enabled OUT NOCOPY number,
25 p_pm_cost_collection_enabled OUT NOCOPY number,
26 p_project_control_level OUT NOCOPY number,
27 success OUT NOCOPY boolean);
28
29 Function onhand_qty(
30 org_id number,
31 sub_code varchar2,
32 loc_id number)return number ;
33
34 Function pending_in_temp(
35 org_id number,
36 sub_code varchar2,
37 loc_id number) return number ;
38
39
40 Function pending_in_interface(
41 org_id number,
42 sub_code varchar2,
43 loc_id number) return number ;
44
45
46 Procedure onhand_pending_trx(
47 org_id IN number,
48 sub_code IN varchar2,
49 locator_id IN number,
50 onhand OUT NOCOPY boolean,
51 pending_trx OUT NOCOPY boolean,
52 success OUT NOCOPY boolean);
53
54 Procedure populate_project_info(
55 FM_ORG_ID IN NUMBER,
56 TO_ORG_ID IN NUMBER,
57 FM_SUB IN VARCHAR2,
58 TO_SUB IN VARCHAR2,
59 FM_LOCATOR IN NUMBER,
60 TO_LOCATOR IN NUMBER,
61 F_PROJECT_ID IN OUT NOCOPY NUMBER,
62 F_TASK_ID IN OUT NOCOPY NUMBER,
63 T_PROJECT_ID IN OUT NOCOPY NUMBER,
64 T_TASK_ID IN OUT NOCOPY NUMBER,
65 ERROR_CODE OUT NOCOPY VARCHAR2,
66 ERROR_EXPL OUT NOCOPY VARCHAR2,
67 SRC_TYPE_ID IN NUMBER,
68 ACTION_ID IN NUMBER,
69 SOURCE_ID IN NUMBER ) ;
70
71 Procedure call_cust_val(
72 V_item_id IN number
73 ,V_revision IN varchar2 DEFAULT NULL
74 ,V_org_id IN number
75 ,V_sub_code IN varchar2
76 ,V_locator_id IN number DEFAULT NULL
77 ,V_xfr_org_id IN number DEFAULT NULL
78 ,V_xfr_sub_code IN varchar2 DEFAULT NULL
79 ,V_xfr_locator_id IN number DEFAULT NULL
80 ,V_quantity IN number
81 ,V_txn_type_id IN number
82 ,V_txn_action_id IN number DEFAULT NULL
83 ,V_txn_source_type_id IN number DEFAULT NULL
84 ,V_txn_source_id IN number DEFAULT NULL
85 ,V_txn_source_name IN varchar2 DEFAULT NULL
86 ,V_project_id IN number DEFAULT NULL
87 ,V_task_id IN OUT NOCOPY number
88 ,V_source_project_id IN number DEFAULT NULL
89 ,V_source_task_id IN OUT NOCOPY number
90 ,V_to_project_id IN number DEFAULT NULL
91 ,V_to_task_id IN OUT NOCOPY number
92 ,V_txn_date IN date
93 ,V_pa_expenditure_org_id IN number DEFAULT NULL
94 ,V_expenditure_type IN varchar2 DEFAULT NULL
95 ,V_calling_module IN varchar2
96 ,V_user_id IN number
97 ,V_error_mesg OUT NOCOPY varchar2
98 ,V_warning_mesg OUT NOCOPY varchar2
99 ,V_success_flag OUT NOCOPY number
100 ,V_attribute_category IN varchar2
101 ,V_attribute1 IN varchar2 DEFAULT NULL
102 ,V_attribute2 IN varchar2 DEFAULT NULL
103 ,V_attribute3 IN varchar2 DEFAULT NULL
104 ,V_attribute4 IN varchar2 DEFAULT NULL
105 ,V_attribute5 IN varchar2 DEFAULT NULL
106 ,V_attribute6 IN varchar2 DEFAULT NULL
107 ,V_attribute7 IN varchar2 DEFAULT NULL
108 ,V_attribute8 IN varchar2 DEFAULT NULL
109 ,V_attribute9 IN varchar2 DEFAULT NULL
110 ,V_attribute10 IN varchar2 DEFAULT NULL
111 ,V_attribute11 IN varchar2 DEFAULT NULL
112 ,V_attribute12 IN varchar2 DEFAULT NULL
113 ,V_attribute13 IN varchar2 DEFAULT NULL
114 ,V_attribute14 IN varchar2 DEFAULT NULL
115 ,V_attribute15 IN varchar2 DEFAULT NULL );
116
117
118 Procedure update_project_task(v_org_id number,
119 v_in_project_id number,
120 v_in_task_id number,
121 v_out_project_id in out NOCOPY number,
122 v_out_task_id in out NOCOPY number);
123 Procedure update_project_task_number(v_org_id number,
124 v_in_project_id number,
125 v_in_task_id number,
126 v_out_project_id in out NOCOPY number,
127 v_out_task_id in out NOCOPY number,
128 v_out_project in out NOCOPY varchar2,
129 v_out_task in out NOCOPY varchar2);
130 Procedure Get_project_info_from_Req(
131 x_Return_Status Out NOCOPY Varchar2,
132 x_Project_Id Out NOCOPY Number,
133 x_Task_Id Out NOCOPY Number,
134 P_Req_Line_Id In Number);
135
136 Procedure Get_project_info_for_RcvTrx(
137 x_Return_Status Out NOCOPY Varchar2,
138 x_Project_Id Out NOCOPY Number,
139 x_Task_Id Out NOCOPY Number,
140 P_Rcv_Trx_Id In Number);
141
142 Procedure Get_project_loc_for_prj_Req(
143 X_Return_Status Out NOCOPY Varchar2,
144 X_locator_Id In Out NOCOPY Number,
145 P_organization_id In Number,
146 P_Req_Line_Id In Number);
147
148 Procedure Set_Org_client_info(X_return_Status Out NOCOPY Varchar2,
149 P_Organization_Id In Number);
150
151 Procedure get_proj_task_from_lpn(
152 p_organization_Id IN NUMBER,
153 p_lpn_id IN NUMBER,
154 x_project_id OUT NOCOPY NUMBER,
155 x_task_id OUT NOCOPY NUMBER,
156 x_return_status OUT NOCOPY VARCHAR2,
157 x_msg_count OUT NOCOPY NUMBER,
158 x_msg_data OUT NOCOPY VARCHAR2);
159
160 Function Is_Project_Enabled(
161 p_org_id IN NUMBER
162 ) return VARCHAR2;
163
164
165 PROCEDURE SET_SESSION_PARAMETERS(
166 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
167 X_MSG_COUNT OUT NOCOPY NUMBER,
168 X_MSG_DATA OUT NOCOPY VARCHAR2,
169 P_ORGANIZATION_ID IN NUMBER
170 );
171 FUNCTION GET_LOCATOR(P_LOCATOR_ID IN NUMBER,
172 P_ORG_ID IN NUMBER) RETURN VARCHAR2;
173
174 FUNCTION GET_PROJECT_NUMBER(P_PROJECT_ID IN NUMBER) RETURN VARCHAR2;
175 FUNCTION GET_TASK_NUMBER(P_TASK_ID IN NUMBER) RETURN VARCHAR2;
176
177 FUNCTION GET_LOCSEGS(P_LOCATOR_ID IN NUMBER, P_ORG_ID IN NUMBER) RETURN VARCHAR2;
178 FUNCTION GET_PROJECT_NUMBER RETURN VARCHAR2;
179 FUNCTION GET_TASK_NUMBER RETURN VARCHAR2;
180 FUNCTION GET_PROJECT_ID RETURN VARCHAR2;
181 FUNCTION GET_TASK_ID RETURN VARCHAR2;
182 --This function is written as a part of bug fix 2902336 for the locator performance issue
183 FUNCTION GET_LOCSEGS(P_CONCATENATED_SEGMENTS IN VARCHAR2)RETURN VARCHAR2;
184 FUNCTION GET_PJM_LOCSEGS(p_concatenated_segments IN VARCHAR2)
185 RETURN VARCHAR2;
186 END inv_project;