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 6377: -- INSTALLATION PROCEDURE FOR : PAY_REPORT_FORMAT_ITEMS_F

6373: END install_magnetic_records;
6374:
6375:
6376: --****************************************************************************
6377: -- INSTALLATION PROCEDURE FOR : PAY_REPORT_FORMAT_ITEMS_F
6378: --****************************************************************************
6379: PROCEDURE install_report_items(p_phase IN number)
6380:
6381: -- as this table does not have a primary key, but uses a cpomposite key,

Line 6438: from pay_report_format_items_f a

6434: If cnt=0 then return; end if;
6435:
6436: select distinct null
6437: into l_null_return
6438: from pay_report_format_items_f a
6439: where exists
6440: (select null
6441: from hr_s_report_format_items_f b
6442: where a.report_format_item_id = b.report_format_item_id

Line 6461: from pay_report_format_items_f;

6457: from hr_s_report_format_items_f;
6458:
6459: select max(report_format_item_id)
6460: into v_max_live
6461: from pay_report_format_items_f;
6462:
6463: select pay_report_format_items_s.nextval
6464: into v_sequence_number
6465: from dual;

Line 6497: from pay_report_format_items_f

6493: BEGIN
6494:
6495: select distinct report_format_item_id
6496: into l_new_surrogate_key
6497: from pay_report_format_items_f
6498: where report_type = stu_rec.report_type
6499: and report_qualifier = stu_rec.report_qualifier
6500: and report_category = stu_rec.report_category
6501: and user_entity_id = stu_rec.user_entity_id;

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

6508: from dual;
6509:
6510: WHEN TOO_MANY_ROWS THEN
6511: hrrunprc_trace_on;
6512: hr_utility.trace('sel pay_report_format_items_f TMR');
6513: hr_utility.trace('report_type ' ||
6514: stu_rec.report_type);
6515: hr_utility.trace('report_qualifier ' ||
6516: stu_rec.report_qualifier);

Line 6565: update pay_report_format_items_f

6561: -- this updates uses only report_type,qualifier,category as its primary key
6562: -- it may be that effective start and end dates will need to be added
6563: -- but as of know we can see no need for this
6564:
6565: update pay_report_format_items_f
6566: set effective_start_date=stu_rec.effective_start_date
6567: , effective_end_date=stu_rec.effective_end_date
6568: , archive_type=stu_rec.archive_type
6569: , updatable_flag=stu_rec.updatable_flag

Line 6586: insert into pay_report_format_items_f

6582: and effective_end_date = stu_rec.effective_end_date ;
6583:
6584: IF SQL%NOTFOUND THEN
6585: BEGIN
6586: insert into pay_report_format_items_f
6587: ( report_type ,
6588: report_qualifier ,
6589: report_category ,
6590: user_entity_id ,

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

6619: );
6620:
6621: EXCEPTION WHEN OTHERS THEN
6622: hrrunprc_trace_on;
6623: hr_utility.trace('ins pay_report_format_items_f');
6624: hr_utility.trace('report_type ' ||
6625: stu_rec.report_type);
6626: hr_utility.trace('report_qualifier ' ||
6627: stu_rec.report_qualifier);