APPS.PA_PROJ_ACCUM_MAIN dependencies on PA_CHECK_COMMITMENTS

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

1063: WHERE pfa.request_id = x_request_id
1064: AND pfa.segment1
1065: BETWEEN l_project_num_from AND l_project_num_to ;
1066:
1067: /* Bug1751445 Replaced union with union all. Also commented out call to pa_check_commitments */
1068:
1069: INSERT INTO pa_projects_for_accum
1070: (project_id, request_id, action_flag, segment1, exception_flag)
1071: SELECT proj.project_id, x_request_id request_id,

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

1117: 'CM' action_flag, proj.segment1, 'N'
1118: FROM pa_projects_for_accum_v proj
1119: WHERE proj.segment1 BETWEEN l_project_num_from AND l_project_num_to
1120: AND x_commitments_flag = 'Y'
1121: AND PA_CHECK_COMMITMENTS.commitments_changed(proj.project_id) = 'Y' */
1122: UNION ALL
1123: SELECT proj.project_id, x_request_id request_id,
1124: 'BD' action_flag, proj.segment1, 'N'
1125: FROM pa_projects_for_accum_v proj

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

1234: INSERT INTO pa_projects_for_accum
1235: (project_id, request_id, action_flag, segment1, exception_flag)
1236: SELECT recs.project_id, x_request_id, 'CM', recs.segment1, 'N'
1237: FROM dual
1238: WHERE Pa_Check_Commitments.commitments_changed(recs.project_id) = 'Y';
1239:
1240: END LOOP;
1241:
1242: END IF;