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

Line 12: P_USAGE IN JTF_RS_DYNAMIC_GROUPS_B.USAGE%TYPE,

8:
9: PROCEDURE create_dynamic_groups_pre
10: (P_GROUP_NAME IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_NAME%TYPE,
11: P_GROUP_DESC IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_DESC%TYPE DEFAULT NULL,
12: P_USAGE IN JTF_RS_DYNAMIC_GROUPS_B.USAGE%TYPE,
13: P_START_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.START_DATE_ACTIVE%TYPE,
14: P_END_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.END_DATE_ACTIVE%TYPE DEFAULT NULL,
15: P_SQL_TEXT IN JTF_RS_DYNAMIC_GROUPS_B.SQL_TEXT%TYPE,
16: P_DATA OUT NOCOPY VARCHAR2,

Line 13: P_START_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.START_DATE_ACTIVE%TYPE,

9: PROCEDURE create_dynamic_groups_pre
10: (P_GROUP_NAME IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_NAME%TYPE,
11: P_GROUP_DESC IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_DESC%TYPE DEFAULT NULL,
12: P_USAGE IN JTF_RS_DYNAMIC_GROUPS_B.USAGE%TYPE,
13: P_START_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.START_DATE_ACTIVE%TYPE,
14: P_END_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.END_DATE_ACTIVE%TYPE DEFAULT NULL,
15: P_SQL_TEXT IN JTF_RS_DYNAMIC_GROUPS_B.SQL_TEXT%TYPE,
16: P_DATA OUT NOCOPY VARCHAR2,
17: P_COUNT OUT NOCOPY NUMBER,

Line 14: P_END_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.END_DATE_ACTIVE%TYPE DEFAULT NULL,

10: (P_GROUP_NAME IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_NAME%TYPE,
11: P_GROUP_DESC IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_DESC%TYPE DEFAULT NULL,
12: P_USAGE IN JTF_RS_DYNAMIC_GROUPS_B.USAGE%TYPE,
13: P_START_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.START_DATE_ACTIVE%TYPE,
14: P_END_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.END_DATE_ACTIVE%TYPE DEFAULT NULL,
15: P_SQL_TEXT IN JTF_RS_DYNAMIC_GROUPS_B.SQL_TEXT%TYPE,
16: P_DATA OUT NOCOPY VARCHAR2,
17: P_COUNT OUT NOCOPY NUMBER,
18: P_RETURN_CODE OUT NOCOPY VARCHAR2

Line 15: P_SQL_TEXT IN JTF_RS_DYNAMIC_GROUPS_B.SQL_TEXT%TYPE,

11: P_GROUP_DESC IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_DESC%TYPE DEFAULT NULL,
12: P_USAGE IN JTF_RS_DYNAMIC_GROUPS_B.USAGE%TYPE,
13: P_START_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.START_DATE_ACTIVE%TYPE,
14: P_END_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.END_DATE_ACTIVE%TYPE DEFAULT NULL,
15: P_SQL_TEXT IN JTF_RS_DYNAMIC_GROUPS_B.SQL_TEXT%TYPE,
16: P_DATA OUT NOCOPY VARCHAR2,
17: P_COUNT OUT NOCOPY NUMBER,
18: P_RETURN_CODE OUT NOCOPY VARCHAR2
19: )

Line 27: (P_GROUP_ID IN JTF_RS_DYNAMIC_GROUPS_B.GROUP_ID%TYPE,

23: END;
24:
25:
26: PROCEDURE update_dynamic_groups_pre
27: (P_GROUP_ID IN JTF_RS_DYNAMIC_GROUPS_B.GROUP_ID%TYPE,
28: P_GROUP_NUMBER IN JTF_RS_DYNAMIC_GROUPS_B.GROUP_NUMBER%TYPE,
29: P_GROUP_NAME IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
30: P_GROUP_DESC IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
31: P_USAGE IN JTF_RS_DYNAMIC_GROUPS_B.USAGE%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 28: P_GROUP_NUMBER IN JTF_RS_DYNAMIC_GROUPS_B.GROUP_NUMBER%TYPE,

24:
25:
26: PROCEDURE update_dynamic_groups_pre
27: (P_GROUP_ID IN JTF_RS_DYNAMIC_GROUPS_B.GROUP_ID%TYPE,
28: P_GROUP_NUMBER IN JTF_RS_DYNAMIC_GROUPS_B.GROUP_NUMBER%TYPE,
29: P_GROUP_NAME IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
30: P_GROUP_DESC IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
31: P_USAGE IN JTF_RS_DYNAMIC_GROUPS_B.USAGE%TYPE DEFAULT FND_API.G_MISS_CHAR,
32: P_START_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,

Line 31: P_USAGE IN JTF_RS_DYNAMIC_GROUPS_B.USAGE%TYPE DEFAULT FND_API.G_MISS_CHAR,

27: (P_GROUP_ID IN JTF_RS_DYNAMIC_GROUPS_B.GROUP_ID%TYPE,
28: P_GROUP_NUMBER IN JTF_RS_DYNAMIC_GROUPS_B.GROUP_NUMBER%TYPE,
29: P_GROUP_NAME IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
30: P_GROUP_DESC IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
31: P_USAGE IN JTF_RS_DYNAMIC_GROUPS_B.USAGE%TYPE DEFAULT FND_API.G_MISS_CHAR,
32: P_START_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
33: P_END_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
34: P_SQL_TEXT IN JTF_RS_DYNAMIC_GROUPS_B.SQL_TEXT%TYPE DEFAULT FND_API.G_MISS_CHAR,
35: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_DYNAMIC_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE,

Line 32: P_START_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,

28: P_GROUP_NUMBER IN JTF_RS_DYNAMIC_GROUPS_B.GROUP_NUMBER%TYPE,
29: P_GROUP_NAME IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
30: P_GROUP_DESC IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
31: P_USAGE IN JTF_RS_DYNAMIC_GROUPS_B.USAGE%TYPE DEFAULT FND_API.G_MISS_CHAR,
32: P_START_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
33: P_END_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
34: P_SQL_TEXT IN JTF_RS_DYNAMIC_GROUPS_B.SQL_TEXT%TYPE DEFAULT FND_API.G_MISS_CHAR,
35: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_DYNAMIC_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE,
36: P_DATA OUT NOCOPY VARCHAR2,

Line 33: P_END_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,

29: P_GROUP_NAME IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
30: P_GROUP_DESC IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
31: P_USAGE IN JTF_RS_DYNAMIC_GROUPS_B.USAGE%TYPE DEFAULT FND_API.G_MISS_CHAR,
32: P_START_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
33: P_END_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
34: P_SQL_TEXT IN JTF_RS_DYNAMIC_GROUPS_B.SQL_TEXT%TYPE DEFAULT FND_API.G_MISS_CHAR,
35: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_DYNAMIC_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE,
36: P_DATA OUT NOCOPY VARCHAR2,
37: P_COUNT OUT NOCOPY NUMBER,

Line 34: P_SQL_TEXT IN JTF_RS_DYNAMIC_GROUPS_B.SQL_TEXT%TYPE DEFAULT FND_API.G_MISS_CHAR,

30: P_GROUP_DESC IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
31: P_USAGE IN JTF_RS_DYNAMIC_GROUPS_B.USAGE%TYPE DEFAULT FND_API.G_MISS_CHAR,
32: P_START_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
33: P_END_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
34: P_SQL_TEXT IN JTF_RS_DYNAMIC_GROUPS_B.SQL_TEXT%TYPE DEFAULT FND_API.G_MISS_CHAR,
35: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_DYNAMIC_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE,
36: P_DATA OUT NOCOPY VARCHAR2,
37: P_COUNT OUT NOCOPY NUMBER,
38: P_RETURN_CODE OUT NOCOPY VARCHAR2

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

31: P_USAGE IN JTF_RS_DYNAMIC_GROUPS_B.USAGE%TYPE DEFAULT FND_API.G_MISS_CHAR,
32: P_START_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
33: P_END_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
34: P_SQL_TEXT IN JTF_RS_DYNAMIC_GROUPS_B.SQL_TEXT%TYPE DEFAULT FND_API.G_MISS_CHAR,
35: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_DYNAMIC_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE,
36: P_DATA OUT NOCOPY VARCHAR2,
37: P_COUNT OUT NOCOPY NUMBER,
38: P_RETURN_CODE OUT NOCOPY VARCHAR2
39: )

Line 47: (P_GROUP_ID IN JTF_RS_DYNAMIC_GROUPS_B.GROUP_ID%TYPE,

43: END;
44:
45:
46: PROCEDURE delete_dynamic_groups_pre
47: (P_GROUP_ID IN JTF_RS_DYNAMIC_GROUPS_B.GROUP_ID%TYPE,
48: P_OBJECT_VERSION_NUMBER IN JTF_RS_DYNAMIC_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE,
49: P_DATA OUT NOCOPY VARCHAR2,
50: P_COUNT OUT NOCOPY NUMBER,
51: P_RETURN_CODE OUT NOCOPY VARCHAR2

Line 48: P_OBJECT_VERSION_NUMBER IN JTF_RS_DYNAMIC_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE,

44:
45:
46: PROCEDURE delete_dynamic_groups_pre
47: (P_GROUP_ID IN JTF_RS_DYNAMIC_GROUPS_B.GROUP_ID%TYPE,
48: P_OBJECT_VERSION_NUMBER IN JTF_RS_DYNAMIC_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE,
49: P_DATA OUT NOCOPY VARCHAR2,
50: P_COUNT OUT NOCOPY NUMBER,
51: P_RETURN_CODE OUT NOCOPY VARCHAR2
52: )

Line 60: (P_GROUP_ID IN JTF_RS_DYNAMIC_GROUPS_B.GROUP_ID%TYPE,

56: END;
57:
58:
59: PROCEDURE create_dynamic_groups_post
60: (P_GROUP_ID IN JTF_RS_DYNAMIC_GROUPS_B.GROUP_ID%TYPE,
61: P_GROUP_NAME IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_NAME%TYPE,
62: P_GROUP_DESC IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_DESC%TYPE DEFAULT NULL,
63: P_USAGE IN JTF_RS_DYNAMIC_GROUPS_B.USAGE%TYPE,
64: P_START_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.START_DATE_ACTIVE%TYPE,

Line 63: P_USAGE IN JTF_RS_DYNAMIC_GROUPS_B.USAGE%TYPE,

59: PROCEDURE create_dynamic_groups_post
60: (P_GROUP_ID IN JTF_RS_DYNAMIC_GROUPS_B.GROUP_ID%TYPE,
61: P_GROUP_NAME IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_NAME%TYPE,
62: P_GROUP_DESC IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_DESC%TYPE DEFAULT NULL,
63: P_USAGE IN JTF_RS_DYNAMIC_GROUPS_B.USAGE%TYPE,
64: P_START_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.START_DATE_ACTIVE%TYPE,
65: P_END_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.END_DATE_ACTIVE%TYPE DEFAULT NULL,
66: P_SQL_TEXT IN JTF_RS_DYNAMIC_GROUPS_B.SQL_TEXT%TYPE,
67: P_DATA OUT NOCOPY VARCHAR2,

Line 64: P_START_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.START_DATE_ACTIVE%TYPE,

60: (P_GROUP_ID IN JTF_RS_DYNAMIC_GROUPS_B.GROUP_ID%TYPE,
61: P_GROUP_NAME IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_NAME%TYPE,
62: P_GROUP_DESC IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_DESC%TYPE DEFAULT NULL,
63: P_USAGE IN JTF_RS_DYNAMIC_GROUPS_B.USAGE%TYPE,
64: P_START_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.START_DATE_ACTIVE%TYPE,
65: P_END_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.END_DATE_ACTIVE%TYPE DEFAULT NULL,
66: P_SQL_TEXT IN JTF_RS_DYNAMIC_GROUPS_B.SQL_TEXT%TYPE,
67: P_DATA OUT NOCOPY VARCHAR2,
68: P_COUNT OUT NOCOPY NUMBER,

Line 65: P_END_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.END_DATE_ACTIVE%TYPE DEFAULT NULL,

61: P_GROUP_NAME IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_NAME%TYPE,
62: P_GROUP_DESC IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_DESC%TYPE DEFAULT NULL,
63: P_USAGE IN JTF_RS_DYNAMIC_GROUPS_B.USAGE%TYPE,
64: P_START_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.START_DATE_ACTIVE%TYPE,
65: P_END_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.END_DATE_ACTIVE%TYPE DEFAULT NULL,
66: P_SQL_TEXT IN JTF_RS_DYNAMIC_GROUPS_B.SQL_TEXT%TYPE,
67: P_DATA OUT NOCOPY VARCHAR2,
68: P_COUNT OUT NOCOPY NUMBER,
69: P_RETURN_CODE OUT NOCOPY VARCHAR2

Line 66: P_SQL_TEXT IN JTF_RS_DYNAMIC_GROUPS_B.SQL_TEXT%TYPE,

62: P_GROUP_DESC IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_DESC%TYPE DEFAULT NULL,
63: P_USAGE IN JTF_RS_DYNAMIC_GROUPS_B.USAGE%TYPE,
64: P_START_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.START_DATE_ACTIVE%TYPE,
65: P_END_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.END_DATE_ACTIVE%TYPE DEFAULT NULL,
66: P_SQL_TEXT IN JTF_RS_DYNAMIC_GROUPS_B.SQL_TEXT%TYPE,
67: P_DATA OUT NOCOPY VARCHAR2,
68: P_COUNT OUT NOCOPY NUMBER,
69: P_RETURN_CODE OUT NOCOPY VARCHAR2
70: )

Line 79: (P_GROUP_ID IN JTF_RS_DYNAMIC_GROUPS_B.GROUP_ID%TYPE,

75:
76:
77:
78: PROCEDURE update_dynamic_groups_post
79: (P_GROUP_ID IN JTF_RS_DYNAMIC_GROUPS_B.GROUP_ID%TYPE,
80: P_GROUP_NUMBER IN JTF_RS_DYNAMIC_GROUPS_B.GROUP_NUMBER%TYPE,
81: P_GROUP_NAME IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
82: P_GROUP_DESC IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
83: P_USAGE IN JTF_RS_DYNAMIC_GROUPS_B.USAGE%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 80: P_GROUP_NUMBER IN JTF_RS_DYNAMIC_GROUPS_B.GROUP_NUMBER%TYPE,

76:
77:
78: PROCEDURE update_dynamic_groups_post
79: (P_GROUP_ID IN JTF_RS_DYNAMIC_GROUPS_B.GROUP_ID%TYPE,
80: P_GROUP_NUMBER IN JTF_RS_DYNAMIC_GROUPS_B.GROUP_NUMBER%TYPE,
81: P_GROUP_NAME IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
82: P_GROUP_DESC IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
83: P_USAGE IN JTF_RS_DYNAMIC_GROUPS_B.USAGE%TYPE DEFAULT FND_API.G_MISS_CHAR,
84: P_START_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,

Line 83: P_USAGE IN JTF_RS_DYNAMIC_GROUPS_B.USAGE%TYPE DEFAULT FND_API.G_MISS_CHAR,

79: (P_GROUP_ID IN JTF_RS_DYNAMIC_GROUPS_B.GROUP_ID%TYPE,
80: P_GROUP_NUMBER IN JTF_RS_DYNAMIC_GROUPS_B.GROUP_NUMBER%TYPE,
81: P_GROUP_NAME IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
82: P_GROUP_DESC IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
83: P_USAGE IN JTF_RS_DYNAMIC_GROUPS_B.USAGE%TYPE DEFAULT FND_API.G_MISS_CHAR,
84: P_START_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
85: P_END_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
86: P_SQL_TEXT IN JTF_RS_DYNAMIC_GROUPS_B.SQL_TEXT%TYPE DEFAULT FND_API.G_MISS_CHAR,
87: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_DYNAMIC_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE,

Line 84: P_START_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,

80: P_GROUP_NUMBER IN JTF_RS_DYNAMIC_GROUPS_B.GROUP_NUMBER%TYPE,
81: P_GROUP_NAME IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
82: P_GROUP_DESC IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
83: P_USAGE IN JTF_RS_DYNAMIC_GROUPS_B.USAGE%TYPE DEFAULT FND_API.G_MISS_CHAR,
84: P_START_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
85: P_END_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
86: P_SQL_TEXT IN JTF_RS_DYNAMIC_GROUPS_B.SQL_TEXT%TYPE DEFAULT FND_API.G_MISS_CHAR,
87: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_DYNAMIC_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE,
88: P_DATA OUT NOCOPY VARCHAR2,

Line 85: P_END_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,

81: P_GROUP_NAME IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
82: P_GROUP_DESC IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
83: P_USAGE IN JTF_RS_DYNAMIC_GROUPS_B.USAGE%TYPE DEFAULT FND_API.G_MISS_CHAR,
84: P_START_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
85: P_END_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
86: P_SQL_TEXT IN JTF_RS_DYNAMIC_GROUPS_B.SQL_TEXT%TYPE DEFAULT FND_API.G_MISS_CHAR,
87: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_DYNAMIC_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE,
88: P_DATA OUT NOCOPY VARCHAR2,
89: P_COUNT OUT NOCOPY NUMBER,

Line 86: P_SQL_TEXT IN JTF_RS_DYNAMIC_GROUPS_B.SQL_TEXT%TYPE DEFAULT FND_API.G_MISS_CHAR,

82: P_GROUP_DESC IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
83: P_USAGE IN JTF_RS_DYNAMIC_GROUPS_B.USAGE%TYPE DEFAULT FND_API.G_MISS_CHAR,
84: P_START_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
85: P_END_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
86: P_SQL_TEXT IN JTF_RS_DYNAMIC_GROUPS_B.SQL_TEXT%TYPE DEFAULT FND_API.G_MISS_CHAR,
87: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_DYNAMIC_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE,
88: P_DATA OUT NOCOPY VARCHAR2,
89: P_COUNT OUT NOCOPY NUMBER,
90: P_RETURN_CODE OUT NOCOPY VARCHAR2

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

83: P_USAGE IN JTF_RS_DYNAMIC_GROUPS_B.USAGE%TYPE DEFAULT FND_API.G_MISS_CHAR,
84: P_START_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
85: P_END_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
86: P_SQL_TEXT IN JTF_RS_DYNAMIC_GROUPS_B.SQL_TEXT%TYPE DEFAULT FND_API.G_MISS_CHAR,
87: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_DYNAMIC_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE,
88: P_DATA OUT NOCOPY VARCHAR2,
89: P_COUNT OUT NOCOPY NUMBER,
90: P_RETURN_CODE OUT NOCOPY VARCHAR2
91: )

Line 100: (P_GROUP_ID IN JTF_RS_DYNAMIC_GROUPS_B.GROUP_ID%TYPE,

96:
97:
98:
99: PROCEDURE delete_dynamic_groups_post
100: (P_GROUP_ID IN JTF_RS_DYNAMIC_GROUPS_B.GROUP_ID%TYPE,
101: P_OBJECT_VERSION_NUMBER IN JTF_RS_DYNAMIC_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE,
102: P_DATA OUT NOCOPY VARCHAR2,
103: P_COUNT OUT NOCOPY NUMBER,
104: P_RETURN_CODE OUT NOCOPY VARCHAR2

Line 101: P_OBJECT_VERSION_NUMBER IN JTF_RS_DYNAMIC_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE,

97:
98:
99: PROCEDURE delete_dynamic_groups_post
100: (P_GROUP_ID IN JTF_RS_DYNAMIC_GROUPS_B.GROUP_ID%TYPE,
101: P_OBJECT_VERSION_NUMBER IN JTF_RS_DYNAMIC_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE,
102: P_DATA OUT NOCOPY VARCHAR2,
103: P_COUNT OUT NOCOPY NUMBER,
104: P_RETURN_CODE OUT NOCOPY VARCHAR2
105: )