[Home] [Help]
1431: -- two records would have been processed by the Update statements.
1432:
1433: If v_noof_tasks > 0 Then
1434: For i in 1..v_noof_tasks LOOP
1435: Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id
1436: From sys.Dual;
1437: PA_MAINT_PROJECT_ACCUMS.Insert_Headers_tasks
1438: (X_project_id,
1439: v_task_array(i),
1601: -- two records would have been processed by the Update statements.
1602:
1603: If v_noof_tasks > 0 Then
1604: For i in 1..v_noof_tasks LOOP
1605: Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id
1606: From sys.Dual;
1607: PA_process_accum_actuals_res.insert_headers_res
1608: (x_project_id,
1609: v_task_array(i),
1668: -- and if not present create the Header and Detail records for budgets
1669: Open Proj_Res_level_Cur;
1670: Fetch Proj_Res_level_Cur Into V_Accum_Id;
1671: IF Proj_Res_level_Cur%NOTFOUND Then
1672: Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id
1673: From sys.Dual;
1674: PA_process_accum_actuals_res.insert_headers_res
1675: (x_project_id,
1676: 0,
2137: and task_id = x_task_id
2138: and resource_list_member_id = x_resource_list_member_id;
2139:
2140: exception when no_data_found then
2141: Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id
2142: from sys.dual;
2143: Insert into PA_PROJECT_ACCUM_HEADERS
2144: (PROJECT_ACCUM_ID,PROJECT_ID,TASK_ID,ACCUM_PERIOD,RESOURCE_ID,
2145: RESOURCE_LIST_ID,RESOURCE_LIST_ASSIGNMENT_ID,
2452: and task_id = x_task_id
2453: and resource_list_member_id = x_resource_list_member_id;
2454:
2455: exception when no_data_found then
2456: Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id
2457: from sys.dual;
2458: Insert into PA_PROJECT_ACCUM_HEADERS
2459: (PROJECT_ACCUM_ID,PROJECT_ID,TASK_ID,ACCUM_PERIOD,RESOURCE_ID,
2460: RESOURCE_LIST_ID,RESOURCE_LIST_ASSIGNMENT_ID,
2764: and task_id = x_task_id
2765: and resource_list_member_id = x_resource_list_member_id;
2766:
2767: exception when no_data_found then
2768: Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id
2769: from sys.dual;
2770: Insert into PA_PROJECT_ACCUM_HEADERS
2771: (PROJECT_ACCUM_ID,PROJECT_ID,TASK_ID,ACCUM_PERIOD,RESOURCE_ID,
2772: RESOURCE_LIST_ID,RESOURCE_LIST_ASSIGNMENT_ID,