APPS.PA_RES_ACCUMS dependencies on PA_PROJ_ACCUM_MAIN

Line 279: pa_resource_maps where rownum <= pa_proj_accum_main.x_commit_size;

275:
276: Loop
277: IF (x_resource_list_assignment_id is null) THEN
278: DELETE
279: pa_resource_maps where rownum <= pa_proj_accum_main.x_commit_size;
280: ELSE
281: DELETE
282: pa_resource_maps prm
283: WHERE

Line 285: and rownum <= pa_proj_accum_main.x_commit_size;

281: DELETE
282: pa_resource_maps prm
283: WHERE
284: prm.resource_list_assignment_id = x_resource_list_assignment_id
285: and rownum <= pa_proj_accum_main.x_commit_size;
286: END IF;
287: if sql%rowcount < pa_proj_accum_main.x_commit_size then
288: Commit;
289: tot_recs_processed := tot_recs_processed + sql%rowcount;

Line 287: if sql%rowcount < pa_proj_accum_main.x_commit_size then

283: WHERE
284: prm.resource_list_assignment_id = x_resource_list_assignment_id
285: and rownum <= pa_proj_accum_main.x_commit_size;
286: END IF;
287: if sql%rowcount < pa_proj_accum_main.x_commit_size then
288: Commit;
289: tot_recs_processed := tot_recs_processed + sql%rowcount;
290: exit;
291: else

Line 343: and rownum <= pa_proj_accum_main.x_commit_size;

339: pa_resource_list_assignments
340: WHERE project_id = x_project_id
341: AND resource_list_id = NVL(x_resource_list_id,resource_list_id)
342: )
343: and rownum <= pa_proj_accum_main.x_commit_size;
344: if sql%rowcount < pa_proj_accum_main.x_commit_size then
345: Commit;
346: tot_recs_processed := tot_recs_processed + sql%rowcount;
347: exit;

Line 344: if sql%rowcount < pa_proj_accum_main.x_commit_size then

340: WHERE project_id = x_project_id
341: AND resource_list_id = NVL(x_resource_list_id,resource_list_id)
342: )
343: and rownum <= pa_proj_accum_main.x_commit_size;
344: if sql%rowcount < pa_proj_accum_main.x_commit_size then
345: Commit;
346: tot_recs_processed := tot_recs_processed + sql%rowcount;
347: exit;
348: else

Line 697: and rownum <= pa_proj_accum_main.x_commit_size;

693: WHERE
694: resource_list_assignment_id =
695: NVL(x_resource_list_assignment_id,resource_list_assignment_id)
696: AND project_id = x_project_id
697: and rownum <= pa_proj_accum_main.x_commit_size;
698: ELSE
699:
700: DELETE
701: pa_resource_accum_details

Line 707: and rownum <= pa_proj_accum_main.x_commit_size;

703: resource_list_assignment_id =
704: NVL(x_resource_list_assignment_id,resource_list_assignment_id)
705: AND resource_list_id = x_resource_list_id
706: AND project_id = x_project_id
707: and rownum <= pa_proj_accum_main.x_commit_size;
708:
709: END IF;
710: if sql%rowcount < pa_proj_accum_main.x_commit_size then
711: /* Commented for Bug 2984871 Commit; */

Line 710: if sql%rowcount < pa_proj_accum_main.x_commit_size then

706: AND project_id = x_project_id
707: and rownum <= pa_proj_accum_main.x_commit_size;
708:
709: END IF;
710: if sql%rowcount < pa_proj_accum_main.x_commit_size then
711: /* Commented for Bug 2984871 Commit; */
712: tot_recs_processed := tot_recs_processed + sql%rowcount;
713: /*Code Changes for Bug No.2984871 start */
714: Commit;

Line 1555: If commit_rows >= pa_proj_accum_main.x_commit_size then

1551: x_err_stage,
1552: x_err_code);
1553:
1554: END IF;
1555: If commit_rows >= pa_proj_accum_main.x_commit_size then
1556: commit;
1557: commit_rows := 0;
1558: end if;
1559: