DBA Data[Home] [Help]

APPS.JTF_RS_TEAM_USAGES_PUB dependencies on JTF_RS_TEAM_USAGES

Line 1: PACKAGE jtf_rs_team_usages_pub AS

1: PACKAGE jtf_rs_team_usages_pub 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

Line 18: Calls to these PROCEDUREs will invoke PROCEDUREs from jtf_rs_team_usages_pvt

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:

Line 45: P_TEAM_ID IN JTF_RS_TEAM_USAGES.TEAM_ID%TYPE,

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,

Line 47: P_USAGE IN JTF_RS_TEAM_USAGES.USAGE%TYPE,

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

Line 51: X_TEAM_USAGE_ID OUT NOCOPY JTF_RS_TEAM_USAGES.TEAM_USAGE_ID%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:

Line 78: P_TEAM_ID IN JTF_RS_TEAM_USAGES.TEAM_ID%TYPE,

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,

Line 80: P_USAGE IN JTF_RS_TEAM_USAGES.USAGE%TYPE,

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

Line 81: P_OBJECT_VERSION_NUM IN JTF_RS_TEAM_USAGES.OBJECT_VERSION_NUMBER%TYPE,

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: );

Line 88: END jtf_rs_team_usages_pub;

84: X_MSG_DATA OUT NOCOPY VARCHAR2
85: );
86:
87:
88: END jtf_rs_team_usages_pub;