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

Line 23: P_RELATED_GROUP_ID IN JTF_RS_GRP_RELATIONS.RELATED_GROUP_ID%TYPE,

19:
20:
21: PROCEDURE create_res_group_relate_pre
22: (P_GROUP_ID IN JTF_RS_GROUPS_B.GROUP_ID%TYPE,
23: P_RELATED_GROUP_ID IN JTF_RS_GRP_RELATIONS.RELATED_GROUP_ID%TYPE,
24: P_RELATION_TYPE IN JTF_RS_GRP_RELATIONS.RELATION_TYPE%TYPE,
25: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
26: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
27: P_DATA OUT NOCOPY VARCHAR2,

Line 24: P_RELATION_TYPE IN JTF_RS_GRP_RELATIONS.RELATION_TYPE%TYPE,

20:
21: PROCEDURE create_res_group_relate_pre
22: (P_GROUP_ID IN JTF_RS_GROUPS_B.GROUP_ID%TYPE,
23: P_RELATED_GROUP_ID IN JTF_RS_GRP_RELATIONS.RELATED_GROUP_ID%TYPE,
24: P_RELATION_TYPE IN JTF_RS_GRP_RELATIONS.RELATION_TYPE%TYPE,
25: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
26: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
27: P_DATA OUT NOCOPY VARCHAR2,
28: P_COUNT OUT NOCOPY NUMBER,

Line 25: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,

21: PROCEDURE create_res_group_relate_pre
22: (P_GROUP_ID IN JTF_RS_GROUPS_B.GROUP_ID%TYPE,
23: P_RELATED_GROUP_ID IN JTF_RS_GRP_RELATIONS.RELATED_GROUP_ID%TYPE,
24: P_RELATION_TYPE IN JTF_RS_GRP_RELATIONS.RELATION_TYPE%TYPE,
25: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
26: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
27: P_DATA OUT NOCOPY VARCHAR2,
28: P_COUNT OUT NOCOPY NUMBER,
29: P_RETURN_CODE OUT NOCOPY VARCHAR2

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

22: (P_GROUP_ID IN JTF_RS_GROUPS_B.GROUP_ID%TYPE,
23: P_RELATED_GROUP_ID IN JTF_RS_GRP_RELATIONS.RELATED_GROUP_ID%TYPE,
24: P_RELATION_TYPE IN JTF_RS_GRP_RELATIONS.RELATION_TYPE%TYPE,
25: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
26: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
27: P_DATA OUT NOCOPY VARCHAR2,
28: P_COUNT OUT NOCOPY NUMBER,
29: P_RETURN_CODE OUT NOCOPY VARCHAR2
30: ) IS

Line 37: (P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,

33: END create_res_group_relate_pre;
34:
35:
36: PROCEDURE update_res_group_relate_pre
37: (P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,
38: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
39: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
40: P_OBJECT_VERSION_NUM IN JTF_RS_GRP_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
41: P_DATA OUT NOCOPY VARCHAR2,

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

34:
35:
36: PROCEDURE update_res_group_relate_pre
37: (P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,
38: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
39: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
40: P_OBJECT_VERSION_NUM IN JTF_RS_GRP_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
41: P_DATA OUT NOCOPY VARCHAR2,
42: P_COUNT OUT NOCOPY NUMBER,

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

35:
36: PROCEDURE update_res_group_relate_pre
37: (P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,
38: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
39: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
40: P_OBJECT_VERSION_NUM IN JTF_RS_GRP_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
41: P_DATA OUT NOCOPY VARCHAR2,
42: P_COUNT OUT NOCOPY NUMBER,
43: P_RETURN_CODE OUT NOCOPY VARCHAR2

Line 40: P_OBJECT_VERSION_NUM IN JTF_RS_GRP_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,

36: PROCEDURE update_res_group_relate_pre
37: (P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,
38: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
39: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
40: P_OBJECT_VERSION_NUM IN JTF_RS_GRP_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
41: P_DATA OUT NOCOPY VARCHAR2,
42: P_COUNT OUT NOCOPY NUMBER,
43: P_RETURN_CODE OUT NOCOPY VARCHAR2
44: ) IS

Line 68: jtf_rs_grp_relations r

64: -- Do we need to make sure that the related group is also used by OSC
65: CURSOR group_info IS
66: SELECT r.start_date_active, r.end_date_active, r.group_id
67: FROM jtf_rs_group_usages u,
68: jtf_rs_grp_relations r
69: WHERE r.group_relate_id = p_group_relate_id
70: AND u.group_id = r.group_id AND u.usage = 'SALES_COMP';
71:
72: -- cursor to get the name of the group identified by p_group_id

Line 333: (P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,

329:
330: END update_res_group_relate_pre;
331:
332: PROCEDURE delete_res_group_relate_pre
333: (P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,
334: P_OBJECT_VERSION_NUM IN JTF_RS_GROUPS_VL.OBJECT_VERSION_NUMBER%TYPE,
335: P_DATA OUT NOCOPY VARCHAR2,
336: P_COUNT OUT NOCOPY NUMBER,
337: P_RETURN_CODE OUT NOCOPY VARCHAR2

Line 363: jtf_rs_grp_relations r

359: -- Do we need to make sure that the related group is also used by OSC
360: CURSOR group_info IS
361: SELECT r.start_date_active, r.end_date_active, r.group_id
362: FROM jtf_rs_group_usages u,
363: jtf_rs_grp_relations r
364: WHERE r.group_relate_id = p_group_relate_id
365: AND u.group_id = r.group_id AND u.usage = 'SALES_COMP';
366:
367: -- cursor to get the name of the group identified by p_group_id

Line 555: (P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,

551: );
552: END delete_res_group_relate_pre;
553:
554: PROCEDURE create_res_group_relate_post
555: (P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,
556: P_GROUP_ID IN JTF_RS_GROUPS_B.GROUP_ID%TYPE,
557: P_RELATED_GROUP_ID IN JTF_RS_GRP_RELATIONS.RELATED_GROUP_ID%TYPE,
558: P_RELATION_TYPE IN JTF_RS_GRP_RELATIONS.RELATION_TYPE%TYPE,
559: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,

Line 557: P_RELATED_GROUP_ID IN JTF_RS_GRP_RELATIONS.RELATED_GROUP_ID%TYPE,

553:
554: PROCEDURE create_res_group_relate_post
555: (P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,
556: P_GROUP_ID IN JTF_RS_GROUPS_B.GROUP_ID%TYPE,
557: P_RELATED_GROUP_ID IN JTF_RS_GRP_RELATIONS.RELATED_GROUP_ID%TYPE,
558: P_RELATION_TYPE IN JTF_RS_GRP_RELATIONS.RELATION_TYPE%TYPE,
559: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
560: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
561: P_DATA OUT NOCOPY VARCHAR2,

Line 558: P_RELATION_TYPE IN JTF_RS_GRP_RELATIONS.RELATION_TYPE%TYPE,

554: PROCEDURE create_res_group_relate_post
555: (P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,
556: P_GROUP_ID IN JTF_RS_GROUPS_B.GROUP_ID%TYPE,
557: P_RELATED_GROUP_ID IN JTF_RS_GRP_RELATIONS.RELATED_GROUP_ID%TYPE,
558: P_RELATION_TYPE IN JTF_RS_GRP_RELATIONS.RELATION_TYPE%TYPE,
559: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
560: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
561: P_DATA OUT NOCOPY VARCHAR2,
562: P_COUNT OUT NOCOPY NUMBER,

Line 559: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,

555: (P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,
556: P_GROUP_ID IN JTF_RS_GROUPS_B.GROUP_ID%TYPE,
557: P_RELATED_GROUP_ID IN JTF_RS_GRP_RELATIONS.RELATED_GROUP_ID%TYPE,
558: P_RELATION_TYPE IN JTF_RS_GRP_RELATIONS.RELATION_TYPE%TYPE,
559: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
560: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
561: P_DATA OUT NOCOPY VARCHAR2,
562: P_COUNT OUT NOCOPY NUMBER,
563: P_RETURN_CODE OUT NOCOPY VARCHAR2

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

556: P_GROUP_ID IN JTF_RS_GROUPS_B.GROUP_ID%TYPE,
557: P_RELATED_GROUP_ID IN JTF_RS_GRP_RELATIONS.RELATED_GROUP_ID%TYPE,
558: P_RELATION_TYPE IN JTF_RS_GRP_RELATIONS.RELATION_TYPE%TYPE,
559: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
560: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
561: P_DATA OUT NOCOPY VARCHAR2,
562: P_COUNT OUT NOCOPY NUMBER,
563: P_RETURN_CODE OUT NOCOPY VARCHAR2
564: ) IS

Line 781: (P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,

777: END create_res_group_relate_post;
778:
779:
780: PROCEDURE update_res_group_relate_post
781: (P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,
782: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
783: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
784: P_OBJECT_VERSION_NUM IN JTF_RS_GRP_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
785: P_DATA OUT NOCOPY VARCHAR2,

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

778:
779:
780: PROCEDURE update_res_group_relate_post
781: (P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,
782: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
783: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
784: P_OBJECT_VERSION_NUM IN JTF_RS_GRP_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
785: P_DATA OUT NOCOPY VARCHAR2,
786: P_COUNT OUT NOCOPY NUMBER,

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

779:
780: PROCEDURE update_res_group_relate_post
781: (P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,
782: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
783: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
784: P_OBJECT_VERSION_NUM IN JTF_RS_GRP_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
785: P_DATA OUT NOCOPY VARCHAR2,
786: P_COUNT OUT NOCOPY NUMBER,
787: P_RETURN_CODE OUT NOCOPY VARCHAR2

Line 784: P_OBJECT_VERSION_NUM IN JTF_RS_GRP_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,

780: PROCEDURE update_res_group_relate_post
781: (P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,
782: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
783: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
784: P_OBJECT_VERSION_NUM IN JTF_RS_GRP_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
785: P_DATA OUT NOCOPY VARCHAR2,
786: P_COUNT OUT NOCOPY NUMBER,
787: P_RETURN_CODE OUT NOCOPY VARCHAR2
788: ) IS

Line 1016: (P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,

1012: );
1013: END update_res_group_relate_post;
1014:
1015: PROCEDURE delete_res_group_relate_post
1016: (P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,
1017: P_OBJECT_VERSION_NUM IN JTF_RS_GROUPS_VL.OBJECT_VERSION_NUMBER%TYPE,
1018: P_DATA OUT NOCOPY VARCHAR2,
1019: P_COUNT OUT NOCOPY NUMBER,
1020: P_RETURN_CODE OUT NOCOPY VARCHAR2