APPS.PA_MAINT_PROJECT_ACCUMS dependencies on PA_RESOURCE_LIST_ASSIGNMENTS

Line 81: TABLE OF PA_RESOURCE_LIST_ASSIGNMENTS.RESOURCE_LIST_ID%TYPE

77: -- 20-feb-2006 degupta To port the changes done in 11i file v115.23 to v115.25
78: -- 27-AUG-2008 jngeorge Bug 6511571: Removed the incorrect fix done for Bug# 5019025
79: --
80: TYPE resource_list_id_tabtype IS
81: TABLE OF PA_RESOURCE_LIST_ASSIGNMENTS.RESOURCE_LIST_ID%TYPE
82: INDEX BY BINARY_INTEGER;
83:
84: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N'); /* Added Debug Profile Option variable initialization for bug#2674619 */
85:

Line 145: PA_RESOURCE_LIST_ASSIGNMENTS

141: CURSOR Reslist_assgmt_Cur is
142: Select Distinct
143: Resource_list_id
144: FROM
145: PA_RESOURCE_LIST_ASSIGNMENTS
146: WHERE Project_id = X_project_id;
147:
148: /* Commented the cursor for bug 4195598
149: -- This cursor fetches the Resource Accum Details

Line 1958: update pa_resource_list_assignments

1954: Trunc(Sysdate),pa_proj_accum_main.x_created_by,
1955: pa_proj_accum_main.x_last_update_login);
1956: end if;
1957: end if;
1958: update pa_resource_list_assignments
1959: set resource_list_accumulated_flag = 'Y'
1960: where project_id = x_project_id
1961: and resource_list_id = nvl(x_resource_list_id,resource_list_id);
1962: -- Restore the old x_err_stack;