APPS.HZ_ACCOUNT_VALIDATE_V2PUB dependencies on HZ_CUST_ACCT_RELATE

Line 2356: l_customer_reciprocal_flag HZ_CUST_ACCT_RELATE.customer_reciprocal_flag%TYPE;

2352: ) IS
2353:
2354: l_debug_prefix VARCHAR2(30) := '';
2355: l_dummy VARCHAR2(1);
2356: l_customer_reciprocal_flag HZ_CUST_ACCT_RELATE.customer_reciprocal_flag%TYPE;
2357: l_created_by_module HZ_CUST_ACCT_RELATE.created_by_module%TYPE;
2358: l_application_id NUMBER;
2359: l_relationship_type HZ_CUST_ACCT_RELATE.relationship_type%TYPE;
2360: l_status HZ_CUST_ACCT_RELATE.status%TYPE;

Line 2357: l_created_by_module HZ_CUST_ACCT_RELATE.created_by_module%TYPE;

2353:
2354: l_debug_prefix VARCHAR2(30) := '';
2355: l_dummy VARCHAR2(1);
2356: l_customer_reciprocal_flag HZ_CUST_ACCT_RELATE.customer_reciprocal_flag%TYPE;
2357: l_created_by_module HZ_CUST_ACCT_RELATE.created_by_module%TYPE;
2358: l_application_id NUMBER;
2359: l_relationship_type HZ_CUST_ACCT_RELATE.relationship_type%TYPE;
2360: l_status HZ_CUST_ACCT_RELATE.status%TYPE;
2361:

Line 2359: l_relationship_type HZ_CUST_ACCT_RELATE.relationship_type%TYPE;

2355: l_dummy VARCHAR2(1);
2356: l_customer_reciprocal_flag HZ_CUST_ACCT_RELATE.customer_reciprocal_flag%TYPE;
2357: l_created_by_module HZ_CUST_ACCT_RELATE.created_by_module%TYPE;
2358: l_application_id NUMBER;
2359: l_relationship_type HZ_CUST_ACCT_RELATE.relationship_type%TYPE;
2360: l_status HZ_CUST_ACCT_RELATE.status%TYPE;
2361:
2362: BEGIN
2363:

Line 2360: l_status HZ_CUST_ACCT_RELATE.status%TYPE;

2356: l_customer_reciprocal_flag HZ_CUST_ACCT_RELATE.customer_reciprocal_flag%TYPE;
2357: l_created_by_module HZ_CUST_ACCT_RELATE.created_by_module%TYPE;
2358: l_application_id NUMBER;
2359: l_relationship_type HZ_CUST_ACCT_RELATE.relationship_type%TYPE;
2360: l_status HZ_CUST_ACCT_RELATE.status%TYPE;
2361:
2362: BEGIN
2363:
2364: -- Check if API is called in debug mode. If yes, enable debug.

Line 2382: FROM HZ_CUST_ACCT_RELATE_ALL -- Bug 3456489

2378: SELECT CUSTOMER_RECIPROCAL_FLAG, CREATED_BY_MODULE, APPLICATION_ID,
2379: RELATIONSHIP_TYPE, STATUS
2380: INTO l_customer_reciprocal_flag, l_created_by_module, l_application_id,
2381: l_relationship_type, l_status
2382: FROM HZ_CUST_ACCT_RELATE_ALL -- Bug 3456489
2383: WHERE CUST_ACCT_RELATE_ID = p_cust_acct_relate_id;
2384: END IF;
2385:
2386: --------------------------------------

Line 2488: FROM HZ_CUST_ACCT_RELATE_ALL -- Bug 3456489

2484: -- are primary key.
2485: IF p_create_update_flag = 'C' THEN
2486: BEGIN
2487: SELECT 'Y' INTO l_dummy
2488: FROM HZ_CUST_ACCT_RELATE_ALL -- Bug 3456489
2489: WHERE CUST_ACCOUNT_ID = p_cust_acct_relate_rec.cust_account_id
2490: AND RELATED_CUST_ACCOUNT_ID = p_cust_acct_relate_rec.related_cust_account_id
2491: --Bug 2985448
2492: AND STATUS='A'

Line 7486: * hz_cust_acct_relate_all table should be Y when validating

7482: * warehouse_id,date_type_preference,
7483: * ship_sets_include_lines_flag and arrivalsets_include_lines_flag
7484: * in procedure VALIDATE_CUST_SITE_USE.
7485: * 03-26-2002 P.Suresh Bug No : 2266165. Added the check that bill_to_flag of
7486: * hz_cust_acct_relate_all table should be Y when validating
7487: * bill_to_site_use_id.
7488: * 04-11-2002 P.Suresh Bug No : 2260832. Added the check for the status
7489: * when validating that only one primary is allowed for
7490: * one site use type per account in the procedure

Line 8078: FROM HZ_CUST_ACCT_RELATE_ALL

8074: SELECT l_cust_account_id
8075: FROM DUAL
8076: UNION
8077: SELECT CUST_ACCOUNT_ID
8078: FROM HZ_CUST_ACCT_RELATE_ALL
8079: WHERE RELATED_CUST_ACCOUNT_ID = l_cust_account_id
8080: AND BILL_TO_FLAG = 'Y' );
8081: EXCEPTION
8082: WHEN NO_DATA_FOUND THEN