APPS.HZ_CUST_ACCOUNT_V2PUB dependencies on HZ_CUST_ACCT_RELATE_ALL

Line 1146: FROM HZ_CUST_ACCT_RELATE_ALL -- Bug 3456489

1142: END IF;
1143:
1144: SELECT CUST_ACCT_RELATE_ID, CUSTOMER_RECIPROCAL_FLAG -- Bug 4529413
1145: INTO l_cust_acct_relate_id, l_customer_reciprocal_flag
1146: FROM HZ_CUST_ACCT_RELATE_ALL -- Bug 3456489
1147: WHERE CUST_ACCOUNT_ID = p_cust_acct_relate_rec.related_cust_account_id
1148: AND RELATED_CUST_ACCOUNT_ID = p_cust_acct_relate_rec.cust_account_id
1149: --Bug 2985448.
1150: AND STATUS='A'

Line 1157: UPDATE HZ_CUST_ACCT_RELATE_ALL

1153: -- reciprocal relationship exist, update its reciprocal flag.
1154: -- customer_reciprocal_flag is NOT NULL column.
1155:
1156: IF l_customer_reciprocal_flag <> 'Y' THEN
1157: UPDATE HZ_CUST_ACCT_RELATE_ALL
1158: SET CUSTOMER_RECIPROCAL_FLAG = 'Y'
1159: WHERE CUST_ACCT_RELATE_ID = l_cust_acct_relate_id; -- Bug 4529413
1160: END IF;
1161:

Line 1323: FROM HZ_CUST_ACCT_RELATE_ALL

1319: l_cust_account_id,
1320: l_related_cust_account_id,
1321: l_status,
1322: p_cust_acct_relate_rec.org_id -- Bug 3456489
1323: FROM HZ_CUST_ACCT_RELATE_ALL
1324: WHERE CUST_ACCT_RELATE_ID = l_cust_acct_relate_id
1325: FOR UPDATE NOWAIT;
1326:
1327: -- cust_account_id is not updateable.

Line 1356: FROM HZ_CUST_ACCT_RELATE_ALL -- Bug 3456489

1352: l_status = 'I'
1353: THEN
1354: SELECT COUNT(*)
1355: INTO l_count
1356: FROM HZ_CUST_ACCT_RELATE_ALL -- Bug 3456489
1357: WHERE CUST_ACCOUNT_ID = l_cust_account_id AND
1358: RELATED_CUST_ACCOUNT_ID = l_related_cust_account_id AND
1359: STATUS = 'A' AND
1360: ORG_ID = p_cust_acct_relate_rec.org_id; -- Bug 3456489

Line 2669: HZ_POPULATE_BOT_PKG.pop_hz_cust_acct_relate_all(

2665: END IF;
2666:
2667: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
2668: -- populate function for integration service
2669: HZ_POPULATE_BOT_PKG.pop_hz_cust_acct_relate_all(
2670: p_operation => 'I',
2671: p_cust_acct_relate_id => l_cust_acct_relate_rec.cust_acct_relate_id);
2672: END IF;
2673: END IF;

Line 2890: HZ_POPULATE_BOT_PKG.pop_hz_cust_acct_relate_all(

2886: END IF;
2887:
2888: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
2889: -- populate function for integration service
2890: HZ_POPULATE_BOT_PKG.pop_hz_cust_acct_relate_all(
2891: p_operation => 'U',
2892: p_cust_acct_relate_id => l_cust_acct_relate_rec.cust_acct_relate_id);
2893: END IF;
2894: END IF;

Line 3116: HZ_POPULATE_BOT_PKG.pop_hz_cust_acct_relate_all(

3112: END IF;
3113:
3114: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
3115: -- populate function for integration service
3116: HZ_POPULATE_BOT_PKG.pop_hz_cust_acct_relate_all(
3117: p_operation => 'U',
3118: p_cust_acct_relate_id => l_cust_acct_relate_rec.cust_acct_relate_id);
3119: END IF;
3120: END IF;