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_PHONES_V

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

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
29: Added the validation for contact party id in process_institution_contacts

Line 547: l_phone_id igs_or_phones_v.phone_id%TYPE;

543: l_pty_id hz_parties.party_id%TYPE;
544: l_update_success BOOLEAN;
545: l_dml_operation VARCHAR2(10);
546: l_row_id ROWID;
547: l_phone_id igs_or_phones_v.phone_id%TYPE;
548: l_msg_cnt NUMBER;
549: l_msg_dt VARCHAR2(1000);
550: l_ret_status VARCHAR2(1);
551: l_last_update_date DATE;