DBA Data[Home] [Help]

APPS.PA_ADW_COLLECT_DIMENSIONS dependencies on PA_TOP_TASKS_IT

Line 259: PA_TOP_TASKS_IT

255: FOR top_tasks_r IN sel_top_tasks LOOP
256:
257: -- First Try to Update the Row in the Interface Table
258: UPDATE
259: PA_TOP_TASKS_IT
260: SET
261: PROJECT_ID = TOP_TASKS_R.PROJECT_ID,
262: TASK_NUMBER = TOP_TASKS_R.TASK_NUMBER,
263: TASK_NAME = TOP_TASKS_R.TASK_NAME,

Line 294: INSERT INTO PA_TOP_TASKS_IT

290: -- Check If Any row was updated
291:
292: IF (SQL%ROWCOUNT = 0) THEN
293: -- No row was updated, So Insert a new row into the interface table
294: INSERT INTO PA_TOP_TASKS_IT
295: (
296: TOP_TASK_ID,
297: PROJECT_ID,
298: TASK_NUMBER,