DBA Data[Home] [Help]

APPS.PA_ADW_COLLECT_DIMENSIONS dependencies on PA_LOWEST_TASKS_IT

Line 133: PA_LOWEST_TASKS_IT

129: FOR lowest_tasks_r IN sel_lowest_tasks LOOP
130:
131: -- First Try to Update the Row in the Interface Table
132: UPDATE
133: PA_LOWEST_TASKS_IT
134: SET
135: TOP_TASK_ID = LOWEST_TASKS_R.TOP_TASK_ID,
136: TASK_NUMBER = LOWEST_TASKS_R.TASK_NUMBER,
137: TASK_NAME = LOWEST_TASKS_R.TASK_NAME,

Line 168: INSERT INTO PA_LOWEST_TASKS_IT

164: -- Check If Any row was updated
165:
166: IF (SQL%ROWCOUNT = 0) THEN
167: -- No row was updated, So Insert a new row into the interface table
168: INSERT INTO PA_LOWEST_TASKS_IT
169: (
170: TASK_ID,
171: TOP_TASK_ID,
172: TASK_NUMBER,