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

24: PROCEDURE create_resource_role_relate
25: (P_API_VERSION IN NUMBER,
26: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
27: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
28: P_ROLE_RESOURCE_TYPE IN JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_TYPE%TYPE,
29: P_ROLE_RESOURCE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,
30: P_ROLE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE,
31: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
32: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,

Line 29: P_ROLE_RESOURCE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,

25: (P_API_VERSION IN NUMBER,
26: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
27: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
28: P_ROLE_RESOURCE_TYPE IN JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_TYPE%TYPE,
29: P_ROLE_RESOURCE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,
30: P_ROLE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE,
31: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
32: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
33: P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT NULL,

Line 30: P_ROLE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE,

26: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
27: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
28: P_ROLE_RESOURCE_TYPE IN JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_TYPE%TYPE,
29: P_ROLE_RESOURCE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,
30: P_ROLE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE,
31: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
32: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
33: P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
34: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 32: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,

28: P_ROLE_RESOURCE_TYPE IN JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_TYPE%TYPE,
29: P_ROLE_RESOURCE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,
30: P_ROLE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE,
31: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
32: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
33: P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
34: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
35: X_MSG_COUNT OUT NOCOPY NUMBER,
36: X_MSG_DATA OUT NOCOPY VARCHAR2,

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

29: P_ROLE_RESOURCE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,
30: P_ROLE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE,
31: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
32: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
33: P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
34: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
35: X_MSG_COUNT OUT NOCOPY NUMBER,
36: X_MSG_DATA OUT NOCOPY VARCHAR2,
37: X_ROLE_RELATE_ID OUT NOCOPY JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE

Line 37: X_ROLE_RELATE_ID OUT NOCOPY JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE

33: P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
34: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
35: X_MSG_COUNT OUT NOCOPY NUMBER,
36: X_MSG_DATA OUT NOCOPY VARCHAR2,
37: X_ROLE_RELATE_ID OUT NOCOPY JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE
38: ) IS
39:
40: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RESOURCE_ROLE_RELATE';
41: l_api_version CONSTANT NUMBER :=1.0;

Line 43: l_role_resource_type JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_TYPE%TYPE := 'X';

39:
40: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RESOURCE_ROLE_RELATE';
41: l_api_version CONSTANT NUMBER :=1.0;
42:
43: l_role_resource_type JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_TYPE%TYPE := 'X';
44: l_role_resource_id JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE := p_role_resource_id;
45: l_role_id JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE := p_role_id;
46: l_role_code JTF_RS_ROLES_B.ROLE_CODE%TYPE := p_role_code;
47: l_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE := p_start_date_active;

Line 44: l_role_resource_id JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE := p_role_resource_id;

40: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RESOURCE_ROLE_RELATE';
41: l_api_version CONSTANT NUMBER :=1.0;
42:
43: l_role_resource_type JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_TYPE%TYPE := 'X';
44: l_role_resource_id JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE := p_role_resource_id;
45: l_role_id JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE := p_role_id;
46: l_role_code JTF_RS_ROLES_B.ROLE_CODE%TYPE := p_role_code;
47: l_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE := p_start_date_active;
48: l_end_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE := p_end_date_active;

Line 45: l_role_id JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE := p_role_id;

41: l_api_version CONSTANT NUMBER :=1.0;
42:
43: l_role_resource_type JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_TYPE%TYPE := 'X';
44: l_role_resource_id JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE := p_role_resource_id;
45: l_role_id JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE := p_role_id;
46: l_role_code JTF_RS_ROLES_B.ROLE_CODE%TYPE := p_role_code;
47: l_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE := p_start_date_active;
48: l_end_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE := p_end_date_active;
49:

Line 47: l_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE := p_start_date_active;

43: l_role_resource_type JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_TYPE%TYPE := 'X';
44: l_role_resource_id JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE := p_role_resource_id;
45: l_role_id JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE := p_role_id;
46: l_role_code JTF_RS_ROLES_B.ROLE_CODE%TYPE := p_role_code;
47: l_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE := p_start_date_active;
48: l_end_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE := p_end_date_active;
49:
50: l_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE;
51: l_return_status VARCHAR2(200);

Line 48: l_end_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE := p_end_date_active;

44: l_role_resource_id JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE := p_role_resource_id;
45: l_role_id JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE := p_role_id;
46: l_role_code JTF_RS_ROLES_B.ROLE_CODE%TYPE := p_role_code;
47: l_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE := p_start_date_active;
48: l_end_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE := p_end_date_active;
49:
50: l_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE;
51: l_return_status VARCHAR2(200);
52: l_msg_count NUMBER;

Line 50: l_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE;

46: l_role_code JTF_RS_ROLES_B.ROLE_CODE%TYPE := p_role_code;
47: l_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE := p_start_date_active;
48: l_end_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE := p_end_date_active;
49:
50: l_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE;
51: l_return_status VARCHAR2(200);
52: l_msg_count NUMBER;
53: l_msg_data VARCHAR2(200);
54:

Line 250: P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,

246: PROCEDURE update_resource_role_relate
247: (P_API_VERSION IN NUMBER,
248: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
249: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
250: P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
251: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
252: P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE,
253: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
254: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 251: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,

247: (P_API_VERSION IN NUMBER,
248: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
249: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
250: P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
251: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
252: P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE,
253: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
254: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
255: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 252: P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE,

248: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
249: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
250: P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
251: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
252: P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE,
253: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
254: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
255: X_MSG_COUNT OUT NOCOPY NUMBER,
256: X_MSG_DATA OUT NOCOPY VARCHAR2

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

249: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
250: P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
251: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
252: P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE,
253: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
254: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
255: X_MSG_COUNT OUT NOCOPY NUMBER,
256: X_MSG_DATA OUT NOCOPY VARCHAR2
257: ) IS

Line 259: CURSOR role_relate_cur(l_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE)

255: X_MSG_COUNT OUT NOCOPY NUMBER,
256: X_MSG_DATA OUT NOCOPY VARCHAR2
257: ) IS
258:
259: CURSOR role_relate_cur(l_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE)
260: IS
261: SELECT role_relate_id,
262: object_version_number
263: FROM jtf_rs_role_relations

Line 263: FROM jtf_rs_role_relations

259: CURSOR role_relate_cur(l_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE)
260: IS
261: SELECT role_relate_id,
262: object_version_number
263: FROM jtf_rs_role_relations
264: WHERE role_relate_id = l_role_relate_id;
265:
266: role_relate_rec role_relate_cur%rowtype;
267:

Line 271: l_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE := p_start_date_active;

267:
268: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_RESOURCE_ROLE_RELATE';
269: l_api_version CONSTANT NUMBER :=1.0;
270:
271: l_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE := p_start_date_active;
272: l_end_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE := p_end_date_active;
273: l_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE := p_role_relate_id;
274:
275: l_object_version_number JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE := P_OBJECT_VERSION_NUM;

Line 272: l_end_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE := p_end_date_active;

268: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_RESOURCE_ROLE_RELATE';
269: l_api_version CONSTANT NUMBER :=1.0;
270:
271: l_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE := p_start_date_active;
272: l_end_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE := p_end_date_active;
273: l_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE := p_role_relate_id;
274:
275: l_object_version_number JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE := P_OBJECT_VERSION_NUM;
276: l_return_status VARCHAR2(200);

Line 273: l_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE := p_role_relate_id;

269: l_api_version CONSTANT NUMBER :=1.0;
270:
271: l_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE := p_start_date_active;
272: l_end_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE := p_end_date_active;
273: l_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE := p_role_relate_id;
274:
275: l_object_version_number JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE := P_OBJECT_VERSION_NUM;
276: l_return_status VARCHAR2(200);
277: l_msg_count NUMBER;

Line 275: l_object_version_number JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE := P_OBJECT_VERSION_NUM;

271: l_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE := p_start_date_active;
272: l_end_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE := p_end_date_active;
273: l_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE := p_role_relate_id;
274:
275: l_object_version_number JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE := P_OBJECT_VERSION_NUM;
276: l_return_status VARCHAR2(200);
277: l_msg_count NUMBER;
278: l_msg_data VARCHAR2(200);
279:

Line 382: P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,

378: PROCEDURE delete_resource_role_relate
379: (P_API_VERSION IN NUMBER,
380: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
381: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
382: P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
383: P_OBJECT_VERSION_NUM IN JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
384: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
385: X_MSG_COUNT OUT NOCOPY NUMBER,
386: X_MSG_DATA OUT NOCOPY VARCHAR2)

Line 383: P_OBJECT_VERSION_NUM IN JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,

379: (P_API_VERSION IN NUMBER,
380: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
381: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
382: P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
383: P_OBJECT_VERSION_NUM IN JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
384: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
385: X_MSG_COUNT OUT NOCOPY NUMBER,
386: X_MSG_DATA OUT NOCOPY VARCHAR2)
387: IS

Line 389: CURSOR role_relate_cur(l_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE)

385: X_MSG_COUNT OUT NOCOPY NUMBER,
386: X_MSG_DATA OUT NOCOPY VARCHAR2)
387: IS
388:
389: CURSOR role_relate_cur(l_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE)
390: IS
391: SELECT role_relate_id,
392: object_version_number
393: FROM jtf_rs_role_relations

Line 393: FROM jtf_rs_role_relations

389: CURSOR role_relate_cur(l_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE)
390: IS
391: SELECT role_relate_id,
392: object_version_number
393: FROM jtf_rs_role_relations
394: WHERE role_relate_id = l_role_relate_id;
395:
396: role_relate_rec role_relate_cur%rowtype;
397:

Line 402: l_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE := p_role_relate_id;

398: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_RESOURCE_ROLE_RELATE';
399: l_api_version CONSTANT NUMBER :=1.0;
400:
401:
402: l_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE := p_role_relate_id;
403:
404: l_object_version_number JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE := P_OBJECT_VERSION_NUM;
405: l_return_status VARCHAR2(200);
406: l_msg_count NUMBER;

Line 404: l_object_version_number JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE := P_OBJECT_VERSION_NUM;

400:
401:
402: l_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE := p_role_relate_id;
403:
404: l_object_version_number JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE := P_OBJECT_VERSION_NUM;
405: l_return_status VARCHAR2(200);
406: l_msg_count NUMBER;
407: l_msg_data VARCHAR2(200);
408: