APPS.PA_ADW_COLLECT_MAIN dependencies on PA_PROJECTS

Line 154: UPDATE PA_PROJECTS SET ADW_NOTIFY_FLAG='Y'

150:
151: UPDATE PA_TASKS SET ADW_NOTIFY_FLAG='Y'
152: WHERE ADW_NOTIFY_FLAG = 'N';
153:
154: UPDATE PA_PROJECTS SET ADW_NOTIFY_FLAG='Y'
155: WHERE ADW_NOTIFY_FLAG = 'N';
156:
157: UPDATE PA_PROJECT_TYPES SET ADW_NOTIFY_FLAG='Y'
158: WHERE ADW_NOTIFY_FLAG = 'N';

Line 216: DELETE FROM PA_PROJECTS_IT;

212:
213: pa_debug.debug(x_err_stage);
214:
215: DELETE FROM PA_TOP_TASKS_IT;
216: DELETE FROM PA_PROJECTS_IT;
217: DELETE FROM PA_PRJ_TYPES_IT;
218: DELETE FROM PA_EXP_TYPES_IT;
219: DELETE FROM PA_PRJ_CLASSES_IT;
220: DELETE FROM PA_CLASS_CATGS_IT;

Line 342: purge_it_OADW('PA_PROJECTS_IT_ALL',earliest_collect_time);

338: END IF;
339: IF (collect_lowest_tasks_flag = 'Y') THEN
340: purge_it_OADW('PA_LOWEST_TASKS_IT',earliest_collect_time);
341: END IF;
342: purge_it_OADW('PA_PROJECTS_IT_ALL',earliest_collect_time);
343: purge_it_OADW('PA_PRJ_TYPES_IT_ALL',earliest_collect_time);
344: purge_it_OADW('PA_ALL_PRJ_TYPES_IT',earliest_collect_time);
345: /* Resource Dimension */
346: purge_it_OADW('PA_LOWEST_RLMEM_IT',earliest_collect_time);

Line 428: DELETE FROM PA_PROJECTS_IT

424:
425: DELETE FROM PA_TOP_TASKS_IT
426: WHERE STATUS_CODE = 'T';
427:
428: DELETE FROM PA_PROJECTS_IT
429: WHERE STATUS_CODE = 'T';
430:
431: DELETE FROM PA_PRJ_TYPES_IT
432: WHERE STATUS_CODE = 'T';