[Home] [Help]
PACKAGE: APPS.UMX_REGISTRATION_PVT
Source
1 PACKAGE UMX_REGISTRATION_PVT AUTHID CURRENT_USER AS
2 /* $Header: UMXVREGS.pls 120.1.12010000.2 2009/07/22 19:08:48 jstyles ship $ */
3
4 TYPE UMX_REGISTRATION_DATA IS RECORD (ATTR_NAME VARCHAR2(30), ATTR_VALUE VARCHAR2(2000));
5
6 TYPE UMX_REGISTRATION_DATA_TBL IS TABLE OF UMX_REGISTRATION_DATA INDEX BY BINARY_INTEGER;
7
8 G_REG_SERVICE_CODE constant varchar2(30) := 'reg_service_code';
9 G_REG_SERVICE_TYPE constant varchar2(30) := 'reg_service_type';
10 G_REG_SERVICE_DESCRIPTION constant varchar2(30) := 'regsvc_descrirption';
11 G_REG_SERVICE_APP_ID constant varchar2(30) := 'application_id';
12 G_REG_FUNCTION_NAME constant varchar2(30) := 'reg_function_name';
13 G_REG_SERVICE_DISP_NAME constant varchar2(30) := 'regsvc_disp_name';
14 G_REG_REQUEST_ID constant varchar2(30) := 'reg_request_id';
15 G_REG_REQUEST_STATUS constant varchar2(30) := 'status_code';
16 G_IDENTITY_VERIFY_REQD constant varchar2(30) := 'identity_verification_reqd';
17 G_REQUESTED_FOR_USER_ID constant varchar2(30) := 'requested_for_user_id';
18 G_REQUESTED_BY_USER_ID constant varchar2(30) := 'requested_by_user_id';
19 G_REQUESTED_USERNAME constant varchar2(30) := 'requested_username';
20 G_JUSTIFICATION constant varchar2(30) := 'justification';
21 G_REQUESTED_START_DATE constant varchar2(30) := 'requested_start_date';
22 G_REQUESTED_END_DATE constant varchar2(30) := 'requested_end_date';
23 G_WF_NOTIFICATION_EVENT constant varchar2(30) := 'wf_notification_event';
24 G_WF_ROLE_NAME constant varchar2(30) := 'wf_role_name';
25 G_AME_APPLICATION_ID constant varchar2(30) := 'ame_application_id';
26 G_AME_TXN_TYPE_ID constant varchar2(30) := 'ame_transaction_type_id';
27 G_REQUESTED_FOR_PARTY_ID constant varchar2(30) := 'person_party_id';
28 G_WF_BUS_LOGIC_EVENT constant varchar2(30) := 'custom_event_name';
29
30 /** Procedure : UMX_PROCESS_REG_REQUEST
31 * Type : Private
32 * Pre_reqs : None
33 * Description : Invokes Workflow process after registration flow
34 * This API will return an error if the size of the
35 * that WF can accept to raise an event
36 * Parameters :
37 * input parameters
38 * @param p_registration_data
39 * description: This is of type UMX_REGISTRATION_PVT.UMX_REGISTRATION_DATA
40 * required : Y
41 * validation : None
42 */
43 procedure UMX_PROCESS_REG_REQUEST (p_registration_data IN OUT NOCOPY UMX_REGISTRATION_DATA_TBL,
44 x_return_status out NOCOPY varchar2,
45 x_message_data out NOCOPY varchar2);
46
47 function format_address_lov(p_party_id number) return varchar2;
48
49 procedure POPULATE_REG_DATA(p_registration_data IN OUT NOCOPY UMX_REGISTRATION_DATA_TBL);
50
51 --
52 -- Procedure : assign_role
53 -- Type : Private
54 -- Pre_reqs : None
55 -- Description : This API will assign or launch wf to assign role.
56 -- Input Parameters (Mandatory):
57 -- p_registration_data : Table of record type of UMX_REGISTRATION_DATA
58 -- Output Parameters:
59 -- p_registration_data : Table of record type of UMX_REGISTRATION_DATA
60 --
61 procedure assign_role (p_registration_data in out NOCOPY UMX_REGISTRATION_DATA_TBL,
62 x_return_status out NOCOPY varchar2,
63 x_message_data out NOCOPY varchar2);
64
65 /**
66 * Function : GET_PHONE_NUMBER
67 * Type : Private
68 * Description : Retrieve phone number
69 * Parameters :
70 * input parameters
71 * @param
72 * p_person_id
73 * description: Person Id of the person
74 * required : Y
75 * validation : Must be a valid person_id
76 * default : null
77 * output parameters
78 * @return : Phone Number of the person
79 * Errors : possible errors raised by this API
80 * Other Comments :
81 */
82 function GET_PHONE_NUMBER(p_person_id in per_all_people_f.person_id%type) return varchar2;
83 /**
84 * Function : GET_PERSON_ID
85 * Type : Private
86 * Description : Retrieve person_id from party_id
87 * Parameters :
88 * input parameters
89 * @param
90 * p_party_id
91 * description: Party Id of the person
92 * required : Y
93 * validation : Must be a valid party_id
94 * default : null
95 * output parameters
96 * @return : Person Id of the user
97 * Errors : possible errors raised by this API
98 * Other Comments :
99 */
100 function GET_PERSON_ID (p_party_id in hz_parties.party_id%type) return number;
101 /**
102 * Function : GET_MANAGER_NAME
103 * Type : Private
104 * Description : Find Manager's Name
105 * Parameters :
106 * input parameters
107 * @param
108 * p_person_id
109 * description: Person Id of the person
110 * required : Y
111 * validation : Must be a valid person_id
112 * default : null
113 * output parameters
114 * @return : Name of the manager of the person
115 * Errors : possible errors raised by this API
116 * Other Comments :
117 */
118 function GET_MANAGER_NAME(p_person_id in per_all_people_f.person_id%type) return varchar2;
119
120 /**
121 * Function : GET_JOB_TITLE
122 * Type : Private
123 * Description : Find Job Title
124 * Parameters :
125 * input parameters
126 * @param
127 * p_person_id
128 * description: Person Id of the person
129 * required : Y
130 * validation : Must be a valid person_id
131 * default : null
132 * output parameters
133 * @return : Job Title
134 * Errors : possible errors raised by this API
135 * Other Comments :
136 */
137 function GET_JOB_TITLE(p_person_id in per_all_people_f.person_id%type) return varchar2;
138
139 end UMX_REGISTRATION_PVT;