APPS.HR_LEGISLATION_ELEMENTS dependencies on HR_S_USER_COLUMNS

Line 3358: update /*+NO_INDEX*/ hr_s_user_columns

3354:
3355: --conflict may exist
3356: --update all user_table_id's to remove conflict
3357:
3358: update /*+NO_INDEX*/ hr_s_user_columns
3359: set user_table_id = user_table_id - 50000000;
3360:
3361: update /*+NO_INDEX*/ hr_s_user_rows_f
3362: set user_table_id = user_table_id - 50000000;

Line 3472: update hr_s_user_columns

3468: set key_value = to_char(l_new_surrogate_key)
3469: where key_value = to_char(stu_rec.c_surrogate_key)
3470: and key_name = 'USER_TABLE_ID';
3471:
3472: update hr_s_user_columns
3473: set user_table_id = l_new_surrogate_key
3474: where user_table_id = stu_rec.c_surrogate_key;
3475:
3476: update hr_s_user_rows_f

Line 3826: from hr_s_user_columns;

3822: , last_update_login
3823: , created_by
3824: , creation_date
3825: , rowid
3826: from hr_s_user_columns;
3827:
3828: stu_rec stu%ROWTYPE;
3829:
3830:

Line 3867: from hr_s_user_columns b

3863: into l_null_return
3864: from pay_user_columns a
3865: where exists
3866: (select null
3867: from hr_s_user_columns b
3868: where a.user_column_id = b.user_column_id
3869: );
3870:
3871: --conflict may exist

Line 3874: update /*+NO_INDEX*/ hr_s_user_columns

3870:
3871: --conflict may exist
3872: --update all user_column_id's to remove conflict
3873:
3874: update /*+NO_INDEX*/ hr_s_user_columns
3875: set user_column_id = user_column_id - 50000000;
3876:
3877: update /*+NO_INDEX*/ hr_s_user_column_instances_f
3878: set user_column_id = user_column_id - 50000000;

Line 3894: from hr_s_user_columns;

3890: select min(user_column_id) - (count(*) *3)
3891: , max(user_column_id) + (count(*) *3)
3892: into v_min_delivered
3893: , v_max_delivered
3894: from hr_s_user_columns;
3895:
3896: select pay_user_columns_s.nextval
3897: into v_sequence_number
3898: from dual;

Line 3983: update hr_s_user_columns

3979: END;
3980:
3981: -- Update all child entities
3982:
3983: update hr_s_user_columns
3984: set user_column_id = l_new_surrogate_key
3985: where user_column_id = stu_rec.c_surrogate_key;
3986:
3987: update hr_s_application_ownerships

Line 4005: delete from hr_s_user_columns

4001: -- Remove a row from either the startup tables or the installed tables
4002:
4003: BEGIN
4004:
4005: delete from hr_s_user_columns
4006: where rowid = stu_rec.rowid;
4007:
4008: END remove;
4009: