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_DYNAMIC_GROUPS_PUB dependencies on JTF_RS_DYNAMIC_GROUPS_B

Line 29: P_USAGE IN JTF_RS_DYNAMIC_GROUPS_B.USAGE%TYPE,

25: P_INIT_MSG_LIST IN VARCHAR2,
26: P_COMMIT IN VARCHAR2,
27: P_GROUP_NAME IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_NAME%TYPE,
28: P_GROUP_DESC IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_DESC%TYPE,
29: P_USAGE IN JTF_RS_DYNAMIC_GROUPS_B.USAGE%TYPE,
30: P_START_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.START_DATE_ACTIVE%TYPE,
31: P_END_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.END_DATE_ACTIVE%TYPE,
32: P_SQL_TEXT IN JTF_RS_DYNAMIC_GROUPS_B.SQL_TEXT%TYPE,
33: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 30: P_START_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.START_DATE_ACTIVE%TYPE,

26: P_COMMIT IN VARCHAR2,
27: P_GROUP_NAME IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_NAME%TYPE,
28: P_GROUP_DESC IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_DESC%TYPE,
29: P_USAGE IN JTF_RS_DYNAMIC_GROUPS_B.USAGE%TYPE,
30: P_START_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.START_DATE_ACTIVE%TYPE,
31: P_END_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.END_DATE_ACTIVE%TYPE,
32: P_SQL_TEXT IN JTF_RS_DYNAMIC_GROUPS_B.SQL_TEXT%TYPE,
33: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
34: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 31: P_END_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.END_DATE_ACTIVE%TYPE,

27: P_GROUP_NAME IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_NAME%TYPE,
28: P_GROUP_DESC IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_DESC%TYPE,
29: P_USAGE IN JTF_RS_DYNAMIC_GROUPS_B.USAGE%TYPE,
30: P_START_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.START_DATE_ACTIVE%TYPE,
31: P_END_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.END_DATE_ACTIVE%TYPE,
32: P_SQL_TEXT IN JTF_RS_DYNAMIC_GROUPS_B.SQL_TEXT%TYPE,
33: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
34: X_MSG_COUNT OUT NOCOPY NUMBER,
35: X_MSG_DATA OUT NOCOPY VARCHAR2,

Line 32: P_SQL_TEXT IN JTF_RS_DYNAMIC_GROUPS_B.SQL_TEXT%TYPE,

28: P_GROUP_DESC IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_DESC%TYPE,
29: P_USAGE IN JTF_RS_DYNAMIC_GROUPS_B.USAGE%TYPE,
30: P_START_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.START_DATE_ACTIVE%TYPE,
31: P_END_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.END_DATE_ACTIVE%TYPE,
32: P_SQL_TEXT IN JTF_RS_DYNAMIC_GROUPS_B.SQL_TEXT%TYPE,
33: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
34: X_MSG_COUNT OUT NOCOPY NUMBER,
35: X_MSG_DATA OUT NOCOPY VARCHAR2,
36: X_GROUP_ID OUT NOCOPY JTF_RS_DYNAMIC_GROUPS_B.GROUP_ID%TYPE,

Line 36: X_GROUP_ID OUT NOCOPY JTF_RS_DYNAMIC_GROUPS_B.GROUP_ID%TYPE,

32: P_SQL_TEXT IN JTF_RS_DYNAMIC_GROUPS_B.SQL_TEXT%TYPE,
33: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
34: X_MSG_COUNT OUT NOCOPY NUMBER,
35: X_MSG_DATA OUT NOCOPY VARCHAR2,
36: X_GROUP_ID OUT NOCOPY JTF_RS_DYNAMIC_GROUPS_B.GROUP_ID%TYPE,
37: X_GROUP_NUMBER OUT NOCOPY JTF_RS_DYNAMIC_GROUPS_B.GROUP_NUMBER%TYPE
38: ) IS
39: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_DYNAMIC_GROUPS';
40: l_api_version CONSTANT NUMBER :=1.0;

Line 37: X_GROUP_NUMBER OUT NOCOPY JTF_RS_DYNAMIC_GROUPS_B.GROUP_NUMBER%TYPE

33: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
34: X_MSG_COUNT OUT NOCOPY NUMBER,
35: X_MSG_DATA OUT NOCOPY VARCHAR2,
36: X_GROUP_ID OUT NOCOPY JTF_RS_DYNAMIC_GROUPS_B.GROUP_ID%TYPE,
37: X_GROUP_NUMBER OUT NOCOPY JTF_RS_DYNAMIC_GROUPS_B.GROUP_NUMBER%TYPE
38: ) IS
39: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_DYNAMIC_GROUPS';
40: l_api_version CONSTANT NUMBER :=1.0;
41:

Line 58: l_usage jtf_rs_dynamic_groups_b.usage%type;

54:
55:
56: l_group_name jtf_rs_dynamic_groups_tl.group_name%type;
57: l_group_desc jtf_rs_dynamic_groups_tl.group_desc%type;
58: l_usage jtf_rs_dynamic_groups_b.usage%type;
59: l_start_date_active jtf_rs_dynamic_groups_b.start_date_active%type;
60: l_end_date_active jtf_rs_dynamic_groups_b.end_date_active%type;
61: l_sql_text jtf_rs_dynamic_groups_b.sql_text%type;
62:

Line 59: l_start_date_active jtf_rs_dynamic_groups_b.start_date_active%type;

55:
56: l_group_name jtf_rs_dynamic_groups_tl.group_name%type;
57: l_group_desc jtf_rs_dynamic_groups_tl.group_desc%type;
58: l_usage jtf_rs_dynamic_groups_b.usage%type;
59: l_start_date_active jtf_rs_dynamic_groups_b.start_date_active%type;
60: l_end_date_active jtf_rs_dynamic_groups_b.end_date_active%type;
61: l_sql_text jtf_rs_dynamic_groups_b.sql_text%type;
62:
63:

Line 60: l_end_date_active jtf_rs_dynamic_groups_b.end_date_active%type;

56: l_group_name jtf_rs_dynamic_groups_tl.group_name%type;
57: l_group_desc jtf_rs_dynamic_groups_tl.group_desc%type;
58: l_usage jtf_rs_dynamic_groups_b.usage%type;
59: l_start_date_active jtf_rs_dynamic_groups_b.start_date_active%type;
60: l_end_date_active jtf_rs_dynamic_groups_b.end_date_active%type;
61: l_sql_text jtf_rs_dynamic_groups_b.sql_text%type;
62:
63:
64: l_group_id jtf_rs_dynamic_groups_b.group_id%type;

Line 61: l_sql_text jtf_rs_dynamic_groups_b.sql_text%type;

57: l_group_desc jtf_rs_dynamic_groups_tl.group_desc%type;
58: l_usage jtf_rs_dynamic_groups_b.usage%type;
59: l_start_date_active jtf_rs_dynamic_groups_b.start_date_active%type;
60: l_end_date_active jtf_rs_dynamic_groups_b.end_date_active%type;
61: l_sql_text jtf_rs_dynamic_groups_b.sql_text%type;
62:
63:
64: l_group_id jtf_rs_dynamic_groups_b.group_id%type;
65: l_group_number jtf_rs_dynamic_groups_b.group_number%type;

Line 64: l_group_id jtf_rs_dynamic_groups_b.group_id%type;

60: l_end_date_active jtf_rs_dynamic_groups_b.end_date_active%type;
61: l_sql_text jtf_rs_dynamic_groups_b.sql_text%type;
62:
63:
64: l_group_id jtf_rs_dynamic_groups_b.group_id%type;
65: l_group_number jtf_rs_dynamic_groups_b.group_number%type;
66:
67: BEGIN
68:

Line 65: l_group_number jtf_rs_dynamic_groups_b.group_number%type;

61: l_sql_text jtf_rs_dynamic_groups_b.sql_text%type;
62:
63:
64: l_group_id jtf_rs_dynamic_groups_b.group_id%type;
65: l_group_number jtf_rs_dynamic_groups_b.group_number%type;
66:
67: BEGIN
68:
69: l_group_name := P_GROUP_NAME;

Line 201: P_GROUP_ID IN JTF_RS_DYNAMIC_GROUPS_B.GROUP_ID%TYPE,

197: PROCEDURE update_dynamic_groups
198: (P_API_VERSION IN NUMBER,
199: P_INIT_MSG_LIST IN VARCHAR2,
200: P_COMMIT IN VARCHAR2,
201: P_GROUP_ID IN JTF_RS_DYNAMIC_GROUPS_B.GROUP_ID%TYPE,
202: P_GROUP_NUMBER IN JTF_RS_DYNAMIC_GROUPS_B.GROUP_NUMBER%TYPE,
203: P_GROUP_NAME IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_NAME%TYPE,
204: P_GROUP_DESC IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_DESC%TYPE,
205: P_USAGE IN JTF_RS_DYNAMIC_GROUPS_B.USAGE%TYPE,

Line 202: P_GROUP_NUMBER IN JTF_RS_DYNAMIC_GROUPS_B.GROUP_NUMBER%TYPE,

198: (P_API_VERSION IN NUMBER,
199: P_INIT_MSG_LIST IN VARCHAR2,
200: P_COMMIT IN VARCHAR2,
201: P_GROUP_ID IN JTF_RS_DYNAMIC_GROUPS_B.GROUP_ID%TYPE,
202: P_GROUP_NUMBER IN JTF_RS_DYNAMIC_GROUPS_B.GROUP_NUMBER%TYPE,
203: P_GROUP_NAME IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_NAME%TYPE,
204: P_GROUP_DESC IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_DESC%TYPE,
205: P_USAGE IN JTF_RS_DYNAMIC_GROUPS_B.USAGE%TYPE,
206: P_START_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.START_DATE_ACTIVE%TYPE,

Line 205: P_USAGE IN JTF_RS_DYNAMIC_GROUPS_B.USAGE%TYPE,

201: P_GROUP_ID IN JTF_RS_DYNAMIC_GROUPS_B.GROUP_ID%TYPE,
202: P_GROUP_NUMBER IN JTF_RS_DYNAMIC_GROUPS_B.GROUP_NUMBER%TYPE,
203: P_GROUP_NAME IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_NAME%TYPE,
204: P_GROUP_DESC IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_DESC%TYPE,
205: P_USAGE IN JTF_RS_DYNAMIC_GROUPS_B.USAGE%TYPE,
206: P_START_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.START_DATE_ACTIVE%TYPE,
207: P_END_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.END_DATE_ACTIVE%TYPE,
208: P_SQL_TEXT IN JTF_RS_DYNAMIC_GROUPS_B.SQL_TEXT%TYPE,
209: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_DYNAMIC_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE,

Line 206: P_START_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.START_DATE_ACTIVE%TYPE,

202: P_GROUP_NUMBER IN JTF_RS_DYNAMIC_GROUPS_B.GROUP_NUMBER%TYPE,
203: P_GROUP_NAME IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_NAME%TYPE,
204: P_GROUP_DESC IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_DESC%TYPE,
205: P_USAGE IN JTF_RS_DYNAMIC_GROUPS_B.USAGE%TYPE,
206: P_START_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.START_DATE_ACTIVE%TYPE,
207: P_END_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.END_DATE_ACTIVE%TYPE,
208: P_SQL_TEXT IN JTF_RS_DYNAMIC_GROUPS_B.SQL_TEXT%TYPE,
209: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_DYNAMIC_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE,
210: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 207: P_END_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.END_DATE_ACTIVE%TYPE,

203: P_GROUP_NAME IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_NAME%TYPE,
204: P_GROUP_DESC IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_DESC%TYPE,
205: P_USAGE IN JTF_RS_DYNAMIC_GROUPS_B.USAGE%TYPE,
206: P_START_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.START_DATE_ACTIVE%TYPE,
207: P_END_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.END_DATE_ACTIVE%TYPE,
208: P_SQL_TEXT IN JTF_RS_DYNAMIC_GROUPS_B.SQL_TEXT%TYPE,
209: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_DYNAMIC_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE,
210: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
211: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 208: P_SQL_TEXT IN JTF_RS_DYNAMIC_GROUPS_B.SQL_TEXT%TYPE,

204: P_GROUP_DESC IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_DESC%TYPE,
205: P_USAGE IN JTF_RS_DYNAMIC_GROUPS_B.USAGE%TYPE,
206: P_START_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.START_DATE_ACTIVE%TYPE,
207: P_END_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.END_DATE_ACTIVE%TYPE,
208: P_SQL_TEXT IN JTF_RS_DYNAMIC_GROUPS_B.SQL_TEXT%TYPE,
209: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_DYNAMIC_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE,
210: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
211: X_MSG_COUNT OUT NOCOPY NUMBER,
212: X_MSG_DATA OUT NOCOPY VARCHAR2

Line 209: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_DYNAMIC_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE,

205: P_USAGE IN JTF_RS_DYNAMIC_GROUPS_B.USAGE%TYPE,
206: P_START_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.START_DATE_ACTIVE%TYPE,
207: P_END_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.END_DATE_ACTIVE%TYPE,
208: P_SQL_TEXT IN JTF_RS_DYNAMIC_GROUPS_B.SQL_TEXT%TYPE,
209: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_DYNAMIC_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE,
210: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
211: X_MSG_COUNT OUT NOCOPY NUMBER,
212: X_MSG_DATA OUT NOCOPY VARCHAR2
213: ) IS

Line 234: l_usage jtf_rs_dynamic_groups_b.usage%type;

230:
231:
232: l_group_name jtf_rs_dynamic_groups_tl.group_name%type;
233: l_group_desc jtf_rs_dynamic_groups_tl.group_desc%type;
234: l_usage jtf_rs_dynamic_groups_b.usage%type;
235: l_start_date_active jtf_rs_dynamic_groups_b.start_date_active%type;
236: l_end_date_active jtf_rs_dynamic_groups_b.end_date_active%type;
237: l_sql_text jtf_rs_dynamic_groups_b.sql_text%type;
238: l_object_version_number jtf_rs_dynamic_groups_b.object_version_number%type;

Line 235: l_start_date_active jtf_rs_dynamic_groups_b.start_date_active%type;

231:
232: l_group_name jtf_rs_dynamic_groups_tl.group_name%type;
233: l_group_desc jtf_rs_dynamic_groups_tl.group_desc%type;
234: l_usage jtf_rs_dynamic_groups_b.usage%type;
235: l_start_date_active jtf_rs_dynamic_groups_b.start_date_active%type;
236: l_end_date_active jtf_rs_dynamic_groups_b.end_date_active%type;
237: l_sql_text jtf_rs_dynamic_groups_b.sql_text%type;
238: l_object_version_number jtf_rs_dynamic_groups_b.object_version_number%type;
239:

Line 236: l_end_date_active jtf_rs_dynamic_groups_b.end_date_active%type;

232: l_group_name jtf_rs_dynamic_groups_tl.group_name%type;
233: l_group_desc jtf_rs_dynamic_groups_tl.group_desc%type;
234: l_usage jtf_rs_dynamic_groups_b.usage%type;
235: l_start_date_active jtf_rs_dynamic_groups_b.start_date_active%type;
236: l_end_date_active jtf_rs_dynamic_groups_b.end_date_active%type;
237: l_sql_text jtf_rs_dynamic_groups_b.sql_text%type;
238: l_object_version_number jtf_rs_dynamic_groups_b.object_version_number%type;
239:
240: l_group_id jtf_rs_dynamic_groups_b.group_id%type;

Line 237: l_sql_text jtf_rs_dynamic_groups_b.sql_text%type;

233: l_group_desc jtf_rs_dynamic_groups_tl.group_desc%type;
234: l_usage jtf_rs_dynamic_groups_b.usage%type;
235: l_start_date_active jtf_rs_dynamic_groups_b.start_date_active%type;
236: l_end_date_active jtf_rs_dynamic_groups_b.end_date_active%type;
237: l_sql_text jtf_rs_dynamic_groups_b.sql_text%type;
238: l_object_version_number jtf_rs_dynamic_groups_b.object_version_number%type;
239:
240: l_group_id jtf_rs_dynamic_groups_b.group_id%type;
241: l_group_number jtf_rs_dynamic_groups_b.group_number%type;

Line 238: l_object_version_number jtf_rs_dynamic_groups_b.object_version_number%type;

234: l_usage jtf_rs_dynamic_groups_b.usage%type;
235: l_start_date_active jtf_rs_dynamic_groups_b.start_date_active%type;
236: l_end_date_active jtf_rs_dynamic_groups_b.end_date_active%type;
237: l_sql_text jtf_rs_dynamic_groups_b.sql_text%type;
238: l_object_version_number jtf_rs_dynamic_groups_b.object_version_number%type;
239:
240: l_group_id jtf_rs_dynamic_groups_b.group_id%type;
241: l_group_number jtf_rs_dynamic_groups_b.group_number%type;
242:

Line 240: l_group_id jtf_rs_dynamic_groups_b.group_id%type;

236: l_end_date_active jtf_rs_dynamic_groups_b.end_date_active%type;
237: l_sql_text jtf_rs_dynamic_groups_b.sql_text%type;
238: l_object_version_number jtf_rs_dynamic_groups_b.object_version_number%type;
239:
240: l_group_id jtf_rs_dynamic_groups_b.group_id%type;
241: l_group_number jtf_rs_dynamic_groups_b.group_number%type;
242:
243: BEGIN
244:

Line 241: l_group_number jtf_rs_dynamic_groups_b.group_number%type;

237: l_sql_text jtf_rs_dynamic_groups_b.sql_text%type;
238: l_object_version_number jtf_rs_dynamic_groups_b.object_version_number%type;
239:
240: l_group_id jtf_rs_dynamic_groups_b.group_id%type;
241: l_group_number jtf_rs_dynamic_groups_b.group_number%type;
242:
243: BEGIN
244:
245: l_group_name := P_GROUP_NAME;

Line 361: P_GROUP_ID IN JTF_RS_DYNAMIC_GROUPS_B.GROUP_ID%TYPE,

357: PROCEDURE delete_dynamic_groups
358: (P_API_VERSION IN NUMBER,
359: P_INIT_MSG_LIST IN VARCHAR2,
360: P_COMMIT IN VARCHAR2,
361: P_GROUP_ID IN JTF_RS_DYNAMIC_GROUPS_B.GROUP_ID%TYPE,
362: P_OBJECT_VERSION_NUMBER IN JTF_RS_DYNAMIC_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE,
363: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
364: X_MSG_COUNT OUT NOCOPY NUMBER,
365: X_MSG_DATA OUT NOCOPY VARCHAR2

Line 362: P_OBJECT_VERSION_NUMBER IN JTF_RS_DYNAMIC_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE,

358: (P_API_VERSION IN NUMBER,
359: P_INIT_MSG_LIST IN VARCHAR2,
360: P_COMMIT IN VARCHAR2,
361: P_GROUP_ID IN JTF_RS_DYNAMIC_GROUPS_B.GROUP_ID%TYPE,
362: P_OBJECT_VERSION_NUMBER IN JTF_RS_DYNAMIC_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE,
363: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
364: X_MSG_COUNT OUT NOCOPY NUMBER,
365: X_MSG_DATA OUT NOCOPY VARCHAR2
366: ) IS

Line 383: l_group_id jtf_rs_dynamic_groups_b.group_id%type;

379: l_date Date;
380: l_user_id Number;
381: l_login_id Number;
382:
383: l_group_id jtf_rs_dynamic_groups_b.group_id%type;
384:
385:
386: BEGIN
387: