[Home] [Help]
566:
567: if p_tab_name='xla_transaction_entities' then
568: If p_row_number = 1 then
569: select xla_transaction_entities_s.nextval,
570: xla_events_s.nextval,
571: xla_ae_headers_s.nextval
572: into g_xla_tran_s,g_xla_event_s,g_xla_headers_s
573: from dual;
574: return g_xla_tran_s;
802: upg_source_application_id)
803: VALUES (l_upg_batch_id,
804: lv_application_id,
805: xla_transaction_seq,
806: xla_events_seq,
807: 1,
808: EVENT_TYPE_CODE,
809: EFFECTIVE_DATE,
810: 'P',
846: VALUES (l_upg_batch_id,
847: lv_application_id,
848: 'DEFAULT',
849: xla_transaction_seq,
850: xla_events_seq,
851: EVENT_TYPE_CODE,
852: xla_ae_headers_seq,
853: ledger_id,
854: lv_application_name,
872: event_id,
873: assignment_action_id,
874: accounting_date,
875: event_status)
876: VALUES(xla_events_seq,
877: TGL_ASSIGNMENT_ACTION_ID,
878: EFFECTIVE_DATE,
879: 'P')
880: WHEN (1=1) then
947: event_class_code,
948: event_type_code)
949: VALUES (l_upg_batch_id,
950: lv_application_id,
951: xla_events_seq,
952: xla_ae_headers_seq,
953: rank_id,
954: action_type,
955: TGL_ASSIGNMENT_ACTION_ID,
959: EVENT_CLASS_CODE,
960: DIS_EVENT_TYPE_CODE)
961: SELECT row_number() over(partition by tgl_assignment_action_id order by debit_or_credit) RANK_ID,
962: get_sequence_value((row_number() over(partition by tgl_assignment_action_id order by debit_or_credit)),'xla_transaction_entities') xla_transaction_seq,
963: get_sequence_value((row_number() over(partition by tgl_assignment_action_id order by debit_or_credit)),'xla_events') xla_events_seq,
964: get_sequence_value((row_number() over(partition by tgl_assignment_action_id order by debit_or_credit)),'xla_ae_headers') xla_ae_headers_seq,
965: ledger_id,
966: period_name,
967: je_header_id,