APPS.PA_FUNDS_CONTROL_PKG dependencies on GL_BC_PACKETS_S

Line 12053: SELECT gl_bc_packets_s.nextval

12049: x_e_code VARCHAR2(10);
12050: x_e_stage VARCHAR2(2000);
12051:
12052: CURSOR cur_packets IS
12053: SELECT gl_bc_packets_s.nextval
12054: FROM dual;
12055:
12056: CURSOR cur_sob(v_packet_id number) IS
12057: SELECT set_of_books_id

Line 12643: -- Update gl_bc_packets status such that GL FC will not execute funds

12639: log_message(p_msg_token1 => 'The return code of the FC process :'||l_packet_status);
12640: end if;
12641:
12642: -- --------------------------------------------------------------------------+
12643: -- Update gl_bc_packets status such that GL FC will not execute funds
12644: -- avaialble validation ... This is for no/separate line burdening
12645: -- --------------------------------------------------------------------------+
12646: --IF p_calling_module in ('GL','CBC') and l_mode IN ('R','C','F') then
12647:

Line 13210: -- gl bc packets status code based on partial flag.

13206: );
13207:
13208: -- Cursor to check the number of failed/passed records in gl and accordingly pass return status back to PSA.
13209: -- Note : No need to have partial flag logic here as procedure update_GL_CBC_result_code has already stamped
13210: -- gl bc packets status code based on partial flag.
13211: -- Output values :
13212: -- return 'F' if all have failed --fail
13213: -- return 'P' if some of the records have failed --partial
13214: -- return 'S' if all have success --success

Line 14100: l_source_distribution_type gl_bc_packets.source_distribution_type%TYPE;

14096:
14097: l_session_id pa_bc_packets.session_id%TYPE;
14098: l_serial_id pa_bc_packets.serial_id%TYPE;
14099: l_event_id pa_bc_packets.source_event_id%TYPE;
14100: l_source_distribution_type gl_bc_packets.source_distribution_type%TYPE;
14101:
14102: PRAGMA AUTONOMOUS_TRANSACTION;
14103: BEGIN
14104: l_program_name := 'Synch_data:';