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_POR_EXT_ITEM dependencies on ICX_POR_EXTRACTOR

Line 1680: last_updated_by = ICX_POR_EXTRACTOR.gUserId,

1676: SET description = xUPItemDescriptions(i),
1677: picture = xUPItemPictures(i),
1678: picture_url = xUPItemPictureUrls(i),
1679: thumbnail_image = xUPItemPictures(i),
1680: last_updated_by = ICX_POR_EXTRACTOR.gUserId,
1681: last_update_date = SYSDATE,
1682: last_update_login = ICX_POR_EXTRACTOR.gLoginId,
1683: request_id = ICX_POR_EXTRACTOR.gRequestId,
1684: program_application_id = ICX_POR_EXTRACTOR.gProgramApplicationId,

Line 1682: last_update_login = ICX_POR_EXTRACTOR.gLoginId,

1678: picture_url = xUPItemPictureUrls(i),
1679: thumbnail_image = xUPItemPictures(i),
1680: last_updated_by = ICX_POR_EXTRACTOR.gUserId,
1681: last_update_date = SYSDATE,
1682: last_update_login = ICX_POR_EXTRACTOR.gLoginId,
1683: request_id = ICX_POR_EXTRACTOR.gRequestId,
1684: program_application_id = ICX_POR_EXTRACTOR.gProgramApplicationId,
1685: program_id = ICX_POR_EXTRACTOR.gProgramId,
1686: program_update_date = SYSDATE

Line 1683: request_id = ICX_POR_EXTRACTOR.gRequestId,

1679: thumbnail_image = xUPItemPictures(i),
1680: last_updated_by = ICX_POR_EXTRACTOR.gUserId,
1681: last_update_date = SYSDATE,
1682: last_update_login = ICX_POR_EXTRACTOR.gLoginId,
1683: request_id = ICX_POR_EXTRACTOR.gRequestId,
1684: program_application_id = ICX_POR_EXTRACTOR.gProgramApplicationId,
1685: program_id = ICX_POR_EXTRACTOR.gProgramId,
1686: program_update_date = SYSDATE
1687: WHERE rt_item_id = xUPItemRtItemIds(i)

Line 1684: program_application_id = ICX_POR_EXTRACTOR.gProgramApplicationId,

1680: last_updated_by = ICX_POR_EXTRACTOR.gUserId,
1681: last_update_date = SYSDATE,
1682: last_update_login = ICX_POR_EXTRACTOR.gLoginId,
1683: request_id = ICX_POR_EXTRACTOR.gRequestId,
1684: program_application_id = ICX_POR_EXTRACTOR.gProgramApplicationId,
1685: program_id = ICX_POR_EXTRACTOR.gProgramId,
1686: program_update_date = SYSDATE
1687: WHERE rt_item_id = xUPItemRtItemIds(i)
1688: AND language = ICX_POR_EXTRACTOR.gBaseLang;

Line 1685: program_id = ICX_POR_EXTRACTOR.gProgramId,

1681: last_update_date = SYSDATE,
1682: last_update_login = ICX_POR_EXTRACTOR.gLoginId,
1683: request_id = ICX_POR_EXTRACTOR.gRequestId,
1684: program_application_id = ICX_POR_EXTRACTOR.gProgramApplicationId,
1685: program_id = ICX_POR_EXTRACTOR.gProgramId,
1686: program_update_date = SYSDATE
1687: WHERE rt_item_id = xUPItemRtItemIds(i)
1688: AND language = ICX_POR_EXTRACTOR.gBaseLang;
1689:

Line 1688: AND language = ICX_POR_EXTRACTOR.gBaseLang;

1684: program_application_id = ICX_POR_EXTRACTOR.gProgramApplicationId,
1685: program_id = ICX_POR_EXTRACTOR.gProgramId,
1686: program_update_date = SYSDATE
1687: WHERE rt_item_id = xUPItemRtItemIds(i)
1688: AND language = ICX_POR_EXTRACTOR.gBaseLang;
1689:
1690: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DETIL_LEVEL THEN
1691: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DETIL_LEVEL,
1692: 'gExtractImageDet:'||gExtractImageDet ||

Line 1699: last_updated_by = ICX_POR_EXTRACTOR.gUserId,

1695: ELSE
1696: FORALL i IN 1..xUPItemRtItemIds.COUNT
1697: UPDATE icx_cat_items_tlp
1698: SET description = xUPItemDescriptions(i),
1699: last_updated_by = ICX_POR_EXTRACTOR.gUserId,
1700: last_update_date = SYSDATE,
1701: last_update_login = ICX_POR_EXTRACTOR.gLoginId,
1702: request_id = ICX_POR_EXTRACTOR.gRequestId,
1703: program_application_id = ICX_POR_EXTRACTOR.gProgramApplicationId,

Line 1701: last_update_login = ICX_POR_EXTRACTOR.gLoginId,

1697: UPDATE icx_cat_items_tlp
1698: SET description = xUPItemDescriptions(i),
1699: last_updated_by = ICX_POR_EXTRACTOR.gUserId,
1700: last_update_date = SYSDATE,
1701: last_update_login = ICX_POR_EXTRACTOR.gLoginId,
1702: request_id = ICX_POR_EXTRACTOR.gRequestId,
1703: program_application_id = ICX_POR_EXTRACTOR.gProgramApplicationId,
1704: program_id = ICX_POR_EXTRACTOR.gProgramId,
1705: program_update_date = SYSDATE

Line 1702: request_id = ICX_POR_EXTRACTOR.gRequestId,

1698: SET description = xUPItemDescriptions(i),
1699: last_updated_by = ICX_POR_EXTRACTOR.gUserId,
1700: last_update_date = SYSDATE,
1701: last_update_login = ICX_POR_EXTRACTOR.gLoginId,
1702: request_id = ICX_POR_EXTRACTOR.gRequestId,
1703: program_application_id = ICX_POR_EXTRACTOR.gProgramApplicationId,
1704: program_id = ICX_POR_EXTRACTOR.gProgramId,
1705: program_update_date = SYSDATE
1706: WHERE rt_item_id = xUPItemRtItemIds(i)

Line 1703: program_application_id = ICX_POR_EXTRACTOR.gProgramApplicationId,

1699: last_updated_by = ICX_POR_EXTRACTOR.gUserId,
1700: last_update_date = SYSDATE,
1701: last_update_login = ICX_POR_EXTRACTOR.gLoginId,
1702: request_id = ICX_POR_EXTRACTOR.gRequestId,
1703: program_application_id = ICX_POR_EXTRACTOR.gProgramApplicationId,
1704: program_id = ICX_POR_EXTRACTOR.gProgramId,
1705: program_update_date = SYSDATE
1706: WHERE rt_item_id = xUPItemRtItemIds(i)
1707: AND language = ICX_POR_EXTRACTOR.gBaseLang;

Line 1704: program_id = ICX_POR_EXTRACTOR.gProgramId,

1700: last_update_date = SYSDATE,
1701: last_update_login = ICX_POR_EXTRACTOR.gLoginId,
1702: request_id = ICX_POR_EXTRACTOR.gRequestId,
1703: program_application_id = ICX_POR_EXTRACTOR.gProgramApplicationId,
1704: program_id = ICX_POR_EXTRACTOR.gProgramId,
1705: program_update_date = SYSDATE
1706: WHERE rt_item_id = xUPItemRtItemIds(i)
1707: AND language = ICX_POR_EXTRACTOR.gBaseLang;
1708:

Line 1707: AND language = ICX_POR_EXTRACTOR.gBaseLang;

1703: program_application_id = ICX_POR_EXTRACTOR.gProgramApplicationId,
1704: program_id = ICX_POR_EXTRACTOR.gProgramId,
1705: program_update_date = SYSDATE
1706: WHERE rt_item_id = xUPItemRtItemIds(i)
1707: AND language = ICX_POR_EXTRACTOR.gBaseLang;
1708:
1709: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DETIL_LEVEL THEN
1710: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DETIL_LEVEL,
1711: 'gExtractImageDet:'||gExtractImageDet ||

Line 2133: last_updated_by = ICX_POR_EXTRACTOR.gUserId,

2129: supplier_contact_id = gUpSupplierContactIds(i),
2130: item_revision = gUpItemRevisions(i),
2131: line_type_id = gUpLineTypeIds(i),
2132: buyer_id = gUpBuyerIds(i),
2133: last_updated_by = ICX_POR_EXTRACTOR.gUserId,
2134: last_update_date = gUPLastUpdateDates(i),
2135: last_update_login = ICX_POR_EXTRACTOR.gLoginId,
2136: -- Bug#3352834
2137: request_id = ICX_POR_EXT_ITEM.CURRENT_REQUEST_ID,

Line 2135: last_update_login = ICX_POR_EXTRACTOR.gLoginId,

2131: line_type_id = gUpLineTypeIds(i),
2132: buyer_id = gUpBuyerIds(i),
2133: last_updated_by = ICX_POR_EXTRACTOR.gUserId,
2134: last_update_date = gUPLastUpdateDates(i),
2135: last_update_login = ICX_POR_EXTRACTOR.gLoginId,
2136: -- Bug#3352834
2137: request_id = ICX_POR_EXT_ITEM.CURRENT_REQUEST_ID,
2138: program_application_id = ICX_POR_EXTRACTOR.gProgramApplicationId,
2139: program_id = ICX_POR_EXTRACTOR.gProgramId,

Line 2138: program_application_id = ICX_POR_EXTRACTOR.gProgramApplicationId,

2134: last_update_date = gUPLastUpdateDates(i),
2135: last_update_login = ICX_POR_EXTRACTOR.gLoginId,
2136: -- Bug#3352834
2137: request_id = ICX_POR_EXT_ITEM.CURRENT_REQUEST_ID,
2138: program_application_id = ICX_POR_EXTRACTOR.gProgramApplicationId,
2139: program_id = ICX_POR_EXTRACTOR.gProgramId,
2140: program_update_date = SYSDATE
2141: WHERE rowid = gUPPriceRowIds(i);
2142:

Line 2139: program_id = ICX_POR_EXTRACTOR.gProgramId,

2135: last_update_login = ICX_POR_EXTRACTOR.gLoginId,
2136: -- Bug#3352834
2137: request_id = ICX_POR_EXT_ITEM.CURRENT_REQUEST_ID,
2138: program_application_id = ICX_POR_EXTRACTOR.gProgramApplicationId,
2139: program_id = ICX_POR_EXTRACTOR.gProgramId,
2140: program_update_date = SYSDATE
2141: WHERE rowid = gUPPriceRowIds(i);
2142:
2143: clearTables(xActionMode);

Line 2173: last_updated_by = ICX_POR_EXTRACTOR.gUserId,

2169: line_type_id = gUPGLineTypeIds(i),
2170: currency = gUPGCurrencys(i),
2171: unit_of_measure = gUPGUnitOfMeasures(i),
2172: functional_price = gUPGFunctionalPrices(i),
2173: last_updated_by = ICX_POR_EXTRACTOR.gUserId,
2174: last_update_date = SYSDATE,
2175: last_update_login = ICX_POR_EXTRACTOR.gLoginId,
2176: -- Bug#3352834
2177: request_id = ICX_POR_EXT_ITEM.CURRENT_REQUEST_ID,

Line 2175: last_update_login = ICX_POR_EXTRACTOR.gLoginId,

2171: unit_of_measure = gUPGUnitOfMeasures(i),
2172: functional_price = gUPGFunctionalPrices(i),
2173: last_updated_by = ICX_POR_EXTRACTOR.gUserId,
2174: last_update_date = SYSDATE,
2175: last_update_login = ICX_POR_EXTRACTOR.gLoginId,
2176: -- Bug#3352834
2177: request_id = ICX_POR_EXT_ITEM.CURRENT_REQUEST_ID,
2178: program_application_id = ICX_POR_EXTRACTOR.gProgramApplicationId,
2179: program_id = ICX_POR_EXTRACTOR.gProgramId,

Line 2178: program_application_id = ICX_POR_EXTRACTOR.gProgramApplicationId,

2174: last_update_date = SYSDATE,
2175: last_update_login = ICX_POR_EXTRACTOR.gLoginId,
2176: -- Bug#3352834
2177: request_id = ICX_POR_EXT_ITEM.CURRENT_REQUEST_ID,
2178: program_application_id = ICX_POR_EXTRACTOR.gProgramApplicationId,
2179: program_id = ICX_POR_EXTRACTOR.gProgramId,
2180: program_update_date = SYSDATE
2181: WHERE contract_id = gUPGContractIds(i)
2182: AND contract_line_id = gUPGContractLineIds(i)

Line 2179: program_id = ICX_POR_EXTRACTOR.gProgramId,

2175: last_update_login = ICX_POR_EXTRACTOR.gLoginId,
2176: -- Bug#3352834
2177: request_id = ICX_POR_EXT_ITEM.CURRENT_REQUEST_ID,
2178: program_application_id = ICX_POR_EXTRACTOR.gProgramApplicationId,
2179: program_id = ICX_POR_EXTRACTOR.gProgramId,
2180: program_update_date = SYSDATE
2181: WHERE contract_id = gUPGContractIds(i)
2182: AND contract_line_id = gUPGContractLineIds(i)
2183: AND price_type = 'GLOBAL_AGREEMENT';

Line 2243: NULL, ICX_POR_EXTRACTOR.gLoginId,

2239: gIPContractNums(i), gIPContractLineNums(i),
2240: gIpRateTypes(i), gIpRateDates(i), gIpRates(i),
2241: gIpSupplierNumbers(i), gIpSupplierContactIds(i),
2242: gIpItemRevisions(i), gIpLineTypeIds(i), gIpBuyerIds(i),
2243: NULL, ICX_POR_EXTRACTOR.gLoginId,
2244: ICX_POR_EXTRACTOR.gUserId, gIPLastUpdateDates(i),
2245: ICX_POR_EXTRACTOR.gUserId, SYSDATE,
2246: -- Bug#3352834
2247: ICX_POR_EXT_ITEM.CURRENT_REQUEST_ID,

Line 2244: ICX_POR_EXTRACTOR.gUserId, gIPLastUpdateDates(i),

2240: gIpRateTypes(i), gIpRateDates(i), gIpRates(i),
2241: gIpSupplierNumbers(i), gIpSupplierContactIds(i),
2242: gIpItemRevisions(i), gIpLineTypeIds(i), gIpBuyerIds(i),
2243: NULL, ICX_POR_EXTRACTOR.gLoginId,
2244: ICX_POR_EXTRACTOR.gUserId, gIPLastUpdateDates(i),
2245: ICX_POR_EXTRACTOR.gUserId, SYSDATE,
2246: -- Bug#3352834
2247: ICX_POR_EXT_ITEM.CURRENT_REQUEST_ID,
2248: ICX_POR_EXTRACTOR.gProgramApplicationId,

Line 2245: ICX_POR_EXTRACTOR.gUserId, SYSDATE,

2241: gIpSupplierNumbers(i), gIpSupplierContactIds(i),
2242: gIpItemRevisions(i), gIpLineTypeIds(i), gIpBuyerIds(i),
2243: NULL, ICX_POR_EXTRACTOR.gLoginId,
2244: ICX_POR_EXTRACTOR.gUserId, gIPLastUpdateDates(i),
2245: ICX_POR_EXTRACTOR.gUserId, SYSDATE,
2246: -- Bug#3352834
2247: ICX_POR_EXT_ITEM.CURRENT_REQUEST_ID,
2248: ICX_POR_EXTRACTOR.gProgramApplicationId,
2249: ICX_POR_EXTRACTOR.gProgramId, SYSDATE);

Line 2248: ICX_POR_EXTRACTOR.gProgramApplicationId,

2244: ICX_POR_EXTRACTOR.gUserId, gIPLastUpdateDates(i),
2245: ICX_POR_EXTRACTOR.gUserId, SYSDATE,
2246: -- Bug#3352834
2247: ICX_POR_EXT_ITEM.CURRENT_REQUEST_ID,
2248: ICX_POR_EXTRACTOR.gProgramApplicationId,
2249: ICX_POR_EXTRACTOR.gProgramId, SYSDATE);
2250:
2251: clearTables(xActionMode);
2252:

Line 2249: ICX_POR_EXTRACTOR.gProgramId, SYSDATE);

2245: ICX_POR_EXTRACTOR.gUserId, SYSDATE,
2246: -- Bug#3352834
2247: ICX_POR_EXT_ITEM.CURRENT_REQUEST_ID,
2248: ICX_POR_EXTRACTOR.gProgramApplicationId,
2249: ICX_POR_EXTRACTOR.gProgramId, SYSDATE);
2250:
2251: clearTables(xActionMode);
2252:
2253: xErrLoc := 240;

Line 2276: ICX_POR_EXTRACTOR.gLoginId, ICX_POR_EXTRACTOR.gUserId, SYSDATE,

2272: (gIBRtItemIds(i), 1, gIBOrgIds(i),
2273: gIBSupplierIds(i), gIBSuppliers(i), gIBSupplierPartNums(i),
2274: '##NULL##', gIBInternalItemIds(i), gIBInternalItemNums(i),
2275: 'Y', NULL,
2276: ICX_POR_EXTRACTOR.gLoginId, ICX_POR_EXTRACTOR.gUserId, SYSDATE,
2277: ICX_POR_EXTRACTOR.gUserId, SYSDATE, ICX_POR_EXTRACTOR.gRequestId,
2278: ICX_POR_EXTRACTOR.gProgramApplicationId,
2279: ICX_POR_EXTRACTOR.gProgramId, SYSDATE);
2280:

Line 2277: ICX_POR_EXTRACTOR.gUserId, SYSDATE, ICX_POR_EXTRACTOR.gRequestId,

2273: gIBSupplierIds(i), gIBSuppliers(i), gIBSupplierPartNums(i),
2274: '##NULL##', gIBInternalItemIds(i), gIBInternalItemNums(i),
2275: 'Y', NULL,
2276: ICX_POR_EXTRACTOR.gLoginId, ICX_POR_EXTRACTOR.gUserId, SYSDATE,
2277: ICX_POR_EXTRACTOR.gUserId, SYSDATE, ICX_POR_EXTRACTOR.gRequestId,
2278: ICX_POR_EXTRACTOR.gProgramApplicationId,
2279: ICX_POR_EXTRACTOR.gProgramId, SYSDATE);
2280:
2281: clearTables(xActionMode);

Line 2278: ICX_POR_EXTRACTOR.gProgramApplicationId,

2274: '##NULL##', gIBInternalItemIds(i), gIBInternalItemNums(i),
2275: 'Y', NULL,
2276: ICX_POR_EXTRACTOR.gLoginId, ICX_POR_EXTRACTOR.gUserId, SYSDATE,
2277: ICX_POR_EXTRACTOR.gUserId, SYSDATE, ICX_POR_EXTRACTOR.gRequestId,
2278: ICX_POR_EXTRACTOR.gProgramApplicationId,
2279: ICX_POR_EXTRACTOR.gProgramId, SYSDATE);
2280:
2281: clearTables(xActionMode);
2282:

Line 2279: ICX_POR_EXTRACTOR.gProgramId, SYSDATE);

2275: 'Y', NULL,
2276: ICX_POR_EXTRACTOR.gLoginId, ICX_POR_EXTRACTOR.gUserId, SYSDATE,
2277: ICX_POR_EXTRACTOR.gUserId, SYSDATE, ICX_POR_EXTRACTOR.gRequestId,
2278: ICX_POR_EXTRACTOR.gProgramApplicationId,
2279: ICX_POR_EXTRACTOR.gProgramId, SYSDATE);
2280:
2281: clearTables(xActionMode);
2282:
2283: xErrLoc := 260;

Line 2299: last_updated_by = ICX_POR_EXTRACTOR.gUserId,

2295: extractor_updated_flag = gUBExtractorUpdatedFlags(i),
2296: supplier_part_auxid = '##NULL##',
2297: internal_item_num = gUBInternalItemNums(i),
2298: catalog_name = NULL,
2299: last_updated_by = ICX_POR_EXTRACTOR.gUserId,
2300: last_update_date = SYSDATE,
2301: last_update_login = ICX_POR_EXTRACTOR.gLoginId,
2302: request_id = ICX_POR_EXTRACTOR.gRequestId,
2303: program_application_id = ICX_POR_EXTRACTOR.gProgramApplicationId,

Line 2301: last_update_login = ICX_POR_EXTRACTOR.gLoginId,

2297: internal_item_num = gUBInternalItemNums(i),
2298: catalog_name = NULL,
2299: last_updated_by = ICX_POR_EXTRACTOR.gUserId,
2300: last_update_date = SYSDATE,
2301: last_update_login = ICX_POR_EXTRACTOR.gLoginId,
2302: request_id = ICX_POR_EXTRACTOR.gRequestId,
2303: program_application_id = ICX_POR_EXTRACTOR.gProgramApplicationId,
2304: program_id = ICX_POR_EXTRACTOR.gProgramId,
2305: program_update_date = SYSDATE

Line 2302: request_id = ICX_POR_EXTRACTOR.gRequestId,

2298: catalog_name = NULL,
2299: last_updated_by = ICX_POR_EXTRACTOR.gUserId,
2300: last_update_date = SYSDATE,
2301: last_update_login = ICX_POR_EXTRACTOR.gLoginId,
2302: request_id = ICX_POR_EXTRACTOR.gRequestId,
2303: program_application_id = ICX_POR_EXTRACTOR.gProgramApplicationId,
2304: program_id = ICX_POR_EXTRACTOR.gProgramId,
2305: program_update_date = SYSDATE
2306: WHERE rt_item_id = gUBRtItemIds(i);

Line 2303: program_application_id = ICX_POR_EXTRACTOR.gProgramApplicationId,

2299: last_updated_by = ICX_POR_EXTRACTOR.gUserId,
2300: last_update_date = SYSDATE,
2301: last_update_login = ICX_POR_EXTRACTOR.gLoginId,
2302: request_id = ICX_POR_EXTRACTOR.gRequestId,
2303: program_application_id = ICX_POR_EXTRACTOR.gProgramApplicationId,
2304: program_id = ICX_POR_EXTRACTOR.gProgramId,
2305: program_update_date = SYSDATE
2306: WHERE rt_item_id = gUBRtItemIds(i);
2307:

Line 2304: program_id = ICX_POR_EXTRACTOR.gProgramId,

2300: last_update_date = SYSDATE,
2301: last_update_login = ICX_POR_EXTRACTOR.gLoginId,
2302: request_id = ICX_POR_EXTRACTOR.gRequestId,
2303: program_application_id = ICX_POR_EXTRACTOR.gProgramApplicationId,
2304: program_id = ICX_POR_EXTRACTOR.gProgramId,
2305: program_update_date = SYSDATE
2306: WHERE rt_item_id = gUBRtItemIds(i);
2307:
2308: clearTables(xActionMode);

Line 2343: NULL, ICX_POR_EXTRACTOR.gLoginId,

2339: gITSuppliers(i), gITSupplierPartNums(i), '##NULL##', gITManufacturers(i),
2340: gITManufacturerPartNums(i), gITDescriptions(i), NULL, NULL,
2341: gITPictures(i), gITPictureURLs(i), gITPictures(i), NULL, NULL,
2342: NULL, NULL, NULL, NULL,
2343: NULL, ICX_POR_EXTRACTOR.gLoginId,
2344: ICX_POR_EXTRACTOR.gUserId, SYSDATE,
2345: ICX_POR_EXTRACTOR.gUserId, SYSDATE, ICX_POR_EXTRACTOR.gRequestId,
2346: ICX_POR_EXTRACTOR.gProgramApplicationId,
2347: ICX_POR_EXTRACTOR.gProgramId, SYSDATE);

Line 2344: ICX_POR_EXTRACTOR.gUserId, SYSDATE,

2340: gITManufacturerPartNums(i), gITDescriptions(i), NULL, NULL,
2341: gITPictures(i), gITPictureURLs(i), gITPictures(i), NULL, NULL,
2342: NULL, NULL, NULL, NULL,
2343: NULL, ICX_POR_EXTRACTOR.gLoginId,
2344: ICX_POR_EXTRACTOR.gUserId, SYSDATE,
2345: ICX_POR_EXTRACTOR.gUserId, SYSDATE, ICX_POR_EXTRACTOR.gRequestId,
2346: ICX_POR_EXTRACTOR.gProgramApplicationId,
2347: ICX_POR_EXTRACTOR.gProgramId, SYSDATE);
2348: ELSE

Line 2345: ICX_POR_EXTRACTOR.gUserId, SYSDATE, ICX_POR_EXTRACTOR.gRequestId,

2341: gITPictures(i), gITPictureURLs(i), gITPictures(i), NULL, NULL,
2342: NULL, NULL, NULL, NULL,
2343: NULL, ICX_POR_EXTRACTOR.gLoginId,
2344: ICX_POR_EXTRACTOR.gUserId, SYSDATE,
2345: ICX_POR_EXTRACTOR.gUserId, SYSDATE, ICX_POR_EXTRACTOR.gRequestId,
2346: ICX_POR_EXTRACTOR.gProgramApplicationId,
2347: ICX_POR_EXTRACTOR.gProgramId, SYSDATE);
2348: ELSE
2349: FORALL i IN 1..gITRtItemIds.COUNT

Line 2346: ICX_POR_EXTRACTOR.gProgramApplicationId,

2342: NULL, NULL, NULL, NULL,
2343: NULL, ICX_POR_EXTRACTOR.gLoginId,
2344: ICX_POR_EXTRACTOR.gUserId, SYSDATE,
2345: ICX_POR_EXTRACTOR.gUserId, SYSDATE, ICX_POR_EXTRACTOR.gRequestId,
2346: ICX_POR_EXTRACTOR.gProgramApplicationId,
2347: ICX_POR_EXTRACTOR.gProgramId, SYSDATE);
2348: ELSE
2349: FORALL i IN 1..gITRtItemIds.COUNT
2350: INSERT INTO icx_cat_items_tlp

Line 2347: ICX_POR_EXTRACTOR.gProgramId, SYSDATE);

2343: NULL, ICX_POR_EXTRACTOR.gLoginId,
2344: ICX_POR_EXTRACTOR.gUserId, SYSDATE,
2345: ICX_POR_EXTRACTOR.gUserId, SYSDATE, ICX_POR_EXTRACTOR.gRequestId,
2346: ICX_POR_EXTRACTOR.gProgramApplicationId,
2347: ICX_POR_EXTRACTOR.gProgramId, SYSDATE);
2348: ELSE
2349: FORALL i IN 1..gITRtItemIds.COUNT
2350: INSERT INTO icx_cat_items_tlp
2351: (rt_item_id, language, org_id,

Line 2371: NULL, ICX_POR_EXTRACTOR.gLoginId,

2367: gITSuppliers(i), gITSupplierPartNums(i), '##NULL##', gITManufacturers(i),
2368: gITManufacturerPartNums(i), gITDescriptions(i), NULL, NULL,
2369: NULL, NULL,
2370: NULL, NULL, NULL, NULL,
2371: NULL, ICX_POR_EXTRACTOR.gLoginId,
2372: ICX_POR_EXTRACTOR.gUserId, SYSDATE,
2373: ICX_POR_EXTRACTOR.gUserId, SYSDATE, ICX_POR_EXTRACTOR.gRequestId,
2374: ICX_POR_EXTRACTOR.gProgramApplicationId,
2375: ICX_POR_EXTRACTOR.gProgramId, SYSDATE);

Line 2372: ICX_POR_EXTRACTOR.gUserId, SYSDATE,

2368: gITManufacturerPartNums(i), gITDescriptions(i), NULL, NULL,
2369: NULL, NULL,
2370: NULL, NULL, NULL, NULL,
2371: NULL, ICX_POR_EXTRACTOR.gLoginId,
2372: ICX_POR_EXTRACTOR.gUserId, SYSDATE,
2373: ICX_POR_EXTRACTOR.gUserId, SYSDATE, ICX_POR_EXTRACTOR.gRequestId,
2374: ICX_POR_EXTRACTOR.gProgramApplicationId,
2375: ICX_POR_EXTRACTOR.gProgramId, SYSDATE);
2376: END IF;

Line 2373: ICX_POR_EXTRACTOR.gUserId, SYSDATE, ICX_POR_EXTRACTOR.gRequestId,

2369: NULL, NULL,
2370: NULL, NULL, NULL, NULL,
2371: NULL, ICX_POR_EXTRACTOR.gLoginId,
2372: ICX_POR_EXTRACTOR.gUserId, SYSDATE,
2373: ICX_POR_EXTRACTOR.gUserId, SYSDATE, ICX_POR_EXTRACTOR.gRequestId,
2374: ICX_POR_EXTRACTOR.gProgramApplicationId,
2375: ICX_POR_EXTRACTOR.gProgramId, SYSDATE);
2376: END IF;
2377:

Line 2374: ICX_POR_EXTRACTOR.gProgramApplicationId,

2370: NULL, NULL, NULL, NULL,
2371: NULL, ICX_POR_EXTRACTOR.gLoginId,
2372: ICX_POR_EXTRACTOR.gUserId, SYSDATE,
2373: ICX_POR_EXTRACTOR.gUserId, SYSDATE, ICX_POR_EXTRACTOR.gRequestId,
2374: ICX_POR_EXTRACTOR.gProgramApplicationId,
2375: ICX_POR_EXTRACTOR.gProgramId, SYSDATE);
2376: END IF;
2377:
2378: clearTables(xActionMode);

Line 2375: ICX_POR_EXTRACTOR.gProgramId, SYSDATE);

2371: NULL, ICX_POR_EXTRACTOR.gLoginId,
2372: ICX_POR_EXTRACTOR.gUserId, SYSDATE,
2373: ICX_POR_EXTRACTOR.gUserId, SYSDATE, ICX_POR_EXTRACTOR.gRequestId,
2374: ICX_POR_EXTRACTOR.gProgramApplicationId,
2375: ICX_POR_EXTRACTOR.gProgramId, SYSDATE);
2376: END IF;
2377:
2378: clearTables(xActionMode);
2379:

Line 2404: last_updated_by = ICX_POR_EXTRACTOR.gUserId,

2400: supplier_part_auxid = '##NULL##',
2401: --manufacturer = gUTManufacturers(i),
2402: --manufacturer_part_num = gUTManufacturerPartNums(i),
2403: thumbnail_image = gUTPictures(i),
2404: last_updated_by = ICX_POR_EXTRACTOR.gUserId,
2405: last_update_date = SYSDATE,
2406: last_update_login = ICX_POR_EXTRACTOR.gLoginId,
2407: request_id = ICX_POR_EXTRACTOR.gRequestId,
2408: program_application_id = ICX_POR_EXTRACTOR.gProgramApplicationId,

Line 2406: last_update_login = ICX_POR_EXTRACTOR.gLoginId,

2402: --manufacturer_part_num = gUTManufacturerPartNums(i),
2403: thumbnail_image = gUTPictures(i),
2404: last_updated_by = ICX_POR_EXTRACTOR.gUserId,
2405: last_update_date = SYSDATE,
2406: last_update_login = ICX_POR_EXTRACTOR.gLoginId,
2407: request_id = ICX_POR_EXTRACTOR.gRequestId,
2408: program_application_id = ICX_POR_EXTRACTOR.gProgramApplicationId,
2409: program_id = ICX_POR_EXTRACTOR.gProgramId,
2410: program_update_date = SYSDATE

Line 2407: request_id = ICX_POR_EXTRACTOR.gRequestId,

2403: thumbnail_image = gUTPictures(i),
2404: last_updated_by = ICX_POR_EXTRACTOR.gUserId,
2405: last_update_date = SYSDATE,
2406: last_update_login = ICX_POR_EXTRACTOR.gLoginId,
2407: request_id = ICX_POR_EXTRACTOR.gRequestId,
2408: program_application_id = ICX_POR_EXTRACTOR.gProgramApplicationId,
2409: program_id = ICX_POR_EXTRACTOR.gProgramId,
2410: program_update_date = SYSDATE
2411: WHERE rt_item_id = gUTRtItemIds(i)

Line 2408: program_application_id = ICX_POR_EXTRACTOR.gProgramApplicationId,

2404: last_updated_by = ICX_POR_EXTRACTOR.gUserId,
2405: last_update_date = SYSDATE,
2406: last_update_login = ICX_POR_EXTRACTOR.gLoginId,
2407: request_id = ICX_POR_EXTRACTOR.gRequestId,
2408: program_application_id = ICX_POR_EXTRACTOR.gProgramApplicationId,
2409: program_id = ICX_POR_EXTRACTOR.gProgramId,
2410: program_update_date = SYSDATE
2411: WHERE rt_item_id = gUTRtItemIds(i)
2412: AND language = gUTLanguages(i);

Line 2409: program_id = ICX_POR_EXTRACTOR.gProgramId,

2405: last_update_date = SYSDATE,
2406: last_update_login = ICX_POR_EXTRACTOR.gLoginId,
2407: request_id = ICX_POR_EXTRACTOR.gRequestId,
2408: program_application_id = ICX_POR_EXTRACTOR.gProgramApplicationId,
2409: program_id = ICX_POR_EXTRACTOR.gProgramId,
2410: program_update_date = SYSDATE
2411: WHERE rt_item_id = gUTRtItemIds(i)
2412: AND language = gUTLanguages(i);
2413: ELSE

Line 2425: last_updated_by = ICX_POR_EXTRACTOR.gUserId,

2421: description = gUTDescriptions(i),
2422: supplier_part_auxid = '##NULL##',
2423: --manufacturer = gUTManufacturers(i),
2424: --manufacturer_part_num = gUTManufacturerPartNums(i),
2425: last_updated_by = ICX_POR_EXTRACTOR.gUserId,
2426: last_update_date = SYSDATE,
2427: last_update_login = ICX_POR_EXTRACTOR.gLoginId,
2428: request_id = ICX_POR_EXTRACTOR.gRequestId,
2429: program_application_id = ICX_POR_EXTRACTOR.gProgramApplicationId,

Line 2427: last_update_login = ICX_POR_EXTRACTOR.gLoginId,

2423: --manufacturer = gUTManufacturers(i),
2424: --manufacturer_part_num = gUTManufacturerPartNums(i),
2425: last_updated_by = ICX_POR_EXTRACTOR.gUserId,
2426: last_update_date = SYSDATE,
2427: last_update_login = ICX_POR_EXTRACTOR.gLoginId,
2428: request_id = ICX_POR_EXTRACTOR.gRequestId,
2429: program_application_id = ICX_POR_EXTRACTOR.gProgramApplicationId,
2430: program_id = ICX_POR_EXTRACTOR.gProgramId,
2431: program_update_date = SYSDATE

Line 2428: request_id = ICX_POR_EXTRACTOR.gRequestId,

2424: --manufacturer_part_num = gUTManufacturerPartNums(i),
2425: last_updated_by = ICX_POR_EXTRACTOR.gUserId,
2426: last_update_date = SYSDATE,
2427: last_update_login = ICX_POR_EXTRACTOR.gLoginId,
2428: request_id = ICX_POR_EXTRACTOR.gRequestId,
2429: program_application_id = ICX_POR_EXTRACTOR.gProgramApplicationId,
2430: program_id = ICX_POR_EXTRACTOR.gProgramId,
2431: program_update_date = SYSDATE
2432: WHERE rt_item_id = gUTRtItemIds(i)

Line 2429: program_application_id = ICX_POR_EXTRACTOR.gProgramApplicationId,

2425: last_updated_by = ICX_POR_EXTRACTOR.gUserId,
2426: last_update_date = SYSDATE,
2427: last_update_login = ICX_POR_EXTRACTOR.gLoginId,
2428: request_id = ICX_POR_EXTRACTOR.gRequestId,
2429: program_application_id = ICX_POR_EXTRACTOR.gProgramApplicationId,
2430: program_id = ICX_POR_EXTRACTOR.gProgramId,
2431: program_update_date = SYSDATE
2432: WHERE rt_item_id = gUTRtItemIds(i)
2433: AND language = gUTLanguages(i);

Line 2430: program_id = ICX_POR_EXTRACTOR.gProgramId,

2426: last_update_date = SYSDATE,
2427: last_update_login = ICX_POR_EXTRACTOR.gLoginId,
2428: request_id = ICX_POR_EXTRACTOR.gRequestId,
2429: program_application_id = ICX_POR_EXTRACTOR.gProgramApplicationId,
2430: program_id = ICX_POR_EXTRACTOR.gProgramId,
2431: program_update_date = SYSDATE
2432: WHERE rt_item_id = gUTRtItemIds(i)
2433: AND language = gUTLanguages(i);
2434: END IF;

Line 2455: ICX_POR_EXTRACTOR.gLoginId, ICX_POR_EXTRACTOR.gUserId, SYSDATE,

2451: created_by, creation_date, request_id,
2452: program_application_id, program_id, program_update_date)
2453: VALUES
2454: (gICRtItemIds(i), gICRtCategoryIds(i),
2455: ICX_POR_EXTRACTOR.gLoginId, ICX_POR_EXTRACTOR.gUserId, SYSDATE,
2456: ICX_POR_EXTRACTOR.gUserId, SYSDATE, ICX_POR_EXTRACTOR.gRequestId,
2457: ICX_POR_EXTRACTOR.gProgramApplicationId,
2458: ICX_POR_EXTRACTOR.gProgramId, SYSDATE);
2459:

Line 2456: ICX_POR_EXTRACTOR.gUserId, SYSDATE, ICX_POR_EXTRACTOR.gRequestId,

2452: program_application_id, program_id, program_update_date)
2453: VALUES
2454: (gICRtItemIds(i), gICRtCategoryIds(i),
2455: ICX_POR_EXTRACTOR.gLoginId, ICX_POR_EXTRACTOR.gUserId, SYSDATE,
2456: ICX_POR_EXTRACTOR.gUserId, SYSDATE, ICX_POR_EXTRACTOR.gRequestId,
2457: ICX_POR_EXTRACTOR.gProgramApplicationId,
2458: ICX_POR_EXTRACTOR.gProgramId, SYSDATE);
2459:
2460: clearTables(xActionMode);

Line 2457: ICX_POR_EXTRACTOR.gProgramApplicationId,

2453: VALUES
2454: (gICRtItemIds(i), gICRtCategoryIds(i),
2455: ICX_POR_EXTRACTOR.gLoginId, ICX_POR_EXTRACTOR.gUserId, SYSDATE,
2456: ICX_POR_EXTRACTOR.gUserId, SYSDATE, ICX_POR_EXTRACTOR.gRequestId,
2457: ICX_POR_EXTRACTOR.gProgramApplicationId,
2458: ICX_POR_EXTRACTOR.gProgramId, SYSDATE);
2459:
2460: clearTables(xActionMode);
2461:

Line 2458: ICX_POR_EXTRACTOR.gProgramId, SYSDATE);

2454: (gICRtItemIds(i), gICRtCategoryIds(i),
2455: ICX_POR_EXTRACTOR.gLoginId, ICX_POR_EXTRACTOR.gUserId, SYSDATE,
2456: ICX_POR_EXTRACTOR.gUserId, SYSDATE, ICX_POR_EXTRACTOR.gRequestId,
2457: ICX_POR_EXTRACTOR.gProgramApplicationId,
2458: ICX_POR_EXTRACTOR.gProgramId, SYSDATE);
2459:
2460: clearTables(xActionMode);
2461:
2462: xErrLoc := 320;

Line 2474: last_updated_by = ICX_POR_EXTRACTOR.gUserId,

2470: END IF;
2471: FORALL i IN 1..gUCRtItemIds.COUNT
2472: UPDATE icx_cat_category_items
2473: SET rt_category_id = gUCRtCategoryIds(i),
2474: last_updated_by = ICX_POR_EXTRACTOR.gUserId,
2475: last_update_date = SYSDATE,
2476: last_update_login = ICX_POR_EXTRACTOR.gLoginId,
2477: request_id = ICX_POR_EXTRACTOR.gRequestId,
2478: program_application_id = ICX_POR_EXTRACTOR.gProgramApplicationId,

Line 2476: last_update_login = ICX_POR_EXTRACTOR.gLoginId,

2472: UPDATE icx_cat_category_items
2473: SET rt_category_id = gUCRtCategoryIds(i),
2474: last_updated_by = ICX_POR_EXTRACTOR.gUserId,
2475: last_update_date = SYSDATE,
2476: last_update_login = ICX_POR_EXTRACTOR.gLoginId,
2477: request_id = ICX_POR_EXTRACTOR.gRequestId,
2478: program_application_id = ICX_POR_EXTRACTOR.gProgramApplicationId,
2479: program_id = ICX_POR_EXTRACTOR.gProgramId,
2480: program_update_date = SYSDATE

Line 2477: request_id = ICX_POR_EXTRACTOR.gRequestId,

2473: SET rt_category_id = gUCRtCategoryIds(i),
2474: last_updated_by = ICX_POR_EXTRACTOR.gUserId,
2475: last_update_date = SYSDATE,
2476: last_update_login = ICX_POR_EXTRACTOR.gLoginId,
2477: request_id = ICX_POR_EXTRACTOR.gRequestId,
2478: program_application_id = ICX_POR_EXTRACTOR.gProgramApplicationId,
2479: program_id = ICX_POR_EXTRACTOR.gProgramId,
2480: program_update_date = SYSDATE
2481: WHERE rt_item_id = gUCRtItemIds(i)

Line 2478: program_application_id = ICX_POR_EXTRACTOR.gProgramApplicationId,

2474: last_updated_by = ICX_POR_EXTRACTOR.gUserId,
2475: last_update_date = SYSDATE,
2476: last_update_login = ICX_POR_EXTRACTOR.gLoginId,
2477: request_id = ICX_POR_EXTRACTOR.gRequestId,
2478: program_application_id = ICX_POR_EXTRACTOR.gProgramApplicationId,
2479: program_id = ICX_POR_EXTRACTOR.gProgramId,
2480: program_update_date = SYSDATE
2481: WHERE rt_item_id = gUCRtItemIds(i)
2482: AND rt_category_id = gUCOldRtCategoryIds(i);

Line 2479: program_id = ICX_POR_EXTRACTOR.gProgramId,

2475: last_update_date = SYSDATE,
2476: last_update_login = ICX_POR_EXTRACTOR.gLoginId,
2477: request_id = ICX_POR_EXTRACTOR.gRequestId,
2478: program_application_id = ICX_POR_EXTRACTOR.gProgramApplicationId,
2479: program_id = ICX_POR_EXTRACTOR.gProgramId,
2480: program_update_date = SYSDATE
2481: WHERE rt_item_id = gUCRtItemIds(i)
2482: AND rt_category_id = gUCOldRtCategoryIds(i);
2483:

Line 2508: ICX_POR_EXTRACTOR.gLoginId, ICX_POR_EXTRACTOR.gUserId, SYSDATE,

2504: VALUES
2505: -- gIERtItemIds(i), language_code, gIEOrgIds(i),
2506: (gIERtItemIds(i), gIELanguages(i), gIEOrgIds(i),
2507: gIERtCategoryIds(i), 'Y',
2508: ICX_POR_EXTRACTOR.gLoginId, ICX_POR_EXTRACTOR.gUserId, SYSDATE,
2509: ICX_POR_EXTRACTOR.gUserId, SYSDATE, ICX_POR_EXTRACTOR.gRequestId,
2510: ICX_POR_EXTRACTOR.gProgramApplicationId,
2511: ICX_POR_EXTRACTOR.gProgramId, SYSDATE);
2512: -- bug 2925403

Line 2509: ICX_POR_EXTRACTOR.gUserId, SYSDATE, ICX_POR_EXTRACTOR.gRequestId,

2505: -- gIERtItemIds(i), language_code, gIEOrgIds(i),
2506: (gIERtItemIds(i), gIELanguages(i), gIEOrgIds(i),
2507: gIERtCategoryIds(i), 'Y',
2508: ICX_POR_EXTRACTOR.gLoginId, ICX_POR_EXTRACTOR.gUserId, SYSDATE,
2509: ICX_POR_EXTRACTOR.gUserId, SYSDATE, ICX_POR_EXTRACTOR.gRequestId,
2510: ICX_POR_EXTRACTOR.gProgramApplicationId,
2511: ICX_POR_EXTRACTOR.gProgramId, SYSDATE);
2512: -- bug 2925403
2513: -- FROM fnd_languages

Line 2510: ICX_POR_EXTRACTOR.gProgramApplicationId,

2506: (gIERtItemIds(i), gIELanguages(i), gIEOrgIds(i),
2507: gIERtCategoryIds(i), 'Y',
2508: ICX_POR_EXTRACTOR.gLoginId, ICX_POR_EXTRACTOR.gUserId, SYSDATE,
2509: ICX_POR_EXTRACTOR.gUserId, SYSDATE, ICX_POR_EXTRACTOR.gRequestId,
2510: ICX_POR_EXTRACTOR.gProgramApplicationId,
2511: ICX_POR_EXTRACTOR.gProgramId, SYSDATE);
2512: -- bug 2925403
2513: -- FROM fnd_languages
2514: -- WHERE installed_flag IN ('B', 'I');

Line 2511: ICX_POR_EXTRACTOR.gProgramId, SYSDATE);

2507: gIERtCategoryIds(i), 'Y',
2508: ICX_POR_EXTRACTOR.gLoginId, ICX_POR_EXTRACTOR.gUserId, SYSDATE,
2509: ICX_POR_EXTRACTOR.gUserId, SYSDATE, ICX_POR_EXTRACTOR.gRequestId,
2510: ICX_POR_EXTRACTOR.gProgramApplicationId,
2511: ICX_POR_EXTRACTOR.gProgramId, SYSDATE);
2512: -- bug 2925403
2513: -- FROM fnd_languages
2514: -- WHERE installed_flag IN ('B', 'I');
2515:

Line 2530: last_updated_by = ICX_POR_EXTRACTOR.gUserId,

2526: END IF;
2527: FORALL i IN 1..gUERtItemIds.COUNT
2528: UPDATE icx_cat_ext_items_tlp
2529: SET rt_category_id = gUERtCategoryIds(i),
2530: last_updated_by = ICX_POR_EXTRACTOR.gUserId,
2531: last_update_date = SYSDATE,
2532: last_update_login = ICX_POR_EXTRACTOR.gLoginId,
2533: request_id = ICX_POR_EXTRACTOR.gRequestId,
2534: program_application_id = ICX_POR_EXTRACTOR.gProgramApplicationId,

Line 2532: last_update_login = ICX_POR_EXTRACTOR.gLoginId,

2528: UPDATE icx_cat_ext_items_tlp
2529: SET rt_category_id = gUERtCategoryIds(i),
2530: last_updated_by = ICX_POR_EXTRACTOR.gUserId,
2531: last_update_date = SYSDATE,
2532: last_update_login = ICX_POR_EXTRACTOR.gLoginId,
2533: request_id = ICX_POR_EXTRACTOR.gRequestId,
2534: program_application_id = ICX_POR_EXTRACTOR.gProgramApplicationId,
2535: program_id = ICX_POR_EXTRACTOR.gProgramId,
2536: program_update_date = SYSDATE

Line 2533: request_id = ICX_POR_EXTRACTOR.gRequestId,

2529: SET rt_category_id = gUERtCategoryIds(i),
2530: last_updated_by = ICX_POR_EXTRACTOR.gUserId,
2531: last_update_date = SYSDATE,
2532: last_update_login = ICX_POR_EXTRACTOR.gLoginId,
2533: request_id = ICX_POR_EXTRACTOR.gRequestId,
2534: program_application_id = ICX_POR_EXTRACTOR.gProgramApplicationId,
2535: program_id = ICX_POR_EXTRACTOR.gProgramId,
2536: program_update_date = SYSDATE
2537: WHERE rt_item_id = gUERtItemIds(i)

Line 2534: program_application_id = ICX_POR_EXTRACTOR.gProgramApplicationId,

2530: last_updated_by = ICX_POR_EXTRACTOR.gUserId,
2531: last_update_date = SYSDATE,
2532: last_update_login = ICX_POR_EXTRACTOR.gLoginId,
2533: request_id = ICX_POR_EXTRACTOR.gRequestId,
2534: program_application_id = ICX_POR_EXTRACTOR.gProgramApplicationId,
2535: program_id = ICX_POR_EXTRACTOR.gProgramId,
2536: program_update_date = SYSDATE
2537: WHERE rt_item_id = gUERtItemIds(i)
2538: -- bug 2925403

Line 2535: program_id = ICX_POR_EXTRACTOR.gProgramId,

2531: last_update_date = SYSDATE,
2532: last_update_login = ICX_POR_EXTRACTOR.gLoginId,
2533: request_id = ICX_POR_EXTRACTOR.gRequestId,
2534: program_application_id = ICX_POR_EXTRACTOR.gProgramApplicationId,
2535: program_id = ICX_POR_EXTRACTOR.gProgramId,
2536: program_update_date = SYSDATE
2537: WHERE rt_item_id = gUERtItemIds(i)
2538: -- bug 2925403
2539: AND language = gUELanguages(i)

Line 2609: last_updated_by = ICX_POR_EXTRACTOR.gUserId,

2605: line_type_id = gUPGALineTypeIds(i),
2606: rate_type = gUPGARateTypes(i),
2607: rate_date = gUPGARateDates(i),
2608: rate = gUPGARates(i),
2609: last_updated_by = ICX_POR_EXTRACTOR.gUserId,
2610: last_update_date = SYSDATE,
2611: last_update_login = ICX_POR_EXTRACTOR.gLoginId,
2612: -- Bug#3352834
2613: request_id = ICX_POR_EXT_ITEM.CURRENT_REQUEST_ID,

Line 2611: last_update_login = ICX_POR_EXTRACTOR.gLoginId,

2607: rate_date = gUPGARateDates(i),
2608: rate = gUPGARates(i),
2609: last_updated_by = ICX_POR_EXTRACTOR.gUserId,
2610: last_update_date = SYSDATE,
2611: last_update_login = ICX_POR_EXTRACTOR.gLoginId,
2612: -- Bug#3352834
2613: request_id = ICX_POR_EXT_ITEM.CURRENT_REQUEST_ID,
2614: program_application_id = ICX_POR_EXTRACTOR.gProgramApplicationId,
2615: program_id = ICX_POR_EXTRACTOR.gProgramId,

Line 2614: program_application_id = ICX_POR_EXTRACTOR.gProgramApplicationId,

2610: last_update_date = SYSDATE,
2611: last_update_login = ICX_POR_EXTRACTOR.gLoginId,
2612: -- Bug#3352834
2613: request_id = ICX_POR_EXT_ITEM.CURRENT_REQUEST_ID,
2614: program_application_id = ICX_POR_EXTRACTOR.gProgramApplicationId,
2615: program_id = ICX_POR_EXTRACTOR.gProgramId,
2616: program_update_date = SYSDATE
2617: WHERE contract_id = gUPGAContractIds(i)
2618: AND contract_line_id = gUPGAContractLineIds(i)

Line 2615: program_id = ICX_POR_EXTRACTOR.gProgramId,

2611: last_update_login = ICX_POR_EXTRACTOR.gLoginId,
2612: -- Bug#3352834
2613: request_id = ICX_POR_EXT_ITEM.CURRENT_REQUEST_ID,
2614: program_application_id = ICX_POR_EXTRACTOR.gProgramApplicationId,
2615: program_id = ICX_POR_EXTRACTOR.gProgramId,
2616: program_update_date = SYSDATE
2617: WHERE contract_id = gUPGAContractIds(i)
2618: AND contract_line_id = gUPGAContractLineIds(i)
2619: -- bug 3298502 : Enabled Org Ids

Line 2682: NULL, ICX_POR_EXTRACTOR.gLoginId,

2678: gIPGALineTypeIds(i),
2679: gIPGARateTypes(i), gIPGARateDates(i), gIPGARates(i),
2680: -- Use local_rt_item_id to store local rt_item_id
2681: gIPGALocalRtItemIds(i),
2682: NULL, ICX_POR_EXTRACTOR.gLoginId,
2683: ICX_POR_EXTRACTOR.gUserId, SYSDATE,
2684: ICX_POR_EXTRACTOR.gUserId, SYSDATE,
2685: -- Bug#3352834
2686: ICX_POR_EXT_ITEM.CURRENT_REQUEST_ID,

Line 2683: ICX_POR_EXTRACTOR.gUserId, SYSDATE,

2679: gIPGARateTypes(i), gIPGARateDates(i), gIPGARates(i),
2680: -- Use local_rt_item_id to store local rt_item_id
2681: gIPGALocalRtItemIds(i),
2682: NULL, ICX_POR_EXTRACTOR.gLoginId,
2683: ICX_POR_EXTRACTOR.gUserId, SYSDATE,
2684: ICX_POR_EXTRACTOR.gUserId, SYSDATE,
2685: -- Bug#3352834
2686: ICX_POR_EXT_ITEM.CURRENT_REQUEST_ID,
2687: ICX_POR_EXTRACTOR.gProgramApplicationId,

Line 2684: ICX_POR_EXTRACTOR.gUserId, SYSDATE,

2680: -- Use local_rt_item_id to store local rt_item_id
2681: gIPGALocalRtItemIds(i),
2682: NULL, ICX_POR_EXTRACTOR.gLoginId,
2683: ICX_POR_EXTRACTOR.gUserId, SYSDATE,
2684: ICX_POR_EXTRACTOR.gUserId, SYSDATE,
2685: -- Bug#3352834
2686: ICX_POR_EXT_ITEM.CURRENT_REQUEST_ID,
2687: ICX_POR_EXTRACTOR.gProgramApplicationId,
2688: ICX_POR_EXTRACTOR.gProgramId, SYSDATE);

Line 2687: ICX_POR_EXTRACTOR.gProgramApplicationId,

2683: ICX_POR_EXTRACTOR.gUserId, SYSDATE,
2684: ICX_POR_EXTRACTOR.gUserId, SYSDATE,
2685: -- Bug#3352834
2686: ICX_POR_EXT_ITEM.CURRENT_REQUEST_ID,
2687: ICX_POR_EXTRACTOR.gProgramApplicationId,
2688: ICX_POR_EXTRACTOR.gProgramId, SYSDATE);
2689:
2690: FORALL i IN 1..gIPGARtItemIds.COUNT
2691: UPDATE icx_cat_items_tlp

Line 2688: ICX_POR_EXTRACTOR.gProgramId, SYSDATE);

2684: ICX_POR_EXTRACTOR.gUserId, SYSDATE,
2685: -- Bug#3352834
2686: ICX_POR_EXT_ITEM.CURRENT_REQUEST_ID,
2687: ICX_POR_EXTRACTOR.gProgramApplicationId,
2688: ICX_POR_EXTRACTOR.gProgramId, SYSDATE);
2689:
2690: FORALL i IN 1..gIPGARtItemIds.COUNT
2691: UPDATE icx_cat_items_tlp
2692: SET request_id = ICX_POR_EXTRACTOR.gRequestId

Line 2692: SET request_id = ICX_POR_EXTRACTOR.gRequestId

2688: ICX_POR_EXTRACTOR.gProgramId, SYSDATE);
2689:
2690: FORALL i IN 1..gIPGARtItemIds.COUNT
2691: UPDATE icx_cat_items_tlp
2692: SET request_id = ICX_POR_EXTRACTOR.gRequestId
2693: WHERE rt_item_id = gIPGARtItemIds(i);
2694:
2695: clearTables(xActionMode);
2696:

Line 3281: ICX_POR_EXTRACTOR.gLoaderValue.load_contracts,

3277: END IF;
3278:
3279: IF ICX_POR_EXT_DIAG.isValidExtPrice(
3280: gCurrentPrice.document_type, gCurrentPrice.status,
3281: ICX_POR_EXTRACTOR.gLoaderValue.load_contracts,
3282: ICX_POR_EXTRACTOR.gLoaderValue.load_template_lines,
3283: ICX_POR_EXTRACTOR.gLoaderValue.load_item_master,
3284: ICX_POR_EXTRACTOR.gLoaderValue.load_internal_item) = 0
3285: THEN

Line 3282: ICX_POR_EXTRACTOR.gLoaderValue.load_template_lines,

3278:
3279: IF ICX_POR_EXT_DIAG.isValidExtPrice(
3280: gCurrentPrice.document_type, gCurrentPrice.status,
3281: ICX_POR_EXTRACTOR.gLoaderValue.load_contracts,
3282: ICX_POR_EXTRACTOR.gLoaderValue.load_template_lines,
3283: ICX_POR_EXTRACTOR.gLoaderValue.load_item_master,
3284: ICX_POR_EXTRACTOR.gLoaderValue.load_internal_item) = 0
3285: THEN
3286: xErrLoc := 150;

Line 3283: ICX_POR_EXTRACTOR.gLoaderValue.load_item_master,

3279: IF ICX_POR_EXT_DIAG.isValidExtPrice(
3280: gCurrentPrice.document_type, gCurrentPrice.status,
3281: ICX_POR_EXTRACTOR.gLoaderValue.load_contracts,
3282: ICX_POR_EXTRACTOR.gLoaderValue.load_template_lines,
3283: ICX_POR_EXTRACTOR.gLoaderValue.load_item_master,
3284: ICX_POR_EXTRACTOR.gLoaderValue.load_internal_item) = 0
3285: THEN
3286: xErrLoc := 150;
3287: -- Report analysis message here

Line 3284: ICX_POR_EXTRACTOR.gLoaderValue.load_internal_item) = 0

3280: gCurrentPrice.document_type, gCurrentPrice.status,
3281: ICX_POR_EXTRACTOR.gLoaderValue.load_contracts,
3282: ICX_POR_EXTRACTOR.gLoaderValue.load_template_lines,
3283: ICX_POR_EXTRACTOR.gLoaderValue.load_item_master,
3284: ICX_POR_EXTRACTOR.gLoaderValue.load_internal_item) = 0
3285: THEN
3286: xErrLoc := 150;
3287: -- Report analysis message here
3288: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.ANLYS_LEVEL THEN

Line 3681: gUBJobNumbers(xIndex) := ICX_POR_EXTRACTOR.gJobNum;

3677: xIndex := gUBRtItemIds.COUNT + 1;
3678: gUBRtItemIds(xIndex) := gCurrentPrice.rt_item_id;
3679: gUBInternalItemNums(xIndex) := gCurrentPrice.internal_item_num;
3680: gUBExtractorUpdatedFlags(xIndex) := 'Y';
3681: gUBJobNumbers(xIndex) := ICX_POR_EXTRACTOR.gJobNum;
3682: xErrLoc := 400;
3683: EXCEPTION
3684: when others then
3685: ICX_POR_EXT_UTL.extRollback;

Line 3775: -- AND xLanguage = ICX_POR_EXTRACTOR.gBaseLang

3771: END IF;
3772: IF (gCurrentPrice.document_type NOT IN (PURCHASING_ITEM_TYPE,
3773: INTERNAL_ITEM_TYPE)
3774: /*Bug#5909923 Start - Wrong description shown for installed langauge*/
3775: -- AND xLanguage = ICX_POR_EXTRACTOR.gBaseLang
3776: /*Bug#5909923 End*/
3777: )
3778: THEN
3779: -- Purchasing/Internal Template, Contract, ASL

Line 3797: IF ICX_POR_EXTRACTOR.gLoaderValue.load_onetimeitems_all_langs = 'Y' THEN

3793: -- Bug # 3991430
3794: -- New column is added in the ICX_POR_LOADER_VALUES table to extract one time item in all the installed languages
3795: xString := 'SELECT language_code ' || 'FROM fnd_languages ' || 'WHERE installed_flag IN (''B''';
3796:
3797: IF ICX_POR_EXTRACTOR.gLoaderValue.load_onetimeitems_all_langs = 'Y' THEN
3798: xString := xString || ', ''I'')';
3799: ELSE
3800: xString := xString || ')';
3801: END IF;

Line 3814: gITLanguages(xIndex) := xLanguage; -- ICX_POR_EXTRACTOR.gBaseLang;

3810:
3811: gTransactionCount := gTransactionCount + 1;
3812: xIndex := gITRtItemIds.COUNT + 1;
3813: gITRtItemIds(xIndex) := gCurrentPrice.rt_item_id;
3814: gITLanguages(xIndex) := xLanguage; -- ICX_POR_EXTRACTOR.gBaseLang;
3815: gITOrgIds(xIndex) := gCurrentPrice.org_id;
3816: gITItemSourceTypes(xIndex) := gCurrentPrice.item_source_type;
3817: gITSearchTypes(xIndex) := gCurrentPrice.item_search_type;
3818: gITPrimaryCategoryIds(xIndex) := gCurrentPrice.primary_category_id;

Line 3961: xLanguage = ICX_POR_EXTRACTOR.gBaseLang)

3957: gUTPrimaryCategoryNames(xIndex) := xCategoryName;
3958: gUTInternalItemNums(xIndex) := gCurrentPrice.internal_item_num;
3959: IF (gCurrentPrice.document_type NOT IN (PURCHASING_ITEM_TYPE,
3960: INTERNAL_ITEM_TYPE) AND
3961: xLanguage = ICX_POR_EXTRACTOR.gBaseLang)
3962: THEN
3963: -- Purchasing/Internal Template, Contract, ASL
3964: xDescription := gCurrentPrice.description;
3965: END IF;

Line 3985: IF ICX_POR_EXTRACTOR.gLoaderValue.load_onetimeitems_all_langs = 'Y' THEN

3981: 'f.language_code = i.language(+) AND ' ||
3982: 'i.rt_item_id(+) = :rt_item_id AND ' ||
3983: 'f.installed_flag IN (''B''';
3984:
3985: IF ICX_POR_EXTRACTOR.gLoaderValue.load_onetimeitems_all_langs = 'Y' THEN
3986: xString := xString || ', ''I'')';
3987: ELSE
3988: xString := xString || ')';
3989: END IF;

Line 4040: gUTLanguages(xIndex) := xLanguage; -- ICX_POR_EXTRACTOR.gBaseLang;

4036: xErrLoc := 320;
4037: gTransactionCount := gTransactionCount + 1;
4038: xIndex := gUTRtItemIds.COUNT + 1;
4039: gUTRtItemIds(xIndex) := gCurrentPrice.rt_item_id;
4040: gUTLanguages(xIndex) := xLanguage; -- ICX_POR_EXTRACTOR.gBaseLang;
4041: gUTItemSourceTypes(xIndex) := gCurrentPrice.item_source_type;
4042: gUTSearchTypes(xIndex) := gCurrentPrice.item_search_type;
4043: gUTPrimaryCategoryIds(xIndex) := gCurrentPrice.primary_category_id;
4044: gUTPrimaryCategoryNames(xIndex) := gCurrentPrice.primary_category_name;

Line 4136: IF ICX_POR_EXTRACTOR.gLoaderValue.load_onetimeitems_all_langs = 'Y' THEN

4132: 'SELECT language_code ' ||
4133: 'FROM fnd_languages ' ||
4134: 'WHERE installed_flag IN (''B''';
4135:
4136: IF ICX_POR_EXTRACTOR.gLoaderValue.load_onetimeitems_all_langs = 'Y' THEN
4137: xString := xString || ', ''I'')';
4138: ELSE
4139: xString := xString || ')';
4140: END IF;

Line 4153: gIELanguages(xIndex) := xLanguage; -- ICX_POR_EXTRACTOR.gBaseLang;

4149: xErrLoc := 300;
4150: gTransactionCount := gTransactionCount + 1;
4151: xIndex := gIERtItemIds.COUNT + 1;
4152: gIERtItemIds(xIndex) := gCurrentPrice.rt_item_id;
4153: gIELanguages(xIndex) := xLanguage; -- ICX_POR_EXTRACTOR.gBaseLang;
4154: gIEOrgIds(xIndex) := gCurrentPrice.org_id;
4155: gIERtCategoryIds(xIndex) := gCurrentPrice.primary_category_id;
4156: END LOOP;
4157: xErrLoc := 320;

Line 4271: IF ICX_POR_EXTRACTOR.gLoaderValue.load_onetimeitems_all_langs = 'Y' THEN

4267: 'f.language_code = i.language(+) AND ' ||
4268: 'i.rt_item_id(+) = :rt_item_id AND ' ||
4269: 'f.installed_flag IN (''B''';
4270:
4271: IF ICX_POR_EXTRACTOR.gLoaderValue.load_onetimeitems_all_langs = 'Y' THEN
4272: xString := xString || ', ''I'')';
4273: ELSE
4274: xString := xString || ')';
4275: END IF;

Line 4309: gUELanguages(xIndex) := xLanguage; --ICX_POR_EXTRACTOR.gBaseLang;

4305: gCurrentPrice.primary_category_id) THEN
4306: gTransactionCount := gTransactionCount + 1;
4307: xIndex := gUERtItemIds.COUNT + 1;
4308: gUERtItemIds(xIndex) := gCurrentPrice.rt_item_id;
4309: gUELanguages(xIndex) := xLanguage; --ICX_POR_EXTRACTOR.gBaseLang;
4310: gUERtCategoryIds(xIndex) := gCurrentPrice.primary_category_id;
4311: gUEOldRtCategoryIds(xIndex) :=
4312: gCurrentPrice.match_primary_category_id;
4313: END IF;

Line 4347: ICX_POR_EXTRACTOR.gInstalledLanguageCount;

4343: /* bug 2925403
4344: -- ICX_CAT_EXT_ITEMS_TLP
4345: xErrLoc := 300;
4346: gTransactionCount := gTransactionCount +
4347: ICX_POR_EXTRACTOR.gInstalledLanguageCount;
4348: xIndex := gIERtItemIds.COUNT + 1;
4349: gIERtItemIds(xIndex) := gCurrentPrice.rt_item_id;
4350: gIEOrgIds(xIndex) := gCurrentPrice.org_id;
4351: gIERtCategoryIds(xIndex) := gCurrentPrice.primary_category_id;

Line 4376: ICX_POR_EXTRACTOR.gInstalledLanguageCount;

4372: /* bug 2925403
4373: -- ICX_CAT_EXT_ITEMS_TLP
4374: xErrLoc := 300;
4375: gTransactionCount := gTransactionCount +
4376: ICX_POR_EXTRACTOR.gInstalledLanguageCount;
4377: xIndex := gUERtItemIds.COUNT + 1;
4378: gUERtItemIds(xIndex) := gCurrentPrice.rt_item_id;
4379: gUERtCategoryIds(xIndex) := gCurrentPrice.primary_category_id;
4380: gUEOldRtCategoryIds(xIndex) := gCurrentPrice.match_primary_category_id;

Line 5784: 'AND uomtl.language = ''' || ICX_POR_EXTRACTOR.gBaseLang || ''' ' ||

5780: 'AND DECODE(pltb.order_type_lookup_code, ' ||
5781: ' ''FIXED PRICE'', ''' || xOneValidUomCode || ''' , ' ||
5782: ' NVL(pl.unit_meas_lookup_code, prl.unit_meas_lookup_code) ) = ' ||
5783: ' uomtl.unit_of_measure ' ||
5784: 'AND uomtl.language = ''' || ICX_POR_EXTRACTOR.gBaseLang || ''' ' ||
5785: --Bug#2998604 'AND uomtl.source_lang = uomtl.language '||
5786: 'AND (prl.org_id is null and prh.org_id is null or '||
5787: 'prl.org_id = prh.org_id) '||
5788: 'AND prl.po_header_id = ph.po_header_id(+) '||

Line 6076: 'AND uomtl.language(+) = '''||ICX_POR_EXTRACTOR.gBaseLang||''' ' ||

6072: --FPJ FPSL Extractor Changes
6073: --For Fixed Price Service line types i.e
6074: --order_type_lookup_code='FIXED PRICE' pl.unit_meas_lookup_code will be null
6075: 'AND pl.unit_meas_lookup_code = uomtl.unit_of_measure(+) '||
6076: 'AND uomtl.language(+) = '''||ICX_POR_EXTRACTOR.gBaseLang||''' ' ||
6077: --Bug#2998604 'AND uomtl.source_lang = uomtl.language '||
6078: 'AND ph.type_lookup_code in (''BLANKET'', ''QUOTATION'') '||
6079: 'AND ph.currency_code = gc.currency_code '||
6080: 'AND (ph.org_id is null and fsp.org_id is null or '||

Line 6202: 'AND mitl.language = '''||ICX_POR_EXTRACTOR.gBaseLang||''' '||

6198: 'AND pasl.owning_organization_id = mi.organization_id '||
6199: 'AND fsp.set_of_books_id = gsb.set_of_books_id '||
6200: 'AND mi.inventory_item_id = mitl.inventory_item_id '||
6201: 'AND mi.organization_id = mitl.organization_id '||
6202: 'AND mitl.language = '''||ICX_POR_EXTRACTOR.gBaseLang||''' '||
6203: 'AND pasl.vendor_id = icx_pv.vendor_id '||
6204: 'AND pasl.vendor_site_id = pvs.vendor_site_id (+) ';
6205: ELSIF pType = 'ITEM' THEN
6206: xErrLoc := 280;

Line 6342: 'AND muom.language(+) = '''||ICX_POR_EXTRACTOR.gBaseLang||''' '||

6338: 'AND NOT (mi.replenish_to_order_flag = ''Y'' AND '||
6339: 'mi.base_item_id IS NOT NULL AND '||
6340: 'mi.auto_created_config_flag = ''Y'') '||
6341: 'AND mi.unit_of_issue = muom.unit_of_measure(+) '||
6342: 'AND muom.language(+) = '''||ICX_POR_EXTRACTOR.gBaseLang||''' '||
6343: 'AND mi.organization_id = fsp.inventory_organization_id '||
6344: 'AND fsp.set_of_books_id = gsb.set_of_books_id ';
6345: END IF;
6346:

Line 6368: 'AND ic1.language = '''||ICX_POR_EXTRACTOR.gBaseLang||''' ';

6364: 'WHERE ic1.key = ds1.category_key '||
6365: 'AND ds1.external_source_key = doc.category_key '||
6366: 'AND ds1.external_source = ''Oracle'' ' ||
6367: 'AND ic1.type = '||ICX_POR_EXT_CLASS.CATEGORY_TYPE||' '||
6368: 'AND ic1.language = '''||ICX_POR_EXTRACTOR.gBaseLang||''' ';
6369: IF pType = 'TEMPLATE' THEN
6370: xWhereStr := xWhereStr ||
6371: 'AND doc.template_id||''_tmpl'' = ds2.external_source_key (+) '||
6372: 'AND ds2.external_source (+) = ''Oracle'' ' ||

Line 6375: 'AND ic2.language (+) = '''||ICX_POR_EXTRACTOR.gBaseLang||''' '||

6371: 'AND doc.template_id||''_tmpl'' = ds2.external_source_key (+) '||
6372: 'AND ds2.external_source (+) = ''Oracle'' ' ||
6373: 'AND ds2.category_key = ic2.key (+) '||
6374: 'AND ic2.type (+) = '||ICX_POR_EXT_CLASS.TEMPLATE_HEADER_TYPE||' '||
6375: 'AND ic2.language (+) = '''||ICX_POR_EXTRACTOR.gBaseLang||''' '||
6376: 'AND doc.template_id = p.template_id (+) '||
6377: 'AND doc.template_line_id = p.template_line_id (+) ';
6378: ELSIF pType = 'CONTRACT' THEN
6379: xWhereStr := xWhereStr ||

Line 6402: 'AND ic3.language (+) = '''||ICX_POR_EXTRACTOR.gBaseLang||''' '||

6398: 'AND to_char(p.mtl_category_id) = ds3.external_source_key (+) '||
6399: 'AND ds3.external_source (+) = ''Oracle'' ' ||
6400: 'AND ds3.category_key = ic3.key (+) '||
6401: 'AND ic3.type (+) = '||ICX_POR_EXT_CLASS.CATEGORY_TYPE||' '||
6402: 'AND ic3.language (+) = '''||ICX_POR_EXTRACTOR.gBaseLang||''' '||
6403: 'AND (p.rowid IS NOT NULL OR '||
6404: 'ICX_POR_EXT_DIAG.isValidExtPrice(doc.document_type, doc.status, '''||
6405: ICX_POR_EXTRACTOR.gLoaderValue.load_contracts||''', '''||
6406: ICX_POR_EXTRACTOR.gLoaderValue.load_template_lines||''', '''||

Line 6405: ICX_POR_EXTRACTOR.gLoaderValue.load_contracts||''', '''||

6401: 'AND ic3.type (+) = '||ICX_POR_EXT_CLASS.CATEGORY_TYPE||' '||
6402: 'AND ic3.language (+) = '''||ICX_POR_EXTRACTOR.gBaseLang||''' '||
6403: 'AND (p.rowid IS NOT NULL OR '||
6404: 'ICX_POR_EXT_DIAG.isValidExtPrice(doc.document_type, doc.status, '''||
6405: ICX_POR_EXTRACTOR.gLoaderValue.load_contracts||''', '''||
6406: ICX_POR_EXTRACTOR.gLoaderValue.load_template_lines||''', '''||
6407: ICX_POR_EXTRACTOR.gLoaderValue.load_item_master||''', '''||
6408: ICX_POR_EXTRACTOR.gLoaderValue.load_internal_item||''') = 1)';
6409:

Line 6406: ICX_POR_EXTRACTOR.gLoaderValue.load_template_lines||''', '''||

6402: 'AND ic3.language (+) = '''||ICX_POR_EXTRACTOR.gBaseLang||''' '||
6403: 'AND (p.rowid IS NOT NULL OR '||
6404: 'ICX_POR_EXT_DIAG.isValidExtPrice(doc.document_type, doc.status, '''||
6405: ICX_POR_EXTRACTOR.gLoaderValue.load_contracts||''', '''||
6406: ICX_POR_EXTRACTOR.gLoaderValue.load_template_lines||''', '''||
6407: ICX_POR_EXTRACTOR.gLoaderValue.load_item_master||''', '''||
6408: ICX_POR_EXTRACTOR.gLoaderValue.load_internal_item||''') = 1)';
6409:
6410: -- Bug#3352834

Line 6407: ICX_POR_EXTRACTOR.gLoaderValue.load_item_master||''', '''||

6403: 'AND (p.rowid IS NOT NULL OR '||
6404: 'ICX_POR_EXT_DIAG.isValidExtPrice(doc.document_type, doc.status, '''||
6405: ICX_POR_EXTRACTOR.gLoaderValue.load_contracts||''', '''||
6406: ICX_POR_EXTRACTOR.gLoaderValue.load_template_lines||''', '''||
6407: ICX_POR_EXTRACTOR.gLoaderValue.load_item_master||''', '''||
6408: ICX_POR_EXTRACTOR.gLoaderValue.load_internal_item||''') = 1)';
6409:
6410: -- Bug#3352834
6411: xErrLoc := 500;

Line 6408: ICX_POR_EXTRACTOR.gLoaderValue.load_internal_item||''') = 1)';

6404: 'ICX_POR_EXT_DIAG.isValidExtPrice(doc.document_type, doc.status, '''||
6405: ICX_POR_EXTRACTOR.gLoaderValue.load_contracts||''', '''||
6406: ICX_POR_EXTRACTOR.gLoaderValue.load_template_lines||''', '''||
6407: ICX_POR_EXTRACTOR.gLoaderValue.load_item_master||''', '''||
6408: ICX_POR_EXTRACTOR.gLoaderValue.load_internal_item||''') = 1)';
6409:
6410: -- Bug#3352834
6411: xErrLoc := 500;
6412: xWhereStr := xWhereStr ||

Line 6620: ICX_POR_EXTRACTOR.gLoaderValue.load_contracts||''', '''||

6616: 'AND p.price_type (+) = ''GLOBAL_AGREEMENT'' '||
6617: 'AND (p.rowid IS NOT NULL OR '||
6618: 'ICX_POR_EXT_DIAG.isValidExtPrice('||GLOBAL_AGREEMENT_TYPE||', '||
6619: 'doc.status, '''||
6620: ICX_POR_EXTRACTOR.gLoaderValue.load_contracts||''', '''||
6621: ICX_POR_EXTRACTOR.gLoaderValue.load_template_lines||''', '''||
6622: ICX_POR_EXTRACTOR.gLoaderValue.load_item_master||''', '''||
6623: ICX_POR_EXTRACTOR.gLoaderValue.load_internal_item||''') = 1)';
6624:

Line 6621: ICX_POR_EXTRACTOR.gLoaderValue.load_template_lines||''', '''||

6617: 'AND (p.rowid IS NOT NULL OR '||
6618: 'ICX_POR_EXT_DIAG.isValidExtPrice('||GLOBAL_AGREEMENT_TYPE||', '||
6619: 'doc.status, '''||
6620: ICX_POR_EXTRACTOR.gLoaderValue.load_contracts||''', '''||
6621: ICX_POR_EXTRACTOR.gLoaderValue.load_template_lines||''', '''||
6622: ICX_POR_EXTRACTOR.gLoaderValue.load_item_master||''', '''||
6623: ICX_POR_EXTRACTOR.gLoaderValue.load_internal_item||''') = 1)';
6624:
6625:

Line 6622: ICX_POR_EXTRACTOR.gLoaderValue.load_item_master||''', '''||

6618: 'ICX_POR_EXT_DIAG.isValidExtPrice('||GLOBAL_AGREEMENT_TYPE||', '||
6619: 'doc.status, '''||
6620: ICX_POR_EXTRACTOR.gLoaderValue.load_contracts||''', '''||
6621: ICX_POR_EXTRACTOR.gLoaderValue.load_template_lines||''', '''||
6622: ICX_POR_EXTRACTOR.gLoaderValue.load_item_master||''', '''||
6623: ICX_POR_EXTRACTOR.gLoaderValue.load_internal_item||''') = 1)';
6624:
6625:
6626: xErrLoc := 650;

Line 6623: ICX_POR_EXTRACTOR.gLoaderValue.load_internal_item||''') = 1)';

6619: 'doc.status, '''||
6620: ICX_POR_EXTRACTOR.gLoaderValue.load_contracts||''', '''||
6621: ICX_POR_EXTRACTOR.gLoaderValue.load_template_lines||''', '''||
6622: ICX_POR_EXTRACTOR.gLoaderValue.load_item_master||''', '''||
6623: ICX_POR_EXTRACTOR.gLoaderValue.load_internal_item||''') = 1)';
6624:
6625:
6626: xErrLoc := 650;
6627: -- If a global agreement is updated, we need to reset the active flag

Line 6790: (ICX_POR_EXTRACTOR.gInstalledLanguageCount+1);

6786: 'Enter extractVendorNames()');
6787: END IF;
6788:
6789: xCommitSize := ICX_POR_EXT_UTL.gCommitSize/
6790: (ICX_POR_EXTRACTOR.gInstalledLanguageCount+1);
6791:
6792: xErrLoc := 120;
6793: xString :=
6794: 'SELECT /*+ LEADING(v) */ v.vendor_id, '||

Line 6872: last_updated_by = ICX_POR_EXTRACTOR.gUserId,

6868: xErrLoc := 240;
6869: FORALL i in 1..xVendorId.COUNT
6870: UPDATE icx_cat_items_b
6871: SET supplier = xVendorName(i),
6872: last_updated_by = ICX_POR_EXTRACTOR.gUserId,
6873: last_update_date = SYSDATE,
6874: last_update_login = ICX_POR_EXTRACTOR.gLoginId,
6875: request_id = ICX_POR_EXTRACTOR.gRequestId,
6876: program_application_id = ICX_POR_EXTRACTOR.gProgramApplicationId,

Line 6874: last_update_login = ICX_POR_EXTRACTOR.gLoginId,

6870: UPDATE icx_cat_items_b
6871: SET supplier = xVendorName(i),
6872: last_updated_by = ICX_POR_EXTRACTOR.gUserId,
6873: last_update_date = SYSDATE,
6874: last_update_login = ICX_POR_EXTRACTOR.gLoginId,
6875: request_id = ICX_POR_EXTRACTOR.gRequestId,
6876: program_application_id = ICX_POR_EXTRACTOR.gProgramApplicationId,
6877: program_id = ICX_POR_EXTRACTOR.gProgramId,
6878: program_update_date = SYSDATE

Line 6875: request_id = ICX_POR_EXTRACTOR.gRequestId,

6871: SET supplier = xVendorName(i),
6872: last_updated_by = ICX_POR_EXTRACTOR.gUserId,
6873: last_update_date = SYSDATE,
6874: last_update_login = ICX_POR_EXTRACTOR.gLoginId,
6875: request_id = ICX_POR_EXTRACTOR.gRequestId,
6876: program_application_id = ICX_POR_EXTRACTOR.gProgramApplicationId,
6877: program_id = ICX_POR_EXTRACTOR.gProgramId,
6878: program_update_date = SYSDATE
6879: WHERE supplier_id = xVendorId(i)

Line 6876: program_application_id = ICX_POR_EXTRACTOR.gProgramApplicationId,

6872: last_updated_by = ICX_POR_EXTRACTOR.gUserId,
6873: last_update_date = SYSDATE,
6874: last_update_login = ICX_POR_EXTRACTOR.gLoginId,
6875: request_id = ICX_POR_EXTRACTOR.gRequestId,
6876: program_application_id = ICX_POR_EXTRACTOR.gProgramApplicationId,
6877: program_id = ICX_POR_EXTRACTOR.gProgramId,
6878: program_update_date = SYSDATE
6879: WHERE supplier_id = xVendorId(i)
6880: AND supplier <> xVendorName(i)

Line 6877: program_id = ICX_POR_EXTRACTOR.gProgramId,

6873: last_update_date = SYSDATE,
6874: last_update_login = ICX_POR_EXTRACTOR.gLoginId,
6875: request_id = ICX_POR_EXTRACTOR.gRequestId,
6876: program_application_id = ICX_POR_EXTRACTOR.gProgramApplicationId,
6877: program_id = ICX_POR_EXTRACTOR.gProgramId,
6878: program_update_date = SYSDATE
6879: WHERE supplier_id = xVendorId(i)
6880: AND supplier <> xVendorName(i)
6881: AND rownum <= xCommitSize

Line 6898: last_updated_by = ICX_POR_EXTRACTOR.gUserId,

6894: -- interMedia index, have to set the column jobNum
6895: FORALL i IN 1..xRtItemIds.COUNT
6896: UPDATE icx_cat_items_tlp
6897: SET supplier = xNewVendorNames(i),
6898: last_updated_by = ICX_POR_EXTRACTOR.gUserId,
6899: last_update_date = SYSDATE,
6900: last_update_login = ICX_POR_EXTRACTOR.gLoginId,
6901: request_id = ICX_POR_EXTRACTOR.gRequestId,
6902: program_application_id = ICX_POR_EXTRACTOR.gProgramApplicationId,

Line 6900: last_update_login = ICX_POR_EXTRACTOR.gLoginId,

6896: UPDATE icx_cat_items_tlp
6897: SET supplier = xNewVendorNames(i),
6898: last_updated_by = ICX_POR_EXTRACTOR.gUserId,
6899: last_update_date = SYSDATE,
6900: last_update_login = ICX_POR_EXTRACTOR.gLoginId,
6901: request_id = ICX_POR_EXTRACTOR.gRequestId,
6902: program_application_id = ICX_POR_EXTRACTOR.gProgramApplicationId,
6903: program_id = ICX_POR_EXTRACTOR.gProgramId,
6904: program_update_date = SYSDATE

Line 6901: request_id = ICX_POR_EXTRACTOR.gRequestId,

6897: SET supplier = xNewVendorNames(i),
6898: last_updated_by = ICX_POR_EXTRACTOR.gUserId,
6899: last_update_date = SYSDATE,
6900: last_update_login = ICX_POR_EXTRACTOR.gLoginId,
6901: request_id = ICX_POR_EXTRACTOR.gRequestId,
6902: program_application_id = ICX_POR_EXTRACTOR.gProgramApplicationId,
6903: program_id = ICX_POR_EXTRACTOR.gProgramId,
6904: program_update_date = SYSDATE
6905: WHERE rt_item_id = xRtItemIds(i);

Line 6902: program_application_id = ICX_POR_EXTRACTOR.gProgramApplicationId,

6898: last_updated_by = ICX_POR_EXTRACTOR.gUserId,
6899: last_update_date = SYSDATE,
6900: last_update_login = ICX_POR_EXTRACTOR.gLoginId,
6901: request_id = ICX_POR_EXTRACTOR.gRequestId,
6902: program_application_id = ICX_POR_EXTRACTOR.gProgramApplicationId,
6903: program_id = ICX_POR_EXTRACTOR.gProgramId,
6904: program_update_date = SYSDATE
6905: WHERE rt_item_id = xRtItemIds(i);
6906:

Line 6903: program_id = ICX_POR_EXTRACTOR.gProgramId,

6899: last_update_date = SYSDATE,
6900: last_update_login = ICX_POR_EXTRACTOR.gLoginId,
6901: request_id = ICX_POR_EXTRACTOR.gRequestId,
6902: program_application_id = ICX_POR_EXTRACTOR.gProgramApplicationId,
6903: program_id = ICX_POR_EXTRACTOR.gProgramId,
6904: program_update_date = SYSDATE
6905: WHERE rt_item_id = xRtItemIds(i);
6906:
6907: xErrLoc := 300;

Line 7001: last_updated_by = ICX_POR_EXTRACTOR.gUserId,

6997: xErrLoc := 630;
6998: FORALL i in 1..xVendorSiteIds.COUNT
6999: UPDATE icx_cat_item_prices
7000: SET supplier_site_code = xVendorSiteNames(i),
7001: last_updated_by = ICX_POR_EXTRACTOR.gUserId,
7002: last_update_date = SYSDATE,
7003: last_update_login = ICX_POR_EXTRACTOR.gLoginId,
7004: request_id = ICX_POR_EXTRACTOR.gRequestId,
7005: program_application_id = ICX_POR_EXTRACTOR.gProgramApplicationId,

Line 7003: last_update_login = ICX_POR_EXTRACTOR.gLoginId,

6999: UPDATE icx_cat_item_prices
7000: SET supplier_site_code = xVendorSiteNames(i),
7001: last_updated_by = ICX_POR_EXTRACTOR.gUserId,
7002: last_update_date = SYSDATE,
7003: last_update_login = ICX_POR_EXTRACTOR.gLoginId,
7004: request_id = ICX_POR_EXTRACTOR.gRequestId,
7005: program_application_id = ICX_POR_EXTRACTOR.gProgramApplicationId,
7006: program_id = ICX_POR_EXTRACTOR.gProgramId,
7007: program_update_date = SYSDATE

Line 7004: request_id = ICX_POR_EXTRACTOR.gRequestId,

7000: SET supplier_site_code = xVendorSiteNames(i),
7001: last_updated_by = ICX_POR_EXTRACTOR.gUserId,
7002: last_update_date = SYSDATE,
7003: last_update_login = ICX_POR_EXTRACTOR.gLoginId,
7004: request_id = ICX_POR_EXTRACTOR.gRequestId,
7005: program_application_id = ICX_POR_EXTRACTOR.gProgramApplicationId,
7006: program_id = ICX_POR_EXTRACTOR.gProgramId,
7007: program_update_date = SYSDATE
7008: WHERE supplier_site_id = xVendorSiteIds(i)

Line 7005: program_application_id = ICX_POR_EXTRACTOR.gProgramApplicationId,

7001: last_updated_by = ICX_POR_EXTRACTOR.gUserId,
7002: last_update_date = SYSDATE,
7003: last_update_login = ICX_POR_EXTRACTOR.gLoginId,
7004: request_id = ICX_POR_EXTRACTOR.gRequestId,
7005: program_application_id = ICX_POR_EXTRACTOR.gProgramApplicationId,
7006: program_id = ICX_POR_EXTRACTOR.gProgramId,
7007: program_update_date = SYSDATE
7008: WHERE supplier_site_id = xVendorSiteIds(i)
7009: AND supplier_site_code <> xVendorSiteNames(i)

Line 7006: program_id = ICX_POR_EXTRACTOR.gProgramId,

7002: last_update_date = SYSDATE,
7003: last_update_login = ICX_POR_EXTRACTOR.gLoginId,
7004: request_id = ICX_POR_EXTRACTOR.gRequestId,
7005: program_application_id = ICX_POR_EXTRACTOR.gProgramApplicationId,
7006: program_id = ICX_POR_EXTRACTOR.gProgramId,
7007: program_update_date = SYSDATE
7008: WHERE supplier_site_id = xVendorSiteIds(i)
7009: AND supplier_site_code <> xVendorSiteNames(i)
7010: AND rownum <= xCommitSize;

Line 7236: last_updated_by = ICX_POR_EXTRACTOR.gUserId,

7232: xErrLoc := 240;
7233: FORALL i IN 1..gSARowIds.COUNT
7234: UPDATE icx_cat_item_prices
7235: SET active_flag = gSAActiveFlags(i),
7236: last_updated_by = ICX_POR_EXTRACTOR.gUserId,
7237: last_update_date = SYSDATE,
7238: last_update_login = ICX_POR_EXTRACTOR.gLoginId,
7239: -- Bug # 3542291
7240: request_id = ICX_POR_EXT_ITEM.AF_CURRENT_REQUEST_ID,

Line 7238: last_update_login = ICX_POR_EXTRACTOR.gLoginId,

7234: UPDATE icx_cat_item_prices
7235: SET active_flag = gSAActiveFlags(i),
7236: last_updated_by = ICX_POR_EXTRACTOR.gUserId,
7237: last_update_date = SYSDATE,
7238: last_update_login = ICX_POR_EXTRACTOR.gLoginId,
7239: -- Bug # 3542291
7240: request_id = ICX_POR_EXT_ITEM.AF_CURRENT_REQUEST_ID,
7241: program_application_id = ICX_POR_EXTRACTOR.gProgramApplicationId,
7242: program_id = ICX_POR_EXTRACTOR.gProgramId,

Line 7241: program_application_id = ICX_POR_EXTRACTOR.gProgramApplicationId,

7237: last_update_date = SYSDATE,
7238: last_update_login = ICX_POR_EXTRACTOR.gLoginId,
7239: -- Bug # 3542291
7240: request_id = ICX_POR_EXT_ITEM.AF_CURRENT_REQUEST_ID,
7241: program_application_id = ICX_POR_EXTRACTOR.gProgramApplicationId,
7242: program_id = ICX_POR_EXTRACTOR.gProgramId,
7243: program_update_date = SYSDATE
7244: WHERE rowid = gSARowIds(i);
7245:

Line 7242: program_id = ICX_POR_EXTRACTOR.gProgramId,

7238: last_update_login = ICX_POR_EXTRACTOR.gLoginId,
7239: -- Bug # 3542291
7240: request_id = ICX_POR_EXT_ITEM.AF_CURRENT_REQUEST_ID,
7241: program_application_id = ICX_POR_EXTRACTOR.gProgramApplicationId,
7242: program_id = ICX_POR_EXTRACTOR.gProgramId,
7243: program_update_date = SYSDATE
7244: WHERE rowid = gSARowIds(i);
7245:
7246: ICX_POR_EXT_UTL.extAFCommit;

Line 7407: 'AND ic.language (+) = '''||ICX_POR_EXTRACTOR.gBaseLang||''' ';

7403: ICX_POR_EXT_TEST.gTestMode||''') <> '||
7404: ICX_POR_EXT_DIAG.VALID_FOR_EXTRACT||' '||
7405: 'AND p.template_id||''_tmpl'' = ic.key (+) '||
7406: 'AND ic.type (+) = '||ICX_POR_EXT_CLASS.TEMPLATE_HEADER_TYPE||' '||
7407: 'AND ic.language (+) = '''||ICX_POR_EXTRACTOR.gBaseLang||''' ';
7408: IF ICX_POR_EXT_TEST.gTestMode = 'Y' THEN
7409: xString := xString ||
7410: 'AND p.last_updated_by = '||ICX_POR_EXT_TEST.TEST_USER_ID||' ';
7411: END IF;

Line 7584: ICX_POR_EXTRACTOR.setLastRunDates('VENDOR_NAME');

7580:
7581: xErrLoc := 200;
7582: extractVendorNames;
7583: xErrLoc := 220;
7584: ICX_POR_EXTRACTOR.setLastRunDates('VENDOR_NAME');
7585: xErrLoc := 260;
7586: -- use global temporary table to hold all items need to reset active_flag...
7587: truncateTempTable('NOGA');
7588: xErrLoc := 280;

Line 7594: ICX_POR_EXTRACTOR.setLastRunDates('TEMPLATE');

7590: xErrLoc := 300;
7591: processItemData('TEMPLATE');
7592: xErrLoc := 320;
7593: IF gSetTemplateLastRunDate THEN
7594: ICX_POR_EXTRACTOR.setLastRunDates('TEMPLATE');
7595: END IF;
7596: xErrLoc := 340;
7597: processItemData('CONTRACT');
7598: xErrLoc := 360;

Line 7601: ICX_POR_EXTRACTOR.setLastRunDates('CONTRACT');

7597: processItemData('CONTRACT');
7598: xErrLoc := 360;
7599: processItemData('GLOBAL_AGREEMENT');
7600: xErrLoc := 380;
7601: ICX_POR_EXTRACTOR.setLastRunDates('CONTRACT');
7602: xErrLoc := 400;
7603: processItemData('ASL');
7604: xErrLoc := 420;
7605: processItemData('ITEM');

Line 7607: ICX_POR_EXTRACTOR.setLastRunDates('ITEM');

7603: processItemData('ASL');
7604: xErrLoc := 420;
7605: processItemData('ITEM');
7606: xErrLoc := 440;
7607: ICX_POR_EXTRACTOR.setLastRunDates('ITEM');
7608: xErrLoc := 460;
7609: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL,
7610: 'All updated price rows processing done: ' || gTotalCount);
7611: xErrLoc := 480;

Line 7612: IF ICX_POR_EXTRACTOR.gLoaderValue.cleanup_flag = 'Y' THEN

7608: xErrLoc := 460;
7609: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL,
7610: 'All updated price rows processing done: ' || gTotalCount);
7611: xErrLoc := 480;
7612: IF ICX_POR_EXTRACTOR.gLoaderValue.cleanup_flag = 'Y' THEN
7613: cleanupPrices;
7614: END IF;
7615:
7616: updatePriceRequestIds;

Line 7638: SET REQUEST_ID = ICX_POR_EXTRACTOR.gRequestId

7634: BEGIN
7635: xErrLoc := 100;
7636:
7637: UPDATE ICX_CAT_ITEM_PRICES
7638: SET REQUEST_ID = ICX_POR_EXTRACTOR.gRequestId
7639: WHERE REQUEST_ID IN (
7640: TEMPLATE_TEMP_REQUEST_ID,
7641: CONTRACT_TEMP_REQUEST_ID,
7642: GA_TEMP_REQUEST_ID,