[Home] [Help]
127:
128: cursor cur_user_entity_exists is
129: select user_entity_id ,
130: creator_type
131: from ff_user_entities
132: where user_entity_name = p_user_entity_name
133: and legislation_code = 'CA';
134:
135: cursor cur_user_entity_id is
132: where user_entity_name = p_user_entity_name
133: and legislation_code = 'CA';
134:
135: cursor cur_user_entity_id is
136: select ff_user_entities_s.nextval
137: from dual;
138:
139: l_user_entity_id number;
140: l_creator_type ff_user_entities.creator_type%TYPE;
136: select ff_user_entities_s.nextval
137: from dual;
138:
139: l_user_entity_id number;
140: l_creator_type ff_user_entities.creator_type%TYPE;
141: begin
142: open cur_user_entity_exists;
143: fetch cur_user_entity_exists
144: into l_user_entity_id,
146:
147: if cur_user_entity_exists%found then
148: close cur_user_entity_exists;
149: if l_creator_type = 'SEH' then
150: update ff_user_entities
151: set creator_type = 'X'
152: where user_entity_id = l_user_entity_id
153: and creator_type = 'SEH';
154: end if;
161: fetch cur_user_entity_id
162: into l_user_entity_id;
163: close cur_user_entity_id;
164:
165: insert into ff_user_entities
166: (
167: user_entity_id,
168: business_group_id,
169: legislation_code,
448: declare
449: start_of_time constant date := to_date('0001/01/01','YYYY/MM/DD');
450: end_of_time constant date := to_date('4712/12/31','YYYY/MM/DD');
451:
452: l_user_entity_id ff_user_entities.user_entity_id%TYPE;
453: l_report_type pay_report_format_mappings_f.report_type%TYPE;
454: l_archive_type pay_report_format_items_f.archive_type%TYPE;
455: l_updatable_flag pay_report_format_items_f.updatable_flag%TYPE;
456:
455: l_updatable_flag pay_report_format_items_f.updatable_flag%TYPE;
456:
457: cursor cur_format_item is
458: select fue.user_entity_id
459: from ff_user_entities fue
460: where upper(fue.user_entity_name) = upper(p_user_name);
461:
462: ret number := 0;
463: