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_TRNS_IMP dependencies on HZ_PARTIES

Line 44: p_person_id IN hz_parties.party_id%TYPE,

40: END write_message;
41:
42: PROCEDURE notify_error (
43: p_batch_id IN igs_da_rqst.batch_id%TYPE,
44: p_person_id IN hz_parties.party_id%TYPE,
45: p_program_code IN igs_av_lgcy_unt_int.program_cd%TYPE,
46: p_msg IN VARCHAR2
47: )
48: IS

Line 97: FROM hz_parties p, igs_pe_hz_parties hp

93: AS
94: CURSOR c_val_inst_cd_non_uk_cur
95: IS
96: SELECT hp.ROWID row_id
97: FROM hz_parties p, igs_pe_hz_parties hp
98: WHERE hp.party_id = p.party_id
99: AND hp.inst_org_ind = 'I'
100: AND p.party_number = person_history_rec.prev_institution_code;
101:

Line 105: FROM hz_parties p,

101:
102: CURSOR c_val_inst_cd_uk_cur
103: IS
104: SELECT hp.ROWID row_id
105: FROM hz_parties p,
106: igs_pe_hz_parties hp,
107: igs_or_org_inst_type_all oit
108: WHERE hp.party_id = p.party_id
109: AND hp.inst_org_ind = 'I'

Line 106: igs_pe_hz_parties hp,

102: CURSOR c_val_inst_cd_uk_cur
103: IS
104: SELECT hp.ROWID row_id
105: FROM hz_parties p,
106: igs_pe_hz_parties hp,
107: igs_or_org_inst_type_all oit
108: WHERE hp.party_id = p.party_id
109: AND hp.inst_org_ind = 'I'
110: AND p.party_number = person_history_rec.prev_institution_code

Line 366: FROM hz_education h1, hz_parties h2

362:
363: CURSOR c_edu_id
364: IS
365: SELECT h1.education_id
366: FROM hz_education h1, hz_parties h2
367: WHERE h1.party_id = acad_hist_rec.person_id
368: AND h2.party_number = acad_hist_rec.prev_institution_code
369: AND h2.party_id = h1.school_party_id
370: ORDER BY h1.creation_date DESC;

Line 422: PROCEDURE delete_adv_stnd_records (p_person_id IN hz_parties.party_id%TYPE)

418: THEN
419: write_message('ERROR ' || sqlerrm);
420: END prc_pe_acad_hist;
421:
422: PROCEDURE delete_adv_stnd_records (p_person_id IN hz_parties.party_id%TYPE)
423: AS
424: CURSOR c_edu_id
425: IS
426: SELECT education_id

Line 1009: p_person_id IN hz_parties.party_id%TYPE,

1005: END create_term_unit_details;
1006:
1007: FUNCTION process_term_unit_details (
1008: p_batch_id IN igs_da_req_stdnts.batch_id%TYPE,
1009: p_person_id IN hz_parties.party_id%TYPE,
1010: p_program_cd IN igs_av_lgcy_unt_int.program_cd%TYPE,
1011: p_trans_cur_rec IN OUT NOCOPY trans_cur_rec
1012: )
1013: RETURN igs_ad_term_unitdtls.unit_details_id%TYPE

Line 1282: p_person_id IN hz_parties.party_id%TYPE,

1278: END update_term_details;
1279:
1280: PROCEDURE process_term_details (
1281: p_batch_id IN igs_da_req_stdnts.batch_id%TYPE,
1282: p_person_id IN hz_parties.party_id%TYPE,
1283: p_program_cd IN igs_av_lgcy_unt_int.program_cd%TYPE,
1284: p_trans_cur_rec IN OUT NOCOPY trans_cur_rec
1285: )
1286: AS

Line 1414: l_person_number hz_parties.party_number%TYPE;

1410: FROM hz_education hz
1411: WHERE education_id = l_trans_cur_rec.education_id;
1412:
1413: dup_cur_rec c_dup_cur%ROWTYPE;
1414: l_person_number hz_parties.party_number%TYPE;
1415: l_school_party_id hz_parties.party_id%TYPE;
1416: l_edu_rec c_edu%ROWTYPE;
1417: l_edu_id_rec c_edu_id%ROWTYPE;
1418: BEGIN

Line 1415: l_school_party_id hz_parties.party_id%TYPE;

1411: WHERE education_id = l_trans_cur_rec.education_id;
1412:
1413: dup_cur_rec c_dup_cur%ROWTYPE;
1414: l_person_number hz_parties.party_number%TYPE;
1415: l_school_party_id hz_parties.party_id%TYPE;
1416: l_edu_rec c_edu%ROWTYPE;
1417: l_edu_id_rec c_edu_id%ROWTYPE;
1418: BEGIN
1419: write_message (' p_batch_id ' || p_batch_id);

Line 1977: CURSOR c_ind (cp_party_id igs_pe_hz_parties.party_id%TYPE)

1973: /*
1974: check whether person is deceased or not
1975: */
1976: DECLARE
1977: CURSOR c_ind (cp_party_id igs_pe_hz_parties.party_id%TYPE)
1978: IS
1979: SELECT deceased_ind
1980: FROM igs_pe_hz_parties
1981: WHERE party_id = cp_party_id;

Line 1980: FROM igs_pe_hz_parties

1976: DECLARE
1977: CURSOR c_ind (cp_party_id igs_pe_hz_parties.party_id%TYPE)
1978: IS
1979: SELECT deceased_ind
1980: FROM igs_pe_hz_parties
1981: WHERE party_id = cp_party_id;
1982:
1983: l_ind igs_pe_hz_parties.deceased_ind%TYPE;
1984: BEGIN

Line 1983: l_ind igs_pe_hz_parties.deceased_ind%TYPE;

1979: SELECT deceased_ind
1980: FROM igs_pe_hz_parties
1981: WHERE party_id = cp_party_id;
1982:
1983: l_ind igs_pe_hz_parties.deceased_ind%TYPE;
1984: BEGIN
1985: OPEN c_ind (p_person_id);
1986: FETCH c_ind INTO l_ind;
1987: CLOSE c_ind;

Line 2019: FROM hz_parties hp, igs_pe_hz_parties ihp

2015: ihp.oss_org_unit_cd exemption_institution_cd, hp.party_name,
2016: ihp.oi_institution_status, 'INSTITUTION CODE' SOURCE, hp.created_by,
2017: hp.creation_date, hp.last_updated_by, hp.last_update_date,
2018: hp.last_update_login
2019: FROM hz_parties hp, igs_pe_hz_parties ihp
2020: WHERE hp.party_id = ihp.party_id
2021: AND ihp.inst_org_ind = 'I'
2022: AND ihp.oi_institution_status = 'ACTIVE'
2023: AND ihp.oss_org_unit_cd = cp_exemption_institution_cd;

Line 2716: SELECT hz_parties.party_id

2712:
2713:
2714: CURSOR c_requestor_id
2715: IS
2716: SELECT hz_parties.party_id
2717: FROM hz_parties, fnd_user
2718: WHERE fnd_user.customer_id = hz_parties.party_id
2719: AND fnd_user.user_id = fnd_profile.VALUE ('IGS_DA_WF_ADMIN');
2720:

Line 2717: FROM hz_parties, fnd_user

2713:
2714: CURSOR c_requestor_id
2715: IS
2716: SELECT hz_parties.party_id
2717: FROM hz_parties, fnd_user
2718: WHERE fnd_user.customer_id = hz_parties.party_id
2719: AND fnd_user.user_id = fnd_profile.VALUE ('IGS_DA_WF_ADMIN');
2720:
2721:

Line 2718: WHERE fnd_user.customer_id = hz_parties.party_id

2714: CURSOR c_requestor_id
2715: IS
2716: SELECT hz_parties.party_id
2717: FROM hz_parties, fnd_user
2718: WHERE fnd_user.customer_id = hz_parties.party_id
2719: AND fnd_user.user_id = fnd_profile.VALUE ('IGS_DA_WF_ADMIN');
2720:
2721:
2722:

Line 2725: v_dummy hz_parties.party_id%TYPE;

2721:
2722:
2723: l_adv_stnd_unt c_adv_stnd_unt%ROWTYPE;
2724: l_grant_status igs_av_stnd_unit_all.s_adv_stnd_granting_status%TYPE;
2725: v_dummy hz_parties.party_id%TYPE;
2726: v_rowid ROWID;
2727: BEGIN
2728: write_message (' p_batch_id => ' || p_batch_id);
2729: write_message ( ' p_unit_details_id => '

Line 3331: CURSOR c_stdnts_batch (p_person_id hz_parties.party_id%TYPE)

3327: SELECT requestor_id
3328: FROM igs_da_rqst
3329: WHERE batch_id = p_batch_id;
3330:
3331: CURSOR c_stdnts_batch (p_person_id hz_parties.party_id%TYPE)
3332: IS
3333: SELECT 'x'
3334: FROM igs_da_req_stdnts
3335: WHERE batch_id = p_batch_id

Line 3341: SELECT hz_parties.party_id

3337: AND ERROR_CODE = 'INP';
3338:
3339: CURSOR c_requestor_id
3340: IS
3341: SELECT hz_parties.party_id
3342: FROM hz_parties, fnd_user
3343: WHERE fnd_user.customer_id = hz_parties.party_id
3344: AND fnd_user.user_id = fnd_profile.VALUE ('IGS_DA_WF_ADMIN');
3345:

Line 3342: FROM hz_parties, fnd_user

3338:
3339: CURSOR c_requestor_id
3340: IS
3341: SELECT hz_parties.party_id
3342: FROM hz_parties, fnd_user
3343: WHERE fnd_user.customer_id = hz_parties.party_id
3344: AND fnd_user.user_id = fnd_profile.VALUE ('IGS_DA_WF_ADMIN');
3345:
3346: l_request_type_id igs_da_cnfg_req_typ.request_type_id%TYPE;

Line 3343: WHERE fnd_user.customer_id = hz_parties.party_id

3339: CURSOR c_requestor_id
3340: IS
3341: SELECT hz_parties.party_id
3342: FROM hz_parties, fnd_user
3343: WHERE fnd_user.customer_id = hz_parties.party_id
3344: AND fnd_user.user_id = fnd_profile.VALUE ('IGS_DA_WF_ADMIN');
3345:
3346: l_request_type_id igs_da_cnfg_req_typ.request_type_id%TYPE;
3347: l_batch_id igs_da_rqst.batch_id%TYPE;

Line 3348: l_person_id hz_parties.party_id%TYPE;

3344: AND fnd_user.user_id = fnd_profile.VALUE ('IGS_DA_WF_ADMIN');
3345:
3346: l_request_type_id igs_da_cnfg_req_typ.request_type_id%TYPE;
3347: l_batch_id igs_da_rqst.batch_id%TYPE;
3348: l_person_id hz_parties.party_id%TYPE;
3349: l_requestor_person_id hz_parties.party_id%TYPE;
3350: l_person_number hz_parties.party_number%TYPE;
3351: v_dummy VARCHAR2 (1);
3352: v_dummy_rowid ROWID;

Line 3349: l_requestor_person_id hz_parties.party_id%TYPE;

3345:
3346: l_request_type_id igs_da_cnfg_req_typ.request_type_id%TYPE;
3347: l_batch_id igs_da_rqst.batch_id%TYPE;
3348: l_person_id hz_parties.party_id%TYPE;
3349: l_requestor_person_id hz_parties.party_id%TYPE;
3350: l_person_number hz_parties.party_number%TYPE;
3351: v_dummy VARCHAR2 (1);
3352: v_dummy_rowid ROWID;
3353: l_return_status VARCHAR2 (500);

Line 3350: l_person_number hz_parties.party_number%TYPE;

3346: l_request_type_id igs_da_cnfg_req_typ.request_type_id%TYPE;
3347: l_batch_id igs_da_rqst.batch_id%TYPE;
3348: l_person_id hz_parties.party_id%TYPE;
3349: l_requestor_person_id hz_parties.party_id%TYPE;
3350: l_person_number hz_parties.party_number%TYPE;
3351: v_dummy VARCHAR2 (1);
3352: v_dummy_rowid ROWID;
3353: l_return_status VARCHAR2 (500);
3354: l_msg_data VARCHAR2 (2000);