APPS.HR_LEGISLATION_ELEMENTS dependencies on HR_S_USER_COLUMNS

Line 3390: update /*+NO_INDEX*/ hr_s_user_columns

3386:
3387: --conflict may exist
3388: --update all user_table_id's to remove conflict
3389:
3390: update /*+NO_INDEX*/ hr_s_user_columns
3391: set user_table_id = user_table_id - 50000000;
3392:
3393: update /*+NO_INDEX*/ hr_s_user_rows_f
3394: set user_table_id = user_table_id - 50000000;

Line 3504: update hr_s_user_columns

3500: set key_value = to_char(l_new_surrogate_key)
3501: where key_value = to_char(stu_rec.c_surrogate_key)
3502: and key_name = 'USER_TABLE_ID';
3503:
3504: update hr_s_user_columns
3505: set user_table_id = l_new_surrogate_key
3506: where user_table_id = stu_rec.c_surrogate_key;
3507:
3508: update hr_s_user_rows_f

Line 3858: from hr_s_user_columns;

3854: , last_update_login
3855: , created_by
3856: , creation_date
3857: , rowid
3858: from hr_s_user_columns;
3859:
3860: stu_rec stu%ROWTYPE;
3861:
3862:

Line 3899: from hr_s_user_columns b

3895: into l_null_return
3896: from pay_user_columns a
3897: where exists
3898: (select null
3899: from hr_s_user_columns b
3900: where a.user_column_id = b.user_column_id
3901: );
3902:
3903: --conflict may exist

Line 3906: update /*+NO_INDEX*/ hr_s_user_columns

3902:
3903: --conflict may exist
3904: --update all user_column_id's to remove conflict
3905:
3906: update /*+NO_INDEX*/ hr_s_user_columns
3907: set user_column_id = user_column_id - 50000000;
3908:
3909: update /*+NO_INDEX*/ hr_s_user_column_instances_f
3910: set user_column_id = user_column_id - 50000000;

Line 3926: from hr_s_user_columns;

3922: select min(user_column_id) - (count(*) *3)
3923: , max(user_column_id) + (count(*) *3)
3924: into v_min_delivered
3925: , v_max_delivered
3926: from hr_s_user_columns;
3927:
3928: select pay_user_columns_s.nextval
3929: into v_sequence_number
3930: from dual;

Line 4015: update hr_s_user_columns

4011: END;
4012:
4013: -- Update all child entities
4014:
4015: update hr_s_user_columns
4016: set user_column_id = l_new_surrogate_key
4017: where user_column_id = stu_rec.c_surrogate_key;
4018:
4019: update hr_s_application_ownerships

Line 4037: delete from hr_s_user_columns

4033: -- Remove a row from either the startup tables or the installed tables
4034:
4035: BEGIN
4036:
4037: delete from hr_s_user_columns
4038: where rowid = stu_rec.rowid;
4039:
4040: END remove;
4041: