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_FPI_UPGRADE dependencies on DBMS_SQL

Line 45: gIRtItemIds DBMS_SQL.NUMBER_TABLE;

41: -- Global PL/SQL Tables --
42: --------------------------------------------------------------
43: -- Global PL/SQL tables for ICX_CAT_ITEMS_B, ICX_CAT_ITEMS_TLP,
44: -- ICX_CAT_EXT_ITEMS_TLP, ICX_CAT_CATEGORY_ITEMS
45: gIRtItemIds DBMS_SQL.NUMBER_TABLE;
46: gIOldRtItemIds DBMS_SQL.NUMBER_TABLE;
47: gIOrgIds DBMS_SQL.NUMBER_TABLE;
48: gISupplierPartNums DBMS_SQL.VARCHAR2_TABLE;
49: gIRtCategoryIds DBMS_SQL.NUMBER_TABLE;

Line 46: gIOldRtItemIds DBMS_SQL.NUMBER_TABLE;

42: --------------------------------------------------------------
43: -- Global PL/SQL tables for ICX_CAT_ITEMS_B, ICX_CAT_ITEMS_TLP,
44: -- ICX_CAT_EXT_ITEMS_TLP, ICX_CAT_CATEGORY_ITEMS
45: gIRtItemIds DBMS_SQL.NUMBER_TABLE;
46: gIOldRtItemIds DBMS_SQL.NUMBER_TABLE;
47: gIOrgIds DBMS_SQL.NUMBER_TABLE;
48: gISupplierPartNums DBMS_SQL.VARCHAR2_TABLE;
49: gIRtCategoryIds DBMS_SQL.NUMBER_TABLE;
50: gIExtractorUpdatedFlags DBMS_SQL.VARCHAR2_TABLE;

Line 47: gIOrgIds DBMS_SQL.NUMBER_TABLE;

43: -- Global PL/SQL tables for ICX_CAT_ITEMS_B, ICX_CAT_ITEMS_TLP,
44: -- ICX_CAT_EXT_ITEMS_TLP, ICX_CAT_CATEGORY_ITEMS
45: gIRtItemIds DBMS_SQL.NUMBER_TABLE;
46: gIOldRtItemIds DBMS_SQL.NUMBER_TABLE;
47: gIOrgIds DBMS_SQL.NUMBER_TABLE;
48: gISupplierPartNums DBMS_SQL.VARCHAR2_TABLE;
49: gIRtCategoryIds DBMS_SQL.NUMBER_TABLE;
50: gIExtractorUpdatedFlags DBMS_SQL.VARCHAR2_TABLE;
51:

Line 48: gISupplierPartNums DBMS_SQL.VARCHAR2_TABLE;

44: -- ICX_CAT_EXT_ITEMS_TLP, ICX_CAT_CATEGORY_ITEMS
45: gIRtItemIds DBMS_SQL.NUMBER_TABLE;
46: gIOldRtItemIds DBMS_SQL.NUMBER_TABLE;
47: gIOrgIds DBMS_SQL.NUMBER_TABLE;
48: gISupplierPartNums DBMS_SQL.VARCHAR2_TABLE;
49: gIRtCategoryIds DBMS_SQL.NUMBER_TABLE;
50: gIExtractorUpdatedFlags DBMS_SQL.VARCHAR2_TABLE;
51:
52: -- Global PL/SQL tables for description of ICX_CAT_ITEMS_TLP,

Line 49: gIRtCategoryIds DBMS_SQL.NUMBER_TABLE;

45: gIRtItemIds DBMS_SQL.NUMBER_TABLE;
46: gIOldRtItemIds DBMS_SQL.NUMBER_TABLE;
47: gIOrgIds DBMS_SQL.NUMBER_TABLE;
48: gISupplierPartNums DBMS_SQL.VARCHAR2_TABLE;
49: gIRtCategoryIds DBMS_SQL.NUMBER_TABLE;
50: gIExtractorUpdatedFlags DBMS_SQL.VARCHAR2_TABLE;
51:
52: -- Global PL/SQL tables for description of ICX_CAT_ITEMS_TLP,
53: gITRtItemIds DBMS_SQL.NUMBER_TABLE;

Line 50: gIExtractorUpdatedFlags DBMS_SQL.VARCHAR2_TABLE;

46: gIOldRtItemIds DBMS_SQL.NUMBER_TABLE;
47: gIOrgIds DBMS_SQL.NUMBER_TABLE;
48: gISupplierPartNums DBMS_SQL.VARCHAR2_TABLE;
49: gIRtCategoryIds DBMS_SQL.NUMBER_TABLE;
50: gIExtractorUpdatedFlags DBMS_SQL.VARCHAR2_TABLE;
51:
52: -- Global PL/SQL tables for description of ICX_CAT_ITEMS_TLP,
53: gITRtItemIds DBMS_SQL.NUMBER_TABLE;
54: gITItemDescriptions DBMS_SQL.VARCHAR2_TABLE;

Line 53: gITRtItemIds DBMS_SQL.NUMBER_TABLE;

49: gIRtCategoryIds DBMS_SQL.NUMBER_TABLE;
50: gIExtractorUpdatedFlags DBMS_SQL.VARCHAR2_TABLE;
51:
52: -- Global PL/SQL tables for description of ICX_CAT_ITEMS_TLP,
53: gITRtItemIds DBMS_SQL.NUMBER_TABLE;
54: gITItemDescriptions DBMS_SQL.VARCHAR2_TABLE;
55:
56: -- Global PL/SQL tables for template headers of ICX_CAT_CATEGORY_ITEMS
57: gCIRtItemIds DBMS_SQL.NUMBER_TABLE;

Line 54: gITItemDescriptions DBMS_SQL.VARCHAR2_TABLE;

50: gIExtractorUpdatedFlags DBMS_SQL.VARCHAR2_TABLE;
51:
52: -- Global PL/SQL tables for description of ICX_CAT_ITEMS_TLP,
53: gITRtItemIds DBMS_SQL.NUMBER_TABLE;
54: gITItemDescriptions DBMS_SQL.VARCHAR2_TABLE;
55:
56: -- Global PL/SQL tables for template headers of ICX_CAT_CATEGORY_ITEMS
57: gCIRtItemIds DBMS_SQL.NUMBER_TABLE;
58: gCITemplateIds DBMS_SQL.VARCHAR2_TABLE;

Line 57: gCIRtItemIds DBMS_SQL.NUMBER_TABLE;

53: gITRtItemIds DBMS_SQL.NUMBER_TABLE;
54: gITItemDescriptions DBMS_SQL.VARCHAR2_TABLE;
55:
56: -- Global PL/SQL tables for template headers of ICX_CAT_CATEGORY_ITEMS
57: gCIRtItemIds DBMS_SQL.NUMBER_TABLE;
58: gCITemplateIds DBMS_SQL.VARCHAR2_TABLE;
59:
60: -- Global PL/SQL tables for ICX_CAT_ITEM_PRICES
61: -- Extracted price records

Line 58: gCITemplateIds DBMS_SQL.VARCHAR2_TABLE;

54: gITItemDescriptions DBMS_SQL.VARCHAR2_TABLE;
55:
56: -- Global PL/SQL tables for template headers of ICX_CAT_CATEGORY_ITEMS
57: gCIRtItemIds DBMS_SQL.NUMBER_TABLE;
58: gCITemplateIds DBMS_SQL.VARCHAR2_TABLE;
59:
60: -- Global PL/SQL tables for ICX_CAT_ITEM_PRICES
61: -- Extracted price records
62: gEPRtItemIds DBMS_SQL.NUMBER_TABLE;

Line 62: gEPRtItemIds DBMS_SQL.NUMBER_TABLE;

58: gCITemplateIds DBMS_SQL.VARCHAR2_TABLE;
59:
60: -- Global PL/SQL tables for ICX_CAT_ITEM_PRICES
61: -- Extracted price records
62: gEPRtItemIds DBMS_SQL.NUMBER_TABLE;
63: gEPActiveFlags DBMS_SQL.VARCHAR2_TABLE;
64: gEPOrgIds DBMS_SQL.NUMBER_TABLE;
65: gEPPriceTypes DBMS_SQL.VARCHAR2_TABLE;
66: gEPRowIds DBMS_SQL.UROWID_TABLE;

Line 63: gEPActiveFlags DBMS_SQL.VARCHAR2_TABLE;

59:
60: -- Global PL/SQL tables for ICX_CAT_ITEM_PRICES
61: -- Extracted price records
62: gEPRtItemIds DBMS_SQL.NUMBER_TABLE;
63: gEPActiveFlags DBMS_SQL.VARCHAR2_TABLE;
64: gEPOrgIds DBMS_SQL.NUMBER_TABLE;
65: gEPPriceTypes DBMS_SQL.VARCHAR2_TABLE;
66: gEPRowIds DBMS_SQL.UROWID_TABLE;
67: gEPRateTypes DBMS_SQL.VARCHAR2_TABLE;

Line 64: gEPOrgIds DBMS_SQL.NUMBER_TABLE;

60: -- Global PL/SQL tables for ICX_CAT_ITEM_PRICES
61: -- Extracted price records
62: gEPRtItemIds DBMS_SQL.NUMBER_TABLE;
63: gEPActiveFlags DBMS_SQL.VARCHAR2_TABLE;
64: gEPOrgIds DBMS_SQL.NUMBER_TABLE;
65: gEPPriceTypes DBMS_SQL.VARCHAR2_TABLE;
66: gEPRowIds DBMS_SQL.UROWID_TABLE;
67: gEPRateTypes DBMS_SQL.VARCHAR2_TABLE;
68: gEPRateDates DBMS_SQL.DATE_TABLE;

Line 65: gEPPriceTypes DBMS_SQL.VARCHAR2_TABLE;

61: -- Extracted price records
62: gEPRtItemIds DBMS_SQL.NUMBER_TABLE;
63: gEPActiveFlags DBMS_SQL.VARCHAR2_TABLE;
64: gEPOrgIds DBMS_SQL.NUMBER_TABLE;
65: gEPPriceTypes DBMS_SQL.VARCHAR2_TABLE;
66: gEPRowIds DBMS_SQL.UROWID_TABLE;
67: gEPRateTypes DBMS_SQL.VARCHAR2_TABLE;
68: gEPRateDates DBMS_SQL.DATE_TABLE;
69: gEPRates DBMS_SQL.NUMBER_TABLE;

Line 66: gEPRowIds DBMS_SQL.UROWID_TABLE;

62: gEPRtItemIds DBMS_SQL.NUMBER_TABLE;
63: gEPActiveFlags DBMS_SQL.VARCHAR2_TABLE;
64: gEPOrgIds DBMS_SQL.NUMBER_TABLE;
65: gEPPriceTypes DBMS_SQL.VARCHAR2_TABLE;
66: gEPRowIds DBMS_SQL.UROWID_TABLE;
67: gEPRateTypes DBMS_SQL.VARCHAR2_TABLE;
68: gEPRateDates DBMS_SQL.DATE_TABLE;
69: gEPRates DBMS_SQL.NUMBER_TABLE;
70: gEPSupplierNumbers DBMS_SQL.VARCHAR2_TABLE;

Line 67: gEPRateTypes DBMS_SQL.VARCHAR2_TABLE;

63: gEPActiveFlags DBMS_SQL.VARCHAR2_TABLE;
64: gEPOrgIds DBMS_SQL.NUMBER_TABLE;
65: gEPPriceTypes DBMS_SQL.VARCHAR2_TABLE;
66: gEPRowIds DBMS_SQL.UROWID_TABLE;
67: gEPRateTypes DBMS_SQL.VARCHAR2_TABLE;
68: gEPRateDates DBMS_SQL.DATE_TABLE;
69: gEPRates DBMS_SQL.NUMBER_TABLE;
70: gEPSupplierNumbers DBMS_SQL.VARCHAR2_TABLE;
71: gEPSupplierContactIds DBMS_SQL.NUMBER_TABLE;

Line 68: gEPRateDates DBMS_SQL.DATE_TABLE;

64: gEPOrgIds DBMS_SQL.NUMBER_TABLE;
65: gEPPriceTypes DBMS_SQL.VARCHAR2_TABLE;
66: gEPRowIds DBMS_SQL.UROWID_TABLE;
67: gEPRateTypes DBMS_SQL.VARCHAR2_TABLE;
68: gEPRateDates DBMS_SQL.DATE_TABLE;
69: gEPRates DBMS_SQL.NUMBER_TABLE;
70: gEPSupplierNumbers DBMS_SQL.VARCHAR2_TABLE;
71: gEPSupplierContactIds DBMS_SQL.NUMBER_TABLE;
72: gEPItemRevisions DBMS_SQL.VARCHAR2_TABLE;

Line 69: gEPRates DBMS_SQL.NUMBER_TABLE;

65: gEPPriceTypes DBMS_SQL.VARCHAR2_TABLE;
66: gEPRowIds DBMS_SQL.UROWID_TABLE;
67: gEPRateTypes DBMS_SQL.VARCHAR2_TABLE;
68: gEPRateDates DBMS_SQL.DATE_TABLE;
69: gEPRates DBMS_SQL.NUMBER_TABLE;
70: gEPSupplierNumbers DBMS_SQL.VARCHAR2_TABLE;
71: gEPSupplierContactIds DBMS_SQL.NUMBER_TABLE;
72: gEPItemRevisions DBMS_SQL.VARCHAR2_TABLE;
73: gEPLineTypeIds DBMS_SQL.NUMBER_TABLE;

Line 70: gEPSupplierNumbers DBMS_SQL.VARCHAR2_TABLE;

66: gEPRowIds DBMS_SQL.UROWID_TABLE;
67: gEPRateTypes DBMS_SQL.VARCHAR2_TABLE;
68: gEPRateDates DBMS_SQL.DATE_TABLE;
69: gEPRates DBMS_SQL.NUMBER_TABLE;
70: gEPSupplierNumbers DBMS_SQL.VARCHAR2_TABLE;
71: gEPSupplierContactIds DBMS_SQL.NUMBER_TABLE;
72: gEPItemRevisions DBMS_SQL.VARCHAR2_TABLE;
73: gEPLineTypeIds DBMS_SQL.NUMBER_TABLE;
74: gEPBuyerIds DBMS_SQL.NUMBER_TABLE;

Line 71: gEPSupplierContactIds DBMS_SQL.NUMBER_TABLE;

67: gEPRateTypes DBMS_SQL.VARCHAR2_TABLE;
68: gEPRateDates DBMS_SQL.DATE_TABLE;
69: gEPRates DBMS_SQL.NUMBER_TABLE;
70: gEPSupplierNumbers DBMS_SQL.VARCHAR2_TABLE;
71: gEPSupplierContactIds DBMS_SQL.NUMBER_TABLE;
72: gEPItemRevisions DBMS_SQL.VARCHAR2_TABLE;
73: gEPLineTypeIds DBMS_SQL.NUMBER_TABLE;
74: gEPBuyerIds DBMS_SQL.NUMBER_TABLE;
75:

Line 72: gEPItemRevisions DBMS_SQL.VARCHAR2_TABLE;

68: gEPRateDates DBMS_SQL.DATE_TABLE;
69: gEPRates DBMS_SQL.NUMBER_TABLE;
70: gEPSupplierNumbers DBMS_SQL.VARCHAR2_TABLE;
71: gEPSupplierContactIds DBMS_SQL.NUMBER_TABLE;
72: gEPItemRevisions DBMS_SQL.VARCHAR2_TABLE;
73: gEPLineTypeIds DBMS_SQL.NUMBER_TABLE;
74: gEPBuyerIds DBMS_SQL.NUMBER_TABLE;
75:
76: -- Bulkloaded price records

Line 73: gEPLineTypeIds DBMS_SQL.NUMBER_TABLE;

69: gEPRates DBMS_SQL.NUMBER_TABLE;
70: gEPSupplierNumbers DBMS_SQL.VARCHAR2_TABLE;
71: gEPSupplierContactIds DBMS_SQL.NUMBER_TABLE;
72: gEPItemRevisions DBMS_SQL.VARCHAR2_TABLE;
73: gEPLineTypeIds DBMS_SQL.NUMBER_TABLE;
74: gEPBuyerIds DBMS_SQL.NUMBER_TABLE;
75:
76: -- Bulkloaded price records
77: gBPRtItemIds DBMS_SQL.NUMBER_TABLE;

Line 74: gEPBuyerIds DBMS_SQL.NUMBER_TABLE;

70: gEPSupplierNumbers DBMS_SQL.VARCHAR2_TABLE;
71: gEPSupplierContactIds DBMS_SQL.NUMBER_TABLE;
72: gEPItemRevisions DBMS_SQL.VARCHAR2_TABLE;
73: gEPLineTypeIds DBMS_SQL.NUMBER_TABLE;
74: gEPBuyerIds DBMS_SQL.NUMBER_TABLE;
75:
76: -- Bulkloaded price records
77: gBPRtItemIds DBMS_SQL.NUMBER_TABLE;
78: gBRActiveFlgs DBMS_SQL.VARCHAR2_TABLE;

Line 77: gBPRtItemIds DBMS_SQL.NUMBER_TABLE;

73: gEPLineTypeIds DBMS_SQL.NUMBER_TABLE;
74: gEPBuyerIds DBMS_SQL.NUMBER_TABLE;
75:
76: -- Bulkloaded price records
77: gBPRtItemIds DBMS_SQL.NUMBER_TABLE;
78: gBRActiveFlgs DBMS_SQL.VARCHAR2_TABLE;
79: gBPOrgIds DBMS_SQL.NUMBER_TABLE;
80: gBPSupplierSiteIds DBMS_SQL.NUMBER_TABLE;
81: gBPPriceTypes DBMS_SQL.VARCHAR2_TABLE;

Line 78: gBRActiveFlgs DBMS_SQL.VARCHAR2_TABLE;

74: gEPBuyerIds DBMS_SQL.NUMBER_TABLE;
75:
76: -- Bulkloaded price records
77: gBPRtItemIds DBMS_SQL.NUMBER_TABLE;
78: gBRActiveFlgs DBMS_SQL.VARCHAR2_TABLE;
79: gBPOrgIds DBMS_SQL.NUMBER_TABLE;
80: gBPSupplierSiteIds DBMS_SQL.NUMBER_TABLE;
81: gBPPriceTypes DBMS_SQL.VARCHAR2_TABLE;
82: gBPRowIds DBMS_SQL.UROWID_TABLE;

Line 79: gBPOrgIds DBMS_SQL.NUMBER_TABLE;

75:
76: -- Bulkloaded price records
77: gBPRtItemIds DBMS_SQL.NUMBER_TABLE;
78: gBRActiveFlgs DBMS_SQL.VARCHAR2_TABLE;
79: gBPOrgIds DBMS_SQL.NUMBER_TABLE;
80: gBPSupplierSiteIds DBMS_SQL.NUMBER_TABLE;
81: gBPPriceTypes DBMS_SQL.VARCHAR2_TABLE;
82: gBPRowIds DBMS_SQL.UROWID_TABLE;
83:

Line 80: gBPSupplierSiteIds DBMS_SQL.NUMBER_TABLE;

76: -- Bulkloaded price records
77: gBPRtItemIds DBMS_SQL.NUMBER_TABLE;
78: gBRActiveFlgs DBMS_SQL.VARCHAR2_TABLE;
79: gBPOrgIds DBMS_SQL.NUMBER_TABLE;
80: gBPSupplierSiteIds DBMS_SQL.NUMBER_TABLE;
81: gBPPriceTypes DBMS_SQL.VARCHAR2_TABLE;
82: gBPRowIds DBMS_SQL.UROWID_TABLE;
83:
84: -- POR_FAVORITE_LIST_LINES

Line 81: gBPPriceTypes DBMS_SQL.VARCHAR2_TABLE;

77: gBPRtItemIds DBMS_SQL.NUMBER_TABLE;
78: gBRActiveFlgs DBMS_SQL.VARCHAR2_TABLE;
79: gBPOrgIds DBMS_SQL.NUMBER_TABLE;
80: gBPSupplierSiteIds DBMS_SQL.NUMBER_TABLE;
81: gBPPriceTypes DBMS_SQL.VARCHAR2_TABLE;
82: gBPRowIds DBMS_SQL.UROWID_TABLE;
83:
84: -- POR_FAVORITE_LIST_LINES
85: gUpFavRowIds DBMS_SQL.UROWID_TABLE;

Line 82: gBPRowIds DBMS_SQL.UROWID_TABLE;

78: gBRActiveFlgs DBMS_SQL.VARCHAR2_TABLE;
79: gBPOrgIds DBMS_SQL.NUMBER_TABLE;
80: gBPSupplierSiteIds DBMS_SQL.NUMBER_TABLE;
81: gBPPriceTypes DBMS_SQL.VARCHAR2_TABLE;
82: gBPRowIds DBMS_SQL.UROWID_TABLE;
83:
84: -- POR_FAVORITE_LIST_LINES
85: gUpFavRowIds DBMS_SQL.UROWID_TABLE;
86: gUpFavRtItemIds DBMS_SQL.NUMBER_TABLE;

Line 85: gUpFavRowIds DBMS_SQL.UROWID_TABLE;

81: gBPPriceTypes DBMS_SQL.VARCHAR2_TABLE;
82: gBPRowIds DBMS_SQL.UROWID_TABLE;
83:
84: -- POR_FAVORITE_LIST_LINES
85: gUpFavRowIds DBMS_SQL.UROWID_TABLE;
86: gUpFavRtItemIds DBMS_SQL.NUMBER_TABLE;
87: gInFavRowIds DBMS_SQL.UROWID_TABLE;
88: gInFavRtItemIds DBMS_SQL.NUMBER_TABLE;
89:

Line 86: gUpFavRtItemIds DBMS_SQL.NUMBER_TABLE;

82: gBPRowIds DBMS_SQL.UROWID_TABLE;
83:
84: -- POR_FAVORITE_LIST_LINES
85: gUpFavRowIds DBMS_SQL.UROWID_TABLE;
86: gUpFavRtItemIds DBMS_SQL.NUMBER_TABLE;
87: gInFavRowIds DBMS_SQL.UROWID_TABLE;
88: gInFavRtItemIds DBMS_SQL.NUMBER_TABLE;
89:
90: --------------------------------------------------------------

Line 87: gInFavRowIds DBMS_SQL.UROWID_TABLE;

83:
84: -- POR_FAVORITE_LIST_LINES
85: gUpFavRowIds DBMS_SQL.UROWID_TABLE;
86: gUpFavRtItemIds DBMS_SQL.NUMBER_TABLE;
87: gInFavRowIds DBMS_SQL.UROWID_TABLE;
88: gInFavRtItemIds DBMS_SQL.NUMBER_TABLE;
89:
90: --------------------------------------------------------------
91: -- Procedures --

Line 88: gInFavRtItemIds DBMS_SQL.NUMBER_TABLE;

84: -- POR_FAVORITE_LIST_LINES
85: gUpFavRowIds DBMS_SQL.UROWID_TABLE;
86: gUpFavRtItemIds DBMS_SQL.NUMBER_TABLE;
87: gInFavRowIds DBMS_SQL.UROWID_TABLE;
88: gInFavRtItemIds DBMS_SQL.NUMBER_TABLE;
89:
90: --------------------------------------------------------------
91: -- Procedures --
92: --------------------------------------------------------------

Line 378: xRtDescriptorIds DBMS_SQL.NUMBER_TABLE;

374: AND language = (SELECT language_code
375: FROM fnd_languages
376: WHERE installed_flag = 'B');
377:
378: xRtDescriptorIds DBMS_SQL.NUMBER_TABLE;
379: xKeys DBMS_SQL.VARCHAR2_TABLE;
380: xTypes DBMS_SQL.NUMBER_TABLE;
381: xStoredInTables DBMS_SQL.VARCHAR2_TABLE;
382: xStoredInColumns DBMS_SQL.VARCHAR2_TABLE;

Line 379: xKeys DBMS_SQL.VARCHAR2_TABLE;

375: FROM fnd_languages
376: WHERE installed_flag = 'B');
377:
378: xRtDescriptorIds DBMS_SQL.NUMBER_TABLE;
379: xKeys DBMS_SQL.VARCHAR2_TABLE;
380: xTypes DBMS_SQL.NUMBER_TABLE;
381: xStoredInTables DBMS_SQL.VARCHAR2_TABLE;
382: xStoredInColumns DBMS_SQL.VARCHAR2_TABLE;
383:

Line 380: xTypes DBMS_SQL.NUMBER_TABLE;

376: WHERE installed_flag = 'B');
377:
378: xRtDescriptorIds DBMS_SQL.NUMBER_TABLE;
379: xKeys DBMS_SQL.VARCHAR2_TABLE;
380: xTypes DBMS_SQL.NUMBER_TABLE;
381: xStoredInTables DBMS_SQL.VARCHAR2_TABLE;
382: xStoredInColumns DBMS_SQL.VARCHAR2_TABLE;
383:
384: xUpdateColumns VARCHAR2(2000) := NULL;

Line 381: xStoredInTables DBMS_SQL.VARCHAR2_TABLE;

377:
378: xRtDescriptorIds DBMS_SQL.NUMBER_TABLE;
379: xKeys DBMS_SQL.VARCHAR2_TABLE;
380: xTypes DBMS_SQL.NUMBER_TABLE;
381: xStoredInTables DBMS_SQL.VARCHAR2_TABLE;
382: xStoredInColumns DBMS_SQL.VARCHAR2_TABLE;
383:
384: xUpdateColumns VARCHAR2(2000) := NULL;
385: xSelectColumns VARCHAR2(2000) := NULL;

Line 382: xStoredInColumns DBMS_SQL.VARCHAR2_TABLE;

378: xRtDescriptorIds DBMS_SQL.NUMBER_TABLE;
379: xKeys DBMS_SQL.VARCHAR2_TABLE;
380: xTypes DBMS_SQL.NUMBER_TABLE;
381: xStoredInTables DBMS_SQL.VARCHAR2_TABLE;
382: xStoredInColumns DBMS_SQL.VARCHAR2_TABLE;
383:
384: xUpdateColumns VARCHAR2(2000) := NULL;
385: xSelectColumns VARCHAR2(2000) := NULL;
386:

Line 808: xOrgIds DBMS_SQL.NUMBER_TABLE;

804: ORDER BY 1, 2, 3, 5 DESC, 6 DESC;
805: -- org_id, supplier_id, supplier_part_num,
806: -- type, last_update_date;
807:
808: xOrgIds DBMS_SQL.NUMBER_TABLE;
809: xSupplierIds DBMS_SQL.NUMBER_TABLE;
810: xSupplierPartNums DBMS_SQL.VARCHAR2_TABLE;
811: xSupplierSiteIds DBMS_SQL.NUMBER_TABLE;
812: xTypes DBMS_SQL.NUMBER_TABLE;

Line 809: xSupplierIds DBMS_SQL.NUMBER_TABLE;

805: -- org_id, supplier_id, supplier_part_num,
806: -- type, last_update_date;
807:
808: xOrgIds DBMS_SQL.NUMBER_TABLE;
809: xSupplierIds DBMS_SQL.NUMBER_TABLE;
810: xSupplierPartNums DBMS_SQL.VARCHAR2_TABLE;
811: xSupplierSiteIds DBMS_SQL.NUMBER_TABLE;
812: xTypes DBMS_SQL.NUMBER_TABLE;
813: xLastUpdateDates DBMS_SQL.DATE_TABLE;

Line 810: xSupplierPartNums DBMS_SQL.VARCHAR2_TABLE;

806: -- type, last_update_date;
807:
808: xOrgIds DBMS_SQL.NUMBER_TABLE;
809: xSupplierIds DBMS_SQL.NUMBER_TABLE;
810: xSupplierPartNums DBMS_SQL.VARCHAR2_TABLE;
811: xSupplierSiteIds DBMS_SQL.NUMBER_TABLE;
812: xTypes DBMS_SQL.NUMBER_TABLE;
813: xLastUpdateDates DBMS_SQL.DATE_TABLE;
814: xPriceTypes DBMS_SQL.VARCHAR2_TABLE;

Line 811: xSupplierSiteIds DBMS_SQL.NUMBER_TABLE;

807:
808: xOrgIds DBMS_SQL.NUMBER_TABLE;
809: xSupplierIds DBMS_SQL.NUMBER_TABLE;
810: xSupplierPartNums DBMS_SQL.VARCHAR2_TABLE;
811: xSupplierSiteIds DBMS_SQL.NUMBER_TABLE;
812: xTypes DBMS_SQL.NUMBER_TABLE;
813: xLastUpdateDates DBMS_SQL.DATE_TABLE;
814: xPriceTypes DBMS_SQL.VARCHAR2_TABLE;
815: xItemDescriptions DBMS_SQL.VARCHAR2_TABLE;

Line 812: xTypes DBMS_SQL.NUMBER_TABLE;

808: xOrgIds DBMS_SQL.NUMBER_TABLE;
809: xSupplierIds DBMS_SQL.NUMBER_TABLE;
810: xSupplierPartNums DBMS_SQL.VARCHAR2_TABLE;
811: xSupplierSiteIds DBMS_SQL.NUMBER_TABLE;
812: xTypes DBMS_SQL.NUMBER_TABLE;
813: xLastUpdateDates DBMS_SQL.DATE_TABLE;
814: xPriceTypes DBMS_SQL.VARCHAR2_TABLE;
815: xItemDescriptions DBMS_SQL.VARCHAR2_TABLE;
816: xTemplateIds DBMS_SQL.VARCHAR2_TABLE;

Line 813: xLastUpdateDates DBMS_SQL.DATE_TABLE;

809: xSupplierIds DBMS_SQL.NUMBER_TABLE;
810: xSupplierPartNums DBMS_SQL.VARCHAR2_TABLE;
811: xSupplierSiteIds DBMS_SQL.NUMBER_TABLE;
812: xTypes DBMS_SQL.NUMBER_TABLE;
813: xLastUpdateDates DBMS_SQL.DATE_TABLE;
814: xPriceTypes DBMS_SQL.VARCHAR2_TABLE;
815: xItemDescriptions DBMS_SQL.VARCHAR2_TABLE;
816: xTemplateIds DBMS_SQL.VARCHAR2_TABLE;
817: xRateTypes DBMS_SQL.VARCHAR2_TABLE;

Line 814: xPriceTypes DBMS_SQL.VARCHAR2_TABLE;

810: xSupplierPartNums DBMS_SQL.VARCHAR2_TABLE;
811: xSupplierSiteIds DBMS_SQL.NUMBER_TABLE;
812: xTypes DBMS_SQL.NUMBER_TABLE;
813: xLastUpdateDates DBMS_SQL.DATE_TABLE;
814: xPriceTypes DBMS_SQL.VARCHAR2_TABLE;
815: xItemDescriptions DBMS_SQL.VARCHAR2_TABLE;
816: xTemplateIds DBMS_SQL.VARCHAR2_TABLE;
817: xRateTypes DBMS_SQL.VARCHAR2_TABLE;
818: xRateDates DBMS_SQL.DATE_TABLE;

Line 815: xItemDescriptions DBMS_SQL.VARCHAR2_TABLE;

811: xSupplierSiteIds DBMS_SQL.NUMBER_TABLE;
812: xTypes DBMS_SQL.NUMBER_TABLE;
813: xLastUpdateDates DBMS_SQL.DATE_TABLE;
814: xPriceTypes DBMS_SQL.VARCHAR2_TABLE;
815: xItemDescriptions DBMS_SQL.VARCHAR2_TABLE;
816: xTemplateIds DBMS_SQL.VARCHAR2_TABLE;
817: xRateTypes DBMS_SQL.VARCHAR2_TABLE;
818: xRateDates DBMS_SQL.DATE_TABLE;
819: xRates DBMS_SQL.NUMBER_TABLE;

Line 816: xTemplateIds DBMS_SQL.VARCHAR2_TABLE;

812: xTypes DBMS_SQL.NUMBER_TABLE;
813: xLastUpdateDates DBMS_SQL.DATE_TABLE;
814: xPriceTypes DBMS_SQL.VARCHAR2_TABLE;
815: xItemDescriptions DBMS_SQL.VARCHAR2_TABLE;
816: xTemplateIds DBMS_SQL.VARCHAR2_TABLE;
817: xRateTypes DBMS_SQL.VARCHAR2_TABLE;
818: xRateDates DBMS_SQL.DATE_TABLE;
819: xRates DBMS_SQL.NUMBER_TABLE;
820: xSupplierNumbers DBMS_SQL.VARCHAR2_TABLE;

Line 817: xRateTypes DBMS_SQL.VARCHAR2_TABLE;

813: xLastUpdateDates DBMS_SQL.DATE_TABLE;
814: xPriceTypes DBMS_SQL.VARCHAR2_TABLE;
815: xItemDescriptions DBMS_SQL.VARCHAR2_TABLE;
816: xTemplateIds DBMS_SQL.VARCHAR2_TABLE;
817: xRateTypes DBMS_SQL.VARCHAR2_TABLE;
818: xRateDates DBMS_SQL.DATE_TABLE;
819: xRates DBMS_SQL.NUMBER_TABLE;
820: xSupplierNumbers DBMS_SQL.VARCHAR2_TABLE;
821: xSupplierContactIds DBMS_SQL.NUMBER_TABLE;

Line 818: xRateDates DBMS_SQL.DATE_TABLE;

814: xPriceTypes DBMS_SQL.VARCHAR2_TABLE;
815: xItemDescriptions DBMS_SQL.VARCHAR2_TABLE;
816: xTemplateIds DBMS_SQL.VARCHAR2_TABLE;
817: xRateTypes DBMS_SQL.VARCHAR2_TABLE;
818: xRateDates DBMS_SQL.DATE_TABLE;
819: xRates DBMS_SQL.NUMBER_TABLE;
820: xSupplierNumbers DBMS_SQL.VARCHAR2_TABLE;
821: xSupplierContactIds DBMS_SQL.NUMBER_TABLE;
822: xItemRevisions DBMS_SQL.VARCHAR2_TABLE;

Line 819: xRates DBMS_SQL.NUMBER_TABLE;

815: xItemDescriptions DBMS_SQL.VARCHAR2_TABLE;
816: xTemplateIds DBMS_SQL.VARCHAR2_TABLE;
817: xRateTypes DBMS_SQL.VARCHAR2_TABLE;
818: xRateDates DBMS_SQL.DATE_TABLE;
819: xRates DBMS_SQL.NUMBER_TABLE;
820: xSupplierNumbers DBMS_SQL.VARCHAR2_TABLE;
821: xSupplierContactIds DBMS_SQL.NUMBER_TABLE;
822: xItemRevisions DBMS_SQL.VARCHAR2_TABLE;
823: xLineTypeIds DBMS_SQL.NUMBER_TABLE;

Line 820: xSupplierNumbers DBMS_SQL.VARCHAR2_TABLE;

816: xTemplateIds DBMS_SQL.VARCHAR2_TABLE;
817: xRateTypes DBMS_SQL.VARCHAR2_TABLE;
818: xRateDates DBMS_SQL.DATE_TABLE;
819: xRates DBMS_SQL.NUMBER_TABLE;
820: xSupplierNumbers DBMS_SQL.VARCHAR2_TABLE;
821: xSupplierContactIds DBMS_SQL.NUMBER_TABLE;
822: xItemRevisions DBMS_SQL.VARCHAR2_TABLE;
823: xLineTypeIds DBMS_SQL.NUMBER_TABLE;
824: xBuyerIds DBMS_SQL.NUMBER_TABLE;

Line 821: xSupplierContactIds DBMS_SQL.NUMBER_TABLE;

817: xRateTypes DBMS_SQL.VARCHAR2_TABLE;
818: xRateDates DBMS_SQL.DATE_TABLE;
819: xRates DBMS_SQL.NUMBER_TABLE;
820: xSupplierNumbers DBMS_SQL.VARCHAR2_TABLE;
821: xSupplierContactIds DBMS_SQL.NUMBER_TABLE;
822: xItemRevisions DBMS_SQL.VARCHAR2_TABLE;
823: xLineTypeIds DBMS_SQL.NUMBER_TABLE;
824: xBuyerIds DBMS_SQL.NUMBER_TABLE;
825:

Line 822: xItemRevisions DBMS_SQL.VARCHAR2_TABLE;

818: xRateDates DBMS_SQL.DATE_TABLE;
819: xRates DBMS_SQL.NUMBER_TABLE;
820: xSupplierNumbers DBMS_SQL.VARCHAR2_TABLE;
821: xSupplierContactIds DBMS_SQL.NUMBER_TABLE;
822: xItemRevisions DBMS_SQL.VARCHAR2_TABLE;
823: xLineTypeIds DBMS_SQL.NUMBER_TABLE;
824: xBuyerIds DBMS_SQL.NUMBER_TABLE;
825:
826: xRowIds DBMS_SQL.UROWID_TABLE;

Line 823: xLineTypeIds DBMS_SQL.NUMBER_TABLE;

819: xRates DBMS_SQL.NUMBER_TABLE;
820: xSupplierNumbers DBMS_SQL.VARCHAR2_TABLE;
821: xSupplierContactIds DBMS_SQL.NUMBER_TABLE;
822: xItemRevisions DBMS_SQL.VARCHAR2_TABLE;
823: xLineTypeIds DBMS_SQL.NUMBER_TABLE;
824: xBuyerIds DBMS_SQL.NUMBER_TABLE;
825:
826: xRowIds DBMS_SQL.UROWID_TABLE;
827:

Line 824: xBuyerIds DBMS_SQL.NUMBER_TABLE;

820: xSupplierNumbers DBMS_SQL.VARCHAR2_TABLE;
821: xSupplierContactIds DBMS_SQL.NUMBER_TABLE;
822: xItemRevisions DBMS_SQL.VARCHAR2_TABLE;
823: xLineTypeIds DBMS_SQL.NUMBER_TABLE;
824: xBuyerIds DBMS_SQL.NUMBER_TABLE;
825:
826: xRowIds DBMS_SQL.UROWID_TABLE;
827:
828: xErrLoc PLS_INTEGER;

Line 826: xRowIds DBMS_SQL.UROWID_TABLE;

822: xItemRevisions DBMS_SQL.VARCHAR2_TABLE;
823: xLineTypeIds DBMS_SQL.NUMBER_TABLE;
824: xBuyerIds DBMS_SQL.NUMBER_TABLE;
825:
826: xRowIds DBMS_SQL.UROWID_TABLE;
827:
828: xErrLoc PLS_INTEGER;
829: xReturnErr VARCHAR2(2000);
830:

Line 1217: xCursorId := DBMS_SQL.open_cursor;

1213: 'Dynamic SQL to update base attributes of ICX_CAT_ITEMS_TLP');
1214:
1215: IF (gDynSqlBaseAttributes IS NOT NULL) THEN
1216: xErrLoc := 210;
1217: xCursorId := DBMS_SQL.open_cursor;
1218: xErrLoc := 220;
1219: DBMS_SQL.parse(xCursorId, gDynSqlBaseAttributes, DBMS_SQL.NATIVE);
1220: xErrLoc := 230;
1221: DBMS_SQL.bind_array(xCursorId, ':new_rt_item_id', gIRtItemIds);

Line 1219: DBMS_SQL.parse(xCursorId, gDynSqlBaseAttributes, DBMS_SQL.NATIVE);

1215: IF (gDynSqlBaseAttributes IS NOT NULL) THEN
1216: xErrLoc := 210;
1217: xCursorId := DBMS_SQL.open_cursor;
1218: xErrLoc := 220;
1219: DBMS_SQL.parse(xCursorId, gDynSqlBaseAttributes, DBMS_SQL.NATIVE);
1220: xErrLoc := 230;
1221: DBMS_SQL.bind_array(xCursorId, ':new_rt_item_id', gIRtItemIds);
1222: xErrLoc := 240;
1223: DBMS_SQL.bind_array(xCursorId, ':old_rt_item_id', gIOldRtItemIds);

Line 1221: DBMS_SQL.bind_array(xCursorId, ':new_rt_item_id', gIRtItemIds);

1217: xCursorId := DBMS_SQL.open_cursor;
1218: xErrLoc := 220;
1219: DBMS_SQL.parse(xCursorId, gDynSqlBaseAttributes, DBMS_SQL.NATIVE);
1220: xErrLoc := 230;
1221: DBMS_SQL.bind_array(xCursorId, ':new_rt_item_id', gIRtItemIds);
1222: xErrLoc := 240;
1223: DBMS_SQL.bind_array(xCursorId, ':old_rt_item_id', gIOldRtItemIds);
1224: xErrLoc := 250;
1225: xResultCount := DBMS_SQL.execute(xCursorId);

Line 1223: DBMS_SQL.bind_array(xCursorId, ':old_rt_item_id', gIOldRtItemIds);

1219: DBMS_SQL.parse(xCursorId, gDynSqlBaseAttributes, DBMS_SQL.NATIVE);
1220: xErrLoc := 230;
1221: DBMS_SQL.bind_array(xCursorId, ':new_rt_item_id', gIRtItemIds);
1222: xErrLoc := 240;
1223: DBMS_SQL.bind_array(xCursorId, ':old_rt_item_id', gIOldRtItemIds);
1224: xErrLoc := 250;
1225: xResultCount := DBMS_SQL.execute(xCursorId);
1226: xErrLoc := 260;
1227: DBMS_SQL.close_cursor(xCursorId);

Line 1225: xResultCount := DBMS_SQL.execute(xCursorId);

1221: DBMS_SQL.bind_array(xCursorId, ':new_rt_item_id', gIRtItemIds);
1222: xErrLoc := 240;
1223: DBMS_SQL.bind_array(xCursorId, ':old_rt_item_id', gIOldRtItemIds);
1224: xErrLoc := 250;
1225: xResultCount := DBMS_SQL.execute(xCursorId);
1226: xErrLoc := 260;
1227: DBMS_SQL.close_cursor(xCursorId);
1228:
1229: xErrLoc := 270;

Line 1227: DBMS_SQL.close_cursor(xCursorId);

1223: DBMS_SQL.bind_array(xCursorId, ':old_rt_item_id', gIOldRtItemIds);
1224: xErrLoc := 250;
1225: xResultCount := DBMS_SQL.execute(xCursorId);
1226: xErrLoc := 260;
1227: DBMS_SQL.close_cursor(xCursorId);
1228:
1229: xErrLoc := 270;
1230: COMMIT;
1231: END IF;

Line 1640: xRtItemIds DBMS_SQL.NUMBER_TABLE;

1636:
1637: xErrLoc PLS_INTEGER;
1638: xReturnErr VARCHAR2(2000);
1639:
1640: xRtItemIds DBMS_SQL.NUMBER_TABLE;
1641: xOldRtItemIds DBMS_SQL.NUMBER_TABLE;
1642:
1643: xSqlString VARCHAR2(4000);
1644: xCursorId NUMBER;

Line 1641: xOldRtItemIds DBMS_SQL.NUMBER_TABLE;

1637: xErrLoc PLS_INTEGER;
1638: xReturnErr VARCHAR2(2000);
1639:
1640: xRtItemIds DBMS_SQL.NUMBER_TABLE;
1641: xOldRtItemIds DBMS_SQL.NUMBER_TABLE;
1642:
1643: xSqlString VARCHAR2(4000);
1644: xCursorId NUMBER;
1645: xResultCount NUMBER;

Line 1684: xCursorId := DBMS_SQL.open_cursor;

1680:
1681: -- Dynamic SQL to update category attributes of ICX_CAT_EXT_ITEMS_TLP
1682:
1683: xErrLoc := 220;
1684: xCursorId := DBMS_SQL.open_cursor;
1685: xErrLoc := 230;
1686: DBMS_SQL.parse(xCursorId, gDynSqlCatAttributes, DBMS_SQL.NATIVE);
1687: xErrLoc := 240;
1688: DBMS_SQL.bind_array(xCursorId, ':new_rt_item_id', xRtItemIds);

Line 1686: DBMS_SQL.parse(xCursorId, gDynSqlCatAttributes, DBMS_SQL.NATIVE);

1682:
1683: xErrLoc := 220;
1684: xCursorId := DBMS_SQL.open_cursor;
1685: xErrLoc := 230;
1686: DBMS_SQL.parse(xCursorId, gDynSqlCatAttributes, DBMS_SQL.NATIVE);
1687: xErrLoc := 240;
1688: DBMS_SQL.bind_array(xCursorId, ':new_rt_item_id', xRtItemIds);
1689: xErrLoc := 260;
1690: DBMS_SQL.bind_array(xCursorId, ':old_rt_item_id', xOldRtItemIds);

Line 1688: DBMS_SQL.bind_array(xCursorId, ':new_rt_item_id', xRtItemIds);

1684: xCursorId := DBMS_SQL.open_cursor;
1685: xErrLoc := 230;
1686: DBMS_SQL.parse(xCursorId, gDynSqlCatAttributes, DBMS_SQL.NATIVE);
1687: xErrLoc := 240;
1688: DBMS_SQL.bind_array(xCursorId, ':new_rt_item_id', xRtItemIds);
1689: xErrLoc := 260;
1690: DBMS_SQL.bind_array(xCursorId, ':old_rt_item_id', xOldRtItemIds);
1691: xErrLoc := 270;
1692: xResultCount := DBMS_SQL.execute(xCursorId);

Line 1690: DBMS_SQL.bind_array(xCursorId, ':old_rt_item_id', xOldRtItemIds);

1686: DBMS_SQL.parse(xCursorId, gDynSqlCatAttributes, DBMS_SQL.NATIVE);
1687: xErrLoc := 240;
1688: DBMS_SQL.bind_array(xCursorId, ':new_rt_item_id', xRtItemIds);
1689: xErrLoc := 260;
1690: DBMS_SQL.bind_array(xCursorId, ':old_rt_item_id', xOldRtItemIds);
1691: xErrLoc := 270;
1692: xResultCount := DBMS_SQL.execute(xCursorId);
1693: xErrLoc := 280;
1694: DBMS_SQL.close_cursor(xCursorId);

Line 1692: xResultCount := DBMS_SQL.execute(xCursorId);

1688: DBMS_SQL.bind_array(xCursorId, ':new_rt_item_id', xRtItemIds);
1689: xErrLoc := 260;
1690: DBMS_SQL.bind_array(xCursorId, ':old_rt_item_id', xOldRtItemIds);
1691: xErrLoc := 270;
1692: xResultCount := DBMS_SQL.execute(xCursorId);
1693: xErrLoc := 280;
1694: DBMS_SQL.close_cursor(xCursorId);
1695:
1696: xErrLoc := 300;

Line 1694: DBMS_SQL.close_cursor(xCursorId);

1690: DBMS_SQL.bind_array(xCursorId, ':old_rt_item_id', xOldRtItemIds);
1691: xErrLoc := 270;
1692: xResultCount := DBMS_SQL.execute(xCursorId);
1693: xErrLoc := 280;
1694: DBMS_SQL.close_cursor(xCursorId);
1695:
1696: xErrLoc := 300;
1697: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DETIL_LEVEL THEN
1698: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DETIL_LEVEL,

Line 1750: xRowIds DBMS_SQL.UROWID_TABLE;

1746: WHERE p2.rt_item_id = p.rt_item_id
1747: AND p2.price_type = 'INTERNAL_ITEM');
1748: xErrLoc PLS_INTEGER;
1749: xReturnErr VARCHAR2(2000);
1750: xRowIds DBMS_SQL.UROWID_TABLE;
1751: BEGIN
1752: xErrLoc := 50;
1753: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL,
1754: 'create missing internal item prices');

Line 1873: xRtItemIds DBMS_SQL.NUMBER_TABLE;

1869: xErrLoc PLS_INTEGER;
1870: xCount PLS_INTEGER;
1871: xReturnErr VARCHAR2(2000);
1872:
1873: xRtItemIds DBMS_SQL.NUMBER_TABLE;
1874: xOldRtItemIds DBMS_SQL.NUMBER_TABLE;
1875: xInternalRtItemIds DBMS_SQL.NUMBER_TABLE;
1876: xInventoryItemIds DBMS_SQL.NUMBER_TABLE;
1877: xOrgIds DBMS_SQL.NUMBER_TABLE;

Line 1874: xOldRtItemIds DBMS_SQL.NUMBER_TABLE;

1870: xCount PLS_INTEGER;
1871: xReturnErr VARCHAR2(2000);
1872:
1873: xRtItemIds DBMS_SQL.NUMBER_TABLE;
1874: xOldRtItemIds DBMS_SQL.NUMBER_TABLE;
1875: xInternalRtItemIds DBMS_SQL.NUMBER_TABLE;
1876: xInventoryItemIds DBMS_SQL.NUMBER_TABLE;
1877: xOrgIds DBMS_SQL.NUMBER_TABLE;
1878: xRtCategoryIds DBMS_SQL.NUMBER_TABLE;

Line 1875: xInternalRtItemIds DBMS_SQL.NUMBER_TABLE;

1871: xReturnErr VARCHAR2(2000);
1872:
1873: xRtItemIds DBMS_SQL.NUMBER_TABLE;
1874: xOldRtItemIds DBMS_SQL.NUMBER_TABLE;
1875: xInternalRtItemIds DBMS_SQL.NUMBER_TABLE;
1876: xInventoryItemIds DBMS_SQL.NUMBER_TABLE;
1877: xOrgIds DBMS_SQL.NUMBER_TABLE;
1878: xRtCategoryIds DBMS_SQL.NUMBER_TABLE;
1879: xLanguage VARCHAR2(4);

Line 1876: xInventoryItemIds DBMS_SQL.NUMBER_TABLE;

1872:
1873: xRtItemIds DBMS_SQL.NUMBER_TABLE;
1874: xOldRtItemIds DBMS_SQL.NUMBER_TABLE;
1875: xInternalRtItemIds DBMS_SQL.NUMBER_TABLE;
1876: xInventoryItemIds DBMS_SQL.NUMBER_TABLE;
1877: xOrgIds DBMS_SQL.NUMBER_TABLE;
1878: xRtCategoryIds DBMS_SQL.NUMBER_TABLE;
1879: xLanguage VARCHAR2(4);
1880:

Line 1877: xOrgIds DBMS_SQL.NUMBER_TABLE;

1873: xRtItemIds DBMS_SQL.NUMBER_TABLE;
1874: xOldRtItemIds DBMS_SQL.NUMBER_TABLE;
1875: xInternalRtItemIds DBMS_SQL.NUMBER_TABLE;
1876: xInventoryItemIds DBMS_SQL.NUMBER_TABLE;
1877: xOrgIds DBMS_SQL.NUMBER_TABLE;
1878: xRtCategoryIds DBMS_SQL.NUMBER_TABLE;
1879: xLanguage VARCHAR2(4);
1880:
1881: BEGIN

Line 1878: xRtCategoryIds DBMS_SQL.NUMBER_TABLE;

1874: xOldRtItemIds DBMS_SQL.NUMBER_TABLE;
1875: xInternalRtItemIds DBMS_SQL.NUMBER_TABLE;
1876: xInventoryItemIds DBMS_SQL.NUMBER_TABLE;
1877: xOrgIds DBMS_SQL.NUMBER_TABLE;
1878: xRtCategoryIds DBMS_SQL.NUMBER_TABLE;
1879: xLanguage VARCHAR2(4);
1880:
1881: BEGIN
1882: xErrLoc := 100;

Line 2043: xRtItemIds DBMS_SQL.NUMBER_TABLE;

2039: --
2040: PROCEDURE updateRequestId IS
2041:
2042: xErrLoc PLS_INTEGER;
2043: xRtItemIds DBMS_SQL.NUMBER_TABLE;
2044: xReturnErr VARCHAR2(2000);
2045:
2046: CURSOR cRequestId IS
2047: SELECT p.rt_item_id

Line 2345: xRtItemIds DBMS_SQL.NUMBER_TABLE;

2341: cMatchRtItemIds tCursorType;
2342:
2343: xErrLoc PLS_INTEGER;
2344: xReturnErr VARCHAR2(2000);
2345: xRtItemIds DBMS_SQL.NUMBER_TABLE;
2346: xCount PLS_INTEGER;
2347:
2348: BEGIN
2349: xErrLoc := 50;