DBA Data[Home] [Help]

APPS.PA_SCHEDULE_PUB dependencies on PA_ASSIGNMENT_UTILS

Line 1587: l_return_status := PA_ASSIGNMENT_UTILS.is_asgmt_allow_stus_ctl_check(

1583: RAISE l_assignment_status_null;
1584:
1585: ELSIF (p_assignment_status_code IS NOT NULL) AND (p_assignment_type <> 'OPEN_ASSIGNMENT') THEN
1586:
1587: l_return_status := PA_ASSIGNMENT_UTILS.is_asgmt_allow_stus_ctl_check(
1588: p_asgmt_status_code => p_assignment_status_code,
1589: p_project_id => p_project_id,
1590: p_add_message => 'N');
1591:

Line 2474: l_return_status := PA_ASSIGNMENT_UTILS.is_asgmt_allow_stus_ctl_check(

2470:
2471: -- New Project Status Control added for PRM v1.0.2.
2472: -- 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.
2473: IF (p_assignment_status_code IS NOT NULL) AND (p_assignment_type <> 'OPEN_ASSIGNMENT') THEN
2474: l_return_status := PA_ASSIGNMENT_UTILS.is_asgmt_allow_stus_ctl_check(
2475: p_asgmt_status_code => p_assignment_status_code,
2476: p_project_id => p_project_id,
2477: p_add_message => 'N');
2478:

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

2508:
2509: -- Checking the assignment that if it is cancelled then it will not be partialy cancelled it
2510: -- should be fully cancelled
2511: -- IF (p_assignment_type = 'OPEN_ASSIGNMENT') THEN
2512: -- l_t_check_cancel := PA_ASSIGNMENT_UTILS.is_open_asgmt_cancelled(
2513: -- p_status_code => p_assignment_status_code,
2514: -- p_status_type => l_status_type);
2515: -- IF(UPPER(l_t_check_cancel) = 'Y') THEN
2516: -- IF ((p_start_date <> p_asgn_start_date) OR

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

2518: -- RAISE l_invalid_asgn_cancelled_date;
2519: -- END IF;
2520: -- END IF;
2521: -- ELSIF (p_assignment_type = 'STAFFED_ASSIGNMENT') THEN
2522: -- l_t_check_cancel := PA_ASSIGNMENT_UTILS.is_staffed_asgmt_cancelled(
2523: -- p_status_code => p_assignment_status_code,
2524: -- p_status_type => l_status_type);
2525: -- IF(UPPER(l_t_check_cancel) = 'Y') THEN
2526: -- IF ((p_start_date <> p_asgn_start_date) OR

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

5142: DECODE(mass_wf_in_progress_flag, 'Y', 1,
5143: DECODE(pending_approval_flag, 'Y', 1,
5144: DECODE(apprvl_status_code, 'ASGMT_APPRVL_CANCELED', 1, -- Bug 3235731
5145: DECODE(status_code, null, 0, -- 3235675 This is needed as is_asgmt_allow_stus_ctl_check returns N if status_code is null
5146: DECODE(pa_assignment_utils.is_asgmt_allow_stus_ctl_check(status_code, project_id, 'N'), 'N', 1, 0))))) read_only_flag
5147: FROM pa_project_assignments_v asgn
5148: WHERE asgn.resource_id = l_res_id
5149: AND (
5150: ((p_assgn_range_start_date IS NOT NULL AND p_assgn_range_end_date IS NOT NULL)