[Home] [Help]
97: procedure get_ddf_exists(p_legislation_code VARCHAR2
98: ,p_ddf_exists IN OUT NOCOPY VARCHAR2) is
99: cursor ddf is
100: select 'Y'
101: from sys.dual
102: where exists( select 1 from FND_DESCR_FLEX_CONTEXTS fdfc
103: where fdfc.APPLICATION_ID = 800
104: and fdfc.DESCRIPTIVE_FLEXFIELD_NAME = 'Person Developer DF'
105: and fdfc.enabled_flag = 'Y'
118: procedure get_people_ddf_exists(p_legislation_code VARCHAR2
119: ,p_people_ddf_exists IN OUT NOCOPY VARCHAR2) is
120: cursor ddf is
121: select 'Y'
122: from sys.dual
123: where exists( select 1 from fnd_descr_flex_column_usages fdfc
124: where fdfc.APPLICATION_ID = 800
125: and fdfc.DESCRIPTIVE_FLEXFIELD_NAME = 'PER_PEOPLE'
126: and fdfc.enabled_flag = 'Y');
258: --
259: l_dummy VARCHAR2(1);
260: --
261: cursor fut_apl is select 'Y'
262: from sys.dual
263: where exists (select 'future assignment exists'
264: from per_assignments_f paf
265: where paf.person_id = p_person_id
266: and paf.assignment_type = 'A'
288: l_assignment_id per_all_assignments_f.assignment_id%type;
289: --
290: --
291: cursor fut_apl(l_assignment_id number) is select 'Y'
292: from sys.dual
293: where exists (select 'future assignment exists'
294: from per_assignments_f paf
295: where paf.assignment_id = l_assignment_id
296: and paf.assignment_type = 'A'
894: --
895: begin
896: select 'X'
897: into l_temp
898: from sys.dual
899: where exists ( select 'Events rows exist'
900: from per_events pe
901: , per_assignments_f a
902: where pe.business_group_id +0 = p_business_group_id