APPS.FF_DATA_DICT dependencies on HR_S_QP_REPORTS

Line 590: update hr_s_qp_reports

586:
587: update hr_s_ftype_context_usages
588: set formula_type_id = formula_type_id - 50000000;
589:
590: update hr_s_qp_reports
591: set formula_type_id = formula_type_id - 50000000;
592:
593: update hr_s_application_ownerships
594: set key_value = key_value - 50000000

Line 671: update hr_s_qp_reports

667: update hr_s_ftype_context_usages
668: set formula_type_id = l_new_surrogate_key
669: where formula_type_id = stu_rec.c_surrogate_key;
670:
671: update hr_s_qp_reports
672: set formula_type_id = l_new_surrogate_key
673: where formula_type_id = stu_rec.c_surrogate_key;
674:
675: END update_uid;

Line 1153: update /*+NO_INDEX*/ hr_s_qp_reports

1149:
1150: update /*+NO_INDEX*/ hr_s_formulas_f
1151: set formula_id = formula_id - 50000000;
1152:
1153: update /*+NO_INDEX*/ hr_s_qp_reports
1154: set formula_id = formula_id - 50000000;
1155:
1156: update /*+NO_INDEX*/ hr_s_element_types_f
1157: set formula_id = formula_id - 50000000;

Line 1267: update hr_s_qp_reports

1263: set key_value = to_char(l_new_formula_id)
1264: where key_value = to_char(r_distinct.c_surrogate_key)
1265: and key_name = 'FORMULA_ID';
1266:
1267: update hr_s_qp_reports
1268: set formula_id = l_new_formula_id
1269: where formula_id = r_distinct.c_surrogate_key;
1270:
1271: update hr_s_element_Types_f

Line 3704: from hr_s_qp_reports;

3700: , last_update_login
3701: , created_by
3702: , creation_date
3703: , rowid
3704: from hr_s_qp_reports;
3705:
3706: stu_rec stu%ROWTYPE;
3707:
3708: PROCEDURE crt_exc(exception_type IN varchar2)

Line 3769: from hr_s_qp_reports b

3765: into l_null_return
3766: from ff_qp_reports a
3767: where exists
3768: (select null
3769: from hr_s_qp_reports b
3770: where a.qp_report_id = b.qp_report_id
3771: );
3772:
3773: --conflict may exist

Line 3776: update hr_s_qp_reports

3772:
3773: --conflict may exist
3774: --update all qp_report_id's to remove conflict
3775:
3776: update hr_s_qp_reports
3777: set qp_report_id = qp_report_id - 50000000;
3778:
3779: update hr_s_application_ownerships
3780: set key_value = key_value - 50000000

Line 3792: from hr_s_qp_reports;

3788: select min(qp_report_id) - (count(*) *3)
3789: , max(qp_report_id) + (count(*) *3)
3790: into v_min_delivered
3791: , v_max_delivered
3792: from hr_s_qp_reports;
3793:
3794: select ff_qp_reports_s.nextval
3795: into v_sequence_number
3796: from dual;

Line 3837: update hr_s_qp_reports

3833: END;
3834:
3835: -- Update all child entities
3836:
3837: update hr_s_qp_reports
3838: set qp_report_id = l_new_surrogate_key
3839: where qp_report_id = stu_rec.c_surrogate_key;
3840:
3841: update hr_s_application_ownerships

Line 3855: delete from hr_s_qp_reports

3851: -- Remove a row from either the startup tables or the installed tables
3852:
3853: BEGIN
3854:
3855: delete from hr_s_qp_reports
3856: where rowid = stu_rec.rowid;
3857:
3858: END remove;
3859: