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_MEMBERS_PUB dependencies on JTF_RS_GROUP_MEMBERS

Line 1: PACKAGE jtf_rs_group_members_pub AUTHID CURRENT_USER AS

1: PACKAGE jtf_rs_group_members_pub AUTHID CURRENT_USER AS
2: /* $Header: jtfrspms.pls 120.0 2005/05/11 08:21:16 appldev ship $ */
3: /*#
4: * Group Member create, update and delete API
5: * This API contains the procedures to insert, update and delete Group member record.

Line 18: Calls to these procedures will invoke procedures from jtf_rs_group_members_pvt

14: create, update and delete resource group members from other modules.
15: Its main procedures are as following:
16: Create Resource Group Members
17: Delete Resource Group Members
18: Calls to these procedures will invoke procedures from jtf_rs_group_members_pvt
19: to do business validations and to do actual inserts and deletes into tables.
20: ******************************************************************************************/
21:
22:

Line 47: P_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,

43: PROCEDURE create_resource_group_members
44: (P_API_VERSION IN NUMBER,
45: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
46: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
47: P_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,
48: P_GROUP_NUMBER IN JTF_RS_GROUPS_VL.GROUP_NUMBER%TYPE,
49: P_RESOURCE_ID IN JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,
50: P_RESOURCE_NUMBER IN JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE,
51: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 49: P_RESOURCE_ID IN JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,

45: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
46: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
47: P_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,
48: P_GROUP_NUMBER IN JTF_RS_GROUPS_VL.GROUP_NUMBER%TYPE,
49: P_RESOURCE_ID IN JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,
50: P_RESOURCE_NUMBER IN JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE,
51: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
52: X_MSG_COUNT OUT NOCOPY NUMBER,
53: X_MSG_DATA OUT NOCOPY VARCHAR2,

Line 54: X_GROUP_MEMBER_ID OUT NOCOPY JTF_RS_GROUP_MEMBERS.GROUP_MEMBER_ID%TYPE

50: P_RESOURCE_NUMBER IN JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE,
51: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
52: X_MSG_COUNT OUT NOCOPY NUMBER,
53: X_MSG_DATA OUT NOCOPY VARCHAR2,
54: X_GROUP_MEMBER_ID OUT NOCOPY JTF_RS_GROUP_MEMBERS.GROUP_MEMBER_ID%TYPE
55: );
56:
57:
58: /* Procedure to update the resource group members. */

Line 70: * @param p_object_version_number The object version number of the group member derives from the jtf_rs_group_members table.

66: * @param p_group_id Group Identifier
67: * @param p_group_number Group Number
68: * @param p_resource_id Resource Identifier
69: * @param p_resource_number Resource Number
70: * @param p_object_version_number The object version number of the group member derives from the jtf_rs_group_members table.
71: * @param x_return_status Output parameter for return status
72: * @param x_msg_count Output parameter for number of user messages from this procedure
73: * @param x_msg_data Output parameter containing last user message from this procedure
74: * @rep:scope internal

Line 82: P_GROUP_MEMBER_ID IN JTF_RS_GROUP_MEMBERS.GROUP_MEMBER_ID%TYPE,

78: PROCEDURE update_resource_group_members
79: (P_API_VERSION IN NUMBER,
80: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
81: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
82: P_GROUP_MEMBER_ID IN JTF_RS_GROUP_MEMBERS.GROUP_MEMBER_ID%TYPE,
83: P_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,
84: P_GROUP_NUMBER IN JTF_RS_GROUPS_VL.GROUP_NUMBER%TYPE,
85: P_RESOURCE_ID IN JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,
86: P_RESOURCE_NUMBER IN JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE,

Line 83: P_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,

79: (P_API_VERSION IN NUMBER,
80: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
81: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
82: P_GROUP_MEMBER_ID IN JTF_RS_GROUP_MEMBERS.GROUP_MEMBER_ID%TYPE,
83: P_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,
84: P_GROUP_NUMBER IN JTF_RS_GROUPS_VL.GROUP_NUMBER%TYPE,
85: P_RESOURCE_ID IN JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,
86: P_RESOURCE_NUMBER IN JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE,
87: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_GROUP_MEMBERS.OBJECT_VERSION_NUMBER%TYPE,

Line 85: P_RESOURCE_ID IN JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,

81: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
82: P_GROUP_MEMBER_ID IN JTF_RS_GROUP_MEMBERS.GROUP_MEMBER_ID%TYPE,
83: P_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,
84: P_GROUP_NUMBER IN JTF_RS_GROUPS_VL.GROUP_NUMBER%TYPE,
85: P_RESOURCE_ID IN JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,
86: P_RESOURCE_NUMBER IN JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE,
87: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_GROUP_MEMBERS.OBJECT_VERSION_NUMBER%TYPE,
88: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
89: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 87: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_GROUP_MEMBERS.OBJECT_VERSION_NUMBER%TYPE,

83: P_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,
84: P_GROUP_NUMBER IN JTF_RS_GROUPS_VL.GROUP_NUMBER%TYPE,
85: P_RESOURCE_ID IN JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,
86: P_RESOURCE_NUMBER IN JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE,
87: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_GROUP_MEMBERS.OBJECT_VERSION_NUMBER%TYPE,
88: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
89: X_MSG_COUNT OUT NOCOPY NUMBER,
90: X_MSG_DATA OUT NOCOPY VARCHAR2
91: );

Line 104: * @param p_object_version_num The object version number of the group member derives from the jtf_rs_group_members table.

100: * @param p_group_id Group Identifier
101: * @param p_group_number Group Number
102: * @param p_resource_id Resource Identifier
103: * @param p_resource_number Resource Number
104: * @param p_object_version_num The object version number of the group member derives from the jtf_rs_group_members table.
105: * @param x_return_status Output parameter for return status
106: * @param x_msg_count Output parameter for number of user messages from this procedure
107: * @param x_msg_data Output parameter containing last user message from this procedure
108: * @rep:scope internal

Line 116: P_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,

112: PROCEDURE delete_resource_group_members
113: (P_API_VERSION IN NUMBER,
114: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
115: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
116: P_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,
117: P_GROUP_NUMBER IN JTF_RS_GROUPS_VL.GROUP_NUMBER%TYPE,
118: P_RESOURCE_ID IN JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,
119: P_RESOURCE_NUMBER IN JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE,
120: P_OBJECT_VERSION_NUM IN JTF_RS_GROUP_MEMBERS.OBJECT_VERSION_NUMBER%TYPE,

Line 118: P_RESOURCE_ID IN JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,

114: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
115: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
116: P_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,
117: P_GROUP_NUMBER IN JTF_RS_GROUPS_VL.GROUP_NUMBER%TYPE,
118: P_RESOURCE_ID IN JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,
119: P_RESOURCE_NUMBER IN JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE,
120: P_OBJECT_VERSION_NUM IN JTF_RS_GROUP_MEMBERS.OBJECT_VERSION_NUMBER%TYPE,
121: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
122: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 120: P_OBJECT_VERSION_NUM IN JTF_RS_GROUP_MEMBERS.OBJECT_VERSION_NUMBER%TYPE,

116: P_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,
117: P_GROUP_NUMBER IN JTF_RS_GROUPS_VL.GROUP_NUMBER%TYPE,
118: P_RESOURCE_ID IN JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,
119: P_RESOURCE_NUMBER IN JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE,
120: P_OBJECT_VERSION_NUM IN JTF_RS_GROUP_MEMBERS.OBJECT_VERSION_NUMBER%TYPE,
121: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
122: X_MSG_COUNT OUT NOCOPY NUMBER,
123: X_MSG_DATA OUT NOCOPY VARCHAR2
124: );

Line 127: END jtf_rs_group_members_pub;

123: X_MSG_DATA OUT NOCOPY VARCHAR2
124: );
125:
126:
127: END jtf_rs_group_members_pub;