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_AD_PS_APPL_INST_PKG dependencies on IGS_PE_PERSON

Line 332: v_staff_member_ind IGS_PE_PERSON.staff_member_ind%TYPE;

328: v_message_name VARCHAR2(30);
329: v_return_type VARCHAR2(1);
330: v_update_non_enrol_detail_ind VARCHAR2(1) ;
331: v_late_ind VARCHAR2(1) ;
332: v_staff_member_ind IGS_PE_PERSON.staff_member_ind%TYPE;
333: v_p_inserting_ind VARCHAR2(1) ;
334: v_offer_ind VARCHAR2(1) ;
335: v_crv_version_number IGS_PS_VER.version_number%TYPE;
336: v_admission_cat IGS_AD_APPL.admission_cat%TYPE;

Line 397: igs_pe_person_types ppt

393: cp_nominated_course_cd igs_ad_ps_appl_inst.nominated_course_cd%TYPE,
394: cp_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE) IS
395: SELECT pti.rowid row_id
396: FROM igs_pe_typ_instances_all pti,
397: igs_pe_person_types ppt
398: WHERE pti.person_id = cp_person_id
399: AND pti.admission_appl_number = cp_admission_appl_number
400: AND pti.nominated_course_cd = cp_nominated_course_cd
401: AND pti.sequence_number = cp_sequence_number

Line 1656: -- Validate the Outcome Status Authorising IGS_PE_PERSON ID.

1652: APP_EXCEPTION.RAISE_EXCEPTION;
1653: END IF;
1654: END IF;
1655: --
1656: -- Validate the Outcome Status Authorising IGS_PE_PERSON ID.
1657: --
1658: IF NVL(old_references.adm_otcm_status_auth_person_id, -1) <>
1659: NVL(new_references.adm_otcm_status_auth_person_id, -1) OR
1660: NVL(TRUNC(old_references.adm_outcome_status_auth_dt),

Line 1786: CURSOR c_pti (cp_person_id igs_pe_person.person_id%TYPE) IS

1782: p_inserting IN BOOLEAN,
1783: p_updating IN BOOLEAN,
1784: p_deleting IN BOOLEAN
1785: ) AS
1786: CURSOR c_pti (cp_person_id igs_pe_person.person_id%TYPE) IS
1787: SELECT pti.rowid row_id,pti.*, lv.lookup_code lv_end_method
1788: FROM igs_pe_typ_instances_all pti,
1789: igs_pe_person_types ppt,
1790: igs_lookup_values lv

Line 1789: igs_pe_person_types ppt,

1785: ) AS
1786: CURSOR c_pti (cp_person_id igs_pe_person.person_id%TYPE) IS
1787: SELECT pti.rowid row_id,pti.*, lv.lookup_code lv_end_method
1788: FROM igs_pe_typ_instances_all pti,
1789: igs_pe_person_types ppt,
1790: igs_lookup_values lv
1791: WHERE pti.person_id = cp_person_id
1792: AND ppt.person_type_code = pti.person_type_code
1793: AND ppt.system_type = 'PROSPECT'

Line 1838: igs_pe_person_types ppt

1834: cp_nominated_course_cd igs_ad_ps_appl_inst.nominated_course_cd%TYPE,
1835: cp_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE) IS
1836: SELECT pti.rowid row_id,pti.*
1837: FROM igs_pe_typ_instances_all pti,
1838: igs_pe_person_types ppt
1839: WHERE pti.person_id = cp_person_id
1840: AND pti.admission_appl_number = cp_admission_appl_number
1841: AND pti.nominated_course_cd = cp_nominated_course_cd
1842: AND pti.sequence_number = cp_sequence_number

Line 1854: igs_pe_person_types ppt

1850: cp_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE,
1851: cp_end_method igs_lookup_values.lookup_code%TYPE) IS
1852: SELECT pti.rowid row_id,pti.*
1853: FROM igs_pe_typ_instances_all pti,
1854: igs_pe_person_types ppt
1855: WHERE pti.person_id = cp_person_id
1856: AND pti.admission_appl_number = cp_admission_appl_number
1857: AND pti.nominated_course_cd = cp_nominated_course_cd
1858: AND pti.sequence_number = cp_sequence_number

Line 2835: ELSIF NOT Igs_Pe_Person_Pkg.Get_PK_For_Validation (

2831: END IF;
2832: IF (((old_references.decision_make_id = new_references.decision_make_id)) OR
2833: ((new_references.decision_make_id IS NULL))) THEN
2834: NULL;
2835: ELSIF NOT Igs_Pe_Person_Pkg.Get_PK_For_Validation (
2836: new_references.decision_make_id
2837: ) THEN
2838: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
2839: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_DEC_MAKE'));

Line 3055: IF NOT IGS_PE_PERSON_PKG.Get_PK_For_Validation (

3051: IF (((old_references.person_id = new_references.person_id)) OR
3052: ((new_references.person_id IS NULL))) THEN
3053: NULL;
3054: ELSE
3055: IF NOT IGS_PE_PERSON_PKG.Get_PK_For_Validation (
3056: new_references.person_id
3057: )THEN
3058: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
3059: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_PERSON'));

Line 3636: PROCEDURE Get_FK_Igs_Pe_Person (

3632: END IF;
3633: Close cur_rowid;
3634: END Get_FK_Igs_Or_Institution;
3635:
3636: PROCEDURE Get_FK_Igs_Pe_Person (
3637: x_person_id IN NUMBER
3638: ) IS
3639: /*************************************************************
3640: Created By :

Line 3678: END Get_FK_Igs_Pe_Person;

3674: App_Exception.Raise_Exception;
3675: Return;
3676: END IF;
3677: Close cur_rowid2;
3678: END Get_FK_Igs_Pe_Person;
3679:
3680: PROCEDURE GET_FK_IGS_EN_ATD_MODE (
3681: x_attendance_mode IN VARCHAR2
3682: ) IS

Line 4690: CURSOR c_get_init_recent(p_person_id IGS_PE_PERSON.PERSON_ID%TYPE) IS

4686: kamohan 8/2/02 Bug 2407628 Modified the logic comments whereever neccessary
4687: knag 23-JAN-2003 Modified population of admittance logic and code indents
4688: (reverse chronological order - newest change first)
4689: ***************************************************************/
4690: CURSOR c_get_init_recent(p_person_id IGS_PE_PERSON.PERSON_ID%TYPE) IS
4691: SELECT psv.init_cal_type, psv.init_sequence_number,
4692: psv.recent_cal_type, psv.recent_sequence_number,
4693: psv.catalog_cal_type, psv.catalog_sequence_number
4694: FROM igs_pe_stat_details psv

Line 7028: p_person_id igs_pe_person.person_id%TYPE,

7024: p_adm_outcome_status igs_ad_ps_appl_inst.adm_outcome_status%TYPE,
7025: p_cond_offer_status igs_ad_ps_appl_inst.adm_cndtnl_offer_status%TYPE,
7026: p_adm_outcome_status_old igs_ad_ps_appl_inst.adm_outcome_status%TYPE,
7027: p_cond_offer_status_old igs_ad_ps_appl_inst.adm_cndtnl_offer_status%TYPE,
7028: p_person_id igs_pe_person.person_id%TYPE,
7029: p_condition_category IN igs_uc_offer_conds.condition_category%TYPE,
7030: p_condition_name IN igs_uc_offer_conds.condition_name%TYPE,
7031: p_uc_tran_id OUT NOCOPY NUMBER )
7032: IS

Line 7049: CURSOR c_igs_ad_appl(cp_n_person_id igs_pe_person.person_id%TYPE,

7045: ayedubat 10-NOV-2003 Changed the ucas_user_hook procedure to add a new OUT parameter to procedure call,
7046: igs_uc_trx_gen_hook.create_ucas_transactions for UC208 Enhancement Bug, 3009203
7047: (reverse chronological order - newest change first)
7048: ***************************************************************/
7049: CURSOR c_igs_ad_appl(cp_n_person_id igs_pe_person.person_id%TYPE,
7050: cp_n_admission_appl_no igs_ad_appl.admission_appl_number%TYPE
7051: ) IS
7052: SELECT choice_number, alt_appl_id
7053: FROM igs_ad_appl

Line 7059: CURSOR c_igs_pe_person(cp_n_person_id igs_pe_person.person_id%TYPE) IS

7055: AND admission_appl_number = cp_n_admission_appl_no ;
7056: rec_c_igs_ad_appl c_igs_ad_appl%ROWTYPE;
7057:
7058:
7059: CURSOR c_igs_pe_person(cp_n_person_id igs_pe_person.person_id%TYPE) IS
7060: SELECT party_number person_number
7061: FROM hz_parties hz
7062: WHERE hz.party_id = cp_n_person_id;
7063: rec_c_igs_pe_person c_igs_pe_person%ROWTYPE;

Line 7063: rec_c_igs_pe_person c_igs_pe_person%ROWTYPE;

7059: CURSOR c_igs_pe_person(cp_n_person_id igs_pe_person.person_id%TYPE) IS
7060: SELECT party_number person_number
7061: FROM hz_parties hz
7062: WHERE hz.party_id = cp_n_person_id;
7063: rec_c_igs_pe_person c_igs_pe_person%ROWTYPE;
7064:
7065:
7066: CURSOR c_igs_pe_ucas(cp_n_person_id igs_pe_person.person_id%TYPE) IS
7067: SELECT api_person_id

Line 7066: CURSOR c_igs_pe_ucas(cp_n_person_id igs_pe_person.person_id%TYPE) IS

7062: WHERE hz.party_id = cp_n_person_id;
7063: rec_c_igs_pe_person c_igs_pe_person%ROWTYPE;
7064:
7065:
7066: CURSOR c_igs_pe_ucas(cp_n_person_id igs_pe_person.person_id%TYPE) IS
7067: SELECT api_person_id
7068: FROM igs_pe_alt_pers_id
7069: WHERE sysdate BETWEEN start_dt AND NVL(end_dt, sysdate)
7070: AND person_id_type IN ('UCASID', 'SWASID', 'NMASID', 'GTTRID')

Line 7090: OPEN c_igs_pe_person(p_person_id);

7086: FETCH c_igs_ad_appl INTO rec_c_igs_ad_appl;
7087: CLOSE c_igs_ad_appl;
7088:
7089:
7090: OPEN c_igs_pe_person(p_person_id);
7091: FETCH c_igs_pe_person INTO rec_c_igs_pe_person;
7092: CLOSE c_igs_pe_person;
7093:
7094: EXECUTE IMMEDIATE

Line 7091: FETCH c_igs_pe_person INTO rec_c_igs_pe_person;

7087: CLOSE c_igs_ad_appl;
7088:
7089:
7090: OPEN c_igs_pe_person(p_person_id);
7091: FETCH c_igs_pe_person INTO rec_c_igs_pe_person;
7092: CLOSE c_igs_pe_person;
7093:
7094: EXECUTE IMMEDIATE
7095: 'BEGIN igs_uc_trx_gen_hook.create_ucas_transactions(

Line 7092: CLOSE c_igs_pe_person;

7088:
7089:
7090: OPEN c_igs_pe_person(p_person_id);
7091: FETCH c_igs_pe_person INTO rec_c_igs_pe_person;
7092: CLOSE c_igs_pe_person;
7093:
7094: EXECUTE IMMEDIATE
7095: 'BEGIN igs_uc_trx_gen_hook.create_ucas_transactions(
7096: P_UCAS_ID => :1,

Line 7111: rec_c_igs_pe_person.person_number,

7107: P_UC_TRAN_ID => :12); END;'
7108: USING
7109: IGS_GE_NUMBER.TO_CANN(NULL), -- made obsolete, earlier passed rec_c_igs_pe_ucas.api_person_id,
7110: rec_c_igs_ad_appl.choice_number,
7111: rec_c_igs_pe_person.person_number,
7112: p_admission_appl_number,
7113: p_nominated_course_cd,
7114: p_sequence_number,
7115: p_adm_outcome_status,