84: * ***************************************************************
85: */
86:
87: TYPE Rbs_Header_Rec_Typ Is Record (
88: Rbs_Header_Id Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
89: Name Varchar2(240) Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
90: Description Varchar2(2000) Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
91: Effective_From_Date Date Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
92: Effective_To_Date Date Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
85: */
86:
87: TYPE Rbs_Header_Rec_Typ Is Record (
88: Rbs_Header_Id Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
89: Name Varchar2(240) Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
90: Description Varchar2(2000) Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
91: Effective_From_Date Date Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
92: Effective_To_Date Date Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
93: Record_Version_Number Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
86:
87: TYPE Rbs_Header_Rec_Typ Is Record (
88: Rbs_Header_Id Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
89: Name Varchar2(240) Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
90: Description Varchar2(2000) Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
91: Effective_From_Date Date Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
92: Effective_To_Date Date Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
93: Record_Version_Number Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
94:
87: TYPE Rbs_Header_Rec_Typ Is Record (
88: Rbs_Header_Id Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
89: Name Varchar2(240) Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
90: Description Varchar2(2000) Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
91: Effective_From_Date Date Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
92: Effective_To_Date Date Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
93: Record_Version_Number Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
94:
95: /*
88: Rbs_Header_Id Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
89: Name Varchar2(240) Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
90: Description Varchar2(2000) Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
91: Effective_From_Date Date Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
92: Effective_To_Date Date Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
93: Record_Version_Number Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
94:
95: /*
96: * *******************************************************************
89: Name Varchar2(240) Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
90: Description Varchar2(2000) Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
91: Effective_From_Date Date Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
92: Effective_To_Date Date Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
93: Record_Version_Number Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
94:
95: /*
96: * *******************************************************************
97: * Rbs_Header_Rec_Out_Typ
140: * PA_RBS_VERSIONS_AMG_V.
141: * ***************************************************************
142: */
143: TYPE Rbs_Version_Rec_Typ Is Record (
144: Rbs_Version_Id Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
145: Name Varchar2(240) Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
146: Description Varchar2(2000) Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
147: Version_Start_Date Date Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
148: Job_Group_Id Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
141: * ***************************************************************
142: */
143: TYPE Rbs_Version_Rec_Typ Is Record (
144: Rbs_Version_Id Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
145: Name Varchar2(240) Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
146: Description Varchar2(2000) Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
147: Version_Start_Date Date Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
148: Job_Group_Id Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
149: Record_Version_Number Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
142: */
143: TYPE Rbs_Version_Rec_Typ Is Record (
144: Rbs_Version_Id Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
145: Name Varchar2(240) Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
146: Description Varchar2(2000) Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
147: Version_Start_Date Date Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
148: Job_Group_Id Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
149: Record_Version_Number Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
150:
143: TYPE Rbs_Version_Rec_Typ Is Record (
144: Rbs_Version_Id Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
145: Name Varchar2(240) Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
146: Description Varchar2(2000) Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
147: Version_Start_Date Date Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
148: Job_Group_Id Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
149: Record_Version_Number Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
150:
151:
144: Rbs_Version_Id Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
145: Name Varchar2(240) Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
146: Description Varchar2(2000) Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
147: Version_Start_Date Date Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
148: Job_Group_Id Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
149: Record_Version_Number Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
150:
151:
152:
145: Name Varchar2(240) Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
146: Description Varchar2(2000) Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
147: Version_Start_Date Date Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
148: Job_Group_Id Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
149: Record_Version_Number Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
150:
151:
152:
153: /*
249: * root element's Id.
250: * ***************************************************************
251: */
252: TYPE Rbs_Elements_Rec_Typ IS RECORD (
253: Rbs_Version_Id Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
254: Rbs_Element_Id Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
255: Parent_Element_Id Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
256: Resource_Type_Id Number,
257: Resource_Source_Id Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
250: * ***************************************************************
251: */
252: TYPE Rbs_Elements_Rec_Typ IS RECORD (
253: Rbs_Version_Id Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
254: Rbs_Element_Id Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
255: Parent_Element_Id Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
256: Resource_Type_Id Number,
257: Resource_Source_Id Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
258: Resource_Source_Code Varchar2(240) Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
251: */
252: TYPE Rbs_Elements_Rec_Typ IS RECORD (
253: Rbs_Version_Id Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
254: Rbs_Element_Id Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
255: Parent_Element_Id Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
256: Resource_Type_Id Number,
257: Resource_Source_Id Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
258: Resource_Source_Code Varchar2(240) Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
259: Order_Number Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
253: Rbs_Version_Id Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
254: Rbs_Element_Id Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
255: Parent_Element_Id Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
256: Resource_Type_Id Number,
257: Resource_Source_Id Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
258: Resource_Source_Code Varchar2(240) Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
259: Order_Number Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
260: Process_Type Varchar2(1),
261: Rbs_Level Number,
254: Rbs_Element_Id Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
255: Parent_Element_Id Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
256: Resource_Type_Id Number,
257: Resource_Source_Id Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
258: Resource_Source_Code Varchar2(240) Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
259: Order_Number Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
260: Process_Type Varchar2(1),
261: Rbs_Level Number,
262: Record_Version_Number Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
255: Parent_Element_Id Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
256: Resource_Type_Id Number,
257: Resource_Source_Id Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
258: Resource_Source_Code Varchar2(240) Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
259: Order_Number Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
260: Process_Type Varchar2(1),
261: Rbs_Level Number,
262: Record_Version_Number Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
263: Parent_Ref_Element_Id Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
258: Resource_Source_Code Varchar2(240) Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
259: Order_Number Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
260: Process_Type Varchar2(1),
261: Rbs_Level Number,
262: Record_Version_Number Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
263: Parent_Ref_Element_Id Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
264: Rbs_Ref_Element_Id Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
265:
266: TYPE Rbs_Elements_Tbl_Typ IS TABLE OF Rbs_Elements_Rec_Typ
259: Order_Number Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
260: Process_Type Varchar2(1),
261: Rbs_Level Number,
262: Record_Version_Number Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
263: Parent_Ref_Element_Id Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
264: Rbs_Ref_Element_Id Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
265:
266: TYPE Rbs_Elements_Tbl_Typ IS TABLE OF Rbs_Elements_Rec_Typ
267: INDEX BY BINARY_INTEGER;
260: Process_Type Varchar2(1),
261: Rbs_Level Number,
262: Record_Version_Number Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
263: Parent_Ref_Element_Id Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
264: Rbs_Ref_Element_Id Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
265:
266: TYPE Rbs_Elements_Tbl_Typ IS TABLE OF Rbs_Elements_Rec_Typ
267: INDEX BY BINARY_INTEGER;
268:
612: * @rep:compatibility S
613: */
614: Procedure Load_Rbs_Header(
615: P_Api_Version_Number IN Number,
616: P_Rbs_Header_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
617: P_Name IN Varchar2 Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
618: P_Description IN Varchar2 Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
619: P_Effective_From_Date IN Date Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
620: P_Effective_To_Date IN Date Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
613: */
614: Procedure Load_Rbs_Header(
615: P_Api_Version_Number IN Number,
616: P_Rbs_Header_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
617: P_Name IN Varchar2 Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
618: P_Description IN Varchar2 Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
619: P_Effective_From_Date IN Date Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
620: P_Effective_To_Date IN Date Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
621: P_Record_Version_Number IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
614: Procedure Load_Rbs_Header(
615: P_Api_Version_Number IN Number,
616: P_Rbs_Header_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
617: P_Name IN Varchar2 Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
618: P_Description IN Varchar2 Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
619: P_Effective_From_Date IN Date Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
620: P_Effective_To_Date IN Date Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
621: P_Record_Version_Number IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
622: X_Return_status OUT NOCOPY Varchar2);
615: P_Api_Version_Number IN Number,
616: P_Rbs_Header_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
617: P_Name IN Varchar2 Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
618: P_Description IN Varchar2 Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
619: P_Effective_From_Date IN Date Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
620: P_Effective_To_Date IN Date Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
621: P_Record_Version_Number IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
622: X_Return_status OUT NOCOPY Varchar2);
623:
616: P_Rbs_Header_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
617: P_Name IN Varchar2 Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
618: P_Description IN Varchar2 Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
619: P_Effective_From_Date IN Date Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
620: P_Effective_To_Date IN Date Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
621: P_Record_Version_Number IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
622: X_Return_status OUT NOCOPY Varchar2);
623:
624:
617: P_Name IN Varchar2 Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
618: P_Description IN Varchar2 Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
619: P_Effective_From_Date IN Date Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
620: P_Effective_To_Date IN Date Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
621: P_Record_Version_Number IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
622: X_Return_status OUT NOCOPY Varchar2);
623:
624:
625:
680: * @rep:compatibility S
681: */
682: Procedure Load_Rbs_Version(
683: P_Api_Version_Number IN Number,
684: P_Rbs_Version_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
685: P_Name IN Varchar2 Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
686: P_Description IN Varchar2 Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
687: P_Version_Start_Date IN Date Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
688: P_Job_Group_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
681: */
682: Procedure Load_Rbs_Version(
683: P_Api_Version_Number IN Number,
684: P_Rbs_Version_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
685: P_Name IN Varchar2 Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
686: P_Description IN Varchar2 Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
687: P_Version_Start_Date IN Date Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
688: P_Job_Group_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
689: P_Record_Version_Number IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
682: Procedure Load_Rbs_Version(
683: P_Api_Version_Number IN Number,
684: P_Rbs_Version_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
685: P_Name IN Varchar2 Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
686: P_Description IN Varchar2 Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
687: P_Version_Start_Date IN Date Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
688: P_Job_Group_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
689: P_Record_Version_Number IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
690: X_Return_Status OUT NOCOPY VARCHAR2);
683: P_Api_Version_Number IN Number,
684: P_Rbs_Version_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
685: P_Name IN Varchar2 Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
686: P_Description IN Varchar2 Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
687: P_Version_Start_Date IN Date Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
688: P_Job_Group_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
689: P_Record_Version_Number IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
690: X_Return_Status OUT NOCOPY VARCHAR2);
691:
684: P_Rbs_Version_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
685: P_Name IN Varchar2 Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
686: P_Description IN Varchar2 Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
687: P_Version_Start_Date IN Date Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
688: P_Job_Group_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
689: P_Record_Version_Number IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
690: X_Return_Status OUT NOCOPY VARCHAR2);
691:
692:
685: P_Name IN Varchar2 Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
686: P_Description IN Varchar2 Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
687: P_Version_Start_Date IN Date Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
688: P_Job_Group_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
689: P_Record_Version_Number IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
690: X_Return_Status OUT NOCOPY VARCHAR2);
691:
692:
693:
813: * @rep:compatibility S
814: */
815: Procedure Load_Rbs_Elements(
816: P_Api_Version_Number IN Number,
817: P_Rbs_Version_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
818: P_Rbs_Element_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
819: P_Parent_Element_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
820: P_Resource_Type_Id IN Number,
821: P_Resource_Source_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
814: */
815: Procedure Load_Rbs_Elements(
816: P_Api_Version_Number IN Number,
817: P_Rbs_Version_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
818: P_Rbs_Element_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
819: P_Parent_Element_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
820: P_Resource_Type_Id IN Number,
821: P_Resource_Source_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
822: P_Resource_Source_Code IN Varchar2 Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
815: Procedure Load_Rbs_Elements(
816: P_Api_Version_Number IN Number,
817: P_Rbs_Version_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
818: P_Rbs_Element_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
819: P_Parent_Element_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
820: P_Resource_Type_Id IN Number,
821: P_Resource_Source_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
822: P_Resource_Source_Code IN Varchar2 Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
823: P_Order_Number IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
817: P_Rbs_Version_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
818: P_Rbs_Element_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
819: P_Parent_Element_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
820: P_Resource_Type_Id IN Number,
821: P_Resource_Source_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
822: P_Resource_Source_Code IN Varchar2 Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
823: P_Order_Number IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
824: P_Process_Type IN Varchar2,
825: P_Rbs_Level IN Number,
818: P_Rbs_Element_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
819: P_Parent_Element_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
820: P_Resource_Type_Id IN Number,
821: P_Resource_Source_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
822: P_Resource_Source_Code IN Varchar2 Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
823: P_Order_Number IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
824: P_Process_Type IN Varchar2,
825: P_Rbs_Level IN Number,
826: P_Record_Version_Number IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
819: P_Parent_Element_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
820: P_Resource_Type_Id IN Number,
821: P_Resource_Source_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
822: P_Resource_Source_Code IN Varchar2 Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
823: P_Order_Number IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
824: P_Process_Type IN Varchar2,
825: P_Rbs_Level IN Number,
826: P_Record_Version_Number IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
827: P_Parent_Ref_Element_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
822: P_Resource_Source_Code IN Varchar2 Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
823: P_Order_Number IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
824: P_Process_Type IN Varchar2,
825: P_Rbs_Level IN Number,
826: P_Record_Version_Number IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
827: P_Parent_Ref_Element_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
828: P_Rbs_Ref_Element_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
829: X_Return_Status OUT NOCOPY Varchar2);
830:
823: P_Order_Number IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
824: P_Process_Type IN Varchar2,
825: P_Rbs_Level IN Number,
826: P_Record_Version_Number IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
827: P_Parent_Ref_Element_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
828: P_Rbs_Ref_Element_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
829: X_Return_Status OUT NOCOPY Varchar2);
830:
831:
824: P_Process_Type IN Varchar2,
825: P_Rbs_Level IN Number,
826: P_Record_Version_Number IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
827: P_Parent_Ref_Element_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
828: P_Rbs_Ref_Element_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
829: X_Return_Status OUT NOCOPY Varchar2);
830:
831:
832:
1175: Procedure Copy_Rbs_Working_Version(
1176: P_Commit IN Varchar2 Default Fnd_Api.G_False,
1177: P_Init_Msg_List IN Varchar2 Default Fnd_Api.G_True,
1178: P_Api_Version_Number IN Number,
1179: P_RBS_Version_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
1180: P_Rbs_Header_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
1181: P_Rbs_Header_Name IN Varchar2 Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
1182: P_Rbs_Version_Number IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
1183: P_Rec_Version_Number IN Number,
1176: P_Commit IN Varchar2 Default Fnd_Api.G_False,
1177: P_Init_Msg_List IN Varchar2 Default Fnd_Api.G_True,
1178: P_Api_Version_Number IN Number,
1179: P_RBS_Version_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
1180: P_Rbs_Header_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
1181: P_Rbs_Header_Name IN Varchar2 Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
1182: P_Rbs_Version_Number IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
1183: P_Rec_Version_Number IN Number,
1184: X_Return_Status OUT NOCOPY Varchar2,
1177: P_Init_Msg_List IN Varchar2 Default Fnd_Api.G_True,
1178: P_Api_Version_Number IN Number,
1179: P_RBS_Version_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
1180: P_Rbs_Header_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
1181: P_Rbs_Header_Name IN Varchar2 Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
1182: P_Rbs_Version_Number IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
1183: P_Rec_Version_Number IN Number,
1184: X_Return_Status OUT NOCOPY Varchar2,
1185: X_Msg_Count OUT NOCOPY Number,
1178: P_Api_Version_Number IN Number,
1179: P_RBS_Version_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
1180: P_Rbs_Header_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
1181: P_Rbs_Header_Name IN Varchar2 Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
1182: P_Rbs_Version_Number IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
1183: P_Rec_Version_Number IN Number,
1184: X_Return_Status OUT NOCOPY Varchar2,
1185: X_Msg_Count OUT NOCOPY Number,
1186: X_Error_Msg_Data OUT NOCOPY Varchar2 );
1258: Procedure Freeze_Rbs_Version(
1259: P_Commit IN Varchar2 Default Fnd_Api.G_False,
1260: P_Init_Msg_List IN Varchar2 Default Fnd_Api.G_True,
1261: P_API_Version_Number IN Number,
1262: P_Rbs_Version_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
1263: P_Rbs_Header_Name IN Varchar2 Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
1264: P_Rbs_Header_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
1265: P_Rbs_Version_Record_Ver_Num IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
1266: X_Return_Status OUT NOCOPY Varchar2,
1259: P_Commit IN Varchar2 Default Fnd_Api.G_False,
1260: P_Init_Msg_List IN Varchar2 Default Fnd_Api.G_True,
1261: P_API_Version_Number IN Number,
1262: P_Rbs_Version_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
1263: P_Rbs_Header_Name IN Varchar2 Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
1264: P_Rbs_Header_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
1265: P_Rbs_Version_Record_Ver_Num IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
1266: X_Return_Status OUT NOCOPY Varchar2,
1267: X_Msg_Count OUT NOCOPY Number,
1260: P_Init_Msg_List IN Varchar2 Default Fnd_Api.G_True,
1261: P_API_Version_Number IN Number,
1262: P_Rbs_Version_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
1263: P_Rbs_Header_Name IN Varchar2 Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
1264: P_Rbs_Header_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
1265: P_Rbs_Version_Record_Ver_Num IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
1266: X_Return_Status OUT NOCOPY Varchar2,
1267: X_Msg_Count OUT NOCOPY Number,
1268: X_Error_Msg_Data OUT NOCOPY Varchar2);
1261: P_API_Version_Number IN Number,
1262: P_Rbs_Version_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
1263: P_Rbs_Header_Name IN Varchar2 Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
1264: P_Rbs_Header_Id IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
1265: P_Rbs_Version_Record_Ver_Num IN Number Default PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
1266: X_Return_Status OUT NOCOPY Varchar2,
1267: X_Msg_Count OUT NOCOPY Number,
1268: X_Error_Msg_Data OUT NOCOPY Varchar2);
1269:
1358: Procedure Assign_Rbs_To_Project(
1359: P_Commit IN Varchar2 DEFAULT FND_API.G_FALSE,
1360: P_Init_Msg_List IN Varchar2 DEFAULT FND_API.G_True,
1361: P_API_Version_Number IN Number,
1362: P_Rbs_Header_Id IN Number DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
1363: P_Rbs_Version_Id IN Number DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, --Not used
1364: P_Project_Id IN Number DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
1365: P_Pm_Project_Reference IN Varchar2 DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
1366: P_Rbs_Header_Name IN Varchar2 DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
1359: P_Commit IN Varchar2 DEFAULT FND_API.G_FALSE,
1360: P_Init_Msg_List IN Varchar2 DEFAULT FND_API.G_True,
1361: P_API_Version_Number IN Number,
1362: P_Rbs_Header_Id IN Number DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
1363: P_Rbs_Version_Id IN Number DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, --Not used
1364: P_Project_Id IN Number DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
1365: P_Pm_Project_Reference IN Varchar2 DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
1366: P_Rbs_Header_Name IN Varchar2 DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
1367: P_Rbs_Version_Number IN Number DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
1360: P_Init_Msg_List IN Varchar2 DEFAULT FND_API.G_True,
1361: P_API_Version_Number IN Number,
1362: P_Rbs_Header_Id IN Number DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
1363: P_Rbs_Version_Id IN Number DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, --Not used
1364: P_Project_Id IN Number DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
1365: P_Pm_Project_Reference IN Varchar2 DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
1366: P_Rbs_Header_Name IN Varchar2 DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
1367: P_Rbs_Version_Number IN Number DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
1368: P_Prog_Rep_Usage_Flag IN Varchar2 DEFAULT 'N',
1361: P_API_Version_Number IN Number,
1362: P_Rbs_Header_Id IN Number DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
1363: P_Rbs_Version_Id IN Number DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, --Not used
1364: P_Project_Id IN Number DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
1365: P_Pm_Project_Reference IN Varchar2 DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
1366: P_Rbs_Header_Name IN Varchar2 DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
1367: P_Rbs_Version_Number IN Number DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
1368: P_Prog_Rep_Usage_Flag IN Varchar2 DEFAULT 'N',
1369: P_Primary_Rep_Flag IN Varchar2 DEFAULT 'N',
1362: P_Rbs_Header_Id IN Number DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
1363: P_Rbs_Version_Id IN Number DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, --Not used
1364: P_Project_Id IN Number DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
1365: P_Pm_Project_Reference IN Varchar2 DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
1366: P_Rbs_Header_Name IN Varchar2 DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
1367: P_Rbs_Version_Number IN Number DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
1368: P_Prog_Rep_Usage_Flag IN Varchar2 DEFAULT 'N',
1369: P_Primary_Rep_Flag IN Varchar2 DEFAULT 'N',
1370: X_Return_Status OUT NOCOPY Varchar2,
1363: P_Rbs_Version_Id IN Number DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, --Not used
1364: P_Project_Id IN Number DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
1365: P_Pm_Project_Reference IN Varchar2 DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
1366: P_Rbs_Header_Name IN Varchar2 DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
1367: P_Rbs_Version_Number IN Number DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
1368: P_Prog_Rep_Usage_Flag IN Varchar2 DEFAULT 'N',
1369: P_Primary_Rep_Flag IN Varchar2 DEFAULT 'N',
1370: X_Return_Status OUT NOCOPY Varchar2,
1371: X_Msg_Count OUT NOCOPY Number,