APPS.CSD_REPAIR_MANAGER_UTIL dependencies on CSD_PRODUCT_TRANSACTIONS

Line 268: TYPE l_prod_txn_tbl_type IS TABLE OF CSD_PRODUCT_TRANSACTIONS%ROWTYPE INDEX BY BINARY_INTEGER;

264: l_source_org NUMBER := fnd_profile.value('CSD_DEF_REP_INV_ORG');
265: l_dest_ou NUMBER := fnd_profile.value('ORG_ID');
266: l_dest_org NUMBER;
267: l_dest_loc_id NUMBER;
268: TYPE l_prod_txn_tbl_type IS TABLE OF CSD_PRODUCT_TRANSACTIONS%ROWTYPE INDEX BY BINARY_INTEGER;
269: l_prod_txn_tbl l_prod_txn_tbl_type;
270: TYPE int_order_item_qty IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
271: int_org_item_qty_tbl int_order_item_qty;
272: l_rule_input_rec CSD_RULES_ENGINE_PVT.CSD_RULE_INPUT_REC_TYPE;

Line 411: 'Forall insert into csd_product_transactions. Number of product txn lines = '||l_prod_txn_tbl.COUNT);

407:
408: -- insert the records into the product transactions table.
409: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
410: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,
411: 'Forall insert into csd_product_transactions. Number of product txn lines = '||l_prod_txn_tbl.COUNT);
412: END IF;
413:
414: FORALL i IN 1 ..l_prod_txn_tbl.COUNT
415: INSERT INTO csd_product_transactions

Line 415: INSERT INTO csd_product_transactions

411: 'Forall insert into csd_product_transactions. Number of product txn lines = '||l_prod_txn_tbl.COUNT);
412: END IF;
413:
414: FORALL i IN 1 ..l_prod_txn_tbl.COUNT
415: INSERT INTO csd_product_transactions
416: (product_transaction_id,
417: repair_line_id,
418: exp_quantity,
419: inventory_item_id,

Line 432: (csd_product_transactions_s1.nextval,

428: last_updated_by,
429: object_version_number
430: )
431: VALUES
432: (csd_product_transactions_s1.nextval,
433: l_prod_txn_tbl(i).repair_line_id,
434: l_prod_txn_tbl(i).exp_quantity,
435: l_prod_txn_tbl(i).inventory_item_id,
436: l_prod_txn_tbl(i).ship_from_ou,

Line 512: FROM csd_product_transactions

508: RAISE fnd_api.g_exc_error;
509: END IF;
510: -- update the values for the other product transaction lines also.
511: FOR i IN (SELECT req_header_id,req_line_id,order_header_id,order_line_id,inventory_item_id,delivery_detail_id
512: FROM csd_product_transactions
513: WHERE product_transaction_id IN (SELECT * FROM TABLE(CAST(l_ord_product_txn_ids AS JTF_NUMBER_TABLE)))
514: )
515: LOOP
516: UPDATE csd_product_transactions SET req_header_id = i.req_header_id,req_line_id = i.req_line_id,

Line 516: UPDATE csd_product_transactions SET req_header_id = i.req_header_id,req_line_id = i.req_line_id,

512: FROM csd_product_transactions
513: WHERE product_transaction_id IN (SELECT * FROM TABLE(CAST(l_ord_product_txn_ids AS JTF_NUMBER_TABLE)))
514: )
515: LOOP
516: UPDATE csd_product_transactions SET req_header_id = i.req_header_id,req_line_id = i.req_line_id,
517: order_header_id = i.order_header_id,order_line_id = i.order_line_id,delivery_detail_id = i.delivery_detail_id
518: WHERE product_transaction_id IN (SELECT * FROM TABLE(CAST(l_product_txn_ids AS JTF_NUMBER_TABLE)))
519: AND req_header_id IS NULL;
520: END LOOP;