APPS.IGS_OR_INST_IMP_003_PKG dependencies on IGS_PE_PERSON

Line 40: gmaheswa 22-Jun-06 Bug 5189180: in process_institution_address, if igs_pe_person_addr_pkg.insert_row returns return_status as 'W' then set erro code E022.

36: d) Error code 'E162' is replaced with 'E049'
37: c) FND_FILE.PUT_LINE method calls replaced with
38: logging mechanism using FND_LOG package
39: gmaheswa 27-Jan-2006 Bug:4938278 : process_institution_address: Raise Address Change event at after processing address data of all persons.
40: gmaheswa 22-Jun-06 Bug 5189180: in process_institution_address, if igs_pe_person_addr_pkg.insert_row returns return_status as 'W' then set erro code E022.
41: ***************************************************************/
42:
43: PROCEDURE process_institution_notes(
44: p_interface_id IN igs_or_inst_nts_int.interface_id%TYPE,

Line 281: p_person_type IN igs_pe_person.party_type%TYPE,

277:
278: --Procedure to process the Contacts
279: PROCEDURE process_institution_contacts(
280: p_interface_id IN igs_or_inst_con_int.interface_id%TYPE,
281: p_person_type IN igs_pe_person.party_type%TYPE,
282: p_party_id IN hz_parties.party_id%TYPE)
283: /***************************************************************
284: Created By : mesriniv
285: Date Created By : 2001/07/12

Line 394: CURSOR check_person_cur(cp_person_id igs_pe_person_base_v.person_id%TYPE) IS

390: AND view_application_id = 222
391: AND security_group_id = 0
392: AND language = userenv('LANG');
393:
394: CURSOR check_person_cur(cp_person_id igs_pe_person_base_v.person_id%TYPE) IS
395: SELECT 'X'
396: FROM igs_pe_person_base_v
397: WHERE person_id = cp_person_id;
398:

Line 396: FROM igs_pe_person_base_v

392: AND language = userenv('LANG');
393:
394: CURSOR check_person_cur(cp_person_id igs_pe_person_base_v.person_id%TYPE) IS
395: SELECT 'X'
396: FROM igs_pe_person_base_v
397: WHERE person_id = cp_person_id;
398:
399: oss_cont_rec cur_get_oss_contacts%ROWTYPE;
400: c_val_contact_title_rec c_val_contact_title%ROWTYPE;

Line 1511: asbala 12-nov-03 3227107: address changes - signature of igs_pe_person_addr_pkg.insert_row changed

1507: ENH Bug No : 1872994
1508: ENH Desc : Modelling and Forcasting DLD- Institutions Build
1509: Who When What
1510: pkpatel 15-MAR-2002 Bug no.2238946 :Added the parameter p_status in the call to igs_pe_party_site_use_pkg
1511: asbala 12-nov-03 3227107: address changes - signature of igs_pe_person_addr_pkg.insert_row changed
1512: ***************************************************************/
1513: AS
1514: l_addr_usage igs_or_adrusge_int.site_use_code%TYPE;
1515: l_existing_usage igs_or_adrusge_int.site_use_code%TYPE;

Line 1792: igs_pe_person_addr_pkg.insert_row

1788: OPEN c_adr_val(int_addr_rec.country);
1789: FETCH c_adr_val into c_adr_val_rec;
1790:
1791: IF c_adr_val%FOUND THEN
1792: igs_pe_person_addr_pkg.insert_row
1793: (
1794: p_action => 'R',
1795: p_rowid => l_addr_row_id,
1796: p_location_id => l_location_id,