[Home] [Help]
769: /* Added for 12.2 Payroll billing ER 11847616 */
770:
771: );
772:
773: --Call Add options api to add options in pa_project_options with the created template.
774: DECLARE
775: CURSOR cur_template_options
776: IS
777: SELECT option_code
2291:
2292: CURSOR cur_chk_options
2293: IS
2294: SELECT 'x'
2295: FROM pa_project_options
2296: WHERE project_id = p_project_id
2297: AND option_code = p_option_code;
2298: BEGIN
2299: pa_debug.init_err_stack ('PA_PROJ_TEMPLATE_SETUP_PVT.Add_Project_Options');
2317: OPEN cur_chk_options;
2318: FETCH cur_chk_options INTO l_dummy_char;
2319: IF cur_chk_options%NOTFOUND
2320: THEN
2321: INSERT INTO pa_project_options
2322: (
2323: project_id,
2324: option_code,
2325: last_update_date,
2493: x_return_status := 'E';
2494: RAISE FND_API.G_EXC_ERROR;
2495: END IF;
2496:
2497: DELETE FROM pa_project_options WHERE project_id = p_project_id AND option_code = p_option_code;
2498:
2499: enable_disbale_proj_opt( p_project_id, p_option_code, 'DISABLE' );
2500:
2501: x_return_status := FND_API.G_RET_STS_SUCCESS;
3245:
3246: CURSOR cur_chk_options( c_option_code VARCHAR2 )
3247: IS
3248: SELECT 'x'
3249: FROM pa_project_options
3250: WHERE project_id = p_project_id
3251: AND option_code = c_option_code;
3252:
3253: l_option_code VARCHAR2(30);
3273: OPEN cur_chk_options( l_option_code );
3274: FETCH cur_chk_options INTO l_dummy_char;
3275: IF cur_chk_options%NOTFOUND
3276: THEN
3277: INSERT INTO pa_project_options
3278: (
3279: project_id,
3280: option_code,
3281: last_update_date,
3297: END IF;
3298: CLOSE cur_chk_options;
3299: ELSIF l_found_flag = 'Y' AND l_option_code IS NOT NULL AND p_action = 'DISABLE'
3300: THEN
3301: DELETE FROM pa_project_options WHERE project_id = p_project_id and option_code = l_option_code ;
3302: END IF; --<< l_insert_flag >>
3303: END LOOP;
3304: END enable_disbale_proj_opt;
3305: