[Home] [Help]
445: regular flow where one event is raised per expenditrue_item_id/line_type(R/C+D/BL/PC)/gl_date combination
446:
447: Xla_transaction_entities has a non unique index N1 on columns(application_id,ledger_id,entity_code,source_id..)*/
448:
449: INSERT ALL INTO XLA_EVENTS
450: (upg_batch_id,
451: upg_source_application_id,
452: application_id,
453: event_type_code,
472: (p_upg_batch_id,
473: l_pa_app_id,
474: l_pa_app_id,
475: event_type_code,
476: xla_events_s.nextval,
477: 'P', --event status
478: 'P', --process status
479: 'N',
480: gl_date, --event date
487: l_user,
488: l_pa_app_id,
489: l_request_id,
490: entity_id,
491: xla_events_s.nextval,
492: gl_date
493: )
494: INTO XLA_AE_HEADERS
495: (upg_batch_id,
522: l_pa_app_id,
523: l_pa_app_id,
524: 'DEFAULT',
525: entity_id,
526: xla_events_s.nextval,
527: event_type_code,
528: xla_ae_headers_s.nextval,
529: ledger_id,
530: gl_date,
552: header_id
553: )
554: VALUES
555: (expenditure_item_id,
556: xla_events_s.nextval,
557: grouped_line_type,
558: gl_date,
559: xla_ae_headers_s.nextval
560: )
1109: from PA_MC_COST_DIST_LINES_ALL mc,
1110: PA_COST_DISTRIBUTION_LINES_ALL cdl,
1111: PA_EXPENDITURE_ITEMS_ALL ei,
1112: PA_IMPLEMENTATIONS_ALL imp,
1113: XLA_EVENTS evt,
1114: HR_ORGANIZATION_INFORMATION hoi
1115: where mc.expenditure_item_id = cdl.expenditure_item_id
1116: and mc.line_num = cdl.line_num
1117: and mc.xla_migrated_flag is null
1160: from PA_MC_CC_DIST_LINES_ALL mc,
1161: PA_CC_DIST_LINES_ALL cdl,
1162: PA_EXPENDITURE_ITEMS_ALL ei,
1163: PA_IMPLEMENTATIONS_ALL imp,
1164: XLA_EVENTS evt,
1165: HR_ORGANIZATION_INFORMATION hoi
1166: where mc.expenditure_item_id = cdl.expenditure_item_id
1167: and mc.line_num = cdl.line_num
1168: and mc.xla_migrated_flag is null