APPS.IGI_DOS_FUNDS dependencies on GL_BC_PACKETS_S

Line 78: l_session_id gl_bc_packets.session_id%type;

74: PRAGMA AUTONOMOUS_TRANSACTION;
75:
76: --l_trx_id NUMBER;
77:
78: l_session_id gl_bc_packets.session_id%type;
79: l_serial_id gl_bc_packets.serial_id%type;
80: l_application_id gl_bc_packets.application_id%type;
81:
82:

Line 79: l_serial_id gl_bc_packets.serial_id%type;

75:
76: --l_trx_id NUMBER;
77:
78: l_session_id gl_bc_packets.session_id%type;
79: l_serial_id gl_bc_packets.serial_id%type;
80: l_application_id gl_bc_packets.application_id%type;
81:
82:
83: CURSOR get_dest (p_source_trx_id igi_dos_trx_dest.source_trx_id%TYPE)

Line 319: l_session_id gl_bc_packets.session_id%type;

315: P_source_trx_id number ) AS
316:
317: PRAGMA AUTONOMOUS_TRANSACTION;
318:
319: l_session_id gl_bc_packets.session_id%type;
320: l_serial_id gl_bc_packets.serial_id%type;
321: l_application_id gl_bc_packets.application_id%type;
322:
323:

Line 320: l_serial_id gl_bc_packets.serial_id%type;

316:
317: PRAGMA AUTONOMOUS_TRANSACTION;
318:
319: l_session_id gl_bc_packets.session_id%type;
320: l_serial_id gl_bc_packets.serial_id%type;
321: l_application_id gl_bc_packets.application_id%type;
322:
323:
324: BEGIN

Line 610: SELECT gl_bc_packets_s.nextval

606: Debug_log_string (l_proc_level, 'Approve.Msg25',
607: ' l_packet_id --> ' || l_packet_id);
608: -- =============== END DEBUG LOG ==================
609:
610: SELECT gl_bc_packets_s.nextval
611: INTO v_packet_id
612: FROM dual;
613:
614: -- Bug 9128478 : Storing the generated packet details

Line 1148: SELECT gl_bc_packets_s.nextval

1144: Debug_log_string (l_proc_level, 'Reject.Msg26',
1145: ' l_packet_id --> '|| l_packet_id);
1146: -- =============== END DEBUG LOG ==================
1147:
1148: SELECT gl_bc_packets_s.nextval
1149: INTO v_packet_id
1150: FROM dual;
1151:
1152: -- =============== START DEBUG LOG ================