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,
33: P_END_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
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,
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,
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,
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,
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,
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
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,
85: P_END_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
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,
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,
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,
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,
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,
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