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

Line 2230: Table : per_time_periods

2226: This procedure will set the log_context at wks periods level
2227:
2228: Display the period start date for start_time_period_id and
2229: Display the period end date for end_time_period_id
2230: Table : per_time_periods
2231:
2232: */
2233:
2234: l_proc varchar2(72) := g_package||'set_wpr_log_context';

Line 2236: l_per_time_periods per_time_periods%ROWTYPE;

2232: */
2233:
2234: l_proc varchar2(72) := g_package||'set_wpr_log_context';
2235: l_worksheet_periods_rec pqh_worksheet_periods%ROWTYPE;
2236: l_per_time_periods per_time_periods%ROWTYPE;
2237: l_start_date per_time_periods.start_date%TYPE;
2238: l_end_date per_time_periods.end_date%TYPE;
2239:
2240: CURSOR csr_wks_periods_rec IS

Line 2237: l_start_date per_time_periods.start_date%TYPE;

2233:
2234: l_proc varchar2(72) := g_package||'set_wpr_log_context';
2235: l_worksheet_periods_rec pqh_worksheet_periods%ROWTYPE;
2236: l_per_time_periods per_time_periods%ROWTYPE;
2237: l_start_date per_time_periods.start_date%TYPE;
2238: l_end_date per_time_periods.end_date%TYPE;
2239:
2240: CURSOR csr_wks_periods_rec IS
2241: SELECT *

Line 2238: l_end_date per_time_periods.end_date%TYPE;

2234: l_proc varchar2(72) := g_package||'set_wpr_log_context';
2235: l_worksheet_periods_rec pqh_worksheet_periods%ROWTYPE;
2236: l_per_time_periods per_time_periods%ROWTYPE;
2237: l_start_date per_time_periods.start_date%TYPE;
2238: l_end_date per_time_periods.end_date%TYPE;
2239:
2240: CURSOR csr_wks_periods_rec IS
2241: SELECT *
2242: FROM pqh_worksheet_periods

Line 2245: CURSOR csr_per_time_periods ( p_time_period_id IN number ) IS

2241: SELECT *
2242: FROM pqh_worksheet_periods
2243: WHERE worksheet_period_id = p_worksheet_period_id ;
2244:
2245: CURSOR csr_per_time_periods ( p_time_period_id IN number ) IS
2246: SELECT *
2247: FROM per_time_periods
2248: WHERE time_period_id = p_time_period_id ;
2249:

Line 2247: FROM per_time_periods

2243: WHERE worksheet_period_id = p_worksheet_period_id ;
2244:
2245: CURSOR csr_per_time_periods ( p_time_period_id IN number ) IS
2246: SELECT *
2247: FROM per_time_periods
2248: WHERE time_period_id = p_time_period_id ;
2249:
2250: BEGIN
2251:

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

2255: FETCH csr_wks_periods_rec INTO l_worksheet_periods_rec;
2256: CLOSE csr_wks_periods_rec;
2257:
2258: -- get the start date
2259: OPEN csr_per_time_periods ( p_time_period_id => l_worksheet_periods_rec.start_time_period_id);
2260: FETCH csr_per_time_periods INTO l_per_time_periods;
2261: CLOSE csr_per_time_periods;
2262:
2263: l_start_date := l_per_time_periods.start_date;

Line 2260: FETCH csr_per_time_periods INTO l_per_time_periods;

2256: CLOSE csr_wks_periods_rec;
2257:
2258: -- get the start date
2259: OPEN csr_per_time_periods ( p_time_period_id => l_worksheet_periods_rec.start_time_period_id);
2260: FETCH csr_per_time_periods INTO l_per_time_periods;
2261: CLOSE csr_per_time_periods;
2262:
2263: l_start_date := l_per_time_periods.start_date;
2264:

Line 2261: CLOSE csr_per_time_periods;

2257:
2258: -- get the start date
2259: OPEN csr_per_time_periods ( p_time_period_id => l_worksheet_periods_rec.start_time_period_id);
2260: FETCH csr_per_time_periods INTO l_per_time_periods;
2261: CLOSE csr_per_time_periods;
2262:
2263: l_start_date := l_per_time_periods.start_date;
2264:
2265:

Line 2263: l_start_date := l_per_time_periods.start_date;

2259: OPEN csr_per_time_periods ( p_time_period_id => l_worksheet_periods_rec.start_time_period_id);
2260: FETCH csr_per_time_periods INTO l_per_time_periods;
2261: CLOSE csr_per_time_periods;
2262:
2263: l_start_date := l_per_time_periods.start_date;
2264:
2265:
2266: -- get the end date
2267:

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

2264:
2265:
2266: -- get the end date
2267:
2268: OPEN csr_per_time_periods ( p_time_period_id => l_worksheet_periods_rec.end_time_period_id);
2269: FETCH csr_per_time_periods INTO l_per_time_periods;
2270: CLOSE csr_per_time_periods;
2271:
2272: l_end_date := l_per_time_periods.end_date;

Line 2269: FETCH csr_per_time_periods INTO l_per_time_periods;

2265:
2266: -- get the end date
2267:
2268: OPEN csr_per_time_periods ( p_time_period_id => l_worksheet_periods_rec.end_time_period_id);
2269: FETCH csr_per_time_periods INTO l_per_time_periods;
2270: CLOSE csr_per_time_periods;
2271:
2272: l_end_date := l_per_time_periods.end_date;
2273:

Line 2270: CLOSE csr_per_time_periods;

2266: -- get the end date
2267:
2268: OPEN csr_per_time_periods ( p_time_period_id => l_worksheet_periods_rec.end_time_period_id);
2269: FETCH csr_per_time_periods INTO l_per_time_periods;
2270: CLOSE csr_per_time_periods;
2271:
2272: l_end_date := l_per_time_periods.end_date;
2273:
2274: -- set log context

Line 2272: l_end_date := l_per_time_periods.end_date;

2268: OPEN csr_per_time_periods ( p_time_period_id => l_worksheet_periods_rec.end_time_period_id);
2269: FETCH csr_per_time_periods INTO l_per_time_periods;
2270: CLOSE csr_per_time_periods;
2271:
2272: l_end_date := l_per_time_periods.end_date;
2273:
2274: -- set log context
2275:
2276: p_log_context := l_start_date||' - '||l_end_date;