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_ITEM_UPLOAD dependencies on ICX_POR_EXT_ITEM

Line 842: -- icx_por_ext_item.getBulkLoadActiveFlag() returns,

838: || xErrLoc || '): ' || SQLERRM);
839: END process_batch_add_prices;
840:
841: /* Processes the price updates in the current batch */
842: -- icx_por_ext_item.getBulkLoadActiveFlag() returns,
843: -- 'A' if the bulkloaded price is active and there is an ASL
844: -- 'Y' if the bulkloaded price is active and there is No ASL
845: -- 'N' if the bulkloaded price is inactive
846: PROCEDURE process_batch_addupdate_prices(p_batch_type IN VARCHAR2,

Line 1087: -- icx_por_ext_item.getBulkLoadActiveFlag() returns,

1083: || xErrLoc || ') 2 arg: ' || SQLERRM);
1084: END process_batch_addupdate_prices;
1085:
1086: /* Processes the price deletes in the current batch */
1087: -- icx_por_ext_item.getBulkLoadActiveFlag() returns,
1088: -- 'A' if the bulkloaded price is active and there is an ASL
1089: -- 'Y' if the bulkloaded price is active and there is No ASL
1090: -- 'N' if the bulkloaded price is inactive
1091: PROCEDURE process_batch_delete_prices(p_batch_type IN VARCHAR2) IS

Line 1127: -- If the icx_por_ext_item.getBulkLoadActiveFlag returns 'A' or 'Y' then it means that

1123:
1124: xErrLoc := 150;
1125: -- If it was a delete operation then the ASL active flag
1126: -- will be set to "Y", if it did not have contracts/templates..
1127: -- If the icx_por_ext_item.getBulkLoadActiveFlag returns 'A' or 'Y' then it means that
1128: -- there are no contract, templates and this bulkloaded item was the last
1129: -- active price. So after deletion of this price, active flag of ASL price
1130: -- will be set to 'Y'. If the icx_por_ext_item.getBulkLoadActiveFlag returned 'N', the
1131: -- there is a contract/template, So set the active_flag to 'N'

Line 1130: -- will be set to 'Y'. If the icx_por_ext_item.getBulkLoadActiveFlag returned 'N', the

1126: -- will be set to "Y", if it did not have contracts/templates..
1127: -- If the icx_por_ext_item.getBulkLoadActiveFlag returns 'A' or 'Y' then it means that
1128: -- there are no contract, templates and this bulkloaded item was the last
1129: -- active price. So after deletion of this price, active flag of ASL price
1130: -- will be set to 'Y'. If the icx_por_ext_item.getBulkLoadActiveFlag returned 'N', the
1131: -- there is a contract/template, So set the active_flag to 'N'
1132: -- (Active flag constraint used to pick the right index.)
1133: FORALL i in 1..gRowIds.COUNT
1134: update icx_cat_item_prices

Line 3545: decode(i.extractor_updated_flag, 'N', 'Y', 'Y', decode(icx_por_ext_item.getBulkLoadActiveFlag(it.action, i.rt_item_id), 'N', 'N', 'Y')),

3541: it.supplier_id,
3542: decode(it.contract_num, null, 'BULKLOAD', 'CONTRACT'),
3543: it.supplier_part_num,
3544: i.rt_item_id,
3545: decode(i.extractor_updated_flag, 'N', 'Y', 'Y', decode(icx_por_ext_item.getBulkLoadActiveFlag(it.action, i.rt_item_id), 'N', 'N', 'Y')),
3546: decode(it.action, 'SYNC', 'ADD', it.action),
3547: decode(it.error_flag, 'Y', 'Y',
3548: decode(it.error_message, NULL, 'N', 'Y')),
3549: it.row_type,

Line 3937: decode(i.extractor_updated_flag, 'N', 'Y', 'Y', decode(icx_por_ext_item.getBulkLoadActiveFlag(it.action, i.rt_item_id), 'N', 'N', 'Y')),

3933: it.org_id,
3934: it.price_list_id,
3935: it.supplier_site_id,
3936: i.extractor_updated_flag,
3937: decode(i.extractor_updated_flag, 'N', 'Y', 'Y', decode(icx_por_ext_item.getBulkLoadActiveFlag(it.action, i.rt_item_id), 'N', 'N', 'Y')),
3938: decode(it.required_descriptors, NULL, 'N', 'Y'),
3939: decode(it.required_tl_descriptors, NULL, 'N', 'Y'),
3940: it.unit_price,
3941: it.unit_of_measure