APPS.HR_LEGISLATION dependencies on PAY_REPORT_FORMAT_ITEMS_F

Line 192: -- 115.34 tbattoo 25-Apr-2000 Added support for pay_report_format_items_f

188: -- 115.32 tbattoo 12-APr-2000 Added new columns to install
189: -- pay_legislative_field_info
190: -- 115.33 tbattoo 18-Apr-2000 Added updatable_flag column to
191: -- install_report_mappings
192: -- 115.34 tbattoo 25-Apr-2000 Added support for pay_report_format_items_f
193: -- 115.35 mreid 19-Jun-2000 Added to update_sequence in case
194: -- sequence has been rebuilt and is less
195: -- than the installed rows.
196: -- 115.36 divicker 11-Sep-2000 Performace changes

Line 6127: -- INSTALLATION PROCEDURE FOR : PAY_REPORT_FORMAT_ITEMS_F

6123: END install_magnetic_records;
6124:
6125:
6126: --****************************************************************************
6127: -- INSTALLATION PROCEDURE FOR : PAY_REPORT_FORMAT_ITEMS_F
6128: --****************************************************************************
6129: PROCEDURE install_report_items(p_phase IN number)
6130:
6131: -- as this table does not have a primary key, but uses a cpomposite key,

Line 6188: from pay_report_format_items_f a

6184: If cnt=0 then return; end if;
6185:
6186: select distinct null
6187: into l_null_return
6188: from pay_report_format_items_f a
6189: where exists
6190: (select null
6191: from hr_s_report_format_items_f b
6192: where a.report_format_item_id = b.report_format_item_id

Line 6211: from pay_report_format_items_f;

6207: from hr_s_report_format_items_f;
6208:
6209: select max(report_format_item_id)
6210: into v_max_live
6211: from pay_report_format_items_f;
6212:
6213: select pay_report_format_items_s.nextval
6214: into v_sequence_number
6215: from dual;

Line 6247: from pay_report_format_items_f

6243: BEGIN
6244:
6245: select distinct report_format_item_id
6246: into l_new_surrogate_key
6247: from pay_report_format_items_f
6248: where report_type = stu_rec.report_type
6249: and report_qualifier = stu_rec.report_qualifier
6250: and report_category = stu_rec.report_category
6251: and user_entity_id = stu_rec.user_entity_id;

Line 6262: hr_utility.trace('sel pay_report_format_items_f TMR');

6258: from dual;
6259:
6260: WHEN TOO_MANY_ROWS THEN
6261: hrrunprc_trace_on;
6262: hr_utility.trace('sel pay_report_format_items_f TMR');
6263: hr_utility.trace('report_type ' ||
6264: stu_rec.report_type);
6265: hr_utility.trace('report_qualifier ' ||
6266: stu_rec.report_qualifier);

Line 6315: update pay_report_format_items_f

6311: -- this updates uses only report_type,qualifier,category as its primary key
6312: -- it may be that effective start and end dates will need to be added
6313: -- but as of know we can see no need for this
6314:
6315: update pay_report_format_items_f
6316: set effective_start_date=stu_rec.effective_start_date
6317: , effective_end_date=stu_rec.effective_end_date
6318: , archive_type=stu_rec.archive_type
6319: , updatable_flag=stu_rec.updatable_flag

Line 6336: insert into pay_report_format_items_f

6332: and effective_end_date = stu_rec.effective_end_date ;
6333:
6334: IF SQL%NOTFOUND THEN
6335: BEGIN
6336: insert into pay_report_format_items_f
6337: ( report_type ,
6338: report_qualifier ,
6339: report_category ,
6340: user_entity_id ,

Line 6373: hr_utility.trace('ins pay_report_format_items_f');

6369: );
6370:
6371: EXCEPTION WHEN OTHERS THEN
6372: hrrunprc_trace_on;
6373: hr_utility.trace('ins pay_report_format_items_f');
6374: hr_utility.trace('report_type ' ||
6375: stu_rec.report_type);
6376: hr_utility.trace('report_qualifier ' ||
6377: stu_rec.report_qualifier);