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_AV_UNT_LGCY_PUB dependencies on IGS_AD_TERM_UNITDTLS

Line 297: p_unit_details_id OUT NOCOPY igs_ad_term_unitdtls.unit_details_id%TYPE,

293: p_s_adv_stnd_type OUT NOCOPY igs_av_stnd_unit_all. s_adv_stnd_type%TYPE,
294: p_cal_type OUT NOCOPY igs_ca_inst.cal_type%TYPE,
295: p_seq_number OUT NOCOPY igs_ca_inst. sequence_number%TYPE,
296: p_auth_pers_id OUT NOCOPY igs_pe_person.person_id%TYPE,
297: p_unit_details_id OUT NOCOPY igs_ad_term_unitdtls.unit_details_id%TYPE,
298: p_tst_rslt_dtls_id OUT NOCOPY igs_ad_tst_rslt_dtls .tst_rslt_dtls_id%TYPE,
299: p_as_version_number OUT NOCOPY igs_en_stdnt_ps_att.version_number%TYPE,
300: p_reference_code_id OUT NOCOPY igs_ge_ref_cd.reference_code_id%TYPE
301: )RETURN BOOLEAN IS

Line 336: CURSOR c_unit_details_id ( cp_unit igs_ad_term_unitdtls.unit%TYPE,

332: | jhanda 11-11-2002 Created |
333: +===========================================================================*/
334: l_n_rec_count NUMBER :=0 ;
335:
336: CURSOR c_unit_details_id ( cp_unit igs_ad_term_unitdtls.unit%TYPE,
337: cp_prev_term igs_av_lgcy_lvl_int.prev_term%TYPE,
338: cp_start_date igs_av_lgcy_lvl_int.start_date%TYPE,
339: cp_end_date igs_av_lgcy_lvl_int.end_date%TYPE,
340: cp_person_id igs_pe_person.person_id%TYPE,

Line 759: p_unit_details_id IN igs_ad_term_unitdtls. unit_details_id%TYPE,

755: p_s_adv_stnd_type IN igs_av_stnd_unit_all. s_adv_stnd_type %TYPE,
756: p_cal_type IN igs_ca_inst.cal_type%TYPE,
757: p_seq_number IN igs_ca_inst. sequence_number%TYPE,
758: p_auth_pers_id IN igs_pe_person.person_id%TYPE,
759: p_unit_details_id IN igs_ad_term_unitdtls. unit_details_id%TYPE,
760: p_tst_rslt_dtls_id IN igs_ad_tst_rslt_dtls .tst_rslt_dtls_id%TYPE,
761: p_as_version_number IN igs_en_stdnt_ps_att.version_number%TYPE,
762: p_av_stnd_unit_lvl_id OUT NOCOPY igs_av_stnd_unit_all.av_stnd_unit_id%TYPE
763: )RETURN BOOLEAN IS

Line 820: -- Foreign Key with Table IGS_AD_TERM_UNITDTLS

816: ELSE
817: p_av_stnd_unit_lvl_id :=l_av_stnd_unit_lvl_id;
818: END IF;
819: mydebug('**p_av_stnd_unit_lvl_id=' || p_av_stnd_unit_lvl_id || 'l_av_stnd_unit_lvl_id=' ||l_av_stnd_unit_lvl_id);
820: -- Foreign Key with Table IGS_AD_TERM_UNITDTLS
821:
822: IF p_unit_details_id IS NULL AND
823: p_lgcy_adstunt_rec.prev_unit_cd IS NOT NULL AND
824: p_lgcy_adstunt_rec.prev_term IS NOT NULL THEN

Line 941: p_unit_details_id IN igs_ad_term_unitdtls. unit_details_id%TYPE,

937: p_s_adv_stnd_type IN igs_av_stnd_unit_all. s_adv_stnd_type %TYPE,
938: p_cal_type IN igs_ca_inst.cal_type%TYPE,
939: p_seq_number IN igs_ca_inst. sequence_number%TYPE,
940: p_auth_pers_id IN igs_pe_person.person_id%TYPE,
941: p_unit_details_id IN igs_ad_term_unitdtls. unit_details_id%TYPE,
942: p_tst_rslt_dtls_id IN igs_ad_tst_rslt_dtls .tst_rslt_dtls_id%TYPE,
943: p_as_version_number IN igs_en_stdnt_ps_att.version_number%TYPE
944: )RETURN BOOLEAN IS
945: /*===========================================================================+

Line 1168: p_unit_details_id IN igs_ad_term_unitdtls. unit_details_id%type,

1164:
1165: FUNCTION create_post_unit(
1166: p_person_id IN igs_pe_person.person_id%type,
1167: p_course_version IN igs_ps_ver.version_number%type,
1168: p_unit_details_id IN igs_ad_term_unitdtls. unit_details_id%type,
1169: p_tst_rslt_dtls_id IN igs_ad_tst_rslt_dtls.tst_rslt_dtls_id%type,
1170: p_lgcy_adstunt_rec IN lgcy_adstunt_rec_type
1171: )RETURN BOOLEAN IS
1172: /*===========================================================================+

Line 1251: p_unit_details_id IN IGS_AD_TERM_UNITDTLS.UNIT_DETAILS_ID%TYPE ,

1247: p_lgcy_adstunt_rec IN LGCY_ADSTUNT_REC_TYPE,
1248: p_av_stnd_unit_id IN IGS_AV_STND_UNIT_ALL.AV_STND_UNIT_ID%TYPE ,
1249: p_s_adv_stnd_type IN IGS_AV_STND_UNIT_ALL.S_ADV_STND_TYPE%TYPE ,
1250: p_person_id IN IGS_PE_PERSON.PERSON_ID%TYPE ,
1251: p_unit_details_id IN IGS_AD_TERM_UNITDTLS.UNIT_DETAILS_ID%TYPE ,
1252: p_tst_rslt_dtls_id IN IGS_AD_TST_RSLT_DTLS.TST_RSLT_DTLS_ID%TYPE ,
1253: p_as_version_number IN IGS_AV_STND_UNIT_ALL.AS_VERSION_NUMBER%TYPE ,
1254: p_av_stnd_unit_lvl_id OUT NOCOPY IGS_AV_STND_ALT_UNIT.AV_STND_UNIT_ID%TYPE ,
1255: x_return_status OUT NOCOPY VARCHAR2

Line 1597: l_unit_details_id igs_ad_term_unitdtls.unit_details_id%TYPE;

1593: l_s_adv_stnd_type igs_av_stnd_unit_all. s_adv_stnd_type%TYPE;
1594: l_cal_type igs_ca_inst.cal_type%TYPE;
1595: l_seq_number igs_ca_inst. sequence_number%TYPE;
1596: l_auth_pers_id igs_pe_person.person_id%TYPE;
1597: l_unit_details_id igs_ad_term_unitdtls.unit_details_id%TYPE;
1598: l_tst_rslt_dtls_id igs_ad_tst_rslt_dtls .tst_rslt_dtls_id%TYPE;
1599: l_as_version_number igs_en_stdnt_ps_att.version_number%TYPE;
1600: l_av_stnd_unit_lvl_id igs_av_stnd_unit_all.av_stnd_unit_id%TYPE;
1601: L_REQUEST_ID igs_av_stnd_unit_all.request_id%TYPE ;