DBA Data[Home] [Help]

PACKAGE: APPS.JTF_RS_INTERFACE_PVT

Source


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;