APPS.HZ_EXTRACT_PARTY_SITE_BO_PVT dependencies on HZ_PARTY_SITES

Line 70: Party Site Y N HZ_PARTY_SITES

66:
67: Embedded TCA Entity Mandatory Multiple TCA Table Entities
68:
69: Location Y N HZ_LOCATIONS
70: Party Site Y N HZ_PARTY_SITES
71: Party Site Use N Y HZ_PARTY_SITE_USES
72: Contact Preference N Y HZ_CONTACT_PREFERENCES
73: */
74:

Line 175: AND OWNER_TABLE_NAME = 'HZ_PARTY_SITES'

171: ATTRIBUTE20)
172: FROM HZ_ORIG_SYS_REFERENCES OSR
173: WHERE
174: OSR.OWNER_TABLE_ID = PS.PARTY_SITE_ID
175: AND OWNER_TABLE_NAME = 'HZ_PARTY_SITES'
176: AND STATUS = 'A') AS HZ_ORIG_SYS_REF_OBJ_TBL),
177: HZ_EXT_ATTRIBUTE_OBJ_TBL(),
178: HZ_LOCATION_OBJ(
179: P_ACTION_TYPE,

Line 305: WHERE CONTACT_LEVEL_TABLE = 'HZ_PARTY_SITES'

301: CREATION_DATE,
302: LAST_UPDATE_DATE,
303: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))
304: FROM HZ_CONTACT_PREFERENCES CPREF
305: WHERE CONTACT_LEVEL_TABLE = 'HZ_PARTY_SITES'
306: AND CONTACT_LEVEL_TABLE_ID = PS.PARTY_SITE_ID) AS HZ_CONTACT_PREF_OBJ_TBL))
307: FROM HZ_PARTY_SITES PS, HZ_LOCATIONS LOC WHERE PS.LOCATION_ID = LOC.LOCATION_ID
308: AND ((P_PARTY_SITE_ID IS NULL AND PARTY_ID = P_PARTY_ID)
309: OR (P_PARTY_SITE_ID IS NOT NULL AND PARTY_SITE_ID = P_PARTY_SITE_ID));

Line 307: FROM HZ_PARTY_SITES PS, HZ_LOCATIONS LOC WHERE PS.LOCATION_ID = LOC.LOCATION_ID

303: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))
304: FROM HZ_CONTACT_PREFERENCES CPREF
305: WHERE CONTACT_LEVEL_TABLE = 'HZ_PARTY_SITES'
306: AND CONTACT_LEVEL_TABLE_ID = PS.PARTY_SITE_ID) AS HZ_CONTACT_PREF_OBJ_TBL))
307: FROM HZ_PARTY_SITES PS, HZ_LOCATIONS LOC WHERE PS.LOCATION_ID = LOC.LOCATION_ID
308: AND ((P_PARTY_SITE_ID IS NULL AND PARTY_ID = P_PARTY_ID)
309: OR (P_PARTY_SITE_ID IS NOT NULL AND PARTY_SITE_ID = P_PARTY_SITE_ID));
310:
311:

Line 345: p_parent_table_name => 'HZ_PARTY_SITES',

341: hz_extract_cont_point_bo_pvt.get_phone_bos
342: (p_init_msg_list => fnd_api.g_false,
343: p_phone_id => null,
344: p_parent_id => x_party_site_objs(i).party_site_id,
345: p_parent_table_name => 'HZ_PARTY_SITES',
346: p_action_type => p_action_type,
347: x_phone_objs => x_party_site_objs(i).phone_objs,
348: x_return_status => x_return_status,
349: x_msg_count => x_msg_count,

Line 359: p_ext_object_name => 'HZ_PARTY_SITES',

355:
356: hz_extract_ext_attri_bo_pvt.get_ext_attribute_bos
357: (p_init_msg_list => fnd_api.g_false,
358: p_ext_object_id => x_party_site_objs(i).party_site_id,
359: p_ext_object_name => 'HZ_PARTY_SITES',
360: p_action_type => p_action_type,
361: x_ext_attribute_objs => x_party_site_objs(i).ext_attributes_objs,
362: x_return_status => x_return_status,
363: x_msg_count => x_msg_count,

Line 374: p_parent_table_name => 'HZ_PARTY_SITES',

370: hz_extract_cont_point_bo_pvt.get_telex_bos
371: (p_init_msg_list => fnd_api.g_false,
372: p_telex_id => null,
373: p_parent_id => x_party_site_objs(i).party_site_id,
374: p_parent_table_name => 'HZ_PARTY_SITES',
375: p_action_type => p_action_type,
376: x_telex_objs => x_party_site_objs(i).telex_objs,
377: x_return_status => x_return_status,
378: x_msg_count => x_msg_count,

Line 390: p_parent_table_name => 'HZ_PARTY_SITES',

386: hz_extract_cont_point_bo_pvt.get_email_bos
387: (p_init_msg_list => fnd_api.g_false,
388: p_email_id => null,
389: p_parent_id => x_party_site_objs(i).party_site_id,
390: p_parent_table_name => 'HZ_PARTY_SITES',
391: p_action_type => p_action_type,
392: x_email_objs => x_party_site_objs(i).email_objs,
393: x_return_status => x_return_status,
394: x_msg_count => x_msg_count,

Line 406: p_parent_table_name => 'HZ_PARTY_SITES',

402: hz_extract_cont_point_bo_pvt.get_web_bos
403: (p_init_msg_list => fnd_api.g_false,
404: p_web_id => null,
405: p_parent_id => x_party_site_objs(i).party_site_id,
406: p_parent_table_name => 'HZ_PARTY_SITES',
407: p_action_type => p_action_type,
408: x_web_objs => x_party_site_objs(i).web_objs,
409: x_return_status => x_return_status,
410: x_msg_count => x_msg_count,