APPS.PA_PROJ_ACCUM_MAIN dependencies on PA_CHECK_COMMITMENTS

Line 1035: /* Bug1751445 Replaced union with union all. Also commented out call to pa_check_commitments */

1031: WHERE pfa.request_id = x_request_id
1032: AND pfa.segment1
1033: BETWEEN l_project_num_from AND l_project_num_to ;
1034:
1035: /* Bug1751445 Replaced union with union all. Also commented out call to pa_check_commitments */
1036:
1037: INSERT INTO pa_projects_for_accum
1038: (project_id, request_id, action_flag, segment1, exception_flag)
1039: SELECT proj.project_id, x_request_id request_id,

Line 1086: AND PA_CHECK_COMMITMENTS.commitments_changed(proj.project_id) = 'Y' */

1082: 'CM' action_flag, proj.segment1, 'N'
1083: FROM pa_projects_for_accum_v proj
1084: WHERE proj.segment1 BETWEEN l_project_num_from AND l_project_num_to
1085: AND x_commitments_flag = 'Y'
1086: AND PA_CHECK_COMMITMENTS.commitments_changed(proj.project_id) = 'Y' */
1087: UNION ALL
1088: SELECT proj.project_id, x_request_id request_id,
1089: 'BD' action_flag, proj.segment1, 'N'
1090: FROM pa_projects_for_accum_v proj

Line 1195: WHERE Pa_Check_Commitments.commitments_changed(recs.project_id) = 'Y';

1191: INSERT INTO pa_projects_for_accum
1192: (project_id, request_id, action_flag, segment1, exception_flag)
1193: SELECT recs.project_id, x_request_id, 'CM', recs.segment1, 'N'
1194: FROM dual
1195: WHERE Pa_Check_Commitments.commitments_changed(recs.project_id) = 'Y';
1196:
1197: END LOOP;
1198:
1199: END IF;