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_CUSTOMER_PROFILES

Line 2208: FROM HZ_CUST_PROFILE_AMTS cpa, HZ_CUSTOMER_PROFILES cp

2204: cpa.CUST_ACCT_PROFILE_AMT_ID child_id,
2205: nvl(cp.site_use_id, cp.cust_account_id) cp_parent_id,
2206: decode(cp.site_use_id, null, 'HZ_CUST_ACCOUNTS', 'HZ_CUST_SITE_USES_ALL') cp_parent_entity,
2207: decode(cp.site_use_id, null, 'CUST_ACCT', 'CUST_ACCT_SITE_USE') cp_parent_bo
2208: FROM HZ_CUST_PROFILE_AMTS cpa, HZ_CUSTOMER_PROFILES cp
2209: WHERE cpa.CUST_ACCT_PROFILE_AMT_ID = P_CUST_ACCT_PROFILE_AMT_ID
2210: AND cpa.cust_account_profile_id = cp.cust_account_profile_id
2211: AND cp.cust_account_id > 0;
2212:

Line 2270: l_lud, l_lud, 'HZ_CUSTOMER_PROFILES', l_parent_id, 'CUST_PROFILE');

2266: ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
2267: LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
2268: ) VALUES (
2269: 'N', p_operation, l_child_id, 'HZ_CUST_PROFILE_AMTS', NULL,
2270: l_lud, l_lud, 'HZ_CUSTOMER_PROFILES', l_parent_id, 'CUST_PROFILE');
2271:
2272: -- populate org party record
2273: pop_parent_record(p_child_id => l_parent_id,
2274: p_lud => l_lud,

Line 2275: p_centity_name => 'HZ_CUSTOMER_PROFILES',

2271:
2272: -- populate org party record
2273: pop_parent_record(p_child_id => l_parent_id,
2274: p_lud => l_lud,
2275: p_centity_name => 'HZ_CUSTOMER_PROFILES',
2276: p_cbo_code => 'CUST_PROFILE',
2277: p_parent_id => l_cp_parent_id,
2278: p_pentity_name => l_cp_parent_entity,
2279: p_pbo_code => l_cp_parent_bo);

Line 2777: -- Procedure name: pop_hz_customer_profiles()

2773: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2774: END pop_hz_cust_accounts;
2775:
2776: -----------------------------------------------------------------
2777: -- Procedure name: pop_hz_customer_profiles()
2778: -- Purpose: populates BOT for HZ_CUSTOMER_PROFILES create or update
2779: -- Scope: internal
2780: -- Called From: V2 API
2781: -- Called By: HZ_CUSTOMER_PROFILES create or update APIs

Line 2778: -- Purpose: populates BOT for HZ_CUSTOMER_PROFILES create or update

2774: END pop_hz_cust_accounts;
2775:
2776: -----------------------------------------------------------------
2777: -- Procedure name: pop_hz_customer_profiles()
2778: -- Purpose: populates BOT for HZ_CUSTOMER_PROFILES create or update
2779: -- Scope: internal
2780: -- Called From: V2 API
2781: -- Called By: HZ_CUSTOMER_PROFILES create or update APIs
2782: -- Input Parameters:

Line 2781: -- Called By: HZ_CUSTOMER_PROFILES create or update APIs

2777: -- Procedure name: pop_hz_customer_profiles()
2778: -- Purpose: populates BOT for HZ_CUSTOMER_PROFILES create or update
2779: -- Scope: internal
2780: -- Called From: V2 API
2781: -- Called By: HZ_CUSTOMER_PROFILES create or update APIs
2782: -- Input Parameters:
2783: -- p_operation -- contains I or U. 'I' if create API is calling this otherwise 'U'.
2784: -- p_cust_account_profile_id IN NUMBER
2785: --

Line 2787: -- Following are the allowed PARENT and CHILD BO combinations for HZ_CUSTOMER_PROFILES

2783: -- p_operation -- contains I or U. 'I' if create API is calling this otherwise 'U'.
2784: -- p_cust_account_profile_id IN NUMBER
2785: --
2786: -- Note:
2787: -- Following are the allowed PARENT and CHILD BO combinations for HZ_CUSTOMER_PROFILES
2788: -- This procedure must ensure that the combination is valid before populating BOT
2789: --
2790: -- PARENT BO: CUST_ACCT :: CHILD BO: CUST_PROFILE
2791: -- PARENT BO: CUST_ACCT_SITE_USE :: CHILD BO: CUST_PROFILE

Line 2793: PROCEDURE pop_hz_customer_profiles(p_operation IN VARCHAR2, p_cust_account_profile_id IN NUMBER) IS

2789: --
2790: -- PARENT BO: CUST_ACCT :: CHILD BO: CUST_PROFILE
2791: -- PARENT BO: CUST_ACCT_SITE_USE :: CHILD BO: CUST_PROFILE
2792: -----------------------------------------------------------------
2793: PROCEDURE pop_hz_customer_profiles(p_operation IN VARCHAR2, p_cust_account_profile_id IN NUMBER) IS
2794:
2795: -- cursor statement to select the info from child table
2796: CURSOR C_child IS
2797: SELECT cp.LAST_UPDATE_DATE lud,

Line 2802: FROM HZ_CUSTOMER_PROFILES cp

2798: nvl(cp.site_use_id, cp.cust_account_id) parent_id,
2799: decode(cp.site_use_id, NULL, 'HZ_CUST_ACCOUNTS', 'HZ_CUST_SITE_USES_ALL') parent_entity,
2800: decode(cp.site_use_id, NULL, 'CUST_ACCT', 'CUST_ACCT_SITE_USE') parent_bo,
2801: cp.CUST_ACCOUNT_PROFILE_ID child_id
2802: FROM HZ_CUSTOMER_PROFILES cp
2803: WHERE cp.CUST_ACCOUNT_PROFILE_ID = P_CUST_ACCOUNT_PROFILE_ID
2804: AND cp.cust_account_id > 0;
2805:
2806: -- local variables

Line 2807: l_debug_prefix VARCHAR2(40) := 'pop_hz_customer_profiles';

2803: WHERE cp.CUST_ACCOUNT_PROFILE_ID = P_CUST_ACCOUNT_PROFILE_ID
2804: AND cp.cust_account_id > 0;
2805:
2806: -- local variables
2807: l_debug_prefix VARCHAR2(40) := 'pop_hz_customer_profiles';
2808: l_parent_id NUMBER; -- used to store parent entity identifier
2809: l_parent_bo VARCHAR2(30);
2810: l_parent_entity VARCHAR2(30);
2811: l_child_id NUMBER; -- used to store HZ_CUSTOMER_PROFILES identifier

Line 2811: l_child_id NUMBER; -- used to store HZ_CUSTOMER_PROFILES identifier

2807: l_debug_prefix VARCHAR2(40) := 'pop_hz_customer_profiles';
2808: l_parent_id NUMBER; -- used to store parent entity identifier
2809: l_parent_bo VARCHAR2(30);
2810: l_parent_entity VARCHAR2(30);
2811: l_child_id NUMBER; -- used to store HZ_CUSTOMER_PROFILES identifier
2812: l_lud DATE; -- used to store the child last update date
2813: l_child_rec_exists_no NUMBER;
2814: l_pop_flag VARCHAR2(1);
2815: l_cen VARCHAR2(30) := 'HZ_CUSTOMER_PROFILES';

Line 2815: l_cen VARCHAR2(30) := 'HZ_CUSTOMER_PROFILES';

2811: l_child_id NUMBER; -- used to store HZ_CUSTOMER_PROFILES identifier
2812: l_lud DATE; -- used to store the child last update date
2813: l_child_rec_exists_no NUMBER;
2814: l_pop_flag VARCHAR2(1);
2815: l_cen VARCHAR2(30) := 'HZ_CUSTOMER_PROFILES';
2816: BEGIN
2817: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_customer_profiles+',
2818: p_prefix=>l_debug_prefix,
2819: p_msg_level=>fnd_log.level_procedure);

Line 2817: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_customer_profiles+',

2813: l_child_rec_exists_no NUMBER;
2814: l_pop_flag VARCHAR2(1);
2815: l_cen VARCHAR2(30) := 'HZ_CUSTOMER_PROFILES';
2816: BEGIN
2817: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_customer_profiles+',
2818: p_prefix=>l_debug_prefix,
2819: p_msg_level=>fnd_log.level_procedure);
2820:
2821: -- validate p_operation

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

2821: -- validate p_operation
2822: IF p_operation IN ('I','U') THEN
2823: NULL;
2824: ELSE
2825: hz_utility_v2pub.DEBUG(p_message=> 'incorrect operation flag sent to pop_hz_customer_profiles',
2826: p_prefix=>l_debug_prefix,
2827: p_msg_level=>fnd_log.level_procedure);
2828: RAISE FND_API.G_EXC_ERROR;
2829: END IF;

Line 2872: 'N', p_operation, l_child_id, 'HZ_CUSTOMER_PROFILES', 'CUST_PROFILE',

2868: INSERT INTO HZ_BUS_OBJ_TRACKING
2869: ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
2870: LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
2871: ) VALUES (
2872: 'N', p_operation, l_child_id, 'HZ_CUSTOMER_PROFILES', 'CUST_PROFILE',
2873: l_lud, l_lud, l_parent_entity, l_parent_id, l_parent_bo);
2874: END ; -- anonymous block end
2875: END IF; -- l_parent_id > 0
2876: END LOOP;

Line 2878: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_customer_profiles-',

2874: END ; -- anonymous block end
2875: END IF; -- l_parent_id > 0
2876: END LOOP;
2877:
2878: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_customer_profiles-',
2879: p_prefix=>l_debug_prefix,
2880: p_msg_level=>fnd_log.level_procedure);
2881: EXCEPTION
2882: WHEN OTHERS THEN

Line 2887: END pop_hz_customer_profiles;

2883: hz_utility_v2pub.DEBUG(p_message=> SQLERRM,
2884: p_prefix=>l_debug_prefix,
2885: p_msg_level=>fnd_log.level_procedure);
2886: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2887: END pop_hz_customer_profiles;
2888:
2889: -----------------------------------------------------------------
2890: -- Procedure name: pop_hz_credit_ratings()
2891: -- Purpose: populates BOT for HZ_CREDIT_RATINGS create or update