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_BES_BO_UTIL_PKG dependencies on HZ_CUST_SITE_USES_ALL

Line 2079: Procedure name: PROCEDURE ei_HZ_CUST_SITE_USES_ALL()

2075: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2076: END ei_HZ_LOCATIONS;
2077: -----------------------------------------------------------------
2078: /*
2079: Procedure name: PROCEDURE ei_HZ_CUST_SITE_USES_ALL()
2080: Purpose: Writes the parent node record for HZ_CUST_SITE_USES_ALL in BOT
2081: Scope: internal
2082: Called From: This pkg
2083: Called By: populate_missing_links()

Line 2080: Purpose: Writes the parent node record for HZ_CUST_SITE_USES_ALL in BOT

2076: END ei_HZ_LOCATIONS;
2077: -----------------------------------------------------------------
2078: /*
2079: Procedure name: PROCEDURE ei_HZ_CUST_SITE_USES_ALL()
2080: Purpose: Writes the parent node record for HZ_CUST_SITE_USES_ALL in BOT
2081: Scope: internal
2082: Called From: This pkg
2083: Called By: populate_missing_links()
2084: */

Line 2087: PROCEDURE ei_HZ_CUST_SITE_USES_ALL IS

2083: Called By: populate_missing_links()
2084: */
2085: -----------------------------------------------------------------
2086:
2087: PROCEDURE ei_HZ_CUST_SITE_USES_ALL IS
2088:
2089: -- local variables
2090: l_debug_prefix VARCHAR2(40) := 'EI_HZ_CUST_SITE_USES_ALL';
2091:

Line 2090: l_debug_prefix VARCHAR2(40) := 'EI_HZ_CUST_SITE_USES_ALL';

2086:
2087: PROCEDURE ei_HZ_CUST_SITE_USES_ALL IS
2088:
2089: -- local variables
2090: l_debug_prefix VARCHAR2(40) := 'EI_HZ_CUST_SITE_USES_ALL';
2091:
2092: BEGIN
2093: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2094: hz_utility_v2pub.DEBUG

Line 2095: (p_message=>'ei_HZ_CUST_SITE_USES_ALL+',

2091:
2092: BEGIN
2093: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2094: hz_utility_v2pub.DEBUG
2095: (p_message=>'ei_HZ_CUST_SITE_USES_ALL+',
2096: p_prefix=>l_debug_prefix,
2097: p_msg_level=>fnd_log.level_procedure,
2098: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',
2099: p_module =>'ei_actsiteuse');

Line 2102: HZ_CUST_SITE_USES_ALL has following parent

2098: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',
2099: p_module =>'ei_actsiteuse');
2100: END IF;
2101: /*
2102: HZ_CUST_SITE_USES_ALL has following parent
2103: 1. HZ_CUST_ACCT_SITES_ALL (CUST_ACCT_SITE)
2104:
2105: Hence, HZ_CUST_SITE_USES_ALL can exist in 3 different scenarios.
2106: The different combinations of (parent, grand parent) are :

Line 2105: Hence, HZ_CUST_SITE_USES_ALL can exist in 3 different scenarios.

2101: /*
2102: HZ_CUST_SITE_USES_ALL has following parent
2103: 1. HZ_CUST_ACCT_SITES_ALL (CUST_ACCT_SITE)
2104:
2105: Hence, HZ_CUST_SITE_USES_ALL can exist in 3 different scenarios.
2106: The different combinations of (parent, grand parent) are :
2107: 1. (CUST_ACCT_SITE, CUST_ACCT)
2108: 2. (CUST_ACCT, PERSON_CUST)
2109: 3. (CUST_ACCT, ORG_CUST)

Line 2111: The following SQL gets the Parent and Grand parent info of each HZ_CUST_SITE_USES_ALL

2107: 1. (CUST_ACCT_SITE, CUST_ACCT)
2108: 2. (CUST_ACCT, PERSON_CUST)
2109: 3. (CUST_ACCT, ORG_CUST)
2110:
2111: The following SQL gets the Parent and Grand parent info of each HZ_CUST_SITE_USES_ALL
2112: record that was not already processed in BOT.
2113:
2114: Test Cases for the following SQL are:
2115: Create HZ_CUST_SITE_USES_ALL rec in BOT with (Parent, Grand Parent)

Line 2115: Create HZ_CUST_SITE_USES_ALL rec in BOT with (Parent, Grand Parent)

2111: The following SQL gets the Parent and Grand parent info of each HZ_CUST_SITE_USES_ALL
2112: record that was not already processed in BOT.
2113:
2114: Test Cases for the following SQL are:
2115: Create HZ_CUST_SITE_USES_ALL rec in BOT with (Parent, Grand Parent)
2116: combinations existing in TCA data model
2117: 1. (CUST_ACCT_SITE, CUST_ACCT) -- tested
2118: 2. (CUST_ACCT, PERSON_CUST) -- tested
2119: 3. (CUST_ACCT, ORG_CUST) -- tested

Line 2151: child_id: 123, child_entity_name: HZ_CUST_SITE_USES_ALL,

2147:
2148: example:
2149:
2150: child record:
2151: child_id: 123, child_entity_name: HZ_CUST_SITE_USES_ALL,
2152: child_bo: CUST_ACCT_SITE_USE, parent_bo: CUST_ACCT_SITE, parent_entity_name: HZ_CUST_ACCT_SITES_ALL,
2153: parent_id: 234
2154:
2155: The "inner select" fetches above record from BOT and identifies

Line 2203: WHERE t.CHILD_ENTITY_NAME = 'HZ_CUST_SITE_USES_ALL'

2199: ,RANK()
2200: OVER (PARTITION BY PARENT_BO_CODE, PARENT_ID
2201: ORDER BY t.LAST_UPDATE_DATE, child_id) as acrrank
2202: FROM HZ_BUS_OBJ_TRACKING t, HZ_CUST_ACCT_SITES_ALL s
2203: WHERE t.CHILD_ENTITY_NAME = 'HZ_CUST_SITE_USES_ALL'
2204: AND t.event_id IS NULL
2205: AND t.parent_id = s.CUST_ACCT_SITE_ID) temp
2206: WHERE NOT EXISTS
2207: (SELECT 1 FROM HZ_BUS_OBJ_TRACKING bot --select to exclude the parents that were already written to BOT

Line 2220: (p_message=>'ei_HZ_CUST_SITE_USES_ALL-',

2216: -- save the records populated
2217: COMMIT;
2218: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2219: hz_utility_v2pub.DEBUG
2220: (p_message=>'ei_HZ_CUST_SITE_USES_ALL-',
2221: p_prefix=>l_debug_prefix,
2222: p_msg_level=>fnd_log.level_procedure,
2223: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',
2224: p_module =>'ei_actsiteuse');

Line 2228: LOG( message => 'ei_HZ_CUST_SITE_USES_ALL:'||SQLERRM,

2224: p_module =>'ei_actsiteuse');
2225: END IF;
2226: EXCEPTION
2227: WHEN OTHERS THEN
2228: LOG( message => 'ei_HZ_CUST_SITE_USES_ALL:'||SQLERRM,
2229: p_prefix =>l_debug_prefix,
2230: p_module =>'ei_actsiteuse');
2231: ROLLBACK;
2232: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2233: END ei_HZ_CUST_SITE_USES_ALL;

2229: p_prefix =>l_debug_prefix,
2230: p_module =>'ei_actsiteuse');
2231: ROLLBACK;
2232: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2233: END ei_HZ_CUST_SITE_USES_ALL;
2234: -----------------------------------------------------------------
2235: /*
2236: Procedure name: PROCEDURE ei_HZ_CUST_ACCT_SITES_ALL()
2237: Purpose: Writes the parent node record for HZ_CUST_ACCT_SITES_ALL in BOT

Line 2849: FROM HZ_CUST_SITE_USES_ALL

2845: END parent_entity_name -- this is grand parent tbl name of acct roles, written as parent entity name
2846: ,CASE PARENT_BO_CODE
2847: WHEN 'CUST_ACCT_SITE_USE' THEN
2848: (SELECT CUST_ACCT_SITE_ID
2849: FROM HZ_CUST_SITE_USES_ALL
2850: WHERE SITE_USE_ID = PARENT_ID)
2851: WHEN 'CUST_ACCT' THEN
2852: (SELECT PARTY_ID
2853: FROM HZ_CUST_ACCOUNTS

Line 3436: 14. HZ_CUST_SITE_USES_ALL

3432: 10. HZ_ORG_CONTACTS
3433: 11. HZ_ORG_PROFILES_EXT_VL
3434: 12. HZ_CUST_ACCOUNT_ROLES
3435: 13. HZ_CUSTOMER_PROFILES
3436: 14. HZ_CUST_SITE_USES_ALL
3437: 15. HZ_CUST_ACCT_SITES_ALL
3438: 16. HZ_CUST_ACCOUNTS
3439: */
3440: -- Insert the parent record

Line 3649: -- 14. HZ_CUST_SITE_USES_ALL

3645: p_module =>'pop_missing_lnks');
3646: END IF;
3647:
3648: ei_HZ_CUSTOMER_PROFILES;
3649: -- 14. HZ_CUST_SITE_USES_ALL
3650: /* LOG(
3651: message => 'bfr calling ei_HZ_CUST_SITE_USES_ALL()',
3652: p_prefix =>l_debug_prefix,
3653: p_module => l_module);

Line 3651: message => 'bfr calling ei_HZ_CUST_SITE_USES_ALL()',

3647:
3648: ei_HZ_CUSTOMER_PROFILES;
3649: -- 14. HZ_CUST_SITE_USES_ALL
3650: /* LOG(
3651: message => 'bfr calling ei_HZ_CUST_SITE_USES_ALL()',
3652: p_prefix =>l_debug_prefix,
3653: p_module => l_module);
3654: */
3655: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 3657: (p_message=>'bfr calling ei_HZ_CUST_SITE_USES_ALL()',

3653: p_module => l_module);
3654: */
3655: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3656: hz_utility_v2pub.DEBUG
3657: (p_message=>'bfr calling ei_HZ_CUST_SITE_USES_ALL()',
3658: p_prefix=>l_debug_prefix,
3659: p_msg_level=>fnd_log.level_procedure,
3660: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',
3661: p_module =>'pop_missing_lnks');

Line 3664: ei_HZ_CUST_SITE_USES_ALL;

3660: p_module_prefix => 'HZ_BES_BO_UTIL_PKG',
3661: p_module =>'pop_missing_lnks');
3662: END IF;
3663:
3664: ei_HZ_CUST_SITE_USES_ALL;
3665: -- 15. HZ_CUST_ACCT_SITES_ALL
3666: /*
3667: LOG(
3668: message => 'bfr calling ei_HZ_CUST_ACCT_SITES_ALL()',