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 HZ_PARTIES

Line 827: FROM hz_parties p, igs_en_stdnt_ps_att spa, igs_ps_ver crv, igs_ca_teach_to_load_v ttl,

823: suao_gsg_table t_suao_gsg_table;
824: --
825: CURSOR repeatable_cur is
826: SELECT uv.repeatable_ind
827: FROM hz_parties p, igs_en_stdnt_ps_att spa, igs_ps_ver crv, igs_ca_teach_to_load_v ttl,
828: igs_en_su_attempt sua, igs_ps_unit_ver uv, igs_ps_unit_ofr_opt uoo, IGS_PS_PRG_UNIT_REL pur,
829: igs_as_su_atmptout_h_all atm
830: WHERE p.party_id = sua.person_id
831: AND sua.person_id = p_person_id

Line 916: p_person_id OUT NOCOPY hz_parties.party_id%TYPE,

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
920: SELECT hp.party_id

Line 917: p_person_number OUT NOCOPY hz_parties.party_number%TYPE) IS

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
920: SELECT hp.party_id
921: FROM hz_parties hp

Line 921: FROM hz_parties hp

917: p_person_number OUT NOCOPY hz_parties.party_number%TYPE) IS
918:
919: CURSOR c1 IS
920: SELECT hp.party_id
921: FROM hz_parties hp
922: WHERE hp.party_number = p_person_id_code;
923:
924: CURSOR c2 IS
925: SELECT hp.party_id, hp.party_number

Line 926: FROM hz_parties hp,

922: WHERE hp.party_number = p_person_id_code;
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

Line 963: l_person_id hz_parties.party_id%TYPE;

959: p_error_code IN igs_da_req_stdnts.error_code%TYPE,
960: x_return_status OUT NOCOPY VARCHAR2
961: ) IS
962: l_err_msg_pos1 VARCHAR2(30);
963: l_person_id hz_parties.party_id%TYPE;
964: l_person_number hz_parties.party_number%TYPE;
965:
966:
967: CURSOR c1 IS

Line 964: l_person_number hz_parties.party_number%TYPE;

960: x_return_status OUT NOCOPY VARCHAR2
961: ) IS
962: l_err_msg_pos1 VARCHAR2(30);
963: l_person_id hz_parties.party_id%TYPE;
964: l_person_number hz_parties.party_number%TYPE;
965:
966:
967: CURSOR c1 IS
968: SELECT ROWID,drs.*

Line 1041: l_person_id hz_parties.party_id%TYPE;

1037: ) IS
1038:
1039: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_REQ_STUDENTS';
1040: l_error_code VARCHAR2(30);
1041: l_person_id hz_parties.party_id%TYPE;
1042: l_person_number hz_parties.party_number%TYPE;
1043: l_progmajor_ind igs_da_setup.program_definition_ind%TYPE;
1044: l_prog_comparison_type igs_da_rqst.program_comparison_type%TYPE;
1045: pos1 NUMBER ;

Line 1042: l_person_number hz_parties.party_number%TYPE;

1038:
1039: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_REQ_STUDENTS';
1040: l_error_code VARCHAR2(30);
1041: l_person_id hz_parties.party_id%TYPE;
1042: l_person_number hz_parties.party_number%TYPE;
1043: l_progmajor_ind igs_da_setup.program_definition_ind%TYPE;
1044: l_prog_comparison_type igs_da_rqst.program_comparison_type%TYPE;
1045: pos1 NUMBER ;
1046: pos2 NUMBER ;

Line 1331: l_person_id hz_parties.party_id%TYPE;

1327: x_return_status OUT NOCOPY VARCHAR2
1328: ) IS
1329:
1330: l_api_name CONSTANT VARCHAR2(30) := 'INSERT_GPA';
1331: l_person_id hz_parties.party_id%TYPE;
1332: l_person_number hz_parties.party_number%TYPE;
1333: l_program_code igs_pr_stu_acad_stat_int.course_cd%TYPE;
1334:
1335: CURSOR c1 IS

Line 1332: l_person_number hz_parties.party_number%TYPE;

1328: ) IS
1329:
1330: l_api_name CONSTANT VARCHAR2(30) := 'INSERT_GPA';
1331: l_person_id hz_parties.party_id%TYPE;
1332: l_person_number hz_parties.party_number%TYPE;
1333: l_program_code igs_pr_stu_acad_stat_int.course_cd%TYPE;
1334:
1335: CURSOR c1 IS
1336: SELECT drs.program_code

Line 1416: l_person_id hz_parties.party_id%TYPE;

1412: x_return_status OUT NOCOPY VARCHAR2
1413: ) IS
1414:
1415: l_api_name CONSTANT VARCHAR2(30) := 'INSERT_PROGRAM_COMPLETION';
1416: l_person_id hz_parties.party_id%TYPE;
1417: l_person_number hz_parties.party_number%TYPE;
1418: l_program_code igs_pr_spa_complete_int.course_cd%TYPE;
1419:
1420: CURSOR c1 IS

Line 1417: l_person_number hz_parties.party_number%TYPE;

1413: ) IS
1414:
1415: l_api_name CONSTANT VARCHAR2(30) := 'INSERT_PROGRAM_COMPLETION';
1416: l_person_id hz_parties.party_id%TYPE;
1417: l_person_number hz_parties.party_number%TYPE;
1418: l_program_code igs_pr_spa_complete_int.course_cd%TYPE;
1419:
1420: CURSOR c1 IS
1421: SELECT drs.program_code

Line 1975: FROM hz_parties

1971:
1972: FUNCTION get_person (pp_person_id igs_da_req_stdnts.person_id%TYPE) RETURN VARCHAR2 IS
1973: CURSOR c_get_pers (cp_person_id igs_da_req_stdnts.person_id%TYPE) IS
1974: SELECT party_name||' ('||party_number||') '
1975: FROM hz_parties
1976: WHERE party_id = cp_person_id;
1977: v_get_pers VARCHAR2(4000);
1978: BEGIN
1979: OPEN c_get_pers (pp_person_id);