APPS.PER_ORG_STRUCTURES_PKG dependencies on PER_ORGANIZATION_STRUCTURES

Line 74: from per_organization_structures os

70: into l_exists
71: from sys.dual
72: where exists(
73: select 'Name exists'
74: from per_organization_structures os
75: where ( os.business_group_id + 0 = p_business_group_id
76: or ( os.business_group_id is null
77: and p_business_group_id is null))
78: and upper(os.name) = upper(p_name)

Line 103: from per_organization_structures os

99: into l_exists
100: from sys.dual
101: where exists(
102: select 'Primary exists'
103: from per_organization_structures os
104: where ( os.business_group_id + 0 = p_business_group_id
105: or ( os.business_group_id is null
106: and p_business_group_id is null))
107: and os.primary_structure_flag = p_primary_flag

Line 127: from per_organization_structures

123: ) is
124:
125: CURSOR C1 is
126: select position_control_structure_flg
127: from per_organization_structures
128: where position_control_structure_flg = 'Y'
129: and organization_structure_id <> nvl(p_organization_structure_id, -1)
130: -- BUG 1694549
131: -- add predicate to check for other pos control structures

Line 149: from per_organization_structures

145: osv.topnode_pos_ctrl_enabled_flag = 'Y'));
146:
147: CURSOR C3 is
148: select *
149: from per_organization_structures
150: where organization_structure_id = nvl(p_organization_structure_id, -1);
151:
152: Recinfo C3%ROWTYPE;
153:

Line 265: CURSOR C IS SELECT rowid FROM PER_ORGANIZATION_STRUCTURES

261: X_Attribute20 VARCHAR2,
262: X_Pos_Control_Structure_Flag VARCHAR2
263: ) IS
264: --
265: CURSOR C IS SELECT rowid FROM PER_ORGANIZATION_STRUCTURES
266: WHERE organization_structure_id = X_Organization_Structure_Id;
267: CURSOR C2 IS SELECT PER_ORGANIZATION_STRUCTURES_S.nextval FROM sys.dual;
268: --
269: BEGIN

Line 267: CURSOR C2 IS SELECT PER_ORGANIZATION_STRUCTURES_S.nextval FROM sys.dual;

263: ) IS
264: --
265: CURSOR C IS SELECT rowid FROM PER_ORGANIZATION_STRUCTURES
266: WHERE organization_structure_id = X_Organization_Structure_Id;
267: CURSOR C2 IS SELECT PER_ORGANIZATION_STRUCTURES_S.nextval FROM sys.dual;
268: --
269: BEGIN
270: --
271: if (X_Organization_Structure_Id is NULL) then

Line 281: INSERT INTO PER_ORGANIZATION_STRUCTURES(

277: check_position_control_flag(X_Organization_Structure_Id,
278: X_Pos_Control_Structure_Flag,
279: X_Business_Group_Id);
280:
281: INSERT INTO PER_ORGANIZATION_STRUCTURES(
282: organization_structure_id,
283: business_group_id,
284: name,
285: comments,

Line 379: FROM PER_ORGANIZATION_STRUCTURES

375: ) IS
376: --
377: CURSOR C IS
378: SELECT *
379: FROM PER_ORGANIZATION_STRUCTURES
380: WHERE rowid = X_Rowid
381: FOR UPDATE of Organization_Structure_Id NOWAIT;
382: Recinfo C%ROWTYPE;
383: --

Line 547: UPDATE PER_ORGANIZATION_STRUCTURES

543: check_position_control_flag(X_Organization_Structure_Id,
544: X_Pos_Control_Structure_Flag,
545: X_Business_Group_Id);
546:
547: UPDATE PER_ORGANIZATION_STRUCTURES
548: SET
549: organization_structure_id = X_Organization_Structure_Id,
550: business_group_id = X_Business_Group_Id,
551: name = X_Name,

Line 596: DELETE FROM PER_ORGANIZATION_STRUCTURES

592: ,p_business_group_id =>p_business_group_id
593: ,p_pa_installed => p_pa_installed
594: );
595: --
596: DELETE FROM PER_ORGANIZATION_STRUCTURES
597: WHERE rowid = X_Rowid;
598: --
599: if (SQL%NOTFOUND) then
600: RAISE NO_DATA_FOUND;