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.

[Home] [Help]

APPS.IGS_GR_GRADUAND_PKG dependencies on IGS_PS_AWARD

Line 446: CURSOR c_closed_ind (cp_c_award_cd IN IGS_PS_AWARD.AWARD_CD%TYPE,

442: END AfterRowUpdate3;
443:
444: PROCEDURE before_insert_update(p_inserting IN BOOLEAN DEFAULT FALSE,
445: p_updating IN BOOLEAN DEFAULT FALSE ) AS
446: CURSOR c_closed_ind (cp_c_award_cd IN IGS_PS_AWARD.AWARD_CD%TYPE,
447: cp_c_course_cd IN IGS_PS_AWARD.COURSE_CD%TYPE,
448: cp_n_version_num IN IGS_PS_AWARD.VERSION_NUMBER%TYPE) IS
449: SELECT CLOSED_IND
450: FROM IGS_PS_AWARD

Line 447: cp_c_course_cd IN IGS_PS_AWARD.COURSE_CD%TYPE,

443:
444: PROCEDURE before_insert_update(p_inserting IN BOOLEAN DEFAULT FALSE,
445: p_updating IN BOOLEAN DEFAULT FALSE ) AS
446: CURSOR c_closed_ind (cp_c_award_cd IN IGS_PS_AWARD.AWARD_CD%TYPE,
447: cp_c_course_cd IN IGS_PS_AWARD.COURSE_CD%TYPE,
448: cp_n_version_num IN IGS_PS_AWARD.VERSION_NUMBER%TYPE) IS
449: SELECT CLOSED_IND
450: FROM IGS_PS_AWARD
451: WHERE AWARD_CD = cp_c_award_cd

Line 448: cp_n_version_num IN IGS_PS_AWARD.VERSION_NUMBER%TYPE) IS

444: PROCEDURE before_insert_update(p_inserting IN BOOLEAN DEFAULT FALSE,
445: p_updating IN BOOLEAN DEFAULT FALSE ) AS
446: CURSOR c_closed_ind (cp_c_award_cd IN IGS_PS_AWARD.AWARD_CD%TYPE,
447: cp_c_course_cd IN IGS_PS_AWARD.COURSE_CD%TYPE,
448: cp_n_version_num IN IGS_PS_AWARD.VERSION_NUMBER%TYPE) IS
449: SELECT CLOSED_IND
450: FROM IGS_PS_AWARD
451: WHERE AWARD_CD = cp_c_award_cd
452: AND COURSE_CD = cp_c_course_cd

Line 450: FROM IGS_PS_AWARD

446: CURSOR c_closed_ind (cp_c_award_cd IN IGS_PS_AWARD.AWARD_CD%TYPE,
447: cp_c_course_cd IN IGS_PS_AWARD.COURSE_CD%TYPE,
448: cp_n_version_num IN IGS_PS_AWARD.VERSION_NUMBER%TYPE) IS
449: SELECT CLOSED_IND
450: FROM IGS_PS_AWARD
451: WHERE AWARD_CD = cp_c_award_cd
452: AND COURSE_CD = cp_c_course_cd
453: AND VERSION_NUMBER = cp_n_version_num;
454:

Line 505: IF NOT IGS_PS_AWARD_PKG.Get_PK_For_Validation (

501: (new_references.award_crs_version_number IS NULL) OR
502: (new_references.award_cd IS NULL))) THEN
503: NULL;
504: ELSE
505: IF NOT IGS_PS_AWARD_PKG.Get_PK_For_Validation (
506: new_references.award_course_cd,
507: new_references.award_crs_version_number,
508: new_references.award_cd
509: ) THEN

Line 608: IF NOT IGS_PS_AWARD_PKG.Get_PK_For_Validation (

604: (new_references.sur_for_crs_version_number IS NULL) OR
605: (new_references.sur_for_award_cd IS NULL))) THEN
606: NULL;
607: ELSE
608: IF NOT IGS_PS_AWARD_PKG.Get_PK_For_Validation (
609: new_references.sur_for_course_cd,
610: new_references.sur_for_crs_version_number,
611: new_references.sur_for_award_cd
612: ) THEN