eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_EN_SU_ATTEMPT_PKG dependencies on IGS_EN_SU_ATTEMPT_PKG

Line 1: PACKAGE BODY Igs_En_Su_Attempt_Pkg AS

1: PACKAGE BODY Igs_En_Su_Attempt_Pkg AS
2: /* $Header: IGSEI36B.pls 120.22 2006/03/02 03:30:18 bdeviset ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_EN_SU_ATTEMPT_ALL%ROWTYPE;

Line 492: IF IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop IS NULL OR IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop <> 'PLAN' THEN

488:
489: END IF;
490: IF p_inserting OR p_updating THEN
491:
492: IF IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop IS NULL OR IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop <> 'PLAN' THEN
493:
494: IF p_inserting THEN
495:
496: -- Validate that discontinued date is not entered when p_inserting

Line 719: END IF; --IF IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop IS NULL OR IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop <> 'PLAN' THEN

715: APP_EXCEPTION.RAISE_EXCEPTION;
716: END IF;
717: END IF;
718:
719: END IF; --IF IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop IS NULL OR IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop <> 'PLAN' THEN
720:
721: -- Validate that advanced standing does not already exist
722: IF p_inserting OR
723: (p_updating AND

Line 745: IF IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop IS NULL OR IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop <> 'PLAN' THEN

741: APP_EXCEPTION.RAISE_EXCEPTION;
742: END IF;
743: END IF;
744:
745: IF IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop IS NULL OR IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop <> 'PLAN' THEN
746:
747: -- Set IGS_PS_UNIT attempt status
748: IF new_references.unit_attempt_status IS NULL THEN
749: v_unit_attempt_status := 'Unknown';

Line 842: END IF; -- IF IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop IS NULL OR IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop <> 'PLAN' THEN

838: -- Validate that teaching period is not prior to commencement date
839: -- with the exception of DUPLICATE IGS_PS_UNIT attempts
840: END IF;
841:
842: END IF; -- IF IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop IS NULL OR IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop <> 'PLAN' THEN
843:
844: IF p_inserting THEN
845: IF IGS_EN_VAL_SUA.enrp_val_sua_ci(
846: new_references.person_id,

Line 884: IF IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop IS NULL OR IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop <> 'PLAN' THEN

880: END IF;
881: END IF;
882:
883:
884: IF IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop IS NULL OR IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop <> 'PLAN' THEN
885: -- Save rowid and old discontinuation date
886: -- if discontinuation details change
887:
888: IF p_updating THEN

Line 985: END IF; --IF IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop IS NULL OR IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop <> 'PLAN' THEN

981: IGS_GE_MSG_STACK.ADD;
982: APP_EXCEPTION.RAISE_EXCEPTION;
983: END IF;
984: END IF;
985: END IF; --IF IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop IS NULL OR IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop <> 'PLAN' THEN
986:
987: -- Validate override enrolled and achievable credit points
988: IF new_references.no_assessment_ind <> 'Y' THEN
989: --skip validation of override enrolled and achievable credit points for audited record

Line 1054: IF IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop IS NULL OR IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop <> 'PLAN' THEN

1050: CLOSE cur_sub_uoo;
1051:
1052: END IF;
1053:
1054: IF IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop IS NULL OR IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop <> 'PLAN' THEN
1055:
1056: -- If required add a todo entry to forced the re-checking of the IGS_PS_UNIT IGS_RU_RULEs
1057: -- for the student. This is done in insert of a new ENROLLED/INVALID IGS_PS_UNIT
1058: -- attempt, on the confirmation of a IGS_PS_UNIT attempt or on lifting of a

Line 1169: END IF; -- IF IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop IS NULL OR IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop <> 'PLAN' THEN

1165: END IF;
1166: CLOSE cur_placement_unit;
1167: END IF;
1168: END IF;
1169: END IF; -- IF IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop IS NULL OR IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop <> 'PLAN' THEN
1170:
1171: END IF; -- IF p_inserting OR p_updating THEN
1172: IF p_deleting THEN
1173:

Line 1502: when IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop = 'PLAN' since Plaaning Sheet Records

1498: BEGIN
1499:
1500: /* WHO WHEN WHAT
1501: ckasu 27-NOV-2005 Added logic inorder toby pass validation IGS_LOOKUPS_VIEW_PKG.GET_PK_FOR_VALIDATION
1502: when IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop = 'PLAN' since Plaaning Sheet Records
1503: are created in 'PLANNED' Status which is not a looup value as a part of bug#4666102
1504:
1505: */
1506:

Line 1507: IF igs_en_su_attempt_pkg.pkg_source_of_drop = 'SWAP' THEN

1503: are created in 'PLANNED' Status which is not a looup value as a part of bug#4666102
1504:
1505: */
1506:
1507: IF igs_en_su_attempt_pkg.pkg_source_of_drop = 'SWAP' THEN
1508: RETURN;
1509: END IF;
1510: IF (((old_references.administrative_unit_status= new_references.administrative_unit_status)) OR
1511: ((new_references.administrative_unit_status IS NULL))) THEN

Line 1593: ((new_references.unit_attempt_status IS NULL)) OR (IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop IS NOT NULL

1589: IGS_GE_MSG_STACK.ADD;
1590: APP_EXCEPTION.RAISE_EXCEPTION;
1591: END IF;
1592: IF (((old_references.unit_attempt_status = new_references.unit_attempt_status)) OR
1593: ((new_references.unit_attempt_status IS NULL)) OR (IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop IS NOT NULL
1594: AND IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop = 'PLAN') ) THEN
1595: NULL;
1596: ELSIF NOT IGS_LOOKUPS_VIEW_PKG.GET_PK_FOR_VALIDATION('UNIT_ATTEMPT_STATUS',
1597: new_references.unit_attempt_status) THEN

Line 1594: AND IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop = 'PLAN') ) THEN

1590: APP_EXCEPTION.RAISE_EXCEPTION;
1591: END IF;
1592: IF (((old_references.unit_attempt_status = new_references.unit_attempt_status)) OR
1593: ((new_references.unit_attempt_status IS NULL)) OR (IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop IS NOT NULL
1594: AND IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop = 'PLAN') ) THEN
1595: NULL;
1596: ELSIF NOT IGS_LOOKUPS_VIEW_PKG.GET_PK_FOR_VALIDATION('UNIT_ATTEMPT_STATUS',
1597: new_references.unit_attempt_status) THEN
1598: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');

Line 2332: END IF; -- IF NVL(X_SS_SOURCE_IND,'N') <> 'S' OR (IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop IS NOT NULL AND IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop = 'PLAN') THEN

2328: p_course_cd => x_course_cd,
2329: p_uoo_id => x_uoo_id);
2330:
2331:
2332: END IF; -- IF NVL(X_SS_SOURCE_IND,'N') <> 'S' OR (IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop IS NOT NULL AND IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop = 'PLAN') THEN
2333: END IF;
2334:
2335: IF (p_action = 'INSERT') THEN
2336: -- Call all the procedures related to Before Insert.

Line 2342: IF IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop IS NULL OR IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop <> 'PLAN' THEN

2338: BeforeRowInsertUpdateDelete1 ( p_inserting => TRUE,
2339: p_updating => FALSE,
2340: p_deleting => FALSE );
2341:
2342: IF IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop IS NULL OR IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop <> 'PLAN' THEN
2343:
2344: BeforeRowInsertUpdateDelete2 ( p_inserting => TRUE,
2345: p_updating => FALSE,
2346: p_deleting => FALSE);

Line 2348: END IF; --IF IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop IS NULL OR IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop <> 'PLAN' THEN

2344: BeforeRowInsertUpdateDelete2 ( p_inserting => TRUE,
2345: p_updating => FALSE,
2346: p_deleting => FALSE);
2347:
2348: END IF; --IF IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop IS NULL OR IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop <> 'PLAN' THEN
2349:
2350: IF Get_PK_For_Validation (
2351: NEW_REFERENCES.person_id,
2352: NEW_REFERENCES.course_cd,

Line 2374: IF IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop IS NULL OR IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop <> 'PLAN' THEN

2370: -- Call all the procedures related to Before Update.
2371: BeforeRowInsertUpdateDelete1 ( p_inserting => FALSE,
2372: p_updating => TRUE,
2373: p_deleting => FALSE);
2374: IF IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop IS NULL OR IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop <> 'PLAN' THEN
2375:
2376: BeforeRowInsertUpdateDelete2 ( p_inserting => FALSE,
2377: p_updating => TRUE ,
2378: p_deleting => FALSE);

Line 2379: END IF;--IF IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop IS NULL OR IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop <> 'PLAN' THEN

2375:
2376: BeforeRowInsertUpdateDelete2 ( p_inserting => FALSE,
2377: p_updating => TRUE ,
2378: p_deleting => FALSE);
2379: END IF;--IF IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop IS NULL OR IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop <> 'PLAN' THEN
2380:
2381: Check_Constraints;
2382: Check_Parent_Existance;
2383: Check_Uniqueness;

Line 2621: IF IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop IS NULL OR IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop <> 'PLAN' THEN

2617: END IF; --IF old_references.unit_attempt_status <> new_references.unit_attempt_status THEN
2618:
2619: END IF; -- end of IF (p_action = 'UPDATE') THEN
2620:
2621: IF IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop IS NULL OR IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop <> 'PLAN' THEN
2622:
2623:
2624: l_rowid := x_rowid;
2625: IF (p_action = 'INSERT') THEN

Line 2673: IF NVL(igs_en_su_attempt_pkg.pkg_source_of_drop,'NULL') NOT IN ( 'SWAP','DROP') THEN

2669:
2670: -- modified this condition to include DROP also for bug#4864437
2671: -- this code is being commented here but will be replicated in swap page and Drop page
2672: -- SwapAMImpl.java :swapSubmit , StdDropAMImpl.java:dropSubmit
2673: IF NVL(igs_en_su_attempt_pkg.pkg_source_of_drop,'NULL') NOT IN ( 'SWAP','DROP') THEN
2674:
2675: AfterRowInsertUpdateDelete3 ( p_inserting => FALSE,
2676: p_updating => TRUE,
2677: p_deleting => FALSE );

Line 2710: igs_en_su_attempt_pkg.update_row(

2706: FOR l_sua_details IN c_sua_details(new_references.uoo_id) LOOP
2707: IF l_cnt <> NVL(l_sua_details.administrative_priority,0) THEN
2708: l_sua_details.administrative_priority := l_cnt;
2709: BEGIN
2710: igs_en_su_attempt_pkg.update_row(
2711: X_ROWID => l_sua_details.row_id ,
2712: X_PERSON_ID => l_sua_details.person_id ,
2713: X_COURSE_CD => l_sua_details.course_cd ,
2714: X_UNIT_CD => l_sua_details.unit_cd ,

Line 2805: END IF; --IF IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop IS NULL OR IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop <> 'PLAN' THEN

2801: END IF;
2802:
2803: END IF;
2804:
2805: END IF; --IF IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop IS NULL OR IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop <> 'PLAN' THEN
2806:
2807: IF (p_action = 'DELETE') THEN
2808: -- Call all the procedures related to After Delete.
2809: AfterRowInsertUpdateDelete3 ( p_inserting => FALSE,

Line 2858: IF IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop IS NULL OR IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop <> 'PLAN' THEN

2854: END IF; --renroll check
2855: END IF; --l_repeatable_unit
2856: END IF;
2857:
2858: IF IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop IS NULL OR IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop <> 'PLAN' THEN
2859:
2860: IF (p_action = 'UPDATE') THEN
2861: IF (old_references.unit_attempt_status <> new_references.unit_attempt_status) AND
2862: (new_references.unit_attempt_status IN ('DROPPED', 'DISCONTIN')) THEN

Line 2974: END IF; -- IF IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop IS NULL OR IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop <> 'PLAN' THEN

2970: x_plan_sht_status =>'SKIP');
2971: END LOOP;
2972: END IF;
2973:
2974: END IF; -- IF IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop IS NULL OR IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop <> 'PLAN' THEN
2975:
2976: END After_DML;
2977: --
2978: PROCEDURE INSERT_ROW (

Line 4846: END Igs_En_Su_Attempt_Pkg;

4842: END IF;
4843: END IF;
4844: END update_reserved_seat;
4845:
4846: END Igs_En_Su_Attempt_Pkg;