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.IGS_PE_PERS_IMP_001 dependencies on FND_LOOKUP_VALUES

Line 1737: FUNCTION validate_lookup_type_code(p_lookup_type IN fnd_lookup_values.lookup_type%TYPE,

1733: END prc_pe_imp_record_sts;
1734:
1735: --< nsidana 9/23/2003 Admissions Import process enhancements : Lookups caching >
1736:
1737: FUNCTION validate_lookup_type_code(p_lookup_type IN fnd_lookup_values.lookup_type%TYPE,
1738: p_lookup_code IN fnd_lookup_values.lookup_type%TYPE,
1739: p_application_id IN NUMBER)
1740: RETURN BOOLEAN IS
1741: /*****************************************************************

Line 1738: p_lookup_code IN fnd_lookup_values.lookup_type%TYPE,

1734:
1735: --< nsidana 9/23/2003 Admissions Import process enhancements : Lookups caching >
1736:
1737: FUNCTION validate_lookup_type_code(p_lookup_type IN fnd_lookup_values.lookup_type%TYPE,
1738: p_lookup_code IN fnd_lookup_values.lookup_type%TYPE,
1739: p_application_id IN NUMBER)
1740: RETURN BOOLEAN IS
1741: /*****************************************************************
1742: Created By : nsidana

Line 1761: CURSOR c_fetch_lkups(cp_lkup_type VARCHAR2,cp_application_id fnd_lookup_values.view_application_id%TYPE,

1757:
1758: -- Cursor to fetch all the lookup codes associated with a lookup type.
1759: -- Will be used to cache the lookups.
1760:
1761: CURSOR c_fetch_lkups(cp_lkup_type VARCHAR2,cp_application_id fnd_lookup_values.view_application_id%TYPE,
1762: cp_security_group_id fnd_lookup_values.security_group_id%TYPE)
1763: IS
1764: SELECT lookup_type,lookup_code
1765: FROM fnd_lookup_values

Line 1762: cp_security_group_id fnd_lookup_values.security_group_id%TYPE)

1758: -- Cursor to fetch all the lookup codes associated with a lookup type.
1759: -- Will be used to cache the lookups.
1760:
1761: CURSOR c_fetch_lkups(cp_lkup_type VARCHAR2,cp_application_id fnd_lookup_values.view_application_id%TYPE,
1762: cp_security_group_id fnd_lookup_values.security_group_id%TYPE)
1763: IS
1764: SELECT lookup_type,lookup_code
1765: FROM fnd_lookup_values
1766: WHERE lookup_type = cp_lkup_type AND

Line 1765: FROM fnd_lookup_values

1761: CURSOR c_fetch_lkups(cp_lkup_type VARCHAR2,cp_application_id fnd_lookup_values.view_application_id%TYPE,
1762: cp_security_group_id fnd_lookup_values.security_group_id%TYPE)
1763: IS
1764: SELECT lookup_type,lookup_code
1765: FROM fnd_lookup_values
1766: WHERE lookup_type = cp_lkup_type AND
1767: view_application_id = cp_application_id AND
1768: security_group_id = cp_security_group_id AND
1769: language = userenv('LANG') AND

Line 1772: CURSOR c_validate_lkup_code(cp_lkup_type VARCHAR2, cp_lkup_code VARCHAR2, cp_application_id fnd_lookup_values.view_application_id%TYPE,

1768: security_group_id = cp_security_group_id AND
1769: language = userenv('LANG') AND
1770: enabled_flag = 'Y';
1771:
1772: CURSOR c_validate_lkup_code(cp_lkup_type VARCHAR2, cp_lkup_code VARCHAR2, cp_application_id fnd_lookup_values.view_application_id%TYPE,
1773: cp_security_group_id fnd_lookup_values.security_group_id%TYPE)
1774: IS
1775: SELECT 'X'
1776: FROM fnd_lookup_values

Line 1773: cp_security_group_id fnd_lookup_values.security_group_id%TYPE)

1769: language = userenv('LANG') AND
1770: enabled_flag = 'Y';
1771:
1772: CURSOR c_validate_lkup_code(cp_lkup_type VARCHAR2, cp_lkup_code VARCHAR2, cp_application_id fnd_lookup_values.view_application_id%TYPE,
1773: cp_security_group_id fnd_lookup_values.security_group_id%TYPE)
1774: IS
1775: SELECT 'X'
1776: FROM fnd_lookup_values
1777: WHERE lookup_type = cp_lkup_type AND

Line 1776: FROM fnd_lookup_values

1772: CURSOR c_validate_lkup_code(cp_lkup_type VARCHAR2, cp_lkup_code VARCHAR2, cp_application_id fnd_lookup_values.view_application_id%TYPE,
1773: cp_security_group_id fnd_lookup_values.security_group_id%TYPE)
1774: IS
1775: SELECT 'X'
1776: FROM fnd_lookup_values
1777: WHERE lookup_type = cp_lkup_type AND
1778: lookup_code = cp_lkup_code AND
1779: view_application_id = cp_application_id AND
1780: security_group_id = cp_security_group_id AND