[Home] [Help]
435: regular flow where one event is raised per expenditrue_item_id/line_type(R/C+D/BL/PC)/gl_date combination
436:
437: Xla_transaction_entities has a non unique index N1 on columns(application_id,ledger_id,entity_code,source_id..)*/
438:
439: INSERT ALL INTO XLA_EVENTS
440: (upg_batch_id,
441: upg_source_application_id,
442: application_id,
443: event_type_code,
462: (p_upg_batch_id,
463: l_pa_app_id,
464: l_pa_app_id,
465: event_type_code,
466: xla_events_s.nextval,
467: 'P', --event status
468: 'P', --process status
469: 'N',
470: gl_date, --event date
477: l_user,
478: l_pa_app_id,
479: l_request_id,
480: entity_id,
481: xla_events_s.nextval,
482: gl_date
483: )
484: INTO XLA_AE_HEADERS
485: (upg_batch_id,
512: l_pa_app_id,
513: l_pa_app_id,
514: 'DEFAULT',
515: entity_id,
516: xla_events_s.nextval,
517: event_type_code,
518: xla_ae_headers_s.nextval,
519: ledger_id,
520: gl_date,
542: header_id
543: )
544: VALUES
545: (expenditure_item_id,
546: xla_events_s.nextval,
547: grouped_line_type,
548: gl_date,
549: xla_ae_headers_s.nextval
550: )
1098: from PA_MC_COST_DIST_LINES_ALL mc,
1099: PA_COST_DISTRIBUTION_LINES_ALL cdl,
1100: PA_EXPENDITURE_ITEMS_ALL ei,
1101: PA_IMPLEMENTATIONS_ALL imp,
1102: XLA_EVENTS evt,
1103: HR_ORGANIZATION_INFORMATION hoi
1104: where mc.expenditure_item_id = cdl.expenditure_item_id
1105: and mc.line_num = cdl.line_num
1106: and mc.xla_migrated_flag is null
1149: from PA_MC_CC_DIST_LINES_ALL mc,
1150: PA_CC_DIST_LINES_ALL cdl,
1151: PA_EXPENDITURE_ITEMS_ALL ei,
1152: PA_IMPLEMENTATIONS_ALL imp,
1153: XLA_EVENTS evt,
1154: HR_ORGANIZATION_INFORMATION hoi
1155: where mc.expenditure_item_id = cdl.expenditure_item_id
1156: and mc.line_num = cdl.line_num
1157: and mc.xla_migrated_flag is null