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_PS_UNIT_LGCY_PKG dependencies on IGS_GE_REF_CD_TYPE_ALL

Line 7349: CURSOR c_res_flag (cp_c_ref_type igs_ge_ref_cd_type_all.reference_cd_type%TYPE) IS

7345: --
7346: l_insert_update VARCHAR2(1);
7347: --
7348: -- Following cursor added as part of bug#2972950 for the PSP Enhancements TD
7349: CURSOR c_res_flag (cp_c_ref_type igs_ge_ref_cd_type_all.reference_cd_type%TYPE) IS
7350: SELECT restricted_flag
7351: FROM igs_ge_ref_cd_type_all
7352: WHERE reference_cd_type = cp_c_ref_type;
7353:

Line 7351: FROM igs_ge_ref_cd_type_all

7347: --
7348: -- Following cursor added as part of bug#2972950 for the PSP Enhancements TD
7349: CURSOR c_res_flag (cp_c_ref_type igs_ge_ref_cd_type_all.reference_cd_type%TYPE) IS
7350: SELECT restricted_flag
7351: FROM igs_ge_ref_cd_type_all
7352: WHERE reference_cd_type = cp_c_ref_type;
7353:
7354: rec_res_flag c_res_flag%ROWTYPE;
7355:

Line 7553: CURSOR c_ref_des (cp_c_ref_type igs_ge_ref_cd_type_all.reference_cd_type%TYPE,

7549: -- Decides to call the derivation procedures based on the datatype
7550: PROCEDURE validate_derivation( p_ref_cd_rec IN OUT NOCOPY igs_ps_generic_pub.unit_ref_rec_type) AS
7551:
7552: -- Following cursor added as part of bug#2972950 for the PSP Enhancements TD
7553: CURSOR c_ref_des (cp_c_ref_type igs_ge_ref_cd_type_all.reference_cd_type%TYPE,
7554: cp_c_ref_cd igs_ge_ref_cd.reference_cd%TYPE) IS
7555: SELECT rc.description
7556: FROM igs_ge_ref_cd_type_all rct,
7557: igs_ge_ref_cd rc

Line 7556: FROM igs_ge_ref_cd_type_all rct,

7552: -- Following cursor added as part of bug#2972950 for the PSP Enhancements TD
7553: CURSOR c_ref_des (cp_c_ref_type igs_ge_ref_cd_type_all.reference_cd_type%TYPE,
7554: cp_c_ref_cd igs_ge_ref_cd.reference_cd%TYPE) IS
7555: SELECT rc.description
7556: FROM igs_ge_ref_cd_type_all rct,
7557: igs_ge_ref_cd rc
7558: WHERE rct.reference_cd_type = cp_c_ref_type
7559: AND rct.reference_cd_type = rc.reference_cd_type
7560: AND rc.reference_cd = cp_c_ref_cd

Line 7794: FROM igs_ps_usec_ref_cd ur, igs_ge_ref_cd_type_all rc

7790: FUNCTION check_insert_update ( p_ref_cd_rec IN OUT NOCOPY igs_ps_generic_pub.unit_ref_rec_type ) RETURN VARCHAR2 IS
7791: --For IGS_PS_USEC_REF_CD record
7792: CURSOR c_gen IS
7793: SELECT rc.restricted_flag,ur.reference_code_desc
7794: FROM igs_ps_usec_ref_cd ur, igs_ge_ref_cd_type_all rc
7795: WHERE ur.unit_section_reference_id = l_n_usec_ref_id
7796: AND ur.reference_code_type = p_ref_cd_rec.reference_cd_type
7797: AND ur.reference_code = p_ref_cd_rec.reference_cd
7798: AND ur.reference_code_type=rc.reference_cd_type;

Line 7804: FROM igs_ps_us_req_ref_cd urr,igs_ge_ref_cd_type_all rc

7800:
7801: --For IGS_PS_US_REQ_REF_CD record
7802: CURSOR c_req IS
7803: SELECT rc.restricted_flag,urr.reference_code_desc
7804: FROM igs_ps_us_req_ref_cd urr,igs_ge_ref_cd_type_all rc
7805: WHERE urr.unit_section_reference_id = l_n_usec_ref_id
7806: AND urr.reference_cd_type = p_ref_cd_rec.reference_cd_type
7807: AND urr.reference_code = p_ref_cd_rec.reference_cd
7808: AND urr.reference_cd_type=rc.reference_cd_type;

Line 7813: FROM igs_ps_usec_ocur_ref uo,igs_ge_ref_cd_type_all rc

7809:
7810: --For IGS_PS_USEC_OCUR_REF record
7811: CURSOR c_occr IS
7812: SELECT rc.restricted_flag,uo.reference_code_desc
7813: FROM igs_ps_usec_ocur_ref uo,igs_ge_ref_cd_type_all rc
7814: WHERE uo.reference_code_type = p_ref_cd_rec.reference_cd_type
7815: AND uo.reference_code = p_ref_cd_rec.reference_cd
7816: AND uo.unit_section_occurrence_id = l_n_uso_id
7817: AND uo.reference_code_type=rc.reference_cd_type;