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_RESOURCE_EXTNS

Line 30: P_RESOURCE_NUMBER IN JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE,

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,
33: X_MSG_DATA OUT NOCOPY VARCHAR2,
34: X_GROUP_MEMBER_ID OUT NOCOPY JTF_RS_GROUP_MEMBERS.GROUP_MEMBER_ID%TYPE

Line 43: l_resource_number jtf_rs_resource_extns.resource_number%type := p_resource_number;

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:
46: l_group_id_out jtf_rs_group_members.group_id%TYPE;
47: l_resource_id_out jtf_rs_group_members.resource_id%type;

Line 206: P_RESOURCE_NUMBER IN JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE,

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,
209: X_MSG_COUNT OUT NOCOPY NUMBER,
210: X_MSG_DATA OUT NOCOPY VARCHAR2

Line 219: l_resource_number jtf_rs_resource_extns.resource_number%type := p_resource_number;

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:
222: l_group_id_out jtf_rs_group_members.group_id%TYPE;
223: l_resource_id_out jtf_rs_group_members.resource_id%type;

Line 381: P_RESOURCE_NUMBER IN JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE,

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,
384: X_MSG_COUNT OUT NOCOPY NUMBER,
385: X_MSG_DATA OUT NOCOPY VARCHAR2

Line 393: l_resource_number jtf_rs_resource_extns.resource_number%type := p_resource_number;

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;
396: l_resource_id_out jtf_rs_group_members.resource_id%type;
397:

Line 401: FROM jtf_rs_resource_extns

397:
398:
399: CURSOR c_resource_id IS
400: SELECT resource_id
401: FROM jtf_rs_resource_extns
402: WHERE resource_id = p_resource_id;
403:
404: CURSOR c_resource_number IS
405: SELECT resource_id

Line 406: FROM jtf_rs_resource_extns

402: WHERE resource_id = p_resource_id;
403:
404: CURSOR c_resource_number IS
405: SELECT resource_id
406: FROM jtf_rs_resource_extns
407: WHERE resource_number = p_resource_number;
408:
409: BEGIN
410: