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.

APPS.HR_ASSIGNMENT_COMMON_SAVE_WEB dependencies on PER_ALL_ASSIGNMENTS_F

Line 126: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE

122: ,p_pgp_segment28 in varchar2 default null
123: ,p_pgp_segment29 in varchar2 default null
124: ,p_pgp_segment30 in varchar2 default null
125: --
126: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
127: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
128: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
129: ,p_special_ceiling_step_id in out nocopy per_all_assignments_f.special_ceiling_step_id%TYPE
130: ,p_primary_flag in per_all_assignments_f.primary_flag%TYPE

Line 127: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE

123: ,p_pgp_segment29 in varchar2 default null
124: ,p_pgp_segment30 in varchar2 default null
125: --
126: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
127: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
128: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
129: ,p_special_ceiling_step_id in out nocopy per_all_assignments_f.special_ceiling_step_id%TYPE
130: ,p_primary_flag in per_all_assignments_f.primary_flag%TYPE
131: ,p_person_id in per_all_assignments_f.person_id%TYPE

Line 128: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE

124: ,p_pgp_segment30 in varchar2 default null
125: --
126: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
127: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
128: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
129: ,p_special_ceiling_step_id in out nocopy per_all_assignments_f.special_ceiling_step_id%TYPE
130: ,p_primary_flag in per_all_assignments_f.primary_flag%TYPE
131: ,p_person_id in per_all_assignments_f.person_id%TYPE
132: ,p_effective_start_date out nocopy date

Line 129: ,p_special_ceiling_step_id in out nocopy per_all_assignments_f.special_ceiling_step_id%TYPE

125: --
126: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
127: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
128: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
129: ,p_special_ceiling_step_id in out nocopy per_all_assignments_f.special_ceiling_step_id%TYPE
130: ,p_primary_flag in per_all_assignments_f.primary_flag%TYPE
131: ,p_person_id in per_all_assignments_f.person_id%TYPE
132: ,p_effective_start_date out nocopy date
133: ,p_effective_end_date out nocopy date

Line 130: ,p_primary_flag in per_all_assignments_f.primary_flag%TYPE

126: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
127: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
128: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
129: ,p_special_ceiling_step_id in out nocopy per_all_assignments_f.special_ceiling_step_id%TYPE
130: ,p_primary_flag in per_all_assignments_f.primary_flag%TYPE
131: ,p_person_id in per_all_assignments_f.person_id%TYPE
132: ,p_effective_start_date out nocopy date
133: ,p_effective_end_date out nocopy date
134: ,p_element_warning in boolean

Line 131: ,p_person_id in per_all_assignments_f.person_id%TYPE

127: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
128: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
129: ,p_special_ceiling_step_id in out nocopy per_all_assignments_f.special_ceiling_step_id%TYPE
130: ,p_primary_flag in per_all_assignments_f.primary_flag%TYPE
131: ,p_person_id in per_all_assignments_f.person_id%TYPE
132: ,p_effective_start_date out nocopy date
133: ,p_effective_end_date out nocopy date
134: ,p_element_warning in boolean
135: ,p_element_changed in out nocopy varchar2

Line 141: l_object_version_number per_all_assignments_f.object_version_number%TYPE;

137: ) is
138: --
139:
140: l_effective_date date;
141: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
142: l_effective_start_date date;
143: l_effective_end_date date;
144: l_people_group_id per_all_assignments_f.people_group_id%TYPE;
145: l_group_name VARCHAR2(2000);

Line 144: l_people_group_id per_all_assignments_f.people_group_id%TYPE;

140: l_effective_date date;
141: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
142: l_effective_start_date date;
143: l_effective_end_date date;
144: l_people_group_id per_all_assignments_f.people_group_id%TYPE;
145: l_group_name VARCHAR2(2000);
146: l_org_now_no_manager_warning boolean;
147: l_other_manager_warning boolean;
148: l_spp_delete_warning boolean;

Line 151: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;

147: l_other_manager_warning boolean;
148: l_spp_delete_warning boolean;
149: l_entries_changed_warning VARCHAR2(30);
150: l_tax_district_changed_warning boolean;
151: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;
152: l_comment_id per_all_assignments_f.comment_id%TYPE;
153: l_concatenated_segments VARCHAR2(2000);
154: l_validation_start_date per_assignments_f.effective_start_date%TYPE;
155: l_validation_end_date per_assignments_f.effective_end_date%TYPE;

Line 152: l_comment_id per_all_assignments_f.comment_id%TYPE;

148: l_spp_delete_warning boolean;
149: l_entries_changed_warning VARCHAR2(30);
150: l_tax_district_changed_warning boolean;
151: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;
152: l_comment_id per_all_assignments_f.comment_id%TYPE;
153: l_concatenated_segments VARCHAR2(2000);
154: l_validation_start_date per_assignments_f.effective_start_date%TYPE;
155: l_validation_end_date per_assignments_f.effective_end_date%TYPE;
156: l_inv_pos_grade_warning boolean;

Line 165: l_special_ceiling_step_id per_all_assignments_f.special_ceiling_step_id%TYPE;

161: l_old_job_id number;
162: l_new_wc_code number;
163: l_assignment_status_type varchar2(30);
164: l_element_changed varchar2(2000);
165: l_special_ceiling_step_id per_all_assignments_f.special_ceiling_step_id%TYPE;
166: --
167: cursor current_job_id is
168: select job_id
169: from per_all_assignments_f

Line 169: from per_all_assignments_f

165: l_special_ceiling_step_id per_all_assignments_f.special_ceiling_step_id%TYPE;
166: --
167: cursor current_job_id is
168: select job_id
169: from per_all_assignments_f
170: where assignment_id=p_assignment_id
171: and l_effective_date between effective_start_date and effective_end_date;
172: --
173: cursor status_type is

Line 1771: ,p_assignment_rec out nocopy per_all_assignments_f%rowtype

1767: --
1768: --
1769: procedure get_asg_from_tt
1770: (p_transaction_step_id in number
1771: ,p_assignment_rec out nocopy per_all_assignments_f%rowtype
1772: ) is
1773: /* this procedure gets all of the assignment data from the transaction tables
1774: */
1775: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

Line 1775: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

1771: ,p_assignment_rec out nocopy per_all_assignments_f%rowtype
1772: ) is
1773: /* this procedure gets all of the assignment data from the transaction tables
1774: */
1775: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
1776: l_effective_date date;
1777:
1778: begin
1779: --

Line 2358: ,p_assignment_rec out nocopy per_all_assignments_f%rowtype)

2354: end get_scl_from_tt;
2355: --
2356: procedure get_asg_from_asg(p_assignment_id in number
2357: ,p_effective_date in date
2358: ,p_assignment_rec out nocopy per_all_assignments_f%rowtype)
2359: is
2360: /* This procedure gets all of the assignment data from the online tables
2361: */
2362: cursor csr_get_asg is

Line 2364: from per_all_assignments_f

2360: /* This procedure gets all of the assignment data from the online tables
2361: */
2362: cursor csr_get_asg is
2363: select *
2364: from per_all_assignments_f
2365: where assignment_id=p_assignment_id
2366: and p_effective_date between effective_start_date and effective_end_date;
2367: --
2368: begin

Line 2448: ,p_assignment_id in per_all_assignments_f.assignment_id%type

2444: --
2445: procedure get_asg(
2446: p_item_type in wf_items.item_type%TYPE
2447: ,p_item_key in wf_items.item_key%TYPE
2448: ,p_assignment_id in per_all_assignments_f.assignment_id%type
2449: ,p_effective_date in date
2450: ,p_assignment_rec out nocopy per_all_assignments_f%rowtype) is
2451: /* This procedure gets all of the assignment data from the transaction tables
2452: or the online tables if no processing step exists, based in a given item type

Line 2450: ,p_assignment_rec out nocopy per_all_assignments_f%rowtype) is

2446: p_item_type in wf_items.item_type%TYPE
2447: ,p_item_key in wf_items.item_key%TYPE
2448: ,p_assignment_id in per_all_assignments_f.assignment_id%type
2449: ,p_effective_date in date
2450: ,p_assignment_rec out nocopy per_all_assignments_f%rowtype) is
2451: /* This procedure gets all of the assignment data from the transaction tables
2452: or the online tables if no processing step exists, based in a given item type
2453: and item key
2454: */