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,
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,