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_APPLY_BUDGET dependencies on PER_TIME_PERIODS

Line 2141: Table : per_time_periods

2137: This procedure will set the log_context at wks periods level
2138:
2139: Display the period start date for start_time_period_id and
2140: Display the period end date for end_time_period_id
2141: Table : per_time_periods
2142:
2143: */
2144:
2145: l_proc varchar2(72) := g_package||'set_wpr_log_context';

Line 2147: l_per_time_periods per_time_periods%ROWTYPE;

2143: */
2144:
2145: l_proc varchar2(72) := g_package||'set_wpr_log_context';
2146: l_worksheet_periods_rec pqh_worksheet_periods%ROWTYPE;
2147: l_per_time_periods per_time_periods%ROWTYPE;
2148: l_start_date per_time_periods.start_date%TYPE;
2149: l_end_date per_time_periods.end_date%TYPE;
2150:
2151: CURSOR csr_wks_periods_rec IS

Line 2148: l_start_date per_time_periods.start_date%TYPE;

2144:
2145: l_proc varchar2(72) := g_package||'set_wpr_log_context';
2146: l_worksheet_periods_rec pqh_worksheet_periods%ROWTYPE;
2147: l_per_time_periods per_time_periods%ROWTYPE;
2148: l_start_date per_time_periods.start_date%TYPE;
2149: l_end_date per_time_periods.end_date%TYPE;
2150:
2151: CURSOR csr_wks_periods_rec IS
2152: SELECT *

Line 2149: l_end_date per_time_periods.end_date%TYPE;

2145: l_proc varchar2(72) := g_package||'set_wpr_log_context';
2146: l_worksheet_periods_rec pqh_worksheet_periods%ROWTYPE;
2147: l_per_time_periods per_time_periods%ROWTYPE;
2148: l_start_date per_time_periods.start_date%TYPE;
2149: l_end_date per_time_periods.end_date%TYPE;
2150:
2151: CURSOR csr_wks_periods_rec IS
2152: SELECT *
2153: FROM pqh_worksheet_periods

Line 2156: CURSOR csr_per_time_periods ( p_time_period_id IN number ) IS

2152: SELECT *
2153: FROM pqh_worksheet_periods
2154: WHERE worksheet_period_id = p_worksheet_period_id ;
2155:
2156: CURSOR csr_per_time_periods ( p_time_period_id IN number ) IS
2157: SELECT *
2158: FROM per_time_periods
2159: WHERE time_period_id = p_time_period_id ;
2160:

Line 2158: FROM per_time_periods

2154: WHERE worksheet_period_id = p_worksheet_period_id ;
2155:
2156: CURSOR csr_per_time_periods ( p_time_period_id IN number ) IS
2157: SELECT *
2158: FROM per_time_periods
2159: WHERE time_period_id = p_time_period_id ;
2160:
2161: BEGIN
2162:

Line 2170: OPEN csr_per_time_periods ( p_time_period_id => l_worksheet_periods_rec.start_time_period_id);

2166: FETCH csr_wks_periods_rec INTO l_worksheet_periods_rec;
2167: CLOSE csr_wks_periods_rec;
2168:
2169: -- get the start date
2170: OPEN csr_per_time_periods ( p_time_period_id => l_worksheet_periods_rec.start_time_period_id);
2171: FETCH csr_per_time_periods INTO l_per_time_periods;
2172: CLOSE csr_per_time_periods;
2173:
2174: l_start_date := l_per_time_periods.start_date;

Line 2171: FETCH csr_per_time_periods INTO l_per_time_periods;

2167: CLOSE csr_wks_periods_rec;
2168:
2169: -- get the start date
2170: OPEN csr_per_time_periods ( p_time_period_id => l_worksheet_periods_rec.start_time_period_id);
2171: FETCH csr_per_time_periods INTO l_per_time_periods;
2172: CLOSE csr_per_time_periods;
2173:
2174: l_start_date := l_per_time_periods.start_date;
2175:

Line 2172: CLOSE csr_per_time_periods;

2168:
2169: -- get the start date
2170: OPEN csr_per_time_periods ( p_time_period_id => l_worksheet_periods_rec.start_time_period_id);
2171: FETCH csr_per_time_periods INTO l_per_time_periods;
2172: CLOSE csr_per_time_periods;
2173:
2174: l_start_date := l_per_time_periods.start_date;
2175:
2176:

Line 2174: l_start_date := l_per_time_periods.start_date;

2170: OPEN csr_per_time_periods ( p_time_period_id => l_worksheet_periods_rec.start_time_period_id);
2171: FETCH csr_per_time_periods INTO l_per_time_periods;
2172: CLOSE csr_per_time_periods;
2173:
2174: l_start_date := l_per_time_periods.start_date;
2175:
2176:
2177: -- get the end date
2178:

Line 2179: OPEN csr_per_time_periods ( p_time_period_id => l_worksheet_periods_rec.end_time_period_id);

2175:
2176:
2177: -- get the end date
2178:
2179: OPEN csr_per_time_periods ( p_time_period_id => l_worksheet_periods_rec.end_time_period_id);
2180: FETCH csr_per_time_periods INTO l_per_time_periods;
2181: CLOSE csr_per_time_periods;
2182:
2183: l_end_date := l_per_time_periods.end_date;

Line 2180: FETCH csr_per_time_periods INTO l_per_time_periods;

2176:
2177: -- get the end date
2178:
2179: OPEN csr_per_time_periods ( p_time_period_id => l_worksheet_periods_rec.end_time_period_id);
2180: FETCH csr_per_time_periods INTO l_per_time_periods;
2181: CLOSE csr_per_time_periods;
2182:
2183: l_end_date := l_per_time_periods.end_date;
2184:

Line 2181: CLOSE csr_per_time_periods;

2177: -- get the end date
2178:
2179: OPEN csr_per_time_periods ( p_time_period_id => l_worksheet_periods_rec.end_time_period_id);
2180: FETCH csr_per_time_periods INTO l_per_time_periods;
2181: CLOSE csr_per_time_periods;
2182:
2183: l_end_date := l_per_time_periods.end_date;
2184:
2185: -- set log context

Line 2183: l_end_date := l_per_time_periods.end_date;

2179: OPEN csr_per_time_periods ( p_time_period_id => l_worksheet_periods_rec.end_time_period_id);
2180: FETCH csr_per_time_periods INTO l_per_time_periods;
2181: CLOSE csr_per_time_periods;
2182:
2183: l_end_date := l_per_time_periods.end_date;
2184:
2185: -- set log context
2186:
2187: p_log_context := l_start_date||' - '||l_end_date;