[Home] [Help]
2: /* $Header: payxlaupg.pkb 120.4 2011/09/26 09:45:27 kskoduri ship $*/
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: -------------------------------------------------------------------------------------
566: FUNCTION get_sequence_value(p_row_number in number,p_tab_name varchar2)
567: return number is
568: BEGIN
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
568: BEGIN
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;
753: End if;
754:
755: INSERT ALL
756: WHEN (rank_id=1) then
757: INTO xla_transaction_entities (
758: upg_batch_id,
759: entity_id,
760: application_id,
761: ledger_id,
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,
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,