APPS.IGS_EN_PLAN_UTILS dependencies on IGS_EN_SU_ATTEMPT_PKG

Line 346: igs_en_su_attempt_pkg.UPDATE_ROW(

342: p_audit IN VARCHAR2,
343: p_credit IN NUMBER,
344: p_old_refsua select_sua%ROWTYPE) IS
345: BEGIN
346: igs_en_su_attempt_pkg.UPDATE_ROW(
347: X_ROWID => p_old_refsua.rowid,
348: X_PERSON_ID => p_old_refsua.PERSON_ID,
349: X_COURSE_CD => p_old_refsua.COURSE_CD,
350: X_UNIT_CD => p_old_refsua.UNIT_CD,

Line 1145: -- Set the calling package as 'SWAP' so that check parent existence in igs_en_su_attempt_pkg will not be called.

1141: CLOSE c_drop_reason;
1142:
1143: IF l_uoo_ids IS NOT NULL THEN
1144:
1145: -- Set the calling package as 'SWAP' so that check parent existence in igs_en_su_attempt_pkg will not be called.
1146: -- This is to overcome the locking issue encountered during Swap.
1147: -- (i.e) when the user is dropping few sua in the swap to be replaced, the sua is getting updated as 'DROPPED' and
1148: -- it locks all the parent records like SPA terms, sca...., in the swap to be added page when the user tries to
1149: -- add few sua, sua records are created in autonomous transaction where the check_parent_existences of TBH is being

Line 1153: igs_en_su_attempt_pkg.pkg_source_of_drop := 'SWAP';

1149: -- add few sua, sua records are created in autonomous transaction where the check_parent_existences of TBH is being
1150: -- called as the parents are already locked in another transaction while dropping, SUA record creation in autonomous
1151: -- transaction fails.
1152:
1153: igs_en_su_attempt_pkg.pkg_source_of_drop := 'SWAP';
1154:
1155: while l_uoo_ids is not null loop
1156: pos := instr(l_uoo_ids,',',1);
1157: if pos=0 then

Line 1169: IGS_EN_SU_ATTEMPT_PKG.UPDATE_ROW (

1165: FOR rec_sua IN c_sua(p_person_id,p_program_cd,l_cur_uoo_id)
1166: LOOP
1167:
1168: -- Drop the sua with reason code as swap reason code.
1169: IGS_EN_SU_ATTEMPT_PKG.UPDATE_ROW (
1170: X_ROWID => rec_sua.row_id,
1171: X_PERSON_ID => rec_sua.person_id,
1172: X_COURSE_CD => rec_sua.course_cd,
1173: X_UNIT_CD => rec_sua.unit_cd,

Line 1276: igs_en_su_attempt_pkg.pkg_source_of_drop := NULL;

1272: END LOOP; -- While loop
1273: END IF;
1274:
1275: -- Unsetting the package variable after dropping SUA.
1276: igs_en_su_attempt_pkg.pkg_source_of_drop := NULL;
1277:
1278:
1279: l_display_rule := NVL(fnd_profile.value('IGS_EN_CART_RULE_DISPLAY'),'N');
1280:

Line 1484: igs_en_su_attempt_pkg.delete_row ( X_ROWID => rec_del.row_id,

1480: AND sua.uoo_id = cp_uoo_id;
1481:
1482: BEGIN
1483: FOR rec_del IN c_del(p_person_id, p_course_cd, p_uoo_id) LOOP
1484: igs_en_su_attempt_pkg.delete_row ( X_ROWID => rec_del.row_id,
1485: X_MODE => 'R');
1486: END LOOP;
1487: END sua_delete;
1488:

Line 1682: igs_en_su_attempt_pkg.delete_row(X_ROWID => rec_sua.row_id,

1678: END LOOP;
1679:
1680: FOR rec_sua IN c_sua(p_n_person_id,p_c_program_code,p_c_load_cal,p_n_load_seq_num) LOOP
1681:
1682: igs_en_su_attempt_pkg.delete_row(X_ROWID => rec_sua.row_id,
1683: x_mode => 'R');
1684: END LOOP;
1685:
1686: COMMIT;

Line 2004: igs_en_su_attempt_pkg.lock_row(

2000: -------------------------------------------------------------------
2001: IS
2002: PRAGMA AUTONOMOUS_TRANSACTION;
2003: BEGIN
2004: igs_en_su_attempt_pkg.lock_row(
2005: X_ROWID => X_ROWID,
2006: X_PERSON_ID => p_person_id,
2007: X_COURSE_CD => p_course_cd,
2008: X_UNIT_CD => X_UNIT_CD,