[Home] [Help]
1060: -- quantity adjustment children.
1061: l_stmt_num := 60;
1062: debug(l_stmt_num);
1063: FORALL i IN l_cogs_om_line_id_tbl.FIRST..l_cogs_om_line_id_tbl.LAST
1064: INSERT INTO cst_cogs_qty_adj_events_temp (
1065: adj_event_id,
1066: adj_mmt_txn_id,
1067: adj_cogs_om_line_id,
1068: adj_rma_om_line_id,
1163: p_request_id,
1164: p_pgm_app_id,
1165: p_pgm_id,
1166: sysdate
1167: FROM cst_cogs_qty_adj_events_temp;
1168:
1169: -- Get the source code from the OE profile system parameter.
1170: -- It can be overridden by the user but most likely uses the default
1171: -- called 'ORDER ENTRY' and will most likely never change.
1236: ccqa.adj_cogs_om_line_id,
1237: ccqa.adj_rma_om_line_id, -- RMA Line ID
1238: 1, -- Logical Txn
1239: ccqa.adj_new_cogs_percentage
1240: FROM cst_cogs_qty_adj_events_temp ccqa,
1241: mtl_sales_orders mso,
1242: oe_order_lines_all ool,
1243: oe_order_headers_all ooh,
1244: oe_transaction_types_tl ott
1276: END IF;
1277:
1278: l_stmt_num := 90;
1279: debug(l_stmt_num);
1280: commit; --delete from cst_cogs_qty_adj_events_temp;
1281: SAVEPOINT Insert_RmaReceipts_PVT;
1282:
1283: END LOOP all_rma_receipts_loop;
1284:
3117: -- Now create quantity adjustment events for all future COGS Rec events
3118: -- This is a 2 step process, first insert into the global temp table
3119: l_stmt_num := 60;
3120: debug(l_stmt_num);
3121: INSERT INTO cst_cogs_qty_adj_events_temp (
3122: adj_event_id,
3123: adj_mmt_txn_id,
3124: adj_cogs_om_line_id,
3125: adj_rma_om_line_id,
3220: p_request_id,
3221: p_pgm_app_id,
3222: p_pgm_id,
3223: sysdate
3224: FROM cst_cogs_qty_adj_events_temp;
3225:
3226: -- Get the source code from the OE profile system parameter.
3227: -- It can be overridden by the user but most likely uses the default
3228: -- called 'ORDER ENTRY' and will most likely never change.
3292: ccqa.adj_cogs_om_line_id,
3293: ccqa.adj_rma_om_line_id, -- RMA Line ID
3294: 1, -- Logical Txn
3295: ccqa.adj_new_cogs_percentage
3296: FROM cst_cogs_qty_adj_events_temp ccqa,
3297: mtl_sales_orders mso,
3298: oe_order_lines_all ool,
3299: oe_order_headers_all ooh,
3300: oe_transaction_types_tl ott