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.

[Home] [Help]

APPS.IGS_EN_VAL_SUA dependencies on IGS_PS_UNIT_STAT

Line 1893: IGS_PS_UNIT_STAT us

1889: WHERE administrative_unit_status = p_administrative_unit_status;
1890: CURSOR c_uvus IS
1891: SELECT us.s_unit_status
1892: FROM IGS_PS_UNIT_VER uv,
1893: IGS_PS_UNIT_STAT us
1894: WHERE uv.unit_cd = p_unit_cd AND
1895: uv.version_number = p_version_number AND
1896: us.unit_status = uv.unit_status;
1897: CURSOR c_cas IS

Line 2990: SELECT IGS_PS_UNIT_STAT.s_unit_status

2986: gv_other_details VARCHAR2(255);
2987: BEGIN
2988: DECLARE
2989: CURSOR c_get_uv_status IS
2990: SELECT IGS_PS_UNIT_STAT.s_unit_status
2991: FROM IGS_PS_UNIT_VER,
2992: IGS_PS_UNIT_STAT
2993: WHERE IGS_PS_UNIT_VER.unit_cd = p_unit_cd AND
2994: IGS_PS_UNIT_VER.version_number = p_version_number AND

Line 2992: IGS_PS_UNIT_STAT

2988: DECLARE
2989: CURSOR c_get_uv_status IS
2990: SELECT IGS_PS_UNIT_STAT.s_unit_status
2991: FROM IGS_PS_UNIT_VER,
2992: IGS_PS_UNIT_STAT
2993: WHERE IGS_PS_UNIT_VER.unit_cd = p_unit_cd AND
2994: IGS_PS_UNIT_VER.version_number = p_version_number AND
2995: IGS_PS_UNIT_STAT.unit_status = IGS_PS_UNIT_VER.unit_status;
2996: CURSOR c_val_uoo IS

Line 2995: IGS_PS_UNIT_STAT.unit_status = IGS_PS_UNIT_VER.unit_status;

2991: FROM IGS_PS_UNIT_VER,
2992: IGS_PS_UNIT_STAT
2993: WHERE IGS_PS_UNIT_VER.unit_cd = p_unit_cd AND
2994: IGS_PS_UNIT_VER.version_number = p_version_number AND
2995: IGS_PS_UNIT_STAT.unit_status = IGS_PS_UNIT_VER.unit_status;
2996: CURSOR c_val_uoo IS
2997: SELECT offered_ind
2998: FROM IGS_PS_UNIT_OFR_OPT
2999: WHERE unit_cd = p_unit_cd AND

Line 3006: cst_active IGS_PS_UNIT_STAT.s_unit_status%TYPE := 'ACTIVE';

3002: ci_sequence_number = p_ci_sequence_number AND
3003: location_cd = p_location_cd AND
3004: unit_class = p_unit_class;
3005: cst_no IGS_PS_UNIT_OFR_OPT.offered_ind%TYPE := 'N';
3006: cst_active IGS_PS_UNIT_STAT.s_unit_status%TYPE := 'ACTIVE';
3007: cst_inactive IGS_PS_UNIT_STAT.s_unit_status%TYPE := 'INACTIVE';
3008: v_uv_status IGS_PS_UNIT_STAT.s_unit_status%TYPE;
3009: v_offered_ind IGS_PS_UNIT_OFR_OPT.offered_ind%TYPE;
3010: BEGIN

Line 3007: cst_inactive IGS_PS_UNIT_STAT.s_unit_status%TYPE := 'INACTIVE';

3003: location_cd = p_location_cd AND
3004: unit_class = p_unit_class;
3005: cst_no IGS_PS_UNIT_OFR_OPT.offered_ind%TYPE := 'N';
3006: cst_active IGS_PS_UNIT_STAT.s_unit_status%TYPE := 'ACTIVE';
3007: cst_inactive IGS_PS_UNIT_STAT.s_unit_status%TYPE := 'INACTIVE';
3008: v_uv_status IGS_PS_UNIT_STAT.s_unit_status%TYPE;
3009: v_offered_ind IGS_PS_UNIT_OFR_OPT.offered_ind%TYPE;
3010: BEGIN
3011: --- Set the default message number

Line 3008: v_uv_status IGS_PS_UNIT_STAT.s_unit_status%TYPE;

3004: unit_class = p_unit_class;
3005: cst_no IGS_PS_UNIT_OFR_OPT.offered_ind%TYPE := 'N';
3006: cst_active IGS_PS_UNIT_STAT.s_unit_status%TYPE := 'ACTIVE';
3007: cst_inactive IGS_PS_UNIT_STAT.s_unit_status%TYPE := 'INACTIVE';
3008: v_uv_status IGS_PS_UNIT_STAT.s_unit_status%TYPE;
3009: v_offered_ind IGS_PS_UNIT_OFR_OPT.offered_ind%TYPE;
3010: BEGIN
3011: --- Set the default message number
3012: p_message_name := null;