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

Line 87: p_unit_details_id OUT NOCOPY igs_ad_term_unitdtls.unit_details_id%type,

83: p_s_adv_stnd_unit_level OUT NOCOPY igs_av_stnd_unit_lvl.s_adv_stnd_type%type,
84: p_cal_type OUT NOCOPY igs_ca_inst.cal_type%type,
85: p_sequence_number OUT NOCOPY igs_ca_inst.sequence_number%type,
86: p_auth_pers_id OUT NOCOPY igs_pe_person.person_id%type,
87: p_unit_details_id OUT NOCOPY igs_ad_term_unitdtls.unit_details_id%type,
88: p_tst_rslt_dtls_id OUT NOCOPY igs_ad_tst_rslt_dtls.tst_rslt_dtls_id%type,
89: p_qual_dets_id OUT NOCOPY igs_uc_qual_dets.qual_dets_id%type,
90: p_as_version_number OUT NOCOPY igs_en_stdnt_ps_att.version_number%type
91: );

Line 127: p_unit_details_id IN igs_ad_term_unitdtls.unit_details_id%type,

123: p_s_adv_stnd_unit_level IN igs_ps_unit_level.unit_level%type,
124: p_cal_type IN igs_ca_inst.cal_type%type,
125: p_seq_number IN igs_ca_inst.sequence_number%type,
126: p_auth_pers_id IN igs_pe_person.person_id%type,
127: p_unit_details_id IN igs_ad_term_unitdtls.unit_details_id%type,
128: p_tst_rslt_dtls_id IN igs_ad_tst_rslt_dtls.tst_rslt_dtls_id%type,
129: p_qual_dets_id IN igs_uc_qual_dets.qual_dets_id%type,
130: p_course_version IN igs_ps_ver.version_number%type,
131: p_lgcy_adstlvl_rec IN lgcy_adstlvl_rec_type,

Line 147: p_unit_details_id IN igs_ad_term_unitdtls.unit_details_id%type,

143: p_unit_level IN igs_ps_unit_level.unit_level%type,
144: p_cal_type IN igs_ca_inst.cal_type%type,
145: p_seq_number IN igs_ca_inst.sequence_number%type,
146: p_auth_pers_id IN igs_pe_person.person_id%type,
147: p_unit_details_id IN igs_ad_term_unitdtls.unit_details_id%type,
148: p_tst_rslt_dtls_id IN igs_ad_tst_rslt_dtls.tst_rslt_dtls_id%type,
149: p_qual_dets_id IN igs_uc_qual_dets.qual_dets_id%type,
150: p_course_version IN igs_ps_ver.version_number%type,
151: p_lgcy_adstlvl_rec IN lgcy_adstlvl_rec_type

Line 163: p_unit_details_id IN igs_ad_term_unitdtls.unit_details_id%type,

159: FUNCTION create_post_lvl
160: (
161: p_person_id IN igs_pe_person.person_id%type,
162: p_course_version IN igs_ps_ver.version_number%type,
163: p_unit_details_id IN igs_ad_term_unitdtls.unit_details_id%type,
164: p_tst_rslt_dtls_id IN igs_ad_tst_rslt_dtls.tst_rslt_dtls_id%type,
165: p_lgcy_adstlvl_rec IN lgcy_adstlvl_rec_type
166: )
167: RETURN BOOLEAN;

Line 252: l_unit_details_id igs_ad_term_unitdtls.unit_details_id%type;

248: l_s_adv_stnd_unit_level igs_av_stnd_unit_lvl.s_adv_stnd_type%type;
249: l_cal_type igs_ca_inst.cal_type%type;
250: l_sequence_number igs_ca_inst.sequence_number%type;
251: l_auth_pers_id igs_pe_person.person_id%type;
252: l_unit_details_id igs_ad_term_unitdtls.unit_details_id%type;
253: l_tst_rslt_dtls_id igs_ad_tst_rslt_dtls.tst_rslt_dtls_id%type;
254: l_qual_dets_id igs_uc_qual_dets.qual_dets_id%type;
255: l_as_version_number igs_en_stdnt_ps_att.version_number%type;
256:

Line 888: p_unit_details_id OUT NOCOPY igs_ad_term_unitdtls.unit_details_id%type,

884: p_s_adv_stnd_unit_level OUT NOCOPY igs_av_stnd_unit_lvl.s_adv_stnd_type%type,
885: p_cal_type OUT NOCOPY igs_ca_inst.cal_type%type,
886: p_sequence_number OUT NOCOPY igs_ca_inst.sequence_number%type,
887: p_auth_pers_id OUT NOCOPY igs_pe_person.person_id%type,
888: p_unit_details_id OUT NOCOPY igs_ad_term_unitdtls.unit_details_id%type,
889: p_tst_rslt_dtls_id OUT NOCOPY igs_ad_tst_rslt_dtls.tst_rslt_dtls_id%type,
890: p_qual_dets_id OUT NOCOPY igs_uc_qual_dets.qual_dets_id%type,
891: p_as_version_number OUT NOCOPY igs_en_stdnt_ps_att.version_number%type
892: )

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

1006: Added the following IF clauses before deriving the value for unit details ID
1007: */
1008: IF p_lgcy_adstlvl_rec.prev_unit_cd IS NOT NULL THEN
1009: DECLARE
1010: CURSOR c_unit_details_id (cp_unit igs_ad_term_unitdtls.unit%TYPE,
1011: cp_prev_term igs_av_lgcy_lvl_int.prev_term%TYPE,
1012: cp_start_date igs_av_lgcy_lvl_int.start_date%TYPE,
1013: cp_end_date igs_av_lgcy_lvl_int.end_date%TYPE,
1014: cp_person_id igs_pe_person.person_id%TYPE,

Line 1331: p_unit_details_id IN igs_ad_term_unitdtls.unit_details_id%type,

1327: p_s_adv_stnd_unit_level IN igs_ps_unit_level.unit_level%type,
1328: p_cal_type IN igs_ca_inst.cal_type%type,
1329: p_seq_number IN igs_ca_inst.sequence_number%type,
1330: p_auth_pers_id IN igs_pe_person.person_id%type,
1331: p_unit_details_id IN igs_ad_term_unitdtls.unit_details_id%type,
1332: p_tst_rslt_dtls_id IN igs_ad_tst_rslt_dtls.tst_rslt_dtls_id%type,
1333: p_qual_dets_id IN igs_uc_qual_dets.qual_dets_id%type,
1334: p_course_version IN igs_ps_ver.version_number%type,
1335: p_lgcy_adstlvl_rec IN lgcy_adstlvl_rec_type,

Line 1534: p_unit_details_id IN igs_ad_term_unitdtls.unit_details_id%type,

1530: p_unit_level IN igs_ps_unit_level.unit_level%type,
1531: p_cal_type IN igs_ca_inst.cal_type%type,
1532: p_seq_number IN igs_ca_inst.sequence_number%type,
1533: p_auth_pers_id IN igs_pe_person.person_id%type,
1534: p_unit_details_id IN igs_ad_term_unitdtls.unit_details_id%type,
1535: p_tst_rslt_dtls_id IN igs_ad_tst_rslt_dtls.tst_rslt_dtls_id%type,
1536: p_qual_dets_id IN igs_uc_qual_dets.qual_dets_id%type,
1537: p_course_version IN igs_ps_ver.version_number%type,
1538: p_lgcy_adstlvl_rec IN lgcy_adstlvl_rec_type

Line 1703: p_unit_details_id IN igs_ad_term_unitdtls.unit_details_id%type,

1699: FUNCTION create_post_lvl
1700: (
1701: p_person_id IN igs_pe_person.person_id%type,
1702: p_course_version IN igs_ps_ver.version_number%type,
1703: p_unit_details_id IN igs_ad_term_unitdtls.unit_details_id%type,
1704: p_tst_rslt_dtls_id IN igs_ad_tst_rslt_dtls.tst_rslt_dtls_id%type,
1705: p_lgcy_adstlvl_rec IN lgcy_adstlvl_rec_type
1706: )
1707: RETURN BOOLEAN