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_PVT dependencies on JTF_RS_DYNAMIC_GROUPS_TL

Line 23: P_GROUP_NAME IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_NAME%TYPE,

19: PROCEDURE create_dynamic_groups
20: (P_API_VERSION IN NUMBER,
21: P_INIT_MSG_LIST IN VARCHAR2,
22: P_COMMIT IN VARCHAR2,
23: P_GROUP_NAME IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_NAME%TYPE,
24: P_GROUP_DESC IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_DESC%TYPE,
25: P_USAGE IN JTF_RS_DYNAMIC_GROUPS_B.USAGE%TYPE,
26: P_START_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.START_DATE_ACTIVE%TYPE,
27: P_END_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.END_DATE_ACTIVE%TYPE,

Line 24: P_GROUP_DESC IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_DESC%TYPE,

20: (P_API_VERSION IN NUMBER,
21: P_INIT_MSG_LIST IN VARCHAR2,
22: P_COMMIT IN VARCHAR2,
23: P_GROUP_NAME IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_NAME%TYPE,
24: P_GROUP_DESC IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_DESC%TYPE,
25: P_USAGE IN JTF_RS_DYNAMIC_GROUPS_B.USAGE%TYPE,
26: P_START_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.START_DATE_ACTIVE%TYPE,
27: P_END_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.END_DATE_ACTIVE%TYPE,
28: P_SQL_TEXT IN JTF_RS_DYNAMIC_GROUPS_B.SQL_TEXT%TYPE,

Line 69: l_group_name jtf_rs_dynamic_groups_tl.group_name%type;

65: l_user_id Number;
66: l_login_id Number;
67:
68:
69: l_group_name jtf_rs_dynamic_groups_tl.group_name%type;
70: l_group_desc jtf_rs_dynamic_groups_tl.group_desc%type;
71: l_usage jtf_rs_dynamic_groups_b.usage%type;
72: l_start_date_active jtf_rs_dynamic_groups_b.start_date_active%type;
73: l_end_date_active jtf_rs_dynamic_groups_b.end_date_active%type;

Line 70: l_group_desc jtf_rs_dynamic_groups_tl.group_desc%type;

66: l_login_id Number;
67:
68:
69: l_group_name jtf_rs_dynamic_groups_tl.group_name%type;
70: l_group_desc jtf_rs_dynamic_groups_tl.group_desc%type;
71: l_usage jtf_rs_dynamic_groups_b.usage%type;
72: l_start_date_active jtf_rs_dynamic_groups_b.start_date_active%type;
73: l_end_date_active jtf_rs_dynamic_groups_b.end_date_active%type;
74: l_sql_text jtf_rs_dynamic_groups_b.sql_text%type;

Line 592: P_GROUP_NAME IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_NAME%TYPE,

588: P_INIT_MSG_LIST IN VARCHAR2,
589: P_COMMIT IN VARCHAR2,
590: P_GROUP_ID IN JTF_RS_DYNAMIC_GROUPS_B.GROUP_ID%TYPE,
591: P_GROUP_NUMBER IN JTF_RS_DYNAMIC_GROUPS_B.GROUP_NUMBER%TYPE,
592: P_GROUP_NAME IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_NAME%TYPE,
593: P_GROUP_DESC IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_DESC%TYPE,
594: P_USAGE IN JTF_RS_DYNAMIC_GROUPS_B.USAGE%TYPE,
595: P_START_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.START_DATE_ACTIVE%TYPE,
596: P_END_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.END_DATE_ACTIVE%TYPE,

Line 593: P_GROUP_DESC IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_DESC%TYPE,

589: P_COMMIT IN VARCHAR2,
590: P_GROUP_ID IN JTF_RS_DYNAMIC_GROUPS_B.GROUP_ID%TYPE,
591: P_GROUP_NUMBER IN JTF_RS_DYNAMIC_GROUPS_B.GROUP_NUMBER%TYPE,
592: P_GROUP_NAME IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_NAME%TYPE,
593: P_GROUP_DESC IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_DESC%TYPE,
594: P_USAGE IN JTF_RS_DYNAMIC_GROUPS_B.USAGE%TYPE,
595: P_START_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.START_DATE_ACTIVE%TYPE,
596: P_END_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.END_DATE_ACTIVE%TYPE,
597: P_SQL_TEXT IN JTF_RS_DYNAMIC_GROUPS_B.SQL_TEXT%TYPE,

Line 638: l_group_name jtf_rs_dynamic_groups_tl.group_name%type ;

634: l_login_id Number;
635:
636: l_group_id jtf_rs_dynamic_groups_b.group_id%type;
637: l_group_number jtf_rs_dynamic_groups_b.group_number%type ;
638: l_group_name jtf_rs_dynamic_groups_tl.group_name%type ;
639: l_group_desc jtf_rs_dynamic_groups_tl.group_desc%type ;
640: l_usage jtf_rs_dynamic_groups_b.usage%type ;
641: l_start_date_active jtf_rs_dynamic_groups_b.start_date_active%type;
642: l_end_date_active jtf_rs_dynamic_groups_b.end_date_active%type ;

Line 639: l_group_desc jtf_rs_dynamic_groups_tl.group_desc%type ;

635:
636: l_group_id jtf_rs_dynamic_groups_b.group_id%type;
637: l_group_number jtf_rs_dynamic_groups_b.group_number%type ;
638: l_group_name jtf_rs_dynamic_groups_tl.group_name%type ;
639: l_group_desc jtf_rs_dynamic_groups_tl.group_desc%type ;
640: l_usage jtf_rs_dynamic_groups_b.usage%type ;
641: l_start_date_active jtf_rs_dynamic_groups_b.start_date_active%type;
642: l_end_date_active jtf_rs_dynamic_groups_b.end_date_active%type ;
643: l_sql_text jtf_rs_dynamic_groups_b.sql_text%type ;