1 PACKAGE jtf_rs_teams_pub AUTHID CURRENT_USER AS
2 /* $Header: jtfrspts.pls 120.0 2005/05/11 08:21:25 appldev ship $ */
3 /*#
4 * Package containing procedures to maintain teams
5 * @rep:scope internal
6 * @rep:product JTF
7 * @rep:displayname Teams Package
8 * @rep:category BUSINESS_ENTITY JTF_RS_TEAM
9 */
10
11
12 /*****************************************************************************************
13 This is a public API that caller will invoke.
14 It provides PROCEDUREs for managing resource teams.
15 Its main PROCEDUREs are as following:
16 Create Resource Teams
17 Update Resource Teams
18 Calls to these PROCEDUREs will invoke PROCEDUREs from jtf_rs_teams_pvt
19 to do business validations and to do actual inserts and updates into tables.
20 This package uses variables of type record and pl/sql table .
21 ******************************************************************************************/
22
23 /* PROCEDURE to create the resource team and the members
24 based on input values passed by calling routines. */
25
26 /*#
27 * Create a resource team
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_NAME Name of the team
32 * @param P_TEAM_DESC Description for the team
33 * @param P_EXCLUSIVE_FLAG Is it exclusive
34 * @param P_EMAIL_ADDRESS Email for the team
35 * @param P_START_DATE_ACTIVE Active From Date
36 * @param P_END_DATE_ACTIVE Active To Date
37 * @param X_RETURN_STATUS Output parameter for return status
38 * @param X_MSG_COUNT Output parameter for number of user messages from this procedure
39 * @param X_MSG_DATA Output parameter containing last user message from this procedure
40 * @param X_TEAM_ID Output parameter containing Internal Unique ID for the newly create team
41 * @param X_TEAM_NUMBER Output parameter containing team number for the newly create team
42 * @rep:scope internal
43 * @rep:displayname Create Resource Team
44 */
45 PROCEDURE create_resource_team
46 (P_API_VERSION IN NUMBER,
47 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
48 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
49 P_TEAM_NAME IN JTF_RS_TEAMS_VL.TEAM_NAME%TYPE,
50 P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE DEFAULT NULL,
51 P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT 'N',
52 P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE DEFAULT NULL,
53 P_START_DATE_ACTIVE IN JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE,
54 P_END_DATE_ACTIVE IN JTF_RS_TEAMS_VL.END_DATE_ACTIVE%TYPE DEFAULT NULL,
55 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
56 X_MSG_COUNT OUT NOCOPY NUMBER,
57 X_MSG_DATA OUT NOCOPY VARCHAR2,
58 X_TEAM_ID OUT NOCOPY JTF_RS_TEAMS_VL.TEAM_ID%TYPE,
59 X_TEAM_NUMBER OUT NOCOPY JTF_RS_TEAMS_VL.TEAM_NUMBER%TYPE
60 );
61
62
63 /* PROCEDURE to update the resource team based on input values
64 passed by calling routines. */
65
66 /*#
67 * Update Resource Team
68 * @param P_API_VERSION API version number
69 * @param P_INIT_MSG_LIST Flag to start with clearing messages from database
70 * @param P_COMMIT Flag to commit at the end of the procedure
71 * @param P_TEAM_ID Internal Unique identifier for the team
72 * @param P_TEAM_NUMBER Team Number for the team
73 * @param P_TEAM_NAME Name of the team
74 * @param P_TEAM_DESC Description for the team
75 * @param P_EXCLUSIVE_FLAG Is it exclusive
76 * @param P_EMAIL_ADDRESS Email for the team
77 * @param P_START_DATE_ACTIVE Active From Date
78 * @param P_END_DATE_ACTIVE Active To Date
79 * @param P_OBJECT_VERSION_NUM Object version number for the team record
80 * @param X_RETURN_STATUS Output parameter for return status
81 * @param X_MSG_COUNT Output parameter for number of user messages from this procedure
82 * @param X_MSG_DATA Output parameter containing last user message from this procedure
83 * @rep:scope internal
84 * @rep:displayname Update Resource Team
85 */
86 PROCEDURE update_resource_team
87 (P_API_VERSION IN NUMBER,
88 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
89 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
90 P_TEAM_ID IN JTF_RS_TEAMS_VL.TEAM_ID%TYPE,
91 P_TEAM_NUMBER IN JTF_RS_TEAMS_VL.TEAM_NUMBER%TYPE,
92 P_TEAM_NAME IN JTF_RS_TEAMS_VL.TEAM_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
93 P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
94 P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
95 P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE DEFAULT FND_API.G_MISS_CHAR,
96 P_START_DATE_ACTIVE IN JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
97 P_END_DATE_ACTIVE IN JTF_RS_TEAMS_VL.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
98 P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_TEAMS_VL.OBJECT_VERSION_NUMBER%TYPE,
99 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
100 X_MSG_COUNT OUT NOCOPY NUMBER,
101 X_MSG_DATA OUT NOCOPY VARCHAR2
102 );
103
104
105 END jtf_rs_teams_pub;