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

APPS.ICX_CAT_POPULATE_ITEM_PVT dependencies on DBMS_SQL

Line 13: gIHInventoryItemIdTbl DBMS_SQL.NUMBER_TABLE;

9: ----------------------------------------------------
10: -- Global PL/SQL Tables --
11: ----------------------------------------------------
12: -- INSERT icx_cat_items_ctx_hdrs_tlp
13: gIHInventoryItemIdTbl DBMS_SQL.NUMBER_TABLE;
14: gIHPoLineIdTbl DBMS_SQL.NUMBER_TABLE;
15: gIHReqTemplateNameTbl DBMS_SQL.VARCHAR2_TABLE;
16: gIHReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;
17: gIHOrgIdTbl DBMS_SQL.NUMBER_TABLE;

Line 14: gIHPoLineIdTbl DBMS_SQL.NUMBER_TABLE;

10: -- Global PL/SQL Tables --
11: ----------------------------------------------------
12: -- INSERT icx_cat_items_ctx_hdrs_tlp
13: gIHInventoryItemIdTbl DBMS_SQL.NUMBER_TABLE;
14: gIHPoLineIdTbl DBMS_SQL.NUMBER_TABLE;
15: gIHReqTemplateNameTbl DBMS_SQL.VARCHAR2_TABLE;
16: gIHReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;
17: gIHOrgIdTbl DBMS_SQL.NUMBER_TABLE;
18: gIHLanguageTbl DBMS_SQL.VARCHAR2_TABLE;

Line 15: gIHReqTemplateNameTbl DBMS_SQL.VARCHAR2_TABLE;

11: ----------------------------------------------------
12: -- INSERT icx_cat_items_ctx_hdrs_tlp
13: gIHInventoryItemIdTbl DBMS_SQL.NUMBER_TABLE;
14: gIHPoLineIdTbl DBMS_SQL.NUMBER_TABLE;
15: gIHReqTemplateNameTbl DBMS_SQL.VARCHAR2_TABLE;
16: gIHReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;
17: gIHOrgIdTbl DBMS_SQL.NUMBER_TABLE;
18: gIHLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
19: gIHSourceTypeTbl DBMS_SQL.VARCHAR2_TABLE;

Line 16: gIHReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;

12: -- INSERT icx_cat_items_ctx_hdrs_tlp
13: gIHInventoryItemIdTbl DBMS_SQL.NUMBER_TABLE;
14: gIHPoLineIdTbl DBMS_SQL.NUMBER_TABLE;
15: gIHReqTemplateNameTbl DBMS_SQL.VARCHAR2_TABLE;
16: gIHReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;
17: gIHOrgIdTbl DBMS_SQL.NUMBER_TABLE;
18: gIHLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
19: gIHSourceTypeTbl DBMS_SQL.VARCHAR2_TABLE;
20: gIHItemTypeTbl DBMS_SQL.VARCHAR2_TABLE;

Line 17: gIHOrgIdTbl DBMS_SQL.NUMBER_TABLE;

13: gIHInventoryItemIdTbl DBMS_SQL.NUMBER_TABLE;
14: gIHPoLineIdTbl DBMS_SQL.NUMBER_TABLE;
15: gIHReqTemplateNameTbl DBMS_SQL.VARCHAR2_TABLE;
16: gIHReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;
17: gIHOrgIdTbl DBMS_SQL.NUMBER_TABLE;
18: gIHLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
19: gIHSourceTypeTbl DBMS_SQL.VARCHAR2_TABLE;
20: gIHItemTypeTbl DBMS_SQL.VARCHAR2_TABLE;
21: gIHPurchasingOrgIdTbl DBMS_SQL.NUMBER_TABLE;

Line 18: gIHLanguageTbl DBMS_SQL.VARCHAR2_TABLE;

14: gIHPoLineIdTbl DBMS_SQL.NUMBER_TABLE;
15: gIHReqTemplateNameTbl DBMS_SQL.VARCHAR2_TABLE;
16: gIHReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;
17: gIHOrgIdTbl DBMS_SQL.NUMBER_TABLE;
18: gIHLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
19: gIHSourceTypeTbl DBMS_SQL.VARCHAR2_TABLE;
20: gIHItemTypeTbl DBMS_SQL.VARCHAR2_TABLE;
21: gIHPurchasingOrgIdTbl DBMS_SQL.NUMBER_TABLE;
22: gIHOwningOrgIdTbl DBMS_SQL.NUMBER_TABLE;

Line 19: gIHSourceTypeTbl DBMS_SQL.VARCHAR2_TABLE;

15: gIHReqTemplateNameTbl DBMS_SQL.VARCHAR2_TABLE;
16: gIHReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;
17: gIHOrgIdTbl DBMS_SQL.NUMBER_TABLE;
18: gIHLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
19: gIHSourceTypeTbl DBMS_SQL.VARCHAR2_TABLE;
20: gIHItemTypeTbl DBMS_SQL.VARCHAR2_TABLE;
21: gIHPurchasingOrgIdTbl DBMS_SQL.NUMBER_TABLE;
22: gIHOwningOrgIdTbl DBMS_SQL.NUMBER_TABLE;
23: gIHIpCategoryIdTbl DBMS_SQL.NUMBER_TABLE;

Line 20: gIHItemTypeTbl DBMS_SQL.VARCHAR2_TABLE;

16: gIHReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;
17: gIHOrgIdTbl DBMS_SQL.NUMBER_TABLE;
18: gIHLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
19: gIHSourceTypeTbl DBMS_SQL.VARCHAR2_TABLE;
20: gIHItemTypeTbl DBMS_SQL.VARCHAR2_TABLE;
21: gIHPurchasingOrgIdTbl DBMS_SQL.NUMBER_TABLE;
22: gIHOwningOrgIdTbl DBMS_SQL.NUMBER_TABLE;
23: gIHIpCategoryIdTbl DBMS_SQL.NUMBER_TABLE;
24: gIHIpCategoryNameTbl DBMS_SQL.VARCHAR2_TABLE;

Line 21: gIHPurchasingOrgIdTbl DBMS_SQL.NUMBER_TABLE;

17: gIHOrgIdTbl DBMS_SQL.NUMBER_TABLE;
18: gIHLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
19: gIHSourceTypeTbl DBMS_SQL.VARCHAR2_TABLE;
20: gIHItemTypeTbl DBMS_SQL.VARCHAR2_TABLE;
21: gIHPurchasingOrgIdTbl DBMS_SQL.NUMBER_TABLE;
22: gIHOwningOrgIdTbl DBMS_SQL.NUMBER_TABLE;
23: gIHIpCategoryIdTbl DBMS_SQL.NUMBER_TABLE;
24: gIHIpCategoryNameTbl DBMS_SQL.VARCHAR2_TABLE;
25: gIHPoCategoryIdTbl DBMS_SQL.NUMBER_TABLE;

Line 22: gIHOwningOrgIdTbl DBMS_SQL.NUMBER_TABLE;

18: gIHLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
19: gIHSourceTypeTbl DBMS_SQL.VARCHAR2_TABLE;
20: gIHItemTypeTbl DBMS_SQL.VARCHAR2_TABLE;
21: gIHPurchasingOrgIdTbl DBMS_SQL.NUMBER_TABLE;
22: gIHOwningOrgIdTbl DBMS_SQL.NUMBER_TABLE;
23: gIHIpCategoryIdTbl DBMS_SQL.NUMBER_TABLE;
24: gIHIpCategoryNameTbl DBMS_SQL.VARCHAR2_TABLE;
25: gIHPoCategoryIdTbl DBMS_SQL.NUMBER_TABLE;
26: gIHSupplierIdTbl DBMS_SQL.NUMBER_TABLE;

Line 23: gIHIpCategoryIdTbl DBMS_SQL.NUMBER_TABLE;

19: gIHSourceTypeTbl DBMS_SQL.VARCHAR2_TABLE;
20: gIHItemTypeTbl DBMS_SQL.VARCHAR2_TABLE;
21: gIHPurchasingOrgIdTbl DBMS_SQL.NUMBER_TABLE;
22: gIHOwningOrgIdTbl DBMS_SQL.NUMBER_TABLE;
23: gIHIpCategoryIdTbl DBMS_SQL.NUMBER_TABLE;
24: gIHIpCategoryNameTbl DBMS_SQL.VARCHAR2_TABLE;
25: gIHPoCategoryIdTbl DBMS_SQL.NUMBER_TABLE;
26: gIHSupplierIdTbl DBMS_SQL.NUMBER_TABLE;
27: gIHSupplierPartNumTbl DBMS_SQL.VARCHAR2_TABLE;

Line 24: gIHIpCategoryNameTbl DBMS_SQL.VARCHAR2_TABLE;

20: gIHItemTypeTbl DBMS_SQL.VARCHAR2_TABLE;
21: gIHPurchasingOrgIdTbl DBMS_SQL.NUMBER_TABLE;
22: gIHOwningOrgIdTbl DBMS_SQL.NUMBER_TABLE;
23: gIHIpCategoryIdTbl DBMS_SQL.NUMBER_TABLE;
24: gIHIpCategoryNameTbl DBMS_SQL.VARCHAR2_TABLE;
25: gIHPoCategoryIdTbl DBMS_SQL.NUMBER_TABLE;
26: gIHSupplierIdTbl DBMS_SQL.NUMBER_TABLE;
27: gIHSupplierPartNumTbl DBMS_SQL.VARCHAR2_TABLE;
28: gIHSupplierPartAuxidTbl DBMS_SQL.VARCHAR2_TABLE;

Line 25: gIHPoCategoryIdTbl DBMS_SQL.NUMBER_TABLE;

21: gIHPurchasingOrgIdTbl DBMS_SQL.NUMBER_TABLE;
22: gIHOwningOrgIdTbl DBMS_SQL.NUMBER_TABLE;
23: gIHIpCategoryIdTbl DBMS_SQL.NUMBER_TABLE;
24: gIHIpCategoryNameTbl DBMS_SQL.VARCHAR2_TABLE;
25: gIHPoCategoryIdTbl DBMS_SQL.NUMBER_TABLE;
26: gIHSupplierIdTbl DBMS_SQL.NUMBER_TABLE;
27: gIHSupplierPartNumTbl DBMS_SQL.VARCHAR2_TABLE;
28: gIHSupplierPartAuxidTbl DBMS_SQL.VARCHAR2_TABLE;
29: gIHSupplierSiteIdTbl DBMS_SQL.NUMBER_TABLE;

Line 26: gIHSupplierIdTbl DBMS_SQL.NUMBER_TABLE;

22: gIHOwningOrgIdTbl DBMS_SQL.NUMBER_TABLE;
23: gIHIpCategoryIdTbl DBMS_SQL.NUMBER_TABLE;
24: gIHIpCategoryNameTbl DBMS_SQL.VARCHAR2_TABLE;
25: gIHPoCategoryIdTbl DBMS_SQL.NUMBER_TABLE;
26: gIHSupplierIdTbl DBMS_SQL.NUMBER_TABLE;
27: gIHSupplierPartNumTbl DBMS_SQL.VARCHAR2_TABLE;
28: gIHSupplierPartAuxidTbl DBMS_SQL.VARCHAR2_TABLE;
29: gIHSupplierSiteIdTbl DBMS_SQL.NUMBER_TABLE;
30: gIHReqTemplatePoLineIdTbl DBMS_SQL.NUMBER_TABLE;

Line 27: gIHSupplierPartNumTbl DBMS_SQL.VARCHAR2_TABLE;

23: gIHIpCategoryIdTbl DBMS_SQL.NUMBER_TABLE;
24: gIHIpCategoryNameTbl DBMS_SQL.VARCHAR2_TABLE;
25: gIHPoCategoryIdTbl DBMS_SQL.NUMBER_TABLE;
26: gIHSupplierIdTbl DBMS_SQL.NUMBER_TABLE;
27: gIHSupplierPartNumTbl DBMS_SQL.VARCHAR2_TABLE;
28: gIHSupplierPartAuxidTbl DBMS_SQL.VARCHAR2_TABLE;
29: gIHSupplierSiteIdTbl DBMS_SQL.NUMBER_TABLE;
30: gIHReqTemplatePoLineIdTbl DBMS_SQL.NUMBER_TABLE;
31: gIHItemRevisionTbl DBMS_SQL.VARCHAR2_TABLE;

Line 28: gIHSupplierPartAuxidTbl DBMS_SQL.VARCHAR2_TABLE;

24: gIHIpCategoryNameTbl DBMS_SQL.VARCHAR2_TABLE;
25: gIHPoCategoryIdTbl DBMS_SQL.NUMBER_TABLE;
26: gIHSupplierIdTbl DBMS_SQL.NUMBER_TABLE;
27: gIHSupplierPartNumTbl DBMS_SQL.VARCHAR2_TABLE;
28: gIHSupplierPartAuxidTbl DBMS_SQL.VARCHAR2_TABLE;
29: gIHSupplierSiteIdTbl DBMS_SQL.NUMBER_TABLE;
30: gIHReqTemplatePoLineIdTbl DBMS_SQL.NUMBER_TABLE;
31: gIHItemRevisionTbl DBMS_SQL.VARCHAR2_TABLE;
32: gIHPoHeaderIdTbl DBMS_SQL.NUMBER_TABLE;

Line 29: gIHSupplierSiteIdTbl DBMS_SQL.NUMBER_TABLE;

25: gIHPoCategoryIdTbl DBMS_SQL.NUMBER_TABLE;
26: gIHSupplierIdTbl DBMS_SQL.NUMBER_TABLE;
27: gIHSupplierPartNumTbl DBMS_SQL.VARCHAR2_TABLE;
28: gIHSupplierPartAuxidTbl DBMS_SQL.VARCHAR2_TABLE;
29: gIHSupplierSiteIdTbl DBMS_SQL.NUMBER_TABLE;
30: gIHReqTemplatePoLineIdTbl DBMS_SQL.NUMBER_TABLE;
31: gIHItemRevisionTbl DBMS_SQL.VARCHAR2_TABLE;
32: gIHPoHeaderIdTbl DBMS_SQL.NUMBER_TABLE;
33: gIHDocumentNumberTbl DBMS_SQL.VARCHAR2_TABLE;

Line 30: gIHReqTemplatePoLineIdTbl DBMS_SQL.NUMBER_TABLE;

26: gIHSupplierIdTbl DBMS_SQL.NUMBER_TABLE;
27: gIHSupplierPartNumTbl DBMS_SQL.VARCHAR2_TABLE;
28: gIHSupplierPartAuxidTbl DBMS_SQL.VARCHAR2_TABLE;
29: gIHSupplierSiteIdTbl DBMS_SQL.NUMBER_TABLE;
30: gIHReqTemplatePoLineIdTbl DBMS_SQL.NUMBER_TABLE;
31: gIHItemRevisionTbl DBMS_SQL.VARCHAR2_TABLE;
32: gIHPoHeaderIdTbl DBMS_SQL.NUMBER_TABLE;
33: gIHDocumentNumberTbl DBMS_SQL.VARCHAR2_TABLE;
34: gIHLineNumTbl DBMS_SQL.NUMBER_TABLE;

Line 31: gIHItemRevisionTbl DBMS_SQL.VARCHAR2_TABLE;

27: gIHSupplierPartNumTbl DBMS_SQL.VARCHAR2_TABLE;
28: gIHSupplierPartAuxidTbl DBMS_SQL.VARCHAR2_TABLE;
29: gIHSupplierSiteIdTbl DBMS_SQL.NUMBER_TABLE;
30: gIHReqTemplatePoLineIdTbl DBMS_SQL.NUMBER_TABLE;
31: gIHItemRevisionTbl DBMS_SQL.VARCHAR2_TABLE;
32: gIHPoHeaderIdTbl DBMS_SQL.NUMBER_TABLE;
33: gIHDocumentNumberTbl DBMS_SQL.VARCHAR2_TABLE;
34: gIHLineNumTbl DBMS_SQL.NUMBER_TABLE;
35: gIHAllowPriceOverrideFlagTbl DBMS_SQL.VARCHAR2_TABLE;

Line 32: gIHPoHeaderIdTbl DBMS_SQL.NUMBER_TABLE;

28: gIHSupplierPartAuxidTbl DBMS_SQL.VARCHAR2_TABLE;
29: gIHSupplierSiteIdTbl DBMS_SQL.NUMBER_TABLE;
30: gIHReqTemplatePoLineIdTbl DBMS_SQL.NUMBER_TABLE;
31: gIHItemRevisionTbl DBMS_SQL.VARCHAR2_TABLE;
32: gIHPoHeaderIdTbl DBMS_SQL.NUMBER_TABLE;
33: gIHDocumentNumberTbl DBMS_SQL.VARCHAR2_TABLE;
34: gIHLineNumTbl DBMS_SQL.NUMBER_TABLE;
35: gIHAllowPriceOverrideFlagTbl DBMS_SQL.VARCHAR2_TABLE;
36: gIHNotToExceedPriceTbl DBMS_SQL.NUMBER_TABLE;

Line 33: gIHDocumentNumberTbl DBMS_SQL.VARCHAR2_TABLE;

29: gIHSupplierSiteIdTbl DBMS_SQL.NUMBER_TABLE;
30: gIHReqTemplatePoLineIdTbl DBMS_SQL.NUMBER_TABLE;
31: gIHItemRevisionTbl DBMS_SQL.VARCHAR2_TABLE;
32: gIHPoHeaderIdTbl DBMS_SQL.NUMBER_TABLE;
33: gIHDocumentNumberTbl DBMS_SQL.VARCHAR2_TABLE;
34: gIHLineNumTbl DBMS_SQL.NUMBER_TABLE;
35: gIHAllowPriceOverrideFlagTbl DBMS_SQL.VARCHAR2_TABLE;
36: gIHNotToExceedPriceTbl DBMS_SQL.NUMBER_TABLE;
37: gIHLineTypeIdTbl DBMS_SQL.NUMBER_TABLE;

Line 34: gIHLineNumTbl DBMS_SQL.NUMBER_TABLE;

30: gIHReqTemplatePoLineIdTbl DBMS_SQL.NUMBER_TABLE;
31: gIHItemRevisionTbl DBMS_SQL.VARCHAR2_TABLE;
32: gIHPoHeaderIdTbl DBMS_SQL.NUMBER_TABLE;
33: gIHDocumentNumberTbl DBMS_SQL.VARCHAR2_TABLE;
34: gIHLineNumTbl DBMS_SQL.NUMBER_TABLE;
35: gIHAllowPriceOverrideFlagTbl DBMS_SQL.VARCHAR2_TABLE;
36: gIHNotToExceedPriceTbl DBMS_SQL.NUMBER_TABLE;
37: gIHLineTypeIdTbl DBMS_SQL.NUMBER_TABLE;
38: gIHUnitMeasLookupCodeTbl DBMS_SQL.VARCHAR2_TABLE;

Line 35: gIHAllowPriceOverrideFlagTbl DBMS_SQL.VARCHAR2_TABLE;

31: gIHItemRevisionTbl DBMS_SQL.VARCHAR2_TABLE;
32: gIHPoHeaderIdTbl DBMS_SQL.NUMBER_TABLE;
33: gIHDocumentNumberTbl DBMS_SQL.VARCHAR2_TABLE;
34: gIHLineNumTbl DBMS_SQL.NUMBER_TABLE;
35: gIHAllowPriceOverrideFlagTbl DBMS_SQL.VARCHAR2_TABLE;
36: gIHNotToExceedPriceTbl DBMS_SQL.NUMBER_TABLE;
37: gIHLineTypeIdTbl DBMS_SQL.NUMBER_TABLE;
38: gIHUnitMeasLookupCodeTbl DBMS_SQL.VARCHAR2_TABLE;
39: gIHSuggestedQuantityTbl DBMS_SQL.NUMBER_TABLE;

Line 36: gIHNotToExceedPriceTbl DBMS_SQL.NUMBER_TABLE;

32: gIHPoHeaderIdTbl DBMS_SQL.NUMBER_TABLE;
33: gIHDocumentNumberTbl DBMS_SQL.VARCHAR2_TABLE;
34: gIHLineNumTbl DBMS_SQL.NUMBER_TABLE;
35: gIHAllowPriceOverrideFlagTbl DBMS_SQL.VARCHAR2_TABLE;
36: gIHNotToExceedPriceTbl DBMS_SQL.NUMBER_TABLE;
37: gIHLineTypeIdTbl DBMS_SQL.NUMBER_TABLE;
38: gIHUnitMeasLookupCodeTbl DBMS_SQL.VARCHAR2_TABLE;
39: gIHSuggestedQuantityTbl DBMS_SQL.NUMBER_TABLE;
40: gIHUnitPriceTbl DBMS_SQL.NUMBER_TABLE;

Line 37: gIHLineTypeIdTbl DBMS_SQL.NUMBER_TABLE;

33: gIHDocumentNumberTbl DBMS_SQL.VARCHAR2_TABLE;
34: gIHLineNumTbl DBMS_SQL.NUMBER_TABLE;
35: gIHAllowPriceOverrideFlagTbl DBMS_SQL.VARCHAR2_TABLE;
36: gIHNotToExceedPriceTbl DBMS_SQL.NUMBER_TABLE;
37: gIHLineTypeIdTbl DBMS_SQL.NUMBER_TABLE;
38: gIHUnitMeasLookupCodeTbl DBMS_SQL.VARCHAR2_TABLE;
39: gIHSuggestedQuantityTbl DBMS_SQL.NUMBER_TABLE;
40: gIHUnitPriceTbl DBMS_SQL.NUMBER_TABLE;
41: gIHAmountTbl DBMS_SQL.NUMBER_TABLE;

Line 38: gIHUnitMeasLookupCodeTbl DBMS_SQL.VARCHAR2_TABLE;

34: gIHLineNumTbl DBMS_SQL.NUMBER_TABLE;
35: gIHAllowPriceOverrideFlagTbl DBMS_SQL.VARCHAR2_TABLE;
36: gIHNotToExceedPriceTbl DBMS_SQL.NUMBER_TABLE;
37: gIHLineTypeIdTbl DBMS_SQL.NUMBER_TABLE;
38: gIHUnitMeasLookupCodeTbl DBMS_SQL.VARCHAR2_TABLE;
39: gIHSuggestedQuantityTbl DBMS_SQL.NUMBER_TABLE;
40: gIHUnitPriceTbl DBMS_SQL.NUMBER_TABLE;
41: gIHAmountTbl DBMS_SQL.NUMBER_TABLE;
42: gIHCurrencyCodeTbl DBMS_SQL.VARCHAR2_TABLE;

Line 39: gIHSuggestedQuantityTbl DBMS_SQL.NUMBER_TABLE;

35: gIHAllowPriceOverrideFlagTbl DBMS_SQL.VARCHAR2_TABLE;
36: gIHNotToExceedPriceTbl DBMS_SQL.NUMBER_TABLE;
37: gIHLineTypeIdTbl DBMS_SQL.NUMBER_TABLE;
38: gIHUnitMeasLookupCodeTbl DBMS_SQL.VARCHAR2_TABLE;
39: gIHSuggestedQuantityTbl DBMS_SQL.NUMBER_TABLE;
40: gIHUnitPriceTbl DBMS_SQL.NUMBER_TABLE;
41: gIHAmountTbl DBMS_SQL.NUMBER_TABLE;
42: gIHCurrencyCodeTbl DBMS_SQL.VARCHAR2_TABLE;
43: gIHRateTypeTbl DBMS_SQL.VARCHAR2_TABLE;

Line 40: gIHUnitPriceTbl DBMS_SQL.NUMBER_TABLE;

36: gIHNotToExceedPriceTbl DBMS_SQL.NUMBER_TABLE;
37: gIHLineTypeIdTbl DBMS_SQL.NUMBER_TABLE;
38: gIHUnitMeasLookupCodeTbl DBMS_SQL.VARCHAR2_TABLE;
39: gIHSuggestedQuantityTbl DBMS_SQL.NUMBER_TABLE;
40: gIHUnitPriceTbl DBMS_SQL.NUMBER_TABLE;
41: gIHAmountTbl DBMS_SQL.NUMBER_TABLE;
42: gIHCurrencyCodeTbl DBMS_SQL.VARCHAR2_TABLE;
43: gIHRateTypeTbl DBMS_SQL.VARCHAR2_TABLE;
44: gIHRateDateTbl DBMS_SQL.DATE_TABLE;

Line 41: gIHAmountTbl DBMS_SQL.NUMBER_TABLE;

37: gIHLineTypeIdTbl DBMS_SQL.NUMBER_TABLE;
38: gIHUnitMeasLookupCodeTbl DBMS_SQL.VARCHAR2_TABLE;
39: gIHSuggestedQuantityTbl DBMS_SQL.NUMBER_TABLE;
40: gIHUnitPriceTbl DBMS_SQL.NUMBER_TABLE;
41: gIHAmountTbl DBMS_SQL.NUMBER_TABLE;
42: gIHCurrencyCodeTbl DBMS_SQL.VARCHAR2_TABLE;
43: gIHRateTypeTbl DBMS_SQL.VARCHAR2_TABLE;
44: gIHRateDateTbl DBMS_SQL.DATE_TABLE;
45: gIHRateTbl DBMS_SQL.NUMBER_TABLE;

Line 42: gIHCurrencyCodeTbl DBMS_SQL.VARCHAR2_TABLE;

38: gIHUnitMeasLookupCodeTbl DBMS_SQL.VARCHAR2_TABLE;
39: gIHSuggestedQuantityTbl DBMS_SQL.NUMBER_TABLE;
40: gIHUnitPriceTbl DBMS_SQL.NUMBER_TABLE;
41: gIHAmountTbl DBMS_SQL.NUMBER_TABLE;
42: gIHCurrencyCodeTbl DBMS_SQL.VARCHAR2_TABLE;
43: gIHRateTypeTbl DBMS_SQL.VARCHAR2_TABLE;
44: gIHRateDateTbl DBMS_SQL.DATE_TABLE;
45: gIHRateTbl DBMS_SQL.NUMBER_TABLE;
46: gIHBuyerIdTbl DBMS_SQL.NUMBER_TABLE;

Line 43: gIHRateTypeTbl DBMS_SQL.VARCHAR2_TABLE;

39: gIHSuggestedQuantityTbl DBMS_SQL.NUMBER_TABLE;
40: gIHUnitPriceTbl DBMS_SQL.NUMBER_TABLE;
41: gIHAmountTbl DBMS_SQL.NUMBER_TABLE;
42: gIHCurrencyCodeTbl DBMS_SQL.VARCHAR2_TABLE;
43: gIHRateTypeTbl DBMS_SQL.VARCHAR2_TABLE;
44: gIHRateDateTbl DBMS_SQL.DATE_TABLE;
45: gIHRateTbl DBMS_SQL.NUMBER_TABLE;
46: gIHBuyerIdTbl DBMS_SQL.NUMBER_TABLE;
47: gIHSupplierContactIdTbl DBMS_SQL.NUMBER_TABLE;

Line 44: gIHRateDateTbl DBMS_SQL.DATE_TABLE;

40: gIHUnitPriceTbl DBMS_SQL.NUMBER_TABLE;
41: gIHAmountTbl DBMS_SQL.NUMBER_TABLE;
42: gIHCurrencyCodeTbl DBMS_SQL.VARCHAR2_TABLE;
43: gIHRateTypeTbl DBMS_SQL.VARCHAR2_TABLE;
44: gIHRateDateTbl DBMS_SQL.DATE_TABLE;
45: gIHRateTbl DBMS_SQL.NUMBER_TABLE;
46: gIHBuyerIdTbl DBMS_SQL.NUMBER_TABLE;
47: gIHSupplierContactIdTbl DBMS_SQL.NUMBER_TABLE;
48: gIHRfqRequiredFlagTbl DBMS_SQL.VARCHAR2_TABLE;

Line 45: gIHRateTbl DBMS_SQL.NUMBER_TABLE;

41: gIHAmountTbl DBMS_SQL.NUMBER_TABLE;
42: gIHCurrencyCodeTbl DBMS_SQL.VARCHAR2_TABLE;
43: gIHRateTypeTbl DBMS_SQL.VARCHAR2_TABLE;
44: gIHRateDateTbl DBMS_SQL.DATE_TABLE;
45: gIHRateTbl DBMS_SQL.NUMBER_TABLE;
46: gIHBuyerIdTbl DBMS_SQL.NUMBER_TABLE;
47: gIHSupplierContactIdTbl DBMS_SQL.NUMBER_TABLE;
48: gIHRfqRequiredFlagTbl DBMS_SQL.VARCHAR2_TABLE;
49: gIHNegotiatedByPreparerFlagTbl DBMS_SQL.VARCHAR2_TABLE;

Line 46: gIHBuyerIdTbl DBMS_SQL.NUMBER_TABLE;

42: gIHCurrencyCodeTbl DBMS_SQL.VARCHAR2_TABLE;
43: gIHRateTypeTbl DBMS_SQL.VARCHAR2_TABLE;
44: gIHRateDateTbl DBMS_SQL.DATE_TABLE;
45: gIHRateTbl DBMS_SQL.NUMBER_TABLE;
46: gIHBuyerIdTbl DBMS_SQL.NUMBER_TABLE;
47: gIHSupplierContactIdTbl DBMS_SQL.NUMBER_TABLE;
48: gIHRfqRequiredFlagTbl DBMS_SQL.VARCHAR2_TABLE;
49: gIHNegotiatedByPreparerFlagTbl DBMS_SQL.VARCHAR2_TABLE;
50: gIHDescriptionTbl DBMS_SQL.VARCHAR2_TABLE;

Line 47: gIHSupplierContactIdTbl DBMS_SQL.NUMBER_TABLE;

43: gIHRateTypeTbl DBMS_SQL.VARCHAR2_TABLE;
44: gIHRateDateTbl DBMS_SQL.DATE_TABLE;
45: gIHRateTbl DBMS_SQL.NUMBER_TABLE;
46: gIHBuyerIdTbl DBMS_SQL.NUMBER_TABLE;
47: gIHSupplierContactIdTbl DBMS_SQL.NUMBER_TABLE;
48: gIHRfqRequiredFlagTbl DBMS_SQL.VARCHAR2_TABLE;
49: gIHNegotiatedByPreparerFlagTbl DBMS_SQL.VARCHAR2_TABLE;
50: gIHDescriptionTbl DBMS_SQL.VARCHAR2_TABLE;
51: --Bug6599217

Line 48: gIHRfqRequiredFlagTbl DBMS_SQL.VARCHAR2_TABLE;

44: gIHRateDateTbl DBMS_SQL.DATE_TABLE;
45: gIHRateTbl DBMS_SQL.NUMBER_TABLE;
46: gIHBuyerIdTbl DBMS_SQL.NUMBER_TABLE;
47: gIHSupplierContactIdTbl DBMS_SQL.NUMBER_TABLE;
48: gIHRfqRequiredFlagTbl DBMS_SQL.VARCHAR2_TABLE;
49: gIHNegotiatedByPreparerFlagTbl DBMS_SQL.VARCHAR2_TABLE;
50: gIHDescriptionTbl DBMS_SQL.VARCHAR2_TABLE;
51: --Bug6599217
52: gIHLongDescriptionTbl ICX_CAT_POPULATE_MI_PVT.VARCHAR4_TABLE;

Line 49: gIHNegotiatedByPreparerFlagTbl DBMS_SQL.VARCHAR2_TABLE;

45: gIHRateTbl DBMS_SQL.NUMBER_TABLE;
46: gIHBuyerIdTbl DBMS_SQL.NUMBER_TABLE;
47: gIHSupplierContactIdTbl DBMS_SQL.NUMBER_TABLE;
48: gIHRfqRequiredFlagTbl DBMS_SQL.VARCHAR2_TABLE;
49: gIHNegotiatedByPreparerFlagTbl DBMS_SQL.VARCHAR2_TABLE;
50: gIHDescriptionTbl DBMS_SQL.VARCHAR2_TABLE;
51: --Bug6599217
52: gIHLongDescriptionTbl ICX_CAT_POPULATE_MI_PVT.VARCHAR4_TABLE;
53: gIHOrganizationIdTbl DBMS_SQL.NUMBER_TABLE;

Line 50: gIHDescriptionTbl DBMS_SQL.VARCHAR2_TABLE;

46: gIHBuyerIdTbl DBMS_SQL.NUMBER_TABLE;
47: gIHSupplierContactIdTbl DBMS_SQL.NUMBER_TABLE;
48: gIHRfqRequiredFlagTbl DBMS_SQL.VARCHAR2_TABLE;
49: gIHNegotiatedByPreparerFlagTbl DBMS_SQL.VARCHAR2_TABLE;
50: gIHDescriptionTbl DBMS_SQL.VARCHAR2_TABLE;
51: --Bug6599217
52: gIHLongDescriptionTbl ICX_CAT_POPULATE_MI_PVT.VARCHAR4_TABLE;
53: gIHOrganizationIdTbl DBMS_SQL.NUMBER_TABLE;
54: gIHMasterOrganizationIdTbl DBMS_SQL.NUMBER_TABLE;

Line 53: gIHOrganizationIdTbl DBMS_SQL.NUMBER_TABLE;

49: gIHNegotiatedByPreparerFlagTbl DBMS_SQL.VARCHAR2_TABLE;
50: gIHDescriptionTbl DBMS_SQL.VARCHAR2_TABLE;
51: --Bug6599217
52: gIHLongDescriptionTbl ICX_CAT_POPULATE_MI_PVT.VARCHAR4_TABLE;
53: gIHOrganizationIdTbl DBMS_SQL.NUMBER_TABLE;
54: gIHMasterOrganizationIdTbl DBMS_SQL.NUMBER_TABLE;
55: gIHOrderTypeLookupCodeTbl DBMS_SQL.VARCHAR2_TABLE;
56: gIHSupplierTbl DBMS_SQL.VARCHAR2_TABLE;
57: gIHGlobalAgreementFlagTbl DBMS_SQL.VARCHAR2_TABLE;

Line 54: gIHMasterOrganizationIdTbl DBMS_SQL.NUMBER_TABLE;

50: gIHDescriptionTbl DBMS_SQL.VARCHAR2_TABLE;
51: --Bug6599217
52: gIHLongDescriptionTbl ICX_CAT_POPULATE_MI_PVT.VARCHAR4_TABLE;
53: gIHOrganizationIdTbl DBMS_SQL.NUMBER_TABLE;
54: gIHMasterOrganizationIdTbl DBMS_SQL.NUMBER_TABLE;
55: gIHOrderTypeLookupCodeTbl DBMS_SQL.VARCHAR2_TABLE;
56: gIHSupplierTbl DBMS_SQL.VARCHAR2_TABLE;
57: gIHGlobalAgreementFlagTbl DBMS_SQL.VARCHAR2_TABLE;
58: gIHMergedSourceTypeTbl DBMS_SQL.VARCHAR2_TABLE;

Line 55: gIHOrderTypeLookupCodeTbl DBMS_SQL.VARCHAR2_TABLE;

51: --Bug6599217
52: gIHLongDescriptionTbl ICX_CAT_POPULATE_MI_PVT.VARCHAR4_TABLE;
53: gIHOrganizationIdTbl DBMS_SQL.NUMBER_TABLE;
54: gIHMasterOrganizationIdTbl DBMS_SQL.NUMBER_TABLE;
55: gIHOrderTypeLookupCodeTbl DBMS_SQL.VARCHAR2_TABLE;
56: gIHSupplierTbl DBMS_SQL.VARCHAR2_TABLE;
57: gIHGlobalAgreementFlagTbl DBMS_SQL.VARCHAR2_TABLE;
58: gIHMergedSourceTypeTbl DBMS_SQL.VARCHAR2_TABLE;
59:

Line 56: gIHSupplierTbl DBMS_SQL.VARCHAR2_TABLE;

52: gIHLongDescriptionTbl ICX_CAT_POPULATE_MI_PVT.VARCHAR4_TABLE;
53: gIHOrganizationIdTbl DBMS_SQL.NUMBER_TABLE;
54: gIHMasterOrganizationIdTbl DBMS_SQL.NUMBER_TABLE;
55: gIHOrderTypeLookupCodeTbl DBMS_SQL.VARCHAR2_TABLE;
56: gIHSupplierTbl DBMS_SQL.VARCHAR2_TABLE;
57: gIHGlobalAgreementFlagTbl DBMS_SQL.VARCHAR2_TABLE;
58: gIHMergedSourceTypeTbl DBMS_SQL.VARCHAR2_TABLE;
59:
60: -- INSERT icx_cat_items_ctx_dtls_tlp

Line 57: gIHGlobalAgreementFlagTbl DBMS_SQL.VARCHAR2_TABLE;

53: gIHOrganizationIdTbl DBMS_SQL.NUMBER_TABLE;
54: gIHMasterOrganizationIdTbl DBMS_SQL.NUMBER_TABLE;
55: gIHOrderTypeLookupCodeTbl DBMS_SQL.VARCHAR2_TABLE;
56: gIHSupplierTbl DBMS_SQL.VARCHAR2_TABLE;
57: gIHGlobalAgreementFlagTbl DBMS_SQL.VARCHAR2_TABLE;
58: gIHMergedSourceTypeTbl DBMS_SQL.VARCHAR2_TABLE;
59:
60: -- INSERT icx_cat_items_ctx_dtls_tlp
61: gIDInventoryItemIdTbl DBMS_SQL.NUMBER_TABLE;

Line 58: gIHMergedSourceTypeTbl DBMS_SQL.VARCHAR2_TABLE;

54: gIHMasterOrganizationIdTbl DBMS_SQL.NUMBER_TABLE;
55: gIHOrderTypeLookupCodeTbl DBMS_SQL.VARCHAR2_TABLE;
56: gIHSupplierTbl DBMS_SQL.VARCHAR2_TABLE;
57: gIHGlobalAgreementFlagTbl DBMS_SQL.VARCHAR2_TABLE;
58: gIHMergedSourceTypeTbl DBMS_SQL.VARCHAR2_TABLE;
59:
60: -- INSERT icx_cat_items_ctx_dtls_tlp
61: gIDInventoryItemIdTbl DBMS_SQL.NUMBER_TABLE;
62: gIDPoLineIdTbl DBMS_SQL.NUMBER_TABLE;

Line 61: gIDInventoryItemIdTbl DBMS_SQL.NUMBER_TABLE;

57: gIHGlobalAgreementFlagTbl DBMS_SQL.VARCHAR2_TABLE;
58: gIHMergedSourceTypeTbl DBMS_SQL.VARCHAR2_TABLE;
59:
60: -- INSERT icx_cat_items_ctx_dtls_tlp
61: gIDInventoryItemIdTbl DBMS_SQL.NUMBER_TABLE;
62: gIDPoLineIdTbl DBMS_SQL.NUMBER_TABLE;
63: gIDReqTemplateNameTbl DBMS_SQL.VARCHAR2_TABLE;
64: gIDReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;
65: gIDOrgIdTbl DBMS_SQL.NUMBER_TABLE;

Line 62: gIDPoLineIdTbl DBMS_SQL.NUMBER_TABLE;

58: gIHMergedSourceTypeTbl DBMS_SQL.VARCHAR2_TABLE;
59:
60: -- INSERT icx_cat_items_ctx_dtls_tlp
61: gIDInventoryItemIdTbl DBMS_SQL.NUMBER_TABLE;
62: gIDPoLineIdTbl DBMS_SQL.NUMBER_TABLE;
63: gIDReqTemplateNameTbl DBMS_SQL.VARCHAR2_TABLE;
64: gIDReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;
65: gIDOrgIdTbl DBMS_SQL.NUMBER_TABLE;
66: gIDLanguageTbl DBMS_SQL.VARCHAR2_TABLE;

Line 63: gIDReqTemplateNameTbl DBMS_SQL.VARCHAR2_TABLE;

59:
60: -- INSERT icx_cat_items_ctx_dtls_tlp
61: gIDInventoryItemIdTbl DBMS_SQL.NUMBER_TABLE;
62: gIDPoLineIdTbl DBMS_SQL.NUMBER_TABLE;
63: gIDReqTemplateNameTbl DBMS_SQL.VARCHAR2_TABLE;
64: gIDReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;
65: gIDOrgIdTbl DBMS_SQL.NUMBER_TABLE;
66: gIDLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
67: gIDPurchasingOrgIdTbl DBMS_SQL.NUMBER_TABLE;

Line 64: gIDReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;

60: -- INSERT icx_cat_items_ctx_dtls_tlp
61: gIDInventoryItemIdTbl DBMS_SQL.NUMBER_TABLE;
62: gIDPoLineIdTbl DBMS_SQL.NUMBER_TABLE;
63: gIDReqTemplateNameTbl DBMS_SQL.VARCHAR2_TABLE;
64: gIDReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;
65: gIDOrgIdTbl DBMS_SQL.NUMBER_TABLE;
66: gIDLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
67: gIDPurchasingOrgIdTbl DBMS_SQL.NUMBER_TABLE;
68: gIDOwningOrgIdTbl DBMS_SQL.NUMBER_TABLE;

Line 65: gIDOrgIdTbl DBMS_SQL.NUMBER_TABLE;

61: gIDInventoryItemIdTbl DBMS_SQL.NUMBER_TABLE;
62: gIDPoLineIdTbl DBMS_SQL.NUMBER_TABLE;
63: gIDReqTemplateNameTbl DBMS_SQL.VARCHAR2_TABLE;
64: gIDReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;
65: gIDOrgIdTbl DBMS_SQL.NUMBER_TABLE;
66: gIDLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
67: gIDPurchasingOrgIdTbl DBMS_SQL.NUMBER_TABLE;
68: gIDOwningOrgIdTbl DBMS_SQL.NUMBER_TABLE;
69:

Line 66: gIDLanguageTbl DBMS_SQL.VARCHAR2_TABLE;

62: gIDPoLineIdTbl DBMS_SQL.NUMBER_TABLE;
63: gIDReqTemplateNameTbl DBMS_SQL.VARCHAR2_TABLE;
64: gIDReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;
65: gIDOrgIdTbl DBMS_SQL.NUMBER_TABLE;
66: gIDLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
67: gIDPurchasingOrgIdTbl DBMS_SQL.NUMBER_TABLE;
68: gIDOwningOrgIdTbl DBMS_SQL.NUMBER_TABLE;
69:
70: -- UPDATE icx_cat_items_ctx_hdrs_tlp

Line 67: gIDPurchasingOrgIdTbl DBMS_SQL.NUMBER_TABLE;

63: gIDReqTemplateNameTbl DBMS_SQL.VARCHAR2_TABLE;
64: gIDReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;
65: gIDOrgIdTbl DBMS_SQL.NUMBER_TABLE;
66: gIDLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
67: gIDPurchasingOrgIdTbl DBMS_SQL.NUMBER_TABLE;
68: gIDOwningOrgIdTbl DBMS_SQL.NUMBER_TABLE;
69:
70: -- UPDATE icx_cat_items_ctx_hdrs_tlp
71: gUHInventoryItemIdTbl DBMS_SQL.NUMBER_TABLE;

Line 68: gIDOwningOrgIdTbl DBMS_SQL.NUMBER_TABLE;

64: gIDReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;
65: gIDOrgIdTbl DBMS_SQL.NUMBER_TABLE;
66: gIDLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
67: gIDPurchasingOrgIdTbl DBMS_SQL.NUMBER_TABLE;
68: gIDOwningOrgIdTbl DBMS_SQL.NUMBER_TABLE;
69:
70: -- UPDATE icx_cat_items_ctx_hdrs_tlp
71: gUHInventoryItemIdTbl DBMS_SQL.NUMBER_TABLE;
72: gUHPoLineIdTbl DBMS_SQL.NUMBER_TABLE;

Line 71: gUHInventoryItemIdTbl DBMS_SQL.NUMBER_TABLE;

67: gIDPurchasingOrgIdTbl DBMS_SQL.NUMBER_TABLE;
68: gIDOwningOrgIdTbl DBMS_SQL.NUMBER_TABLE;
69:
70: -- UPDATE icx_cat_items_ctx_hdrs_tlp
71: gUHInventoryItemIdTbl DBMS_SQL.NUMBER_TABLE;
72: gUHPoLineIdTbl DBMS_SQL.NUMBER_TABLE;
73: gUHReqTemplateNameTbl DBMS_SQL.VARCHAR2_TABLE;
74: gUHReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;
75: gUHOrgIdTbl DBMS_SQL.NUMBER_TABLE;

Line 72: gUHPoLineIdTbl DBMS_SQL.NUMBER_TABLE;

68: gIDOwningOrgIdTbl DBMS_SQL.NUMBER_TABLE;
69:
70: -- UPDATE icx_cat_items_ctx_hdrs_tlp
71: gUHInventoryItemIdTbl DBMS_SQL.NUMBER_TABLE;
72: gUHPoLineIdTbl DBMS_SQL.NUMBER_TABLE;
73: gUHReqTemplateNameTbl DBMS_SQL.VARCHAR2_TABLE;
74: gUHReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;
75: gUHOrgIdTbl DBMS_SQL.NUMBER_TABLE;
76: gUHLanguageTbl DBMS_SQL.VARCHAR2_TABLE;

Line 73: gUHReqTemplateNameTbl DBMS_SQL.VARCHAR2_TABLE;

69:
70: -- UPDATE icx_cat_items_ctx_hdrs_tlp
71: gUHInventoryItemIdTbl DBMS_SQL.NUMBER_TABLE;
72: gUHPoLineIdTbl DBMS_SQL.NUMBER_TABLE;
73: gUHReqTemplateNameTbl DBMS_SQL.VARCHAR2_TABLE;
74: gUHReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;
75: gUHOrgIdTbl DBMS_SQL.NUMBER_TABLE;
76: gUHLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
77: gUHSourceTypeTbl DBMS_SQL.VARCHAR2_TABLE;

Line 74: gUHReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;

70: -- UPDATE icx_cat_items_ctx_hdrs_tlp
71: gUHInventoryItemIdTbl DBMS_SQL.NUMBER_TABLE;
72: gUHPoLineIdTbl DBMS_SQL.NUMBER_TABLE;
73: gUHReqTemplateNameTbl DBMS_SQL.VARCHAR2_TABLE;
74: gUHReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;
75: gUHOrgIdTbl DBMS_SQL.NUMBER_TABLE;
76: gUHLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
77: gUHSourceTypeTbl DBMS_SQL.VARCHAR2_TABLE;
78: gUHItemTypeTbl DBMS_SQL.VARCHAR2_TABLE;

Line 75: gUHOrgIdTbl DBMS_SQL.NUMBER_TABLE;

71: gUHInventoryItemIdTbl DBMS_SQL.NUMBER_TABLE;
72: gUHPoLineIdTbl DBMS_SQL.NUMBER_TABLE;
73: gUHReqTemplateNameTbl DBMS_SQL.VARCHAR2_TABLE;
74: gUHReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;
75: gUHOrgIdTbl DBMS_SQL.NUMBER_TABLE;
76: gUHLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
77: gUHSourceTypeTbl DBMS_SQL.VARCHAR2_TABLE;
78: gUHItemTypeTbl DBMS_SQL.VARCHAR2_TABLE;
79: gUHPurchasingOrgIdTbl DBMS_SQL.NUMBER_TABLE;

Line 76: gUHLanguageTbl DBMS_SQL.VARCHAR2_TABLE;

72: gUHPoLineIdTbl DBMS_SQL.NUMBER_TABLE;
73: gUHReqTemplateNameTbl DBMS_SQL.VARCHAR2_TABLE;
74: gUHReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;
75: gUHOrgIdTbl DBMS_SQL.NUMBER_TABLE;
76: gUHLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
77: gUHSourceTypeTbl DBMS_SQL.VARCHAR2_TABLE;
78: gUHItemTypeTbl DBMS_SQL.VARCHAR2_TABLE;
79: gUHPurchasingOrgIdTbl DBMS_SQL.NUMBER_TABLE;
80: gUHIpCategoryIdTbl DBMS_SQL.NUMBER_TABLE;

Line 77: gUHSourceTypeTbl DBMS_SQL.VARCHAR2_TABLE;

73: gUHReqTemplateNameTbl DBMS_SQL.VARCHAR2_TABLE;
74: gUHReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;
75: gUHOrgIdTbl DBMS_SQL.NUMBER_TABLE;
76: gUHLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
77: gUHSourceTypeTbl DBMS_SQL.VARCHAR2_TABLE;
78: gUHItemTypeTbl DBMS_SQL.VARCHAR2_TABLE;
79: gUHPurchasingOrgIdTbl DBMS_SQL.NUMBER_TABLE;
80: gUHIpCategoryIdTbl DBMS_SQL.NUMBER_TABLE;
81: gUHIpCategoryNameTbl DBMS_SQL.VARCHAR2_TABLE;

Line 78: gUHItemTypeTbl DBMS_SQL.VARCHAR2_TABLE;

74: gUHReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;
75: gUHOrgIdTbl DBMS_SQL.NUMBER_TABLE;
76: gUHLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
77: gUHSourceTypeTbl DBMS_SQL.VARCHAR2_TABLE;
78: gUHItemTypeTbl DBMS_SQL.VARCHAR2_TABLE;
79: gUHPurchasingOrgIdTbl DBMS_SQL.NUMBER_TABLE;
80: gUHIpCategoryIdTbl DBMS_SQL.NUMBER_TABLE;
81: gUHIpCategoryNameTbl DBMS_SQL.VARCHAR2_TABLE;
82: gUHPoCategoryIdTbl DBMS_SQL.NUMBER_TABLE;

Line 79: gUHPurchasingOrgIdTbl DBMS_SQL.NUMBER_TABLE;

75: gUHOrgIdTbl DBMS_SQL.NUMBER_TABLE;
76: gUHLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
77: gUHSourceTypeTbl DBMS_SQL.VARCHAR2_TABLE;
78: gUHItemTypeTbl DBMS_SQL.VARCHAR2_TABLE;
79: gUHPurchasingOrgIdTbl DBMS_SQL.NUMBER_TABLE;
80: gUHIpCategoryIdTbl DBMS_SQL.NUMBER_TABLE;
81: gUHIpCategoryNameTbl DBMS_SQL.VARCHAR2_TABLE;
82: gUHPoCategoryIdTbl DBMS_SQL.NUMBER_TABLE;
83: gUHSupplierIdTbl DBMS_SQL.NUMBER_TABLE;

Line 80: gUHIpCategoryIdTbl DBMS_SQL.NUMBER_TABLE;

76: gUHLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
77: gUHSourceTypeTbl DBMS_SQL.VARCHAR2_TABLE;
78: gUHItemTypeTbl DBMS_SQL.VARCHAR2_TABLE;
79: gUHPurchasingOrgIdTbl DBMS_SQL.NUMBER_TABLE;
80: gUHIpCategoryIdTbl DBMS_SQL.NUMBER_TABLE;
81: gUHIpCategoryNameTbl DBMS_SQL.VARCHAR2_TABLE;
82: gUHPoCategoryIdTbl DBMS_SQL.NUMBER_TABLE;
83: gUHSupplierIdTbl DBMS_SQL.NUMBER_TABLE;
84: gUHSupplierPartNumTbl DBMS_SQL.VARCHAR2_TABLE;

Line 81: gUHIpCategoryNameTbl DBMS_SQL.VARCHAR2_TABLE;

77: gUHSourceTypeTbl DBMS_SQL.VARCHAR2_TABLE;
78: gUHItemTypeTbl DBMS_SQL.VARCHAR2_TABLE;
79: gUHPurchasingOrgIdTbl DBMS_SQL.NUMBER_TABLE;
80: gUHIpCategoryIdTbl DBMS_SQL.NUMBER_TABLE;
81: gUHIpCategoryNameTbl DBMS_SQL.VARCHAR2_TABLE;
82: gUHPoCategoryIdTbl DBMS_SQL.NUMBER_TABLE;
83: gUHSupplierIdTbl DBMS_SQL.NUMBER_TABLE;
84: gUHSupplierPartNumTbl DBMS_SQL.VARCHAR2_TABLE;
85: gUHSupplierPartAuxidTbl DBMS_SQL.VARCHAR2_TABLE;

Line 82: gUHPoCategoryIdTbl DBMS_SQL.NUMBER_TABLE;

78: gUHItemTypeTbl DBMS_SQL.VARCHAR2_TABLE;
79: gUHPurchasingOrgIdTbl DBMS_SQL.NUMBER_TABLE;
80: gUHIpCategoryIdTbl DBMS_SQL.NUMBER_TABLE;
81: gUHIpCategoryNameTbl DBMS_SQL.VARCHAR2_TABLE;
82: gUHPoCategoryIdTbl DBMS_SQL.NUMBER_TABLE;
83: gUHSupplierIdTbl DBMS_SQL.NUMBER_TABLE;
84: gUHSupplierPartNumTbl DBMS_SQL.VARCHAR2_TABLE;
85: gUHSupplierPartAuxidTbl DBMS_SQL.VARCHAR2_TABLE;
86: gUHSupplierSiteIdTbl DBMS_SQL.NUMBER_TABLE;

Line 83: gUHSupplierIdTbl DBMS_SQL.NUMBER_TABLE;

79: gUHPurchasingOrgIdTbl DBMS_SQL.NUMBER_TABLE;
80: gUHIpCategoryIdTbl DBMS_SQL.NUMBER_TABLE;
81: gUHIpCategoryNameTbl DBMS_SQL.VARCHAR2_TABLE;
82: gUHPoCategoryIdTbl DBMS_SQL.NUMBER_TABLE;
83: gUHSupplierIdTbl DBMS_SQL.NUMBER_TABLE;
84: gUHSupplierPartNumTbl DBMS_SQL.VARCHAR2_TABLE;
85: gUHSupplierPartAuxidTbl DBMS_SQL.VARCHAR2_TABLE;
86: gUHSupplierSiteIdTbl DBMS_SQL.NUMBER_TABLE;
87: gUHReqTemplatePoLineIdTbl DBMS_SQL.NUMBER_TABLE;

Line 84: gUHSupplierPartNumTbl DBMS_SQL.VARCHAR2_TABLE;

80: gUHIpCategoryIdTbl DBMS_SQL.NUMBER_TABLE;
81: gUHIpCategoryNameTbl DBMS_SQL.VARCHAR2_TABLE;
82: gUHPoCategoryIdTbl DBMS_SQL.NUMBER_TABLE;
83: gUHSupplierIdTbl DBMS_SQL.NUMBER_TABLE;
84: gUHSupplierPartNumTbl DBMS_SQL.VARCHAR2_TABLE;
85: gUHSupplierPartAuxidTbl DBMS_SQL.VARCHAR2_TABLE;
86: gUHSupplierSiteIdTbl DBMS_SQL.NUMBER_TABLE;
87: gUHReqTemplatePoLineIdTbl DBMS_SQL.NUMBER_TABLE;
88: gUHItemRevisionTbl DBMS_SQL.VARCHAR2_TABLE;

Line 85: gUHSupplierPartAuxidTbl DBMS_SQL.VARCHAR2_TABLE;

81: gUHIpCategoryNameTbl DBMS_SQL.VARCHAR2_TABLE;
82: gUHPoCategoryIdTbl DBMS_SQL.NUMBER_TABLE;
83: gUHSupplierIdTbl DBMS_SQL.NUMBER_TABLE;
84: gUHSupplierPartNumTbl DBMS_SQL.VARCHAR2_TABLE;
85: gUHSupplierPartAuxidTbl DBMS_SQL.VARCHAR2_TABLE;
86: gUHSupplierSiteIdTbl DBMS_SQL.NUMBER_TABLE;
87: gUHReqTemplatePoLineIdTbl DBMS_SQL.NUMBER_TABLE;
88: gUHItemRevisionTbl DBMS_SQL.VARCHAR2_TABLE;
89: gUHPoHeaderIdTbl DBMS_SQL.NUMBER_TABLE;

Line 86: gUHSupplierSiteIdTbl DBMS_SQL.NUMBER_TABLE;

82: gUHPoCategoryIdTbl DBMS_SQL.NUMBER_TABLE;
83: gUHSupplierIdTbl DBMS_SQL.NUMBER_TABLE;
84: gUHSupplierPartNumTbl DBMS_SQL.VARCHAR2_TABLE;
85: gUHSupplierPartAuxidTbl DBMS_SQL.VARCHAR2_TABLE;
86: gUHSupplierSiteIdTbl DBMS_SQL.NUMBER_TABLE;
87: gUHReqTemplatePoLineIdTbl DBMS_SQL.NUMBER_TABLE;
88: gUHItemRevisionTbl DBMS_SQL.VARCHAR2_TABLE;
89: gUHPoHeaderIdTbl DBMS_SQL.NUMBER_TABLE;
90: gUHDocumentNumberTbl DBMS_SQL.VARCHAR2_TABLE;

Line 87: gUHReqTemplatePoLineIdTbl DBMS_SQL.NUMBER_TABLE;

83: gUHSupplierIdTbl DBMS_SQL.NUMBER_TABLE;
84: gUHSupplierPartNumTbl DBMS_SQL.VARCHAR2_TABLE;
85: gUHSupplierPartAuxidTbl DBMS_SQL.VARCHAR2_TABLE;
86: gUHSupplierSiteIdTbl DBMS_SQL.NUMBER_TABLE;
87: gUHReqTemplatePoLineIdTbl DBMS_SQL.NUMBER_TABLE;
88: gUHItemRevisionTbl DBMS_SQL.VARCHAR2_TABLE;
89: gUHPoHeaderIdTbl DBMS_SQL.NUMBER_TABLE;
90: gUHDocumentNumberTbl DBMS_SQL.VARCHAR2_TABLE;
91: gUHLineNumTbl DBMS_SQL.NUMBER_TABLE;

Line 88: gUHItemRevisionTbl DBMS_SQL.VARCHAR2_TABLE;

84: gUHSupplierPartNumTbl DBMS_SQL.VARCHAR2_TABLE;
85: gUHSupplierPartAuxidTbl DBMS_SQL.VARCHAR2_TABLE;
86: gUHSupplierSiteIdTbl DBMS_SQL.NUMBER_TABLE;
87: gUHReqTemplatePoLineIdTbl DBMS_SQL.NUMBER_TABLE;
88: gUHItemRevisionTbl DBMS_SQL.VARCHAR2_TABLE;
89: gUHPoHeaderIdTbl DBMS_SQL.NUMBER_TABLE;
90: gUHDocumentNumberTbl DBMS_SQL.VARCHAR2_TABLE;
91: gUHLineNumTbl DBMS_SQL.NUMBER_TABLE;
92: gUHAllowPriceOverrideFlagTbl DBMS_SQL.VARCHAR2_TABLE;

Line 89: gUHPoHeaderIdTbl DBMS_SQL.NUMBER_TABLE;

85: gUHSupplierPartAuxidTbl DBMS_SQL.VARCHAR2_TABLE;
86: gUHSupplierSiteIdTbl DBMS_SQL.NUMBER_TABLE;
87: gUHReqTemplatePoLineIdTbl DBMS_SQL.NUMBER_TABLE;
88: gUHItemRevisionTbl DBMS_SQL.VARCHAR2_TABLE;
89: gUHPoHeaderIdTbl DBMS_SQL.NUMBER_TABLE;
90: gUHDocumentNumberTbl DBMS_SQL.VARCHAR2_TABLE;
91: gUHLineNumTbl DBMS_SQL.NUMBER_TABLE;
92: gUHAllowPriceOverrideFlagTbl DBMS_SQL.VARCHAR2_TABLE;
93: gUHNotToExceedPriceTbl DBMS_SQL.NUMBER_TABLE;

Line 90: gUHDocumentNumberTbl DBMS_SQL.VARCHAR2_TABLE;

86: gUHSupplierSiteIdTbl DBMS_SQL.NUMBER_TABLE;
87: gUHReqTemplatePoLineIdTbl DBMS_SQL.NUMBER_TABLE;
88: gUHItemRevisionTbl DBMS_SQL.VARCHAR2_TABLE;
89: gUHPoHeaderIdTbl DBMS_SQL.NUMBER_TABLE;
90: gUHDocumentNumberTbl DBMS_SQL.VARCHAR2_TABLE;
91: gUHLineNumTbl DBMS_SQL.NUMBER_TABLE;
92: gUHAllowPriceOverrideFlagTbl DBMS_SQL.VARCHAR2_TABLE;
93: gUHNotToExceedPriceTbl DBMS_SQL.NUMBER_TABLE;
94: gUHLineTypeIdTbl DBMS_SQL.NUMBER_TABLE;

Line 91: gUHLineNumTbl DBMS_SQL.NUMBER_TABLE;

87: gUHReqTemplatePoLineIdTbl DBMS_SQL.NUMBER_TABLE;
88: gUHItemRevisionTbl DBMS_SQL.VARCHAR2_TABLE;
89: gUHPoHeaderIdTbl DBMS_SQL.NUMBER_TABLE;
90: gUHDocumentNumberTbl DBMS_SQL.VARCHAR2_TABLE;
91: gUHLineNumTbl DBMS_SQL.NUMBER_TABLE;
92: gUHAllowPriceOverrideFlagTbl DBMS_SQL.VARCHAR2_TABLE;
93: gUHNotToExceedPriceTbl DBMS_SQL.NUMBER_TABLE;
94: gUHLineTypeIdTbl DBMS_SQL.NUMBER_TABLE;
95: gUHUnitMeasLookupCodeTbl DBMS_SQL.VARCHAR2_TABLE;

Line 92: gUHAllowPriceOverrideFlagTbl DBMS_SQL.VARCHAR2_TABLE;

88: gUHItemRevisionTbl DBMS_SQL.VARCHAR2_TABLE;
89: gUHPoHeaderIdTbl DBMS_SQL.NUMBER_TABLE;
90: gUHDocumentNumberTbl DBMS_SQL.VARCHAR2_TABLE;
91: gUHLineNumTbl DBMS_SQL.NUMBER_TABLE;
92: gUHAllowPriceOverrideFlagTbl DBMS_SQL.VARCHAR2_TABLE;
93: gUHNotToExceedPriceTbl DBMS_SQL.NUMBER_TABLE;
94: gUHLineTypeIdTbl DBMS_SQL.NUMBER_TABLE;
95: gUHUnitMeasLookupCodeTbl DBMS_SQL.VARCHAR2_TABLE;
96: gUHSuggestedQuantityTbl DBMS_SQL.NUMBER_TABLE;

Line 93: gUHNotToExceedPriceTbl DBMS_SQL.NUMBER_TABLE;

89: gUHPoHeaderIdTbl DBMS_SQL.NUMBER_TABLE;
90: gUHDocumentNumberTbl DBMS_SQL.VARCHAR2_TABLE;
91: gUHLineNumTbl DBMS_SQL.NUMBER_TABLE;
92: gUHAllowPriceOverrideFlagTbl DBMS_SQL.VARCHAR2_TABLE;
93: gUHNotToExceedPriceTbl DBMS_SQL.NUMBER_TABLE;
94: gUHLineTypeIdTbl DBMS_SQL.NUMBER_TABLE;
95: gUHUnitMeasLookupCodeTbl DBMS_SQL.VARCHAR2_TABLE;
96: gUHSuggestedQuantityTbl DBMS_SQL.NUMBER_TABLE;
97: gUHUnitPriceTbl DBMS_SQL.NUMBER_TABLE;

Line 94: gUHLineTypeIdTbl DBMS_SQL.NUMBER_TABLE;

90: gUHDocumentNumberTbl DBMS_SQL.VARCHAR2_TABLE;
91: gUHLineNumTbl DBMS_SQL.NUMBER_TABLE;
92: gUHAllowPriceOverrideFlagTbl DBMS_SQL.VARCHAR2_TABLE;
93: gUHNotToExceedPriceTbl DBMS_SQL.NUMBER_TABLE;
94: gUHLineTypeIdTbl DBMS_SQL.NUMBER_TABLE;
95: gUHUnitMeasLookupCodeTbl DBMS_SQL.VARCHAR2_TABLE;
96: gUHSuggestedQuantityTbl DBMS_SQL.NUMBER_TABLE;
97: gUHUnitPriceTbl DBMS_SQL.NUMBER_TABLE;
98: gUHAmountTbl DBMS_SQL.NUMBER_TABLE;

Line 95: gUHUnitMeasLookupCodeTbl DBMS_SQL.VARCHAR2_TABLE;

91: gUHLineNumTbl DBMS_SQL.NUMBER_TABLE;
92: gUHAllowPriceOverrideFlagTbl DBMS_SQL.VARCHAR2_TABLE;
93: gUHNotToExceedPriceTbl DBMS_SQL.NUMBER_TABLE;
94: gUHLineTypeIdTbl DBMS_SQL.NUMBER_TABLE;
95: gUHUnitMeasLookupCodeTbl DBMS_SQL.VARCHAR2_TABLE;
96: gUHSuggestedQuantityTbl DBMS_SQL.NUMBER_TABLE;
97: gUHUnitPriceTbl DBMS_SQL.NUMBER_TABLE;
98: gUHAmountTbl DBMS_SQL.NUMBER_TABLE;
99: gUHCurrencyCodeTbl DBMS_SQL.VARCHAR2_TABLE;

Line 96: gUHSuggestedQuantityTbl DBMS_SQL.NUMBER_TABLE;

92: gUHAllowPriceOverrideFlagTbl DBMS_SQL.VARCHAR2_TABLE;
93: gUHNotToExceedPriceTbl DBMS_SQL.NUMBER_TABLE;
94: gUHLineTypeIdTbl DBMS_SQL.NUMBER_TABLE;
95: gUHUnitMeasLookupCodeTbl DBMS_SQL.VARCHAR2_TABLE;
96: gUHSuggestedQuantityTbl DBMS_SQL.NUMBER_TABLE;
97: gUHUnitPriceTbl DBMS_SQL.NUMBER_TABLE;
98: gUHAmountTbl DBMS_SQL.NUMBER_TABLE;
99: gUHCurrencyCodeTbl DBMS_SQL.VARCHAR2_TABLE;
100: gUHRateTypeTbl DBMS_SQL.VARCHAR2_TABLE;

Line 97: gUHUnitPriceTbl DBMS_SQL.NUMBER_TABLE;

93: gUHNotToExceedPriceTbl DBMS_SQL.NUMBER_TABLE;
94: gUHLineTypeIdTbl DBMS_SQL.NUMBER_TABLE;
95: gUHUnitMeasLookupCodeTbl DBMS_SQL.VARCHAR2_TABLE;
96: gUHSuggestedQuantityTbl DBMS_SQL.NUMBER_TABLE;
97: gUHUnitPriceTbl DBMS_SQL.NUMBER_TABLE;
98: gUHAmountTbl DBMS_SQL.NUMBER_TABLE;
99: gUHCurrencyCodeTbl DBMS_SQL.VARCHAR2_TABLE;
100: gUHRateTypeTbl DBMS_SQL.VARCHAR2_TABLE;
101: gUHRateDateTbl DBMS_SQL.DATE_TABLE;

Line 98: gUHAmountTbl DBMS_SQL.NUMBER_TABLE;

94: gUHLineTypeIdTbl DBMS_SQL.NUMBER_TABLE;
95: gUHUnitMeasLookupCodeTbl DBMS_SQL.VARCHAR2_TABLE;
96: gUHSuggestedQuantityTbl DBMS_SQL.NUMBER_TABLE;
97: gUHUnitPriceTbl DBMS_SQL.NUMBER_TABLE;
98: gUHAmountTbl DBMS_SQL.NUMBER_TABLE;
99: gUHCurrencyCodeTbl DBMS_SQL.VARCHAR2_TABLE;
100: gUHRateTypeTbl DBMS_SQL.VARCHAR2_TABLE;
101: gUHRateDateTbl DBMS_SQL.DATE_TABLE;
102: gUHRateTbl DBMS_SQL.NUMBER_TABLE;

Line 99: gUHCurrencyCodeTbl DBMS_SQL.VARCHAR2_TABLE;

95: gUHUnitMeasLookupCodeTbl DBMS_SQL.VARCHAR2_TABLE;
96: gUHSuggestedQuantityTbl DBMS_SQL.NUMBER_TABLE;
97: gUHUnitPriceTbl DBMS_SQL.NUMBER_TABLE;
98: gUHAmountTbl DBMS_SQL.NUMBER_TABLE;
99: gUHCurrencyCodeTbl DBMS_SQL.VARCHAR2_TABLE;
100: gUHRateTypeTbl DBMS_SQL.VARCHAR2_TABLE;
101: gUHRateDateTbl DBMS_SQL.DATE_TABLE;
102: gUHRateTbl DBMS_SQL.NUMBER_TABLE;
103: gUHBuyerIdTbl DBMS_SQL.NUMBER_TABLE;

Line 100: gUHRateTypeTbl DBMS_SQL.VARCHAR2_TABLE;

96: gUHSuggestedQuantityTbl DBMS_SQL.NUMBER_TABLE;
97: gUHUnitPriceTbl DBMS_SQL.NUMBER_TABLE;
98: gUHAmountTbl DBMS_SQL.NUMBER_TABLE;
99: gUHCurrencyCodeTbl DBMS_SQL.VARCHAR2_TABLE;
100: gUHRateTypeTbl DBMS_SQL.VARCHAR2_TABLE;
101: gUHRateDateTbl DBMS_SQL.DATE_TABLE;
102: gUHRateTbl DBMS_SQL.NUMBER_TABLE;
103: gUHBuyerIdTbl DBMS_SQL.NUMBER_TABLE;
104: gUHSupplierContactIdTbl DBMS_SQL.NUMBER_TABLE;

Line 101: gUHRateDateTbl DBMS_SQL.DATE_TABLE;

97: gUHUnitPriceTbl DBMS_SQL.NUMBER_TABLE;
98: gUHAmountTbl DBMS_SQL.NUMBER_TABLE;
99: gUHCurrencyCodeTbl DBMS_SQL.VARCHAR2_TABLE;
100: gUHRateTypeTbl DBMS_SQL.VARCHAR2_TABLE;
101: gUHRateDateTbl DBMS_SQL.DATE_TABLE;
102: gUHRateTbl DBMS_SQL.NUMBER_TABLE;
103: gUHBuyerIdTbl DBMS_SQL.NUMBER_TABLE;
104: gUHSupplierContactIdTbl DBMS_SQL.NUMBER_TABLE;
105: gUHRfqRequiredFlagTbl DBMS_SQL.VARCHAR2_TABLE;

Line 102: gUHRateTbl DBMS_SQL.NUMBER_TABLE;

98: gUHAmountTbl DBMS_SQL.NUMBER_TABLE;
99: gUHCurrencyCodeTbl DBMS_SQL.VARCHAR2_TABLE;
100: gUHRateTypeTbl DBMS_SQL.VARCHAR2_TABLE;
101: gUHRateDateTbl DBMS_SQL.DATE_TABLE;
102: gUHRateTbl DBMS_SQL.NUMBER_TABLE;
103: gUHBuyerIdTbl DBMS_SQL.NUMBER_TABLE;
104: gUHSupplierContactIdTbl DBMS_SQL.NUMBER_TABLE;
105: gUHRfqRequiredFlagTbl DBMS_SQL.VARCHAR2_TABLE;
106: gUHNegotiatedByPreparerFlagTbl DBMS_SQL.VARCHAR2_TABLE;

Line 103: gUHBuyerIdTbl DBMS_SQL.NUMBER_TABLE;

99: gUHCurrencyCodeTbl DBMS_SQL.VARCHAR2_TABLE;
100: gUHRateTypeTbl DBMS_SQL.VARCHAR2_TABLE;
101: gUHRateDateTbl DBMS_SQL.DATE_TABLE;
102: gUHRateTbl DBMS_SQL.NUMBER_TABLE;
103: gUHBuyerIdTbl DBMS_SQL.NUMBER_TABLE;
104: gUHSupplierContactIdTbl DBMS_SQL.NUMBER_TABLE;
105: gUHRfqRequiredFlagTbl DBMS_SQL.VARCHAR2_TABLE;
106: gUHNegotiatedByPreparerFlagTbl DBMS_SQL.VARCHAR2_TABLE;
107: gUHDescriptionTbl DBMS_SQL.VARCHAR2_TABLE;

Line 104: gUHSupplierContactIdTbl DBMS_SQL.NUMBER_TABLE;

100: gUHRateTypeTbl DBMS_SQL.VARCHAR2_TABLE;
101: gUHRateDateTbl DBMS_SQL.DATE_TABLE;
102: gUHRateTbl DBMS_SQL.NUMBER_TABLE;
103: gUHBuyerIdTbl DBMS_SQL.NUMBER_TABLE;
104: gUHSupplierContactIdTbl DBMS_SQL.NUMBER_TABLE;
105: gUHRfqRequiredFlagTbl DBMS_SQL.VARCHAR2_TABLE;
106: gUHNegotiatedByPreparerFlagTbl DBMS_SQL.VARCHAR2_TABLE;
107: gUHDescriptionTbl DBMS_SQL.VARCHAR2_TABLE;
108: --Bug6599217

Line 105: gUHRfqRequiredFlagTbl DBMS_SQL.VARCHAR2_TABLE;

101: gUHRateDateTbl DBMS_SQL.DATE_TABLE;
102: gUHRateTbl DBMS_SQL.NUMBER_TABLE;
103: gUHBuyerIdTbl DBMS_SQL.NUMBER_TABLE;
104: gUHSupplierContactIdTbl DBMS_SQL.NUMBER_TABLE;
105: gUHRfqRequiredFlagTbl DBMS_SQL.VARCHAR2_TABLE;
106: gUHNegotiatedByPreparerFlagTbl DBMS_SQL.VARCHAR2_TABLE;
107: gUHDescriptionTbl DBMS_SQL.VARCHAR2_TABLE;
108: --Bug6599217
109: gUHLongDescriptionTbl ICX_CAT_POPULATE_MI_PVT.VARCHAR4_TABLE;

Line 106: gUHNegotiatedByPreparerFlagTbl DBMS_SQL.VARCHAR2_TABLE;

102: gUHRateTbl DBMS_SQL.NUMBER_TABLE;
103: gUHBuyerIdTbl DBMS_SQL.NUMBER_TABLE;
104: gUHSupplierContactIdTbl DBMS_SQL.NUMBER_TABLE;
105: gUHRfqRequiredFlagTbl DBMS_SQL.VARCHAR2_TABLE;
106: gUHNegotiatedByPreparerFlagTbl DBMS_SQL.VARCHAR2_TABLE;
107: gUHDescriptionTbl DBMS_SQL.VARCHAR2_TABLE;
108: --Bug6599217
109: gUHLongDescriptionTbl ICX_CAT_POPULATE_MI_PVT.VARCHAR4_TABLE;
110: gUHOrganizationIdTbl DBMS_SQL.NUMBER_TABLE;

Line 107: gUHDescriptionTbl DBMS_SQL.VARCHAR2_TABLE;

103: gUHBuyerIdTbl DBMS_SQL.NUMBER_TABLE;
104: gUHSupplierContactIdTbl DBMS_SQL.NUMBER_TABLE;
105: gUHRfqRequiredFlagTbl DBMS_SQL.VARCHAR2_TABLE;
106: gUHNegotiatedByPreparerFlagTbl DBMS_SQL.VARCHAR2_TABLE;
107: gUHDescriptionTbl DBMS_SQL.VARCHAR2_TABLE;
108: --Bug6599217
109: gUHLongDescriptionTbl ICX_CAT_POPULATE_MI_PVT.VARCHAR4_TABLE;
110: gUHOrganizationIdTbl DBMS_SQL.NUMBER_TABLE;
111: gUHMasterOrganizationIdTbl DBMS_SQL.NUMBER_TABLE;

Line 110: gUHOrganizationIdTbl DBMS_SQL.NUMBER_TABLE;

106: gUHNegotiatedByPreparerFlagTbl DBMS_SQL.VARCHAR2_TABLE;
107: gUHDescriptionTbl DBMS_SQL.VARCHAR2_TABLE;
108: --Bug6599217
109: gUHLongDescriptionTbl ICX_CAT_POPULATE_MI_PVT.VARCHAR4_TABLE;
110: gUHOrganizationIdTbl DBMS_SQL.NUMBER_TABLE;
111: gUHMasterOrganizationIdTbl DBMS_SQL.NUMBER_TABLE;
112:
113: gUHOrderTypeLookupCodeTbl DBMS_SQL.VARCHAR2_TABLE;
114: gUHSupplierTbl DBMS_SQL.VARCHAR2_TABLE;

Line 111: gUHMasterOrganizationIdTbl DBMS_SQL.NUMBER_TABLE;

107: gUHDescriptionTbl DBMS_SQL.VARCHAR2_TABLE;
108: --Bug6599217
109: gUHLongDescriptionTbl ICX_CAT_POPULATE_MI_PVT.VARCHAR4_TABLE;
110: gUHOrganizationIdTbl DBMS_SQL.NUMBER_TABLE;
111: gUHMasterOrganizationIdTbl DBMS_SQL.NUMBER_TABLE;
112:
113: gUHOrderTypeLookupCodeTbl DBMS_SQL.VARCHAR2_TABLE;
114: gUHSupplierTbl DBMS_SQL.VARCHAR2_TABLE;
115: gUHGlobalAgreementFlagTbl DBMS_SQL.VARCHAR2_TABLE;

Line 113: gUHOrderTypeLookupCodeTbl DBMS_SQL.VARCHAR2_TABLE;

109: gUHLongDescriptionTbl ICX_CAT_POPULATE_MI_PVT.VARCHAR4_TABLE;
110: gUHOrganizationIdTbl DBMS_SQL.NUMBER_TABLE;
111: gUHMasterOrganizationIdTbl DBMS_SQL.NUMBER_TABLE;
112:
113: gUHOrderTypeLookupCodeTbl DBMS_SQL.VARCHAR2_TABLE;
114: gUHSupplierTbl DBMS_SQL.VARCHAR2_TABLE;
115: gUHGlobalAgreementFlagTbl DBMS_SQL.VARCHAR2_TABLE;
116: gUHMergedSourceTypeTbl DBMS_SQL.VARCHAR2_TABLE;
117:

Line 114: gUHSupplierTbl DBMS_SQL.VARCHAR2_TABLE;

110: gUHOrganizationIdTbl DBMS_SQL.NUMBER_TABLE;
111: gUHMasterOrganizationIdTbl DBMS_SQL.NUMBER_TABLE;
112:
113: gUHOrderTypeLookupCodeTbl DBMS_SQL.VARCHAR2_TABLE;
114: gUHSupplierTbl DBMS_SQL.VARCHAR2_TABLE;
115: gUHGlobalAgreementFlagTbl DBMS_SQL.VARCHAR2_TABLE;
116: gUHMergedSourceTypeTbl DBMS_SQL.VARCHAR2_TABLE;
117:
118: -- DELETE icx_cat_items_ctx_hdrs_tlp

Line 115: gUHGlobalAgreementFlagTbl DBMS_SQL.VARCHAR2_TABLE;

111: gUHMasterOrganizationIdTbl DBMS_SQL.NUMBER_TABLE;
112:
113: gUHOrderTypeLookupCodeTbl DBMS_SQL.VARCHAR2_TABLE;
114: gUHSupplierTbl DBMS_SQL.VARCHAR2_TABLE;
115: gUHGlobalAgreementFlagTbl DBMS_SQL.VARCHAR2_TABLE;
116: gUHMergedSourceTypeTbl DBMS_SQL.VARCHAR2_TABLE;
117:
118: -- DELETE icx_cat_items_ctx_hdrs_tlp
119: gDHInventoryItemIdTbl DBMS_SQL.NUMBER_TABLE;

Line 116: gUHMergedSourceTypeTbl DBMS_SQL.VARCHAR2_TABLE;

112:
113: gUHOrderTypeLookupCodeTbl DBMS_SQL.VARCHAR2_TABLE;
114: gUHSupplierTbl DBMS_SQL.VARCHAR2_TABLE;
115: gUHGlobalAgreementFlagTbl DBMS_SQL.VARCHAR2_TABLE;
116: gUHMergedSourceTypeTbl DBMS_SQL.VARCHAR2_TABLE;
117:
118: -- DELETE icx_cat_items_ctx_hdrs_tlp
119: gDHInventoryItemIdTbl DBMS_SQL.NUMBER_TABLE;
120: gDHPoLineIdTbl DBMS_SQL.NUMBER_TABLE;

Line 119: gDHInventoryItemIdTbl DBMS_SQL.NUMBER_TABLE;

115: gUHGlobalAgreementFlagTbl DBMS_SQL.VARCHAR2_TABLE;
116: gUHMergedSourceTypeTbl DBMS_SQL.VARCHAR2_TABLE;
117:
118: -- DELETE icx_cat_items_ctx_hdrs_tlp
119: gDHInventoryItemIdTbl DBMS_SQL.NUMBER_TABLE;
120: gDHPoLineIdTbl DBMS_SQL.NUMBER_TABLE;
121: gDHReqTemplateNameTbl DBMS_SQL.VARCHAR2_TABLE;
122: gDHReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;
123: gDHOrgIdTbl DBMS_SQL.NUMBER_TABLE;

Line 120: gDHPoLineIdTbl DBMS_SQL.NUMBER_TABLE;

116: gUHMergedSourceTypeTbl DBMS_SQL.VARCHAR2_TABLE;
117:
118: -- DELETE icx_cat_items_ctx_hdrs_tlp
119: gDHInventoryItemIdTbl DBMS_SQL.NUMBER_TABLE;
120: gDHPoLineIdTbl DBMS_SQL.NUMBER_TABLE;
121: gDHReqTemplateNameTbl DBMS_SQL.VARCHAR2_TABLE;
122: gDHReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;
123: gDHOrgIdTbl DBMS_SQL.NUMBER_TABLE;
124: gDHLanguageTbl DBMS_SQL.VARCHAR2_TABLE;

Line 121: gDHReqTemplateNameTbl DBMS_SQL.VARCHAR2_TABLE;

117:
118: -- DELETE icx_cat_items_ctx_hdrs_tlp
119: gDHInventoryItemIdTbl DBMS_SQL.NUMBER_TABLE;
120: gDHPoLineIdTbl DBMS_SQL.NUMBER_TABLE;
121: gDHReqTemplateNameTbl DBMS_SQL.VARCHAR2_TABLE;
122: gDHReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;
123: gDHOrgIdTbl DBMS_SQL.NUMBER_TABLE;
124: gDHLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
125:

Line 122: gDHReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;

118: -- DELETE icx_cat_items_ctx_hdrs_tlp
119: gDHInventoryItemIdTbl DBMS_SQL.NUMBER_TABLE;
120: gDHPoLineIdTbl DBMS_SQL.NUMBER_TABLE;
121: gDHReqTemplateNameTbl DBMS_SQL.VARCHAR2_TABLE;
122: gDHReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;
123: gDHOrgIdTbl DBMS_SQL.NUMBER_TABLE;
124: gDHLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
125:
126: -- DELETE icx_cat_items_ctx_dtls_tlp

Line 123: gDHOrgIdTbl DBMS_SQL.NUMBER_TABLE;

119: gDHInventoryItemIdTbl DBMS_SQL.NUMBER_TABLE;
120: gDHPoLineIdTbl DBMS_SQL.NUMBER_TABLE;
121: gDHReqTemplateNameTbl DBMS_SQL.VARCHAR2_TABLE;
122: gDHReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;
123: gDHOrgIdTbl DBMS_SQL.NUMBER_TABLE;
124: gDHLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
125:
126: -- DELETE icx_cat_items_ctx_dtls_tlp
127: gDDInventoryItemIdTbl DBMS_SQL.NUMBER_TABLE;

Line 124: gDHLanguageTbl DBMS_SQL.VARCHAR2_TABLE;

120: gDHPoLineIdTbl DBMS_SQL.NUMBER_TABLE;
121: gDHReqTemplateNameTbl DBMS_SQL.VARCHAR2_TABLE;
122: gDHReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;
123: gDHOrgIdTbl DBMS_SQL.NUMBER_TABLE;
124: gDHLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
125:
126: -- DELETE icx_cat_items_ctx_dtls_tlp
127: gDDInventoryItemIdTbl DBMS_SQL.NUMBER_TABLE;
128: gDDPoLineIdTbl DBMS_SQL.NUMBER_TABLE;

Line 127: gDDInventoryItemIdTbl DBMS_SQL.NUMBER_TABLE;

123: gDHOrgIdTbl DBMS_SQL.NUMBER_TABLE;
124: gDHLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
125:
126: -- DELETE icx_cat_items_ctx_dtls_tlp
127: gDDInventoryItemIdTbl DBMS_SQL.NUMBER_TABLE;
128: gDDPoLineIdTbl DBMS_SQL.NUMBER_TABLE;
129: gDDReqTemplateNameTbl DBMS_SQL.VARCHAR2_TABLE;
130: gDDReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;
131: gDDOrgIdTbl DBMS_SQL.NUMBER_TABLE;

Line 128: gDDPoLineIdTbl DBMS_SQL.NUMBER_TABLE;

124: gDHLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
125:
126: -- DELETE icx_cat_items_ctx_dtls_tlp
127: gDDInventoryItemIdTbl DBMS_SQL.NUMBER_TABLE;
128: gDDPoLineIdTbl DBMS_SQL.NUMBER_TABLE;
129: gDDReqTemplateNameTbl DBMS_SQL.VARCHAR2_TABLE;
130: gDDReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;
131: gDDOrgIdTbl DBMS_SQL.NUMBER_TABLE;
132: gDDLanguageTbl DBMS_SQL.VARCHAR2_TABLE;

Line 129: gDDReqTemplateNameTbl DBMS_SQL.VARCHAR2_TABLE;

125:
126: -- DELETE icx_cat_items_ctx_dtls_tlp
127: gDDInventoryItemIdTbl DBMS_SQL.NUMBER_TABLE;
128: gDDPoLineIdTbl DBMS_SQL.NUMBER_TABLE;
129: gDDReqTemplateNameTbl DBMS_SQL.VARCHAR2_TABLE;
130: gDDReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;
131: gDDOrgIdTbl DBMS_SQL.NUMBER_TABLE;
132: gDDLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
133:

Line 130: gDDReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;

126: -- DELETE icx_cat_items_ctx_dtls_tlp
127: gDDInventoryItemIdTbl DBMS_SQL.NUMBER_TABLE;
128: gDDPoLineIdTbl DBMS_SQL.NUMBER_TABLE;
129: gDDReqTemplateNameTbl DBMS_SQL.VARCHAR2_TABLE;
130: gDDReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;
131: gDDOrgIdTbl DBMS_SQL.NUMBER_TABLE;
132: gDDLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
133:
134: -- DELETE rows with sequence 1 (Mandatory Row) in icx_cat_items_ctx_dtl_tlp

Line 131: gDDOrgIdTbl DBMS_SQL.NUMBER_TABLE;

127: gDDInventoryItemIdTbl DBMS_SQL.NUMBER_TABLE;
128: gDDPoLineIdTbl DBMS_SQL.NUMBER_TABLE;
129: gDDReqTemplateNameTbl DBMS_SQL.VARCHAR2_TABLE;
130: gDDReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;
131: gDDOrgIdTbl DBMS_SQL.NUMBER_TABLE;
132: gDDLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
133:
134: -- DELETE rows with sequence 1 (Mandatory Row) in icx_cat_items_ctx_dtl_tlp
135: gDMDInventoryItemIdTbl DBMS_SQL.NUMBER_TABLE;

Line 132: gDDLanguageTbl DBMS_SQL.VARCHAR2_TABLE;

128: gDDPoLineIdTbl DBMS_SQL.NUMBER_TABLE;
129: gDDReqTemplateNameTbl DBMS_SQL.VARCHAR2_TABLE;
130: gDDReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;
131: gDDOrgIdTbl DBMS_SQL.NUMBER_TABLE;
132: gDDLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
133:
134: -- DELETE rows with sequence 1 (Mandatory Row) in icx_cat_items_ctx_dtl_tlp
135: gDMDInventoryItemIdTbl DBMS_SQL.NUMBER_TABLE;
136: gDMDPoLineIdTbl DBMS_SQL.NUMBER_TABLE;

Line 135: gDMDInventoryItemIdTbl DBMS_SQL.NUMBER_TABLE;

131: gDDOrgIdTbl DBMS_SQL.NUMBER_TABLE;
132: gDDLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
133:
134: -- DELETE rows with sequence 1 (Mandatory Row) in icx_cat_items_ctx_dtl_tlp
135: gDMDInventoryItemIdTbl DBMS_SQL.NUMBER_TABLE;
136: gDMDPoLineIdTbl DBMS_SQL.NUMBER_TABLE;
137: gDMDReqTemplateNameTbl DBMS_SQL.VARCHAR2_TABLE;
138: gDMDReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;
139: gDMDOrgIdTbl DBMS_SQL.NUMBER_TABLE;

Line 136: gDMDPoLineIdTbl DBMS_SQL.NUMBER_TABLE;

132: gDDLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
133:
134: -- DELETE rows with sequence 1 (Mandatory Row) in icx_cat_items_ctx_dtl_tlp
135: gDMDInventoryItemIdTbl DBMS_SQL.NUMBER_TABLE;
136: gDMDPoLineIdTbl DBMS_SQL.NUMBER_TABLE;
137: gDMDReqTemplateNameTbl DBMS_SQL.VARCHAR2_TABLE;
138: gDMDReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;
139: gDMDOrgIdTbl DBMS_SQL.NUMBER_TABLE;
140: gDMDOwningOrgIdTbl DBMS_SQL.NUMBER_TABLE;

Line 137: gDMDReqTemplateNameTbl DBMS_SQL.VARCHAR2_TABLE;

133:
134: -- DELETE rows with sequence 1 (Mandatory Row) in icx_cat_items_ctx_dtl_tlp
135: gDMDInventoryItemIdTbl DBMS_SQL.NUMBER_TABLE;
136: gDMDPoLineIdTbl DBMS_SQL.NUMBER_TABLE;
137: gDMDReqTemplateNameTbl DBMS_SQL.VARCHAR2_TABLE;
138: gDMDReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;
139: gDMDOrgIdTbl DBMS_SQL.NUMBER_TABLE;
140: gDMDOwningOrgIdTbl DBMS_SQL.NUMBER_TABLE;
141: gDMDLanguageTbl DBMS_SQL.VARCHAR2_TABLE;

Line 138: gDMDReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;

134: -- DELETE rows with sequence 1 (Mandatory Row) in icx_cat_items_ctx_dtl_tlp
135: gDMDInventoryItemIdTbl DBMS_SQL.NUMBER_TABLE;
136: gDMDPoLineIdTbl DBMS_SQL.NUMBER_TABLE;
137: gDMDReqTemplateNameTbl DBMS_SQL.VARCHAR2_TABLE;
138: gDMDReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;
139: gDMDOrgIdTbl DBMS_SQL.NUMBER_TABLE;
140: gDMDOwningOrgIdTbl DBMS_SQL.NUMBER_TABLE;
141: gDMDLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
142:

Line 139: gDMDOrgIdTbl DBMS_SQL.NUMBER_TABLE;

135: gDMDInventoryItemIdTbl DBMS_SQL.NUMBER_TABLE;
136: gDMDPoLineIdTbl DBMS_SQL.NUMBER_TABLE;
137: gDMDReqTemplateNameTbl DBMS_SQL.VARCHAR2_TABLE;
138: gDMDReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;
139: gDMDOrgIdTbl DBMS_SQL.NUMBER_TABLE;
140: gDMDOwningOrgIdTbl DBMS_SQL.NUMBER_TABLE;
141: gDMDLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
142:
143: -- DELETE rows with sequence 2 (Supplier) in icx_cat_items_ctx_dtl_tlp

Line 140: gDMDOwningOrgIdTbl DBMS_SQL.NUMBER_TABLE;

136: gDMDPoLineIdTbl DBMS_SQL.NUMBER_TABLE;
137: gDMDReqTemplateNameTbl DBMS_SQL.VARCHAR2_TABLE;
138: gDMDReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;
139: gDMDOrgIdTbl DBMS_SQL.NUMBER_TABLE;
140: gDMDOwningOrgIdTbl DBMS_SQL.NUMBER_TABLE;
141: gDMDLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
142:
143: -- DELETE rows with sequence 2 (Supplier) in icx_cat_items_ctx_dtl_tlp
144: gDSDInventoryItemIdTbl DBMS_SQL.NUMBER_TABLE;

Line 141: gDMDLanguageTbl DBMS_SQL.VARCHAR2_TABLE;

137: gDMDReqTemplateNameTbl DBMS_SQL.VARCHAR2_TABLE;
138: gDMDReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;
139: gDMDOrgIdTbl DBMS_SQL.NUMBER_TABLE;
140: gDMDOwningOrgIdTbl DBMS_SQL.NUMBER_TABLE;
141: gDMDLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
142:
143: -- DELETE rows with sequence 2 (Supplier) in icx_cat_items_ctx_dtl_tlp
144: gDSDInventoryItemIdTbl DBMS_SQL.NUMBER_TABLE;
145: gDSDPoLineIdTbl DBMS_SQL.NUMBER_TABLE;

Line 144: gDSDInventoryItemIdTbl DBMS_SQL.NUMBER_TABLE;

140: gDMDOwningOrgIdTbl DBMS_SQL.NUMBER_TABLE;
141: gDMDLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
142:
143: -- DELETE rows with sequence 2 (Supplier) in icx_cat_items_ctx_dtl_tlp
144: gDSDInventoryItemIdTbl DBMS_SQL.NUMBER_TABLE;
145: gDSDPoLineIdTbl DBMS_SQL.NUMBER_TABLE;
146: gDSDReqTemplateNameTbl DBMS_SQL.VARCHAR2_TABLE;
147: gDSDReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;
148: gDSDOrgIdTbl DBMS_SQL.NUMBER_TABLE;

Line 145: gDSDPoLineIdTbl DBMS_SQL.NUMBER_TABLE;

141: gDMDLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
142:
143: -- DELETE rows with sequence 2 (Supplier) in icx_cat_items_ctx_dtl_tlp
144: gDSDInventoryItemIdTbl DBMS_SQL.NUMBER_TABLE;
145: gDSDPoLineIdTbl DBMS_SQL.NUMBER_TABLE;
146: gDSDReqTemplateNameTbl DBMS_SQL.VARCHAR2_TABLE;
147: gDSDReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;
148: gDSDOrgIdTbl DBMS_SQL.NUMBER_TABLE;
149: gDSDOwningOrgIdTbl DBMS_SQL.NUMBER_TABLE;

Line 146: gDSDReqTemplateNameTbl DBMS_SQL.VARCHAR2_TABLE;

142:
143: -- DELETE rows with sequence 2 (Supplier) in icx_cat_items_ctx_dtl_tlp
144: gDSDInventoryItemIdTbl DBMS_SQL.NUMBER_TABLE;
145: gDSDPoLineIdTbl DBMS_SQL.NUMBER_TABLE;
146: gDSDReqTemplateNameTbl DBMS_SQL.VARCHAR2_TABLE;
147: gDSDReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;
148: gDSDOrgIdTbl DBMS_SQL.NUMBER_TABLE;
149: gDSDOwningOrgIdTbl DBMS_SQL.NUMBER_TABLE;
150: gDSDLanguageTbl DBMS_SQL.VARCHAR2_TABLE;

Line 147: gDSDReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;

143: -- DELETE rows with sequence 2 (Supplier) in icx_cat_items_ctx_dtl_tlp
144: gDSDInventoryItemIdTbl DBMS_SQL.NUMBER_TABLE;
145: gDSDPoLineIdTbl DBMS_SQL.NUMBER_TABLE;
146: gDSDReqTemplateNameTbl DBMS_SQL.VARCHAR2_TABLE;
147: gDSDReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;
148: gDSDOrgIdTbl DBMS_SQL.NUMBER_TABLE;
149: gDSDOwningOrgIdTbl DBMS_SQL.NUMBER_TABLE;
150: gDSDLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
151:

Line 148: gDSDOrgIdTbl DBMS_SQL.NUMBER_TABLE;

144: gDSDInventoryItemIdTbl DBMS_SQL.NUMBER_TABLE;
145: gDSDPoLineIdTbl DBMS_SQL.NUMBER_TABLE;
146: gDSDReqTemplateNameTbl DBMS_SQL.VARCHAR2_TABLE;
147: gDSDReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;
148: gDSDOrgIdTbl DBMS_SQL.NUMBER_TABLE;
149: gDSDOwningOrgIdTbl DBMS_SQL.NUMBER_TABLE;
150: gDSDLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
151:
152: -- DELETE rows with sequence 5 (ItemRevision) in icx_cat_items_ctx_dtl_tlp

Line 149: gDSDOwningOrgIdTbl DBMS_SQL.NUMBER_TABLE;

145: gDSDPoLineIdTbl DBMS_SQL.NUMBER_TABLE;
146: gDSDReqTemplateNameTbl DBMS_SQL.VARCHAR2_TABLE;
147: gDSDReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;
148: gDSDOrgIdTbl DBMS_SQL.NUMBER_TABLE;
149: gDSDOwningOrgIdTbl DBMS_SQL.NUMBER_TABLE;
150: gDSDLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
151:
152: -- DELETE rows with sequence 5 (ItemRevision) in icx_cat_items_ctx_dtl_tlp
153: gDIRDInventoryItemIdTbl DBMS_SQL.NUMBER_TABLE;

Line 150: gDSDLanguageTbl DBMS_SQL.VARCHAR2_TABLE;

146: gDSDReqTemplateNameTbl DBMS_SQL.VARCHAR2_TABLE;
147: gDSDReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;
148: gDSDOrgIdTbl DBMS_SQL.NUMBER_TABLE;
149: gDSDOwningOrgIdTbl DBMS_SQL.NUMBER_TABLE;
150: gDSDLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
151:
152: -- DELETE rows with sequence 5 (ItemRevision) in icx_cat_items_ctx_dtl_tlp
153: gDIRDInventoryItemIdTbl DBMS_SQL.NUMBER_TABLE;
154: gDIRDPoLineIdTbl DBMS_SQL.NUMBER_TABLE;

Line 153: gDIRDInventoryItemIdTbl DBMS_SQL.NUMBER_TABLE;

149: gDSDOwningOrgIdTbl DBMS_SQL.NUMBER_TABLE;
150: gDSDLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
151:
152: -- DELETE rows with sequence 5 (ItemRevision) in icx_cat_items_ctx_dtl_tlp
153: gDIRDInventoryItemIdTbl DBMS_SQL.NUMBER_TABLE;
154: gDIRDPoLineIdTbl DBMS_SQL.NUMBER_TABLE;
155: gDIRDReqTemplateNameTbl DBMS_SQL.VARCHAR2_TABLE;
156: gDIRDReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;
157: gDIRDOrgIdTbl DBMS_SQL.NUMBER_TABLE;

Line 154: gDIRDPoLineIdTbl DBMS_SQL.NUMBER_TABLE;

150: gDSDLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
151:
152: -- DELETE rows with sequence 5 (ItemRevision) in icx_cat_items_ctx_dtl_tlp
153: gDIRDInventoryItemIdTbl DBMS_SQL.NUMBER_TABLE;
154: gDIRDPoLineIdTbl DBMS_SQL.NUMBER_TABLE;
155: gDIRDReqTemplateNameTbl DBMS_SQL.VARCHAR2_TABLE;
156: gDIRDReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;
157: gDIRDOrgIdTbl DBMS_SQL.NUMBER_TABLE;
158: gDIRDOwningOrgIdTbl DBMS_SQL.NUMBER_TABLE;

Line 155: gDIRDReqTemplateNameTbl DBMS_SQL.VARCHAR2_TABLE;

151:
152: -- DELETE rows with sequence 5 (ItemRevision) in icx_cat_items_ctx_dtl_tlp
153: gDIRDInventoryItemIdTbl DBMS_SQL.NUMBER_TABLE;
154: gDIRDPoLineIdTbl DBMS_SQL.NUMBER_TABLE;
155: gDIRDReqTemplateNameTbl DBMS_SQL.VARCHAR2_TABLE;
156: gDIRDReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;
157: gDIRDOrgIdTbl DBMS_SQL.NUMBER_TABLE;
158: gDIRDOwningOrgIdTbl DBMS_SQL.NUMBER_TABLE;
159: gDIRDLanguageTbl DBMS_SQL.VARCHAR2_TABLE;

Line 156: gDIRDReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;

152: -- DELETE rows with sequence 5 (ItemRevision) in icx_cat_items_ctx_dtl_tlp
153: gDIRDInventoryItemIdTbl DBMS_SQL.NUMBER_TABLE;
154: gDIRDPoLineIdTbl DBMS_SQL.NUMBER_TABLE;
155: gDIRDReqTemplateNameTbl DBMS_SQL.VARCHAR2_TABLE;
156: gDIRDReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;
157: gDIRDOrgIdTbl DBMS_SQL.NUMBER_TABLE;
158: gDIRDOwningOrgIdTbl DBMS_SQL.NUMBER_TABLE;
159: gDIRDLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
160:

Line 157: gDIRDOrgIdTbl DBMS_SQL.NUMBER_TABLE;

153: gDIRDInventoryItemIdTbl DBMS_SQL.NUMBER_TABLE;
154: gDIRDPoLineIdTbl DBMS_SQL.NUMBER_TABLE;
155: gDIRDReqTemplateNameTbl DBMS_SQL.VARCHAR2_TABLE;
156: gDIRDReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;
157: gDIRDOrgIdTbl DBMS_SQL.NUMBER_TABLE;
158: gDIRDOwningOrgIdTbl DBMS_SQL.NUMBER_TABLE;
159: gDIRDLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
160:
161: -- DELETE rows with sequence 6 (ShoppingCategory) in icx_cat_items_ctx_dtl_tlp

Line 158: gDIRDOwningOrgIdTbl DBMS_SQL.NUMBER_TABLE;

154: gDIRDPoLineIdTbl DBMS_SQL.NUMBER_TABLE;
155: gDIRDReqTemplateNameTbl DBMS_SQL.VARCHAR2_TABLE;
156: gDIRDReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;
157: gDIRDOrgIdTbl DBMS_SQL.NUMBER_TABLE;
158: gDIRDOwningOrgIdTbl DBMS_SQL.NUMBER_TABLE;
159: gDIRDLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
160:
161: -- DELETE rows with sequence 6 (ShoppingCategory) in icx_cat_items_ctx_dtl_tlp
162: gDSCDInventoryItemIdTbl DBMS_SQL.NUMBER_TABLE;

Line 159: gDIRDLanguageTbl DBMS_SQL.VARCHAR2_TABLE;

155: gDIRDReqTemplateNameTbl DBMS_SQL.VARCHAR2_TABLE;
156: gDIRDReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;
157: gDIRDOrgIdTbl DBMS_SQL.NUMBER_TABLE;
158: gDIRDOwningOrgIdTbl DBMS_SQL.NUMBER_TABLE;
159: gDIRDLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
160:
161: -- DELETE rows with sequence 6 (ShoppingCategory) in icx_cat_items_ctx_dtl_tlp
162: gDSCDInventoryItemIdTbl DBMS_SQL.NUMBER_TABLE;
163: gDSCDPoLineIdTbl DBMS_SQL.NUMBER_TABLE;

Line 162: gDSCDInventoryItemIdTbl DBMS_SQL.NUMBER_TABLE;

158: gDIRDOwningOrgIdTbl DBMS_SQL.NUMBER_TABLE;
159: gDIRDLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
160:
161: -- DELETE rows with sequence 6 (ShoppingCategory) in icx_cat_items_ctx_dtl_tlp
162: gDSCDInventoryItemIdTbl DBMS_SQL.NUMBER_TABLE;
163: gDSCDPoLineIdTbl DBMS_SQL.NUMBER_TABLE;
164: gDSCDReqTemplateNameTbl DBMS_SQL.VARCHAR2_TABLE;
165: gDSCDReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;
166: gDSCDOrgIdTbl DBMS_SQL.NUMBER_TABLE;

Line 163: gDSCDPoLineIdTbl DBMS_SQL.NUMBER_TABLE;

159: gDIRDLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
160:
161: -- DELETE rows with sequence 6 (ShoppingCategory) in icx_cat_items_ctx_dtl_tlp
162: gDSCDInventoryItemIdTbl DBMS_SQL.NUMBER_TABLE;
163: gDSCDPoLineIdTbl DBMS_SQL.NUMBER_TABLE;
164: gDSCDReqTemplateNameTbl DBMS_SQL.VARCHAR2_TABLE;
165: gDSCDReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;
166: gDSCDOrgIdTbl DBMS_SQL.NUMBER_TABLE;
167: gDSCDOwningOrgIdTbl DBMS_SQL.NUMBER_TABLE;

Line 164: gDSCDReqTemplateNameTbl DBMS_SQL.VARCHAR2_TABLE;

160:
161: -- DELETE rows with sequence 6 (ShoppingCategory) in icx_cat_items_ctx_dtl_tlp
162: gDSCDInventoryItemIdTbl DBMS_SQL.NUMBER_TABLE;
163: gDSCDPoLineIdTbl DBMS_SQL.NUMBER_TABLE;
164: gDSCDReqTemplateNameTbl DBMS_SQL.VARCHAR2_TABLE;
165: gDSCDReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;
166: gDSCDOrgIdTbl DBMS_SQL.NUMBER_TABLE;
167: gDSCDOwningOrgIdTbl DBMS_SQL.NUMBER_TABLE;
168: gDSCDLanguageTbl DBMS_SQL.VARCHAR2_TABLE;

Line 165: gDSCDReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;

161: -- DELETE rows with sequence 6 (ShoppingCategory) in icx_cat_items_ctx_dtl_tlp
162: gDSCDInventoryItemIdTbl DBMS_SQL.NUMBER_TABLE;
163: gDSCDPoLineIdTbl DBMS_SQL.NUMBER_TABLE;
164: gDSCDReqTemplateNameTbl DBMS_SQL.VARCHAR2_TABLE;
165: gDSCDReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;
166: gDSCDOrgIdTbl DBMS_SQL.NUMBER_TABLE;
167: gDSCDOwningOrgIdTbl DBMS_SQL.NUMBER_TABLE;
168: gDSCDLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
169:

Line 166: gDSCDOrgIdTbl DBMS_SQL.NUMBER_TABLE;

162: gDSCDInventoryItemIdTbl DBMS_SQL.NUMBER_TABLE;
163: gDSCDPoLineIdTbl DBMS_SQL.NUMBER_TABLE;
164: gDSCDReqTemplateNameTbl DBMS_SQL.VARCHAR2_TABLE;
165: gDSCDReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;
166: gDSCDOrgIdTbl DBMS_SQL.NUMBER_TABLE;
167: gDSCDOwningOrgIdTbl DBMS_SQL.NUMBER_TABLE;
168: gDSCDLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
169:
170: -- DELETE rows with sequence 15001 (PurchasingOrgId) in icx_cat_items_ctx_dtl_tlp

Line 167: gDSCDOwningOrgIdTbl DBMS_SQL.NUMBER_TABLE;

163: gDSCDPoLineIdTbl DBMS_SQL.NUMBER_TABLE;
164: gDSCDReqTemplateNameTbl DBMS_SQL.VARCHAR2_TABLE;
165: gDSCDReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;
166: gDSCDOrgIdTbl DBMS_SQL.NUMBER_TABLE;
167: gDSCDOwningOrgIdTbl DBMS_SQL.NUMBER_TABLE;
168: gDSCDLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
169:
170: -- DELETE rows with sequence 15001 (PurchasingOrgId) in icx_cat_items_ctx_dtl_tlp
171: gDPODInventoryItemIdTbl DBMS_SQL.NUMBER_TABLE;

Line 168: gDSCDLanguageTbl DBMS_SQL.VARCHAR2_TABLE;

164: gDSCDReqTemplateNameTbl DBMS_SQL.VARCHAR2_TABLE;
165: gDSCDReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;
166: gDSCDOrgIdTbl DBMS_SQL.NUMBER_TABLE;
167: gDSCDOwningOrgIdTbl DBMS_SQL.NUMBER_TABLE;
168: gDSCDLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
169:
170: -- DELETE rows with sequence 15001 (PurchasingOrgId) in icx_cat_items_ctx_dtl_tlp
171: gDPODInventoryItemIdTbl DBMS_SQL.NUMBER_TABLE;
172: gDPODPoLineIdTbl DBMS_SQL.NUMBER_TABLE;

Line 171: gDPODInventoryItemIdTbl DBMS_SQL.NUMBER_TABLE;

167: gDSCDOwningOrgIdTbl DBMS_SQL.NUMBER_TABLE;
168: gDSCDLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
169:
170: -- DELETE rows with sequence 15001 (PurchasingOrgId) in icx_cat_items_ctx_dtl_tlp
171: gDPODInventoryItemIdTbl DBMS_SQL.NUMBER_TABLE;
172: gDPODPoLineIdTbl DBMS_SQL.NUMBER_TABLE;
173: gDPODReqTemplateNameTbl DBMS_SQL.VARCHAR2_TABLE;
174: gDPODReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;
175: gDPODOrgIdTbl DBMS_SQL.NUMBER_TABLE;

Line 172: gDPODPoLineIdTbl DBMS_SQL.NUMBER_TABLE;

168: gDSCDLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
169:
170: -- DELETE rows with sequence 15001 (PurchasingOrgId) in icx_cat_items_ctx_dtl_tlp
171: gDPODInventoryItemIdTbl DBMS_SQL.NUMBER_TABLE;
172: gDPODPoLineIdTbl DBMS_SQL.NUMBER_TABLE;
173: gDPODReqTemplateNameTbl DBMS_SQL.VARCHAR2_TABLE;
174: gDPODReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;
175: gDPODOrgIdTbl DBMS_SQL.NUMBER_TABLE;
176: gDPODOwningOrgIdTbl DBMS_SQL.NUMBER_TABLE;

Line 173: gDPODReqTemplateNameTbl DBMS_SQL.VARCHAR2_TABLE;

169:
170: -- DELETE rows with sequence 15001 (PurchasingOrgId) in icx_cat_items_ctx_dtl_tlp
171: gDPODInventoryItemIdTbl DBMS_SQL.NUMBER_TABLE;
172: gDPODPoLineIdTbl DBMS_SQL.NUMBER_TABLE;
173: gDPODReqTemplateNameTbl DBMS_SQL.VARCHAR2_TABLE;
174: gDPODReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;
175: gDPODOrgIdTbl DBMS_SQL.NUMBER_TABLE;
176: gDPODOwningOrgIdTbl DBMS_SQL.NUMBER_TABLE;
177: gDPODPurchasingOrgIdTbl DBMS_SQL.NUMBER_TABLE;

Line 174: gDPODReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;

170: -- DELETE rows with sequence 15001 (PurchasingOrgId) in icx_cat_items_ctx_dtl_tlp
171: gDPODInventoryItemIdTbl DBMS_SQL.NUMBER_TABLE;
172: gDPODPoLineIdTbl DBMS_SQL.NUMBER_TABLE;
173: gDPODReqTemplateNameTbl DBMS_SQL.VARCHAR2_TABLE;
174: gDPODReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;
175: gDPODOrgIdTbl DBMS_SQL.NUMBER_TABLE;
176: gDPODOwningOrgIdTbl DBMS_SQL.NUMBER_TABLE;
177: gDPODPurchasingOrgIdTbl DBMS_SQL.NUMBER_TABLE;
178: gDPODLanguageTbl DBMS_SQL.VARCHAR2_TABLE;

Line 175: gDPODOrgIdTbl DBMS_SQL.NUMBER_TABLE;

171: gDPODInventoryItemIdTbl DBMS_SQL.NUMBER_TABLE;
172: gDPODPoLineIdTbl DBMS_SQL.NUMBER_TABLE;
173: gDPODReqTemplateNameTbl DBMS_SQL.VARCHAR2_TABLE;
174: gDPODReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;
175: gDPODOrgIdTbl DBMS_SQL.NUMBER_TABLE;
176: gDPODOwningOrgIdTbl DBMS_SQL.NUMBER_TABLE;
177: gDPODPurchasingOrgIdTbl DBMS_SQL.NUMBER_TABLE;
178: gDPODLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
179:

Line 176: gDPODOwningOrgIdTbl DBMS_SQL.NUMBER_TABLE;

172: gDPODPoLineIdTbl DBMS_SQL.NUMBER_TABLE;
173: gDPODReqTemplateNameTbl DBMS_SQL.VARCHAR2_TABLE;
174: gDPODReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;
175: gDPODOrgIdTbl DBMS_SQL.NUMBER_TABLE;
176: gDPODOwningOrgIdTbl DBMS_SQL.NUMBER_TABLE;
177: gDPODPurchasingOrgIdTbl DBMS_SQL.NUMBER_TABLE;
178: gDPODLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
179:
180: -- DELETE rows with sequence > 100 and < 10000 in icx_cat_items_ctx_dtl_tlp

Line 177: gDPODPurchasingOrgIdTbl DBMS_SQL.NUMBER_TABLE;

173: gDPODReqTemplateNameTbl DBMS_SQL.VARCHAR2_TABLE;
174: gDPODReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;
175: gDPODOrgIdTbl DBMS_SQL.NUMBER_TABLE;
176: gDPODOwningOrgIdTbl DBMS_SQL.NUMBER_TABLE;
177: gDPODPurchasingOrgIdTbl DBMS_SQL.NUMBER_TABLE;
178: gDPODLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
179:
180: -- DELETE rows with sequence > 100 and < 10000 in icx_cat_items_ctx_dtl_tlp
181: -- (Regular Base and Local Attributes)

Line 178: gDPODLanguageTbl DBMS_SQL.VARCHAR2_TABLE;

174: gDPODReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;
175: gDPODOrgIdTbl DBMS_SQL.NUMBER_TABLE;
176: gDPODOwningOrgIdTbl DBMS_SQL.NUMBER_TABLE;
177: gDPODPurchasingOrgIdTbl DBMS_SQL.NUMBER_TABLE;
178: gDPODLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
179:
180: -- DELETE rows with sequence > 100 and < 10000 in icx_cat_items_ctx_dtl_tlp
181: -- (Regular Base and Local Attributes)
182: gDBLDInventoryItemIdTbl DBMS_SQL.NUMBER_TABLE;

Line 182: gDBLDInventoryItemIdTbl DBMS_SQL.NUMBER_TABLE;

178: gDPODLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
179:
180: -- DELETE rows with sequence > 100 and < 10000 in icx_cat_items_ctx_dtl_tlp
181: -- (Regular Base and Local Attributes)
182: gDBLDInventoryItemIdTbl DBMS_SQL.NUMBER_TABLE;
183: gDBLDPoLineIdTbl DBMS_SQL.NUMBER_TABLE;
184: gDBLDReqTemplateNameTbl DBMS_SQL.VARCHAR2_TABLE;
185: gDBLDReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;
186: gDBLDOrgIdTbl DBMS_SQL.NUMBER_TABLE;

Line 183: gDBLDPoLineIdTbl DBMS_SQL.NUMBER_TABLE;

179:
180: -- DELETE rows with sequence > 100 and < 10000 in icx_cat_items_ctx_dtl_tlp
181: -- (Regular Base and Local Attributes)
182: gDBLDInventoryItemIdTbl DBMS_SQL.NUMBER_TABLE;
183: gDBLDPoLineIdTbl DBMS_SQL.NUMBER_TABLE;
184: gDBLDReqTemplateNameTbl DBMS_SQL.VARCHAR2_TABLE;
185: gDBLDReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;
186: gDBLDOrgIdTbl DBMS_SQL.NUMBER_TABLE;
187: gDBLDOwningOrgIdTbl DBMS_SQL.NUMBER_TABLE;

Line 184: gDBLDReqTemplateNameTbl DBMS_SQL.VARCHAR2_TABLE;

180: -- DELETE rows with sequence > 100 and < 10000 in icx_cat_items_ctx_dtl_tlp
181: -- (Regular Base and Local Attributes)
182: gDBLDInventoryItemIdTbl DBMS_SQL.NUMBER_TABLE;
183: gDBLDPoLineIdTbl DBMS_SQL.NUMBER_TABLE;
184: gDBLDReqTemplateNameTbl DBMS_SQL.VARCHAR2_TABLE;
185: gDBLDReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;
186: gDBLDOrgIdTbl DBMS_SQL.NUMBER_TABLE;
187: gDBLDOwningOrgIdTbl DBMS_SQL.NUMBER_TABLE;
188: gDBLDLanguageTbl DBMS_SQL.VARCHAR2_TABLE;

Line 185: gDBLDReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;

181: -- (Regular Base and Local Attributes)
182: gDBLDInventoryItemIdTbl DBMS_SQL.NUMBER_TABLE;
183: gDBLDPoLineIdTbl DBMS_SQL.NUMBER_TABLE;
184: gDBLDReqTemplateNameTbl DBMS_SQL.VARCHAR2_TABLE;
185: gDBLDReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;
186: gDBLDOrgIdTbl DBMS_SQL.NUMBER_TABLE;
187: gDBLDOwningOrgIdTbl DBMS_SQL.NUMBER_TABLE;
188: gDBLDLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
189:

Line 186: gDBLDOrgIdTbl DBMS_SQL.NUMBER_TABLE;

182: gDBLDInventoryItemIdTbl DBMS_SQL.NUMBER_TABLE;
183: gDBLDPoLineIdTbl DBMS_SQL.NUMBER_TABLE;
184: gDBLDReqTemplateNameTbl DBMS_SQL.VARCHAR2_TABLE;
185: gDBLDReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;
186: gDBLDOrgIdTbl DBMS_SQL.NUMBER_TABLE;
187: gDBLDOwningOrgIdTbl DBMS_SQL.NUMBER_TABLE;
188: gDBLDLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
189:
190: PROCEDURE clearTables

Line 187: gDBLDOwningOrgIdTbl DBMS_SQL.NUMBER_TABLE;

183: gDBLDPoLineIdTbl DBMS_SQL.NUMBER_TABLE;
184: gDBLDReqTemplateNameTbl DBMS_SQL.VARCHAR2_TABLE;
185: gDBLDReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;
186: gDBLDOrgIdTbl DBMS_SQL.NUMBER_TABLE;
187: gDBLDOwningOrgIdTbl DBMS_SQL.NUMBER_TABLE;
188: gDBLDLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
189:
190: PROCEDURE clearTables
191: ( p_action_mode IN VARCHAR2

Line 188: gDBLDLanguageTbl DBMS_SQL.VARCHAR2_TABLE;

184: gDBLDReqTemplateNameTbl DBMS_SQL.VARCHAR2_TABLE;
185: gDBLDReqTemplateLineNumTbl DBMS_SQL.NUMBER_TABLE;
186: gDBLDOrgIdTbl DBMS_SQL.NUMBER_TABLE;
187: gDBLDOwningOrgIdTbl DBMS_SQL.NUMBER_TABLE;
188: gDBLDLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
189:
190: PROCEDURE clearTables
191: ( p_action_mode IN VARCHAR2
192: )

Line 3266: l_csr_handle:=DBMS_SQL.OPEN_CURSOR;

3262: -- will be exact copies of owning org
3263: EXIT;
3264: END IF;
3265: l_err_loc := 1650;
3266: l_csr_handle:=DBMS_SQL.OPEN_CURSOR;
3267: l_err_loc := 1700;
3268: DBMS_SQL.PARSE(l_csr_handle, l_ctx_sql_string, DBMS_SQL.NATIVE);
3269: IF (gIDInventoryItemIdTbl.COUNT > 0) THEN
3270: l_err_loc := 1750;

Line 3268: DBMS_SQL.PARSE(l_csr_handle, l_ctx_sql_string, DBMS_SQL.NATIVE);

3264: END IF;
3265: l_err_loc := 1650;
3266: l_csr_handle:=DBMS_SQL.OPEN_CURSOR;
3267: l_err_loc := 1700;
3268: DBMS_SQL.PARSE(l_csr_handle, l_ctx_sql_string, DBMS_SQL.NATIVE);
3269: IF (gIDInventoryItemIdTbl.COUNT > 0) THEN
3270: l_err_loc := 1750;
3271: l_action_mode := 'INSERT_CTX_DTLS';
3272: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_sequence);

Line 3272: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_sequence);

3268: DBMS_SQL.PARSE(l_csr_handle, l_ctx_sql_string, DBMS_SQL.NATIVE);
3269: IF (gIDInventoryItemIdTbl.COUNT > 0) THEN
3270: l_err_loc := 1750;
3271: l_action_mode := 'INSERT_CTX_DTLS';
3272: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_sequence);
3273: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_INVENTORY_ITEM_ID', gIDInventoryItemIdTbl);
3274: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_PO_LINE_ID', gIDPoLineIdTbl);
3275: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_NAME', gIDReqTemplateNameTbl);
3276: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_LINE_NUM', gIDReqTemplateLineNumTbl);

Line 3273: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_INVENTORY_ITEM_ID', gIDInventoryItemIdTbl);

3269: IF (gIDInventoryItemIdTbl.COUNT > 0) THEN
3270: l_err_loc := 1750;
3271: l_action_mode := 'INSERT_CTX_DTLS';
3272: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_sequence);
3273: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_INVENTORY_ITEM_ID', gIDInventoryItemIdTbl);
3274: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_PO_LINE_ID', gIDPoLineIdTbl);
3275: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_NAME', gIDReqTemplateNameTbl);
3276: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_LINE_NUM', gIDReqTemplateLineNumTbl);
3277: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gIDOrgIdTbl);

Line 3274: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_PO_LINE_ID', gIDPoLineIdTbl);

3270: l_err_loc := 1750;
3271: l_action_mode := 'INSERT_CTX_DTLS';
3272: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_sequence);
3273: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_INVENTORY_ITEM_ID', gIDInventoryItemIdTbl);
3274: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_PO_LINE_ID', gIDPoLineIdTbl);
3275: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_NAME', gIDReqTemplateNameTbl);
3276: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_LINE_NUM', gIDReqTemplateLineNumTbl);
3277: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gIDOrgIdTbl);
3278: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gIDLanguageTbl);

Line 3275: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_NAME', gIDReqTemplateNameTbl);

3271: l_action_mode := 'INSERT_CTX_DTLS';
3272: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_sequence);
3273: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_INVENTORY_ITEM_ID', gIDInventoryItemIdTbl);
3274: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_PO_LINE_ID', gIDPoLineIdTbl);
3275: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_NAME', gIDReqTemplateNameTbl);
3276: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_LINE_NUM', gIDReqTemplateLineNumTbl);
3277: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gIDOrgIdTbl);
3278: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gIDLanguageTbl);
3279: l_err_loc := 1800;

Line 3276: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_LINE_NUM', gIDReqTemplateLineNumTbl);

3272: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_sequence);
3273: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_INVENTORY_ITEM_ID', gIDInventoryItemIdTbl);
3274: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_PO_LINE_ID', gIDPoLineIdTbl);
3275: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_NAME', gIDReqTemplateNameTbl);
3276: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_LINE_NUM', gIDReqTemplateLineNumTbl);
3277: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gIDOrgIdTbl);
3278: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gIDLanguageTbl);
3279: l_err_loc := 1800;
3280: l_status := DBMS_SQL.EXECUTE(l_csr_handle);

Line 3277: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gIDOrgIdTbl);

3273: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_INVENTORY_ITEM_ID', gIDInventoryItemIdTbl);
3274: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_PO_LINE_ID', gIDPoLineIdTbl);
3275: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_NAME', gIDReqTemplateNameTbl);
3276: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_LINE_NUM', gIDReqTemplateLineNumTbl);
3277: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gIDOrgIdTbl);
3278: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gIDLanguageTbl);
3279: l_err_loc := 1800;
3280: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
3281: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 3278: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gIDLanguageTbl);

3274: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_PO_LINE_ID', gIDPoLineIdTbl);
3275: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_NAME', gIDReqTemplateNameTbl);
3276: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_LINE_NUM', gIDReqTemplateLineNumTbl);
3277: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gIDOrgIdTbl);
3278: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gIDLanguageTbl);
3279: l_err_loc := 1800;
3280: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
3281: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3282: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

Line 3280: l_status := DBMS_SQL.EXECUTE(l_csr_handle);

3276: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_LINE_NUM', gIDReqTemplateLineNumTbl);
3277: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gIDOrgIdTbl);
3278: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gIDLanguageTbl);
3279: l_err_loc := 1800;
3280: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
3281: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3282: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3283: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3284: 'special Ctx SQLS details..' ||

Line 3293: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_sequence);

3289:
3290: IF (l_sequence = 1 AND gDMDInventoryItemIdTbl.COUNT > 0) THEN
3291: l_err_loc := 1850;
3292: l_action_mode := 'DELETE_MANDATORY_ROW_CTX_DTLS';
3293: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_sequence);
3294: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_INVENTORY_ITEM_ID', gDMDInventoryItemIdTbl);
3295: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_PO_LINE_ID', gDMDPoLineIdTbl);
3296: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_NAME', gDMDReqTemplateNameTbl);
3297: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_LINE_NUM', gDMDReqTemplateLineNumTbl);

Line 3294: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_INVENTORY_ITEM_ID', gDMDInventoryItemIdTbl);

3290: IF (l_sequence = 1 AND gDMDInventoryItemIdTbl.COUNT > 0) THEN
3291: l_err_loc := 1850;
3292: l_action_mode := 'DELETE_MANDATORY_ROW_CTX_DTLS';
3293: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_sequence);
3294: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_INVENTORY_ITEM_ID', gDMDInventoryItemIdTbl);
3295: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_PO_LINE_ID', gDMDPoLineIdTbl);
3296: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_NAME', gDMDReqTemplateNameTbl);
3297: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_LINE_NUM', gDMDReqTemplateLineNumTbl);
3298: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gDMDOrgIdTbl);

Line 3295: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_PO_LINE_ID', gDMDPoLineIdTbl);

3291: l_err_loc := 1850;
3292: l_action_mode := 'DELETE_MANDATORY_ROW_CTX_DTLS';
3293: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_sequence);
3294: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_INVENTORY_ITEM_ID', gDMDInventoryItemIdTbl);
3295: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_PO_LINE_ID', gDMDPoLineIdTbl);
3296: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_NAME', gDMDReqTemplateNameTbl);
3297: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_LINE_NUM', gDMDReqTemplateLineNumTbl);
3298: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gDMDOrgIdTbl);
3299: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gDMDLanguageTbl);

Line 3296: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_NAME', gDMDReqTemplateNameTbl);

3292: l_action_mode := 'DELETE_MANDATORY_ROW_CTX_DTLS';
3293: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_sequence);
3294: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_INVENTORY_ITEM_ID', gDMDInventoryItemIdTbl);
3295: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_PO_LINE_ID', gDMDPoLineIdTbl);
3296: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_NAME', gDMDReqTemplateNameTbl);
3297: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_LINE_NUM', gDMDReqTemplateLineNumTbl);
3298: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gDMDOrgIdTbl);
3299: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gDMDLanguageTbl);
3300: l_err_loc := 1900;

Line 3297: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_LINE_NUM', gDMDReqTemplateLineNumTbl);

3293: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_sequence);
3294: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_INVENTORY_ITEM_ID', gDMDInventoryItemIdTbl);
3295: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_PO_LINE_ID', gDMDPoLineIdTbl);
3296: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_NAME', gDMDReqTemplateNameTbl);
3297: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_LINE_NUM', gDMDReqTemplateLineNumTbl);
3298: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gDMDOrgIdTbl);
3299: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gDMDLanguageTbl);
3300: l_err_loc := 1900;
3301: l_status := DBMS_SQL.EXECUTE(l_csr_handle);

Line 3298: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gDMDOrgIdTbl);

3294: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_INVENTORY_ITEM_ID', gDMDInventoryItemIdTbl);
3295: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_PO_LINE_ID', gDMDPoLineIdTbl);
3296: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_NAME', gDMDReqTemplateNameTbl);
3297: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_LINE_NUM', gDMDReqTemplateLineNumTbl);
3298: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gDMDOrgIdTbl);
3299: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gDMDLanguageTbl);
3300: l_err_loc := 1900;
3301: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
3302: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 3299: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gDMDLanguageTbl);

3295: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_PO_LINE_ID', gDMDPoLineIdTbl);
3296: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_NAME', gDMDReqTemplateNameTbl);
3297: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_LINE_NUM', gDMDReqTemplateLineNumTbl);
3298: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gDMDOrgIdTbl);
3299: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gDMDLanguageTbl);
3300: l_err_loc := 1900;
3301: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
3302: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3303: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

Line 3301: l_status := DBMS_SQL.EXECUTE(l_csr_handle);

3297: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_LINE_NUM', gDMDReqTemplateLineNumTbl);
3298: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gDMDOrgIdTbl);
3299: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gDMDLanguageTbl);
3300: l_err_loc := 1900;
3301: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
3302: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3303: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3304: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3305: 'special Ctx SQLS, Mandatory Row details..' ||

Line 3314: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_sequence);

3310:
3311: IF (l_sequence = 2 AND gDSDInventoryItemIdTbl.COUNT > 0) THEN
3312: l_err_loc := 1950;
3313: l_action_mode := 'DELETE_SUPPLIER_ROW_CTX_DTLS';
3314: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_sequence);
3315: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_INVENTORY_ITEM_ID', gDSDInventoryItemIdTbl);
3316: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_PO_LINE_ID', gDSDPoLineIdTbl);
3317: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_NAME', gDSDReqTemplateNameTbl);
3318: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_LINE_NUM', gDSDReqTemplateLineNumTbl);

Line 3315: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_INVENTORY_ITEM_ID', gDSDInventoryItemIdTbl);

3311: IF (l_sequence = 2 AND gDSDInventoryItemIdTbl.COUNT > 0) THEN
3312: l_err_loc := 1950;
3313: l_action_mode := 'DELETE_SUPPLIER_ROW_CTX_DTLS';
3314: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_sequence);
3315: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_INVENTORY_ITEM_ID', gDSDInventoryItemIdTbl);
3316: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_PO_LINE_ID', gDSDPoLineIdTbl);
3317: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_NAME', gDSDReqTemplateNameTbl);
3318: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_LINE_NUM', gDSDReqTemplateLineNumTbl);
3319: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gDSDOrgIdTbl);

Line 3316: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_PO_LINE_ID', gDSDPoLineIdTbl);

3312: l_err_loc := 1950;
3313: l_action_mode := 'DELETE_SUPPLIER_ROW_CTX_DTLS';
3314: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_sequence);
3315: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_INVENTORY_ITEM_ID', gDSDInventoryItemIdTbl);
3316: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_PO_LINE_ID', gDSDPoLineIdTbl);
3317: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_NAME', gDSDReqTemplateNameTbl);
3318: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_LINE_NUM', gDSDReqTemplateLineNumTbl);
3319: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gDSDOrgIdTbl);
3320: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gDSDLanguageTbl);

Line 3317: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_NAME', gDSDReqTemplateNameTbl);

3313: l_action_mode := 'DELETE_SUPPLIER_ROW_CTX_DTLS';
3314: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_sequence);
3315: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_INVENTORY_ITEM_ID', gDSDInventoryItemIdTbl);
3316: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_PO_LINE_ID', gDSDPoLineIdTbl);
3317: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_NAME', gDSDReqTemplateNameTbl);
3318: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_LINE_NUM', gDSDReqTemplateLineNumTbl);
3319: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gDSDOrgIdTbl);
3320: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gDSDLanguageTbl);
3321: l_err_loc := 2000;

Line 3318: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_LINE_NUM', gDSDReqTemplateLineNumTbl);

3314: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_sequence);
3315: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_INVENTORY_ITEM_ID', gDSDInventoryItemIdTbl);
3316: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_PO_LINE_ID', gDSDPoLineIdTbl);
3317: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_NAME', gDSDReqTemplateNameTbl);
3318: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_LINE_NUM', gDSDReqTemplateLineNumTbl);
3319: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gDSDOrgIdTbl);
3320: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gDSDLanguageTbl);
3321: l_err_loc := 2000;
3322: l_status := DBMS_SQL.EXECUTE(l_csr_handle);

Line 3319: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gDSDOrgIdTbl);

3315: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_INVENTORY_ITEM_ID', gDSDInventoryItemIdTbl);
3316: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_PO_LINE_ID', gDSDPoLineIdTbl);
3317: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_NAME', gDSDReqTemplateNameTbl);
3318: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_LINE_NUM', gDSDReqTemplateLineNumTbl);
3319: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gDSDOrgIdTbl);
3320: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gDSDLanguageTbl);
3321: l_err_loc := 2000;
3322: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
3323: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 3320: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gDSDLanguageTbl);

3316: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_PO_LINE_ID', gDSDPoLineIdTbl);
3317: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_NAME', gDSDReqTemplateNameTbl);
3318: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_LINE_NUM', gDSDReqTemplateLineNumTbl);
3319: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gDSDOrgIdTbl);
3320: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gDSDLanguageTbl);
3321: l_err_loc := 2000;
3322: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
3323: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3324: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

Line 3322: l_status := DBMS_SQL.EXECUTE(l_csr_handle);

3318: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_LINE_NUM', gDSDReqTemplateLineNumTbl);
3319: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gDSDOrgIdTbl);
3320: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gDSDLanguageTbl);
3321: l_err_loc := 2000;
3322: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
3323: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3324: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3325: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3326: 'special Ctx SQLS, Supplier Row details..' ||

Line 3336: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_sequence);

3332: -- internal item number
3333: IF (l_sequence = 3 AND gDBLDInventoryItemIdTbl.COUNT > 0) THEN
3334: l_err_loc := 2010;
3335: l_action_mode := 'DELETE_SPECIFIC_CTX_DTLS';
3336: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_sequence);
3337: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_INVENTORY_ITEM_ID', gDBLDInventoryItemIdTbl);
3338: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_PO_LINE_ID', gDBLDPoLineIdTbl);
3339: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_NAME', gDBLDReqTemplateNameTbl);
3340: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_LINE_NUM', gDBLDReqTemplateLineNumTbl);

Line 3337: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_INVENTORY_ITEM_ID', gDBLDInventoryItemIdTbl);

3333: IF (l_sequence = 3 AND gDBLDInventoryItemIdTbl.COUNT > 0) THEN
3334: l_err_loc := 2010;
3335: l_action_mode := 'DELETE_SPECIFIC_CTX_DTLS';
3336: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_sequence);
3337: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_INVENTORY_ITEM_ID', gDBLDInventoryItemIdTbl);
3338: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_PO_LINE_ID', gDBLDPoLineIdTbl);
3339: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_NAME', gDBLDReqTemplateNameTbl);
3340: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_LINE_NUM', gDBLDReqTemplateLineNumTbl);
3341: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gDBLDOrgIdTbl);

Line 3338: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_PO_LINE_ID', gDBLDPoLineIdTbl);

3334: l_err_loc := 2010;
3335: l_action_mode := 'DELETE_SPECIFIC_CTX_DTLS';
3336: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_sequence);
3337: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_INVENTORY_ITEM_ID', gDBLDInventoryItemIdTbl);
3338: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_PO_LINE_ID', gDBLDPoLineIdTbl);
3339: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_NAME', gDBLDReqTemplateNameTbl);
3340: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_LINE_NUM', gDBLDReqTemplateLineNumTbl);
3341: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gDBLDOrgIdTbl);
3342: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gDBLDLanguageTbl);

Line 3339: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_NAME', gDBLDReqTemplateNameTbl);

3335: l_action_mode := 'DELETE_SPECIFIC_CTX_DTLS';
3336: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_sequence);
3337: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_INVENTORY_ITEM_ID', gDBLDInventoryItemIdTbl);
3338: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_PO_LINE_ID', gDBLDPoLineIdTbl);
3339: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_NAME', gDBLDReqTemplateNameTbl);
3340: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_LINE_NUM', gDBLDReqTemplateLineNumTbl);
3341: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gDBLDOrgIdTbl);
3342: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gDBLDLanguageTbl);
3343: l_err_loc := 2020;

Line 3340: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_LINE_NUM', gDBLDReqTemplateLineNumTbl);

3336: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_sequence);
3337: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_INVENTORY_ITEM_ID', gDBLDInventoryItemIdTbl);
3338: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_PO_LINE_ID', gDBLDPoLineIdTbl);
3339: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_NAME', gDBLDReqTemplateNameTbl);
3340: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_LINE_NUM', gDBLDReqTemplateLineNumTbl);
3341: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gDBLDOrgIdTbl);
3342: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gDBLDLanguageTbl);
3343: l_err_loc := 2020;
3344: l_status := DBMS_SQL.EXECUTE(l_csr_handle);

Line 3341: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gDBLDOrgIdTbl);

3337: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_INVENTORY_ITEM_ID', gDBLDInventoryItemIdTbl);
3338: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_PO_LINE_ID', gDBLDPoLineIdTbl);
3339: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_NAME', gDBLDReqTemplateNameTbl);
3340: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_LINE_NUM', gDBLDReqTemplateLineNumTbl);
3341: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gDBLDOrgIdTbl);
3342: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gDBLDLanguageTbl);
3343: l_err_loc := 2020;
3344: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
3345: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 3342: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gDBLDLanguageTbl);

3338: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_PO_LINE_ID', gDBLDPoLineIdTbl);
3339: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_NAME', gDBLDReqTemplateNameTbl);
3340: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_LINE_NUM', gDBLDReqTemplateLineNumTbl);
3341: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gDBLDOrgIdTbl);
3342: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gDBLDLanguageTbl);
3343: l_err_loc := 2020;
3344: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
3345: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3346: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

Line 3344: l_status := DBMS_SQL.EXECUTE(l_csr_handle);

3340: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_LINE_NUM', gDBLDReqTemplateLineNumTbl);
3341: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gDBLDOrgIdTbl);
3342: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gDBLDLanguageTbl);
3343: l_err_loc := 2020;
3344: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
3345: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3346: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3347: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3348: 'special Ctx SQLS, Item Number details..' ||

Line 3357: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_sequence);

3353:
3354: IF (l_sequence = 5 AND gDIRDInventoryItemIdTbl.COUNT > 0) THEN
3355: l_err_loc := 2050;
3356: l_action_mode := 'DELETE_ITEMREV_ROW_CTX_DTLS';
3357: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_sequence);
3358: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_INVENTORY_ITEM_ID', gDIRDInventoryItemIdTbl);
3359: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_PO_LINE_ID', gDIRDPoLineIdTbl);
3360: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_NAME', gDIRDReqTemplateNameTbl);
3361: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_LINE_NUM', gDIRDReqTemplateLineNumTbl);

Line 3358: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_INVENTORY_ITEM_ID', gDIRDInventoryItemIdTbl);

3354: IF (l_sequence = 5 AND gDIRDInventoryItemIdTbl.COUNT > 0) THEN
3355: l_err_loc := 2050;
3356: l_action_mode := 'DELETE_ITEMREV_ROW_CTX_DTLS';
3357: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_sequence);
3358: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_INVENTORY_ITEM_ID', gDIRDInventoryItemIdTbl);
3359: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_PO_LINE_ID', gDIRDPoLineIdTbl);
3360: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_NAME', gDIRDReqTemplateNameTbl);
3361: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_LINE_NUM', gDIRDReqTemplateLineNumTbl);
3362: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gDIRDOrgIdTbl);

Line 3359: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_PO_LINE_ID', gDIRDPoLineIdTbl);

3355: l_err_loc := 2050;
3356: l_action_mode := 'DELETE_ITEMREV_ROW_CTX_DTLS';
3357: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_sequence);
3358: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_INVENTORY_ITEM_ID', gDIRDInventoryItemIdTbl);
3359: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_PO_LINE_ID', gDIRDPoLineIdTbl);
3360: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_NAME', gDIRDReqTemplateNameTbl);
3361: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_LINE_NUM', gDIRDReqTemplateLineNumTbl);
3362: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gDIRDOrgIdTbl);
3363: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gDIRDLanguageTbl);

Line 3360: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_NAME', gDIRDReqTemplateNameTbl);

3356: l_action_mode := 'DELETE_ITEMREV_ROW_CTX_DTLS';
3357: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_sequence);
3358: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_INVENTORY_ITEM_ID', gDIRDInventoryItemIdTbl);
3359: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_PO_LINE_ID', gDIRDPoLineIdTbl);
3360: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_NAME', gDIRDReqTemplateNameTbl);
3361: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_LINE_NUM', gDIRDReqTemplateLineNumTbl);
3362: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gDIRDOrgIdTbl);
3363: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gDIRDLanguageTbl);
3364: l_err_loc := 2100;

Line 3361: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_LINE_NUM', gDIRDReqTemplateLineNumTbl);

3357: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_sequence);
3358: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_INVENTORY_ITEM_ID', gDIRDInventoryItemIdTbl);
3359: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_PO_LINE_ID', gDIRDPoLineIdTbl);
3360: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_NAME', gDIRDReqTemplateNameTbl);
3361: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_LINE_NUM', gDIRDReqTemplateLineNumTbl);
3362: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gDIRDOrgIdTbl);
3363: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gDIRDLanguageTbl);
3364: l_err_loc := 2100;
3365: l_status := DBMS_SQL.EXECUTE(l_csr_handle);

Line 3362: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gDIRDOrgIdTbl);

3358: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_INVENTORY_ITEM_ID', gDIRDInventoryItemIdTbl);
3359: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_PO_LINE_ID', gDIRDPoLineIdTbl);
3360: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_NAME', gDIRDReqTemplateNameTbl);
3361: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_LINE_NUM', gDIRDReqTemplateLineNumTbl);
3362: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gDIRDOrgIdTbl);
3363: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gDIRDLanguageTbl);
3364: l_err_loc := 2100;
3365: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
3366: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 3363: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gDIRDLanguageTbl);

3359: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_PO_LINE_ID', gDIRDPoLineIdTbl);
3360: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_NAME', gDIRDReqTemplateNameTbl);
3361: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_LINE_NUM', gDIRDReqTemplateLineNumTbl);
3362: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gDIRDOrgIdTbl);
3363: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gDIRDLanguageTbl);
3364: l_err_loc := 2100;
3365: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
3366: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3367: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

Line 3365: l_status := DBMS_SQL.EXECUTE(l_csr_handle);

3361: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_LINE_NUM', gDIRDReqTemplateLineNumTbl);
3362: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gDIRDOrgIdTbl);
3363: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gDIRDLanguageTbl);
3364: l_err_loc := 2100;
3365: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
3366: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3367: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3368: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3369: 'special Ctx SQLS, ItemRev Row details..' ||

Line 3378: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_sequence);

3374:
3375: IF (l_sequence = 6 AND gDSCDInventoryItemIdTbl.COUNT > 0) THEN
3376: l_err_loc := 2150;
3377: l_action_mode := 'DELETE_SHOPCATG_ROW_CTX_DTLS';
3378: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_sequence);
3379: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_INVENTORY_ITEM_ID', gDSCDInventoryItemIdTbl);
3380: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_PO_LINE_ID', gDSCDPoLineIdTbl);
3381: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_NAME', gDSCDReqTemplateNameTbl);
3382: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_LINE_NUM', gDSCDReqTemplateLineNumTbl);

Line 3379: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_INVENTORY_ITEM_ID', gDSCDInventoryItemIdTbl);

3375: IF (l_sequence = 6 AND gDSCDInventoryItemIdTbl.COUNT > 0) THEN
3376: l_err_loc := 2150;
3377: l_action_mode := 'DELETE_SHOPCATG_ROW_CTX_DTLS';
3378: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_sequence);
3379: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_INVENTORY_ITEM_ID', gDSCDInventoryItemIdTbl);
3380: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_PO_LINE_ID', gDSCDPoLineIdTbl);
3381: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_NAME', gDSCDReqTemplateNameTbl);
3382: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_LINE_NUM', gDSCDReqTemplateLineNumTbl);
3383: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gDSCDOrgIdTbl);

Line 3380: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_PO_LINE_ID', gDSCDPoLineIdTbl);

3376: l_err_loc := 2150;
3377: l_action_mode := 'DELETE_SHOPCATG_ROW_CTX_DTLS';
3378: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_sequence);
3379: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_INVENTORY_ITEM_ID', gDSCDInventoryItemIdTbl);
3380: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_PO_LINE_ID', gDSCDPoLineIdTbl);
3381: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_NAME', gDSCDReqTemplateNameTbl);
3382: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_LINE_NUM', gDSCDReqTemplateLineNumTbl);
3383: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gDSCDOrgIdTbl);
3384: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gDSCDLanguageTbl);

Line 3381: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_NAME', gDSCDReqTemplateNameTbl);

3377: l_action_mode := 'DELETE_SHOPCATG_ROW_CTX_DTLS';
3378: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_sequence);
3379: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_INVENTORY_ITEM_ID', gDSCDInventoryItemIdTbl);
3380: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_PO_LINE_ID', gDSCDPoLineIdTbl);
3381: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_NAME', gDSCDReqTemplateNameTbl);
3382: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_LINE_NUM', gDSCDReqTemplateLineNumTbl);
3383: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gDSCDOrgIdTbl);
3384: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gDSCDLanguageTbl);
3385: l_err_loc := 2200;

Line 3382: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_LINE_NUM', gDSCDReqTemplateLineNumTbl);

3378: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_sequence);
3379: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_INVENTORY_ITEM_ID', gDSCDInventoryItemIdTbl);
3380: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_PO_LINE_ID', gDSCDPoLineIdTbl);
3381: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_NAME', gDSCDReqTemplateNameTbl);
3382: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_LINE_NUM', gDSCDReqTemplateLineNumTbl);
3383: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gDSCDOrgIdTbl);
3384: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gDSCDLanguageTbl);
3385: l_err_loc := 2200;
3386: l_status := DBMS_SQL.EXECUTE(l_csr_handle);

Line 3383: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gDSCDOrgIdTbl);

3379: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_INVENTORY_ITEM_ID', gDSCDInventoryItemIdTbl);
3380: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_PO_LINE_ID', gDSCDPoLineIdTbl);
3381: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_NAME', gDSCDReqTemplateNameTbl);
3382: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_LINE_NUM', gDSCDReqTemplateLineNumTbl);
3383: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gDSCDOrgIdTbl);
3384: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gDSCDLanguageTbl);
3385: l_err_loc := 2200;
3386: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
3387: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 3384: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gDSCDLanguageTbl);

3380: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_PO_LINE_ID', gDSCDPoLineIdTbl);
3381: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_NAME', gDSCDReqTemplateNameTbl);
3382: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_LINE_NUM', gDSCDReqTemplateLineNumTbl);
3383: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gDSCDOrgIdTbl);
3384: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gDSCDLanguageTbl);
3385: l_err_loc := 2200;
3386: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
3387: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3388: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

Line 3386: l_status := DBMS_SQL.EXECUTE(l_csr_handle);

3382: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_LINE_NUM', gDSCDReqTemplateLineNumTbl);
3383: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gDSCDOrgIdTbl);
3384: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gDSCDLanguageTbl);
3385: l_err_loc := 2200;
3386: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
3387: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3388: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3389: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3390: 'special Ctx SQLS, ShopCatg Row details..' ||

Line 3397: DBMS_SQL.CLOSE_CURSOR(l_csr_handle);

3393: END IF;
3394: END IF;
3395:
3396: l_err_loc := 2250;
3397: DBMS_SQL.CLOSE_CURSOR(l_csr_handle);
3398: l_err_loc := 10000 + i;
3399: END LOOP;
3400: END IF;
3401:

Line 3610: l_csr_handle:=DBMS_SQL.OPEN_CURSOR;

3606: FOR i IN 1..l_regular_ctx_sql_tbl.COUNT LOOP
3607: l_err_loc := 3100;
3608: l_ctx_sqlstring_rec := l_regular_ctx_sql_tbl(i);
3609: l_err_loc := 3200;
3610: l_csr_handle:=DBMS_SQL.OPEN_CURSOR;
3611: l_err_loc := 3300;
3612: DBMS_SQL.PARSE(l_csr_handle, l_ctx_sqlstring_rec.ctx_sql_string, DBMS_SQL.NATIVE);
3613: IF (gIDInventoryItemIdTbl.COUNT > 0) THEN
3614: l_action_mode := 'INSERT_CTX_DTLS';

Line 3612: DBMS_SQL.PARSE(l_csr_handle, l_ctx_sqlstring_rec.ctx_sql_string, DBMS_SQL.NATIVE);

3608: l_ctx_sqlstring_rec := l_regular_ctx_sql_tbl(i);
3609: l_err_loc := 3200;
3610: l_csr_handle:=DBMS_SQL.OPEN_CURSOR;
3611: l_err_loc := 3300;
3612: DBMS_SQL.PARSE(l_csr_handle, l_ctx_sqlstring_rec.ctx_sql_string, DBMS_SQL.NATIVE);
3613: IF (gIDInventoryItemIdTbl.COUNT > 0) THEN
3614: l_action_mode := 'INSERT_CTX_DTLS';
3615: l_err_loc := 3400;
3616: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_ctx_sqlstring_rec.bind_sequence);

Line 3616: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_ctx_sqlstring_rec.bind_sequence);

3612: DBMS_SQL.PARSE(l_csr_handle, l_ctx_sqlstring_rec.ctx_sql_string, DBMS_SQL.NATIVE);
3613: IF (gIDInventoryItemIdTbl.COUNT > 0) THEN
3614: l_action_mode := 'INSERT_CTX_DTLS';
3615: l_err_loc := 3400;
3616: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_ctx_sqlstring_rec.bind_sequence);
3617: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_INVENTORY_ITEM_ID', gIDInventoryItemIdTbl);
3618: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_PO_LINE_ID', gIDPoLineIdTbl);
3619: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_NAME', gIDReqTemplateNameTbl);
3620: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_LINE_NUM', gIDReqTemplateLineNumTbl);

Line 3617: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_INVENTORY_ITEM_ID', gIDInventoryItemIdTbl);

3613: IF (gIDInventoryItemIdTbl.COUNT > 0) THEN
3614: l_action_mode := 'INSERT_CTX_DTLS';
3615: l_err_loc := 3400;
3616: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_ctx_sqlstring_rec.bind_sequence);
3617: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_INVENTORY_ITEM_ID', gIDInventoryItemIdTbl);
3618: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_PO_LINE_ID', gIDPoLineIdTbl);
3619: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_NAME', gIDReqTemplateNameTbl);
3620: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_LINE_NUM', gIDReqTemplateLineNumTbl);
3621: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gIDOrgIdTbl);

Line 3618: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_PO_LINE_ID', gIDPoLineIdTbl);

3614: l_action_mode := 'INSERT_CTX_DTLS';
3615: l_err_loc := 3400;
3616: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_ctx_sqlstring_rec.bind_sequence);
3617: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_INVENTORY_ITEM_ID', gIDInventoryItemIdTbl);
3618: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_PO_LINE_ID', gIDPoLineIdTbl);
3619: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_NAME', gIDReqTemplateNameTbl);
3620: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_LINE_NUM', gIDReqTemplateLineNumTbl);
3621: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gIDOrgIdTbl);
3622: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gIDLanguageTbl);

Line 3619: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_NAME', gIDReqTemplateNameTbl);

3615: l_err_loc := 3400;
3616: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_ctx_sqlstring_rec.bind_sequence);
3617: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_INVENTORY_ITEM_ID', gIDInventoryItemIdTbl);
3618: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_PO_LINE_ID', gIDPoLineIdTbl);
3619: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_NAME', gIDReqTemplateNameTbl);
3620: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_LINE_NUM', gIDReqTemplateLineNumTbl);
3621: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gIDOrgIdTbl);
3622: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gIDLanguageTbl);
3623: l_err_loc := 3500;

Line 3620: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_LINE_NUM', gIDReqTemplateLineNumTbl);

3616: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_ctx_sqlstring_rec.bind_sequence);
3617: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_INVENTORY_ITEM_ID', gIDInventoryItemIdTbl);
3618: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_PO_LINE_ID', gIDPoLineIdTbl);
3619: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_NAME', gIDReqTemplateNameTbl);
3620: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_LINE_NUM', gIDReqTemplateLineNumTbl);
3621: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gIDOrgIdTbl);
3622: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gIDLanguageTbl);
3623: l_err_loc := 3500;
3624: l_status := DBMS_SQL.EXECUTE(l_csr_handle);

Line 3621: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gIDOrgIdTbl);

3617: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_INVENTORY_ITEM_ID', gIDInventoryItemIdTbl);
3618: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_PO_LINE_ID', gIDPoLineIdTbl);
3619: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_NAME', gIDReqTemplateNameTbl);
3620: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_LINE_NUM', gIDReqTemplateLineNumTbl);
3621: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gIDOrgIdTbl);
3622: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gIDLanguageTbl);
3623: l_err_loc := 3500;
3624: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
3625: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 3622: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gIDLanguageTbl);

3618: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_PO_LINE_ID', gIDPoLineIdTbl);
3619: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_NAME', gIDReqTemplateNameTbl);
3620: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_LINE_NUM', gIDReqTemplateLineNumTbl);
3621: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gIDOrgIdTbl);
3622: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gIDLanguageTbl);
3623: l_err_loc := 3500;
3624: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
3625: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3626: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

Line 3624: l_status := DBMS_SQL.EXECUTE(l_csr_handle);

3620: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_LINE_NUM', gIDReqTemplateLineNumTbl);
3621: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gIDOrgIdTbl);
3622: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gIDLanguageTbl);
3623: l_err_loc := 3500;
3624: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
3625: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3626: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3627: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3628: 'regular Ctx SQLS details..' ||

Line 3638: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_ctx_sqlstring_rec.bind_sequence);

3634: l_err_loc := 3600;
3635: IF (gDBLDInventoryItemIdTbl.COUNT > 0) THEN
3636: l_action_mode := 'DELETE_SPECIFIC_CTX_DTLS';
3637: l_err_loc := 3700;
3638: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_ctx_sqlstring_rec.bind_sequence);
3639: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_INVENTORY_ITEM_ID', gDBLDInventoryItemIdTbl);
3640: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_PO_LINE_ID', gDBLDPoLineIdTbl);
3641: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_NAME', gDBLDReqTemplateNameTbl);
3642: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_LINE_NUM', gDBLDReqTemplateLineNumTbl);

Line 3639: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_INVENTORY_ITEM_ID', gDBLDInventoryItemIdTbl);

3635: IF (gDBLDInventoryItemIdTbl.COUNT > 0) THEN
3636: l_action_mode := 'DELETE_SPECIFIC_CTX_DTLS';
3637: l_err_loc := 3700;
3638: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_ctx_sqlstring_rec.bind_sequence);
3639: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_INVENTORY_ITEM_ID', gDBLDInventoryItemIdTbl);
3640: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_PO_LINE_ID', gDBLDPoLineIdTbl);
3641: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_NAME', gDBLDReqTemplateNameTbl);
3642: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_LINE_NUM', gDBLDReqTemplateLineNumTbl);
3643: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gDBLDOrgIdTbl);

Line 3640: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_PO_LINE_ID', gDBLDPoLineIdTbl);

3636: l_action_mode := 'DELETE_SPECIFIC_CTX_DTLS';
3637: l_err_loc := 3700;
3638: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_ctx_sqlstring_rec.bind_sequence);
3639: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_INVENTORY_ITEM_ID', gDBLDInventoryItemIdTbl);
3640: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_PO_LINE_ID', gDBLDPoLineIdTbl);
3641: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_NAME', gDBLDReqTemplateNameTbl);
3642: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_LINE_NUM', gDBLDReqTemplateLineNumTbl);
3643: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gDBLDOrgIdTbl);
3644: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gDBLDLanguageTbl);

Line 3641: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_NAME', gDBLDReqTemplateNameTbl);

3637: l_err_loc := 3700;
3638: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_ctx_sqlstring_rec.bind_sequence);
3639: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_INVENTORY_ITEM_ID', gDBLDInventoryItemIdTbl);
3640: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_PO_LINE_ID', gDBLDPoLineIdTbl);
3641: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_NAME', gDBLDReqTemplateNameTbl);
3642: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_LINE_NUM', gDBLDReqTemplateLineNumTbl);
3643: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gDBLDOrgIdTbl);
3644: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gDBLDLanguageTbl);
3645: l_err_loc := 3800;

Line 3642: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_LINE_NUM', gDBLDReqTemplateLineNumTbl);

3638: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_ctx_sqlstring_rec.bind_sequence);
3639: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_INVENTORY_ITEM_ID', gDBLDInventoryItemIdTbl);
3640: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_PO_LINE_ID', gDBLDPoLineIdTbl);
3641: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_NAME', gDBLDReqTemplateNameTbl);
3642: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_LINE_NUM', gDBLDReqTemplateLineNumTbl);
3643: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gDBLDOrgIdTbl);
3644: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gDBLDLanguageTbl);
3645: l_err_loc := 3800;
3646: l_status := DBMS_SQL.EXECUTE(l_csr_handle);

Line 3643: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gDBLDOrgIdTbl);

3639: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_INVENTORY_ITEM_ID', gDBLDInventoryItemIdTbl);
3640: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_PO_LINE_ID', gDBLDPoLineIdTbl);
3641: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_NAME', gDBLDReqTemplateNameTbl);
3642: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_LINE_NUM', gDBLDReqTemplateLineNumTbl);
3643: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gDBLDOrgIdTbl);
3644: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gDBLDLanguageTbl);
3645: l_err_loc := 3800;
3646: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
3647: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 3644: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gDBLDLanguageTbl);

3640: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_PO_LINE_ID', gDBLDPoLineIdTbl);
3641: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_NAME', gDBLDReqTemplateNameTbl);
3642: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_LINE_NUM', gDBLDReqTemplateLineNumTbl);
3643: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gDBLDOrgIdTbl);
3644: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gDBLDLanguageTbl);
3645: l_err_loc := 3800;
3646: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
3647: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3648: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

Line 3646: l_status := DBMS_SQL.EXECUTE(l_csr_handle);

3642: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_LINE_NUM', gDBLDReqTemplateLineNumTbl);
3643: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gDBLDOrgIdTbl);
3644: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gDBLDLanguageTbl);
3645: l_err_loc := 3800;
3646: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
3647: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3648: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3649: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3650: 'regular Ctx SQLS details..' ||

Line 3657: DBMS_SQL.CLOSE_CURSOR(l_csr_handle);

3653: ', Num. of rows inserted into dtls:' || l_status);
3654: END IF;
3655: END IF;
3656: l_err_loc := 3900;
3657: DBMS_SQL.CLOSE_CURSOR(l_csr_handle);
3658: l_err_loc := 20000 + i;
3659: END LOOP;
3660: END IF; -- (p_current_cursor = ICX_CAT_UTIL_PVT.g_GBPACsr_const)
3661:

Line 3703: l_rowid_tbl DBMS_SQL.UROWID_TABLE;

3699: l_err_loc PLS_INTEGER;
3700: l_searchable NUMBER;
3701: l_section_tag NUMBER;
3702: l_continue BOOLEAN := TRUE;
3703: l_rowid_tbl DBMS_SQL.UROWID_TABLE;
3704: l_row_count PLS_INTEGER;
3705: BEGIN
3706: l_err_loc := 100;
3707: ICX_CAT_BUILD_CTX_SQL_PVT.checkIfAttributeIsSrchble

Line 3903: l_rowid_tbl DBMS_SQL.UROWID_TABLE;

3899: l_api_name CONSTANT VARCHAR2(30) := 'populateVendorMerge';
3900: l_err_loc PLS_INTEGER;
3901: l_to_vendor_name po_vendors.vendor_name%TYPE;
3902: l_continue BOOLEAN := TRUE;
3903: l_rowid_tbl DBMS_SQL.UROWID_TABLE;
3904: l_rows_updated BOOLEAN := TRUE;
3905: l_metadataTblFormed BOOLEAN := FALSE;
3906: l_special_metadata_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_metadata_tbl_type;
3907: l_regular_nontl_metadata_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_metadata_tbl_type;

Line 3944: l_csr_handle := DBMS_SQL.OPEN_CURSOR;

3940:
3941: l_err_loc := 600;
3942: -- open the cursor for the dynamic sql to insert the
3943: -- row with sequence 1 in icx_cat_items_ctx_dtls_tlp only once
3944: l_csr_handle := DBMS_SQL.OPEN_CURSOR;
3945:
3946: l_err_loc := 700;
3947: WHILE l_continue LOOP
3948: l_err_loc := 800;

Line 4032: DBMS_SQL.PARSE(l_csr_handle, l_ctx_sqlstring_rec.ctx_sql_string, DBMS_SQL.NATIVE);

4028: l_ctx_sqlstring_rec := l_special_ctx_sql_tbl(1);
4029:
4030: -- parse the cursor only once
4031: l_err_loc := 1800;
4032: DBMS_SQL.PARSE(l_csr_handle, l_ctx_sqlstring_rec.ctx_sql_string, DBMS_SQL.NATIVE);
4033: END IF;
4034:
4035: l_err_loc := 1900;
4036:

Line 4038: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_ctx_sqlstring_rec.bind_sequence);

4034:
4035: l_err_loc := 1900;
4036:
4037: -- insert the mandatory row in icx_cat_items_ctx_dtls_tlp i.e. the row with sequence = 1
4038: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_ctx_sqlstring_rec.bind_sequence);
4039: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_rowid', l_rowid_tbl);
4040: l_err_loc := 2000;
4041: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
4042: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 4039: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_rowid', l_rowid_tbl);

4035: l_err_loc := 1900;
4036:
4037: -- insert the mandatory row in icx_cat_items_ctx_dtls_tlp i.e. the row with sequence = 1
4038: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_ctx_sqlstring_rec.bind_sequence);
4039: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_rowid', l_rowid_tbl);
4040: l_err_loc := 2000;
4041: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
4042: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4043: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

Line 4041: l_status := DBMS_SQL.EXECUTE(l_csr_handle);

4037: -- insert the mandatory row in icx_cat_items_ctx_dtls_tlp i.e. the row with sequence = 1
4038: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_ctx_sqlstring_rec.bind_sequence);
4039: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_rowid', l_rowid_tbl);
4040: l_err_loc := 2000;
4041: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
4042: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4043: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4044: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4045: 'Num. of rows inserted into dtls for seq=1:' || l_status);

Line 4124: DBMS_SQL.CLOSE_CURSOR(l_csr_handle);

4120: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
4121: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4122: 'the dynamic sql is closed');
4123: END IF;
4124: DBMS_SQL.CLOSE_CURSOR(l_csr_handle);
4125:
4126: l_err_loc := 2900;
4127: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
4128: l_err_loc := 3000;

Line 4212: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;

4208: PROCEDURE purgeInvalidCategoryItems
4209: IS
4210:
4211: ----- Start of declaring columns fetched from the cursor-----
4212: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
4213: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
4214: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
4215: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
4216: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 4213: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;

4209: IS
4210:
4211: ----- Start of declaring columns fetched from the cursor-----
4212: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
4213: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
4214: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
4215: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
4216: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
4217: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 4214: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;

4210:
4211: ----- Start of declaring columns fetched from the cursor-----
4212: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
4213: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
4214: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
4215: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
4216: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
4217: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
4218: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 4215: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;

4211: ----- Start of declaring columns fetched from the cursor-----
4212: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
4213: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
4214: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
4215: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
4216: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
4217: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
4218: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
4219: ------ End of declaring columns fetched from the cursor ------

Line 4216: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;

4212: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
4213: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
4214: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
4215: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
4216: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
4217: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
4218: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
4219: ------ End of declaring columns fetched from the cursor ------
4220:

Line 4217: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;

4213: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
4214: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
4215: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
4216: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
4217: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
4218: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
4219: ------ End of declaring columns fetched from the cursor ------
4220:
4221: l_api_name CONSTANT VARCHAR2(30) := 'purgeInvalidCategoryItems';

Line 4218: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;

4214: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
4215: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
4216: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
4217: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
4218: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
4219: ------ End of declaring columns fetched from the cursor ------
4220:
4221: l_api_name CONSTANT VARCHAR2(30) := 'purgeInvalidCategoryItems';
4222: l_continue BOOLEAN := TRUE;

Line 4385: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;

4381: PROCEDURE purgeInvalidReqTmpltLines
4382: IS
4383:
4384: ----- Start of declaring columns returned from the delete -----
4385: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
4386: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
4387: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
4388: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
4389: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 4386: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;

4382: IS
4383:
4384: ----- Start of declaring columns returned from the delete -----
4385: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
4386: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
4387: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
4388: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
4389: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
4390: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 4387: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;

4383:
4384: ----- Start of declaring columns returned from the delete -----
4385: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
4386: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
4387: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
4388: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
4389: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
4390: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
4391: ------ End of declaring columns returned from the delete ------

Line 4388: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;

4384: ----- Start of declaring columns returned from the delete -----
4385: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
4386: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
4387: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
4388: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
4389: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
4390: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
4391: ------ End of declaring columns returned from the delete ------
4392:

Line 4389: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;

4385: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
4386: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
4387: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
4388: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
4389: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
4390: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
4391: ------ End of declaring columns returned from the delete ------
4392:
4393: l_api_name CONSTANT VARCHAR2(30) := 'purgeInvalidReqTmpltLines';

Line 4390: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;

4386: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
4387: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
4388: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
4389: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
4390: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
4391: ------ End of declaring columns returned from the delete ------
4392:
4393: l_api_name CONSTANT VARCHAR2(30) := 'purgeInvalidReqTmpltLines';
4394: l_continue BOOLEAN := TRUE;

Line 4533: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;

4529: PROCEDURE purgeInvalidQuoteLines
4530: IS
4531:
4532: ----- Start of declaring columns returned from the delete -----
4533: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
4534: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
4535: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
4536: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
4537: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 4534: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;

4530: IS
4531:
4532: ----- Start of declaring columns returned from the delete -----
4533: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
4534: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
4535: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
4536: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
4537: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
4538: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 4535: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;

4531:
4532: ----- Start of declaring columns returned from the delete -----
4533: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
4534: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
4535: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
4536: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
4537: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
4538: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
4539: ------ End of declaring columns returned from the delete ------

Line 4536: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;

4532: ----- Start of declaring columns returned from the delete -----
4533: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
4534: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
4535: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
4536: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
4537: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
4538: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
4539: ------ End of declaring columns returned from the delete ------
4540:

Line 4537: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;

4533: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
4534: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
4535: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
4536: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
4537: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
4538: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
4539: ------ End of declaring columns returned from the delete ------
4540:
4541: l_api_name CONSTANT VARCHAR2(30) := 'purgeInvalidQuoteLines';

Line 4538: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;

4534: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
4535: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
4536: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
4537: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
4538: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
4539: ------ End of declaring columns returned from the delete ------
4540:
4541: l_api_name CONSTANT VARCHAR2(30) := 'purgeInvalidQuoteLines';
4542: l_continue BOOLEAN := TRUE;

Line 4665: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;

4661: PROCEDURE purgeInvalidBlanketLines
4662: IS
4663:
4664: ----- Start of declaring columns returned from the delete -----
4665: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
4666: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
4667: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
4668: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
4669: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 4666: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;

4662: IS
4663:
4664: ----- Start of declaring columns returned from the delete -----
4665: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
4666: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
4667: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
4668: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
4669: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
4670: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 4667: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;

4663:
4664: ----- Start of declaring columns returned from the delete -----
4665: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
4666: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
4667: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
4668: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
4669: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
4670: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
4671: ------ End of declaring columns returned from the delete ------

Line 4668: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;

4664: ----- Start of declaring columns returned from the delete -----
4665: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
4666: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
4667: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
4668: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
4669: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
4670: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
4671: ------ End of declaring columns returned from the delete ------
4672:

Line 4669: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;

4665: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
4666: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
4667: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
4668: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
4669: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
4670: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
4671: ------ End of declaring columns returned from the delete ------
4672:
4673: l_api_name CONSTANT VARCHAR2(30) := 'purgeInvalidBlanketLines';

Line 4670: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;

4666: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
4667: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
4668: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
4669: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
4670: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
4671: ------ End of declaring columns returned from the delete ------
4672:
4673: l_api_name CONSTANT VARCHAR2(30) := 'purgeInvalidBlanketLines';
4674: l_continue BOOLEAN := TRUE;