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,
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,
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
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: );
18: );
19:
20:
21: PROCEDURE update_res_group_relate_pre
22: (P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,
23: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
24: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
25: P_OBJECT_VERSION_NUM IN JTF_RS_GRP_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
26: P_DATA OUT NOCOPY VARCHAR2,
19:
20:
21: PROCEDURE update_res_group_relate_pre
22: (P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,
23: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
24: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
25: P_OBJECT_VERSION_NUM IN JTF_RS_GRP_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
26: P_DATA OUT NOCOPY VARCHAR2,
27: P_COUNT OUT NOCOPY NUMBER,
20:
21: PROCEDURE update_res_group_relate_pre
22: (P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,
23: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
24: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
25: P_OBJECT_VERSION_NUM IN JTF_RS_GRP_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
26: P_DATA OUT NOCOPY VARCHAR2,
27: P_COUNT OUT NOCOPY NUMBER,
28: P_RETURN_CODE OUT NOCOPY VARCHAR2
21: PROCEDURE update_res_group_relate_pre
22: (P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,
23: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
24: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
25: P_OBJECT_VERSION_NUM IN JTF_RS_GRP_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
26: P_DATA OUT NOCOPY VARCHAR2,
27: P_COUNT OUT NOCOPY NUMBER,
28: P_RETURN_CODE OUT NOCOPY VARCHAR2
29: );
29: );
30:
31:
32: PROCEDURE delete_res_group_relate_pre
33: (P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,
34: P_OBJECT_VERSION_NUM IN JTF_RS_GROUPS_VL.OBJECT_VERSION_NUMBER%TYPE,
35: P_DATA OUT NOCOPY VARCHAR2,
36: P_COUNT OUT NOCOPY NUMBER,
37: P_RETURN_CODE OUT NOCOPY VARCHAR2
37: P_RETURN_CODE OUT NOCOPY VARCHAR2
38: );
39:
40: PROCEDURE create_res_group_relate_post
41: (P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,
42: P_GROUP_ID IN JTF_RS_GROUPS_B.GROUP_ID%TYPE,
43: P_RELATED_GROUP_ID IN JTF_RS_GRP_RELATIONS.RELATED_GROUP_ID%TYPE,
44: P_RELATION_TYPE IN JTF_RS_GRP_RELATIONS.RELATION_TYPE%TYPE,
45: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
39:
40: PROCEDURE create_res_group_relate_post
41: (P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,
42: P_GROUP_ID IN JTF_RS_GROUPS_B.GROUP_ID%TYPE,
43: P_RELATED_GROUP_ID IN JTF_RS_GRP_RELATIONS.RELATED_GROUP_ID%TYPE,
44: P_RELATION_TYPE IN JTF_RS_GRP_RELATIONS.RELATION_TYPE%TYPE,
45: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
46: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
47: P_DATA OUT NOCOPY VARCHAR2,
40: PROCEDURE create_res_group_relate_post
41: (P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,
42: P_GROUP_ID IN JTF_RS_GROUPS_B.GROUP_ID%TYPE,
43: P_RELATED_GROUP_ID IN JTF_RS_GRP_RELATIONS.RELATED_GROUP_ID%TYPE,
44: P_RELATION_TYPE IN JTF_RS_GRP_RELATIONS.RELATION_TYPE%TYPE,
45: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
46: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
47: P_DATA OUT NOCOPY VARCHAR2,
48: P_COUNT OUT NOCOPY NUMBER,
41: (P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,
42: P_GROUP_ID IN JTF_RS_GROUPS_B.GROUP_ID%TYPE,
43: P_RELATED_GROUP_ID IN JTF_RS_GRP_RELATIONS.RELATED_GROUP_ID%TYPE,
44: P_RELATION_TYPE IN JTF_RS_GRP_RELATIONS.RELATION_TYPE%TYPE,
45: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
46: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
47: P_DATA OUT NOCOPY VARCHAR2,
48: P_COUNT OUT NOCOPY NUMBER,
49: P_RETURN_CODE OUT NOCOPY VARCHAR2
42: P_GROUP_ID IN JTF_RS_GROUPS_B.GROUP_ID%TYPE,
43: P_RELATED_GROUP_ID IN JTF_RS_GRP_RELATIONS.RELATED_GROUP_ID%TYPE,
44: P_RELATION_TYPE IN JTF_RS_GRP_RELATIONS.RELATION_TYPE%TYPE,
45: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
46: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
47: P_DATA OUT NOCOPY VARCHAR2,
48: P_COUNT OUT NOCOPY NUMBER,
49: P_RETURN_CODE OUT NOCOPY VARCHAR2
50: );
50: );
51:
52:
53: PROCEDURE update_res_group_relate_post
54: (P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,
55: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
56: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
57: P_OBJECT_VERSION_NUM IN JTF_RS_GRP_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
58: P_DATA OUT NOCOPY VARCHAR2,
51:
52:
53: PROCEDURE update_res_group_relate_post
54: (P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,
55: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
56: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
57: P_OBJECT_VERSION_NUM IN JTF_RS_GRP_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
58: P_DATA OUT NOCOPY VARCHAR2,
59: P_COUNT OUT NOCOPY NUMBER,
52:
53: PROCEDURE update_res_group_relate_post
54: (P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,
55: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
56: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
57: P_OBJECT_VERSION_NUM IN JTF_RS_GRP_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
58: P_DATA OUT NOCOPY VARCHAR2,
59: P_COUNT OUT NOCOPY NUMBER,
60: P_RETURN_CODE OUT NOCOPY VARCHAR2
53: PROCEDURE update_res_group_relate_post
54: (P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,
55: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
56: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
57: P_OBJECT_VERSION_NUM IN JTF_RS_GRP_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
58: P_DATA OUT NOCOPY VARCHAR2,
59: P_COUNT OUT NOCOPY NUMBER,
60: P_RETURN_CODE OUT NOCOPY VARCHAR2
61: );
61: );
62:
63:
64: PROCEDURE delete_res_group_relate_post
65: (P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,
66: P_OBJECT_VERSION_NUM IN JTF_RS_GROUPS_VL.OBJECT_VERSION_NUMBER%TYPE,
67: P_DATA OUT NOCOPY VARCHAR2,
68: P_COUNT OUT NOCOPY NUMBER,
69: P_RETURN_CODE OUT NOCOPY VARCHAR2