APPS.PJI_PJP_EXTRACTION_UTILS dependencies on PA_PROJECT_UTILS

Line 123: PA_PROJECT_UTILS.CHECK_PRJ_STUS_ACTION_ALLOWED

119: PJI_PROJ_EXTR_STATUS fm_status Added for bug 8661279 */
120: where
121: prj.TEMPLATE_FLAG = 'N' and
122: prj.PROJECT_ID = pjp_status.PROJECT_ID (+) and
123: PA_PROJECT_UTILS.CHECK_PRJ_STUS_ACTION_ALLOWED
124: (prj.PROJECT_STATUS_CODE, 'STATUS_REPORTING') = 'Y' and /* Added for bug 8916168 */
125: /*prj.PROJECT_ID = fm_status.PROJECT_ID and Added for bug 8661279 Commented for bug 8916168 */
126: pjp_status.PROJECT_ID is null
127: and prj.project_type <> 'AWARD_PROJECT'; /* Added for Bug 6450518 */

Line 158: and PA_PROJECT_UTILS.CHECK_PRJ_STUS_ACTION_ALLOWED(prj.PROJECT_STATUS_CODE, 'STATUS_REPORTING') = 'N'); */

154: from PJI_PJP_PROJ_EXTR_STATUS pjp
155: where exists (select 1
156: from PA_PROJECTS_ALL prj
157: where prj.PROJECT_ID = pjp.PROJECT_ID
158: and PA_PROJECT_UTILS.CHECK_PRJ_STUS_ACTION_ALLOWED(prj.PROJECT_STATUS_CODE, 'STATUS_REPORTING') = 'N'); */
159: /* End for Bug# 9749751 */
160:
161: update PJI_PJP_PROJ_EXTR_STATUS sts
162: set sts.PROJECT_ORGANIZATION_ID =

Line 214: PA_PROJECT_UTILS.CHECK_PRJ_STUS_ACTION_ALLOWED

210: prj.TEMPLATE_FLAG = 'N' and
211: prj.ORG_ID = pt.ORG_ID and /*5377131*/
212: prj.PROJECT_TYPE = pt.PROJECT_TYPE and
213: prj.PROJECT_ID = pjp_status.PROJECT_ID (+) and
214: PA_PROJECT_UTILS.CHECK_PRJ_STUS_ACTION_ALLOWED
215: (prj.PROJECT_STATUS_CODE, 'STATUS_REPORTING') = 'Y' and /* Added for bug 8916168 */
216: /*prj.PROJECT_ID = fm_status.project_id and Added for bug 6748705 Commented for bug 8916168 */
217: pjp_status.PROJECT_ID is null
218: and prj.project_type <> 'AWARD_PROJECT'; /* Added for Bug 6450518 */