APPS.IGS_PS_CREATE_GENERIC_PKG dependencies on IGS_RU_CALL

Line 8704: IF NOT igs_ru_call_pkg.get_pk_for_validation (p_usec_rule_rec.s_rule_call_cd ) THEN

8700: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_NOT_EXISTS', 'UNIT_SECTION', 'LEGACY_TOKENS', FALSE);
8701: p_usec_rule_rec.status := 'E';
8702: END IF;
8703:
8704: IF NOT igs_ru_call_pkg.get_pk_for_validation (p_usec_rule_rec.s_rule_call_cd ) THEN
8705: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_NOT_EXISTS', 'S_RULE_CALL_CD', 'LEGACY_TOKENS', FALSE);
8706: p_usec_rule_rec.status := 'E';
8707: END IF;
8708:

Line 8740: FROM igs_ru_call rc,igs_ru_description rd

8736: PROCEDURE Business_validation(p_usec_rule_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rule_rec_type) AS
8737:
8738: CURSOR cur_rule_check IS
8739: SELECT rc.select_group,rd.rule_description
8740: FROM igs_ru_call rc,igs_ru_description rd
8741: WHERE rc.s_rule_type_cd = 'USEC'
8742: AND rc.s_rule_call_cd = p_usec_rule_rec.s_rule_call_cd
8743: AND rc.rud_sequence_number = rd.sequence_number;
8744:

Line 8756: -- s_rule_call_cd must exists in igs_ru_call with S_RULE_TYPE_CD='USEC'

8752: fnd_msg_pub.add;
8753: p_usec_rule_rec.status := 'E';
8754: END IF;
8755:
8756: -- s_rule_call_cd must exists in igs_ru_call with S_RULE_TYPE_CD='USEC'
8757: --Valid values of S_RULE_CALL_CD are 'USECCOREQ' and 'USECPREREQ'
8758: OPEN cur_rule_check;
8759: FETCH cur_rule_check INTO l_n_select_group,l_c_rule_desc;
8760: IF cur_rule_check%NOTFOUND THEN