APPS.ARI_SELF_REGISTRATION_PKG dependencies on HZ_CUST_ACCOUNT_ROLES

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

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

Line 840: l_cust_account_role_id HZ_CUST_ACCOUNT_ROLES.cust_account_role_id%TYPE;

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

Line 842: l_object_version_number HZ_CUST_ACCOUNT_ROLES.object_version_number%TYPE;

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

Line 1764: FROM hz_cust_account_roles a

1760: l_status:='A';
1761: --Bug 4764121: Activating a inactive role
1762: SELECT 'Y',a.cust_account_role_id,status,a.object_version_number
1763: INTO l_already_exists,p_cust_acct_role_id,l_status,l_version_number
1764: FROM hz_cust_account_roles a
1765: WHERE party_id = p_party_id
1766: AND cust_account_id = l_customer_id
1767: AND ((cust_acct_site_id is null and l_cust_acct_site_id is null )
1768: OR cust_acct_site_id = l_cust_acct_site_id )

Line 2022: l_cust_acct_role_id HZ_CUST_ACCOUNT_ROLES.cust_account_role_id%type;

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

Line 2076: l_cust_acct_role_id HZ_CUST_ACCOUNT_ROLES.cust_account_role_id%type;

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