eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_RS_TEAM_USAGES_PUB dependencies on JTF_RS_TEAM_USAGES

Line 1: PACKAGE BODY jtf_rs_team_usages_pub AS

1: PACKAGE BODY jtf_rs_team_usages_pub AS
2: /* $Header: jtfrspjb.pls 120.0 2005/05/11 08:21:12 appldev ship $ */
3:
4: /*****************************************************************************************
5: This is a public API that caller will invoke.

Line 10: Calls to these procedures will invoke procedures from jtf_rs_team_usages_pvt

6: It provides procedures for managing resource team usages.
7: Its main procedures are as following:
8: Create Resource Team Usage
9: Delete Resource Team Usage
10: Calls to these procedures will invoke procedures from jtf_rs_team_usages_pvt
11: to do business validations and to do actual inserts and updates into tables.
12: ******************************************************************************************/
13:
14:

Line 17: G_PKG_NAME VARCHAR2(30) := 'JTF_RS_TEAM_USAGES_PUB';

13:
14:
15: /* Package variables. */
16:
17: G_PKG_NAME VARCHAR2(30) := 'JTF_RS_TEAM_USAGES_PUB';
18:
19:
20: /* Procedure to create the resource team usage
21: based on input values passed by calling routines. */

Line 27: P_TEAM_ID IN JTF_RS_TEAM_USAGES.TEAM_ID%TYPE,

23: PROCEDURE create_team_usage
24: (P_API_VERSION IN NUMBER,
25: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
26: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
27: P_TEAM_ID IN JTF_RS_TEAM_USAGES.TEAM_ID%TYPE,
28: P_TEAM_NUMBER IN JTF_RS_TEAMS_VL.TEAM_NUMBER%TYPE,
29: P_USAGE IN JTF_RS_TEAM_USAGES.USAGE%TYPE,
30: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
31: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 29: P_USAGE IN JTF_RS_TEAM_USAGES.USAGE%TYPE,

25: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
26: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
27: P_TEAM_ID IN JTF_RS_TEAM_USAGES.TEAM_ID%TYPE,
28: P_TEAM_NUMBER IN JTF_RS_TEAMS_VL.TEAM_NUMBER%TYPE,
29: P_USAGE IN JTF_RS_TEAM_USAGES.USAGE%TYPE,
30: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
31: X_MSG_COUNT OUT NOCOPY NUMBER,
32: X_MSG_DATA OUT NOCOPY VARCHAR2,
33: X_TEAM_USAGE_ID OUT NOCOPY JTF_RS_TEAM_USAGES.TEAM_USAGE_ID%TYPE

Line 33: X_TEAM_USAGE_ID OUT NOCOPY JTF_RS_TEAM_USAGES.TEAM_USAGE_ID%TYPE

29: P_USAGE IN JTF_RS_TEAM_USAGES.USAGE%TYPE,
30: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
31: X_MSG_COUNT OUT NOCOPY NUMBER,
32: X_MSG_DATA OUT NOCOPY VARCHAR2,
33: X_TEAM_USAGE_ID OUT NOCOPY JTF_RS_TEAM_USAGES.TEAM_USAGE_ID%TYPE
34: ) IS
35:
36: l_api_version CONSTANT NUMBER := 1.0;
37: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_TEAM_USAGE';

Line 38: l_team_id jtf_rs_team_usages.team_id%TYPE := p_team_id;

34: ) IS
35:
36: l_api_version CONSTANT NUMBER := 1.0;
37: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_TEAM_USAGE';
38: l_team_id jtf_rs_team_usages.team_id%TYPE := p_team_id;
39: l_team_number jtf_rs_teams_vl.team_number%TYPE := p_team_number;
40: l_usage jtf_rs_team_usages.usage%TYPE := p_usage;
41:
42: l_team_id_out jtf_rs_team_usages.team_id%TYPE;

Line 40: l_usage jtf_rs_team_usages.usage%TYPE := p_usage;

36: l_api_version CONSTANT NUMBER := 1.0;
37: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_TEAM_USAGE';
38: l_team_id jtf_rs_team_usages.team_id%TYPE := p_team_id;
39: l_team_number jtf_rs_teams_vl.team_number%TYPE := p_team_number;
40: l_usage jtf_rs_team_usages.usage%TYPE := p_usage;
41:
42: l_team_id_out jtf_rs_team_usages.team_id%TYPE;
43:
44:

Line 42: l_team_id_out jtf_rs_team_usages.team_id%TYPE;

38: l_team_id jtf_rs_team_usages.team_id%TYPE := p_team_id;
39: l_team_number jtf_rs_teams_vl.team_number%TYPE := p_team_number;
40: l_usage jtf_rs_team_usages.usage%TYPE := p_usage;
41:
42: l_team_id_out jtf_rs_team_usages.team_id%TYPE;
43:
44:
45: BEGIN
46:

Line 110: jtf_rs_team_usages_pvt.create_team_usage

106:
107:
108: /* Call the private procedure with the validated parameters. */
109:
110: jtf_rs_team_usages_pvt.create_team_usage
111: (P_API_VERSION => 1,
112: P_INIT_MSG_LIST => fnd_api.g_false,
113: P_COMMIT => fnd_api.g_false,
114: P_TEAM_ID => l_team_id,

Line 183: P_TEAM_ID IN JTF_RS_TEAM_USAGES.TEAM_ID%TYPE,

179: PROCEDURE delete_team_usage
180: (P_API_VERSION IN NUMBER,
181: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
182: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
183: P_TEAM_ID IN JTF_RS_TEAM_USAGES.TEAM_ID%TYPE,
184: P_TEAM_NUMBER IN JTF_RS_TEAMS_VL.TEAM_NUMBER%TYPE,
185: P_USAGE IN JTF_RS_TEAM_USAGES.USAGE%TYPE,
186: P_OBJECT_VERSION_NUM IN JTF_RS_TEAM_USAGES.OBJECT_VERSION_NUMBER%TYPE,
187: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 185: P_USAGE IN JTF_RS_TEAM_USAGES.USAGE%TYPE,

181: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
182: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
183: P_TEAM_ID IN JTF_RS_TEAM_USAGES.TEAM_ID%TYPE,
184: P_TEAM_NUMBER IN JTF_RS_TEAMS_VL.TEAM_NUMBER%TYPE,
185: P_USAGE IN JTF_RS_TEAM_USAGES.USAGE%TYPE,
186: P_OBJECT_VERSION_NUM IN JTF_RS_TEAM_USAGES.OBJECT_VERSION_NUMBER%TYPE,
187: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
188: X_MSG_COUNT OUT NOCOPY NUMBER,
189: X_MSG_DATA OUT NOCOPY VARCHAR2

Line 186: P_OBJECT_VERSION_NUM IN JTF_RS_TEAM_USAGES.OBJECT_VERSION_NUMBER%TYPE,

182: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
183: P_TEAM_ID IN JTF_RS_TEAM_USAGES.TEAM_ID%TYPE,
184: P_TEAM_NUMBER IN JTF_RS_TEAMS_VL.TEAM_NUMBER%TYPE,
185: P_USAGE IN JTF_RS_TEAM_USAGES.USAGE%TYPE,
186: P_OBJECT_VERSION_NUM IN JTF_RS_TEAM_USAGES.OBJECT_VERSION_NUMBER%TYPE,
187: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
188: X_MSG_COUNT OUT NOCOPY NUMBER,
189: X_MSG_DATA OUT NOCOPY VARCHAR2
190: ) IS

Line 194: l_team_id jtf_rs_team_usages.team_id%TYPE := p_team_id;

190: ) IS
191:
192: l_api_version CONSTANT NUMBER := 1.0;
193: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_TEAM_USAGE';
194: l_team_id jtf_rs_team_usages.team_id%TYPE := p_team_id;
195: l_team_number jtf_rs_teams_vl.team_number%TYPE := p_team_number;
196: l_usage jtf_rs_team_usages.usage%TYPE := p_usage;
197:
198: l_team_id_out jtf_rs_team_usages.team_id%TYPE;

Line 196: l_usage jtf_rs_team_usages.usage%TYPE := p_usage;

192: l_api_version CONSTANT NUMBER := 1.0;
193: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_TEAM_USAGE';
194: l_team_id jtf_rs_team_usages.team_id%TYPE := p_team_id;
195: l_team_number jtf_rs_teams_vl.team_number%TYPE := p_team_number;
196: l_usage jtf_rs_team_usages.usage%TYPE := p_usage;
197:
198: l_team_id_out jtf_rs_team_usages.team_id%TYPE;
199:
200:

Line 198: l_team_id_out jtf_rs_team_usages.team_id%TYPE;

194: l_team_id jtf_rs_team_usages.team_id%TYPE := p_team_id;
195: l_team_number jtf_rs_teams_vl.team_number%TYPE := p_team_number;
196: l_usage jtf_rs_team_usages.usage%TYPE := p_usage;
197:
198: l_team_id_out jtf_rs_team_usages.team_id%TYPE;
199:
200:
201: BEGIN
202:

Line 270: jtf_rs_team_usages_pvt.delete_team_usage

266:
267:
268: /* Call the private procedure for delete */
269:
270: jtf_rs_team_usages_pvt.delete_team_usage
271: (P_API_VERSION => 1,
272: P_INIT_MSG_LIST => fnd_api.g_false,
273: P_COMMIT => fnd_api.g_false,
274: P_TEAM_ID => l_team_id,

Line 335: END jtf_rs_team_usages_pub;

331:
332: END delete_team_usage;
333:
334:
335: END jtf_rs_team_usages_pub;