1 PACKAGE jtf_rs_res_sswa_pub AS
2 /* $Header: jtfrssrs.pls 120.0 2005/05/11 08:22:00 appldev ship $ */
3 /*#
4 * Employee Resource create/update API
5 * This API contains the procedures to insert and update Employee Resource record.
6 * This procedure will insert/update Employee records in HR,
7 * insert/update Employee Resources JTF Resources and
8 * insert FND User Record if the User name is not null.
9 * @rep:scope private
10 * @rep:product JTF
11 * @rep:displayname Employee Resource API
12 * @rep:category BUSINESS_ENTITY JTF_RS_RESOURCE
13 */
14
15 /*****************************************************************************************
16 ******************************************************************************************/
17
18 /* Procedure to create the Employee Resource
19 based on input values passed by calling routines. */
20 /*#
21 * Create Employee Resource API
22 * This procedure will insert Employee records in HR,
23 * insert Employee Resources JTF Resources and
24 * insert FND User Record if the User name is not null.
25 * @param p_api_version API version
26 * @param p_init_msg_list Initialization of the message list
27 * @param p_commit Commit
28 * @param p_source_first_name Source First Name
29 * @param p_source_last_name Source Last Name
30 * @param p_source_middle_name Source Middle Name
31 * @param p_employee_number Employee Number
32 * @param p_source_sex Source Sex
33 * @param p_source_title Source title
34 * @param p_source_job_id Source job Identifier
35 * @param p_source_email Source Email
36 * @param p_source_start_date Start date of the Employee
37 * @param p_source_end_date End date of the Employee
38 * @param p_user_name User Name
39 * @param p_source_address_id Source Address Identifier
40 * @param p_source_office Source Office
41 * @param p_source_mailstop Source Mailstop
42 * @param p_source_location Source Location
43 * @param p_source_phone Source Phone
44 * @param p_salesrep_number Salesperson Number
45 * @param p_sales_credit_type_id Sales Credit Identifier
46 * @param p_source_mgr_id Source manager Identifier
47 * @param p_called_from Where this procedure is called
48 * @param p_user_password Password of the User
49 * @param x_return_status Output parameter for return status
50 * @param x_msg_count Output parameter for number of user messages from this procedure
51 * @param x_msg_data Output parameter containing last user message from this procedure
52 * @param x_resource_id Out parameter for resource Identifier
53 * @rep:scope private
54 * @rep:lifecycle active
55 * @rep:displayname Create Employee Resource API
56 */
57 PROCEDURE create_emp_resource
58 (P_API_VERSION IN NUMBER,
59 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
60 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
61 P_SOURCE_FIRST_NAME IN VARCHAR2 DEFAULT NULL,
62 P_SOURCE_LAST_NAME IN VARCHAR2,
63 P_SOURCE_MIDDLE_NAME IN VARCHAR2 DEFAULT NULL,
64 P_EMPLOYEE_NUMBER IN VARCHAR2 DEFAULT NULL,
65 P_SOURCE_SEX IN VARCHAR2,
66 P_SOURCE_TITLE IN VARCHAR2 DEFAULT NULL,
67 P_SOURCE_JOB_ID IN NUMBER DEFAULT NULL,
68 P_SOURCE_EMAIL IN VARCHAR2 DEFAULT NULL,
69 P_SOURCE_START_DATE IN DATE,
70 P_SOURCE_END_DATE IN DATE DEFAULT NULL,
71 P_USER_NAME IN VARCHAR2,
72 P_SOURCE_ADDRESS_ID IN NUMBER DEFAULT NULL,
73 P_SOURCE_OFFICE IN VARCHAR2 DEFAULT NULL,
74 P_SOURCE_MAILSTOP IN VARCHAR2 DEFAULT NULL,
75 P_SOURCE_LOCATION IN VARCHAR2 DEFAULT NULL,
76 P_SOURCE_PHONE IN VARCHAR2 DEFAULT NULL,
77 P_SALESREP_NUMBER IN VARCHAR2,
78 P_SALES_CREDIT_TYPE_ID IN NUMBER,
79 P_SOURCE_MGR_ID IN NUMBER DEFAULT NULL,
80 X_RESOURCE_ID OUT NOCOPY NUMBER,
81 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
82 X_MSG_COUNT OUT NOCOPY NUMBER,
83 X_MSG_DATA OUT NOCOPY VARCHAR2,
84 P_CALLED_FROM IN VARCHAR2 DEFAULT NULL,
85 P_USER_PASSWORD IN OUT NOCOPY VARCHAR2
86 );
87
88
89 /* Procedure to create the resource group and the members
90 based on input values passed by calling routines. */
91
92 /*#
93 * Update Employee Resource API
94 * This procedure will update Employee records in HR and update Employee Resources JTF Resources
95 * @param p_api_version API version
96 * @param p_init_msg_list Initialization of the message list
97 * @param p_commit Commit
98 * @param p_resource_id Resource Identifier
99 * @param p_resource_number Resource Number
100 * @param p_resource_name Resource Name
101 * @param p_source_name Source Name
102 * @param p_address_id Address Identifier
103 * @param p_source_office Source Office
104 * @param p_source_mailstop Source Mailstop
105 * @param p_source_location Source Location
106 * @param p_source_phone Source Phone
107 * @param p_source_email Source Email
108 * @param p_object_version_number The object version number of the resource derives from the jtf_rs_resource_extns table.
109 * @param p_approved Approval required or not
110 * @param p_source_job_id Source job Identifier
111 * @param p_source_job_title Source job Title
112 * @param p_salesrep_number Salesperson Number
113 * @param p_sales_credit_type_id Sales Credit Identifier
114 * @param p_end_date_active Date on which the resource is no longer active.
115 * @param p_user_id User Identifier
116 * @param p_user_name User Name
117 * @param p_mgr_resource_id Resource Identifier for the manager of the resource
118 * @param p_org_id Organization Identifier
119 * @param p_time_zone Time zone, this value must be a valid time zone as defined in table HZ_TIMEZONES.
120 * @param p_cost_per_hr The salary cost per hour for this resource. This value is used in conjunction with the p_comp_currency_code parameter.
121 * @param p_primary_language The resource's primary language. This value must be a valid NLS language as defined in table FND_LANGUAGES
122 * @param p_secondary_language The resource's secondary language. This value must be a valid NLS language as defined in table FND_LANGUAGES
123 * @param p_support_site_id Value used by the Service applications.
124 * @param p_source_mobile_phone Source Mobile Phone
125 * @param p_source_pager Source Pager
126 * @param x_return_status Output parameter for return status
127 * @param x_msg_count Output parameter for number of user messages from this procedure
128 * @param x_msg_data Output parameter containing last user message from this procedure
129 * @rep:scope private
130 * @rep:lifecycle active
131 * @rep:displayname Update Employee Resource API
132 */
133 PROCEDURE update_resource
134 (P_API_VERSION IN NUMBER,
135 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
136 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
137 P_RESOURCE_ID IN NUMBER,
138 P_RESOURCE_NUMBER IN VARCHAR2,
139 P_RESOURCE_NAME IN VARCHAR2 ,
140 P_SOURCE_NAME IN VARCHAR2 ,
141 P_ADDRESS_ID IN VARCHAR2 ,
142 P_SOURCE_OFFICE IN VARCHAR2 ,
143 P_SOURCE_MAILSTOP IN VARCHAR2 ,
144 P_SOURCE_LOCATION IN VARCHAR2 ,
145 P_SOURCE_PHONE IN VARCHAR2 ,
146 P_SOURCE_EMAIL IN VARCHAR2 ,
147 P_OBJECT_VERSION_NUMBER IN NUMBER,
148 P_APPROVED IN VARCHAR2 DEFAULT 'N',
149 P_SOURCE_JOB_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
150 P_SOURCE_JOB_TITLE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
151 P_SALESREP_NUMBER IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
152 P_SALES_CREDIT_TYPE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
153 P_END_DATE_ACTIVE IN DATE DEFAULT FND_API.G_MISS_DATE,
154 P_USER_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
155 P_USER_NAME IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
156 P_MGR_RESOURCE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
157 P_ORG_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
158 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
159 X_MSG_COUNT OUT NOCOPY NUMBER,
160 X_MSG_DATA OUT NOCOPY VARCHAR2,
161 P_TIME_ZONE IN NUMBER DEFAULT FND_API.G_MISS_NUM,
162 P_COST_PER_HR IN NUMBER DEFAULT FND_API.G_MISS_NUM,
163 P_PRIMARY_LANGUAGE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
164 P_SECONDARY_LANGUAGE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
165 P_SUPPORT_SITE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
166 P_SOURCE_MOBILE_PHONE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
167 P_SOURCE_PAGER IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
168 ) ;
169
170 END jtf_rs_res_sswa_pub;