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.IGF_AP_MATCHING_PROCESS_PKG dependencies on HZ_CONTACT_POINTS

Line 2336: CURSOR c_get_obj_version(cp_person_id hz_contact_points.owner_table_id%TYPE,

2332:
2333: l_chk_email cur_chk_email_addr%ROWTYPE;
2334:
2335:
2336: CURSOR c_get_obj_version(cp_person_id hz_contact_points.owner_table_id%TYPE,
2337: cp_primary_flag hz_contact_points.primary_flag%TYPE,
2338: cp_contact_point_type hz_contact_points.contact_point_type%TYPE)
2339: IS
2340: SELECT object_version_number,

Line 2337: cp_primary_flag hz_contact_points.primary_flag%TYPE,

2333: l_chk_email cur_chk_email_addr%ROWTYPE;
2334:
2335:
2336: CURSOR c_get_obj_version(cp_person_id hz_contact_points.owner_table_id%TYPE,
2337: cp_primary_flag hz_contact_points.primary_flag%TYPE,
2338: cp_contact_point_type hz_contact_points.contact_point_type%TYPE)
2339: IS
2340: SELECT object_version_number,
2341: contact_point_id

Line 2338: cp_contact_point_type hz_contact_points.contact_point_type%TYPE)

2334:
2335:
2336: CURSOR c_get_obj_version(cp_person_id hz_contact_points.owner_table_id%TYPE,
2337: cp_primary_flag hz_contact_points.primary_flag%TYPE,
2338: cp_contact_point_type hz_contact_points.contact_point_type%TYPE)
2339: IS
2340: SELECT object_version_number,
2341: contact_point_id
2342: FROM hz_contact_points

Line 2342: FROM hz_contact_points

2338: cp_contact_point_type hz_contact_points.contact_point_type%TYPE)
2339: IS
2340: SELECT object_version_number,
2341: contact_point_id
2342: FROM hz_contact_points
2343: WHERE owner_table_id = cp_person_id
2344: AND contact_point_type = cp_contact_point_type
2345: AND NVL(primary_flag,'X') = cp_primary_flag;
2346:

Line 2351: l_obj_ver hz_contact_points.object_version_number%TYPE;

2347:
2348: p_contact_points_rec hz_contact_point_v2pub.contact_point_rec_type;
2349: p_email_rec hz_contact_point_v2pub.email_rec_type := NULL;
2350: p_phone_rec hz_contact_point_v2pub.phone_rec_type;
2351: l_obj_ver hz_contact_points.object_version_number%TYPE;
2352: l_contact_point_id hz_contact_points.contact_point_id%TYPE := NULL;
2353: l_obj_version hz_contact_points.object_version_number%TYPE;
2354: l_return_status VARCHAR2(25);
2355: l_msg_count NUMBER;

Line 2352: l_contact_point_id hz_contact_points.contact_point_id%TYPE := NULL;

2348: p_contact_points_rec hz_contact_point_v2pub.contact_point_rec_type;
2349: p_email_rec hz_contact_point_v2pub.email_rec_type := NULL;
2350: p_phone_rec hz_contact_point_v2pub.phone_rec_type;
2351: l_obj_ver hz_contact_points.object_version_number%TYPE;
2352: l_contact_point_id hz_contact_points.contact_point_id%TYPE := NULL;
2353: l_obj_version hz_contact_points.object_version_number%TYPE;
2354: l_return_status VARCHAR2(25);
2355: l_msg_count NUMBER;
2356: l_msg_data VARCHAR2(4000);

Line 2353: l_obj_version hz_contact_points.object_version_number%TYPE;

2349: p_email_rec hz_contact_point_v2pub.email_rec_type := NULL;
2350: p_phone_rec hz_contact_point_v2pub.phone_rec_type;
2351: l_obj_ver hz_contact_points.object_version_number%TYPE;
2352: l_contact_point_id hz_contact_points.contact_point_id%TYPE := NULL;
2353: l_obj_version hz_contact_points.object_version_number%TYPE;
2354: l_return_status VARCHAR2(25);
2355: l_msg_count NUMBER;
2356: l_msg_data VARCHAR2(4000);
2357: