1 PACKAGE jtf_rs_team_usages_pub AUTHID CURRENT_USER AS
2 /* $Header: jtfrspjs.pls 120.0 2005/05/11 08:21:13 appldev ship $ */
3 /*#
4 * Package containing procedures to maintain team usages
5 * @rep:scope internal
6 * @rep:product JTF
7 * @rep:displayname Taem Usages Package
8 * @rep:category BUSINESS_ENTITY JTF_RS_TEAM_USAGE
9 */
10
11
12 /*****************************************************************************************
13 This is a public API that caller will invoke.
14 It provides PROCEDUREs for managing resource team usages.
15 Its main PROCEDUREs are as following:
16 Create Resource Team Usage
17 Delete Resource Team Usage
18 Calls to these PROCEDUREs will invoke PROCEDUREs from jtf_rs_team_usages_pvt
19 to do business validations and to do actual inserts and updates into tables.
20 ******************************************************************************************/
21
22
23 /* PROCEDURE to create the resource team usage
24 based on input values passed by calling routines. */
25
26 /*#
27 * Procedure to Create Team Usage
28 * @param P_API_VERSION API version number
29 * @param P_INIT_MSG_LIST Flag to start with clearing messages from database
30 * @param P_COMMIT Flag to commit at the end of the procedure
31 * @param P_TEAM_ID Team's unique internal ID
32 * @param P_TEAM_NUMBER Team Number
33 * @param P_USAGE Usage code
34 * @param X_RETURN_STATUS Output parameter for return status
35 * @param X_MSG_COUNT Output parameter for number of user messages from this procedure
36 * @param X_MSG_DATA Output parameter containing last user message from this procedure
37 * @param X_TEAM_USAGE_ID Output parameter containing unique internal ID of newly created team usage record
38 * @rep:scope internal
39 * @rep:displayname Create Team Usage
40 */
41 PROCEDURE create_team_usage
42 (P_API_VERSION IN NUMBER,
43 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
44 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
45 P_TEAM_ID IN JTF_RS_TEAM_USAGES.TEAM_ID%TYPE,
46 P_TEAM_NUMBER IN JTF_RS_TEAMS_VL.TEAM_NUMBER%TYPE,
47 P_USAGE IN JTF_RS_TEAM_USAGES.USAGE%TYPE,
48 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
49 X_MSG_COUNT OUT NOCOPY NUMBER,
50 X_MSG_DATA OUT NOCOPY VARCHAR2,
51 X_TEAM_USAGE_ID OUT NOCOPY JTF_RS_TEAM_USAGES.TEAM_USAGE_ID%TYPE
52 );
53
54
55
56 /* PROCEDURE to delete the resource team usage
57 based on input values passed by calling routines. */
58
59 /*#
60 * Procedure to delete a team usage
61 * @param P_API_VERSION API version number
62 * @param P_INIT_MSG_LIST Flag to start with clearing messages from database
63 * @param P_COMMIT Flag to commit at the end of the procedure
64 * @param P_TEAM_ID Team's unique internal ID
65 * @param P_TEAM_NUMBER Team Number
66 * @param P_USAGE Usage code
67 * @param P_OBJECT_VERSION_NUM Object Version Number for the record to delete
68 * @param X_RETURN_STATUS Output parameter for return status
69 * @param X_MSG_COUNT Output parameter for number of user messages from this procedure
70 * @param X_MSG_DATA Output parameter containing last user message from this procedure
71 * @rep:scope internal
72 * @rep:displayname Delete Team Usage
73 */
74 PROCEDURE delete_team_usage
75 (P_API_VERSION IN NUMBER,
76 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
77 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
78 P_TEAM_ID IN JTF_RS_TEAM_USAGES.TEAM_ID%TYPE,
79 P_TEAM_NUMBER IN JTF_RS_TEAMS_VL.TEAM_NUMBER%TYPE,
80 P_USAGE IN JTF_RS_TEAM_USAGES.USAGE%TYPE,
81 P_OBJECT_VERSION_NUM IN JTF_RS_TEAM_USAGES.OBJECT_VERSION_NUMBER%TYPE,
82 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
83 X_MSG_COUNT OUT NOCOPY NUMBER,
84 X_MSG_DATA OUT NOCOPY VARCHAR2
85 );
86
87
88 END jtf_rs_team_usages_pub;