[Home] [Help]
PACKAGE: APPS.UMX_REGISTRATION_PVT
Source
1 PACKAGE UMX_REGISTRATION_PVT AS
2 /* $Header: UMXVREGS.pls 120.1 2005/07/02 04:25:25 appldev noship $ */
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
45 function format_address_lov(p_party_id number) return varchar2;
46
47 procedure POPULATE_REG_DATA(p_registration_data IN OUT NOCOPY UMX_REGISTRATION_DATA_TBL);
48
49 --
50 -- Procedure : assign_role
51 -- Type : Private
52 -- Pre_reqs : None
53 -- Description : This API will assign or launch wf to assign role.
54 -- Input Parameters (Mandatory):
55 -- p_registration_data : Table of record type of UMX_REGISTRATION_DATA
56 -- Output Parameters:
57 -- p_registration_data : Table of record type of UMX_REGISTRATION_DATA
58 --
59 procedure assign_role (p_registration_data in out NOCOPY UMX_REGISTRATION_DATA_TBL);
60
61 /**
62 * Function : GET_PHONE_NUMBER
63 * Type : Private
64 * Description : Retrieve phone number
65 * Parameters :
66 * input parameters
67 * @param
68 * p_person_id
69 * description: Person Id of the person
70 * required : Y
71 * validation : Must be a valid person_id
72 * default : null
73 * output parameters
74 * @return : Phone Number of the person
75 * Errors : possible errors raised by this API
76 * Other Comments :
77 */
78 function GET_PHONE_NUMBER(p_person_id in per_all_people_f.person_id%type) return varchar2;
79 /**
80 * Function : GET_PERSON_ID
81 * Type : Private
82 * Description : Retrieve person_id from party_id
83 * Parameters :
84 * input parameters
85 * @param
86 * p_party_id
87 * description: Party Id of the person
88 * required : Y
89 * validation : Must be a valid party_id
90 * default : null
91 * output parameters
92 * @return : Person Id of the user
93 * Errors : possible errors raised by this API
94 * Other Comments :
95 */
96 function GET_PERSON_ID (p_party_id in hz_parties.party_id%type) return number;
97 /**
98 * Function : GET_MANAGER_NAME
99 * Type : Private
100 * Description : Find Manager's Name
101 * Parameters :
102 * input parameters
103 * @param
104 * p_person_id
105 * description: Person Id of the person
106 * required : Y
107 * validation : Must be a valid person_id
108 * default : null
109 * output parameters
110 * @return : Name of the manager of the person
111 * Errors : possible errors raised by this API
112 * Other Comments :
113 */
114 function GET_MANAGER_NAME(p_person_id in per_all_people_f.person_id%type) return varchar2;
115
116 /**
117 * Function : GET_JOB_TITLE
118 * Type : Private
119 * Description : Find Job Title
120 * Parameters :
121 * input parameters
122 * @param
123 * p_person_id
124 * description: Person Id of the person
125 * required : Y
126 * validation : Must be a valid person_id
127 * default : null
128 * output parameters
129 * @return : Job Title
130 * Errors : possible errors raised by this API
131 * Other Comments :
132 */
133 function GET_JOB_TITLE(p_person_id in per_all_people_f.person_id%type) return varchar2;
134
135 end UMX_REGISTRATION_PVT;