APPS.CST_REVENUECOGSMATCH_PVT dependencies on CST_COGS_PCT_ADJ_EVENTS_TEMP

Line 2185: INSERT INTO cst_cogs_pct_adj_events_temp (

2181: -- This portion is for Revenue Recognition adjustment activity for the bug#6809034 remain untouched
2182: l_stmt_num := 90;
2183: debug(l_stmt_num);
2184: FORALL i IN l_cogs_om_line_id_tbl.FIRST..l_cogs_om_line_id_tbl.LAST
2185: INSERT INTO cst_cogs_pct_adj_events_temp (
2186: adj_event_id,
2187: adj_mmt_txn_id,
2188: adj_cogs_om_line_id,
2189: adj_event_date,

Line 2277: FROM cst_cogs_pct_adj_events_temp;

2273: p_request_id,
2274: p_pgm_app_id,
2275: p_pgm_id,
2276: sysdate
2277: FROM cst_cogs_pct_adj_events_temp;
2278:
2279: l_cce_count := l_cce_count + SQL%ROWCOUNT;
2280: debug(' l_cce_count : '|| l_cce_count);
2281: l_stmt_num := 110;

Line 2342: FROM cst_cogs_pct_adj_events_temp;

2338: adj_cogs_om_line_id,
2339: 1, -- Logical Txn
2340: adj_new_cogs_percentage
2341: ,p_neg_req_id --BUG#7387575
2342: FROM cst_cogs_pct_adj_events_temp;
2343:
2344: -- Next update MTL_COGS_RECOGNITION_TEMP to populate transaction_source_id with the
2345: -- sales_order_id from mtl_sales_orders.
2346: -- Get the source code from the OE profile system parameter.

Line 2424: cst_cogs_pct_adj_events_temp cba

2420: UPDATE (
2421: SELECT cce.prior_event_id,
2422: cba.adj_event_id
2423: FROM cst_cogs_events cce,
2424: cst_cogs_pct_adj_events_temp cba
2425: WHERE cce.event_id = cba.ftr_event_id)
2426: SET prior_event_id = adj_event_id;
2427:
2428: l_stmt_num := 180;

Line 2445: COMMIT; --also deletes from cst_cogs_pct_adj_events_temp;

2441: program_update_date = SYSDATE
2442: WHERE ROWID = l_upd_rowid_tab(i);
2443:
2444:
2445: COMMIT; --also deletes from cst_cogs_pct_adj_events_temp;
2446: SAVEPOINT Create_CogsRecEvents_PVT;
2447:
2448: END LOOP mismatched_lines_loop; -- c_mismatched_lines bulk fetches
2449: