APPS.IGS_PR_GEN_004 dependencies on IGS_PR_OU_PS

Line 3717: FROM IGS_PR_OU_PS poc

3713: WHERE crv.course_cd = p_course_cd AND
3714: crv.version_number = p_sca_version_number;
3715: CURSOR c_poc IS
3716: SELECT poc.course_cd
3717: FROM IGS_PR_OU_PS poc
3718: WHERE poc.progression_rule_cat = p_progression_rule_cat AND
3719: poc.pra_sequence_number = p_original_pra_sequence_number AND
3720: poc.pro_sequence_number = p_pro_sequence_number;
3721: CURSOR c_pot_etde IS

Line 4406: FROM IGS_PR_OU_PS poc

4402: cp_progression_rule_cat IGS_PR_RU_APPL.progression_rule_cat%TYPE,
4403: cp_pra_sequence_number IGS_PR_RU_APPL.sequence_number%TYPE,
4404: cp_pro_sequence_number IGS_PR_RU_OU.sequence_number%TYPE) IS
4405: SELECT poc.progression_rule_cat, poc.ROWID
4406: FROM IGS_PR_OU_PS poc
4407: WHERE poc.progression_rule_cat = cp_progression_rule_cat AND
4408: poc.pra_sequence_number = cp_pra_sequence_number AND
4409: poc.pro_sequence_number = cp_pro_sequence_number
4410: FOR UPDATE NOWAIT;

Line 4590: -- Delete from IGS_PR_OU_PS

4586: FOR v_pro_rec IN c_pro (
4587: v_pra_rec.progression_rule_cat,
4588: v_pra_rec.sequence_number) LOOP
4589:
4590: -- Delete from IGS_PR_OU_PS
4591: FOR v_poc_rec IN c_poc (
4592: v_pra_rec.progression_rule_cat,
4593: v_pra_rec.sequence_number,
4594: v_pro_rec.sequence_number) LOOP

Line 4595: IGS_PR_OU_PS_PKG.DELETE_ROW(

4591: FOR v_poc_rec IN c_poc (
4592: v_pra_rec.progression_rule_cat,
4593: v_pra_rec.sequence_number,
4594: v_pro_rec.sequence_number) LOOP
4595: IGS_PR_OU_PS_PKG.DELETE_ROW(
4596: v_poc_rec.ROWID
4597: );
4598: END LOOP;
4599: