eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_RBS_PUB dependencies on PA_INTERFACE_UTILS_PUB

Line 77: If l_rbs_header_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then

73: X_Header_Rec :=P_Header_Rec;
74:
75: l_rbs_header_id :=P_Header_Rec.Rbs_Header_Id;
76:
77: If l_rbs_header_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then
78: l_rbs_header_id := null;
79: End if;
80:
81: l_rbs_header_name := P_Header_Rec.Name ;

Line 89: IF l_rbs_header_name is not null and l_rbs_header_name <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then

85:
86: IF P_Mode = 1 Then
87: IF l_rbs_header_id is null Then
88: -- Get the header id from the name if the name is not null
89: IF l_rbs_header_name is not null and l_rbs_header_name <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
90: BEGIN
91: Select rbs_header_id
92: into l_rbs_header_id
93: from pa_rbs_headers_tl

Line 126: IF l_rbs_header_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM and l_rbs_header_id is not null Then

122: END IF;
123: End if;
124:
125:
126: IF l_rbs_header_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM and l_rbs_header_id is not null Then
127: OPEN C_Rbs_Header_Details(P_Rbs_Header_Id => l_rbs_header_id);
128: FETCH C_Rbs_Header_Details INTO Rec_Details;
129: CLOSE C_Rbs_Header_Details;
130:

Line 131: If P_Header_Rec.Rbs_Header_Id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then

127: OPEN C_Rbs_Header_Details(P_Rbs_Header_Id => l_rbs_header_id);
128: FETCH C_Rbs_Header_Details INTO Rec_Details;
129: CLOSE C_Rbs_Header_Details;
130:
131: If P_Header_Rec.Rbs_Header_Id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then
132: X_Header_Rec.Rbs_Header_Id := Rec_Details.Rbs_Header_Id;
133:
134: End If;
135:

Line 136: If P_Header_Rec.Name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then

132: X_Header_Rec.Rbs_Header_Id := Rec_Details.Rbs_Header_Id;
133:
134: End If;
135:
136: If P_Header_Rec.Name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
137: X_Header_Rec.Name := Rec_Details.Name;
138:
139: End If;
140:

Line 141: If P_Header_Rec.Description = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then

137: X_Header_Rec.Name := Rec_Details.Name;
138:
139: End If;
140:
141: If P_Header_Rec.Description = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
142: X_Header_Rec.Description := Rec_Details.Description;
143:
144: End If;
145:

Line 146: If P_Header_Rec.Effective_From_Date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE Then

142: X_Header_Rec.Description := Rec_Details.Description;
143:
144: End If;
145:
146: If P_Header_Rec.Effective_From_Date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE Then
147: X_Header_Rec.Effective_From_Date := Rec_Details.Effective_From_Date;
148:
149: End If;
150:

Line 151: If P_Header_Rec.Effective_To_Date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE Then

147: X_Header_Rec.Effective_From_Date := Rec_Details.Effective_From_Date;
148:
149: End If;
150:
151: If P_Header_Rec.Effective_To_Date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE Then
152: X_Header_Rec.Effective_To_Date := Rec_Details.Effective_To_Date;
153:
154: End If;
155:

Line 156: If P_Header_Rec.Record_Version_Number = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then

152: X_Header_Rec.Effective_To_Date := Rec_Details.Effective_To_Date;
153:
154: End If;
155:
156: If P_Header_Rec.Record_Version_Number = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then
157: X_Header_Rec.Record_Version_Number := null;
158:
159: End If;
160:

Line 164: If P_Header_Rec.Rbs_Header_Id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then

160:
161:
162: End If;
163: ElsIf P_Mode = 0 Then
164: If P_Header_Rec.Rbs_Header_Id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then
165: X_Header_Rec.Rbs_Header_Id := null;
166: End If;
167: If P_Header_Rec.Name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
168: X_Header_Rec.Name := null;

Line 167: If P_Header_Rec.Name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then

163: ElsIf P_Mode = 0 Then
164: If P_Header_Rec.Rbs_Header_Id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then
165: X_Header_Rec.Rbs_Header_Id := null;
166: End If;
167: If P_Header_Rec.Name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
168: X_Header_Rec.Name := null;
169:
170: End If;
171:

Line 172: If P_Header_Rec.Description = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then

168: X_Header_Rec.Name := null;
169:
170: End If;
171:
172: If P_Header_Rec.Description = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
173: X_Header_Rec.Description := null;
174:
175: End If;
176:

Line 177: If P_Header_Rec.Effective_From_Date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE Then

173: X_Header_Rec.Description := null;
174:
175: End If;
176:
177: If P_Header_Rec.Effective_From_Date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE Then
178: X_Header_Rec.Effective_From_Date := null;
179:
180: End If;
181:

Line 182: If P_Header_Rec.Effective_To_Date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE Then

178: X_Header_Rec.Effective_From_Date := null;
179:
180: End If;
181:
182: If P_Header_Rec.Effective_To_Date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE Then
183: X_Header_Rec.Effective_To_Date := null;
184:
185: End If;
186:

Line 187: If P_Header_Rec.Record_Version_Number = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then

183: X_Header_Rec.Effective_To_Date := null;
184:
185: End If;
186:
187: If P_Header_Rec.Record_Version_Number = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then
188: X_Header_Rec.Record_Version_Number := null;
189:
190: End If;
191:

Line 260: If l_rbs_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then

256:
257: X_Version_Rec :=P_Version_Rec;
258:
259: l_rbs_version_id :=P_Version_Rec.Rbs_Version_Id;
260: If l_rbs_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then
261: l_rbs_version_id := null;
262: End if;
263: l_rbs_version_name := P_Version_Rec.Name ;
264:

Line 271: IF l_rbs_version_name is not null and l_rbs_version_name <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then

267:
268: IF P_Mode = 1 Then
269: IF l_rbs_version_id is null Then
270: -- Get the header id from the name if the name is not null
271: IF l_rbs_version_name is not null and l_rbs_version_name <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
272: Select rbs_version_id
273: Into l_rbs_version_id
274: From pa_rbs_versions_tl
275: Where name= l_rbs_version_name ;

Line 279: IF l_rbs_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM and l_rbs_version_id is not null Then

275: Where name= l_rbs_version_name ;
276: End if ;
277: End if;
278:
279: IF l_rbs_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM and l_rbs_version_id is not null Then
280: OPEN C_Rbs_Version_Details(P_Rbs_Version_Id => l_rbs_version_id);
281: FETCH C_Rbs_Version_Details INTO Rec_Details;
282: CLOSE C_Rbs_Version_Details;
283:

Line 284: If P_Version_Rec.Rbs_Version_Id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then

280: OPEN C_Rbs_Version_Details(P_Rbs_Version_Id => l_rbs_version_id);
281: FETCH C_Rbs_Version_Details INTO Rec_Details;
282: CLOSE C_Rbs_Version_Details;
283:
284: If P_Version_Rec.Rbs_Version_Id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then
285: X_Version_Rec.Rbs_Version_Id := Rec_Details.Rbs_Version_Id;
286:
287: End If;
288: If P_Version_Rec.Name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then

Line 288: If P_Version_Rec.Name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then

284: If P_Version_Rec.Rbs_Version_Id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then
285: X_Version_Rec.Rbs_Version_Id := Rec_Details.Rbs_Version_Id;
286:
287: End If;
288: If P_Version_Rec.Name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
289: X_Version_Rec.Name := Rec_Details.Name;
290:
291: End If;
292:

Line 293: If P_Version_Rec.Description = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then

289: X_Version_Rec.Name := Rec_Details.Name;
290:
291: End If;
292:
293: If P_Version_Rec.Description = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
294: X_Version_Rec.Description := Rec_Details.Description;
295:
296: End If;
297:

Line 298: If P_Version_Rec.Version_Start_Date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE Then

294: X_Version_Rec.Description := Rec_Details.Description;
295:
296: End If;
297:
298: If P_Version_Rec.Version_Start_Date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE Then
299: X_Version_Rec.Version_Start_Date := Rec_Details.Version_Start_Date;
300:
301: End If;
302:

Line 303: If P_Version_Rec.Job_Group_Id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then

299: X_Version_Rec.Version_Start_Date := Rec_Details.Version_Start_Date;
300:
301: End If;
302:
303: If P_Version_Rec.Job_Group_Id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then
304: X_Version_Rec.Job_Group_Id := Rec_Details.Job_Group_Id;
305:
306: End If;
307:

Line 308: If P_Version_Rec.Record_Version_Number = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then

304: X_Version_Rec.Job_Group_Id := Rec_Details.Job_Group_Id;
305:
306: End If;
307:
308: If P_Version_Rec.Record_Version_Number = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then
309: X_Version_Rec.Record_Version_Number := Rec_Details.Record_Version_Number;
310:
311: End If;
312: End If;

Line 314: If P_Version_Rec.Rbs_Version_Id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then

310:
311: End If;
312: End If;
313: Elsif P_Mode = 0 Then
314: If P_Version_Rec.Rbs_Version_Id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then
315: X_Version_Rec.Rbs_Version_Id := null;
316: End If;
317:
318: If P_Version_Rec.Name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then

Line 318: If P_Version_Rec.Name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then

314: If P_Version_Rec.Rbs_Version_Id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then
315: X_Version_Rec.Rbs_Version_Id := null;
316: End If;
317:
318: If P_Version_Rec.Name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
319: X_Version_Rec.Name := null;
320:
321: End If;
322:

Line 323: If P_Version_Rec.Description = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then

319: X_Version_Rec.Name := null;
320:
321: End If;
322:
323: If P_Version_Rec.Description = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
324: X_Version_Rec.Description := null;
325:
326: End If;
327:

Line 328: If P_Version_Rec.Version_Start_Date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE Then

324: X_Version_Rec.Description := null;
325:
326: End If;
327:
328: If P_Version_Rec.Version_Start_Date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE Then
329: X_Version_Rec.Version_Start_Date := null;
330:
331: End If;
332:

Line 333: If P_Version_Rec.Job_Group_Id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then

329: X_Version_Rec.Version_Start_Date := null;
330:
331: End If;
332:
333: If P_Version_Rec.Job_Group_Id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then
334: X_Version_Rec.Job_Group_Id := null;
335:
336: End If;
337:

Line 338: If P_Version_Rec.Record_Version_Number = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then

334: X_Version_Rec.Job_Group_Id := null;
335:
336: End If;
337:
338: If P_Version_Rec.Record_Version_Number = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then
339: X_Version_Rec.Record_Version_Number := null;
340:
341: End If;
342:

Line 403: /*Rbs_Version_Id Number(15) Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

399: and a.resource_source_id =b.resource_id(+) ;
400:
401:
402:
403: /*Rbs_Version_Id Number(15) Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
404: Rbs_Element_Id Number(15) Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
405: Parent_Element_Id Number(15) Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
406: Resource_Type_Id Number(15),
407: Resource_Source_Id Number(15) Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

Line 404: Rbs_Element_Id Number(15) Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

400:
401:
402:
403: /*Rbs_Version_Id Number(15) Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
404: Rbs_Element_Id Number(15) Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
405: Parent_Element_Id Number(15) Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
406: Resource_Type_Id Number(15),
407: Resource_Source_Id Number(15) Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
408: Resource_Source_Code Varchar2(240) Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

Line 405: Parent_Element_Id Number(15) Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

401:
402:
403: /*Rbs_Version_Id Number(15) Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
404: Rbs_Element_Id Number(15) Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
405: Parent_Element_Id Number(15) Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
406: Resource_Type_Id Number(15),
407: Resource_Source_Id Number(15) Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
408: Resource_Source_Code Varchar2(240) Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
409: Order_Number Number(15) Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

Line 407: Resource_Source_Id Number(15) Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

403: /*Rbs_Version_Id Number(15) Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
404: Rbs_Element_Id Number(15) Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
405: Parent_Element_Id Number(15) Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
406: Resource_Type_Id Number(15),
407: Resource_Source_Id Number(15) Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
408: Resource_Source_Code Varchar2(240) Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
409: Order_Number Number(15) Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
410: Process_Type Varchar2(1),
411: Rbs_Level Number(15),

Line 408: Resource_Source_Code Varchar2(240) Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

404: Rbs_Element_Id Number(15) Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
405: Parent_Element_Id Number(15) Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
406: Resource_Type_Id Number(15),
407: Resource_Source_Id Number(15) Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
408: Resource_Source_Code Varchar2(240) Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
409: Order_Number Number(15) Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
410: Process_Type Varchar2(1),
411: Rbs_Level Number(15),
412: Record_Version_Number Number(15) Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

Line 409: Order_Number Number(15) Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

405: Parent_Element_Id Number(15) Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
406: Resource_Type_Id Number(15),
407: Resource_Source_Id Number(15) Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
408: Resource_Source_Code Varchar2(240) Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
409: Order_Number Number(15) Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
410: Process_Type Varchar2(1),
411: Rbs_Level Number(15),
412: Record_Version_Number Number(15) Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
413: Parent_Ref_Element_Id Number(15) Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

Line 412: Record_Version_Number Number(15) Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

408: Resource_Source_Code Varchar2(240) Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
409: Order_Number Number(15) Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
410: Process_Type Varchar2(1),
411: Rbs_Level Number(15),
412: Record_Version_Number Number(15) Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
413: Parent_Ref_Element_Id Number(15) Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
414: Rbs_Ref_Element_Id Number(15) Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
415: */
416: Rec_Details C_Rbs_Elements_Details%RowType;

Line 413: Parent_Ref_Element_Id Number(15) Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

409: Order_Number Number(15) Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
410: Process_Type Varchar2(1),
411: Rbs_Level Number(15),
412: Record_Version_Number Number(15) Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
413: Parent_Ref_Element_Id Number(15) Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
414: Rbs_Ref_Element_Id Number(15) Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
415: */
416: Rec_Details C_Rbs_Elements_Details%RowType;
417:

Line 414: Rbs_Ref_Element_Id Number(15) Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);

410: Process_Type Varchar2(1),
411: Rbs_Level Number(15),
412: Record_Version_Number Number(15) Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
413: Parent_Ref_Element_Id Number(15) Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
414: Rbs_Ref_Element_Id Number(15) Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
415: */
416: Rec_Details C_Rbs_Elements_Details%RowType;
417:
418: l_rbs_version_id NUMBER;

Line 443: If P_Elements_Tbl(i).Rbs_Version_Id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then

439: Else
440: FETCH C_Rbs_Elements_Details INTO Rec_Details;
441: CLOSE C_Rbs_Elements_Details;
442:
443: If P_Elements_Tbl(i).Rbs_Version_Id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then
444: X_Elements_Tbl(i).Rbs_Version_Id := Rec_Details.Rbs_Version_Id;
445:
446: End If;
447:

Line 448: If P_Elements_Tbl(i).Parent_Element_Id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then

444: X_Elements_Tbl(i).Rbs_Version_Id := Rec_Details.Rbs_Version_Id;
445:
446: End If;
447:
448: If P_Elements_Tbl(i).Parent_Element_Id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then
449: X_Elements_Tbl(i).Parent_Element_Id := Rec_Details.Parent_Element_Id;
450:
451: End If;
452:

Line 453: If P_Elements_Tbl(i).Resource_Source_Id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then

449: X_Elements_Tbl(i).Parent_Element_Id := Rec_Details.Parent_Element_Id;
450:
451: End If;
452:
453: If P_Elements_Tbl(i).Resource_Source_Id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then
454: X_Elements_Tbl(i).Resource_Source_Id := Rec_Details.Resource_Source_Id;
455:
456: End If;
457:

Line 460: If P_Elements_Tbl(i).Resource_Source_Code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then

456: End If;
457:
458:
459:
460: If P_Elements_Tbl(i).Resource_Source_Code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
461: X_Elements_Tbl(i).Resource_Source_Code := Rec_Details.Resource_Source_Code;
462:
463: End If;
464:

Line 467: If P_Elements_Tbl(i).Order_Number = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then

463: End If;
464:
465:
466:
467: If P_Elements_Tbl(i).Order_Number = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then
468: X_Elements_Tbl(i).Order_Number := Rec_Details.Order_Number;
469:
470: End If;
471:

Line 474: If P_Elements_Tbl(i).Record_Version_Number = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then

470: End If;
471:
472:
473:
474: If P_Elements_Tbl(i).Record_Version_Number = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then
475: X_Elements_Tbl(i).Record_Version_Number := Rec_Details.Record_Version_Number;
476:
477: End If;
478:

Line 479: If P_Elements_Tbl(i).Process_Type = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then

475: X_Elements_Tbl(i).Record_Version_Number := Rec_Details.Record_Version_Number;
476:
477: End If;
478:
479: If P_Elements_Tbl(i).Process_Type = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
480: X_Elements_Tbl(i).Process_Type := null;
481: End if;
482:
483:

Line 484: If P_Elements_Tbl(i).Rbs_Level = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then

480: X_Elements_Tbl(i).Process_Type := null;
481: End if;
482:
483:
484: If P_Elements_Tbl(i).Rbs_Level = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then
485: X_Elements_Tbl(i).Rbs_Level := Rec_Details.Rbs_Level;
486:
487: End If;
488:

Line 489: If P_Elements_Tbl(i).Resource_Type_Id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then

485: X_Elements_Tbl(i).Rbs_Level := Rec_Details.Rbs_Level;
486:
487: End If;
488:
489: If P_Elements_Tbl(i).Resource_Type_Id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then
490: X_Elements_Tbl(i).Resource_Type_Id := Rec_Details.Resource_Type_Id;
491:
492: End If;
493:

Line 495: If P_Elements_Tbl(i).Parent_Ref_Element_Id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then

491:
492: End If;
493:
494:
495: If P_Elements_Tbl(i).Parent_Ref_Element_Id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then
496: X_Elements_Tbl(i).Parent_Ref_Element_Id := null;
497:
498: End If;
499:

Line 500: If P_Elements_Tbl(i).Rbs_Ref_Element_Id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then

496: X_Elements_Tbl(i).Parent_Ref_Element_Id := null;
497:
498: End If;
499:
500: If P_Elements_Tbl(i).Rbs_Ref_Element_Id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then
501: X_Elements_Tbl(i).Rbs_Ref_Element_Id := null;
502:
503: End If;
504: End if ;

Line 510: If P_Elements_Tbl(i).Rbs_Version_Id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then

506:
507: ElsIf P_Mode =0 Then
508: For i in P_Elements_Tbl.First .. P_Elements_Tbl.Last
509: Loop
510: If P_Elements_Tbl(i).Rbs_Version_Id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then
511: X_Elements_Tbl(i).Rbs_Version_Id := null;
512:
513: End If;
514:

Line 515: If P_Elements_Tbl(i).Rbs_Element_Id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then

511: X_Elements_Tbl(i).Rbs_Version_Id := null;
512:
513: End If;
514:
515: If P_Elements_Tbl(i).Rbs_Element_Id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then
516: X_Elements_Tbl(i).Rbs_Element_Id := null;
517:
518: End If;
519:

Line 522: If P_Elements_Tbl(i).Parent_Element_Id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then

518: End If;
519:
520:
521:
522: If P_Elements_Tbl(i).Parent_Element_Id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then
523: X_Elements_Tbl(i).Parent_Element_Id := null;
524:
525: End If;
526:

Line 529: If P_Elements_Tbl(i).Resource_Source_Id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then

525: End If;
526:
527:
528:
529: If P_Elements_Tbl(i).Resource_Source_Id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then
530: X_Elements_Tbl(i).Resource_Source_Id := null;
531:
532: End If;
533:

Line 536: If P_Elements_Tbl(i).Resource_Source_Code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then

532: End If;
533:
534:
535:
536: If P_Elements_Tbl(i).Resource_Source_Code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
537: X_Elements_Tbl(i).Resource_Source_Code := null;
538:
539: End If;
540:

Line 543: If P_Elements_Tbl(i).Order_Number = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then

539: End If;
540:
541:
542:
543: If P_Elements_Tbl(i).Order_Number = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then
544: X_Elements_Tbl(i).Order_Number := null;
545:
546: End If;
547:

Line 550: If P_Elements_Tbl(i).Record_Version_Number = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then

546: End If;
547:
548:
549:
550: If P_Elements_Tbl(i).Record_Version_Number = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then
551: X_Elements_Tbl(i).Record_Version_Number := null;
552:
553: End If;
554:

Line 555: If P_Elements_Tbl(i).Process_Type = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then

551: X_Elements_Tbl(i).Record_Version_Number := null;
552:
553: End If;
554:
555: If P_Elements_Tbl(i).Process_Type = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
556: X_Elements_Tbl(i).Process_Type := null;
557:
558: End If;
559:

Line 561: If P_Elements_Tbl(i).Rbs_Level = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then

557:
558: End If;
559:
560:
561: If P_Elements_Tbl(i).Rbs_Level = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then
562: X_Elements_Tbl(i).Rbs_Level := null;
563:
564: End If;
565:

Line 566: If P_Elements_Tbl(i).Resource_Type_Id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then

562: X_Elements_Tbl(i).Rbs_Level := null;
563:
564: End If;
565:
566: If P_Elements_Tbl(i).Resource_Type_Id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then
567: X_Elements_Tbl(i).Resource_Type_Id := null;
568:
569: End If;
570:

Line 571: If P_Elements_Tbl(i).Parent_Ref_Element_Id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then

567: X_Elements_Tbl(i).Resource_Type_Id := null;
568:
569: End If;
570:
571: If P_Elements_Tbl(i).Parent_Ref_Element_Id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then
572: X_Elements_Tbl(i).Parent_Ref_Element_Id := null;
573:
574: End If;
575:

Line 576: If P_Elements_Tbl(i).Rbs_Ref_Element_Id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then

572: X_Elements_Tbl(i).Parent_Ref_Element_Id := null;
573:
574: End If;
575:
576: If P_Elements_Tbl(i).Rbs_Ref_Element_Id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then
577: X_Elements_Tbl(i).Rbs_Ref_Element_Id := null;
578:
579: End If;
580: End Loop;

Line 1099: Pa_Interface_Utils_Pub.Get_Messages(

1095: Exception
1096: When l_ERROR Then
1097: l_Msg_Count := Fnd_Msg_Pub.Count_Msg;
1098: If l_Msg_Count = 1 Then
1099: Pa_Interface_Utils_Pub.Get_Messages(
1100: P_Encoded => Fnd_Api.G_True,
1101: P_Msg_Index => 1,
1102: P_Msg_Count => l_Msg_Count,
1103: P_Msg_Data => l_Msg_Data,

Line 1571: l_Elements_Tbl(i).Rbs_Version_Id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)

1567: -- Validate the RBS Version. Only elements of a working
1568: -- version can be updated.
1569:
1570: IF (l_Elements_Tbl(i).Rbs_Version_Id is null OR
1571: l_Elements_Tbl(i).Rbs_Version_Id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
1572: THEN
1573: Pa_Debug.G_Stage := 'Version Identifier Invalid.';
1574: Pa_Utils.Add_Message(
1575: P_App_Short_Name => 'PA',

Line 1939: Pa_Interface_Utils_Pub.Get_Messages(

1935: l_Msg_Count := Fnd_Msg_Pub.Count_Msg;
1936:
1937: If l_Msg_Count = 1 Then
1938:
1939: Pa_Interface_Utils_Pub.Get_Messages(
1940: P_Encoded => Fnd_Api.G_True,
1941: P_Msg_Index => 1,
1942: P_Msg_Count => l_Msg_Count,
1943: P_Msg_Data => l_Msg_Data,

Line 1988: P_Rbs_Header_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

1984: *******************************************************************************************
1985: */
1986: Procedure Load_Rbs_Header(
1987: P_Api_Version_Number IN Number,
1988: P_Rbs_Header_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
1989: P_Name IN Varchar2 Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
1990: P_Description IN Varchar2 Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
1991: P_Effective_From_Date IN Date Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
1992: P_Effective_To_Date IN Date Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,

Line 1989: P_Name IN Varchar2 Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

1985: */
1986: Procedure Load_Rbs_Header(
1987: P_Api_Version_Number IN Number,
1988: P_Rbs_Header_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
1989: P_Name IN Varchar2 Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
1990: P_Description IN Varchar2 Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
1991: P_Effective_From_Date IN Date Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
1992: P_Effective_To_Date IN Date Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
1993: P_Record_Version_Number IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

Line 1990: P_Description IN Varchar2 Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

1986: Procedure Load_Rbs_Header(
1987: P_Api_Version_Number IN Number,
1988: P_Rbs_Header_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
1989: P_Name IN Varchar2 Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
1990: P_Description IN Varchar2 Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
1991: P_Effective_From_Date IN Date Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
1992: P_Effective_To_Date IN Date Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
1993: P_Record_Version_Number IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
1994: X_return_status OUT NOCOPY Varchar2)

Line 1991: P_Effective_From_Date IN Date Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,

1987: P_Api_Version_Number IN Number,
1988: P_Rbs_Header_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
1989: P_Name IN Varchar2 Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
1990: P_Description IN Varchar2 Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
1991: P_Effective_From_Date IN Date Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
1992: P_Effective_To_Date IN Date Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
1993: P_Record_Version_Number IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
1994: X_return_status OUT NOCOPY Varchar2)
1995:

Line 1992: P_Effective_To_Date IN Date Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,

1988: P_Rbs_Header_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
1989: P_Name IN Varchar2 Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
1990: P_Description IN Varchar2 Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
1991: P_Effective_From_Date IN Date Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
1992: P_Effective_To_Date IN Date Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
1993: P_Record_Version_Number IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
1994: X_return_status OUT NOCOPY Varchar2)
1995:
1996: Is

Line 1993: P_Record_Version_Number IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

1989: P_Name IN Varchar2 Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
1990: P_Description IN Varchar2 Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
1991: P_Effective_From_Date IN Date Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
1992: P_Effective_To_Date IN Date Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
1993: P_Record_Version_Number IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
1994: X_return_status OUT NOCOPY Varchar2)
1995:
1996: Is
1997:

Line 2051: P_Rbs_Version_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

2047: * **********************************************************************************
2048: */
2049: Procedure Load_Rbs_Version(
2050: P_Api_Version_Number IN Number,
2051: P_Rbs_Version_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2052: P_Name IN Varchar2 Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
2053: P_Description IN Varchar2 Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
2054: P_Version_Start_Date IN Date Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
2055: P_Job_Group_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

Line 2052: P_Name IN Varchar2 Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

2048: */
2049: Procedure Load_Rbs_Version(
2050: P_Api_Version_Number IN Number,
2051: P_Rbs_Version_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2052: P_Name IN Varchar2 Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
2053: P_Description IN Varchar2 Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
2054: P_Version_Start_Date IN Date Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
2055: P_Job_Group_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2056: P_Record_Version_Number IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

Line 2053: P_Description IN Varchar2 Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

2049: Procedure Load_Rbs_Version(
2050: P_Api_Version_Number IN Number,
2051: P_Rbs_Version_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2052: P_Name IN Varchar2 Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
2053: P_Description IN Varchar2 Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
2054: P_Version_Start_Date IN Date Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
2055: P_Job_Group_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2056: P_Record_Version_Number IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2057: X_Return_Status OUT NOCOPY VARCHAR2)

Line 2054: P_Version_Start_Date IN Date Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,

2050: P_Api_Version_Number IN Number,
2051: P_Rbs_Version_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2052: P_Name IN Varchar2 Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
2053: P_Description IN Varchar2 Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
2054: P_Version_Start_Date IN Date Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
2055: P_Job_Group_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2056: P_Record_Version_Number IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2057: X_Return_Status OUT NOCOPY VARCHAR2)
2058:

Line 2055: P_Job_Group_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

2051: P_Rbs_Version_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2052: P_Name IN Varchar2 Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
2053: P_Description IN Varchar2 Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
2054: P_Version_Start_Date IN Date Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
2055: P_Job_Group_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2056: P_Record_Version_Number IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2057: X_Return_Status OUT NOCOPY VARCHAR2)
2058:
2059: Is

Line 2056: P_Record_Version_Number IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

2052: P_Name IN Varchar2 Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
2053: P_Description IN Varchar2 Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
2054: P_Version_Start_Date IN Date Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
2055: P_Job_Group_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2056: P_Record_Version_Number IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2057: X_Return_Status OUT NOCOPY VARCHAR2)
2058:
2059: Is
2060:

Line 2112: P_Rbs_Version_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

2108: *************************************************************************************************
2109: */
2110: Procedure Load_Rbs_Elements(
2111: P_Api_Version_Number IN Number,
2112: P_Rbs_Version_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2113: P_Rbs_Element_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2114: P_Parent_Element_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2115: P_Resource_Type_Id IN Number,
2116: P_Resource_Source_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

Line 2113: P_Rbs_Element_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

2109: */
2110: Procedure Load_Rbs_Elements(
2111: P_Api_Version_Number IN Number,
2112: P_Rbs_Version_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2113: P_Rbs_Element_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2114: P_Parent_Element_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2115: P_Resource_Type_Id IN Number,
2116: P_Resource_Source_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2117: P_Resource_Source_Code IN Varchar2 Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

Line 2114: P_Parent_Element_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

2110: Procedure Load_Rbs_Elements(
2111: P_Api_Version_Number IN Number,
2112: P_Rbs_Version_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2113: P_Rbs_Element_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2114: P_Parent_Element_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2115: P_Resource_Type_Id IN Number,
2116: P_Resource_Source_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2117: P_Resource_Source_Code IN Varchar2 Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
2118: P_Order_Number IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

Line 2116: P_Resource_Source_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

2112: P_Rbs_Version_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2113: P_Rbs_Element_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2114: P_Parent_Element_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2115: P_Resource_Type_Id IN Number,
2116: P_Resource_Source_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2117: P_Resource_Source_Code IN Varchar2 Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
2118: P_Order_Number IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2119: P_Process_Type IN Varchar2,
2120: P_Rbs_Level IN Number,

Line 2117: P_Resource_Source_Code IN Varchar2 Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

2113: P_Rbs_Element_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2114: P_Parent_Element_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2115: P_Resource_Type_Id IN Number,
2116: P_Resource_Source_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2117: P_Resource_Source_Code IN Varchar2 Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
2118: P_Order_Number IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2119: P_Process_Type IN Varchar2,
2120: P_Rbs_Level IN Number,
2121: P_Record_Version_Number IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

Line 2118: P_Order_Number IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

2114: P_Parent_Element_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2115: P_Resource_Type_Id IN Number,
2116: P_Resource_Source_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2117: P_Resource_Source_Code IN Varchar2 Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
2118: P_Order_Number IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2119: P_Process_Type IN Varchar2,
2120: P_Rbs_Level IN Number,
2121: P_Record_Version_Number IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2122: P_Parent_Ref_Element_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

Line 2121: P_Record_Version_Number IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

2117: P_Resource_Source_Code IN Varchar2 Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
2118: P_Order_Number IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2119: P_Process_Type IN Varchar2,
2120: P_Rbs_Level IN Number,
2121: P_Record_Version_Number IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2122: P_Parent_Ref_Element_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2123: P_Rbs_Ref_Element_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2124: X_Return_Status OUT NOCOPY Varchar2)
2125:

Line 2122: P_Parent_Ref_Element_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

2118: P_Order_Number IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2119: P_Process_Type IN Varchar2,
2120: P_Rbs_Level IN Number,
2121: P_Record_Version_Number IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2122: P_Parent_Ref_Element_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2123: P_Rbs_Ref_Element_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2124: X_Return_Status OUT NOCOPY Varchar2)
2125:
2126: Is

Line 2123: P_Rbs_Ref_Element_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

2119: P_Process_Type IN Varchar2,
2120: P_Rbs_Level IN Number,
2121: P_Record_Version_Number IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2122: P_Parent_Ref_Element_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2123: P_Rbs_Ref_Element_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2124: X_Return_Status OUT NOCOPY Varchar2)
2125:
2126: Is
2127:

Line 2555: P_RBS_Version_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

2551: Procedure Copy_Rbs_Working_Version(
2552: P_Commit IN Varchar2 Default Fnd_Api.G_False,
2553: P_Init_Msg_List IN Varchar2 Default Fnd_Api.G_True,
2554: P_Api_Version_Number IN Number,
2555: P_RBS_Version_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2556: P_Rbs_Header_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2557: P_Rbs_Header_Name IN Varchar2 Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
2558: P_Rbs_Version_Number IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2559: P_Rec_Version_Number IN Number,

Line 2556: P_Rbs_Header_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

2552: P_Commit IN Varchar2 Default Fnd_Api.G_False,
2553: P_Init_Msg_List IN Varchar2 Default Fnd_Api.G_True,
2554: P_Api_Version_Number IN Number,
2555: P_RBS_Version_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2556: P_Rbs_Header_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2557: P_Rbs_Header_Name IN Varchar2 Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
2558: P_Rbs_Version_Number IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2559: P_Rec_Version_Number IN Number,
2560: X_Return_Status OUT NOCOPY Varchar2,

Line 2557: P_Rbs_Header_Name IN Varchar2 Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

2553: P_Init_Msg_List IN Varchar2 Default Fnd_Api.G_True,
2554: P_Api_Version_Number IN Number,
2555: P_RBS_Version_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2556: P_Rbs_Header_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2557: P_Rbs_Header_Name IN Varchar2 Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
2558: P_Rbs_Version_Number IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2559: P_Rec_Version_Number IN Number,
2560: X_Return_Status OUT NOCOPY Varchar2,
2561: X_Msg_Count OUT NOCOPY Number,

Line 2558: P_Rbs_Version_Number IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

2554: P_Api_Version_Number IN Number,
2555: P_RBS_Version_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2556: P_Rbs_Header_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2557: P_Rbs_Header_Name IN Varchar2 Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
2558: P_Rbs_Version_Number IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2559: P_Rec_Version_Number IN Number,
2560: X_Return_Status OUT NOCOPY Varchar2,
2561: X_Msg_Count OUT NOCOPY Number,
2562: X_Error_Msg_Data OUT NOCOPY Varchar2 )

Line 2645: If P_Rbs_Version_Id is null or P_Rbs_Version_Id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then

2641:
2642: l_Rbs_Version_Id:=P_Rbs_Version_Id;
2643:
2644: Pa_Debug.G_Stage := 'Checks if P_Rbs_Version_Id is null';
2645: If P_Rbs_Version_Id is null or P_Rbs_Version_Id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then
2646:
2647: If P_Rbs_Header_Id is not null and P_Rbs_Header_Id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM and P_Rbs_Version_Number <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM and P_Rbs_Version_Number is not null then
2648:
2649: OPEN C_GetVersionId1(P_Header_Id=>P_Rbs_Header_Id,P_Version_Number=>P_Rbs_Version_Number);

Line 2647: If P_Rbs_Header_Id is not null and P_Rbs_Header_Id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM and P_Rbs_Version_Number <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM and P_Rbs_Version_Number is not null then

2643:
2644: Pa_Debug.G_Stage := 'Checks if P_Rbs_Version_Id is null';
2645: If P_Rbs_Version_Id is null or P_Rbs_Version_Id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then
2646:
2647: If P_Rbs_Header_Id is not null and P_Rbs_Header_Id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM and P_Rbs_Version_Number <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM and P_Rbs_Version_Number is not null then
2648:
2649: OPEN C_GetVersionId1(P_Header_Id=>P_Rbs_Header_Id,P_Version_Number=>P_Rbs_Version_Number);
2650: FETCH C_GetVersionId1 INTO l_Rbs_Version_Id;
2651: CLOSE C_GetVersionId1;

Line 2653: ElsIf P_Rbs_Header_Name is not null and P_Rbs_Header_Name <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM and P_Rbs_Version_Number <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM and P_Rbs_Version_Number is not null then

2649: OPEN C_GetVersionId1(P_Header_Id=>P_Rbs_Header_Id,P_Version_Number=>P_Rbs_Version_Number);
2650: FETCH C_GetVersionId1 INTO l_Rbs_Version_Id;
2651: CLOSE C_GetVersionId1;
2652:
2653: ElsIf P_Rbs_Header_Name is not null and P_Rbs_Header_Name <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM and P_Rbs_Version_Number <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM and P_Rbs_Version_Number is not null then
2654:
2655: OPEN C_GetVersionId2(P_Header_Name=>P_Rbs_Header_Name,P_Version_Number=>P_Rbs_Version_Number);
2656: FETCH C_GetVersionId2 INTO l_Rbs_Version_Id;
2657: CLOSE C_GetVersionId2;

Line 2672: If P_Rbs_Header_Id is null or P_Rbs_Header_Id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then

2668:
2669: l_Rbs_Header_Id:=P_Rbs_Header_Id;
2670:
2671: Pa_Debug.G_Stage := 'Checks if P_Rbs_Header_Id is null';
2672: If P_Rbs_Header_Id is null or P_Rbs_Header_Id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then
2673:
2674: OPEN C_GetHeaderId;
2675: FETCH C_GetHeaderId Into l_Rbs_Header_Id;
2676: CLOSE C_GetHeaderId;

Line 2740: P_Rbs_Version_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

2736: PROCEDURE Freeze_Rbs_Version(
2737: P_Commit IN Varchar2 Default Fnd_Api.G_False,
2738: P_Init_Msg_List IN Varchar2 Default Fnd_Api.G_True,
2739: P_API_Version_Number IN Number,
2740: P_Rbs_Version_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2741: P_Rbs_Header_Name IN Varchar2 Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
2742: P_Rbs_Header_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2743: P_Rbs_Version_Record_Ver_Num IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2744: X_Return_Status OUT NOCOPY Varchar2,

Line 2741: P_Rbs_Header_Name IN Varchar2 Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

2737: P_Commit IN Varchar2 Default Fnd_Api.G_False,
2738: P_Init_Msg_List IN Varchar2 Default Fnd_Api.G_True,
2739: P_API_Version_Number IN Number,
2740: P_Rbs_Version_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2741: P_Rbs_Header_Name IN Varchar2 Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
2742: P_Rbs_Header_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2743: P_Rbs_Version_Record_Ver_Num IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2744: X_Return_Status OUT NOCOPY Varchar2,
2745: X_Msg_Count OUT NOCOPY Number,

Line 2742: P_Rbs_Header_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

2738: P_Init_Msg_List IN Varchar2 Default Fnd_Api.G_True,
2739: P_API_Version_Number IN Number,
2740: P_Rbs_Version_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2741: P_Rbs_Header_Name IN Varchar2 Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
2742: P_Rbs_Header_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2743: P_Rbs_Version_Record_Ver_Num IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2744: X_Return_Status OUT NOCOPY Varchar2,
2745: X_Msg_Count OUT NOCOPY Number,
2746: X_Error_Msg_Data OUT NOCOPY Varchar2)

Line 2743: P_Rbs_Version_Record_Ver_Num IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

2739: P_API_Version_Number IN Number,
2740: P_Rbs_Version_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2741: P_Rbs_Header_Name IN Varchar2 Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
2742: P_Rbs_Header_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2743: P_Rbs_Version_Record_Ver_Num IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2744: X_Return_Status OUT NOCOPY Varchar2,
2745: X_Msg_Count OUT NOCOPY Number,
2746: X_Error_Msg_Data OUT NOCOPY Varchar2)
2747: IS

Line 2813: If P_Rbs_Version_Id is null or P_Rbs_Version_Id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then

2809:
2810: l_Rbs_Version_Id:=P_Rbs_Version_Id;
2811:
2812: Pa_Debug.G_Stage := 'Checks if P_Rbs_Version_Id is null';
2813: If P_Rbs_Version_Id is null or P_Rbs_Version_Id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then
2814:
2815: If P_Rbs_Header_Id is not null and P_Rbs_Header_Id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then
2816:
2817: OPEN C_GetVersionId1(P_Header_Id=>P_Rbs_Header_Id);

Line 2815: If P_Rbs_Header_Id is not null and P_Rbs_Header_Id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then

2811:
2812: Pa_Debug.G_Stage := 'Checks if P_Rbs_Version_Id is null';
2813: If P_Rbs_Version_Id is null or P_Rbs_Version_Id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then
2814:
2815: If P_Rbs_Header_Id is not null and P_Rbs_Header_Id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then
2816:
2817: OPEN C_GetVersionId1(P_Header_Id=>P_Rbs_Header_Id);
2818: FETCH C_GetVersionId1 INTO l_Rbs_Version_Id;
2819: CLOSE C_GetVersionId1;

Line 2821: ElsIf P_Rbs_Header_Name is not null and P_Rbs_Header_Name <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then

2817: OPEN C_GetVersionId1(P_Header_Id=>P_Rbs_Header_Id);
2818: FETCH C_GetVersionId1 INTO l_Rbs_Version_Id;
2819: CLOSE C_GetVersionId1;
2820:
2821: ElsIf P_Rbs_Header_Name is not null and P_Rbs_Header_Name <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
2822:
2823: OPEN C_GetVersionId2(P_Header_Name=>P_Rbs_Header_Name);
2824: FETCH C_GetVersionId2 INTO l_Rbs_Version_Id;
2825: CLOSE C_GetVersionId2;

Line 2899: P_Rbs_Header_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

2895: Procedure Assign_Rbs_To_Project(
2896: P_Commit IN Varchar2 Default Fnd_Api.G_False,
2897: P_Init_Msg_List IN Varchar2 Default Fnd_Api.G_True,
2898: P_API_Version_Number IN Number,
2899: P_Rbs_Header_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2900: P_Rbs_Version_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, --Not used
2901: P_Project_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2902: P_Pm_project_Reference IN Varchar2 Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
2903: P_Rbs_Header_Name IN Varchar2 Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

Line 2900: P_Rbs_Version_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, --Not used

2896: P_Commit IN Varchar2 Default Fnd_Api.G_False,
2897: P_Init_Msg_List IN Varchar2 Default Fnd_Api.G_True,
2898: P_API_Version_Number IN Number,
2899: P_Rbs_Header_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2900: P_Rbs_Version_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, --Not used
2901: P_Project_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2902: P_Pm_project_Reference IN Varchar2 Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
2903: P_Rbs_Header_Name IN Varchar2 Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
2904: P_Rbs_Version_Number IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

Line 2901: P_Project_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

2897: P_Init_Msg_List IN Varchar2 Default Fnd_Api.G_True,
2898: P_API_Version_Number IN Number,
2899: P_Rbs_Header_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2900: P_Rbs_Version_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, --Not used
2901: P_Project_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2902: P_Pm_project_Reference IN Varchar2 Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
2903: P_Rbs_Header_Name IN Varchar2 Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
2904: P_Rbs_Version_Number IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2905: P_Prog_Rep_Usage_Flag IN Varchar2 Default 'N',

Line 2902: P_Pm_project_Reference IN Varchar2 Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

2898: P_API_Version_Number IN Number,
2899: P_Rbs_Header_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2900: P_Rbs_Version_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, --Not used
2901: P_Project_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2902: P_Pm_project_Reference IN Varchar2 Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
2903: P_Rbs_Header_Name IN Varchar2 Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
2904: P_Rbs_Version_Number IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2905: P_Prog_Rep_Usage_Flag IN Varchar2 Default 'N',
2906: P_Primary_Rep_Flag IN Varchar2 Default 'N',

Line 2903: P_Rbs_Header_Name IN Varchar2 Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

2899: P_Rbs_Header_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2900: P_Rbs_Version_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, --Not used
2901: P_Project_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2902: P_Pm_project_Reference IN Varchar2 Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
2903: P_Rbs_Header_Name IN Varchar2 Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
2904: P_Rbs_Version_Number IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2905: P_Prog_Rep_Usage_Flag IN Varchar2 Default 'N',
2906: P_Primary_Rep_Flag IN Varchar2 Default 'N',
2907: X_Return_Status OUT NOCOPY Varchar2,

Line 2904: P_Rbs_Version_Number IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

2900: P_Rbs_Version_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, --Not used
2901: P_Project_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2902: P_Pm_project_Reference IN Varchar2 Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
2903: P_Rbs_Header_Name IN Varchar2 Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
2904: P_Rbs_Version_Number IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2905: P_Prog_Rep_Usage_Flag IN Varchar2 Default 'N',
2906: P_Primary_Rep_Flag IN Varchar2 Default 'N',
2907: X_Return_Status OUT NOCOPY Varchar2,
2908: X_Msg_Count OUT NOCOPY Number,

Line 2980: P_Project_Id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then

2976: l_project_id := P_Project_Id;
2977:
2978: Pa_Debug.G_Stage := 'Check if P_Project_Id is null';
2979: If P_Project_Id is null or
2980: P_Project_Id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then
2981:
2982: Pa_Debug.G_Stage := 'Get the project id from Pa_Project_Pvt.Convert_Pm_Projref_to_id';
2983:
2984: Pa_Project_Pvt.Convert_Pm_Projref_to_id(

Line 3002: -- If P_Rbs_Version_Id is null or P_Rbs_Version_Id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then

2998: -- l_Rbs_Version_Id:=P_Rbs_Version_Id;
2999:
3000: Pa_Debug.G_Stage := 'Check if P_Rbs_Version_Id is null';
3001:
3002: -- If P_Rbs_Version_Id is null or P_Rbs_Version_Id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then
3003:
3004: IF P_Rbs_Header_Id is not null AND
3005: P_Rbs_Header_Id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
3006:

Line 3005: P_Rbs_Header_Id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

3001:
3002: -- If P_Rbs_Version_Id is null or P_Rbs_Version_Id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then
3003:
3004: IF P_Rbs_Header_Id is not null AND
3005: P_Rbs_Header_Id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
3006:
3007: OPEN C_GetVersionId1(P_Header_Id => P_Rbs_Header_Id);
3008: FETCH C_GetVersionId1 INTO l_Rbs_Version_Id;
3009: CLOSE C_GetVersionId1;

Line 3012: P_Rbs_Header_Name <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

3008: FETCH C_GetVersionId1 INTO l_Rbs_Version_Id;
3009: CLOSE C_GetVersionId1;
3010:
3011: ELSIF P_Rbs_Header_Name is not null AND
3012: P_Rbs_Header_Name <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
3013:
3014: OPEN C_GetVersionId2(P_Header_Name => P_Rbs_Header_Name);
3015: FETCH C_GetVersionId2 INTO l_Rbs_Version_Id;
3016: CLOSE C_GetVersionId2;

Line 3034: P_Rbs_Header_Id =PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then

3030:
3031: /*
3032: Pa_Debug.G_Stage := 'Check if P_Rbs_Header_Id is null';
3033: If P_Rbs_Header_Id is null or
3034: P_Rbs_Header_Id =PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then
3035:
3036: OPEN C_GetHeaderId;
3037: FETCH C_GetHeaderId Into l_Rbs_Header_Id;
3038: CLOSE C_GetHeaderId;