DBA Data[Home] [Help]

APPS.PJI_PJP_SUM_MAIN dependencies on PA_PROJECT_UTILS

Line 3200: PA_PROJECT_UTILS.CHECK_PRJ_STUS_ACTION_ALLOWED

3196: status.PROJECT_ORGANIZATION_ID) and
3197: prj.SEGMENT1 between nvl(p_from_project, prj.SEGMENT1) and
3198: nvl(p_to_project, prj.SEGMENT1) and
3199: -- Bug 11785181
3200: PA_PROJECT_UTILS.CHECK_PRJ_STUS_ACTION_ALLOWED
3201: (prj.PROJECT_STATUS_CODE, 'STATUS_REPORTING') = 'Y'
3202: -- End bug 11785181
3203: and proj_status.status_type = 'PROJECT'
3204: and prj.PROJECT_STATUS_CODE = proj_status.PROJECT_STATUS_CODE

Line 3509: PA_PROJECT_UTILS.CHECK_PRJ_STUS_ACTION_ALLOWED

3505: -- rbs_asg.RBS_VERSION_ID in (log.EVENT_OBJECT, log.ATTRIBUTE2) and --Commented for Bug#5728852 by VVJOSHI
3506: rbs_asg.RBS_HEADER_ID = nvl(p_rbs_header_id,
3507: rbs_asg.RBS_HEADER_ID) and
3508: nvl(prj.org_id,-99) = nvl(p_operating_unit, nvl(prj.org_id,-99)) and
3509: PA_PROJECT_UTILS.CHECK_PRJ_STUS_ACTION_ALLOWED
3510: (prj.PROJECT_STATUS_CODE, 'STATUS_REPORTING') = 'Y' and
3511:
3512: rbs_asg.PROJECT_ID = prj.PROJECT_ID and
3513: nvl(prj.ORG_ID, -1) = nvl(pt.ORG_ID, -1) and

Line 3560: PA_PROJECT_UTILS.CHECK_PRJ_STUS_ACTION_ALLOWED

3556: where
3557: log.EVENT_TYPE in ('RBS_PUSH', 'RBS_DELETE') and
3558: prj.cbs_version_id = log.attribute2 and
3559: nvl(prj.org_id,-99) = nvl(p_operating_unit, nvl(prj.org_id,-99)) and
3560: PA_PROJECT_UTILS.CHECK_PRJ_STUS_ACTION_ALLOWED
3561: (prj.PROJECT_STATUS_CODE, 'STATUS_REPORTING') = 'Y' and
3562:
3563: nvl(prj.ORG_ID, -1) = nvl(pt.ORG_ID, -1) and
3564: prj.PROJECT_TYPE = pt.PROJECT_TYPE ; /* and