APPS.ARI_SELF_REGISTRATION_PKG dependencies on HZ_ROLE_RESPONSIBILITY

Line 825: from hz_role_responsibility hrr, hz_cust_account_roles hcar

821: CURSOR cust_acct_role_cur(p_person_party_id IN VARCHAR2,
822: p_customer_id IN VARCHAR2,
823: p_cust_acct_site_id IN VARCHAR2) IS
824: select hcar.cust_account_role_id
825: from hz_role_responsibility hrr, hz_cust_account_roles hcar
826: where hrr.responsibility_type = 'SELF_SERVICE_USER'
827: and hrr.cust_account_role_id = hcar.cust_account_role_id
828: and hcar.cust_account_id = p_customer_id
829: --Bug 4764121 : Fixed the removal of access to all customers

Line 2104: FROM hz_role_responsibility

2100: l_already_exists := 'N';
2101:
2102: SELECT 'Y'
2103: INTO l_already_exists
2104: FROM hz_role_responsibility
2105: WHERE cust_account_role_id = p_cust_acct_role_id
2106: AND responsibility_type = 'SELF_SERVICE_USER';
2107: ----------------------------------------------------------------------------
2108: l_debug_info := 'In CreateRoleRespFor l_already_exists:'||l_already_exists;

Line 2212: l_role_resp_id HZ_ROLE_RESPONSIBILITY.responsibility_id%type;

2208: ---------------------------------------------------------------------------
2209: IS
2210: l_party_id NUMBER;
2211: l_cust_acct_role_id HZ_CUST_ACCOUNT_ROLES.cust_account_role_id%type;
2212: l_role_resp_id HZ_ROLE_RESPONSIBILITY.responsibility_id%type;
2213: l_cust_acct_type VARCHAR2(20);
2214: l_procedure_name VARCHAR2(50) := '.RegisterB2BUser';
2215: l_debug_info VARCHAR2(300);
2216:

Line 2266: l_role_resp_id HZ_ROLE_RESPONSIBILITY.responsibility_id%type;

2262: l_contact_preference VARCHAR2(5);
2263: l_contact_preference_id number;
2264: l_party_id NUMBER;
2265: l_cust_acct_role_id HZ_CUST_ACCOUNT_ROLES.cust_account_role_id%type;
2266: l_role_resp_id HZ_ROLE_RESPONSIBILITY.responsibility_id%type;
2267: l_cust_acct_type VARCHAR2(20);
2268: l_new_user VARCHAR2(10);
2269:
2270: l_procedure_name VARCHAR2(50) := '.RegisterB2CUser';