1 PACKAGE ARI_SELF_REGISTRATION_PKG AUTHID CURRENT_USER AS
2 /* $Header: ARISREGS.pls 120.14.12020000.2 2012/07/22 13:31:30 rsinthre ship $ */
3
4 /*=======================================================================+
5 | Types
6 +=======================================================================*/
7
8 TYPE GenCursorRef IS REF CURSOR;
9
10 TYPE TokenRec IS RECORD (
11 token_name VARCHAR2(30),
12 token_value VARCHAR2(1000));
13
14 TYPE TokensTable IS TABLE OF TokenRec
15 INDEX BY BINARY_INTEGER;
16
17 TYPE VerifyAccessRec is RECORD
18 (
19 question VARCHAR2(2000),
20 expected_answer VARCHAR2(2000)
21 );
22
23 TYPE VerifyAccessTable IS TABLE OF VerifyAccessRec
24 INDEX BY BINARY_INTEGER;
25
26 TYPE QuestionsArray IS TABLE OF VARCHAR2(2000)
27 INDEX BY PLS_INTEGER;
28
29 TYPE AnswersArray IS TABLE OF VARCHAR2(2000)
30 INDEX BY PLS_INTEGER;
31
32 /*=======================================================================+
33 | Procedures and Functions
34 +=======================================================================*/
35 ---------------------------------------------------------------------------
36 PROCEDURE ResolveCustomerAccessRequest(p_customer_id IN VARCHAR2,
37 x_cust_acct_type OUT NOCOPY VARCHAR2,
38 x_result_code OUT NOCOPY NUMBER);
39 ---------------------------------------------------------------------------
40
41 ---------------------------------------------------------------------------
42 PROCEDURE InitiateHZUserCreation(p_registration_id IN NUMBER,
43 p_user_email_addr IN VARCHAR2,
44 p_cust_acct_type IN VARCHAR2,
45 p_company_id IN NUMBER DEFAULT NULL,
46 p_access_domain_id IN NUMBER,
47 p_access_domain_number IN VARCHAR2,
48 p_person_id IN NUMBER DEFAULT NULL,
49 p_first_name IN VARCHAR2 DEFAULT NULL,
50 p_family_name IN VARCHAR2 DEFAULT NULL,
51 p_job_title IN VARCHAR2 DEFAULT NULL,
52 p_phone_country_code IN VARCHAR2 DEFAULT NULL,
53 p_area_code IN VARCHAR2 DEFAULT NULL,
54 p_phone_number IN VARCHAR2 DEFAULT NULL,
55 p_extension IN VARCHAR2 DEFAULT NULL,
56 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
57 p_reg_service_code IN VARCHAR2 DEFAULT 'FND_RESP|AR|ARI_EXTERNAL|STAND',
58 p_identity_verification_reqd IN VARCHAR2 DEFAULT NULL,
59 p_requested_username IN VARCHAR2 DEFAULT NULL,
60 p_justification IN VARCHAR2 DEFAULT NULL,
61 p_req_start_date IN DATE DEFAULT SYSDATE,
62 p_req_end_date IN DATE DEFAULT NULL,
63 p_ame_application_id IN VARCHAR2 DEFAULT NULL,
64 p_ame_trx_type_id IN VARCHAR2 DEFAULT NULL,
65 x_return_status OUT NOCOPY VARCHAR2,
66 x_msg_count OUT NOCOPY NUMBER,
67 x_msg_data OUT NOCOPY VARCHAR2);
68 ---------------------------------------------------------------------------
69
70 --------------------------------------------------------------------------
71 PROCEDURE OpenCustAcctCur(p_customer_id IN VARCHAR2,
72 p_cust_acct_cur OUT NOCOPY GenCursorRef);
73 --------------------------------------------------------------------------
74
75 --------------------------------------------------------------------------
76 PROCEDURE GenerateAccessVerifyQuestion(
77 p_registration_id IN NUMBER,
78 p_client_ip_address IN VARCHAR2,
79 p_customer_id IN VARCHAR2,
80 p_customer_site_use_id IN VARCHAR2);
81
82 ---------------------------------------------------------------------------
83 PROCEDURE GenCustDetailAccessQuestion(
84 p_client_ip_address IN VARCHAR2,
85 p_customer_id IN VARCHAR2);
86 ---------------------------------------------------------------------------
87 PROCEDURE ClearRegistrationTable;
88 --------------------------------------------------------------------------
89 /*FUNCTION ValidateAnswer( p_answer IN VARCHAR2,
90 p_reg_access_verify_id IN NUMBER)
91 RETURN VARCHAR2;*/
92 --------------------------------------------------------------------------
93 PROCEDURE RemoveRoleAccess(p_person_party_id IN VARCHAR2,
94 p_customer_id IN VARCHAR2,
95 p_cust_acct_site_id IN VARCHAR2,
96 x_return_status OUT NOCOPY VARCHAR2);
97 --------------------------------------------------------------------------
98 FUNCTION GetPartyRelationshipId (p_user_id IN VARCHAR2,
99 p_customer_id IN VARCHAR2)
100 RETURN VARCHAR2;
101 --------------------------------------------------------------------------
102 FUNCTION GetCustomerAcctNumber (p_cust_account_id IN VARCHAR2)
103 RETURN VARCHAR2;
104 --------------------------------------------------------------------------
105 FUNCTION CheckUserIsAdmin (p_user_id IN VARCHAR2)
106 RETURN VARCHAR2;
107 --------------------------------------------------------------------------
108 FUNCTION CreatePersonParty(p_subscription_guid in raw,
109 p_event in out NOCOPY WF_EVENT_T) RETURN VARCHAR2;
110 --------------------------------------------------------------------------
111 FUNCTION AddCustomerAccess(p_subscription_guid in raw,
112 p_event in out NOCOPY WF_EVENT_T)
113 RETURN VARCHAR2;
114 --------------------------------------------------------------------------
115 FUNCTION UpdateRegistrationTable(p_subscription_guid in raw,
116 p_event in out NOCOPY WF_EVENT_T)
117 RETURN VARCHAR2;
118 --------------------------------------------------------------------------
119 PROCEDURE RegisterUser( p_event IN OUT NOCOPY WF_EVENT_T,
120 p_person_party_id IN OUT NOCOPY varchar2 );
121 --------------------------------------------------------------------------
122 PROCEDURE RaiseAddCustAccessEvent (p_person_party_id IN VARCHAR2,
123 p_customer_id IN VARCHAR2,
124 p_cust_site_use_id IN VARCHAR2 DEFAULT NULL,
125 p_cust_acct_type IN VARCHAR2,
126 p_first_name IN VARCHAR2,
127 p_last_name IN VARCHAR2,
128 p_middle_name IN VARCHAR2,
129 p_pre_name_adjunct IN VARCHAR2,
130 p_person_suffix IN VARCHAR2,
131 p_req_acc_no IN VARCHAR2,
132 p_req_location IN VARCHAR2,
133 p_req_cust_name IN VARCHAR2,
134 p_registration_id IN VARCHAR2,
135 p_responsibility_id IN NUMBER); --Added for Bug 13856182
136 --------------------------------------------------------------------------
137 FUNCTION GetRegSecurityProfile(p_user_id IN VARCHAR2 DEFAULT NULL,
138 p_resp_id IN VARCHAR2)
139 RETURN VARCHAR2;
140 --------------------------------------------------------------------------
141 FUNCTION UpdateRejectedStatus(p_subscription_guid in raw,
142 p_event in out NOCOPY WF_EVENT_T)
143 RETURN VARCHAR2;
144 --------------------------------------------------------------------------
145 PROCEDURE ValidateRequestedCustomer (p_customer_id IN VARCHAR2,
146 x_return_status OUT NOCOPY VARCHAR2);
147 --------------------------------------------------------------------------
148 FUNCTION GetRequestedRespId (p_role_name IN VARCHAR2)
149 RETURN VARCHAR2;
150 --------------------------------------------------------------------------
151 PROCEDURE CheckPastRegStatus(p_user_name IN VARCHAR2,
152 p_access_domain_search_number IN VARCHAR2,
153 p_access_domain_billto_id IN NUMBER,
154 p_access_domain_search_type IN VARCHAR2,
155 p_registration_id OUT NOCOPY NUMBER,
156 p_past_reg_status OUT NOCOPY VARCHAR2);
157 ----------------------------------------------------------------------------
158
159 PROCEDURE OpenRegistrationCur(p_cust_account_id IN VARCHAR2,
160 p_billto_id IN VARCHAR2,
161 p_user_name IN VARCHAR2,
162 p_application_code IN VARCHAR2,
163 p_mode IN VARCHAR2,
164 p_registration_cur OUT NOCOPY GenCursorRef);
165 --------------------------------------------------------------------------
166 PROCEDURE ReleaseRegHold(p_registration_id IN NUMBER,
167 p_reg_status_lookup_code OUT NOCOPY VARCHAR2);
168 ---------------------------------------------------------------------------
169 PROCEDURE LogRegistration(p_registration_id IN OUT NOCOPY NUMBER,
170 p_application_code IN VARCHAR2,
171 p_user_email_addr IN VARCHAR2,
172 p_access_domain_search_type IN VARCHAR2,
173 p_access_domain_search_number IN VARCHAR2,
174 p_access_domain_type IN VARCHAR2,
175 p_access_domain_cust_id IN NUMBER,
176 p_access_domain_billto_id IN NUMBER,
177 p_registration_type IN VARCHAR2);
178 ---------------------------------------------------------------------------
179 PROCEDURE OpenInvCustAcctCur(p_access_domain_search_number IN VARCHAR2,
180 p_inv_cust_acct_cur OUT NOCOPY GenCursorRef);
181 ---------------------------------------------------------------------------
182 PROCEDURE HoldRegistrationRequest(p_registration_id IN VARCHAR2,
183 p_status IN VARCHAR2);
184 ---------------------------------------------------------------------------
185 PROCEDURE IncrementMissedCount(p_registration_id IN VARCHAR2,
186 p_missed_cust_count IN VARCHAR2,
187 p_missed_billto_count IN VARCHAR2);
188 ---------------------------------------------------------------------------
189 PROCEDURE UpdateBilltoSite(p_registration_id IN VARCHAR2,
190 p_access_domain_billto_id IN VARCHAR2);
191 ---------------------------------------------------------------------------
192 PROCEDURE UpdateRequestAccess(p_registration_id IN VARCHAR2,
193 p_registration_type IN VARCHAR2,
194 p_registration_status IN VARCHAR2);
198 p_actid IN NUMBER,
195 ---------------------------------------------------------------------------
196 PROCEDURE Set_Application_Login_Url(p_itemtype IN VARCHAR2,
197 p_itemkey IN VARCHAR2,
199 p_funcmode IN VARCHAR2,
200 p_result IN OUT NOCOPY VARCHAR2);
201 ---------------------------------------------------------------------------
202 PROCEDURE UpdateApprovalStatus(p_itemtype IN VARCHAR2,
203 p_itemkey IN VARCHAR2,
204 p_actid IN NUMBER,
205 p_funcmode IN VARCHAR2,
206 p_result IN OUT NOCOPY VARCHAR2);
207 ---------------------------------------------------------------------------
208 PROCEDURE UpdateRejectStatus(p_itemtype IN VARCHAR2,
209 p_itemkey IN VARCHAR2,
210 p_actid IN NUMBER,
211 p_funcmode IN VARCHAR2,
212 p_result IN OUT NOCOPY VARCHAR2);
213 ---------------------------------------------------------------------------
214 END ARI_SELF_REGISTRATION_PKG;