125: ----------------------------------------------------
126: -- Global PL/SQL Tables --
127: ----------------------------------------------------
128: --INSERT po_headers_interface
129: gIHInterfaceHeaderIdTbl DBMS_SQL.NUMBER_TABLE;
130: gIHActionTbl DBMS_SQL.VARCHAR2_TABLE;
131: gIHOrgIdTbl DBMS_SQL.NUMBER_TABLE;
132: gIHDocumentTypeCodeTbl DBMS_SQL.VARCHAR2_TABLE;
133: gIHBudgetAccountSegment1Tbl DBMS_SQL.VARCHAR2_TABLE;
126: -- Global PL/SQL Tables --
127: ----------------------------------------------------
128: --INSERT po_headers_interface
129: gIHInterfaceHeaderIdTbl DBMS_SQL.NUMBER_TABLE;
130: gIHActionTbl DBMS_SQL.VARCHAR2_TABLE;
131: gIHOrgIdTbl DBMS_SQL.NUMBER_TABLE;
132: gIHDocumentTypeCodeTbl DBMS_SQL.VARCHAR2_TABLE;
133: gIHBudgetAccountSegment1Tbl DBMS_SQL.VARCHAR2_TABLE;
134: gIHPoHeaderIdTbl DBMS_SQL.NUMBER_TABLE;
127: ----------------------------------------------------
128: --INSERT po_headers_interface
129: gIHInterfaceHeaderIdTbl DBMS_SQL.NUMBER_TABLE;
130: gIHActionTbl DBMS_SQL.VARCHAR2_TABLE;
131: gIHOrgIdTbl DBMS_SQL.NUMBER_TABLE;
132: gIHDocumentTypeCodeTbl DBMS_SQL.VARCHAR2_TABLE;
133: gIHBudgetAccountSegment1Tbl DBMS_SQL.VARCHAR2_TABLE;
134: gIHPoHeaderIdTbl DBMS_SQL.NUMBER_TABLE;
135: gIHApprovalStatusTbl DBMS_SQL.VARCHAR2_TABLE;
128: --INSERT po_headers_interface
129: gIHInterfaceHeaderIdTbl DBMS_SQL.NUMBER_TABLE;
130: gIHActionTbl DBMS_SQL.VARCHAR2_TABLE;
131: gIHOrgIdTbl DBMS_SQL.NUMBER_TABLE;
132: gIHDocumentTypeCodeTbl DBMS_SQL.VARCHAR2_TABLE;
133: gIHBudgetAccountSegment1Tbl DBMS_SQL.VARCHAR2_TABLE;
134: gIHPoHeaderIdTbl DBMS_SQL.NUMBER_TABLE;
135: gIHApprovalStatusTbl DBMS_SQL.VARCHAR2_TABLE;
136: gIHVendorIdTbl DBMS_SQL.NUMBER_TABLE;
129: gIHInterfaceHeaderIdTbl DBMS_SQL.NUMBER_TABLE;
130: gIHActionTbl DBMS_SQL.VARCHAR2_TABLE;
131: gIHOrgIdTbl DBMS_SQL.NUMBER_TABLE;
132: gIHDocumentTypeCodeTbl DBMS_SQL.VARCHAR2_TABLE;
133: gIHBudgetAccountSegment1Tbl DBMS_SQL.VARCHAR2_TABLE;
134: gIHPoHeaderIdTbl DBMS_SQL.NUMBER_TABLE;
135: gIHApprovalStatusTbl DBMS_SQL.VARCHAR2_TABLE;
136: gIHVendorIdTbl DBMS_SQL.NUMBER_TABLE;
137: gIHVendorSiteIdTbl DBMS_SQL.NUMBER_TABLE;
130: gIHActionTbl DBMS_SQL.VARCHAR2_TABLE;
131: gIHOrgIdTbl DBMS_SQL.NUMBER_TABLE;
132: gIHDocumentTypeCodeTbl DBMS_SQL.VARCHAR2_TABLE;
133: gIHBudgetAccountSegment1Tbl DBMS_SQL.VARCHAR2_TABLE;
134: gIHPoHeaderIdTbl DBMS_SQL.NUMBER_TABLE;
135: gIHApprovalStatusTbl DBMS_SQL.VARCHAR2_TABLE;
136: gIHVendorIdTbl DBMS_SQL.NUMBER_TABLE;
137: gIHVendorSiteIdTbl DBMS_SQL.NUMBER_TABLE;
138: gIHCurrencyCodeTbl DBMS_SQL.VARCHAR2_TABLE;
131: gIHOrgIdTbl DBMS_SQL.NUMBER_TABLE;
132: gIHDocumentTypeCodeTbl DBMS_SQL.VARCHAR2_TABLE;
133: gIHBudgetAccountSegment1Tbl DBMS_SQL.VARCHAR2_TABLE;
134: gIHPoHeaderIdTbl DBMS_SQL.NUMBER_TABLE;
135: gIHApprovalStatusTbl DBMS_SQL.VARCHAR2_TABLE;
136: gIHVendorIdTbl DBMS_SQL.NUMBER_TABLE;
137: gIHVendorSiteIdTbl DBMS_SQL.NUMBER_TABLE;
138: gIHCurrencyCodeTbl DBMS_SQL.VARCHAR2_TABLE;
139: gIHCpaReferenceTbl DBMS_SQL.NUMBER_TABLE;
132: gIHDocumentTypeCodeTbl DBMS_SQL.VARCHAR2_TABLE;
133: gIHBudgetAccountSegment1Tbl DBMS_SQL.VARCHAR2_TABLE;
134: gIHPoHeaderIdTbl DBMS_SQL.NUMBER_TABLE;
135: gIHApprovalStatusTbl DBMS_SQL.VARCHAR2_TABLE;
136: gIHVendorIdTbl DBMS_SQL.NUMBER_TABLE;
137: gIHVendorSiteIdTbl DBMS_SQL.NUMBER_TABLE;
138: gIHCurrencyCodeTbl DBMS_SQL.VARCHAR2_TABLE;
139: gIHCpaReferenceTbl DBMS_SQL.NUMBER_TABLE;
140: gIHCreatedLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
133: gIHBudgetAccountSegment1Tbl DBMS_SQL.VARCHAR2_TABLE;
134: gIHPoHeaderIdTbl DBMS_SQL.NUMBER_TABLE;
135: gIHApprovalStatusTbl DBMS_SQL.VARCHAR2_TABLE;
136: gIHVendorIdTbl DBMS_SQL.NUMBER_TABLE;
137: gIHVendorSiteIdTbl DBMS_SQL.NUMBER_TABLE;
138: gIHCurrencyCodeTbl DBMS_SQL.VARCHAR2_TABLE;
139: gIHCpaReferenceTbl DBMS_SQL.NUMBER_TABLE;
140: gIHCreatedLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
141: gIHCommentsTbl DBMS_SQL.VARCHAR2_TABLE;
134: gIHPoHeaderIdTbl DBMS_SQL.NUMBER_TABLE;
135: gIHApprovalStatusTbl DBMS_SQL.VARCHAR2_TABLE;
136: gIHVendorIdTbl DBMS_SQL.NUMBER_TABLE;
137: gIHVendorSiteIdTbl DBMS_SQL.NUMBER_TABLE;
138: gIHCurrencyCodeTbl DBMS_SQL.VARCHAR2_TABLE;
139: gIHCpaReferenceTbl DBMS_SQL.NUMBER_TABLE;
140: gIHCreatedLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
141: gIHCommentsTbl DBMS_SQL.VARCHAR2_TABLE;
142:
135: gIHApprovalStatusTbl DBMS_SQL.VARCHAR2_TABLE;
136: gIHVendorIdTbl DBMS_SQL.NUMBER_TABLE;
137: gIHVendorSiteIdTbl DBMS_SQL.NUMBER_TABLE;
138: gIHCurrencyCodeTbl DBMS_SQL.VARCHAR2_TABLE;
139: gIHCpaReferenceTbl DBMS_SQL.NUMBER_TABLE;
140: gIHCreatedLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
141: gIHCommentsTbl DBMS_SQL.VARCHAR2_TABLE;
142:
143: --INSERT po_lines_interface
136: gIHVendorIdTbl DBMS_SQL.NUMBER_TABLE;
137: gIHVendorSiteIdTbl DBMS_SQL.NUMBER_TABLE;
138: gIHCurrencyCodeTbl DBMS_SQL.VARCHAR2_TABLE;
139: gIHCpaReferenceTbl DBMS_SQL.NUMBER_TABLE;
140: gIHCreatedLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
141: gIHCommentsTbl DBMS_SQL.VARCHAR2_TABLE;
142:
143: --INSERT po_lines_interface
144: gILInterfaceLineIdTbl DBMS_SQL.NUMBER_TABLE;
137: gIHVendorSiteIdTbl DBMS_SQL.NUMBER_TABLE;
138: gIHCurrencyCodeTbl DBMS_SQL.VARCHAR2_TABLE;
139: gIHCpaReferenceTbl DBMS_SQL.NUMBER_TABLE;
140: gIHCreatedLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
141: gIHCommentsTbl DBMS_SQL.VARCHAR2_TABLE;
142:
143: --INSERT po_lines_interface
144: gILInterfaceLineIdTbl DBMS_SQL.NUMBER_TABLE;
145: gILInterfaceHeaderIdTbl DBMS_SQL.NUMBER_TABLE;
140: gIHCreatedLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
141: gIHCommentsTbl DBMS_SQL.VARCHAR2_TABLE;
142:
143: --INSERT po_lines_interface
144: gILInterfaceLineIdTbl DBMS_SQL.NUMBER_TABLE;
145: gILInterfaceHeaderIdTbl DBMS_SQL.NUMBER_TABLE;
146: gILActionTbl DBMS_SQL.VARCHAR2_TABLE;
147: gILPoLineIdTbl DBMS_SQL.NUMBER_TABLE;
148: gILPoHeaderIdTbl DBMS_SQL.NUMBER_TABLE;
141: gIHCommentsTbl DBMS_SQL.VARCHAR2_TABLE;
142:
143: --INSERT po_lines_interface
144: gILInterfaceLineIdTbl DBMS_SQL.NUMBER_TABLE;
145: gILInterfaceHeaderIdTbl DBMS_SQL.NUMBER_TABLE;
146: gILActionTbl DBMS_SQL.VARCHAR2_TABLE;
147: gILPoLineIdTbl DBMS_SQL.NUMBER_TABLE;
148: gILPoHeaderIdTbl DBMS_SQL.NUMBER_TABLE;
149: gILUnitPriceTbl DBMS_SQL.NUMBER_TABLE;
142:
143: --INSERT po_lines_interface
144: gILInterfaceLineIdTbl DBMS_SQL.NUMBER_TABLE;
145: gILInterfaceHeaderIdTbl DBMS_SQL.NUMBER_TABLE;
146: gILActionTbl DBMS_SQL.VARCHAR2_TABLE;
147: gILPoLineIdTbl DBMS_SQL.NUMBER_TABLE;
148: gILPoHeaderIdTbl DBMS_SQL.NUMBER_TABLE;
149: gILUnitPriceTbl DBMS_SQL.NUMBER_TABLE;
150: gILUomCodeTbl DBMS_SQL.VARCHAR2_TABLE;
143: --INSERT po_lines_interface
144: gILInterfaceLineIdTbl DBMS_SQL.NUMBER_TABLE;
145: gILInterfaceHeaderIdTbl DBMS_SQL.NUMBER_TABLE;
146: gILActionTbl DBMS_SQL.VARCHAR2_TABLE;
147: gILPoLineIdTbl DBMS_SQL.NUMBER_TABLE;
148: gILPoHeaderIdTbl DBMS_SQL.NUMBER_TABLE;
149: gILUnitPriceTbl DBMS_SQL.NUMBER_TABLE;
150: gILUomCodeTbl DBMS_SQL.VARCHAR2_TABLE;
151: gILNegByPrepFlagTbl DBMS_SQL.VARCHAR2_TABLE;
144: gILInterfaceLineIdTbl DBMS_SQL.NUMBER_TABLE;
145: gILInterfaceHeaderIdTbl DBMS_SQL.NUMBER_TABLE;
146: gILActionTbl DBMS_SQL.VARCHAR2_TABLE;
147: gILPoLineIdTbl DBMS_SQL.NUMBER_TABLE;
148: gILPoHeaderIdTbl DBMS_SQL.NUMBER_TABLE;
149: gILUnitPriceTbl DBMS_SQL.NUMBER_TABLE;
150: gILUomCodeTbl DBMS_SQL.VARCHAR2_TABLE;
151: gILNegByPrepFlagTbl DBMS_SQL.VARCHAR2_TABLE;
152: gILIpCategoryIdTbl DBMS_SQL.NUMBER_TABLE;
145: gILInterfaceHeaderIdTbl DBMS_SQL.NUMBER_TABLE;
146: gILActionTbl DBMS_SQL.VARCHAR2_TABLE;
147: gILPoLineIdTbl DBMS_SQL.NUMBER_TABLE;
148: gILPoHeaderIdTbl DBMS_SQL.NUMBER_TABLE;
149: gILUnitPriceTbl DBMS_SQL.NUMBER_TABLE;
150: gILUomCodeTbl DBMS_SQL.VARCHAR2_TABLE;
151: gILNegByPrepFlagTbl DBMS_SQL.VARCHAR2_TABLE;
152: gILIpCategoryIdTbl DBMS_SQL.NUMBER_TABLE;
153: gILCategoryIdTbl DBMS_SQL.NUMBER_TABLE;
146: gILActionTbl DBMS_SQL.VARCHAR2_TABLE;
147: gILPoLineIdTbl DBMS_SQL.NUMBER_TABLE;
148: gILPoHeaderIdTbl DBMS_SQL.NUMBER_TABLE;
149: gILUnitPriceTbl DBMS_SQL.NUMBER_TABLE;
150: gILUomCodeTbl DBMS_SQL.VARCHAR2_TABLE;
151: gILNegByPrepFlagTbl DBMS_SQL.VARCHAR2_TABLE;
152: gILIpCategoryIdTbl DBMS_SQL.NUMBER_TABLE;
153: gILCategoryIdTbl DBMS_SQL.NUMBER_TABLE;
154: gILCategoryNameTbl DBMS_SQL.VARCHAR2_TABLE;
147: gILPoLineIdTbl DBMS_SQL.NUMBER_TABLE;
148: gILPoHeaderIdTbl DBMS_SQL.NUMBER_TABLE;
149: gILUnitPriceTbl DBMS_SQL.NUMBER_TABLE;
150: gILUomCodeTbl DBMS_SQL.VARCHAR2_TABLE;
151: gILNegByPrepFlagTbl DBMS_SQL.VARCHAR2_TABLE;
152: gILIpCategoryIdTbl DBMS_SQL.NUMBER_TABLE;
153: gILCategoryIdTbl DBMS_SQL.NUMBER_TABLE;
154: gILCategoryNameTbl DBMS_SQL.VARCHAR2_TABLE;
155: gILVendorProductNumTbl DBMS_SQL.VARCHAR2_TABLE;
148: gILPoHeaderIdTbl DBMS_SQL.NUMBER_TABLE;
149: gILUnitPriceTbl DBMS_SQL.NUMBER_TABLE;
150: gILUomCodeTbl DBMS_SQL.VARCHAR2_TABLE;
151: gILNegByPrepFlagTbl DBMS_SQL.VARCHAR2_TABLE;
152: gILIpCategoryIdTbl DBMS_SQL.NUMBER_TABLE;
153: gILCategoryIdTbl DBMS_SQL.NUMBER_TABLE;
154: gILCategoryNameTbl DBMS_SQL.VARCHAR2_TABLE;
155: gILVendorProductNumTbl DBMS_SQL.VARCHAR2_TABLE;
156: gILSupplierPartAuxidTbl DBMS_SQL.VARCHAR2_TABLE;
149: gILUnitPriceTbl DBMS_SQL.NUMBER_TABLE;
150: gILUomCodeTbl DBMS_SQL.VARCHAR2_TABLE;
151: gILNegByPrepFlagTbl DBMS_SQL.VARCHAR2_TABLE;
152: gILIpCategoryIdTbl DBMS_SQL.NUMBER_TABLE;
153: gILCategoryIdTbl DBMS_SQL.NUMBER_TABLE;
154: gILCategoryNameTbl DBMS_SQL.VARCHAR2_TABLE;
155: gILVendorProductNumTbl DBMS_SQL.VARCHAR2_TABLE;
156: gILSupplierPartAuxidTbl DBMS_SQL.VARCHAR2_TABLE;
157: gILItemDescripionTbl DBMS_SQL.VARCHAR2_TABLE;
150: gILUomCodeTbl DBMS_SQL.VARCHAR2_TABLE;
151: gILNegByPrepFlagTbl DBMS_SQL.VARCHAR2_TABLE;
152: gILIpCategoryIdTbl DBMS_SQL.NUMBER_TABLE;
153: gILCategoryIdTbl DBMS_SQL.NUMBER_TABLE;
154: gILCategoryNameTbl DBMS_SQL.VARCHAR2_TABLE;
155: gILVendorProductNumTbl DBMS_SQL.VARCHAR2_TABLE;
156: gILSupplierPartAuxidTbl DBMS_SQL.VARCHAR2_TABLE;
157: gILItemDescripionTbl DBMS_SQL.VARCHAR2_TABLE;
158: gILCatalogNameTbl DBMS_SQL.VARCHAR2_TABLE;
151: gILNegByPrepFlagTbl DBMS_SQL.VARCHAR2_TABLE;
152: gILIpCategoryIdTbl DBMS_SQL.NUMBER_TABLE;
153: gILCategoryIdTbl DBMS_SQL.NUMBER_TABLE;
154: gILCategoryNameTbl DBMS_SQL.VARCHAR2_TABLE;
155: gILVendorProductNumTbl DBMS_SQL.VARCHAR2_TABLE;
156: gILSupplierPartAuxidTbl DBMS_SQL.VARCHAR2_TABLE;
157: gILItemDescripionTbl DBMS_SQL.VARCHAR2_TABLE;
158: gILCatalogNameTbl DBMS_SQL.VARCHAR2_TABLE;
159:
152: gILIpCategoryIdTbl DBMS_SQL.NUMBER_TABLE;
153: gILCategoryIdTbl DBMS_SQL.NUMBER_TABLE;
154: gILCategoryNameTbl DBMS_SQL.VARCHAR2_TABLE;
155: gILVendorProductNumTbl DBMS_SQL.VARCHAR2_TABLE;
156: gILSupplierPartAuxidTbl DBMS_SQL.VARCHAR2_TABLE;
157: gILItemDescripionTbl DBMS_SQL.VARCHAR2_TABLE;
158: gILCatalogNameTbl DBMS_SQL.VARCHAR2_TABLE;
159:
160: --INSERT po_attr_values_interface
153: gILCategoryIdTbl DBMS_SQL.NUMBER_TABLE;
154: gILCategoryNameTbl DBMS_SQL.VARCHAR2_TABLE;
155: gILVendorProductNumTbl DBMS_SQL.VARCHAR2_TABLE;
156: gILSupplierPartAuxidTbl DBMS_SQL.VARCHAR2_TABLE;
157: gILItemDescripionTbl DBMS_SQL.VARCHAR2_TABLE;
158: gILCatalogNameTbl DBMS_SQL.VARCHAR2_TABLE;
159:
160: --INSERT po_attr_values_interface
161: gIAVInterfaceHeaderIdTbl DBMS_SQL.NUMBER_TABLE;
154: gILCategoryNameTbl DBMS_SQL.VARCHAR2_TABLE;
155: gILVendorProductNumTbl DBMS_SQL.VARCHAR2_TABLE;
156: gILSupplierPartAuxidTbl DBMS_SQL.VARCHAR2_TABLE;
157: gILItemDescripionTbl DBMS_SQL.VARCHAR2_TABLE;
158: gILCatalogNameTbl DBMS_SQL.VARCHAR2_TABLE;
159:
160: --INSERT po_attr_values_interface
161: gIAVInterfaceHeaderIdTbl DBMS_SQL.NUMBER_TABLE;
162: gIAVInterfaceLineIdTbl DBMS_SQL.NUMBER_TABLE;
157: gILItemDescripionTbl DBMS_SQL.VARCHAR2_TABLE;
158: gILCatalogNameTbl DBMS_SQL.VARCHAR2_TABLE;
159:
160: --INSERT po_attr_values_interface
161: gIAVInterfaceHeaderIdTbl DBMS_SQL.NUMBER_TABLE;
162: gIAVInterfaceLineIdTbl DBMS_SQL.NUMBER_TABLE;
163: gIAVActionTbl DBMS_SQL.VARCHAR2_TABLE;
164: gIAVPoLineIdTbl DBMS_SQL.NUMBER_TABLE;
165: gIAVReqTemplateNameTbl DBMS_SQL.VARCHAR2_TABLE;
158: gILCatalogNameTbl DBMS_SQL.VARCHAR2_TABLE;
159:
160: --INSERT po_attr_values_interface
161: gIAVInterfaceHeaderIdTbl DBMS_SQL.NUMBER_TABLE;
162: gIAVInterfaceLineIdTbl DBMS_SQL.NUMBER_TABLE;
163: gIAVActionTbl DBMS_SQL.VARCHAR2_TABLE;
164: gIAVPoLineIdTbl DBMS_SQL.NUMBER_TABLE;
165: gIAVReqTemplateNameTbl DBMS_SQL.VARCHAR2_TABLE;
166: gIAVReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;
159:
160: --INSERT po_attr_values_interface
161: gIAVInterfaceHeaderIdTbl DBMS_SQL.NUMBER_TABLE;
162: gIAVInterfaceLineIdTbl DBMS_SQL.NUMBER_TABLE;
163: gIAVActionTbl DBMS_SQL.VARCHAR2_TABLE;
164: gIAVPoLineIdTbl DBMS_SQL.NUMBER_TABLE;
165: gIAVReqTemplateNameTbl DBMS_SQL.VARCHAR2_TABLE;
166: gIAVReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;
167: gIAVInventoryItemIdTbl DBMS_SQL.NUMBER_TABLE;
160: --INSERT po_attr_values_interface
161: gIAVInterfaceHeaderIdTbl DBMS_SQL.NUMBER_TABLE;
162: gIAVInterfaceLineIdTbl DBMS_SQL.NUMBER_TABLE;
163: gIAVActionTbl DBMS_SQL.VARCHAR2_TABLE;
164: gIAVPoLineIdTbl DBMS_SQL.NUMBER_TABLE;
165: gIAVReqTemplateNameTbl DBMS_SQL.VARCHAR2_TABLE;
166: gIAVReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;
167: gIAVInventoryItemIdTbl DBMS_SQL.NUMBER_TABLE;
168: gIAVOrgIdTbl DBMS_SQL.NUMBER_TABLE;
161: gIAVInterfaceHeaderIdTbl DBMS_SQL.NUMBER_TABLE;
162: gIAVInterfaceLineIdTbl DBMS_SQL.NUMBER_TABLE;
163: gIAVActionTbl DBMS_SQL.VARCHAR2_TABLE;
164: gIAVPoLineIdTbl DBMS_SQL.NUMBER_TABLE;
165: gIAVReqTemplateNameTbl DBMS_SQL.VARCHAR2_TABLE;
166: gIAVReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;
167: gIAVInventoryItemIdTbl DBMS_SQL.NUMBER_TABLE;
168: gIAVOrgIdTbl DBMS_SQL.NUMBER_TABLE;
169: gIAVRtItemIdTbl DBMS_SQL.NUMBER_TABLE;
162: gIAVInterfaceLineIdTbl DBMS_SQL.NUMBER_TABLE;
163: gIAVActionTbl DBMS_SQL.VARCHAR2_TABLE;
164: gIAVPoLineIdTbl DBMS_SQL.NUMBER_TABLE;
165: gIAVReqTemplateNameTbl DBMS_SQL.VARCHAR2_TABLE;
166: gIAVReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;
167: gIAVInventoryItemIdTbl DBMS_SQL.NUMBER_TABLE;
168: gIAVOrgIdTbl DBMS_SQL.NUMBER_TABLE;
169: gIAVRtItemIdTbl DBMS_SQL.NUMBER_TABLE;
170: gIAVLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
163: gIAVActionTbl DBMS_SQL.VARCHAR2_TABLE;
164: gIAVPoLineIdTbl DBMS_SQL.NUMBER_TABLE;
165: gIAVReqTemplateNameTbl DBMS_SQL.VARCHAR2_TABLE;
166: gIAVReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;
167: gIAVInventoryItemIdTbl DBMS_SQL.NUMBER_TABLE;
168: gIAVOrgIdTbl DBMS_SQL.NUMBER_TABLE;
169: gIAVRtItemIdTbl DBMS_SQL.NUMBER_TABLE;
170: gIAVLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
171:
164: gIAVPoLineIdTbl DBMS_SQL.NUMBER_TABLE;
165: gIAVReqTemplateNameTbl DBMS_SQL.VARCHAR2_TABLE;
166: gIAVReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;
167: gIAVInventoryItemIdTbl DBMS_SQL.NUMBER_TABLE;
168: gIAVOrgIdTbl DBMS_SQL.NUMBER_TABLE;
169: gIAVRtItemIdTbl DBMS_SQL.NUMBER_TABLE;
170: gIAVLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
171:
172: --INSERT po_attr_values_tlp_interface
165: gIAVReqTemplateNameTbl DBMS_SQL.VARCHAR2_TABLE;
166: gIAVReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;
167: gIAVInventoryItemIdTbl DBMS_SQL.NUMBER_TABLE;
168: gIAVOrgIdTbl DBMS_SQL.NUMBER_TABLE;
169: gIAVRtItemIdTbl DBMS_SQL.NUMBER_TABLE;
170: gIAVLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
171:
172: --INSERT po_attr_values_tlp_interface
173: gIAVTInterfaceHeaderIdTbl DBMS_SQL.NUMBER_TABLE;
166: gIAVReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;
167: gIAVInventoryItemIdTbl DBMS_SQL.NUMBER_TABLE;
168: gIAVOrgIdTbl DBMS_SQL.NUMBER_TABLE;
169: gIAVRtItemIdTbl DBMS_SQL.NUMBER_TABLE;
170: gIAVLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
171:
172: --INSERT po_attr_values_tlp_interface
173: gIAVTInterfaceHeaderIdTbl DBMS_SQL.NUMBER_TABLE;
174: gIAVTInterfaceLineIdTbl DBMS_SQL.NUMBER_TABLE;
169: gIAVRtItemIdTbl DBMS_SQL.NUMBER_TABLE;
170: gIAVLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
171:
172: --INSERT po_attr_values_tlp_interface
173: gIAVTInterfaceHeaderIdTbl DBMS_SQL.NUMBER_TABLE;
174: gIAVTInterfaceLineIdTbl DBMS_SQL.NUMBER_TABLE;
175: gIAVTActionTbl DBMS_SQL.VARCHAR2_TABLE;
176: gIAVTPoLineIdTbl DBMS_SQL.NUMBER_TABLE;
177: gIAVTReqTemplateNameTbl DBMS_SQL.VARCHAR2_TABLE;
170: gIAVLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
171:
172: --INSERT po_attr_values_tlp_interface
173: gIAVTInterfaceHeaderIdTbl DBMS_SQL.NUMBER_TABLE;
174: gIAVTInterfaceLineIdTbl DBMS_SQL.NUMBER_TABLE;
175: gIAVTActionTbl DBMS_SQL.VARCHAR2_TABLE;
176: gIAVTPoLineIdTbl DBMS_SQL.NUMBER_TABLE;
177: gIAVTReqTemplateNameTbl DBMS_SQL.VARCHAR2_TABLE;
178: gIAVTReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;
171:
172: --INSERT po_attr_values_tlp_interface
173: gIAVTInterfaceHeaderIdTbl DBMS_SQL.NUMBER_TABLE;
174: gIAVTInterfaceLineIdTbl DBMS_SQL.NUMBER_TABLE;
175: gIAVTActionTbl DBMS_SQL.VARCHAR2_TABLE;
176: gIAVTPoLineIdTbl DBMS_SQL.NUMBER_TABLE;
177: gIAVTReqTemplateNameTbl DBMS_SQL.VARCHAR2_TABLE;
178: gIAVTReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;
179: gIAVTInventoryItemIdTbl DBMS_SQL.NUMBER_TABLE;
172: --INSERT po_attr_values_tlp_interface
173: gIAVTInterfaceHeaderIdTbl DBMS_SQL.NUMBER_TABLE;
174: gIAVTInterfaceLineIdTbl DBMS_SQL.NUMBER_TABLE;
175: gIAVTActionTbl DBMS_SQL.VARCHAR2_TABLE;
176: gIAVTPoLineIdTbl DBMS_SQL.NUMBER_TABLE;
177: gIAVTReqTemplateNameTbl DBMS_SQL.VARCHAR2_TABLE;
178: gIAVTReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;
179: gIAVTInventoryItemIdTbl DBMS_SQL.NUMBER_TABLE;
180: gIAVTOrgIdTbl DBMS_SQL.NUMBER_TABLE;
173: gIAVTInterfaceHeaderIdTbl DBMS_SQL.NUMBER_TABLE;
174: gIAVTInterfaceLineIdTbl DBMS_SQL.NUMBER_TABLE;
175: gIAVTActionTbl DBMS_SQL.VARCHAR2_TABLE;
176: gIAVTPoLineIdTbl DBMS_SQL.NUMBER_TABLE;
177: gIAVTReqTemplateNameTbl DBMS_SQL.VARCHAR2_TABLE;
178: gIAVTReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;
179: gIAVTInventoryItemIdTbl DBMS_SQL.NUMBER_TABLE;
180: gIAVTOrgIdTbl DBMS_SQL.NUMBER_TABLE;
181: gIAVTRtItemIdTbl DBMS_SQL.NUMBER_TABLE;
174: gIAVTInterfaceLineIdTbl DBMS_SQL.NUMBER_TABLE;
175: gIAVTActionTbl DBMS_SQL.VARCHAR2_TABLE;
176: gIAVTPoLineIdTbl DBMS_SQL.NUMBER_TABLE;
177: gIAVTReqTemplateNameTbl DBMS_SQL.VARCHAR2_TABLE;
178: gIAVTReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;
179: gIAVTInventoryItemIdTbl DBMS_SQL.NUMBER_TABLE;
180: gIAVTOrgIdTbl DBMS_SQL.NUMBER_TABLE;
181: gIAVTRtItemIdTbl DBMS_SQL.NUMBER_TABLE;
182: gIAVTLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
175: gIAVTActionTbl DBMS_SQL.VARCHAR2_TABLE;
176: gIAVTPoLineIdTbl DBMS_SQL.NUMBER_TABLE;
177: gIAVTReqTemplateNameTbl DBMS_SQL.VARCHAR2_TABLE;
178: gIAVTReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;
179: gIAVTInventoryItemIdTbl DBMS_SQL.NUMBER_TABLE;
180: gIAVTOrgIdTbl DBMS_SQL.NUMBER_TABLE;
181: gIAVTRtItemIdTbl DBMS_SQL.NUMBER_TABLE;
182: gIAVTLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
183: gIAVTCheckDescUpdateTbl DBMS_SQL.VARCHAR2_TABLE;
176: gIAVTPoLineIdTbl DBMS_SQL.NUMBER_TABLE;
177: gIAVTReqTemplateNameTbl DBMS_SQL.VARCHAR2_TABLE;
178: gIAVTReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;
179: gIAVTInventoryItemIdTbl DBMS_SQL.NUMBER_TABLE;
180: gIAVTOrgIdTbl DBMS_SQL.NUMBER_TABLE;
181: gIAVTRtItemIdTbl DBMS_SQL.NUMBER_TABLE;
182: gIAVTLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
183: gIAVTCheckDescUpdateTbl DBMS_SQL.VARCHAR2_TABLE;
184:
177: gIAVTReqTemplateNameTbl DBMS_SQL.VARCHAR2_TABLE;
178: gIAVTReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;
179: gIAVTInventoryItemIdTbl DBMS_SQL.NUMBER_TABLE;
180: gIAVTOrgIdTbl DBMS_SQL.NUMBER_TABLE;
181: gIAVTRtItemIdTbl DBMS_SQL.NUMBER_TABLE;
182: gIAVTLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
183: gIAVTCheckDescUpdateTbl DBMS_SQL.VARCHAR2_TABLE;
184:
185: --INSERT icx_cat_r12_upgrade
178: gIAVTReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;
179: gIAVTInventoryItemIdTbl DBMS_SQL.NUMBER_TABLE;
180: gIAVTOrgIdTbl DBMS_SQL.NUMBER_TABLE;
181: gIAVTRtItemIdTbl DBMS_SQL.NUMBER_TABLE;
182: gIAVTLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
183: gIAVTCheckDescUpdateTbl DBMS_SQL.VARCHAR2_TABLE;
184:
185: --INSERT icx_cat_r12_upgrade
186: gIRURtItemIdTbl DBMS_SQL.NUMBER_TABLE;
179: gIAVTInventoryItemIdTbl DBMS_SQL.NUMBER_TABLE;
180: gIAVTOrgIdTbl DBMS_SQL.NUMBER_TABLE;
181: gIAVTRtItemIdTbl DBMS_SQL.NUMBER_TABLE;
182: gIAVTLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
183: gIAVTCheckDescUpdateTbl DBMS_SQL.VARCHAR2_TABLE;
184:
185: --INSERT icx_cat_r12_upgrade
186: gIRURtItemIdTbl DBMS_SQL.NUMBER_TABLE;
187: gIRUSupplierSiteIdTbl DBMS_SQL.NUMBER_TABLE;
182: gIAVTLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
183: gIAVTCheckDescUpdateTbl DBMS_SQL.VARCHAR2_TABLE;
184:
185: --INSERT icx_cat_r12_upgrade
186: gIRURtItemIdTbl DBMS_SQL.NUMBER_TABLE;
187: gIRUSupplierSiteIdTbl DBMS_SQL.NUMBER_TABLE;
188: gIRUCurrencyTbl DBMS_SQL.VARCHAR2_TABLE;
189: gIRUCpaReferenceTbl DBMS_SQL.NUMBER_TABLE;
190: gIRUPriceContractIdTbl DBMS_SQL.NUMBER_TABLE;
183: gIAVTCheckDescUpdateTbl DBMS_SQL.VARCHAR2_TABLE;
184:
185: --INSERT icx_cat_r12_upgrade
186: gIRURtItemIdTbl DBMS_SQL.NUMBER_TABLE;
187: gIRUSupplierSiteIdTbl DBMS_SQL.NUMBER_TABLE;
188: gIRUCurrencyTbl DBMS_SQL.VARCHAR2_TABLE;
189: gIRUCpaReferenceTbl DBMS_SQL.NUMBER_TABLE;
190: gIRUPriceContractIdTbl DBMS_SQL.NUMBER_TABLE;
191: gIRUSrcContractIdTbl DBMS_SQL.NUMBER_TABLE;
184:
185: --INSERT icx_cat_r12_upgrade
186: gIRURtItemIdTbl DBMS_SQL.NUMBER_TABLE;
187: gIRUSupplierSiteIdTbl DBMS_SQL.NUMBER_TABLE;
188: gIRUCurrencyTbl DBMS_SQL.VARCHAR2_TABLE;
189: gIRUCpaReferenceTbl DBMS_SQL.NUMBER_TABLE;
190: gIRUPriceContractIdTbl DBMS_SQL.NUMBER_TABLE;
191: gIRUSrcContractIdTbl DBMS_SQL.NUMBER_TABLE;
192: gIRUPoCategoryIdTbl DBMS_SQL.VARCHAR2_TABLE;
185: --INSERT icx_cat_r12_upgrade
186: gIRURtItemIdTbl DBMS_SQL.NUMBER_TABLE;
187: gIRUSupplierSiteIdTbl DBMS_SQL.NUMBER_TABLE;
188: gIRUCurrencyTbl DBMS_SQL.VARCHAR2_TABLE;
189: gIRUCpaReferenceTbl DBMS_SQL.NUMBER_TABLE;
190: gIRUPriceContractIdTbl DBMS_SQL.NUMBER_TABLE;
191: gIRUSrcContractIdTbl DBMS_SQL.NUMBER_TABLE;
192: gIRUPoCategoryIdTbl DBMS_SQL.VARCHAR2_TABLE;
193: gIRUPoInterfaceHeaderIdTbl DBMS_SQL.NUMBER_TABLE;
186: gIRURtItemIdTbl DBMS_SQL.NUMBER_TABLE;
187: gIRUSupplierSiteIdTbl DBMS_SQL.NUMBER_TABLE;
188: gIRUCurrencyTbl DBMS_SQL.VARCHAR2_TABLE;
189: gIRUCpaReferenceTbl DBMS_SQL.NUMBER_TABLE;
190: gIRUPriceContractIdTbl DBMS_SQL.NUMBER_TABLE;
191: gIRUSrcContractIdTbl DBMS_SQL.NUMBER_TABLE;
192: gIRUPoCategoryIdTbl DBMS_SQL.VARCHAR2_TABLE;
193: gIRUPoInterfaceHeaderIdTbl DBMS_SQL.NUMBER_TABLE;
194: gIRUPoInterfaceLineIdTbl DBMS_SQL.NUMBER_TABLE;
187: gIRUSupplierSiteIdTbl DBMS_SQL.NUMBER_TABLE;
188: gIRUCurrencyTbl DBMS_SQL.VARCHAR2_TABLE;
189: gIRUCpaReferenceTbl DBMS_SQL.NUMBER_TABLE;
190: gIRUPriceContractIdTbl DBMS_SQL.NUMBER_TABLE;
191: gIRUSrcContractIdTbl DBMS_SQL.NUMBER_TABLE;
192: gIRUPoCategoryIdTbl DBMS_SQL.VARCHAR2_TABLE;
193: gIRUPoInterfaceHeaderIdTbl DBMS_SQL.NUMBER_TABLE;
194: gIRUPoInterfaceLineIdTbl DBMS_SQL.NUMBER_TABLE;
195: gIRUCreatedLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
188: gIRUCurrencyTbl DBMS_SQL.VARCHAR2_TABLE;
189: gIRUCpaReferenceTbl DBMS_SQL.NUMBER_TABLE;
190: gIRUPriceContractIdTbl DBMS_SQL.NUMBER_TABLE;
191: gIRUSrcContractIdTbl DBMS_SQL.NUMBER_TABLE;
192: gIRUPoCategoryIdTbl DBMS_SQL.VARCHAR2_TABLE;
193: gIRUPoInterfaceHeaderIdTbl DBMS_SQL.NUMBER_TABLE;
194: gIRUPoInterfaceLineIdTbl DBMS_SQL.NUMBER_TABLE;
195: gIRUCreatedLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
196: -- TBD gIRUExtractorUpdatedFlagTbl DBMS_SQL.VARCHAR2_TABLE;
189: gIRUCpaReferenceTbl DBMS_SQL.NUMBER_TABLE;
190: gIRUPriceContractIdTbl DBMS_SQL.NUMBER_TABLE;
191: gIRUSrcContractIdTbl DBMS_SQL.NUMBER_TABLE;
192: gIRUPoCategoryIdTbl DBMS_SQL.VARCHAR2_TABLE;
193: gIRUPoInterfaceHeaderIdTbl DBMS_SQL.NUMBER_TABLE;
194: gIRUPoInterfaceLineIdTbl DBMS_SQL.NUMBER_TABLE;
195: gIRUCreatedLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
196: -- TBD gIRUExtractorUpdatedFlagTbl DBMS_SQL.VARCHAR2_TABLE;
197:
190: gIRUPriceContractIdTbl DBMS_SQL.NUMBER_TABLE;
191: gIRUSrcContractIdTbl DBMS_SQL.NUMBER_TABLE;
192: gIRUPoCategoryIdTbl DBMS_SQL.VARCHAR2_TABLE;
193: gIRUPoInterfaceHeaderIdTbl DBMS_SQL.NUMBER_TABLE;
194: gIRUPoInterfaceLineIdTbl DBMS_SQL.NUMBER_TABLE;
195: gIRUCreatedLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
196: -- TBD gIRUExtractorUpdatedFlagTbl DBMS_SQL.VARCHAR2_TABLE;
197:
198: --UPDATE icx_cat_r12_upgrade
191: gIRUSrcContractIdTbl DBMS_SQL.NUMBER_TABLE;
192: gIRUPoCategoryIdTbl DBMS_SQL.VARCHAR2_TABLE;
193: gIRUPoInterfaceHeaderIdTbl DBMS_SQL.NUMBER_TABLE;
194: gIRUPoInterfaceLineIdTbl DBMS_SQL.NUMBER_TABLE;
195: gIRUCreatedLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
196: -- TBD gIRUExtractorUpdatedFlagTbl DBMS_SQL.VARCHAR2_TABLE;
197:
198: --UPDATE icx_cat_r12_upgrade
199: gURURtItemIdTbl DBMS_SQL.NUMBER_TABLE;
192: gIRUPoCategoryIdTbl DBMS_SQL.VARCHAR2_TABLE;
193: gIRUPoInterfaceHeaderIdTbl DBMS_SQL.NUMBER_TABLE;
194: gIRUPoInterfaceLineIdTbl DBMS_SQL.NUMBER_TABLE;
195: gIRUCreatedLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
196: -- TBD gIRUExtractorUpdatedFlagTbl DBMS_SQL.VARCHAR2_TABLE;
197:
198: --UPDATE icx_cat_r12_upgrade
199: gURURtItemIdTbl DBMS_SQL.NUMBER_TABLE;
200: gURUPoCategoryIdTbl DBMS_SQL.NUMBER_TABLE;
195: gIRUCreatedLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
196: -- TBD gIRUExtractorUpdatedFlagTbl DBMS_SQL.VARCHAR2_TABLE;
197:
198: --UPDATE icx_cat_r12_upgrade
199: gURURtItemIdTbl DBMS_SQL.NUMBER_TABLE;
200: gURUPoCategoryIdTbl DBMS_SQL.NUMBER_TABLE;
201: gURUCpaReferenceTbl DBMS_SQL.NUMBER_TABLE;
202: gURUPriceContractIdTbl DBMS_SQL.NUMBER_TABLE;
203: gURUSrcContractIdTbl DBMS_SQL.NUMBER_TABLE;
196: -- TBD gIRUExtractorUpdatedFlagTbl DBMS_SQL.VARCHAR2_TABLE;
197:
198: --UPDATE icx_cat_r12_upgrade
199: gURURtItemIdTbl DBMS_SQL.NUMBER_TABLE;
200: gURUPoCategoryIdTbl DBMS_SQL.NUMBER_TABLE;
201: gURUCpaReferenceTbl DBMS_SQL.NUMBER_TABLE;
202: gURUPriceContractIdTbl DBMS_SQL.NUMBER_TABLE;
203: gURUSrcContractIdTbl DBMS_SQL.NUMBER_TABLE;
204: gURUOldPoInterfaceLineIdTbl DBMS_SQL.NUMBER_TABLE;
197:
198: --UPDATE icx_cat_r12_upgrade
199: gURURtItemIdTbl DBMS_SQL.NUMBER_TABLE;
200: gURUPoCategoryIdTbl DBMS_SQL.NUMBER_TABLE;
201: gURUCpaReferenceTbl DBMS_SQL.NUMBER_TABLE;
202: gURUPriceContractIdTbl DBMS_SQL.NUMBER_TABLE;
203: gURUSrcContractIdTbl DBMS_SQL.NUMBER_TABLE;
204: gURUOldPoInterfaceLineIdTbl DBMS_SQL.NUMBER_TABLE;
205: gURUPoInterfaceHeaderIdTbl DBMS_SQL.NUMBER_TABLE;
198: --UPDATE icx_cat_r12_upgrade
199: gURURtItemIdTbl DBMS_SQL.NUMBER_TABLE;
200: gURUPoCategoryIdTbl DBMS_SQL.NUMBER_TABLE;
201: gURUCpaReferenceTbl DBMS_SQL.NUMBER_TABLE;
202: gURUPriceContractIdTbl DBMS_SQL.NUMBER_TABLE;
203: gURUSrcContractIdTbl DBMS_SQL.NUMBER_TABLE;
204: gURUOldPoInterfaceLineIdTbl DBMS_SQL.NUMBER_TABLE;
205: gURUPoInterfaceHeaderIdTbl DBMS_SQL.NUMBER_TABLE;
206: gURUPoInterfaceLineIdTbl DBMS_SQL.NUMBER_TABLE;
199: gURURtItemIdTbl DBMS_SQL.NUMBER_TABLE;
200: gURUPoCategoryIdTbl DBMS_SQL.NUMBER_TABLE;
201: gURUCpaReferenceTbl DBMS_SQL.NUMBER_TABLE;
202: gURUPriceContractIdTbl DBMS_SQL.NUMBER_TABLE;
203: gURUSrcContractIdTbl DBMS_SQL.NUMBER_TABLE;
204: gURUOldPoInterfaceLineIdTbl DBMS_SQL.NUMBER_TABLE;
205: gURUPoInterfaceHeaderIdTbl DBMS_SQL.NUMBER_TABLE;
206: gURUPoInterfaceLineIdTbl DBMS_SQL.NUMBER_TABLE;
207: gURUPoHeaderIdTbl DBMS_SQL.NUMBER_TABLE;
200: gURUPoCategoryIdTbl DBMS_SQL.NUMBER_TABLE;
201: gURUCpaReferenceTbl DBMS_SQL.NUMBER_TABLE;
202: gURUPriceContractIdTbl DBMS_SQL.NUMBER_TABLE;
203: gURUSrcContractIdTbl DBMS_SQL.NUMBER_TABLE;
204: gURUOldPoInterfaceLineIdTbl DBMS_SQL.NUMBER_TABLE;
205: gURUPoInterfaceHeaderIdTbl DBMS_SQL.NUMBER_TABLE;
206: gURUPoInterfaceLineIdTbl DBMS_SQL.NUMBER_TABLE;
207: gURUPoHeaderIdTbl DBMS_SQL.NUMBER_TABLE;
208: gURUPoLineIdTbl DBMS_SQL.NUMBER_TABLE;
201: gURUCpaReferenceTbl DBMS_SQL.NUMBER_TABLE;
202: gURUPriceContractIdTbl DBMS_SQL.NUMBER_TABLE;
203: gURUSrcContractIdTbl DBMS_SQL.NUMBER_TABLE;
204: gURUOldPoInterfaceLineIdTbl DBMS_SQL.NUMBER_TABLE;
205: gURUPoInterfaceHeaderIdTbl DBMS_SQL.NUMBER_TABLE;
206: gURUPoInterfaceLineIdTbl DBMS_SQL.NUMBER_TABLE;
207: gURUPoHeaderIdTbl DBMS_SQL.NUMBER_TABLE;
208: gURUPoLineIdTbl DBMS_SQL.NUMBER_TABLE;
209: gURUCreatedLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
202: gURUPriceContractIdTbl DBMS_SQL.NUMBER_TABLE;
203: gURUSrcContractIdTbl DBMS_SQL.NUMBER_TABLE;
204: gURUOldPoInterfaceLineIdTbl DBMS_SQL.NUMBER_TABLE;
205: gURUPoInterfaceHeaderIdTbl DBMS_SQL.NUMBER_TABLE;
206: gURUPoInterfaceLineIdTbl DBMS_SQL.NUMBER_TABLE;
207: gURUPoHeaderIdTbl DBMS_SQL.NUMBER_TABLE;
208: gURUPoLineIdTbl DBMS_SQL.NUMBER_TABLE;
209: gURUCreatedLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
210:
203: gURUSrcContractIdTbl DBMS_SQL.NUMBER_TABLE;
204: gURUOldPoInterfaceLineIdTbl DBMS_SQL.NUMBER_TABLE;
205: gURUPoInterfaceHeaderIdTbl DBMS_SQL.NUMBER_TABLE;
206: gURUPoInterfaceLineIdTbl DBMS_SQL.NUMBER_TABLE;
207: gURUPoHeaderIdTbl DBMS_SQL.NUMBER_TABLE;
208: gURUPoLineIdTbl DBMS_SQL.NUMBER_TABLE;
209: gURUCreatedLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
210:
211: --DELETE icx_cat_r12_upgrade
204: gURUOldPoInterfaceLineIdTbl DBMS_SQL.NUMBER_TABLE;
205: gURUPoInterfaceHeaderIdTbl DBMS_SQL.NUMBER_TABLE;
206: gURUPoInterfaceLineIdTbl DBMS_SQL.NUMBER_TABLE;
207: gURUPoHeaderIdTbl DBMS_SQL.NUMBER_TABLE;
208: gURUPoLineIdTbl DBMS_SQL.NUMBER_TABLE;
209: gURUCreatedLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
210:
211: --DELETE icx_cat_r12_upgrade
212: gDRURtItemIdTbl DBMS_SQL.NUMBER_TABLE;
205: gURUPoInterfaceHeaderIdTbl DBMS_SQL.NUMBER_TABLE;
206: gURUPoInterfaceLineIdTbl DBMS_SQL.NUMBER_TABLE;
207: gURUPoHeaderIdTbl DBMS_SQL.NUMBER_TABLE;
208: gURUPoLineIdTbl DBMS_SQL.NUMBER_TABLE;
209: gURUCreatedLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
210:
211: --DELETE icx_cat_r12_upgrade
212: gDRURtItemIdTbl DBMS_SQL.NUMBER_TABLE;
213: gDRUPoInterfaceHeaderIdTbl DBMS_SQL.NUMBER_TABLE;
208: gURUPoLineIdTbl DBMS_SQL.NUMBER_TABLE;
209: gURUCreatedLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
210:
211: --DELETE icx_cat_r12_upgrade
212: gDRURtItemIdTbl DBMS_SQL.NUMBER_TABLE;
213: gDRUPoInterfaceHeaderIdTbl DBMS_SQL.NUMBER_TABLE;
214: gDRUPoInterfaceLineIdTbl DBMS_SQL.NUMBER_TABLE;
215:
216: --INSERT icx_cat_fav_list_lines_tlp for catalog items
209: gURUCreatedLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
210:
211: --DELETE icx_cat_r12_upgrade
212: gDRURtItemIdTbl DBMS_SQL.NUMBER_TABLE;
213: gDRUPoInterfaceHeaderIdTbl DBMS_SQL.NUMBER_TABLE;
214: gDRUPoInterfaceLineIdTbl DBMS_SQL.NUMBER_TABLE;
215:
216: --INSERT icx_cat_fav_list_lines_tlp for catalog items
217: gIFLCFavoriteListIdTbl DBMS_SQL.NUMBER_TABLE;
210:
211: --DELETE icx_cat_r12_upgrade
212: gDRURtItemIdTbl DBMS_SQL.NUMBER_TABLE;
213: gDRUPoInterfaceHeaderIdTbl DBMS_SQL.NUMBER_TABLE;
214: gDRUPoInterfaceLineIdTbl DBMS_SQL.NUMBER_TABLE;
215:
216: --INSERT icx_cat_fav_list_lines_tlp for catalog items
217: gIFLCFavoriteListIdTbl DBMS_SQL.NUMBER_TABLE;
218: gIFLCNewFavoriteListLineIdTbl DBMS_SQL.NUMBER_TABLE;
213: gDRUPoInterfaceHeaderIdTbl DBMS_SQL.NUMBER_TABLE;
214: gDRUPoInterfaceLineIdTbl DBMS_SQL.NUMBER_TABLE;
215:
216: --INSERT icx_cat_fav_list_lines_tlp for catalog items
217: gIFLCFavoriteListIdTbl DBMS_SQL.NUMBER_TABLE;
218: gIFLCNewFavoriteListLineIdTbl DBMS_SQL.NUMBER_TABLE;
219: gIFLCOldFavoriteListLineIdTbl DBMS_SQL.NUMBER_TABLE;
220: gIFLCRtItemIdTbl DBMS_SQL.NUMBER_TABLE;
221: gIFLCSourceTypeTbl DBMS_SQL.VARCHAR2_TABLE;
214: gDRUPoInterfaceLineIdTbl DBMS_SQL.NUMBER_TABLE;
215:
216: --INSERT icx_cat_fav_list_lines_tlp for catalog items
217: gIFLCFavoriteListIdTbl DBMS_SQL.NUMBER_TABLE;
218: gIFLCNewFavoriteListLineIdTbl DBMS_SQL.NUMBER_TABLE;
219: gIFLCOldFavoriteListLineIdTbl DBMS_SQL.NUMBER_TABLE;
220: gIFLCRtItemIdTbl DBMS_SQL.NUMBER_TABLE;
221: gIFLCSourceTypeTbl DBMS_SQL.VARCHAR2_TABLE;
222: gIFLCOrgIdTbl DBMS_SQL.NUMBER_TABLE;
215:
216: --INSERT icx_cat_fav_list_lines_tlp for catalog items
217: gIFLCFavoriteListIdTbl DBMS_SQL.NUMBER_TABLE;
218: gIFLCNewFavoriteListLineIdTbl DBMS_SQL.NUMBER_TABLE;
219: gIFLCOldFavoriteListLineIdTbl DBMS_SQL.NUMBER_TABLE;
220: gIFLCRtItemIdTbl DBMS_SQL.NUMBER_TABLE;
221: gIFLCSourceTypeTbl DBMS_SQL.VARCHAR2_TABLE;
222: gIFLCOrgIdTbl DBMS_SQL.NUMBER_TABLE;
223: gIFLCLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
216: --INSERT icx_cat_fav_list_lines_tlp for catalog items
217: gIFLCFavoriteListIdTbl DBMS_SQL.NUMBER_TABLE;
218: gIFLCNewFavoriteListLineIdTbl DBMS_SQL.NUMBER_TABLE;
219: gIFLCOldFavoriteListLineIdTbl DBMS_SQL.NUMBER_TABLE;
220: gIFLCRtItemIdTbl DBMS_SQL.NUMBER_TABLE;
221: gIFLCSourceTypeTbl DBMS_SQL.VARCHAR2_TABLE;
222: gIFLCOrgIdTbl DBMS_SQL.NUMBER_TABLE;
223: gIFLCLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
224:
217: gIFLCFavoriteListIdTbl DBMS_SQL.NUMBER_TABLE;
218: gIFLCNewFavoriteListLineIdTbl DBMS_SQL.NUMBER_TABLE;
219: gIFLCOldFavoriteListLineIdTbl DBMS_SQL.NUMBER_TABLE;
220: gIFLCRtItemIdTbl DBMS_SQL.NUMBER_TABLE;
221: gIFLCSourceTypeTbl DBMS_SQL.VARCHAR2_TABLE;
222: gIFLCOrgIdTbl DBMS_SQL.NUMBER_TABLE;
223: gIFLCLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
224:
225: --INSERT icx_cat_fav_list_lines_tlp for other items
218: gIFLCNewFavoriteListLineIdTbl DBMS_SQL.NUMBER_TABLE;
219: gIFLCOldFavoriteListLineIdTbl DBMS_SQL.NUMBER_TABLE;
220: gIFLCRtItemIdTbl DBMS_SQL.NUMBER_TABLE;
221: gIFLCSourceTypeTbl DBMS_SQL.VARCHAR2_TABLE;
222: gIFLCOrgIdTbl DBMS_SQL.NUMBER_TABLE;
223: gIFLCLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
224:
225: --INSERT icx_cat_fav_list_lines_tlp for other items
226: gIFLOFavoriteListIdTbl DBMS_SQL.NUMBER_TABLE;
219: gIFLCOldFavoriteListLineIdTbl DBMS_SQL.NUMBER_TABLE;
220: gIFLCRtItemIdTbl DBMS_SQL.NUMBER_TABLE;
221: gIFLCSourceTypeTbl DBMS_SQL.VARCHAR2_TABLE;
222: gIFLCOrgIdTbl DBMS_SQL.NUMBER_TABLE;
223: gIFLCLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
224:
225: --INSERT icx_cat_fav_list_lines_tlp for other items
226: gIFLOFavoriteListIdTbl DBMS_SQL.NUMBER_TABLE;
227: gIFLONewFavoriteListLineIdTbl DBMS_SQL.NUMBER_TABLE;
222: gIFLCOrgIdTbl DBMS_SQL.NUMBER_TABLE;
223: gIFLCLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
224:
225: --INSERT icx_cat_fav_list_lines_tlp for other items
226: gIFLOFavoriteListIdTbl DBMS_SQL.NUMBER_TABLE;
227: gIFLONewFavoriteListLineIdTbl DBMS_SQL.NUMBER_TABLE;
228: gIFLOOldFavoriteListLineIdTbl DBMS_SQL.NUMBER_TABLE;
229: gIFLOOrgIdTbl DBMS_SQL.NUMBER_TABLE;
230: gIFLOLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
223: gIFLCLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
224:
225: --INSERT icx_cat_fav_list_lines_tlp for other items
226: gIFLOFavoriteListIdTbl DBMS_SQL.NUMBER_TABLE;
227: gIFLONewFavoriteListLineIdTbl DBMS_SQL.NUMBER_TABLE;
228: gIFLOOldFavoriteListLineIdTbl DBMS_SQL.NUMBER_TABLE;
229: gIFLOOrgIdTbl DBMS_SQL.NUMBER_TABLE;
230: gIFLOLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
231:
224:
225: --INSERT icx_cat_fav_list_lines_tlp for other items
226: gIFLOFavoriteListIdTbl DBMS_SQL.NUMBER_TABLE;
227: gIFLONewFavoriteListLineIdTbl DBMS_SQL.NUMBER_TABLE;
228: gIFLOOldFavoriteListLineIdTbl DBMS_SQL.NUMBER_TABLE;
229: gIFLOOrgIdTbl DBMS_SQL.NUMBER_TABLE;
230: gIFLOLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
231:
232: PROCEDURE clearTables
225: --INSERT icx_cat_fav_list_lines_tlp for other items
226: gIFLOFavoriteListIdTbl DBMS_SQL.NUMBER_TABLE;
227: gIFLONewFavoriteListLineIdTbl DBMS_SQL.NUMBER_TABLE;
228: gIFLOOldFavoriteListLineIdTbl DBMS_SQL.NUMBER_TABLE;
229: gIFLOOrgIdTbl DBMS_SQL.NUMBER_TABLE;
230: gIFLOLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
231:
232: PROCEDURE clearTables
233: ( p_action_mode IN VARCHAR2
226: gIFLOFavoriteListIdTbl DBMS_SQL.NUMBER_TABLE;
227: gIFLONewFavoriteListLineIdTbl DBMS_SQL.NUMBER_TABLE;
228: gIFLOOldFavoriteListLineIdTbl DBMS_SQL.NUMBER_TABLE;
229: gIFLOOrgIdTbl DBMS_SQL.NUMBER_TABLE;
230: gIFLOLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
231:
232: PROCEDURE clearTables
233: ( p_action_mode IN VARCHAR2
234: )
2162: IS
2163:
2164: ----- Start of declaring columns selected in the cursor -----
2165:
2166: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
2167: l_price_type_tbl DBMS_SQL.VARCHAR2_TABLE;
2168: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
2169: l_rt_item_id_tbl DBMS_SQL.NUMBER_TABLE;
2170: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
2163:
2164: ----- Start of declaring columns selected in the cursor -----
2165:
2166: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
2167: l_price_type_tbl DBMS_SQL.VARCHAR2_TABLE;
2168: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
2169: l_rt_item_id_tbl DBMS_SQL.NUMBER_TABLE;
2170: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
2171: l_interface_header_id_tbl DBMS_SQL.NUMBER_TABLE;
2164: ----- Start of declaring columns selected in the cursor -----
2165:
2166: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
2167: l_price_type_tbl DBMS_SQL.VARCHAR2_TABLE;
2168: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
2169: l_rt_item_id_tbl DBMS_SQL.NUMBER_TABLE;
2170: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
2171: l_interface_header_id_tbl DBMS_SQL.NUMBER_TABLE;
2172: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
2165:
2166: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
2167: l_price_type_tbl DBMS_SQL.VARCHAR2_TABLE;
2168: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
2169: l_rt_item_id_tbl DBMS_SQL.NUMBER_TABLE;
2170: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
2171: l_interface_header_id_tbl DBMS_SQL.NUMBER_TABLE;
2172: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
2173: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
2166: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
2167: l_price_type_tbl DBMS_SQL.VARCHAR2_TABLE;
2168: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
2169: l_rt_item_id_tbl DBMS_SQL.NUMBER_TABLE;
2170: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
2171: l_interface_header_id_tbl DBMS_SQL.NUMBER_TABLE;
2172: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
2173: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
2174: l_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
2167: l_price_type_tbl DBMS_SQL.VARCHAR2_TABLE;
2168: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
2169: l_rt_item_id_tbl DBMS_SQL.NUMBER_TABLE;
2170: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
2171: l_interface_header_id_tbl DBMS_SQL.NUMBER_TABLE;
2172: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
2173: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
2174: l_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
2175: l_catalog_name_tbl DBMS_SQL.VARCHAR2_TABLE;
2168: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
2169: l_rt_item_id_tbl DBMS_SQL.NUMBER_TABLE;
2170: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
2171: l_interface_header_id_tbl DBMS_SQL.NUMBER_TABLE;
2172: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
2173: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
2174: l_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
2175: l_catalog_name_tbl DBMS_SQL.VARCHAR2_TABLE;
2176: l_primary_category_id_tbl DBMS_SQL.NUMBER_TABLE;
2169: l_rt_item_id_tbl DBMS_SQL.NUMBER_TABLE;
2170: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
2171: l_interface_header_id_tbl DBMS_SQL.NUMBER_TABLE;
2172: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
2173: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
2174: l_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
2175: l_catalog_name_tbl DBMS_SQL.VARCHAR2_TABLE;
2176: l_primary_category_id_tbl DBMS_SQL.NUMBER_TABLE;
2177: l_attr_val_tlp_action_tbl DBMS_SQL.VARCHAR2_TABLE;
2170: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
2171: l_interface_header_id_tbl DBMS_SQL.NUMBER_TABLE;
2172: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
2173: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
2174: l_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
2175: l_catalog_name_tbl DBMS_SQL.VARCHAR2_TABLE;
2176: l_primary_category_id_tbl DBMS_SQL.NUMBER_TABLE;
2177: l_attr_val_tlp_action_tbl DBMS_SQL.VARCHAR2_TABLE;
2178:
2171: l_interface_header_id_tbl DBMS_SQL.NUMBER_TABLE;
2172: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
2173: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
2174: l_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
2175: l_catalog_name_tbl DBMS_SQL.VARCHAR2_TABLE;
2176: l_primary_category_id_tbl DBMS_SQL.NUMBER_TABLE;
2177: l_attr_val_tlp_action_tbl DBMS_SQL.VARCHAR2_TABLE;
2178:
2179: ------ End of declaring columns selected in the cursor ------
2172: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
2173: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
2174: l_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
2175: l_catalog_name_tbl DBMS_SQL.VARCHAR2_TABLE;
2176: l_primary_category_id_tbl DBMS_SQL.NUMBER_TABLE;
2177: l_attr_val_tlp_action_tbl DBMS_SQL.VARCHAR2_TABLE;
2178:
2179: ------ End of declaring columns selected in the cursor ------
2180:
2173: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
2174: l_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
2175: l_catalog_name_tbl DBMS_SQL.VARCHAR2_TABLE;
2176: l_primary_category_id_tbl DBMS_SQL.NUMBER_TABLE;
2177: l_attr_val_tlp_action_tbl DBMS_SQL.VARCHAR2_TABLE;
2178:
2179: ------ End of declaring columns selected in the cursor ------
2180:
2181: l_api_name CONSTANT VARCHAR2(30) := 'processBlanketsAndQuotes';
2590: IS
2591:
2592: ----- Start of declaring columns selected in the cursor -----
2593:
2594: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
2595: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
2596: l_rt_item_id_tbl DBMS_SQL.NUMBER_TABLE;
2597: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
2598: l_interface_header_id_tbl DBMS_SQL.NUMBER_TABLE;
2591:
2592: ----- Start of declaring columns selected in the cursor -----
2593:
2594: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
2595: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
2596: l_rt_item_id_tbl DBMS_SQL.NUMBER_TABLE;
2597: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
2598: l_interface_header_id_tbl DBMS_SQL.NUMBER_TABLE;
2599: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
2592: ----- Start of declaring columns selected in the cursor -----
2593:
2594: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
2595: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
2596: l_rt_item_id_tbl DBMS_SQL.NUMBER_TABLE;
2597: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
2598: l_interface_header_id_tbl DBMS_SQL.NUMBER_TABLE;
2599: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
2600: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
2593:
2594: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
2595: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
2596: l_rt_item_id_tbl DBMS_SQL.NUMBER_TABLE;
2597: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
2598: l_interface_header_id_tbl DBMS_SQL.NUMBER_TABLE;
2599: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
2600: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
2601: l_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
2594: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
2595: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
2596: l_rt_item_id_tbl DBMS_SQL.NUMBER_TABLE;
2597: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
2598: l_interface_header_id_tbl DBMS_SQL.NUMBER_TABLE;
2599: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
2600: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
2601: l_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
2602: l_catalog_name_tbl DBMS_SQL.VARCHAR2_TABLE;
2595: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
2596: l_rt_item_id_tbl DBMS_SQL.NUMBER_TABLE;
2597: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
2598: l_interface_header_id_tbl DBMS_SQL.NUMBER_TABLE;
2599: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
2600: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
2601: l_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
2602: l_catalog_name_tbl DBMS_SQL.VARCHAR2_TABLE;
2603: l_primary_category_id_tbl DBMS_SQL.NUMBER_TABLE;
2596: l_rt_item_id_tbl DBMS_SQL.NUMBER_TABLE;
2597: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
2598: l_interface_header_id_tbl DBMS_SQL.NUMBER_TABLE;
2599: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
2600: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
2601: l_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
2602: l_catalog_name_tbl DBMS_SQL.VARCHAR2_TABLE;
2603: l_primary_category_id_tbl DBMS_SQL.NUMBER_TABLE;
2604: l_attr_val_tlp_action_tbl DBMS_SQL.VARCHAR2_TABLE;
2597: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
2598: l_interface_header_id_tbl DBMS_SQL.NUMBER_TABLE;
2599: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
2600: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
2601: l_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
2602: l_catalog_name_tbl DBMS_SQL.VARCHAR2_TABLE;
2603: l_primary_category_id_tbl DBMS_SQL.NUMBER_TABLE;
2604: l_attr_val_tlp_action_tbl DBMS_SQL.VARCHAR2_TABLE;
2605:
2598: l_interface_header_id_tbl DBMS_SQL.NUMBER_TABLE;
2599: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
2600: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
2601: l_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
2602: l_catalog_name_tbl DBMS_SQL.VARCHAR2_TABLE;
2603: l_primary_category_id_tbl DBMS_SQL.NUMBER_TABLE;
2604: l_attr_val_tlp_action_tbl DBMS_SQL.VARCHAR2_TABLE;
2605:
2606: ------ End of declaring columns selected in the cursor ------
2599: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
2600: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
2601: l_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
2602: l_catalog_name_tbl DBMS_SQL.VARCHAR2_TABLE;
2603: l_primary_category_id_tbl DBMS_SQL.NUMBER_TABLE;
2604: l_attr_val_tlp_action_tbl DBMS_SQL.VARCHAR2_TABLE;
2605:
2606: ------ End of declaring columns selected in the cursor ------
2607:
2600: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
2601: l_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
2602: l_catalog_name_tbl DBMS_SQL.VARCHAR2_TABLE;
2603: l_primary_category_id_tbl DBMS_SQL.NUMBER_TABLE;
2604: l_attr_val_tlp_action_tbl DBMS_SQL.VARCHAR2_TABLE;
2605:
2606: ------ End of declaring columns selected in the cursor ------
2607:
2608: l_api_name CONSTANT VARCHAR2(30) := 'processReqTemplates';
3016: IS
3017:
3018: ----- Start of declaring columns selected in the cursor -----
3019:
3020: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
3021: l_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
3022: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
3023: l_currency_tbl DBMS_SQL.VARCHAR2_TABLE;
3024: l_contract_id_tbl DBMS_SQL.NUMBER_TABLE;
3017:
3018: ----- Start of declaring columns selected in the cursor -----
3019:
3020: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
3021: l_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
3022: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
3023: l_currency_tbl DBMS_SQL.VARCHAR2_TABLE;
3024: l_contract_id_tbl DBMS_SQL.NUMBER_TABLE;
3025: l_po_category_id_tbl DBMS_SQL.VARCHAR2_TABLE;
3018: ----- Start of declaring columns selected in the cursor -----
3019:
3020: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
3021: l_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
3022: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
3023: l_currency_tbl DBMS_SQL.VARCHAR2_TABLE;
3024: l_contract_id_tbl DBMS_SQL.NUMBER_TABLE;
3025: l_po_category_id_tbl DBMS_SQL.VARCHAR2_TABLE;
3026:
3019:
3020: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
3021: l_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
3022: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
3023: l_currency_tbl DBMS_SQL.VARCHAR2_TABLE;
3024: l_contract_id_tbl DBMS_SQL.NUMBER_TABLE;
3025: l_po_category_id_tbl DBMS_SQL.VARCHAR2_TABLE;
3026:
3027: ------ End of declaring columns selected in the cursor ------
3020: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
3021: l_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
3022: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
3023: l_currency_tbl DBMS_SQL.VARCHAR2_TABLE;
3024: l_contract_id_tbl DBMS_SQL.NUMBER_TABLE;
3025: l_po_category_id_tbl DBMS_SQL.VARCHAR2_TABLE;
3026:
3027: ------ End of declaring columns selected in the cursor ------
3028:
3021: l_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
3022: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
3023: l_currency_tbl DBMS_SQL.VARCHAR2_TABLE;
3024: l_contract_id_tbl DBMS_SQL.NUMBER_TABLE;
3025: l_po_category_id_tbl DBMS_SQL.VARCHAR2_TABLE;
3026:
3027: ------ End of declaring columns selected in the cursor ------
3028:
3029: l_api_name CONSTANT VARCHAR2(30) := 'contractAutoSourcing';
3043: l_purchasing_uom PO_LINES_ALL.unit_meas_lookup_code%TYPE := '';
3044: l_icx_schema_name VARCHAR2(30) := NULL;
3045:
3046: l_as_index PLS_INTEGER := 0;
3047: l_as_org_id_tbl DBMS_SQL.NUMBER_TABLE;
3048: l_as_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
3049: l_as_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
3050: l_as_currency_tbl DBMS_SQL.VARCHAR2_TABLE;
3051: l_as_contract_id_tbl DBMS_SQL.NUMBER_TABLE;
3044: l_icx_schema_name VARCHAR2(30) := NULL;
3045:
3046: l_as_index PLS_INTEGER := 0;
3047: l_as_org_id_tbl DBMS_SQL.NUMBER_TABLE;
3048: l_as_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
3049: l_as_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
3050: l_as_currency_tbl DBMS_SQL.VARCHAR2_TABLE;
3051: l_as_contract_id_tbl DBMS_SQL.NUMBER_TABLE;
3052: l_as_po_category_id_tbl DBMS_SQL.VARCHAR2_TABLE;
3045:
3046: l_as_index PLS_INTEGER := 0;
3047: l_as_org_id_tbl DBMS_SQL.NUMBER_TABLE;
3048: l_as_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
3049: l_as_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
3050: l_as_currency_tbl DBMS_SQL.VARCHAR2_TABLE;
3051: l_as_contract_id_tbl DBMS_SQL.NUMBER_TABLE;
3052: l_as_po_category_id_tbl DBMS_SQL.VARCHAR2_TABLE;
3053: l_contractAutoSourcing_csr g_csr_type;
3046: l_as_index PLS_INTEGER := 0;
3047: l_as_org_id_tbl DBMS_SQL.NUMBER_TABLE;
3048: l_as_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
3049: l_as_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
3050: l_as_currency_tbl DBMS_SQL.VARCHAR2_TABLE;
3051: l_as_contract_id_tbl DBMS_SQL.NUMBER_TABLE;
3052: l_as_po_category_id_tbl DBMS_SQL.VARCHAR2_TABLE;
3053: l_contractAutoSourcing_csr g_csr_type;
3054: l_start_date DATE;
3047: l_as_org_id_tbl DBMS_SQL.NUMBER_TABLE;
3048: l_as_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
3049: l_as_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
3050: l_as_currency_tbl DBMS_SQL.VARCHAR2_TABLE;
3051: l_as_contract_id_tbl DBMS_SQL.NUMBER_TABLE;
3052: l_as_po_category_id_tbl DBMS_SQL.VARCHAR2_TABLE;
3053: l_contractAutoSourcing_csr g_csr_type;
3054: l_start_date DATE;
3055: l_end_date DATE;
3048: l_as_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
3049: l_as_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
3050: l_as_currency_tbl DBMS_SQL.VARCHAR2_TABLE;
3051: l_as_contract_id_tbl DBMS_SQL.NUMBER_TABLE;
3052: l_as_po_category_id_tbl DBMS_SQL.VARCHAR2_TABLE;
3053: l_contractAutoSourcing_csr g_csr_type;
3054: l_start_date DATE;
3055: l_end_date DATE;
3056: l_log_string VARCHAR2(2000);
3333: ORDER BY 1;
3334:
3335: ----- Start of declaring columns selected in the cursor -----
3336:
3337: l_rt_item_id_tbl DBMS_SQL.NUMBER_TABLE;
3338: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
3339: l_unit_of_measure_tbl DBMS_SQL.VARCHAR2_TABLE;
3340: l_neg_by_prep_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
3341: l_primary_category_id_tbl DBMS_SQL.NUMBER_TABLE;
3334:
3335: ----- Start of declaring columns selected in the cursor -----
3336:
3337: l_rt_item_id_tbl DBMS_SQL.NUMBER_TABLE;
3338: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
3339: l_unit_of_measure_tbl DBMS_SQL.VARCHAR2_TABLE;
3340: l_neg_by_prep_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
3341: l_primary_category_id_tbl DBMS_SQL.NUMBER_TABLE;
3342: l_po_category_id_tbl DBMS_SQL.VARCHAR2_TABLE;
3335: ----- Start of declaring columns selected in the cursor -----
3336:
3337: l_rt_item_id_tbl DBMS_SQL.NUMBER_TABLE;
3338: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
3339: l_unit_of_measure_tbl DBMS_SQL.VARCHAR2_TABLE;
3340: l_neg_by_prep_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
3341: l_primary_category_id_tbl DBMS_SQL.NUMBER_TABLE;
3342: l_po_category_id_tbl DBMS_SQL.VARCHAR2_TABLE;
3343: l_supp_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
3336:
3337: l_rt_item_id_tbl DBMS_SQL.NUMBER_TABLE;
3338: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
3339: l_unit_of_measure_tbl DBMS_SQL.VARCHAR2_TABLE;
3340: l_neg_by_prep_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
3341: l_primary_category_id_tbl DBMS_SQL.NUMBER_TABLE;
3342: l_po_category_id_tbl DBMS_SQL.VARCHAR2_TABLE;
3343: l_supp_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
3344: l_supp_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
3337: l_rt_item_id_tbl DBMS_SQL.NUMBER_TABLE;
3338: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
3339: l_unit_of_measure_tbl DBMS_SQL.VARCHAR2_TABLE;
3340: l_neg_by_prep_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
3341: l_primary_category_id_tbl DBMS_SQL.NUMBER_TABLE;
3342: l_po_category_id_tbl DBMS_SQL.VARCHAR2_TABLE;
3343: l_supp_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
3344: l_supp_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
3345: l_description_tbl DBMS_SQL.VARCHAR2_TABLE;
3338: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
3339: l_unit_of_measure_tbl DBMS_SQL.VARCHAR2_TABLE;
3340: l_neg_by_prep_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
3341: l_primary_category_id_tbl DBMS_SQL.NUMBER_TABLE;
3342: l_po_category_id_tbl DBMS_SQL.VARCHAR2_TABLE;
3343: l_supp_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
3344: l_supp_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
3345: l_description_tbl DBMS_SQL.VARCHAR2_TABLE;
3346: l_catalog_name_tbl DBMS_SQL.VARCHAR2_TABLE;
3339: l_unit_of_measure_tbl DBMS_SQL.VARCHAR2_TABLE;
3340: l_neg_by_prep_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
3341: l_primary_category_id_tbl DBMS_SQL.NUMBER_TABLE;
3342: l_po_category_id_tbl DBMS_SQL.VARCHAR2_TABLE;
3343: l_supp_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
3344: l_supp_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
3345: l_description_tbl DBMS_SQL.VARCHAR2_TABLE;
3346: l_catalog_name_tbl DBMS_SQL.VARCHAR2_TABLE;
3347: l_po_interface_header_id_tbl DBMS_SQL.NUMBER_TABLE;
3340: l_neg_by_prep_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
3341: l_primary_category_id_tbl DBMS_SQL.NUMBER_TABLE;
3342: l_po_category_id_tbl DBMS_SQL.VARCHAR2_TABLE;
3343: l_supp_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
3344: l_supp_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
3345: l_description_tbl DBMS_SQL.VARCHAR2_TABLE;
3346: l_catalog_name_tbl DBMS_SQL.VARCHAR2_TABLE;
3347: l_po_interface_header_id_tbl DBMS_SQL.NUMBER_TABLE;
3348: l_upg_created_language_tbl DBMS_SQL.VARCHAR2_TABLE;
3341: l_primary_category_id_tbl DBMS_SQL.NUMBER_TABLE;
3342: l_po_category_id_tbl DBMS_SQL.VARCHAR2_TABLE;
3343: l_supp_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
3344: l_supp_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
3345: l_description_tbl DBMS_SQL.VARCHAR2_TABLE;
3346: l_catalog_name_tbl DBMS_SQL.VARCHAR2_TABLE;
3347: l_po_interface_header_id_tbl DBMS_SQL.NUMBER_TABLE;
3348: l_upg_created_language_tbl DBMS_SQL.VARCHAR2_TABLE;
3349: l_po_interface_line_id_tbl DBMS_SQL.NUMBER_TABLE;
3342: l_po_category_id_tbl DBMS_SQL.VARCHAR2_TABLE;
3343: l_supp_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
3344: l_supp_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
3345: l_description_tbl DBMS_SQL.VARCHAR2_TABLE;
3346: l_catalog_name_tbl DBMS_SQL.VARCHAR2_TABLE;
3347: l_po_interface_header_id_tbl DBMS_SQL.NUMBER_TABLE;
3348: l_upg_created_language_tbl DBMS_SQL.VARCHAR2_TABLE;
3349: l_po_interface_line_id_tbl DBMS_SQL.NUMBER_TABLE;
3350: l_price_type_tbl DBMS_SQL.VARCHAR2_TABLE;
3343: l_supp_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
3344: l_supp_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
3345: l_description_tbl DBMS_SQL.VARCHAR2_TABLE;
3346: l_catalog_name_tbl DBMS_SQL.VARCHAR2_TABLE;
3347: l_po_interface_header_id_tbl DBMS_SQL.NUMBER_TABLE;
3348: l_upg_created_language_tbl DBMS_SQL.VARCHAR2_TABLE;
3349: l_po_interface_line_id_tbl DBMS_SQL.NUMBER_TABLE;
3350: l_price_type_tbl DBMS_SQL.VARCHAR2_TABLE;
3351: l_primary_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
3344: l_supp_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
3345: l_description_tbl DBMS_SQL.VARCHAR2_TABLE;
3346: l_catalog_name_tbl DBMS_SQL.VARCHAR2_TABLE;
3347: l_po_interface_header_id_tbl DBMS_SQL.NUMBER_TABLE;
3348: l_upg_created_language_tbl DBMS_SQL.VARCHAR2_TABLE;
3349: l_po_interface_line_id_tbl DBMS_SQL.NUMBER_TABLE;
3350: l_price_type_tbl DBMS_SQL.VARCHAR2_TABLE;
3351: l_primary_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
3352:
3345: l_description_tbl DBMS_SQL.VARCHAR2_TABLE;
3346: l_catalog_name_tbl DBMS_SQL.VARCHAR2_TABLE;
3347: l_po_interface_header_id_tbl DBMS_SQL.NUMBER_TABLE;
3348: l_upg_created_language_tbl DBMS_SQL.VARCHAR2_TABLE;
3349: l_po_interface_line_id_tbl DBMS_SQL.NUMBER_TABLE;
3350: l_price_type_tbl DBMS_SQL.VARCHAR2_TABLE;
3351: l_primary_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
3352:
3353: ------ End of declaring columns selected in the cursor ------
3346: l_catalog_name_tbl DBMS_SQL.VARCHAR2_TABLE;
3347: l_po_interface_header_id_tbl DBMS_SQL.NUMBER_TABLE;
3348: l_upg_created_language_tbl DBMS_SQL.VARCHAR2_TABLE;
3349: l_po_interface_line_id_tbl DBMS_SQL.NUMBER_TABLE;
3350: l_price_type_tbl DBMS_SQL.VARCHAR2_TABLE;
3351: l_primary_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
3352:
3353: ------ End of declaring columns selected in the cursor ------
3354:
3347: l_po_interface_header_id_tbl DBMS_SQL.NUMBER_TABLE;
3348: l_upg_created_language_tbl DBMS_SQL.VARCHAR2_TABLE;
3349: l_po_interface_line_id_tbl DBMS_SQL.NUMBER_TABLE;
3350: l_price_type_tbl DBMS_SQL.VARCHAR2_TABLE;
3351: l_primary_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
3352:
3353: ------ End of declaring columns selected in the cursor ------
3354:
3355: l_api_name CONSTANT VARCHAR2(30) := 'checkAndProcessGBPALines';
3779: ORDER BY 1;
3780:
3781: ----- Start of declaring columns selected in the cursor -----
3782:
3783: l_rt_item_id_tbl DBMS_SQL.NUMBER_TABLE;
3784: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
3785: l_unit_of_measure_tbl DBMS_SQL.VARCHAR2_TABLE;
3786: l_neg_by_prep_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
3787: l_primary_category_id_tbl DBMS_SQL.NUMBER_TABLE;
3780:
3781: ----- Start of declaring columns selected in the cursor -----
3782:
3783: l_rt_item_id_tbl DBMS_SQL.NUMBER_TABLE;
3784: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
3785: l_unit_of_measure_tbl DBMS_SQL.VARCHAR2_TABLE;
3786: l_neg_by_prep_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
3787: l_primary_category_id_tbl DBMS_SQL.NUMBER_TABLE;
3788: l_po_category_id_tbl DBMS_SQL.VARCHAR2_TABLE;
3781: ----- Start of declaring columns selected in the cursor -----
3782:
3783: l_rt_item_id_tbl DBMS_SQL.NUMBER_TABLE;
3784: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
3785: l_unit_of_measure_tbl DBMS_SQL.VARCHAR2_TABLE;
3786: l_neg_by_prep_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
3787: l_primary_category_id_tbl DBMS_SQL.NUMBER_TABLE;
3788: l_po_category_id_tbl DBMS_SQL.VARCHAR2_TABLE;
3789: l_supp_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
3782:
3783: l_rt_item_id_tbl DBMS_SQL.NUMBER_TABLE;
3784: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
3785: l_unit_of_measure_tbl DBMS_SQL.VARCHAR2_TABLE;
3786: l_neg_by_prep_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
3787: l_primary_category_id_tbl DBMS_SQL.NUMBER_TABLE;
3788: l_po_category_id_tbl DBMS_SQL.VARCHAR2_TABLE;
3789: l_supp_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
3790: l_supp_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
3783: l_rt_item_id_tbl DBMS_SQL.NUMBER_TABLE;
3784: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
3785: l_unit_of_measure_tbl DBMS_SQL.VARCHAR2_TABLE;
3786: l_neg_by_prep_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
3787: l_primary_category_id_tbl DBMS_SQL.NUMBER_TABLE;
3788: l_po_category_id_tbl DBMS_SQL.VARCHAR2_TABLE;
3789: l_supp_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
3790: l_supp_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
3791: l_description_tbl DBMS_SQL.VARCHAR2_TABLE;
3784: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
3785: l_unit_of_measure_tbl DBMS_SQL.VARCHAR2_TABLE;
3786: l_neg_by_prep_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
3787: l_primary_category_id_tbl DBMS_SQL.NUMBER_TABLE;
3788: l_po_category_id_tbl DBMS_SQL.VARCHAR2_TABLE;
3789: l_supp_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
3790: l_supp_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
3791: l_description_tbl DBMS_SQL.VARCHAR2_TABLE;
3792: l_catalog_name_tbl DBMS_SQL.VARCHAR2_TABLE;
3785: l_unit_of_measure_tbl DBMS_SQL.VARCHAR2_TABLE;
3786: l_neg_by_prep_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
3787: l_primary_category_id_tbl DBMS_SQL.NUMBER_TABLE;
3788: l_po_category_id_tbl DBMS_SQL.VARCHAR2_TABLE;
3789: l_supp_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
3790: l_supp_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
3791: l_description_tbl DBMS_SQL.VARCHAR2_TABLE;
3792: l_catalog_name_tbl DBMS_SQL.VARCHAR2_TABLE;
3793: l_price_type_tbl DBMS_SQL.VARCHAR2_TABLE;
3786: l_neg_by_prep_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
3787: l_primary_category_id_tbl DBMS_SQL.NUMBER_TABLE;
3788: l_po_category_id_tbl DBMS_SQL.VARCHAR2_TABLE;
3789: l_supp_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
3790: l_supp_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
3791: l_description_tbl DBMS_SQL.VARCHAR2_TABLE;
3792: l_catalog_name_tbl DBMS_SQL.VARCHAR2_TABLE;
3793: l_price_type_tbl DBMS_SQL.VARCHAR2_TABLE;
3794: l_primary_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
3787: l_primary_category_id_tbl DBMS_SQL.NUMBER_TABLE;
3788: l_po_category_id_tbl DBMS_SQL.VARCHAR2_TABLE;
3789: l_supp_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
3790: l_supp_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
3791: l_description_tbl DBMS_SQL.VARCHAR2_TABLE;
3792: l_catalog_name_tbl DBMS_SQL.VARCHAR2_TABLE;
3793: l_price_type_tbl DBMS_SQL.VARCHAR2_TABLE;
3794: l_primary_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
3795:
3788: l_po_category_id_tbl DBMS_SQL.VARCHAR2_TABLE;
3789: l_supp_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
3790: l_supp_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
3791: l_description_tbl DBMS_SQL.VARCHAR2_TABLE;
3792: l_catalog_name_tbl DBMS_SQL.VARCHAR2_TABLE;
3793: l_price_type_tbl DBMS_SQL.VARCHAR2_TABLE;
3794: l_primary_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
3795:
3796: ------ End of declaring columns selected in the cursor ------
3789: l_supp_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
3790: l_supp_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
3791: l_description_tbl DBMS_SQL.VARCHAR2_TABLE;
3792: l_catalog_name_tbl DBMS_SQL.VARCHAR2_TABLE;
3793: l_price_type_tbl DBMS_SQL.VARCHAR2_TABLE;
3794: l_primary_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
3795:
3796: ------ End of declaring columns selected in the cursor ------
3797:
3790: l_supp_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
3791: l_description_tbl DBMS_SQL.VARCHAR2_TABLE;
3792: l_catalog_name_tbl DBMS_SQL.VARCHAR2_TABLE;
3793: l_price_type_tbl DBMS_SQL.VARCHAR2_TABLE;
3794: l_primary_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
3795:
3796: ------ End of declaring columns selected in the cursor ------
3797:
3798: l_api_name CONSTANT VARCHAR2(30) := 'processGBPALines';
4140: doc.currency, doc.gbpa_cpa_reference,
4141: count DESC, doc.language;
4142:
4143: ----- Start of declaring columns selected in the cursor -----
4144: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
4145: l_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
4146: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
4147: l_currency_tbl DBMS_SQL.VARCHAR2_TABLE;
4148: l_gbpa_cpa_reference_tbl DBMS_SQL.NUMBER_TABLE;
4141: count DESC, doc.language;
4142:
4143: ----- Start of declaring columns selected in the cursor -----
4144: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
4145: l_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
4146: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
4147: l_currency_tbl DBMS_SQL.VARCHAR2_TABLE;
4148: l_gbpa_cpa_reference_tbl DBMS_SQL.NUMBER_TABLE;
4149: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
4142:
4143: ----- Start of declaring columns selected in the cursor -----
4144: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
4145: l_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
4146: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
4147: l_currency_tbl DBMS_SQL.VARCHAR2_TABLE;
4148: l_gbpa_cpa_reference_tbl DBMS_SQL.NUMBER_TABLE;
4149: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
4150: l_count_tbl DBMS_SQL.NUMBER_TABLE;
4143: ----- Start of declaring columns selected in the cursor -----
4144: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
4145: l_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
4146: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
4147: l_currency_tbl DBMS_SQL.VARCHAR2_TABLE;
4148: l_gbpa_cpa_reference_tbl DBMS_SQL.NUMBER_TABLE;
4149: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
4150: l_count_tbl DBMS_SQL.NUMBER_TABLE;
4151:
4144: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
4145: l_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
4146: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
4147: l_currency_tbl DBMS_SQL.VARCHAR2_TABLE;
4148: l_gbpa_cpa_reference_tbl DBMS_SQL.NUMBER_TABLE;
4149: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
4150: l_count_tbl DBMS_SQL.NUMBER_TABLE;
4151:
4152: ------ End of declaring columns selected in the cursor ------
4145: l_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
4146: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
4147: l_currency_tbl DBMS_SQL.VARCHAR2_TABLE;
4148: l_gbpa_cpa_reference_tbl DBMS_SQL.NUMBER_TABLE;
4149: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
4150: l_count_tbl DBMS_SQL.NUMBER_TABLE;
4151:
4152: ------ End of declaring columns selected in the cursor ------
4153:
4146: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
4147: l_currency_tbl DBMS_SQL.VARCHAR2_TABLE;
4148: l_gbpa_cpa_reference_tbl DBMS_SQL.NUMBER_TABLE;
4149: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
4150: l_count_tbl DBMS_SQL.NUMBER_TABLE;
4151:
4152: ------ End of declaring columns selected in the cursor ------
4153:
4154: l_api_name CONSTANT VARCHAR2(30) := 'createGBPAsForBlkldItems';
4461: ORDER BY 1;
4462:
4463: ----- Start of declaring columns selected in the cursor -----
4464:
4465: l_rt_item_id_tbl DBMS_SQL.NUMBER_TABLE;
4466: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
4467: l_unit_of_measure_tbl DBMS_SQL.VARCHAR2_TABLE;
4468: l_neg_by_prep_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
4469: l_primary_category_id_tbl DBMS_SQL.NUMBER_TABLE;
4462:
4463: ----- Start of declaring columns selected in the cursor -----
4464:
4465: l_rt_item_id_tbl DBMS_SQL.NUMBER_TABLE;
4466: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
4467: l_unit_of_measure_tbl DBMS_SQL.VARCHAR2_TABLE;
4468: l_neg_by_prep_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
4469: l_primary_category_id_tbl DBMS_SQL.NUMBER_TABLE;
4470: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
4463: ----- Start of declaring columns selected in the cursor -----
4464:
4465: l_rt_item_id_tbl DBMS_SQL.NUMBER_TABLE;
4466: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
4467: l_unit_of_measure_tbl DBMS_SQL.VARCHAR2_TABLE;
4468: l_neg_by_prep_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
4469: l_primary_category_id_tbl DBMS_SQL.NUMBER_TABLE;
4470: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
4471: l_supp_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
4464:
4465: l_rt_item_id_tbl DBMS_SQL.NUMBER_TABLE;
4466: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
4467: l_unit_of_measure_tbl DBMS_SQL.VARCHAR2_TABLE;
4468: l_neg_by_prep_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
4469: l_primary_category_id_tbl DBMS_SQL.NUMBER_TABLE;
4470: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
4471: l_supp_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
4472: l_supp_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
4465: l_rt_item_id_tbl DBMS_SQL.NUMBER_TABLE;
4466: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
4467: l_unit_of_measure_tbl DBMS_SQL.VARCHAR2_TABLE;
4468: l_neg_by_prep_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
4469: l_primary_category_id_tbl DBMS_SQL.NUMBER_TABLE;
4470: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
4471: l_supp_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
4472: l_supp_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
4473: l_description_tbl DBMS_SQL.VARCHAR2_TABLE;
4466: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
4467: l_unit_of_measure_tbl DBMS_SQL.VARCHAR2_TABLE;
4468: l_neg_by_prep_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
4469: l_primary_category_id_tbl DBMS_SQL.NUMBER_TABLE;
4470: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
4471: l_supp_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
4472: l_supp_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
4473: l_description_tbl DBMS_SQL.VARCHAR2_TABLE;
4474: l_catalog_name_tbl DBMS_SQL.VARCHAR2_TABLE;
4467: l_unit_of_measure_tbl DBMS_SQL.VARCHAR2_TABLE;
4468: l_neg_by_prep_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
4469: l_primary_category_id_tbl DBMS_SQL.NUMBER_TABLE;
4470: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
4471: l_supp_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
4472: l_supp_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
4473: l_description_tbl DBMS_SQL.VARCHAR2_TABLE;
4474: l_catalog_name_tbl DBMS_SQL.VARCHAR2_TABLE;
4475: l_po_interface_header_id_tbl DBMS_SQL.NUMBER_TABLE;
4468: l_neg_by_prep_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
4469: l_primary_category_id_tbl DBMS_SQL.NUMBER_TABLE;
4470: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
4471: l_supp_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
4472: l_supp_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
4473: l_description_tbl DBMS_SQL.VARCHAR2_TABLE;
4474: l_catalog_name_tbl DBMS_SQL.VARCHAR2_TABLE;
4475: l_po_interface_header_id_tbl DBMS_SQL.NUMBER_TABLE;
4476: l_po_interface_line_id_tbl DBMS_SQL.NUMBER_TABLE;
4469: l_primary_category_id_tbl DBMS_SQL.NUMBER_TABLE;
4470: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
4471: l_supp_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
4472: l_supp_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
4473: l_description_tbl DBMS_SQL.VARCHAR2_TABLE;
4474: l_catalog_name_tbl DBMS_SQL.VARCHAR2_TABLE;
4475: l_po_interface_header_id_tbl DBMS_SQL.NUMBER_TABLE;
4476: l_po_interface_line_id_tbl DBMS_SQL.NUMBER_TABLE;
4477: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
4470: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
4471: l_supp_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
4472: l_supp_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
4473: l_description_tbl DBMS_SQL.VARCHAR2_TABLE;
4474: l_catalog_name_tbl DBMS_SQL.VARCHAR2_TABLE;
4475: l_po_interface_header_id_tbl DBMS_SQL.NUMBER_TABLE;
4476: l_po_interface_line_id_tbl DBMS_SQL.NUMBER_TABLE;
4477: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
4478: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
4471: l_supp_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
4472: l_supp_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
4473: l_description_tbl DBMS_SQL.VARCHAR2_TABLE;
4474: l_catalog_name_tbl DBMS_SQL.VARCHAR2_TABLE;
4475: l_po_interface_header_id_tbl DBMS_SQL.NUMBER_TABLE;
4476: l_po_interface_line_id_tbl DBMS_SQL.NUMBER_TABLE;
4477: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
4478: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
4479: l_created_language_tbl DBMS_SQL.VARCHAR2_TABLE;
4472: l_supp_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
4473: l_description_tbl DBMS_SQL.VARCHAR2_TABLE;
4474: l_catalog_name_tbl DBMS_SQL.VARCHAR2_TABLE;
4475: l_po_interface_header_id_tbl DBMS_SQL.NUMBER_TABLE;
4476: l_po_interface_line_id_tbl DBMS_SQL.NUMBER_TABLE;
4477: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
4478: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
4479: l_created_language_tbl DBMS_SQL.VARCHAR2_TABLE;
4480: l_old_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
4473: l_description_tbl DBMS_SQL.VARCHAR2_TABLE;
4474: l_catalog_name_tbl DBMS_SQL.VARCHAR2_TABLE;
4475: l_po_interface_header_id_tbl DBMS_SQL.NUMBER_TABLE;
4476: l_po_interface_line_id_tbl DBMS_SQL.NUMBER_TABLE;
4477: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
4478: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
4479: l_created_language_tbl DBMS_SQL.VARCHAR2_TABLE;
4480: l_old_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
4481: l_attr_val_tlp_action_tbl DBMS_SQL.VARCHAR2_TABLE;
4474: l_catalog_name_tbl DBMS_SQL.VARCHAR2_TABLE;
4475: l_po_interface_header_id_tbl DBMS_SQL.NUMBER_TABLE;
4476: l_po_interface_line_id_tbl DBMS_SQL.NUMBER_TABLE;
4477: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
4478: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
4479: l_created_language_tbl DBMS_SQL.VARCHAR2_TABLE;
4480: l_old_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
4481: l_attr_val_tlp_action_tbl DBMS_SQL.VARCHAR2_TABLE;
4482: l_price_type_tbl DBMS_SQL.VARCHAR2_TABLE;
4475: l_po_interface_header_id_tbl DBMS_SQL.NUMBER_TABLE;
4476: l_po_interface_line_id_tbl DBMS_SQL.NUMBER_TABLE;
4477: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
4478: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
4479: l_created_language_tbl DBMS_SQL.VARCHAR2_TABLE;
4480: l_old_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
4481: l_attr_val_tlp_action_tbl DBMS_SQL.VARCHAR2_TABLE;
4482: l_price_type_tbl DBMS_SQL.VARCHAR2_TABLE;
4483: l_primary_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
4476: l_po_interface_line_id_tbl DBMS_SQL.NUMBER_TABLE;
4477: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
4478: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
4479: l_created_language_tbl DBMS_SQL.VARCHAR2_TABLE;
4480: l_old_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
4481: l_attr_val_tlp_action_tbl DBMS_SQL.VARCHAR2_TABLE;
4482: l_price_type_tbl DBMS_SQL.VARCHAR2_TABLE;
4483: l_primary_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
4484:
4477: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
4478: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
4479: l_created_language_tbl DBMS_SQL.VARCHAR2_TABLE;
4480: l_old_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
4481: l_attr_val_tlp_action_tbl DBMS_SQL.VARCHAR2_TABLE;
4482: l_price_type_tbl DBMS_SQL.VARCHAR2_TABLE;
4483: l_primary_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
4484:
4485: ------ End of declaring columns selected in the cursor ------
4478: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
4479: l_created_language_tbl DBMS_SQL.VARCHAR2_TABLE;
4480: l_old_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
4481: l_attr_val_tlp_action_tbl DBMS_SQL.VARCHAR2_TABLE;
4482: l_price_type_tbl DBMS_SQL.VARCHAR2_TABLE;
4483: l_primary_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
4484:
4485: ------ End of declaring columns selected in the cursor ------
4486:
4479: l_created_language_tbl DBMS_SQL.VARCHAR2_TABLE;
4480: l_old_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
4481: l_attr_val_tlp_action_tbl DBMS_SQL.VARCHAR2_TABLE;
4482: l_price_type_tbl DBMS_SQL.VARCHAR2_TABLE;
4483: l_primary_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
4484:
4485: ------ End of declaring columns selected in the cursor ------
4486:
4487: l_api_name CONSTANT VARCHAR2(30) := 'processGBPALinesForDelta';
5241: doc.po_interface_header_id, count DESC, doc.language;
5242:
5243: ----- Start of declaring columns selected in the cursor -----
5244:
5245: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
5246: l_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
5247: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
5248: l_currency_tbl DBMS_SQL.VARCHAR2_TABLE;
5249: l_gbpa_cpa_reference_tbl DBMS_SQL.NUMBER_TABLE;
5242:
5243: ----- Start of declaring columns selected in the cursor -----
5244:
5245: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
5246: l_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
5247: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
5248: l_currency_tbl DBMS_SQL.VARCHAR2_TABLE;
5249: l_gbpa_cpa_reference_tbl DBMS_SQL.NUMBER_TABLE;
5250: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
5243: ----- Start of declaring columns selected in the cursor -----
5244:
5245: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
5246: l_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
5247: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
5248: l_currency_tbl DBMS_SQL.VARCHAR2_TABLE;
5249: l_gbpa_cpa_reference_tbl DBMS_SQL.NUMBER_TABLE;
5250: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
5251: l_po_interface_header_id_tbl DBMS_SQL.NUMBER_TABLE;
5244:
5245: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
5246: l_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
5247: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
5248: l_currency_tbl DBMS_SQL.VARCHAR2_TABLE;
5249: l_gbpa_cpa_reference_tbl DBMS_SQL.NUMBER_TABLE;
5250: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
5251: l_po_interface_header_id_tbl DBMS_SQL.NUMBER_TABLE;
5252: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
5245: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
5246: l_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
5247: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
5248: l_currency_tbl DBMS_SQL.VARCHAR2_TABLE;
5249: l_gbpa_cpa_reference_tbl DBMS_SQL.NUMBER_TABLE;
5250: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
5251: l_po_interface_header_id_tbl DBMS_SQL.NUMBER_TABLE;
5252: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
5253: l_upg_created_language_tbl DBMS_SQL.VARCHAR2_TABLE;
5246: l_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
5247: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
5248: l_currency_tbl DBMS_SQL.VARCHAR2_TABLE;
5249: l_gbpa_cpa_reference_tbl DBMS_SQL.NUMBER_TABLE;
5250: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
5251: l_po_interface_header_id_tbl DBMS_SQL.NUMBER_TABLE;
5252: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
5253: l_upg_created_language_tbl DBMS_SQL.VARCHAR2_TABLE;
5254: l_upg_cpa_reference_tbl DBMS_SQL.NUMBER_TABLE;
5247: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
5248: l_currency_tbl DBMS_SQL.VARCHAR2_TABLE;
5249: l_gbpa_cpa_reference_tbl DBMS_SQL.NUMBER_TABLE;
5250: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
5251: l_po_interface_header_id_tbl DBMS_SQL.NUMBER_TABLE;
5252: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
5253: l_upg_created_language_tbl DBMS_SQL.VARCHAR2_TABLE;
5254: l_upg_cpa_reference_tbl DBMS_SQL.NUMBER_TABLE;
5255: l_count_tbl DBMS_SQL.NUMBER_TABLE;
5248: l_currency_tbl DBMS_SQL.VARCHAR2_TABLE;
5249: l_gbpa_cpa_reference_tbl DBMS_SQL.NUMBER_TABLE;
5250: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
5251: l_po_interface_header_id_tbl DBMS_SQL.NUMBER_TABLE;
5252: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
5253: l_upg_created_language_tbl DBMS_SQL.VARCHAR2_TABLE;
5254: l_upg_cpa_reference_tbl DBMS_SQL.NUMBER_TABLE;
5255: l_count_tbl DBMS_SQL.NUMBER_TABLE;
5256:
5249: l_gbpa_cpa_reference_tbl DBMS_SQL.NUMBER_TABLE;
5250: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
5251: l_po_interface_header_id_tbl DBMS_SQL.NUMBER_TABLE;
5252: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
5253: l_upg_created_language_tbl DBMS_SQL.VARCHAR2_TABLE;
5254: l_upg_cpa_reference_tbl DBMS_SQL.NUMBER_TABLE;
5255: l_count_tbl DBMS_SQL.NUMBER_TABLE;
5256:
5257: ------ End of declaring columns selected in the cursor ------
5250: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
5251: l_po_interface_header_id_tbl DBMS_SQL.NUMBER_TABLE;
5252: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
5253: l_upg_created_language_tbl DBMS_SQL.VARCHAR2_TABLE;
5254: l_upg_cpa_reference_tbl DBMS_SQL.NUMBER_TABLE;
5255: l_count_tbl DBMS_SQL.NUMBER_TABLE;
5256:
5257: ------ End of declaring columns selected in the cursor ------
5258:
5251: l_po_interface_header_id_tbl DBMS_SQL.NUMBER_TABLE;
5252: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
5253: l_upg_created_language_tbl DBMS_SQL.VARCHAR2_TABLE;
5254: l_upg_cpa_reference_tbl DBMS_SQL.NUMBER_TABLE;
5255: l_count_tbl DBMS_SQL.NUMBER_TABLE;
5256:
5257: ------ End of declaring columns selected in the cursor ------
5258:
5259: l_api_name CONSTANT VARCHAR2(30) := 'checkUpdateInGBPAForDelta';
5378: ORDER BY upg.po_header_id;
5379:
5380: ----- Start of declaring columns selected in the cursor -----
5381:
5382: l_rt_item_id_tbl DBMS_SQL.NUMBER_TABLE;
5383: l_po_interface_header_id_tbl DBMS_SQL.NUMBER_TABLE;
5384: l_po_interface_line_id_tbl DBMS_SQL.NUMBER_TABLE;
5385: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
5386: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
5379:
5380: ----- Start of declaring columns selected in the cursor -----
5381:
5382: l_rt_item_id_tbl DBMS_SQL.NUMBER_TABLE;
5383: l_po_interface_header_id_tbl DBMS_SQL.NUMBER_TABLE;
5384: l_po_interface_line_id_tbl DBMS_SQL.NUMBER_TABLE;
5385: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
5386: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
5387: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
5380: ----- Start of declaring columns selected in the cursor -----
5381:
5382: l_rt_item_id_tbl DBMS_SQL.NUMBER_TABLE;
5383: l_po_interface_header_id_tbl DBMS_SQL.NUMBER_TABLE;
5384: l_po_interface_line_id_tbl DBMS_SQL.NUMBER_TABLE;
5385: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
5386: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
5387: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
5388:
5381:
5382: l_rt_item_id_tbl DBMS_SQL.NUMBER_TABLE;
5383: l_po_interface_header_id_tbl DBMS_SQL.NUMBER_TABLE;
5384: l_po_interface_line_id_tbl DBMS_SQL.NUMBER_TABLE;
5385: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
5386: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
5387: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
5388:
5389: ------ End of declaring columns selected in the cursor ------
5382: l_rt_item_id_tbl DBMS_SQL.NUMBER_TABLE;
5383: l_po_interface_header_id_tbl DBMS_SQL.NUMBER_TABLE;
5384: l_po_interface_line_id_tbl DBMS_SQL.NUMBER_TABLE;
5385: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
5386: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
5387: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
5388:
5389: ------ End of declaring columns selected in the cursor ------
5390:
5383: l_po_interface_header_id_tbl DBMS_SQL.NUMBER_TABLE;
5384: l_po_interface_line_id_tbl DBMS_SQL.NUMBER_TABLE;
5385: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
5386: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
5387: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
5388:
5389: ------ End of declaring columns selected in the cursor ------
5390:
5391: l_api_name CONSTANT VARCHAR2(30) := 'checkDeleteInGBPAForDelta';
5613: AND po_interface_header_id IS NOT NULL;
5614:
5615: ----- Start of declaring columns selected in the cursor -----
5616:
5617: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
5618: l_count_tbl DBMS_SQL.NUMBER_TABLE;
5619: l_rowid_tbl DBMS_SQL.UROWID_TABLE;
5620:
5621: ------ End of declaring columns selected in the cursor ------
5614:
5615: ----- Start of declaring columns selected in the cursor -----
5616:
5617: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
5618: l_count_tbl DBMS_SQL.NUMBER_TABLE;
5619: l_rowid_tbl DBMS_SQL.UROWID_TABLE;
5620:
5621: ------ End of declaring columns selected in the cursor ------
5622:
5615: ----- Start of declaring columns selected in the cursor -----
5616:
5617: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
5618: l_count_tbl DBMS_SQL.NUMBER_TABLE;
5619: l_rowid_tbl DBMS_SQL.UROWID_TABLE;
5620:
5621: ------ End of declaring columns selected in the cursor ------
5622:
5623: l_api_name CONSTANT VARCHAR2(30) := 'syncPOIntHdrIdInR12UpgTbl';
5625: l_batch_count PLS_INTEGER;
5626: l_item_row_count PLS_INTEGER;
5627: l_start_date DATE;
5628: l_end_date DATE;
5629: l_upo_hdr_id_tbl DBMS_SQL.NUMBER_TABLE;
5630: l_upo_int_hdr_id_tbl DBMS_SQL.NUMBER_TABLE;
5631: l_upd_index PLS_INTEGER;
5632: l_err_string VARCHAR2(4000);
5633:
5626: l_item_row_count PLS_INTEGER;
5627: l_start_date DATE;
5628: l_end_date DATE;
5629: l_upo_hdr_id_tbl DBMS_SQL.NUMBER_TABLE;
5630: l_upo_int_hdr_id_tbl DBMS_SQL.NUMBER_TABLE;
5631: l_upd_index PLS_INTEGER;
5632: l_err_string VARCHAR2(4000);
5633:
5634: BEGIN
5834: AND contract_id IS NULL;
5835:
5836: l_api_name CONSTANT VARCHAR2(30) := 'migrateBulkloadItems';
5837: l_err_loc PLS_INTEGER;
5838: l_rowid_tbl DBMS_SQL.UROWID_TABLE;
5839: l_rt_item_id_tbl DBMS_SQL.NUMBER_TABLE;
5840: l_batch_count PLS_INTEGER;
5841: l_start_rt_item_id NUMBER;
5842: l_err_string VARCHAR2(4000);
5835:
5836: l_api_name CONSTANT VARCHAR2(30) := 'migrateBulkloadItems';
5837: l_err_loc PLS_INTEGER;
5838: l_rowid_tbl DBMS_SQL.UROWID_TABLE;
5839: l_rt_item_id_tbl DBMS_SQL.NUMBER_TABLE;
5840: l_batch_count PLS_INTEGER;
5841: l_start_rt_item_id NUMBER;
5842: l_err_string VARCHAR2(4000);
5843: l_icx_schema_name VARCHAR2(30) := NULL;
6078: ICX_CAT_UTIL_PVT.g_job_complete_date := NULL;
6079: END callICXProcessDataExcptnRpt;
6080:
6081: PROCEDURE updatePOHeaderId
6082: ( p_interface_header_id IN DBMS_SQL.NUMBER_TABLE
6083: )
6084: IS
6085: l_api_name CONSTANT VARCHAR2(30) := 'updatePOHeaderId';
6086: l_err_loc PLS_INTEGER;
6151: RAISE;
6152: END updatePOHeaderId;
6153:
6154: PROCEDURE updatePOLineId
6155: ( p_interface_line_id IN DBMS_SQL.NUMBER_TABLE
6156: )
6157: IS
6158: l_api_name CONSTANT VARCHAR2(30) := 'updatePOLineId';
6159: l_err_loc PLS_INTEGER;
6480: AND fav_lines.item_type <> 'CATALOG';
6481:
6482: ----- Start of declaring columns selected in the cursor -----
6483:
6484: l_rowid_tbl DBMS_SQL.UROWID_TABLE;
6485: l_favorite_list_id_tbl DBMS_SQL.NUMBER_TABLE;
6486: l_favorite_list_line_id_tbl DBMS_SQL.NUMBER_TABLE;
6487: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
6488: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
6481:
6482: ----- Start of declaring columns selected in the cursor -----
6483:
6484: l_rowid_tbl DBMS_SQL.UROWID_TABLE;
6485: l_favorite_list_id_tbl DBMS_SQL.NUMBER_TABLE;
6486: l_favorite_list_line_id_tbl DBMS_SQL.NUMBER_TABLE;
6487: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
6488: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
6489: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
6482: ----- Start of declaring columns selected in the cursor -----
6483:
6484: l_rowid_tbl DBMS_SQL.UROWID_TABLE;
6485: l_favorite_list_id_tbl DBMS_SQL.NUMBER_TABLE;
6486: l_favorite_list_line_id_tbl DBMS_SQL.NUMBER_TABLE;
6487: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
6488: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
6489: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
6490: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
6483:
6484: l_rowid_tbl DBMS_SQL.UROWID_TABLE;
6485: l_favorite_list_id_tbl DBMS_SQL.NUMBER_TABLE;
6486: l_favorite_list_line_id_tbl DBMS_SQL.NUMBER_TABLE;
6487: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
6488: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
6489: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
6490: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
6491: l_asl_id_tbl DBMS_SQL.NUMBER_TABLE;
6484: l_rowid_tbl DBMS_SQL.UROWID_TABLE;
6485: l_favorite_list_id_tbl DBMS_SQL.NUMBER_TABLE;
6486: l_favorite_list_line_id_tbl DBMS_SQL.NUMBER_TABLE;
6487: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
6488: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
6489: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
6490: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
6491: l_asl_id_tbl DBMS_SQL.NUMBER_TABLE;
6492: l_rt_item_id_tbl DBMS_SQL.NUMBER_TABLE;
6485: l_favorite_list_id_tbl DBMS_SQL.NUMBER_TABLE;
6486: l_favorite_list_line_id_tbl DBMS_SQL.NUMBER_TABLE;
6487: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
6488: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
6489: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
6490: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
6491: l_asl_id_tbl DBMS_SQL.NUMBER_TABLE;
6492: l_rt_item_id_tbl DBMS_SQL.NUMBER_TABLE;
6493: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
6486: l_favorite_list_line_id_tbl DBMS_SQL.NUMBER_TABLE;
6487: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
6488: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
6489: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
6490: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
6491: l_asl_id_tbl DBMS_SQL.NUMBER_TABLE;
6492: l_rt_item_id_tbl DBMS_SQL.NUMBER_TABLE;
6493: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
6494: l_employee_id_tbl DBMS_SQL.NUMBER_TABLE;
6487: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
6488: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
6489: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
6490: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
6491: l_asl_id_tbl DBMS_SQL.NUMBER_TABLE;
6492: l_rt_item_id_tbl DBMS_SQL.NUMBER_TABLE;
6493: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
6494: l_employee_id_tbl DBMS_SQL.NUMBER_TABLE;
6495: l_user_id_tbl DBMS_SQL.NUMBER_TABLE;
6488: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
6489: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
6490: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
6491: l_asl_id_tbl DBMS_SQL.NUMBER_TABLE;
6492: l_rt_item_id_tbl DBMS_SQL.NUMBER_TABLE;
6493: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
6494: l_employee_id_tbl DBMS_SQL.NUMBER_TABLE;
6495: l_user_id_tbl DBMS_SQL.NUMBER_TABLE;
6496: l_profile_option_value_tbl DBMS_SQL.VARCHAR2_TABLE;
6489: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
6490: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
6491: l_asl_id_tbl DBMS_SQL.NUMBER_TABLE;
6492: l_rt_item_id_tbl DBMS_SQL.NUMBER_TABLE;
6493: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
6494: l_employee_id_tbl DBMS_SQL.NUMBER_TABLE;
6495: l_user_id_tbl DBMS_SQL.NUMBER_TABLE;
6496: l_profile_option_value_tbl DBMS_SQL.VARCHAR2_TABLE;
6497: l_count_tbl DBMS_SQL.NUMBER_TABLE;
6490: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
6491: l_asl_id_tbl DBMS_SQL.NUMBER_TABLE;
6492: l_rt_item_id_tbl DBMS_SQL.NUMBER_TABLE;
6493: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
6494: l_employee_id_tbl DBMS_SQL.NUMBER_TABLE;
6495: l_user_id_tbl DBMS_SQL.NUMBER_TABLE;
6496: l_profile_option_value_tbl DBMS_SQL.VARCHAR2_TABLE;
6497: l_count_tbl DBMS_SQL.NUMBER_TABLE;
6498: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
6491: l_asl_id_tbl DBMS_SQL.NUMBER_TABLE;
6492: l_rt_item_id_tbl DBMS_SQL.NUMBER_TABLE;
6493: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
6494: l_employee_id_tbl DBMS_SQL.NUMBER_TABLE;
6495: l_user_id_tbl DBMS_SQL.NUMBER_TABLE;
6496: l_profile_option_value_tbl DBMS_SQL.VARCHAR2_TABLE;
6497: l_count_tbl DBMS_SQL.NUMBER_TABLE;
6498: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
6499: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
6492: l_rt_item_id_tbl DBMS_SQL.NUMBER_TABLE;
6493: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
6494: l_employee_id_tbl DBMS_SQL.NUMBER_TABLE;
6495: l_user_id_tbl DBMS_SQL.NUMBER_TABLE;
6496: l_profile_option_value_tbl DBMS_SQL.VARCHAR2_TABLE;
6497: l_count_tbl DBMS_SQL.NUMBER_TABLE;
6498: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
6499: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
6500: l_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
6493: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
6494: l_employee_id_tbl DBMS_SQL.NUMBER_TABLE;
6495: l_user_id_tbl DBMS_SQL.NUMBER_TABLE;
6496: l_profile_option_value_tbl DBMS_SQL.VARCHAR2_TABLE;
6497: l_count_tbl DBMS_SQL.NUMBER_TABLE;
6498: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
6499: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
6500: l_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
6501: l_dupe_fav_list_line_id_tbl DBMS_SQL.NUMBER_TABLE;
6494: l_employee_id_tbl DBMS_SQL.NUMBER_TABLE;
6495: l_user_id_tbl DBMS_SQL.NUMBER_TABLE;
6496: l_profile_option_value_tbl DBMS_SQL.VARCHAR2_TABLE;
6497: l_count_tbl DBMS_SQL.NUMBER_TABLE;
6498: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
6499: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
6500: l_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
6501: l_dupe_fav_list_line_id_tbl DBMS_SQL.NUMBER_TABLE;
6502:
6495: l_user_id_tbl DBMS_SQL.NUMBER_TABLE;
6496: l_profile_option_value_tbl DBMS_SQL.VARCHAR2_TABLE;
6497: l_count_tbl DBMS_SQL.NUMBER_TABLE;
6498: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
6499: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
6500: l_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
6501: l_dupe_fav_list_line_id_tbl DBMS_SQL.NUMBER_TABLE;
6502:
6503: ------ End of declaring columns selected in the cursor ------
6496: l_profile_option_value_tbl DBMS_SQL.VARCHAR2_TABLE;
6497: l_count_tbl DBMS_SQL.NUMBER_TABLE;
6498: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
6499: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
6500: l_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
6501: l_dupe_fav_list_line_id_tbl DBMS_SQL.NUMBER_TABLE;
6502:
6503: ------ End of declaring columns selected in the cursor ------
6504:
6497: l_count_tbl DBMS_SQL.NUMBER_TABLE;
6498: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
6499: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
6500: l_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
6501: l_dupe_fav_list_line_id_tbl DBMS_SQL.NUMBER_TABLE;
6502:
6503: ------ End of declaring columns selected in the cursor ------
6504:
6505: l_api_name CONSTANT VARCHAR2(30) := 'upgradeFavoriteListLines';
7614: AND rt_category_id = 0
7615: AND language = ICX_CAT_UTIL_PVT.g_base_language;
7616:
7617: ----- Start of declaring columns selected in the cursor -----
7618: l_rt_descriptor_id_tbl DBMS_SQL.NUMBER_TABLE;
7619: l_attribute_id_tbl DBMS_SQL.NUMBER_TABLE;
7620: l_key_tbl DBMS_SQL.VARCHAR2_TABLE;
7621: ------ End of declaring columns selected in the cursor ------
7622:
7615: AND language = ICX_CAT_UTIL_PVT.g_base_language;
7616:
7617: ----- Start of declaring columns selected in the cursor -----
7618: l_rt_descriptor_id_tbl DBMS_SQL.NUMBER_TABLE;
7619: l_attribute_id_tbl DBMS_SQL.NUMBER_TABLE;
7620: l_key_tbl DBMS_SQL.VARCHAR2_TABLE;
7621: ------ End of declaring columns selected in the cursor ------
7622:
7623: -- variables for update
7616:
7617: ----- Start of declaring columns selected in the cursor -----
7618: l_rt_descriptor_id_tbl DBMS_SQL.NUMBER_TABLE;
7619: l_attribute_id_tbl DBMS_SQL.NUMBER_TABLE;
7620: l_key_tbl DBMS_SQL.VARCHAR2_TABLE;
7621: ------ End of declaring columns selected in the cursor ------
7622:
7623: -- variables for update
7624: l_upd_index PLS_INTEGER;
7621: ------ End of declaring columns selected in the cursor ------
7622:
7623: -- variables for update
7624: l_upd_index PLS_INTEGER;
7625: l_upd_rt_descriptor_id_tbl DBMS_SQL.NUMBER_TABLE;
7626: l_upd_key_tbl DBMS_SQL.VARCHAR2_TABLE;
7627: l_new_key VARCHAR2(250);
7628:
7629: l_api_name CONSTANT VARCHAR2(30) := 'runAttributeUpgrade';
7622:
7623: -- variables for update
7624: l_upd_index PLS_INTEGER;
7625: l_upd_rt_descriptor_id_tbl DBMS_SQL.NUMBER_TABLE;
7626: l_upd_key_tbl DBMS_SQL.VARCHAR2_TABLE;
7627: l_new_key VARCHAR2(250);
7628:
7629: l_api_name CONSTANT VARCHAR2(30) := 'runAttributeUpgrade';
7630: l_err_loc PLS_INTEGER;