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 571: xla_ae_headers_s.nextval

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

Line 584: if p_tab_name='xla_ae_headers' then

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
585: return g_xla_headers_s;
586: end if;
587:
588: END get_sequence_value;

Line 820: INTO xla_ae_headers (

816: last_updated_by,
817: last_update_login,
818: EFFECTIVE_DATE,
819: lv_application_id)
820: INTO xla_ae_headers (
821: upg_batch_id,
822: application_id,
823: amb_context_code,
824: entity_id,

Line 852: xla_ae_headers_seq,

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,
855: EFFECTIVE_DATE,
856: period_name,

Line 911: xla_ae_headers_seq,

907: ledger_id,
908: mpa_accrual_entry_flag)
909: VALUES (l_upg_batch_id,
910: lv_application_id,
911: xla_ae_headers_seq,
912: rank_id,
913: code_combination_id,
914: 'S',
915: line_desc,

Line 952: xla_ae_headers_seq,

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

Line 957: xla_ae_headers_seq,

953: rank_id,
954: action_type,
955: TGL_ASSIGNMENT_ACTION_ID,
956: 'N',
957: xla_ae_headers_seq,
958: rank_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,

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

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