APPS.FF_DATA_DICT dependencies on HR_S_APPLICATION_OWNERSHIPS

Line 192: update hr_s_application_ownerships

188:
189: update /*+NO_INDEX*/ hr_s_function_context_usages
190: set context_id = context_id - 50000000;
191:
192: update hr_s_application_ownerships
193: set key_value = key_value - 50000000
194: where key_name = 'CONTEXT_ID';
195:
196: EXCEPTION WHEN NO_DATA_FOUND THEN NULL;

Line 255: update hr_s_application_ownerships

251: update hr_s_contexts
252: set context_id = l_new_surrogate_key
253: where context_id = stu_rec.c_surrogate_key;
254:
255: update hr_s_application_ownerships
256: set key_value = to_char(l_new_surrogate_key)
257: where key_value = to_char(stu_rec.c_surrogate_key)
258: and key_name = 'CONTEXT_ID';
259:

Line 333: from hr_s_application_ownerships a

329: into l_null_return
330: from dual
331: where exists (
332: select null
333: from hr_s_application_ownerships a
334: , fnd_product_installations b
335: , fnd_application c
336: where a.key_name = 'CONTEXT_ID'
337: and a.key_value = l_new_surrogate_key

Line 593: update hr_s_application_ownerships

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
595: where key_name = 'FORMULA_TYPE_ID';
596:
597: EXCEPTION WHEN NO_DATA_FOUND THEN NULL;

Line 658: update hr_s_application_ownerships

654: update hr_s_formula_types
655: set formula_type_id = l_new_surrogate_key
656: where formula_type_id = stu_rec.c_surrogate_key;
657:
658: update hr_s_application_ownerships
659: set key_value = to_char(l_new_surrogate_key)
660: where key_value = to_char(stu_rec.c_surrogate_key)
661: and key_name = 'FORMULA_TYPE_ID';
662:

Line 701: from hr_s_application_ownerships a

697: select null --if exception raised then this row is not needed
698: from dual
699: where exists (
700: select null
701: from hr_s_application_ownerships a
702: , fnd_product_installations b
703: , fnd_application c
704: where a.key_name = 'FORMULA_TYPE_ID'
705: and a.key_value = l_new_surrogate_key

Line 1174: update hr_s_application_ownerships

1170:
1171: update /*+NO_INDEX*/ hr_s_user_columns
1172: set formula_id = formula_id - 50000000;
1173:
1174: update hr_s_application_ownerships
1175: set key_value = key_value - 50000000
1176: where key_name = 'FORMULA_ID';
1177:
1178: update /*+NO_INDEX*/ hr_s_magnetic_records

Line 1262: update hr_s_application_ownerships

1258: update hr_s_formulas_f
1259: set formula_id = l_new_formula_id
1260: where formula_id = r_distinct.c_surrogate_key;
1261:
1262: update hr_s_application_ownerships
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:

Line 1558: from hr_s_application_ownerships a

1554: select null --if exception raised then this row is not needed
1555: into l_null_return
1556: from dual
1557: where exists (select null
1558: from hr_s_application_ownerships a
1559: , fnd_product_installations b
1560: , fnd_application c
1561: where a.key_name = 'FORMULA_ID'
1562: and a.key_value = r_distinct.c_surrogate_key

Line 2040: update hr_s_application_ownerships

2036:
2037: update /*+NO_INDEX*/ hr_s_routes
2038: set route_id = route_id - 50000000;
2039:
2040: update hr_s_application_ownerships
2041: set key_value = key_value - 50000000
2042: where key_name = 'ROUTE_ID';
2043:
2044: update /*+NO_INDEX*/ hr_s_balance_dimensions

Line 2238: update hr_s_application_ownerships

2234: update hr_s_routes
2235: set route_id = l_new_surrogate_key
2236: where rowid = stu_rec.rowid;
2237:
2238: update hr_s_application_ownerships
2239: set key_value = to_char(l_new_surrogate_key)
2240: where key_value = to_char(stu_rec.c_surrogate_key)
2241: and key_name = 'ROUTE_ID';
2242:

Line 2419: from hr_s_application_ownerships a

2415: select null
2416: from dual
2417: where exists
2418: (select null
2419: from hr_s_application_ownerships a
2420: , fnd_product_installations b
2421: , fnd_application c
2422: where a.key_name = 'ROUTE_ID'
2423: and a.key_value = stu_rec.c_surrogate_key

Line 3779: update hr_s_application_ownerships

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
3781: where key_name = 'QP_REPORT_ID';
3782:
3783: EXCEPTION WHEN NO_DATA_FOUND THEN NULL;

Line 3841: update hr_s_application_ownerships

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
3842: set key_value = to_char(l_new_surrogate_key)
3843: where key_value = to_char(stu_rec.c_surrogate_key)
3844: and key_name = 'QP_REPORT_ID';
3845:

Line 3903: from hr_s_application_ownerships a

3899: into l_null_return
3900: from dual
3901: where exists
3902: (select null
3903: from hr_s_application_ownerships a
3904: , fnd_product_installations b
3905: , fnd_application c
3906: where a.key_name = 'QP_REPORT_ID'
3907: and a.key_value = stu_rec.c_surrogate_key

Line 4392: update hr_s_application_ownerships

4388:
4389: update /*+NO_INDEX*/ hr_s_globals_f
4390: set global_id = global_id - 50000000;
4391:
4392: update hr_s_application_ownerships
4393: set key_value = key_value - 50000000
4394: where key_name = 'GLOBAL_ID';
4395:
4396: EXCEPTION WHEN NO_DATA_FOUND THEN NULL;

Line 4468: update hr_s_application_ownerships

4464: update hr_s_globals_f
4465: set global_id = l_new_global_id
4466: where global_id = r_distinct.c_surrogate_key;
4467:
4468: update hr_s_application_ownerships
4469: set key_value = to_char(l_new_global_id)
4470: where key_value = to_char(r_distinct.c_surrogate_key)
4471: and key_name = 'GLOBAL_ID';
4472:

Line 4602: where exists (select null from hr_s_application_ownerships a

4598:
4599: select null
4600: into l_null_return
4601: from dual
4602: where exists (select null from hr_s_application_ownerships a
4603: , fnd_product_installations b
4604: , fnd_application c
4605: where a.key_name = 'GLOBAL_ID'
4606: and a.key_value = r_distinct.c_surrogate_key