APPS.PER_PERFRALC_PKG dependencies on PAY_USER_COLUMN_INSTANCES_F

Line 42: from pay_user_column_instances_f a

38: and b.row_low_range_or_name(+) = hl.lookup_code;
39:
40: cursor csr_instance (p_user_row_id number, p_user_column_id number) is
41: select a.user_column_instance_id
42: from pay_user_column_instances_f a
43: where a.user_row_id = p_user_row_id
44: and a.user_column_id = p_user_column_id;
45:
46: cursor csr_max_sequence (p_user_table_id number) is

Line 349: -- PAY_USER_COLUMN_INSTANCES_F (related value for added column)

345: EXIT When Get_pay_user_rows_f%NOTFOUND;
346:
347: hr_utility.set_location('user_rows_f found. to be deleted ' || to_char(ln_pay_user_rows), 15);
348: -- for each pay_user_row found, delete the associated
349: -- PAY_USER_COLUMN_INSTANCES_F (related value for added column)
350: DELETE FROM PAY_USER_COLUMN_INSTANCES_F
351: WHERE USER_ROW_ID = ln_pay_user_rows and
352: USER_COLUMN_ID = ln_user_column_id and
353: BUSINESS_GROUP_ID = cn_business_group_id;

Line 350: DELETE FROM PAY_USER_COLUMN_INSTANCES_F

346:
347: hr_utility.set_location('user_rows_f found. to be deleted ' || to_char(ln_pay_user_rows), 15);
348: -- for each pay_user_row found, delete the associated
349: -- PAY_USER_COLUMN_INSTANCES_F (related value for added column)
350: DELETE FROM PAY_USER_COLUMN_INSTANCES_F
351: WHERE USER_ROW_ID = ln_pay_user_rows and
352: USER_COLUMN_ID = ln_user_column_id and
353: BUSINESS_GROUP_ID = cn_business_group_id;
354:

Line 391: cp_value IN pay_user_column_instances_f.value%TYPE

387: cp_legislation_code IN per_business_groups.legislation_code%TYPE,
388: cp_user_table_name IN pay_user_tables.user_table_name%TYPE ,
389: cp_user_column_name IN pay_user_columns.user_column_name%TYPE ,
390: cp_row_name IN pay_user_rows_f.row_low_range_or_name%TYPE ,
391: cp_value IN pay_user_column_instances_f.value%TYPE
392: ) IS
393:
394:
395: ln_count_column_instance_id NUMBER;

Line 438: FROM PAY_USER_COLUMN_INSTANCES_F

434: CURSOR Get_Column_instance_id (cn_user_row_id NUMBER,
435: cn_user_column_id NUMBER,
436: cn_business_group_id NUMBER) IS
437: SELECT USER_COLUMN_INSTANCE_ID
438: FROM PAY_USER_COLUMN_INSTANCES_F
439: WHERE USER_ROW_ID = cn_user_row_id and
440: USER_COLUMN_ID = cn_user_column_id and
441: BUSINESS_GROUP_ID = cn_business_group_id;
442:

Line 496: hr_utility.set_location(' Update PAY_USER_COLUMN_INSTANCES_F for ' || to_char(ln_column_instance_id),16);

492: if (ln_count_column_instance_id > 1) then
493: hr_utility.set_location('no change to do. More than one instance : ' || cp_row_name, 15);
494: Else
495: Begin
496: hr_utility.set_location(' Update PAY_USER_COLUMN_INSTANCES_F for ' || to_char(ln_column_instance_id),16);
497: UPDATE PAY_USER_COLUMN_INSTANCES_F
498: set value = cp_value
499: where user_column_instance_id = ln_column_instance_id;
500: EXCEPTION

Line 497: UPDATE PAY_USER_COLUMN_INSTANCES_F

493: hr_utility.set_location('no change to do. More than one instance : ' || cp_row_name, 15);
494: Else
495: Begin
496: hr_utility.set_location(' Update PAY_USER_COLUMN_INSTANCES_F for ' || to_char(ln_column_instance_id),16);
497: UPDATE PAY_USER_COLUMN_INSTANCES_F
498: set value = cp_value
499: where user_column_instance_id = ln_column_instance_id;
500: EXCEPTION
501: WHEN OTHERS Then

Line 502: hr_utility.set_location ('perfralc - set_instance_value - unable to update row into PAY_USER_COLUMN_INSTANCES_F '|| to_char(ln_column_instance_id), 20);

498: set value = cp_value
499: where user_column_instance_id = ln_column_instance_id;
500: EXCEPTION
501: WHEN OTHERS Then
502: hr_utility.set_location ('perfralc - set_instance_value - unable to update row into PAY_USER_COLUMN_INSTANCES_F '|| to_char(ln_column_instance_id), 20);
503: End;
504: End if;
505: End;
506: end if;

Line 538: cp_value IN pay_user_column_instances_f.value%TYPE

534: cp_legislation_code IN per_business_groups.legislation_code%TYPE,
535: cp_user_table_name IN pay_user_tables.user_table_name%TYPE ,
536: cp_user_column_name IN pay_user_columns.user_column_name%TYPE ,
537: cp_row_name IN pay_user_rows_f.row_low_range_or_name%TYPE ,
538: cp_value IN pay_user_column_instances_f.value%TYPE
539: ) IS
540:
541: ln_user_table_id NUMBER;
542: ln_user_column_id NUMBER;