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_SS_ENR_DETAILS dependencies on IGS_LOOKUP_VALUES

Line 4: g_tba_desc CONSTANT igs_lookup_values.meaning%TYPE := get_meaning('SCHEDULE_TYPE', 'TBA');

1: PACKAGE BODY igs_ss_enr_details AS
2: /* $Header: IGSSS05B.pls 120.21 2006/04/12 23:02:49 snambaka ship $ */
3:
4: g_tba_desc CONSTANT igs_lookup_values.meaning%TYPE := get_meaning('SCHEDULE_TYPE', 'TBA');
5: g_nsd_desc CONSTANT igs_lookup_values.meaning%TYPE := get_meaning('LEGACY_TOKENS','NO_SET_DAY');
6:
7: FUNCTION get_location_bldg_room ( p_uoo_id IN NUMBER ) RETURN VARCHAR2
8: ------------------------------------------------------------------------------------

Line 5: g_nsd_desc CONSTANT igs_lookup_values.meaning%TYPE := get_meaning('LEGACY_TOKENS','NO_SET_DAY');

1: PACKAGE BODY igs_ss_enr_details AS
2: /* $Header: IGSSS05B.pls 120.21 2006/04/12 23:02:49 snambaka ship $ */
3:
4: g_tba_desc CONSTANT igs_lookup_values.meaning%TYPE := get_meaning('SCHEDULE_TYPE', 'TBA');
5: g_nsd_desc CONSTANT igs_lookup_values.meaning%TYPE := get_meaning('LEGACY_TOKENS','NO_SET_DAY');
6:
7: FUNCTION get_location_bldg_room ( p_uoo_id IN NUMBER ) RETURN VARCHAR2
8: ------------------------------------------------------------------------------------
9: --Created by :

Line 2259: FROM igs_lookup_values lkup, IGS_EN_SS_DISP_STPS en

2255: -- Cursor to find the meaning of lookup code CORE
2256: --
2257: CURSOR cur_get_lkp_meaning IS
2258: SELECT meaning
2259: FROM igs_lookup_values lkup, IGS_EN_SS_DISP_STPS en
2260: WHERE lkup.lookup_type = 'IGS_EN_CORE_IND'
2261: AND lkup.lookup_code = en.core_req_ind;
2262:
2263:

Line 2266: l_core_meaning igs_lookup_values.meaning%TYPE;

2262:
2263:
2264: l_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE;
2265: l_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE;
2266: l_core_meaning igs_lookup_values.meaning%TYPE;
2267:
2268: BEGIN
2269: -- Get the Unit Code
2270: OPEN cur_unit_cd(p_uoo_id);

Line 2664: FROM igs_lookup_values

2660: --Who When What
2661: -------------------------------------------------------------------
2662: CURSOR c_lkups (CP_LOOKUP_CODE IGS_LOOKUPS_VIEW.LOOKUP_CODE%TYPE) IS
2663: SELECT meaning
2664: FROM igs_lookup_values
2665: WHERE lookup_code = cp_lookup_code
2666: AND lookup_type = 'UOO_RELATION_TYPE';
2667:
2668: CURSOR c_sup_unit_cd (CP_SUP_UOO_ID IGS_PS_UNIT_OFR_OPT.UOO_ID%TYPE) IS

Line 3634: FROM igs_lookup_values

3630: **/
3631: FUNCTION get_meaning (p_c_lkup_type IN VARCHAR2,p_c_lkup_code IN VARCHAR2 ) RETURN VARCHAR2 IS
3632: cursor c_meaning (cp_c_lkup_type IN VARCHAR2, cp_c_lkup_code IN VARCHAR2) IS
3633: SELECT meaning
3634: FROM igs_lookup_values
3635: WHERE lookup_type = cp_c_lkup_type
3636: AND lookup_code = cp_c_lkup_code;
3637:
3638: l_c_meaning igs_lookup_values.meaning%TYPE;

Line 3638: l_c_meaning igs_lookup_values.meaning%TYPE;

3634: FROM igs_lookup_values
3635: WHERE lookup_type = cp_c_lkup_type
3636: AND lookup_code = cp_c_lkup_code;
3637:
3638: l_c_meaning igs_lookup_values.meaning%TYPE;
3639:
3640: BEGIN
3641:
3642: OPEN c_meaning(p_c_lkup_type, p_c_lkup_code);

Line 5231: FROM igs_lookup_values lkup, IGS_EN_SS_DISP_STPS en

5227: -- Cursor to find the meaning of lookup code CORE
5228: --
5229: CURSOR cur_get_lkp_meaning IS
5230: SELECT meaning
5231: FROM igs_lookup_values lkup, IGS_EN_SS_DISP_STPS en
5232: WHERE lkup.lookup_type = 'IGS_EN_CORE_IND'
5233: AND lkup.lookup_code = en.core_req_ind;
5234:
5235:

Line 5238: l_core_meaning igs_lookup_values.meaning%TYPE;

5234:
5235:
5236: l_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE;
5237: l_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE;
5238: l_core_meaning igs_lookup_values.meaning%TYPE;
5239: l_core_ind_cd igs_en_su_attempt_all.CORE_INDICATOR_CODE%TYPE;
5240: BEGIN
5241: -- Get the Unit Code
5242: OPEN cur_unit_cd(p_uoo_id);

Line 5442: FROM igs_lookup_values

5438: --Who When What
5439: -------------------------------------------------------------------
5440: CURSOR c_lkups (CP_LOOKUP_CODE IGS_LOOKUPS_VIEW.LOOKUP_CODE%TYPE) IS
5441: SELECT meaning
5442: FROM igs_lookup_values
5443: WHERE lookup_code = cp_lookup_code
5444: AND lookup_type = 'UOO_RELATION_TYPE';
5445:
5446: CURSOR c_sup_unit_cd (CP_SUP_UOO_ID IGS_PS_UNIT_OFR_OPT.UOO_ID%TYPE) IS