8:
9: /*for create resource role relate */
10:
11: PROCEDURE create_res_role_relate_pre
12: (P_ROLE_RESOURCE_TYPE JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_TYPE%TYPE,
13: P_ROLE_RESOURCE_ID JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,
14: P_ROLE_ID JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE,
15: P_START_DATE_ACTIVE JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
16: P_END_DATE_ACTIVE JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE ,
9: /*for create resource role relate */
10:
11: PROCEDURE create_res_role_relate_pre
12: (P_ROLE_RESOURCE_TYPE JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_TYPE%TYPE,
13: P_ROLE_RESOURCE_ID JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,
14: P_ROLE_ID JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE,
15: P_START_DATE_ACTIVE JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
16: P_END_DATE_ACTIVE JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE ,
17: P_DATA OUT NOCOPY VARCHAR2,
10:
11: PROCEDURE create_res_role_relate_pre
12: (P_ROLE_RESOURCE_TYPE JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_TYPE%TYPE,
13: P_ROLE_RESOURCE_ID JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,
14: P_ROLE_ID JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE,
15: P_START_DATE_ACTIVE JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
16: P_END_DATE_ACTIVE JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE ,
17: P_DATA OUT NOCOPY VARCHAR2,
18: P_COUNT OUT NOCOPY NUMBER,
11: PROCEDURE create_res_role_relate_pre
12: (P_ROLE_RESOURCE_TYPE JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_TYPE%TYPE,
13: P_ROLE_RESOURCE_ID JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,
14: P_ROLE_ID JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE,
15: P_START_DATE_ACTIVE JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
16: P_END_DATE_ACTIVE JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE ,
17: P_DATA OUT NOCOPY VARCHAR2,
18: P_COUNT OUT NOCOPY NUMBER,
19: P_RETURN_CODE OUT NOCOPY VARCHAR2
12: (P_ROLE_RESOURCE_TYPE JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_TYPE%TYPE,
13: P_ROLE_RESOURCE_ID JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,
14: P_ROLE_ID JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE,
15: P_START_DATE_ACTIVE JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
16: P_END_DATE_ACTIVE JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE ,
17: P_DATA OUT NOCOPY VARCHAR2,
18: P_COUNT OUT NOCOPY NUMBER,
19: P_RETURN_CODE OUT NOCOPY VARCHAR2
20: );
21:
22:
23: PROCEDURE update_res_role_relate_pre
24: (
25: P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
26: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
27: P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
28: P_OBJECT_VERSION_NUM IN JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
29: P_DATA OUT NOCOPY VARCHAR2,
22:
23: PROCEDURE update_res_role_relate_pre
24: (
25: P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
26: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
27: P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
28: P_OBJECT_VERSION_NUM IN JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
29: P_DATA OUT NOCOPY VARCHAR2,
30: P_COUNT OUT NOCOPY NUMBER,
23: PROCEDURE update_res_role_relate_pre
24: (
25: P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
26: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
27: P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
28: P_OBJECT_VERSION_NUM IN JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
29: P_DATA OUT NOCOPY VARCHAR2,
30: P_COUNT OUT NOCOPY NUMBER,
31: P_RETURN_CODE OUT NOCOPY VARCHAR2
24: (
25: P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
26: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
27: P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
28: P_OBJECT_VERSION_NUM IN JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
29: P_DATA OUT NOCOPY VARCHAR2,
30: P_COUNT OUT NOCOPY NUMBER,
31: P_RETURN_CODE OUT NOCOPY VARCHAR2
32: );
32: );
33:
34:
35: PROCEDURE delete_res_role_relate_pre
36: (P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
37: P_OBJECT_VERSION_NUM IN JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
38: P_DATA OUT NOCOPY VARCHAR2,
39: P_COUNT OUT NOCOPY NUMBER,
40: P_RETURN_CODE OUT NOCOPY VARCHAR2
33:
34:
35: PROCEDURE delete_res_role_relate_pre
36: (P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
37: P_OBJECT_VERSION_NUM IN JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
38: P_DATA OUT NOCOPY VARCHAR2,
39: P_COUNT OUT NOCOPY NUMBER,
40: P_RETURN_CODE OUT NOCOPY VARCHAR2
41: );
40: P_RETURN_CODE OUT NOCOPY VARCHAR2
41: );
42:
43: PROCEDURE create_res_role_relate_post
44: (P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
45: P_ROLE_RESOURCE_TYPE IN JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_TYPE%TYPE,
46: P_ROLE_RESOURCE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,
47: P_ROLE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE,
48: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
41: );
42:
43: PROCEDURE create_res_role_relate_post
44: (P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
45: P_ROLE_RESOURCE_TYPE IN JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_TYPE%TYPE,
46: P_ROLE_RESOURCE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,
47: P_ROLE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE,
48: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
49: P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
42:
43: PROCEDURE create_res_role_relate_post
44: (P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
45: P_ROLE_RESOURCE_TYPE IN JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_TYPE%TYPE,
46: P_ROLE_RESOURCE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,
47: P_ROLE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE,
48: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
49: P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
50: P_DATA OUT NOCOPY VARCHAR2,
43: PROCEDURE create_res_role_relate_post
44: (P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
45: P_ROLE_RESOURCE_TYPE IN JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_TYPE%TYPE,
46: P_ROLE_RESOURCE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,
47: P_ROLE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE,
48: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
49: P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
50: P_DATA OUT NOCOPY VARCHAR2,
51: P_COUNT OUT NOCOPY NUMBER,
44: (P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
45: P_ROLE_RESOURCE_TYPE IN JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_TYPE%TYPE,
46: P_ROLE_RESOURCE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,
47: P_ROLE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE,
48: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
49: P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
50: P_DATA OUT NOCOPY VARCHAR2,
51: P_COUNT OUT NOCOPY NUMBER,
52: P_RETURN_CODE OUT NOCOPY VARCHAR2
45: P_ROLE_RESOURCE_TYPE IN JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_TYPE%TYPE,
46: P_ROLE_RESOURCE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,
47: P_ROLE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE,
48: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
49: P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
50: P_DATA OUT NOCOPY VARCHAR2,
51: P_COUNT OUT NOCOPY NUMBER,
52: P_RETURN_CODE OUT NOCOPY VARCHAR2
53: );
54:
55:
56: PROCEDURE update_res_role_relate_post
57: (
58: P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
59: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
60: P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
61: P_OBJECT_VERSION_NUM IN JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
62: P_DATA OUT NOCOPY VARCHAR2,
55:
56: PROCEDURE update_res_role_relate_post
57: (
58: P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
59: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
60: P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
61: P_OBJECT_VERSION_NUM IN JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
62: P_DATA OUT NOCOPY VARCHAR2,
63: P_COUNT OUT NOCOPY NUMBER,
56: PROCEDURE update_res_role_relate_post
57: (
58: P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
59: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
60: P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
61: P_OBJECT_VERSION_NUM IN JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
62: P_DATA OUT NOCOPY VARCHAR2,
63: P_COUNT OUT NOCOPY NUMBER,
64: P_RETURN_CODE OUT NOCOPY VARCHAR2
57: (
58: P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
59: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
60: P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
61: P_OBJECT_VERSION_NUM IN JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
62: P_DATA OUT NOCOPY VARCHAR2,
63: P_COUNT OUT NOCOPY NUMBER,
64: P_RETURN_CODE OUT NOCOPY VARCHAR2
65: );
65: );
66:
67:
68: PROCEDURE delete_res_role_relate_post
69: (P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
70: P_OBJECT_VERSION_NUM IN JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
71: P_DATA OUT NOCOPY VARCHAR2,
72: P_COUNT OUT NOCOPY NUMBER,
73: P_RETURN_CODE OUT NOCOPY VARCHAR2
66:
67:
68: PROCEDURE delete_res_role_relate_post
69: (P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
70: P_OBJECT_VERSION_NUM IN JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
71: P_DATA OUT NOCOPY VARCHAR2,
72: P_COUNT OUT NOCOPY NUMBER,
73: P_RETURN_CODE OUT NOCOPY VARCHAR2
74: );