APPS.IGS_EN_SUA_LGCY_PUB dependencies on IGS_PS_STDNT_TRN

Line 275: igs_ps_stdnt_trn_pkg.check_constraints(

271:
272: -- If Transfer Program Code is specified , it should be in Upper Case.
273: IF p_sua_dtls_rec.transfer_program_cd IS NOT NULL THEN
274: BEGIN
275: igs_ps_stdnt_trn_pkg.check_constraints(
276: column_name => 'TRANSFER_COURSE_CD' ,
277: column_value => p_sua_dtls_rec.transfer_program_cd);
278: EXCEPTION
279: WHEN OTHERS THEN

Line 555: FROM igs_ps_stdnt_trn

551: --
552: -- cursor to determine if Student Program Attempt Transfer details already exist .
553: CURSOR get_sca_trn IS
554: SELECT 'x'
555: FROM igs_ps_stdnt_trn
556: WHERE person_id = p_person_id AND
557: course_cd= p_sua_dtls_rec.program_cd AND
558: transfer_course_cd = p_sua_dtls_rec.transfer_program_cd AND
559: TRUNC(transfer_dt) = TRUNC( p_sua_dtls_rec.transfer_dt);

Line 573: l_creation_date igs_ps_stdnt_trn.creation_date%TYPE;

569: transfer_dt = p_sua_dtls_rec.transfer_dt AND
570: uoo_id = p_uoo_id;
571:
572:
573: l_creation_date igs_ps_stdnt_trn.creation_date%TYPE;
574: l_last_update_date igs_ps_stdnt_trn.last_update_date%TYPE;
575: l_created_by igs_ps_stdnt_trn.created_by%TYPE;
576: l_last_updated_by igs_ps_stdnt_trn.last_updated_by%TYPE;
577: l_last_update_login igs_ps_stdnt_trn.last_update_login%TYPE;

Line 574: l_last_update_date igs_ps_stdnt_trn.last_update_date%TYPE;

570: uoo_id = p_uoo_id;
571:
572:
573: l_creation_date igs_ps_stdnt_trn.creation_date%TYPE;
574: l_last_update_date igs_ps_stdnt_trn.last_update_date%TYPE;
575: l_created_by igs_ps_stdnt_trn.created_by%TYPE;
576: l_last_updated_by igs_ps_stdnt_trn.last_updated_by%TYPE;
577: l_last_update_login igs_ps_stdnt_trn.last_update_login%TYPE;
578: l_dummy VARCHAR2(1) := NULL;

Line 575: l_created_by igs_ps_stdnt_trn.created_by%TYPE;

571:
572:
573: l_creation_date igs_ps_stdnt_trn.creation_date%TYPE;
574: l_last_update_date igs_ps_stdnt_trn.last_update_date%TYPE;
575: l_created_by igs_ps_stdnt_trn.created_by%TYPE;
576: l_last_updated_by igs_ps_stdnt_trn.last_updated_by%TYPE;
577: l_last_update_login igs_ps_stdnt_trn.last_update_login%TYPE;
578: l_dummy VARCHAR2(1) := NULL;
579:

Line 576: l_last_updated_by igs_ps_stdnt_trn.last_updated_by%TYPE;

572:
573: l_creation_date igs_ps_stdnt_trn.creation_date%TYPE;
574: l_last_update_date igs_ps_stdnt_trn.last_update_date%TYPE;
575: l_created_by igs_ps_stdnt_trn.created_by%TYPE;
576: l_last_updated_by igs_ps_stdnt_trn.last_updated_by%TYPE;
577: l_last_update_login igs_ps_stdnt_trn.last_update_login%TYPE;
578: l_dummy VARCHAR2(1) := NULL;
579:
580: BEGIN

Line 577: l_last_update_login igs_ps_stdnt_trn.last_update_login%TYPE;

573: l_creation_date igs_ps_stdnt_trn.creation_date%TYPE;
574: l_last_update_date igs_ps_stdnt_trn.last_update_date%TYPE;
575: l_created_by igs_ps_stdnt_trn.created_by%TYPE;
576: l_last_updated_by igs_ps_stdnt_trn.last_updated_by%TYPE;
577: l_last_update_login igs_ps_stdnt_trn.last_update_login%TYPE;
578: l_dummy VARCHAR2(1) := NULL;
579:
580: BEGIN
581:

Line 608: INSERT INTO IGS_PS_STDNT_TRN (

604:
605: IF get_sca_trn%NOTFOUND THEN
606:
607: BEGIN
608: INSERT INTO IGS_PS_STDNT_TRN (
609: PERSON_ID,
610: COURSE_CD,
611: TRANSFER_COURSE_CD,
612: TRANSFER_DT,