APPS.IGS_PR_GEN_004 dependencies on IGS_PR_OU_UNIT

Line 3736: FROM IGS_PR_OU_UNIT popu

3732: cst_exc_course);
3733: CURSOR c_popu IS
3734: SELECT popu.unit_cd,
3735: popu.s_unit_type
3736: FROM IGS_PR_OU_UNIT popu
3737: WHERE popu.progression_rule_cat = p_progression_rule_cat AND
3738: popu.pra_sequence_number = p_original_pra_sequence_number AND
3739: popu.pro_sequence_number = p_pro_sequence_number;
3740:

Line 3745: FROM IGS_PR_OU_UNIT_SET pous

3741:
3742: CURSOR c_pous IS
3743: SELECT pous.unit_set_cd,
3744: pous.us_version_number
3745: FROM IGS_PR_OU_UNIT_SET pous
3746: WHERE pous.progression_rule_cat = p_progression_rule_cat AND
3747: pous.pra_sequence_number = p_original_pra_sequence_number AND
3748: pous.pro_sequence_number = p_pro_sequence_number;
3749:

Line 4418: FROM IGS_PR_OU_UNIT_SET pous

4414: cp_progression_rule_cat IGS_PR_RU_APPL.progression_rule_cat%TYPE,
4415: cp_pra_sequence_number IGS_PR_RU_APPL.sequence_number%TYPE,
4416: cp_pro_sequence_number IGS_PR_RU_OU.sequence_number%TYPE) IS
4417: SELECT pous.ROWID
4418: FROM IGS_PR_OU_UNIT_SET pous
4419: WHERE pous.progression_rule_cat = cp_progression_rule_cat AND
4420: pous.pra_sequence_number = cp_pra_sequence_number AND
4421: pous.pro_sequence_number = cp_pro_sequence_number
4422: FOR UPDATE NOWAIT;

Line 4440: FROM IGS_PR_OU_UNIT popu

4436: cp_progression_rule_cat IGS_PR_RU_APPL.progression_rule_cat%TYPE,
4437: cp_pra_sequence_number IGS_PR_RU_APPL.sequence_number%TYPE,
4438: cp_pro_sequence_number IGS_PR_RU_OU.sequence_number%TYPE) IS
4439: SELECT popu.ROWID
4440: FROM IGS_PR_OU_UNIT popu
4441: WHERE popu.progression_rule_cat = cp_progression_rule_cat AND
4442: popu.pra_sequence_number = cp_pra_sequence_number AND
4443: popu.pro_sequence_number = cp_pro_sequence_number
4444: FOR UPDATE NOWAIT;

Line 4600: -- Delete from IGS_PR_OU_UNIT_SET

4596: v_poc_rec.ROWID
4597: );
4598: END LOOP;
4599:
4600: -- Delete from IGS_PR_OU_UNIT_SET
4601: FOR v_pous_rec IN c_pous (
4602: v_pra_rec.progression_rule_cat,
4603: v_pra_rec.sequence_number,
4604: v_pro_rec.sequence_number) LOOP

Line 4605: IGS_PR_OU_UNIT_SET_PKG.DELETE_ROW(

4601: FOR v_pous_rec IN c_pous (
4602: v_pra_rec.progression_rule_cat,
4603: v_pra_rec.sequence_number,
4604: v_pro_rec.sequence_number) LOOP
4605: IGS_PR_OU_UNIT_SET_PKG.DELETE_ROW(
4606: v_pous_rec.ROWID
4607: );
4608: END LOOP;
4609:

Line 4618: -- Delete from IGS_PR_OU_UNIT

4614: v_pro_rec.sequence_number) LOOP
4615: IGS_PR_OU_AWD_PKG.DELETE_ROW(v_poa_rec.ROWID);
4616: END LOOP;
4617:
4618: -- Delete from IGS_PR_OU_UNIT
4619: FOR v_popu_rec IN c_popu (
4620: v_pra_rec.progression_rule_cat,
4621: v_pra_rec.sequence_number,
4622: v_pro_rec.sequence_number) LOOP

Line 4623: IGS_PR_OU_UNIT_PKG.DELETE_ROW(

4619: FOR v_popu_rec IN c_popu (
4620: v_pra_rec.progression_rule_cat,
4621: v_pra_rec.sequence_number,
4622: v_pro_rec.sequence_number) LOOP
4623: IGS_PR_OU_UNIT_PKG.DELETE_ROW(
4624: v_popu_rec.ROWID
4625: );
4626: END LOOP;
4627: --

Line 4630: -- Delete from IGS_PR_OU_UNIT

4626: END LOOP;
4627: --
4628: -- Start of new code added as per the FA110 PR Enh. Bug# 2658550.
4629: --
4630: -- Delete from IGS_PR_OU_UNIT
4631: FOR v_pfnd_rec IN c_pfnd (v_pra_rec.progression_rule_cat,
4632: v_pra_rec.sequence_number,
4633: v_pro_rec.sequence_number) LOOP
4634: IGS_PR_OU_FND_PKG.DELETE_ROW (v_pfnd_rec.ROWID);