APPS.PA_SCHEDULE_PVT dependencies on PA_PROJECT_STUS_UTILS

Line 2729: (PA_PROJECT_STUS_UTILS.Allow_Status_Change(

2725:
2726: -- Check if the user is allowed to change the status.
2727:
2728: IF ( ( p_sch_except_record.assignment_status_code <> p_sch_record.assignment_status_code) AND
2729: (PA_PROJECT_STUS_UTILS.Allow_Status_Change(
2730: o_status_code => p_sch_record.assignment_status_code ,
2731: n_status_code => p_sch_except_record.assignment_status_code) <> 'Y' ) ) THEN
2732: Raise Status_change_not_allowed;
2733: END IF;

Line 4668: PA_PROJECT_STUS_UTILS.get_wf_success_failure_status (

4664: FROM pa_schedules
4665: where assignment_id= p_assignment_id;
4666:
4667: PA_SCHEDULE_UTILS.log_message(1,'Call API to get next status');
4668: PA_PROJECT_STUS_UTILS.get_wf_success_failure_status (
4669: p_status_code => l_first_status,
4670: p_status_type => l_status_type,
4671: x_wf_success_status_code => l_next_status_code,
4672: x_wf_failure_status_code => l_temp_status_code,

Line 4706: PA_PROJECT_STUS_UTILS.get_wf_success_failure_status (

4702: PA_SCHEDULE_UTILS.log_message(1, 'In loop: ' || rec.start_date ||
4703: ' ' || rec.end_date);
4704: -- Call Ramesh's API to get next success status.
4705: -- For now, make them the same.
4706: PA_PROJECT_STUS_UTILS.get_wf_success_failure_status (
4707: p_status_code => rec.status_code,
4708: p_status_type => l_status_type,
4709: x_wf_success_status_code => l_next_status_code,
4710: x_wf_failure_status_code => l_temp_status_code,

Line 4771: PA_PROJECT_STUS_UTILS.get_wf_success_failure_status (

4767: END IF;
4768:
4769: IF l_first_status <> l_status_code THEN
4770: PA_SCHEDULE_UTILS.log_message(1,'Call API to get next status');
4771: PA_PROJECT_STUS_UTILS.get_wf_success_failure_status (
4772: p_status_code => l_first_status,
4773: p_status_type => l_status_type,
4774: x_wf_success_status_code => l_next_status_code,
4775: x_wf_failure_status_code => l_temp_status_code,

Line 4808: PA_PROJECT_STUS_UTILS.get_wf_success_failure_status (

4804: l_last_end_date := l_end_date;
4805:
4806: IF C1%ROWCOUNT = l_count THEN
4807: PA_SCHEDULE_UTILS.log_message(1,'Call API to get next status for last record');
4808: PA_PROJECT_STUS_UTILS.get_wf_success_failure_status (
4809: p_status_code => l_first_status,
4810: p_status_type => l_status_type,
4811: x_wf_success_status_code => l_next_status_code,
4812: x_wf_failure_status_code => l_temp_status_code,

Line 4958: PA_PROJECT_STUS_UTILS.get_wf_success_failure_status (

4954:
4955: /* FOR rec IN C1 LOOP
4956: -- Call Ramesh's API to get next success status.
4957: -- For now, make them the same.
4958: PA_PROJECT_STUS_UTILS.get_wf_success_failure_status (
4959: p_status_code => rec.status_code,
4960: p_status_type => l_status_type,
4961: x_wf_success_status_code => l_temp_status_code,
4962: x_wf_failure_status_code => l_next_status_code,

Line 5020: PA_PROJECT_STUS_UTILS.get_wf_success_failure_status (

5016: END IF;
5017:
5018: IF l_first_status <> l_status_code THEN
5019: PA_SCHEDULE_UTILS.log_message(1,'Call API to get next status');
5020: PA_PROJECT_STUS_UTILS.get_wf_success_failure_status (
5021: p_status_code => l_first_status,
5022: p_status_type => l_status_type,
5023: x_wf_success_status_code => l_temp_status_code,
5024: x_wf_failure_status_code => l_next_status_code,

Line 5057: PA_PROJECT_STUS_UTILS.get_wf_success_failure_status (

5053: l_last_end_date := l_end_date;
5054:
5055: IF C1%ROWCOUNT = l_count THEN
5056: PA_SCHEDULE_UTILS.log_message(1,'Call API to get next status for last record');
5057: PA_PROJECT_STUS_UTILS.get_wf_success_failure_status (
5058: p_status_code => l_first_status,
5059: p_status_type => l_status_type,
5060: x_wf_success_status_code => l_temp_status_code,
5061: x_wf_failure_status_code => l_next_status_code,