APPS.PA_SCHEDULE_PVT dependencies on PA_ASSIGNMENT_APPROVAL_PUB

Line 5732: IF (p_change_id <> -1 AND l_apprvl_status_code <> PA_ASSIGNMENT_APPROVAL_PUB.g_approved) THEN

5728: -- Populate the temp table from pa_schedule_except_history
5729: ------------------------------------------------------------------------
5730: -- If there is last approved data in history table and approval status is not 'approve',
5731: -- populate temp table from history table first. Because we need to consider mass update submit case.
5732: IF (p_change_id <> -1 AND l_apprvl_status_code <> PA_ASSIGNMENT_APPROVAL_PUB.g_approved) THEN
5733: FOR v_c1 IN C1 LOOP
5734: -- If exception_type is either 'CHANGE_DURATION' or 'SHIFT_DURATION', we want to add only one row
5735: -- to the temp table for both.
5736: IF ( (v_c1.exception_type_code = 'CHANGE_DURATION' OR v_c1.exception_type_code = 'SHIFT_DURATION' OR v_c1.exception_type_code = 'DURATION_PATTERN_SHIFT') AND

Line 7802: PA_ASSIGNMENT_APPROVAL_PUB.cancel_assignment(p_record_version_number =>v_c1.record_version_number,

7798: BEGIN
7799: x_return_status := FND_API.G_RET_STS_SUCCESS;
7800:
7801: For v_c1 in c1 LOOP
7802: PA_ASSIGNMENT_APPROVAL_PUB.cancel_assignment(p_record_version_number =>v_c1.record_version_number,
7803: p_assignment_id => v_c1.assignment_id,
7804: p_assignment_type => v_c1.assignment_type,
7805: p_start_date => v_c1.start_date,
7806: p_end_date => v_c1.end_date,

Line 7853: PA_ASSIGNMENT_APPROVAL_PUB.revert_to_last_approved(p_assignment_id => v_c1.assignment_id,

7849: x_return_status := FND_API.G_RET_STS_SUCCESS;
7850:
7851: FOR v_c1 IN c1 LOOP
7852: PA_SCHEDULE_UTILS.debug('Revert_Overcom_Txn_Items: v_c1.assignment_id = ' || v_c1.assignment_id);
7853: PA_ASSIGNMENT_APPROVAL_PUB.revert_to_last_approved(p_assignment_id => v_c1.assignment_id,
7854: x_return_status => x_return_status,
7855: x_msg_count => x_msg_count,
7856: x_msg_data => x_msg_data);
7857: PA_SCHEDULE_UTILS.debug('Revert_Overcom_Txn_Items: After revert_to_last_approved');

Line 8589: IF (l_history_exist = 'Y' AND l_apprvl_status_code <> PA_ASSIGNMENT_APPROVAL_PUB.g_approved) THEN

8585: ------------------------------------------------------------------
8586: -- CHANGE_DURATION OR SHIFT_DURATION
8587: ------------------------------------------------------------------
8588: IF p_exception_type_code = 'CHANGE_DURATION' OR p_exception_type_code = 'SHIFT_DURATION' OR p_exception_type_code = 'DURATION_PATTERN_SHIFT' THEN
8589: IF (l_history_exist = 'Y' AND l_apprvl_status_code <> PA_ASSIGNMENT_APPROVAL_PUB.g_approved) THEN
8590: l_old_value_text := PA_SCHEDULE_PVT.get_date_range_text(v_c1.start_date, v_c1.end_date);
8591: ELSE
8592: OPEN C1_CURRENT;
8593: FETCH C1_CURRENT INTO v_c1_current;

Line 8605: IF (l_history_exist = 'Y' AND l_apprvl_status_code <> PA_ASSIGNMENT_APPROVAL_PUB.g_approved) THEN

8601: ELSIF p_exception_type_code = 'CHANGE_STATUS' THEN
8602: l_count := 0;
8603: l_multiple := 'F';
8604:
8605: IF (l_history_exist = 'Y' AND l_apprvl_status_code <> PA_ASSIGNMENT_APPROVAL_PUB.g_approved) THEN
8606: FOR v_c2 IN C2 LOOP
8607: IF l_count = 0 THEN
8608: l_current_value := v_c2.status_code;
8609: SELECT project_status_name

Line 8659: IF (l_history_exist = 'Y' AND l_apprvl_status_code <> PA_ASSIGNMENT_APPROVAL_PUB.g_approved) THEN

8655: ------------------------------------------------------------------
8656: ELSIF p_exception_type_code = 'CHANGE_WORK_PATTERN' THEN
8657: l_count := 0;
8658: l_multiple := 'F';
8659: IF (l_history_exist = 'Y' AND l_apprvl_status_code <> PA_ASSIGNMENT_APPROVAL_PUB.g_approved) THEN
8660: FOR v_c2 IN C2 LOOP
8661: IF l_count = 0 THEN
8662: l_current_value := v_c2.mon_hours||','||v_c2.tue_hours||','||v_c2.wed_hours||','||
8663: v_c2.thu_hours||','||v_c2.fri_hours||','||v_c2.sat_hours||','|| v_c2.sun_hours;

Line 8728: IF (l_history_exist = 'Y' AND l_apprvl_status_code <> PA_ASSIGNMENT_APPROVAL_PUB.g_approved) THEN

8724: FOR date_check IN 0..(nvl(p_end_date,p_start_date) - nvl(p_start_date,p_end_date)) LOOP
8725: week_of_day(to_number(to_char(nvl(p_start_date,p_end_date) + date_check,'D'))):=1;
8726: END LOOP;
8727:
8728: IF (l_history_exist = 'Y' AND l_apprvl_status_code <> PA_ASSIGNMENT_APPROVAL_PUB.g_approved) THEN
8729: FOR v_c2 IN C2 LOOP
8730: IF(week_of_day(2)=1)then
8731: change_hours_check(total_nonzero) := v_c2.mon_hours;
8732: total_nonzero:=total_nonzero+1;