APPS.PAY_SLA_UPDATE_PKG dependencies on XLA_AE_HEADERS

Line 8: g_xla_headers_s xla_ae_headers.ae_header_id%type;

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
12: -- Function : To transfer qualified periods to PAY_PATCH_STATUS.

Line 574: xla_ae_headers_s.nextval

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;
578: else

Line 587: if p_tab_name='xla_ae_headers' then

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
588: return g_xla_headers_s;
589: end if;
590:
591: END get_sequence_value;

Line 823: INTO xla_ae_headers (

819: last_updated_by,
820: last_update_login,
821: EFFECTIVE_DATE,
822: lv_application_id)
823: INTO xla_ae_headers (
824: upg_batch_id,
825: application_id,
826: amb_context_code,
827: entity_id,

Line 855: xla_ae_headers_seq,

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,
858: EFFECTIVE_DATE,
859: period_name,

Line 914: xla_ae_headers_seq,

910: ledger_id,
911: mpa_accrual_entry_flag)
912: VALUES (l_upg_batch_id,
913: lv_application_id,
914: xla_ae_headers_seq,
915: rank_id,
916: code_combination_id,
917: 'S',
918: line_desc,

Line 955: xla_ae_headers_seq,

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,
959: 'N',

Line 960: xla_ae_headers_seq,

956: rank_id,
957: action_type,
958: TGL_ASSIGNMENT_ACTION_ID,
959: 'N',
960: xla_ae_headers_seq,
961: rank_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,

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

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,
971: currency_code,