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 1572: from hr_s_application_ownerships a

1568: select null --if exception raised then this row is not needed
1569: into l_null_return
1570: from dual
1571: where exists (select null
1572: from hr_s_application_ownerships a
1573: , fnd_product_installations b
1574: , fnd_application c
1575: where a.key_name = 'FORMULA_ID'
1576: and a.key_value = r_distinct.c_surrogate_key

Line 2056: update hr_s_application_ownerships

2052:
2053: update /*+NO_INDEX*/ hr_s_routes
2054: set route_id = route_id - 50000000;
2055:
2056: update hr_s_application_ownerships
2057: set key_value = key_value - 50000000
2058: where key_name = 'ROUTE_ID';
2059:
2060: update /*+NO_INDEX*/ hr_s_balance_dimensions

Line 2254: update hr_s_application_ownerships

2250: update hr_s_routes
2251: set route_id = l_new_surrogate_key
2252: where rowid = stu_rec.rowid;
2253:
2254: update hr_s_application_ownerships
2255: set key_value = to_char(l_new_surrogate_key)
2256: where key_value = to_char(stu_rec.c_surrogate_key)
2257: and key_name = 'ROUTE_ID';
2258:

Line 2445: from hr_s_application_ownerships a

2441: select null
2442: from dual
2443: where exists
2444: (select null
2445: from hr_s_application_ownerships a
2446: , fnd_product_installations b
2447: , fnd_application c
2448: where a.key_name = 'ROUTE_ID'
2449: and a.key_value = stu_rec.c_surrogate_key

Line 3830: update hr_s_application_ownerships

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
3832: where key_name = 'QP_REPORT_ID';
3833:
3834: EXCEPTION WHEN NO_DATA_FOUND THEN NULL;

Line 3892: update hr_s_application_ownerships

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
3893: set key_value = to_char(l_new_surrogate_key)
3894: where key_value = to_char(stu_rec.c_surrogate_key)
3895: and key_name = 'QP_REPORT_ID';
3896:

Line 3954: from hr_s_application_ownerships a

3950: into l_null_return
3951: from dual
3952: where exists
3953: (select null
3954: from hr_s_application_ownerships a
3955: , fnd_product_installations b
3956: , fnd_application c
3957: where a.key_name = 'QP_REPORT_ID'
3958: and a.key_value = stu_rec.c_surrogate_key

Line 4443: update hr_s_application_ownerships

4439:
4440: update /*+NO_INDEX*/ hr_s_globals_f
4441: set global_id = global_id - 50000000;
4442:
4443: update hr_s_application_ownerships
4444: set key_value = key_value - 50000000
4445: where key_name = 'GLOBAL_ID';
4446:
4447: EXCEPTION WHEN NO_DATA_FOUND THEN NULL;

Line 4519: update hr_s_application_ownerships

4515: update hr_s_globals_f
4516: set global_id = l_new_global_id
4517: where global_id = r_distinct.c_surrogate_key;
4518:
4519: update hr_s_application_ownerships
4520: set key_value = to_char(l_new_global_id)
4521: where key_value = to_char(r_distinct.c_surrogate_key)
4522: and key_name = 'GLOBAL_ID';
4523:

Line 4653: where exists (select null from hr_s_application_ownerships a

4649:
4650: select null
4651: into l_null_return
4652: from dual
4653: where exists (select null from hr_s_application_ownerships a
4654: , fnd_product_installations b
4655: , fnd_application c
4656: where a.key_name = 'GLOBAL_ID'
4657: and a.key_value = r_distinct.c_surrogate_key