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_FI_GET_SCAEH dependencies on IGS_PS_COURSE

Line 7: p_course_cd IN IGS_PS_COURSE.course_cd%TYPE ,

3: --
4: -- Routine to save SCA effective history data in a PL/SQL RECORD.
5: PROCEDURE FINP_GET_SCAEH(
6: p_person_id IN NUMBER ,
7: p_course_cd IN IGS_PS_COURSE.course_cd%TYPE ,
8: p_effective_dt IN DATE ,
9: p_data_found OUT NOCOPY BOOLEAN ,
10: p_scaeh_dtl IN OUT NOCOPY IGS_AS_SC_ATTEMPT_H_ALL%ROWTYPE )
11: AS

Line 15: -- cursor to get the current student IGS_PS_COURSE attempt status

11: AS
12: gv_other_detail VARCHAR2(255);
13: BEGIN
14: DECLARE
15: -- cursor to get the current student IGS_PS_COURSE attempt status
16: CURSOR c_sca IS
17: SELECT *
18: FROM IGS_EN_STDNT_PS_ATT sca
19: WHERE sca.person_id = p_person_id AND

Line 591: -- the transitions between IGS_PS_COURSE status's are;

587: END finpl_prc_sca_enrhist;
588: -------------------------------------------------------------------------------
589: BEGIN -- finp_get_scaeh
590: -- effective history logic is based upon the following assumptions -
591: -- the transitions between IGS_PS_COURSE status's are;
592: -- UNCONFIRM -> ENROLLED
593: -- -> DELETED
594: -- -> INACTIVE
595: --

Line 657: -- get the current student IGS_PS_COURSE attempt details

653: gv_person_id := p_person_id;
654: gv_course_cd := p_course_cd;
655: gv_effective_dt :=igs_ge_date.igsdate(igs_ge_date.igschar(p_effective_dt)|| '23:59:59');
656: p_data_found := FALSE;
657: -- get the current student IGS_PS_COURSE attempt details
658: OPEN c_sca;
659: FETCH c_sca INTO r_sca;
660: IF (c_sca%NOTFOUND) THEN
661: CLOSE c_sca;

Line 675: -- save the current student IGS_PS_COURSE attempt data

671: 'LAPSED',
672: 'INACTIVE') THEN
673: -- check if commencing on or before the effective date
674: IF TRUNC(r_sca.commencement_dt) <= TRUNC(gv_effective_dt) THEN
675: -- save the current student IGS_PS_COURSE attempt data
676: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before finpl_ins_sca_rec');
677: finpl_ins_sca_rec(
678: r_sca.commencement_dt,
679: gv_effective_dt,

Line 683: -- save the current student IGS_PS_COURSE attempt data as an

679: gv_effective_dt,
680: r_sca);
681: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after finpl_ins_sca_rec');
682: ELSE
683: -- save the current student IGS_PS_COURSE attempt data as an
684: -- unconfirmed history
685: r_sca.course_attempt_status := 'UNCONFIRM';
686: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before finpl_ins_sca_rec');
687: finpl_ins_sca_rec(

Line 694: -- save the current student IGS_PS_COURSE attempt data

690: r_sca);
691: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after finpl_ins_sca_rec');
692: END IF;
693: ELSIF r_sca.course_attempt_status = 'DISCONTIN' THEN
694: -- save the current student IGS_PS_COURSE attempt data
695: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before finpl_ins_sca_rec');
696: finpl_ins_sca_rec(
697: r_sca.discontinued_dt,
698: gv_effective_dt,

Line 702: -- save the current student IGS_PS_COURSE attempt data

698: gv_effective_dt,
699: r_sca);
700: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after finpl_ins_sca_rec');
701: ELSIF r_sca.course_attempt_status = 'UNCONFIRM' THEN
702: -- save the current student IGS_PS_COURSE attempt data
703: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before finpl_ins_sca_rec');
704: finpl_ins_sca_rec(
705: r_sca.LAST_UPDATE_DATE,
706: gv_effective_dt,

Line 717: -- check if effective date falls within a student IGS_PS_COURSE attempt history

713: END IF;
714: RETURN;
715: END IF;
716: -- process history effective up until the current day
717: -- check if effective date falls within a student IGS_PS_COURSE attempt history
718: OPEN c_scah(gv_effective_dt);
719: FETCH c_scah INTO r_scah;
720: IF (c_scah%FOUND) THEN
721: v_scah_found := TRUE;

Line 744: -- save the student IGS_PS_COURSE attempt history data

740: IF v_scah_found = TRUE THEN
741: IF r_scah.course_attempt_status IN (
742: 'ENROLLED',
743: 'INTERMIT') THEN
744: -- save the student IGS_PS_COURSE attempt history data
745: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before finpl_ins_scah_rec');
746: finpl_ins_scah_rec(
747: r_scah,
748: r_sca);

Line 751: -- save the current student IGS_PS_COURSE attempt data

747: r_scah,
748: r_sca);
749: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after finpl_ins_scah_rec');
750: ELSE -- enrolment overrides history
751: -- save the current student IGS_PS_COURSE attempt data
752: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before finpl_ins_sca_rec');
753: finpl_ins_sca_rec(r_sca.commencement_dt,
754: SYSDATE,
755: r_sca);

Line 759: -- save the current student IGS_PS_COURSE attempt data

755: r_sca);
756: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after finpl_ins_sca_rec');
757: END IF;
758: ELSE -- no matching history
759: -- save the current student IGS_PS_COURSE attempt data
760: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before finpl_ins_sca_rec');
761: finpl_ins_sca_rec(r_sca.commencement_dt,
762: SYSDATE,
763: r_sca);

Line 766: ELSE -- prior to student IGS_PS_COURSE attempt commencement

762: SYSDATE,
763: r_sca);
764: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after finpl_ins_sca_rec');
765: END IF;
766: ELSE -- prior to student IGS_PS_COURSE attempt commencement
767: IF v_scah_found = TRUE THEN
768: IF r_scah.course_attempt_status IN ('UNCONFIRM') THEN
769: -- save the student IGS_PS_COURSE attempt history data
770: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before finpl_ins_scah_rec');

Line 769: -- save the student IGS_PS_COURSE attempt history data

765: END IF;
766: ELSE -- prior to student IGS_PS_COURSE attempt commencement
767: IF v_scah_found = TRUE THEN
768: IF r_scah.course_attempt_status IN ('UNCONFIRM') THEN
769: -- save the student IGS_PS_COURSE attempt history data
770: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before finpl_ins_scah_rec');
771: finpl_ins_scah_rec(
772: r_scah,
773: r_sca);

Line 791: -- save the student IGS_PS_COURSE attempt history data

787: IF r_scah.course_attempt_status IN (
788: 'COMPLETED',
789: 'ENROLLED',
790: 'INTERMIT') THEN
791: -- save the student IGS_PS_COURSE attempt history data
792:
793: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before finpl_ins_scah_rec');
794: finpl_ins_scah_rec(
795: r_scah,

Line 812: ELSE -- prior to student IGS_PS_COURSE attempt commencement

808: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before finpl_prc_sca_enrhist');
809: finpl_prc_sca_enrhist(r_sca);
810: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after finpl_prc_sca_enrhist');
811: END IF;
812: ELSE -- prior to student IGS_PS_COURSE attempt commencement
813: IF v_scah_found = TRUE THEN
814: IF r_scah.course_attempt_status IN ('UNCONFIRM') THEN
815: -- save the student IGS_PS_COURSE attempt history data
816: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before finpl_ins_scah_rec');

Line 815: -- save the student IGS_PS_COURSE attempt history data

811: END IF;
812: ELSE -- prior to student IGS_PS_COURSE attempt commencement
813: IF v_scah_found = TRUE THEN
814: IF r_scah.course_attempt_status IN ('UNCONFIRM') THEN
815: -- save the student IGS_PS_COURSE attempt history data
816: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before finpl_ins_scah_rec');
817: finpl_ins_scah_rec(
818: r_scah,
819: r_sca);

Line 834: -- save the student IGS_PS_COURSE attempt history data

830: -- discontinuation period
831: IF TRUNC(gv_effective_dt) >= TRUNC(r_sca.discontinued_dt) THEN
832: IF v_scah_found = TRUE THEN
833: IF r_scah.course_attempt_status = 'DISCONTIN' THEN
834: -- save the student IGS_PS_COURSE attempt history data
835: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before finpl_ins_scah_rec');
836: finpl_ins_scah_rec(
837: r_scah,
838: r_sca);

Line 841: -- save the current student IGS_PS_COURSE attempt data

837: r_scah,
838: r_sca);
839: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after finpl_ins_scah_rec');
840: ELSE -- discontinuation overrides the history
841: -- save the current student IGS_PS_COURSE attempt data
842: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before finpl_ins_sca_rec');
843: finpl_ins_sca_rec(r_sca.discontinued_dt,
844: SYSDATE,
845: r_sca);

Line 849: -- save the current student IGS_PS_COURSE attempt data

845: r_sca);
846: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after finpl_ins_sca_rec');
847: END IF;
848: ELSE -- no matching history
849: -- save the current student IGS_PS_COURSE attempt data
850: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before finpl_ins_sca_rec');
851: finpl_ins_sca_rec(r_sca.discontinued_dt,
852: SYSDATE,
853: r_sca);

Line 856: ELSE -- prior to student IGS_PS_COURSE attempt discontinuation

852: SYSDATE,
853: r_sca);
854: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after finpl_ins_sca_rec');
855: END IF;
856: ELSE -- prior to student IGS_PS_COURSE attempt discontinuation
857: IF gv_effective_dt >= TRUNC(r_sca.commencement_dt) THEN
858: -- within the enrolled period
859: IF v_scah_found = TRUE THEN
860: IF r_scah.course_attempt_status IN (

Line 865: -- save the student IGS_PS_COURSE attempt history data

861: 'ENROLLED',
862: 'LAPSED',
863: 'INACTIVE',
864: 'INTERMIT') THEN
865: -- save the student IGS_PS_COURSE attempt history data
866: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before finpl_ins_scah_rec');
867: finpl_ins_scah_rec(
868: r_scah,
869: r_sca);

Line 885: ELSE -- prior to student IGS_PS_COURSE attempt commencement

881: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before finpl_prc_sca_enrhist');
882: finpl_prc_sca_enrhist(r_sca);
883: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after finpl_prc_sca_enrhist');
884: END IF;
885: ELSE -- prior to student IGS_PS_COURSE attempt commencement
886: IF v_scah_found = TRUE THEN
887: IF r_scah.course_attempt_status IN ('UNCONFIRM') THEN
888: -- save the student IGS_PS_COURSE attempt history data
889: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before finpl_ins_scah_rec');

Line 888: -- save the student IGS_PS_COURSE attempt history data

884: END IF;
885: ELSE -- prior to student IGS_PS_COURSE attempt commencement
886: IF v_scah_found = TRUE THEN
887: IF r_scah.course_attempt_status IN ('UNCONFIRM') THEN
888: -- save the student IGS_PS_COURSE attempt history data
889: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before finpl_ins_scah_rec');
890: finpl_ins_scah_rec(
891: r_scah,
892: r_sca);

Line 905: -- save the student IGS_PS_COURSE attempt history data

901: END IF;
902: ELSIF r_sca.course_attempt_status = 'UNCONFIRM' THEN
903: IF v_scah_found = TRUE THEN
904: IF r_scah.course_attempt_status = 'UNCONFIRM' THEN
905: -- save the student IGS_PS_COURSE attempt history data
906: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before finpl_ins_scah_rec');
907: finpl_ins_scah_rec(
908: r_scah,
909: r_sca);

Line 912: -- save the current student IGS_PS_COURSE attempt data

908: r_scah,
909: r_sca);
910: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('a finpl_ins_scah_rec');
911: ELSE -- unconfirm overrides history
912: -- save the current student IGS_PS_COURSE attempt data
913: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('b finpl_ins_sca_rec');
914: finpl_ins_sca_rec(gv_effective_dt,
915: SYSDATE,
916: r_sca);

Line 921: -- student IGS_PS_COURSE attempt was created and today

917: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('a finpl_ins_sca_rec');
918: END IF;
919: ELSE -- no matching history
920: -- check if the effective date falls within the period the
921: -- student IGS_PS_COURSE attempt was created and today
922: IF TRUNC(gv_effective_dt) >= TRUNC(r_sca.LAST_UPDATE_DATE) THEN
923: -- save the current student IGS_PS_COURSE attempt data
924: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('b finpl_ins_sca_rec');
925: finpl_ins_sca_rec(r_sca.LAST_UPDATE_DATE,

Line 923: -- save the current student IGS_PS_COURSE attempt data

919: ELSE -- no matching history
920: -- check if the effective date falls within the period the
921: -- student IGS_PS_COURSE attempt was created and today
922: IF TRUNC(gv_effective_dt) >= TRUNC(r_sca.LAST_UPDATE_DATE) THEN
923: -- save the current student IGS_PS_COURSE attempt data
924: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('b finpl_ins_sca_rec');
925: finpl_ins_sca_rec(r_sca.LAST_UPDATE_DATE,
926: SYSDATE,
927: r_sca);

Line 929: ELSE -- prior to student IGS_PS_COURSE attempt record creation

925: finpl_ins_sca_rec(r_sca.LAST_UPDATE_DATE,
926: SYSDATE,
927: r_sca);
928: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('a finpl_ins_sca_rec');
929: ELSE -- prior to student IGS_PS_COURSE attempt record creation
930: RETURN;
931: END IF;
932: END IF;
933: ELSIF r_sca.course_attempt_status IN (

Line 946: -- save the student IGS_PS_COURSE attempt history data

942: 'ENROLLED',
943: 'LAPSED',
944: 'INACTIVE',
945: 'INTERMIT') THEN
946: -- save the student IGS_PS_COURSE attempt history data
947: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('b finpl_ins_scah_rec');
948: finpl_ins_scah_rec(
949: r_scah,
950: r_sca);

Line 966: ELSE -- prior to student IGS_PS_COURSE attempt commencement

962: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('b finpl_prc_sca_enrhist');
963: finpl_prc_sca_enrhist(r_sca);
964: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('a finpl_prc_sca_enrhist');
965: END IF;
966: ELSE -- prior to student IGS_PS_COURSE attempt commencement
967: IF v_scah_found = TRUE THEN
968: IF r_scah.course_attempt_status IN ('UNCONFIRM') THEN
969: -- save the student IGS_PS_COURSE attempt history data
970: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('b finpl_ins_scah_rec');

Line 969: -- save the student IGS_PS_COURSE attempt history data

965: END IF;
966: ELSE -- prior to student IGS_PS_COURSE attempt commencement
967: IF v_scah_found = TRUE THEN
968: IF r_scah.course_attempt_status IN ('UNCONFIRM') THEN
969: -- save the student IGS_PS_COURSE attempt history data
970: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('b finpl_ins_scah_rec');
971: finpl_ins_scah_rec(
972: r_scah,
973: r_sca);

Line 986: -- save the student IGS_PS_COURSE attempt history data

982: ELSIF r_sca.course_attempt_status = 'DELETED' THEN
983: IF v_scah_found = TRUE THEN
984: IF r_scah.course_attempt_status IN ('DELETED',
985: 'UNCONFIRM') THEN
986: -- save the student IGS_PS_COURSE attempt history data
987: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('b finpl_ins_scah_rec');
988: finpl_ins_scah_rec(
989: r_scah,
990: r_sca);

Line 993: -- save the current student IGS_PS_COURSE attempt data

989: r_scah,
990: r_sca);
991: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('a finpl_ins_scah_rec');
992: ELSE -- delete overrides history
993: -- save the current student IGS_PS_COURSE attempt data
994: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('b finpl_ins_sca_rec');
995: finpl_ins_sca_rec( gv_effective_dt,
996: SYSDATE,
997: r_sca);

Line 1002: -- student IGS_PS_COURSE attempt was created and today

998: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('a finpl_ins_sca_rec');
999: END IF;
1000: ELSE
1001: -- check if the effective date falls within the period the
1002: -- student IGS_PS_COURSE attempt was created and today
1003: IF TRUNC(gv_effective_dt) >= TRUNC(r_sca.LAST_UPDATE_DATE) THEN
1004: -- save the current student IGS_PS_COURSE attempt data
1005: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('b finpl_ins_sca_rec');
1006: finpl_ins_sca_rec( r_sca.LAST_UPDATE_DATE,

Line 1004: -- save the current student IGS_PS_COURSE attempt data

1000: ELSE
1001: -- check if the effective date falls within the period the
1002: -- student IGS_PS_COURSE attempt was created and today
1003: IF TRUNC(gv_effective_dt) >= TRUNC(r_sca.LAST_UPDATE_DATE) THEN
1004: -- save the current student IGS_PS_COURSE attempt data
1005: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('b finpl_ins_sca_rec');
1006: finpl_ins_sca_rec( r_sca.LAST_UPDATE_DATE,
1007: SYSDATE,
1008: r_sca);

Line 1010: ELSE -- prior to student IGS_PS_COURSE attempt record creation

1006: finpl_ins_sca_rec( r_sca.LAST_UPDATE_DATE,
1007: SYSDATE,
1008: r_sca);
1009: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('a finpl_ins_sca_rec');
1010: ELSE -- prior to student IGS_PS_COURSE attempt record creation
1011: RETURN;
1012: END IF;
1013: END IF;
1014: ELSE -- unrecognised status