APPS.HZ_ACCOUNT_VALIDATE_V2PUB dependencies on HZ_ROLE_RESPONSIBILITY

Line 10573: l_responsibility_type HZ_ROLE_RESPONSIBILITY.responsibility_type%TYPE;

10569: l_debug_prefix VARCHAR2(30) := ''; -- 'validate_role_repsonsibility'
10570:
10571: l_dummy VARCHAR2(1);
10572:
10573: l_responsibility_type HZ_ROLE_RESPONSIBILITY.responsibility_type%TYPE;
10574: l_cust_account_role_id NUMBER;
10575: l_orig_system_reference HZ_ROLE_RESPONSIBILITY.orig_system_reference%TYPE;
10576: l_created_by_module HZ_ROLE_RESPONSIBILITY.created_by_module%TYPE;
10577: l_application_id NUMBER;

Line 10575: l_orig_system_reference HZ_ROLE_RESPONSIBILITY.orig_system_reference%TYPE;

10571: l_dummy VARCHAR2(1);
10572:
10573: l_responsibility_type HZ_ROLE_RESPONSIBILITY.responsibility_type%TYPE;
10574: l_cust_account_role_id NUMBER;
10575: l_orig_system_reference HZ_ROLE_RESPONSIBILITY.orig_system_reference%TYPE;
10576: l_created_by_module HZ_ROLE_RESPONSIBILITY.created_by_module%TYPE;
10577: l_application_id NUMBER;
10578:
10579: BEGIN

Line 10576: l_created_by_module HZ_ROLE_RESPONSIBILITY.created_by_module%TYPE;

10572:
10573: l_responsibility_type HZ_ROLE_RESPONSIBILITY.responsibility_type%TYPE;
10574: l_cust_account_role_id NUMBER;
10575: l_orig_system_reference HZ_ROLE_RESPONSIBILITY.orig_system_reference%TYPE;
10576: l_created_by_module HZ_ROLE_RESPONSIBILITY.created_by_module%TYPE;
10577: l_application_id NUMBER;
10578:
10579: BEGIN
10580:

Line 10597: FROM HZ_ROLE_RESPONSIBILITY

10593: SELECT RESPONSIBILITY_TYPE, CUST_ACCOUNT_ROLE_ID, ORIG_SYSTEM_REFERENCE ,
10594: CREATED_BY_MODULE, APPLICATION_ID
10595: INTO l_responsibility_type, l_cust_account_role_id, l_orig_system_reference,
10596: l_created_by_module, l_application_id
10597: FROM HZ_ROLE_RESPONSIBILITY
10598: WHERE ROWID = p_rowid;
10599: END IF;
10600:
10601: --------------------------------------

Line 10617: FROM HZ_ROLE_RESPONSIBILITY

10613: p_role_responsibility_rec.responsibility_id <> FND_API.G_MISS_NUM
10614: THEN
10615: BEGIN
10616: SELECT 'Y' INTO l_dummy
10617: FROM HZ_ROLE_RESPONSIBILITY
10618: WHERE RESPONSIBILITY_ID = p_role_responsibility_rec.responsibility_id;
10619:
10620: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_DUPLICATE_COLUMN' );
10621: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'responsibility_id' );

Line 10784: FROM HZ_ROLE_RESPONSIBILITY

10780: END IF;
10781:
10782: BEGIN
10783: SELECT 'Y' INTO l_dummy
10784: FROM HZ_ROLE_RESPONSIBILITY
10785: WHERE CUST_ACCOUNT_ROLE_ID = l_cust_account_role_id
10786: AND RESPONSIBILITY_TYPE = l_responsibility_type
10787: AND ( p_create_update_flag = 'C' OR
10788: ( p_create_update_flag = 'U' AND ROWID <> p_rowid ) )

Line 10881: FROM HZ_ROLE_RESPONSIBILITY

10877: END IF;
10878:
10879: BEGIN
10880: SELECT 'Y' INTO l_dummy
10881: FROM HZ_ROLE_RESPONSIBILITY
10882: WHERE CUST_ACCOUNT_ROLE_ID = l_cust_account_role_id
10883: AND PRIMARY_FLAG = 'Y'
10884: AND ( p_create_update_flag = 'C' OR
10885: p_create_update_flag = 'U' AND ROWID <> p_rowid )