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

Line 55: P_ROLE_RESOURCE_TYPE IN JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_TYPE%TYPE,

51: PROCEDURE create_resource_role_relate
52: (P_API_VERSION IN NUMBER,
53: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
54: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
55: P_ROLE_RESOURCE_TYPE IN JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_TYPE%TYPE,
56: P_ROLE_RESOURCE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,
57: P_ROLE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE,
58: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
59: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE ,

Line 56: P_ROLE_RESOURCE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,

52: (P_API_VERSION IN NUMBER,
53: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
54: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
55: P_ROLE_RESOURCE_TYPE IN JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_TYPE%TYPE,
56: P_ROLE_RESOURCE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,
57: P_ROLE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE,
58: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
59: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE ,
60: P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT NULL,

Line 57: P_ROLE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE,

53: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
54: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
55: P_ROLE_RESOURCE_TYPE IN JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_TYPE%TYPE,
56: P_ROLE_RESOURCE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,
57: P_ROLE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE,
58: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
59: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE ,
60: P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
61: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 59: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE ,

55: P_ROLE_RESOURCE_TYPE IN JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_TYPE%TYPE,
56: P_ROLE_RESOURCE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,
57: P_ROLE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE,
58: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
59: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE ,
60: P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
61: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
62: X_MSG_COUNT OUT NOCOPY NUMBER,
63: X_MSG_DATA OUT NOCOPY VARCHAR2,

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

56: P_ROLE_RESOURCE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,
57: P_ROLE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE,
58: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
59: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE ,
60: P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
61: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
62: X_MSG_COUNT OUT NOCOPY NUMBER,
63: X_MSG_DATA OUT NOCOPY VARCHAR2,
64: X_ROLE_RELATE_ID OUT NOCOPY JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE

Line 64: X_ROLE_RELATE_ID OUT NOCOPY JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE

60: P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
61: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
62: X_MSG_COUNT OUT NOCOPY NUMBER,
63: X_MSG_DATA OUT NOCOPY VARCHAR2,
64: X_ROLE_RELATE_ID OUT NOCOPY JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE
65: );
66:
67:
68: /* Procedure to update the resource roles

Line 79: * @param p_object_version_num The object version number of the role relation derives from the jtf_rs_role_relations table.

75: * @param p_commit Commit
76: * @param p_role_relate_id Role Relation Identifier
77: * @param p_start_date_active Date on which the role relation becomes active.
78: * @param p_end_date_active Date on which the role relation is no longer active.
79: * @param p_object_version_num The object version number of the role relation derives from the jtf_rs_role_relations table.
80: * @param x_return_status Output parameter for return status
81: * @param x_msg_count Output parameter for number of user messages from this procedure
82: * @param x_msg_data Output parameter containing last user message from this procedure
83: * @rep:scope internal

Line 92: P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,

88: PROCEDURE update_resource_role_relate
89: (P_API_VERSION IN NUMBER,
90: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
91: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
92: P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
93: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
94: P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
95: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
96: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

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

89: (P_API_VERSION IN NUMBER,
90: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
91: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
92: P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
93: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
94: P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
95: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
96: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
97: X_MSG_COUNT OUT NOCOPY NUMBER,

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

90: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
91: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
92: P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
93: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
94: P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
95: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
96: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
97: X_MSG_COUNT OUT NOCOPY NUMBER,
98: X_MSG_DATA OUT NOCOPY VARCHAR2

Line 95: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,

91: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
92: P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
93: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
94: P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
95: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
96: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
97: X_MSG_COUNT OUT NOCOPY NUMBER,
98: X_MSG_DATA OUT NOCOPY VARCHAR2
99: );

Line 111: * @param p_object_version_num The object version number of the role relation derives from the jtf_rs_role_relations table.

107: * @param p_api_version API version
108: * @param p_init_msg_list Initialization of the message list
109: * @param p_commit Commit
110: * @param p_role_relate_id Role Relation Identifier
111: * @param p_object_version_num The object version number of the role relation derives from the jtf_rs_role_relations table.
112: * @param x_return_status Output parameter for return status
113: * @param x_msg_count Output parameter for number of user messages from this procedure
114: * @param x_msg_data Output parameter containing last user message from this procedure
115: * @rep:scope internal

Line 124: P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,

120: PROCEDURE delete_resource_role_relate
121: (P_API_VERSION IN NUMBER,
122: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
123: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
124: P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
125: P_OBJECT_VERSION_NUM IN JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
126: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
127: X_MSG_COUNT OUT NOCOPY NUMBER,
128: X_MSG_DATA OUT NOCOPY VARCHAR2

Line 125: P_OBJECT_VERSION_NUM IN JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,

121: (P_API_VERSION IN NUMBER,
122: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
123: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
124: P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
125: P_OBJECT_VERSION_NUM IN JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
126: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
127: X_MSG_COUNT OUT NOCOPY NUMBER,
128: X_MSG_DATA OUT NOCOPY VARCHAR2
129: );