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_OR_INST_IMP_003_PKG dependencies on IGS_OR_INST_CON_INT

Line 280: p_interface_id IN igs_or_inst_con_int.interface_id%TYPE,

276:
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

Line 327: l_val_fail_err_cd igs_or_inst_con_int.error_code%TYPE;

323: l_msg_count NUMBER;
324: l_msg_data VARCHAR2(1000);
325: l_email_address hz_contact_points.email_address%TYPE;
326: SKIP_CONTACT EXCEPTION;
327: l_val_fail_err_cd igs_or_inst_con_int.error_code%TYPE;
328: l_exists VARCHAR2(1);
329:
330: l_org_role_ovn igs_or_contacts_v.org_role_ovn%TYPE;
331: l_rel_ovn igs_or_contacts_v.rel_ovn%TYPE;

Line 337: CURSOR cur_get_int_contacts(cp_interface_id igs_or_inst_con_int.interface_id%TYPE,

333: l_org_cont_ovn igs_or_contacts_v.org_cont_ovn%TYPE;
334: l_contact_point_ovn hz_contact_points.object_version_number%TYPE;
335:
336: --Cursor to fetch the Pending Interface Contacts
337: CURSOR cur_get_int_contacts(cp_interface_id igs_or_inst_con_int.interface_id%TYPE,
338: cp_status igs_or_inst_con_int.status%TYPE) IS
339: SELECT *
340: FROM igs_or_inst_con_int
341: WHERE interface_id = cp_interface_id

Line 338: cp_status igs_or_inst_con_int.status%TYPE) IS

334: l_contact_point_ovn hz_contact_points.object_version_number%TYPE;
335:
336: --Cursor to fetch the Pending Interface Contacts
337: CURSOR cur_get_int_contacts(cp_interface_id igs_or_inst_con_int.interface_id%TYPE,
338: cp_status igs_or_inst_con_int.status%TYPE) IS
339: SELECT *
340: FROM igs_or_inst_con_int
341: WHERE interface_id = cp_interface_id
342: AND status = cp_status;

Line 340: FROM igs_or_inst_con_int

336: --Cursor to fetch the Pending Interface Contacts
337: CURSOR cur_get_int_contacts(cp_interface_id igs_or_inst_con_int.interface_id%TYPE,
338: cp_status igs_or_inst_con_int.status%TYPE) IS
339: SELECT *
340: FROM igs_or_inst_con_int
341: WHERE interface_id = cp_interface_id
342: AND status = cp_status;
343:
344: --Cursor to check if such a Contact ID exists in OSS

Line 345: CURSOR cur_get_oss_contacts(p_contact_party_id igs_or_inst_con_int.contact_party_id%TYPE,cp_party_id hz_parties.party_id%TYPE) IS

341: WHERE interface_id = cp_interface_id
342: AND status = cp_status;
343:
344: --Cursor to check if such a Contact ID exists in OSS
345: CURSOR cur_get_oss_contacts(p_contact_party_id igs_or_inst_con_int.contact_party_id%TYPE,cp_party_id hz_parties.party_id%TYPE) IS
346: SELECT org_conts.attribute_category, org_conts.attribute10, org_conts.attribute11, org_conts.attribute12,
347: org_conts.attribute13, org_conts.attribute14, org_conts.attribute15, org_conts.attribute16,
348: org_conts.attribute17, org_conts.attribute18, org_conts.attribute19, org_conts.attribute20,
349: org_conts.attribute1, org_conts.attribute2, org_conts.attribute21, org_conts.attribute22,

Line 382: CURSOR c_val_contact_title(p_title igs_or_inst_con_int.title%TYPE,

378: AND contact_point_type = cp_contact_point_type
379: AND owner_table_name = cp_owner_table_name;
380:
381: --cursor for field level validation of data , for TITLE field (tray)
382: CURSOR c_val_contact_title(p_title igs_or_inst_con_int.title%TYPE,
383: cp_lookup_type fnd_lookup_values.lookup_type%TYPE,
384: cp_enabled_flag fnd_lookup_values.enabled_flag%TYPE) IS
385: SELECT 'X'
386: FROM fnd_lookup_values

Line 403: PROCEDURE update_int_contact(p_status igs_or_inst_con_int.status%TYPE,

399: oss_cont_rec cur_get_oss_contacts%ROWTYPE;
400: c_val_contact_title_rec c_val_contact_title%ROWTYPE;
401:
402: --Procedure to Update the status of the Contact Id's Interface Record
403: PROCEDURE update_int_contact(p_status igs_or_inst_con_int.status%TYPE,
404: p_interface_contacts_id igs_or_inst_con_int.interface_contacts_id%TYPE,
405: p_contact_party_id igs_or_inst_con_int.contact_party_id%TYPE,
406: p_err_code igs_or_inst_con_int.error_code%TYPE,
407: p_err_text igs_or_inst_con_int.error_text%TYPE

Line 404: p_interface_contacts_id igs_or_inst_con_int.interface_contacts_id%TYPE,

400: c_val_contact_title_rec c_val_contact_title%ROWTYPE;
401:
402: --Procedure to Update the status of the Contact Id's Interface Record
403: PROCEDURE update_int_contact(p_status igs_or_inst_con_int.status%TYPE,
404: p_interface_contacts_id igs_or_inst_con_int.interface_contacts_id%TYPE,
405: p_contact_party_id igs_or_inst_con_int.contact_party_id%TYPE,
406: p_err_code igs_or_inst_con_int.error_code%TYPE,
407: p_err_text igs_or_inst_con_int.error_text%TYPE
408: )

Line 405: p_contact_party_id igs_or_inst_con_int.contact_party_id%TYPE,

401:
402: --Procedure to Update the status of the Contact Id's Interface Record
403: PROCEDURE update_int_contact(p_status igs_or_inst_con_int.status%TYPE,
404: p_interface_contacts_id igs_or_inst_con_int.interface_contacts_id%TYPE,
405: p_contact_party_id igs_or_inst_con_int.contact_party_id%TYPE,
406: p_err_code igs_or_inst_con_int.error_code%TYPE,
407: p_err_text igs_or_inst_con_int.error_text%TYPE
408: )
409:

Line 406: p_err_code igs_or_inst_con_int.error_code%TYPE,

402: --Procedure to Update the status of the Contact Id's Interface Record
403: PROCEDURE update_int_contact(p_status igs_or_inst_con_int.status%TYPE,
404: p_interface_contacts_id igs_or_inst_con_int.interface_contacts_id%TYPE,
405: p_contact_party_id igs_or_inst_con_int.contact_party_id%TYPE,
406: p_err_code igs_or_inst_con_int.error_code%TYPE,
407: p_err_text igs_or_inst_con_int.error_text%TYPE
408: )
409:
410: AS

Line 407: p_err_text igs_or_inst_con_int.error_text%TYPE

403: PROCEDURE update_int_contact(p_status igs_or_inst_con_int.status%TYPE,
404: p_interface_contacts_id igs_or_inst_con_int.interface_contacts_id%TYPE,
405: p_contact_party_id igs_or_inst_con_int.contact_party_id%TYPE,
406: p_err_code igs_or_inst_con_int.error_code%TYPE,
407: p_err_text igs_or_inst_con_int.error_text%TYPE
408: )
409:
410: AS
411:

Line 415: UPDATE igs_or_inst_con_int

411:
412: BEGIN
413:
414: --Since there is no TBH direct Updation on Table
415: UPDATE igs_or_inst_con_int
416: SET status = p_status ,
417: error_code = p_err_code,
418: error_text = p_err_text
419: WHERE interface_contacts_id =p_interface_contacts_id;

Line 437: PROCEDURE associate_persontype(p_interface_contacts_id igs_or_inst_con_int.interface_contacts_id%TYPE,

433:
434: END update_int_contact;
435:
436: --Associate the person type
437: PROCEDURE associate_persontype(p_interface_contacts_id igs_or_inst_con_int.interface_contacts_id%TYPE,
438: p_contact_party_id igs_or_inst_con_int.contact_party_id%TYPE
439: ) IS
440:
441: l_person_type igs_pe_typ_instances.person_type_code%TYPE;

Line 438: p_contact_party_id igs_or_inst_con_int.contact_party_id%TYPE

434: END update_int_contact;
435:
436: --Associate the person type
437: PROCEDURE associate_persontype(p_interface_contacts_id igs_or_inst_con_int.interface_contacts_id%TYPE,
438: p_contact_party_id igs_or_inst_con_int.contact_party_id%TYPE
439: ) IS
440:
441: l_person_type igs_pe_typ_instances.person_type_code%TYPE;
442:

Line 444: CURSOR cur_person_type(cp_contact_party_id igs_or_inst_con_int.contact_party_id%TYPE) IS

440:
441: l_person_type igs_pe_typ_instances.person_type_code%TYPE;
442:
443: --Cursor to fetch person type
444: CURSOR cur_person_type(cp_contact_party_id igs_or_inst_con_int.contact_party_id%TYPE) IS
445: SELECT person_type_code
446: FROM igs_pe_typ_instances_all
447: WHERE person_id = cp_contact_party_id AND
448: SYSDATE BETWEEN start_date AND NVL(end_date,SYSDATE);