APPS.IGS_EN_GEN_LEGACY dependencies on IGS_PR_CLASS_STD

Line 723: p_class_standing IN igs_pr_class_std.class_standing%TYPE)

719:
720:
721:
722: FUNCTION get_class_std_id(
723: p_class_standing IN igs_pr_class_std.class_standing%TYPE)
724: RETURN igs_pr_class_std.igs_pr_class_std_id%TYPE AS
725: /*----------------------------------------------------------------------------
726: || Created By : kkillams
727: || Created On : 08-11-2002

Line 724: RETURN igs_pr_class_std.igs_pr_class_std_id%TYPE AS

720:
721:
722: FUNCTION get_class_std_id(
723: p_class_standing IN igs_pr_class_std.class_standing%TYPE)
724: RETURN igs_pr_class_std.igs_pr_class_std_id%TYPE AS
725: /*----------------------------------------------------------------------------
726: || Created By : kkillams
727: || Created On : 08-11-2002
728: || Purpose : Returns the class standing identifier for a class standing.

Line 733: CURSOR cur_class_std IS SELECT igs_pr_class_std_id FROM IGS_PR_CLASS_STD

729: || Known limitations, enhancements or remarks :
730: || Change History :
731: || Who When What
732: ------------------------------------------------------------------------------*/
733: CURSOR cur_class_std IS SELECT igs_pr_class_std_id FROM IGS_PR_CLASS_STD
734: WHERE class_standing = p_class_standing;
735: l_igs_pr_class_std_id igs_pr_class_std.igs_pr_class_std_id%TYPE;
736: BEGIN
737: --Return null if input parameters is null.

Line 735: l_igs_pr_class_std_id igs_pr_class_std.igs_pr_class_std_id%TYPE;

731: || Who When What
732: ------------------------------------------------------------------------------*/
733: CURSOR cur_class_std IS SELECT igs_pr_class_std_id FROM IGS_PR_CLASS_STD
734: WHERE class_standing = p_class_standing;
735: l_igs_pr_class_std_id igs_pr_class_std.igs_pr_class_std_id%TYPE;
736: BEGIN
737: --Return null if input parameters is null.
738: IF p_class_standing IS NULL THEN
739: RETURN NULL;

Line 743: FETCH cur_class_std INTO l_igs_pr_class_std_id;

739: RETURN NULL;
740: END IF;
741: --Get class identifier for the given class standing.
742: OPEN cur_class_std;
743: FETCH cur_class_std INTO l_igs_pr_class_std_id;
744: IF cur_class_std%NOTFOUND THEN
745: CLOSE cur_class_std;
746: RETURN NULL;
747: END IF;

Line 749: RETURN l_igs_pr_class_std_id;

745: CLOSE cur_class_std;
746: RETURN NULL;
747: END IF;
748: CLOSE cur_class_std;
749: RETURN l_igs_pr_class_std_id;
750: EXCEPTION
751: WHEN OTHERS THEN
752: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
753: FND_MESSAGE.SET_TOKEN('NAME', 'igs_en_gen_legacy.get_class_std_id');