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 573: xla_events_s.nextval,

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;

Line 583: if p_tab_name='xla_events' then

579: return g_xla_tran_s;
580: end if;
581: end if;
582:
583: if p_tab_name='xla_events' then
584: return g_xla_event_s;
585: end if;
586:
587: if p_tab_name='xla_ae_headers' then

Line 788: INTO xla_events (

784: last_updated_by,
785: last_update_login,
786: lv_application_id,
787: lv_application_id)
788: INTO xla_events (
789: upg_batch_id,
790: application_id,
791: entity_id,
792: event_id,

Line 809: xla_events_seq,

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

Line 853: xla_events_seq,

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,

Line 874: INTO pay_xla_events(

870: last_update_login,
871: 'N',
872: 'N',
873: lv_application_id)
874: INTO pay_xla_events(
875: event_id,
876: assignment_action_id,
877: accounting_date,
878: event_status)

Line 879: VALUES(xla_events_seq,

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

Line 954: xla_events_seq,

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,

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

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,