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_GROUP_USAGES_PUB dependencies on JTF_RS_GROUP_USAGES

Line 1: PACKAGE BODY jtf_rs_group_usages_pub AS

1: PACKAGE BODY jtf_rs_group_usages_pub AS
2: /* $Header: jtfrspab.pls 120.0 2005/05/11 08:21:03 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_group_usages_pvt

6: It provides procedures for managing resource group usages.
7: Its main procedures are as following:
8: Create Resource Group Usage
9: Delete Resource Group Usage
10: Calls to these procedures will invoke procedures from jtf_rs_group_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_GROUP_USAGES_PUB';

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

Line 27: P_GROUP_ID IN JTF_RS_GROUP_USAGES.GROUP_ID%TYPE,

23: PROCEDURE create_group_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_GROUP_ID IN JTF_RS_GROUP_USAGES.GROUP_ID%TYPE,
28: P_GROUP_NUMBER IN JTF_RS_GROUPS_VL.GROUP_NUMBER%TYPE,
29: P_USAGE IN JTF_RS_GROUP_USAGES.USAGE%TYPE,
30: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
31: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 29: P_USAGE IN JTF_RS_GROUP_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_GROUP_ID IN JTF_RS_GROUP_USAGES.GROUP_ID%TYPE,
28: P_GROUP_NUMBER IN JTF_RS_GROUPS_VL.GROUP_NUMBER%TYPE,
29: P_USAGE IN JTF_RS_GROUP_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_GROUP_USAGE_ID OUT NOCOPY JTF_RS_GROUP_USAGES.GROUP_USAGE_ID%TYPE

Line 33: X_GROUP_USAGE_ID OUT NOCOPY JTF_RS_GROUP_USAGES.GROUP_USAGE_ID%TYPE

29: P_USAGE IN JTF_RS_GROUP_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_GROUP_USAGE_ID OUT NOCOPY JTF_RS_GROUP_USAGES.GROUP_USAGE_ID%TYPE
34: ) IS
35:
36: l_api_version CONSTANT NUMBER := 1.0;
37: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_GROUP_USAGE';

Line 38: l_group_id jtf_rs_group_usages.group_id%TYPE := p_group_id;

34: ) IS
35:
36: l_api_version CONSTANT NUMBER := 1.0;
37: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_GROUP_USAGE';
38: l_group_id jtf_rs_group_usages.group_id%TYPE := p_group_id;
39: l_group_number jtf_rs_groups_vl.group_number%TYPE := p_group_number;
40: l_usage jtf_rs_group_usages.usage%TYPE := p_usage;
41: -- added to handle NOCOPY
42: l_group_id_out jtf_rs_group_usages.group_id%TYPE ;

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

36: l_api_version CONSTANT NUMBER := 1.0;
37: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_GROUP_USAGE';
38: l_group_id jtf_rs_group_usages.group_id%TYPE := p_group_id;
39: l_group_number jtf_rs_groups_vl.group_number%TYPE := p_group_number;
40: l_usage jtf_rs_group_usages.usage%TYPE := p_usage;
41: -- added to handle NOCOPY
42: l_group_id_out jtf_rs_group_usages.group_id%TYPE ;
43:
44:

Line 42: l_group_id_out jtf_rs_group_usages.group_id%TYPE ;

38: l_group_id jtf_rs_group_usages.group_id%TYPE := p_group_id;
39: l_group_number jtf_rs_groups_vl.group_number%TYPE := p_group_number;
40: l_usage jtf_rs_group_usages.usage%TYPE := p_usage;
41: -- added to handle NOCOPY
42: l_group_id_out jtf_rs_group_usages.group_id%TYPE ;
43:
44:
45: BEGIN
46:

Line 111: jtf_rs_group_usages_pvt.create_group_usage

107:
108:
109: /* Call the private procedure with the validated parameters. */
110:
111: jtf_rs_group_usages_pvt.create_group_usage
112: (P_API_VERSION => 1,
113: P_INIT_MSG_LIST => fnd_api.g_false,
114: P_COMMIT => fnd_api.g_false,
115: P_GROUP_ID => l_group_id,

Line 190: P_GROUP_ID IN JTF_RS_GROUP_USAGES.GROUP_ID%TYPE,

186: PROCEDURE delete_group_usage
187: (P_API_VERSION IN NUMBER,
188: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
189: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
190: P_GROUP_ID IN JTF_RS_GROUP_USAGES.GROUP_ID%TYPE,
191: P_GROUP_NUMBER IN JTF_RS_GROUPS_VL.GROUP_NUMBER%TYPE,
192: P_USAGE IN JTF_RS_GROUP_USAGES.USAGE%TYPE,
193: P_OBJECT_VERSION_NUM IN JTF_RS_GROUP_USAGES.OBJECT_VERSION_NUMBER%TYPE,
194: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 192: P_USAGE IN JTF_RS_GROUP_USAGES.USAGE%TYPE,

188: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
189: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
190: P_GROUP_ID IN JTF_RS_GROUP_USAGES.GROUP_ID%TYPE,
191: P_GROUP_NUMBER IN JTF_RS_GROUPS_VL.GROUP_NUMBER%TYPE,
192: P_USAGE IN JTF_RS_GROUP_USAGES.USAGE%TYPE,
193: P_OBJECT_VERSION_NUM IN JTF_RS_GROUP_USAGES.OBJECT_VERSION_NUMBER%TYPE,
194: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
195: X_MSG_COUNT OUT NOCOPY NUMBER,
196: X_MSG_DATA OUT NOCOPY VARCHAR2

Line 193: P_OBJECT_VERSION_NUM IN JTF_RS_GROUP_USAGES.OBJECT_VERSION_NUMBER%TYPE,

189: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
190: P_GROUP_ID IN JTF_RS_GROUP_USAGES.GROUP_ID%TYPE,
191: P_GROUP_NUMBER IN JTF_RS_GROUPS_VL.GROUP_NUMBER%TYPE,
192: P_USAGE IN JTF_RS_GROUP_USAGES.USAGE%TYPE,
193: P_OBJECT_VERSION_NUM IN JTF_RS_GROUP_USAGES.OBJECT_VERSION_NUMBER%TYPE,
194: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
195: X_MSG_COUNT OUT NOCOPY NUMBER,
196: X_MSG_DATA OUT NOCOPY VARCHAR2
197: ) IS

Line 201: l_group_id jtf_rs_group_usages.group_id%TYPE := p_group_id;

197: ) IS
198:
199: l_api_version CONSTANT NUMBER := 1.0;
200: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_GROUP_USAGE';
201: l_group_id jtf_rs_group_usages.group_id%TYPE := p_group_id;
202: l_group_number jtf_rs_groups_vl.group_number%TYPE := p_group_number;
203: l_usage jtf_rs_group_usages.usage%TYPE := p_usage;
204:
205: -- added to handle NOCOPY

Line 203: l_usage jtf_rs_group_usages.usage%TYPE := p_usage;

199: l_api_version CONSTANT NUMBER := 1.0;
200: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_GROUP_USAGE';
201: l_group_id jtf_rs_group_usages.group_id%TYPE := p_group_id;
202: l_group_number jtf_rs_groups_vl.group_number%TYPE := p_group_number;
203: l_usage jtf_rs_group_usages.usage%TYPE := p_usage;
204:
205: -- added to handle NOCOPY
206: l_group_id_out jtf_rs_group_usages.group_id%TYPE;
207:

Line 206: l_group_id_out jtf_rs_group_usages.group_id%TYPE;

202: l_group_number jtf_rs_groups_vl.group_number%TYPE := p_group_number;
203: l_usage jtf_rs_group_usages.usage%TYPE := p_usage;
204:
205: -- added to handle NOCOPY
206: l_group_id_out jtf_rs_group_usages.group_id%TYPE;
207:
208:
209: BEGIN
210:

Line 280: jtf_rs_group_usages_pvt.delete_group_usage

276:
277:
278: /* Call the private procedure for delete */
279:
280: jtf_rs_group_usages_pvt.delete_group_usage
281: (P_API_VERSION => 1,
282: P_INIT_MSG_LIST => fnd_api.g_false,
283: P_COMMIT => fnd_api.g_false,
284: P_GROUP_ID => l_group_id,

Line 351: END jtf_rs_group_usages_pub;

347:
348: END delete_group_usage;
349:
350:
351: END jtf_rs_group_usages_pub;