APPS.IGS_PR_GEN_004 dependencies on IGS_PR_OU_UNIT_SET

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 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: