APPS.PER_SIT_PKG dependencies on PER_SPECIAL_INFO_TYPES

Line 25: from per_special_info_types

21: ,p_bg_id in number
22: ,p_id_flex_num in number) is
23: cursor c is
24: select 'x'
25: from per_special_info_types
26: where id_flex_num = p_id_flex_num
27: and (p_special_information_type_id is null or
28: (p_special_information_type_id is not null and
29: special_information_type_id <> p_special_information_type_id))

Line 58: per_special_info_types c

54: ,p_id_flex_num number) return boolean is
55: cursor c is
56: select 'x'
57: from per_person_analyses pa,
58: per_special_info_types c
59: where pa.id_flex_num = c.id_flex_num
60: and pa.business_group_id = p_bg_id
61: and c.business_group_id = pa.business_group_id
62: and pa.id_flex_num = p_id_flex_num; --bug 3648683

Line 130: select per_special_info_types_s.nextval

126: --
127: function get_special_info_type_id return number is
128: l_id number;
129: cursor c is
130: select per_special_info_types_s.nextval
131: from sys.dual;
132: --
133: begin
134: open c;

Line 143: -- Inserts a record into PER_SPECIAL_INFO_TYPES

139: --
140: ----------------------------------------------------------------------
141: -- ins_sit
142: --
143: -- Inserts a record into PER_SPECIAL_INFO_TYPES
144: ----------------------------------------------------------------------
145: --
146: procedure ins_sit (p_SPECIAL_INFORMATION_TYPE_ID in out nocopy NUMBER,
147: p_BUSINESS_GROUP_ID in NUMBER,

Line 186: insert into per_special_info_types

182: ,p_id_flex_num => p_id_flex_num);
183: --
184: p_special_information_type_id := get_special_info_type_id;
185: --
186: insert into per_special_info_types
187: (SPECIAL_INFORMATION_TYPE_ID,
188: BUSINESS_GROUP_ID,
189: ID_FLEX_NUM,
190: COMMENTS,

Line 256: -- Updates a record into PER_SPECIAL_INFO_TYPES

252:
253: ----------------------------------------------------------------------
254: -- upd_sit
255: --
256: -- Updates a record into PER_SPECIAL_INFO_TYPES
257: ----------------------------------------------------------------------
258: --
259: procedure upd_sit (p_SPECIAL_INFORMATION_TYPE_ID in NUMBER,
260: p_BUSINESS_GROUP_ID in NUMBER,

Line 298: update per_special_info_types

294: (p_special_information_type_id => p_special_information_type_id
295: ,p_bg_id => p_business_group_id
296: ,p_id_flex_num => p_id_flex_num);
297: --
298: update per_special_info_types
299: set BUSINESS_GROUP_ID = p_BUSINESS_GROUP_ID,
300: ID_FLEX_NUM = p_ID_FLEX_NUM,
301: COMMENTS = p_COMMENTS,
302: ENABLED_FLAG = p_ENABLED_FLAG,

Line 336: -- Locks a record into PER_SPECIAL_INFO_TYPES

332: --
333: ----------------------------------------------------------------------
334: -- lck
335: --
336: -- Locks a record into PER_SPECIAL_INFO_TYPES
337: ----------------------------------------------------------------------
338: --
339: Procedure lck (p_special_information_type_id in number) is
340: --

Line 345: from per_special_info_types

341: -- Cursor selects the 'current' row from the HR Schema
342: --
343: Cursor C_Sel1 is
344: select SPECIAL_INFORMATION_TYPE_ID
345: from per_special_info_types
346: where SPECIAL_INFORMATION_TYPE_ID = p_SPECIAL_INFORMATION_TYPE_ID
347: for update nowait;
348: --
349: l_dummy number;

Line 482: -- Deletes a record from PER_SPECIAL_INFO_TYPES

478:
479: ----------------------------------------------------------------------
480: -- del_sit
481: --
482: -- Deletes a record from PER_SPECIAL_INFO_TYPES
483: -- Calls delete_usages to also delete associated category usages
484: ----------------------------------------------------------------------
485: --
486: procedure del_sit (p_special_information_type_id in number) is

Line 491: delete from per_special_info_types

487: begin
488: --
489: delete_usages (p_special_information_type_id);
490: --
491: delete from per_special_info_types
492: where special_information_type_id = p_special_information_type_id;
493: --
494: end;
495: