[Home] [Help]
185: INSERT ALL /*+ rowid(dr) leading(dr) */
186: WHEN (/*unbilled_receivable_dr <> 0 Commented for Bug 10302541
187: and */unbilled_code_combination_id is not null
188: and currency_code is not null)THEN /*5455002*/
189: INTO PA_XLA_LINES_TMP
190: ( project_id,
191: draft_revenue_num,
192: ae_header_id,
193: xla_event_id,
221: )
222: WHEN (/*unearned_revenue_cr <> 0 Commented for Bug 10302541
223: and */ unearned_code_combination_id is not null
224: and currency_code is not null) THEN /*5455002*/
225: INTO PA_XLA_LINES_TMP
226: ( project_id,
227: draft_revenue_num,
228: ae_header_id,
229: xla_event_id,
257: )
258: WHEN (realized_gains_amount <> 0
259: and realized_gains_ccid is not null
260: and currency_code is not null) THEN /*5455002*/
261: INTO PA_XLA_LINES_TMP
262: ( project_id,
263: draft_revenue_num,
264: ae_header_id,
265: xla_event_id,
293: )
294: WHEN (realized_losses_amount <> 0
295: and realized_losses_ccid is not null
296: and currency_code is not null) THEN/*5455002*/
297: INTO PA_XLA_LINES_TMP
298: ( project_id,
299: draft_revenue_num,
300: ae_header_id,
301: xla_event_id,
789: gl_category,
790: rownum row_num,
791: accounting_date,
792: ledger_id
793: FROM PA_XLA_LINES_TMP DR);
794:
795:
796: UPDATE PA_DRAFT_REVENUES_ALL dr
797: SET dr.event_id = ( select tmp.xla_event_id
924: INSERT ALL /*+ rowid(mc) leading(mc) */
925: WHEN (mc_unbilled_receivable_dr <> 0
926: and unbilled_code_combination_id is not null
927: and currency_code is not null)THEN /*5455002*/
928: INTO PA_XLA_LINES_TMP
929: ( project_id,
930: draft_revenue_num,
931: ae_header_id,
932: xla_event_id,
968: )
969: WHEN (mc_unearned_revenue_cr <> 0
970: and unearned_code_combination_id is not null
971: and currency_code is not null) THEN /*5455002*/
972: INTO PA_XLA_LINES_TMP
973: ( project_id,
974: draft_revenue_num,
975: ae_header_id,
976: xla_event_id,
1012: )
1013: WHEN (mc_realized_gains_amount <> 0
1014: and realized_gains_ccid is not null
1015: and currency_code is not null) THEN /*5455002*/
1016: INTO PA_XLA_LINES_TMP
1017: ( project_id,
1018: draft_revenue_num,
1019: ae_header_id,
1020: xla_event_id,
1056: )
1057: WHEN (mc_realized_losses_amount <> 0
1058: and realized_losses_ccid is not null
1059: and currency_code is not null)THEN /*5455002*/
1060: INTO PA_XLA_LINES_TMP
1061: ( project_id,
1062: draft_revenue_num,
1063: ae_header_id,
1064: xla_event_id,
1527: gl_category,
1528: rownum row_num,
1529: accounting_date,
1530: ledger_id
1531: FROM PA_XLA_LINES_TMP MC );
1532:
1533: UPDATE PA_MC_DRAFT_REVS_ALL mc
1534: SET mc.xla_migrated_flag = 'Y'
1535: WHERE mc.rowid >= p_start_rowid