APPS.GMS_RES_MAP dependencies on PA_RESOURCE_ACCUM_DETAILS

Line 2427: -- We will not allow to have multiple PA_RESOURCE_ACCUM_DETAILS

2423: RETURN NULL;
2424: END get_group_resource_type_code;
2425:
2426: -- This procedure created resource accum details
2427: -- We will not allow to have multiple PA_RESOURCE_ACCUM_DETAILS
2428: -- for the same TXN_ACCUM_ID and different resource_id and
2429: -- pa_resource_list_member_id
2430:
2431: PROCEDURE create_resource_accum_details

Line 2449: INSERT INTO pa_resource_accum_details

2445: -- x_err_stage := 'Creating resource accum details';
2446:
2447: -- pa_debug.debug(x_err_stage);
2448:
2449: INSERT INTO pa_resource_accum_details
2450: (resource_list_id,
2451: resource_list_assignment_id,
2452: resource_list_member_id,
2453: resource_id,

Line 2487: pa_resource_accum_details rad

2483: WHERE NOT EXISTS
2484: (SELECT
2485: 'Yes'
2486: FROM
2487: pa_resource_accum_details rad
2488: WHERE
2489: resource_list_id = x_resource_list_id
2490: AND resource_list_assignment_id = x_resource_list_assignment_id
2491: /*

Line 2527: pa_resource_accum_details

2523:
2524: IF (x_resource_list_id IS NULL) THEN
2525:
2526: DELETE
2527: pa_resource_accum_details
2528: WHERE
2529: resource_list_assignment_id =
2530: NVL(x_resource_list_assignment_id,resource_list_assignment_id)
2531: AND project_id = x_project_id;

Line 2535: pa_resource_accum_details

2531: AND project_id = x_project_id;
2532: ELSE
2533:
2534: DELETE
2535: pa_resource_accum_details
2536: WHERE
2537: resource_list_assignment_id =
2538: NVL(x_resource_list_assignment_id,resource_list_assignment_id)
2539: AND resource_list_id = x_resource_list_id