DBA Data[Home] [Help]

APPS.PA_PROJ_TASK_STRUC_PUB dependencies on PA_TEMP_IMPORT_TASKS

Line 1090: SELECT 'X' from PA_TEMP_IMPORT_TASKS

1086: --Adding the following cursor to avoid create_task_structure call if
1087: --execute_update_project is called from import or publish apis.
1088: CURSOR cur_pa_temp_import
1089: IS
1090: SELECT 'X' from PA_TEMP_IMPORT_TASKS
1091: WHERE project_id = p_project_id;
1092:
1093: /* Bug 2680486 -- Performance changes -- Added d.project_id= c.project_id
1094: join in the following cursor*/

Line 14279: pa_debug.g_err_stage:= 'Records found in PA_TEMP_IMPORT_TASKS - Returning';

14275: open cur_pa_temp_import(p_project_id);
14276: fetch cur_pa_temp_import into l_dummy_char;
14277: IF cur_pa_temp_import%FOUND THEN
14278: IF l_debug_mode = 'Y' THEN
14279: pa_debug.g_err_stage:= 'Records found in PA_TEMP_IMPORT_TASKS - Returning';
14280: pa_debug.write(l_module_name,pa_debug.g_err_stage,
14281: l_debug_level3);
14282: END IF;
14283: