[Home] [Help]
1115: request_id,
1116: program_application_id,
1117: program_id,
1118: program_update_date)
1119: VALUES ( cst_cogs_events_s.nextval,
1120: l_cogs_om_line_id_tbl(i),
1121: l_txn_date_tbl(i),
1122: NULL, -- Quantity placeholder - no MMT transaction
1123: l_prior_percent_tbl(i),
1126: RMA_RECEIPT_PLACEHOLDER,
1127: l_rma_om_line_id_tbl(i),
1128: l_prior_event_qty_tbl(i),
1129: NULL, -- This event is a quantity placeholder, thus is never costed
1130: cst_cogs_events_s.currval,
1131: -- WHO COLUMNS
1132: sysdate,
1133: p_user_id,
1134: sysdate,
1167: request_id,
1168: program_application_id,
1169: program_id,
1170: program_update_date)
1171: VALUES ( cst_cogs_events_s.nextval,
1172: l_cogs_om_line_id_tbl(i),
1173: l_txn_date_tbl(i),
1174: l_mmt_txn_id_tbl(i),
1175: l_prior_percent_tbl(i), -- COGS percentage
1256: cogs_acct_id,
1257: opm_org_flag,
1258: acct_period_id
1259: )
1260: SELECT cst_cogs_events_s.nextval,
1261: decode(event_type, COGS_RECOGNITION_EVENT, mtl_material_transactions_s.nextval,
1262: COGS_REC_PERCENT_ADJUSTMENT, mtl_material_transactions_s.nextval,
1263: NULL),
1264: cce.cogs_om_line_id,
2045: program_application_id,
2046: program_id,
2047: program_update_date)
2048: VALUES(
2049: cst_cogs_events_s.nextval,
2050: l_cogs_om_line_id_tbl(i),
2051: --BUG#6809034 -- As JAN-XX is opened the transaction_date is AR recognition event date
2052: --But as the bug is only on the material transaction, this COGS event event_date remains
2053: --untouch to avoid breaking the current logic based on the CCE,CRCML,CRRL for CCE creation
2064: COGS_RECOGNITION_EVENT,
2065: NULL, -- event OM line ID
2066: l_event_quantity_tbl(i),
2067: 'N',
2068: cst_cogs_events_s.currval,
2069: -- WHO COLUMNS
2070: sysdate,
2071: p_user_id,
2072: sysdate,
2199: cogs_acct_id,
2200: opm_org_flag,
2201: acct_period_id
2202: )
2203: SELECT cst_cogs_events_s.nextval,
2204: mtl_material_transactions_s.nextval,
2205: cogs_om_line_id,
2206: event_date,
2207: l_prior_percentage_tbl(i), -- could also use cce.prior_cogs_percentage
2788: program_application_id,
2789: program_id,
2790: program_update_date)
2791: VALUES (
2792: cst_cogs_events_s.nextval,
2793: p_cogs_om_line_id,
2794: p_transaction_date,
2795: p_mmt_txn_id,
2796: 0, -- COGS %
2798: SO_ISSUE,
2799: p_cogs_om_line_id,
2800: p_quantity,
2801: 'N',
2802: nvl(l_parent_cce_id,cst_cogs_events_s.currval),
2803: -- WHO COLUMNS
2804: sysdate,
2805: p_user_id,
2806: sysdate,
3031: request_id,
3032: program_application_id,
3033: program_id,
3034: program_update_date)
3035: VALUES ( cst_cogs_events_s.nextval,
3036: p_cogs_om_line_id,
3037: p_transaction_date,
3038: NULL, -- Quantity Placeholder event - no corresponding MMT txn
3039: l_cogs_percentage,
3042: RMA_RECEIPT_PLACEHOLDER,
3043: p_rma_om_line_id,
3044: l_prior_event_quantity,
3045: NULL, -- RMA quantity placeholders are not costed
3046: cst_cogs_events_s.currval,
3047: -- WHO COLUMNS
3048: sysdate,
3049: p_user_id,
3050: sysdate,
3081: request_id,
3082: program_application_id,
3083: program_id,
3084: program_update_date)
3085: VALUES ( cst_cogs_events_s.nextval,
3086: p_cogs_om_line_id,
3087: p_transaction_date,
3088: p_mmt_txn_id,
3089: l_cogs_percentage,
3159: cogs_acct_id,
3160: opm_org_flag,
3161: acct_period_id
3162: )
3163: SELECT cst_cogs_events_s.nextval,
3164: decode(event_type, COGS_RECOGNITION_EVENT, mtl_material_transactions_s.nextval,
3165: COGS_REC_PERCENT_ADJUSTMENT, mtl_material_transactions_s.nextval,
3166: NULL),
3167: cce.cogs_om_line_id,
7087: PROCEDURE update_one_set_crrl
7088: (p_rowid_tab IN DBMS_SQL.VARCHAR2_TABLE) IS
7089: l_gp_id NUMBER;
7090: BEGIN
7091: SELECT cst_cogs_events_s.nextval
7092: INTO l_gp_id
7093: FROM dual;
7094:
7095: FORALL j IN p_rowid_tab.FIRST .. p_rowid_tab.LAST