APPS.PA_REFRESH_RES_LISTS dependencies on PA_RESOURCE_LIST_ASSIGNMENTS

Line 4: TABLE OF PA_RESOURCE_LIST_ASSIGNMENTS.RESOURCE_LIST_ID%TYPE

1: PACKAGE body PA_REFRESH_RES_LISTS AS
2: /* $Header: PAACREFB.pls 120.1 2005/08/19 16:14:06 mwasowic noship $ */
3: TYPE resource_list_id_tabtype IS
4: TABLE OF PA_RESOURCE_LIST_ASSIGNMENTS.RESOURCE_LIST_ID%TYPE
5: INDEX BY BINARY_INTEGER;
6:
7: -- Process_All_Res_Lists - This procedure accumulates the Actuals and
8: -- Commitments for a given Resource lists for a Project

Line 27: PA_RESOURCE_LIST_ASSIGNMENTS

23:
24: CURSOR Reslist_assgmt_Cur IS
25: Select Distinct Resource_list_id
26: FROM
27: PA_RESOURCE_LIST_ASSIGNMENTS
28: Where Project_id = X_project_id
29: and resource_list_id = NVL(x_resource_list_id,resource_list_id);
30:
31: v_Res_accum_txn_accum_id Number := 0;

Line 457: Update PA_RESOURCE_LIST_ASSIGNMENTS

453:
454: -- Now Update the Resource list assignement record, to set the
455: -- Resource list as Accumulated
456:
457: Update PA_RESOURCE_LIST_ASSIGNMENTS
458: SET
459: RESOURCE_LIST_ACCUMULATED_FLAG = 'Y'
460: Where
461: PROJECT_ID = x_project_id