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.PER_POS_STRUCT_ELEMENTS_PKG2 dependencies on PER_POS_STRUCTURE_ELEMENTS

Line 21: from per_pos_structure_elements a

17:
18: begin
19: select '1'
20: into l_dummy
21: from per_pos_structure_elements a
22: where a.business_group_id + 0 = X_Business_Group_Id
23: and a.POS_structure_version_id = X_Pos_Structure_Version_Id;
24: exception when no_data_found then
25: null;

Line 44: from per_pos_structure_elements ose

40:
41: begin
42: select '1'
43: into l_dummy
44: from per_pos_structure_elements ose
45: where ose.business_group_id + 0 = X_Business_Group_Id
46: and ose.POS_structure_version_id = X_Pos_Structure_Version_Id
47: and exists
48: (select null

Line 49: from per_pos_structure_elements a

45: where ose.business_group_id + 0 = X_Business_Group_Id
46: and ose.POS_structure_version_id = X_Pos_Structure_Version_Id
47: and exists
48: (select null
49: from per_pos_structure_elements a
50: where a.POS_structure_version_id = X_Pos_Structure_Version_Id
51: and a.parent_position_id = X_Position_Id)
52: and not exists
53: (select null

Line 54: from per_pos_structure_elements b

50: where a.POS_structure_version_id = X_Pos_Structure_Version_Id
51: and a.parent_position_id = X_Position_Id)
52: and not exists
53: (select null
54: from per_pos_structure_elements b
55: where b.POS_structure_version_id = X_Pos_Structure_Version_Id
56: and b.subordinate_position_id = X_Position_Id);
57:
58: exception when no_data_found then

Line 93: from per_pos_structure_elements ose

89: The parent of a root POSITION should not already exist in the hierarchy
90: */
91: select '1'
92: into l_dummy
93: from per_pos_structure_elements ose
94: where (ose.subordinate_position_id = X_Parent_Position_Id
95: or ose.parent_position_id = X_Parent_Position_Id)
96: and ose.POS_structure_version_id = X_Pos_Structure_Version_Id
97: and ose.business_group_id + 0 = X_Business_Group_Id;

Line 117: from per_pos_structure_elements ose

113: l_dummy :=NULL;
114: begin
115: select '1'
116: into l_dummy
117: from per_pos_structure_elements ose
118: where (ose.subordinate_position_id = X_Parent_Position_Id
119: or ose.parent_position_id = X_Parent_Position_Id)
120: and ose.POS_structure_version_id = X_Pos_Structure_Version_Id
121: and ose.business_group_id + 0 = X_Business_Group_Id;

Line 141: from per_pos_structure_elements ose

137: l_dummy :=NULL;
138: begin
139: select '1'
140: into l_dummy
141: from per_pos_structure_elements ose
142: where
143: ose.POS_structure_version_id = X_Pos_Structure_Version_Id
144: and ose.business_group_id + 0 = X_Business_Group_Id
145: and X_Parent_Position_Id in

Line 148: from per_pos_structure_elements ose

144: and ose.business_group_id + 0 = X_Business_Group_Id
145: and X_Parent_Position_Id in
146: (
147: select ose.subordinate_position_id
148: from per_pos_structure_elements ose
149: where ose.POS_structure_version_id = X_Pos_Structure_Version_Id
150: and ose.business_group_id + 0 = X_Business_Group_Id
151: connect by
152: prior ose.subordinate_position_id = ose.parent_position_id

Line 184: from per_pos_structure_elements tab

180: l_dummy varchar2(1);
181:
182: cursor csr_exists is
183: select '1'
184: from per_pos_structure_elements tab
185: where (( X_Rowid is not null
186: and tab.rowid <> X_Rowid)
187: or X_Rowid is null)
188: and X_Pos_Structure_Version_Id = tab.pos_structure_version_id

Line 270: from per_pos_structure_elements ose

266: l_dummy := NULL;
267: begin
268: select '1'
269: into l_dummy
270: from per_pos_structure_elements ose
271: where ose.business_group_id + 0 = X_Business_Group_Id
272: and ose.POS_structure_version_id = X_Pos_Structure_Version_Id
273: and not exists
274: (select null

Line 275: from per_pos_structure_elements b

271: where ose.business_group_id + 0 = X_Business_Group_Id
272: and ose.POS_structure_version_id = X_Pos_Structure_Version_Id
273: and not exists
274: (select null
275: from per_pos_structure_elements b
276: where b.POS_structure_version_id = X_Pos_Structure_Version_Id
277: and b.subordinate_position_id = X_Parent_Position_Id)
278: and not exists
279: (select null

Line 280: from per_pos_structure_elements c

276: where b.POS_structure_version_id = X_Pos_Structure_Version_Id
277: and b.subordinate_position_id = X_Parent_Position_Id)
278: and not exists
279: (select null
280: from per_pos_structure_elements c
281: where c.pos_structure_version_id = X_Pos_Structure_Version_Id
282: and c.parent_position_id = X_Parent_Position_Id
283: and c.subordinate_position_id <> X_Subordinate_Position_Id);
284: exception when no_data_found then

Line 294: FROM PER_POS_STRUCTURE_ELEMENTS OSE

290: l_dummy := NULL;
291: begin
292: SELECT '1'
293: into l_dummy
294: FROM PER_POS_STRUCTURE_ELEMENTS OSE
295: WHERE OSE.POS_STRUCTURE_VERSION_ID = X_Pos_Structure_Version_Id
296: AND OSE.PARENT_POSITION_ID = X_Subordinate_Position_Id;
297: exception when no_data_found then
298: null;

Line 324: CURSOR C IS SELECT rowid FROM PER_POS_STRUCTURE_ELEMENTS

320: X_End_of_time DATE,
321: X_Session_Date DATE,
322: X_hr_ins VARCHAR2
323: ) IS
324: CURSOR C IS SELECT rowid FROM PER_POS_STRUCTURE_ELEMENTS
325:
326: WHERE pos_structure_element_id = X_Pos_Structure_Element_Id;
327:
328:

Line 332: CURSOR C2 IS SELECT per_pos_structure_elements_s.nextval FROM sys.dual;

328:
329:
330:
331:
332: CURSOR C2 IS SELECT per_pos_structure_elements_s.nextval FROM sys.dual;
333: BEGIN
334:
335: if (X_Pos_Structure_Element_Id is NULL) then
336: OPEN C2;

Line 352: INSERT INTO PER_POS_STRUCTURE_ELEMENTS(

348: X_Position_Id,
349: X_Parent_Position_Id,
350: X_Subordinate_Position_Id);
351:
352: INSERT INTO PER_POS_STRUCTURE_ELEMENTS(
353: pos_structure_element_id,
354: business_group_id,
355: pos_structure_version_id,
356: subordinate_position_id,

Line 388: FROM PER_POS_STRUCTURE_ELEMENTS

384: X_Parent_Position_Id NUMBER
385: ) IS
386: CURSOR C IS
387: SELECT *
388: FROM PER_POS_STRUCTURE_ELEMENTS
389: WHERE rowid = X_Rowid
390: FOR UPDATE of Pos_Structure_Element_Id NOWAIT;
391: Recinfo C%ROWTYPE;
392: BEGIN

Line 441: UPDATE PER_POS_STRUCTURE_ELEMENTS

437: X_Parent_Position_Id,
438: X_Subordinate_Position_Id);
439:
440:
441: UPDATE PER_POS_STRUCTURE_ELEMENTS
442: SET
443:
444: pos_structure_element_id = X_Pos_Structure_Element_Id,
445: business_group_id = X_Business_Group_Id,

Line 482: DELETE FROM PER_POS_STRUCTURE_ELEMENTS

478: X_Subordinate_Position_Id,
479: X_Position_Id);
480: end if;
481:
482: DELETE FROM PER_POS_STRUCTURE_ELEMENTS
483: WHERE rowid = X_Rowid;
484:
485: if (SQL%NOTFOUND) then
486: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');