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

Line 3025: FROM HZ_CONTACT_POINTS

3021: WHERE cpp.CONTACT_PREFERENCE_ID = P_CONTACT_PREFERENCE_ID;
3022:
3023: CURSOR c_cp(p_parent_id NUMBER) IS
3024: SELECT decode(contact_point_type, 'PHONE', 'PHONE', 'EMAIL', 'EMAIL', 'WEB', 'WEB', 'EFT', 'EFT', 'SMS', 'SMS', 'TLX', 'TLX', 'EDI', 'EDI', NULL), owner_table_name, owner_table_id
3025: FROM HZ_CONTACT_POINTS
3026: WHERE contact_point_id = p_parent_id
3027: AND contact_point_type in ('PHONE', 'EMAIL', 'TLX', 'WEB', 'EFT', 'EDI', 'SMS');
3028:
3029: CURSOR c_pty(p_parent_id NUMBER) IS

Line 3087: ELSIF(l_parent_tbl_name = 'HZ_CONTACT_POINTS') THEN

3083: l_bo_code := 'PARTY_SITE';
3084: IF NOT(is_valid_ps(l_parent_id)) THEN
3085: RETURN;
3086: END IF;
3087: ELSIF(l_parent_tbl_name = 'HZ_CONTACT_POINTS') THEN
3088: OPEN c_cp(l_parent_id);
3089: FETCH c_cp INTO l_bo_code, l_cp_owner_table, l_cp_owner_id;
3090: CLOSE c_cp;
3091: IF l_bo_code in ('PHONE', 'SMS', 'EDI') and l_cp_owner_table = 'HZ_PARTIES' THEN

Line 3165: -- Procedure name: pop_hz_contact_points()

3161: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3162: END pop_hz_contact_preferences;
3163:
3164: -----------------------------------------------------------------
3165: -- Procedure name: pop_hz_contact_points()
3166: -- Purpose: populates BOT for HZ_CONTACT_POINTS create or update
3167: -- Scope: internal
3168: -- Called From: V2 API
3169: -- Called By: HZ_CONTACT_POINTS create or update APIs

Line 3166: -- Purpose: populates BOT for HZ_CONTACT_POINTS create or update

3162: END pop_hz_contact_preferences;
3163:
3164: -----------------------------------------------------------------
3165: -- Procedure name: pop_hz_contact_points()
3166: -- Purpose: populates BOT for HZ_CONTACT_POINTS create or update
3167: -- Scope: internal
3168: -- Called From: V2 API
3169: -- Called By: HZ_CONTACT_POINTS create or update APIs
3170: -- Input Parameters:

Line 3169: -- Called By: HZ_CONTACT_POINTS create or update APIs

3165: -- Procedure name: pop_hz_contact_points()
3166: -- Purpose: populates BOT for HZ_CONTACT_POINTS create or update
3167: -- Scope: internal
3168: -- Called From: V2 API
3169: -- Called By: HZ_CONTACT_POINTS create or update APIs
3170: -- Input Parameters:
3171: -- p_operation -- contains I or U. 'I' if create API is calling this otherwise 'U'.
3172: -- p_contact_point_id IN NUMBER
3173: --

Line 3175: -- Following are the allowed PARENT and CHILD BO combinations for HZ_CONTACT_POINTS

3171: -- p_operation -- contains I or U. 'I' if create API is calling this otherwise 'U'.
3172: -- p_contact_point_id IN NUMBER
3173: --
3174: -- Note:
3175: -- Following are the allowed PARENT and CHILD BO combinations for HZ_CONTACT_POINTS
3176: -- This procedure must ensure that the combination is valid before populating BOT
3177: --
3178: -- PARENT BO: ORG :: CHILD BO: PHONE
3179: -- PARENT BO: ORG :: CHILD BO: TLX

Line 3198: PROCEDURE pop_hz_contact_points(p_operation IN VARCHAR2, p_contact_point_id IN NUMBER) IS

3194: -- PARENT BO: PARTY_SITE :: CHILD BO: TLX
3195: -- PARENT BO: PARTY_SITE :: CHILD BO: EMAIL
3196: -- PARENT BO: PARTY_SITE :: CHILD BO: WEB
3197: -----------------------------------------------------------------
3198: PROCEDURE pop_hz_contact_points(p_operation IN VARCHAR2, p_contact_point_id IN NUMBER) IS
3199:
3200: -- cursor statement to select the info from child table
3201: CURSOR c_child IS
3202: SELECT LAST_UPDATE_DATE lud, OWNER_TABLE_ID parent_id, CONTACT_POINT_ID child_id,

Line 3204: FROM HZ_CONTACT_POINTS

3200: -- cursor statement to select the info from child table
3201: CURSOR c_child IS
3202: SELECT LAST_UPDATE_DATE lud, OWNER_TABLE_ID parent_id, CONTACT_POINT_ID child_id,
3203: OWNER_TABLE_NAME parent_entity, CONTACT_POINT_TYPE child_bo_code
3204: FROM HZ_CONTACT_POINTS
3205: WHERE CONTACT_POINT_ID = P_CONTACT_POINT_ID
3206: AND OWNER_TABLE_NAME in ('HZ_PARTY_SITES', 'HZ_PARTIES');
3207:
3208: -- cursor statement to select the info from party parent table

Line 3226: l_debug_prefix VARCHAR2(40) := 'pop_hz_contact_points';

3222: AND r.party_id = p_parent_id
3223: AND rownum = 1;
3224:
3225: -- local variables
3226: l_debug_prefix VARCHAR2(40) := 'pop_hz_contact_points';
3227: l_parent_id NUMBER; -- used to store parent entity identifier
3228: l_parent_tbl_name VARCHAR2(30); -- used to store parent entity name
3229: l_bo_code VARCHAR2(30); -- used to store BO Code
3230: l_child_bo_code VARCHAR2(30); -- used to store Child BO Code (if child entity is a root node)

Line 3231: l_child_id NUMBER; -- used to store HZ_CONTACT_POINTS identifier

3227: l_parent_id NUMBER; -- used to store parent entity identifier
3228: l_parent_tbl_name VARCHAR2(30); -- used to store parent entity name
3229: l_bo_code VARCHAR2(30); -- used to store BO Code
3230: l_child_bo_code VARCHAR2(30); -- used to store Child BO Code (if child entity is a root node)
3231: l_child_id NUMBER; -- used to store HZ_CONTACT_POINTS identifier
3232: l_lud DATE; -- used to store the child last update date
3233: l_child_rec_exists_no NUMBER;
3234: l_oc_id NUMBER;
3235: l_cen VARCHAR2(30) := 'HZ_CONTACT_POINTS';

Line 3235: l_cen VARCHAR2(30) := 'HZ_CONTACT_POINTS';

3231: l_child_id NUMBER; -- used to store HZ_CONTACT_POINTS identifier
3232: l_lud DATE; -- used to store the child last update date
3233: l_child_rec_exists_no NUMBER;
3234: l_oc_id NUMBER;
3235: l_cen VARCHAR2(30) := 'HZ_CONTACT_POINTS';
3236: BEGIN
3237: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_contact_points+',
3238: p_prefix=>l_debug_prefix,
3239: p_msg_level=>fnd_log.level_procedure);

Line 3237: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_contact_points+',

3233: l_child_rec_exists_no NUMBER;
3234: l_oc_id NUMBER;
3235: l_cen VARCHAR2(30) := 'HZ_CONTACT_POINTS';
3236: BEGIN
3237: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_contact_points+',
3238: p_prefix=>l_debug_prefix,
3239: p_msg_level=>fnd_log.level_procedure);
3240:
3241: -- validate p_operation

Line 3245: hz_utility_v2pub.DEBUG(p_message=> 'incorrect operation flag sent to pop_hz_contact_points',

3241: -- validate p_operation
3242: IF p_operation IN ('I','U') THEN
3243: NULL;
3244: ELSE
3245: hz_utility_v2pub.DEBUG(p_message=> 'incorrect operation flag sent to pop_hz_contact_points',
3246: p_prefix=>l_debug_prefix,
3247: p_msg_level=>fnd_log.level_procedure);
3248: RAISE FND_API.G_EXC_ERROR;
3249: END IF;

Line 3325: 'N', p_operation, l_child_id, 'HZ_CONTACT_POINTS', l_child_bo_code,

3321: INSERT INTO HZ_BUS_OBJ_TRACKING
3322: ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
3323: LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
3324: ) VALUES (
3325: 'N', p_operation, l_child_id, 'HZ_CONTACT_POINTS', l_child_bo_code,
3326: l_lud, l_lud, l_parent_tbl_name, l_parent_id, l_bo_code);
3327: END ; -- anonymous block end
3328: END LOOP;
3329:

Line 3330: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_contact_points-',

3326: l_lud, l_lud, l_parent_tbl_name, l_parent_id, l_bo_code);
3327: END ; -- anonymous block end
3328: END LOOP;
3329:
3330: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_contact_points-',
3331: p_prefix=>l_debug_prefix,
3332: p_msg_level=>fnd_log.level_procedure);
3333: EXCEPTION
3334: WHEN OTHERS THEN

Line 3339: END pop_hz_contact_points;

3335: hz_utility_v2pub.DEBUG(p_message=> SQLERRM,
3336: p_prefix=>l_debug_prefix,
3337: p_msg_level=>fnd_log.level_procedure);
3338: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3339: END pop_hz_contact_points;
3340:
3341: -----------------------------------------------------------------
3342: -- Procedure name: pop_hz_code_assignments()
3343: -- Purpose: populates BOT for HZ_CODE_ASSIGNMENTS create or update