APPS.PA_PROCESS_ACCUM_CMT_RES dependencies on PA_PROJECT_ACCUM_HEADERS_S

Line 160: Select PA_PROJECT_ACCUM_HEADERS_S.Nextval

156: -- two records would have been processed by the Update statements.
157:
158: If v_noof_tasks > 0 Then
159: For i in 1..v_noof_tasks LOOP
160: Select PA_PROJECT_ACCUM_HEADERS_S.Nextval
161: into V_Accum_id
162: From Dual;
163: PA_PROCESS_ACCUM_ACTUALS_RES.Insert_Headers_res
164: (X_project_id,

Line 203: Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id

199:
200: Open Proj_Res_level_Cur;
201: Fetch Proj_Res_level_Cur Into V_Accum_Id;
202: If Proj_Res_level_Cur%NOTFOUND Then
203: Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id
204: From Dual;
205: PA_PROCESS_ACCUM_ACTUALS_RES.Insert_Headers_res
206: (X_project_id,
207: 0,

Line 403: Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id

399: -- two records would have been processed by the Update statements.
400:
401: If v_noof_tasks > 0 Then
402: For i in 1..v_noof_tasks LOOP
403: Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id
404: From Dual;
405: PA_PROCESS_ACCUM_ACTUALS_RES.Insert_Headers_res
406: (X_project_id,
407: v_task_array(i),

Line 445: Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id

441:
442: Open Proj_Res_level_Cur;
443: Fetch Proj_Res_level_Cur Into V_Accum_Id;
444: If Proj_Res_level_Cur%NOTFOUND Then
445: Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id
446: From Dual;
447: PA_PROCESS_ACCUM_ACTUALS_RES.Insert_Headers_res
448: (X_project_id,
449: 0,

Line 647: Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id

643: -- two records would have been processed by the Update statements.
644:
645: If v_noof_tasks > 0 Then
646: For i in 1..v_noof_tasks LOOP
647: Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id
648: From Dual;
649: PA_PROCESS_ACCUM_ACTUALS_RES.Insert_Headers_res
650: (X_project_id,
651: v_task_array(i),

Line 689: Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id

685:
686: Open Proj_Res_level_Cur;
687: Fetch Proj_Res_level_Cur Into V_Accum_Id;
688: If Proj_Res_level_Cur%NOTFOUND Then
689: Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id
690: From Dual;
691: PA_PROCESS_ACCUM_ACTUALS_RES.Insert_Headers_res
692: (X_project_id,
693: 0,

Line 890: Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id

886: -- two records would have been processed by the Update statements.
887:
888: If v_noof_tasks > 0 Then
889: For i in 1..v_noof_tasks LOOP
890: Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id
891: From Dual;
892: PA_PROCESS_ACCUM_ACTUALS_RES.Insert_Headers_res
893: (X_project_id,
894: v_task_array(i),

Line 932: Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id

928:
929: Open Proj_Res_level_Cur;
930: Fetch Proj_Res_level_Cur Into V_Accum_Id;
931: If Proj_Res_level_Cur%NOTFOUND Then
932: Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id
933: From Dual;
934: PA_PROCESS_ACCUM_ACTUALS_RES.Insert_Headers_res
935: (X_project_id,
936: 0,

Line 1127: Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id

1123: -- two records would have been processed by the Update statements.
1124:
1125: If v_noof_tasks > 0 Then
1126: For i in 1..v_noof_tasks LOOP
1127: Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id
1128: From Dual;
1129: PA_PROCESS_ACCUM_ACTUALS_RES.Insert_Headers_res
1130: (X_project_id,
1131: v_task_array(i),

Line 1168: Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id

1164:
1165: Open Proj_Res_level_Cur;
1166: Fetch Proj_Res_level_Cur Into V_Accum_Id;
1167: If Proj_Res_level_Cur%NOTFOUND Then
1168: Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id
1169: From Dual;
1170: PA_PROCESS_ACCUM_ACTUALS_RES.Insert_Headers_res
1171: (X_project_id,
1172: 0,