43: * @rep:displayname Create Dynamic Group
44: */
45: PROCEDURE create_dynamic_groups
46: (P_API_VERSION IN NUMBER,
47: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
48: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
49: P_GROUP_NAME IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_NAME%TYPE,
50: P_GROUP_DESC IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_DESC%TYPE DEFAULT NULL,
51: P_USAGE IN JTF_RS_DYNAMIC_GROUPS_B.USAGE%TYPE,
44: */
45: PROCEDURE create_dynamic_groups
46: (P_API_VERSION IN NUMBER,
47: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
48: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
49: P_GROUP_NAME IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_NAME%TYPE,
50: P_GROUP_DESC IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_DESC%TYPE DEFAULT NULL,
51: P_USAGE IN JTF_RS_DYNAMIC_GROUPS_B.USAGE%TYPE,
52: P_START_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.START_DATE_ACTIVE%TYPE,
84: * @rep:displayname Update Dynamic Group
85: */
86: PROCEDURE update_dynamic_groups
87: (P_API_VERSION IN NUMBER,
88: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
89: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
90: P_GROUP_ID IN JTF_RS_DYNAMIC_GROUPS_B.GROUP_ID%TYPE,
91: P_GROUP_NUMBER IN JTF_RS_DYNAMIC_GROUPS_B.GROUP_NUMBER%TYPE,
92: P_GROUP_NAME IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
85: */
86: PROCEDURE update_dynamic_groups
87: (P_API_VERSION IN NUMBER,
88: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
89: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
90: P_GROUP_ID IN JTF_RS_DYNAMIC_GROUPS_B.GROUP_ID%TYPE,
91: P_GROUP_NUMBER IN JTF_RS_DYNAMIC_GROUPS_B.GROUP_NUMBER%TYPE,
92: P_GROUP_NAME IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
93: P_GROUP_DESC IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
88: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
89: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
90: P_GROUP_ID IN JTF_RS_DYNAMIC_GROUPS_B.GROUP_ID%TYPE,
91: P_GROUP_NUMBER IN JTF_RS_DYNAMIC_GROUPS_B.GROUP_NUMBER%TYPE,
92: P_GROUP_NAME IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
93: P_GROUP_DESC IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
94: P_USAGE IN JTF_RS_DYNAMIC_GROUPS_B.USAGE%TYPE DEFAULT FND_API.G_MISS_CHAR,
95: P_START_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
96: P_END_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
89: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
90: P_GROUP_ID IN JTF_RS_DYNAMIC_GROUPS_B.GROUP_ID%TYPE,
91: P_GROUP_NUMBER IN JTF_RS_DYNAMIC_GROUPS_B.GROUP_NUMBER%TYPE,
92: P_GROUP_NAME IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
93: P_GROUP_DESC IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
94: P_USAGE IN JTF_RS_DYNAMIC_GROUPS_B.USAGE%TYPE DEFAULT FND_API.G_MISS_CHAR,
95: P_START_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
96: P_END_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
97: P_SQL_TEXT IN JTF_RS_DYNAMIC_GROUPS_B.SQL_TEXT%TYPE DEFAULT FND_API.G_MISS_CHAR,
90: P_GROUP_ID IN JTF_RS_DYNAMIC_GROUPS_B.GROUP_ID%TYPE,
91: P_GROUP_NUMBER IN JTF_RS_DYNAMIC_GROUPS_B.GROUP_NUMBER%TYPE,
92: P_GROUP_NAME IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
93: P_GROUP_DESC IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
94: P_USAGE IN JTF_RS_DYNAMIC_GROUPS_B.USAGE%TYPE DEFAULT FND_API.G_MISS_CHAR,
95: P_START_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
96: P_END_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
97: P_SQL_TEXT IN JTF_RS_DYNAMIC_GROUPS_B.SQL_TEXT%TYPE DEFAULT FND_API.G_MISS_CHAR,
98: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_DYNAMIC_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE,
91: P_GROUP_NUMBER IN JTF_RS_DYNAMIC_GROUPS_B.GROUP_NUMBER%TYPE,
92: P_GROUP_NAME IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
93: P_GROUP_DESC IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
94: P_USAGE IN JTF_RS_DYNAMIC_GROUPS_B.USAGE%TYPE DEFAULT FND_API.G_MISS_CHAR,
95: P_START_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
96: P_END_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
97: P_SQL_TEXT IN JTF_RS_DYNAMIC_GROUPS_B.SQL_TEXT%TYPE DEFAULT FND_API.G_MISS_CHAR,
98: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_DYNAMIC_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE,
99: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
92: P_GROUP_NAME IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
93: P_GROUP_DESC IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
94: P_USAGE IN JTF_RS_DYNAMIC_GROUPS_B.USAGE%TYPE DEFAULT FND_API.G_MISS_CHAR,
95: P_START_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
96: P_END_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
97: P_SQL_TEXT IN JTF_RS_DYNAMIC_GROUPS_B.SQL_TEXT%TYPE DEFAULT FND_API.G_MISS_CHAR,
98: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_DYNAMIC_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE,
99: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
100: X_MSG_COUNT OUT NOCOPY NUMBER,
93: P_GROUP_DESC IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
94: P_USAGE IN JTF_RS_DYNAMIC_GROUPS_B.USAGE%TYPE DEFAULT FND_API.G_MISS_CHAR,
95: P_START_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
96: P_END_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
97: P_SQL_TEXT IN JTF_RS_DYNAMIC_GROUPS_B.SQL_TEXT%TYPE DEFAULT FND_API.G_MISS_CHAR,
98: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_DYNAMIC_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE,
99: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
100: X_MSG_COUNT OUT NOCOPY NUMBER,
101: X_MSG_DATA OUT NOCOPY VARCHAR2
118: * @rep:displayname Delete Dynamic Group
119: */
120: PROCEDURE delete_dynamic_groups
121: (P_API_VERSION IN NUMBER,
122: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
123: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
124: P_GROUP_ID IN JTF_RS_DYNAMIC_GROUPS_B.GROUP_ID%TYPE,
125: P_OBJECT_VERSION_NUMBER IN JTF_RS_DYNAMIC_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE,
126: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
119: */
120: PROCEDURE delete_dynamic_groups
121: (P_API_VERSION IN NUMBER,
122: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
123: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
124: P_GROUP_ID IN JTF_RS_DYNAMIC_GROUPS_B.GROUP_ID%TYPE,
125: P_OBJECT_VERSION_NUMBER IN JTF_RS_DYNAMIC_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE,
126: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
127: X_MSG_COUNT OUT NOCOPY NUMBER,