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_ROLE_RELATE_IUHK dependencies on JTF_RS_ROLE_RELATIONS

Line 12: (P_ROLE_RESOURCE_TYPE JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_TYPE%TYPE,

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 ,

Line 13: P_ROLE_RESOURCE_ID JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%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,

Line 14: P_ROLE_ID JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE,

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,

Line 15: P_START_DATE_ACTIVE JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,

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

Line 16: P_END_DATE_ACTIVE JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE ,

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: );

Line 25: P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,

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,

Line 26: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,

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,

Line 27: P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,

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

Line 28: P_OBJECT_VERSION_NUM IN JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,

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: );

Line 36: (P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,

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

Line 37: P_OBJECT_VERSION_NUM IN JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,

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: );

Line 44: (P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,

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,

Line 45: P_ROLE_RESOURCE_TYPE IN JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_TYPE%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,

Line 46: P_ROLE_RESOURCE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,

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,

Line 47: P_ROLE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE,

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,

Line 48: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,

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

Line 49: P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT NULL,

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: );

Line 58: P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,

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,

Line 59: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,

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,

Line 60: P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,

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

Line 61: P_OBJECT_VERSION_NUM IN JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,

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: );

Line 69: (P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,

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

Line 70: P_OBJECT_VERSION_NUM IN JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,

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: );