APPS.ARI_SELF_REGISTRATION_PKG dependencies on HZ_CUST_ACCOUNT_ROLES

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 836: FROM HZ_CUST_ACCOUNT_ROLES

832: and hcar.party_id = p_person_party_id;
833:
834: CURSOR cu_acct_role_version (p_cust_acct_role_id IN NUMBER) IS
835: SELECT OBJECT_VERSION_NUMBER
836: FROM HZ_CUST_ACCOUNT_ROLES
837: WHERE CUST_ACCOUNT_ROLE_ID = p_cust_acct_role_id;
838:
839: l_cust_account_role_id HZ_CUST_ACCOUNT_ROLES.cust_account_role_id%TYPE;
840: p_cust_account_role_rec_type HZ_CUST_ACCOUNT_ROLE_V2PUB.cust_account_role_rec_type;

Line 839: l_cust_account_role_id HZ_CUST_ACCOUNT_ROLES.cust_account_role_id%TYPE;

835: SELECT OBJECT_VERSION_NUMBER
836: FROM HZ_CUST_ACCOUNT_ROLES
837: WHERE CUST_ACCOUNT_ROLE_ID = p_cust_acct_role_id;
838:
839: l_cust_account_role_id HZ_CUST_ACCOUNT_ROLES.cust_account_role_id%TYPE;
840: p_cust_account_role_rec_type HZ_CUST_ACCOUNT_ROLE_V2PUB.cust_account_role_rec_type;
841: l_object_version_number HZ_CUST_ACCOUNT_ROLES.object_version_number%TYPE;
842: l_msg_count NUMBER;
843: l_msg_data VARCHAR2(2000);

Line 841: l_object_version_number HZ_CUST_ACCOUNT_ROLES.object_version_number%TYPE;

837: WHERE CUST_ACCOUNT_ROLE_ID = p_cust_acct_role_id;
838:
839: l_cust_account_role_id HZ_CUST_ACCOUNT_ROLES.cust_account_role_id%TYPE;
840: p_cust_account_role_rec_type HZ_CUST_ACCOUNT_ROLE_V2PUB.cust_account_role_rec_type;
841: l_object_version_number HZ_CUST_ACCOUNT_ROLES.object_version_number%TYPE;
842: l_msg_count NUMBER;
843: l_msg_data VARCHAR2(2000);
844: l_return_status VARCHAR2(10);
845: l_procedure_name VARCHAR2(500) := '.RemoveRoleAccess';

Line 1915: FROM hz_cust_account_roles a

1911: l_status:='A';
1912: --Bug 4764121: Activating a inactive role
1913: SELECT 'Y',a.cust_account_role_id,status,a.object_version_number
1914: INTO l_already_exists,p_cust_acct_role_id,l_status,l_version_number
1915: FROM hz_cust_account_roles a
1916: WHERE party_id = p_party_id
1917: AND cust_account_id = l_customer_id
1918: AND ((cust_acct_site_id is null and l_cust_acct_site_id is null )
1919: OR cust_acct_site_id = l_cust_acct_site_id )

Line 2211: l_cust_acct_role_id HZ_CUST_ACCOUNT_ROLES.cust_account_role_id%type;

2207: p_person_party_id IN OUT NOCOPY VARCHAR2)
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);

Line 2265: l_cust_acct_role_id HZ_CUST_ACCOUNT_ROLES.cust_account_role_id%type;

2261: l_contact_preference_rec HZ_CONTACT_PREFERENCE_V2PUB.CONTACT_PREFERENCE_REC_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: