APPS.PA_SCHEDULE_PVT dependencies on PA_ASSIGNMENT_APPROVAL_PUB

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

5440: -- Populate the temp table from pa_schedule_except_history
5441: ------------------------------------------------------------------------
5442: -- If there is last approved data in history table and approval status is not 'approve',
5443: -- populate temp table from history table first. Because we need to consider mass update submit case.
5444: IF (p_change_id <> -1 AND l_apprvl_status_code <> PA_ASSIGNMENT_APPROVAL_PUB.g_approved) THEN
5445: FOR v_c1 IN C1 LOOP
5446: -- If exception_type is either 'CHANGE_DURATION' or 'SHIFT_DURATION', we want to add only one row
5447: -- to the temp table for both.
5448: IF ( (v_c1.exception_type_code = 'CHANGE_DURATION' OR v_c1.exception_type_code = 'SHIFT_DURATION') AND

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

7505: BEGIN
7506: x_return_status := FND_API.G_RET_STS_SUCCESS;
7507:
7508: For v_c1 in c1 LOOP
7509: PA_ASSIGNMENT_APPROVAL_PUB.cancel_assignment(p_record_version_number =>v_c1.record_version_number,
7510: p_assignment_id => v_c1.assignment_id,
7511: p_assignment_type => v_c1.assignment_type,
7512: p_start_date => v_c1.start_date,
7513: p_end_date => v_c1.end_date,

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

7556: x_return_status := FND_API.G_RET_STS_SUCCESS;
7557:
7558: FOR v_c1 IN c1 LOOP
7559: PA_SCHEDULE_UTILS.debug('Revert_Overcom_Txn_Items: v_c1.assignment_id = ' || v_c1.assignment_id);
7560: PA_ASSIGNMENT_APPROVAL_PUB.revert_to_last_approved(p_assignment_id => v_c1.assignment_id,
7561: x_return_status => x_return_status,
7562: x_msg_count => x_msg_count,
7563: x_msg_data => x_msg_data);
7564: PA_SCHEDULE_UTILS.debug('Revert_Overcom_Txn_Items: After revert_to_last_approved');

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

8292: ------------------------------------------------------------------
8293: -- CHANGE_DURATION OR SHIFT_DURATION
8294: ------------------------------------------------------------------
8295: IF p_exception_type_code = 'CHANGE_DURATION' OR p_exception_type_code = 'SHIFT_DURATION' THEN
8296: IF (l_history_exist = 'Y' AND l_apprvl_status_code <> PA_ASSIGNMENT_APPROVAL_PUB.g_approved) THEN
8297: l_old_value_text := PA_SCHEDULE_PVT.get_date_range_text(v_c1.start_date, v_c1.end_date);
8298: ELSE
8299: OPEN C1_CURRENT;
8300: FETCH C1_CURRENT INTO v_c1_current;

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

8308: ELSIF p_exception_type_code = 'CHANGE_STATUS' THEN
8309: l_count := 0;
8310: l_multiple := 'F';
8311:
8312: IF (l_history_exist = 'Y' AND l_apprvl_status_code <> PA_ASSIGNMENT_APPROVAL_PUB.g_approved) THEN
8313: FOR v_c2 IN C2 LOOP
8314: IF l_count = 0 THEN
8315: l_current_value := v_c2.status_code;
8316: SELECT project_status_name

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

8362: ------------------------------------------------------------------
8363: ELSIF p_exception_type_code = 'CHANGE_WORK_PATTERN' THEN
8364: l_count := 0;
8365: l_multiple := 'F';
8366: IF (l_history_exist = 'Y' AND l_apprvl_status_code <> PA_ASSIGNMENT_APPROVAL_PUB.g_approved) THEN
8367: FOR v_c2 IN C2 LOOP
8368: IF l_count = 0 THEN
8369: l_current_value := v_c2.mon_hours||','||v_c2.tue_hours||','||v_c2.wed_hours||','||
8370: v_c2.thu_hours||','||v_c2.fri_hours||','||v_c2.sat_hours||','|| v_c2.sun_hours;

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

8431: FOR date_check IN 0..(nvl(p_end_date,p_start_date) - nvl(p_start_date,p_end_date)) LOOP
8432: week_of_day(to_number(to_char(nvl(p_start_date,p_end_date) + date_check,'D'))):=1;
8433: END LOOP;
8434:
8435: IF (l_history_exist = 'Y' AND l_apprvl_status_code <> PA_ASSIGNMENT_APPROVAL_PUB.g_approved) THEN
8436: FOR v_c2 IN C2 LOOP
8437: IF(week_of_day(2)=1)then
8438: change_hours_check(total_nonzero) := v_c2.mon_hours;
8439: total_nonzero:=total_nonzero+1;