APPS.IGS_PR_GEN_006 dependencies on IGS_PR_OU_AWD

Line 758: -- to add records to the IGS_PR_OU_AWD table as well

754: -- Prodecdure to create new IGS_PR_OU_RS, IGS_PR_OU_UNIT_SET
755: -- and IGS_PR_OU_UNIT records
756:
757: --Modified as part of Academic Standing and Progression build
758: -- to add records to the IGS_PR_OU_AWD table as well
759: -- amuthu 6-Dec-2001
760: DECLARE
761: CURSOR c_poc IS
762: SELECT poc.course_cd

Line 777: FROM IGS_PR_OU_AWD poa

773: pous.pro_sequence_number = p_pro_sequence_number;
774:
775: CURSOR c_poa IS
776: SELECT poa.award_cd
777: FROM IGS_PR_OU_AWD poa
778: WHERE poa.progression_rule_cat = p_progression_rule_cat AND
779: poa.pra_sequence_number = p_pra_sequence_number AND
780: poa.pro_sequence_number = p_pro_sequence_number;
781: CURSOR c_popu IS

Line 865: IGS_PR_OU_AWD_PKG.INSERT_ROW (

861: lv_rowid VARCHAR2(25);
862: l_org_id NUMBER(15);
863: BEGIN
864: l_org_id := igs_ge_gen_003.get_org_id();
865: IGS_PR_OU_AWD_PKG.INSERT_ROW (
866: X_ROWID => lv_rowid,
867: X_PROGRESSION_RULE_CAT => p_progression_rule_cat,
868: X_PRA_SEQUENCE_NUMBER => p_new_pra_sequence_number,
869: X_PRO_SEQUENCE_NUMBER => p_new_pro_sequence_number,