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_B

Line 25: P_USAGE IN JTF_RS_DYNAMIC_GROUPS_B.USAGE%TYPE,

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,
29: P_ATTRIBUTE1 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE1%TYPE,

Line 26: P_START_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.START_DATE_ACTIVE%TYPE,

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,
29: P_ATTRIBUTE1 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE1%TYPE,
30: P_ATTRIBUTE2 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE2%TYPE,

Line 27: P_END_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.END_DATE_ACTIVE%TYPE,

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,
29: P_ATTRIBUTE1 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE1%TYPE,
30: P_ATTRIBUTE2 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE2%TYPE,
31: P_ATTRIBUTE3 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE3%TYPE,

Line 28: P_SQL_TEXT IN JTF_RS_DYNAMIC_GROUPS_B.SQL_TEXT%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,
29: P_ATTRIBUTE1 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE1%TYPE,
30: P_ATTRIBUTE2 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE2%TYPE,
31: P_ATTRIBUTE3 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE3%TYPE,
32: P_ATTRIBUTE4 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE4%TYPE,

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

44: P_ATTRIBUTE_CATEGORY IN JTF_RS_GRP_RELATIONS.ATTRIBUTE_CATEGORY%TYPE,
45: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
46: X_MSG_COUNT OUT NOCOPY NUMBER,
47: X_MSG_DATA OUT NOCOPY VARCHAR2,
48: X_GROUP_ID OUT NOCOPY JTF_RS_DYNAMIC_GROUPS_B.GROUP_ID%TYPE,
49: X_GROUP_NUMBER OUT NOCOPY JTF_RS_DYNAMIC_GROUPS_B.GROUP_NUMBER%TYPE
50: )
51: IS
52:

Line 49: X_GROUP_NUMBER OUT NOCOPY JTF_RS_DYNAMIC_GROUPS_B.GROUP_NUMBER%TYPE

45: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
46: X_MSG_COUNT OUT NOCOPY NUMBER,
47: X_MSG_DATA OUT NOCOPY VARCHAR2,
48: X_GROUP_ID OUT NOCOPY JTF_RS_DYNAMIC_GROUPS_B.GROUP_ID%TYPE,
49: X_GROUP_NUMBER OUT NOCOPY JTF_RS_DYNAMIC_GROUPS_B.GROUP_NUMBER%TYPE
50: )
51: IS
52:
53: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_DYNAMIC_GROUPS';

Line 71: l_usage jtf_rs_dynamic_groups_b.usage%type;

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;
75:

Line 72: l_start_date_active jtf_rs_dynamic_groups_b.start_date_active%type;

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;
75:
76:

Line 73: l_end_date_active jtf_rs_dynamic_groups_b.end_date_active%type;

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;
75:
76:
77: l_cursorid NUMBER;

Line 74: l_sql_text jtf_rs_dynamic_groups_b.sql_text%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;
75:
76:
77: l_cursorid NUMBER;
78: v_dummy integer;

Line 80: l_group_id jtf_rs_dynamic_groups_b.group_id%type;

76:
77: l_cursorid NUMBER;
78: v_dummy integer;
79:
80: l_group_id jtf_rs_dynamic_groups_b.group_id%type;
81: l_group_number jtf_rs_dynamic_groups_b.group_number%type;
82:
83: l_bind_data_id number;
84:

Line 81: l_group_number jtf_rs_dynamic_groups_b.group_number%type;

77: l_cursorid NUMBER;
78: v_dummy integer;
79:
80: l_group_id jtf_rs_dynamic_groups_b.group_id%type;
81: l_group_number jtf_rs_dynamic_groups_b.group_number%type;
82:
83: l_bind_data_id number;
84:
85: BEGIN

Line 590: P_GROUP_ID IN JTF_RS_DYNAMIC_GROUPS_B.GROUP_ID%TYPE,

586: PROCEDURE update_dynamic_groups
587: (P_API_VERSION IN NUMBER,
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,

Line 591: P_GROUP_NUMBER IN JTF_RS_DYNAMIC_GROUPS_B.GROUP_NUMBER%TYPE,

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

Line 594: P_USAGE IN JTF_RS_DYNAMIC_GROUPS_B.USAGE%TYPE,

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,
598: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_DYNAMIC_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE,

Line 595: P_START_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.START_DATE_ACTIVE%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,
598: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_DYNAMIC_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE,
599: P_ATTRIBUTE1 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE1%TYPE,

Line 596: P_END_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.END_DATE_ACTIVE%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,
598: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_DYNAMIC_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE,
599: P_ATTRIBUTE1 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE1%TYPE,
600: P_ATTRIBUTE2 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE2%TYPE,

Line 597: P_SQL_TEXT IN JTF_RS_DYNAMIC_GROUPS_B.SQL_TEXT%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,
598: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_DYNAMIC_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE,
599: P_ATTRIBUTE1 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE1%TYPE,
600: P_ATTRIBUTE2 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE2%TYPE,
601: P_ATTRIBUTE3 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE3%TYPE,

Line 598: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_DYNAMIC_GROUPS_B.OBJECT_VERSION_NUMBER%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,
598: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_DYNAMIC_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE,
599: P_ATTRIBUTE1 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE1%TYPE,
600: P_ATTRIBUTE2 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE2%TYPE,
601: P_ATTRIBUTE3 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE3%TYPE,
602: P_ATTRIBUTE4 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE4%TYPE,

Line 636: l_group_id jtf_rs_dynamic_groups_b.group_id%type;

632: l_date Date;
633: l_user_id Number;
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 ;

Line 637: l_group_number jtf_rs_dynamic_groups_b.group_number%type ;

633: l_user_id Number;
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;

Line 640: l_usage jtf_rs_dynamic_groups_b.usage%type ;

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 ;
644: l_object_version_number jtf_rs_dynamic_groups_b.object_version_number%type;

Line 641: l_start_date_active jtf_rs_dynamic_groups_b.start_date_active%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 ;
644: l_object_version_number jtf_rs_dynamic_groups_b.object_version_number%type;
645:

Line 642: l_end_date_active jtf_rs_dynamic_groups_b.end_date_active%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 ;
644: l_object_version_number jtf_rs_dynamic_groups_b.object_version_number%type;
645:
646: l_attribute1 jtf_rs_dynamic_groups_b.attribute1%type;

Line 643: l_sql_text jtf_rs_dynamic_groups_b.sql_text%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 ;
644: l_object_version_number jtf_rs_dynamic_groups_b.object_version_number%type;
645:
646: l_attribute1 jtf_rs_dynamic_groups_b.attribute1%type;
647: l_attribute2 jtf_rs_dynamic_groups_b.attribute2%type;

Line 644: l_object_version_number jtf_rs_dynamic_groups_b.object_version_number%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 ;
644: l_object_version_number jtf_rs_dynamic_groups_b.object_version_number%type;
645:
646: l_attribute1 jtf_rs_dynamic_groups_b.attribute1%type;
647: l_attribute2 jtf_rs_dynamic_groups_b.attribute2%type;
648: l_attribute3 jtf_rs_dynamic_groups_b.attribute3%type;

Line 646: l_attribute1 jtf_rs_dynamic_groups_b.attribute1%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 ;
644: l_object_version_number jtf_rs_dynamic_groups_b.object_version_number%type;
645:
646: l_attribute1 jtf_rs_dynamic_groups_b.attribute1%type;
647: l_attribute2 jtf_rs_dynamic_groups_b.attribute2%type;
648: l_attribute3 jtf_rs_dynamic_groups_b.attribute3%type;
649: l_attribute4 jtf_rs_dynamic_groups_b.attribute4%type;
650: l_attribute5 jtf_rs_dynamic_groups_b.attribute5%type;

Line 647: l_attribute2 jtf_rs_dynamic_groups_b.attribute2%type;

643: l_sql_text jtf_rs_dynamic_groups_b.sql_text%type ;
644: l_object_version_number jtf_rs_dynamic_groups_b.object_version_number%type;
645:
646: l_attribute1 jtf_rs_dynamic_groups_b.attribute1%type;
647: l_attribute2 jtf_rs_dynamic_groups_b.attribute2%type;
648: l_attribute3 jtf_rs_dynamic_groups_b.attribute3%type;
649: l_attribute4 jtf_rs_dynamic_groups_b.attribute4%type;
650: l_attribute5 jtf_rs_dynamic_groups_b.attribute5%type;
651: l_attribute6 jtf_rs_dynamic_groups_b.attribute6%type;

Line 648: l_attribute3 jtf_rs_dynamic_groups_b.attribute3%type;

644: l_object_version_number jtf_rs_dynamic_groups_b.object_version_number%type;
645:
646: l_attribute1 jtf_rs_dynamic_groups_b.attribute1%type;
647: l_attribute2 jtf_rs_dynamic_groups_b.attribute2%type;
648: l_attribute3 jtf_rs_dynamic_groups_b.attribute3%type;
649: l_attribute4 jtf_rs_dynamic_groups_b.attribute4%type;
650: l_attribute5 jtf_rs_dynamic_groups_b.attribute5%type;
651: l_attribute6 jtf_rs_dynamic_groups_b.attribute6%type;
652: l_attribute7 jtf_rs_dynamic_groups_b.attribute7%type;

Line 649: l_attribute4 jtf_rs_dynamic_groups_b.attribute4%type;

645:
646: l_attribute1 jtf_rs_dynamic_groups_b.attribute1%type;
647: l_attribute2 jtf_rs_dynamic_groups_b.attribute2%type;
648: l_attribute3 jtf_rs_dynamic_groups_b.attribute3%type;
649: l_attribute4 jtf_rs_dynamic_groups_b.attribute4%type;
650: l_attribute5 jtf_rs_dynamic_groups_b.attribute5%type;
651: l_attribute6 jtf_rs_dynamic_groups_b.attribute6%type;
652: l_attribute7 jtf_rs_dynamic_groups_b.attribute7%type;
653: l_attribute8 jtf_rs_dynamic_groups_b.attribute8%type;

Line 650: l_attribute5 jtf_rs_dynamic_groups_b.attribute5%type;

646: l_attribute1 jtf_rs_dynamic_groups_b.attribute1%type;
647: l_attribute2 jtf_rs_dynamic_groups_b.attribute2%type;
648: l_attribute3 jtf_rs_dynamic_groups_b.attribute3%type;
649: l_attribute4 jtf_rs_dynamic_groups_b.attribute4%type;
650: l_attribute5 jtf_rs_dynamic_groups_b.attribute5%type;
651: l_attribute6 jtf_rs_dynamic_groups_b.attribute6%type;
652: l_attribute7 jtf_rs_dynamic_groups_b.attribute7%type;
653: l_attribute8 jtf_rs_dynamic_groups_b.attribute8%type;
654: l_attribute9 jtf_rs_dynamic_groups_b.attribute9%type;

Line 651: l_attribute6 jtf_rs_dynamic_groups_b.attribute6%type;

647: l_attribute2 jtf_rs_dynamic_groups_b.attribute2%type;
648: l_attribute3 jtf_rs_dynamic_groups_b.attribute3%type;
649: l_attribute4 jtf_rs_dynamic_groups_b.attribute4%type;
650: l_attribute5 jtf_rs_dynamic_groups_b.attribute5%type;
651: l_attribute6 jtf_rs_dynamic_groups_b.attribute6%type;
652: l_attribute7 jtf_rs_dynamic_groups_b.attribute7%type;
653: l_attribute8 jtf_rs_dynamic_groups_b.attribute8%type;
654: l_attribute9 jtf_rs_dynamic_groups_b.attribute9%type;
655: l_attribute10 jtf_rs_dynamic_groups_b.attribute10%type;

Line 652: l_attribute7 jtf_rs_dynamic_groups_b.attribute7%type;

648: l_attribute3 jtf_rs_dynamic_groups_b.attribute3%type;
649: l_attribute4 jtf_rs_dynamic_groups_b.attribute4%type;
650: l_attribute5 jtf_rs_dynamic_groups_b.attribute5%type;
651: l_attribute6 jtf_rs_dynamic_groups_b.attribute6%type;
652: l_attribute7 jtf_rs_dynamic_groups_b.attribute7%type;
653: l_attribute8 jtf_rs_dynamic_groups_b.attribute8%type;
654: l_attribute9 jtf_rs_dynamic_groups_b.attribute9%type;
655: l_attribute10 jtf_rs_dynamic_groups_b.attribute10%type;
656: l_attribute11 jtf_rs_dynamic_groups_b.attribute11%type;

Line 653: l_attribute8 jtf_rs_dynamic_groups_b.attribute8%type;

649: l_attribute4 jtf_rs_dynamic_groups_b.attribute4%type;
650: l_attribute5 jtf_rs_dynamic_groups_b.attribute5%type;
651: l_attribute6 jtf_rs_dynamic_groups_b.attribute6%type;
652: l_attribute7 jtf_rs_dynamic_groups_b.attribute7%type;
653: l_attribute8 jtf_rs_dynamic_groups_b.attribute8%type;
654: l_attribute9 jtf_rs_dynamic_groups_b.attribute9%type;
655: l_attribute10 jtf_rs_dynamic_groups_b.attribute10%type;
656: l_attribute11 jtf_rs_dynamic_groups_b.attribute11%type;
657: l_attribute12 jtf_rs_dynamic_groups_b.attribute12%type;

Line 654: l_attribute9 jtf_rs_dynamic_groups_b.attribute9%type;

650: l_attribute5 jtf_rs_dynamic_groups_b.attribute5%type;
651: l_attribute6 jtf_rs_dynamic_groups_b.attribute6%type;
652: l_attribute7 jtf_rs_dynamic_groups_b.attribute7%type;
653: l_attribute8 jtf_rs_dynamic_groups_b.attribute8%type;
654: l_attribute9 jtf_rs_dynamic_groups_b.attribute9%type;
655: l_attribute10 jtf_rs_dynamic_groups_b.attribute10%type;
656: l_attribute11 jtf_rs_dynamic_groups_b.attribute11%type;
657: l_attribute12 jtf_rs_dynamic_groups_b.attribute12%type;
658: l_attribute13 jtf_rs_dynamic_groups_b.attribute13%type;

Line 655: l_attribute10 jtf_rs_dynamic_groups_b.attribute10%type;

651: l_attribute6 jtf_rs_dynamic_groups_b.attribute6%type;
652: l_attribute7 jtf_rs_dynamic_groups_b.attribute7%type;
653: l_attribute8 jtf_rs_dynamic_groups_b.attribute8%type;
654: l_attribute9 jtf_rs_dynamic_groups_b.attribute9%type;
655: l_attribute10 jtf_rs_dynamic_groups_b.attribute10%type;
656: l_attribute11 jtf_rs_dynamic_groups_b.attribute11%type;
657: l_attribute12 jtf_rs_dynamic_groups_b.attribute12%type;
658: l_attribute13 jtf_rs_dynamic_groups_b.attribute13%type;
659: l_attribute14 jtf_rs_dynamic_groups_b.attribute14%type;

Line 656: l_attribute11 jtf_rs_dynamic_groups_b.attribute11%type;

652: l_attribute7 jtf_rs_dynamic_groups_b.attribute7%type;
653: l_attribute8 jtf_rs_dynamic_groups_b.attribute8%type;
654: l_attribute9 jtf_rs_dynamic_groups_b.attribute9%type;
655: l_attribute10 jtf_rs_dynamic_groups_b.attribute10%type;
656: l_attribute11 jtf_rs_dynamic_groups_b.attribute11%type;
657: l_attribute12 jtf_rs_dynamic_groups_b.attribute12%type;
658: l_attribute13 jtf_rs_dynamic_groups_b.attribute13%type;
659: l_attribute14 jtf_rs_dynamic_groups_b.attribute14%type;
660: l_attribute15 jtf_rs_dynamic_groups_b.attribute15%type;

Line 657: l_attribute12 jtf_rs_dynamic_groups_b.attribute12%type;

653: l_attribute8 jtf_rs_dynamic_groups_b.attribute8%type;
654: l_attribute9 jtf_rs_dynamic_groups_b.attribute9%type;
655: l_attribute10 jtf_rs_dynamic_groups_b.attribute10%type;
656: l_attribute11 jtf_rs_dynamic_groups_b.attribute11%type;
657: l_attribute12 jtf_rs_dynamic_groups_b.attribute12%type;
658: l_attribute13 jtf_rs_dynamic_groups_b.attribute13%type;
659: l_attribute14 jtf_rs_dynamic_groups_b.attribute14%type;
660: l_attribute15 jtf_rs_dynamic_groups_b.attribute15%type;
661: l_attribute_category jtf_rs_dynamic_groups_b.attribute_category%type;

Line 658: l_attribute13 jtf_rs_dynamic_groups_b.attribute13%type;

654: l_attribute9 jtf_rs_dynamic_groups_b.attribute9%type;
655: l_attribute10 jtf_rs_dynamic_groups_b.attribute10%type;
656: l_attribute11 jtf_rs_dynamic_groups_b.attribute11%type;
657: l_attribute12 jtf_rs_dynamic_groups_b.attribute12%type;
658: l_attribute13 jtf_rs_dynamic_groups_b.attribute13%type;
659: l_attribute14 jtf_rs_dynamic_groups_b.attribute14%type;
660: l_attribute15 jtf_rs_dynamic_groups_b.attribute15%type;
661: l_attribute_category jtf_rs_dynamic_groups_b.attribute_category%type;
662:

Line 659: l_attribute14 jtf_rs_dynamic_groups_b.attribute14%type;

655: l_attribute10 jtf_rs_dynamic_groups_b.attribute10%type;
656: l_attribute11 jtf_rs_dynamic_groups_b.attribute11%type;
657: l_attribute12 jtf_rs_dynamic_groups_b.attribute12%type;
658: l_attribute13 jtf_rs_dynamic_groups_b.attribute13%type;
659: l_attribute14 jtf_rs_dynamic_groups_b.attribute14%type;
660: l_attribute15 jtf_rs_dynamic_groups_b.attribute15%type;
661: l_attribute_category jtf_rs_dynamic_groups_b.attribute_category%type;
662:
663:

Line 660: l_attribute15 jtf_rs_dynamic_groups_b.attribute15%type;

656: l_attribute11 jtf_rs_dynamic_groups_b.attribute11%type;
657: l_attribute12 jtf_rs_dynamic_groups_b.attribute12%type;
658: l_attribute13 jtf_rs_dynamic_groups_b.attribute13%type;
659: l_attribute14 jtf_rs_dynamic_groups_b.attribute14%type;
660: l_attribute15 jtf_rs_dynamic_groups_b.attribute15%type;
661: l_attribute_category jtf_rs_dynamic_groups_b.attribute_category%type;
662:
663:
664:

Line 661: l_attribute_category jtf_rs_dynamic_groups_b.attribute_category%type;

657: l_attribute12 jtf_rs_dynamic_groups_b.attribute12%type;
658: l_attribute13 jtf_rs_dynamic_groups_b.attribute13%type;
659: l_attribute14 jtf_rs_dynamic_groups_b.attribute14%type;
660: l_attribute15 jtf_rs_dynamic_groups_b.attribute15%type;
661: l_attribute_category jtf_rs_dynamic_groups_b.attribute_category%type;
662:
663:
664:
665: l_cursorid NUMBER;

Line 669: CURSOR dyn_grp_cur(l_group_id jtf_rs_dynamic_groups_b.group_id%type)

665: l_cursorid NUMBER;
666: v_dummy integer;
667:
668:
669: CURSOR dyn_grp_cur(l_group_id jtf_rs_dynamic_groups_b.group_id%type)
670: IS
671: SELECT group_number,
672: usage ,
673: start_date_active,

Line 1389: P_GROUP_ID IN JTF_RS_DYNAMIC_GROUPS_B.GROUP_ID%TYPE,

1385: PROCEDURE delete_dynamic_groups
1386: (P_API_VERSION IN NUMBER,
1387: P_INIT_MSG_LIST IN VARCHAR2,
1388: P_COMMIT IN VARCHAR2,
1389: P_GROUP_ID IN JTF_RS_DYNAMIC_GROUPS_B.GROUP_ID%TYPE,
1390: P_OBJECT_VERSION_NUMBER IN JTF_RS_DYNAMIC_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE,
1391: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1392: X_MSG_COUNT OUT NOCOPY NUMBER,
1393: X_MSG_DATA OUT NOCOPY VARCHAR2

Line 1390: P_OBJECT_VERSION_NUMBER IN JTF_RS_DYNAMIC_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE,

1386: (P_API_VERSION IN NUMBER,
1387: P_INIT_MSG_LIST IN VARCHAR2,
1388: P_COMMIT IN VARCHAR2,
1389: P_GROUP_ID IN JTF_RS_DYNAMIC_GROUPS_B.GROUP_ID%TYPE,
1390: P_OBJECT_VERSION_NUMBER IN JTF_RS_DYNAMIC_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE,
1391: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1392: X_MSG_COUNT OUT NOCOPY NUMBER,
1393: X_MSG_DATA OUT NOCOPY VARCHAR2
1394: )