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_PERIOD_STATUSES

Line 97: ,p_period_year IN gl_period_statuses.period_year%TYPE

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
99: ,p_quarter_num IN gl_period_statuses.quarter_num%TYPE
100: ,p_currency_code IN pqh_gl_interface.currency_code%TYPE
101: ,p_entered_dr IN pqh_gl_interface.amount_dr%TYPE

Line 98: ,p_period_num IN gl_period_statuses.period_num%TYPE

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
99: ,p_quarter_num IN gl_period_statuses.quarter_num%TYPE
100: ,p_currency_code IN pqh_gl_interface.currency_code%TYPE
101: ,p_entered_dr IN pqh_gl_interface.amount_dr%TYPE
102: ,p_entered_cr IN pqh_gl_interface.amount_cr%TYPE

Line 99: ,p_quarter_num IN gl_period_statuses.quarter_num%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
99: ,p_quarter_num IN gl_period_statuses.quarter_num%TYPE
100: ,p_currency_code IN pqh_gl_interface.currency_code%TYPE
101: ,p_entered_dr IN pqh_gl_interface.amount_dr%TYPE
102: ,p_entered_cr IN pqh_gl_interface.amount_cr%TYPE
103: ,p_accounted_dr IN pqh_gl_interface.amount_dr%TYPE

Line 1072: l_period_name gl_period_statuses.period_name%TYPE;

1068: --
1069: -- local variables
1070: --
1071: l_proc varchar2(72) := g_package||'.update_period_amt_tab';
1072: l_period_name gl_period_statuses.period_name%TYPE;
1073: l_accounting_date gl_period_statuses.start_date%TYPE;
1074: l_code_combination_id gl_code_combinations.code_combination_id%TYPE;
1075: l_gl_period_statuses_rec gl_period_statuses%ROWTYPE;
1076: l_message_text pqh_process_log.message_text%TYPE;

Line 1073: l_accounting_date gl_period_statuses.start_date%TYPE;

1069: -- local variables
1070: --
1071: l_proc varchar2(72) := g_package||'.update_period_amt_tab';
1072: l_period_name gl_period_statuses.period_name%TYPE;
1073: l_accounting_date gl_period_statuses.start_date%TYPE;
1074: l_code_combination_id gl_code_combinations.code_combination_id%TYPE;
1075: l_gl_period_statuses_rec gl_period_statuses%ROWTYPE;
1076: l_message_text pqh_process_log.message_text%TYPE;
1077: l_message_text_out fnd_new_messages.message_text%TYPE;

Line 1075: l_gl_period_statuses_rec gl_period_statuses%ROWTYPE;

1071: l_proc varchar2(72) := g_package||'.update_period_amt_tab';
1072: l_period_name gl_period_statuses.period_name%TYPE;
1073: l_accounting_date gl_period_statuses.start_date%TYPE;
1074: l_code_combination_id gl_code_combinations.code_combination_id%TYPE;
1075: l_gl_period_statuses_rec gl_period_statuses%ROWTYPE;
1076: l_message_text pqh_process_log.message_text%TYPE;
1077: l_message_text_out fnd_new_messages.message_text%TYPE;
1078: l_count NUMBER;
1079: l_error_flag varchar2(10) := 'N';

Line 1111: p_gl_period_statuses_rec => l_gl_period_statuses_rec

1107: -- period name
1108: get_gl_period
1109: (
1110: p_budget_period_id => g_period_amt_tab(i).period_id,
1111: p_gl_period_statuses_rec => l_gl_period_statuses_rec
1112: );
1113:
1114: l_period_name := l_gl_period_statuses_rec.period_name;
1115: l_accounting_date := l_gl_period_statuses_rec.start_date;

Line 1114: l_period_name := l_gl_period_statuses_rec.period_name;

1110: p_budget_period_id => g_period_amt_tab(i).period_id,
1111: p_gl_period_statuses_rec => l_gl_period_statuses_rec
1112: );
1113:
1114: l_period_name := l_gl_period_statuses_rec.period_name;
1115: l_accounting_date := l_gl_period_statuses_rec.start_date;
1116:
1117: IF l_period_name IS NULL THEN
1118: -- no period name found mark detail as error and proceed

Line 1115: l_accounting_date := l_gl_period_statuses_rec.start_date;

1111: p_gl_period_statuses_rec => l_gl_period_statuses_rec
1112: );
1113:
1114: l_period_name := l_gl_period_statuses_rec.period_name;
1115: l_accounting_date := l_gl_period_statuses_rec.start_date;
1116:
1117: IF l_period_name IS NULL THEN
1118: -- no period name found mark detail as error and proceed
1119: g_detail_error := 'Y';

Line 1667: l_gl_period_statuses_rec gl_period_statuses%ROWTYPE;

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);
1671: l_fc_message varchar2(8000);

Line 1696: FROM gl_period_statuses

1692: FROM dual;
1693:
1694: CURSOR csr_period_name( p_period_name IN varchar2 ) IS
1695: SELECT *
1696: FROM gl_period_statuses
1697: WHERE application_id = g_application_id
1698: AND set_of_books_id = g_set_of_books_id
1699: AND period_name = p_period_name;
1700:

Line 1743: FETCH csr_period_name INTO l_gl_period_statuses_rec;

1739: CLOSE csr_packet_id;
1740:
1741: -- get period details
1742: OPEN csr_period_name(p_period_name => l_period_name);
1743: FETCH csr_period_name INTO l_gl_period_statuses_rec;
1744: CLOSE csr_period_name;
1745:
1746: -- compute the GL funds checker Mode
1747: IF g_validate THEN

Line 1777: ,p_period_year => l_gl_period_statuses_rec.period_year

1773: ins_gl_bc_run_fund_check
1774: ( p_packet_id => l_packet_id
1775: ,p_code_combination_id => l_code_combination_id
1776: ,p_period_name => l_period_name
1777: ,p_period_year => l_gl_period_statuses_rec.period_year
1778: ,p_period_num => l_gl_period_statuses_rec.period_num
1779: ,p_quarter_num => l_gl_period_statuses_rec.quarter_num
1780: ,p_currency_code => l_currency_code
1781: ,p_entered_dr => NVL(l_amount_dr,0)

Line 1778: ,p_period_num => l_gl_period_statuses_rec.period_num

1774: ( p_packet_id => l_packet_id
1775: ,p_code_combination_id => l_code_combination_id
1776: ,p_period_name => l_period_name
1777: ,p_period_year => l_gl_period_statuses_rec.period_year
1778: ,p_period_num => l_gl_period_statuses_rec.period_num
1779: ,p_quarter_num => l_gl_period_statuses_rec.quarter_num
1780: ,p_currency_code => l_currency_code
1781: ,p_entered_dr => NVL(l_amount_dr,0)
1782: ,p_entered_cr => NVL(l_amount_cr,0)

Line 1779: ,p_quarter_num => l_gl_period_statuses_rec.quarter_num

1775: ,p_code_combination_id => l_code_combination_id
1776: ,p_period_name => l_period_name
1777: ,p_period_year => l_gl_period_statuses_rec.period_year
1778: ,p_period_num => l_gl_period_statuses_rec.period_num
1779: ,p_quarter_num => l_gl_period_statuses_rec.quarter_num
1780: ,p_currency_code => l_currency_code
1781: ,p_entered_dr => NVL(l_amount_dr,0)
1782: ,p_entered_cr => NVL(l_amount_cr,0)
1783: ,p_accounted_dr => NVL(l_amount_dr,0)

Line 2357: p_gl_period_statuses_rec OUT NOCOPY gl_period_statuses%ROWTYPE

2353:
2354: PROCEDURE get_gl_period
2355: (
2356: p_budget_period_id IN pqh_budget_periods.budget_period_id%TYPE,
2357: p_gl_period_statuses_rec OUT NOCOPY gl_period_statuses%ROWTYPE
2358: ) IS
2359: /*
2360: This procedure will return the period name corresponding to start_date between
2361: gl_period_statuses.start_date and gl_period_statuses.end_date

Line 2361: gl_period_statuses.start_date and gl_period_statuses.end_date

2357: p_gl_period_statuses_rec OUT NOCOPY gl_period_statuses%ROWTYPE
2358: ) IS
2359: /*
2360: This procedure will return the period name corresponding to start_date between
2361: gl_period_statuses.start_date and gl_period_statuses.end_date
2362: */
2363: --
2364: -- local variables
2365: --

Line 2368: l_period_name gl_period_statuses.period_name%TYPE;

2364: -- local variables
2365: --
2366: l_proc varchar2(72) := g_package||'.get_gl_period';
2367: l_start_date DATE;
2368: l_period_name gl_period_statuses.period_name%TYPE;
2369: l_accounting_date DATE;
2370: l_gl_period_statuses_rec gl_period_statuses%ROWTYPE;
2371:
2372:

Line 2370: l_gl_period_statuses_rec gl_period_statuses%ROWTYPE;

2366: l_proc varchar2(72) := g_package||'.get_gl_period';
2367: l_start_date DATE;
2368: l_period_name gl_period_statuses.period_name%TYPE;
2369: l_accounting_date DATE;
2370: l_gl_period_statuses_rec gl_period_statuses%ROWTYPE;
2371:
2372:
2373: CURSOR csr_time_period IS
2374: SELECT start_date

Line 2382: FROM gl_period_statuses

2378: WHERE budget_period_id = p_budget_period_id );
2379:
2380: CURSOR csr_period_name( p_start_date IN DATE ) IS
2381: SELECT *
2382: FROM gl_period_statuses
2383: WHERE application_id = g_application_id
2384: AND set_of_books_id = g_set_of_books_id
2385: AND closing_status = 'O'
2386: AND p_start_date BETWEEN start_date AND end_date;

Line 2400: FETCH csr_period_name INTO l_gl_period_statuses_rec;

2396: hr_utility.set_location('Budget Start Date : '||l_start_date,10);
2397:
2398: -- get the period name and accounting date
2399: OPEN csr_period_name( p_start_date => l_start_date);
2400: FETCH csr_period_name INTO l_gl_period_statuses_rec;
2401: CLOSE csr_period_name;
2402:
2403:
2404:

Line 2405: p_gl_period_statuses_rec := l_gl_period_statuses_rec;

2401: CLOSE csr_period_name;
2402:
2403:
2404:
2405: p_gl_period_statuses_rec := l_gl_period_statuses_rec;
2406:
2407: hr_utility.set_location('Period Name : '||l_gl_period_statuses_rec.period_name,20);
2408:
2409: hr_utility.set_location('Leaving:'||l_proc, 1000);

Line 2407: hr_utility.set_location('Period Name : '||l_gl_period_statuses_rec.period_name,20);

2403:
2404:
2405: p_gl_period_statuses_rec := l_gl_period_statuses_rec;
2406:
2407: hr_utility.set_location('Period Name : '||l_gl_period_statuses_rec.period_name,20);
2408:
2409: hr_utility.set_location('Leaving:'||l_proc, 1000);
2410:
2411: EXCEPTION

Line 6040: ,p_period_year IN gl_period_statuses.period_year%TYPE

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
6042: ,p_quarter_num IN gl_period_statuses.quarter_num%TYPE
6043: ,p_currency_code IN pqh_gl_interface.currency_code%TYPE
6044: ,p_entered_dr IN pqh_gl_interface.amount_dr%TYPE

Line 6041: ,p_period_num IN gl_period_statuses.period_num%TYPE

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
6042: ,p_quarter_num IN gl_period_statuses.quarter_num%TYPE
6043: ,p_currency_code IN pqh_gl_interface.currency_code%TYPE
6044: ,p_entered_dr IN pqh_gl_interface.amount_dr%TYPE
6045: ,p_entered_cr IN pqh_gl_interface.amount_cr%TYPE

Line 6042: ,p_quarter_num IN gl_period_statuses.quarter_num%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
6042: ,p_quarter_num IN gl_period_statuses.quarter_num%TYPE
6043: ,p_currency_code IN pqh_gl_interface.currency_code%TYPE
6044: ,p_entered_dr IN pqh_gl_interface.amount_dr%TYPE
6045: ,p_entered_cr IN pqh_gl_interface.amount_cr%TYPE
6046: ,p_accounted_dr IN pqh_gl_interface.amount_dr%TYPE