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_ELGBL_UNIT dependencies on IGS_PS_UNIT_VER_RU

Line 2759: FROM igs_ps_unit_ver_ru uvr,

2755: s_rule_call_cd = 'USECPREREQ';
2756:
2757: CURSOR cur_unit_prereq(p_uoo_id NUMBER) IS
2758: SELECT rul_sequence_number
2759: FROM igs_ps_unit_ver_ru uvr,
2760: igs_ps_unit_ofr_opt uoo
2761: WHERE uvr.unit_cd = uoo.unit_cd AND
2762: uvr.version_number = uoo.version_number AND
2763: uoo_id = p_uoo_id AND

Line 2772: l_rul_sequence_number igs_ps_unit_ver_ru.rul_sequence_number%TYPE;

2768: FROM igs_ps_unit_ofr_opt
2769: WHERE uoo_id = p_uoo_id;
2770:
2771: l_step_override_limit igs_en_elgb_ovr_step.step_override_limit%TYPE;
2772: l_rul_sequence_number igs_ps_unit_ver_ru.rul_sequence_number%TYPE;
2773: l_unit_dtls_rec cur_usec_dtl%ROWTYPE;
2774: l_version_number igs_ps_unit_ofr_opt.version_number%TYPE;
2775: l_cal_type igs_ps_unit_ofr_opt.cal_type%TYPE;
2776: l_ci_sequence_number igs_ps_unit_ofr_opt.ci_sequence_number%TYPE;

Line 2778: l_rule_text igs_ps_unit_ver_ru_v.rule_text%TYPE;

2774: l_version_number igs_ps_unit_ofr_opt.version_number%TYPE;
2775: l_cal_type igs_ps_unit_ofr_opt.cal_type%TYPE;
2776: l_ci_sequence_number igs_ps_unit_ofr_opt.ci_sequence_number%TYPE;
2777: l_message VARCHAR2(30);
2778: l_rule_text igs_ps_unit_ver_ru_v.rule_text%TYPE;
2779: l_message_icon VARCHAR2(1);
2780:
2781: --
2782: -- begin of the function eval_prereq

Line 2931: FROM igs_ps_unit_ver_ru uvr,

2927: s_rule_call_cd = 'USECCOREQ';
2928:
2929: CURSOR cur_unit_coreq(p_uoo_id NUMBER) IS
2930: SELECT rul_sequence_number
2931: FROM igs_ps_unit_ver_ru uvr,
2932: igs_ps_unit_ofr_opt uoo
2933: WHERE uvr.unit_cd = uoo.unit_cd AND
2934: uvr.version_number = uoo.version_number AND
2935: uoo_id = p_uoo_id AND

Line 2944: l_rul_sequence_number igs_ps_unit_ver_ru.rul_sequence_number%TYPE;

2940: FROM igs_ps_unit_ofr_opt
2941: WHERE uoo_id = p_uoo_id;
2942:
2943: l_step_override_limit igs_en_elgb_ovr_step.step_override_limit%TYPE;
2944: l_rul_sequence_number igs_ps_unit_ver_ru.rul_sequence_number%TYPE;
2945: l_unit_dtls_rec cur_usec_dtl%ROWTYPE;
2946: l_message VARCHAR2(30);
2947: l_message_icon VARCHAR2(1);
2948: l_rule_text igs_ps_unit_ver_ru_v.rule_text%TYPE;

Line 2948: l_rule_text igs_ps_unit_ver_ru_v.rule_text%TYPE;

2944: l_rul_sequence_number igs_ps_unit_ver_ru.rul_sequence_number%TYPE;
2945: l_unit_dtls_rec cur_usec_dtl%ROWTYPE;
2946: l_message VARCHAR2(30);
2947: l_message_icon VARCHAR2(1);
2948: l_rule_text igs_ps_unit_ver_ru_v.rule_text%TYPE;
2949: l_coreq_string VARCHAR2(1000);
2950: l_destination VARCHAR2(100);
2951: l_message_action VARCHAR2(100);
2952: --

Line 3102: FROM igs_ps_unit_ver_ru uvr,

3098: -------------------------------------------------------------------------------------
3099:
3100: CURSOR cur_unit_incomp(p_uoo_id NUMBER) IS
3101: SELECT rul_sequence_number
3102: FROM igs_ps_unit_ver_ru uvr,
3103: igs_ps_unit_ofr_opt uoo
3104: WHERE uvr.unit_cd = uoo.unit_cd AND
3105: uvr.version_number = uoo.version_number AND
3106: uoo_id = p_uoo_id AND

Line 3115: l_rul_sequence_number igs_ps_unit_ver_ru.rul_sequence_number%TYPE;

3111: FROM igs_ps_unit_ofr_opt
3112: WHERE uoo_id = p_uoo_id;
3113:
3114: l_step_override_limit igs_en_elgb_ovr_step.step_override_limit%TYPE;
3115: l_rul_sequence_number igs_ps_unit_ver_ru.rul_sequence_number%TYPE;
3116: l_unit_dtls_rec cur_usec_dtl%ROWTYPE;
3117: l_message VARCHAR2(30);
3118: l_message_icon VARCHAR2(1);
3119: l_rule_text igs_ps_unit_ver_ru_v.rule_text%TYPE;

Line 3119: l_rule_text igs_ps_unit_ver_ru_v.rule_text%TYPE;

3115: l_rul_sequence_number igs_ps_unit_ver_ru.rul_sequence_number%TYPE;
3116: l_unit_dtls_rec cur_usec_dtl%ROWTYPE;
3117: l_message VARCHAR2(30);
3118: l_message_icon VARCHAR2(1);
3119: l_rule_text igs_ps_unit_ver_ru_v.rule_text%TYPE;
3120:
3121: --
3122: -- begin of the function eval_incompatible
3123: --