APPS.HZ_ACCOUNT_VALIDATE_V2PUB dependencies on HZ_ROLE_RESPONSIBILITY

Line 10290: l_responsibility_type HZ_ROLE_RESPONSIBILITY.responsibility_type%TYPE;

10286: l_debug_prefix VARCHAR2(30) := ''; -- 'validate_role_repsonsibility'
10287:
10288: l_dummy VARCHAR2(1);
10289:
10290: l_responsibility_type HZ_ROLE_RESPONSIBILITY.responsibility_type%TYPE;
10291: l_cust_account_role_id NUMBER;
10292: l_orig_system_reference HZ_ROLE_RESPONSIBILITY.orig_system_reference%TYPE;
10293: l_created_by_module HZ_ROLE_RESPONSIBILITY.created_by_module%TYPE;
10294: l_application_id NUMBER;

Line 10292: l_orig_system_reference HZ_ROLE_RESPONSIBILITY.orig_system_reference%TYPE;

10288: l_dummy VARCHAR2(1);
10289:
10290: l_responsibility_type HZ_ROLE_RESPONSIBILITY.responsibility_type%TYPE;
10291: l_cust_account_role_id NUMBER;
10292: l_orig_system_reference HZ_ROLE_RESPONSIBILITY.orig_system_reference%TYPE;
10293: l_created_by_module HZ_ROLE_RESPONSIBILITY.created_by_module%TYPE;
10294: l_application_id NUMBER;
10295:
10296: BEGIN

Line 10293: l_created_by_module HZ_ROLE_RESPONSIBILITY.created_by_module%TYPE;

10289:
10290: l_responsibility_type HZ_ROLE_RESPONSIBILITY.responsibility_type%TYPE;
10291: l_cust_account_role_id NUMBER;
10292: l_orig_system_reference HZ_ROLE_RESPONSIBILITY.orig_system_reference%TYPE;
10293: l_created_by_module HZ_ROLE_RESPONSIBILITY.created_by_module%TYPE;
10294: l_application_id NUMBER;
10295:
10296: BEGIN
10297:

Line 10314: FROM HZ_ROLE_RESPONSIBILITY

10310: SELECT RESPONSIBILITY_TYPE, CUST_ACCOUNT_ROLE_ID, ORIG_SYSTEM_REFERENCE ,
10311: CREATED_BY_MODULE, APPLICATION_ID
10312: INTO l_responsibility_type, l_cust_account_role_id, l_orig_system_reference,
10313: l_created_by_module, l_application_id
10314: FROM HZ_ROLE_RESPONSIBILITY
10315: WHERE ROWID = p_rowid;
10316: END IF;
10317:
10318: --------------------------------------

Line 10334: FROM HZ_ROLE_RESPONSIBILITY

10330: p_role_responsibility_rec.responsibility_id <> FND_API.G_MISS_NUM
10331: THEN
10332: BEGIN
10333: SELECT 'Y' INTO l_dummy
10334: FROM HZ_ROLE_RESPONSIBILITY
10335: WHERE RESPONSIBILITY_ID = p_role_responsibility_rec.responsibility_id;
10336:
10337: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_DUPLICATE_COLUMN' );
10338: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'responsibility_id' );

Line 10501: FROM HZ_ROLE_RESPONSIBILITY

10497: END IF;
10498:
10499: BEGIN
10500: SELECT 'Y' INTO l_dummy
10501: FROM HZ_ROLE_RESPONSIBILITY
10502: WHERE CUST_ACCOUNT_ROLE_ID = l_cust_account_role_id
10503: AND RESPONSIBILITY_TYPE = l_responsibility_type
10504: AND ( p_create_update_flag = 'C' OR
10505: ( p_create_update_flag = 'U' AND ROWID <> p_rowid ) )

Line 10598: FROM HZ_ROLE_RESPONSIBILITY

10594: END IF;
10595:
10596: BEGIN
10597: SELECT 'Y' INTO l_dummy
10598: FROM HZ_ROLE_RESPONSIBILITY
10599: WHERE CUST_ACCOUNT_ROLE_ID = l_cust_account_role_id
10600: AND PRIMARY_FLAG = 'Y'
10601: AND ( p_create_update_flag = 'C' OR
10602: p_create_update_flag = 'U' AND ROWID <> p_rowid )