DBA Data[Home] [Help]

APPS.JTF_RS_GROUP_MEMBERS_PUB dependencies on JTF_RS_GROUPS_VL

Line 28: P_GROUP_NUMBER IN JTF_RS_GROUPS_VL.GROUP_NUMBER%TYPE,

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_MEMBERS.GROUP_ID%TYPE,
28: P_GROUP_NUMBER IN JTF_RS_GROUPS_VL.GROUP_NUMBER%TYPE,
29: P_RESOURCE_ID IN JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,
30: P_RESOURCE_NUMBER IN JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE,
31: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
32: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 41: l_group_number jtf_rs_groups_vl.group_number%TYPE := p_group_number;

37:
38: l_api_version CONSTANT NUMBER := 1.0;
39: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RESOURCE_GROUP_MEMBERS';
40: l_group_id jtf_rs_group_members.group_id%TYPE := p_group_id;
41: l_group_number jtf_rs_groups_vl.group_number%TYPE := p_group_number;
42: l_resource_id jtf_rs_group_members.resource_id%type := p_resource_id;
43: l_resource_number jtf_rs_resource_extns.resource_number%type := p_resource_number;
44: l_group_member_id jtf_rs_group_members.group_member_id%TYPE;
45:

Line 204: P_GROUP_NUMBER IN JTF_RS_GROUPS_VL.GROUP_NUMBER%TYPE,

200: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
201: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
202: P_GROUP_MEMBER_ID IN JTF_RS_GROUP_MEMBERS.GROUP_MEMBER_ID%TYPE,
203: P_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,
204: P_GROUP_NUMBER IN JTF_RS_GROUPS_VL.GROUP_NUMBER%TYPE,
205: P_RESOURCE_ID IN JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,
206: P_RESOURCE_NUMBER IN JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE,
207: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_GROUP_MEMBERS.OBJECT_VERSION_NUMBER%TYPE,
208: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 217: l_group_number jtf_rs_groups_vl.group_number%TYPE := p_group_number;

213:
214: l_api_version CONSTANT NUMBER := 1.0;
215: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_RESOURCE_GROUP_MEMBERS';
216: l_group_id jtf_rs_group_members.group_id%TYPE := p_group_id;
217: l_group_number jtf_rs_groups_vl.group_number%TYPE := p_group_number;
218: l_resource_id jtf_rs_group_members.resource_id%type := p_resource_id;
219: l_resource_number jtf_rs_resource_extns.resource_number%type := p_resource_number;
220: l_group_member_id jtf_rs_group_members.group_member_id%TYPE := p_group_member_id;
221:

Line 379: P_GROUP_NUMBER IN JTF_RS_GROUPS_VL.GROUP_NUMBER%TYPE,

375: (P_API_VERSION IN NUMBER,
376: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
377: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
378: P_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,
379: P_GROUP_NUMBER IN JTF_RS_GROUPS_VL.GROUP_NUMBER%TYPE,
380: P_RESOURCE_ID IN JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,
381: P_RESOURCE_NUMBER IN JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE,
382: P_OBJECT_VERSION_NUM IN JTF_RS_GROUP_MEMBERS.OBJECT_VERSION_NUMBER%TYPE,
383: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 391: l_group_number jtf_rs_groups_vl.group_number%TYPE := p_group_number;

387:
388: l_api_version CONSTANT NUMBER := 1.0;
389: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_RESOURCE_GROUP_MEMBERS';
390: l_group_id jtf_rs_group_members.group_id%TYPE := p_group_id;
391: l_group_number jtf_rs_groups_vl.group_number%TYPE := p_group_number;
392: l_resource_id jtf_rs_group_members.resource_id%type := p_resource_id;
393: l_resource_number jtf_rs_resource_extns.resource_number%type := p_resource_number;
394: l_group_member_id jtf_rs_group_members.group_member_id%TYPE;
395: l_group_id_out jtf_rs_group_members.group_id%TYPE;