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_DA_XML_PKG dependencies on IGS_PE_ALT_PERS_ID

Line 914: p_person_id_code IN igs_pe_alt_pers_id.api_person_id%TYPE,

910:
911:
912: PROCEDURE get_person_details
913: (
914: p_person_id_code IN igs_pe_alt_pers_id.api_person_id%TYPE,
915: p_person_id_code_type IN igs_pe_alt_pers_id.api_person_id%TYPE,
916: p_person_id OUT NOCOPY hz_parties.party_id%TYPE,
917: p_person_number OUT NOCOPY hz_parties.party_number%TYPE) IS
918:

Line 915: p_person_id_code_type IN igs_pe_alt_pers_id.api_person_id%TYPE,

911:
912: PROCEDURE get_person_details
913: (
914: p_person_id_code IN igs_pe_alt_pers_id.api_person_id%TYPE,
915: p_person_id_code_type IN igs_pe_alt_pers_id.api_person_id%TYPE,
916: p_person_id OUT NOCOPY hz_parties.party_id%TYPE,
917: p_person_number OUT NOCOPY hz_parties.party_number%TYPE) IS
918:
919: CURSOR c1 IS

Line 927: igs_pe_alt_pers_id api,

923:
924: CURSOR c2 IS
925: SELECT hp.party_id, hp.party_number
926: FROM hz_parties hp,
927: igs_pe_alt_pers_id api,
928: igs_da_setup ds
929: WHERE ds.s_control_num = 1
930: AND api.api_person_id = p_person_id_code
931: AND api.person_id_type = ds.default_student_id_type

Line 956: p_person_id_code IN igs_pe_alt_pers_id.api_person_id%TYPE,

952: END;
953:
954: PROCEDURE update_stdnts_err (
955: p_batch_id IN igs_da_req_stdnts.batch_id%TYPE,
956: p_person_id_code IN igs_pe_alt_pers_id.api_person_id%TYPE,
957: p_person_id_code_type IN igs_pe_alt_pers_id.person_id_type%TYPE,
958: p_report_text IN igs_da_req_stdnts.report_text%TYPE,
959: p_error_code IN igs_da_req_stdnts.error_code%TYPE,
960: x_return_status OUT NOCOPY VARCHAR2

Line 957: p_person_id_code_type IN igs_pe_alt_pers_id.person_id_type%TYPE,

953:
954: PROCEDURE update_stdnts_err (
955: p_batch_id IN igs_da_req_stdnts.batch_id%TYPE,
956: p_person_id_code IN igs_pe_alt_pers_id.api_person_id%TYPE,
957: p_person_id_code_type IN igs_pe_alt_pers_id.person_id_type%TYPE,
958: p_report_text IN igs_da_req_stdnts.report_text%TYPE,
959: p_error_code IN igs_da_req_stdnts.error_code%TYPE,
960: x_return_status OUT NOCOPY VARCHAR2
961: ) IS

Line 1030: p_person_id_code IN igs_pe_alt_pers_id.api_person_id%TYPE,

1026:
1027:
1028: PROCEDURE update_req_students (
1029: p_batch_id IN igs_da_req_stdnts.batch_id%TYPE,
1030: p_person_id_code IN igs_pe_alt_pers_id.api_person_id%TYPE,
1031: p_person_id_code_type IN igs_pe_alt_pers_id.person_id_type%TYPE,
1032: p_report_text IN igs_da_req_stdnts.report_text%TYPE,
1033: p_academicsubprogram_codes IN VARCHAR2,
1034: p_program_code IN igs_da_req_stdnts.program_code%TYPE,

Line 1031: p_person_id_code_type IN igs_pe_alt_pers_id.person_id_type%TYPE,

1027:
1028: PROCEDURE update_req_students (
1029: p_batch_id IN igs_da_req_stdnts.batch_id%TYPE,
1030: p_person_id_code IN igs_pe_alt_pers_id.api_person_id%TYPE,
1031: p_person_id_code_type IN igs_pe_alt_pers_id.person_id_type%TYPE,
1032: p_report_text IN igs_da_req_stdnts.report_text%TYPE,
1033: p_academicsubprogram_codes IN VARCHAR2,
1034: p_program_code IN igs_da_req_stdnts.program_code%TYPE,
1035: p_error_code IN igs_da_req_stdnts.error_code%TYPE,

Line 1316: p_person_id_code IN igs_pe_alt_pers_id.api_person_id%TYPE,

1312:
1313: PROCEDURE insert_gpa
1314: (
1315: p_batch_id IN igs_pr_stu_acad_stat_int.batch_id%TYPE,
1316: p_person_id_code IN igs_pe_alt_pers_id.api_person_id%TYPE,
1317: p_person_id_code_type IN igs_pe_alt_pers_id.person_id_type%TYPE,
1318: p_program_code IN igs_da_req_stdnts.program_code%TYPE,
1319: p_alternate_code IN igs_pr_stu_acad_stat_int.alternate_code%TYPE,
1320: p_stat_type IN igs_pr_stu_acad_stat_int.stat_type%TYPE,

Line 1317: p_person_id_code_type IN igs_pe_alt_pers_id.person_id_type%TYPE,

1313: PROCEDURE insert_gpa
1314: (
1315: p_batch_id IN igs_pr_stu_acad_stat_int.batch_id%TYPE,
1316: p_person_id_code IN igs_pe_alt_pers_id.api_person_id%TYPE,
1317: p_person_id_code_type IN igs_pe_alt_pers_id.person_id_type%TYPE,
1318: p_program_code IN igs_da_req_stdnts.program_code%TYPE,
1319: p_alternate_code IN igs_pr_stu_acad_stat_int.alternate_code%TYPE,
1320: p_stat_type IN igs_pr_stu_acad_stat_int.stat_type%TYPE,
1321: p_timeframe IN igs_pr_stu_acad_stat_int.timeframe%TYPE,

Line 1407: p_person_id_code IN igs_pe_alt_pers_id.api_person_id%TYPE,

1403:
1404: PROCEDURE insert_program_completion
1405: (
1406: p_batch_id IN igs_pr_spa_complete_int.batch_id%TYPE,
1407: p_person_id_code IN igs_pe_alt_pers_id.api_person_id%TYPE,
1408: p_person_id_code_type IN igs_pe_alt_pers_id.person_id_type%TYPE,
1409: p_program_code IN igs_da_req_stdnts.program_code%TYPE,
1410: p_program_complete IN VARCHAR2,
1411: p_program_complete_date IN VARCHAR2,

Line 1408: p_person_id_code_type IN igs_pe_alt_pers_id.person_id_type%TYPE,

1404: PROCEDURE insert_program_completion
1405: (
1406: p_batch_id IN igs_pr_spa_complete_int.batch_id%TYPE,
1407: p_person_id_code IN igs_pe_alt_pers_id.api_person_id%TYPE,
1408: p_person_id_code_type IN igs_pe_alt_pers_id.person_id_type%TYPE,
1409: p_program_code IN igs_da_req_stdnts.program_code%TYPE,
1410: p_program_complete IN VARCHAR2,
1411: p_program_complete_date IN VARCHAR2,
1412: x_return_status OUT NOCOPY VARCHAR2