APPS.HZ_CUST_ACCOUNT_V2PUB dependencies on HZ_CUST_ACCT_RELATE_ALL

Line 1163: FROM HZ_CUST_ACCT_RELATE_ALL -- Bug 3456489

1159: END IF;
1160:
1161: SELECT CUST_ACCT_RELATE_ID, CUSTOMER_RECIPROCAL_FLAG -- Bug 4529413
1162: INTO l_cust_acct_relate_id, l_customer_reciprocal_flag
1163: FROM HZ_CUST_ACCT_RELATE_ALL -- Bug 3456489
1164: WHERE CUST_ACCOUNT_ID = p_cust_acct_relate_rec.related_cust_account_id
1165: AND RELATED_CUST_ACCOUNT_ID = p_cust_acct_relate_rec.cust_account_id
1166: --Bug 2985448.
1167: AND STATUS='A'

Line 1174: UPDATE HZ_CUST_ACCT_RELATE_ALL

1170: -- reciprocal relationship exist, update its reciprocal flag.
1171: -- customer_reciprocal_flag is NOT NULL column.
1172:
1173: IF l_customer_reciprocal_flag <> 'Y' THEN
1174: UPDATE HZ_CUST_ACCT_RELATE_ALL
1175: SET CUSTOMER_RECIPROCAL_FLAG = 'Y'
1176: WHERE CUST_ACCT_RELATE_ID = l_cust_acct_relate_id; -- Bug 4529413
1177: END IF;
1178:

Line 1340: FROM HZ_CUST_ACCT_RELATE_ALL

1336: l_cust_account_id,
1337: l_related_cust_account_id,
1338: l_status,
1339: p_cust_acct_relate_rec.org_id -- Bug 3456489
1340: FROM HZ_CUST_ACCT_RELATE_ALL
1341: WHERE CUST_ACCT_RELATE_ID = l_cust_acct_relate_id
1342: FOR UPDATE NOWAIT;
1343:
1344: -- cust_account_id is not updateable.

Line 1373: FROM HZ_CUST_ACCT_RELATE_ALL -- Bug 3456489

1369: l_status = 'I'
1370: THEN
1371: SELECT COUNT(*)
1372: INTO l_count
1373: FROM HZ_CUST_ACCT_RELATE_ALL -- Bug 3456489
1374: WHERE CUST_ACCOUNT_ID = l_cust_account_id AND
1375: RELATED_CUST_ACCOUNT_ID = l_related_cust_account_id AND
1376: STATUS = 'A' AND
1377: ORG_ID = p_cust_acct_relate_rec.org_id; -- Bug 3456489

Line 2702: HZ_POPULATE_BOT_PKG.pop_hz_cust_acct_relate_all(

2698: END IF;
2699:
2700: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
2701: -- populate function for integration service
2702: HZ_POPULATE_BOT_PKG.pop_hz_cust_acct_relate_all(
2703: p_operation => 'I',
2704: p_cust_acct_relate_id => l_cust_acct_relate_rec.cust_acct_relate_id);
2705: END IF;
2706: END IF;

Line 2923: HZ_POPULATE_BOT_PKG.pop_hz_cust_acct_relate_all(

2919: END IF;
2920:
2921: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
2922: -- populate function for integration service
2923: HZ_POPULATE_BOT_PKG.pop_hz_cust_acct_relate_all(
2924: p_operation => 'U',
2925: p_cust_acct_relate_id => l_old_cust_acct_relate_rec.cust_acct_relate_id); --bug 8654754. cust_acct_relate_id has no value in relate rec. Old rec got the value from the get API.
2926:
2927: END IF;

Line 3150: HZ_POPULATE_BOT_PKG.pop_hz_cust_acct_relate_all(

3146: END IF;
3147:
3148: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
3149: -- populate function for integration service
3150: HZ_POPULATE_BOT_PKG.pop_hz_cust_acct_relate_all(
3151: p_operation => 'U',
3152: p_cust_acct_relate_id => l_old_cust_acct_relate_rec.cust_acct_relate_id); --bug 8654754. cust_acct_relate_id has no value in relate rec. Old rec got the value from the get API.
3153:
3154: END IF;