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_PERFRALC_PKG dependencies on PAY_USER_TABLES

Line 19: from pay_user_tables_v a

15: l_legislation_code per_business_groups.legislation_code%type;
16: --
17: cursor csr_table_name is
18: select a.user_table_id
19: from pay_user_tables_v a
20: where upper (a.user_table_name) = upper (P_LOOKUP_TYPE)
21: and a.business_group_id = P_BUSINESS_GROUP_ID;
22:
23: cursor csr_column_name (p_user_table_id number) is

Line 106: pay_user_tables_pkg.insert_row (

102: open csr_table_name;
103: fetch csr_table_name into l_user_table_id;
104: --
105: if csr_table_name%notfound then
106: pay_user_tables_pkg.insert_row (
107: P_ROWID => l_table_rowid
108: ,P_USER_TABLE_ID => l_user_table_id
109: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
110: ,P_LEGISLATION_CODE => l_legislation_code

Line 285: cp_user_table_name IN pay_user_tables.user_table_name%TYPE) IS

281: -- |---------------- Clean_pay_tables -------------------------------| -
282: ---------------------------------------------------------------------------
283: procedure clean_pay_tables
284: (cn_business_group_id IN per_business_groups.business_group_id%TYPE,
285: cp_user_table_name IN pay_user_tables.user_table_name%TYPE) IS
286:
287:
288: ln_row_count number := 1;
289: ln_user_table_id number;

Line 299: CURSOR Get_pay_user_tables_id (cp_user_table_name CHAR,

295: --
296: -- Local Cursor Definition
297: --
298:
299: CURSOR Get_pay_user_tables_id (cp_user_table_name CHAR,
300: cn_business_group_id NUMBER) IS
301: SELECT USER_TABLE_ID
302: FROM PAY_USER_TABLES
303: WHERE USER_TABLE_NAME = cp_user_table_name and

Line 302: FROM PAY_USER_TABLES

298:
299: CURSOR Get_pay_user_tables_id (cp_user_table_name CHAR,
300: cn_business_group_id NUMBER) IS
301: SELECT USER_TABLE_ID
302: FROM PAY_USER_TABLES
303: WHERE USER_TABLE_NAME = cp_user_table_name and
304: BUSINESS_GROUP_ID = cn_business_group_id;
305:
306:

Line 324: -- Clean all the PAY_USER tables for one specific (lookup) table

320: BUSINESS_GROUP_ID = cn_business_group_id;
321:
322: begin
323: hr_utility.set_location('perfralc - Clean_pay_tables ', 1);
324: -- Clean all the PAY_USER tables for one specific (lookup) table
325: --
326: --
327: -- Get first the user_table_id associated to the given user_table_name
328: OPEN Get_pay_user_tables_id (cp_user_table_name,cn_business_group_id);

Line 328: OPEN Get_pay_user_tables_id (cp_user_table_name,cn_business_group_id);

324: -- Clean all the PAY_USER tables for one specific (lookup) table
325: --
326: --
327: -- Get first the user_table_id associated to the given user_table_name
328: OPEN Get_pay_user_tables_id (cp_user_table_name,cn_business_group_id);
329: FETCH Get_pay_user_tables_id into ln_user_table_id;
330: If (Get_pay_user_tables_id%FOUND) then
331: Begin
332: hr_utility.set_location('perfralc - Clean_pay_tables', 5);

Line 329: FETCH Get_pay_user_tables_id into ln_user_table_id;

325: --
326: --
327: -- Get first the user_table_id associated to the given user_table_name
328: OPEN Get_pay_user_tables_id (cp_user_table_name,cn_business_group_id);
329: FETCH Get_pay_user_tables_id into ln_user_table_id;
330: If (Get_pay_user_tables_id%FOUND) then
331: Begin
332: hr_utility.set_location('perfralc - Clean_pay_tables', 5);
333: hr_utility.set_location('user_table_id found for ' || cp_user_table_name, 5);

Line 330: If (Get_pay_user_tables_id%FOUND) then

326: --
327: -- Get first the user_table_id associated to the given user_table_name
328: OPEN Get_pay_user_tables_id (cp_user_table_name,cn_business_group_id);
329: FETCH Get_pay_user_tables_id into ln_user_table_id;
330: If (Get_pay_user_tables_id%FOUND) then
331: Begin
332: hr_utility.set_location('perfralc - 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

Line 371: DELETE FROM PAY_USER_TABLES

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
372: WHERE USER_TABLE_ID = ln_user_table_id and
373: BUSINESS_GROUP_ID = cn_business_group_id;
374: end;
375: end if;

Line 376: CLOSE Get_pay_user_tables_id;

372: WHERE USER_TABLE_ID = ln_user_table_id and
373: BUSINESS_GROUP_ID = cn_business_group_id;
374: end;
375: end if;
376: CLOSE Get_pay_user_tables_id;
377: hr_utility.set_location('perfralc - End Clean_pay_tables', 50);
378: end;
379:
380:

Line 388: cp_user_table_name IN pay_user_tables.user_table_name%TYPE ,

384: -- ----- set_instance_value ------------------------------------|
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

Line 405: CURSOR Get_pay_user_tables_id (cp_user_table_name CHAR,

401:
402: --
403: -- Local Cursor Definition
404:
405: CURSOR Get_pay_user_tables_id (cp_user_table_name CHAR,
406: cn_business_group_id NUMBER) IS
407: SELECT USER_TABLE_ID
408: FROM PAY_USER_TABLES
409: WHERE USER_TABLE_NAME = cp_user_table_name

Line 408: FROM PAY_USER_TABLES

404:
405: CURSOR Get_pay_user_tables_id (cp_user_table_name CHAR,
406: cn_business_group_id NUMBER) IS
407: SELECT USER_TABLE_ID
408: FROM PAY_USER_TABLES
409: WHERE USER_TABLE_NAME = cp_user_table_name
410: and BUSINESS_GROUP_ID = cn_business_group_id;
411:
412:

Line 449: OPEN Get_pay_user_tables_id (cp_user_table_name,cn_business_group_id);

445: Begin
446: -- First, Get the table_id
447: --
448: hr_utility.set_location('perfralc - set_instance_value - Entering',1);
449: OPEN Get_pay_user_tables_id (cp_user_table_name,cn_business_group_id);
450: FETCH Get_pay_user_tables_id into ln_user_table_id;
451: if (Get_pay_user_tables_id%NOTFOUND) Then
452: hr_utility.set_location('perfralc - set_instance_value - unknown table_name : ' || cp_user_table_name, 5);
453: Else

Line 450: FETCH Get_pay_user_tables_id into ln_user_table_id;

446: -- First, Get the table_id
447: --
448: hr_utility.set_location('perfralc - set_instance_value - Entering',1);
449: OPEN Get_pay_user_tables_id (cp_user_table_name,cn_business_group_id);
450: FETCH Get_pay_user_tables_id into ln_user_table_id;
451: if (Get_pay_user_tables_id%NOTFOUND) Then
452: hr_utility.set_location('perfralc - set_instance_value - unknown table_name : ' || cp_user_table_name, 5);
453: Else
454: hr_utility.set_location(' --> table_id = ' || to_char(ln_user_table_id),2);

Line 451: if (Get_pay_user_tables_id%NOTFOUND) Then

447: --
448: hr_utility.set_location('perfralc - set_instance_value - Entering',1);
449: OPEN Get_pay_user_tables_id (cp_user_table_name,cn_business_group_id);
450: FETCH Get_pay_user_tables_id into ln_user_table_id;
451: if (Get_pay_user_tables_id%NOTFOUND) Then
452: hr_utility.set_location('perfralc - set_instance_value - unknown table_name : ' || cp_user_table_name, 5);
453: Else
454: hr_utility.set_location(' --> table_id = ' || to_char(ln_user_table_id),2);
455: -- Get the column id

Line 512: CLOSE Get_pay_user_tables_id;

508: CLOSE Get_row_id;
509: End if;
510: CLOSE Get_column_id;
511: End if;
512: CLOSE Get_pay_user_tables_id;
513:
514: hr_utility.set_location('perfralc - Set_instance_value - Leaving',30);
515:
516: End;

Line 535: cp_user_table_name IN pay_user_tables.user_table_name%TYPE ,

531:
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