1 PACKAGE jtf_rs_interface_pvt AUTHID CURRENT_USER AS
2 /* $Header: jtfrsvxs.pls 120.0.12010000.3 2009/06/04 22:20:05 nsinghai noship $ */
3 /*#
4 * Import Resource and SalesRep from Interface API
5 * This API contains the procedures to Import (create, update) Resource & SalesRep records.
6 * @rep:scope internal
7 * @rep:product JTF
8 * @rep:displayname Resource and Salesrep Interface API
9 * @rep:category BUSINESS_ENTITY JTF_RS_RESOURCE
10 * @rep:businessevent oracle.apps.jtf.jres.resource.create
11 * @rep:businessevent oracle.apps.jtf.jres.resource.update.user
12 * @rep:businessevent oracle.apps.jtf.jres.resource.update.effectivedate
13 * @rep:businessevent oracle.apps.jtf.jres.resource.update.attributes
14 */
15 /**********************************************************************************************
16 This is a private API.
17 It provides procedures for Import (create,update) resources and SalesRep from Interface tables.
18 Its main procedures are as following:
19 Import Resource
20 Import Salesreps
21 Calls to these procedures will invoke procedures from EBSI
22 to do business validations and to do actual creates and updates into tables.
23 ******************************************************************************************/
24
25 /*#
26 * Import Resource API
27 * This procedure allows the user to Import a resource record from Interface Table JTF_RS_RESOURCE_EXTNS_INT.
28 * @param p_batch_id Batch Identifier.
29 * @param x_return_status Output parameter for return status
30 * @param x_msg_count Output parameter for number of user messages from this procedure
31 * @param x_msg_data Output parameter containing last user message from this procedure
32 * @rep:scope internal
33 * @rep:lifecycle active
34 * @rep:displayname Import Resource API
35 */
36 PROCEDURE import_resource
37 (P_BATCH_ID IN NUMBER,
38 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
39 X_MSG_COUNT OUT NOCOPY NUMBER,
40 X_MSG_DATA OUT NOCOPY VARCHAR2
41 );
42
43 /*#
44 * Import Salesreps API
45 * This procedure allows the user to Import a Sales Rep record from Interface Table JTF_RS_SALESREPS_INT.
46 * @param p_batch_id Batch Identifier.
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 internal
51 * @rep:lifecycle active
52 * @rep:displayname Import Salesreps API
53 */
54 PROCEDURE import_salesreps
55 (P_BATCH_ID IN NUMBER,
56 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
57 X_MSG_COUNT OUT NOCOPY NUMBER,
58 X_MSG_DATA OUT NOCOPY VARCHAR2
59 );
60
61
62 END jtf_rs_interface_pvt;