APPS.PQH_GL_POSTING dependencies on GL_BC_PACKETS_S

Line 1691: SELECT gl_bc_packets_s.nextval

1687: GROUP BY period_name, accounting_date,code_combination_id,
1688: cost_allocation_keyflex_id,currency_code;
1689:
1690: CURSOR csr_packet_id IS
1691: SELECT gl_bc_packets_s.nextval
1692: FROM dual;
1693:
1694: CURSOR csr_period_name( p_period_name IN varchar2 ) IS
1695: SELECT *

Line 6065: l_session_id gl_bc_packets.session_id%TYPE DEFAULT -1;

6061: --
6062: l_proc varchar2(72) := g_package||'.ins_gl_bc_run_fund_check';
6063: l_fc_success boolean;
6064: l_fc_return varchar2(100);
6065: l_session_id gl_bc_packets.session_id%TYPE DEFAULT -1;
6066: l_serial_id gl_bc_packets.serial_id%TYPE DEFAULT -1;
6067: l_application_id gl_bc_packets.application_id%TYPE ;
6068: PRAGMA AUTONOMOUS_TRANSACTION;
6069:

Line 6066: l_serial_id gl_bc_packets.serial_id%TYPE DEFAULT -1;

6062: l_proc varchar2(72) := g_package||'.ins_gl_bc_run_fund_check';
6063: l_fc_success boolean;
6064: l_fc_return varchar2(100);
6065: l_session_id gl_bc_packets.session_id%TYPE DEFAULT -1;
6066: l_serial_id gl_bc_packets.serial_id%TYPE DEFAULT -1;
6067: l_application_id gl_bc_packets.application_id%TYPE ;
6068: PRAGMA AUTONOMOUS_TRANSACTION;
6069:
6070: BEGIN