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_PERIOD_STATUSES

Line 94: ,p_period_year IN gl_period_statuses.period_year%TYPE

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
96: ,p_quarter_num IN gl_period_statuses.quarter_num%TYPE
97: ,p_currency_code IN pqh_gl_interface.currency_code%TYPE
98: ,p_entered_dr IN pqh_gl_interface.amount_dr%TYPE

Line 95: ,p_period_num IN gl_period_statuses.period_num%TYPE

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

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

Line 1934: p_gl_period_statuses_rec OUT NOCOPY gl_period_statuses%ROWTYPE

1930: PROCEDURE get_gl_period
1931: (
1932: p_budget_period_id IN pqh_budget_periods.budget_period_id%TYPE,
1933: p_set_of_books_id IN pqh_budgets.gl_set_of_books_id%type,
1934: p_gl_period_statuses_rec OUT NOCOPY gl_period_statuses%ROWTYPE
1935: ) IS
1936: --
1937: -- This procedure will return the period name corresponding to start_date between
1938: -- gl_period_statuses.start_date and gl_period_statuses.end_date

Line 1938: -- gl_period_statuses.start_date and gl_period_statuses.end_date

1934: p_gl_period_statuses_rec OUT NOCOPY gl_period_statuses%ROWTYPE
1935: ) IS
1936: --
1937: -- This procedure will return the period name corresponding to start_date between
1938: -- gl_period_statuses.start_date and gl_period_statuses.end_date
1939: --
1940: -- local variables
1941: --
1942: l_start_date DATE;

Line 1943: l_gl_period_statuses_rec gl_period_statuses%ROWTYPE;

1939: --
1940: -- local variables
1941: --
1942: l_start_date DATE;
1943: l_gl_period_statuses_rec gl_period_statuses%ROWTYPE;
1944: --
1945: CURSOR csr_time_period IS
1946: SELECT start_date
1947: FROM per_time_periods

Line 1954: FROM gl_period_statuses

1950: WHERE budget_period_id = p_budget_period_id );
1951: --
1952: CURSOR csr_period_name( p_start_date IN DATE ) IS
1953: SELECT *
1954: FROM gl_period_statuses
1955: WHERE application_id = g_application_id
1956: AND set_of_books_id = g_set_of_books_id
1957: AND closing_status = 'O'
1958: AND p_start_date BETWEEN start_date AND end_date;

Line 1978: FETCH csr_period_name INTO l_gl_period_statuses_rec;

1974: --
1975: -- get the period name and accounting date
1976: --
1977: OPEN csr_period_name( p_start_date => l_start_date);
1978: FETCH csr_period_name INTO l_gl_period_statuses_rec;
1979: CLOSE csr_period_name;
1980: --
1981: p_gl_period_statuses_rec := l_gl_period_statuses_rec;
1982: --

Line 1981: p_gl_period_statuses_rec := l_gl_period_statuses_rec;

1977: OPEN csr_period_name( p_start_date => l_start_date);
1978: FETCH csr_period_name INTO l_gl_period_statuses_rec;
1979: CLOSE csr_period_name;
1980: --
1981: p_gl_period_statuses_rec := l_gl_period_statuses_rec;
1982: --
1983: hr_utility.set_location('Period Name : '||l_gl_period_statuses_rec.period_name,20);
1984: --
1985: hr_utility.set_location('Leaving:'||l_proc, 1000);

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

1979: CLOSE csr_period_name;
1980: --
1981: p_gl_period_statuses_rec := l_gl_period_statuses_rec;
1982: --
1983: hr_utility.set_location('Period Name : '||l_gl_period_statuses_rec.period_name,20);
1984: --
1985: hr_utility.set_location('Leaving:'||l_proc, 1000);
1986: --
1987: EXCEPTION

Line 1989: p_gl_period_statuses_rec := l_gl_period_statuses_rec;

1985: hr_utility.set_location('Leaving:'||l_proc, 1000);
1986: --
1987: EXCEPTION
1988: WHEN OTHERS THEN
1989: p_gl_period_statuses_rec := l_gl_period_statuses_rec;
1990: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
1991: hr_utility.set_message_token('ROUTINE', l_proc);
1992: hr_utility.set_message_token('REASON', SQLERRM);
1993: hr_utility.raise_error;

Line 2001: p_post_to_period_name IN gl_period_statuses.period_name%TYPE

1997: --
1998: PROCEDURE update_period_commitment_tab
1999: (
2000: p_budget_detail_id IN pqh_budget_details.budget_detail_id%TYPE,
2001: p_post_to_period_name IN gl_period_statuses.period_name%TYPE
2002: )
2003: IS
2004: --
2005: -- The foll procedure reads the global table g_period_amt_tab and

Line 2012: l_gl_period_statuses_rec gl_period_statuses%ROWTYPE;

2008: -- or a code_combination_id then it will populate the global variable
2009: -- g_detail_error to Y and we will not populate the pqh_gl_interface
2010: -- table for the current budget_detail_id.
2011: --
2012: l_gl_period_statuses_rec gl_period_statuses%ROWTYPE;
2013: l_period_name gl_period_statuses.period_name%TYPE;
2014: l_accounting_date gl_period_statuses.start_date%TYPE;
2015: --
2016: l_code_combination_id gl_code_combinations.code_combination_id%TYPE;

Line 2013: l_period_name gl_period_statuses.period_name%TYPE;

2009: -- g_detail_error to Y and we will not populate the pqh_gl_interface
2010: -- table for the current budget_detail_id.
2011: --
2012: l_gl_period_statuses_rec gl_period_statuses%ROWTYPE;
2013: l_period_name gl_period_statuses.period_name%TYPE;
2014: l_accounting_date gl_period_statuses.start_date%TYPE;
2015: --
2016: l_code_combination_id gl_code_combinations.code_combination_id%TYPE;
2017: --

Line 2014: l_accounting_date gl_period_statuses.start_date%TYPE;

2010: -- table for the current budget_detail_id.
2011: --
2012: l_gl_period_statuses_rec gl_period_statuses%ROWTYPE;
2013: l_period_name gl_period_statuses.period_name%TYPE;
2014: l_accounting_date gl_period_statuses.start_date%TYPE;
2015: --
2016: l_code_combination_id gl_code_combinations.code_combination_id%TYPE;
2017: --
2018: l_message_text pqh_process_log.message_text%TYPE;

Line 2048: FROM gl_period_statuses gl, pqh_budgets bdgt

2044: hr_utility.set_location('g_set_of_books_id: '||g_set_of_books_id, 10000000);
2045: hr_utility.set_location('g_budget_id: '||g_budget_id, 10000000);
2046: l_period_name := p_post_to_period_name;
2047: SELECT gl.start_date into l_accounting_date
2048: FROM gl_period_statuses gl, pqh_budgets bdgt
2049: WHERE gl.application_id = g_application_id
2050: AND gl.closing_status = 'O'
2051: AND gl.set_of_books_id = g_set_of_books_id
2052: AND gl.period_name = p_post_to_period_name

Line 2059: p_gl_period_statuses_rec => l_gl_period_statuses_rec );

2055: AND gl.end_date >= bdgt.budget_start_date ;
2056: ELSE
2057: get_gl_period(p_budget_period_id => g_period_amt_tab(i).period_id,
2058: p_set_of_books_id => g_set_of_books_id,
2059: p_gl_period_statuses_rec => l_gl_period_statuses_rec );
2060: l_period_name := l_gl_period_statuses_rec.period_name;
2061: l_accounting_date := l_gl_period_statuses_rec.start_date;
2062: END IF;
2063:

Line 2060: l_period_name := l_gl_period_statuses_rec.period_name;

2056: ELSE
2057: get_gl_period(p_budget_period_id => g_period_amt_tab(i).period_id,
2058: p_set_of_books_id => g_set_of_books_id,
2059: p_gl_period_statuses_rec => l_gl_period_statuses_rec );
2060: l_period_name := l_gl_period_statuses_rec.period_name;
2061: l_accounting_date := l_gl_period_statuses_rec.start_date;
2062: END IF;
2063:
2064: --

Line 2061: l_accounting_date := l_gl_period_statuses_rec.start_date;

2057: get_gl_period(p_budget_period_id => g_period_amt_tab(i).period_id,
2058: p_set_of_books_id => g_set_of_books_id,
2059: p_gl_period_statuses_rec => l_gl_period_statuses_rec );
2060: l_period_name := l_gl_period_statuses_rec.period_name;
2061: l_accounting_date := l_gl_period_statuses_rec.start_date;
2062: END IF;
2063:
2064: --
2065: IF l_period_name IS NULL THEN

Line 2700: l_gl_period_statuses_rec gl_period_statuses%ROWTYPE;

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

Line 2729: FROM gl_period_statuses

2725: FROM dual;
2726: --
2727: CURSOR csr_period_name( p_period_name IN varchar2 ) IS
2728: SELECT *
2729: FROM gl_period_statuses
2730: WHERE application_id = g_application_id
2731: AND set_of_books_id = g_set_of_books_id
2732: AND period_name = p_period_name;
2733: --

Line 2782: FETCH csr_period_name INTO l_gl_period_statuses_rec;

2778: --
2779: -- get period details
2780: --
2781: OPEN csr_period_name(p_period_name => l_period_name);
2782: FETCH csr_period_name INTO l_gl_period_statuses_rec;
2783: CLOSE csr_period_name;
2784: --
2785: -- compute the GL funds checker Mode
2786: --

Line 2825: ,p_period_year => l_gl_period_statuses_rec.period_year

2821: ins_gl_bc_run_fund_check
2822: ( p_packet_id => l_packet_id
2823: ,p_code_combination_id => l_code_combination_id
2824: ,p_period_name => l_period_name
2825: ,p_period_year => l_gl_period_statuses_rec.period_year
2826: ,p_period_num => l_gl_period_statuses_rec.period_num
2827: ,p_quarter_num => l_gl_period_statuses_rec.quarter_num
2828: ,p_currency_code => l_currency_code
2829: ,p_entered_dr => NVL(l_amount_dr,0)

Line 2826: ,p_period_num => l_gl_period_statuses_rec.period_num

2822: ( p_packet_id => l_packet_id
2823: ,p_code_combination_id => l_code_combination_id
2824: ,p_period_name => l_period_name
2825: ,p_period_year => l_gl_period_statuses_rec.period_year
2826: ,p_period_num => l_gl_period_statuses_rec.period_num
2827: ,p_quarter_num => l_gl_period_statuses_rec.quarter_num
2828: ,p_currency_code => l_currency_code
2829: ,p_entered_dr => NVL(l_amount_dr,0)
2830: ,p_entered_cr => NVL(l_amount_cr,0)

Line 2827: ,p_quarter_num => l_gl_period_statuses_rec.quarter_num

2823: ,p_code_combination_id => l_code_combination_id
2824: ,p_period_name => l_period_name
2825: ,p_period_year => l_gl_period_statuses_rec.period_year
2826: ,p_period_num => l_gl_period_statuses_rec.period_num
2827: ,p_quarter_num => l_gl_period_statuses_rec.quarter_num
2828: ,p_currency_code => l_currency_code
2829: ,p_entered_dr => NVL(l_amount_dr,0)
2830: ,p_entered_cr => NVL(l_amount_cr,0)
2831: ,p_accounted_dr => NVL(l_amount_dr,0)

Line 3628: p_post_to_period_name IN gl_period_statuses.period_name%TYPE DEFAULT NULL,

3624: errbuf OUT NOCOPY VARCHAR2,
3625: retcode OUT NOCOPY VARCHAR2,
3626: p_effective_date IN VARCHAR2 ,
3627: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE,
3628: p_post_to_period_name IN gl_period_statuses.period_name%TYPE DEFAULT NULL,
3629: p_validate IN VARCHAR2 default 'N'
3630: ) IS
3631: --
3632: -- Declaring local variables

Line 4373: ,p_period_year IN gl_period_statuses.period_year%TYPE

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
4375: ,p_quarter_num IN gl_period_statuses.quarter_num%TYPE
4376: ,p_currency_code IN pqh_gl_interface.currency_code%TYPE
4377: ,p_entered_dr IN pqh_gl_interface.amount_dr%TYPE

Line 4374: ,p_period_num IN gl_period_statuses.period_num%TYPE

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
4375: ,p_quarter_num IN gl_period_statuses.quarter_num%TYPE
4376: ,p_currency_code IN pqh_gl_interface.currency_code%TYPE
4377: ,p_entered_dr IN pqh_gl_interface.amount_dr%TYPE
4378: ,p_entered_cr IN pqh_gl_interface.amount_cr%TYPE

Line 4375: ,p_quarter_num IN gl_period_statuses.quarter_num%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
4375: ,p_quarter_num IN gl_period_statuses.quarter_num%TYPE
4376: ,p_currency_code IN pqh_gl_interface.currency_code%TYPE
4377: ,p_entered_dr IN pqh_gl_interface.amount_dr%TYPE
4378: ,p_entered_cr IN pqh_gl_interface.amount_cr%TYPE
4379: ,p_accounted_dr IN pqh_gl_interface.amount_dr%TYPE