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.PQP_GB_OSP_TEMPLATE dependencies on PAY_USER_ROWS

Line 126: ,pay_user_rows_f urws

122: ,NULL
123: ,NULL
124: ,p_entit -- -999999 -999999 Band1
125: FROM pay_user_columns ucol
126: ,pay_user_rows_f urws
127: WHERE ucol.user_table_id = p_user_tbl_id --fnd_number.canonical_to_number(l_eei_information9)
128: AND ucol.user_column_name = p_band -- bad bad refer 'PQP_GAP_ENTITLEMENT_BANDS'.'BAND1'
129: AND urws.user_table_id = ucol.user_table_id
130: AND urws.row_low_range_or_name = p_lower -- bad bad refer lookup code 'PQP_GAP_ENTITLEMENT_ROWS'.'GB_GAP_PERCENTAGE_ROW'

Line 798: (row_low_range_or_name pay_user_rows_f.row_low_range_or_name%TYPE

794:
795: l_udt_cols t_udt_cols;
796:
797: TYPE r_udt_rows_type IS RECORD
798: (row_low_range_or_name pay_user_rows_f.row_low_range_or_name%TYPE
799: ,display_sequence pay_user_rows_f.display_sequence%TYPE
800: ,row_high_range pay_user_rows_f.row_high_range%TYPE
801: ,business_group_id pay_user_rows.business_group_id%TYPE
802: ,legislation_code pay_user_rows.legislation_code%TYPE

Line 799: ,display_sequence pay_user_rows_f.display_sequence%TYPE

795: l_udt_cols t_udt_cols;
796:
797: TYPE r_udt_rows_type IS RECORD
798: (row_low_range_or_name pay_user_rows_f.row_low_range_or_name%TYPE
799: ,display_sequence pay_user_rows_f.display_sequence%TYPE
800: ,row_high_range pay_user_rows_f.row_high_range%TYPE
801: ,business_group_id pay_user_rows.business_group_id%TYPE
802: ,legislation_code pay_user_rows.legislation_code%TYPE
803: );

Line 800: ,row_high_range pay_user_rows_f.row_high_range%TYPE

796:
797: TYPE r_udt_rows_type IS RECORD
798: (row_low_range_or_name pay_user_rows_f.row_low_range_or_name%TYPE
799: ,display_sequence pay_user_rows_f.display_sequence%TYPE
800: ,row_high_range pay_user_rows_f.row_high_range%TYPE
801: ,business_group_id pay_user_rows.business_group_id%TYPE
802: ,legislation_code pay_user_rows.legislation_code%TYPE
803: );
804:

Line 801: ,business_group_id pay_user_rows.business_group_id%TYPE

797: TYPE r_udt_rows_type IS RECORD
798: (row_low_range_or_name pay_user_rows_f.row_low_range_or_name%TYPE
799: ,display_sequence pay_user_rows_f.display_sequence%TYPE
800: ,row_high_range pay_user_rows_f.row_high_range%TYPE
801: ,business_group_id pay_user_rows.business_group_id%TYPE
802: ,legislation_code pay_user_rows.legislation_code%TYPE
803: );
804:
805: TYPE t_udt_rows IS TABLE OF r_udt_rows_type

Line 802: ,legislation_code pay_user_rows.legislation_code%TYPE

798: (row_low_range_or_name pay_user_rows_f.row_low_range_or_name%TYPE
799: ,display_sequence pay_user_rows_f.display_sequence%TYPE
800: ,row_high_range pay_user_rows_f.row_high_range%TYPE
801: ,business_group_id pay_user_rows.business_group_id%TYPE
802: ,legislation_code pay_user_rows.legislation_code%TYPE
803: );
804:
805: TYPE t_udt_rows IS TABLE OF r_udt_rows_type
806: INDEX BY BINARY_INTEGER;

Line 1299: l_udt_row_name pay_user_rows_f.row_low_range_or_name%TYPE;

1295: AND enabled_flag = 'Y'
1296: ORDER BY lookup_code;
1297:
1298: l_proc_name VARCHAR2(72) := g_package_name || 'get_udt_row_info';
1299: l_udt_row_name pay_user_rows_f.row_low_range_or_name%TYPE;
1300: l_udt_rows t_udt_rows;
1301: -- Nocopy changes
1302: l_udt_rows_nc t_udt_rows;
1303: l_display_seq_nc NUMBER;

Line 1385: SELECT pay_user_rows_s.NEXTVAL

1381: --
1382:
1383: CURSOR csr_get_next_udt_row_seq
1384: IS
1385: SELECT pay_user_rows_s.NEXTVAL
1386: FROM dual;
1387:
1388: l_proc_name VARCHAR2(72) := g_package_name || 'create_udt';
1389: l_user_table_id pay_user_tables.user_table_id%TYPE;

Line 1391: l_user_row_id pay_user_rows_f.user_row_id%TYPE;

1387:
1388: l_proc_name VARCHAR2(72) := g_package_name || 'create_udt';
1389: l_user_table_id pay_user_tables.user_table_id%TYPE;
1390: l_user_column_id pay_user_columns.user_column_id%TYPE;
1391: l_user_row_id pay_user_rows_f.user_row_id%TYPE;
1392: l_udt_rowid rowid ;
1393: l_udt_cols_rowid rowid;
1394: l_udt_rows_rowid rowid;
1395:

Line 1471: pay_user_rows_pkg.pre_insert

1467: OPEN csr_get_next_udt_row_seq;
1468: FETCH csr_get_next_udt_row_seq INTO l_user_row_id;
1469: CLOSE csr_get_next_udt_row_seq;
1470:
1471: pay_user_rows_pkg.pre_insert
1472: (p_rowid => l_udt_rows_rowid
1473: ,p_user_table_id => l_user_table_id
1474: ,p_row_low_range_or_name => p_udt_rows(i).row_low_range_or_name
1475: ,p_user_row_id => l_user_row_id

Line 1479: INSERT INTO pay_user_rows_f

1475: ,p_user_row_id => l_user_row_id
1476: ,p_business_group_id => p_bg_id
1477: );
1478:
1479: INSERT INTO pay_user_rows_f
1480: (user_row_id
1481: ,effective_start_date
1482: ,effective_end_date
1483: ,business_group_id

Line 2677: ,pay_user_rows_f urws

2673: ,NULL
2674: ,NULL
2675: ,'100' -- -999999 -999999 Band1
2676: FROM pay_user_columns ucol
2677: ,pay_user_rows_f urws
2678: WHERE ucol.user_table_id = fnd_number.canonical_to_number(l_eei_information9)
2679: AND ucol.user_column_name = 'Band1' -- bad bad refer 'PQP_GAP_ENTITLEMENT_BANDS'.'BAND1'
2680: AND urws.user_table_id = ucol.user_table_id
2681: AND urws.row_low_range_or_name = '-999999' -- bad bad refer lookup code 'PQP_GAP_ENTITLEMENT_ROWS'.'GB_GAP_PERCENTAGE_ROW'

Line 2708: ,pay_user_rows_f urws

2704: ,NULL
2705: ,NULL
2706: ,'50' -- -999999 -999999 Band2
2707: FROM pay_user_columns ucol
2708: ,pay_user_rows_f urws
2709: WHERE ucol.user_table_id = fnd_number.canonical_to_number(l_eei_information9)
2710: AND ucol.user_column_name = 'Band2' -- bad bad refer 'PQP_GAP_ENTITLEMENT_BANDS'.'BAND1'
2711: AND urws.user_table_id = ucol.user_table_id
2712: AND urws.row_low_range_or_name = '-999999' -- bad bad refer lookup code 'PQP_GAP_ENTITLEMENT_ROWS'.'GB_GAP_PERCENTAGE_ROW'

Line 2740: ,pay_user_rows_f urws

2736: ,NULL
2737: ,NULL
2738: ,'182' -- 0 999999 Band1
2739: FROM pay_user_columns ucol
2740: ,pay_user_rows_f urws
2741: WHERE ucol.user_table_id = fnd_number.canonical_to_number(l_eei_information9)
2742: AND ucol.user_column_name = 'Band1' -- bad bad refer 'PQP_GAP_ENTITLEMENT_BANDS'.'BAND1'
2743: AND urws.user_table_id = ucol.user_table_id
2744: AND urws.row_low_range_or_name = '0' -- bad bad refer lookup code 'PQP_GAP_ENTITLEMENT_ROWS'.'GB_GAP_PERCENTAGE_ROW'

Line 2772: ,pay_user_rows_f urws

2768: ,NULL
2769: ,NULL
2770: ,'183' -- 0 999999 Band2
2771: FROM pay_user_columns ucol
2772: ,pay_user_rows_f urws
2773: WHERE ucol.user_table_id = fnd_number.canonical_to_number(l_eei_information9)
2774: AND ucol.user_column_name = 'Band2' -- bad bad refer 'PQP_GAP_ENTITLEMENT_BANDS'.'BAND1'
2775: AND urws.user_table_id = ucol.user_table_id
2776: AND urws.row_low_range_or_name = '0' -- bad bad refer a variable set in prev section when creating this row

Line 3643: FROM pay_user_rows_f

3639:
3640: CURSOR csr_get_usr_row_id
3641: IS
3642: SELECT user_row_id
3643: FROM pay_user_rows_f
3644: WHERE user_table_id = p_udt_id;
3645:
3646: --
3647: l_proc_step NUMBER(20,10);

Line 3650: l_usr_row_id pay_user_rows.user_row_id%TYPE;

3646: --
3647: l_proc_step NUMBER(20,10);
3648: l_proc_name VARCHAR(72) := g_package_name || 'delete_udt';
3649: l_rowid rowid;
3650: l_usr_row_id pay_user_rows.user_row_id%TYPE;
3651: l_usr_col_id pay_user_columns.user_column_id%TYPE;
3652: --
3653: --
3654: BEGIN

Line 3706: -- Delete pay_user_rows_f for this table id

3702: LOOP
3703: FETCH csr_get_usr_row_id INTO l_usr_row_id;
3704: EXIT WHEN csr_get_usr_row_id%NOTFOUND;
3705:
3706: -- Delete pay_user_rows_f for this table id
3707: l_proc_step := 50;
3708: IF g_debug THEN
3709: debug(l_proc_name, l_proc_step);
3710: END IF;

Line 3713: pay_user_rows_pkg.check_delete_row

3709: debug(l_proc_name, l_proc_step);
3710: END IF;
3711:
3712:
3713: pay_user_rows_pkg.check_delete_row
3714: (p_user_row_id => l_usr_row_id
3715: ,p_validation_start_date => NULL
3716: ,p_dt_delete_mode => 'ZAP'
3717: );

Line 3719: DELETE pay_user_rows_f

3715: ,p_validation_start_date => NULL
3716: ,p_dt_delete_mode => 'ZAP'
3717: );
3718:
3719: DELETE pay_user_rows_f
3720: WHERE user_row_id = l_usr_row_id;
3721:
3722: END LOOP;
3723: CLOSE csr_get_usr_row_id;