[Home] [Help]
938: request_id,
939: program_application_id,
940: program_id,
941: program_update_date)
942: VALUES ( cst_cogs_events_s.nextval,
943: l_cogs_om_line_id_tbl(i),
944: l_txn_date_tbl(i),
945: NULL, -- Quantity placeholder - no MMT transaction
946: l_prior_percent_tbl(i),
949: RMA_RECEIPT_PLACEHOLDER,
950: l_rma_om_line_id_tbl(i),
951: l_prior_event_qty_tbl(i),
952: NULL, -- This event is a quantity placeholder, thus is never costed
953: cst_cogs_events_s.currval,
954: -- WHO COLUMNS
955: sysdate,
956: p_user_id,
957: sysdate,
990: request_id,
991: program_application_id,
992: program_id,
993: program_update_date)
994: VALUES ( cst_cogs_events_s.nextval,
995: l_cogs_om_line_id_tbl(i),
996: l_txn_date_tbl(i),
997: l_mmt_txn_id_tbl(i),
998: l_prior_percent_tbl(i), -- COGS percentage
1078: cogs_acct_id,
1079: opm_org_flag,
1080: acct_period_id
1081: )
1082: SELECT cst_cogs_events_s.nextval,
1083: decode(event_type, COGS_RECOGNITION_EVENT, mtl_material_transactions_s.nextval,
1084: COGS_REC_PERCENT_ADJUSTMENT, mtl_material_transactions_s.nextval,
1085: NULL),
1086: cce.cogs_om_line_id,
1983: program_application_id,
1984: program_id,
1985: program_update_date)
1986: VALUES(
1987: cst_cogs_events_s.nextval,
1988: l_cogs_om_line_id_tbl(i),
1989: --BUG#6809034 -- As JAN-XX is opened the transaction_date is AR recognition event date
1990: --But as the bug is only on the material transaction, this COGS event event_date remains
1991: --untouch to avoid breaking the current logic based on the CCE,CRCML,CRRL for CCE creation
1999: COGS_RECOGNITION_EVENT,
2000: NULL, -- event OM line ID
2001: l_event_quantity_tbl(i),
2002: 'N',
2003: cst_cogs_events_s.currval,
2004: -- WHO COLUMNS
2005: sysdate,
2006: p_user_id,
2007: sysdate,
2150: cogs_acct_id,
2151: opm_org_flag,
2152: acct_period_id
2153: )
2154: SELECT cst_cogs_events_s.nextval,
2155: mtl_material_transactions_s.nextval,
2156: cogs_om_line_id,
2157: event_date,
2158: l_prior_percentage_tbl(i), -- could also use cce.prior_cogs_percentage
2750: program_application_id,
2751: program_id,
2752: program_update_date)
2753: VALUES (
2754: cst_cogs_events_s.nextval,
2755: p_cogs_om_line_id,
2756: p_transaction_date,
2757: p_mmt_txn_id,
2758: 0, -- COGS %
2760: SO_ISSUE,
2761: p_cogs_om_line_id,
2762: p_quantity,
2763: 'N',
2764: nvl(l_parent_cce_id,cst_cogs_events_s.currval),
2765: -- WHO COLUMNS
2766: sysdate,
2767: p_user_id,
2768: sysdate,
3007: request_id,
3008: program_application_id,
3009: program_id,
3010: program_update_date)
3011: VALUES ( cst_cogs_events_s.nextval,
3012: p_cogs_om_line_id,
3013: p_transaction_date,
3014: NULL, -- Quantity Placeholder event - no corresponding MMT txn
3015: l_cogs_percentage,
3018: RMA_RECEIPT_PLACEHOLDER,
3019: p_rma_om_line_id,
3020: l_prior_event_quantity,
3021: NULL, -- RMA quantity placeholders are not costed
3022: cst_cogs_events_s.currval,
3023: -- WHO COLUMNS
3024: sysdate,
3025: p_user_id,
3026: sysdate,
3057: request_id,
3058: program_application_id,
3059: program_id,
3060: program_update_date)
3061: VALUES ( cst_cogs_events_s.nextval,
3062: p_cogs_om_line_id,
3063: p_transaction_date,
3064: p_mmt_txn_id,
3065: l_cogs_percentage,
3135: cogs_acct_id,
3136: opm_org_flag,
3137: acct_period_id
3138: )
3139: SELECT cst_cogs_events_s.nextval,
3140: decode(event_type, COGS_RECOGNITION_EVENT, mtl_material_transactions_s.nextval,
3141: COGS_REC_PERCENT_ADJUSTMENT, mtl_material_transactions_s.nextval,
3142: NULL),
3143: cce.cogs_om_line_id,
6743: PROCEDURE update_one_set_crrl
6744: (p_rowid_tab IN DBMS_SQL.VARCHAR2_TABLE) IS
6745: l_gp_id NUMBER;
6746: BEGIN
6747: SELECT cst_cogs_events_s.nextval
6748: INTO l_gp_id
6749: FROM dual;
6750:
6751: FORALL j IN p_rowid_tab.FIRST .. p_rowid_tab.LAST