APPS.PER_POS_STRUCTURE_VERSIONS_PKG dependencies on PER_POS_STRUCTURE_ELEMENTS

Line 175: from per_pos_structure_elements pse

171: -- Define Cursor for the Inserts
172: --
173: Cursor Struct_element is
174: select *
175: from per_pos_structure_elements pse
176: where pse.pos_structure_version_id = X_Copy_Structure_Version_Id;
177: --
178: -- Local Variable
179: --

Line 185: INSERT INTO PER_POS_STRUCTURE_ELEMENTS(

181: l_Rowid VARCHAR2(20);
182: l_Structure_element_id NUMBER;
183: begin
184:
185: INSERT INTO PER_POS_STRUCTURE_ELEMENTS(
186: pos_structure_element_id,
187: business_group_id,
188: pos_structure_version_id,
189: subordinate_position_id,

Line 192: select per_pos_structure_elements_s.nextval,

188: pos_structure_version_id,
189: subordinate_position_id,
190: parent_position_id
191: )
192: select per_pos_structure_elements_s.nextval,
193: business_group_id,
194: x_pos_structure_version_id,
195: subordinate_position_id,
196: parent_position_id

Line 197: from per_pos_structure_elements pse

193: business_group_id,
194: x_pos_structure_version_id,
195: subordinate_position_id,
196: parent_position_id
197: from per_pos_structure_elements pse
198: where pse.pos_structure_version_id = X_Copy_Structure_Version_Id;
199: /*
200: open Struct_element;
201: fetch Struct_element into ele_record;

Line 204: PER_POS_STRUCTURE_ELEMENTS_PKG.Insert_Row(

200: open Struct_element;
201: fetch Struct_element into ele_record;
202: loop
203: exit when Struct_element%NOTFOUND;
204: PER_POS_STRUCTURE_ELEMENTS_PKG.Insert_Row(
205: X_Rowid => l_Rowid
206: ,X_Pos_Structure_Element_Id =>l_Structure_element_id
207: ,X_Business_Group_Id => ele_record.Business_Group_Id
208: ,X_Pos_Structure_Version_Id => X_Pos_Structure_Version_Id

Line 236: from PER_POS_STRUCTURE_ELEMENTS PSE

232: select null
233: into l_dummy
234: from sys.dual
235: where exists( select null
236: from PER_POS_STRUCTURE_ELEMENTS PSE
237: where PSE.POS_STRUCTURE_VERSION_ID = X_Pos_Structure_Version_Id);
238: --
239: hr_utility.set_message('801','HR_6205_PO_POS_POS_NO_DEL');
240: hr_utility.raise_error;