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 FND_LOOKUP_TYPES_VL

Line 725: l_lookup_type fnd_lookup_types_vl.lookup_type%TYPE;

721: l_abs_ele_correction_pp NUMBER := p_abs_ele_processing_priority - 50;
722: l_pay_ele_correction_pp NUMBER := p_pay_ele_processing_priority - 50;
723: l_formula_name pay_shadow_formulas.formula_name%TYPE;
724: l_formula_id NUMBER;
725: l_lookup_type fnd_lookup_types_vl.lookup_type%TYPE;
726: l_lookup_meaning fnd_lookup_types_vl.meaning%TYPE;
727: l_exists VARCHAR2(1);
728: l_display_sequence NUMBER;
729: l_base_name pay_element_templates.base_name%TYPE

Line 726: l_lookup_meaning fnd_lookup_types_vl.meaning%TYPE;

722: l_pay_ele_correction_pp NUMBER := p_pay_ele_processing_priority - 50;
723: l_formula_name pay_shadow_formulas.formula_name%TYPE;
724: l_formula_id NUMBER;
725: l_lookup_type fnd_lookup_types_vl.lookup_type%TYPE;
726: l_lookup_meaning fnd_lookup_types_vl.meaning%TYPE;
727: l_exists VARCHAR2(1);
728: l_display_sequence NUMBER;
729: l_base_name pay_element_templates.base_name%TYPE
730: := UPPER(TRANSLATE(TRIM(p_abs_ele_name),' ','_'));

Line 1530: FROM fnd_lookup_types_vl

1526:
1527: CURSOR csr_chk_uniq_type
1528: IS
1529: SELECT 'X'
1530: FROM fnd_lookup_types_vl
1531: WHERE lookup_type = p_lookup_type
1532: AND security_group_id = p_security_group_id
1533: AND view_application_id = 3;
1534:

Line 1538: FROM fnd_lookup_types_vl

1534:
1535: CURSOR csr_chk_uniq_meaning
1536: IS
1537: SELECT 'X'
1538: FROM fnd_lookup_types_vl
1539: WHERE meaning = p_lookup_meaning
1540: AND security_group_id = p_security_group_id
1541: AND view_application_id = 3;
1542:

Line 1546: l_rowid fnd_lookup_types_vl.row_id%type;

1542:
1543: l_proc_step NUMBER(20,10);
1544: l_proc_name VARCHAR2(72) := g_package_name || 'create_lookup';
1545: l_exists VARCHAR2(1);
1546: l_rowid fnd_lookup_types_vl.row_id%type;
1547: l_user_id number := fnd_global.user_id;
1548: l_login_id number := fnd_global.login_id;
1549:
1550: --

Line 1690: FROM fnd_lookup_types_vl

1686:
1687: CURSOR csr_chk_uniq_type
1688: IS
1689: SELECT 'X'
1690: FROM fnd_lookup_types_vl
1691: WHERE lookup_type = p_lookup_type
1692: AND security_group_id = p_security_group_id
1693: AND view_application_id = 3;
1694:

Line 1698: FROM fnd_lookup_types_vl

1694:
1695: CURSOR csr_chk_uniq_meaning
1696: IS
1697: SELECT 'X'
1698: FROM fnd_lookup_types_vl
1699: WHERE meaning = p_lookup_meaning
1700: AND security_group_id = p_security_group_id
1701: AND view_application_id = 3;
1702:

Line 1706: l_rowid fnd_lookup_types_vl.row_id%type;

1702:
1703: l_proc_step NUMBER(20,10);
1704: l_proc_name VARCHAR2(72) := g_package_name || 'create_plan_lookup';
1705: l_exists VARCHAR2(1);
1706: l_rowid fnd_lookup_types_vl.row_id%type;
1707: l_user_id number := fnd_global.user_id;
1708: l_login_id number := fnd_global.login_id;
1709:
1710: --

Line 3235: l_lookup_type fnd_lookup_types_vl.lookup_type%TYPE;

3231: l_eei_info_id number;
3232: l_ovn_eei number;
3233: l_entudt_id pay_user_tables.user_table_id%TYPE;
3234: l_caludt_id pay_user_tables.user_table_id%TYPE;
3235: l_lookup_type fnd_lookup_types_vl.lookup_type%TYPE;
3236: -- to delete plan types lookup
3237: l_plan_type_lookup fnd_lookup_types_vl.lookup_type%TYPE;
3238:
3239: l_lookup_code fnd_lookup_values_vl.lookup_code%TYPE;

Line 3237: l_plan_type_lookup fnd_lookup_types_vl.lookup_type%TYPE;

3233: l_entudt_id pay_user_tables.user_table_id%TYPE;
3234: l_caludt_id pay_user_tables.user_table_id%TYPE;
3235: l_lookup_type fnd_lookup_types_vl.lookup_type%TYPE;
3236: -- to delete plan types lookup
3237: l_plan_type_lookup fnd_lookup_types_vl.lookup_type%TYPE;
3238:
3239: l_lookup_code fnd_lookup_values_vl.lookup_code%TYPE;
3240: l_exists VARCHAR2(1);
3241: l_element_type_id pay_element_types_f.element_type_id%TYPE;

Line 3415: l_lookup_type fnd_lookup_types_vl.lookup_type%TYPE;

3411:
3412: l_lookup_collection t_number;
3413: l_number NUMBER;
3414: l_lookup_code fnd_lookup_values_vl.lookup_code%TYPE;
3415: l_lookup_type fnd_lookup_types_vl.lookup_type%TYPE;
3416: l_proc_step NUMBER(20,10);
3417: l_proc_name VARCHAR2(72) := g_package_name || 'get_other_lookups';
3418: l_base_name pay_element_templates.base_name%TYPE ;
3419:

Line 3507: FROM fnd_lookup_types_vl

3503:
3504: CURSOR csr_get_lkt_info
3505: IS
3506: SELECT 'X'
3507: FROM fnd_lookup_types_vl
3508: WHERE lookup_type = p_lookup_type
3509: AND security_group_id = p_security_group_id
3510: AND view_application_id = p_view_application_id;
3511:

Line 4127: FROM fnd_lookup_types_vl

4123:
4124: CURSOR csr_chk_uniq_type
4125: IS
4126: SELECT 'X'
4127: FROM fnd_lookup_types_vl
4128: WHERE lookup_type = p_lookup_type
4129: AND security_group_id = p_security_group_id
4130: AND view_application_id = 3;
4131:

Line 4135: FROM fnd_lookup_types_vl

4131:
4132: CURSOR csr_chk_uniq_meaning
4133: IS
4134: SELECT 'X'
4135: FROM fnd_lookup_types_vl
4136: WHERE meaning = p_lookup_meaning
4137: AND security_group_id = p_security_group_id
4138: AND view_application_id = 3;
4139:

Line 4161: l_rowid fnd_lookup_types_vl.row_id%type;

4157:
4158: l_proc_step NUMBER(20,10);
4159: l_proc_name VARCHAR2(72) := g_package_name || 'create_gap_lookup';
4160: l_exists VARCHAR2(1);
4161: l_rowid fnd_lookup_types_vl.row_id%type;
4162: l_user_id number := fnd_global.user_id;
4163: l_login_id number := fnd_global.login_id;
4164: i number ;
4165: --