APPS.PQP_RIW_WEBADI_UTILS dependencies on PER_RI_SETUP_SUB_TASKS

Line 3229: --$In case of update, update setup_sub_task_action in per_ri_setup_sub_tasks

3225: ||'&bne:map='||l_new_mapping_code
3226: ||'#bne:layout='||l_new_ce_layout_code||'&bne:content='||l_out_ce_content_code
3227: ||'&bne:map='||l_new_dp_mapping_code;
3228:
3229: --$In case of update, update setup_sub_task_action in per_ri_setup_sub_tasks
3230:
3231: IF p_action_type = 'Update' THEN
3232:
3233: SELECT fff.function_name into l_function_name

Line 3242: FROM per_ri_setup_sub_tasks

3238: AND ffft.USER_FUNCTION_NAME = p_user_function_name;
3239:
3240: SELECT object_version_number
3241: into l_ovn
3242: FROM per_ri_setup_sub_tasks
3243: WHERE setup_sub_task_code = l_function_name;
3244:
3245: per_ri_setup_sub_task_api.update_setup_sub_task(
3246: p_validate => false

Line 3264: FROM per_ri_setup_sub_tasks

3260: ,p_user_function_name =>p_user_function_name);
3261:
3262: SELECT max(SETUP_SUB_TASK_SEQUENCE)
3263: INTO l_seq
3264: FROM per_ri_setup_sub_tasks
3265: WHERE SETUP_TASK_CODE='LOAD_EMPLOYEE_DETAILS';
3266:
3267:
3268: per_ri_setup_sub_task_api.create_setup_sub_task

Line 3318: FROM per_ri_setup_sub_tasks

3314:
3315: CURSOR csr_get_fun_name IS
3316: SELECT setup_sub_task_code
3317: ,object_version_number
3318: FROM per_ri_setup_sub_tasks
3319: WHERE setup_sub_task_code --$ setup_sub_task_action
3320: = (SELECT FLXDU_FUNC_NAME
3321: FROM PQP_FLXDU_FUNC_ATTRIBUTES
3322: WHERE FLXDU_FUNC_ATTRIBUTE_ID = p_function_id );