134: --------------------------------------------------------------
135: -- Global PL/SQL Tables --
136: --------------------------------------------------------------
137: -- Update ICX_CAT_ITEM_PRICES
138: gUPRtItemIds DBMS_SQL.NUMBER_TABLE;
139: gUPPriceTypes DBMS_SQL.VARCHAR2_TABLE;
140: gUPAslIds DBMS_SQL.NUMBER_TABLE;
141: gUPSupplierSiteIds DBMS_SQL.NUMBER_TABLE;
142: gUPContractIds DBMS_SQL.NUMBER_TABLE;
135: -- Global PL/SQL Tables --
136: --------------------------------------------------------------
137: -- Update ICX_CAT_ITEM_PRICES
138: gUPRtItemIds DBMS_SQL.NUMBER_TABLE;
139: gUPPriceTypes DBMS_SQL.VARCHAR2_TABLE;
140: gUPAslIds DBMS_SQL.NUMBER_TABLE;
141: gUPSupplierSiteIds DBMS_SQL.NUMBER_TABLE;
142: gUPContractIds DBMS_SQL.NUMBER_TABLE;
143: gUPContractLineIds DBMS_SQL.NUMBER_TABLE;
136: --------------------------------------------------------------
137: -- Update ICX_CAT_ITEM_PRICES
138: gUPRtItemIds DBMS_SQL.NUMBER_TABLE;
139: gUPPriceTypes DBMS_SQL.VARCHAR2_TABLE;
140: gUPAslIds DBMS_SQL.NUMBER_TABLE;
141: gUPSupplierSiteIds DBMS_SQL.NUMBER_TABLE;
142: gUPContractIds DBMS_SQL.NUMBER_TABLE;
143: gUPContractLineIds DBMS_SQL.NUMBER_TABLE;
144: gUPTemplateIds DBMS_SQL.VARCHAR2_TABLE;
137: -- Update ICX_CAT_ITEM_PRICES
138: gUPRtItemIds DBMS_SQL.NUMBER_TABLE;
139: gUPPriceTypes DBMS_SQL.VARCHAR2_TABLE;
140: gUPAslIds DBMS_SQL.NUMBER_TABLE;
141: gUPSupplierSiteIds DBMS_SQL.NUMBER_TABLE;
142: gUPContractIds DBMS_SQL.NUMBER_TABLE;
143: gUPContractLineIds DBMS_SQL.NUMBER_TABLE;
144: gUPTemplateIds DBMS_SQL.VARCHAR2_TABLE;
145: gUPTemplateLineIds DBMS_SQL.NUMBER_TABLE;
138: gUPRtItemIds DBMS_SQL.NUMBER_TABLE;
139: gUPPriceTypes DBMS_SQL.VARCHAR2_TABLE;
140: gUPAslIds DBMS_SQL.NUMBER_TABLE;
141: gUPSupplierSiteIds DBMS_SQL.NUMBER_TABLE;
142: gUPContractIds DBMS_SQL.NUMBER_TABLE;
143: gUPContractLineIds DBMS_SQL.NUMBER_TABLE;
144: gUPTemplateIds DBMS_SQL.VARCHAR2_TABLE;
145: gUPTemplateLineIds DBMS_SQL.NUMBER_TABLE;
146: gUPInventoryItemIds DBMS_SQL.NUMBER_TABLE;
139: gUPPriceTypes DBMS_SQL.VARCHAR2_TABLE;
140: gUPAslIds DBMS_SQL.NUMBER_TABLE;
141: gUPSupplierSiteIds DBMS_SQL.NUMBER_TABLE;
142: gUPContractIds DBMS_SQL.NUMBER_TABLE;
143: gUPContractLineIds DBMS_SQL.NUMBER_TABLE;
144: gUPTemplateIds DBMS_SQL.VARCHAR2_TABLE;
145: gUPTemplateLineIds DBMS_SQL.NUMBER_TABLE;
146: gUPInventoryItemIds DBMS_SQL.NUMBER_TABLE;
147: gUPMtlCategoryIds DBMS_SQL.NUMBER_TABLE;
140: gUPAslIds DBMS_SQL.NUMBER_TABLE;
141: gUPSupplierSiteIds DBMS_SQL.NUMBER_TABLE;
142: gUPContractIds DBMS_SQL.NUMBER_TABLE;
143: gUPContractLineIds DBMS_SQL.NUMBER_TABLE;
144: gUPTemplateIds DBMS_SQL.VARCHAR2_TABLE;
145: gUPTemplateLineIds DBMS_SQL.NUMBER_TABLE;
146: gUPInventoryItemIds DBMS_SQL.NUMBER_TABLE;
147: gUPMtlCategoryIds DBMS_SQL.NUMBER_TABLE;
148: gUPOrgIds DBMS_SQL.NUMBER_TABLE;
141: gUPSupplierSiteIds DBMS_SQL.NUMBER_TABLE;
142: gUPContractIds DBMS_SQL.NUMBER_TABLE;
143: gUPContractLineIds DBMS_SQL.NUMBER_TABLE;
144: gUPTemplateIds DBMS_SQL.VARCHAR2_TABLE;
145: gUPTemplateLineIds DBMS_SQL.NUMBER_TABLE;
146: gUPInventoryItemIds DBMS_SQL.NUMBER_TABLE;
147: gUPMtlCategoryIds DBMS_SQL.NUMBER_TABLE;
148: gUPOrgIds DBMS_SQL.NUMBER_TABLE;
149: gUPSearchTypes DBMS_SQL.VARCHAR2_TABLE;
142: gUPContractIds DBMS_SQL.NUMBER_TABLE;
143: gUPContractLineIds DBMS_SQL.NUMBER_TABLE;
144: gUPTemplateIds DBMS_SQL.VARCHAR2_TABLE;
145: gUPTemplateLineIds DBMS_SQL.NUMBER_TABLE;
146: gUPInventoryItemIds DBMS_SQL.NUMBER_TABLE;
147: gUPMtlCategoryIds DBMS_SQL.NUMBER_TABLE;
148: gUPOrgIds DBMS_SQL.NUMBER_TABLE;
149: gUPSearchTypes DBMS_SQL.VARCHAR2_TABLE;
150: gUPUnitPrices DBMS_SQL.NUMBER_TABLE;
143: gUPContractLineIds DBMS_SQL.NUMBER_TABLE;
144: gUPTemplateIds DBMS_SQL.VARCHAR2_TABLE;
145: gUPTemplateLineIds DBMS_SQL.NUMBER_TABLE;
146: gUPInventoryItemIds DBMS_SQL.NUMBER_TABLE;
147: gUPMtlCategoryIds DBMS_SQL.NUMBER_TABLE;
148: gUPOrgIds DBMS_SQL.NUMBER_TABLE;
149: gUPSearchTypes DBMS_SQL.VARCHAR2_TABLE;
150: gUPUnitPrices DBMS_SQL.NUMBER_TABLE;
151: --FPJ FPSL Extractor Changes
144: gUPTemplateIds DBMS_SQL.VARCHAR2_TABLE;
145: gUPTemplateLineIds DBMS_SQL.NUMBER_TABLE;
146: gUPInventoryItemIds DBMS_SQL.NUMBER_TABLE;
147: gUPMtlCategoryIds DBMS_SQL.NUMBER_TABLE;
148: gUPOrgIds DBMS_SQL.NUMBER_TABLE;
149: gUPSearchTypes DBMS_SQL.VARCHAR2_TABLE;
150: gUPUnitPrices DBMS_SQL.NUMBER_TABLE;
151: --FPJ FPSL Extractor Changes
152: gUPValueBasis DBMS_SQL.VARCHAR2_TABLE;
145: gUPTemplateLineIds DBMS_SQL.NUMBER_TABLE;
146: gUPInventoryItemIds DBMS_SQL.NUMBER_TABLE;
147: gUPMtlCategoryIds DBMS_SQL.NUMBER_TABLE;
148: gUPOrgIds DBMS_SQL.NUMBER_TABLE;
149: gUPSearchTypes DBMS_SQL.VARCHAR2_TABLE;
150: gUPUnitPrices DBMS_SQL.NUMBER_TABLE;
151: --FPJ FPSL Extractor Changes
152: gUPValueBasis DBMS_SQL.VARCHAR2_TABLE;
153: gUPPurchaseBasis DBMS_SQL.VARCHAR2_TABLE;
146: gUPInventoryItemIds DBMS_SQL.NUMBER_TABLE;
147: gUPMtlCategoryIds DBMS_SQL.NUMBER_TABLE;
148: gUPOrgIds DBMS_SQL.NUMBER_TABLE;
149: gUPSearchTypes DBMS_SQL.VARCHAR2_TABLE;
150: gUPUnitPrices DBMS_SQL.NUMBER_TABLE;
151: --FPJ FPSL Extractor Changes
152: gUPValueBasis DBMS_SQL.VARCHAR2_TABLE;
153: gUPPurchaseBasis DBMS_SQL.VARCHAR2_TABLE;
154: gUPAllowPriceOverrideFlag DBMS_SQL.VARCHAR2_TABLE;
148: gUPOrgIds DBMS_SQL.NUMBER_TABLE;
149: gUPSearchTypes DBMS_SQL.VARCHAR2_TABLE;
150: gUPUnitPrices DBMS_SQL.NUMBER_TABLE;
151: --FPJ FPSL Extractor Changes
152: gUPValueBasis DBMS_SQL.VARCHAR2_TABLE;
153: gUPPurchaseBasis DBMS_SQL.VARCHAR2_TABLE;
154: gUPAllowPriceOverrideFlag DBMS_SQL.VARCHAR2_TABLE;
155: gUPNotToExceedPrice DBMS_SQL.NUMBER_TABLE;
156: -- FPJ Bug# 3007068 sosingha: Extractor Changes For Kit Support Project
149: gUPSearchTypes DBMS_SQL.VARCHAR2_TABLE;
150: gUPUnitPrices DBMS_SQL.NUMBER_TABLE;
151: --FPJ FPSL Extractor Changes
152: gUPValueBasis DBMS_SQL.VARCHAR2_TABLE;
153: gUPPurchaseBasis DBMS_SQL.VARCHAR2_TABLE;
154: gUPAllowPriceOverrideFlag DBMS_SQL.VARCHAR2_TABLE;
155: gUPNotToExceedPrice DBMS_SQL.NUMBER_TABLE;
156: -- FPJ Bug# 3007068 sosingha: Extractor Changes For Kit Support Project
157: gUPSuggestedQuantities DBMS_SQL.NUMBER_TABLE;
150: gUPUnitPrices DBMS_SQL.NUMBER_TABLE;
151: --FPJ FPSL Extractor Changes
152: gUPValueBasis DBMS_SQL.VARCHAR2_TABLE;
153: gUPPurchaseBasis DBMS_SQL.VARCHAR2_TABLE;
154: gUPAllowPriceOverrideFlag DBMS_SQL.VARCHAR2_TABLE;
155: gUPNotToExceedPrice DBMS_SQL.NUMBER_TABLE;
156: -- FPJ Bug# 3007068 sosingha: Extractor Changes For Kit Support Project
157: gUPSuggestedQuantities DBMS_SQL.NUMBER_TABLE;
158: -- FPJ Bug# 3110297 jingyu Add negotiated flag
151: --FPJ FPSL Extractor Changes
152: gUPValueBasis DBMS_SQL.VARCHAR2_TABLE;
153: gUPPurchaseBasis DBMS_SQL.VARCHAR2_TABLE;
154: gUPAllowPriceOverrideFlag DBMS_SQL.VARCHAR2_TABLE;
155: gUPNotToExceedPrice DBMS_SQL.NUMBER_TABLE;
156: -- FPJ Bug# 3007068 sosingha: Extractor Changes For Kit Support Project
157: gUPSuggestedQuantities DBMS_SQL.NUMBER_TABLE;
158: -- FPJ Bug# 3110297 jingyu Add negotiated flag
159: gUPNegotiatedFlag DBMS_SQL.VARCHAR2_TABLE;
153: gUPPurchaseBasis DBMS_SQL.VARCHAR2_TABLE;
154: gUPAllowPriceOverrideFlag DBMS_SQL.VARCHAR2_TABLE;
155: gUPNotToExceedPrice DBMS_SQL.NUMBER_TABLE;
156: -- FPJ Bug# 3007068 sosingha: Extractor Changes For Kit Support Project
157: gUPSuggestedQuantities DBMS_SQL.NUMBER_TABLE;
158: -- FPJ Bug# 3110297 jingyu Add negotiated flag
159: gUPNegotiatedFlag DBMS_SQL.VARCHAR2_TABLE;
160: gUPCurrencys DBMS_SQL.VARCHAR2_TABLE;
161: gUPUnitOfMeasures DBMS_SQL.VARCHAR2_TABLE;
155: gUPNotToExceedPrice DBMS_SQL.NUMBER_TABLE;
156: -- FPJ Bug# 3007068 sosingha: Extractor Changes For Kit Support Project
157: gUPSuggestedQuantities DBMS_SQL.NUMBER_TABLE;
158: -- FPJ Bug# 3110297 jingyu Add negotiated flag
159: gUPNegotiatedFlag DBMS_SQL.VARCHAR2_TABLE;
160: gUPCurrencys DBMS_SQL.VARCHAR2_TABLE;
161: gUPUnitOfMeasures DBMS_SQL.VARCHAR2_TABLE;
162: gUPFunctionalPrices DBMS_SQL.NUMBER_TABLE;
163: gUPSupplierSiteCodes DBMS_SQL.VARCHAR2_TABLE;
156: -- FPJ Bug# 3007068 sosingha: Extractor Changes For Kit Support Project
157: gUPSuggestedQuantities DBMS_SQL.NUMBER_TABLE;
158: -- FPJ Bug# 3110297 jingyu Add negotiated flag
159: gUPNegotiatedFlag DBMS_SQL.VARCHAR2_TABLE;
160: gUPCurrencys DBMS_SQL.VARCHAR2_TABLE;
161: gUPUnitOfMeasures DBMS_SQL.VARCHAR2_TABLE;
162: gUPFunctionalPrices DBMS_SQL.NUMBER_TABLE;
163: gUPSupplierSiteCodes DBMS_SQL.VARCHAR2_TABLE;
164: gUPContractNums DBMS_SQL.VARCHAR2_TABLE;
157: gUPSuggestedQuantities DBMS_SQL.NUMBER_TABLE;
158: -- FPJ Bug# 3110297 jingyu Add negotiated flag
159: gUPNegotiatedFlag DBMS_SQL.VARCHAR2_TABLE;
160: gUPCurrencys DBMS_SQL.VARCHAR2_TABLE;
161: gUPUnitOfMeasures DBMS_SQL.VARCHAR2_TABLE;
162: gUPFunctionalPrices DBMS_SQL.NUMBER_TABLE;
163: gUPSupplierSiteCodes DBMS_SQL.VARCHAR2_TABLE;
164: gUPContractNums DBMS_SQL.VARCHAR2_TABLE;
165: gUPContractLineNums DBMS_SQL.NUMBER_TABLE;
158: -- FPJ Bug# 3110297 jingyu Add negotiated flag
159: gUPNegotiatedFlag DBMS_SQL.VARCHAR2_TABLE;
160: gUPCurrencys DBMS_SQL.VARCHAR2_TABLE;
161: gUPUnitOfMeasures DBMS_SQL.VARCHAR2_TABLE;
162: gUPFunctionalPrices DBMS_SQL.NUMBER_TABLE;
163: gUPSupplierSiteCodes DBMS_SQL.VARCHAR2_TABLE;
164: gUPContractNums DBMS_SQL.VARCHAR2_TABLE;
165: gUPContractLineNums DBMS_SQL.NUMBER_TABLE;
166: gUpRateTypes DBMS_SQL.VARCHAR2_TABLE;
159: gUPNegotiatedFlag DBMS_SQL.VARCHAR2_TABLE;
160: gUPCurrencys DBMS_SQL.VARCHAR2_TABLE;
161: gUPUnitOfMeasures DBMS_SQL.VARCHAR2_TABLE;
162: gUPFunctionalPrices DBMS_SQL.NUMBER_TABLE;
163: gUPSupplierSiteCodes DBMS_SQL.VARCHAR2_TABLE;
164: gUPContractNums DBMS_SQL.VARCHAR2_TABLE;
165: gUPContractLineNums DBMS_SQL.NUMBER_TABLE;
166: gUpRateTypes DBMS_SQL.VARCHAR2_TABLE;
167: gUpRateDates DBMS_SQL.DATE_TABLE;
160: gUPCurrencys DBMS_SQL.VARCHAR2_TABLE;
161: gUPUnitOfMeasures DBMS_SQL.VARCHAR2_TABLE;
162: gUPFunctionalPrices DBMS_SQL.NUMBER_TABLE;
163: gUPSupplierSiteCodes DBMS_SQL.VARCHAR2_TABLE;
164: gUPContractNums DBMS_SQL.VARCHAR2_TABLE;
165: gUPContractLineNums DBMS_SQL.NUMBER_TABLE;
166: gUpRateTypes DBMS_SQL.VARCHAR2_TABLE;
167: gUpRateDates DBMS_SQL.DATE_TABLE;
168: gUpRates DBMS_SQL.NUMBER_TABLE;
161: gUPUnitOfMeasures DBMS_SQL.VARCHAR2_TABLE;
162: gUPFunctionalPrices DBMS_SQL.NUMBER_TABLE;
163: gUPSupplierSiteCodes DBMS_SQL.VARCHAR2_TABLE;
164: gUPContractNums DBMS_SQL.VARCHAR2_TABLE;
165: gUPContractLineNums DBMS_SQL.NUMBER_TABLE;
166: gUpRateTypes DBMS_SQL.VARCHAR2_TABLE;
167: gUpRateDates DBMS_SQL.DATE_TABLE;
168: gUpRates DBMS_SQL.NUMBER_TABLE;
169: gUpSupplierNumbers DBMS_SQL.VARCHAR2_TABLE;
162: gUPFunctionalPrices DBMS_SQL.NUMBER_TABLE;
163: gUPSupplierSiteCodes DBMS_SQL.VARCHAR2_TABLE;
164: gUPContractNums DBMS_SQL.VARCHAR2_TABLE;
165: gUPContractLineNums DBMS_SQL.NUMBER_TABLE;
166: gUpRateTypes DBMS_SQL.VARCHAR2_TABLE;
167: gUpRateDates DBMS_SQL.DATE_TABLE;
168: gUpRates DBMS_SQL.NUMBER_TABLE;
169: gUpSupplierNumbers DBMS_SQL.VARCHAR2_TABLE;
170: gUpSupplierContactIds DBMS_SQL.NUMBER_TABLE;
163: gUPSupplierSiteCodes DBMS_SQL.VARCHAR2_TABLE;
164: gUPContractNums DBMS_SQL.VARCHAR2_TABLE;
165: gUPContractLineNums DBMS_SQL.NUMBER_TABLE;
166: gUpRateTypes DBMS_SQL.VARCHAR2_TABLE;
167: gUpRateDates DBMS_SQL.DATE_TABLE;
168: gUpRates DBMS_SQL.NUMBER_TABLE;
169: gUpSupplierNumbers DBMS_SQL.VARCHAR2_TABLE;
170: gUpSupplierContactIds DBMS_SQL.NUMBER_TABLE;
171: gUpItemRevisions DBMS_SQL.VARCHAR2_TABLE;
164: gUPContractNums DBMS_SQL.VARCHAR2_TABLE;
165: gUPContractLineNums DBMS_SQL.NUMBER_TABLE;
166: gUpRateTypes DBMS_SQL.VARCHAR2_TABLE;
167: gUpRateDates DBMS_SQL.DATE_TABLE;
168: gUpRates DBMS_SQL.NUMBER_TABLE;
169: gUpSupplierNumbers DBMS_SQL.VARCHAR2_TABLE;
170: gUpSupplierContactIds DBMS_SQL.NUMBER_TABLE;
171: gUpItemRevisions DBMS_SQL.VARCHAR2_TABLE;
172: gUpLineTypeIds DBMS_SQL.NUMBER_TABLE;
165: gUPContractLineNums DBMS_SQL.NUMBER_TABLE;
166: gUpRateTypes DBMS_SQL.VARCHAR2_TABLE;
167: gUpRateDates DBMS_SQL.DATE_TABLE;
168: gUpRates DBMS_SQL.NUMBER_TABLE;
169: gUpSupplierNumbers DBMS_SQL.VARCHAR2_TABLE;
170: gUpSupplierContactIds DBMS_SQL.NUMBER_TABLE;
171: gUpItemRevisions DBMS_SQL.VARCHAR2_TABLE;
172: gUpLineTypeIds DBMS_SQL.NUMBER_TABLE;
173: gUpBuyerIds DBMS_SQL.NUMBER_TABLE;
166: gUpRateTypes DBMS_SQL.VARCHAR2_TABLE;
167: gUpRateDates DBMS_SQL.DATE_TABLE;
168: gUpRates DBMS_SQL.NUMBER_TABLE;
169: gUpSupplierNumbers DBMS_SQL.VARCHAR2_TABLE;
170: gUpSupplierContactIds DBMS_SQL.NUMBER_TABLE;
171: gUpItemRevisions DBMS_SQL.VARCHAR2_TABLE;
172: gUpLineTypeIds DBMS_SQL.NUMBER_TABLE;
173: gUpBuyerIds DBMS_SQL.NUMBER_TABLE;
174: gUPPriceRowIds DBMS_SQL.UROWID_TABLE;
167: gUpRateDates DBMS_SQL.DATE_TABLE;
168: gUpRates DBMS_SQL.NUMBER_TABLE;
169: gUpSupplierNumbers DBMS_SQL.VARCHAR2_TABLE;
170: gUpSupplierContactIds DBMS_SQL.NUMBER_TABLE;
171: gUpItemRevisions DBMS_SQL.VARCHAR2_TABLE;
172: gUpLineTypeIds DBMS_SQL.NUMBER_TABLE;
173: gUpBuyerIds DBMS_SQL.NUMBER_TABLE;
174: gUPPriceRowIds DBMS_SQL.UROWID_TABLE;
175: gUPActiveFlags DBMS_SQL.VARCHAR2_TABLE;
168: gUpRates DBMS_SQL.NUMBER_TABLE;
169: gUpSupplierNumbers DBMS_SQL.VARCHAR2_TABLE;
170: gUpSupplierContactIds DBMS_SQL.NUMBER_TABLE;
171: gUpItemRevisions DBMS_SQL.VARCHAR2_TABLE;
172: gUpLineTypeIds DBMS_SQL.NUMBER_TABLE;
173: gUpBuyerIds DBMS_SQL.NUMBER_TABLE;
174: gUPPriceRowIds DBMS_SQL.UROWID_TABLE;
175: gUPActiveFlags DBMS_SQL.VARCHAR2_TABLE;
176: gUPLastUpdateDates DBMS_SQL.DATE_TABLE;
169: gUpSupplierNumbers DBMS_SQL.VARCHAR2_TABLE;
170: gUpSupplierContactIds DBMS_SQL.NUMBER_TABLE;
171: gUpItemRevisions DBMS_SQL.VARCHAR2_TABLE;
172: gUpLineTypeIds DBMS_SQL.NUMBER_TABLE;
173: gUpBuyerIds DBMS_SQL.NUMBER_TABLE;
174: gUPPriceRowIds DBMS_SQL.UROWID_TABLE;
175: gUPActiveFlags DBMS_SQL.VARCHAR2_TABLE;
176: gUPLastUpdateDates DBMS_SQL.DATE_TABLE;
177:
170: gUpSupplierContactIds DBMS_SQL.NUMBER_TABLE;
171: gUpItemRevisions DBMS_SQL.VARCHAR2_TABLE;
172: gUpLineTypeIds DBMS_SQL.NUMBER_TABLE;
173: gUpBuyerIds DBMS_SQL.NUMBER_TABLE;
174: gUPPriceRowIds DBMS_SQL.UROWID_TABLE;
175: gUPActiveFlags DBMS_SQL.VARCHAR2_TABLE;
176: gUPLastUpdateDates DBMS_SQL.DATE_TABLE;
177:
178:
171: gUpItemRevisions DBMS_SQL.VARCHAR2_TABLE;
172: gUpLineTypeIds DBMS_SQL.NUMBER_TABLE;
173: gUpBuyerIds DBMS_SQL.NUMBER_TABLE;
174: gUPPriceRowIds DBMS_SQL.UROWID_TABLE;
175: gUPActiveFlags DBMS_SQL.VARCHAR2_TABLE;
176: gUPLastUpdateDates DBMS_SQL.DATE_TABLE;
177:
178:
179: -- Update ICX_CAT_ITEM_PRICES for global agreements
172: gUpLineTypeIds DBMS_SQL.NUMBER_TABLE;
173: gUpBuyerIds DBMS_SQL.NUMBER_TABLE;
174: gUPPriceRowIds DBMS_SQL.UROWID_TABLE;
175: gUPActiveFlags DBMS_SQL.VARCHAR2_TABLE;
176: gUPLastUpdateDates DBMS_SQL.DATE_TABLE;
177:
178:
179: -- Update ICX_CAT_ITEM_PRICES for global agreements
180: gUPGRtItemIds DBMS_SQL.NUMBER_TABLE;
176: gUPLastUpdateDates DBMS_SQL.DATE_TABLE;
177:
178:
179: -- Update ICX_CAT_ITEM_PRICES for global agreements
180: gUPGRtItemIds DBMS_SQL.NUMBER_TABLE;
181: gUPGContractIds DBMS_SQL.NUMBER_TABLE;
182: gUPGContractLineIds DBMS_SQL.NUMBER_TABLE;
183: gUPGInventoryItemIds DBMS_SQL.NUMBER_TABLE;
184: gUPGMtlCategoryIds DBMS_SQL.NUMBER_TABLE;
177:
178:
179: -- Update ICX_CAT_ITEM_PRICES for global agreements
180: gUPGRtItemIds DBMS_SQL.NUMBER_TABLE;
181: gUPGContractIds DBMS_SQL.NUMBER_TABLE;
182: gUPGContractLineIds DBMS_SQL.NUMBER_TABLE;
183: gUPGInventoryItemIds DBMS_SQL.NUMBER_TABLE;
184: gUPGMtlCategoryIds DBMS_SQL.NUMBER_TABLE;
185: gUPGSearchTypes DBMS_SQL.VARCHAR2_TABLE;
178:
179: -- Update ICX_CAT_ITEM_PRICES for global agreements
180: gUPGRtItemIds DBMS_SQL.NUMBER_TABLE;
181: gUPGContractIds DBMS_SQL.NUMBER_TABLE;
182: gUPGContractLineIds DBMS_SQL.NUMBER_TABLE;
183: gUPGInventoryItemIds DBMS_SQL.NUMBER_TABLE;
184: gUPGMtlCategoryIds DBMS_SQL.NUMBER_TABLE;
185: gUPGSearchTypes DBMS_SQL.VARCHAR2_TABLE;
186: gUPGUnitPrices DBMS_SQL.NUMBER_TABLE;
179: -- Update ICX_CAT_ITEM_PRICES for global agreements
180: gUPGRtItemIds DBMS_SQL.NUMBER_TABLE;
181: gUPGContractIds DBMS_SQL.NUMBER_TABLE;
182: gUPGContractLineIds DBMS_SQL.NUMBER_TABLE;
183: gUPGInventoryItemIds DBMS_SQL.NUMBER_TABLE;
184: gUPGMtlCategoryIds DBMS_SQL.NUMBER_TABLE;
185: gUPGSearchTypes DBMS_SQL.VARCHAR2_TABLE;
186: gUPGUnitPrices DBMS_SQL.NUMBER_TABLE;
187: --FPJ FPSL Extractor Changes
180: gUPGRtItemIds DBMS_SQL.NUMBER_TABLE;
181: gUPGContractIds DBMS_SQL.NUMBER_TABLE;
182: gUPGContractLineIds DBMS_SQL.NUMBER_TABLE;
183: gUPGInventoryItemIds DBMS_SQL.NUMBER_TABLE;
184: gUPGMtlCategoryIds DBMS_SQL.NUMBER_TABLE;
185: gUPGSearchTypes DBMS_SQL.VARCHAR2_TABLE;
186: gUPGUnitPrices DBMS_SQL.NUMBER_TABLE;
187: --FPJ FPSL Extractor Changes
188: gUPGValueBasis DBMS_SQL.VARCHAR2_TABLE;
181: gUPGContractIds DBMS_SQL.NUMBER_TABLE;
182: gUPGContractLineIds DBMS_SQL.NUMBER_TABLE;
183: gUPGInventoryItemIds DBMS_SQL.NUMBER_TABLE;
184: gUPGMtlCategoryIds DBMS_SQL.NUMBER_TABLE;
185: gUPGSearchTypes DBMS_SQL.VARCHAR2_TABLE;
186: gUPGUnitPrices DBMS_SQL.NUMBER_TABLE;
187: --FPJ FPSL Extractor Changes
188: gUPGValueBasis DBMS_SQL.VARCHAR2_TABLE;
189: gUPGPurchaseBasis DBMS_SQL.VARCHAR2_TABLE;
182: gUPGContractLineIds DBMS_SQL.NUMBER_TABLE;
183: gUPGInventoryItemIds DBMS_SQL.NUMBER_TABLE;
184: gUPGMtlCategoryIds DBMS_SQL.NUMBER_TABLE;
185: gUPGSearchTypes DBMS_SQL.VARCHAR2_TABLE;
186: gUPGUnitPrices DBMS_SQL.NUMBER_TABLE;
187: --FPJ FPSL Extractor Changes
188: gUPGValueBasis DBMS_SQL.VARCHAR2_TABLE;
189: gUPGPurchaseBasis DBMS_SQL.VARCHAR2_TABLE;
190: gUPGAllowPriceOverrideFlag DBMS_SQL.VARCHAR2_TABLE;
184: gUPGMtlCategoryIds DBMS_SQL.NUMBER_TABLE;
185: gUPGSearchTypes DBMS_SQL.VARCHAR2_TABLE;
186: gUPGUnitPrices DBMS_SQL.NUMBER_TABLE;
187: --FPJ FPSL Extractor Changes
188: gUPGValueBasis DBMS_SQL.VARCHAR2_TABLE;
189: gUPGPurchaseBasis DBMS_SQL.VARCHAR2_TABLE;
190: gUPGAllowPriceOverrideFlag DBMS_SQL.VARCHAR2_TABLE;
191: gUPGNotToExceedPrice DBMS_SQL.NUMBER_TABLE;
192: -- FPJ Bug# 3110297 jingyu Add negotiated flag
185: gUPGSearchTypes DBMS_SQL.VARCHAR2_TABLE;
186: gUPGUnitPrices DBMS_SQL.NUMBER_TABLE;
187: --FPJ FPSL Extractor Changes
188: gUPGValueBasis DBMS_SQL.VARCHAR2_TABLE;
189: gUPGPurchaseBasis DBMS_SQL.VARCHAR2_TABLE;
190: gUPGAllowPriceOverrideFlag DBMS_SQL.VARCHAR2_TABLE;
191: gUPGNotToExceedPrice DBMS_SQL.NUMBER_TABLE;
192: -- FPJ Bug# 3110297 jingyu Add negotiated flag
193: gUPGNegotiatedFlag DBMS_SQL.VARCHAR2_TABLE;
186: gUPGUnitPrices DBMS_SQL.NUMBER_TABLE;
187: --FPJ FPSL Extractor Changes
188: gUPGValueBasis DBMS_SQL.VARCHAR2_TABLE;
189: gUPGPurchaseBasis DBMS_SQL.VARCHAR2_TABLE;
190: gUPGAllowPriceOverrideFlag DBMS_SQL.VARCHAR2_TABLE;
191: gUPGNotToExceedPrice DBMS_SQL.NUMBER_TABLE;
192: -- FPJ Bug# 3110297 jingyu Add negotiated flag
193: gUPGNegotiatedFlag DBMS_SQL.VARCHAR2_TABLE;
194: gUPGLineTypeIds DBMS_SQL.NUMBER_TABLE;
187: --FPJ FPSL Extractor Changes
188: gUPGValueBasis DBMS_SQL.VARCHAR2_TABLE;
189: gUPGPurchaseBasis DBMS_SQL.VARCHAR2_TABLE;
190: gUPGAllowPriceOverrideFlag DBMS_SQL.VARCHAR2_TABLE;
191: gUPGNotToExceedPrice DBMS_SQL.NUMBER_TABLE;
192: -- FPJ Bug# 3110297 jingyu Add negotiated flag
193: gUPGNegotiatedFlag DBMS_SQL.VARCHAR2_TABLE;
194: gUPGLineTypeIds DBMS_SQL.NUMBER_TABLE;
195: gUPGCurrencys DBMS_SQL.VARCHAR2_TABLE;
189: gUPGPurchaseBasis DBMS_SQL.VARCHAR2_TABLE;
190: gUPGAllowPriceOverrideFlag DBMS_SQL.VARCHAR2_TABLE;
191: gUPGNotToExceedPrice DBMS_SQL.NUMBER_TABLE;
192: -- FPJ Bug# 3110297 jingyu Add negotiated flag
193: gUPGNegotiatedFlag DBMS_SQL.VARCHAR2_TABLE;
194: gUPGLineTypeIds DBMS_SQL.NUMBER_TABLE;
195: gUPGCurrencys DBMS_SQL.VARCHAR2_TABLE;
196: gUPGUnitOfMeasures DBMS_SQL.VARCHAR2_TABLE;
197: gUPGFunctionalPrices DBMS_SQL.NUMBER_TABLE;
190: gUPGAllowPriceOverrideFlag DBMS_SQL.VARCHAR2_TABLE;
191: gUPGNotToExceedPrice DBMS_SQL.NUMBER_TABLE;
192: -- FPJ Bug# 3110297 jingyu Add negotiated flag
193: gUPGNegotiatedFlag DBMS_SQL.VARCHAR2_TABLE;
194: gUPGLineTypeIds DBMS_SQL.NUMBER_TABLE;
195: gUPGCurrencys DBMS_SQL.VARCHAR2_TABLE;
196: gUPGUnitOfMeasures DBMS_SQL.VARCHAR2_TABLE;
197: gUPGFunctionalPrices DBMS_SQL.NUMBER_TABLE;
198:
191: gUPGNotToExceedPrice DBMS_SQL.NUMBER_TABLE;
192: -- FPJ Bug# 3110297 jingyu Add negotiated flag
193: gUPGNegotiatedFlag DBMS_SQL.VARCHAR2_TABLE;
194: gUPGLineTypeIds DBMS_SQL.NUMBER_TABLE;
195: gUPGCurrencys DBMS_SQL.VARCHAR2_TABLE;
196: gUPGUnitOfMeasures DBMS_SQL.VARCHAR2_TABLE;
197: gUPGFunctionalPrices DBMS_SQL.NUMBER_TABLE;
198:
199: -- Insert ICX_CAT_ITEM_PRICES
192: -- FPJ Bug# 3110297 jingyu Add negotiated flag
193: gUPGNegotiatedFlag DBMS_SQL.VARCHAR2_TABLE;
194: gUPGLineTypeIds DBMS_SQL.NUMBER_TABLE;
195: gUPGCurrencys DBMS_SQL.VARCHAR2_TABLE;
196: gUPGUnitOfMeasures DBMS_SQL.VARCHAR2_TABLE;
197: gUPGFunctionalPrices DBMS_SQL.NUMBER_TABLE;
198:
199: -- Insert ICX_CAT_ITEM_PRICES
200: gIPRtItemIds DBMS_SQL.NUMBER_TABLE;
193: gUPGNegotiatedFlag DBMS_SQL.VARCHAR2_TABLE;
194: gUPGLineTypeIds DBMS_SQL.NUMBER_TABLE;
195: gUPGCurrencys DBMS_SQL.VARCHAR2_TABLE;
196: gUPGUnitOfMeasures DBMS_SQL.VARCHAR2_TABLE;
197: gUPGFunctionalPrices DBMS_SQL.NUMBER_TABLE;
198:
199: -- Insert ICX_CAT_ITEM_PRICES
200: gIPRtItemIds DBMS_SQL.NUMBER_TABLE;
201: gIPPriceTypes DBMS_SQL.VARCHAR2_TABLE;
196: gUPGUnitOfMeasures DBMS_SQL.VARCHAR2_TABLE;
197: gUPGFunctionalPrices DBMS_SQL.NUMBER_TABLE;
198:
199: -- Insert ICX_CAT_ITEM_PRICES
200: gIPRtItemIds DBMS_SQL.NUMBER_TABLE;
201: gIPPriceTypes DBMS_SQL.VARCHAR2_TABLE;
202: gIPAslIds DBMS_SQL.NUMBER_TABLE;
203: gIPSupplierSiteIds DBMS_SQL.NUMBER_TABLE;
204: gIPContractIds DBMS_SQL.NUMBER_TABLE;
197: gUPGFunctionalPrices DBMS_SQL.NUMBER_TABLE;
198:
199: -- Insert ICX_CAT_ITEM_PRICES
200: gIPRtItemIds DBMS_SQL.NUMBER_TABLE;
201: gIPPriceTypes DBMS_SQL.VARCHAR2_TABLE;
202: gIPAslIds DBMS_SQL.NUMBER_TABLE;
203: gIPSupplierSiteIds DBMS_SQL.NUMBER_TABLE;
204: gIPContractIds DBMS_SQL.NUMBER_TABLE;
205: gIPContractLineIds DBMS_SQL.NUMBER_TABLE;
198:
199: -- Insert ICX_CAT_ITEM_PRICES
200: gIPRtItemIds DBMS_SQL.NUMBER_TABLE;
201: gIPPriceTypes DBMS_SQL.VARCHAR2_TABLE;
202: gIPAslIds DBMS_SQL.NUMBER_TABLE;
203: gIPSupplierSiteIds DBMS_SQL.NUMBER_TABLE;
204: gIPContractIds DBMS_SQL.NUMBER_TABLE;
205: gIPContractLineIds DBMS_SQL.NUMBER_TABLE;
206: gIPTemplateIds DBMS_SQL.VARCHAR2_TABLE;
199: -- Insert ICX_CAT_ITEM_PRICES
200: gIPRtItemIds DBMS_SQL.NUMBER_TABLE;
201: gIPPriceTypes DBMS_SQL.VARCHAR2_TABLE;
202: gIPAslIds DBMS_SQL.NUMBER_TABLE;
203: gIPSupplierSiteIds DBMS_SQL.NUMBER_TABLE;
204: gIPContractIds DBMS_SQL.NUMBER_TABLE;
205: gIPContractLineIds DBMS_SQL.NUMBER_TABLE;
206: gIPTemplateIds DBMS_SQL.VARCHAR2_TABLE;
207: gIPTemplateLineIds DBMS_SQL.NUMBER_TABLE;
200: gIPRtItemIds DBMS_SQL.NUMBER_TABLE;
201: gIPPriceTypes DBMS_SQL.VARCHAR2_TABLE;
202: gIPAslIds DBMS_SQL.NUMBER_TABLE;
203: gIPSupplierSiteIds DBMS_SQL.NUMBER_TABLE;
204: gIPContractIds DBMS_SQL.NUMBER_TABLE;
205: gIPContractLineIds DBMS_SQL.NUMBER_TABLE;
206: gIPTemplateIds DBMS_SQL.VARCHAR2_TABLE;
207: gIPTemplateLineIds DBMS_SQL.NUMBER_TABLE;
208: gIPInventoryItemIds DBMS_SQL.NUMBER_TABLE;
201: gIPPriceTypes DBMS_SQL.VARCHAR2_TABLE;
202: gIPAslIds DBMS_SQL.NUMBER_TABLE;
203: gIPSupplierSiteIds DBMS_SQL.NUMBER_TABLE;
204: gIPContractIds DBMS_SQL.NUMBER_TABLE;
205: gIPContractLineIds DBMS_SQL.NUMBER_TABLE;
206: gIPTemplateIds DBMS_SQL.VARCHAR2_TABLE;
207: gIPTemplateLineIds DBMS_SQL.NUMBER_TABLE;
208: gIPInventoryItemIds DBMS_SQL.NUMBER_TABLE;
209: gIPMtlCategoryIds DBMS_SQL.NUMBER_TABLE;
202: gIPAslIds DBMS_SQL.NUMBER_TABLE;
203: gIPSupplierSiteIds DBMS_SQL.NUMBER_TABLE;
204: gIPContractIds DBMS_SQL.NUMBER_TABLE;
205: gIPContractLineIds DBMS_SQL.NUMBER_TABLE;
206: gIPTemplateIds DBMS_SQL.VARCHAR2_TABLE;
207: gIPTemplateLineIds DBMS_SQL.NUMBER_TABLE;
208: gIPInventoryItemIds DBMS_SQL.NUMBER_TABLE;
209: gIPMtlCategoryIds DBMS_SQL.NUMBER_TABLE;
210: gIPOrgIds DBMS_SQL.NUMBER_TABLE;
203: gIPSupplierSiteIds DBMS_SQL.NUMBER_TABLE;
204: gIPContractIds DBMS_SQL.NUMBER_TABLE;
205: gIPContractLineIds DBMS_SQL.NUMBER_TABLE;
206: gIPTemplateIds DBMS_SQL.VARCHAR2_TABLE;
207: gIPTemplateLineIds DBMS_SQL.NUMBER_TABLE;
208: gIPInventoryItemIds DBMS_SQL.NUMBER_TABLE;
209: gIPMtlCategoryIds DBMS_SQL.NUMBER_TABLE;
210: gIPOrgIds DBMS_SQL.NUMBER_TABLE;
211: gIPSearchTypes DBMS_SQL.VARCHAR2_TABLE;
204: gIPContractIds DBMS_SQL.NUMBER_TABLE;
205: gIPContractLineIds DBMS_SQL.NUMBER_TABLE;
206: gIPTemplateIds DBMS_SQL.VARCHAR2_TABLE;
207: gIPTemplateLineIds DBMS_SQL.NUMBER_TABLE;
208: gIPInventoryItemIds DBMS_SQL.NUMBER_TABLE;
209: gIPMtlCategoryIds DBMS_SQL.NUMBER_TABLE;
210: gIPOrgIds DBMS_SQL.NUMBER_TABLE;
211: gIPSearchTypes DBMS_SQL.VARCHAR2_TABLE;
212: gIPUnitPrices DBMS_SQL.NUMBER_TABLE;
205: gIPContractLineIds DBMS_SQL.NUMBER_TABLE;
206: gIPTemplateIds DBMS_SQL.VARCHAR2_TABLE;
207: gIPTemplateLineIds DBMS_SQL.NUMBER_TABLE;
208: gIPInventoryItemIds DBMS_SQL.NUMBER_TABLE;
209: gIPMtlCategoryIds DBMS_SQL.NUMBER_TABLE;
210: gIPOrgIds DBMS_SQL.NUMBER_TABLE;
211: gIPSearchTypes DBMS_SQL.VARCHAR2_TABLE;
212: gIPUnitPrices DBMS_SQL.NUMBER_TABLE;
213: --FPJ FPSL Extractor Changes
206: gIPTemplateIds DBMS_SQL.VARCHAR2_TABLE;
207: gIPTemplateLineIds DBMS_SQL.NUMBER_TABLE;
208: gIPInventoryItemIds DBMS_SQL.NUMBER_TABLE;
209: gIPMtlCategoryIds DBMS_SQL.NUMBER_TABLE;
210: gIPOrgIds DBMS_SQL.NUMBER_TABLE;
211: gIPSearchTypes DBMS_SQL.VARCHAR2_TABLE;
212: gIPUnitPrices DBMS_SQL.NUMBER_TABLE;
213: --FPJ FPSL Extractor Changes
214: gIPValueBasis DBMS_SQL.VARCHAR2_TABLE;
207: gIPTemplateLineIds DBMS_SQL.NUMBER_TABLE;
208: gIPInventoryItemIds DBMS_SQL.NUMBER_TABLE;
209: gIPMtlCategoryIds DBMS_SQL.NUMBER_TABLE;
210: gIPOrgIds DBMS_SQL.NUMBER_TABLE;
211: gIPSearchTypes DBMS_SQL.VARCHAR2_TABLE;
212: gIPUnitPrices DBMS_SQL.NUMBER_TABLE;
213: --FPJ FPSL Extractor Changes
214: gIPValueBasis DBMS_SQL.VARCHAR2_TABLE;
215: gIPPurchaseBasis DBMS_SQL.VARCHAR2_TABLE;
208: gIPInventoryItemIds DBMS_SQL.NUMBER_TABLE;
209: gIPMtlCategoryIds DBMS_SQL.NUMBER_TABLE;
210: gIPOrgIds DBMS_SQL.NUMBER_TABLE;
211: gIPSearchTypes DBMS_SQL.VARCHAR2_TABLE;
212: gIPUnitPrices DBMS_SQL.NUMBER_TABLE;
213: --FPJ FPSL Extractor Changes
214: gIPValueBasis DBMS_SQL.VARCHAR2_TABLE;
215: gIPPurchaseBasis DBMS_SQL.VARCHAR2_TABLE;
216: gIPAllowPriceOverrideFlag DBMS_SQL.VARCHAR2_TABLE;
210: gIPOrgIds DBMS_SQL.NUMBER_TABLE;
211: gIPSearchTypes DBMS_SQL.VARCHAR2_TABLE;
212: gIPUnitPrices DBMS_SQL.NUMBER_TABLE;
213: --FPJ FPSL Extractor Changes
214: gIPValueBasis DBMS_SQL.VARCHAR2_TABLE;
215: gIPPurchaseBasis DBMS_SQL.VARCHAR2_TABLE;
216: gIPAllowPriceOverrideFlag DBMS_SQL.VARCHAR2_TABLE;
217: gIPNotToExceedPrice DBMS_SQL.NUMBER_TABLE;
218: -- FPJ Bug# 3007068 sosingha: Extractor Changes For Kit Support Project
211: gIPSearchTypes DBMS_SQL.VARCHAR2_TABLE;
212: gIPUnitPrices DBMS_SQL.NUMBER_TABLE;
213: --FPJ FPSL Extractor Changes
214: gIPValueBasis DBMS_SQL.VARCHAR2_TABLE;
215: gIPPurchaseBasis DBMS_SQL.VARCHAR2_TABLE;
216: gIPAllowPriceOverrideFlag DBMS_SQL.VARCHAR2_TABLE;
217: gIPNotToExceedPrice DBMS_SQL.NUMBER_TABLE;
218: -- FPJ Bug# 3007068 sosingha: Extractor Changes For Kit Support Project
219: gIPSuggestedQuantities DBMS_SQL.NUMBER_TABLE;
212: gIPUnitPrices DBMS_SQL.NUMBER_TABLE;
213: --FPJ FPSL Extractor Changes
214: gIPValueBasis DBMS_SQL.VARCHAR2_TABLE;
215: gIPPurchaseBasis DBMS_SQL.VARCHAR2_TABLE;
216: gIPAllowPriceOverrideFlag DBMS_SQL.VARCHAR2_TABLE;
217: gIPNotToExceedPrice DBMS_SQL.NUMBER_TABLE;
218: -- FPJ Bug# 3007068 sosingha: Extractor Changes For Kit Support Project
219: gIPSuggestedQuantities DBMS_SQL.NUMBER_TABLE;
220: -- FPJ Bug# 3110297 jingyu Add negotiated flag
213: --FPJ FPSL Extractor Changes
214: gIPValueBasis DBMS_SQL.VARCHAR2_TABLE;
215: gIPPurchaseBasis DBMS_SQL.VARCHAR2_TABLE;
216: gIPAllowPriceOverrideFlag DBMS_SQL.VARCHAR2_TABLE;
217: gIPNotToExceedPrice DBMS_SQL.NUMBER_TABLE;
218: -- FPJ Bug# 3007068 sosingha: Extractor Changes For Kit Support Project
219: gIPSuggestedQuantities DBMS_SQL.NUMBER_TABLE;
220: -- FPJ Bug# 3110297 jingyu Add negotiated flag
221: gIPNegotiatedFlag DBMS_SQL.VARCHAR2_TABLE;
215: gIPPurchaseBasis DBMS_SQL.VARCHAR2_TABLE;
216: gIPAllowPriceOverrideFlag DBMS_SQL.VARCHAR2_TABLE;
217: gIPNotToExceedPrice DBMS_SQL.NUMBER_TABLE;
218: -- FPJ Bug# 3007068 sosingha: Extractor Changes For Kit Support Project
219: gIPSuggestedQuantities DBMS_SQL.NUMBER_TABLE;
220: -- FPJ Bug# 3110297 jingyu Add negotiated flag
221: gIPNegotiatedFlag DBMS_SQL.VARCHAR2_TABLE;
222: gIPCurrencys DBMS_SQL.VARCHAR2_TABLE;
223: gIPUnitOfMeasures DBMS_SQL.VARCHAR2_TABLE;
217: gIPNotToExceedPrice DBMS_SQL.NUMBER_TABLE;
218: -- FPJ Bug# 3007068 sosingha: Extractor Changes For Kit Support Project
219: gIPSuggestedQuantities DBMS_SQL.NUMBER_TABLE;
220: -- FPJ Bug# 3110297 jingyu Add negotiated flag
221: gIPNegotiatedFlag DBMS_SQL.VARCHAR2_TABLE;
222: gIPCurrencys DBMS_SQL.VARCHAR2_TABLE;
223: gIPUnitOfMeasures DBMS_SQL.VARCHAR2_TABLE;
224: gIPFunctionalPrices DBMS_SQL.NUMBER_TABLE;
225: gIPSupplierSiteCodes DBMS_SQL.VARCHAR2_TABLE;
218: -- FPJ Bug# 3007068 sosingha: Extractor Changes For Kit Support Project
219: gIPSuggestedQuantities DBMS_SQL.NUMBER_TABLE;
220: -- FPJ Bug# 3110297 jingyu Add negotiated flag
221: gIPNegotiatedFlag DBMS_SQL.VARCHAR2_TABLE;
222: gIPCurrencys DBMS_SQL.VARCHAR2_TABLE;
223: gIPUnitOfMeasures DBMS_SQL.VARCHAR2_TABLE;
224: gIPFunctionalPrices DBMS_SQL.NUMBER_TABLE;
225: gIPSupplierSiteCodes DBMS_SQL.VARCHAR2_TABLE;
226: gIPContractNums DBMS_SQL.VARCHAR2_TABLE;
219: gIPSuggestedQuantities DBMS_SQL.NUMBER_TABLE;
220: -- FPJ Bug# 3110297 jingyu Add negotiated flag
221: gIPNegotiatedFlag DBMS_SQL.VARCHAR2_TABLE;
222: gIPCurrencys DBMS_SQL.VARCHAR2_TABLE;
223: gIPUnitOfMeasures DBMS_SQL.VARCHAR2_TABLE;
224: gIPFunctionalPrices DBMS_SQL.NUMBER_TABLE;
225: gIPSupplierSiteCodes DBMS_SQL.VARCHAR2_TABLE;
226: gIPContractNums DBMS_SQL.VARCHAR2_TABLE;
227: gIPContractLineNums DBMS_SQL.NUMBER_TABLE;
220: -- FPJ Bug# 3110297 jingyu Add negotiated flag
221: gIPNegotiatedFlag DBMS_SQL.VARCHAR2_TABLE;
222: gIPCurrencys DBMS_SQL.VARCHAR2_TABLE;
223: gIPUnitOfMeasures DBMS_SQL.VARCHAR2_TABLE;
224: gIPFunctionalPrices DBMS_SQL.NUMBER_TABLE;
225: gIPSupplierSiteCodes DBMS_SQL.VARCHAR2_TABLE;
226: gIPContractNums DBMS_SQL.VARCHAR2_TABLE;
227: gIPContractLineNums DBMS_SQL.NUMBER_TABLE;
228: gIpRateTypes DBMS_SQL.VARCHAR2_TABLE;
221: gIPNegotiatedFlag DBMS_SQL.VARCHAR2_TABLE;
222: gIPCurrencys DBMS_SQL.VARCHAR2_TABLE;
223: gIPUnitOfMeasures DBMS_SQL.VARCHAR2_TABLE;
224: gIPFunctionalPrices DBMS_SQL.NUMBER_TABLE;
225: gIPSupplierSiteCodes DBMS_SQL.VARCHAR2_TABLE;
226: gIPContractNums DBMS_SQL.VARCHAR2_TABLE;
227: gIPContractLineNums DBMS_SQL.NUMBER_TABLE;
228: gIpRateTypes DBMS_SQL.VARCHAR2_TABLE;
229: gIpRateDates DBMS_SQL.DATE_TABLE;
222: gIPCurrencys DBMS_SQL.VARCHAR2_TABLE;
223: gIPUnitOfMeasures DBMS_SQL.VARCHAR2_TABLE;
224: gIPFunctionalPrices DBMS_SQL.NUMBER_TABLE;
225: gIPSupplierSiteCodes DBMS_SQL.VARCHAR2_TABLE;
226: gIPContractNums DBMS_SQL.VARCHAR2_TABLE;
227: gIPContractLineNums DBMS_SQL.NUMBER_TABLE;
228: gIpRateTypes DBMS_SQL.VARCHAR2_TABLE;
229: gIpRateDates DBMS_SQL.DATE_TABLE;
230: gIpRates DBMS_SQL.NUMBER_TABLE;
223: gIPUnitOfMeasures DBMS_SQL.VARCHAR2_TABLE;
224: gIPFunctionalPrices DBMS_SQL.NUMBER_TABLE;
225: gIPSupplierSiteCodes DBMS_SQL.VARCHAR2_TABLE;
226: gIPContractNums DBMS_SQL.VARCHAR2_TABLE;
227: gIPContractLineNums DBMS_SQL.NUMBER_TABLE;
228: gIpRateTypes DBMS_SQL.VARCHAR2_TABLE;
229: gIpRateDates DBMS_SQL.DATE_TABLE;
230: gIpRates DBMS_SQL.NUMBER_TABLE;
231: gIpSupplierNumbers DBMS_SQL.VARCHAR2_TABLE;
224: gIPFunctionalPrices DBMS_SQL.NUMBER_TABLE;
225: gIPSupplierSiteCodes DBMS_SQL.VARCHAR2_TABLE;
226: gIPContractNums DBMS_SQL.VARCHAR2_TABLE;
227: gIPContractLineNums DBMS_SQL.NUMBER_TABLE;
228: gIpRateTypes DBMS_SQL.VARCHAR2_TABLE;
229: gIpRateDates DBMS_SQL.DATE_TABLE;
230: gIpRates DBMS_SQL.NUMBER_TABLE;
231: gIpSupplierNumbers DBMS_SQL.VARCHAR2_TABLE;
232: gIpSupplierContactIds DBMS_SQL.NUMBER_TABLE;
225: gIPSupplierSiteCodes DBMS_SQL.VARCHAR2_TABLE;
226: gIPContractNums DBMS_SQL.VARCHAR2_TABLE;
227: gIPContractLineNums DBMS_SQL.NUMBER_TABLE;
228: gIpRateTypes DBMS_SQL.VARCHAR2_TABLE;
229: gIpRateDates DBMS_SQL.DATE_TABLE;
230: gIpRates DBMS_SQL.NUMBER_TABLE;
231: gIpSupplierNumbers DBMS_SQL.VARCHAR2_TABLE;
232: gIpSupplierContactIds DBMS_SQL.NUMBER_TABLE;
233: gIpItemRevisions DBMS_SQL.VARCHAR2_TABLE;
226: gIPContractNums DBMS_SQL.VARCHAR2_TABLE;
227: gIPContractLineNums DBMS_SQL.NUMBER_TABLE;
228: gIpRateTypes DBMS_SQL.VARCHAR2_TABLE;
229: gIpRateDates DBMS_SQL.DATE_TABLE;
230: gIpRates DBMS_SQL.NUMBER_TABLE;
231: gIpSupplierNumbers DBMS_SQL.VARCHAR2_TABLE;
232: gIpSupplierContactIds DBMS_SQL.NUMBER_TABLE;
233: gIpItemRevisions DBMS_SQL.VARCHAR2_TABLE;
234: gIpLineTypeIds DBMS_SQL.NUMBER_TABLE;
227: gIPContractLineNums DBMS_SQL.NUMBER_TABLE;
228: gIpRateTypes DBMS_SQL.VARCHAR2_TABLE;
229: gIpRateDates DBMS_SQL.DATE_TABLE;
230: gIpRates DBMS_SQL.NUMBER_TABLE;
231: gIpSupplierNumbers DBMS_SQL.VARCHAR2_TABLE;
232: gIpSupplierContactIds DBMS_SQL.NUMBER_TABLE;
233: gIpItemRevisions DBMS_SQL.VARCHAR2_TABLE;
234: gIpLineTypeIds DBMS_SQL.NUMBER_TABLE;
235: gIpBuyerIds DBMS_SQL.NUMBER_TABLE;
228: gIpRateTypes DBMS_SQL.VARCHAR2_TABLE;
229: gIpRateDates DBMS_SQL.DATE_TABLE;
230: gIpRates DBMS_SQL.NUMBER_TABLE;
231: gIpSupplierNumbers DBMS_SQL.VARCHAR2_TABLE;
232: gIpSupplierContactIds DBMS_SQL.NUMBER_TABLE;
233: gIpItemRevisions DBMS_SQL.VARCHAR2_TABLE;
234: gIpLineTypeIds DBMS_SQL.NUMBER_TABLE;
235: gIpBuyerIds DBMS_SQL.NUMBER_TABLE;
236: gIPActiveFlags DBMS_SQL.VARCHAR2_TABLE;
229: gIpRateDates DBMS_SQL.DATE_TABLE;
230: gIpRates DBMS_SQL.NUMBER_TABLE;
231: gIpSupplierNumbers DBMS_SQL.VARCHAR2_TABLE;
232: gIpSupplierContactIds DBMS_SQL.NUMBER_TABLE;
233: gIpItemRevisions DBMS_SQL.VARCHAR2_TABLE;
234: gIpLineTypeIds DBMS_SQL.NUMBER_TABLE;
235: gIpBuyerIds DBMS_SQL.NUMBER_TABLE;
236: gIPActiveFlags DBMS_SQL.VARCHAR2_TABLE;
237: gIPLastUpdateDates DBMS_SQL.DATE_TABLE;
230: gIpRates DBMS_SQL.NUMBER_TABLE;
231: gIpSupplierNumbers DBMS_SQL.VARCHAR2_TABLE;
232: gIpSupplierContactIds DBMS_SQL.NUMBER_TABLE;
233: gIpItemRevisions DBMS_SQL.VARCHAR2_TABLE;
234: gIpLineTypeIds DBMS_SQL.NUMBER_TABLE;
235: gIpBuyerIds DBMS_SQL.NUMBER_TABLE;
236: gIPActiveFlags DBMS_SQL.VARCHAR2_TABLE;
237: gIPLastUpdateDates DBMS_SQL.DATE_TABLE;
238:
231: gIpSupplierNumbers DBMS_SQL.VARCHAR2_TABLE;
232: gIpSupplierContactIds DBMS_SQL.NUMBER_TABLE;
233: gIpItemRevisions DBMS_SQL.VARCHAR2_TABLE;
234: gIpLineTypeIds DBMS_SQL.NUMBER_TABLE;
235: gIpBuyerIds DBMS_SQL.NUMBER_TABLE;
236: gIPActiveFlags DBMS_SQL.VARCHAR2_TABLE;
237: gIPLastUpdateDates DBMS_SQL.DATE_TABLE;
238:
239: -- Insert ICX_CAT_ITEMS_B
232: gIpSupplierContactIds DBMS_SQL.NUMBER_TABLE;
233: gIpItemRevisions DBMS_SQL.VARCHAR2_TABLE;
234: gIpLineTypeIds DBMS_SQL.NUMBER_TABLE;
235: gIpBuyerIds DBMS_SQL.NUMBER_TABLE;
236: gIPActiveFlags DBMS_SQL.VARCHAR2_TABLE;
237: gIPLastUpdateDates DBMS_SQL.DATE_TABLE;
238:
239: -- Insert ICX_CAT_ITEMS_B
240: gIBRtItemIds DBMS_SQL.NUMBER_TABLE;
233: gIpItemRevisions DBMS_SQL.VARCHAR2_TABLE;
234: gIpLineTypeIds DBMS_SQL.NUMBER_TABLE;
235: gIpBuyerIds DBMS_SQL.NUMBER_TABLE;
236: gIPActiveFlags DBMS_SQL.VARCHAR2_TABLE;
237: gIPLastUpdateDates DBMS_SQL.DATE_TABLE;
238:
239: -- Insert ICX_CAT_ITEMS_B
240: gIBRtItemIds DBMS_SQL.NUMBER_TABLE;
241: gIBOrgIds DBMS_SQL.NUMBER_TABLE;
236: gIPActiveFlags DBMS_SQL.VARCHAR2_TABLE;
237: gIPLastUpdateDates DBMS_SQL.DATE_TABLE;
238:
239: -- Insert ICX_CAT_ITEMS_B
240: gIBRtItemIds DBMS_SQL.NUMBER_TABLE;
241: gIBOrgIds DBMS_SQL.NUMBER_TABLE;
242: gIBSupplierIds DBMS_SQL.NUMBER_TABLE;
243: gIBSuppliers DBMS_SQL.VARCHAR2_TABLE;
244: gIBSupplierPartNums DBMS_SQL.VARCHAR2_TABLE;
237: gIPLastUpdateDates DBMS_SQL.DATE_TABLE;
238:
239: -- Insert ICX_CAT_ITEMS_B
240: gIBRtItemIds DBMS_SQL.NUMBER_TABLE;
241: gIBOrgIds DBMS_SQL.NUMBER_TABLE;
242: gIBSupplierIds DBMS_SQL.NUMBER_TABLE;
243: gIBSuppliers DBMS_SQL.VARCHAR2_TABLE;
244: gIBSupplierPartNums DBMS_SQL.VARCHAR2_TABLE;
245: gIBInternalItemIds DBMS_SQL.NUMBER_TABLE;
238:
239: -- Insert ICX_CAT_ITEMS_B
240: gIBRtItemIds DBMS_SQL.NUMBER_TABLE;
241: gIBOrgIds DBMS_SQL.NUMBER_TABLE;
242: gIBSupplierIds DBMS_SQL.NUMBER_TABLE;
243: gIBSuppliers DBMS_SQL.VARCHAR2_TABLE;
244: gIBSupplierPartNums DBMS_SQL.VARCHAR2_TABLE;
245: gIBInternalItemIds DBMS_SQL.NUMBER_TABLE;
246: gIBInternalItemNums DBMS_SQL.VARCHAR2_TABLE;
239: -- Insert ICX_CAT_ITEMS_B
240: gIBRtItemIds DBMS_SQL.NUMBER_TABLE;
241: gIBOrgIds DBMS_SQL.NUMBER_TABLE;
242: gIBSupplierIds DBMS_SQL.NUMBER_TABLE;
243: gIBSuppliers DBMS_SQL.VARCHAR2_TABLE;
244: gIBSupplierPartNums DBMS_SQL.VARCHAR2_TABLE;
245: gIBInternalItemIds DBMS_SQL.NUMBER_TABLE;
246: gIBInternalItemNums DBMS_SQL.VARCHAR2_TABLE;
247:
240: gIBRtItemIds DBMS_SQL.NUMBER_TABLE;
241: gIBOrgIds DBMS_SQL.NUMBER_TABLE;
242: gIBSupplierIds DBMS_SQL.NUMBER_TABLE;
243: gIBSuppliers DBMS_SQL.VARCHAR2_TABLE;
244: gIBSupplierPartNums DBMS_SQL.VARCHAR2_TABLE;
245: gIBInternalItemIds DBMS_SQL.NUMBER_TABLE;
246: gIBInternalItemNums DBMS_SQL.VARCHAR2_TABLE;
247:
248: -- Update ICX_CAT_ITEMS_B
241: gIBOrgIds DBMS_SQL.NUMBER_TABLE;
242: gIBSupplierIds DBMS_SQL.NUMBER_TABLE;
243: gIBSuppliers DBMS_SQL.VARCHAR2_TABLE;
244: gIBSupplierPartNums DBMS_SQL.VARCHAR2_TABLE;
245: gIBInternalItemIds DBMS_SQL.NUMBER_TABLE;
246: gIBInternalItemNums DBMS_SQL.VARCHAR2_TABLE;
247:
248: -- Update ICX_CAT_ITEMS_B
249: gUBRtItemIds DBMS_SQL.NUMBER_TABLE;
242: gIBSupplierIds DBMS_SQL.NUMBER_TABLE;
243: gIBSuppliers DBMS_SQL.VARCHAR2_TABLE;
244: gIBSupplierPartNums DBMS_SQL.VARCHAR2_TABLE;
245: gIBInternalItemIds DBMS_SQL.NUMBER_TABLE;
246: gIBInternalItemNums DBMS_SQL.VARCHAR2_TABLE;
247:
248: -- Update ICX_CAT_ITEMS_B
249: gUBRtItemIds DBMS_SQL.NUMBER_TABLE;
250: gUBInternalItemNums DBMS_SQL.VARCHAR2_TABLE;
245: gIBInternalItemIds DBMS_SQL.NUMBER_TABLE;
246: gIBInternalItemNums DBMS_SQL.VARCHAR2_TABLE;
247:
248: -- Update ICX_CAT_ITEMS_B
249: gUBRtItemIds DBMS_SQL.NUMBER_TABLE;
250: gUBInternalItemNums DBMS_SQL.VARCHAR2_TABLE;
251: gUBExtractorUpdatedFlags DBMS_SQL.VARCHAR2_TABLE;
252: gUBJobNumbers DBMS_SQL.NUMBER_TABLE;
253:
246: gIBInternalItemNums DBMS_SQL.VARCHAR2_TABLE;
247:
248: -- Update ICX_CAT_ITEMS_B
249: gUBRtItemIds DBMS_SQL.NUMBER_TABLE;
250: gUBInternalItemNums DBMS_SQL.VARCHAR2_TABLE;
251: gUBExtractorUpdatedFlags DBMS_SQL.VARCHAR2_TABLE;
252: gUBJobNumbers DBMS_SQL.NUMBER_TABLE;
253:
254: -- Insert ICX_CAT_ITEMS_TLP
247:
248: -- Update ICX_CAT_ITEMS_B
249: gUBRtItemIds DBMS_SQL.NUMBER_TABLE;
250: gUBInternalItemNums DBMS_SQL.VARCHAR2_TABLE;
251: gUBExtractorUpdatedFlags DBMS_SQL.VARCHAR2_TABLE;
252: gUBJobNumbers DBMS_SQL.NUMBER_TABLE;
253:
254: -- Insert ICX_CAT_ITEMS_TLP
255: gITRtItemIds DBMS_SQL.NUMBER_TABLE;
248: -- Update ICX_CAT_ITEMS_B
249: gUBRtItemIds DBMS_SQL.NUMBER_TABLE;
250: gUBInternalItemNums DBMS_SQL.VARCHAR2_TABLE;
251: gUBExtractorUpdatedFlags DBMS_SQL.VARCHAR2_TABLE;
252: gUBJobNumbers DBMS_SQL.NUMBER_TABLE;
253:
254: -- Insert ICX_CAT_ITEMS_TLP
255: gITRtItemIds DBMS_SQL.NUMBER_TABLE;
256: gITLanguages DBMS_SQL.VARCHAR2_TABLE;
251: gUBExtractorUpdatedFlags DBMS_SQL.VARCHAR2_TABLE;
252: gUBJobNumbers DBMS_SQL.NUMBER_TABLE;
253:
254: -- Insert ICX_CAT_ITEMS_TLP
255: gITRtItemIds DBMS_SQL.NUMBER_TABLE;
256: gITLanguages DBMS_SQL.VARCHAR2_TABLE;
257: gITOrgIds DBMS_SQL.NUMBER_TABLE;
258: gITSupplierIds DBMS_SQL.NUMBER_TABLE;
259: gITItemSourceTypes DBMS_SQL.VARCHAR2_TABLE;
252: gUBJobNumbers DBMS_SQL.NUMBER_TABLE;
253:
254: -- Insert ICX_CAT_ITEMS_TLP
255: gITRtItemIds DBMS_SQL.NUMBER_TABLE;
256: gITLanguages DBMS_SQL.VARCHAR2_TABLE;
257: gITOrgIds DBMS_SQL.NUMBER_TABLE;
258: gITSupplierIds DBMS_SQL.NUMBER_TABLE;
259: gITItemSourceTypes DBMS_SQL.VARCHAR2_TABLE;
260: gITSearchTypes DBMS_SQL.VARCHAR2_TABLE;
253:
254: -- Insert ICX_CAT_ITEMS_TLP
255: gITRtItemIds DBMS_SQL.NUMBER_TABLE;
256: gITLanguages DBMS_SQL.VARCHAR2_TABLE;
257: gITOrgIds DBMS_SQL.NUMBER_TABLE;
258: gITSupplierIds DBMS_SQL.NUMBER_TABLE;
259: gITItemSourceTypes DBMS_SQL.VARCHAR2_TABLE;
260: gITSearchTypes DBMS_SQL.VARCHAR2_TABLE;
261: gITPrimaryCategoryIds DBMS_SQL.NUMBER_TABLE;
254: -- Insert ICX_CAT_ITEMS_TLP
255: gITRtItemIds DBMS_SQL.NUMBER_TABLE;
256: gITLanguages DBMS_SQL.VARCHAR2_TABLE;
257: gITOrgIds DBMS_SQL.NUMBER_TABLE;
258: gITSupplierIds DBMS_SQL.NUMBER_TABLE;
259: gITItemSourceTypes DBMS_SQL.VARCHAR2_TABLE;
260: gITSearchTypes DBMS_SQL.VARCHAR2_TABLE;
261: gITPrimaryCategoryIds DBMS_SQL.NUMBER_TABLE;
262: gITPrimaryCategoryNames DBMS_SQL.VARCHAR2_TABLE;
255: gITRtItemIds DBMS_SQL.NUMBER_TABLE;
256: gITLanguages DBMS_SQL.VARCHAR2_TABLE;
257: gITOrgIds DBMS_SQL.NUMBER_TABLE;
258: gITSupplierIds DBMS_SQL.NUMBER_TABLE;
259: gITItemSourceTypes DBMS_SQL.VARCHAR2_TABLE;
260: gITSearchTypes DBMS_SQL.VARCHAR2_TABLE;
261: gITPrimaryCategoryIds DBMS_SQL.NUMBER_TABLE;
262: gITPrimaryCategoryNames DBMS_SQL.VARCHAR2_TABLE;
263: gITInternalItemIds DBMS_SQL.NUMBER_TABLE;
256: gITLanguages DBMS_SQL.VARCHAR2_TABLE;
257: gITOrgIds DBMS_SQL.NUMBER_TABLE;
258: gITSupplierIds DBMS_SQL.NUMBER_TABLE;
259: gITItemSourceTypes DBMS_SQL.VARCHAR2_TABLE;
260: gITSearchTypes DBMS_SQL.VARCHAR2_TABLE;
261: gITPrimaryCategoryIds DBMS_SQL.NUMBER_TABLE;
262: gITPrimaryCategoryNames DBMS_SQL.VARCHAR2_TABLE;
263: gITInternalItemIds DBMS_SQL.NUMBER_TABLE;
264: gITInternalItemNums DBMS_SQL.VARCHAR2_TABLE;
257: gITOrgIds DBMS_SQL.NUMBER_TABLE;
258: gITSupplierIds DBMS_SQL.NUMBER_TABLE;
259: gITItemSourceTypes DBMS_SQL.VARCHAR2_TABLE;
260: gITSearchTypes DBMS_SQL.VARCHAR2_TABLE;
261: gITPrimaryCategoryIds DBMS_SQL.NUMBER_TABLE;
262: gITPrimaryCategoryNames DBMS_SQL.VARCHAR2_TABLE;
263: gITInternalItemIds DBMS_SQL.NUMBER_TABLE;
264: gITInternalItemNums DBMS_SQL.VARCHAR2_TABLE;
265: gITSuppliers DBMS_SQL.VARCHAR2_TABLE;
258: gITSupplierIds DBMS_SQL.NUMBER_TABLE;
259: gITItemSourceTypes DBMS_SQL.VARCHAR2_TABLE;
260: gITSearchTypes DBMS_SQL.VARCHAR2_TABLE;
261: gITPrimaryCategoryIds DBMS_SQL.NUMBER_TABLE;
262: gITPrimaryCategoryNames DBMS_SQL.VARCHAR2_TABLE;
263: gITInternalItemIds DBMS_SQL.NUMBER_TABLE;
264: gITInternalItemNums DBMS_SQL.VARCHAR2_TABLE;
265: gITSuppliers DBMS_SQL.VARCHAR2_TABLE;
266: gITSupplierPartNums DBMS_SQL.VARCHAR2_TABLE;
259: gITItemSourceTypes DBMS_SQL.VARCHAR2_TABLE;
260: gITSearchTypes DBMS_SQL.VARCHAR2_TABLE;
261: gITPrimaryCategoryIds DBMS_SQL.NUMBER_TABLE;
262: gITPrimaryCategoryNames DBMS_SQL.VARCHAR2_TABLE;
263: gITInternalItemIds DBMS_SQL.NUMBER_TABLE;
264: gITInternalItemNums DBMS_SQL.VARCHAR2_TABLE;
265: gITSuppliers DBMS_SQL.VARCHAR2_TABLE;
266: gITSupplierPartNums DBMS_SQL.VARCHAR2_TABLE;
267: gITDescriptions DBMS_SQL.VARCHAR2_TABLE;
260: gITSearchTypes DBMS_SQL.VARCHAR2_TABLE;
261: gITPrimaryCategoryIds DBMS_SQL.NUMBER_TABLE;
262: gITPrimaryCategoryNames DBMS_SQL.VARCHAR2_TABLE;
263: gITInternalItemIds DBMS_SQL.NUMBER_TABLE;
264: gITInternalItemNums DBMS_SQL.VARCHAR2_TABLE;
265: gITSuppliers DBMS_SQL.VARCHAR2_TABLE;
266: gITSupplierPartNums DBMS_SQL.VARCHAR2_TABLE;
267: gITDescriptions DBMS_SQL.VARCHAR2_TABLE;
268: gITPictures DBMS_SQL.VARCHAR2_TABLE;
261: gITPrimaryCategoryIds DBMS_SQL.NUMBER_TABLE;
262: gITPrimaryCategoryNames DBMS_SQL.VARCHAR2_TABLE;
263: gITInternalItemIds DBMS_SQL.NUMBER_TABLE;
264: gITInternalItemNums DBMS_SQL.VARCHAR2_TABLE;
265: gITSuppliers DBMS_SQL.VARCHAR2_TABLE;
266: gITSupplierPartNums DBMS_SQL.VARCHAR2_TABLE;
267: gITDescriptions DBMS_SQL.VARCHAR2_TABLE;
268: gITPictures DBMS_SQL.VARCHAR2_TABLE;
269: gITPictureURLs DBMS_SQL.VARCHAR2_TABLE;
262: gITPrimaryCategoryNames DBMS_SQL.VARCHAR2_TABLE;
263: gITInternalItemIds DBMS_SQL.NUMBER_TABLE;
264: gITInternalItemNums DBMS_SQL.VARCHAR2_TABLE;
265: gITSuppliers DBMS_SQL.VARCHAR2_TABLE;
266: gITSupplierPartNums DBMS_SQL.VARCHAR2_TABLE;
267: gITDescriptions DBMS_SQL.VARCHAR2_TABLE;
268: gITPictures DBMS_SQL.VARCHAR2_TABLE;
269: gITPictureURLs DBMS_SQL.VARCHAR2_TABLE;
270: gITManufacturers DBMS_SQL.VARCHAR2_TABLE;
263: gITInternalItemIds DBMS_SQL.NUMBER_TABLE;
264: gITInternalItemNums DBMS_SQL.VARCHAR2_TABLE;
265: gITSuppliers DBMS_SQL.VARCHAR2_TABLE;
266: gITSupplierPartNums DBMS_SQL.VARCHAR2_TABLE;
267: gITDescriptions DBMS_SQL.VARCHAR2_TABLE;
268: gITPictures DBMS_SQL.VARCHAR2_TABLE;
269: gITPictureURLs DBMS_SQL.VARCHAR2_TABLE;
270: gITManufacturers DBMS_SQL.VARCHAR2_TABLE;
271: gITManufacturerPartNums DBMS_SQL.VARCHAR2_TABLE;
264: gITInternalItemNums DBMS_SQL.VARCHAR2_TABLE;
265: gITSuppliers DBMS_SQL.VARCHAR2_TABLE;
266: gITSupplierPartNums DBMS_SQL.VARCHAR2_TABLE;
267: gITDescriptions DBMS_SQL.VARCHAR2_TABLE;
268: gITPictures DBMS_SQL.VARCHAR2_TABLE;
269: gITPictureURLs DBMS_SQL.VARCHAR2_TABLE;
270: gITManufacturers DBMS_SQL.VARCHAR2_TABLE;
271: gITManufacturerPartNums DBMS_SQL.VARCHAR2_TABLE;
272:
265: gITSuppliers DBMS_SQL.VARCHAR2_TABLE;
266: gITSupplierPartNums DBMS_SQL.VARCHAR2_TABLE;
267: gITDescriptions DBMS_SQL.VARCHAR2_TABLE;
268: gITPictures DBMS_SQL.VARCHAR2_TABLE;
269: gITPictureURLs DBMS_SQL.VARCHAR2_TABLE;
270: gITManufacturers DBMS_SQL.VARCHAR2_TABLE;
271: gITManufacturerPartNums DBMS_SQL.VARCHAR2_TABLE;
272:
273: -- Update ICX_CAT_ITEMS_TLP
266: gITSupplierPartNums DBMS_SQL.VARCHAR2_TABLE;
267: gITDescriptions DBMS_SQL.VARCHAR2_TABLE;
268: gITPictures DBMS_SQL.VARCHAR2_TABLE;
269: gITPictureURLs DBMS_SQL.VARCHAR2_TABLE;
270: gITManufacturers DBMS_SQL.VARCHAR2_TABLE;
271: gITManufacturerPartNums DBMS_SQL.VARCHAR2_TABLE;
272:
273: -- Update ICX_CAT_ITEMS_TLP
274: gUTRtItemIds DBMS_SQL.NUMBER_TABLE;
267: gITDescriptions DBMS_SQL.VARCHAR2_TABLE;
268: gITPictures DBMS_SQL.VARCHAR2_TABLE;
269: gITPictureURLs DBMS_SQL.VARCHAR2_TABLE;
270: gITManufacturers DBMS_SQL.VARCHAR2_TABLE;
271: gITManufacturerPartNums DBMS_SQL.VARCHAR2_TABLE;
272:
273: -- Update ICX_CAT_ITEMS_TLP
274: gUTRtItemIds DBMS_SQL.NUMBER_TABLE;
275: gUTLanguages DBMS_SQL.VARCHAR2_TABLE;
270: gITManufacturers DBMS_SQL.VARCHAR2_TABLE;
271: gITManufacturerPartNums DBMS_SQL.VARCHAR2_TABLE;
272:
273: -- Update ICX_CAT_ITEMS_TLP
274: gUTRtItemIds DBMS_SQL.NUMBER_TABLE;
275: gUTLanguages DBMS_SQL.VARCHAR2_TABLE;
276: gUTItemSourceTypes DBMS_SQL.VARCHAR2_TABLE;
277: gUTSearchTypes DBMS_SQL.VARCHAR2_TABLE;
278: gUTPrimaryCategoryIds DBMS_SQL.NUMBER_TABLE;
271: gITManufacturerPartNums DBMS_SQL.VARCHAR2_TABLE;
272:
273: -- Update ICX_CAT_ITEMS_TLP
274: gUTRtItemIds DBMS_SQL.NUMBER_TABLE;
275: gUTLanguages DBMS_SQL.VARCHAR2_TABLE;
276: gUTItemSourceTypes DBMS_SQL.VARCHAR2_TABLE;
277: gUTSearchTypes DBMS_SQL.VARCHAR2_TABLE;
278: gUTPrimaryCategoryIds DBMS_SQL.NUMBER_TABLE;
279: gUTPrimaryCategoryNames DBMS_SQL.VARCHAR2_TABLE;
272:
273: -- Update ICX_CAT_ITEMS_TLP
274: gUTRtItemIds DBMS_SQL.NUMBER_TABLE;
275: gUTLanguages DBMS_SQL.VARCHAR2_TABLE;
276: gUTItemSourceTypes DBMS_SQL.VARCHAR2_TABLE;
277: gUTSearchTypes DBMS_SQL.VARCHAR2_TABLE;
278: gUTPrimaryCategoryIds DBMS_SQL.NUMBER_TABLE;
279: gUTPrimaryCategoryNames DBMS_SQL.VARCHAR2_TABLE;
280: gUTInternalItemNums DBMS_SQL.VARCHAR2_TABLE;
273: -- Update ICX_CAT_ITEMS_TLP
274: gUTRtItemIds DBMS_SQL.NUMBER_TABLE;
275: gUTLanguages DBMS_SQL.VARCHAR2_TABLE;
276: gUTItemSourceTypes DBMS_SQL.VARCHAR2_TABLE;
277: gUTSearchTypes DBMS_SQL.VARCHAR2_TABLE;
278: gUTPrimaryCategoryIds DBMS_SQL.NUMBER_TABLE;
279: gUTPrimaryCategoryNames DBMS_SQL.VARCHAR2_TABLE;
280: gUTInternalItemNums DBMS_SQL.VARCHAR2_TABLE;
281: gUTDescriptions DBMS_SQL.VARCHAR2_TABLE;
274: gUTRtItemIds DBMS_SQL.NUMBER_TABLE;
275: gUTLanguages DBMS_SQL.VARCHAR2_TABLE;
276: gUTItemSourceTypes DBMS_SQL.VARCHAR2_TABLE;
277: gUTSearchTypes DBMS_SQL.VARCHAR2_TABLE;
278: gUTPrimaryCategoryIds DBMS_SQL.NUMBER_TABLE;
279: gUTPrimaryCategoryNames DBMS_SQL.VARCHAR2_TABLE;
280: gUTInternalItemNums DBMS_SQL.VARCHAR2_TABLE;
281: gUTDescriptions DBMS_SQL.VARCHAR2_TABLE;
282: gUTPictures DBMS_SQL.VARCHAR2_TABLE;
275: gUTLanguages DBMS_SQL.VARCHAR2_TABLE;
276: gUTItemSourceTypes DBMS_SQL.VARCHAR2_TABLE;
277: gUTSearchTypes DBMS_SQL.VARCHAR2_TABLE;
278: gUTPrimaryCategoryIds DBMS_SQL.NUMBER_TABLE;
279: gUTPrimaryCategoryNames DBMS_SQL.VARCHAR2_TABLE;
280: gUTInternalItemNums DBMS_SQL.VARCHAR2_TABLE;
281: gUTDescriptions DBMS_SQL.VARCHAR2_TABLE;
282: gUTPictures DBMS_SQL.VARCHAR2_TABLE;
283: gUTPictureURLs DBMS_SQL.VARCHAR2_TABLE;
276: gUTItemSourceTypes DBMS_SQL.VARCHAR2_TABLE;
277: gUTSearchTypes DBMS_SQL.VARCHAR2_TABLE;
278: gUTPrimaryCategoryIds DBMS_SQL.NUMBER_TABLE;
279: gUTPrimaryCategoryNames DBMS_SQL.VARCHAR2_TABLE;
280: gUTInternalItemNums DBMS_SQL.VARCHAR2_TABLE;
281: gUTDescriptions DBMS_SQL.VARCHAR2_TABLE;
282: gUTPictures DBMS_SQL.VARCHAR2_TABLE;
283: gUTPictureURLs DBMS_SQL.VARCHAR2_TABLE;
284: gUTManufacturers DBMS_SQL.VARCHAR2_TABLE;
277: gUTSearchTypes DBMS_SQL.VARCHAR2_TABLE;
278: gUTPrimaryCategoryIds DBMS_SQL.NUMBER_TABLE;
279: gUTPrimaryCategoryNames DBMS_SQL.VARCHAR2_TABLE;
280: gUTInternalItemNums DBMS_SQL.VARCHAR2_TABLE;
281: gUTDescriptions DBMS_SQL.VARCHAR2_TABLE;
282: gUTPictures DBMS_SQL.VARCHAR2_TABLE;
283: gUTPictureURLs DBMS_SQL.VARCHAR2_TABLE;
284: gUTManufacturers DBMS_SQL.VARCHAR2_TABLE;
285: gUTManufacturerPartNums DBMS_SQL.VARCHAR2_TABLE;
278: gUTPrimaryCategoryIds DBMS_SQL.NUMBER_TABLE;
279: gUTPrimaryCategoryNames DBMS_SQL.VARCHAR2_TABLE;
280: gUTInternalItemNums DBMS_SQL.VARCHAR2_TABLE;
281: gUTDescriptions DBMS_SQL.VARCHAR2_TABLE;
282: gUTPictures DBMS_SQL.VARCHAR2_TABLE;
283: gUTPictureURLs DBMS_SQL.VARCHAR2_TABLE;
284: gUTManufacturers DBMS_SQL.VARCHAR2_TABLE;
285: gUTManufacturerPartNums DBMS_SQL.VARCHAR2_TABLE;
286:
279: gUTPrimaryCategoryNames DBMS_SQL.VARCHAR2_TABLE;
280: gUTInternalItemNums DBMS_SQL.VARCHAR2_TABLE;
281: gUTDescriptions DBMS_SQL.VARCHAR2_TABLE;
282: gUTPictures DBMS_SQL.VARCHAR2_TABLE;
283: gUTPictureURLs DBMS_SQL.VARCHAR2_TABLE;
284: gUTManufacturers DBMS_SQL.VARCHAR2_TABLE;
285: gUTManufacturerPartNums DBMS_SQL.VARCHAR2_TABLE;
286:
287: -- Insert ICX_CAT_CATEGORY_ITEMS
280: gUTInternalItemNums DBMS_SQL.VARCHAR2_TABLE;
281: gUTDescriptions DBMS_SQL.VARCHAR2_TABLE;
282: gUTPictures DBMS_SQL.VARCHAR2_TABLE;
283: gUTPictureURLs DBMS_SQL.VARCHAR2_TABLE;
284: gUTManufacturers DBMS_SQL.VARCHAR2_TABLE;
285: gUTManufacturerPartNums DBMS_SQL.VARCHAR2_TABLE;
286:
287: -- Insert ICX_CAT_CATEGORY_ITEMS
288: gICRtItemIds DBMS_SQL.NUMBER_TABLE;
281: gUTDescriptions DBMS_SQL.VARCHAR2_TABLE;
282: gUTPictures DBMS_SQL.VARCHAR2_TABLE;
283: gUTPictureURLs DBMS_SQL.VARCHAR2_TABLE;
284: gUTManufacturers DBMS_SQL.VARCHAR2_TABLE;
285: gUTManufacturerPartNums DBMS_SQL.VARCHAR2_TABLE;
286:
287: -- Insert ICX_CAT_CATEGORY_ITEMS
288: gICRtItemIds DBMS_SQL.NUMBER_TABLE;
289: gICRtCategoryIds DBMS_SQL.NUMBER_TABLE;
284: gUTManufacturers DBMS_SQL.VARCHAR2_TABLE;
285: gUTManufacturerPartNums DBMS_SQL.VARCHAR2_TABLE;
286:
287: -- Insert ICX_CAT_CATEGORY_ITEMS
288: gICRtItemIds DBMS_SQL.NUMBER_TABLE;
289: gICRtCategoryIds DBMS_SQL.NUMBER_TABLE;
290:
291: -- Update ICX_CAT_CATEGORY_ITEMS
292: gUCRtItemIds DBMS_SQL.NUMBER_TABLE;
285: gUTManufacturerPartNums DBMS_SQL.VARCHAR2_TABLE;
286:
287: -- Insert ICX_CAT_CATEGORY_ITEMS
288: gICRtItemIds DBMS_SQL.NUMBER_TABLE;
289: gICRtCategoryIds DBMS_SQL.NUMBER_TABLE;
290:
291: -- Update ICX_CAT_CATEGORY_ITEMS
292: gUCRtItemIds DBMS_SQL.NUMBER_TABLE;
293: gUCRtCategoryIds DBMS_SQL.NUMBER_TABLE;
288: gICRtItemIds DBMS_SQL.NUMBER_TABLE;
289: gICRtCategoryIds DBMS_SQL.NUMBER_TABLE;
290:
291: -- Update ICX_CAT_CATEGORY_ITEMS
292: gUCRtItemIds DBMS_SQL.NUMBER_TABLE;
293: gUCRtCategoryIds DBMS_SQL.NUMBER_TABLE;
294: gUCOldRtCategoryIds DBMS_SQL.NUMBER_TABLE;
295:
296: -- Insert ICX_CAT_EXT_ITEMS_TLP
289: gICRtCategoryIds DBMS_SQL.NUMBER_TABLE;
290:
291: -- Update ICX_CAT_CATEGORY_ITEMS
292: gUCRtItemIds DBMS_SQL.NUMBER_TABLE;
293: gUCRtCategoryIds DBMS_SQL.NUMBER_TABLE;
294: gUCOldRtCategoryIds DBMS_SQL.NUMBER_TABLE;
295:
296: -- Insert ICX_CAT_EXT_ITEMS_TLP
297: gIERtItemIds DBMS_SQL.NUMBER_TABLE;
290:
291: -- Update ICX_CAT_CATEGORY_ITEMS
292: gUCRtItemIds DBMS_SQL.NUMBER_TABLE;
293: gUCRtCategoryIds DBMS_SQL.NUMBER_TABLE;
294: gUCOldRtCategoryIds DBMS_SQL.NUMBER_TABLE;
295:
296: -- Insert ICX_CAT_EXT_ITEMS_TLP
297: gIERtItemIds DBMS_SQL.NUMBER_TABLE;
298: -- bug 2925403
293: gUCRtCategoryIds DBMS_SQL.NUMBER_TABLE;
294: gUCOldRtCategoryIds DBMS_SQL.NUMBER_TABLE;
295:
296: -- Insert ICX_CAT_EXT_ITEMS_TLP
297: gIERtItemIds DBMS_SQL.NUMBER_TABLE;
298: -- bug 2925403
299: gIELanguages DBMS_SQL.VARCHAR2_TABLE;
300: gIEOrgIds DBMS_SQL.NUMBER_TABLE;
301: gIERtCategoryIds DBMS_SQL.NUMBER_TABLE;
295:
296: -- Insert ICX_CAT_EXT_ITEMS_TLP
297: gIERtItemIds DBMS_SQL.NUMBER_TABLE;
298: -- bug 2925403
299: gIELanguages DBMS_SQL.VARCHAR2_TABLE;
300: gIEOrgIds DBMS_SQL.NUMBER_TABLE;
301: gIERtCategoryIds DBMS_SQL.NUMBER_TABLE;
302:
303: -- Update ICX_CAT_EXT_ITEMS_TLP
296: -- Insert ICX_CAT_EXT_ITEMS_TLP
297: gIERtItemIds DBMS_SQL.NUMBER_TABLE;
298: -- bug 2925403
299: gIELanguages DBMS_SQL.VARCHAR2_TABLE;
300: gIEOrgIds DBMS_SQL.NUMBER_TABLE;
301: gIERtCategoryIds DBMS_SQL.NUMBER_TABLE;
302:
303: -- Update ICX_CAT_EXT_ITEMS_TLP
304: gUERtItemIds DBMS_SQL.NUMBER_TABLE;
297: gIERtItemIds DBMS_SQL.NUMBER_TABLE;
298: -- bug 2925403
299: gIELanguages DBMS_SQL.VARCHAR2_TABLE;
300: gIEOrgIds DBMS_SQL.NUMBER_TABLE;
301: gIERtCategoryIds DBMS_SQL.NUMBER_TABLE;
302:
303: -- Update ICX_CAT_EXT_ITEMS_TLP
304: gUERtItemIds DBMS_SQL.NUMBER_TABLE;
305: -- bug 2925403
300: gIEOrgIds DBMS_SQL.NUMBER_TABLE;
301: gIERtCategoryIds DBMS_SQL.NUMBER_TABLE;
302:
303: -- Update ICX_CAT_EXT_ITEMS_TLP
304: gUERtItemIds DBMS_SQL.NUMBER_TABLE;
305: -- bug 2925403
306: gUELanguages DBMS_SQL.VARCHAR2_TABLE;
307: gUERtCategoryIds DBMS_SQL.NUMBER_TABLE;
308: gUEOldRtCategoryIds DBMS_SQL.NUMBER_TABLE;
302:
303: -- Update ICX_CAT_EXT_ITEMS_TLP
304: gUERtItemIds DBMS_SQL.NUMBER_TABLE;
305: -- bug 2925403
306: gUELanguages DBMS_SQL.VARCHAR2_TABLE;
307: gUERtCategoryIds DBMS_SQL.NUMBER_TABLE;
308: gUEOldRtCategoryIds DBMS_SQL.NUMBER_TABLE;
309:
310: -- Insert temporary table to cleanup item
303: -- Update ICX_CAT_EXT_ITEMS_TLP
304: gUERtItemIds DBMS_SQL.NUMBER_TABLE;
305: -- bug 2925403
306: gUELanguages DBMS_SQL.VARCHAR2_TABLE;
307: gUERtCategoryIds DBMS_SQL.NUMBER_TABLE;
308: gUEOldRtCategoryIds DBMS_SQL.NUMBER_TABLE;
309:
310: -- Insert temporary table to cleanup item
311: gCIRtItemIds DBMS_SQL.NUMBER_TABLE;
304: gUERtItemIds DBMS_SQL.NUMBER_TABLE;
305: -- bug 2925403
306: gUELanguages DBMS_SQL.VARCHAR2_TABLE;
307: gUERtCategoryIds DBMS_SQL.NUMBER_TABLE;
308: gUEOldRtCategoryIds DBMS_SQL.NUMBER_TABLE;
309:
310: -- Insert temporary table to cleanup item
311: gCIRtItemIds DBMS_SQL.NUMBER_TABLE;
312:
307: gUERtCategoryIds DBMS_SQL.NUMBER_TABLE;
308: gUEOldRtCategoryIds DBMS_SQL.NUMBER_TABLE;
309:
310: -- Insert temporary table to cleanup item
311: gCIRtItemIds DBMS_SQL.NUMBER_TABLE;
312:
313: -- Insert temporary table to update global agreement
314: gUGAContractIds DBMS_SQL.NUMBER_TABLE;
315: gUGAContractLineIds DBMS_SQL.NUMBER_TABLE;
310: -- Insert temporary table to cleanup item
311: gCIRtItemIds DBMS_SQL.NUMBER_TABLE;
312:
313: -- Insert temporary table to update global agreement
314: gUGAContractIds DBMS_SQL.NUMBER_TABLE;
315: gUGAContractLineIds DBMS_SQL.NUMBER_TABLE;
316:
317: -- Insert temporary table to set active_flag
318: gTARtItemIds DBMS_SQL.NUMBER_TABLE;
311: gCIRtItemIds DBMS_SQL.NUMBER_TABLE;
312:
313: -- Insert temporary table to update global agreement
314: gUGAContractIds DBMS_SQL.NUMBER_TABLE;
315: gUGAContractLineIds DBMS_SQL.NUMBER_TABLE;
316:
317: -- Insert temporary table to set active_flag
318: gTARtItemIds DBMS_SQL.NUMBER_TABLE;
319: gTAInvItemIds DBMS_SQL.NUMBER_TABLE;
314: gUGAContractIds DBMS_SQL.NUMBER_TABLE;
315: gUGAContractLineIds DBMS_SQL.NUMBER_TABLE;
316:
317: -- Insert temporary table to set active_flag
318: gTARtItemIds DBMS_SQL.NUMBER_TABLE;
319: gTAInvItemIds DBMS_SQL.NUMBER_TABLE;
320: gTAInvOrgIds DBMS_SQL.NUMBER_TABLE;
321:
322: -- Delete Item Prices
315: gUGAContractLineIds DBMS_SQL.NUMBER_TABLE;
316:
317: -- Insert temporary table to set active_flag
318: gTARtItemIds DBMS_SQL.NUMBER_TABLE;
319: gTAInvItemIds DBMS_SQL.NUMBER_TABLE;
320: gTAInvOrgIds DBMS_SQL.NUMBER_TABLE;
321:
322: -- Delete Item Prices
323: gDPRowIds DBMS_SQL.UROWID_TABLE;
316:
317: -- Insert temporary table to set active_flag
318: gTARtItemIds DBMS_SQL.NUMBER_TABLE;
319: gTAInvItemIds DBMS_SQL.NUMBER_TABLE;
320: gTAInvOrgIds DBMS_SQL.NUMBER_TABLE;
321:
322: -- Delete Item Prices
323: gDPRowIds DBMS_SQL.UROWID_TABLE;
324: gDPTemplateCategoryIds DBMS_SQL.NUMBER_TABLE;
319: gTAInvItemIds DBMS_SQL.NUMBER_TABLE;
320: gTAInvOrgIds DBMS_SQL.NUMBER_TABLE;
321:
322: -- Delete Item Prices
323: gDPRowIds DBMS_SQL.UROWID_TABLE;
324: gDPTemplateCategoryIds DBMS_SQL.NUMBER_TABLE;
325: gDPRtItemIds DBMS_SQL.NUMBER_TABLE;
326: gDPInventoryItemIds DBMS_SQL.NUMBER_TABLE;
327: gDPOrgIds DBMS_SQL.NUMBER_TABLE;
320: gTAInvOrgIds DBMS_SQL.NUMBER_TABLE;
321:
322: -- Delete Item Prices
323: gDPRowIds DBMS_SQL.UROWID_TABLE;
324: gDPTemplateCategoryIds DBMS_SQL.NUMBER_TABLE;
325: gDPRtItemIds DBMS_SQL.NUMBER_TABLE;
326: gDPInventoryItemIds DBMS_SQL.NUMBER_TABLE;
327: gDPOrgIds DBMS_SQL.NUMBER_TABLE;
328: gDPLocalRtItemIds DBMS_SQL.NUMBER_TABLE;
321:
322: -- Delete Item Prices
323: gDPRowIds DBMS_SQL.UROWID_TABLE;
324: gDPTemplateCategoryIds DBMS_SQL.NUMBER_TABLE;
325: gDPRtItemIds DBMS_SQL.NUMBER_TABLE;
326: gDPInventoryItemIds DBMS_SQL.NUMBER_TABLE;
327: gDPOrgIds DBMS_SQL.NUMBER_TABLE;
328: gDPLocalRtItemIds DBMS_SQL.NUMBER_TABLE;
329:
322: -- Delete Item Prices
323: gDPRowIds DBMS_SQL.UROWID_TABLE;
324: gDPTemplateCategoryIds DBMS_SQL.NUMBER_TABLE;
325: gDPRtItemIds DBMS_SQL.NUMBER_TABLE;
326: gDPInventoryItemIds DBMS_SQL.NUMBER_TABLE;
327: gDPOrgIds DBMS_SQL.NUMBER_TABLE;
328: gDPLocalRtItemIds DBMS_SQL.NUMBER_TABLE;
329:
330: -- Delete Item Prices for global agreement
323: gDPRowIds DBMS_SQL.UROWID_TABLE;
324: gDPTemplateCategoryIds DBMS_SQL.NUMBER_TABLE;
325: gDPRtItemIds DBMS_SQL.NUMBER_TABLE;
326: gDPInventoryItemIds DBMS_SQL.NUMBER_TABLE;
327: gDPOrgIds DBMS_SQL.NUMBER_TABLE;
328: gDPLocalRtItemIds DBMS_SQL.NUMBER_TABLE;
329:
330: -- Delete Item Prices for global agreement
331: gDPGContractIds DBMS_SQL.NUMBER_TABLE;
324: gDPTemplateCategoryIds DBMS_SQL.NUMBER_TABLE;
325: gDPRtItemIds DBMS_SQL.NUMBER_TABLE;
326: gDPInventoryItemIds DBMS_SQL.NUMBER_TABLE;
327: gDPOrgIds DBMS_SQL.NUMBER_TABLE;
328: gDPLocalRtItemIds DBMS_SQL.NUMBER_TABLE;
329:
330: -- Delete Item Prices for global agreement
331: gDPGContractIds DBMS_SQL.NUMBER_TABLE;
332: gDPGContractLineIds DBMS_SQL.NUMBER_TABLE;
327: gDPOrgIds DBMS_SQL.NUMBER_TABLE;
328: gDPLocalRtItemIds DBMS_SQL.NUMBER_TABLE;
329:
330: -- Delete Item Prices for global agreement
331: gDPGContractIds DBMS_SQL.NUMBER_TABLE;
332: gDPGContractLineIds DBMS_SQL.NUMBER_TABLE;
333:
334: -- Delete Item
335: gDIPurchasingItemIds DBMS_SQL.NUMBER_TABLE;
328: gDPLocalRtItemIds DBMS_SQL.NUMBER_TABLE;
329:
330: -- Delete Item Prices for global agreement
331: gDPGContractIds DBMS_SQL.NUMBER_TABLE;
332: gDPGContractLineIds DBMS_SQL.NUMBER_TABLE;
333:
334: -- Delete Item
335: gDIPurchasingItemIds DBMS_SQL.NUMBER_TABLE;
336: gDIPurchasingOrgIds DBMS_SQL.NUMBER_TABLE;
331: gDPGContractIds DBMS_SQL.NUMBER_TABLE;
332: gDPGContractLineIds DBMS_SQL.NUMBER_TABLE;
333:
334: -- Delete Item
335: gDIPurchasingItemIds DBMS_SQL.NUMBER_TABLE;
336: gDIPurchasingOrgIds DBMS_SQL.NUMBER_TABLE;
337: gDINullPriceItemIds DBMS_SQL.NUMBER_TABLE;
338: gDINullPriceOrgIds DBMS_SQL.NUMBER_TABLE;
339: gDIInternalItemIds DBMS_SQL.NUMBER_TABLE;
332: gDPGContractLineIds DBMS_SQL.NUMBER_TABLE;
333:
334: -- Delete Item
335: gDIPurchasingItemIds DBMS_SQL.NUMBER_TABLE;
336: gDIPurchasingOrgIds DBMS_SQL.NUMBER_TABLE;
337: gDINullPriceItemIds DBMS_SQL.NUMBER_TABLE;
338: gDINullPriceOrgIds DBMS_SQL.NUMBER_TABLE;
339: gDIInternalItemIds DBMS_SQL.NUMBER_TABLE;
340: gDIInternalOrgIds DBMS_SQL.NUMBER_TABLE;
333:
334: -- Delete Item
335: gDIPurchasingItemIds DBMS_SQL.NUMBER_TABLE;
336: gDIPurchasingOrgIds DBMS_SQL.NUMBER_TABLE;
337: gDINullPriceItemIds DBMS_SQL.NUMBER_TABLE;
338: gDINullPriceOrgIds DBMS_SQL.NUMBER_TABLE;
339: gDIInternalItemIds DBMS_SQL.NUMBER_TABLE;
340: gDIInternalOrgIds DBMS_SQL.NUMBER_TABLE;
341:
334: -- Delete Item
335: gDIPurchasingItemIds DBMS_SQL.NUMBER_TABLE;
336: gDIPurchasingOrgIds DBMS_SQL.NUMBER_TABLE;
337: gDINullPriceItemIds DBMS_SQL.NUMBER_TABLE;
338: gDINullPriceOrgIds DBMS_SQL.NUMBER_TABLE;
339: gDIInternalItemIds DBMS_SQL.NUMBER_TABLE;
340: gDIInternalOrgIds DBMS_SQL.NUMBER_TABLE;
341:
342: -- Delete Item without price
335: gDIPurchasingItemIds DBMS_SQL.NUMBER_TABLE;
336: gDIPurchasingOrgIds DBMS_SQL.NUMBER_TABLE;
337: gDINullPriceItemIds DBMS_SQL.NUMBER_TABLE;
338: gDINullPriceOrgIds DBMS_SQL.NUMBER_TABLE;
339: gDIInternalItemIds DBMS_SQL.NUMBER_TABLE;
340: gDIInternalOrgIds DBMS_SQL.NUMBER_TABLE;
341:
342: -- Delete Item without price
343: gDIRtItemIds DBMS_SQL.NUMBER_TABLE;
336: gDIPurchasingOrgIds DBMS_SQL.NUMBER_TABLE;
337: gDINullPriceItemIds DBMS_SQL.NUMBER_TABLE;
338: gDINullPriceOrgIds DBMS_SQL.NUMBER_TABLE;
339: gDIInternalItemIds DBMS_SQL.NUMBER_TABLE;
340: gDIInternalOrgIds DBMS_SQL.NUMBER_TABLE;
341:
342: -- Delete Item without price
343: gDIRtItemIds DBMS_SQL.NUMBER_TABLE;
344:
339: gDIInternalItemIds DBMS_SQL.NUMBER_TABLE;
340: gDIInternalOrgIds DBMS_SQL.NUMBER_TABLE;
341:
342: -- Delete Item without price
343: gDIRtItemIds DBMS_SQL.NUMBER_TABLE;
344:
345: -- Set active flag
346: gSAPriceTypes DBMS_SQL.VARCHAR2_TABLE;
347: gSARtItemIds DBMS_SQL.NUMBER_TABLE;
342: -- Delete Item without price
343: gDIRtItemIds DBMS_SQL.NUMBER_TABLE;
344:
345: -- Set active flag
346: gSAPriceTypes DBMS_SQL.VARCHAR2_TABLE;
347: gSARtItemIds DBMS_SQL.NUMBER_TABLE;
348: gSARowIds DBMS_SQL.UROWID_TABLE;
349: gSAActiveFlags DBMS_SQL.VARCHAR2_TABLE;
350:
343: gDIRtItemIds DBMS_SQL.NUMBER_TABLE;
344:
345: -- Set active flag
346: gSAPriceTypes DBMS_SQL.VARCHAR2_TABLE;
347: gSARtItemIds DBMS_SQL.NUMBER_TABLE;
348: gSARowIds DBMS_SQL.UROWID_TABLE;
349: gSAActiveFlags DBMS_SQL.VARCHAR2_TABLE;
350:
351: -- Set item source type
344:
345: -- Set active flag
346: gSAPriceTypes DBMS_SQL.VARCHAR2_TABLE;
347: gSARtItemIds DBMS_SQL.NUMBER_TABLE;
348: gSARowIds DBMS_SQL.UROWID_TABLE;
349: gSAActiveFlags DBMS_SQL.VARCHAR2_TABLE;
350:
351: -- Set item source type
352: gSIITRtItemIds DBMS_SQL.NUMBER_TABLE;
345: -- Set active flag
346: gSAPriceTypes DBMS_SQL.VARCHAR2_TABLE;
347: gSARtItemIds DBMS_SQL.NUMBER_TABLE;
348: gSARowIds DBMS_SQL.UROWID_TABLE;
349: gSAActiveFlags DBMS_SQL.VARCHAR2_TABLE;
350:
351: -- Set item source type
352: gSIITRtItemIds DBMS_SQL.NUMBER_TABLE;
353: gSITRtItemIds DBMS_SQL.NUMBER_TABLE;
348: gSARowIds DBMS_SQL.UROWID_TABLE;
349: gSAActiveFlags DBMS_SQL.VARCHAR2_TABLE;
350:
351: -- Set item source type
352: gSIITRtItemIds DBMS_SQL.NUMBER_TABLE;
353: gSITRtItemIds DBMS_SQL.NUMBER_TABLE;
354:
355: -- Update ICX_CAT_ITEM_PRICES for local global agreements
356: gUPGASupplierSiteIds DBMS_SQL.NUMBER_TABLE;
349: gSAActiveFlags DBMS_SQL.VARCHAR2_TABLE;
350:
351: -- Set item source type
352: gSIITRtItemIds DBMS_SQL.NUMBER_TABLE;
353: gSITRtItemIds DBMS_SQL.NUMBER_TABLE;
354:
355: -- Update ICX_CAT_ITEM_PRICES for local global agreements
356: gUPGASupplierSiteIds DBMS_SQL.NUMBER_TABLE;
357: gUPGAContractIds DBMS_SQL.NUMBER_TABLE;
352: gSIITRtItemIds DBMS_SQL.NUMBER_TABLE;
353: gSITRtItemIds DBMS_SQL.NUMBER_TABLE;
354:
355: -- Update ICX_CAT_ITEM_PRICES for local global agreements
356: gUPGASupplierSiteIds DBMS_SQL.NUMBER_TABLE;
357: gUPGAContractIds DBMS_SQL.NUMBER_TABLE;
358: gUPGAContractLineIds DBMS_SQL.NUMBER_TABLE;
359: gUPGAFunctionalPrices DBMS_SQL.NUMBER_TABLE;
360: gUPGASupplierSiteCodes DBMS_SQL.VARCHAR2_TABLE;
353: gSITRtItemIds DBMS_SQL.NUMBER_TABLE;
354:
355: -- Update ICX_CAT_ITEM_PRICES for local global agreements
356: gUPGASupplierSiteIds DBMS_SQL.NUMBER_TABLE;
357: gUPGAContractIds DBMS_SQL.NUMBER_TABLE;
358: gUPGAContractLineIds DBMS_SQL.NUMBER_TABLE;
359: gUPGAFunctionalPrices DBMS_SQL.NUMBER_TABLE;
360: gUPGASupplierSiteCodes DBMS_SQL.VARCHAR2_TABLE;
361: -- bug 2912717: populate line_type, rate info. for GA
354:
355: -- Update ICX_CAT_ITEM_PRICES for local global agreements
356: gUPGASupplierSiteIds DBMS_SQL.NUMBER_TABLE;
357: gUPGAContractIds DBMS_SQL.NUMBER_TABLE;
358: gUPGAContractLineIds DBMS_SQL.NUMBER_TABLE;
359: gUPGAFunctionalPrices DBMS_SQL.NUMBER_TABLE;
360: gUPGASupplierSiteCodes DBMS_SQL.VARCHAR2_TABLE;
361: -- bug 2912717: populate line_type, rate info. for GA
362: gUPGALineTypeIds DBMS_SQL.NUMBER_TABLE;
355: -- Update ICX_CAT_ITEM_PRICES for local global agreements
356: gUPGASupplierSiteIds DBMS_SQL.NUMBER_TABLE;
357: gUPGAContractIds DBMS_SQL.NUMBER_TABLE;
358: gUPGAContractLineIds DBMS_SQL.NUMBER_TABLE;
359: gUPGAFunctionalPrices DBMS_SQL.NUMBER_TABLE;
360: gUPGASupplierSiteCodes DBMS_SQL.VARCHAR2_TABLE;
361: -- bug 2912717: populate line_type, rate info. for GA
362: gUPGALineTypeIds DBMS_SQL.NUMBER_TABLE;
363: gUPGARateTypes DBMS_SQL.VARCHAR2_TABLE;
356: gUPGASupplierSiteIds DBMS_SQL.NUMBER_TABLE;
357: gUPGAContractIds DBMS_SQL.NUMBER_TABLE;
358: gUPGAContractLineIds DBMS_SQL.NUMBER_TABLE;
359: gUPGAFunctionalPrices DBMS_SQL.NUMBER_TABLE;
360: gUPGASupplierSiteCodes DBMS_SQL.VARCHAR2_TABLE;
361: -- bug 2912717: populate line_type, rate info. for GA
362: gUPGALineTypeIds DBMS_SQL.NUMBER_TABLE;
363: gUPGARateTypes DBMS_SQL.VARCHAR2_TABLE;
364: gUPGARateDates DBMS_SQL.DATE_TABLE;
358: gUPGAContractLineIds DBMS_SQL.NUMBER_TABLE;
359: gUPGAFunctionalPrices DBMS_SQL.NUMBER_TABLE;
360: gUPGASupplierSiteCodes DBMS_SQL.VARCHAR2_TABLE;
361: -- bug 2912717: populate line_type, rate info. for GA
362: gUPGALineTypeIds DBMS_SQL.NUMBER_TABLE;
363: gUPGARateTypes DBMS_SQL.VARCHAR2_TABLE;
364: gUPGARateDates DBMS_SQL.DATE_TABLE;
365: gUPGARates DBMS_SQL.NUMBER_TABLE;
366: -- bug 3298502: Enabled Org Ids
359: gUPGAFunctionalPrices DBMS_SQL.NUMBER_TABLE;
360: gUPGASupplierSiteCodes DBMS_SQL.VARCHAR2_TABLE;
361: -- bug 2912717: populate line_type, rate info. for GA
362: gUPGALineTypeIds DBMS_SQL.NUMBER_TABLE;
363: gUPGARateTypes DBMS_SQL.VARCHAR2_TABLE;
364: gUPGARateDates DBMS_SQL.DATE_TABLE;
365: gUPGARates DBMS_SQL.NUMBER_TABLE;
366: -- bug 3298502: Enabled Org Ids
367: gUPGAOrgIds DBMS_SQL.NUMBER_TABLE;
360: gUPGASupplierSiteCodes DBMS_SQL.VARCHAR2_TABLE;
361: -- bug 2912717: populate line_type, rate info. for GA
362: gUPGALineTypeIds DBMS_SQL.NUMBER_TABLE;
363: gUPGARateTypes DBMS_SQL.VARCHAR2_TABLE;
364: gUPGARateDates DBMS_SQL.DATE_TABLE;
365: gUPGARates DBMS_SQL.NUMBER_TABLE;
366: -- bug 3298502: Enabled Org Ids
367: gUPGAOrgIds DBMS_SQL.NUMBER_TABLE;
368:
361: -- bug 2912717: populate line_type, rate info. for GA
362: gUPGALineTypeIds DBMS_SQL.NUMBER_TABLE;
363: gUPGARateTypes DBMS_SQL.VARCHAR2_TABLE;
364: gUPGARateDates DBMS_SQL.DATE_TABLE;
365: gUPGARates DBMS_SQL.NUMBER_TABLE;
366: -- bug 3298502: Enabled Org Ids
367: gUPGAOrgIds DBMS_SQL.NUMBER_TABLE;
368:
369: -- Insert ICX_CAT_ITEM_PRICES for local global agreements
363: gUPGARateTypes DBMS_SQL.VARCHAR2_TABLE;
364: gUPGARateDates DBMS_SQL.DATE_TABLE;
365: gUPGARates DBMS_SQL.NUMBER_TABLE;
366: -- bug 3298502: Enabled Org Ids
367: gUPGAOrgIds DBMS_SQL.NUMBER_TABLE;
368:
369: -- Insert ICX_CAT_ITEM_PRICES for local global agreements
370: gIPGARtItemIds DBMS_SQL.NUMBER_TABLE;
371: gIPGALocalRtItemIds DBMS_SQL.NUMBER_TABLE;
366: -- bug 3298502: Enabled Org Ids
367: gUPGAOrgIds DBMS_SQL.NUMBER_TABLE;
368:
369: -- Insert ICX_CAT_ITEM_PRICES for local global agreements
370: gIPGARtItemIds DBMS_SQL.NUMBER_TABLE;
371: gIPGALocalRtItemIds DBMS_SQL.NUMBER_TABLE;
372: gIPGASupplierSiteIds DBMS_SQL.NUMBER_TABLE;
373: gIPGAContractIds DBMS_SQL.NUMBER_TABLE;
374: gIPGAContractLineIds DBMS_SQL.NUMBER_TABLE;
367: gUPGAOrgIds DBMS_SQL.NUMBER_TABLE;
368:
369: -- Insert ICX_CAT_ITEM_PRICES for local global agreements
370: gIPGARtItemIds DBMS_SQL.NUMBER_TABLE;
371: gIPGALocalRtItemIds DBMS_SQL.NUMBER_TABLE;
372: gIPGASupplierSiteIds DBMS_SQL.NUMBER_TABLE;
373: gIPGAContractIds DBMS_SQL.NUMBER_TABLE;
374: gIPGAContractLineIds DBMS_SQL.NUMBER_TABLE;
375: gIPGAInventoryItemIds DBMS_SQL.NUMBER_TABLE;
368:
369: -- Insert ICX_CAT_ITEM_PRICES for local global agreements
370: gIPGARtItemIds DBMS_SQL.NUMBER_TABLE;
371: gIPGALocalRtItemIds DBMS_SQL.NUMBER_TABLE;
372: gIPGASupplierSiteIds DBMS_SQL.NUMBER_TABLE;
373: gIPGAContractIds DBMS_SQL.NUMBER_TABLE;
374: gIPGAContractLineIds DBMS_SQL.NUMBER_TABLE;
375: gIPGAInventoryItemIds DBMS_SQL.NUMBER_TABLE;
376: gIPGAMtlCategoryIds DBMS_SQL.NUMBER_TABLE;
369: -- Insert ICX_CAT_ITEM_PRICES for local global agreements
370: gIPGARtItemIds DBMS_SQL.NUMBER_TABLE;
371: gIPGALocalRtItemIds DBMS_SQL.NUMBER_TABLE;
372: gIPGASupplierSiteIds DBMS_SQL.NUMBER_TABLE;
373: gIPGAContractIds DBMS_SQL.NUMBER_TABLE;
374: gIPGAContractLineIds DBMS_SQL.NUMBER_TABLE;
375: gIPGAInventoryItemIds DBMS_SQL.NUMBER_TABLE;
376: gIPGAMtlCategoryIds DBMS_SQL.NUMBER_TABLE;
377: gIPGAOrgIds DBMS_SQL.NUMBER_TABLE;
370: gIPGARtItemIds DBMS_SQL.NUMBER_TABLE;
371: gIPGALocalRtItemIds DBMS_SQL.NUMBER_TABLE;
372: gIPGASupplierSiteIds DBMS_SQL.NUMBER_TABLE;
373: gIPGAContractIds DBMS_SQL.NUMBER_TABLE;
374: gIPGAContractLineIds DBMS_SQL.NUMBER_TABLE;
375: gIPGAInventoryItemIds DBMS_SQL.NUMBER_TABLE;
376: gIPGAMtlCategoryIds DBMS_SQL.NUMBER_TABLE;
377: gIPGAOrgIds DBMS_SQL.NUMBER_TABLE;
378: gIPGAUnitPrices DBMS_SQL.NUMBER_TABLE;
371: gIPGALocalRtItemIds DBMS_SQL.NUMBER_TABLE;
372: gIPGASupplierSiteIds DBMS_SQL.NUMBER_TABLE;
373: gIPGAContractIds DBMS_SQL.NUMBER_TABLE;
374: gIPGAContractLineIds DBMS_SQL.NUMBER_TABLE;
375: gIPGAInventoryItemIds DBMS_SQL.NUMBER_TABLE;
376: gIPGAMtlCategoryIds DBMS_SQL.NUMBER_TABLE;
377: gIPGAOrgIds DBMS_SQL.NUMBER_TABLE;
378: gIPGAUnitPrices DBMS_SQL.NUMBER_TABLE;
379: --FPJ FPSL Extractor Changes
372: gIPGASupplierSiteIds DBMS_SQL.NUMBER_TABLE;
373: gIPGAContractIds DBMS_SQL.NUMBER_TABLE;
374: gIPGAContractLineIds DBMS_SQL.NUMBER_TABLE;
375: gIPGAInventoryItemIds DBMS_SQL.NUMBER_TABLE;
376: gIPGAMtlCategoryIds DBMS_SQL.NUMBER_TABLE;
377: gIPGAOrgIds DBMS_SQL.NUMBER_TABLE;
378: gIPGAUnitPrices DBMS_SQL.NUMBER_TABLE;
379: --FPJ FPSL Extractor Changes
380: gIPGAValueBasis DBMS_SQL.VARCHAR2_TABLE;
373: gIPGAContractIds DBMS_SQL.NUMBER_TABLE;
374: gIPGAContractLineIds DBMS_SQL.NUMBER_TABLE;
375: gIPGAInventoryItemIds DBMS_SQL.NUMBER_TABLE;
376: gIPGAMtlCategoryIds DBMS_SQL.NUMBER_TABLE;
377: gIPGAOrgIds DBMS_SQL.NUMBER_TABLE;
378: gIPGAUnitPrices DBMS_SQL.NUMBER_TABLE;
379: --FPJ FPSL Extractor Changes
380: gIPGAValueBasis DBMS_SQL.VARCHAR2_TABLE;
381: gIPGAPurchaseBasis DBMS_SQL.VARCHAR2_TABLE;
374: gIPGAContractLineIds DBMS_SQL.NUMBER_TABLE;
375: gIPGAInventoryItemIds DBMS_SQL.NUMBER_TABLE;
376: gIPGAMtlCategoryIds DBMS_SQL.NUMBER_TABLE;
377: gIPGAOrgIds DBMS_SQL.NUMBER_TABLE;
378: gIPGAUnitPrices DBMS_SQL.NUMBER_TABLE;
379: --FPJ FPSL Extractor Changes
380: gIPGAValueBasis DBMS_SQL.VARCHAR2_TABLE;
381: gIPGAPurchaseBasis DBMS_SQL.VARCHAR2_TABLE;
382: gIPGAAllowPriceOverrideFlag DBMS_SQL.VARCHAR2_TABLE;
376: gIPGAMtlCategoryIds DBMS_SQL.NUMBER_TABLE;
377: gIPGAOrgIds DBMS_SQL.NUMBER_TABLE;
378: gIPGAUnitPrices DBMS_SQL.NUMBER_TABLE;
379: --FPJ FPSL Extractor Changes
380: gIPGAValueBasis DBMS_SQL.VARCHAR2_TABLE;
381: gIPGAPurchaseBasis DBMS_SQL.VARCHAR2_TABLE;
382: gIPGAAllowPriceOverrideFlag DBMS_SQL.VARCHAR2_TABLE;
383: gIPGANotToExceedPrice DBMS_SQL.NUMBER_TABLE;
384: -- FPJ Bug# 3110297 jingyu Add negotiated flag
377: gIPGAOrgIds DBMS_SQL.NUMBER_TABLE;
378: gIPGAUnitPrices DBMS_SQL.NUMBER_TABLE;
379: --FPJ FPSL Extractor Changes
380: gIPGAValueBasis DBMS_SQL.VARCHAR2_TABLE;
381: gIPGAPurchaseBasis DBMS_SQL.VARCHAR2_TABLE;
382: gIPGAAllowPriceOverrideFlag DBMS_SQL.VARCHAR2_TABLE;
383: gIPGANotToExceedPrice DBMS_SQL.NUMBER_TABLE;
384: -- FPJ Bug# 3110297 jingyu Add negotiated flag
385: gIPGANegotiatedFlag DBMS_SQL.VARCHAR2_TABLE;
378: gIPGAUnitPrices DBMS_SQL.NUMBER_TABLE;
379: --FPJ FPSL Extractor Changes
380: gIPGAValueBasis DBMS_SQL.VARCHAR2_TABLE;
381: gIPGAPurchaseBasis DBMS_SQL.VARCHAR2_TABLE;
382: gIPGAAllowPriceOverrideFlag DBMS_SQL.VARCHAR2_TABLE;
383: gIPGANotToExceedPrice DBMS_SQL.NUMBER_TABLE;
384: -- FPJ Bug# 3110297 jingyu Add negotiated flag
385: gIPGANegotiatedFlag DBMS_SQL.VARCHAR2_TABLE;
386: gIPGACurrencys DBMS_SQL.VARCHAR2_TABLE;
379: --FPJ FPSL Extractor Changes
380: gIPGAValueBasis DBMS_SQL.VARCHAR2_TABLE;
381: gIPGAPurchaseBasis DBMS_SQL.VARCHAR2_TABLE;
382: gIPGAAllowPriceOverrideFlag DBMS_SQL.VARCHAR2_TABLE;
383: gIPGANotToExceedPrice DBMS_SQL.NUMBER_TABLE;
384: -- FPJ Bug# 3110297 jingyu Add negotiated flag
385: gIPGANegotiatedFlag DBMS_SQL.VARCHAR2_TABLE;
386: gIPGACurrencys DBMS_SQL.VARCHAR2_TABLE;
387: gIPGAUnitOfMeasures DBMS_SQL.VARCHAR2_TABLE;
381: gIPGAPurchaseBasis DBMS_SQL.VARCHAR2_TABLE;
382: gIPGAAllowPriceOverrideFlag DBMS_SQL.VARCHAR2_TABLE;
383: gIPGANotToExceedPrice DBMS_SQL.NUMBER_TABLE;
384: -- FPJ Bug# 3110297 jingyu Add negotiated flag
385: gIPGANegotiatedFlag DBMS_SQL.VARCHAR2_TABLE;
386: gIPGACurrencys DBMS_SQL.VARCHAR2_TABLE;
387: gIPGAUnitOfMeasures DBMS_SQL.VARCHAR2_TABLE;
388: gIPGAFunctionalPrices DBMS_SQL.NUMBER_TABLE;
389: gIPGASupplierSiteCodes DBMS_SQL.VARCHAR2_TABLE;
382: gIPGAAllowPriceOverrideFlag DBMS_SQL.VARCHAR2_TABLE;
383: gIPGANotToExceedPrice DBMS_SQL.NUMBER_TABLE;
384: -- FPJ Bug# 3110297 jingyu Add negotiated flag
385: gIPGANegotiatedFlag DBMS_SQL.VARCHAR2_TABLE;
386: gIPGACurrencys DBMS_SQL.VARCHAR2_TABLE;
387: gIPGAUnitOfMeasures DBMS_SQL.VARCHAR2_TABLE;
388: gIPGAFunctionalPrices DBMS_SQL.NUMBER_TABLE;
389: gIPGASupplierSiteCodes DBMS_SQL.VARCHAR2_TABLE;
390: gIPGAContractNums DBMS_SQL.VARCHAR2_TABLE;
383: gIPGANotToExceedPrice DBMS_SQL.NUMBER_TABLE;
384: -- FPJ Bug# 3110297 jingyu Add negotiated flag
385: gIPGANegotiatedFlag DBMS_SQL.VARCHAR2_TABLE;
386: gIPGACurrencys DBMS_SQL.VARCHAR2_TABLE;
387: gIPGAUnitOfMeasures DBMS_SQL.VARCHAR2_TABLE;
388: gIPGAFunctionalPrices DBMS_SQL.NUMBER_TABLE;
389: gIPGASupplierSiteCodes DBMS_SQL.VARCHAR2_TABLE;
390: gIPGAContractNums DBMS_SQL.VARCHAR2_TABLE;
391: gIPGAContractLineNums DBMS_SQL.NUMBER_TABLE;
384: -- FPJ Bug# 3110297 jingyu Add negotiated flag
385: gIPGANegotiatedFlag DBMS_SQL.VARCHAR2_TABLE;
386: gIPGACurrencys DBMS_SQL.VARCHAR2_TABLE;
387: gIPGAUnitOfMeasures DBMS_SQL.VARCHAR2_TABLE;
388: gIPGAFunctionalPrices DBMS_SQL.NUMBER_TABLE;
389: gIPGASupplierSiteCodes DBMS_SQL.VARCHAR2_TABLE;
390: gIPGAContractNums DBMS_SQL.VARCHAR2_TABLE;
391: gIPGAContractLineNums DBMS_SQL.NUMBER_TABLE;
392: -- bug 2912717: populate line_type, rate info. for GA
385: gIPGANegotiatedFlag DBMS_SQL.VARCHAR2_TABLE;
386: gIPGACurrencys DBMS_SQL.VARCHAR2_TABLE;
387: gIPGAUnitOfMeasures DBMS_SQL.VARCHAR2_TABLE;
388: gIPGAFunctionalPrices DBMS_SQL.NUMBER_TABLE;
389: gIPGASupplierSiteCodes DBMS_SQL.VARCHAR2_TABLE;
390: gIPGAContractNums DBMS_SQL.VARCHAR2_TABLE;
391: gIPGAContractLineNums DBMS_SQL.NUMBER_TABLE;
392: -- bug 2912717: populate line_type, rate info. for GA
393: gIPGALineTypeIds DBMS_SQL.NUMBER_TABLE;
386: gIPGACurrencys DBMS_SQL.VARCHAR2_TABLE;
387: gIPGAUnitOfMeasures DBMS_SQL.VARCHAR2_TABLE;
388: gIPGAFunctionalPrices DBMS_SQL.NUMBER_TABLE;
389: gIPGASupplierSiteCodes DBMS_SQL.VARCHAR2_TABLE;
390: gIPGAContractNums DBMS_SQL.VARCHAR2_TABLE;
391: gIPGAContractLineNums DBMS_SQL.NUMBER_TABLE;
392: -- bug 2912717: populate line_type, rate info. for GA
393: gIPGALineTypeIds DBMS_SQL.NUMBER_TABLE;
394: gIPGARateTypes DBMS_SQL.VARCHAR2_TABLE;
387: gIPGAUnitOfMeasures DBMS_SQL.VARCHAR2_TABLE;
388: gIPGAFunctionalPrices DBMS_SQL.NUMBER_TABLE;
389: gIPGASupplierSiteCodes DBMS_SQL.VARCHAR2_TABLE;
390: gIPGAContractNums DBMS_SQL.VARCHAR2_TABLE;
391: gIPGAContractLineNums DBMS_SQL.NUMBER_TABLE;
392: -- bug 2912717: populate line_type, rate info. for GA
393: gIPGALineTypeIds DBMS_SQL.NUMBER_TABLE;
394: gIPGARateTypes DBMS_SQL.VARCHAR2_TABLE;
395: gIPGARateDates DBMS_SQL.DATE_TABLE;
389: gIPGASupplierSiteCodes DBMS_SQL.VARCHAR2_TABLE;
390: gIPGAContractNums DBMS_SQL.VARCHAR2_TABLE;
391: gIPGAContractLineNums DBMS_SQL.NUMBER_TABLE;
392: -- bug 2912717: populate line_type, rate info. for GA
393: gIPGALineTypeIds DBMS_SQL.NUMBER_TABLE;
394: gIPGARateTypes DBMS_SQL.VARCHAR2_TABLE;
395: gIPGARateDates DBMS_SQL.DATE_TABLE;
396: gIPGARates DBMS_SQL.NUMBER_TABLE;
397:
390: gIPGAContractNums DBMS_SQL.VARCHAR2_TABLE;
391: gIPGAContractLineNums DBMS_SQL.NUMBER_TABLE;
392: -- bug 2912717: populate line_type, rate info. for GA
393: gIPGALineTypeIds DBMS_SQL.NUMBER_TABLE;
394: gIPGARateTypes DBMS_SQL.VARCHAR2_TABLE;
395: gIPGARateDates DBMS_SQL.DATE_TABLE;
396: gIPGARates DBMS_SQL.NUMBER_TABLE;
397:
398: -- Set local rt_item_id for local global agreements
391: gIPGAContractLineNums DBMS_SQL.NUMBER_TABLE;
392: -- bug 2912717: populate line_type, rate info. for GA
393: gIPGALineTypeIds DBMS_SQL.NUMBER_TABLE;
394: gIPGARateTypes DBMS_SQL.VARCHAR2_TABLE;
395: gIPGARateDates DBMS_SQL.DATE_TABLE;
396: gIPGARates DBMS_SQL.NUMBER_TABLE;
397:
398: -- Set local rt_item_id for local global agreements
399: gSLRRowIds DBMS_SQL.UROWID_TABLE;
392: -- bug 2912717: populate line_type, rate info. for GA
393: gIPGALineTypeIds DBMS_SQL.NUMBER_TABLE;
394: gIPGARateTypes DBMS_SQL.VARCHAR2_TABLE;
395: gIPGARateDates DBMS_SQL.DATE_TABLE;
396: gIPGARates DBMS_SQL.NUMBER_TABLE;
397:
398: -- Set local rt_item_id for local global agreements
399: gSLRRowIds DBMS_SQL.UROWID_TABLE;
400: gSLRALocalRtItemIds DBMS_SQL.NUMBER_TABLE;
395: gIPGARateDates DBMS_SQL.DATE_TABLE;
396: gIPGARates DBMS_SQL.NUMBER_TABLE;
397:
398: -- Set local rt_item_id for local global agreements
399: gSLRRowIds DBMS_SQL.UROWID_TABLE;
400: gSLRALocalRtItemIds DBMS_SQL.NUMBER_TABLE;
401:
402: gSetTemplateLastRunDate BOOLEAN := TRUE;
403:
396: gIPGARates DBMS_SQL.NUMBER_TABLE;
397:
398: -- Set local rt_item_id for local global agreements
399: gSLRRowIds DBMS_SQL.UROWID_TABLE;
400: gSLRALocalRtItemIds DBMS_SQL.NUMBER_TABLE;
401:
402: gSetTemplateLastRunDate BOOLEAN := TRUE;
403:
404: --------------------------------------------------------------
1513: END getActiveFlag;
1514:
1515: PROCEDURE setActivePriceItemAttributes
1516: IS
1517: xUPItemRtItemIds DBMS_SQL.NUMBER_TABLE;
1518: xUPItemDescriptions DBMS_SQL.VARCHAR2_TABLE;
1519: xUPItemPictures DBMS_SQL.VARCHAR2_TABLE;
1520: xUPItemPictureUrls DBMS_SQL.VARCHAR2_TABLE;
1521:
1514:
1515: PROCEDURE setActivePriceItemAttributes
1516: IS
1517: xUPItemRtItemIds DBMS_SQL.NUMBER_TABLE;
1518: xUPItemDescriptions DBMS_SQL.VARCHAR2_TABLE;
1519: xUPItemPictures DBMS_SQL.VARCHAR2_TABLE;
1520: xUPItemPictureUrls DBMS_SQL.VARCHAR2_TABLE;
1521:
1522: xErrLoc PLS_INTEGER := 100;
1515: PROCEDURE setActivePriceItemAttributes
1516: IS
1517: xUPItemRtItemIds DBMS_SQL.NUMBER_TABLE;
1518: xUPItemDescriptions DBMS_SQL.VARCHAR2_TABLE;
1519: xUPItemPictures DBMS_SQL.VARCHAR2_TABLE;
1520: xUPItemPictureUrls DBMS_SQL.VARCHAR2_TABLE;
1521:
1522: xErrLoc PLS_INTEGER := 100;
1523: xString VARCHAR2(4000) := NULL;
1516: IS
1517: xUPItemRtItemIds DBMS_SQL.NUMBER_TABLE;
1518: xUPItemDescriptions DBMS_SQL.VARCHAR2_TABLE;
1519: xUPItemPictures DBMS_SQL.VARCHAR2_TABLE;
1520: xUPItemPictureUrls DBMS_SQL.VARCHAR2_TABLE;
1521:
1522: xErrLoc PLS_INTEGER := 100;
1523: xString VARCHAR2(4000) := NULL;
1524: xTestMode VARCHAR2(1);
2066: PROCEDURE processBatchData(pMode IN VARCHAR2) IS
2067: xErrLoc PLS_INTEGER := 100;
2068: xActionMode VARCHAR2(80);
2069: xContinue BOOLEAN := TRUE;
2070: xRtItemIds DBMS_SQL.NUMBER_TABLE;
2071: BEGIN
2072: xErrLoc := 100;
2073: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DETIL_LEVEL THEN
2074: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DETIL_LEVEL,
5040: PRAGMA EXCEPTION_INIT(snap_shot_too_old, -1555);
5041: cUpdatedPriceRows tCursorType;
5042:
5043: xErrLoc PLS_INTEGER := 100;
5044: l_document_type DBMS_SQL.NUMBER_TABLE;
5045: l_last_update_date DBMS_SQL.DATE_TABLE;
5046: l_org_id DBMS_SQL.NUMBER_TABLE;
5047: l_supplier_id DBMS_SQL.NUMBER_TABLE;
5048: l_supplier DBMS_SQL.VARCHAR2_TABLE;
5041: cUpdatedPriceRows tCursorType;
5042:
5043: xErrLoc PLS_INTEGER := 100;
5044: l_document_type DBMS_SQL.NUMBER_TABLE;
5045: l_last_update_date DBMS_SQL.DATE_TABLE;
5046: l_org_id DBMS_SQL.NUMBER_TABLE;
5047: l_supplier_id DBMS_SQL.NUMBER_TABLE;
5048: l_supplier DBMS_SQL.VARCHAR2_TABLE;
5049: l_supplier_part_num DBMS_SQL.VARCHAR2_TABLE;
5042:
5043: xErrLoc PLS_INTEGER := 100;
5044: l_document_type DBMS_SQL.NUMBER_TABLE;
5045: l_last_update_date DBMS_SQL.DATE_TABLE;
5046: l_org_id DBMS_SQL.NUMBER_TABLE;
5047: l_supplier_id DBMS_SQL.NUMBER_TABLE;
5048: l_supplier DBMS_SQL.VARCHAR2_TABLE;
5049: l_supplier_part_num DBMS_SQL.VARCHAR2_TABLE;
5050: l_internal_item_id DBMS_SQL.NUMBER_TABLE;
5043: xErrLoc PLS_INTEGER := 100;
5044: l_document_type DBMS_SQL.NUMBER_TABLE;
5045: l_last_update_date DBMS_SQL.DATE_TABLE;
5046: l_org_id DBMS_SQL.NUMBER_TABLE;
5047: l_supplier_id DBMS_SQL.NUMBER_TABLE;
5048: l_supplier DBMS_SQL.VARCHAR2_TABLE;
5049: l_supplier_part_num DBMS_SQL.VARCHAR2_TABLE;
5050: l_internal_item_id DBMS_SQL.NUMBER_TABLE;
5051: l_mtl_category_id DBMS_SQL.NUMBER_TABLE;
5044: l_document_type DBMS_SQL.NUMBER_TABLE;
5045: l_last_update_date DBMS_SQL.DATE_TABLE;
5046: l_org_id DBMS_SQL.NUMBER_TABLE;
5047: l_supplier_id DBMS_SQL.NUMBER_TABLE;
5048: l_supplier DBMS_SQL.VARCHAR2_TABLE;
5049: l_supplier_part_num DBMS_SQL.VARCHAR2_TABLE;
5050: l_internal_item_id DBMS_SQL.NUMBER_TABLE;
5051: l_mtl_category_id DBMS_SQL.NUMBER_TABLE;
5052: l_category_key DBMS_SQL.VARCHAR2_TABLE;
5045: l_last_update_date DBMS_SQL.DATE_TABLE;
5046: l_org_id DBMS_SQL.NUMBER_TABLE;
5047: l_supplier_id DBMS_SQL.NUMBER_TABLE;
5048: l_supplier DBMS_SQL.VARCHAR2_TABLE;
5049: l_supplier_part_num DBMS_SQL.VARCHAR2_TABLE;
5050: l_internal_item_id DBMS_SQL.NUMBER_TABLE;
5051: l_mtl_category_id DBMS_SQL.NUMBER_TABLE;
5052: l_category_key DBMS_SQL.VARCHAR2_TABLE;
5053: l_description DBMS_SQL.VARCHAR2_TABLE;
5046: l_org_id DBMS_SQL.NUMBER_TABLE;
5047: l_supplier_id DBMS_SQL.NUMBER_TABLE;
5048: l_supplier DBMS_SQL.VARCHAR2_TABLE;
5049: l_supplier_part_num DBMS_SQL.VARCHAR2_TABLE;
5050: l_internal_item_id DBMS_SQL.NUMBER_TABLE;
5051: l_mtl_category_id DBMS_SQL.NUMBER_TABLE;
5052: l_category_key DBMS_SQL.VARCHAR2_TABLE;
5053: l_description DBMS_SQL.VARCHAR2_TABLE;
5054: l_picture DBMS_SQL.VARCHAR2_TABLE;
5047: l_supplier_id DBMS_SQL.NUMBER_TABLE;
5048: l_supplier DBMS_SQL.VARCHAR2_TABLE;
5049: l_supplier_part_num DBMS_SQL.VARCHAR2_TABLE;
5050: l_internal_item_id DBMS_SQL.NUMBER_TABLE;
5051: l_mtl_category_id DBMS_SQL.NUMBER_TABLE;
5052: l_category_key DBMS_SQL.VARCHAR2_TABLE;
5053: l_description DBMS_SQL.VARCHAR2_TABLE;
5054: l_picture DBMS_SQL.VARCHAR2_TABLE;
5055: l_picture_url DBMS_SQL.VARCHAR2_TABLE;
5048: l_supplier DBMS_SQL.VARCHAR2_TABLE;
5049: l_supplier_part_num DBMS_SQL.VARCHAR2_TABLE;
5050: l_internal_item_id DBMS_SQL.NUMBER_TABLE;
5051: l_mtl_category_id DBMS_SQL.NUMBER_TABLE;
5052: l_category_key DBMS_SQL.VARCHAR2_TABLE;
5053: l_description DBMS_SQL.VARCHAR2_TABLE;
5054: l_picture DBMS_SQL.VARCHAR2_TABLE;
5055: l_picture_url DBMS_SQL.VARCHAR2_TABLE;
5056: l_price_type DBMS_SQL.VARCHAR2_TABLE;
5049: l_supplier_part_num DBMS_SQL.VARCHAR2_TABLE;
5050: l_internal_item_id DBMS_SQL.NUMBER_TABLE;
5051: l_mtl_category_id DBMS_SQL.NUMBER_TABLE;
5052: l_category_key DBMS_SQL.VARCHAR2_TABLE;
5053: l_description DBMS_SQL.VARCHAR2_TABLE;
5054: l_picture DBMS_SQL.VARCHAR2_TABLE;
5055: l_picture_url DBMS_SQL.VARCHAR2_TABLE;
5056: l_price_type DBMS_SQL.VARCHAR2_TABLE;
5057: l_asl_id DBMS_SQL.NUMBER_TABLE;
5050: l_internal_item_id DBMS_SQL.NUMBER_TABLE;
5051: l_mtl_category_id DBMS_SQL.NUMBER_TABLE;
5052: l_category_key DBMS_SQL.VARCHAR2_TABLE;
5053: l_description DBMS_SQL.VARCHAR2_TABLE;
5054: l_picture DBMS_SQL.VARCHAR2_TABLE;
5055: l_picture_url DBMS_SQL.VARCHAR2_TABLE;
5056: l_price_type DBMS_SQL.VARCHAR2_TABLE;
5057: l_asl_id DBMS_SQL.NUMBER_TABLE;
5058: l_supplier_site_id DBMS_SQL.NUMBER_TABLE;
5051: l_mtl_category_id DBMS_SQL.NUMBER_TABLE;
5052: l_category_key DBMS_SQL.VARCHAR2_TABLE;
5053: l_description DBMS_SQL.VARCHAR2_TABLE;
5054: l_picture DBMS_SQL.VARCHAR2_TABLE;
5055: l_picture_url DBMS_SQL.VARCHAR2_TABLE;
5056: l_price_type DBMS_SQL.VARCHAR2_TABLE;
5057: l_asl_id DBMS_SQL.NUMBER_TABLE;
5058: l_supplier_site_id DBMS_SQL.NUMBER_TABLE;
5059: l_contract_id DBMS_SQL.NUMBER_TABLE;
5052: l_category_key DBMS_SQL.VARCHAR2_TABLE;
5053: l_description DBMS_SQL.VARCHAR2_TABLE;
5054: l_picture DBMS_SQL.VARCHAR2_TABLE;
5055: l_picture_url DBMS_SQL.VARCHAR2_TABLE;
5056: l_price_type DBMS_SQL.VARCHAR2_TABLE;
5057: l_asl_id DBMS_SQL.NUMBER_TABLE;
5058: l_supplier_site_id DBMS_SQL.NUMBER_TABLE;
5059: l_contract_id DBMS_SQL.NUMBER_TABLE;
5060: l_contract_line_id DBMS_SQL.NUMBER_TABLE;
5053: l_description DBMS_SQL.VARCHAR2_TABLE;
5054: l_picture DBMS_SQL.VARCHAR2_TABLE;
5055: l_picture_url DBMS_SQL.VARCHAR2_TABLE;
5056: l_price_type DBMS_SQL.VARCHAR2_TABLE;
5057: l_asl_id DBMS_SQL.NUMBER_TABLE;
5058: l_supplier_site_id DBMS_SQL.NUMBER_TABLE;
5059: l_contract_id DBMS_SQL.NUMBER_TABLE;
5060: l_contract_line_id DBMS_SQL.NUMBER_TABLE;
5061: l_template_id DBMS_SQL.VARCHAR2_TABLE;
5054: l_picture DBMS_SQL.VARCHAR2_TABLE;
5055: l_picture_url DBMS_SQL.VARCHAR2_TABLE;
5056: l_price_type DBMS_SQL.VARCHAR2_TABLE;
5057: l_asl_id DBMS_SQL.NUMBER_TABLE;
5058: l_supplier_site_id DBMS_SQL.NUMBER_TABLE;
5059: l_contract_id DBMS_SQL.NUMBER_TABLE;
5060: l_contract_line_id DBMS_SQL.NUMBER_TABLE;
5061: l_template_id DBMS_SQL.VARCHAR2_TABLE;
5062: l_template_line_id DBMS_SQL.NUMBER_TABLE;
5055: l_picture_url DBMS_SQL.VARCHAR2_TABLE;
5056: l_price_type DBMS_SQL.VARCHAR2_TABLE;
5057: l_asl_id DBMS_SQL.NUMBER_TABLE;
5058: l_supplier_site_id DBMS_SQL.NUMBER_TABLE;
5059: l_contract_id DBMS_SQL.NUMBER_TABLE;
5060: l_contract_line_id DBMS_SQL.NUMBER_TABLE;
5061: l_template_id DBMS_SQL.VARCHAR2_TABLE;
5062: l_template_line_id DBMS_SQL.NUMBER_TABLE;
5063: l_price_search_type DBMS_SQL.VARCHAR2_TABLE;
5056: l_price_type DBMS_SQL.VARCHAR2_TABLE;
5057: l_asl_id DBMS_SQL.NUMBER_TABLE;
5058: l_supplier_site_id DBMS_SQL.NUMBER_TABLE;
5059: l_contract_id DBMS_SQL.NUMBER_TABLE;
5060: l_contract_line_id DBMS_SQL.NUMBER_TABLE;
5061: l_template_id DBMS_SQL.VARCHAR2_TABLE;
5062: l_template_line_id DBMS_SQL.NUMBER_TABLE;
5063: l_price_search_type DBMS_SQL.VARCHAR2_TABLE;
5064: l_unit_price DBMS_SQL.NUMBER_TABLE;
5057: l_asl_id DBMS_SQL.NUMBER_TABLE;
5058: l_supplier_site_id DBMS_SQL.NUMBER_TABLE;
5059: l_contract_id DBMS_SQL.NUMBER_TABLE;
5060: l_contract_line_id DBMS_SQL.NUMBER_TABLE;
5061: l_template_id DBMS_SQL.VARCHAR2_TABLE;
5062: l_template_line_id DBMS_SQL.NUMBER_TABLE;
5063: l_price_search_type DBMS_SQL.VARCHAR2_TABLE;
5064: l_unit_price DBMS_SQL.NUMBER_TABLE;
5065: --FPJ FPSL Extractor Changes
5058: l_supplier_site_id DBMS_SQL.NUMBER_TABLE;
5059: l_contract_id DBMS_SQL.NUMBER_TABLE;
5060: l_contract_line_id DBMS_SQL.NUMBER_TABLE;
5061: l_template_id DBMS_SQL.VARCHAR2_TABLE;
5062: l_template_line_id DBMS_SQL.NUMBER_TABLE;
5063: l_price_search_type DBMS_SQL.VARCHAR2_TABLE;
5064: l_unit_price DBMS_SQL.NUMBER_TABLE;
5065: --FPJ FPSL Extractor Changes
5066: l_value_basis DBMS_SQL.VARCHAR2_TABLE;
5059: l_contract_id DBMS_SQL.NUMBER_TABLE;
5060: l_contract_line_id DBMS_SQL.NUMBER_TABLE;
5061: l_template_id DBMS_SQL.VARCHAR2_TABLE;
5062: l_template_line_id DBMS_SQL.NUMBER_TABLE;
5063: l_price_search_type DBMS_SQL.VARCHAR2_TABLE;
5064: l_unit_price DBMS_SQL.NUMBER_TABLE;
5065: --FPJ FPSL Extractor Changes
5066: l_value_basis DBMS_SQL.VARCHAR2_TABLE;
5067: l_purchase_basis DBMS_SQL.VARCHAR2_TABLE;
5060: l_contract_line_id DBMS_SQL.NUMBER_TABLE;
5061: l_template_id DBMS_SQL.VARCHAR2_TABLE;
5062: l_template_line_id DBMS_SQL.NUMBER_TABLE;
5063: l_price_search_type DBMS_SQL.VARCHAR2_TABLE;
5064: l_unit_price DBMS_SQL.NUMBER_TABLE;
5065: --FPJ FPSL Extractor Changes
5066: l_value_basis DBMS_SQL.VARCHAR2_TABLE;
5067: l_purchase_basis DBMS_SQL.VARCHAR2_TABLE;
5068: l_allow_price_override_flag DBMS_SQL.VARCHAR2_TABLE;
5062: l_template_line_id DBMS_SQL.NUMBER_TABLE;
5063: l_price_search_type DBMS_SQL.VARCHAR2_TABLE;
5064: l_unit_price DBMS_SQL.NUMBER_TABLE;
5065: --FPJ FPSL Extractor Changes
5066: l_value_basis DBMS_SQL.VARCHAR2_TABLE;
5067: l_purchase_basis DBMS_SQL.VARCHAR2_TABLE;
5068: l_allow_price_override_flag DBMS_SQL.VARCHAR2_TABLE;
5069: l_not_to_exceed_price DBMS_SQL.NUMBER_TABLE;
5070: -- FPJ Bug# 3007068 sosingha: Extractor Changes For Kit Support Project
5063: l_price_search_type DBMS_SQL.VARCHAR2_TABLE;
5064: l_unit_price DBMS_SQL.NUMBER_TABLE;
5065: --FPJ FPSL Extractor Changes
5066: l_value_basis DBMS_SQL.VARCHAR2_TABLE;
5067: l_purchase_basis DBMS_SQL.VARCHAR2_TABLE;
5068: l_allow_price_override_flag DBMS_SQL.VARCHAR2_TABLE;
5069: l_not_to_exceed_price DBMS_SQL.NUMBER_TABLE;
5070: -- FPJ Bug# 3007068 sosingha: Extractor Changes For Kit Support Project
5071: l_suggested_quantity DBMS_SQL.NUMBER_TABLE;
5064: l_unit_price DBMS_SQL.NUMBER_TABLE;
5065: --FPJ FPSL Extractor Changes
5066: l_value_basis DBMS_SQL.VARCHAR2_TABLE;
5067: l_purchase_basis DBMS_SQL.VARCHAR2_TABLE;
5068: l_allow_price_override_flag DBMS_SQL.VARCHAR2_TABLE;
5069: l_not_to_exceed_price DBMS_SQL.NUMBER_TABLE;
5070: -- FPJ Bug# 3007068 sosingha: Extractor Changes For Kit Support Project
5071: l_suggested_quantity DBMS_SQL.NUMBER_TABLE;
5072: -- FPJ Bug# 3110297 jingyu Add negotiated flag
5065: --FPJ FPSL Extractor Changes
5066: l_value_basis DBMS_SQL.VARCHAR2_TABLE;
5067: l_purchase_basis DBMS_SQL.VARCHAR2_TABLE;
5068: l_allow_price_override_flag DBMS_SQL.VARCHAR2_TABLE;
5069: l_not_to_exceed_price DBMS_SQL.NUMBER_TABLE;
5070: -- FPJ Bug# 3007068 sosingha: Extractor Changes For Kit Support Project
5071: l_suggested_quantity DBMS_SQL.NUMBER_TABLE;
5072: -- FPJ Bug# 3110297 jingyu Add negotiated flag
5073: l_negotiated_by_preparer_flag DBMS_SQL.VARCHAR2_TABLE;
5067: l_purchase_basis DBMS_SQL.VARCHAR2_TABLE;
5068: l_allow_price_override_flag DBMS_SQL.VARCHAR2_TABLE;
5069: l_not_to_exceed_price DBMS_SQL.NUMBER_TABLE;
5070: -- FPJ Bug# 3007068 sosingha: Extractor Changes For Kit Support Project
5071: l_suggested_quantity DBMS_SQL.NUMBER_TABLE;
5072: -- FPJ Bug# 3110297 jingyu Add negotiated flag
5073: l_negotiated_by_preparer_flag DBMS_SQL.VARCHAR2_TABLE;
5074: l_currency DBMS_SQL.VARCHAR2_TABLE;
5075: l_unit_of_measure DBMS_SQL.VARCHAR2_TABLE;
5069: l_not_to_exceed_price DBMS_SQL.NUMBER_TABLE;
5070: -- FPJ Bug# 3007068 sosingha: Extractor Changes For Kit Support Project
5071: l_suggested_quantity DBMS_SQL.NUMBER_TABLE;
5072: -- FPJ Bug# 3110297 jingyu Add negotiated flag
5073: l_negotiated_by_preparer_flag DBMS_SQL.VARCHAR2_TABLE;
5074: l_currency DBMS_SQL.VARCHAR2_TABLE;
5075: l_unit_of_measure DBMS_SQL.VARCHAR2_TABLE;
5076: l_functional_price DBMS_SQL.NUMBER_TABLE;
5077: l_supplier_site_code DBMS_SQL.VARCHAR2_TABLE;
5070: -- FPJ Bug# 3007068 sosingha: Extractor Changes For Kit Support Project
5071: l_suggested_quantity DBMS_SQL.NUMBER_TABLE;
5072: -- FPJ Bug# 3110297 jingyu Add negotiated flag
5073: l_negotiated_by_preparer_flag DBMS_SQL.VARCHAR2_TABLE;
5074: l_currency DBMS_SQL.VARCHAR2_TABLE;
5075: l_unit_of_measure DBMS_SQL.VARCHAR2_TABLE;
5076: l_functional_price DBMS_SQL.NUMBER_TABLE;
5077: l_supplier_site_code DBMS_SQL.VARCHAR2_TABLE;
5078: l_contract_num DBMS_SQL.VARCHAR2_TABLE;
5071: l_suggested_quantity DBMS_SQL.NUMBER_TABLE;
5072: -- FPJ Bug# 3110297 jingyu Add negotiated flag
5073: l_negotiated_by_preparer_flag DBMS_SQL.VARCHAR2_TABLE;
5074: l_currency DBMS_SQL.VARCHAR2_TABLE;
5075: l_unit_of_measure DBMS_SQL.VARCHAR2_TABLE;
5076: l_functional_price DBMS_SQL.NUMBER_TABLE;
5077: l_supplier_site_code DBMS_SQL.VARCHAR2_TABLE;
5078: l_contract_num DBMS_SQL.VARCHAR2_TABLE;
5079: l_contract_line_num DBMS_SQL.NUMBER_TABLE;
5072: -- FPJ Bug# 3110297 jingyu Add negotiated flag
5073: l_negotiated_by_preparer_flag DBMS_SQL.VARCHAR2_TABLE;
5074: l_currency DBMS_SQL.VARCHAR2_TABLE;
5075: l_unit_of_measure DBMS_SQL.VARCHAR2_TABLE;
5076: l_functional_price DBMS_SQL.NUMBER_TABLE;
5077: l_supplier_site_code DBMS_SQL.VARCHAR2_TABLE;
5078: l_contract_num DBMS_SQL.VARCHAR2_TABLE;
5079: l_contract_line_num DBMS_SQL.NUMBER_TABLE;
5080: l_manufacturer DBMS_SQL.VARCHAR2_TABLE;
5073: l_negotiated_by_preparer_flag DBMS_SQL.VARCHAR2_TABLE;
5074: l_currency DBMS_SQL.VARCHAR2_TABLE;
5075: l_unit_of_measure DBMS_SQL.VARCHAR2_TABLE;
5076: l_functional_price DBMS_SQL.NUMBER_TABLE;
5077: l_supplier_site_code DBMS_SQL.VARCHAR2_TABLE;
5078: l_contract_num DBMS_SQL.VARCHAR2_TABLE;
5079: l_contract_line_num DBMS_SQL.NUMBER_TABLE;
5080: l_manufacturer DBMS_SQL.VARCHAR2_TABLE;
5081: l_manufacturer_part_num DBMS_SQL.VARCHAR2_TABLE;
5074: l_currency DBMS_SQL.VARCHAR2_TABLE;
5075: l_unit_of_measure DBMS_SQL.VARCHAR2_TABLE;
5076: l_functional_price DBMS_SQL.NUMBER_TABLE;
5077: l_supplier_site_code DBMS_SQL.VARCHAR2_TABLE;
5078: l_contract_num DBMS_SQL.VARCHAR2_TABLE;
5079: l_contract_line_num DBMS_SQL.NUMBER_TABLE;
5080: l_manufacturer DBMS_SQL.VARCHAR2_TABLE;
5081: l_manufacturer_part_num DBMS_SQL.VARCHAR2_TABLE;
5082: l_rate_type DBMS_SQL.VARCHAR2_TABLE;
5075: l_unit_of_measure DBMS_SQL.VARCHAR2_TABLE;
5076: l_functional_price DBMS_SQL.NUMBER_TABLE;
5077: l_supplier_site_code DBMS_SQL.VARCHAR2_TABLE;
5078: l_contract_num DBMS_SQL.VARCHAR2_TABLE;
5079: l_contract_line_num DBMS_SQL.NUMBER_TABLE;
5080: l_manufacturer DBMS_SQL.VARCHAR2_TABLE;
5081: l_manufacturer_part_num DBMS_SQL.VARCHAR2_TABLE;
5082: l_rate_type DBMS_SQL.VARCHAR2_TABLE;
5083: l_rate_date DBMS_SQL.DATE_TABLE;
5076: l_functional_price DBMS_SQL.NUMBER_TABLE;
5077: l_supplier_site_code DBMS_SQL.VARCHAR2_TABLE;
5078: l_contract_num DBMS_SQL.VARCHAR2_TABLE;
5079: l_contract_line_num DBMS_SQL.NUMBER_TABLE;
5080: l_manufacturer DBMS_SQL.VARCHAR2_TABLE;
5081: l_manufacturer_part_num DBMS_SQL.VARCHAR2_TABLE;
5082: l_rate_type DBMS_SQL.VARCHAR2_TABLE;
5083: l_rate_date DBMS_SQL.DATE_TABLE;
5084: l_rate DBMS_SQL.NUMBER_TABLE;
5077: l_supplier_site_code DBMS_SQL.VARCHAR2_TABLE;
5078: l_contract_num DBMS_SQL.VARCHAR2_TABLE;
5079: l_contract_line_num DBMS_SQL.NUMBER_TABLE;
5080: l_manufacturer DBMS_SQL.VARCHAR2_TABLE;
5081: l_manufacturer_part_num DBMS_SQL.VARCHAR2_TABLE;
5082: l_rate_type DBMS_SQL.VARCHAR2_TABLE;
5083: l_rate_date DBMS_SQL.DATE_TABLE;
5084: l_rate DBMS_SQL.NUMBER_TABLE;
5085: l_supplier_number DBMS_SQL.VARCHAR2_TABLE;
5078: l_contract_num DBMS_SQL.VARCHAR2_TABLE;
5079: l_contract_line_num DBMS_SQL.NUMBER_TABLE;
5080: l_manufacturer DBMS_SQL.VARCHAR2_TABLE;
5081: l_manufacturer_part_num DBMS_SQL.VARCHAR2_TABLE;
5082: l_rate_type DBMS_SQL.VARCHAR2_TABLE;
5083: l_rate_date DBMS_SQL.DATE_TABLE;
5084: l_rate DBMS_SQL.NUMBER_TABLE;
5085: l_supplier_number DBMS_SQL.VARCHAR2_TABLE;
5086: l_supplier_contact_id DBMS_SQL.NUMBER_TABLE;
5079: l_contract_line_num DBMS_SQL.NUMBER_TABLE;
5080: l_manufacturer DBMS_SQL.VARCHAR2_TABLE;
5081: l_manufacturer_part_num DBMS_SQL.VARCHAR2_TABLE;
5082: l_rate_type DBMS_SQL.VARCHAR2_TABLE;
5083: l_rate_date DBMS_SQL.DATE_TABLE;
5084: l_rate DBMS_SQL.NUMBER_TABLE;
5085: l_supplier_number DBMS_SQL.VARCHAR2_TABLE;
5086: l_supplier_contact_id DBMS_SQL.NUMBER_TABLE;
5087: l_item_revision DBMS_SQL.VARCHAR2_TABLE;
5080: l_manufacturer DBMS_SQL.VARCHAR2_TABLE;
5081: l_manufacturer_part_num DBMS_SQL.VARCHAR2_TABLE;
5082: l_rate_type DBMS_SQL.VARCHAR2_TABLE;
5083: l_rate_date DBMS_SQL.DATE_TABLE;
5084: l_rate DBMS_SQL.NUMBER_TABLE;
5085: l_supplier_number DBMS_SQL.VARCHAR2_TABLE;
5086: l_supplier_contact_id DBMS_SQL.NUMBER_TABLE;
5087: l_item_revision DBMS_SQL.VARCHAR2_TABLE;
5088: l_line_type_id DBMS_SQL.NUMBER_TABLE;
5081: l_manufacturer_part_num DBMS_SQL.VARCHAR2_TABLE;
5082: l_rate_type DBMS_SQL.VARCHAR2_TABLE;
5083: l_rate_date DBMS_SQL.DATE_TABLE;
5084: l_rate DBMS_SQL.NUMBER_TABLE;
5085: l_supplier_number DBMS_SQL.VARCHAR2_TABLE;
5086: l_supplier_contact_id DBMS_SQL.NUMBER_TABLE;
5087: l_item_revision DBMS_SQL.VARCHAR2_TABLE;
5088: l_line_type_id DBMS_SQL.NUMBER_TABLE;
5089: l_buyer_id DBMS_SQL.NUMBER_TABLE;
5082: l_rate_type DBMS_SQL.VARCHAR2_TABLE;
5083: l_rate_date DBMS_SQL.DATE_TABLE;
5084: l_rate DBMS_SQL.NUMBER_TABLE;
5085: l_supplier_number DBMS_SQL.VARCHAR2_TABLE;
5086: l_supplier_contact_id DBMS_SQL.NUMBER_TABLE;
5087: l_item_revision DBMS_SQL.VARCHAR2_TABLE;
5088: l_line_type_id DBMS_SQL.NUMBER_TABLE;
5089: l_buyer_id DBMS_SQL.NUMBER_TABLE;
5090: l_global_agreement_flag DBMS_SQL.VARCHAR2_TABLE;
5083: l_rate_date DBMS_SQL.DATE_TABLE;
5084: l_rate DBMS_SQL.NUMBER_TABLE;
5085: l_supplier_number DBMS_SQL.VARCHAR2_TABLE;
5086: l_supplier_contact_id DBMS_SQL.NUMBER_TABLE;
5087: l_item_revision DBMS_SQL.VARCHAR2_TABLE;
5088: l_line_type_id DBMS_SQL.NUMBER_TABLE;
5089: l_buyer_id DBMS_SQL.NUMBER_TABLE;
5090: l_global_agreement_flag DBMS_SQL.VARCHAR2_TABLE;
5091: l_status DBMS_SQL.VARCHAR2_TABLE;
5084: l_rate DBMS_SQL.NUMBER_TABLE;
5085: l_supplier_number DBMS_SQL.VARCHAR2_TABLE;
5086: l_supplier_contact_id DBMS_SQL.NUMBER_TABLE;
5087: l_item_revision DBMS_SQL.VARCHAR2_TABLE;
5088: l_line_type_id DBMS_SQL.NUMBER_TABLE;
5089: l_buyer_id DBMS_SQL.NUMBER_TABLE;
5090: l_global_agreement_flag DBMS_SQL.VARCHAR2_TABLE;
5091: l_status DBMS_SQL.VARCHAR2_TABLE;
5092: l_internal_item_num DBMS_SQL.VARCHAR2_TABLE;
5085: l_supplier_number DBMS_SQL.VARCHAR2_TABLE;
5086: l_supplier_contact_id DBMS_SQL.NUMBER_TABLE;
5087: l_item_revision DBMS_SQL.VARCHAR2_TABLE;
5088: l_line_type_id DBMS_SQL.NUMBER_TABLE;
5089: l_buyer_id DBMS_SQL.NUMBER_TABLE;
5090: l_global_agreement_flag DBMS_SQL.VARCHAR2_TABLE;
5091: l_status DBMS_SQL.VARCHAR2_TABLE;
5092: l_internal_item_num DBMS_SQL.VARCHAR2_TABLE;
5093: l_inventory_organization_id DBMS_SQL.NUMBER_TABLE;
5086: l_supplier_contact_id DBMS_SQL.NUMBER_TABLE;
5087: l_item_revision DBMS_SQL.VARCHAR2_TABLE;
5088: l_line_type_id DBMS_SQL.NUMBER_TABLE;
5089: l_buyer_id DBMS_SQL.NUMBER_TABLE;
5090: l_global_agreement_flag DBMS_SQL.VARCHAR2_TABLE;
5091: l_status DBMS_SQL.VARCHAR2_TABLE;
5092: l_internal_item_num DBMS_SQL.VARCHAR2_TABLE;
5093: l_inventory_organization_id DBMS_SQL.NUMBER_TABLE;
5094: l_item_source_type DBMS_SQL.VARCHAR2_TABLE;
5087: l_item_revision DBMS_SQL.VARCHAR2_TABLE;
5088: l_line_type_id DBMS_SQL.NUMBER_TABLE;
5089: l_buyer_id DBMS_SQL.NUMBER_TABLE;
5090: l_global_agreement_flag DBMS_SQL.VARCHAR2_TABLE;
5091: l_status DBMS_SQL.VARCHAR2_TABLE;
5092: l_internal_item_num DBMS_SQL.VARCHAR2_TABLE;
5093: l_inventory_organization_id DBMS_SQL.NUMBER_TABLE;
5094: l_item_source_type DBMS_SQL.VARCHAR2_TABLE;
5095: l_item_search_type DBMS_SQL.VARCHAR2_TABLE;
5088: l_line_type_id DBMS_SQL.NUMBER_TABLE;
5089: l_buyer_id DBMS_SQL.NUMBER_TABLE;
5090: l_global_agreement_flag DBMS_SQL.VARCHAR2_TABLE;
5091: l_status DBMS_SQL.VARCHAR2_TABLE;
5092: l_internal_item_num DBMS_SQL.VARCHAR2_TABLE;
5093: l_inventory_organization_id DBMS_SQL.NUMBER_TABLE;
5094: l_item_source_type DBMS_SQL.VARCHAR2_TABLE;
5095: l_item_search_type DBMS_SQL.VARCHAR2_TABLE;
5096: l_primary_category_id DBMS_SQL.NUMBER_TABLE;
5089: l_buyer_id DBMS_SQL.NUMBER_TABLE;
5090: l_global_agreement_flag DBMS_SQL.VARCHAR2_TABLE;
5091: l_status DBMS_SQL.VARCHAR2_TABLE;
5092: l_internal_item_num DBMS_SQL.VARCHAR2_TABLE;
5093: l_inventory_organization_id DBMS_SQL.NUMBER_TABLE;
5094: l_item_source_type DBMS_SQL.VARCHAR2_TABLE;
5095: l_item_search_type DBMS_SQL.VARCHAR2_TABLE;
5096: l_primary_category_id DBMS_SQL.NUMBER_TABLE;
5097: l_primary_category_name DBMS_SQL.VARCHAR2_TABLE;
5090: l_global_agreement_flag DBMS_SQL.VARCHAR2_TABLE;
5091: l_status DBMS_SQL.VARCHAR2_TABLE;
5092: l_internal_item_num DBMS_SQL.VARCHAR2_TABLE;
5093: l_inventory_organization_id DBMS_SQL.NUMBER_TABLE;
5094: l_item_source_type DBMS_SQL.VARCHAR2_TABLE;
5095: l_item_search_type DBMS_SQL.VARCHAR2_TABLE;
5096: l_primary_category_id DBMS_SQL.NUMBER_TABLE;
5097: l_primary_category_name DBMS_SQL.VARCHAR2_TABLE;
5098: l_template_category_id DBMS_SQL.NUMBER_TABLE;
5091: l_status DBMS_SQL.VARCHAR2_TABLE;
5092: l_internal_item_num DBMS_SQL.VARCHAR2_TABLE;
5093: l_inventory_organization_id DBMS_SQL.NUMBER_TABLE;
5094: l_item_source_type DBMS_SQL.VARCHAR2_TABLE;
5095: l_item_search_type DBMS_SQL.VARCHAR2_TABLE;
5096: l_primary_category_id DBMS_SQL.NUMBER_TABLE;
5097: l_primary_category_name DBMS_SQL.VARCHAR2_TABLE;
5098: l_template_category_id DBMS_SQL.NUMBER_TABLE;
5099: l_price_rt_item_id DBMS_SQL.NUMBER_TABLE;
5092: l_internal_item_num DBMS_SQL.VARCHAR2_TABLE;
5093: l_inventory_organization_id DBMS_SQL.NUMBER_TABLE;
5094: l_item_source_type DBMS_SQL.VARCHAR2_TABLE;
5095: l_item_search_type DBMS_SQL.VARCHAR2_TABLE;
5096: l_primary_category_id DBMS_SQL.NUMBER_TABLE;
5097: l_primary_category_name DBMS_SQL.VARCHAR2_TABLE;
5098: l_template_category_id DBMS_SQL.NUMBER_TABLE;
5099: l_price_rt_item_id DBMS_SQL.NUMBER_TABLE;
5100: l_price_internal_item_id DBMS_SQL.NUMBER_TABLE;
5093: l_inventory_organization_id DBMS_SQL.NUMBER_TABLE;
5094: l_item_source_type DBMS_SQL.VARCHAR2_TABLE;
5095: l_item_search_type DBMS_SQL.VARCHAR2_TABLE;
5096: l_primary_category_id DBMS_SQL.NUMBER_TABLE;
5097: l_primary_category_name DBMS_SQL.VARCHAR2_TABLE;
5098: l_template_category_id DBMS_SQL.NUMBER_TABLE;
5099: l_price_rt_item_id DBMS_SQL.NUMBER_TABLE;
5100: l_price_internal_item_id DBMS_SQL.NUMBER_TABLE;
5101: l_price_supplier_id DBMS_SQL.NUMBER_TABLE;
5094: l_item_source_type DBMS_SQL.VARCHAR2_TABLE;
5095: l_item_search_type DBMS_SQL.VARCHAR2_TABLE;
5096: l_primary_category_id DBMS_SQL.NUMBER_TABLE;
5097: l_primary_category_name DBMS_SQL.VARCHAR2_TABLE;
5098: l_template_category_id DBMS_SQL.NUMBER_TABLE;
5099: l_price_rt_item_id DBMS_SQL.NUMBER_TABLE;
5100: l_price_internal_item_id DBMS_SQL.NUMBER_TABLE;
5101: l_price_supplier_id DBMS_SQL.NUMBER_TABLE;
5102: l_price_supplier_part_num DBMS_SQL.VARCHAR2_TABLE;
5095: l_item_search_type DBMS_SQL.VARCHAR2_TABLE;
5096: l_primary_category_id DBMS_SQL.NUMBER_TABLE;
5097: l_primary_category_name DBMS_SQL.VARCHAR2_TABLE;
5098: l_template_category_id DBMS_SQL.NUMBER_TABLE;
5099: l_price_rt_item_id DBMS_SQL.NUMBER_TABLE;
5100: l_price_internal_item_id DBMS_SQL.NUMBER_TABLE;
5101: l_price_supplier_id DBMS_SQL.NUMBER_TABLE;
5102: l_price_supplier_part_num DBMS_SQL.VARCHAR2_TABLE;
5103: l_price_contract_line_id DBMS_SQL.NUMBER_TABLE;
5096: l_primary_category_id DBMS_SQL.NUMBER_TABLE;
5097: l_primary_category_name DBMS_SQL.VARCHAR2_TABLE;
5098: l_template_category_id DBMS_SQL.NUMBER_TABLE;
5099: l_price_rt_item_id DBMS_SQL.NUMBER_TABLE;
5100: l_price_internal_item_id DBMS_SQL.NUMBER_TABLE;
5101: l_price_supplier_id DBMS_SQL.NUMBER_TABLE;
5102: l_price_supplier_part_num DBMS_SQL.VARCHAR2_TABLE;
5103: l_price_contract_line_id DBMS_SQL.NUMBER_TABLE;
5104: l_price_mtl_category_id DBMS_SQL.NUMBER_TABLE;
5097: l_primary_category_name DBMS_SQL.VARCHAR2_TABLE;
5098: l_template_category_id DBMS_SQL.NUMBER_TABLE;
5099: l_price_rt_item_id DBMS_SQL.NUMBER_TABLE;
5100: l_price_internal_item_id DBMS_SQL.NUMBER_TABLE;
5101: l_price_supplier_id DBMS_SQL.NUMBER_TABLE;
5102: l_price_supplier_part_num DBMS_SQL.VARCHAR2_TABLE;
5103: l_price_contract_line_id DBMS_SQL.NUMBER_TABLE;
5104: l_price_mtl_category_id DBMS_SQL.NUMBER_TABLE;
5105: l_match_primary_category_id DBMS_SQL.NUMBER_TABLE;
5098: l_template_category_id DBMS_SQL.NUMBER_TABLE;
5099: l_price_rt_item_id DBMS_SQL.NUMBER_TABLE;
5100: l_price_internal_item_id DBMS_SQL.NUMBER_TABLE;
5101: l_price_supplier_id DBMS_SQL.NUMBER_TABLE;
5102: l_price_supplier_part_num DBMS_SQL.VARCHAR2_TABLE;
5103: l_price_contract_line_id DBMS_SQL.NUMBER_TABLE;
5104: l_price_mtl_category_id DBMS_SQL.NUMBER_TABLE;
5105: l_match_primary_category_id DBMS_SQL.NUMBER_TABLE;
5106: l_rt_item_id DBMS_SQL.NUMBER_TABLE;
5099: l_price_rt_item_id DBMS_SQL.NUMBER_TABLE;
5100: l_price_internal_item_id DBMS_SQL.NUMBER_TABLE;
5101: l_price_supplier_id DBMS_SQL.NUMBER_TABLE;
5102: l_price_supplier_part_num DBMS_SQL.VARCHAR2_TABLE;
5103: l_price_contract_line_id DBMS_SQL.NUMBER_TABLE;
5104: l_price_mtl_category_id DBMS_SQL.NUMBER_TABLE;
5105: l_match_primary_category_id DBMS_SQL.NUMBER_TABLE;
5106: l_rt_item_id DBMS_SQL.NUMBER_TABLE;
5107: l_local_rt_item_id DBMS_SQL.NUMBER_TABLE;
5100: l_price_internal_item_id DBMS_SQL.NUMBER_TABLE;
5101: l_price_supplier_id DBMS_SQL.NUMBER_TABLE;
5102: l_price_supplier_part_num DBMS_SQL.VARCHAR2_TABLE;
5103: l_price_contract_line_id DBMS_SQL.NUMBER_TABLE;
5104: l_price_mtl_category_id DBMS_SQL.NUMBER_TABLE;
5105: l_match_primary_category_id DBMS_SQL.NUMBER_TABLE;
5106: l_rt_item_id DBMS_SQL.NUMBER_TABLE;
5107: l_local_rt_item_id DBMS_SQL.NUMBER_TABLE;
5108: l_match_template_flag DBMS_SQL.VARCHAR2_TABLE;
5101: l_price_supplier_id DBMS_SQL.NUMBER_TABLE;
5102: l_price_supplier_part_num DBMS_SQL.VARCHAR2_TABLE;
5103: l_price_contract_line_id DBMS_SQL.NUMBER_TABLE;
5104: l_price_mtl_category_id DBMS_SQL.NUMBER_TABLE;
5105: l_match_primary_category_id DBMS_SQL.NUMBER_TABLE;
5106: l_rt_item_id DBMS_SQL.NUMBER_TABLE;
5107: l_local_rt_item_id DBMS_SQL.NUMBER_TABLE;
5108: l_match_template_flag DBMS_SQL.VARCHAR2_TABLE;
5109: l_active_flag DBMS_SQL.VARCHAR2_TABLE;
5102: l_price_supplier_part_num DBMS_SQL.VARCHAR2_TABLE;
5103: l_price_contract_line_id DBMS_SQL.NUMBER_TABLE;
5104: l_price_mtl_category_id DBMS_SQL.NUMBER_TABLE;
5105: l_match_primary_category_id DBMS_SQL.NUMBER_TABLE;
5106: l_rt_item_id DBMS_SQL.NUMBER_TABLE;
5107: l_local_rt_item_id DBMS_SQL.NUMBER_TABLE;
5108: l_match_template_flag DBMS_SQL.VARCHAR2_TABLE;
5109: l_active_flag DBMS_SQL.VARCHAR2_TABLE;
5110: l_price_rowid DBMS_SQL.UROWID_TABLE;
5103: l_price_contract_line_id DBMS_SQL.NUMBER_TABLE;
5104: l_price_mtl_category_id DBMS_SQL.NUMBER_TABLE;
5105: l_match_primary_category_id DBMS_SQL.NUMBER_TABLE;
5106: l_rt_item_id DBMS_SQL.NUMBER_TABLE;
5107: l_local_rt_item_id DBMS_SQL.NUMBER_TABLE;
5108: l_match_template_flag DBMS_SQL.VARCHAR2_TABLE;
5109: l_active_flag DBMS_SQL.VARCHAR2_TABLE;
5110: l_price_rowid DBMS_SQL.UROWID_TABLE;
5111:
5104: l_price_mtl_category_id DBMS_SQL.NUMBER_TABLE;
5105: l_match_primary_category_id DBMS_SQL.NUMBER_TABLE;
5106: l_rt_item_id DBMS_SQL.NUMBER_TABLE;
5107: l_local_rt_item_id DBMS_SQL.NUMBER_TABLE;
5108: l_match_template_flag DBMS_SQL.VARCHAR2_TABLE;
5109: l_active_flag DBMS_SQL.VARCHAR2_TABLE;
5110: l_price_rowid DBMS_SQL.UROWID_TABLE;
5111:
5112: BEGIN
5105: l_match_primary_category_id DBMS_SQL.NUMBER_TABLE;
5106: l_rt_item_id DBMS_SQL.NUMBER_TABLE;
5107: l_local_rt_item_id DBMS_SQL.NUMBER_TABLE;
5108: l_match_template_flag DBMS_SQL.VARCHAR2_TABLE;
5109: l_active_flag DBMS_SQL.VARCHAR2_TABLE;
5110: l_price_rowid DBMS_SQL.UROWID_TABLE;
5111:
5112: BEGIN
5113: xErrLoc := 100;
5106: l_rt_item_id DBMS_SQL.NUMBER_TABLE;
5107: l_local_rt_item_id DBMS_SQL.NUMBER_TABLE;
5108: l_match_template_flag DBMS_SQL.VARCHAR2_TABLE;
5109: l_active_flag DBMS_SQL.VARCHAR2_TABLE;
5110: l_price_rowid DBMS_SQL.UROWID_TABLE;
5111:
5112: BEGIN
5113: xErrLoc := 100;
5114: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DETIL_LEVEL THEN
6761: xErrLoc PLS_INTEGER := 100;
6762: xContinue BOOLEAN := TRUE;
6763: xCommitSize PLS_INTEGER;
6764: xRowCount PLS_INTEGER := 0;
6765: xRtItemIds DBMS_SQL.NUMBER_TABLE;
6766: cUpdatedVendorNames tCursorType;
6767: xString VARCHAR2(2000);
6768: xVendorId DBMS_SQL.NUMBER_TABLE;
6769: xVendorName DBMS_SQL.VARCHAR2_TABLE;
6764: xRowCount PLS_INTEGER := 0;
6765: xRtItemIds DBMS_SQL.NUMBER_TABLE;
6766: cUpdatedVendorNames tCursorType;
6767: xString VARCHAR2(2000);
6768: xVendorId DBMS_SQL.NUMBER_TABLE;
6769: xVendorName DBMS_SQL.VARCHAR2_TABLE;
6770: xNewVendorNames DBMS_SQL.VARCHAR2_TABLE;
6771: xIndex PLS_INTEGER;
6772: -- For Vendor Site Update.
6765: xRtItemIds DBMS_SQL.NUMBER_TABLE;
6766: cUpdatedVendorNames tCursorType;
6767: xString VARCHAR2(2000);
6768: xVendorId DBMS_SQL.NUMBER_TABLE;
6769: xVendorName DBMS_SQL.VARCHAR2_TABLE;
6770: xNewVendorNames DBMS_SQL.VARCHAR2_TABLE;
6771: xIndex PLS_INTEGER;
6772: -- For Vendor Site Update.
6773: cUpdatedVendorSites tCursorType;
6766: cUpdatedVendorNames tCursorType;
6767: xString VARCHAR2(2000);
6768: xVendorId DBMS_SQL.NUMBER_TABLE;
6769: xVendorName DBMS_SQL.VARCHAR2_TABLE;
6770: xNewVendorNames DBMS_SQL.VARCHAR2_TABLE;
6771: xIndex PLS_INTEGER;
6772: -- For Vendor Site Update.
6773: cUpdatedVendorSites tCursorType;
6774: xVendorSiteIds DBMS_SQL.NUMBER_TABLE;
6770: xNewVendorNames DBMS_SQL.VARCHAR2_TABLE;
6771: xIndex PLS_INTEGER;
6772: -- For Vendor Site Update.
6773: cUpdatedVendorSites tCursorType;
6774: xVendorSiteIds DBMS_SQL.NUMBER_TABLE;
6775: xVendorSiteNames DBMS_SQL.VARCHAR2_TABLE;
6776: BEGIN
6777: xErrLoc := 100;
6778: xIndex := 1;
6771: xIndex PLS_INTEGER;
6772: -- For Vendor Site Update.
6773: cUpdatedVendorSites tCursorType;
6774: xVendorSiteIds DBMS_SQL.NUMBER_TABLE;
6775: xVendorSiteNames DBMS_SQL.VARCHAR2_TABLE;
6776: BEGIN
6777: xErrLoc := 100;
6778: xIndex := 1;
6779: