APPS.IGS_PR_GEN_006 dependencies on IGS_PR_OU_UNIT_SET

Line 733: gv_err_ins_pous VARCHAR2(255); -- IGS_PR_OU_UNIT_SET

729: gv_err_ins_pra VARCHAR2(255); -- IGS_PR_RU_APPL
730: gv_err_ins_prrc VARCHAR2(255); -- IGS_PR_RU_CA_TYPE
731: gv_err_ins_pro VARCHAR2(255); -- IGS_PR_RU_OU
732: gv_err_ins_poc VARCHAR2(255); -- IGS_PR_OU_RS
733: gv_err_ins_pous VARCHAR2(255); -- IGS_PR_OU_UNIT_SET
734: gv_err_ins_popu VARCHAR2(255); -- IGS_PR_OU_UNIT
735: gv_err_ins_popf VARCHAR2(255); -- IGS_PR_OU_FND
736: gv_new_pra_sequence_number IGS_PR_RU_APPL.sequence_number%TYPE;
737: BEGIN -- IGS_PR_ins_copy_pra

Line 754: -- Prodecdure to create new IGS_PR_OU_RS, IGS_PR_OU_UNIT_SET

750: p_new_pro_sequence_number IGS_PR_RU_OU.sequence_number%TYPE,
751: p_message_name IN OUT NOCOPY IGS_PR_S_SCRATCH_PAD.MESSAGE_NAME%TYPE)
752: IS
753: BEGIN -- prgpl_ins_poc
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

Line 770: FROM IGS_PR_OU_UNIT_SET pous

766: poc.pro_sequence_number = p_pro_sequence_number;
767: CURSOR c_pous IS
768: SELECT pous.unit_set_cd,
769: pous.us_version_number
770: FROM IGS_PR_OU_UNIT_SET pous
771: WHERE pous.progression_rule_cat = p_progression_rule_cat AND
772: pous.pra_sequence_number = p_pra_sequence_number AND
773: pous.pro_sequence_number = p_pro_sequence_number;
774:

Line 835: IGS_PR_OU_UNIT_SET_PKG.INSERT_ROW (

831: lv_rowid VARCHAR2(25);
832: l_org_id NUMBER(15);
833: BEGIN
834: l_org_id := igs_ge_gen_003.get_org_id;
835: IGS_PR_OU_UNIT_SET_PKG.INSERT_ROW (
836: X_ROWID =>LV_ROWID,
837: X_PROGRESSION_RULE_CAT =>p_progression_rule_cat,
838: X_PRA_SEQUENCE_NUMBER =>p_new_pra_sequence_number,
839: X_PRO_SEQUENCE_NUMBER =>p_new_pro_sequence_number,

Line 1313: -- Where existing, copy IGS_PR_OU_RS, IGS_PR_OU_UNIT_SET and

1309: ELSE
1310: RAISE;
1311: END IF;
1312: END;
1313: -- Where existing, copy IGS_PR_OU_RS, IGS_PR_OU_UNIT_SET and
1314: -- IGS_PR_OU_UNIT records, moving from the old to new pro record
1315: IF v_error_ins_pro = FALSE THEN
1316: prgpl_ins_poc_pous_popu(
1317: p_progression_rule_cat,

Line 1325: gv_err_ins_pous := 'IGS_PR_OU_UNIT_SET ';

1321: v_new_pro_sequence_number,
1322: p_message_name); -- IN OUT NOCOPY
1323: ELSE
1324: gv_err_ins_poc := 'IGS_PR_OU_RS ';
1325: gv_err_ins_pous := 'IGS_PR_OU_UNIT_SET ';
1326: gv_err_ins_popu := 'IGS_PR_OU_UNIT ';
1327: END IF;
1328: OPEN c_pra_check_pro (
1329: p_progression_rule_cat,

Line 1373: gv_err_ins_pous := 'IGS_PR_OU_UNIT_SET ';

1369: -- record was not created.
1370: gv_err_ins_prrc := 'IGS_PR_RU_CA_TYPE ';
1371: gv_err_ins_pro := 'IGS_PR_RU_OU ';
1372: gv_err_ins_poc := 'IGS_PR_OU_RS ';
1373: gv_err_ins_pous := 'IGS_PR_OU_UNIT_SET ';
1374: gv_err_ins_popu := 'IGS_PR_OU_UNIT ';
1375: gv_err_ins_popf := 'IGS_PR_OU_FND';
1376: END IF;
1377: RETURN gv_new_pra_sequence_number;