DBA Data[Home] [Help]

APPS.PA_SCHEDULE_PUB dependencies on PA_ASSIGNMENT_UTILS

Line 1116: l_return_status := PA_ASSIGNMENT_UTILS.is_asgmt_allow_stus_ctl_check(

1112: RAISE l_assignment_status_null;
1113:
1114: ELSIF (p_assignment_status_code IS NOT NULL) AND (p_assignment_type <> 'OPEN_ASSIGNMENT') THEN
1115:
1116: l_return_status := PA_ASSIGNMENT_UTILS.is_asgmt_allow_stus_ctl_check(
1117: p_asgmt_status_code => p_assignment_status_code,
1118: p_project_id => p_project_id,
1119: p_add_message => 'N');
1120:

Line 2002: l_return_status := PA_ASSIGNMENT_UTILS.is_asgmt_allow_stus_ctl_check(

1998:
1999: -- New Project Status Control added for PRM v1.0.2.
2000: -- If extending the staffed assignment duration with a new status, the status should be allowed for the status of the project this assignment belongs to.
2001: IF (p_assignment_status_code IS NOT NULL) AND (p_assignment_type <> 'OPEN_ASSIGNMENT') THEN
2002: l_return_status := PA_ASSIGNMENT_UTILS.is_asgmt_allow_stus_ctl_check(
2003: p_asgmt_status_code => p_assignment_status_code,
2004: p_project_id => p_project_id,
2005: p_add_message => 'N');
2006:

Line 2040: -- l_t_check_cancel := PA_ASSIGNMENT_UTILS.is_open_asgmt_cancelled(

2036:
2037: -- Checking the assignment that if it is cancelled then it will not be partialy cancelled it
2038: -- should be fully cancelled
2039: -- IF (p_assignment_type = 'OPEN_ASSIGNMENT') THEN
2040: -- l_t_check_cancel := PA_ASSIGNMENT_UTILS.is_open_asgmt_cancelled(
2041: -- p_status_code => p_assignment_status_code,
2042: -- p_status_type => l_status_type);
2043: -- IF(UPPER(l_t_check_cancel) = 'Y') THEN
2044: -- IF ((p_start_date <> p_asgn_start_date) OR

Line 2050: -- l_t_check_cancel := PA_ASSIGNMENT_UTILS.is_staffed_asgmt_cancelled(

2046: -- RAISE l_invalid_asgn_cancelled_date;
2047: -- END IF;
2048: -- END IF;
2049: -- ELSIF (p_assignment_type = 'STAFFED_ASSIGNMENT') THEN
2050: -- l_t_check_cancel := PA_ASSIGNMENT_UTILS.is_staffed_asgmt_cancelled(
2051: -- p_status_code => p_assignment_status_code,
2052: -- p_status_type => l_status_type);
2053: -- IF(UPPER(l_t_check_cancel) = 'Y') THEN
2054: -- IF ((p_start_date <> p_asgn_start_date) OR

Line 4666: DECODE(pa_assignment_utils.is_asgmt_allow_stus_ctl_check(status_code, project_id, 'N'), 'N', 1, 0))))) read_only_flag

4662: DECODE(mass_wf_in_progress_flag, 'Y', 1,
4663: DECODE(pending_approval_flag, 'Y', 1,
4664: DECODE(apprvl_status_code, 'ASGMT_APPRVL_CANCELED', 1, -- Bug 3235731
4665: DECODE(status_code, null, 0, -- 3235675 This is needed as is_asgmt_allow_stus_ctl_check returns N if status_code is null
4666: DECODE(pa_assignment_utils.is_asgmt_allow_stus_ctl_check(status_code, project_id, 'N'), 'N', 1, 0))))) read_only_flag
4667: FROM pa_project_assignments_v asgn
4668: WHERE asgn.resource_id = l_res_id
4669: AND (
4670: ((p_assgn_range_start_date IS NOT NULL AND p_assgn_range_end_date IS NOT NULL)