eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.PA_SCHEDULE_PVT dependencies on PA_ASGMT_CHANGED_ITEMS

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

5347:
5348:
5349: --
5350: -- Procedure : Update_asgmt_changed_items_tab
5351: -- Purpose : Poplulates new and old values for schedule changes to pa_asgmt_changed_items
5352: -- table which stores the assignment_changes that are pending approval.
5353: -- Parameter
5354: -- p_populate_mode : SAVED/ASSIGNMENT_UPDATED/SCHEDULE_UPDATED
5355: --

Line 5386: l_changed_item_name pa_asgmt_changed_items.changed_item_name%TYPE;

5382: ,p_duration_shift_unit_code IN VARCHAR2 := NULL
5383: ,p_number_of_shift IN NUMBER := NULL
5384: ,x_return_status OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
5385: IS
5386: l_changed_item_name pa_asgmt_changed_items.changed_item_name%TYPE;
5387: l_date_range pa_asgmt_changed_items.date_range%TYPE;
5388: l_old_value pa_asgmt_changed_items.old_value%TYPE;
5389: l_new_value pa_asgmt_changed_items.new_value%TYPE;
5390: /* Added for bug 1635170*/

Line 5387: l_date_range pa_asgmt_changed_items.date_range%TYPE;

5383: ,p_number_of_shift IN NUMBER := NULL
5384: ,x_return_status OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
5385: IS
5386: l_changed_item_name pa_asgmt_changed_items.changed_item_name%TYPE;
5387: l_date_range pa_asgmt_changed_items.date_range%TYPE;
5388: l_old_value pa_asgmt_changed_items.old_value%TYPE;
5389: l_new_value pa_asgmt_changed_items.new_value%TYPE;
5390: /* Added for bug 1635170*/
5391: temp_start_date DATE;

Line 5388: l_old_value pa_asgmt_changed_items.old_value%TYPE;

5384: ,x_return_status OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
5385: IS
5386: l_changed_item_name pa_asgmt_changed_items.changed_item_name%TYPE;
5387: l_date_range pa_asgmt_changed_items.date_range%TYPE;
5388: l_old_value pa_asgmt_changed_items.old_value%TYPE;
5389: l_new_value pa_asgmt_changed_items.new_value%TYPE;
5390: /* Added for bug 1635170*/
5391: temp_start_date DATE;
5392: temp_end_date DATE;

Line 5389: l_new_value pa_asgmt_changed_items.new_value%TYPE;

5385: IS
5386: l_changed_item_name pa_asgmt_changed_items.changed_item_name%TYPE;
5387: l_date_range pa_asgmt_changed_items.date_range%TYPE;
5388: l_old_value pa_asgmt_changed_items.old_value%TYPE;
5389: l_new_value pa_asgmt_changed_items.new_value%TYPE;
5390: /* Added for bug 1635170*/
5391: temp_start_date DATE;
5392: temp_end_date DATE;
5393: l_insert_schedule_change BOOLEAN :=TRUE;

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

5513: v_c1.resource_calendar_percent,
5514: v_c1.change_calendar_type_code,
5515: null);
5516:
5517: INSERT INTO pa_asgmt_changed_items (assignment_id, changed_item_name, date_range, old_value, new_value)
5518: VALUES (p_assignment_id, l_changed_item_name, l_date_range, l_old_value, l_new_value);
5519: END IF; /* Added for bug 1635170*/
5520: END LOOP;
5521: END IF;

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

5565: null,
5566: null,
5567: null);
5568:
5569: INSERT INTO pa_asgmt_changed_items (assignment_id, changed_item_name, date_range, old_value, new_value)
5570: VALUES (p_assignment_id, l_changed_item_name, l_date_range, l_old_value, l_new_value);
5571: END LOOP;
5572:
5573: END IF;

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

5671: p_calendar_percent,
5672: p_change_calendar_type_code,
5673: p_change_calendar_name);
5674:
5675: INSERT INTO pa_asgmt_changed_items (assignment_id, changed_item_name, date_range, old_value, new_value)
5676: VALUES (p_assignment_id, l_changed_item_name, l_date_range, l_old_value, l_new_value);
5677: END IF;
5678: END IF; -- IF (p_populate_mode = 'SCHEDULE_UPDATED')
5679: