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 3755: from hr_s_qp_reports;

3751: , last_update_login
3752: , created_by
3753: , creation_date
3754: , rowid
3755: from hr_s_qp_reports;
3756:
3757: stu_rec stu%ROWTYPE;
3758:
3759: PROCEDURE crt_exc(exception_type IN varchar2)

Line 3820: from hr_s_qp_reports b

3816: into l_null_return
3817: from ff_qp_reports a
3818: where exists
3819: (select null
3820: from hr_s_qp_reports b
3821: where a.qp_report_id = b.qp_report_id
3822: );
3823:
3824: --conflict may exist

Line 3827: update hr_s_qp_reports

3823:
3824: --conflict may exist
3825: --update all qp_report_id's to remove conflict
3826:
3827: update hr_s_qp_reports
3828: set qp_report_id = qp_report_id - 50000000;
3829:
3830: update hr_s_application_ownerships
3831: set key_value = key_value - 50000000

Line 3843: from hr_s_qp_reports;

3839: select min(qp_report_id) - (count(*) *3)
3840: , max(qp_report_id) + (count(*) *3)
3841: into v_min_delivered
3842: , v_max_delivered
3843: from hr_s_qp_reports;
3844:
3845: select ff_qp_reports_s.nextval
3846: into v_sequence_number
3847: from dual;

Line 3888: update hr_s_qp_reports

3884: END;
3885:
3886: -- Update all child entities
3887:
3888: update hr_s_qp_reports
3889: set qp_report_id = l_new_surrogate_key
3890: where qp_report_id = stu_rec.c_surrogate_key;
3891:
3892: update hr_s_application_ownerships

Line 3906: delete from hr_s_qp_reports

3902: -- Remove a row from either the startup tables or the installed tables
3903:
3904: BEGIN
3905:
3906: delete from hr_s_qp_reports
3907: where rowid = stu_rec.rowid;
3908:
3909: END remove;
3910: