APPS.PA_ACCUM_PROJ_LIST dependencies on PA_PROJECT_ACCUM_HEADERS

Line 10: -- 1) pa_project_accum_headers

6: -- Type: PL/SQL Procedure
7: --
8: -- Description: For a given project, this procedure inserts one project-level row
9: -- for each of the following summarization tables:
10: -- 1) pa_project_accum_headers
11: -- 2) pa_project_accum_actuals
12: -- 3) pa_project_accum_commitments
13: --
14: -- For the pa_project_accum_budgets, one row each is inserted for

Line 52: l_project_accum_id pa_project_accum_headers.project_accum_id%TYPE := 0;

48:
49:
50: l_api_name CONSTANT VARCHAR2(30) := 'Insert_Accum';
51: l_project_id NUMBER := 0;
52: l_project_accum_id pa_project_accum_headers.project_accum_id%TYPE := 0;
53: l_accum_period_type pa_implementations_all.accumulation_period_type%TYPE := NULL;
54: l_period_name pa_periods_all.period_name%TYPE := NULL;
55:
56: l_err_code NUMBER := 0;

Line 64: FROM pa_project_accum_headers

60:
61: CURSOR header_csr
62: IS
63: SELECT project_accum_id
64: FROM pa_project_accum_headers
65: WHERE project_id = l_project_id
66: AND task_id = 0
67: AND resource_list_member_id = 0;
68:

Line 113: SELECT PA_PROJECT_ACCUM_HEADERS_S.Nextval

109: OPEN currperiod_csr;
110: FETCH currperiod_csr INTO l_period_name;
111: CLOSE currperiod_csr;
112:
113: SELECT PA_PROJECT_ACCUM_HEADERS_S.Nextval
114: INTO l_project_accum_id
115: FROM dual;
116:
117: -- Insert Header Record

Line 119: Insert into PA_PROJECT_ACCUM_HEADERS

115: FROM dual;
116:
117: -- Insert Header Record
118:
119: Insert into PA_PROJECT_ACCUM_HEADERS
120: (PROJECT_ACCUM_ID,PROJECT_ID,TASK_ID,ACCUM_PERIOD,RESOURCE_ID,
121: RESOURCE_LIST_ID,RESOURCE_LIST_ASSIGNMENT_ID,
122: RESOURCE_LIST_MEMBER_ID,LAST_UPDATED_BY,LAST_UPDATE_DATE,
123: CREATION_DATE,REQUEST_ID,CREATED_BY,LAST_UPDATE_LOGIN )

Line 131: from pa_project_accum_headers

127: G_request_id,G_created_by,
128: G_last_update_login
129: FROM dual
130: WHERE NOT EXISTS (select 'X'
131: from pa_project_accum_headers
132: where project_id = l_project_id
133: AND task_id = 0
134: AND resource_list_member_id = 0
135: );

Line 354: -- 1) pa_project_accum_headers

350: -- Type: PL/SQL Procedure
351: --
352: -- Description: For a given project, this procedure inserts one project-level row
353: -- for each of the following summarization tables:
354: -- 1) pa_project_accum_headers
355: -- 2) pa_project_accum_actuals
356: -- 3) pa_project_accum_commitments
357: --
358: -- For the pa_project_accum_budgets, one row each is inserted for

Line 395: l_project_accum_id pa_project_accum_headers.project_accum_id%TYPE := 0;

391:
392:
393: l_api_name CONSTANT VARCHAR2(30) := 'Upgrade_Accum';
394: l_project_id NUMBER := 0;
395: l_project_accum_id pa_project_accum_headers.project_accum_id%TYPE := 0;
396: l_accum_period_type pa_implementations_all.accumulation_period_type%TYPE := NULL;
397: l_period_name pa_periods_all.period_name%TYPE := NULL;
398:
399: l_err_code NUMBER := 0;

Line 407: FROM pa_project_accum_headers

403:
404: CURSOR header_csr
405: IS
406: SELECT project_accum_id
407: FROM pa_project_accum_headers
408: WHERE project_id = l_project_id
409: AND task_id = 0
410: AND resource_list_member_id = 0;
411:

Line 465: SELECT PA_PROJECT_ACCUM_HEADERS_S.Nextval

461: OPEN currperiod_csr;
462: FETCH currperiod_csr INTO l_period_name;
463: CLOSE currperiod_csr;
464:
465: SELECT PA_PROJECT_ACCUM_HEADERS_S.Nextval
466: INTO l_project_accum_id
467: FROM dual;
468: -- Insert Header Record
469:

Line 470: Insert into PA_PROJECT_ACCUM_HEADERS

466: INTO l_project_accum_id
467: FROM dual;
468: -- Insert Header Record
469:
470: Insert into PA_PROJECT_ACCUM_HEADERS
471: (PROJECT_ACCUM_ID,PROJECT_ID,TASK_ID,ACCUM_PERIOD,RESOURCE_ID,
472: RESOURCE_LIST_ID,RESOURCE_LIST_ASSIGNMENT_ID,
473: RESOURCE_LIST_MEMBER_ID,LAST_UPDATED_BY,LAST_UPDATE_DATE,
474: CREATION_DATE,REQUEST_ID,CREATED_BY,LAST_UPDATE_LOGIN )