[Home] [Help]
2: /* $Header: payxlaupg.pkb 120.0.12010000.4 2009/01/28 10:00:51 priupadh noship $*/
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: -------------------------------------------------------------------------------------
563: FUNCTION get_sequence_value(p_row_number in number,p_tab_name varchar2)
564: return number is
565: BEGIN
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
565: BEGIN
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;
750: End if;
751:
752: INSERT ALL
753: WHEN (rank_id=1) then
754: INTO xla_transaction_entities (
755: upg_batch_id,
756: entity_id,
757: application_id,
758: ledger_id,
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,
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,