APPS.HZ_POPULATE_TIMEZONE_PKG dependencies on HZ_CONTACT_POINTS

Line 245: FROM hz_contact_points cp

241: VARCHAR2, p_overwrite_flag IN varchar2) is
242:
243: cursor phone_csr is
244: SELECT contact_point_id, phone_country_code, phone_area_code
245: FROM hz_contact_points cp
246: WHERE contact_point_type = 'PHONE';
247:
248: cursor phone_tz_csr is
249: SELECT contact_point_id, phone_country_code, phone_area_code

Line 250: FROM hz_contact_points cp

246: WHERE contact_point_type = 'PHONE';
247:
248: cursor phone_tz_csr is
249: SELECT contact_point_id, phone_country_code, phone_area_code
250: FROM hz_contact_points cp
251: WHERE contact_point_type = 'PHONE'
252: and timezone_id is null;
253:
254:

Line 255: TYPE PHONE_COUNTRY_CODEList IS TABLE OF HZ_CONTACT_POINTS.PHONE_COUNTRY_CODE%TYPE;

251: WHERE contact_point_type = 'PHONE'
252: and timezone_id is null;
253:
254:
255: TYPE PHONE_COUNTRY_CODEList IS TABLE OF HZ_CONTACT_POINTS.PHONE_COUNTRY_CODE%TYPE;
256: TYPE PHONE_AREA_CODEList IS TABLE OF HZ_CONTACT_POINTS.PHONE_AREA_CODE%TYPE;
257: TYPE CONTACT_POINT_IDList IS TABLE OF HZ_CONTACT_POINTS.CONTACT_POINT_ID%TYPE;
258:
259: I_PHONE_COUNTRY_CODE PHONE_COUNTRY_CODEList;

Line 256: TYPE PHONE_AREA_CODEList IS TABLE OF HZ_CONTACT_POINTS.PHONE_AREA_CODE%TYPE;

252: and timezone_id is null;
253:
254:
255: TYPE PHONE_COUNTRY_CODEList IS TABLE OF HZ_CONTACT_POINTS.PHONE_COUNTRY_CODE%TYPE;
256: TYPE PHONE_AREA_CODEList IS TABLE OF HZ_CONTACT_POINTS.PHONE_AREA_CODE%TYPE;
257: TYPE CONTACT_POINT_IDList IS TABLE OF HZ_CONTACT_POINTS.CONTACT_POINT_ID%TYPE;
258:
259: I_PHONE_COUNTRY_CODE PHONE_COUNTRY_CODEList;
260: I_PHONE_AREA_CODE PHONE_AREA_CODEList;

Line 257: TYPE CONTACT_POINT_IDList IS TABLE OF HZ_CONTACT_POINTS.CONTACT_POINT_ID%TYPE;

253:
254:
255: TYPE PHONE_COUNTRY_CODEList IS TABLE OF HZ_CONTACT_POINTS.PHONE_COUNTRY_CODE%TYPE;
256: TYPE PHONE_AREA_CODEList IS TABLE OF HZ_CONTACT_POINTS.PHONE_AREA_CODE%TYPE;
257: TYPE CONTACT_POINT_IDList IS TABLE OF HZ_CONTACT_POINTS.CONTACT_POINT_ID%TYPE;
258:
259: I_PHONE_COUNTRY_CODE PHONE_COUNTRY_CODEList;
260: I_PHONE_AREA_CODE PHONE_AREA_CODEList;
261: I_CONTACT_POINT_ID CONTACT_POINT_IDList;

Line 316: UPDATE hz_contact_points

312: then -- we don't raise error
313: l_timezone_id := null;
314: end if;
315:
316: UPDATE hz_contact_points
317: SET timezone_id = l_timezone_id
318: WHERE contact_point_id = I_CONTACT_POINT_ID(i);
319:
320: END LOOP;

Line 366: UPDATE hz_contact_points

362: then -- we don't raise error
363: l_timezone_id := null;
364: end if;
365:
366: UPDATE hz_contact_points
367: SET timezone_id = l_timezone_id
368: WHERE contact_point_id = I_CONTACT_POINT_ID(i);
369:
370: END LOOP;