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_RELATE_ALL

Line 2404: -- Procedure name: pop_hz_cust_acct_relate_all()

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
2406: -- Scope: internal
2407: -- Called From: V2 API
2408: -- Called By: HZ_CUST_ACCT_RELATE_ALL create or update APIs

Line 2405: -- Purpose: populates BOT for HZ_CUST_ACCT_RELATE_ALL create or update

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
2406: -- Scope: internal
2407: -- Called From: V2 API
2408: -- Called By: HZ_CUST_ACCT_RELATE_ALL create or update APIs
2409: -- Input Parameters:

Line 2408: -- Called By: HZ_CUST_ACCT_RELATE_ALL create or update APIs

2404: -- Procedure name: pop_hz_cust_acct_relate_all()
2405: -- Purpose: populates BOT for HZ_CUST_ACCT_RELATE_ALL create or update
2406: -- Scope: internal
2407: -- Called From: V2 API
2408: -- Called By: HZ_CUST_ACCT_RELATE_ALL create or update APIs
2409: -- Input Parameters:
2410: -- p_operation -- contains I or U. 'I' if create API is calling this otherwise 'U'.
2411: -- p_cust_account_id IN NUMBER
2412: -- p_related_cust_account_id IN NUMBER

Line 2415: -- Following are the allowed PARENT and CHILD BO combinations for HZ_CUST_ACCT_RELATE_ALL

2411: -- p_cust_account_id IN NUMBER
2412: -- p_related_cust_account_id IN NUMBER
2413: --
2414: -- Note:
2415: -- Following are the allowed PARENT and CHILD BO combinations for HZ_CUST_ACCT_RELATE_ALL
2416: -- This procedure must ensure that the combination is valid before populating BOT
2417: --
2418: -- PARENT BO: CUST_ACCT :: CHILD BO:
2419: -----------------------------------------------------------------

Line 2420: PROCEDURE pop_hz_cust_acct_relate_all(p_operation IN VARCHAR2,

2416: -- This procedure must ensure that the combination is valid before populating BOT
2417: --
2418: -- PARENT BO: CUST_ACCT :: CHILD BO:
2419: -----------------------------------------------------------------
2420: PROCEDURE pop_hz_cust_acct_relate_all(p_operation IN VARCHAR2,
2421: p_cust_acct_relate_id IN NUMBER) IS
2422:
2423: -- cursor statement to select the info from child table
2424: CURSOR C_child IS

Line 2432: FROM HZ_CUST_ACCT_RELATE_ALL car, HZ_CUST_ACCOUNTS ca, HZ_CUST_ACCOUNTS rel_ca,

2428: car.related_cust_account_id rcap_id,
2429: decode(p.party_type, 'ORGANIZATION', 'ORG_CUST', 'PERSON', 'PERSON_CUST', NULL) pbo,
2430: decode(rel_p.party_type, 'ORGANIZATION', 'ORG_CUST', 'PERSON', 'PERSON_CUST', NULL) rel_pbo,
2431: p.party_id pid, rel_p.party_id rel_pid
2432: FROM HZ_CUST_ACCT_RELATE_ALL car, HZ_CUST_ACCOUNTS ca, HZ_CUST_ACCOUNTS rel_ca,
2433: HZ_PARTIES p, HZ_PARTIES rel_p
2434: WHERE car.cust_acct_relate_id = p_cust_acct_relate_id
2435: AND car.cust_account_id = ca.cust_account_id
2436: AND car.related_cust_account_id = rel_ca.cust_account_id

Line 2443: l_debug_prefix VARCHAR2(40) := 'pop_hz_cust_acct_relate_all';

2439: AND p.party_type in ('ORGANIZATION', 'PERSON')
2440: AND rel_p.party_type in ('ORGANIZATION', 'PERSON');
2441:
2442: -- local variables
2443: l_debug_prefix VARCHAR2(40) := 'pop_hz_cust_acct_relate_all';
2444: l_child_id NUMBER; -- used to store HZ_CUST_ACCT_RELATE_ALL identifier
2445: l_lud DATE; -- used to store the child last update date
2446: l_child_rec_exists_no NUMBER;
2447: l_cap_id NUMBER;

Line 2444: l_child_id NUMBER; -- used to store HZ_CUST_ACCT_RELATE_ALL identifier

2440: AND rel_p.party_type in ('ORGANIZATION', 'PERSON');
2441:
2442: -- local variables
2443: l_debug_prefix VARCHAR2(40) := 'pop_hz_cust_acct_relate_all';
2444: l_child_id NUMBER; -- used to store HZ_CUST_ACCT_RELATE_ALL identifier
2445: l_lud DATE; -- used to store the child last update date
2446: l_child_rec_exists_no NUMBER;
2447: l_cap_id NUMBER;
2448: l_rcap_id NUMBER;

Line 2453: l_cen VARCHAR2(30) := 'HZ_CUST_ACCT_RELATE_ALL';

2449: l_pbo VARCHAR2(30);
2450: l_pid NUMBER;
2451: l_rel_pbo VARCHAR2(30);
2452: l_rel_pid NUMBER;
2453: l_cen VARCHAR2(30) := 'HZ_CUST_ACCT_RELATE_ALL';
2454: BEGIN
2455: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_cust_acct_relate_all+',
2456: p_prefix=>l_debug_prefix,
2457: p_msg_level=>fnd_log.level_procedure);

Line 2455: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_cust_acct_relate_all+',

2451: l_rel_pbo VARCHAR2(30);
2452: l_rel_pid NUMBER;
2453: l_cen VARCHAR2(30) := 'HZ_CUST_ACCT_RELATE_ALL';
2454: BEGIN
2455: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_cust_acct_relate_all+',
2456: p_prefix=>l_debug_prefix,
2457: p_msg_level=>fnd_log.level_procedure);
2458:
2459: -- validate p_operation

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

2459: -- validate p_operation
2460: IF p_operation IN ('I','U') THEN
2461: NULL;
2462: ELSE
2463: hz_utility_v2pub.DEBUG(p_message=> 'incorrect operation flag sent to pop_hz_cust_acct_relate_all',
2464: p_prefix=>l_debug_prefix,
2465: p_msg_level=>fnd_log.level_procedure);
2466: RAISE FND_API.G_EXC_ERROR;
2467: END IF;

Line 2502: 'N', p_operation, l_child_id, 'HZ_CUST_ACCT_RELATE_ALL', NULL,

2498: INSERT INTO HZ_BUS_OBJ_TRACKING
2499: ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
2500: LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
2501: ) VALUES (
2502: 'N', p_operation, l_child_id, 'HZ_CUST_ACCT_RELATE_ALL', NULL,
2503: l_lud, l_lud, 'HZ_CUST_ACCOUNTS', l_cap_id, 'CUST_ACCT');
2504:
2505: pop_parent_record(p_child_id => l_cap_id,
2506: p_lud => l_lud,

Line 2525: 'N', p_operation, l_child_id, 'HZ_CUST_ACCT_RELATE_ALL', NULL,

2521: INSERT INTO HZ_BUS_OBJ_TRACKING
2522: ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
2523: LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
2524: ) VALUES (
2525: 'N', p_operation, l_child_id, 'HZ_CUST_ACCT_RELATE_ALL', NULL,
2526: l_lud, l_lud, 'HZ_CUST_ACCOUNTS', l_rcap_id, 'CUST_ACCT');
2527:
2528: pop_parent_record(p_child_id => l_rcap_id,
2529: p_lud => l_lud,

Line 2547: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_cust_acct_relate_all-',

2543:
2544: END ; -- anonymous block end
2545: END LOOP;
2546:
2547: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_cust_acct_relate_all-',
2548: p_prefix=>l_debug_prefix,
2549: p_msg_level=>fnd_log.level_procedure);
2550: EXCEPTION
2551: WHEN OTHERS THEN

Line 2556: END pop_hz_cust_acct_relate_all;

2552: hz_utility_v2pub.DEBUG(p_message=> SQLERRM,
2553: p_prefix=>l_debug_prefix,
2554: p_msg_level=>fnd_log.level_procedure);
2555: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2556: END pop_hz_cust_acct_relate_all;
2557:
2558: -----------------------------------------------------------------
2559: -- Procedure name: pop_hz_cust_account_roles()
2560: -- Purpose: populates BOT for HZ_CUST_ACCOUNT_ROLES create or update