APPS.PA_PROJ_TEMPLATE_SETUP_PVT dependencies on PA_PROJECT_OPTIONS

Line 768: --Call Add options api to add options in pa_project_options with the created template.

764: ,x_ar_rec_notify_flag => l_ar_rec_notify_flag -- 7508661 : EnC
765: ,x_auto_release_pwp_inv => l_auto_release_pwp_inv -- 7508661 : EnC
766: );
767:
768: --Call Add options api to add options in pa_project_options with the created template.
769: DECLARE
770: CURSOR cur_template_options
771: IS
772: SELECT option_code

Line 2290: FROM pa_project_options

2286:
2287: CURSOR cur_chk_options
2288: IS
2289: SELECT 'x'
2290: FROM pa_project_options
2291: WHERE project_id = p_project_id
2292: AND option_code = p_option_code;
2293: BEGIN
2294: pa_debug.init_err_stack ('PA_PROJ_TEMPLATE_SETUP_PVT.Add_Project_Options');

Line 2316: INSERT INTO pa_project_options

2312: OPEN cur_chk_options;
2313: FETCH cur_chk_options INTO l_dummy_char;
2314: IF cur_chk_options%NOTFOUND
2315: THEN
2316: INSERT INTO pa_project_options
2317: (
2318: project_id,
2319: option_code,
2320: last_update_date,

Line 2492: DELETE FROM pa_project_options WHERE project_id = p_project_id AND option_code = p_option_code;

2488: x_return_status := 'E';
2489: RAISE FND_API.G_EXC_ERROR;
2490: END IF;
2491:
2492: DELETE FROM pa_project_options WHERE project_id = p_project_id AND option_code = p_option_code;
2493:
2494: enable_disbale_proj_opt( p_project_id, p_option_code, 'DISABLE' );
2495:
2496: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3244: FROM pa_project_options

3240:
3241: CURSOR cur_chk_options( c_option_code VARCHAR2 )
3242: IS
3243: SELECT 'x'
3244: FROM pa_project_options
3245: WHERE project_id = p_project_id
3246: AND option_code = c_option_code;
3247:
3248: l_option_code VARCHAR2(30);

Line 3272: INSERT INTO pa_project_options

3268: OPEN cur_chk_options( l_option_code );
3269: FETCH cur_chk_options INTO l_dummy_char;
3270: IF cur_chk_options%NOTFOUND
3271: THEN
3272: INSERT INTO pa_project_options
3273: (
3274: project_id,
3275: option_code,
3276: last_update_date,

Line 3296: DELETE FROM pa_project_options WHERE project_id = p_project_id and option_code = l_option_code ;

3292: END IF;
3293: CLOSE cur_chk_options;
3294: ELSIF l_found_flag = 'Y' AND l_option_code IS NOT NULL AND p_action = 'DISABLE'
3295: THEN
3296: DELETE FROM pa_project_options WHERE project_id = p_project_id and option_code = l_option_code ;
3297: END IF; --<< l_insert_flag >>
3298: END LOOP;
3299: END enable_disbale_proj_opt;
3300: