APPS.IGS_SS_ENR_DETAILS dependencies on IGS_PS_USEC_RU

Line 3437: FROM igs_ps_usec_ru

3433: IS
3434: --cursor to look up the rule code in unit section version rules
3435: CURSOR c_usec_ru (cp_n_uoo_id IN NUMBER, cp_c_rul_call_cd IN VARCHAR2) IS
3436: SELECT rul_sequence_number
3437: FROM igs_ps_usec_ru
3438: WHERE uoo_id = p_n_uoo_id
3439: AND s_rule_call_cd = cp_c_rul_call_cd;
3440:
3441: --cursor to look up the rule code in unit version rules

Line 3451: l_n_seq_num igs_ps_usec_ru.rul_sequence_number%TYPE;

3447: AND uoo.unit_cd = ru.unit_cd
3448: AND uoo.version_number = ru.version_number
3449: AND ru.s_rule_call_cd = cp_c_rul_call_cd;
3450:
3451: l_n_seq_num igs_ps_usec_ru.rul_sequence_number%TYPE;
3452: l_c_us_cal_cd igs_ps_usec_ru.s_rule_call_cd%TYPE;
3453: BEGIN
3454: IF p_rule_type = 'COREQ' THEN
3455: l_c_us_cal_cd := 'USECCOREQ';

Line 3452: l_c_us_cal_cd igs_ps_usec_ru.s_rule_call_cd%TYPE;

3448: AND uoo.version_number = ru.version_number
3449: AND ru.s_rule_call_cd = cp_c_rul_call_cd;
3450:
3451: l_n_seq_num igs_ps_usec_ru.rul_sequence_number%TYPE;
3452: l_c_us_cal_cd igs_ps_usec_ru.s_rule_call_cd%TYPE;
3453: BEGIN
3454: IF p_rule_type = 'COREQ' THEN
3455: l_c_us_cal_cd := 'USECCOREQ';
3456: ELSIF p_rule_type = 'PREREQ' THEN

Line 3590: FROM igs_ps_usec_ru

3586: AS
3587: --Check if the prereq/coreq rule is setup at the unit section level.
3588: CURSOR c_get_usec_rul_seq_no IS
3589: SELECT rul_sequence_number
3590: FROM igs_ps_usec_ru
3591: WHERE uoo_id = p_uoo_id
3592: AND s_rule_call_cd = 'USEC'|| p_rule_type;
3593:
3594:

Line 4943: FROM igs_ps_usec_ru

4939: AS
4940: /*** get the coreq rule defined at the unit section rules ***/
4941: Cursor c_coreq_usec(cp_uoo_id NUMBER) IS
4942: SELECT rul_sequence_number
4943: FROM igs_ps_usec_ru
4944: WHERE uoo_id = cp_uoo_id
4945: AND s_rule_call_cd = 'USECCOREQ';
4946:
4947: /*** get the coreq rule defined at the unit version rules ***/

Line 4956: l_rule_seq_num igs_ps_usec_ru.rul_sequence_number%TYPE;

4952: AND uvr.version_number = uoo.version_number
4953: AND uoo_id = cp_uoo_id
4954: AND uvr.s_rule_call_cd = 'COREQ';
4955:
4956: l_rule_seq_num igs_ps_usec_ru.rul_sequence_number%TYPE;
4957: l_rule_text igs_ps_usec_ru_v.rule_text%TYPE;
4958: l_index NUMBER;
4959: l_coreq_units VARCHAR2(1000);
4960: l_coreq_string VARCHAR2(1000);

Line 4957: l_rule_text igs_ps_usec_ru_v.rule_text%TYPE;

4953: AND uoo_id = cp_uoo_id
4954: AND uvr.s_rule_call_cd = 'COREQ';
4955:
4956: l_rule_seq_num igs_ps_usec_ru.rul_sequence_number%TYPE;
4957: l_rule_text igs_ps_usec_ru_v.rule_text%TYPE;
4958: l_index NUMBER;
4959: l_coreq_units VARCHAR2(1000);
4960: l_coreq_string VARCHAR2(1000);
4961: l_start_index NUMBER;