66:
67: BEGIN
68: SELECT 1
69: INTO lv_temp
70: FROM Dual
71: WHERE EXISTS (SELECT 1
72: FROM Pay_Patch_Status pps
73: WHERE Process_Type = gv_process_name
74: AND pps.Patch_Number = a.Ledger_Id
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
576: return g_xla_tran_s;
577: end if;