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_PS_VER

Line 99: p_version_number IN igs_ps_ver_all.version_number%type,

95: */
96: FUNCTION validate_adv_std_db_cons
97: (
98: p_person_id IN igs_pe_person.person_id%type,
99: p_version_number IN igs_ps_ver_all.version_number%type,
100: p_lgcy_adstlvl_rec IN lgcy_adstlvl_rec_type
101: )
102: RETURN BOOLEAN;
103:

Line 111: p_version_number IN igs_ps_ver.version_number%type,

107: */
108: FUNCTION validate_adv_stnd
109: (
110: p_person_id IN igs_pe_person.person_id%type,
111: p_version_number IN igs_ps_ver.version_number%type,
112: p_lgcy_adstlvl_rec IN lgcy_adstlvl_rec_type
113: )
114: RETURN BOOLEAN;
115:

Line 130: p_course_version IN igs_ps_ver.version_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,
132: p_av_stnd_unit_lvl_id OUT NOCOPY igs_av_std_ulvlbasis_all.av_stnd_unit_lvl_id%type
133: )
134: RETURN BOOLEAN;

Line 150: p_course_version IN igs_ps_ver.version_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
152: )
153: RETURN BOOLEAN;
154:

Line 162: p_course_version IN igs_ps_ver.version_number%type,

158: */
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: )

Line 187: p_course_version IN igs_ps_ver.version_number%type,

183: inserting into the table IGS_AV_STD_ULVLBASIS_ALL
184: */
185: FUNCTION validate_lvl_bas
186: (
187: p_course_version IN igs_ps_ver.version_number%type,
188: p_lgcy_adstlvl_rec IN lgcy_adstlvl_rec_type
189: )
190: RETURN BOOLEAN;
191:

Line 1120: p_version_number IN igs_ps_ver_all.version_number%type,

1116:
1117: FUNCTION validate_adv_std_db_cons
1118: (
1119: p_person_id IN igs_pe_person.person_id%type,
1120: p_version_number IN igs_ps_ver_all.version_number%type,
1121: p_lgcy_adstlvl_rec IN lgcy_adstlvl_rec_type
1122: )
1123: RETURN BOOLEAN
1124: /*************************************************************

Line 1138: IF NOT IGS_PS_VER_PKG.GET_PK_FOR_VALIDATION

1134: IS
1135: x_return_status BOOLEAN;
1136: BEGIN
1137: x_return_status := TRUE;
1138: IF NOT IGS_PS_VER_PKG.GET_PK_FOR_VALIDATION
1139: (
1140: x_course_cd => p_lgcy_adstlvl_rec.program_cd,
1141: x_version_number => p_version_number
1142: ) THEN

Line 1153: p_version_number IN igs_ps_ver.version_number%type,

1149:
1150: FUNCTION validate_adv_stnd
1151: (
1152: p_person_id IN igs_pe_person.person_id%type,
1153: p_version_number IN igs_ps_ver.version_number%type,
1154: p_lgcy_adstlvl_rec IN lgcy_adstlvl_rec_type
1155: )
1156: RETURN BOOLEAN
1157: /*************************************************************

Line 1243: cp_course_cd igs_ps_ver.course_cd%type,

1239: FROM igs_or_institution ins
1240: WHERE ins.institution_cd = cp_ins_cd;
1241:
1242: CURSOR cur_program_exempt_totals (
1243: cp_course_cd igs_ps_ver.course_cd%type,
1244: cp_version_number igs_ps_ver.version_number%type,
1245: cp_local_ind VARCHAR2) IS
1246: SELECT DECODE (cp_local_ind, 'N', NVL (cv.external_adv_stnd_limit, -1),
1247: NVL (cv.internal_adv_stnd_limit, -1)) adv_stnd_limit

Line 1244: cp_version_number igs_ps_ver.version_number%type,

1240: WHERE ins.institution_cd = cp_ins_cd;
1241:
1242: CURSOR cur_program_exempt_totals (
1243: cp_course_cd igs_ps_ver.course_cd%type,
1244: cp_version_number igs_ps_ver.version_number%type,
1245: cp_local_ind VARCHAR2) IS
1246: SELECT DECODE (cp_local_ind, 'N', NVL (cv.external_adv_stnd_limit, -1),
1247: NVL (cv.internal_adv_stnd_limit, -1)) adv_stnd_limit
1248: FROM igs_ps_ver cv

Line 1248: FROM igs_ps_ver cv

1244: cp_version_number igs_ps_ver.version_number%type,
1245: cp_local_ind VARCHAR2) IS
1246: SELECT DECODE (cp_local_ind, 'N', NVL (cv.external_adv_stnd_limit, -1),
1247: NVL (cv.internal_adv_stnd_limit, -1)) adv_stnd_limit
1248: FROM igs_ps_ver cv
1249: WHERE cv.course_cd = cp_course_cd
1250: AND cv.version_number = cp_version_number;
1251:
1252: rec_cur_program_exempt_totals cur_program_exempt_totals%ROWTYPE;

Line 1334: p_course_version IN igs_ps_ver.version_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,
1336: p_av_stnd_unit_lvl_id OUT NOCOPY igs_av_std_ulvlbasis_all.av_stnd_unit_lvl_id%type
1337: )
1338: RETURN BOOLEAN

Line 1537: p_course_version IN igs_ps_ver.version_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
1539: )
1540: RETURN BOOLEAN
1541: /*************************************************************

Line 1702: p_course_version IN igs_ps_ver.version_number%type,

1698:
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: )

Line 1859: p_course_version IN igs_ps_ver.version_number%type,

1855: END validate_lvl_bas_db_cons;
1856:
1857: FUNCTION validate_lvl_bas
1858: (
1859: p_course_version IN igs_ps_ver.version_number%type,
1860: p_lgcy_adstlvl_rec IN lgcy_adstlvl_rec_type
1861: )
1862: RETURN BOOLEAN
1863: /*************************************************************