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.PA_PROJ_TEMPLATE_SETUP_PVT dependencies on PA_OPTIONS

Line 778: FROM pa_options;

774: DECLARE
775: CURSOR cur_template_options
776: IS
777: SELECT option_code
778: FROM pa_options;
779: BEGIN
780: FOR cur_template_options_rec IN cur_template_options LOOP
781: -- anlee
782: -- Enable Advanced Structures

Line 2429: WHERE lookup_type = 'PA_OPTIONS_SS'

2425: CURSOR cur_option_name
2426: IS
2427: SELECT meaning
2428: FROM fnd_lookup_values
2429: WHERE lookup_type = 'PA_OPTIONS_SS'
2430: AND lookup_code = p_option_code
2431: AND language = userenv('LANG'); -- Bug 5643345: Added the environment language condition.
2432: -- anlee
2433: -- Added for PA_OPTIONS enhancements

Line 2433: -- Added for PA_OPTIONS enhancements

2429: WHERE lookup_type = 'PA_OPTIONS_SS'
2430: AND lookup_code = p_option_code
2431: AND language = userenv('LANG'); -- Bug 5643345: Added the environment language condition.
2432: -- anlee
2433: -- Added for PA_OPTIONS enhancements
2434: CURSOR get_allow_ovr_enabled
2435: IS
2436: SELECT allow_override_enabled_flag
2437: FROM PA_OPTIONS

Line 2437: FROM PA_OPTIONS

2433: -- Added for PA_OPTIONS enhancements
2434: CURSOR get_allow_ovr_enabled
2435: IS
2436: SELECT allow_override_enabled_flag
2437: FROM PA_OPTIONS
2438: WHERE option_code = p_option_code;
2439:
2440: l_allow_ovr_enabled VARCHAR2(1);
2441: -- End of changes

Line 2464: -- Changes for PA_OPTIONS enhancements

2460:
2461: --bug
2462:
2463: -- anlee
2464: -- Changes for PA_OPTIONS enhancements
2465:
2466: OPEN get_allow_ovr_enabled;
2467: FETCH get_allow_ovr_enabled INTO l_allow_ovr_enabled;
2468: CLOSE get_allow_ovr_enabled;

Line 3241: WHERE lk1.lookup_type = 'PA_OPTIONS'

3237: CURSOR cur_pa_lkups
3238: IS
3239: SELECT lk1.lookup_code forms_opt_code, lk2.lookup_code ss_opt_code, lk1.meaning
3240: FROM fnd_lookup_values lk1, fnd_lookup_values lk2
3241: WHERE lk1.lookup_type = 'PA_OPTIONS'
3242: AND lk2.lookup_type = 'PA_OPTIONS_SS'
3243: AND lk1.meaning = lk2.meaning
3244: ;
3245:

Line 3242: AND lk2.lookup_type = 'PA_OPTIONS_SS'

3238: IS
3239: SELECT lk1.lookup_code forms_opt_code, lk2.lookup_code ss_opt_code, lk1.meaning
3240: FROM fnd_lookup_values lk1, fnd_lookup_values lk2
3241: WHERE lk1.lookup_type = 'PA_OPTIONS'
3242: AND lk2.lookup_type = 'PA_OPTIONS_SS'
3243: AND lk1.meaning = lk2.meaning
3244: ;
3245:
3246: CURSOR cur_chk_options( c_option_code VARCHAR2 )