APPS.PSA_FUNDS_CHECKER_PKG dependencies on GL_BC_PACKETS_S

Line 2534: select gl_bc_packets_s.nextval

2530:
2531: FUNCTION glxfiu RETURN BOOLEAN IS
2532:
2533: cursor pkt_id is
2534: select gl_bc_packets_s.nextval
2535: from dual;
2536:
2537: l_dummy VARCHAR2(80);
2538:

Line 4060: TYPE source_dist_id_num_1_tbl_type IS TABLE OF gl_bc_packets.source_distribution_id_num_1%type INDEX BY binary_integer;

4056: FROM gl_bc_packets bc
4057: WHERE bc.packet_id = p_packet_id
4058: AND bc.result_code like 'F%';
4059:
4060: TYPE source_dist_id_num_1_tbl_type IS TABLE OF gl_bc_packets.source_distribution_id_num_1%type INDEX BY binary_integer;
4061:
4062: l_source_dist_id_num_1_tbl source_dist_id_num_1_tbl_type;
4063:
4064: -- Bug 5571064 .. End

Line 7539: | Description : Returns the next packet_id using gl_bc_packets_s seq |

7535: END bc_purge_hist;
7536:
7537: /*=======================================================================+
7538: | Function : GET_PACKET_ID |
7539: | Description : Returns the next packet_id using gl_bc_packets_s seq |
7540: +=======================================================================*/
7541:
7542: FUNCTION get_packet_id RETURN NUMBER IS
7543: l_pkt_id gl_bc_packets.packet_id%type;

Line 7549: select gl_bc_packets_s.nextval into l_pkt_id

7545: BEGIN
7546:
7547: l_full_path := g_path||'Get_Packet_Id';
7548:
7549: select gl_bc_packets_s.nextval into l_pkt_id
7550: from dual;
7551:
7552: -- =========================== FND LOG ===========================
7553: psa_utils.debug_other_string(g_state_level,l_full_path, ' l_pkt_id -> ' || l_pkt_id);

Line 7752: l_session_id gl_bc_packets.session_id%type;

7748: l_date varchar2(50);
7749: l_header boolean;
7750: l_je_first boolean;
7751: l_ledger_id gl_automatic_posting_options.ledger_id%TYPE;
7752: l_session_id gl_bc_packets.session_id%type;
7753: l_serial_id gl_bc_packets.serial_id%type;
7754: l_seg_ccid varchar2(200);
7755: l_je_header_name gl_je_headers.name%TYPE;
7756: l_je_header_id gl_je_headers.je_header_id%TYPE;

Line 7753: l_serial_id gl_bc_packets.serial_id%type;

7749: l_header boolean;
7750: l_je_first boolean;
7751: l_ledger_id gl_automatic_posting_options.ledger_id%TYPE;
7752: l_session_id gl_bc_packets.session_id%type;
7753: l_serial_id gl_bc_packets.serial_id%type;
7754: l_seg_ccid varchar2(200);
7755: l_je_header_name gl_je_headers.name%TYPE;
7756: l_je_header_id gl_je_headers.je_header_id%TYPE;
7757: l_je_line_num gl_je_lines.je_line_num%TYPE;

Line 9485: l_session_id gl_bc_packets.session_id%type;

9481:
9482: FUNCTION budgetary_control (p_ledgerid IN NUMBER,
9483: p_return_code OUT NOCOPY VARCHAR2) return BOOLEAN IS
9484:
9485: l_session_id gl_bc_packets.session_id%type;
9486: l_serial_id gl_bc_packets.serial_id%type;
9487:
9488: l_packet_id gl_bc_packets.packet_id%type;
9489: l_bc_pkts bc_pkts_rec;

Line 9486: l_serial_id gl_bc_packets.serial_id%type;

9482: FUNCTION budgetary_control (p_ledgerid IN NUMBER,
9483: p_return_code OUT NOCOPY VARCHAR2) return BOOLEAN IS
9484:
9485: l_session_id gl_bc_packets.session_id%type;
9486: l_serial_id gl_bc_packets.serial_id%type;
9487:
9488: l_packet_id gl_bc_packets.packet_id%type;
9489: l_bc_pkts bc_pkts_rec;
9490: l_packets num_rec;