eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_COMMITMENT_POSTING dependencies on GL_BC_PACKETS

Line 91: ( p_packet_id IN gl_bc_packets.packet_id%TYPE

87: ) ;
88:
89: -- Procedure added to run funds checker in autonomous transaction
90: PROCEDURE ins_gl_bc_run_fund_check
91: ( p_packet_id IN gl_bc_packets.packet_id%TYPE
92: ,p_code_combination_id IN pqh_gl_interface.code_combination_id%TYPE
93: ,p_period_name IN pqh_gl_interface.period_name%TYPE
94: ,p_period_year IN gl_period_statuses.period_year%TYPE
95: ,p_period_num IN gl_period_statuses.period_num%TYPE

Line 935: -- get the table route id for gl_bc_packets

931: FETCH csr_table_route INTO g_table_route_id_bfs;
932: CLOSE csr_table_route;
933:
934: --
935: -- get the table route id for gl_bc_packets
936: --
937: OPEN csr_table_route(p_table_alias => 'GLF');
938: FETCH csr_table_route INTO g_table_route_id_glf;
939: CLOSE csr_table_route;

Line 2683: -- gl tables depending on the g_budgetary_control_flag If we insert into gl_bc_packets

2679: --
2680: -----------------------------------------------------------------------------------------
2681: --
2682: -- This procedure will pick records from pqh_gl_interface table and insert them into
2683: -- gl tables depending on the g_budgetary_control_flag If we insert into gl_bc_packets
2684: -- do funds checking for each packet
2685: --
2686: PROCEDURE populate_gl_tables
2687: IS

Line 2699: l_packet_id gl_bc_packets.packet_id%TYPE;

2695: l_cost_allocation_keyflex_id pqh_gl_interface.cost_allocation_keyflex_id%TYPE;
2696: l_currency_code pqh_gl_interface.currency_code%TYPE;
2697: l_amount_dr pqh_gl_interface.amount_dr%TYPE;
2698: l_amount_cr pqh_gl_interface.amount_cr%TYPE;
2699: l_packet_id gl_bc_packets.packet_id%TYPE;
2700: l_gl_period_statuses_rec gl_period_statuses%ROWTYPE;
2701: l_fc_success boolean;
2702: l_fc_return varchar2(100);
2703: l_fc_mode varchar2(100);

Line 2724: SELECT gl_bc_packets_s.nextval

2720: GROUP BY period_name, accounting_date,code_combination_id,
2721: cost_allocation_keyflex_id,currency_code;
2722: --
2723: CURSOR csr_packet_id IS
2724: SELECT gl_bc_packets_s.nextval
2725: FROM dual;
2726: --
2727: CURSOR csr_period_name( p_period_name IN varchar2 ) IS
2728: SELECT *

Line 2743: FROM gl_bc_packets

2739: AND NVL(enabled_flag,'N') = 'Y';
2740: --
2741: CURSOR csr_gl_packet_code(p_packet_id IN number ) IS
2742: SELECT result_code
2743: FROM gl_bc_packets
2744: WHERE packet_id = p_packet_id;
2745: --
2746: CURSOR csr_gl_status(p_lookup_code IN varchar2 ) IS
2747: SELECT description

Line 2761: -- insert into gl_bc_packets and do funds checking for each packet

2757: hr_utility.set_location('Entering: '||l_proc, 5);
2758: --
2759: IF g_budgetary_control_flag = 'Y' THEN
2760: --
2761: -- insert into gl_bc_packets and do funds checking for each packet
2762: --
2763: hr_utility.set_location('Inserting into GL_BC_PACKETS',10);
2764: --
2765: OPEN csr_pqh_gl_interface;

Line 2763: hr_utility.set_location('Inserting into GL_BC_PACKETS',10);

2759: IF g_budgetary_control_flag = 'Y' THEN
2760: --
2761: -- insert into gl_bc_packets and do funds checking for each packet
2762: --
2763: hr_utility.set_location('Inserting into GL_BC_PACKETS',10);
2764: --
2765: OPEN csr_pqh_gl_interface;
2766: LOOP
2767: --

Line 2818: -- Insert in gl_bc_packets and run funds checker

2814: -- Mode = C (Checking) if program is run in validate mode i.e g_validate = TRUE
2815: -- Mode C is never called as there as explicit commits in GL funds checker program , so
2816: -- we call the GL funds checker program only when g_validate is FALSE in R or U mode
2817:
2818: -- Insert in gl_bc_packets and run funds checker
2819: hr_utility.set_location('Calling ins_gl_bc_run_fund_check with fund checker Mode : '||l_fc_mode,100);
2820:
2821: ins_gl_bc_run_fund_check
2822: ( p_packet_id => l_packet_id

Line 3823: -- insert into gl_interface or gl_bc_packets table if not in validate mode

3819: END IF;
3820: --
3821: **/
3822: --
3823: -- insert into gl_interface or gl_bc_packets table if not in validate mode
3824: --
3825: IF NOT g_validate THEN
3826: --
3827: populate_gl_tables;

Line 4370: ( p_packet_id IN gl_bc_packets.packet_id%TYPE

4366:
4367: /**************************************************************/
4368:
4369: PROCEDURE ins_gl_bc_run_fund_check
4370: ( p_packet_id IN gl_bc_packets.packet_id%TYPE
4371: ,p_code_combination_id IN pqh_gl_interface.code_combination_id%TYPE
4372: ,p_period_name IN pqh_gl_interface.period_name%TYPE
4373: ,p_period_year IN gl_period_statuses.period_year%TYPE
4374: ,p_period_num IN gl_period_statuses.period_num%TYPE

Line 4388: This procedure Inserts in gl_bc_packets , commits so that the data is available

4384: ,p_fc_return OUT NOCOPY varchar2
4385: )
4386: IS
4387: /*
4388: This procedure Inserts in gl_bc_packets , commits so that the data is available
4389: for the autonomous funds checker and runs funds checker returns as argument funds
4390: checker return code and success flag
4391: */
4392: --

Line 4404: INSERT INTO gl_bc_packets

4400:
4401: BEGIN
4402: hr_utility.set_location('Entering: '||l_proc, 5);
4403:
4404: INSERT INTO gl_bc_packets
4405: (packet_id,
4406: ledger_id,
4407: je_source_name,
4408: je_category_name,

Line 4450: -- Commit so that the gl_bc_packets records are visible to fundschecker

4446: g_budget_version_id,
4447: p_cost_allocation_keyflex_id );
4448:
4449: -- Funds Checker is run in autonomous mode.
4450: -- Commit so that the gl_bc_packets records are visible to fundschecker
4451: commit;
4452:
4453: hr_utility.set_location('Calling GL fund checker in Mode : '||p_fc_mode,100);
4454: