APPS.ARI_SELF_REGISTRATION_PKG dependencies on HZ_ROLE_RESPONSIBILITY

Line 826: from hz_role_responsibility hrr, hz_cust_account_roles hcar

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

Line 1927: FROM hz_role_responsibility

1923: l_already_exists := 'N';
1924:
1925: SELECT 'Y'
1926: INTO l_already_exists
1927: FROM hz_role_responsibility
1928: WHERE cust_account_role_id = p_cust_acct_role_id
1929: AND responsibility_type = 'SELF_SERVICE_USER';
1930:
1931: EXCEPTION

Line 2023: l_role_resp_id HZ_ROLE_RESPONSIBILITY.responsibility_id%type;

2019: ---------------------------------------------------------------------------
2020: IS
2021: l_party_id NUMBER;
2022: l_cust_acct_role_id HZ_CUST_ACCOUNT_ROLES.cust_account_role_id%type;
2023: l_role_resp_id HZ_ROLE_RESPONSIBILITY.responsibility_id%type;
2024: l_cust_acct_type VARCHAR2(20);
2025: l_procedure_name VARCHAR2(50) := '.RegisterB2BUser';
2026: l_debug_info VARCHAR2(300);
2027:

Line 2077: l_role_resp_id HZ_ROLE_RESPONSIBILITY.responsibility_id%type;

2073: l_contact_preference VARCHAR2(5);
2074: l_contact_preference_id number;
2075: l_party_id NUMBER;
2076: l_cust_acct_role_id HZ_CUST_ACCOUNT_ROLES.cust_account_role_id%type;
2077: l_role_resp_id HZ_ROLE_RESPONSIBILITY.responsibility_id%type;
2078: l_cust_acct_type VARCHAR2(20);
2079: l_new_user VARCHAR2(10);
2080:
2081: l_procedure_name VARCHAR2(50) := '.RegisterB2CUser';