APPS.IGS_OR_INST_IMP_003_PKG dependencies on HZ_CONTACT_POINTS

Line 325: l_email_address hz_contact_points.email_address%TYPE;

321: l_rel_party_last_update_date DATE;
322: l_return_status VARCHAR2(1000);
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:

Line 334: l_contact_point_ovn hz_contact_points.object_version_number%TYPE;

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,
338: cp_status igs_or_inst_con_int.status%TYPE) IS

Line 373: cp_contact_point_type hz_contact_points.contact_point_type%TYPE,

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
377: WHERE owner_table_id = cp_rel_party_id

Line 374: cp_owner_table_name hz_contact_points.owner_table_name%TYPE) IS

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
377: WHERE owner_table_id = cp_rel_party_id
378: AND contact_point_type = cp_contact_point_type

Line 376: FROM hz_contact_points

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
377: WHERE owner_table_id = cp_rel_party_id
378: AND contact_point_type = cp_contact_point_type
379: AND owner_table_name = cp_owner_table_name;
380:

Line 555: l_ovn hz_contact_points.object_version_number%TYPE;

551: l_last_update_date DATE;
552: l_orig_sys_ref VARCHAR2(10);
553: SKIP_PHONE EXCEPTION;
554: l_val_fail_err_cd igs_or_inst_cphn_int.error_code%TYPE;
555: l_ovn hz_contact_points.object_version_number%TYPE;
556:
557:
558: --Cursor to fetch the Phone information from Phone Interface Table for the Interface Identifier
559: CURSOR cur_get_int_phones(cp_interface_cont_id igs_or_inst_cphn_int.interface_inst_cont_phone_id%TYPE,