1 PACKAGE ARI_SELF_REGISTRATION_PKG AS
2 /* $Header: ARISREGS.pls 120.11 2005/12/05 10:56:43 vgundlap noship $ */
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 currency_code VARCHAR2(15)
22 );
23
24 TYPE VerifyAccessTable IS TABLE OF VerifyAccessRec
25 INDEX BY BINARY_INTEGER;
26
27 TYPE QuestionsArray IS TABLE OF VARCHAR2(2000)
28 INDEX BY PLS_INTEGER;
29
30 TYPE AnswersArray IS TABLE OF VARCHAR2(2000)
31 INDEX BY PLS_INTEGER;
32
33 /*=======================================================================+
34 | Procedures and Functions
35 +=======================================================================*/
36 ---------------------------------------------------------------------------
37 PROCEDURE ResolveCustomerAccessRequest(p_customer_id IN VARCHAR2,
38 x_cust_acct_type OUT NOCOPY VARCHAR2,
39 x_result_code OUT NOCOPY NUMBER);
40 ---------------------------------------------------------------------------
41
42 ---------------------------------------------------------------------------
43 PROCEDURE InitiateHZUserCreation(p_registration_id IN NUMBER,
44 p_user_email_addr IN VARCHAR2,
45 p_cust_acct_type IN VARCHAR2,
46 p_company_id IN NUMBER DEFAULT NULL,
47 p_access_domain_id IN NUMBER,
48 p_access_domain_number IN VARCHAR2,
49 p_person_id IN NUMBER DEFAULT NULL,
50 p_first_name IN VARCHAR2 DEFAULT NULL,
51 p_family_name IN VARCHAR2 DEFAULT NULL,
52 p_job_title IN VARCHAR2 DEFAULT NULL,
53 p_phone_country_code IN VARCHAR2 DEFAULT NULL,
54 p_area_code IN VARCHAR2 DEFAULT NULL,
55 p_phone_number IN VARCHAR2 DEFAULT NULL,
56 p_extension IN VARCHAR2 DEFAULT NULL,
57 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
58 p_reg_service_code IN VARCHAR2 DEFAULT 'FND_RESP|AR|ARI_EXTERNAL|STAND',
59 p_identity_verification_reqd IN VARCHAR2 DEFAULT NULL,
60 p_requested_username IN VARCHAR2 DEFAULT NULL,
61 p_justification IN VARCHAR2 DEFAULT NULL,
62 p_req_start_date IN DATE DEFAULT SYSDATE,
63 p_req_end_date IN DATE DEFAULT NULL,
64 p_ame_application_id IN VARCHAR2 DEFAULT NULL,
65 p_ame_trx_type_id IN VARCHAR2 DEFAULT NULL,
66 x_return_status OUT NOCOPY VARCHAR2,
67 x_msg_count OUT NOCOPY NUMBER,
68 x_msg_data OUT NOCOPY VARCHAR2);
69 ---------------------------------------------------------------------------
70
71 --------------------------------------------------------------------------
72 PROCEDURE OpenCustAcctCur(p_customer_id IN VARCHAR2,
73 p_cust_acct_cur OUT NOCOPY GenCursorRef);
74 --------------------------------------------------------------------------
75
76 --------------------------------------------------------------------------
77 PROCEDURE GenerateAccessVerifyQuestion(
78 p_registration_id IN NUMBER,
79 p_client_ip_address IN VARCHAR2,
80 p_customer_id IN VARCHAR2,
81 p_customer_site_use_id IN VARCHAR2);
82
83 ---------------------------------------------------------------------------
84 PROCEDURE GenCustDetailAccessQuestion(
85 p_client_ip_address IN VARCHAR2,
86 p_customer_id IN VARCHAR2);
87 ---------------------------------------------------------------------------
88 PROCEDURE ClearRegistrationTable;
89 --------------------------------------------------------------------------
90 /*FUNCTION ValidateAnswer( p_answer IN VARCHAR2,
91 p_reg_access_verify_id IN NUMBER)
92 RETURN VARCHAR2;*/
93 --------------------------------------------------------------------------
94 PROCEDURE RemoveRoleAccess(p_person_party_id IN VARCHAR2,
95 p_customer_id IN VARCHAR2,
96 p_cust_acct_site_id IN VARCHAR2,
97 x_return_status OUT NOCOPY VARCHAR2);
98 --------------------------------------------------------------------------
99 FUNCTION GetPartyRelationshipId (p_user_id IN VARCHAR2,
100 p_customer_id IN VARCHAR2)
101 RETURN VARCHAR2;
102 --------------------------------------------------------------------------
103 FUNCTION GetCustomerAcctNumber (p_cust_account_id IN VARCHAR2)
104 RETURN VARCHAR2;
105 --------------------------------------------------------------------------
106 FUNCTION CheckUserIsAdmin (p_user_id IN VARCHAR2)
107 RETURN VARCHAR2;
108 --------------------------------------------------------------------------
109 FUNCTION CreatePersonParty(p_subscription_guid in raw,
110 p_event in out NOCOPY WF_EVENT_T) RETURN VARCHAR2;
111 --------------------------------------------------------------------------
112 FUNCTION AddCustomerAccess(p_subscription_guid in raw,
113 p_event in out NOCOPY WF_EVENT_T)
114 RETURN VARCHAR2;
115 --------------------------------------------------------------------------
116 PROCEDURE RegisterUser( p_event IN OUT NOCOPY WF_EVENT_T,
117 p_person_party_id IN OUT NOCOPY varchar2 );
118 --------------------------------------------------------------------------
119 PROCEDURE RaiseAddCustAccessEvent (p_person_party_id IN VARCHAR2,
120 p_customer_id IN VARCHAR2,
121 p_cust_site_use_id IN VARCHAR2 DEFAULT NULL,
122 p_cust_acct_type IN VARCHAR2,
123 p_first_name IN VARCHAR2,
124 p_last_name IN VARCHAR2,
125 p_middle_name IN VARCHAR2,
126 p_pre_name_adjunct IN VARCHAR2,
127 p_person_suffix IN VARCHAR2);
128 --------------------------------------------------------------------------
129 FUNCTION GetRegSecurityProfile(p_user_id IN VARCHAR2 DEFAULT NULL,
130 p_resp_id IN VARCHAR2)
131 RETURN VARCHAR2;
132 --------------------------------------------------------------------------
133 PROCEDURE ValidateRequestedCustomer (p_customer_id IN VARCHAR2,
134 x_return_status OUT NOCOPY VARCHAR2);
135 --------------------------------------------------------------------------
136 FUNCTION GetRequestedRespId (p_role_name IN VARCHAR2)
137 RETURN VARCHAR2;
138 --------------------------------------------------------------------------
139 END ARI_SELF_REGISTRATION_PKG;