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.

[Home] [Help]

APPS.IGS_AD_TI_COMP dependencies on IGS_AD_PS_APPL_INST

Line 43: p_person_id IN igs_ad_ps_appl_inst.person_id%TYPE,

39: END IF;
40: END upd_trk_step_complete ;
41:
42: FUNCTION upd_trk_stp_cp(
43: p_person_id IN igs_ad_ps_appl_inst.person_id%TYPE,
44: p_admission_appl_number IN igs_ad_ps_appl_inst.admission_appl_number%TYPE,
45: p_course_cd IN igs_ad_ps_appl_inst.course_cd%TYPE,
46: p_sequence_number IN igs_ad_ps_appl_inst.sequence_number%TYPE,
47: p_tracking_id IN igs_tr_step.tracking_id%TYPE,

Line 44: p_admission_appl_number IN igs_ad_ps_appl_inst.admission_appl_number%TYPE,

40: END upd_trk_step_complete ;
41:
42: FUNCTION upd_trk_stp_cp(
43: p_person_id IN igs_ad_ps_appl_inst.person_id%TYPE,
44: p_admission_appl_number IN igs_ad_ps_appl_inst.admission_appl_number%TYPE,
45: p_course_cd IN igs_ad_ps_appl_inst.course_cd%TYPE,
46: p_sequence_number IN igs_ad_ps_appl_inst.sequence_number%TYPE,
47: p_tracking_id IN igs_tr_step.tracking_id%TYPE,
48: p_tracking_step_id IN igs_tr_step.tracking_step_id%TYPE,

Line 45: p_course_cd IN igs_ad_ps_appl_inst.course_cd%TYPE,

41:
42: FUNCTION upd_trk_stp_cp(
43: p_person_id IN igs_ad_ps_appl_inst.person_id%TYPE,
44: p_admission_appl_number IN igs_ad_ps_appl_inst.admission_appl_number%TYPE,
45: p_course_cd IN igs_ad_ps_appl_inst.course_cd%TYPE,
46: p_sequence_number IN igs_ad_ps_appl_inst.sequence_number%TYPE,
47: p_tracking_id IN igs_tr_step.tracking_id%TYPE,
48: p_tracking_step_id IN igs_tr_step.tracking_step_id%TYPE,
49: p_s_tracking_step_type IN igs_tr_step.s_tracking_step_type%TYPE,

Line 46: p_sequence_number IN igs_ad_ps_appl_inst.sequence_number%TYPE,

42: FUNCTION upd_trk_stp_cp(
43: p_person_id IN igs_ad_ps_appl_inst.person_id%TYPE,
44: p_admission_appl_number IN igs_ad_ps_appl_inst.admission_appl_number%TYPE,
45: p_course_cd IN igs_ad_ps_appl_inst.course_cd%TYPE,
46: p_sequence_number IN igs_ad_ps_appl_inst.sequence_number%TYPE,
47: p_tracking_id IN igs_tr_step.tracking_id%TYPE,
48: p_tracking_step_id IN igs_tr_step.tracking_step_id%TYPE,
49: p_s_tracking_step_type IN igs_tr_step.s_tracking_step_type%TYPE,
50: p_recipient_id IN igs_tr_step.recipient_id%TYPE

Line 84: p_person_id IN igs_ad_ps_appl_inst.person_id%TYPE ,

80: AND CLASS_TYPE_CODE='ADM_CODE_CLASSES');
81:
82: -- Get all the Credential details for each application of the Person.
83: CURSOR cur_credentials(
84: p_person_id IN igs_ad_ps_appl_inst.person_id%TYPE ,
85: p_tracking_id IN igs_tr_step.tracking_id%TYPE,
86: p_tracking_step_id IN igs_tr_step.tracking_step_id%TYPE
87: ) IS
88: SELECT DISTINCT 1

Line 100: p_person_id IN igs_ad_ps_appl_inst.person_id%TYPE ,

96: AND ts.tracking_step_id = p_tracking_step_id;
97:
98: -- Get all the Test details for each application of the Person.
99: CURSOR cur_test(
100: p_person_id IN igs_ad_ps_appl_inst.person_id%TYPE ,
101: p_tracking_id IN igs_tr_step.tracking_id%TYPE,
102: p_tracking_step_id IN igs_tr_step.tracking_step_id%TYPE
103: ) IS
104: SELECT DISTINCT 1

Line 116: CURSOR cur_trans ( p_person_id IN igs_ad_ps_appl_inst.person_id%TYPE ) IS

112: AND atr.person_id =p_person_id ;
113:
114: -- Get all the Education details for each application of the Person.
115:
116: CURSOR cur_trans ( p_person_id IN igs_ad_ps_appl_inst.person_id%TYPE ) IS
117: SELECT DISTINCT institution_code,
118: degree_attempted,
119: degree_earned
120: FROM igs_ad_acad_history_v

Line 204: p_person_id IN igs_ad_ps_appl_inst.person_id%TYPE ,

200: AND c.transcript_type ='UNOFFICIAL');
201:
202: -- Get the Personal Statements for the person
203: CURSOR cur_pers_statements(
204: p_person_id IN igs_ad_ps_appl_inst.person_id%TYPE ,
205: p_admission_appl_number IN igs_ad_ps_appl_inst.admission_appl_number%TYPE ,
206: p_tracking_id IN igs_tr_step.tracking_id%TYPE,
207: p_tracking_step_id IN igs_tr_step.tracking_step_id%TYPE
208: ) IS

Line 205: p_admission_appl_number IN igs_ad_ps_appl_inst.admission_appl_number%TYPE ,

201:
202: -- Get the Personal Statements for the person
203: CURSOR cur_pers_statements(
204: p_person_id IN igs_ad_ps_appl_inst.person_id%TYPE ,
205: p_admission_appl_number IN igs_ad_ps_appl_inst.admission_appl_number%TYPE ,
206: p_tracking_id IN igs_tr_step.tracking_id%TYPE,
207: p_tracking_step_id IN igs_tr_step.tracking_step_id%TYPE
208: ) IS
209: SELECT DISTINCT 1

Line 537: p_person_id IN igs_ad_ps_appl_inst.person_id%TYPE,

533: END upd_trk_stp_cp;
534:
535:
536: PROCEDURE get_incp_trstp(
537: p_person_id IN igs_ad_ps_appl_inst.person_id%TYPE,
538: p_admission_appl_number IN igs_ad_ps_appl_inst.admission_appl_number%TYPE,
539: p_course_cd IN igs_ad_ps_appl_inst.course_cd%TYPE,
540: p_sequence_number IN igs_ad_ps_appl_inst.sequence_number%TYPE
541: ) AS

Line 538: p_admission_appl_number IN igs_ad_ps_appl_inst.admission_appl_number%TYPE,

534:
535:
536: PROCEDURE get_incp_trstp(
537: p_person_id IN igs_ad_ps_appl_inst.person_id%TYPE,
538: p_admission_appl_number IN igs_ad_ps_appl_inst.admission_appl_number%TYPE,
539: p_course_cd IN igs_ad_ps_appl_inst.course_cd%TYPE,
540: p_sequence_number IN igs_ad_ps_appl_inst.sequence_number%TYPE
541: ) AS
542: /*

Line 539: p_course_cd IN igs_ad_ps_appl_inst.course_cd%TYPE,

535:
536: PROCEDURE get_incp_trstp(
537: p_person_id IN igs_ad_ps_appl_inst.person_id%TYPE,
538: p_admission_appl_number IN igs_ad_ps_appl_inst.admission_appl_number%TYPE,
539: p_course_cd IN igs_ad_ps_appl_inst.course_cd%TYPE,
540: p_sequence_number IN igs_ad_ps_appl_inst.sequence_number%TYPE
541: ) AS
542: /*
543: || Created By : brajendr

Line 540: p_sequence_number IN igs_ad_ps_appl_inst.sequence_number%TYPE

536: PROCEDURE get_incp_trstp(
537: p_person_id IN igs_ad_ps_appl_inst.person_id%TYPE,
538: p_admission_appl_number IN igs_ad_ps_appl_inst.admission_appl_number%TYPE,
539: p_course_cd IN igs_ad_ps_appl_inst.course_cd%TYPE,
540: p_sequence_number IN igs_ad_ps_appl_inst.sequence_number%TYPE
541: ) AS
542: /*
543: || Created By : brajendr
544: || Created On :

Line 554: p_person_id IN igs_ad_ps_appl_inst.person_id%TYPE,

550: */
551:
552: -- Get all the Tracking Items for each Application of the Person.
553: CURSOR cur_tr(
554: p_person_id IN igs_ad_ps_appl_inst.person_id%TYPE,
555: p_admission_appl_number IN igs_ad_ps_appl_inst.admission_appl_number%TYPE,
556: p_course_cd IN igs_ad_ps_appl_inst.course_cd%TYPE,
557: p_sequence_number IN igs_ad_ps_appl_inst.sequence_number%TYPE
558: ) IS

Line 555: p_admission_appl_number IN igs_ad_ps_appl_inst.admission_appl_number%TYPE,

551:
552: -- Get all the Tracking Items for each Application of the Person.
553: CURSOR cur_tr(
554: p_person_id IN igs_ad_ps_appl_inst.person_id%TYPE,
555: p_admission_appl_number IN igs_ad_ps_appl_inst.admission_appl_number%TYPE,
556: p_course_cd IN igs_ad_ps_appl_inst.course_cd%TYPE,
557: p_sequence_number IN igs_ad_ps_appl_inst.sequence_number%TYPE
558: ) IS
559: SELECT aa.tracking_id

Line 556: p_course_cd IN igs_ad_ps_appl_inst.course_cd%TYPE,

552: -- Get all the Tracking Items for each Application of the Person.
553: CURSOR cur_tr(
554: p_person_id IN igs_ad_ps_appl_inst.person_id%TYPE,
555: p_admission_appl_number IN igs_ad_ps_appl_inst.admission_appl_number%TYPE,
556: p_course_cd IN igs_ad_ps_appl_inst.course_cd%TYPE,
557: p_sequence_number IN igs_ad_ps_appl_inst.sequence_number%TYPE
558: ) IS
559: SELECT aa.tracking_id
560: FROM igs_ad_aplins_admreq aa,

Line 557: p_sequence_number IN igs_ad_ps_appl_inst.sequence_number%TYPE

553: CURSOR cur_tr(
554: p_person_id IN igs_ad_ps_appl_inst.person_id%TYPE,
555: p_admission_appl_number IN igs_ad_ps_appl_inst.admission_appl_number%TYPE,
556: p_course_cd IN igs_ad_ps_appl_inst.course_cd%TYPE,
557: p_sequence_number IN igs_ad_ps_appl_inst.sequence_number%TYPE
558: ) IS
559: SELECT aa.tracking_id
560: FROM igs_ad_aplins_admreq aa,
561: igs_tr_item ti,

Line 643: p_person_id IN igs_ad_ps_appl_inst.person_id%TYPE,

639:
640: PROCEDURE upd_trk_itm_st(
641: ERRBUF OUT NOCOPY VARCHAR2,
642: RETCODE OUT NOCOPY NUMBER,
643: p_person_id IN igs_ad_ps_appl_inst.person_id%TYPE,
644: p_person_id_group IN igs_pe_prsid_grp_mem_all.group_id%TYPE,
645: p_admission_appl_number IN igs_ad_ps_appl_inst.admission_appl_number%TYPE,
646: p_course_cd IN igs_ad_ps_appl_inst.course_cd%TYPE,
647: p_sequence_number IN igs_ad_ps_appl_inst.sequence_number%TYPE,

Line 645: p_admission_appl_number IN igs_ad_ps_appl_inst.admission_appl_number%TYPE,

641: ERRBUF OUT NOCOPY VARCHAR2,
642: RETCODE OUT NOCOPY NUMBER,
643: p_person_id IN igs_ad_ps_appl_inst.person_id%TYPE,
644: p_person_id_group IN igs_pe_prsid_grp_mem_all.group_id%TYPE,
645: p_admission_appl_number IN igs_ad_ps_appl_inst.admission_appl_number%TYPE,
646: p_course_cd IN igs_ad_ps_appl_inst.course_cd%TYPE,
647: p_sequence_number IN igs_ad_ps_appl_inst.sequence_number%TYPE,
648: p_calendar_details IN VARCHAR2,
649: p_admission_process_category IN VARCHAR2,

Line 646: p_course_cd IN igs_ad_ps_appl_inst.course_cd%TYPE,

642: RETCODE OUT NOCOPY NUMBER,
643: p_person_id IN igs_ad_ps_appl_inst.person_id%TYPE,
644: p_person_id_group IN igs_pe_prsid_grp_mem_all.group_id%TYPE,
645: p_admission_appl_number IN igs_ad_ps_appl_inst.admission_appl_number%TYPE,
646: p_course_cd IN igs_ad_ps_appl_inst.course_cd%TYPE,
647: p_sequence_number IN igs_ad_ps_appl_inst.sequence_number%TYPE,
648: p_calendar_details IN VARCHAR2,
649: p_admission_process_category IN VARCHAR2,
650: p_org_id IN igs_pe_prsid_grp_mem_all.org_id%TYPE

Line 647: p_sequence_number IN igs_ad_ps_appl_inst.sequence_number%TYPE,

643: p_person_id IN igs_ad_ps_appl_inst.person_id%TYPE,
644: p_person_id_group IN igs_pe_prsid_grp_mem_all.group_id%TYPE,
645: p_admission_appl_number IN igs_ad_ps_appl_inst.admission_appl_number%TYPE,
646: p_course_cd IN igs_ad_ps_appl_inst.course_cd%TYPE,
647: p_sequence_number IN igs_ad_ps_appl_inst.sequence_number%TYPE,
648: p_calendar_details IN VARCHAR2,
649: p_admission_process_category IN VARCHAR2,
650: p_org_id IN igs_pe_prsid_grp_mem_all.org_id%TYPE
651: ) AS

Line 673: TYPE c_dyn_pig_checkrecTyp IS RECORD ( person_id igs_ad_ps_appl_inst_all.person_id%TYPE,

669:
670:
671: TYPE c_dyn_pig_checkCurTyp IS REF CURSOR;
672: c_dyn_pig_check c_dyn_pig_checkCurTyp;
673: TYPE c_dyn_pig_checkrecTyp IS RECORD ( person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
674: admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
675: nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
676: sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE);
677: c_dyn_pig_check_rec c_dyn_pig_checkrecTyp ;

Line 674: admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,

670:
671: TYPE c_dyn_pig_checkCurTyp IS REF CURSOR;
672: c_dyn_pig_check c_dyn_pig_checkCurTyp;
673: TYPE c_dyn_pig_checkrecTyp IS RECORD ( person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
674: admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
675: nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
676: sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE);
677: c_dyn_pig_check_rec c_dyn_pig_checkrecTyp ;
678:

Line 675: nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,

671: TYPE c_dyn_pig_checkCurTyp IS REF CURSOR;
672: c_dyn_pig_check c_dyn_pig_checkCurTyp;
673: TYPE c_dyn_pig_checkrecTyp IS RECORD ( person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
674: admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
675: nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
676: sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE);
677: c_dyn_pig_check_rec c_dyn_pig_checkrecTyp ;
678:
679: lv_status VARCHAR2(1) := 'S'; /*Defaulted to 'S' and the function will return 'F' in case of failure */

Line 676: sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE);

672: c_dyn_pig_check c_dyn_pig_checkCurTyp;
673: TYPE c_dyn_pig_checkrecTyp IS RECORD ( person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
674: admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
675: nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
676: sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE);
677: c_dyn_pig_check_rec c_dyn_pig_checkrecTyp ;
678:
679: lv_status VARCHAR2(1) := 'S'; /*Defaulted to 'S' and the function will return 'F' in case of failure */
680: lv_sql_stmt VARCHAR(32767);

Line 684: CURSOR cur_appl_details( p_person_id igs_ad_ps_appl_inst.person_id%TYPE,

680: lv_sql_stmt VARCHAR(32767);
681:
682:
683:
684: CURSOR cur_appl_details( p_person_id igs_ad_ps_appl_inst.person_id%TYPE,
685: p_acad_cal_type igs_ad_appl.acad_cal_type%TYPE,
686: p_adm_cal_type igs_ad_appl.adm_cal_type%TYPE,
687: p_acad_ci_sequence_number igs_ad_appl.acad_ci_sequence_number%TYPE,
688: p_adm_ci_sequence_number igs_ad_appl.adm_ci_sequence_number%TYPE,

Line 691: p_admission_appl_number igs_ad_ps_appl_inst.admission_appl_number%TYPE ,

687: p_acad_ci_sequence_number igs_ad_appl.acad_ci_sequence_number%TYPE,
688: p_adm_ci_sequence_number igs_ad_appl.adm_ci_sequence_number%TYPE,
689: p_admission_cat igs_ad_appl.admission_cat%TYPE,
690: p_s_admission_process_type igs_ad_appl.s_admission_process_type%TYPE ,
691: p_admission_appl_number igs_ad_ps_appl_inst.admission_appl_number%TYPE ,
692: p_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE )IS
693:
694: SELECT
695: apai.person_id,

Line 692: p_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE )IS

688: p_adm_ci_sequence_number igs_ad_appl.adm_ci_sequence_number%TYPE,
689: p_admission_cat igs_ad_appl.admission_cat%TYPE,
690: p_s_admission_process_type igs_ad_appl.s_admission_process_type%TYPE ,
691: p_admission_appl_number igs_ad_ps_appl_inst.admission_appl_number%TYPE ,
692: p_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE )IS
693:
694: SELECT
695: apai.person_id,
696: apai.admission_appl_number,

Line 700: igs_ad_ps_appl_inst apai,

696: apai.admission_appl_number,
697: apai.nominated_course_cd,
698: apai.sequence_number
699: FROM
700: igs_ad_ps_appl_inst apai,
701: igs_ad_ou_stat aos,
702: igs_ad_doc_stat ads,
703: igs_ad_appl aa
704: WHERE

Line 724: p_person_id IN igs_ad_ps_appl_inst.person_id%TYPE,

720: aa.admission_appl_number = apai.admission_appl_number ;
721:
722: --Check whether there is any tracking associated for the person and Application Number
723: CURSOR cur_trk_exists(
724: p_person_id IN igs_ad_ps_appl_inst.person_id%TYPE,
725: p_admission_appl_number IN igs_ad_ps_appl_inst.admission_appl_number%TYPE ,
726: p_course_cd IN igs_ad_aplins_admreq.course_cd%TYPE ,
727: p_sequence_number IN igs_ad_aplins_admreq.sequence_number%TYPE ) IS
728: SELECT 1

Line 725: p_admission_appl_number IN igs_ad_ps_appl_inst.admission_appl_number%TYPE ,

721:
722: --Check whether there is any tracking associated for the person and Application Number
723: CURSOR cur_trk_exists(
724: p_person_id IN igs_ad_ps_appl_inst.person_id%TYPE,
725: p_admission_appl_number IN igs_ad_ps_appl_inst.admission_appl_number%TYPE ,
726: p_course_cd IN igs_ad_aplins_admreq.course_cd%TYPE ,
727: p_sequence_number IN igs_ad_aplins_admreq.sequence_number%TYPE ) IS
728: SELECT 1
729: FROM igs_ad_aplins_admreq aa,

Line 861: igs_ad_ps_appl_inst apai,

857: apai.admission_appl_number,
858: apai.nominated_course_cd,
859: apai.sequence_number
860: FROM
861: igs_ad_ps_appl_inst apai,
862: igs_ad_ou_stat aos,
863: igs_ad_doc_stat ads ,
864: igs_ad_appl aa
865: WHERE

Line 906: igs_ad_ps_appl_inst apai,

902: apai.admission_appl_number,
903: apai.nominated_course_cd,
904: apai.sequence_number
905: FROM
906: igs_ad_ps_appl_inst apai,
907: igs_ad_ou_stat aos,
908: igs_ad_doc_stat ads ,
909: igs_ad_appl aa
910: WHERE