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_CUST_PROFILE_AMTS

Line 2184: -- Procedure name: pop_hz_cust_profile_amts()

2180: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2181: END pop_hz_cust_site_uses_all;
2182:
2183: -----------------------------------------------------------------
2184: -- Procedure name: pop_hz_cust_profile_amts()
2185: -- Purpose: populates BOT for HZ_CUST_PROFILE_AMTS create or update
2186: -- Scope: internal
2187: -- Called From: V2 API
2188: -- Called By: HZ_CUST_PROFILE_AMTS create or update APIs

Line 2185: -- Purpose: populates BOT for HZ_CUST_PROFILE_AMTS create or update

2181: END pop_hz_cust_site_uses_all;
2182:
2183: -----------------------------------------------------------------
2184: -- Procedure name: pop_hz_cust_profile_amts()
2185: -- Purpose: populates BOT for HZ_CUST_PROFILE_AMTS create or update
2186: -- Scope: internal
2187: -- Called From: V2 API
2188: -- Called By: HZ_CUST_PROFILE_AMTS create or update APIs
2189: -- Input Parameters:

Line 2188: -- Called By: HZ_CUST_PROFILE_AMTS create or update APIs

2184: -- Procedure name: pop_hz_cust_profile_amts()
2185: -- Purpose: populates BOT for HZ_CUST_PROFILE_AMTS create or update
2186: -- Scope: internal
2187: -- Called From: V2 API
2188: -- Called By: HZ_CUST_PROFILE_AMTS create or update APIs
2189: -- Input Parameters:
2190: -- p_operation -- contains I or U. 'I' if create API is calling this otherwise 'U'.
2191: -- p_cust_acct_profile_amt_id IN NUMBER
2192: --

Line 2194: -- Following are the allowed PARENT and CHILD BO combinations for HZ_CUST_PROFILE_AMTS

2190: -- p_operation -- contains I or U. 'I' if create API is calling this otherwise 'U'.
2191: -- p_cust_acct_profile_amt_id IN NUMBER
2192: --
2193: -- Note:
2194: -- Following are the allowed PARENT and CHILD BO combinations for HZ_CUST_PROFILE_AMTS
2195: -- This procedure must ensure that the combination is valid before populating BOT
2196: --
2197: -- PARENT BO: CUST_PROFILE :: CHILD BO:
2198: -----------------------------------------------------------------

Line 2199: PROCEDURE pop_hz_cust_profile_amts(p_operation IN VARCHAR2, p_cust_acct_profile_amt_id IN NUMBER) IS

2195: -- This procedure must ensure that the combination is valid before populating BOT
2196: --
2197: -- PARENT BO: CUST_PROFILE :: CHILD BO:
2198: -----------------------------------------------------------------
2199: PROCEDURE pop_hz_cust_profile_amts(p_operation IN VARCHAR2, p_cust_acct_profile_amt_id IN NUMBER) IS
2200:
2201: -- cursor statement to select the info from child table
2202: CURSOR C_child IS
2203: SELECT cpa.LAST_UPDATE_DATE lud, cpa.CUST_ACCOUNT_PROFILE_ID parent_id,

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 2214: l_debug_prefix VARCHAR2(40) := 'pop_hz_cust_profile_amts';

2210: AND cpa.cust_account_profile_id = cp.cust_account_profile_id
2211: AND cp.cust_account_id > 0;
2212:
2213: -- local variables
2214: l_debug_prefix VARCHAR2(40) := 'pop_hz_cust_profile_amts';
2215: l_parent_id NUMBER; -- used to store parent entity identifier
2216: l_child_id NUMBER; -- used to store HZ_CUST_PROFILE_AMTS identifier
2217: l_lud DATE; -- used to store the child last update date
2218: l_child_rec_exists_no NUMBER;

Line 2216: l_child_id NUMBER; -- used to store HZ_CUST_PROFILE_AMTS identifier

2212:
2213: -- local variables
2214: l_debug_prefix VARCHAR2(40) := 'pop_hz_cust_profile_amts';
2215: l_parent_id NUMBER; -- used to store parent entity identifier
2216: l_child_id NUMBER; -- used to store HZ_CUST_PROFILE_AMTS identifier
2217: l_lud DATE; -- used to store the child last update date
2218: l_child_rec_exists_no NUMBER;
2219: l_cp_parent_id NUMBER;
2220: l_cp_parent_entity VARCHAR2(30);

Line 2222: l_cen VARCHAR2(30) := 'HZ_CUST_PROFILE_AMTS';

2218: l_child_rec_exists_no NUMBER;
2219: l_cp_parent_id NUMBER;
2220: l_cp_parent_entity VARCHAR2(30);
2221: l_cp_parent_bo VARCHAR2(30);
2222: l_cen VARCHAR2(30) := 'HZ_CUST_PROFILE_AMTS';
2223: BEGIN
2224: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_cust_profile_amts+',
2225: p_prefix=>l_debug_prefix,
2226: p_msg_level=>fnd_log.level_procedure);

Line 2224: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_cust_profile_amts+',

2220: l_cp_parent_entity VARCHAR2(30);
2221: l_cp_parent_bo VARCHAR2(30);
2222: l_cen VARCHAR2(30) := 'HZ_CUST_PROFILE_AMTS';
2223: BEGIN
2224: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_cust_profile_amts+',
2225: p_prefix=>l_debug_prefix,
2226: p_msg_level=>fnd_log.level_procedure);
2227:
2228: -- validate p_operation

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

2228: -- validate p_operation
2229: IF p_operation IN ('I','U') THEN
2230: NULL;
2231: ELSE
2232: hz_utility_v2pub.DEBUG(p_message=> 'incorrect operation flag sent to pop_hz_cust_profile_amts',
2233: p_prefix=>l_debug_prefix,
2234: p_msg_level=>fnd_log.level_procedure);
2235: RAISE FND_API.G_EXC_ERROR;
2236: END IF;

Line 2269: 'N', p_operation, l_child_id, 'HZ_CUST_PROFILE_AMTS', NULL,

2265: INSERT INTO HZ_BUS_OBJ_TRACKING
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,

Line 2283: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_cust_profile_amts-',

2279: p_pbo_code => l_cp_parent_bo);
2280: END ; -- anonymous block end
2281: END LOOP;
2282:
2283: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_cust_profile_amts-',
2284: p_prefix=>l_debug_prefix,
2285: p_msg_level=>fnd_log.level_procedure);
2286: EXCEPTION
2287: WHEN OTHERS THEN

Line 2292: END pop_hz_cust_profile_amts;

2288: hz_utility_v2pub.DEBUG(p_message=> SQLERRM,
2289: p_prefix=>l_debug_prefix,
2290: p_msg_level=>fnd_log.level_procedure);
2291: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2292: END pop_hz_cust_profile_amts;
2293:
2294: -----------------------------------------------------------------
2295: -- Procedure name: pop_hz_cust_acct_sites_all()
2296: -- Purpose: populates BOT for HZ_CUST_ACCT_SITES_ALL create or update