[Home] [Help]
569:
570: if p_tab_name='xla_transaction_entities' then
571: If p_row_number = 1 then
572: select xla_transaction_entities_s.nextval,
573: xla_events_s.nextval,
574: xla_ae_headers_s.nextval
575: into g_xla_tran_s,g_xla_event_s,g_xla_headers_s
576: from dual;
577: return g_xla_tran_s;
805: upg_source_application_id)
806: VALUES (l_upg_batch_id,
807: lv_application_id,
808: xla_transaction_seq,
809: xla_events_seq,
810: 1,
811: EVENT_TYPE_CODE,
812: EFFECTIVE_DATE,
813: 'P',
849: VALUES (l_upg_batch_id,
850: lv_application_id,
851: 'DEFAULT',
852: xla_transaction_seq,
853: xla_events_seq,
854: EVENT_TYPE_CODE,
855: xla_ae_headers_seq,
856: ledger_id,
857: lv_application_name,
875: event_id,
876: assignment_action_id,
877: accounting_date,
878: event_status)
879: VALUES(xla_events_seq,
880: TGL_ASSIGNMENT_ACTION_ID,
881: EFFECTIVE_DATE,
882: 'P')
883: WHEN (1=1) then
950: event_class_code,
951: event_type_code)
952: VALUES (l_upg_batch_id,
953: lv_application_id,
954: xla_events_seq,
955: xla_ae_headers_seq,
956: rank_id,
957: action_type,
958: TGL_ASSIGNMENT_ACTION_ID,
962: EVENT_CLASS_CODE,
963: DIS_EVENT_TYPE_CODE)
964: SELECT row_number() over(partition by tgl_assignment_action_id order by debit_or_credit) RANK_ID,
965: get_sequence_value((row_number() over(partition by tgl_assignment_action_id order by debit_or_credit)),'xla_transaction_entities') xla_transaction_seq,
966: get_sequence_value((row_number() over(partition by tgl_assignment_action_id order by debit_or_credit)),'xla_events') xla_events_seq,
967: get_sequence_value((row_number() over(partition by tgl_assignment_action_id order by debit_or_credit)),'xla_ae_headers') xla_ae_headers_seq,
968: ledger_id,
969: period_name,
970: je_header_id,