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 PAY_ELEMENT_TYPES

Line 2376: Table : pay_element_types

2372: /*
2373: This procedure will set the log_context at wks budget elements level
2374:
2375: Display the ELEMENT_NAME
2376: Table : pay_element_types
2377:
2378: Added on 11/01/2000
2379: At worksheet element level, we only check for the sum of percentage . The context in this case
2380: will be the above budget set .

Line 2386: l_pay_element_types_rec pay_element_types%ROWTYPE;

2382: */
2383:
2384: l_proc varchar2(72) := g_package||'set_wel_log_context';
2385: l_worksheet_bdgt_elmnts_rec pqh_worksheet_bdgt_elmnts%ROWTYPE;
2386: l_pay_element_types_rec pay_element_types%ROWTYPE;
2387:
2388: l_worksheet_budget_sets_rec pqh_worksheet_budget_sets%ROWTYPE;
2389: l_dflt_budget_sets_rec pqh_dflt_budget_sets%ROWTYPE;
2390:

Line 2398: CURSOR csr_pay_element_types_rec ( p_element_type_id IN number) IS

2394: SELECT *
2395: FROM pqh_worksheet_bdgt_elmnts
2396: WHERE worksheet_bdgt_elmnt_id = p_worksheet_bdgt_elmnt_id;
2397:
2398: CURSOR csr_pay_element_types_rec ( p_element_type_id IN number) IS
2399: SELECT *
2400: FROM pay_element_types
2401: WHERE element_type_id = p_element_type_id;
2402:

Line 2400: FROM pay_element_types

2396: WHERE worksheet_bdgt_elmnt_id = p_worksheet_bdgt_elmnt_id;
2397:
2398: CURSOR csr_pay_element_types_rec ( p_element_type_id IN number) IS
2399: SELECT *
2400: FROM pay_element_types
2401: WHERE element_type_id = p_element_type_id;
2402:
2403: CURSOR csr_wks_budget_sets_rec(p_worksheet_budget_set_id IN number) IS
2404: SELECT *

Line 2423: OPEN csr_pay_element_types_rec(p_element_type_id => l_worksheet_bdgt_elmnts_rec.element_type_id);

2419: FETCH csr_wks_bdgt_elmnts_rec INTO l_worksheet_bdgt_elmnts_rec;
2420: CLOSE csr_wks_bdgt_elmnts_rec;
2421:
2422: /*
2423: OPEN csr_pay_element_types_rec(p_element_type_id => l_worksheet_bdgt_elmnts_rec.element_type_id);
2424: FETCH csr_pay_element_types_rec INTO l_pay_element_types_rec;
2425: CLOSE csr_pay_element_types_rec;
2426: */
2427:

Line 2424: FETCH csr_pay_element_types_rec INTO l_pay_element_types_rec;

2420: CLOSE csr_wks_bdgt_elmnts_rec;
2421:
2422: /*
2423: OPEN csr_pay_element_types_rec(p_element_type_id => l_worksheet_bdgt_elmnts_rec.element_type_id);
2424: FETCH csr_pay_element_types_rec INTO l_pay_element_types_rec;
2425: CLOSE csr_pay_element_types_rec;
2426: */
2427:
2428: OPEN csr_wks_budget_sets_rec(p_worksheet_budget_set_id => l_worksheet_bdgt_elmnts_rec.worksheet_budget_set_id);

Line 2425: CLOSE csr_pay_element_types_rec;

2421:
2422: /*
2423: OPEN csr_pay_element_types_rec(p_element_type_id => l_worksheet_bdgt_elmnts_rec.element_type_id);
2424: FETCH csr_pay_element_types_rec INTO l_pay_element_types_rec;
2425: CLOSE csr_pay_element_types_rec;
2426: */
2427:
2428: OPEN csr_wks_budget_sets_rec(p_worksheet_budget_set_id => l_worksheet_bdgt_elmnts_rec.worksheet_budget_set_id);
2429: FETCH csr_wks_budget_sets_rec INTO l_worksheet_budget_sets_rec;

Line 2439: -- p_log_context := l_pay_element_types_rec.element_name;

2435:
2436:
2437: p_log_context := l_dflt_budget_sets_rec.dflt_budget_set_name;
2438:
2439: -- p_log_context := l_pay_element_types_rec.element_name;
2440:
2441: hr_utility.set_location('Log Context : '||p_log_context, 101);
2442: hr_utility.set_location('Leaving:'||l_proc, 1000);
2443:

Line 2485: l_pay_element_types_rec pay_element_types%ROWTYPE;

2481: l_worksheet_fund_srcs_rec pqh_worksheet_fund_srcs%ROWTYPE;
2482: l_pay_cost_allocation_kf_rec pay_cost_allocation_keyflex%ROWTYPE;
2483:
2484: l_worksheet_bdgt_elmnts_rec pqh_worksheet_bdgt_elmnts%ROWTYPE;
2485: l_pay_element_types_rec pay_element_types%ROWTYPE;
2486:
2487:
2488:
2489: CURSOR csr_wks_bdgt_fund_srcs_rec IS

Line 2504: CURSOR csr_pay_element_types_rec ( p_element_type_id IN number) IS

2500: SELECT *
2501: FROM pqh_worksheet_bdgt_elmnts
2502: WHERE worksheet_bdgt_elmnt_id = p_worksheet_bdgt_elmnt_id;
2503:
2504: CURSOR csr_pay_element_types_rec ( p_element_type_id IN number) IS
2505: SELECT *
2506: FROM pay_element_types
2507: WHERE element_type_id = p_element_type_id;
2508:

Line 2506: FROM pay_element_types

2502: WHERE worksheet_bdgt_elmnt_id = p_worksheet_bdgt_elmnt_id;
2503:
2504: CURSOR csr_pay_element_types_rec ( p_element_type_id IN number) IS
2505: SELECT *
2506: FROM pay_element_types
2507: WHERE element_type_id = p_element_type_id;
2508:
2509:
2510:

Line 2523: OPEN csr_pay_element_types_rec(p_element_type_id => l_worksheet_bdgt_elmnts_rec.element_type_id);

2519: OPEN csr_wks_bdgt_elmnts_rec(p_worksheet_bdgt_elmnt_id => l_worksheet_fund_srcs_rec.worksheet_bdgt_elmnt_id);
2520: FETCH csr_wks_bdgt_elmnts_rec INTO l_worksheet_bdgt_elmnts_rec;
2521: CLOSE csr_wks_bdgt_elmnts_rec;
2522:
2523: OPEN csr_pay_element_types_rec(p_element_type_id => l_worksheet_bdgt_elmnts_rec.element_type_id);
2524: FETCH csr_pay_element_types_rec INTO l_pay_element_types_rec;
2525: CLOSE csr_pay_element_types_rec;
2526:
2527: p_log_context := l_pay_element_types_rec.element_name;

Line 2524: FETCH csr_pay_element_types_rec INTO l_pay_element_types_rec;

2520: FETCH csr_wks_bdgt_elmnts_rec INTO l_worksheet_bdgt_elmnts_rec;
2521: CLOSE csr_wks_bdgt_elmnts_rec;
2522:
2523: OPEN csr_pay_element_types_rec(p_element_type_id => l_worksheet_bdgt_elmnts_rec.element_type_id);
2524: FETCH csr_pay_element_types_rec INTO l_pay_element_types_rec;
2525: CLOSE csr_pay_element_types_rec;
2526:
2527: p_log_context := l_pay_element_types_rec.element_name;
2528:

Line 2525: CLOSE csr_pay_element_types_rec;

2521: CLOSE csr_wks_bdgt_elmnts_rec;
2522:
2523: OPEN csr_pay_element_types_rec(p_element_type_id => l_worksheet_bdgt_elmnts_rec.element_type_id);
2524: FETCH csr_pay_element_types_rec INTO l_pay_element_types_rec;
2525: CLOSE csr_pay_element_types_rec;
2526:
2527: p_log_context := l_pay_element_types_rec.element_name;
2528:
2529:

Line 2527: p_log_context := l_pay_element_types_rec.element_name;

2523: OPEN csr_pay_element_types_rec(p_element_type_id => l_worksheet_bdgt_elmnts_rec.element_type_id);
2524: FETCH csr_pay_element_types_rec INTO l_pay_element_types_rec;
2525: CLOSE csr_pay_element_types_rec;
2526:
2527: p_log_context := l_pay_element_types_rec.element_name;
2528:
2529:
2530: /*
2531: OPEN csr_pay_cost_allocation_kf_rec(p_cost_allocation_keyflex_id => l_worksheet_fund_srcs_rec.cost_allocation_keyflex_id);