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

Line 292: p_person_id OUT NOCOPY igs_pe_person.person_id%TYPE,

288:
289:
290: FUNCTION derive_unit_data(
291: p_lgcy_adstunt_rec IN OUT NOCOPY lgcy_adstunt_rec_type,
292: p_person_id OUT NOCOPY igs_pe_person.person_id%TYPE,
293: p_s_adv_stnd_type OUT NOCOPY igs_av_stnd_unit_all. s_adv_stnd_type%TYPE,
294: p_cal_type OUT NOCOPY igs_ca_inst.cal_type%TYPE,
295: p_seq_number OUT NOCOPY igs_ca_inst. sequence_number%TYPE,
296: p_auth_pers_id OUT NOCOPY igs_pe_person.person_id%TYPE,

Line 296: p_auth_pers_id OUT NOCOPY igs_pe_person.person_id%TYPE,

292: p_person_id OUT NOCOPY igs_pe_person.person_id%TYPE,
293: p_s_adv_stnd_type OUT NOCOPY igs_av_stnd_unit_all. s_adv_stnd_type%TYPE,
294: p_cal_type OUT NOCOPY igs_ca_inst.cal_type%TYPE,
295: p_seq_number OUT NOCOPY igs_ca_inst. sequence_number%TYPE,
296: p_auth_pers_id OUT NOCOPY igs_pe_person.person_id%TYPE,
297: p_unit_details_id OUT NOCOPY igs_ad_term_unitdtls.unit_details_id%TYPE,
298: p_tst_rslt_dtls_id OUT NOCOPY igs_ad_tst_rslt_dtls .tst_rslt_dtls_id%TYPE,
299: p_as_version_number OUT NOCOPY igs_en_stdnt_ps_att.version_number%TYPE,
300: p_reference_code_id OUT NOCOPY igs_ge_ref_cd.reference_code_id%TYPE

Line 340: cp_person_id igs_pe_person.person_id%TYPE,

336: CURSOR c_unit_details_id ( cp_unit igs_ad_term_unitdtls.unit%TYPE,
337: cp_prev_term igs_av_lgcy_lvl_int.prev_term%TYPE,
338: cp_start_date igs_av_lgcy_lvl_int.start_date%TYPE,
339: cp_end_date igs_av_lgcy_lvl_int.end_date%TYPE,
340: cp_person_id igs_pe_person.person_id%TYPE,
341: cp_institution_code igs_av_acad_history_v.institution_code%TYPE
342: ) IS
343: SELECT ahv.unit_details_id
344: FROM igs_av_acad_history_v ahv,

Line 494: p_person_id IN igs_pe_person.person_id%TYPE,

490: END derive_unit_data;
491:
492:
493: FUNCTION validate_unit_basis(
494: p_person_id IN igs_pe_person.person_id%TYPE,
495: p_version_number IN igs_ps_ver_all.version_number%TYPE,
496: p_lgcy_adstunt_rec IN lgcy_adstunt_rec_type
497: )RETURN BOOLEAN IS
498: /*===========================================================================+

Line 582: p_person_id IN igs_pe_person.person_id%TYPE,

578: return x_return_status;
579: END validate_adv_std_db_cons;
580:
581: FUNCTION validate_adv_stnd(
582: p_person_id IN igs_pe_person.person_id%TYPE,
583: p_version_number IN igs_ps_ver_all.version_number%TYPE,
584: p_lgcy_adstunt_rec IN lgcy_adstunt_rec_type
585: )RETURN BOOLEAN IS
586: /*===========================================================================+

Line 754: p_person_id IN igs_pe_person.person_id%TYPE,

750: END validate_adv_stnd;
751:
752: FUNCTION validate_std_unt_db_cons(
753: p_lgcy_adstunt_rec IN lgcy_adstunt_rec_type,
754: p_person_id IN igs_pe_person.person_id%TYPE,
755: p_s_adv_stnd_type IN igs_av_stnd_unit_all. s_adv_stnd_type %TYPE,
756: p_cal_type IN igs_ca_inst.cal_type%TYPE,
757: p_seq_number IN igs_ca_inst. sequence_number%TYPE,
758: p_auth_pers_id IN igs_pe_person.person_id%TYPE,

Line 758: p_auth_pers_id IN igs_pe_person.person_id%TYPE,

754: p_person_id IN igs_pe_person.person_id%TYPE,
755: p_s_adv_stnd_type IN igs_av_stnd_unit_all. s_adv_stnd_type %TYPE,
756: p_cal_type IN igs_ca_inst.cal_type%TYPE,
757: p_seq_number IN igs_ca_inst. sequence_number%TYPE,
758: p_auth_pers_id IN igs_pe_person.person_id%TYPE,
759: p_unit_details_id IN igs_ad_term_unitdtls. unit_details_id%TYPE,
760: p_tst_rslt_dtls_id IN igs_ad_tst_rslt_dtls .tst_rslt_dtls_id%TYPE,
761: p_as_version_number IN igs_en_stdnt_ps_att.version_number%TYPE,
762: p_av_stnd_unit_lvl_id OUT NOCOPY igs_av_stnd_unit_all.av_stnd_unit_id%TYPE

Line 849: -- Foreign Key with AUTHORIZING_PERSON_ID exists in table IGS_PE_PERSON

845: FND_MSG_PUB.ADD;
846: x_return_status := FALSE;
847: mydebug('validate_std_unt_db_cons IGS_AV_ADV_STANDING_PKG.GET_PK_FOR_VALIDATION ');
848: END IF;
849: -- Foreign Key with AUTHORIZING_PERSON_ID exists in table IGS_PE_PERSON
850: IF p_auth_pers_id IS NULL THEN
851: FND_MESSAGE.SET_NAME('IGS','IGS_AV_INVALID_PERS_AUTH_NUM');
852: FND_MSG_PUB.ADD;
853: x_return_status := FALSE;

Line 936: p_person_id IN igs_pe_person.person_id%TYPE,

932: END validate_std_unt_db_cons;
933:
934: FUNCTION validate_unit(
935: p_lgcy_adstunt_rec IN lgcy_adstunt_rec_type,
936: p_person_id IN igs_pe_person.person_id%TYPE,
937: p_s_adv_stnd_type IN igs_av_stnd_unit_all. s_adv_stnd_type %TYPE,
938: p_cal_type IN igs_ca_inst.cal_type%TYPE,
939: p_seq_number IN igs_ca_inst. sequence_number%TYPE,
940: p_auth_pers_id IN igs_pe_person.person_id%TYPE,

Line 940: p_auth_pers_id IN igs_pe_person.person_id%TYPE,

936: p_person_id IN igs_pe_person.person_id%TYPE,
937: p_s_adv_stnd_type IN igs_av_stnd_unit_all. s_adv_stnd_type %TYPE,
938: p_cal_type IN igs_ca_inst.cal_type%TYPE,
939: p_seq_number IN igs_ca_inst. sequence_number%TYPE,
940: p_auth_pers_id IN igs_pe_person.person_id%TYPE,
941: p_unit_details_id IN igs_ad_term_unitdtls. unit_details_id%TYPE,
942: p_tst_rslt_dtls_id IN igs_ad_tst_rslt_dtls .tst_rslt_dtls_id%TYPE,
943: p_as_version_number IN igs_en_stdnt_ps_att.version_number%TYPE
944: )RETURN BOOLEAN IS

Line 1166: p_person_id IN igs_pe_person.person_id%type,

1162: END validate_unit;
1163:
1164:
1165: FUNCTION create_post_unit(
1166: p_person_id IN igs_pe_person.person_id%type,
1167: p_course_version IN igs_ps_ver.version_number%type,
1168: p_unit_details_id IN igs_ad_term_unitdtls. unit_details_id%type,
1169: p_tst_rslt_dtls_id IN igs_ad_tst_rslt_dtls.tst_rslt_dtls_id%type,
1170: p_lgcy_adstunt_rec IN lgcy_adstunt_rec_type

Line 1250: p_person_id IN IGS_PE_PERSON.PERSON_ID%TYPE ,

1246: FUNCTION validate_alt_unt_db_cons(
1247: p_lgcy_adstunt_rec IN LGCY_ADSTUNT_REC_TYPE,
1248: p_av_stnd_unit_id IN IGS_AV_STND_UNIT_ALL.AV_STND_UNIT_ID%TYPE ,
1249: p_s_adv_stnd_type IN IGS_AV_STND_UNIT_ALL.S_ADV_STND_TYPE%TYPE ,
1250: p_person_id IN IGS_PE_PERSON.PERSON_ID%TYPE ,
1251: p_unit_details_id IN IGS_AD_TERM_UNITDTLS.UNIT_DETAILS_ID%TYPE ,
1252: p_tst_rslt_dtls_id IN IGS_AD_TST_RSLT_DTLS.TST_RSLT_DTLS_ID%TYPE ,
1253: p_as_version_number IN IGS_AV_STND_UNIT_ALL.AS_VERSION_NUMBER%TYPE ,
1254: p_av_stnd_unit_lvl_id OUT NOCOPY IGS_AV_STND_ALT_UNIT.AV_STND_UNIT_ID%TYPE ,

Line 1592: l_person_id igs_pe_person.person_id%TYPE;

1588: l_api_name CONSTANT VARCHAR2(30) := 'create_adv_stnd_unit';
1589: l_api_version CONSTANT NUMBER := 1.0;
1590: l_ret_status BOOLEAN;
1591: l_b_av_stnd_alt_unit_pk_exist BOOLEAN := TRUE;
1592: l_person_id igs_pe_person.person_id%TYPE;
1593: l_s_adv_stnd_type igs_av_stnd_unit_all. s_adv_stnd_type%TYPE;
1594: l_cal_type igs_ca_inst.cal_type%TYPE;
1595: l_seq_number igs_ca_inst. sequence_number%TYPE;
1596: l_auth_pers_id igs_pe_person.person_id%TYPE;

Line 1596: l_auth_pers_id igs_pe_person.person_id%TYPE;

1592: l_person_id igs_pe_person.person_id%TYPE;
1593: l_s_adv_stnd_type igs_av_stnd_unit_all. s_adv_stnd_type%TYPE;
1594: l_cal_type igs_ca_inst.cal_type%TYPE;
1595: l_seq_number igs_ca_inst. sequence_number%TYPE;
1596: l_auth_pers_id igs_pe_person.person_id%TYPE;
1597: l_unit_details_id igs_ad_term_unitdtls.unit_details_id%TYPE;
1598: l_tst_rslt_dtls_id igs_ad_tst_rslt_dtls .tst_rslt_dtls_id%TYPE;
1599: l_as_version_number igs_en_stdnt_ps_att.version_number%TYPE;
1600: l_av_stnd_unit_lvl_id igs_av_stnd_unit_all.av_stnd_unit_id%TYPE;