APPS.IGS_ST_GEN_002 dependencies on IGS_OR_INSTITUTION

Line 14: || IGS_OR_INSTITUTION.GOVT_INSTITUTION_CD is modified from NUMBER to VARCHAR2.

10: || Who When What
11: || sarakshi 06-May-2003 Enh#2858431,modified procedure stap_get_crs_study replaced CRSOFSTUDY to OTHER
12: || pkpatel 05-MAR-2002 Bug NO: 2224621
13: || Modified P_GOVT_PRIOR_UG_INST from NUMBER to VARCHAR2 in STAP_GET_PERSON_DATA. Since its source
14: || IGS_OR_INSTITUTION.GOVT_INSTITUTION_CD is modified from NUMBER to VARCHAR2.
15: || (reverse chronological order - newest change first)
16: */
17:
18: Function Stap_Get_Course_Lvl(

Line 501: || IGS_OR_INSTITUTION.GOVT_INSTITUTION_CD is modified from NUMBER to VARCHAR2.

497: || Change History :
498: || Who When What
499: || pkpatel 05-MAR-2002 Bug NO: 2224621
500: || Modified GOVT_PRIOR_UG_INST from NUMBER to VARCHAR2. Since its source
501: || IGS_OR_INSTITUTION.GOVT_INSTITUTION_CD is modified from NUMBER to VARCHAR2.
502: || (reverse chronological order - newest change first)
503: */
504: gv_other_detail VARCHAR2(255);
505: BEGIN

Line 596: cp_prior_ug_inst IGS_OR_INSTITUTION.institution_cd%TYPE) IS

592: SELECT lcd.govt_language_cd
593: FROM IGS_PE_LANGUAGE_CD lcd
594: WHERE lcd.language_cd = cp_language_cd;
595: CURSOR c_inst (
596: cp_prior_ug_inst IGS_OR_INSTITUTION.institution_cd%TYPE) IS
597: SELECT inst.govt_institution_cd
598: FROM IGS_OR_INSTITUTION inst
599: WHERE inst.institution_cd = cp_prior_ug_inst;
600: PROCEDURE stapl_ins_log_message(

Line 598: FROM IGS_OR_INSTITUTION inst

594: WHERE lcd.language_cd = cp_language_cd;
595: CURSOR c_inst (
596: cp_prior_ug_inst IGS_OR_INSTITUTION.institution_cd%TYPE) IS
597: SELECT inst.govt_institution_cd
598: FROM IGS_OR_INSTITUTION inst
599: WHERE inst.institution_cd = cp_prior_ug_inst;
600: PROCEDURE stapl_ins_log_message(
601: p_message_name OUT NOCOPY VARCHAR2,
602: p_logged_ind IN OUT NOCOPY BOOLEAN)