APPS.PAY_SLA_UPDATE_PKG dependencies on XLA_EVENTS

Line 7: g_xla_event_s xla_events.event_id%type;

3: g_pkg_name CONSTANT VARCHAR2(30) := 'PAY_SLA_UPDATE_PKG';
4: gv_process_name CONSTANT varchar2(10) := 'PAYSLAUPG';
5:
6: g_xla_tran_s xla_transaction_entities.entity_id%type;
7: g_xla_event_s xla_events.event_id%type;
8: g_xla_headers_s xla_ae_headers.ae_header_id%type;
9:
10: -------------------------------------------------------------------------------------
11: -- Name : Trans_Pay_Patch_Status

Line 570: xla_events_s.nextval,

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;

Line 580: if p_tab_name='xla_events' then

576: return g_xla_tran_s;
577: end if;
578: end if;
579:
580: if p_tab_name='xla_events' then
581: return g_xla_event_s;
582: end if;
583:
584: if p_tab_name='xla_ae_headers' then

Line 785: INTO xla_events (

781: last_updated_by,
782: last_update_login,
783: lv_application_id,
784: lv_application_id)
785: INTO xla_events (
786: upg_batch_id,
787: application_id,
788: entity_id,
789: event_id,

Line 806: xla_events_seq,

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',

Line 850: xla_events_seq,

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,

Line 871: INTO pay_xla_events(

867: last_update_login,
868: 'N',
869: 'N',
870: lv_application_id)
871: INTO pay_xla_events(
872: event_id,
873: assignment_action_id,
874: accounting_date,
875: event_status)

Line 876: VALUES(xla_events_seq,

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

Line 951: xla_events_seq,

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,

Line 963: get_sequence_value((row_number() over(partition by tgl_assignment_action_id order by debit_or_credit)),'xla_events') xla_events_seq,

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,