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_GEN_LEGACY dependencies on IGS_EN_STDNT_PS_ATT

Line 246: FROM igs_en_stdnt_ps_att spa , igs_en_dcnt_reasoncd disc

242: --
243: -- Cursor to get the type of discontinuation reason code of a program
244: CURSOR get_prgm_reasn IS
245: SELECT 'x'
246: FROM igs_en_stdnt_ps_att spa , igs_en_dcnt_reasoncd disc
247: WHERE spa.person_id = p_person_id AND
248: spa.course_cd = p_transfer_program_cd AND
249: disc.discontinuation_reason_cd = spa.discontinuation_reason_cd AND
250: disc.s_discontinuation_reason_type = 'TRANSFER';

Line 256: FROM igs_en_stdnt_ps_att sca

252: --
253: -- Cursor to get the program attempt status of the Source Transfer Program
254: CURSOR get_prgm_stat IS
255: SELECT sca.course_attempt_status
256: FROM igs_en_stdnt_ps_att sca
257: WHERE sca.course_cd = p_transfer_program_cd
258: AND sca.person_id = p_person_id;
259:
260: l_dummy VARCHAR2(1) := NULL;

Line 261: l_course_attempt_status igs_en_stdnt_ps_att.course_attempt_status%TYPE;

257: WHERE sca.course_cd = p_transfer_program_cd
258: AND sca.person_id = p_person_id;
259:
260: l_dummy VARCHAR2(1) := NULL;
261: l_course_attempt_status igs_en_stdnt_ps_att.course_attempt_status%TYPE;
262:
263: BEGIN
264:
265: OPEN get_prgm_stat ;

Line 509: FROM igs_en_stdnt_ps_att

505: --
506: -- cursor to fetch SPA details
507: CURSOR get_prgm_stats IS
508: SELECT student_confirmed_ind , course_attempt_status , discontinued_dt , primary_program_type , commencement_dt , version_number
509: FROM igs_en_stdnt_ps_att
510: WHERE person_id = p_person_id AND
511: course_cd = p_course_cd ;
512:
513: cst_unconfirm CONSTANT VARCHAR2(10) := 'UNCONFIRM';

Line 516: l_prgm_stats igs_en_stdnt_ps_att.course_attempt_status%TYPE;

512:
513: cst_unconfirm CONSTANT VARCHAR2(10) := 'UNCONFIRM';
514: cst_discontin CONSTANT VARCHAR2(10) := 'DISCONTIN';
515:
516: l_prgm_stats igs_en_stdnt_ps_att.course_attempt_status%TYPE;
517: l_confirmed_ind igs_en_stdnt_ps_att.student_confirmed_ind%TYPE;
518:
519: BEGIN
520:

Line 517: l_confirmed_ind igs_en_stdnt_ps_att.student_confirmed_ind%TYPE;

513: cst_unconfirm CONSTANT VARCHAR2(10) := 'UNCONFIRM';
514: cst_discontin CONSTANT VARCHAR2(10) := 'DISCONTIN';
515:
516: l_prgm_stats igs_en_stdnt_ps_att.course_attempt_status%TYPE;
517: l_confirmed_ind igs_en_stdnt_ps_att.student_confirmed_ind%TYPE;
518:
519: BEGIN
520:
521: OPEN get_prgm_stats ;

Line 759: p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,

755: APP_EXCEPTION.RAISE_EXCEPTION;
756: END get_class_std_id;
757:
758: FUNCTION get_course_att_status(
759: p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,
760: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,
761: p_student_confirmed_ind IN igs_en_stdnt_ps_att.student_confirmed_ind%TYPE,
762: p_discontinued_dt IN igs_en_stdnt_ps_att.discontinued_dt%TYPE,
763: p_lapsed_dt IN igs_en_stdnt_ps_att.lapsed_dt%TYPE,

Line 760: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,

756: END get_class_std_id;
757:
758: FUNCTION get_course_att_status(
759: p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,
760: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,
761: p_student_confirmed_ind IN igs_en_stdnt_ps_att.student_confirmed_ind%TYPE,
762: p_discontinued_dt IN igs_en_stdnt_ps_att.discontinued_dt%TYPE,
763: p_lapsed_dt IN igs_en_stdnt_ps_att.lapsed_dt%TYPE,
764: p_course_rqrmnt_complete_ind IN igs_en_stdnt_ps_att.course_rqrmnt_complete_ind%TYPE,

Line 761: p_student_confirmed_ind IN igs_en_stdnt_ps_att.student_confirmed_ind%TYPE,

757:
758: FUNCTION get_course_att_status(
759: p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,
760: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,
761: p_student_confirmed_ind IN igs_en_stdnt_ps_att.student_confirmed_ind%TYPE,
762: p_discontinued_dt IN igs_en_stdnt_ps_att.discontinued_dt%TYPE,
763: p_lapsed_dt IN igs_en_stdnt_ps_att.lapsed_dt%TYPE,
764: p_course_rqrmnt_complete_ind IN igs_en_stdnt_ps_att.course_rqrmnt_complete_ind%TYPE,
765: p_primary_pg_type IN igs_en_stdnt_ps_att.primary_program_type%TYPE,

Line 762: p_discontinued_dt IN igs_en_stdnt_ps_att.discontinued_dt%TYPE,

758: FUNCTION get_course_att_status(
759: p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,
760: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,
761: p_student_confirmed_ind IN igs_en_stdnt_ps_att.student_confirmed_ind%TYPE,
762: p_discontinued_dt IN igs_en_stdnt_ps_att.discontinued_dt%TYPE,
763: p_lapsed_dt IN igs_en_stdnt_ps_att.lapsed_dt%TYPE,
764: p_course_rqrmnt_complete_ind IN igs_en_stdnt_ps_att.course_rqrmnt_complete_ind%TYPE,
765: p_primary_pg_type IN igs_en_stdnt_ps_att.primary_program_type%TYPE,
766: p_primary_prog_type_source IN igs_en_stdnt_ps_att.primary_prog_type_source%TYPE,

Line 763: p_lapsed_dt IN igs_en_stdnt_ps_att.lapsed_dt%TYPE,

759: p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,
760: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,
761: p_student_confirmed_ind IN igs_en_stdnt_ps_att.student_confirmed_ind%TYPE,
762: p_discontinued_dt IN igs_en_stdnt_ps_att.discontinued_dt%TYPE,
763: p_lapsed_dt IN igs_en_stdnt_ps_att.lapsed_dt%TYPE,
764: p_course_rqrmnt_complete_ind IN igs_en_stdnt_ps_att.course_rqrmnt_complete_ind%TYPE,
765: p_primary_pg_type IN igs_en_stdnt_ps_att.primary_program_type%TYPE,
766: p_primary_prog_type_source IN igs_en_stdnt_ps_att.primary_prog_type_source%TYPE,
767: p_course_type IN igs_ps_type.course_type%TYPE,

Line 764: p_course_rqrmnt_complete_ind IN igs_en_stdnt_ps_att.course_rqrmnt_complete_ind%TYPE,

760: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,
761: p_student_confirmed_ind IN igs_en_stdnt_ps_att.student_confirmed_ind%TYPE,
762: p_discontinued_dt IN igs_en_stdnt_ps_att.discontinued_dt%TYPE,
763: p_lapsed_dt IN igs_en_stdnt_ps_att.lapsed_dt%TYPE,
764: p_course_rqrmnt_complete_ind IN igs_en_stdnt_ps_att.course_rqrmnt_complete_ind%TYPE,
765: p_primary_pg_type IN igs_en_stdnt_ps_att.primary_program_type%TYPE,
766: p_primary_prog_type_source IN igs_en_stdnt_ps_att.primary_prog_type_source%TYPE,
767: p_course_type IN igs_ps_type.course_type%TYPE,
768: p_career_flag IN VARCHAR2)

Line 765: p_primary_pg_type IN igs_en_stdnt_ps_att.primary_program_type%TYPE,

761: p_student_confirmed_ind IN igs_en_stdnt_ps_att.student_confirmed_ind%TYPE,
762: p_discontinued_dt IN igs_en_stdnt_ps_att.discontinued_dt%TYPE,
763: p_lapsed_dt IN igs_en_stdnt_ps_att.lapsed_dt%TYPE,
764: p_course_rqrmnt_complete_ind IN igs_en_stdnt_ps_att.course_rqrmnt_complete_ind%TYPE,
765: p_primary_pg_type IN igs_en_stdnt_ps_att.primary_program_type%TYPE,
766: p_primary_prog_type_source IN igs_en_stdnt_ps_att.primary_prog_type_source%TYPE,
767: p_course_type IN igs_ps_type.course_type%TYPE,
768: p_career_flag IN VARCHAR2)
769: RETURN igs_en_stdnt_ps_att.course_attempt_status%TYPE AS

Line 766: p_primary_prog_type_source IN igs_en_stdnt_ps_att.primary_prog_type_source%TYPE,

762: p_discontinued_dt IN igs_en_stdnt_ps_att.discontinued_dt%TYPE,
763: p_lapsed_dt IN igs_en_stdnt_ps_att.lapsed_dt%TYPE,
764: p_course_rqrmnt_complete_ind IN igs_en_stdnt_ps_att.course_rqrmnt_complete_ind%TYPE,
765: p_primary_pg_type IN igs_en_stdnt_ps_att.primary_program_type%TYPE,
766: p_primary_prog_type_source IN igs_en_stdnt_ps_att.primary_prog_type_source%TYPE,
767: p_course_type IN igs_ps_type.course_type%TYPE,
768: p_career_flag IN VARCHAR2)
769: RETURN igs_en_stdnt_ps_att.course_attempt_status%TYPE AS
770: /*----------------------------------------------------------------------------

Line 769: RETURN igs_en_stdnt_ps_att.course_attempt_status%TYPE AS

765: p_primary_pg_type IN igs_en_stdnt_ps_att.primary_program_type%TYPE,
766: p_primary_prog_type_source IN igs_en_stdnt_ps_att.primary_prog_type_source%TYPE,
767: p_course_type IN igs_ps_type.course_type%TYPE,
768: p_career_flag IN VARCHAR2)
769: RETURN igs_en_stdnt_ps_att.course_attempt_status%TYPE AS
770: /*----------------------------------------------------------------------------
771: || Created By : kkillams
772: || Created On : 08-11-2002
773: || Purpose :Derives the program attempt status.

Line 779: l_course_att_status igs_en_stdnt_ps_att.course_attempt_status%TYPE;

775: || Change History :
776: || Who When What
777: ------------------------------------------------------------------------------*/
778:
779: l_course_att_status igs_en_stdnt_ps_att.course_attempt_status%TYPE;
780: l_career_course_att_status igs_en_stdnt_ps_att.course_attempt_status%TYPE;
781: BEGIN
782: --Get program attempt status by calling following function.
783: l_course_att_status :=igs_en_gen_006.enrp_get_sca_status(p_person_id,

Line 780: l_career_course_att_status igs_en_stdnt_ps_att.course_attempt_status%TYPE;

776: || Who When What
777: ------------------------------------------------------------------------------*/
778:
779: l_course_att_status igs_en_stdnt_ps_att.course_attempt_status%TYPE;
780: l_career_course_att_status igs_en_stdnt_ps_att.course_attempt_status%TYPE;
781: BEGIN
782: --Get program attempt status by calling following function.
783: l_course_att_status :=igs_en_gen_006.enrp_get_sca_status(p_person_id,
784: p_course_cd,

Line 819: RETURN igs_en_stdnt_ps_att.dropped_by%TYPE AS

815: END get_course_att_status;
816:
817:
818: FUNCTION get_sca_dropped_by
819: RETURN igs_en_stdnt_ps_att.dropped_by%TYPE AS
820: /*----------------------------------------------------------------------------
821: || Created By : kkillams
822: || Created On : 08-11-2002
823: || Purpose : Function returns the active staff person type.

Line 831: l_person_type_code igs_en_stdnt_ps_att.dropped_by%TYPE;

827: ------------------------------------------------------------------------------*/
828: CURSOR cur_per_type IS SELECT person_type_code FROM igs_pe_person_types_v
829: WHERE system_type = 'STAFF'
830: AND closed_ind ='N';
831: l_person_type_code igs_en_stdnt_ps_att.dropped_by%TYPE;
832: BEGIN
833: l_person_type_code:= NULL;
834:
835: --Get the active person type of STAFF.

Line 891: p_student_confirmed_ind IN igs_en_stdnt_ps_att.student_confirmed_ind%TYPE,

887: END get_sca_prog_type;
888:
889:
890: FUNCTION val_sca_start_dt (
891: p_student_confirmed_ind IN igs_en_stdnt_ps_att.student_confirmed_ind%TYPE,
892: p_commencement_dt IN igs_en_stdnt_ps_att.commencement_dt%TYPE)
893: RETURN BOOLEAN AS
894: /*----------------------------------------------------------------------------
895: || Created By : kkillams

Line 892: p_commencement_dt IN igs_en_stdnt_ps_att.commencement_dt%TYPE)

888:
889:
890: FUNCTION val_sca_start_dt (
891: p_student_confirmed_ind IN igs_en_stdnt_ps_att.student_confirmed_ind%TYPE,
892: p_commencement_dt IN igs_en_stdnt_ps_att.commencement_dt%TYPE)
893: RETURN BOOLEAN AS
894: /*----------------------------------------------------------------------------
895: || Created By : kkillams
896: || Created On : 08-11-2002

Line 920: p_discontinued_dt igs_en_stdnt_ps_att.discontinued_dt%TYPE)

916: END val_sca_start_dt;
917:
918:
919: FUNCTION val_sca_disc_date(
920: p_discontinued_dt igs_en_stdnt_ps_att.discontinued_dt%TYPE)
921: RETURN BOOLEAN AS
922: /*----------------------------------------------------------------------------
923: || Created By : kkillams
924: || Created On : 08-11-2002

Line 947: p_course_rqrmnt_comp_ind IN igs_en_stdnt_ps_att.course_rqrmnt_complete_ind%TYPE,

943: END val_sca_disc_date;
944:
945:
946: FUNCTION val_sca_reqcmpl_dt(
947: p_course_rqrmnt_comp_ind IN igs_en_stdnt_ps_att.course_rqrmnt_complete_ind%TYPE,
948: p_course_rqrmnts_comp_dt IN igs_en_stdnt_ps_att.course_rqrmnts_complete_dt%TYPE,
949: p_message_name OUT NOCOPY VARCHAR2)
950: RETURN BOOLEAN AS
951: /*----------------------------------------------------------------------------

Line 948: p_course_rqrmnts_comp_dt IN igs_en_stdnt_ps_att.course_rqrmnts_complete_dt%TYPE,

944:
945:
946: FUNCTION val_sca_reqcmpl_dt(
947: p_course_rqrmnt_comp_ind IN igs_en_stdnt_ps_att.course_rqrmnt_complete_ind%TYPE,
948: p_course_rqrmnts_comp_dt IN igs_en_stdnt_ps_att.course_rqrmnts_complete_dt%TYPE,
949: p_message_name OUT NOCOPY VARCHAR2)
950: RETURN BOOLEAN AS
951: /*----------------------------------------------------------------------------
952: || Created By : kkillams

Line 978: p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,

974: END val_sca_reqcmpl_dt;
975:
976:
977: FUNCTION val_sca_key_prg(
978: p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,
979: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,
980: p_key_program IN igs_en_stdnt_ps_att.key_program%TYPE,
981: p_primary_prg_type IN igs_en_stdnt_ps_att.primary_program_type%TYPE,
982: p_course_attempt_st IN igs_en_stdnt_ps_att.course_attempt_status%TYPE,

Line 979: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,

975:
976:
977: FUNCTION val_sca_key_prg(
978: p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,
979: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,
980: p_key_program IN igs_en_stdnt_ps_att.key_program%TYPE,
981: p_primary_prg_type IN igs_en_stdnt_ps_att.primary_program_type%TYPE,
982: p_course_attempt_st IN igs_en_stdnt_ps_att.course_attempt_status%TYPE,
983: p_career_flag IN VARCHAR2)

Line 980: p_key_program IN igs_en_stdnt_ps_att.key_program%TYPE,

976:
977: FUNCTION val_sca_key_prg(
978: p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,
979: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,
980: p_key_program IN igs_en_stdnt_ps_att.key_program%TYPE,
981: p_primary_prg_type IN igs_en_stdnt_ps_att.primary_program_type%TYPE,
982: p_course_attempt_st IN igs_en_stdnt_ps_att.course_attempt_status%TYPE,
983: p_career_flag IN VARCHAR2)
984: RETURN BOOLEAN AS

Line 981: p_primary_prg_type IN igs_en_stdnt_ps_att.primary_program_type%TYPE,

977: FUNCTION val_sca_key_prg(
978: p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,
979: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,
980: p_key_program IN igs_en_stdnt_ps_att.key_program%TYPE,
981: p_primary_prg_type IN igs_en_stdnt_ps_att.primary_program_type%TYPE,
982: p_course_attempt_st IN igs_en_stdnt_ps_att.course_attempt_status%TYPE,
983: p_career_flag IN VARCHAR2)
984: RETURN BOOLEAN AS
985: /*-------------------------------------------------------------------------------------------

Line 982: p_course_attempt_st IN igs_en_stdnt_ps_att.course_attempt_status%TYPE,

978: p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,
979: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,
980: p_key_program IN igs_en_stdnt_ps_att.key_program%TYPE,
981: p_primary_prg_type IN igs_en_stdnt_ps_att.primary_program_type%TYPE,
982: p_course_attempt_st IN igs_en_stdnt_ps_att.course_attempt_status%TYPE,
983: p_career_flag IN VARCHAR2)
984: RETURN BOOLEAN AS
985: /*-------------------------------------------------------------------------------------------
986: || Created By : kkillams

Line 999: CURSOR cur_count IS SELECT count(*) FROM igs_en_stdnt_ps_att

995: || validation if course attempt status is UNCONFIRM
996: || w.r.t. to bug 2721076
997: ----------------------------------------------------------------------------------------------*/
998:
999: CURSOR cur_count IS SELECT count(*) FROM igs_en_stdnt_ps_att
1000: WHERE key_program = 'Y'
1001: AND person_id = p_person_id;
1002: l_error NUMBER :=0;
1003: l_key_count NUMBER :=0;

Line 1049: p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,

1045: END val_sca_key_prg;
1046:
1047:
1048: FUNCTION val_sca_primary_pg(
1049: p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,
1050: p_primary_prog_type IN igs_en_stdnt_ps_att.primary_program_type%TYPE,
1051: P_course_type IN igs_ps_type.course_type%TYPE)
1052: RETURN BOOLEAN AS
1053: /*----------------------------------------------------------------------------

Line 1050: p_primary_prog_type IN igs_en_stdnt_ps_att.primary_program_type%TYPE,

1046:
1047:
1048: FUNCTION val_sca_primary_pg(
1049: p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,
1050: p_primary_prog_type IN igs_en_stdnt_ps_att.primary_program_type%TYPE,
1051: P_course_type IN igs_ps_type.course_type%TYPE)
1052: RETURN BOOLEAN AS
1053: /*----------------------------------------------------------------------------
1054: || Created By : kkillams

Line 1062: CURSOR cur_count IS SELECT count(primary_program_type) FROM igs_en_stdnt_ps_att sca,

1058: || Known limitations, enhancements or remarks :
1059: || Change History :
1060: || Who When What
1061: ------------------------------------------------------------------------------*/
1062: CURSOR cur_count IS SELECT count(primary_program_type) FROM igs_en_stdnt_ps_att sca,
1063: igs_ps_ver crv
1064: WHERE crv.course_type = p_course_type
1065: AND sca.course_cd = crv.course_cd
1066: AND sca.version_number = crv.version_number

Line 1110: p_course_attempt_status IN igs_en_stdnt_ps_att.course_attempt_status%TYPE,

1106: END val_sca_primary_pg;
1107:
1108:
1109: FUNCTION val_sca_comp_flag (
1110: p_course_attempt_status IN igs_en_stdnt_ps_att.course_attempt_status%TYPE,
1111: p_course_rqrmnt_complete_ind IN igs_en_stdnt_ps_att.course_rqrmnt_complete_ind%TYPE)
1112: RETURN BOOLEAN AS
1113: /*----------------------------------------------------------------------------
1114: || Created By : kkillams

Line 1111: p_course_rqrmnt_complete_ind IN igs_en_stdnt_ps_att.course_rqrmnt_complete_ind%TYPE)

1107:
1108:
1109: FUNCTION val_sca_comp_flag (
1110: p_course_attempt_status IN igs_en_stdnt_ps_att.course_attempt_status%TYPE,
1111: p_course_rqrmnt_complete_ind IN igs_en_stdnt_ps_att.course_rqrmnt_complete_ind%TYPE)
1112: RETURN BOOLEAN AS
1113: /*----------------------------------------------------------------------------
1114: || Created By : kkillams
1115: || Created On : 08-11-2002

Line 1211: p_person_id igs_en_stdnt_ps_att.person_id%TYPE,

1207:
1208: END raise_person_type_event;
1209:
1210: FUNCTION val_sca_per_type(
1211: p_person_id igs_en_stdnt_ps_att.person_id%TYPE,
1212: p_course_cd igs_en_stdnt_ps_att.course_cd%TYPE,
1213: p_course_attempt_status igs_en_stdnt_ps_att.course_attempt_status%TYPE)
1214: RETURN BOOLEAN AS
1215: /*----------------------------------------------------------------------------

Line 1212: p_course_cd igs_en_stdnt_ps_att.course_cd%TYPE,

1208: END raise_person_type_event;
1209:
1210: FUNCTION val_sca_per_type(
1211: p_person_id igs_en_stdnt_ps_att.person_id%TYPE,
1212: p_course_cd igs_en_stdnt_ps_att.course_cd%TYPE,
1213: p_course_attempt_status igs_en_stdnt_ps_att.course_attempt_status%TYPE)
1214: RETURN BOOLEAN AS
1215: /*----------------------------------------------------------------------------
1216: || Created By : kkillams

Line 1213: p_course_attempt_status igs_en_stdnt_ps_att.course_attempt_status%TYPE)

1209:
1210: FUNCTION val_sca_per_type(
1211: p_person_id igs_en_stdnt_ps_att.person_id%TYPE,
1212: p_course_cd igs_en_stdnt_ps_att.course_cd%TYPE,
1213: p_course_attempt_status igs_en_stdnt_ps_att.course_attempt_status%TYPE)
1214: RETURN BOOLEAN AS
1215: /*----------------------------------------------------------------------------
1216: || Created By : kkillams
1217: || Created On : 08-11-2002

Line 1922: p_course_attempt_status OUT NOCOPY igs_en_stdnt_ps_att.course_attempt_status%TYPE

1918: FUNCTION check_sca_status_upd (
1919: p_person_id IN igs_en_stdnt_ps_intm.person_id%TYPE,
1920: p_program_cd IN igs_en_stdnt_ps_intm.course_cd%TYPE,
1921: p_called_from IN VARCHAR2,
1922: p_course_attempt_status OUT NOCOPY igs_en_stdnt_ps_att.course_attempt_status%TYPE
1923: ) RETURN BOOLEAN as
1924: /**********************************************************************************************
1925: Created By : pradhakr
1926: Date Created By : 14-Nov-02

Line 1941: FROM igs_en_stdnt_ps_att sca

1937: sca.discontinued_dt,
1938: sca.lapsed_dt,
1939: sca.course_rqrmnt_complete_ind,
1940: sca.logical_delete_dt
1941: FROM igs_en_stdnt_ps_att sca
1942: WHERE sca.person_id = p_person_id
1943: AND sca.course_cd = p_program_cd;
1944:
1945: l_sca_row c_sca%ROWTYPE;

Line 1946: l_pred_sca_status igs_en_stdnt_ps_att.course_attempt_status%TYPE;

1942: WHERE sca.person_id = p_person_id
1943: AND sca.course_cd = p_program_cd;
1944:
1945: l_sca_row c_sca%ROWTYPE;
1946: l_pred_sca_status igs_en_stdnt_ps_att.course_attempt_status%TYPE;
1947:
1948: BEGIN
1949:
1950: OPEN c_sca;

Line 2007: FROM igs_en_stdnt_ps_att spa,

2003: || (reverse chronological order - newest change first)
2004: */
2005: CURSOR c_awd_prg_ver IS
2006: SELECT 'X'
2007: FROM igs_en_stdnt_ps_att spa,
2008: igs_ps_award psa
2009: WHERE spa.person_id = p_person_id
2010: AND spa.course_cd = p_program_cd
2011: AND psa.award_cd = p_award_cd