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 DBMS_SQL.VARCHAR2_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 DBMS_SQL.VARCHAR2_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 DBMS_SQL.VARCHAR2_TABLE;
53: gIHOrganizationIdTbl DBMS_SQL.NUMBER_TABLE;
54: gIHMasterOrganizationIdTbl DBMS_SQL.NUMBER_TABLE;

Line 52: gIHLongDescriptionTbl DBMS_SQL.VARCHAR2_TABLE;

48: gIHRfqRequiredFlagTbl DBMS_SQL.VARCHAR2_TABLE;
49: gIHNegotiatedByPreparerFlagTbl DBMS_SQL.VARCHAR2_TABLE;
50: gIHDescriptionTbl DBMS_SQL.VARCHAR2_TABLE;
51: --Bug6599217
52: gIHLongDescriptionTbl 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;

Line 53: gIHOrganizationIdTbl DBMS_SQL.NUMBER_TABLE;

49: gIHNegotiatedByPreparerFlagTbl DBMS_SQL.VARCHAR2_TABLE;
50: gIHDescriptionTbl DBMS_SQL.VARCHAR2_TABLE;
51: --Bug6599217
52: gIHLongDescriptionTbl 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;

Line 54: gIHMasterOrganizationIdTbl DBMS_SQL.NUMBER_TABLE;

50: gIHDescriptionTbl DBMS_SQL.VARCHAR2_TABLE;
51: --Bug6599217
52: gIHLongDescriptionTbl 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;

Line 55: gIHOrderTypeLookupCodeTbl DBMS_SQL.VARCHAR2_TABLE;

51: --Bug6599217
52: gIHLongDescriptionTbl 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:

Line 56: gIHSupplierTbl DBMS_SQL.VARCHAR2_TABLE;

52: gIHLongDescriptionTbl 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

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 DBMS_SQL.VARCHAR2_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 DBMS_SQL.VARCHAR2_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 DBMS_SQL.VARCHAR2_TABLE;
110: gUHOrganizationIdTbl DBMS_SQL.NUMBER_TABLE;
111: gUHMasterOrganizationIdTbl DBMS_SQL.NUMBER_TABLE;

Line 109: gUHLongDescriptionTbl DBMS_SQL.VARCHAR2_TABLE;

105: gUHRfqRequiredFlagTbl DBMS_SQL.VARCHAR2_TABLE;
106: gUHNegotiatedByPreparerFlagTbl DBMS_SQL.VARCHAR2_TABLE;
107: gUHDescriptionTbl DBMS_SQL.VARCHAR2_TABLE;
108: --Bug6599217
109: gUHLongDescriptionTbl DBMS_SQL.VARCHAR2_TABLE;
110: gUHOrganizationIdTbl DBMS_SQL.NUMBER_TABLE;
111: gUHMasterOrganizationIdTbl DBMS_SQL.NUMBER_TABLE;
112:
113: gUHOrderTypeLookupCodeTbl DBMS_SQL.VARCHAR2_TABLE;

Line 110: gUHOrganizationIdTbl DBMS_SQL.NUMBER_TABLE;

106: gUHNegotiatedByPreparerFlagTbl DBMS_SQL.VARCHAR2_TABLE;
107: gUHDescriptionTbl DBMS_SQL.VARCHAR2_TABLE;
108: --Bug6599217
109: gUHLongDescriptionTbl 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;

Line 111: gUHMasterOrganizationIdTbl DBMS_SQL.NUMBER_TABLE;

107: gUHDescriptionTbl DBMS_SQL.VARCHAR2_TABLE;
108: --Bug6599217
109: gUHLongDescriptionTbl 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;

Line 113: gUHOrderTypeLookupCodeTbl DBMS_SQL.VARCHAR2_TABLE;

109: gUHLongDescriptionTbl 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:

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 3264: l_csr_handle:=DBMS_SQL.OPEN_CURSOR;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

3329:
3330: IF (l_sequence = 5 AND gDIRDInventoryItemIdTbl.COUNT > 0) THEN
3331: l_err_loc := 2050;
3332: l_action_mode := 'DELETE_ITEMREV_ROW_CTX_DTLS';
3333: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_sequence);
3334: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_INVENTORY_ITEM_ID', gDIRDInventoryItemIdTbl);
3335: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_PO_LINE_ID', gDIRDPoLineIdTbl);
3336: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_NAME', gDIRDReqTemplateNameTbl);
3337: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_LINE_NUM', gDIRDReqTemplateLineNumTbl);

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

3330: IF (l_sequence = 5 AND gDIRDInventoryItemIdTbl.COUNT > 0) THEN
3331: l_err_loc := 2050;
3332: l_action_mode := 'DELETE_ITEMREV_ROW_CTX_DTLS';
3333: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_sequence);
3334: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_INVENTORY_ITEM_ID', gDIRDInventoryItemIdTbl);
3335: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_PO_LINE_ID', gDIRDPoLineIdTbl);
3336: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_NAME', gDIRDReqTemplateNameTbl);
3337: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_LINE_NUM', gDIRDReqTemplateLineNumTbl);
3338: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gDIRDOrgIdTbl);

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

3331: l_err_loc := 2050;
3332: l_action_mode := 'DELETE_ITEMREV_ROW_CTX_DTLS';
3333: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_sequence);
3334: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_INVENTORY_ITEM_ID', gDIRDInventoryItemIdTbl);
3335: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_PO_LINE_ID', gDIRDPoLineIdTbl);
3336: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_NAME', gDIRDReqTemplateNameTbl);
3337: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_LINE_NUM', gDIRDReqTemplateLineNumTbl);
3338: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gDIRDOrgIdTbl);
3339: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gDIRDLanguageTbl);

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

3332: l_action_mode := 'DELETE_ITEMREV_ROW_CTX_DTLS';
3333: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_sequence);
3334: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_INVENTORY_ITEM_ID', gDIRDInventoryItemIdTbl);
3335: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_PO_LINE_ID', gDIRDPoLineIdTbl);
3336: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_NAME', gDIRDReqTemplateNameTbl);
3337: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_LINE_NUM', gDIRDReqTemplateLineNumTbl);
3338: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gDIRDOrgIdTbl);
3339: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gDIRDLanguageTbl);
3340: l_err_loc := 2100;

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

3333: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_sequence);
3334: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_INVENTORY_ITEM_ID', gDIRDInventoryItemIdTbl);
3335: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_PO_LINE_ID', gDIRDPoLineIdTbl);
3336: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_NAME', gDIRDReqTemplateNameTbl);
3337: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_LINE_NUM', gDIRDReqTemplateLineNumTbl);
3338: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gDIRDOrgIdTbl);
3339: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gDIRDLanguageTbl);
3340: l_err_loc := 2100;
3341: l_status := DBMS_SQL.EXECUTE(l_csr_handle);

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

3334: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_INVENTORY_ITEM_ID', gDIRDInventoryItemIdTbl);
3335: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_PO_LINE_ID', gDIRDPoLineIdTbl);
3336: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_NAME', gDIRDReqTemplateNameTbl);
3337: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_LINE_NUM', gDIRDReqTemplateLineNumTbl);
3338: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gDIRDOrgIdTbl);
3339: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gDIRDLanguageTbl);
3340: l_err_loc := 2100;
3341: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
3342: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

3335: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_PO_LINE_ID', gDIRDPoLineIdTbl);
3336: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_NAME', gDIRDReqTemplateNameTbl);
3337: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_LINE_NUM', gDIRDReqTemplateLineNumTbl);
3338: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gDIRDOrgIdTbl);
3339: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gDIRDLanguageTbl);
3340: l_err_loc := 2100;
3341: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
3342: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3343: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

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

3337: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_LINE_NUM', gDIRDReqTemplateLineNumTbl);
3338: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gDIRDOrgIdTbl);
3339: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gDIRDLanguageTbl);
3340: l_err_loc := 2100;
3341: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
3342: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3343: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3344: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3345: 'special Ctx SQLS, ItemRev Row details..' ||

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

3350:
3351: IF (l_sequence = 6 AND gDSCDInventoryItemIdTbl.COUNT > 0) THEN
3352: l_err_loc := 2150;
3353: l_action_mode := 'DELETE_SHOPCATG_ROW_CTX_DTLS';
3354: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_sequence);
3355: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_INVENTORY_ITEM_ID', gDSCDInventoryItemIdTbl);
3356: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_PO_LINE_ID', gDSCDPoLineIdTbl);
3357: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_NAME', gDSCDReqTemplateNameTbl);
3358: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_LINE_NUM', gDSCDReqTemplateLineNumTbl);

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

3351: IF (l_sequence = 6 AND gDSCDInventoryItemIdTbl.COUNT > 0) THEN
3352: l_err_loc := 2150;
3353: l_action_mode := 'DELETE_SHOPCATG_ROW_CTX_DTLS';
3354: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_sequence);
3355: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_INVENTORY_ITEM_ID', gDSCDInventoryItemIdTbl);
3356: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_PO_LINE_ID', gDSCDPoLineIdTbl);
3357: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_NAME', gDSCDReqTemplateNameTbl);
3358: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_LINE_NUM', gDSCDReqTemplateLineNumTbl);
3359: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gDSCDOrgIdTbl);

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

3352: l_err_loc := 2150;
3353: l_action_mode := 'DELETE_SHOPCATG_ROW_CTX_DTLS';
3354: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_sequence);
3355: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_INVENTORY_ITEM_ID', gDSCDInventoryItemIdTbl);
3356: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_PO_LINE_ID', gDSCDPoLineIdTbl);
3357: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_NAME', gDSCDReqTemplateNameTbl);
3358: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_LINE_NUM', gDSCDReqTemplateLineNumTbl);
3359: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gDSCDOrgIdTbl);
3360: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gDSCDLanguageTbl);

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

3353: l_action_mode := 'DELETE_SHOPCATG_ROW_CTX_DTLS';
3354: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_sequence);
3355: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_INVENTORY_ITEM_ID', gDSCDInventoryItemIdTbl);
3356: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_PO_LINE_ID', gDSCDPoLineIdTbl);
3357: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_NAME', gDSCDReqTemplateNameTbl);
3358: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_LINE_NUM', gDSCDReqTemplateLineNumTbl);
3359: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gDSCDOrgIdTbl);
3360: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gDSCDLanguageTbl);
3361: l_err_loc := 2200;

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

3354: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_sequence);
3355: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_INVENTORY_ITEM_ID', gDSCDInventoryItemIdTbl);
3356: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_PO_LINE_ID', gDSCDPoLineIdTbl);
3357: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_NAME', gDSCDReqTemplateNameTbl);
3358: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_LINE_NUM', gDSCDReqTemplateLineNumTbl);
3359: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gDSCDOrgIdTbl);
3360: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gDSCDLanguageTbl);
3361: l_err_loc := 2200;
3362: l_status := DBMS_SQL.EXECUTE(l_csr_handle);

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

3355: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_INVENTORY_ITEM_ID', gDSCDInventoryItemIdTbl);
3356: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_PO_LINE_ID', gDSCDPoLineIdTbl);
3357: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_NAME', gDSCDReqTemplateNameTbl);
3358: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_LINE_NUM', gDSCDReqTemplateLineNumTbl);
3359: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gDSCDOrgIdTbl);
3360: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gDSCDLanguageTbl);
3361: l_err_loc := 2200;
3362: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
3363: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

3356: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_PO_LINE_ID', gDSCDPoLineIdTbl);
3357: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_NAME', gDSCDReqTemplateNameTbl);
3358: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_LINE_NUM', gDSCDReqTemplateLineNumTbl);
3359: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gDSCDOrgIdTbl);
3360: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gDSCDLanguageTbl);
3361: l_err_loc := 2200;
3362: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
3363: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3364: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

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

3358: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_LINE_NUM', gDSCDReqTemplateLineNumTbl);
3359: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gDSCDOrgIdTbl);
3360: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gDSCDLanguageTbl);
3361: l_err_loc := 2200;
3362: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
3363: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3364: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3365: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3366: 'special Ctx SQLS, ShopCatg Row details..' ||

Line 3373: DBMS_SQL.CLOSE_CURSOR(l_csr_handle);

3369: END IF;
3370: END IF;
3371:
3372: l_err_loc := 2250;
3373: DBMS_SQL.CLOSE_CURSOR(l_csr_handle);
3374: l_err_loc := 10000 + i;
3375: END LOOP;
3376: END IF;
3377:

Line 3585: l_csr_handle:=DBMS_SQL.OPEN_CURSOR;

3581: FOR i IN 1..l_regular_ctx_sql_tbl.COUNT LOOP
3582: l_err_loc := 3100;
3583: l_ctx_sqlstring_rec := l_regular_ctx_sql_tbl(i);
3584: l_err_loc := 3200;
3585: l_csr_handle:=DBMS_SQL.OPEN_CURSOR;
3586: l_err_loc := 3300;
3587: DBMS_SQL.PARSE(l_csr_handle, l_ctx_sqlstring_rec.ctx_sql_string, DBMS_SQL.NATIVE);
3588: IF (gIDInventoryItemIdTbl.COUNT > 0) THEN
3589: l_action_mode := 'INSERT_CTX_DTLS';

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

3583: l_ctx_sqlstring_rec := l_regular_ctx_sql_tbl(i);
3584: l_err_loc := 3200;
3585: l_csr_handle:=DBMS_SQL.OPEN_CURSOR;
3586: l_err_loc := 3300;
3587: DBMS_SQL.PARSE(l_csr_handle, l_ctx_sqlstring_rec.ctx_sql_string, DBMS_SQL.NATIVE);
3588: IF (gIDInventoryItemIdTbl.COUNT > 0) THEN
3589: l_action_mode := 'INSERT_CTX_DTLS';
3590: l_err_loc := 3400;
3591: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_ctx_sqlstring_rec.bind_sequence);

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

3587: DBMS_SQL.PARSE(l_csr_handle, l_ctx_sqlstring_rec.ctx_sql_string, DBMS_SQL.NATIVE);
3588: IF (gIDInventoryItemIdTbl.COUNT > 0) THEN
3589: l_action_mode := 'INSERT_CTX_DTLS';
3590: l_err_loc := 3400;
3591: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_ctx_sqlstring_rec.bind_sequence);
3592: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_INVENTORY_ITEM_ID', gIDInventoryItemIdTbl);
3593: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_PO_LINE_ID', gIDPoLineIdTbl);
3594: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_NAME', gIDReqTemplateNameTbl);
3595: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_LINE_NUM', gIDReqTemplateLineNumTbl);

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

3588: IF (gIDInventoryItemIdTbl.COUNT > 0) THEN
3589: l_action_mode := 'INSERT_CTX_DTLS';
3590: l_err_loc := 3400;
3591: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_ctx_sqlstring_rec.bind_sequence);
3592: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_INVENTORY_ITEM_ID', gIDInventoryItemIdTbl);
3593: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_PO_LINE_ID', gIDPoLineIdTbl);
3594: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_NAME', gIDReqTemplateNameTbl);
3595: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_LINE_NUM', gIDReqTemplateLineNumTbl);
3596: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gIDOrgIdTbl);

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

3589: l_action_mode := 'INSERT_CTX_DTLS';
3590: l_err_loc := 3400;
3591: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_ctx_sqlstring_rec.bind_sequence);
3592: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_INVENTORY_ITEM_ID', gIDInventoryItemIdTbl);
3593: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_PO_LINE_ID', gIDPoLineIdTbl);
3594: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_NAME', gIDReqTemplateNameTbl);
3595: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_LINE_NUM', gIDReqTemplateLineNumTbl);
3596: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gIDOrgIdTbl);
3597: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gIDLanguageTbl);

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

3590: l_err_loc := 3400;
3591: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_ctx_sqlstring_rec.bind_sequence);
3592: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_INVENTORY_ITEM_ID', gIDInventoryItemIdTbl);
3593: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_PO_LINE_ID', gIDPoLineIdTbl);
3594: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_NAME', gIDReqTemplateNameTbl);
3595: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_LINE_NUM', gIDReqTemplateLineNumTbl);
3596: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gIDOrgIdTbl);
3597: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gIDLanguageTbl);
3598: l_err_loc := 3500;

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

3591: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_ctx_sqlstring_rec.bind_sequence);
3592: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_INVENTORY_ITEM_ID', gIDInventoryItemIdTbl);
3593: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_PO_LINE_ID', gIDPoLineIdTbl);
3594: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_NAME', gIDReqTemplateNameTbl);
3595: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_LINE_NUM', gIDReqTemplateLineNumTbl);
3596: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gIDOrgIdTbl);
3597: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gIDLanguageTbl);
3598: l_err_loc := 3500;
3599: l_status := DBMS_SQL.EXECUTE(l_csr_handle);

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

3592: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_INVENTORY_ITEM_ID', gIDInventoryItemIdTbl);
3593: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_PO_LINE_ID', gIDPoLineIdTbl);
3594: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_NAME', gIDReqTemplateNameTbl);
3595: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_LINE_NUM', gIDReqTemplateLineNumTbl);
3596: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gIDOrgIdTbl);
3597: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gIDLanguageTbl);
3598: l_err_loc := 3500;
3599: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
3600: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

3593: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_PO_LINE_ID', gIDPoLineIdTbl);
3594: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_NAME', gIDReqTemplateNameTbl);
3595: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_LINE_NUM', gIDReqTemplateLineNumTbl);
3596: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gIDOrgIdTbl);
3597: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gIDLanguageTbl);
3598: l_err_loc := 3500;
3599: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
3600: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3601: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

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

3595: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_LINE_NUM', gIDReqTemplateLineNumTbl);
3596: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gIDOrgIdTbl);
3597: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gIDLanguageTbl);
3598: l_err_loc := 3500;
3599: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
3600: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3601: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3602: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3603: 'regular Ctx SQLS details..' ||

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

3609: l_err_loc := 3600;
3610: IF (gDBLDInventoryItemIdTbl.COUNT > 0) THEN
3611: l_action_mode := 'DELETE_SPECIFIC_CTX_DTLS';
3612: l_err_loc := 3700;
3613: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_ctx_sqlstring_rec.bind_sequence);
3614: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_INVENTORY_ITEM_ID', gDBLDInventoryItemIdTbl);
3615: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_PO_LINE_ID', gDBLDPoLineIdTbl);
3616: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_NAME', gDBLDReqTemplateNameTbl);
3617: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_LINE_NUM', gDBLDReqTemplateLineNumTbl);

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

3610: IF (gDBLDInventoryItemIdTbl.COUNT > 0) THEN
3611: l_action_mode := 'DELETE_SPECIFIC_CTX_DTLS';
3612: l_err_loc := 3700;
3613: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_ctx_sqlstring_rec.bind_sequence);
3614: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_INVENTORY_ITEM_ID', gDBLDInventoryItemIdTbl);
3615: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_PO_LINE_ID', gDBLDPoLineIdTbl);
3616: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_NAME', gDBLDReqTemplateNameTbl);
3617: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_LINE_NUM', gDBLDReqTemplateLineNumTbl);
3618: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gDBLDOrgIdTbl);

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

3611: l_action_mode := 'DELETE_SPECIFIC_CTX_DTLS';
3612: l_err_loc := 3700;
3613: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_ctx_sqlstring_rec.bind_sequence);
3614: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_INVENTORY_ITEM_ID', gDBLDInventoryItemIdTbl);
3615: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_PO_LINE_ID', gDBLDPoLineIdTbl);
3616: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_NAME', gDBLDReqTemplateNameTbl);
3617: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_LINE_NUM', gDBLDReqTemplateLineNumTbl);
3618: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gDBLDOrgIdTbl);
3619: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gDBLDLanguageTbl);

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

3612: l_err_loc := 3700;
3613: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_ctx_sqlstring_rec.bind_sequence);
3614: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_INVENTORY_ITEM_ID', gDBLDInventoryItemIdTbl);
3615: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_PO_LINE_ID', gDBLDPoLineIdTbl);
3616: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_NAME', gDBLDReqTemplateNameTbl);
3617: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_LINE_NUM', gDBLDReqTemplateLineNumTbl);
3618: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gDBLDOrgIdTbl);
3619: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gDBLDLanguageTbl);
3620: l_err_loc := 3800;

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

3613: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_ctx_sqlstring_rec.bind_sequence);
3614: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_INVENTORY_ITEM_ID', gDBLDInventoryItemIdTbl);
3615: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_PO_LINE_ID', gDBLDPoLineIdTbl);
3616: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_NAME', gDBLDReqTemplateNameTbl);
3617: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_LINE_NUM', gDBLDReqTemplateLineNumTbl);
3618: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gDBLDOrgIdTbl);
3619: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gDBLDLanguageTbl);
3620: l_err_loc := 3800;
3621: l_status := DBMS_SQL.EXECUTE(l_csr_handle);

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

3614: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_INVENTORY_ITEM_ID', gDBLDInventoryItemIdTbl);
3615: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_PO_LINE_ID', gDBLDPoLineIdTbl);
3616: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_NAME', gDBLDReqTemplateNameTbl);
3617: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_LINE_NUM', gDBLDReqTemplateLineNumTbl);
3618: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gDBLDOrgIdTbl);
3619: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gDBLDLanguageTbl);
3620: l_err_loc := 3800;
3621: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
3622: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

3615: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_PO_LINE_ID', gDBLDPoLineIdTbl);
3616: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_NAME', gDBLDReqTemplateNameTbl);
3617: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_LINE_NUM', gDBLDReqTemplateLineNumTbl);
3618: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gDBLDOrgIdTbl);
3619: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gDBLDLanguageTbl);
3620: l_err_loc := 3800;
3621: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
3622: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3623: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

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

3617: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_REQ_TEMPLATE_LINE_NUM', gDBLDReqTemplateLineNumTbl);
3618: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gDBLDOrgIdTbl);
3619: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gDBLDLanguageTbl);
3620: l_err_loc := 3800;
3621: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
3622: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3623: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3624: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3625: 'regular Ctx SQLS details..' ||

Line 3632: DBMS_SQL.CLOSE_CURSOR(l_csr_handle);

3628: ', Num. of rows inserted into dtls:' || l_status);
3629: END IF;
3630: END IF;
3631: l_err_loc := 3900;
3632: DBMS_SQL.CLOSE_CURSOR(l_csr_handle);
3633: l_err_loc := 20000 + i;
3634: END LOOP;
3635: END IF; -- (p_current_cursor = ICX_CAT_UTIL_PVT.g_GBPACsr_const)
3636:

Line 3678: l_rowid_tbl DBMS_SQL.UROWID_TABLE;

3674: l_err_loc PLS_INTEGER;
3675: l_searchable NUMBER;
3676: l_section_tag NUMBER;
3677: l_continue BOOLEAN := TRUE;
3678: l_rowid_tbl DBMS_SQL.UROWID_TABLE;
3679: l_row_count PLS_INTEGER;
3680: BEGIN
3681: l_err_loc := 100;
3682: ICX_CAT_BUILD_CTX_SQL_PVT.checkIfAttributeIsSrchble

Line 3878: l_rowid_tbl DBMS_SQL.UROWID_TABLE;

3874: l_api_name CONSTANT VARCHAR2(30) := 'populateVendorMerge';
3875: l_err_loc PLS_INTEGER;
3876: l_to_vendor_name po_vendors.vendor_name%TYPE;
3877: l_continue BOOLEAN := TRUE;
3878: l_rowid_tbl DBMS_SQL.UROWID_TABLE;
3879: l_rows_updated BOOLEAN := TRUE;
3880: l_metadataTblFormed BOOLEAN := FALSE;
3881: l_special_metadata_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_metadata_tbl_type;
3882: l_regular_nontl_metadata_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_metadata_tbl_type;

Line 3919: l_csr_handle := DBMS_SQL.OPEN_CURSOR;

3915:
3916: l_err_loc := 600;
3917: -- open the cursor for the dynamic sql to insert the
3918: -- row with sequence 1 in icx_cat_items_ctx_dtls_tlp only once
3919: l_csr_handle := DBMS_SQL.OPEN_CURSOR;
3920:
3921: l_err_loc := 700;
3922: WHILE l_continue LOOP
3923: l_err_loc := 800;

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

4003: l_ctx_sqlstring_rec := l_special_ctx_sql_tbl(1);
4004:
4005: -- parse the cursor only once
4006: l_err_loc := 1800;
4007: DBMS_SQL.PARSE(l_csr_handle, l_ctx_sqlstring_rec.ctx_sql_string, DBMS_SQL.NATIVE);
4008: END IF;
4009:
4010: l_err_loc := 1900;
4011:

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

4009:
4010: l_err_loc := 1900;
4011:
4012: -- insert the mandatory row in icx_cat_items_ctx_dtls_tlp i.e. the row with sequence = 1
4013: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_ctx_sqlstring_rec.bind_sequence);
4014: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_rowid', l_rowid_tbl);
4015: l_err_loc := 2000;
4016: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
4017: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

4010: l_err_loc := 1900;
4011:
4012: -- insert the mandatory row in icx_cat_items_ctx_dtls_tlp i.e. the row with sequence = 1
4013: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_ctx_sqlstring_rec.bind_sequence);
4014: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_rowid', l_rowid_tbl);
4015: l_err_loc := 2000;
4016: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
4017: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4018: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

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

4012: -- insert the mandatory row in icx_cat_items_ctx_dtls_tlp i.e. the row with sequence = 1
4013: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_ctx_sqlstring_rec.bind_sequence);
4014: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_rowid', l_rowid_tbl);
4015: l_err_loc := 2000;
4016: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
4017: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4018: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4019: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4020: 'Num. of rows inserted into dtls for seq=1:' || l_status);

Line 4099: DBMS_SQL.CLOSE_CURSOR(l_csr_handle);

4095: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
4096: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4097: 'the dynamic sql is closed');
4098: END IF;
4099: DBMS_SQL.CLOSE_CURSOR(l_csr_handle);
4100:
4101: l_err_loc := 2900;
4102: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
4103: l_err_loc := 3000;

Line 4187: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;

4183: PROCEDURE purgeInvalidCategoryItems
4184: IS
4185:
4186: ----- Start of declaring columns fetched from the cursor-----
4187: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
4188: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
4189: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
4190: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
4191: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 4188: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;

4184: IS
4185:
4186: ----- Start of declaring columns fetched from the cursor-----
4187: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
4188: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
4189: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
4190: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
4191: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
4192: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 4189: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;

4185:
4186: ----- Start of declaring columns fetched from the cursor-----
4187: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
4188: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
4189: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
4190: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
4191: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
4192: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
4193: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 4190: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;

4186: ----- Start of declaring columns fetched from the cursor-----
4187: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
4188: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
4189: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
4190: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
4191: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
4192: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
4193: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
4194: ------ End of declaring columns fetched from the cursor ------

Line 4191: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;

4187: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
4188: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
4189: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
4190: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
4191: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
4192: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
4193: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
4194: ------ End of declaring columns fetched from the cursor ------
4195:

Line 4192: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;

4188: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
4189: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
4190: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
4191: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
4192: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
4193: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
4194: ------ End of declaring columns fetched from the cursor ------
4195:
4196: l_api_name CONSTANT VARCHAR2(30) := 'purgeInvalidCategoryItems';

Line 4193: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;

4189: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
4190: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
4191: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
4192: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
4193: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
4194: ------ End of declaring columns fetched from the cursor ------
4195:
4196: l_api_name CONSTANT VARCHAR2(30) := 'purgeInvalidCategoryItems';
4197: l_continue BOOLEAN := TRUE;

Line 4360: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;

4356: PROCEDURE purgeInvalidReqTmpltLines
4357: IS
4358:
4359: ----- Start of declaring columns returned from the delete -----
4360: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
4361: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
4362: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
4363: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
4364: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 4361: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;

4357: IS
4358:
4359: ----- Start of declaring columns returned from the delete -----
4360: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
4361: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
4362: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
4363: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
4364: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
4365: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 4362: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;

4358:
4359: ----- Start of declaring columns returned from the delete -----
4360: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
4361: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
4362: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
4363: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
4364: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
4365: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
4366: ------ End of declaring columns returned from the delete ------

Line 4363: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;

4359: ----- Start of declaring columns returned from the delete -----
4360: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
4361: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
4362: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
4363: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
4364: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
4365: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
4366: ------ End of declaring columns returned from the delete ------
4367:

Line 4364: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;

4360: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
4361: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
4362: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
4363: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
4364: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
4365: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
4366: ------ End of declaring columns returned from the delete ------
4367:
4368: l_api_name CONSTANT VARCHAR2(30) := 'purgeInvalidReqTmpltLines';

Line 4365: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;

4361: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
4362: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
4363: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
4364: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
4365: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
4366: ------ End of declaring columns returned from the delete ------
4367:
4368: l_api_name CONSTANT VARCHAR2(30) := 'purgeInvalidReqTmpltLines';
4369: l_continue BOOLEAN := TRUE;

Line 4508: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;

4504: PROCEDURE purgeInvalidQuoteLines
4505: IS
4506:
4507: ----- Start of declaring columns returned from the delete -----
4508: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
4509: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
4510: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
4511: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
4512: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 4509: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;

4505: IS
4506:
4507: ----- Start of declaring columns returned from the delete -----
4508: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
4509: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
4510: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
4511: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
4512: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
4513: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 4510: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;

4506:
4507: ----- Start of declaring columns returned from the delete -----
4508: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
4509: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
4510: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
4511: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
4512: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
4513: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
4514: ------ End of declaring columns returned from the delete ------

Line 4511: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;

4507: ----- Start of declaring columns returned from the delete -----
4508: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
4509: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
4510: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
4511: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
4512: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
4513: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
4514: ------ End of declaring columns returned from the delete ------
4515:

Line 4512: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;

4508: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
4509: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
4510: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
4511: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
4512: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
4513: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
4514: ------ End of declaring columns returned from the delete ------
4515:
4516: l_api_name CONSTANT VARCHAR2(30) := 'purgeInvalidQuoteLines';

Line 4513: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;

4509: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
4510: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
4511: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
4512: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
4513: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
4514: ------ End of declaring columns returned from the delete ------
4515:
4516: l_api_name CONSTANT VARCHAR2(30) := 'purgeInvalidQuoteLines';
4517: l_continue BOOLEAN := TRUE;

Line 4640: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;

4636: PROCEDURE purgeInvalidBlanketLines
4637: IS
4638:
4639: ----- Start of declaring columns returned from the delete -----
4640: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
4641: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
4642: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
4643: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
4644: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 4641: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;

4637: IS
4638:
4639: ----- Start of declaring columns returned from the delete -----
4640: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
4641: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
4642: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
4643: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
4644: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
4645: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 4642: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;

4638:
4639: ----- Start of declaring columns returned from the delete -----
4640: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
4641: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
4642: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
4643: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
4644: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
4645: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
4646: ------ End of declaring columns returned from the delete ------

Line 4643: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;

4639: ----- Start of declaring columns returned from the delete -----
4640: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
4641: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
4642: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
4643: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
4644: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
4645: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
4646: ------ End of declaring columns returned from the delete ------
4647:

Line 4644: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;

4640: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
4641: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
4642: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
4643: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
4644: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
4645: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
4646: ------ End of declaring columns returned from the delete ------
4647:
4648: l_api_name CONSTANT VARCHAR2(30) := 'purgeInvalidBlanketLines';

Line 4645: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;

4641: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
4642: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
4643: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
4644: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
4645: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
4646: ------ End of declaring columns returned from the delete ------
4647:
4648: l_api_name CONSTANT VARCHAR2(30) := 'purgeInvalidBlanketLines';
4649: l_continue BOOLEAN := TRUE;