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_RELATE_PUB dependencies on JTF_RS_GRP_RELATIONS

Line 30: P_RELATED_GROUP_ID IN JTF_RS_GRP_RELATIONS.RELATED_GROUP_ID%TYPE,

26: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
27: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
28: P_GROUP_ID IN JTF_RS_GROUPS_B.GROUP_ID%TYPE,
29: P_GROUP_NUMBER IN JTF_RS_GROUPS_B.GROUP_NUMBER%TYPE,
30: P_RELATED_GROUP_ID IN JTF_RS_GRP_RELATIONS.RELATED_GROUP_ID%TYPE,
31: P_RELATED_GROUP_NUMBER IN JTF_RS_GROUPS_B.GROUP_NUMBER%TYPE,
32: P_RELATION_TYPE IN JTF_RS_GRP_RELATIONS.RELATION_TYPE%TYPE,
33: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
34: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT NULL,

Line 32: P_RELATION_TYPE IN JTF_RS_GRP_RELATIONS.RELATION_TYPE%TYPE,

28: P_GROUP_ID IN JTF_RS_GROUPS_B.GROUP_ID%TYPE,
29: P_GROUP_NUMBER IN JTF_RS_GROUPS_B.GROUP_NUMBER%TYPE,
30: P_RELATED_GROUP_ID IN JTF_RS_GRP_RELATIONS.RELATED_GROUP_ID%TYPE,
31: P_RELATED_GROUP_NUMBER IN JTF_RS_GROUPS_B.GROUP_NUMBER%TYPE,
32: P_RELATION_TYPE IN JTF_RS_GRP_RELATIONS.RELATION_TYPE%TYPE,
33: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
34: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
35: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
36: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 33: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,

29: P_GROUP_NUMBER IN JTF_RS_GROUPS_B.GROUP_NUMBER%TYPE,
30: P_RELATED_GROUP_ID IN JTF_RS_GRP_RELATIONS.RELATED_GROUP_ID%TYPE,
31: P_RELATED_GROUP_NUMBER IN JTF_RS_GROUPS_B.GROUP_NUMBER%TYPE,
32: P_RELATION_TYPE IN JTF_RS_GRP_RELATIONS.RELATION_TYPE%TYPE,
33: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
34: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
35: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
36: X_MSG_COUNT OUT NOCOPY NUMBER,
37: X_MSG_DATA OUT NOCOPY VARCHAR2,

Line 34: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT NULL,

30: P_RELATED_GROUP_ID IN JTF_RS_GRP_RELATIONS.RELATED_GROUP_ID%TYPE,
31: P_RELATED_GROUP_NUMBER IN JTF_RS_GROUPS_B.GROUP_NUMBER%TYPE,
32: P_RELATION_TYPE IN JTF_RS_GRP_RELATIONS.RELATION_TYPE%TYPE,
33: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
34: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
35: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
36: X_MSG_COUNT OUT NOCOPY NUMBER,
37: X_MSG_DATA OUT NOCOPY VARCHAR2,
38: X_GROUP_RELATE_ID OUT NOCOPY JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE

Line 38: X_GROUP_RELATE_ID OUT NOCOPY JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE

34: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
35: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
36: X_MSG_COUNT OUT NOCOPY NUMBER,
37: X_MSG_DATA OUT NOCOPY VARCHAR2,
38: X_GROUP_RELATE_ID OUT NOCOPY JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE
39: ) IS
40: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RESOURCE_GROUP_RELATE';
41: l_api_version CONSTANT NUMBER :=1.0;
42:

Line 47: l_group_relate_id JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE;

43: l_return_status VARCHAR2(200);
44: l_msg_count NUMBER;
45: l_msg_data VARCHAR2(200);
46: l_rowid VARCHAR2(200);
47: l_group_relate_id JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE;
48:
49: l_return_code VARCHAR2(100);
50: l_count NUMBER;
51: l_data VARCHAR2(200);

Line 70: CURSOR chk_rel_cur(l_relation_type JTF_RS_GRP_RELATIONS.RELATION_TYPE%TYPE)

66:
67: grp_rec grp_cur%rowtype;
68:
69:
70: CURSOR chk_rel_cur(l_relation_type JTF_RS_GRP_RELATIONS.RELATION_TYPE%TYPE)
71: IS
72: SELECT 'X'
73: FROM fnd_lookups
74: WHERE lookup_type = 'JTF_RS_RELATION_TYPE'

Line 209: P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,

205: PROCEDURE update_resource_group_relate
206: (P_API_VERSION IN NUMBER,
207: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
208: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
209: P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,
210: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
211: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
212: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_GRP_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
213: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 210: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,

206: (P_API_VERSION IN NUMBER,
207: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
208: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
209: P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,
210: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
211: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
212: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_GRP_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
213: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
214: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 211: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,

207: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
208: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
209: P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,
210: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
211: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
212: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_GRP_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
213: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
214: X_MSG_COUNT OUT NOCOPY NUMBER,
215: X_MSG_DATA OUT NOCOPY VARCHAR2

Line 212: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_GRP_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,

208: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
209: P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,
210: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
211: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
212: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_GRP_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
213: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
214: X_MSG_COUNT OUT NOCOPY NUMBER,
215: X_MSG_DATA OUT NOCOPY VARCHAR2
216: ) IS

Line 220: L_OBJECT_VERSION_NUMBER JTF_RS_GRP_RELATIONS.OBJECT_VERSION_NUMBER%TYPE := P_OBJECT_VERSION_NUM;

216: ) IS
217: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_RESOURCE_GROUP_RELATE';
218: l_api_version CONSTANT NUMBER :=1.0;
219:
220: L_OBJECT_VERSION_NUMBER JTF_RS_GRP_RELATIONS.OBJECT_VERSION_NUMBER%TYPE := P_OBJECT_VERSION_NUM;
221: l_group_relate_id JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE := P_GROUP_RELATE_ID;
222: l_return_status VARCHAR2(200);
223: l_msg_count NUMBER;
224: l_msg_data VARCHAR2(200);

Line 221: l_group_relate_id JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE := P_GROUP_RELATE_ID;

217: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_RESOURCE_GROUP_RELATE';
218: l_api_version CONSTANT NUMBER :=1.0;
219:
220: L_OBJECT_VERSION_NUMBER JTF_RS_GRP_RELATIONS.OBJECT_VERSION_NUMBER%TYPE := P_OBJECT_VERSION_NUM;
221: l_group_relate_id JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE := P_GROUP_RELATE_ID;
222: l_return_status VARCHAR2(200);
223: l_msg_count NUMBER;
224: l_msg_data VARCHAR2(200);
225: l_rowid VARCHAR2(200);

Line 234: CURSOR val_grp_rel_cur(l_group_relate_id JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE)

230: l_date Date;
231: l_user_id Number;
232: l_login_id Number;
233:
234: CURSOR val_grp_rel_cur(l_group_relate_id JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE)
235: IS
236: SELECT 'X'
237: FROM jtf_rs_grp_relations
238: where group_relate_id = l_group_relate_id;

Line 237: FROM jtf_rs_grp_relations

233:
234: CURSOR val_grp_rel_cur(l_group_relate_id JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE)
235: IS
236: SELECT 'X'
237: FROM jtf_rs_grp_relations
238: where group_relate_id = l_group_relate_id;
239:
240: dummy VARCHAR2(30);
241:

Line 340: P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,

336: PROCEDURE delete_resource_group_relate
337: (P_API_VERSION IN NUMBER,
338: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
339: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
340: P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,
341: P_OBJECT_VERSION_NUM IN JTF_RS_GROUPS_VL.OBJECT_VERSION_NUMBER%TYPE,
342: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
343: X_MSG_COUNT OUT NOCOPY NUMBER,
344: X_MSG_DATA OUT NOCOPY VARCHAR2

Line 350: L_OBJECT_VERSION_NUMBER JTF_RS_GRP_RELATIONS.OBJECT_VERSION_NUMBER%TYPE := P_OBJECT_VERSION_NUM;

346:
347: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_RESOURCE_GROUP_RELATE';
348: l_api_version CONSTANT NUMBER :=1.0;
349:
350: L_OBJECT_VERSION_NUMBER JTF_RS_GRP_RELATIONS.OBJECT_VERSION_NUMBER%TYPE := P_OBJECT_VERSION_NUM;
351: l_group_relate_id JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE;
352:
353: l_return_status VARCHAR2(200);
354: l_msg_count NUMBER;

Line 351: l_group_relate_id JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE;

347: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_RESOURCE_GROUP_RELATE';
348: l_api_version CONSTANT NUMBER :=1.0;
349:
350: L_OBJECT_VERSION_NUMBER JTF_RS_GRP_RELATIONS.OBJECT_VERSION_NUMBER%TYPE := P_OBJECT_VERSION_NUM;
351: l_group_relate_id JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE;
352:
353: l_return_status VARCHAR2(200);
354: l_msg_count NUMBER;
355: l_msg_data VARCHAR2(200);

Line 365: CURSOR val_grp_rel_cur(l_group_relate_id JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE)

361: l_date Date;
362: l_user_id Number;
363: l_login_id Number;
364:
365: CURSOR val_grp_rel_cur(l_group_relate_id JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE)
366: IS
367: SELECT 'X'
368: FROM jtf_rs_grp_relations
369: where group_relate_id = l_group_relate_id;

Line 368: FROM jtf_rs_grp_relations

364:
365: CURSOR val_grp_rel_cur(l_group_relate_id JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE)
366: IS
367: SELECT 'X'
368: FROM jtf_rs_grp_relations
369: where group_relate_id = l_group_relate_id;
370:
371: dummy VARCHAR2(30);
372: