APPS.JTF_RS_TEAM_MEMBERS_PUB dependencies on JTF_RS_TEAM_MEMBERS

Line 1: PACKAGE jtf_rs_team_members_pub AS

1: PACKAGE jtf_rs_team_members_pub AS
2: /* $Header: jtfrspes.pls 120.0 2005/05/11 08:21:07 appldev ship $ */
3: /*#
4: * Team Member create and delete API
5: * This API contains the procedures to insert and delete Team member record.

Line 19: Calls to these procedures will invoke procedures from jtf_rs_team_members_pvt

15: Its main procedures are as following:
16: Create Resource Team Members
17: Update Resource Team Members
18: Delete Resource Team Members
19: Calls to these procedures will invoke procedures from jtf_rs_team_members_pvt
20: to do business validations and to do actual inserts, updates and deletes into tables.
21: ******************************************************************************************/
22:
23:

Line 50: P_TEAM_ID IN JTF_RS_TEAM_MEMBERS.TEAM_ID%TYPE,

46: PROCEDURE create_resource_team_members
47: (P_API_VERSION IN NUMBER,
48: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
49: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
50: P_TEAM_ID IN JTF_RS_TEAM_MEMBERS.TEAM_ID%TYPE,
51: P_TEAM_NUMBER IN JTF_RS_TEAMS_VL.TEAM_NUMBER%TYPE,
52: P_TEAM_RESOURCE_ID IN JTF_RS_TEAM_MEMBERS.TEAM_RESOURCE_ID%TYPE,
53: P_TEAM_RESOURCE_NUMBER IN NUMBER,
54: P_RESOURCE_TYPE IN JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE,

Line 52: P_TEAM_RESOURCE_ID IN JTF_RS_TEAM_MEMBERS.TEAM_RESOURCE_ID%TYPE,

48: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
49: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
50: P_TEAM_ID IN JTF_RS_TEAM_MEMBERS.TEAM_ID%TYPE,
51: P_TEAM_NUMBER IN JTF_RS_TEAMS_VL.TEAM_NUMBER%TYPE,
52: P_TEAM_RESOURCE_ID IN JTF_RS_TEAM_MEMBERS.TEAM_RESOURCE_ID%TYPE,
53: P_TEAM_RESOURCE_NUMBER IN NUMBER,
54: P_RESOURCE_TYPE IN JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE,
55: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
56: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 54: P_RESOURCE_TYPE IN JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE,

50: P_TEAM_ID IN JTF_RS_TEAM_MEMBERS.TEAM_ID%TYPE,
51: P_TEAM_NUMBER IN JTF_RS_TEAMS_VL.TEAM_NUMBER%TYPE,
52: P_TEAM_RESOURCE_ID IN JTF_RS_TEAM_MEMBERS.TEAM_RESOURCE_ID%TYPE,
53: P_TEAM_RESOURCE_NUMBER IN NUMBER,
54: P_RESOURCE_TYPE IN JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE,
55: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
56: X_MSG_COUNT OUT NOCOPY NUMBER,
57: X_MSG_DATA OUT NOCOPY VARCHAR2,
58: X_TEAM_MEMBER_ID OUT NOCOPY JTF_RS_TEAM_MEMBERS.TEAM_MEMBER_ID%TYPE

Line 58: X_TEAM_MEMBER_ID OUT NOCOPY JTF_RS_TEAM_MEMBERS.TEAM_MEMBER_ID%TYPE

54: P_RESOURCE_TYPE IN JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE,
55: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
56: X_MSG_COUNT OUT NOCOPY NUMBER,
57: X_MSG_DATA OUT NOCOPY VARCHAR2,
58: X_TEAM_MEMBER_ID OUT NOCOPY JTF_RS_TEAM_MEMBERS.TEAM_MEMBER_ID%TYPE
59: );
60:
61:
62: /* Procedure to delete the resource team members. */

Line 74: * @param p_object_version_num The object version number of the team member derives from the jtf_rs_team_members table

70: * @param p_team_number Team Number
71: * @param p_team_resource_id Team Resource Identifier. This can be Resource or Group Identifier
72: * @param p_team_resource_number Team Resource Number. This can be Resource or Group Number
73: * @param p_resource_type Type of the Resource. This can be Resource or Group.
74: * @param p_object_version_num The object version number of the team member derives from the jtf_rs_team_members table
75: * @param x_return_status Output parameter for return status
76: * @param x_msg_count Output parameter for number of user messages from this procedure
77: * @param x_msg_data Output parameter containing last user message from this procedure
78: * @rep:scope internal

Line 86: P_TEAM_ID IN JTF_RS_TEAM_MEMBERS.TEAM_ID%TYPE,

82: PROCEDURE delete_resource_team_members
83: (P_API_VERSION IN NUMBER,
84: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
85: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
86: P_TEAM_ID IN JTF_RS_TEAM_MEMBERS.TEAM_ID%TYPE,
87: P_TEAM_NUMBER IN JTF_RS_TEAMS_VL.TEAM_NUMBER%TYPE,
88: P_TEAM_RESOURCE_ID IN JTF_RS_TEAM_MEMBERS.TEAM_RESOURCE_ID%TYPE,
89: P_TEAM_RESOURCE_NUMBER IN NUMBER,
90: P_RESOURCE_TYPE IN JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE,

Line 88: P_TEAM_RESOURCE_ID IN JTF_RS_TEAM_MEMBERS.TEAM_RESOURCE_ID%TYPE,

84: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
85: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
86: P_TEAM_ID IN JTF_RS_TEAM_MEMBERS.TEAM_ID%TYPE,
87: P_TEAM_NUMBER IN JTF_RS_TEAMS_VL.TEAM_NUMBER%TYPE,
88: P_TEAM_RESOURCE_ID IN JTF_RS_TEAM_MEMBERS.TEAM_RESOURCE_ID%TYPE,
89: P_TEAM_RESOURCE_NUMBER IN NUMBER,
90: P_RESOURCE_TYPE IN JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE,
91: P_OBJECT_VERSION_NUM IN JTF_RS_TEAM_MEMBERS.OBJECT_VERSION_NUMBER%TYPE,
92: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 90: P_RESOURCE_TYPE IN JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE,

86: P_TEAM_ID IN JTF_RS_TEAM_MEMBERS.TEAM_ID%TYPE,
87: P_TEAM_NUMBER IN JTF_RS_TEAMS_VL.TEAM_NUMBER%TYPE,
88: P_TEAM_RESOURCE_ID IN JTF_RS_TEAM_MEMBERS.TEAM_RESOURCE_ID%TYPE,
89: P_TEAM_RESOURCE_NUMBER IN NUMBER,
90: P_RESOURCE_TYPE IN JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE,
91: P_OBJECT_VERSION_NUM IN JTF_RS_TEAM_MEMBERS.OBJECT_VERSION_NUMBER%TYPE,
92: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
93: X_MSG_COUNT OUT NOCOPY NUMBER,
94: X_MSG_DATA OUT NOCOPY VARCHAR2

Line 91: P_OBJECT_VERSION_NUM IN JTF_RS_TEAM_MEMBERS.OBJECT_VERSION_NUMBER%TYPE,

87: P_TEAM_NUMBER IN JTF_RS_TEAMS_VL.TEAM_NUMBER%TYPE,
88: P_TEAM_RESOURCE_ID IN JTF_RS_TEAM_MEMBERS.TEAM_RESOURCE_ID%TYPE,
89: P_TEAM_RESOURCE_NUMBER IN NUMBER,
90: P_RESOURCE_TYPE IN JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE,
91: P_OBJECT_VERSION_NUM IN JTF_RS_TEAM_MEMBERS.OBJECT_VERSION_NUMBER%TYPE,
92: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
93: X_MSG_COUNT OUT NOCOPY NUMBER,
94: X_MSG_DATA OUT NOCOPY VARCHAR2
95: );

Line 98: END jtf_rs_team_members_pub;

94: X_MSG_DATA OUT NOCOPY VARCHAR2
95: );
96:
97:
98: END jtf_rs_team_members_pub;