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_ST_GEN_001 dependencies on IGS_EN_STDNT_PS_ATT

Line 187: v_commencement_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;

183: E_COMM_DT_NULL EXCEPTION;
184: v_gse_record_found BOOLEAN DEFAULT FALSE;
185: v_prev_sca_rec_found BOOLEAN DEFAULT FALSE;
186: v_exclusion_level VARCHAR2(15);
187: v_commencement_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;
188: v_curr_generic_course_ind IGS_PS_VER.generic_course_ind%TYPE;
189: v_curr_govt_course_type IGS_PS_TYPE.govt_course_type%TYPE;
190: v_curr_responsible_org_unit_cd IGS_PS_VER.responsible_org_unit_cd%TYPE;
191: v_curr_course_level NUMBER;

Line 196: v_prev_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE;

192: v_prev_generic_course_ind IGS_PS_VER.generic_course_ind%TYPE;
193: v_prev_govt_course_type IGS_PS_TYPE.govt_course_type%TYPE;
194: v_prev_responsible_org_unit_cd IGS_PS_VER.responsible_org_unit_cd%TYPE;
195: v_prev_course_level NUMBER;
196: v_prev_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE;
197: v_prev_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
198: v_prev_commencement_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;
199: v_march_string VARCHAR2(10);
200: v_march_dt DATE;

Line 197: v_prev_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;

193: v_prev_govt_course_type IGS_PS_TYPE.govt_course_type%TYPE;
194: v_prev_responsible_org_unit_cd IGS_PS_VER.responsible_org_unit_cd%TYPE;
195: v_prev_course_level NUMBER;
196: v_prev_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE;
197: v_prev_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
198: v_prev_commencement_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;
199: v_march_string VARCHAR2(10);
200: v_march_dt DATE;
201: v_april_string VARCHAR2(10);

Line 198: v_prev_commencement_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;

194: v_prev_responsible_org_unit_cd IGS_PS_VER.responsible_org_unit_cd%TYPE;
195: v_prev_course_level NUMBER;
196: v_prev_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE;
197: v_prev_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
198: v_prev_commencement_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;
199: v_march_string VARCHAR2(10);
200: v_march_dt DATE;
201: v_april_string VARCHAR2(10);
202: v_april_dt DATE;

Line 205: FROM IGS_EN_STDNT_PS_ATT sca

201: v_april_string VARCHAR2(10);
202: v_april_dt DATE;
203: CURSOR c_sca IS
204: SELECT sca.commencement_dt
205: FROM IGS_EN_STDNT_PS_ATT sca
206: WHERE sca.person_id = p_person_id AND
207: sca.course_cd = p_course_cd;
208: CURSOR c_crv_cty(
209: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,

Line 209: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,

205: FROM IGS_EN_STDNT_PS_ATT sca
206: WHERE sca.person_id = p_person_id AND
207: sca.course_cd = p_course_cd;
208: CURSOR c_crv_cty(
209: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
210: cp_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE) IS
211: SELECT crv.generic_course_ind,
212: cty.govt_course_type,
213: crv.responsible_org_unit_cd,

Line 210: cp_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE) IS

206: WHERE sca.person_id = p_person_id AND
207: sca.course_cd = p_course_cd;
208: CURSOR c_crv_cty(
209: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
210: cp_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE) IS
211: SELECT crv.generic_course_ind,
212: cty.govt_course_type,
213: crv.responsible_org_unit_cd,
214: IGS_ST_GEN_002.stap_get_course_lvl(

Line 228: FROM IGS_EN_STDNT_PS_ATT sca

224: cp_april_dt DATE) IS
225: SELECT sca.course_cd,
226: sca.version_number,
227: sca.commencement_dt
228: FROM IGS_EN_STDNT_PS_ATT sca
229: WHERE sca.person_id = p_person_id AND
230: sca.course_cd <> p_course_cd AND
231: sca.commencement_dt < cp_april_dt
232: ORDER BY sca.commencement_dt DESC;

Line 234: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

230: sca.course_cd <> p_course_cd AND
231: sca.commencement_dt < cp_april_dt
232: ORDER BY sca.commencement_dt DESC;
233: FUNCTION stapl_retrieve_curr_prior_gse(
234: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
235: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
236: p_collection_yr NUMBER)
237: RETURN BOOLEAN IS
238: BEGIN

Line 235: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,

231: sca.commencement_dt < cp_april_dt
232: ORDER BY sca.commencement_dt DESC;
233: FUNCTION stapl_retrieve_curr_prior_gse(
234: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
235: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
236: p_collection_yr NUMBER)
237: RETURN BOOLEAN IS
238: BEGIN
239: DECLARE

Line 274: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

270: App_Exception.Raise_Exception;
271: END stapl_retrieve_curr_prior_gse;
272:
273: FUNCTION stapl_check_curr_prior_gse(
274: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
275: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
276: p_collection_yr NUMBER)
277: RETURN BOOLEAN
278: AS

Line 275: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,

271: END stapl_retrieve_curr_prior_gse;
272:
273: FUNCTION stapl_check_curr_prior_gse(
274: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
275: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
276: p_collection_yr NUMBER)
277: RETURN BOOLEAN
278: AS
279: BEGIN

Line 281: v_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE;

277: RETURN BOOLEAN
278: AS
279: BEGIN
280: DECLARE
281: v_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE;
282: v_continue BOOLEAN;
283: CURSOR c_api_pit(
284: cp_person_id IGS_PE_ALT_PERS_ID.pe_person_id%TYPE) IS
285: SELECT api.api_person_id

Line 336: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

332: App_Exception.Raise_Exception;
333: END stapl_check_curr_prior_gse;
334:
335: FUNCTION stapl_retrieve_prev_prior_gse(
336: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
337: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
338: p_collection_yr NUMBER)
339: RETURN BOOLEAN AS
340: BEGIN

Line 337: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,

333: END stapl_check_curr_prior_gse;
334:
335: FUNCTION stapl_retrieve_prev_prior_gse(
336: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
337: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
338: p_collection_yr NUMBER)
339: RETURN BOOLEAN AS
340: BEGIN
341: DECLARE

Line 376: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

372: App_Exception.Raise_Exception;
373: END stapl_retrieve_prev_prior_gse;
374:
375: FUNCTION stapl_check_prev_prior_gse(
376: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
377: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
378: p_collection_yr NUMBER)
379: RETURN BOOLEAN AS
380: BEGIN

Line 377: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,

373: END stapl_retrieve_prev_prior_gse;
374:
375: FUNCTION stapl_check_prev_prior_gse(
376: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
377: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
378: p_collection_yr NUMBER)
379: RETURN BOOLEAN AS
380: BEGIN
381: DECLARE

Line 382: v_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE;

378: p_collection_yr NUMBER)
379: RETURN BOOLEAN AS
380: BEGIN
381: DECLARE
382: v_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE;
383: v_continue BOOLEAN;
384: CURSOR c_api_pit(
385: cp_person_id IGS_PE_ALT_PERS_ID.pe_person_id%TYPE) IS
386: SELECT api.api_person_id

Line 394: -- IGS_EN_STDNT_PS_ATT in the prior years' Student Enrolment File.

390: pit.person_id_type = api.person_id_type AND
391: pit.s_person_id_type = 'OBSOLETE';
392: BEGIN
393: -- This module checks if there is matching record for the previous
394: -- IGS_EN_STDNT_PS_ATT in the prior years' Student Enrolment File.
395: IF NOT stapl_retrieve_prev_prior_gse(
396: p_person_id,
397: p_course_cd,
398: p_collection_yr) THEN

Line 476: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,

472: IGS_GE_MSG_STACK.ADD;
473: App_Exception.Raise_Exception;
474: END stapl_check_prev_crs_enrolled;
475: FUNCTION stapl_check_same_award(
476: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
477: p_version_nunber IGS_EN_STDNT_PS_ATT.version_number%TYPE,
478: p_prev_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
479: p_prev_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE)
480: RETURN BOOLEAN AS

Line 477: p_version_nunber IGS_EN_STDNT_PS_ATT.version_number%TYPE,

473: App_Exception.Raise_Exception;
474: END stapl_check_prev_crs_enrolled;
475: FUNCTION stapl_check_same_award(
476: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
477: p_version_nunber IGS_EN_STDNT_PS_ATT.version_number%TYPE,
478: p_prev_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
479: p_prev_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE)
480: RETURN BOOLEAN AS
481: /***************************************************************

Line 478: p_prev_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,

474: END stapl_check_prev_crs_enrolled;
475: FUNCTION stapl_check_same_award(
476: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
477: p_version_nunber IGS_EN_STDNT_PS_ATT.version_number%TYPE,
478: p_prev_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
479: p_prev_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE)
480: RETURN BOOLEAN AS
481: /***************************************************************
482: Created By :

Line 479: p_prev_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE)

475: FUNCTION stapl_check_same_award(
476: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
477: p_version_nunber IGS_EN_STDNT_PS_ATT.version_number%TYPE,
478: p_prev_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
479: p_prev_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE)
480: RETURN BOOLEAN AS
481: /***************************************************************
482: Created By :
483: Date Created By :

Line 531: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,

527: IGS_GE_MSG_STACK.ADD;
528: App_Exception.Raise_Exception;
529: END stapl_check_same_award;
530: FUNCTION stapl_check_same_equiv(
531: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
532: p_version_nunber IGS_EN_STDNT_PS_ATT.version_number%TYPE,
533: p_prev_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
534: p_prev_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE)
535: RETURN BOOLEAN AS

Line 532: p_version_nunber IGS_EN_STDNT_PS_ATT.version_number%TYPE,

528: App_Exception.Raise_Exception;
529: END stapl_check_same_award;
530: FUNCTION stapl_check_same_equiv(
531: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
532: p_version_nunber IGS_EN_STDNT_PS_ATT.version_number%TYPE,
533: p_prev_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
534: p_prev_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE)
535: RETURN BOOLEAN AS
536: BEGIN

Line 533: p_prev_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,

529: END stapl_check_same_award;
530: FUNCTION stapl_check_same_equiv(
531: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
532: p_version_nunber IGS_EN_STDNT_PS_ATT.version_number%TYPE,
533: p_prev_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
534: p_prev_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE)
535: RETURN BOOLEAN AS
536: BEGIN
537: DECLARE

Line 534: p_prev_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE)

530: FUNCTION stapl_check_same_equiv(
531: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
532: p_version_nunber IGS_EN_STDNT_PS_ATT.version_number%TYPE,
533: p_prev_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
534: p_prev_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE)
535: RETURN BOOLEAN AS
536: BEGIN
537: DECLARE
538: v_course_equivalance_cd IGS_PS_GRP_MBR.course_group_cd%TYPE;

Line 584: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,

580: IGS_GE_MSG_STACK.ADD;
581: App_Exception.Raise_Exception;
582: END stapl_check_same_equiv;
583: FUNCTION stapl_check_combined(
584: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
585: p_version_nunber IGS_EN_STDNT_PS_ATT.version_number%TYPE)
586: RETURN BOOLEAN AS
587: BEGIN
588: DECLARE

Line 585: p_version_nunber IGS_EN_STDNT_PS_ATT.version_number%TYPE)

581: App_Exception.Raise_Exception;
582: END stapl_check_same_equiv;
583: FUNCTION stapl_check_combined(
584: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
585: p_version_nunber IGS_EN_STDNT_PS_ATT.version_number%TYPE)
586: RETURN BOOLEAN AS
587: BEGIN
588: DECLARE
589: v_cgm_cgr_cgt_exists VARCHAR2(1);

Line 765: p_prev_commencement_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE)

761: END stapl_check_course_transfer;
762: FUNCTION stapl_get_comm_dt(
763: p_prev_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
764: p_prev_version_number IGS_EN_SU_ATTEMPT.version_number%TYPE,
765: p_prev_commencement_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE)
766: RETURN DATE
767: AS
768: BEGIN
769: DECLARE