1 PACKAGE jtf_rs_import_user_pub AUTHID CURRENT_USER AS
2 /* $Header: jtfrsius.pls 115.5 2004/06/25 18:15:47 baianand ship $ */
3 /*#
4 * This package contains procedures to create resources by
5 * importing employee information stored in jtf_rs_upload_data table
6 * @rep:scope private
7 * @rep:product JTF
8 * @rep:displayname Import Users Package
9 * @rep:category BUSINESS_ENTITY JTF_RS_RESOURCE
10 * @rep:category BUSINESS_ENTITY JTF_RS_GROUP_MEMBER
11 */
12
13
14 /*****************************************************************************************
15 ******************************************************************************************/
16
17 /* Package variables. */
18
19 G_PKG_NAME VARCHAR2(30) := 'JTF_RS_IMPORT_USER_PUB';
20
21 /*#
22 * This procedure imports in bulk. It takes all records from
23 * jtf_rs_upload_data table for a transaction and tries to
24 * import them into resources.
25 * @param ERRBUF output parameter containg errors
26 * @param RETCODE output parameter containing return status
27 * @param P_TRANSACTION_NO Transation number indicating the unique batch data in
28 * jtf_rs_upload_data.
29 * @rep:scope private
30 * @rep:displayname Import Users
31 */
32 PROCEDURE crt_bulk_import (
33 ERRBUF OUT NOCOPY VARCHAR2,
34 RETCODE OUT NOCOPY VARCHAR2,
35 P_TRANSACTION_NO IN NUMBER);
36
37 /*#
38 * This procedure starts concurrent request for
39 * importing records from jtf_rs_upload_data table for a transaction,
40 * into resources.
41 * @param P_API_VERSION API version number
42 * @param P_INIT_MSG_LIST Flag to start with clearing messages from database
43 * @param P_COMMIT Flag to commit at the end of the procedure
44 * @param P_TRANSACTION_NO Transation number indicating the unique batch data in
45 * jtf_rs_upload_data.
46 * @param P_REQUEST_NO Output parameter for concurrent request number
47 * @param X_RETURN_STATUS Output parameter for return status
48 * @param X_MSG_COUNT Output parameter for number of user messages from this procedure
49 * @param X_MSG_DATA Output parameter containing last user message from this procedure
50 * @rep:scope private
51 * @rep:displayname Start Import User Concurrent Request
52 */
53 PROCEDURE import_user
54 (P_API_VERSION IN NUMBER,
55 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
56 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
57 P_TRANSACTION_NO IN JTF_RS_UPLOAD_DATA.TRANSACTION_NO%TYPE,
58 P_REQUEST_NO OUT NOCOPY NUMBER,
59 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
60 X_MSG_COUNT OUT NOCOPY NUMBER,
61 X_MSG_DATA OUT NOCOPY VARCHAR2
62 );
63
64 /*#
65 * Procedure to update the import status and error information for a
66 * record in jtf_rs_upload_data table.
67 * @param P_TRANSACTION_NO Transation number indicating the unique batch data in
68 * jtf_rs_upload_data.
69 * @param P_RECORD_NO Record Number to identify a specific record for a P_TRANSACTION_NO
70 * @param P_PROCESS_STATUS Status of upload - S -success, U -Unsuccessful, W -Warning
71 * @param P_ERROR_TEXT Error text in case status is U or W
72 * @rep:scope private
73 * @rep:displayname Update Upload Data
74 */
75 PROCEDURE update_upload_data (
76 P_TRANSACTION_NO IN JTF_RS_UPLOAD_DATA.TRANSACTION_NO%TYPE,
77 P_RECORD_NO IN JTF_RS_UPLOAD_DATA.RECORD_NO%TYPE,
78 P_PROCESS_STATUS IN JTF_RS_UPLOAD_DATA.PROCESS_STATUS%TYPE,
79 P_ERROR_TEXT IN JTF_RS_UPLOAD_DATA.ERROR_TEXT%TYPE
80 );
81
82 END jtf_rs_import_user_pub;