DBA Data[Home] [Help]

APPS.JTF_RS_IMPORT_USER_PUB dependencies on JTF_RS_UPLOAD_DATA

Line 5: * importing employee information stored in jtf_rs_upload_data table

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

Line 23: * jtf_rs_upload_data table for a transaction and tries to

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

Line 28: * jtf_rs_upload_data.

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 (

Line 39: * importing records from jtf_rs_upload_data table for a transaction,

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

Line 45: * jtf_rs_upload_data.

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

Line 57: P_TRANSACTION_NO IN JTF_RS_UPLOAD_DATA.TRANSACTION_NO%TYPE,

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

Line 66: * record in jtf_rs_upload_data table.

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

Line 68: * jtf_rs_upload_data.

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

Line 76: P_TRANSACTION_NO IN JTF_RS_UPLOAD_DATA.TRANSACTION_NO%TYPE,

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: );

Line 77: P_RECORD_NO IN JTF_RS_UPLOAD_DATA.RECORD_NO%TYPE,

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:

Line 78: P_PROCESS_STATUS IN JTF_RS_UPLOAD_DATA.PROCESS_STATUS%TYPE,

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;

Line 79: P_ERROR_TEXT IN JTF_RS_UPLOAD_DATA.ERROR_TEXT%TYPE

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;