DBA Data[Home] [Help]

APPS.PA_SCHEDULE_PVT dependencies on PA_PROJECT_STUS_UTILS

Line 2941: (PA_PROJECT_STUS_UTILS.Allow_Status_Change(

2937:
2938: -- Check if the user is allowed to change the status.
2939:
2940: IF ( ( p_sch_except_record.assignment_status_code <> p_sch_record.assignment_status_code) AND
2941: (PA_PROJECT_STUS_UTILS.Allow_Status_Change(
2942: o_status_code => p_sch_record.assignment_status_code ,
2943: n_status_code => p_sch_except_record.assignment_status_code) <> 'Y' ) ) THEN
2944: Raise Status_change_not_allowed;
2945: END IF;

Line 4954: PA_PROJECT_STUS_UTILS.get_wf_success_failure_status (

4950: FROM pa_schedules
4951: where assignment_id= p_assignment_id;
4952:
4953: PA_SCHEDULE_UTILS.log_message(1,'Call API to get next status');
4954: PA_PROJECT_STUS_UTILS.get_wf_success_failure_status (
4955: p_status_code => l_first_status,
4956: p_status_type => l_status_type,
4957: x_wf_success_status_code => l_next_status_code,
4958: x_wf_failure_status_code => l_temp_status_code,

Line 4992: PA_PROJECT_STUS_UTILS.get_wf_success_failure_status (

4988: PA_SCHEDULE_UTILS.log_message(1, 'In loop: ' || rec.start_date ||
4989: ' ' || rec.end_date);
4990: -- Call Ramesh's API to get next success status.
4991: -- For now, make them the same.
4992: PA_PROJECT_STUS_UTILS.get_wf_success_failure_status (
4993: p_status_code => rec.status_code,
4994: p_status_type => l_status_type,
4995: x_wf_success_status_code => l_next_status_code,
4996: x_wf_failure_status_code => l_temp_status_code,

Line 5057: PA_PROJECT_STUS_UTILS.get_wf_success_failure_status (

5053: END IF;
5054:
5055: IF l_first_status <> l_status_code THEN
5056: PA_SCHEDULE_UTILS.log_message(1,'Call API to get next status');
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_next_status_code,
5061: x_wf_failure_status_code => l_temp_status_code,

Line 5094: PA_PROJECT_STUS_UTILS.get_wf_success_failure_status (

5090: l_last_end_date := l_end_date;
5091:
5092: IF C1%ROWCOUNT = l_count THEN
5093: PA_SCHEDULE_UTILS.log_message(1,'Call API to get next status for last record');
5094: PA_PROJECT_STUS_UTILS.get_wf_success_failure_status (
5095: p_status_code => l_first_status,
5096: p_status_type => l_status_type,
5097: x_wf_success_status_code => l_next_status_code,
5098: x_wf_failure_status_code => l_temp_status_code,

Line 5244: PA_PROJECT_STUS_UTILS.get_wf_success_failure_status (

5240:
5241: /* FOR rec IN C1 LOOP
5242: -- Call Ramesh's API to get next success status.
5243: -- For now, make them the same.
5244: PA_PROJECT_STUS_UTILS.get_wf_success_failure_status (
5245: p_status_code => rec.status_code,
5246: p_status_type => l_status_type,
5247: x_wf_success_status_code => l_temp_status_code,
5248: x_wf_failure_status_code => l_next_status_code,

Line 5306: PA_PROJECT_STUS_UTILS.get_wf_success_failure_status (

5302: END IF;
5303:
5304: IF l_first_status <> l_status_code THEN
5305: PA_SCHEDULE_UTILS.log_message(1,'Call API to get next status');
5306: PA_PROJECT_STUS_UTILS.get_wf_success_failure_status (
5307: p_status_code => l_first_status,
5308: p_status_type => l_status_type,
5309: x_wf_success_status_code => l_temp_status_code,
5310: x_wf_failure_status_code => l_next_status_code,

Line 5343: PA_PROJECT_STUS_UTILS.get_wf_success_failure_status (

5339: l_last_end_date := l_end_date;
5340:
5341: IF C1%ROWCOUNT = l_count THEN
5342: PA_SCHEDULE_UTILS.log_message(1,'Call API to get next status for last record');
5343: PA_PROJECT_STUS_UTILS.get_wf_success_failure_status (
5344: p_status_code => l_first_status,
5345: p_status_type => l_status_type,
5346: x_wf_success_status_code => l_temp_status_code,
5347: x_wf_failure_status_code => l_next_status_code,