DBA Data[Home] [Help]

APPS.PA_SCHEDULE_PVT dependencies on PA_ASGMT_CHANGED_ITEMS

Line 5637: -- Purpose : Poplulates new and old values for schedule changes to pa_asgmt_changed_items

5633:
5634:
5635: --
5636: -- Procedure : Update_asgmt_changed_items_tab
5637: -- Purpose : Poplulates new and old values for schedule changes to pa_asgmt_changed_items
5638: -- table which stores the assignment_changes that are pending approval.
5639: -- Parameter
5640: -- p_populate_mode : SAVED/ASSIGNMENT_UPDATED/SCHEDULE_UPDATED
5641: --

Line 5672: l_changed_item_name pa_asgmt_changed_items.changed_item_name%TYPE;

5668: ,p_duration_shift_unit_code IN VARCHAR2 := NULL
5669: ,p_number_of_shift IN NUMBER := NULL
5670: ,x_return_status OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
5671: IS
5672: l_changed_item_name pa_asgmt_changed_items.changed_item_name%TYPE;
5673: l_date_range pa_asgmt_changed_items.date_range%TYPE;
5674: l_old_value pa_asgmt_changed_items.old_value%TYPE;
5675: l_new_value pa_asgmt_changed_items.new_value%TYPE;
5676: /* Added for bug 1635170*/

Line 5673: l_date_range pa_asgmt_changed_items.date_range%TYPE;

5669: ,p_number_of_shift IN NUMBER := NULL
5670: ,x_return_status OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
5671: IS
5672: l_changed_item_name pa_asgmt_changed_items.changed_item_name%TYPE;
5673: l_date_range pa_asgmt_changed_items.date_range%TYPE;
5674: l_old_value pa_asgmt_changed_items.old_value%TYPE;
5675: l_new_value pa_asgmt_changed_items.new_value%TYPE;
5676: /* Added for bug 1635170*/
5677: temp_start_date DATE;

Line 5674: l_old_value pa_asgmt_changed_items.old_value%TYPE;

5670: ,x_return_status OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
5671: IS
5672: l_changed_item_name pa_asgmt_changed_items.changed_item_name%TYPE;
5673: l_date_range pa_asgmt_changed_items.date_range%TYPE;
5674: l_old_value pa_asgmt_changed_items.old_value%TYPE;
5675: l_new_value pa_asgmt_changed_items.new_value%TYPE;
5676: /* Added for bug 1635170*/
5677: temp_start_date DATE;
5678: temp_end_date DATE;

Line 5675: l_new_value pa_asgmt_changed_items.new_value%TYPE;

5671: IS
5672: l_changed_item_name pa_asgmt_changed_items.changed_item_name%TYPE;
5673: l_date_range pa_asgmt_changed_items.date_range%TYPE;
5674: l_old_value pa_asgmt_changed_items.old_value%TYPE;
5675: l_new_value pa_asgmt_changed_items.new_value%TYPE;
5676: /* Added for bug 1635170*/
5677: temp_start_date DATE;
5678: temp_end_date DATE;
5679: l_insert_schedule_change BOOLEAN :=TRUE;

Line 5805: INSERT INTO pa_asgmt_changed_items (assignment_id, changed_item_name, date_range, old_value, new_value)

5801: v_c1.resource_calendar_percent,
5802: v_c1.change_calendar_type_code,
5803: null);
5804:
5805: INSERT INTO pa_asgmt_changed_items (assignment_id, changed_item_name, date_range, old_value, new_value)
5806: VALUES (p_assignment_id, l_changed_item_name, l_date_range, l_old_value, l_new_value);
5807: END IF; /* Added for bug 1635170*/
5808: END LOOP;
5809: END IF;

Line 5857: INSERT INTO pa_asgmt_changed_items (assignment_id, changed_item_name, date_range, old_value, new_value)

5853: null,
5854: null,
5855: null);
5856:
5857: INSERT INTO pa_asgmt_changed_items (assignment_id, changed_item_name, date_range, old_value, new_value)
5858: VALUES (p_assignment_id, l_changed_item_name, l_date_range, l_old_value, l_new_value);
5859: END LOOP;
5860:
5861: END IF;

Line 5963: INSERT INTO pa_asgmt_changed_items (assignment_id, changed_item_name, date_range, old_value, new_value)

5959: p_calendar_percent,
5960: p_change_calendar_type_code,
5961: p_change_calendar_name);
5962:
5963: INSERT INTO pa_asgmt_changed_items (assignment_id, changed_item_name, date_range, old_value, new_value)
5964: VALUES (p_assignment_id, l_changed_item_name, l_date_range, l_old_value, l_new_value);
5965: END IF;
5966: END IF; -- IF (p_populate_mode = 'SCHEDULE_UPDATED')
5967: