eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_ALT_LOOKUPS_PKG dependencies on PAY_USER_COLUMNS

Line 25: from pay_user_columns_v c

21: and a.business_group_id = P_BUSINESS_GROUP_ID;
22:
23: cursor csr_column_name (p_user_table_id number) is
24: select c.user_column_id
25: from pay_user_columns_v c
26: where p_user_table_id = c.user_table_id
27: and upper (c.user_column_name) = upper (P_FUNCTION_TYPE)
28: and nvl(c.business_group_id,P_BUSINESS_GROUP_ID) = P_BUSINESS_GROUP_ID
29: and nvl(c.legislation_code,l_legislation_code) = l_legislation_code;

Line 130: pay_user_columns_pkg.insert_row (

126: --
127: open csr_column_name(l_user_table_id);
128: fetch csr_column_name into l_user_column_id;
129: if csr_column_name%notfound then
130: pay_user_columns_pkg.insert_row (
131: P_ROWID => l_column_rowid
132: ,P_USER_COLUMN_ID => l_user_column_id
133: ,P_USER_TABLE_ID => l_user_table_id
134: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID

Line 307: CURSOR Get_pay_user_columns (cp_user_table_id NUMBER,

303: WHERE USER_TABLE_NAME = cp_user_table_name and
304: BUSINESS_GROUP_ID = cn_business_group_id;
305:
306:
307: CURSOR Get_pay_user_columns (cp_user_table_id NUMBER,
308: cn_business_group_id NUMBER) IS
309: SELECT USER_COLUMN_ID
310: FROM PAY_USER_COLUMNS
311: WHERE USER_TABLE_ID = cp_user_table_id and

Line 310: FROM PAY_USER_COLUMNS

306:
307: CURSOR Get_pay_user_columns (cp_user_table_id NUMBER,
308: cn_business_group_id NUMBER) IS
309: SELECT USER_COLUMN_ID
310: FROM PAY_USER_COLUMNS
311: WHERE USER_TABLE_ID = cp_user_table_id and
312: BUSINESS_GROUP_ID = cn_business_group_id;
313:
314:

Line 334: -- Get all the PAY_USER_COLUMNS associated to the user_table_name

330: If (Get_pay_user_tables_id%FOUND) then
331: Begin
332: hr_utility.set_location('perwsalc - Clean_pay_tables', 5);
333: hr_utility.set_location('user_table_id found for ' || cp_user_table_name, 5);
334: -- Get all the PAY_USER_COLUMNS associated to the user_table_name
335: -- For each column, get the Ids of the column instances to delete them
336: OPEN Get_pay_user_columns (ln_user_table_id,cn_business_group_id);
337: Loop
338: FETCH Get_pay_user_columns into ln_user_column_id;

Line 336: OPEN Get_pay_user_columns (ln_user_table_id,cn_business_group_id);

332: hr_utility.set_location('perwsalc - Clean_pay_tables', 5);
333: hr_utility.set_location('user_table_id found for ' || cp_user_table_name, 5);
334: -- Get all the PAY_USER_COLUMNS associated to the user_table_name
335: -- For each column, get the Ids of the column instances to delete them
336: OPEN Get_pay_user_columns (ln_user_table_id,cn_business_group_id);
337: Loop
338: FETCH Get_pay_user_columns into ln_user_column_id;
339: EXIT When Get_pay_user_columns%NOTFOUND;
340: hr_utility.set_location('user_column_id found for ' || to_char(ln_user_column_id), 10);

Line 338: FETCH Get_pay_user_columns into ln_user_column_id;

334: -- Get all the PAY_USER_COLUMNS associated to the user_table_name
335: -- For each column, get the Ids of the column instances to delete them
336: OPEN Get_pay_user_columns (ln_user_table_id,cn_business_group_id);
337: Loop
338: FETCH Get_pay_user_columns into ln_user_column_id;
339: EXIT When Get_pay_user_columns%NOTFOUND;
340: hr_utility.set_location('user_column_id found for ' || to_char(ln_user_column_id), 10);
341: -- Get all the PAY_USER_ROWS_F Columns
342: OPEN Get_pay_user_rows_f (ln_user_table_id,cn_business_group_id);

Line 339: EXIT When Get_pay_user_columns%NOTFOUND;

335: -- For each column, get the Ids of the column instances to delete them
336: OPEN Get_pay_user_columns (ln_user_table_id,cn_business_group_id);
337: Loop
338: FETCH Get_pay_user_columns into ln_user_column_id;
339: EXIT When Get_pay_user_columns%NOTFOUND;
340: hr_utility.set_location('user_column_id found for ' || to_char(ln_user_column_id), 10);
341: -- Get all the PAY_USER_ROWS_F Columns
342: OPEN Get_pay_user_rows_f (ln_user_table_id,cn_business_group_id);
343: Loop

Line 359: CLOSE Get_pay_user_columns;

355: End Loop;
356: CLOSE Get_pay_user_rows_f;
357:
358: End Loop;
359: CLOSE Get_pay_user_columns;
360:
361: hr_utility.set_location('perwsalc - delete pay_user_row, column and table rows' , 20);
362: -- Delete all the PAY_USER_ROW, COLUMNS and TABLE rows
363: DELETE FROM PAY_USER_ROWS_F

Line 367: DELETE FROM PAY_USER_COLUMNS

363: DELETE FROM PAY_USER_ROWS_F
364: WHERE USER_TABLE_ID = ln_user_table_id and
365: BUSINESS_GROUP_ID = cn_business_group_id;
366:
367: DELETE FROM PAY_USER_COLUMNS
368: WHERE USER_TABLE_ID = ln_user_table_id and
369: BUSINESS_GROUP_ID = cn_business_group_id;
370:
371: DELETE FROM PAY_USER_TABLES

Line 389: cp_user_column_name IN pay_user_columns.user_column_name%TYPE ,

385: ------------------------------------------------------------------
386: Procedure Set_instance_value (cn_business_group_id IN per_business_groups.business_group_id%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:

Line 414: cp_user_column_name pay_user_columns.user_column_name%TYPE,

410: and BUSINESS_GROUP_ID = cn_business_group_id;
411:
412:
413: CURSOR Get_column_id (cp_user_table_id NUMBER,
414: cp_user_column_name pay_user_columns.user_column_name%TYPE,
415: cn_business_group_id NUMBER) IS
416: SELECT USER_COLUMN_ID
417: FROM PAY_USER_COLUMNS
418: WHERE USER_TABLE_ID = cp_user_table_id and

Line 417: FROM PAY_USER_COLUMNS

413: CURSOR Get_column_id (cp_user_table_id NUMBER,
414: cp_user_column_name pay_user_columns.user_column_name%TYPE,
415: cn_business_group_id NUMBER) IS
416: SELECT USER_COLUMN_ID
417: FROM PAY_USER_COLUMNS
418: WHERE USER_TABLE_ID = cp_user_table_id and
419: USER_COLUMN_NAME = cp_user_column_name and
420: BUSINESS_GROUP_ID = cn_business_group_id;
421:

Line 536: cp_user_column_name IN pay_user_columns.user_column_name%TYPE ,

532: Procedure Update_Instance_value
533: (cn_business_group_id IN per_business_groups.business_group_id%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: