APPS.JTF_RS_GROUP_RELATE_IUHK dependencies on JTF_RS_GRP_RELATIONS

Line 11: P_RELATED_GROUP_ID IN JTF_RS_GRP_RELATIONS.RELATED_GROUP_ID%TYPE,

7:
8:
9: PROCEDURE create_res_group_relate_pre
10: (P_GROUP_ID IN JTF_RS_GROUPS_B.GROUP_ID%TYPE,
11: P_RELATED_GROUP_ID IN JTF_RS_GRP_RELATIONS.RELATED_GROUP_ID%TYPE,
12: P_RELATION_TYPE IN JTF_RS_GRP_RELATIONS.RELATION_TYPE%TYPE,
13: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
14: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
15: P_DATA OUT NOCOPY VARCHAR2,

Line 12: P_RELATION_TYPE IN JTF_RS_GRP_RELATIONS.RELATION_TYPE%TYPE,

8:
9: PROCEDURE create_res_group_relate_pre
10: (P_GROUP_ID IN JTF_RS_GROUPS_B.GROUP_ID%TYPE,
11: P_RELATED_GROUP_ID IN JTF_RS_GRP_RELATIONS.RELATED_GROUP_ID%TYPE,
12: P_RELATION_TYPE IN JTF_RS_GRP_RELATIONS.RELATION_TYPE%TYPE,
13: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
14: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
15: P_DATA OUT NOCOPY VARCHAR2,
16: P_COUNT OUT NOCOPY NUMBER,

Line 13: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,

9: PROCEDURE create_res_group_relate_pre
10: (P_GROUP_ID IN JTF_RS_GROUPS_B.GROUP_ID%TYPE,
11: P_RELATED_GROUP_ID IN JTF_RS_GRP_RELATIONS.RELATED_GROUP_ID%TYPE,
12: P_RELATION_TYPE IN JTF_RS_GRP_RELATIONS.RELATION_TYPE%TYPE,
13: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
14: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
15: P_DATA OUT NOCOPY VARCHAR2,
16: P_COUNT OUT NOCOPY NUMBER,
17: P_RETURN_CODE OUT NOCOPY VARCHAR2

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

10: (P_GROUP_ID IN JTF_RS_GROUPS_B.GROUP_ID%TYPE,
11: P_RELATED_GROUP_ID IN JTF_RS_GRP_RELATIONS.RELATED_GROUP_ID%TYPE,
12: P_RELATION_TYPE IN JTF_RS_GRP_RELATIONS.RELATION_TYPE%TYPE,
13: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
14: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
15: P_DATA OUT NOCOPY VARCHAR2,
16: P_COUNT OUT NOCOPY NUMBER,
17: P_RETURN_CODE OUT NOCOPY VARCHAR2
18: )

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

22: END;
23:
24:
25: PROCEDURE update_res_group_relate_pre
26: (P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,
27: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
28: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
29: P_OBJECT_VERSION_NUM IN JTF_RS_GRP_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
30: P_DATA OUT NOCOPY VARCHAR2,

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

23:
24:
25: PROCEDURE update_res_group_relate_pre
26: (P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,
27: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
28: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
29: P_OBJECT_VERSION_NUM IN JTF_RS_GRP_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
30: P_DATA OUT NOCOPY VARCHAR2,
31: P_COUNT OUT NOCOPY NUMBER,

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

24:
25: PROCEDURE update_res_group_relate_pre
26: (P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,
27: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
28: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
29: P_OBJECT_VERSION_NUM IN JTF_RS_GRP_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
30: P_DATA OUT NOCOPY VARCHAR2,
31: P_COUNT OUT NOCOPY NUMBER,
32: P_RETURN_CODE OUT NOCOPY VARCHAR2

Line 29: P_OBJECT_VERSION_NUM IN JTF_RS_GRP_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,

25: PROCEDURE update_res_group_relate_pre
26: (P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,
27: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
28: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
29: P_OBJECT_VERSION_NUM IN JTF_RS_GRP_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
30: P_DATA OUT NOCOPY VARCHAR2,
31: P_COUNT OUT NOCOPY NUMBER,
32: P_RETURN_CODE OUT NOCOPY VARCHAR2
33: )

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

37: END;
38:
39:
40: PROCEDURE delete_res_group_relate_pre
41: (P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,
42: P_OBJECT_VERSION_NUM IN JTF_RS_GROUPS_VL.OBJECT_VERSION_NUMBER%TYPE,
43: P_DATA OUT NOCOPY VARCHAR2,
44: P_COUNT OUT NOCOPY NUMBER,
45: P_RETURN_CODE OUT NOCOPY VARCHAR2

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

49: NULL;
50: END;
51:
52: PROCEDURE create_res_group_relate_post
53: (P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,
54: P_GROUP_ID IN JTF_RS_GROUPS_B.GROUP_ID%TYPE,
55: P_RELATED_GROUP_ID IN JTF_RS_GRP_RELATIONS.RELATED_GROUP_ID%TYPE,
56: P_RELATION_TYPE IN JTF_RS_GRP_RELATIONS.RELATION_TYPE%TYPE,
57: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,

Line 55: P_RELATED_GROUP_ID IN JTF_RS_GRP_RELATIONS.RELATED_GROUP_ID%TYPE,

51:
52: PROCEDURE create_res_group_relate_post
53: (P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,
54: P_GROUP_ID IN JTF_RS_GROUPS_B.GROUP_ID%TYPE,
55: P_RELATED_GROUP_ID IN JTF_RS_GRP_RELATIONS.RELATED_GROUP_ID%TYPE,
56: P_RELATION_TYPE IN JTF_RS_GRP_RELATIONS.RELATION_TYPE%TYPE,
57: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
58: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
59: P_DATA OUT NOCOPY VARCHAR2,

Line 56: P_RELATION_TYPE IN JTF_RS_GRP_RELATIONS.RELATION_TYPE%TYPE,

52: PROCEDURE create_res_group_relate_post
53: (P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,
54: P_GROUP_ID IN JTF_RS_GROUPS_B.GROUP_ID%TYPE,
55: P_RELATED_GROUP_ID IN JTF_RS_GRP_RELATIONS.RELATED_GROUP_ID%TYPE,
56: P_RELATION_TYPE IN JTF_RS_GRP_RELATIONS.RELATION_TYPE%TYPE,
57: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
58: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
59: P_DATA OUT NOCOPY VARCHAR2,
60: P_COUNT OUT NOCOPY NUMBER,

Line 57: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,

53: (P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,
54: P_GROUP_ID IN JTF_RS_GROUPS_B.GROUP_ID%TYPE,
55: P_RELATED_GROUP_ID IN JTF_RS_GRP_RELATIONS.RELATED_GROUP_ID%TYPE,
56: P_RELATION_TYPE IN JTF_RS_GRP_RELATIONS.RELATION_TYPE%TYPE,
57: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
58: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
59: P_DATA OUT NOCOPY VARCHAR2,
60: P_COUNT OUT NOCOPY NUMBER,
61: P_RETURN_CODE OUT NOCOPY VARCHAR2

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

54: P_GROUP_ID IN JTF_RS_GROUPS_B.GROUP_ID%TYPE,
55: P_RELATED_GROUP_ID IN JTF_RS_GRP_RELATIONS.RELATED_GROUP_ID%TYPE,
56: P_RELATION_TYPE IN JTF_RS_GRP_RELATIONS.RELATION_TYPE%TYPE,
57: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
58: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
59: P_DATA OUT NOCOPY VARCHAR2,
60: P_COUNT OUT NOCOPY NUMBER,
61: P_RETURN_CODE OUT NOCOPY VARCHAR2
62: )

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

66: END;
67:
68:
69: PROCEDURE update_res_group_relate_post
70: (P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,
71: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
72: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
73: P_OBJECT_VERSION_NUM IN JTF_RS_GRP_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
74: P_DATA OUT NOCOPY VARCHAR2,

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

67:
68:
69: PROCEDURE update_res_group_relate_post
70: (P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,
71: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
72: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
73: P_OBJECT_VERSION_NUM IN JTF_RS_GRP_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
74: P_DATA OUT NOCOPY VARCHAR2,
75: P_COUNT OUT NOCOPY NUMBER,

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

68:
69: PROCEDURE update_res_group_relate_post
70: (P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,
71: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
72: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
73: P_OBJECT_VERSION_NUM IN JTF_RS_GRP_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
74: P_DATA OUT NOCOPY VARCHAR2,
75: P_COUNT OUT NOCOPY NUMBER,
76: P_RETURN_CODE OUT NOCOPY VARCHAR2

Line 73: P_OBJECT_VERSION_NUM IN JTF_RS_GRP_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,

69: PROCEDURE update_res_group_relate_post
70: (P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,
71: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
72: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
73: P_OBJECT_VERSION_NUM IN JTF_RS_GRP_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
74: P_DATA OUT NOCOPY VARCHAR2,
75: P_COUNT OUT NOCOPY NUMBER,
76: P_RETURN_CODE OUT NOCOPY VARCHAR2
77: )

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

81: END;
82:
83:
84: PROCEDURE delete_res_group_relate_post
85: (P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,
86: P_OBJECT_VERSION_NUM IN JTF_RS_GROUPS_VL.OBJECT_VERSION_NUMBER%TYPE,
87: P_DATA OUT NOCOPY VARCHAR2,
88: P_COUNT OUT NOCOPY NUMBER,
89: P_RETURN_CODE OUT NOCOPY VARCHAR2