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_SITE_USES_ALL

Line 2088: -- Procedure name: pop_hz_cust_site_uses_all()

2084: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2085: END pop_hz_education;
2086:
2087: -----------------------------------------------------------------
2088: -- Procedure name: pop_hz_cust_site_uses_all()
2089: -- Purpose: populates BOT for HZ_CUST_SITE_USES_ALL create or update
2090: -- Scope: internal
2091: -- Called From: V2 API
2092: -- Called By: HZ_CUST_SITE_USES_ALL create or update APIs

Line 2089: -- Purpose: populates BOT for HZ_CUST_SITE_USES_ALL create or update

2085: END pop_hz_education;
2086:
2087: -----------------------------------------------------------------
2088: -- Procedure name: pop_hz_cust_site_uses_all()
2089: -- Purpose: populates BOT for HZ_CUST_SITE_USES_ALL create or update
2090: -- Scope: internal
2091: -- Called From: V2 API
2092: -- Called By: HZ_CUST_SITE_USES_ALL create or update APIs
2093: -- Input Parameters:

Line 2092: -- Called By: HZ_CUST_SITE_USES_ALL create or update APIs

2088: -- Procedure name: pop_hz_cust_site_uses_all()
2089: -- Purpose: populates BOT for HZ_CUST_SITE_USES_ALL create or update
2090: -- Scope: internal
2091: -- Called From: V2 API
2092: -- Called By: HZ_CUST_SITE_USES_ALL create or update APIs
2093: -- Input Parameters:
2094: -- p_operation -- contains I or U. 'I' if create API is calling this otherwise 'U'.
2095: -- p_site_use_id IN NUMBER
2096: --

Line 2098: -- Following are the allowed PARENT and CHILD BO combinations for HZ_CUST_SITE_USES_ALL

2094: -- p_operation -- contains I or U. 'I' if create API is calling this otherwise 'U'.
2095: -- p_site_use_id IN NUMBER
2096: --
2097: -- Note:
2098: -- Following are the allowed PARENT and CHILD BO combinations for HZ_CUST_SITE_USES_ALL
2099: -- This procedure must ensure that the combination is valid before populating BOT
2100: --
2101: -- PARENT BO: CUST_ACCT_SITE :: CHILD BO: CUST_ACCT_SITE_USE
2102: -----------------------------------------------------------------

Line 2103: PROCEDURE pop_hz_cust_site_uses_all(p_operation IN VARCHAR2, p_site_use_id IN NUMBER) IS

2099: -- This procedure must ensure that the combination is valid before populating BOT
2100: --
2101: -- PARENT BO: CUST_ACCT_SITE :: CHILD BO: CUST_ACCT_SITE_USE
2102: -----------------------------------------------------------------
2103: PROCEDURE pop_hz_cust_site_uses_all(p_operation IN VARCHAR2, p_site_use_id IN NUMBER) IS
2104:
2105: -- cursor statement to select the info from child table
2106: CURSOR C_child IS
2107: SELECT casu.LAST_UPDATE_DATE lud, casu.CUST_ACCT_SITE_ID parent_id,

Line 2109: FROM HZ_CUST_SITE_USES_ALL casu, HZ_CUST_ACCT_SITES_ALL cas

2105: -- cursor statement to select the info from child table
2106: CURSOR C_child IS
2107: SELECT casu.LAST_UPDATE_DATE lud, casu.CUST_ACCT_SITE_ID parent_id,
2108: casu.SITE_USE_ID child_id, cas.cust_account_id cust_acct_id
2109: FROM HZ_CUST_SITE_USES_ALL casu, HZ_CUST_ACCT_SITES_ALL cas
2110: WHERE casu.SITE_USE_ID = P_SITE_USE_ID
2111: AND casu.cust_acct_site_id = cas.cust_acct_site_id
2112: AND cas.cust_account_id > 0;
2113:

Line 2115: l_debug_prefix VARCHAR2(40) := 'pop_hz_cust_site_uses_all';

2111: AND casu.cust_acct_site_id = cas.cust_acct_site_id
2112: AND cas.cust_account_id > 0;
2113:
2114: -- local variables
2115: l_debug_prefix VARCHAR2(40) := 'pop_hz_cust_site_uses_all';
2116: l_parent_id NUMBER; -- used to store parent entity identifier
2117: l_child_id NUMBER; -- used to store HZ_CUST_SITE_USES_ALL identifier
2118: l_lud DATE; -- used to store the child last update date
2119: l_child_rec_exists_no NUMBER;

Line 2117: l_child_id NUMBER; -- used to store HZ_CUST_SITE_USES_ALL identifier

2113:
2114: -- local variables
2115: l_debug_prefix VARCHAR2(40) := 'pop_hz_cust_site_uses_all';
2116: l_parent_id NUMBER; -- used to store parent entity identifier
2117: l_child_id NUMBER; -- used to store HZ_CUST_SITE_USES_ALL identifier
2118: l_lud DATE; -- used to store the child last update date
2119: l_child_rec_exists_no NUMBER;
2120: l_acct_id NUMBER;
2121: l_cen VARCHAR2(30) := 'HZ_CUST_SITE_USES_ALL';

Line 2121: l_cen VARCHAR2(30) := 'HZ_CUST_SITE_USES_ALL';

2117: l_child_id NUMBER; -- used to store HZ_CUST_SITE_USES_ALL identifier
2118: l_lud DATE; -- used to store the child last update date
2119: l_child_rec_exists_no NUMBER;
2120: l_acct_id NUMBER;
2121: l_cen VARCHAR2(30) := 'HZ_CUST_SITE_USES_ALL';
2122: BEGIN
2123: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_cust_site_uses_all+',
2124: p_prefix=>l_debug_prefix,
2125: p_msg_level=>fnd_log.level_procedure);

Line 2123: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_cust_site_uses_all+',

2119: l_child_rec_exists_no NUMBER;
2120: l_acct_id NUMBER;
2121: l_cen VARCHAR2(30) := 'HZ_CUST_SITE_USES_ALL';
2122: BEGIN
2123: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_cust_site_uses_all+',
2124: p_prefix=>l_debug_prefix,
2125: p_msg_level=>fnd_log.level_procedure);
2126:
2127: -- validate p_operation

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

2127: -- validate p_operation
2128: IF p_operation IN ('I','U') THEN
2129: NULL;
2130: ELSE
2131: hz_utility_v2pub.DEBUG(p_message=> 'incorrect operation flag sent to pop_hz_cust_site_uses_all',
2132: p_prefix=>l_debug_prefix,
2133: p_msg_level=>fnd_log.level_procedure);
2134: RAISE FND_API.G_EXC_ERROR;
2135: END IF;

Line 2167: 'N', p_operation, l_child_id, 'HZ_CUST_SITE_USES_ALL', 'CUST_ACCT_SITE_USE',

2163: INSERT INTO HZ_BUS_OBJ_TRACKING
2164: ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
2165: LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
2166: ) VALUES (
2167: 'N', p_operation, l_child_id, 'HZ_CUST_SITE_USES_ALL', 'CUST_ACCT_SITE_USE',
2168: l_lud, l_lud, 'HZ_CUST_ACCT_SITES_ALL', l_parent_id, 'CUST_ACCT_SITE');
2169: END ; -- anonymous block end
2170: END LOOP;
2171:

Line 2172: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_cust_site_uses_all-',

2168: l_lud, l_lud, 'HZ_CUST_ACCT_SITES_ALL', l_parent_id, 'CUST_ACCT_SITE');
2169: END ; -- anonymous block end
2170: END LOOP;
2171:
2172: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_cust_site_uses_all-',
2173: p_prefix=>l_debug_prefix,
2174: p_msg_level=>fnd_log.level_procedure);
2175: EXCEPTION
2176: WHEN OTHERS THEN

Line 2181: END pop_hz_cust_site_uses_all;

2177: hz_utility_v2pub.DEBUG(p_message=> SQLERRM,
2178: p_prefix=>l_debug_prefix,
2179: p_msg_level=>fnd_log.level_procedure);
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

Line 2206: decode(cp.site_use_id, null, 'HZ_CUST_ACCOUNTS', 'HZ_CUST_SITE_USES_ALL') cp_parent_entity,

2202: CURSOR C_child IS
2203: SELECT cpa.LAST_UPDATE_DATE lud, cpa.CUST_ACCOUNT_PROFILE_ID parent_id,
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

Line 2799: decode(cp.site_use_id, NULL, 'HZ_CUST_ACCOUNTS', 'HZ_CUST_SITE_USES_ALL') parent_entity,

2795: -- cursor statement to select the info from child table
2796: CURSOR C_child IS
2797: SELECT cp.LAST_UPDATE_DATE lud,
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

Line 3916: decode(rcrm.site_use_id, NULL, 'HZ_CUST_ACCOUNTS', 'HZ_CUST_SITE_USES_ALL') parent_tbl_name,

3912: -- cursor statement to select the info from child table
3913: CURSOR C_child IS
3914: SELECT rcrm.last_update_date lud, rcrm.cust_receipt_method_id child_id,
3915: nvl(rcrm.site_use_id, rcrm.customer_id) parent_id,
3916: decode(rcrm.site_use_id, NULL, 'HZ_CUST_ACCOUNTS', 'HZ_CUST_SITE_USES_ALL') parent_tbl_name,
3917: decode(rcrm.site_use_id, NULL, 'CUST_ACCT', 'CUST_ACCT_SITE_USE') parent_bo_code,
3918: decode(rcrm.site_use_id, NULL, p.party_id, rcrm.customer_id) grand_parent_id,
3919: decode(rcrm.site_use_id, NULL, 'HZ_PARTIES', 'HZ_CUST_ACCOUNTS') grand_parent_tbl_name,
3920: decode(rcrm.site_use_id, NULL, decode(p.party_type, 'ORGANIZATION', 'ORG_CUST', 'PERSON', 'PERSON_CUST', NULL), 'CUST_ACCT') grand_parent_bo_code