APPS.ICX_POR_ITEM_UPLOAD dependencies on ICX_CAT_PRICES_GT

Line 935: FROM ICX_CAT_PRICES_GT it

931: 'SUPPLIER', it.unit_price, it.currency, it.unit_of_measure,
932: it.supplier_site_code, it.price_list_id, gJobNumber, gUserId, sysdate, gUserId,
933: gUserLogin, sysdate, it.contract_num, it.contract_id , 1,
934: gNegotiatedPrice --Bug#3107596
935: FROM ICX_CAT_PRICES_GT it
936: WHERE rowid = gRowIds(i)
937: AND gRowTypes(i) = p_batch_type
938: AND gSystemActions(i) = p_action
939: AND v_price_updated(i) = 0;

Line 959: FROM ICX_CAT_PRICES_GT it

955: it.supplier_site_code, gJobNumber, gUserId, gUserLogin, sysdate,
956: it.contract_num, it.contract_id, 1,
957: gPriceTypes(i), --Bug#3503280
958: gNegotiatedPrice --Bug#3107596
959: FROM ICX_CAT_PRICES_GT it
960: WHERE rowid = gRowIds(i)
961: AND gRowTypes(i) = p_batch_type
962: AND gSystemActions(i) = p_action
963: AND v_price_updated(i) = 1)

Line 3288: --unit_price in ICX_CAT_PRICES_GT is already VARCHAR type

3284: supplier, supplier_part_num, supplier_part_auxid, --Bug#2611529
3285: supplier_site_code, --Bug#
3286: --Bug#2785949
3287: --Removed the to_char function as
3288: --unit_price in ICX_CAT_PRICES_GT is already VARCHAR type
3289: unit_price, currency, unit_of_measure,
3290: buyer_name, price_list_name,
3291: error_message, error_flag
3292: FROM ICX_CAT_PRICES_GT

Line 3292: FROM ICX_CAT_PRICES_GT

3288: --unit_price in ICX_CAT_PRICES_GT is already VARCHAR type
3289: unit_price, currency, unit_of_measure,
3290: buyer_name, price_list_name,
3291: error_message, error_flag
3292: FROM ICX_CAT_PRICES_GT
3293: WHERE rowid = p_rowid;
3294: v_rec tITPriceRecord;
3295: xErrLoc PLS_INTEGER := 100;
3296: BEGIN

Line 3408: UPDATE ICX_CAT_PRICES_GT SET error_message = error_message ||

3404: UPDATE ICX_CAT_ITEMS_GT SET error_message = error_message ||
3405: p_error_message
3406: WHERE rowid = p_row_id;
3407: ELSE
3408: UPDATE ICX_CAT_PRICES_GT SET error_message = error_message ||
3409: p_error_message
3410: WHERE rowid = p_row_id;
3411: END IF;
3412:

Line 3430: FROM ICX_CAT_PRICES_GT it

3426: CURSOR it_table_csr IS
3427: SELECT it.rowid, it.supplier,
3428: it.supplier_part_num, it.supplier_part_auxid, it.org_id,
3429: it.supplier_site_id, it.currency
3430: FROM ICX_CAT_PRICES_GT it
3431: ORDER BY it.supplier asc, it.supplier_part_num asc,
3432: it.supplier_part_auxid asc,
3433: it.org_id asc, it.currency asc, it.supplier_site_id asc,
3434: it.line_number desc;

Line 3554: FROM ICX_CAT_PRICES_GT it,

3550: it.org_id,
3551: it.price_list_id,
3552: it.supplier_site_id,
3553: it.unit_of_measure
3554: FROM ICX_CAT_PRICES_GT it,
3555: icx_cat_items_b i
3556: WHERE it.supplier = i.supplier (+)
3557: AND it.supplier_part_num = i.supplier_part_num (+)
3558: AND it.supplier_part_auxid = i.supplier_part_auxid (+) -- Bug#2611529

Line 3740: UPDATE ICX_CAT_PRICES_GT

3736: EXIT;
3737: -- Update the processed_flag to null
3738: ELSE
3739: FORALL i IN 1..vRowids.COUNT
3740: UPDATE ICX_CAT_PRICES_GT
3741: SET processed_flag = 'Y' --Bug#2587763: set to "Y" instead of null.
3742: WHERE rowid = vRowids(i);
3743:
3744: COMMIT;

Line 4345: vTableName := 'ICX_CAT_PRICES_GT';

4341:
4342: IF (p_data_type = 'ITEM') THEN
4343: vTableName := 'ICX_CAT_ITEMS_GT';
4344: ELSIF (p_data_type = 'PRICE') THEN
4345: vTableName := 'ICX_CAT_PRICES_GT';
4346: ELSE
4347: p_failed_lines_saved_count := 0;
4348: RETURN;
4349: END IF;