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_CONTACTS_V

Line 24: In igs_or_contacts_v.insert_row and igs_or_contacts_v.update_row all the attributes that references to customer are removed

20: Cursor rel_party_id_cur is added to get relationship party id
21: Cursor cur_get_lst_date is modified to get last_update_date from HZ_ORG_CONTACT_ROLES table
22: In Procedure process_contact_phones rel_party_id is passed as argument instead of cust_acct_role_id
23: In Cursor cur_get_oss_phones reference to cust_acct_role_id is removed and owner_table_id is used to pick the record
24: In igs_or_contacts_v.insert_row and igs_or_contacts_v.update_row all the attributes that references to customer are removed
25: In igs_or_phones_v.insert_row and igs_or_phones_v.update_row all the attributes that references to customer are removed
26: pkpatel 25-OCT-2002 Bug No: 2613704
27: Modified stat_type_id to stat_type_cd
28: pkpatel 3-JAn-2003 Bug 2730137

Line 308: l_org_contact_id igs_or_contacts_v.org_contact_id%TYPE;

304: l_sys_refer hz_parties.orig_system_reference%TYPE;
305: l_last_update_date DATE;
306: l_party_last_update_date DATE;
307: l_org_cont_last_update_date DATE;
308: l_org_contact_id igs_or_contacts_v.org_contact_id%TYPE;
309: l_or_cont_id igs_or_contacts_v.org_contact_id%TYPE;
310: l_org_id igs_pe_typ_instances_all.org_id%TYPE;
311: l_instance_id igs_pe_typ_instances.type_instance_id%TYPE;
312: l_contact_point_id igs_or_contacts_v.org_contact_id%TYPE;

Line 309: l_or_cont_id igs_or_contacts_v.org_contact_id%TYPE;

305: l_last_update_date DATE;
306: l_party_last_update_date DATE;
307: l_org_cont_last_update_date DATE;
308: l_org_contact_id igs_or_contacts_v.org_contact_id%TYPE;
309: l_or_cont_id igs_or_contacts_v.org_contact_id%TYPE;
310: l_org_id igs_pe_typ_instances_all.org_id%TYPE;
311: l_instance_id igs_pe_typ_instances.type_instance_id%TYPE;
312: l_contact_point_id igs_or_contacts_v.org_contact_id%TYPE;
313: l_contact_number igs_or_contacts_v.contact_number%TYPE;

Line 312: l_contact_point_id igs_or_contacts_v.org_contact_id%TYPE;

308: l_org_contact_id igs_or_contacts_v.org_contact_id%TYPE;
309: l_or_cont_id igs_or_contacts_v.org_contact_id%TYPE;
310: l_org_id igs_pe_typ_instances_all.org_id%TYPE;
311: l_instance_id igs_pe_typ_instances.type_instance_id%TYPE;
312: l_contact_point_id igs_or_contacts_v.org_contact_id%TYPE;
313: l_contact_number igs_or_contacts_v.contact_number%TYPE;
314: l_cont_dml_operation VARCHAR2(10);
315: l_lst_update_date DATE;
316: l_org_contact_role_id igs_or_contacts_v.contact_id%TYPE;

Line 313: l_contact_number igs_or_contacts_v.contact_number%TYPE;

309: l_or_cont_id igs_or_contacts_v.org_contact_id%TYPE;
310: l_org_id igs_pe_typ_instances_all.org_id%TYPE;
311: l_instance_id igs_pe_typ_instances.type_instance_id%TYPE;
312: l_contact_point_id igs_or_contacts_v.org_contact_id%TYPE;
313: l_contact_number igs_or_contacts_v.contact_number%TYPE;
314: l_cont_dml_operation VARCHAR2(10);
315: l_lst_update_date DATE;
316: l_org_contact_role_id igs_or_contacts_v.contact_id%TYPE;
317: l_rel_party_id igs_or_contacts_v.rel_party_id%TYPE;

Line 316: l_org_contact_role_id igs_or_contacts_v.contact_id%TYPE;

312: l_contact_point_id igs_or_contacts_v.org_contact_id%TYPE;
313: l_contact_number igs_or_contacts_v.contact_number%TYPE;
314: l_cont_dml_operation VARCHAR2(10);
315: l_lst_update_date DATE;
316: l_org_contact_role_id igs_or_contacts_v.contact_id%TYPE;
317: l_rel_party_id igs_or_contacts_v.rel_party_id%TYPE;
318: l_type_rowid ROWID;
319: l_cont_point_last_update_date DATE;
320: l_prel_last_update_date DATE;

Line 317: l_rel_party_id igs_or_contacts_v.rel_party_id%TYPE;

313: l_contact_number igs_or_contacts_v.contact_number%TYPE;
314: l_cont_dml_operation VARCHAR2(10);
315: l_lst_update_date DATE;
316: l_org_contact_role_id igs_or_contacts_v.contact_id%TYPE;
317: l_rel_party_id igs_or_contacts_v.rel_party_id%TYPE;
318: l_type_rowid ROWID;
319: l_cont_point_last_update_date DATE;
320: l_prel_last_update_date DATE;
321: l_rel_party_last_update_date DATE;

Line 330: l_org_role_ovn igs_or_contacts_v.org_role_ovn%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;
332: l_rel_party_ovn igs_or_contacts_v.rel_party_ovn%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;

Line 331: l_rel_ovn igs_or_contacts_v.rel_ovn%TYPE;

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;
332: l_rel_party_ovn igs_or_contacts_v.rel_party_ovn%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:

Line 332: l_rel_party_ovn igs_or_contacts_v.rel_party_ovn%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;
332: l_rel_party_ovn igs_or_contacts_v.rel_party_ovn%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

Line 333: l_org_cont_ovn igs_or_contacts_v.org_cont_ovn%TYPE;

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;
332: l_rel_party_ovn igs_or_contacts_v.rel_party_ovn%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,

Line 372: CURSOR email_cur (cp_rel_party_id igs_or_contacts_v.rel_party_id%TYPE,

368: AND REL.SUBJECT_ID = p_contact_party_id
369: AND REL.OBJECT_ID = cp_party_id;
370:
371: -- ssawhney added OVN
372: CURSOR email_cur (cp_rel_party_id igs_or_contacts_v.rel_party_id%TYPE,
373: cp_contact_point_type hz_contact_points.contact_point_type%TYPE,
374: cp_owner_table_name hz_contact_points.owner_table_name%TYPE) IS
375: SELECT email_address, contact_point_id, object_version_number
376: FROM hz_contact_points

Line 534: p_rel_party_id IN igs_or_contacts_v.rel_party_id%TYPE)

530: END associate_persontype;
531:
532: --Process the Contact Phones
533: PROCEDURE process_contact_phones( p_interface_cont_id IN igs_or_inst_cphn_int.interface_inst_cont_phone_id%TYPE,
534: p_rel_party_id IN igs_or_contacts_v.rel_party_id%TYPE)
535: /*
536: || Change History
537: ||
538: || Who When What

Line 539: || ssawhney OVN logic added. change to signature of IGS_OR_CONTACTS_V

535: /*
536: || Change History
537: ||
538: || Who When What
539: || ssawhney OVN logic added. change to signature of IGS_OR_CONTACTS_V
540: */
541: AS
542: l_insert_success BOOLEAN;
543: l_pty_id hz_parties.party_id%TYPE;