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 29: P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,

25:
26:
27: PROCEDURE update_res_role_relate_pre
28: (
29: P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
30: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
31: P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
32: P_OBJECT_VERSION_NUM IN JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
33: P_DATA OUT NOCOPY VARCHAR2,

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

26:
27: PROCEDURE update_res_role_relate_pre
28: (
29: P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
30: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
31: P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
32: P_OBJECT_VERSION_NUM IN JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
33: P_DATA OUT NOCOPY VARCHAR2,
34: P_COUNT OUT NOCOPY NUMBER,

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

27: PROCEDURE update_res_role_relate_pre
28: (
29: P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
30: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
31: P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
32: P_OBJECT_VERSION_NUM IN JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
33: P_DATA OUT NOCOPY VARCHAR2,
34: P_COUNT OUT NOCOPY NUMBER,
35: P_RETURN_CODE OUT NOCOPY VARCHAR2

Line 32: P_OBJECT_VERSION_NUM IN JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,

28: (
29: P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
30: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
31: P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
32: P_OBJECT_VERSION_NUM IN JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
33: P_DATA OUT NOCOPY VARCHAR2,
34: P_COUNT OUT NOCOPY NUMBER,
35: P_RETURN_CODE OUT NOCOPY VARCHAR2
36: )

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

40: END;
41:
42:
43: PROCEDURE delete_res_role_relate_pre
44: (P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
45: P_OBJECT_VERSION_NUM IN JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
46: P_DATA OUT NOCOPY VARCHAR2,
47: P_COUNT OUT NOCOPY NUMBER,
48: P_RETURN_CODE OUT NOCOPY VARCHAR2

Line 45: P_OBJECT_VERSION_NUM IN JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,

41:
42:
43: PROCEDURE delete_res_role_relate_pre
44: (P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
45: P_OBJECT_VERSION_NUM IN JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
46: P_DATA OUT NOCOPY VARCHAR2,
47: P_COUNT OUT NOCOPY NUMBER,
48: P_RETURN_CODE OUT NOCOPY VARCHAR2
49: )

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

53: END;
54:
55:
56: PROCEDURE create_res_role_relate_post
57: (P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
58: P_ROLE_RESOURCE_TYPE IN JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_TYPE%TYPE,
59: P_ROLE_RESOURCE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,
60: P_ROLE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE,
61: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,

Line 58: P_ROLE_RESOURCE_TYPE IN JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_TYPE%TYPE,

54:
55:
56: PROCEDURE create_res_role_relate_post
57: (P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
58: P_ROLE_RESOURCE_TYPE IN JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_TYPE%TYPE,
59: P_ROLE_RESOURCE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,
60: P_ROLE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE,
61: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
62: P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT NULL,

Line 59: P_ROLE_RESOURCE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,

55:
56: PROCEDURE create_res_role_relate_post
57: (P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
58: P_ROLE_RESOURCE_TYPE IN JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_TYPE%TYPE,
59: P_ROLE_RESOURCE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,
60: P_ROLE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE,
61: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
62: P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
63: P_DATA OUT NOCOPY VARCHAR2,

Line 60: P_ROLE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE,

56: PROCEDURE create_res_role_relate_post
57: (P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
58: P_ROLE_RESOURCE_TYPE IN JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_TYPE%TYPE,
59: P_ROLE_RESOURCE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,
60: P_ROLE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE,
61: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
62: P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
63: P_DATA OUT NOCOPY VARCHAR2,
64: P_COUNT OUT NOCOPY NUMBER,

Line 61: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,

57: (P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
58: P_ROLE_RESOURCE_TYPE IN JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_TYPE%TYPE,
59: P_ROLE_RESOURCE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,
60: P_ROLE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE,
61: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
62: P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
63: P_DATA OUT NOCOPY VARCHAR2,
64: P_COUNT OUT NOCOPY NUMBER,
65: P_RETURN_CODE OUT NOCOPY VARCHAR2

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

58: P_ROLE_RESOURCE_TYPE IN JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_TYPE%TYPE,
59: P_ROLE_RESOURCE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,
60: P_ROLE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE,
61: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
62: P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
63: P_DATA OUT NOCOPY VARCHAR2,
64: P_COUNT OUT NOCOPY NUMBER,
65: P_RETURN_CODE OUT NOCOPY VARCHAR2
66: )

Line 76: P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,

72:
73:
74: PROCEDURE update_res_role_relate_post
75: (
76: P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
77: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
78: P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
79: P_OBJECT_VERSION_NUM IN JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
80: P_DATA OUT NOCOPY VARCHAR2,

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

73:
74: PROCEDURE update_res_role_relate_post
75: (
76: P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
77: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
78: P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
79: P_OBJECT_VERSION_NUM IN JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
80: P_DATA OUT NOCOPY VARCHAR2,
81: P_COUNT OUT NOCOPY NUMBER,

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

74: PROCEDURE update_res_role_relate_post
75: (
76: P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
77: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
78: P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
79: P_OBJECT_VERSION_NUM IN JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
80: P_DATA OUT NOCOPY VARCHAR2,
81: P_COUNT OUT NOCOPY NUMBER,
82: P_RETURN_CODE OUT NOCOPY VARCHAR2

Line 79: P_OBJECT_VERSION_NUM IN JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,

75: (
76: P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
77: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
78: P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
79: P_OBJECT_VERSION_NUM IN JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
80: P_DATA OUT NOCOPY VARCHAR2,
81: P_COUNT OUT NOCOPY NUMBER,
82: P_RETURN_CODE OUT NOCOPY VARCHAR2
83: )

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

88:
89:
90:
91: PROCEDURE delete_res_role_relate_post
92: (P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
93: P_OBJECT_VERSION_NUM IN JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
94: P_DATA OUT NOCOPY VARCHAR2,
95: P_COUNT OUT NOCOPY NUMBER,
96: P_RETURN_CODE OUT NOCOPY VARCHAR2

Line 93: P_OBJECT_VERSION_NUM IN JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,

89:
90:
91: PROCEDURE delete_res_role_relate_post
92: (P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
93: P_OBJECT_VERSION_NUM IN JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
94: P_DATA OUT NOCOPY VARCHAR2,
95: P_COUNT OUT NOCOPY NUMBER,
96: P_RETURN_CODE OUT NOCOPY VARCHAR2
97: )