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_COLUMNS

Line 125: FROM pay_user_columns ucol

121: ,p_bg_id
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

Line 786: (user_column_name pay_user_columns.user_column_name%TYPE

782:
783: l_udt_type r_udt_type;
784:
785: TYPE r_udt_cols_type IS RECORD
786: (user_column_name pay_user_columns.user_column_name%TYPE
787: ,formula_id pay_user_columns.formula_id%TYPE
788: ,business_group_id pay_user_columns.business_group_id%TYPE
789: ,legislation_code pay_user_columns.legislation_code%TYPE
790: );

Line 787: ,formula_id pay_user_columns.formula_id%TYPE

783: l_udt_type r_udt_type;
784:
785: TYPE r_udt_cols_type IS RECORD
786: (user_column_name pay_user_columns.user_column_name%TYPE
787: ,formula_id pay_user_columns.formula_id%TYPE
788: ,business_group_id pay_user_columns.business_group_id%TYPE
789: ,legislation_code pay_user_columns.legislation_code%TYPE
790: );
791:

Line 788: ,business_group_id pay_user_columns.business_group_id%TYPE

784:
785: TYPE r_udt_cols_type IS RECORD
786: (user_column_name pay_user_columns.user_column_name%TYPE
787: ,formula_id pay_user_columns.formula_id%TYPE
788: ,business_group_id pay_user_columns.business_group_id%TYPE
789: ,legislation_code pay_user_columns.legislation_code%TYPE
790: );
791:
792: TYPE t_udt_cols IS TABLE OF r_udt_cols_type

Line 789: ,legislation_code pay_user_columns.legislation_code%TYPE

785: TYPE r_udt_cols_type IS RECORD
786: (user_column_name pay_user_columns.user_column_name%TYPE
787: ,formula_id pay_user_columns.formula_id%TYPE
788: ,business_group_id pay_user_columns.business_group_id%TYPE
789: ,legislation_code pay_user_columns.legislation_code%TYPE
790: );
791:
792: TYPE t_udt_cols IS TABLE OF r_udt_cols_type
793: INDEX BY BINARY_INTEGER;

Line 1231: l_udt_col_name pay_user_columns.user_column_name%TYPE;

1227: ORDER BY lookup_code;
1228:
1229: l_proc_step NUMBER(20,10);
1230: l_proc_name VARCHAR2(72) := g_package_name || 'get_udt_col_info';
1231: l_udt_col_name pay_user_columns.user_column_name%TYPE;
1232: l_udt_cols t_udt_cols;
1233: i number;
1234:
1235: --

Line 1390: l_user_column_id pay_user_columns.user_column_id%TYPE;

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;
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;

Line 1437: pay_user_columns_pkg.insert_row

1433:
1434: WHILE i IS NOT NULL
1435: LOOP
1436:
1437: pay_user_columns_pkg.insert_row
1438: (p_rowid => l_udt_cols_rowid
1439: ,p_user_column_id => l_user_column_id
1440: ,p_user_table_id => l_user_table_id
1441: ,p_business_group_id => p_udt_cols(i).business_group_id

Line 2676: FROM pay_user_columns ucol

2672: ,p_bg_id
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

Line 2707: FROM pay_user_columns ucol

2703: ,p_bg_id
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

Line 2739: FROM pay_user_columns ucol

2735: ,p_bg_id
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

Line 2771: FROM pay_user_columns ucol

2767: ,p_bg_id
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

Line 3637: FROM pay_user_columns

3633:
3634: CURSOR csr_get_usr_col_id
3635: IS
3636: SELECT user_column_id
3637: FROM pay_user_columns
3638: WHERE user_table_id = p_udt_id;
3639:
3640: CURSOR csr_get_usr_row_id
3641: IS

Line 3651: l_usr_col_id pay_user_columns.user_column_id%TYPE;

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

Line 3666: -- Get user_column_id from pay_user_columns

3662: FETCH csr_get_usr_table_id INTO l_rowid;
3663:
3664: IF csr_get_usr_table_id%FOUND THEN
3665:
3666: -- Get user_column_id from pay_user_columns
3667: l_proc_step := 20;
3668: IF g_debug THEN
3669: debug(l_proc_name, l_proc_step);
3670: END IF;

Line 3691: -- Delete pay_user_columns for this table_id

3687:
3688: END LOOP;
3689: CLOSE csr_get_usr_col_id;
3690:
3691: -- Delete pay_user_columns for this table_id
3692: l_proc_step := 40;
3693: IF g_debug THEN
3694: debug(l_proc_name, l_proc_step);
3695: END IF;

Line 3698: DELETE pay_user_columns

3694: debug(l_proc_name, l_proc_step);
3695: END IF;
3696:
3697:
3698: DELETE pay_user_columns
3699: WHERE user_table_id = p_udt_id;
3700:
3701: OPEN csr_get_usr_row_id;
3702: LOOP