APPS.PER_POSITION_STRUCTURES_PKG dependencies on PER_POSITION_STRUCTURES

Line 1: PACKAGE BODY PER_POSITION_STRUCTURES_PKG as

1: PACKAGE BODY PER_POSITION_STRUCTURES_PKG as
2: /* $Header: pepst01t.pkb 120.1 2006/01/11 04:15:38 asahay noship $ */
3:
4: procedure form_startup(p_business_group_id NUMBER,
5: p_security_profile_id IN OUT NOCOPY NUMBER,

Line 80: from per_position_structures psp

76: into l_duplicate_name
77: from sys.dual
78: where exists (
79: select 1
80: from per_position_structures psp
81: where (psp.rowid <> X_Rowid
82: or X_Rowid is null)
83: and upper(psp.name) = upper(X_Name)
84: and psp.business_group_id + 0 = X_Business_group_id);

Line 109: from per_position_structures psp

105: into l_primary_exists
106: from sys.dual
107: where exists (
108: select 1
109: from per_position_structures psp
110: where (psp.rowid <> X_Rowid
111: or X_Rowid is null)
112: and psp.primary_position_flag = 'Y'
113: and psp.business_group_id + 0 = X_Business_group_id);

Line 266: CURSOR C IS SELECT rowid FROM PER_POSITION_STRUCTURES

262: X_Attribute18 VARCHAR2 ,
263: X_Attribute19 VARCHAR2 ,
264: X_Attribute20 VARCHAR2
265: ) IS
266: CURSOR C IS SELECT rowid FROM PER_POSITION_STRUCTURES
267:
268: WHERE position_structure_id = X_Position_Structure_Id;
269: CURSOR C2 IS SELECT per_position_structures_s.nextval FROM sys.dual;
270: BEGIN

Line 269: CURSOR C2 IS SELECT per_position_structures_s.nextval FROM sys.dual;

265: ) IS
266: CURSOR C IS SELECT rowid FROM PER_POSITION_STRUCTURES
267:
268: WHERE position_structure_id = X_Position_Structure_Id;
269: CURSOR C2 IS SELECT per_position_structures_s.nextval FROM sys.dual;
270: BEGIN
271: check_name_unique(X_Rowid => X_Rowid,
272: X_Name => X_Name,
273: X_Business_Group_id => X_Business_Group_id);

Line 284: INSERT INTO PER_POSITION_STRUCTURES(

280: OPEN C2;
281: FETCH C2 INTO X_Position_Structure_Id;
282: CLOSE C2;
283: end if;
284: INSERT INTO PER_POSITION_STRUCTURES(
285: position_structure_id,
286: business_group_id,
287: name,
288: comments,

Line 378: FROM PER_POSITION_STRUCTURES

374: X_Attribute20 VARCHAR2
375: ) IS
376: CURSOR C IS
377: SELECT *
378: FROM PER_POSITION_STRUCTURES
379: WHERE rowid = X_Rowid
380: FOR UPDATE of Position_Structure_Id NOWAIT;
381: Recinfo C%ROWTYPE;
382: BEGIN

Line 514: UPDATE PER_POSITION_STRUCTURES

510: check_primary_flag(X_Rowid => X_Rowid,
511: X_Primary_Flag => X_Primary_Position_Flag,
512: X_Business_Group_id => X_Business_Group_id);
513: --
514: UPDATE PER_POSITION_STRUCTURES
515: SET
516: position_structure_id = X_Position_Structure_Id,
517: business_group_id = X_Business_Group_Id,
518: name = X_Name,

Line 560: DELETE FROM PER_POSITION_STRUCTURES

556: X_Business_Group_Id => X_Business_Group_Id,
557: X_Po_Installed => X_Po_Installed,
558: X_Hr_Installed => X_Hr_Installed);
559: --
560: DELETE FROM PER_POSITION_STRUCTURES
561: WHERE rowid = X_Rowid;
562: if (SQL%NOTFOUND) then
563: RAISE NO_DATA_FOUND;
564: end if;

Line 603: END PER_POSITION_STRUCTURES_PKG;

599: when no_data_found then
600: return false;
601: end postform;
602:
603: END PER_POSITION_STRUCTURES_PKG;