APPS.PSA_FUNDS_CHECKER_PKG dependencies on GL_BC_PACKETS_S

Line 2545: select gl_bc_packets_s.nextval

2541:
2542: FUNCTION glxfiu RETURN BOOLEAN IS
2543:
2544: cursor pkt_id is
2545: select gl_bc_packets_s.nextval
2546: from dual;
2547:
2548: l_dummy VARCHAR2(80);
2549:

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

4131: FROM gl_bc_packets bc
4132: WHERE bc.packet_id = p_packet_id
4133: AND bc.result_code like 'F%';
4134:
4135: TYPE source_dist_id_num_1_tbl_type IS TABLE OF gl_bc_packets.source_distribution_id_num_1%type INDEX BY binary_integer;
4136:
4137: l_source_dist_id_num_1_tbl source_dist_id_num_1_tbl_type;
4138:
4139: -- Bug 5571064 .. End

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

7721: END bc_purge_hist;
7722:
7723: /*=======================================================================+
7724: | Function : GET_PACKET_ID |
7725: | Description : Returns the next packet_id using gl_bc_packets_s seq |
7726: +=======================================================================*/
7727:
7728: FUNCTION get_packet_id RETURN NUMBER IS
7729: l_pkt_id gl_bc_packets.packet_id%type;

Line 7735: select gl_bc_packets_s.nextval into l_pkt_id

7731: BEGIN
7732:
7733: l_full_path := g_path||'Get_Packet_Id';
7734:
7735: select gl_bc_packets_s.nextval into l_pkt_id
7736: from dual;
7737:
7738: -- =========================== FND LOG ===========================
7739: psa_utils.debug_other_string(g_state_level,l_full_path, ' l_pkt_id -> ' || l_pkt_id);

Line 7938: l_session_id gl_bc_packets.session_id%type;

7934: l_date varchar2(50);
7935: l_header boolean;
7936: l_je_first boolean;
7937: l_ledger_id gl_automatic_posting_options.ledger_id%TYPE;
7938: l_session_id gl_bc_packets.session_id%type;
7939: l_serial_id gl_bc_packets.serial_id%type;
7940: l_seg_ccid varchar2(200);
7941: l_je_header_name gl_je_headers.name%TYPE;
7942: l_je_header_id gl_je_headers.je_header_id%TYPE;

Line 7939: l_serial_id gl_bc_packets.serial_id%type;

7935: l_header boolean;
7936: l_je_first boolean;
7937: l_ledger_id gl_automatic_posting_options.ledger_id%TYPE;
7938: l_session_id gl_bc_packets.session_id%type;
7939: l_serial_id gl_bc_packets.serial_id%type;
7940: l_seg_ccid varchar2(200);
7941: l_je_header_name gl_je_headers.name%TYPE;
7942: l_je_header_id gl_je_headers.je_header_id%TYPE;
7943: l_je_line_num gl_je_lines.je_line_num%TYPE;

Line 9754: l_session_id gl_bc_packets.session_id%type;

9750:
9751: FUNCTION budgetary_control (p_ledgerid IN NUMBER,
9752: p_return_code OUT NOCOPY VARCHAR2) return BOOLEAN IS
9753:
9754: l_session_id gl_bc_packets.session_id%type;
9755: l_serial_id gl_bc_packets.serial_id%type;
9756:
9757: l_packet_id gl_bc_packets.packet_id%type;
9758: l_bc_pkts bc_pkts_rec;

Line 9755: l_serial_id gl_bc_packets.serial_id%type;

9751: FUNCTION budgetary_control (p_ledgerid IN NUMBER,
9752: p_return_code OUT NOCOPY VARCHAR2) return BOOLEAN IS
9753:
9754: l_session_id gl_bc_packets.session_id%type;
9755: l_serial_id gl_bc_packets.serial_id%type;
9756:
9757: l_packet_id gl_bc_packets.packet_id%type;
9758: l_bc_pkts bc_pkts_rec;
9759: l_packets num_rec;