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 773: FROM pa_options;

769: DECLARE
770: CURSOR cur_template_options
771: IS
772: SELECT option_code
773: FROM pa_options;
774: BEGIN
775: FOR cur_template_options_rec IN cur_template_options LOOP
776: -- anlee
777: -- Enable Advanced Structures

Line 2424: WHERE lookup_type = 'PA_OPTIONS_SS'

2420: CURSOR cur_option_name
2421: IS
2422: SELECT meaning
2423: FROM fnd_lookup_values
2424: WHERE lookup_type = 'PA_OPTIONS_SS'
2425: AND lookup_code = p_option_code
2426: AND language = userenv('LANG'); -- Bug 5643345: Added the environment language condition.
2427: -- anlee
2428: -- Added for PA_OPTIONS enhancements

Line 2428: -- Added for PA_OPTIONS enhancements

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

Line 2432: FROM PA_OPTIONS

2428: -- Added for PA_OPTIONS enhancements
2429: CURSOR get_allow_ovr_enabled
2430: IS
2431: SELECT allow_override_enabled_flag
2432: FROM PA_OPTIONS
2433: WHERE option_code = p_option_code;
2434:
2435: l_allow_ovr_enabled VARCHAR2(1);
2436: -- End of changes

Line 2459: -- Changes for PA_OPTIONS enhancements

2455:
2456: --bug
2457:
2458: -- anlee
2459: -- Changes for PA_OPTIONS enhancements
2460:
2461: OPEN get_allow_ovr_enabled;
2462: FETCH get_allow_ovr_enabled INTO l_allow_ovr_enabled;
2463: CLOSE get_allow_ovr_enabled;

Line 3236: WHERE lk1.lookup_type = 'PA_OPTIONS'

3232: CURSOR cur_pa_lkups
3233: IS
3234: SELECT lk1.lookup_code forms_opt_code, lk2.lookup_code ss_opt_code, lk1.meaning
3235: FROM fnd_lookup_values lk1, fnd_lookup_values lk2
3236: WHERE lk1.lookup_type = 'PA_OPTIONS'
3237: AND lk2.lookup_type = 'PA_OPTIONS_SS'
3238: AND lk1.meaning = lk2.meaning
3239: ;
3240:

Line 3237: AND lk2.lookup_type = 'PA_OPTIONS_SS'

3233: IS
3234: SELECT lk1.lookup_code forms_opt_code, lk2.lookup_code ss_opt_code, lk1.meaning
3235: FROM fnd_lookup_values lk1, fnd_lookup_values lk2
3236: WHERE lk1.lookup_type = 'PA_OPTIONS'
3237: AND lk2.lookup_type = 'PA_OPTIONS_SS'
3238: AND lk1.meaning = lk2.meaning
3239: ;
3240:
3241: CURSOR cur_chk_options( c_option_code VARCHAR2 )