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_TL

Line 27: P_GROUP_NAME IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_NAME%TYPE,

23: PROCEDURE create_dynamic_groups
24: (P_API_VERSION IN NUMBER,
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,

Line 28: P_GROUP_DESC IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_DESC%TYPE,

24: (P_API_VERSION IN NUMBER,
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,

Line 56: l_group_name jtf_rs_dynamic_groups_tl.group_name%type;

52: l_user_id Number;
53: l_login_id Number;
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;

Line 57: l_group_desc jtf_rs_dynamic_groups_tl.group_desc%type;

53: l_login_id Number;
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;

Line 203: P_GROUP_NAME IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_NAME%TYPE,

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,
207: P_END_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.END_DATE_ACTIVE%TYPE,

Line 204: P_GROUP_DESC IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_DESC%TYPE,

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,
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,

Line 232: l_group_name jtf_rs_dynamic_groups_tl.group_name%type;

228: l_user_id Number;
229: l_login_id Number;
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;

Line 233: l_group_desc jtf_rs_dynamic_groups_tl.group_desc%type;

229: l_login_id Number;
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;