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_GL_POSTING dependencies on GL_BC_PACKETS

Line 94: ( p_packet_id IN gl_bc_packets.packet_id%TYPE

90:
91: PROCEDURE populate_gms_tables;
92:
93: PROCEDURE ins_gl_bc_run_fund_check
94: ( p_packet_id IN gl_bc_packets.packet_id%TYPE
95: ,p_code_combination_id IN pqh_gl_interface.code_combination_id%TYPE
96: ,p_period_name IN pqh_gl_interface.period_name%TYPE
97: ,p_period_year IN gl_period_statuses.period_year%TYPE
98: ,p_period_num IN gl_period_statuses.period_num%TYPE

Line 301: -- insert into gl_interface or gl_bc_packets table all Records that need to be transfered to GL

297: reverse_prev_posted_version;
298: END IF;
299:
300: -- if not in validate mode
301: -- insert into gl_interface or gl_bc_packets table all Records that need to be transfered to GL
302: -- For all Records that need to be transfered to Grants
303: -- insert into pa_interface_all table and call gms_pub api
304:
305: IF NOT p_validate THEN

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

832: OPEN csr_table_route(p_table_alias => 'BFS');
833: FETCH csr_table_route INTO g_table_route_id_bfs;
834: CLOSE csr_table_route;
835:
836: -- get the table route id for gl_bc_packets
837: OPEN csr_table_route(p_table_alias => 'GLF');
838: FETCH csr_table_route INTO g_table_route_id_glf;
839: CLOSE csr_table_route;
840:

Line 1652: If we insert into gl_bc_packets do funds checking for each packet

1648: IS
1649: /*
1650: This procedure will pick records from pqh_gl_interface table and insert them into
1651: gl tables depending on the g_budgetary_control_flag
1652: If we insert into gl_bc_packets do funds checking for each packet
1653: */
1654: --
1655: -- local variables
1656: --

Line 1666: l_packet_id gl_bc_packets.packet_id%TYPE;

1662: l_cost_allocation_keyflex_id pqh_gl_interface.cost_allocation_keyflex_id%TYPE;
1663: l_currency_code pqh_gl_interface.currency_code%TYPE;
1664: l_amount_dr pqh_gl_interface.amount_dr%TYPE;
1665: l_amount_cr pqh_gl_interface.amount_cr%TYPE;
1666: l_packet_id gl_bc_packets.packet_id%TYPE;
1667: l_gl_period_statuses_rec gl_period_statuses%ROWTYPE;
1668: l_fc_success boolean;
1669: l_fc_return varchar2(100);
1670: l_fc_mode varchar2(100);

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 1710: FROM gl_bc_packets

1706: AND NVL(enabled_flag,'N') = 'Y';
1707:
1708: CURSOR csr_gl_packet_code(p_packet_id IN number ) IS
1709: SELECT result_code
1710: FROM gl_bc_packets
1711: WHERE packet_id = p_packet_id;
1712:
1713: CURSOR csr_gl_status(p_lookup_code IN varchar2 ) IS
1714: SELECT description

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

1721:
1722: hr_utility.set_location('Entering: '||l_proc, 5);
1723:
1724: IF g_budgetary_control_flag = 'Y' THEN
1725: -- insert into gl_bc_packets and do funds checking for each packet
1726:
1727: hr_utility.set_location('Inserting into GL_BC_PACKETS',10);
1728:
1729: OPEN csr_pqh_gl_interface;

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

1723:
1724: IF g_budgetary_control_flag = 'Y' THEN
1725: -- insert into gl_bc_packets and do funds checking for each packet
1726:
1727: hr_utility.set_location('Inserting into GL_BC_PACKETS',10);
1728:
1729: OPEN csr_pqh_gl_interface;
1730: LOOP
1731: FETCH csr_pqh_gl_interface INTO l_period_name, l_accounting_date,

Line 1759: Insert in gl_bc_packets and Call the GL funds checker

1755: l_fc_mode := 'U';
1756: END IF;
1757: /*
1758: ------------------------------------------------------------------------------------------------
1759: Insert in gl_bc_packets and Call the GL funds checker
1760: The GL funds checker program has COMMIT inside the program so we cannot rollback
1761: The GL funds checker is only called when the validate flag is false i.e no validation
1762: -- do funds checking for each packet
1763: -- Mode = R (reserved) if amount is dr

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

1766: -- Mode C is never called as there as explicit commits in GL funds checker program , so
1767: -- we call the GL funds checker program only when p_validate is FALSE in R or U mode
1768: ------------------------------------------------------------------------------------------------
1769: */
1770: -- Insert in gl_bc_packets and run funds checker
1771: hr_utility.set_location('Calling ins_gl_bc_run_fund_check with fund checker Mode : '||l_fc_mode,100);
1772:
1773: ins_gl_bc_run_fund_check
1774: ( p_packet_id => l_packet_id

Line 6037: ( p_packet_id IN gl_bc_packets.packet_id%TYPE

6033:
6034: /**************************************************************/
6035:
6036: PROCEDURE ins_gl_bc_run_fund_check
6037: ( p_packet_id IN gl_bc_packets.packet_id%TYPE
6038: ,p_code_combination_id IN pqh_gl_interface.code_combination_id%TYPE
6039: ,p_period_name IN pqh_gl_interface.period_name%TYPE
6040: ,p_period_year IN gl_period_statuses.period_year%TYPE
6041: ,p_period_num IN gl_period_statuses.period_num%TYPE

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

6051: ,p_fc_return OUT NOCOPY varchar2
6052: )
6053: IS
6054: /*
6055: This procedure Inserts in gl_bc_packets , commits so that the data is available
6056: for the autonomous funds checker and runs funds checker returns as argument funds
6057: checker return code and success flag
6058: */
6059: --

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

Line 6067: l_application_id gl_bc_packets.application_id%TYPE ;

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
6071: hr_utility.set_location('Entering: '||l_proc, 5);

Line 6073: -- get the session details and application_id to insert into gl_bc_packets (Bug Fix 6769905)

6069:
6070: BEGIN
6071: hr_utility.set_location('Entering: '||l_proc, 5);
6072:
6073: -- get the session details and application_id to insert into gl_bc_packets (Bug Fix 6769905)
6074: -- session id and serial id is fetched from v$session, same as that in psa_funds_checker_pkg.get_session_details
6075: select s.audsid, s.serial#
6076: into l_session_id, l_serial_id
6077: from v$session s, v$process p

Line 6084: INSERT INTO gl_bc_packets

6080:
6081: l_application_id := fnd_global.resp_appl_id;
6082:
6083:
6084: INSERT INTO gl_bc_packets
6085: (packet_id,
6086: ledger_id,
6087: je_source_name,
6088: je_category_name,

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

6135: l_serial_id,
6136: l_application_id);
6137:
6138: -- Funds Checker is run in autonomous mode.
6139: -- Commit so that the gl_bc_packets records are visible to fundschecker
6140: commit;
6141:
6142: hr_utility.set_location('Calling GL fund checker in Mode : '||p_fc_mode,100);
6143: