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_ACCT_SITES_ALL

Line 218: decode(car.cust_acct_site_id, null, 'HZ_CUST_ACCOUNTS', 'HZ_CUST_ACCT_SITES_ALL') car_parent_entity,

214: -- cursor statement to select the info from child table
215: CURSOR c_child IS
216: SELECT rr.LAST_UPDATE_DATE lud, rr.CUST_ACCOUNT_ROLE_ID parent_id, rr.RESPONSIBILITY_ID child_id,
217: nvl(car.cust_acct_site_id, car.cust_account_id) car_parent_id,
218: decode(car.cust_acct_site_id, null, 'HZ_CUST_ACCOUNTS', 'HZ_CUST_ACCT_SITES_ALL') car_parent_entity,
219: decode(car.cust_acct_site_id, null, 'CUST_ACCT', 'CUST_ACCT_SITE') car_parent_bo
220: FROM HZ_ROLE_RESPONSIBILITY rr, HZ_CUST_ACCOUNT_ROLES car
221: WHERE rr.RESPONSIBILITY_ID = P_RESPONSIBILITY_ID
222: AND rr.cust_account_role_id = car.cust_account_role_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 2168: l_lud, l_lud, 'HZ_CUST_ACCT_SITES_ALL', l_parent_id, 'CUST_ACCT_SITE');

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:
2172: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_cust_site_uses_all-',

Line 2295: -- Procedure name: pop_hz_cust_acct_sites_all()

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
2297: -- Scope: internal
2298: -- Called From: V2 API
2299: -- Called By: HZ_CUST_ACCT_SITES_ALL create or update APIs

Line 2296: -- Purpose: populates BOT for HZ_CUST_ACCT_SITES_ALL create or update

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
2297: -- Scope: internal
2298: -- Called From: V2 API
2299: -- Called By: HZ_CUST_ACCT_SITES_ALL create or update APIs
2300: -- Input Parameters:

Line 2299: -- Called By: HZ_CUST_ACCT_SITES_ALL create or update APIs

2295: -- Procedure name: pop_hz_cust_acct_sites_all()
2296: -- Purpose: populates BOT for HZ_CUST_ACCT_SITES_ALL create or update
2297: -- Scope: internal
2298: -- Called From: V2 API
2299: -- Called By: HZ_CUST_ACCT_SITES_ALL create or update APIs
2300: -- Input Parameters:
2301: -- p_operation -- contains I or U. 'I' if create API is calling this otherwise 'U'.
2302: -- p_cust_acct_site_id IN NUMBER
2303: --

Line 2305: -- Following are the allowed PARENT and CHILD BO combinations for HZ_CUST_ACCT_SITES_ALL

2301: -- p_operation -- contains I or U. 'I' if create API is calling this otherwise 'U'.
2302: -- p_cust_acct_site_id IN NUMBER
2303: --
2304: -- Note:
2305: -- Following are the allowed PARENT and CHILD BO combinations for HZ_CUST_ACCT_SITES_ALL
2306: -- This procedure must ensure that the combination is valid before populating BOT
2307: --
2308: -- PARENT BO: CUST_ACCT :: CHILD BO: CUST_ACCT_SITE
2309: -----------------------------------------------------------------

Line 2310: PROCEDURE pop_hz_cust_acct_sites_all(p_operation IN VARCHAR2, p_cust_acct_site_id IN NUMBER) IS

2306: -- This procedure must ensure that the combination is valid before populating BOT
2307: --
2308: -- PARENT BO: CUST_ACCT :: CHILD BO: CUST_ACCT_SITE
2309: -----------------------------------------------------------------
2310: PROCEDURE pop_hz_cust_acct_sites_all(p_operation IN VARCHAR2, p_cust_acct_site_id IN NUMBER) IS
2311:
2312: -- cursor statement to select the info from child table
2313: CURSOR C_child IS
2314: SELECT cas.LAST_UPDATE_DATE lud, cas.CUST_ACCOUNT_ID parent_id, cas.CUST_ACCT_SITE_ID child_id,

Line 2317: FROM HZ_CUST_ACCT_SITES_ALL cas, HZ_CUST_ACCOUNTS ca, HZ_PARTIES p

2313: CURSOR C_child IS
2314: SELECT cas.LAST_UPDATE_DATE lud, cas.CUST_ACCOUNT_ID parent_id, cas.CUST_ACCT_SITE_ID child_id,
2315: ca.party_id ca_parent_id,
2316: decode(p.party_type, 'ORGANIZATION', 'ORG', 'PERSON', 'PERSON', NULL) ca_parent_bo
2317: FROM HZ_CUST_ACCT_SITES_ALL cas, HZ_CUST_ACCOUNTS ca, HZ_PARTIES p
2318: WHERE cas.CUST_ACCT_SITE_ID = P_CUST_ACCT_SITE_ID
2319: AND cas.cust_account_id = ca.cust_account_id
2320: AND ca.party_id = p.party_id
2321: AND p.party_type in ('ORGANIZATION', 'PERSON')

Line 2325: l_debug_prefix VARCHAR2(40) := 'pop_hz_cust_acct_sites_all';

2321: AND p.party_type in ('ORGANIZATION', 'PERSON')
2322: AND cas.cust_account_id > 0;
2323:
2324: -- local variables
2325: l_debug_prefix VARCHAR2(40) := 'pop_hz_cust_acct_sites_all';
2326: l_parent_id NUMBER; -- used to store parent entity identifier
2327: l_child_id NUMBER; -- used to store HZ_CUST_ACCT_SITES_ALL identifier
2328: l_lud DATE; -- used to store the child last update date
2329: l_child_rec_exists_no NUMBER;

Line 2327: l_child_id NUMBER; -- used to store HZ_CUST_ACCT_SITES_ALL identifier

2323:
2324: -- local variables
2325: l_debug_prefix VARCHAR2(40) := 'pop_hz_cust_acct_sites_all';
2326: l_parent_id NUMBER; -- used to store parent entity identifier
2327: l_child_id NUMBER; -- used to store HZ_CUST_ACCT_SITES_ALL identifier
2328: l_lud DATE; -- used to store the child last update date
2329: l_child_rec_exists_no NUMBER;
2330: l_ca_parent_id NUMBER;
2331: l_ca_parent_bo VARCHAR2(30);

Line 2333: l_cen VARCHAR2(30) := 'HZ_CUST_ACCT_SITES_ALL';

2329: l_child_rec_exists_no NUMBER;
2330: l_ca_parent_id NUMBER;
2331: l_ca_parent_bo VARCHAR2(30);
2332: l_pop_flag VARCHAR2(1);
2333: l_cen VARCHAR2(30) := 'HZ_CUST_ACCT_SITES_ALL';
2334: BEGIN
2335: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_cust_acct_sites_all+',
2336: p_prefix=>l_debug_prefix,
2337: p_msg_level=>fnd_log.level_procedure);

Line 2335: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_cust_acct_sites_all+',

2331: l_ca_parent_bo VARCHAR2(30);
2332: l_pop_flag VARCHAR2(1);
2333: l_cen VARCHAR2(30) := 'HZ_CUST_ACCT_SITES_ALL';
2334: BEGIN
2335: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_cust_acct_sites_all+',
2336: p_prefix=>l_debug_prefix,
2337: p_msg_level=>fnd_log.level_procedure);
2338:
2339: -- validate p_operation

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

2339: -- validate p_operation
2340: IF p_operation IN ('I','U') THEN
2341: NULL;
2342: ELSE
2343: hz_utility_v2pub.DEBUG(p_message=> 'incorrect operation flag sent to pop_hz_cust_acct_sites_all',
2344: p_prefix=>l_debug_prefix,
2345: p_msg_level=>fnd_log.level_procedure);
2346: RAISE FND_API.G_EXC_ERROR;
2347: END IF;

Line 2387: 'N', p_operation, l_child_id, 'HZ_CUST_ACCT_SITES_ALL', 'CUST_ACCT_SITE',

2383: INSERT INTO HZ_BUS_OBJ_TRACKING
2384: ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
2385: LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
2386: ) VALUES (
2387: 'N', p_operation, l_child_id, 'HZ_CUST_ACCT_SITES_ALL', 'CUST_ACCT_SITE',
2388: l_lud, l_lud, 'HZ_CUST_ACCOUNTS', l_parent_id, 'CUST_ACCT');
2389: END ; -- anonymous block end
2390: END LOOP;
2391:

Line 2392: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_cust_acct_sites_all-',

2388: l_lud, l_lud, 'HZ_CUST_ACCOUNTS', l_parent_id, 'CUST_ACCT');
2389: END ; -- anonymous block end
2390: END LOOP;
2391:
2392: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_cust_acct_sites_all-',
2393: p_prefix=>l_debug_prefix,
2394: p_msg_level=>fnd_log.level_procedure);
2395: EXCEPTION
2396: WHEN OTHERS THEN

Line 2401: END pop_hz_cust_acct_sites_all;

2397: hz_utility_v2pub.DEBUG(p_message=> SQLERRM,
2398: p_prefix=>l_debug_prefix,
2399: p_msg_level=>fnd_log.level_procedure);
2400: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2401: END pop_hz_cust_acct_sites_all;
2402:
2403: -----------------------------------------------------------------
2404: -- Procedure name: pop_hz_cust_acct_relate_all()
2405: -- Purpose: populates BOT for HZ_CUST_ACCT_RELATE_ALL create or update

Line 2582: decode(car.cust_acct_site_id, null, 'HZ_CUST_ACCOUNTS', 'HZ_CUST_ACCT_SITES_ALL') parent_entity,

2578: CURSOR C_child IS
2579: SELECT car.LAST_UPDATE_DATE lud, car.CUST_ACCOUNT_ROLE_ID child_id,
2580: nvl(car.cust_acct_site_id, car.cust_account_id) parent_id,
2581: decode(car.cust_acct_site_id, null, 'CUST_ACCT', 'CUST_ACCT_SITE') parent_bo,
2582: decode(car.cust_acct_site_id, null, 'HZ_CUST_ACCOUNTS', 'HZ_CUST_ACCT_SITES_ALL') parent_entity,
2583: ca.cust_account_id ca_id
2584: FROM HZ_CUST_ACCOUNT_ROLES car, HZ_CUST_ACCOUNTS ca, HZ_PARTIES p
2585: WHERE car.CUST_ACCOUNT_ROLE_ID = P_CUST_ACCOUNT_ROLE_ID
2586: AND car.cust_account_id = ca.cust_account_id