52: -- End of Comments
53:
54: TYPE CASE_DEFINITION_Rec_Type IS RECORD
55: (
56: CASE_DEFINITION_ID NUMBER := FND_API.G_MISS_NUM,
57: COLUMN_NAME VARCHAR2(240) := FND_API.G_MISS_CHAR,
58: COLUMN_VALUE VARCHAR2(240) := FND_API.G_MISS_CHAR,
59: ACTIVE_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR,
60: TABLE_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,
53:
54: TYPE CASE_DEFINITION_Rec_Type IS RECORD
55: (
56: CASE_DEFINITION_ID NUMBER := FND_API.G_MISS_NUM,
57: COLUMN_NAME VARCHAR2(240) := FND_API.G_MISS_CHAR,
58: COLUMN_VALUE VARCHAR2(240) := FND_API.G_MISS_CHAR,
59: ACTIVE_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR,
60: TABLE_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,
61: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
54: TYPE CASE_DEFINITION_Rec_Type IS RECORD
55: (
56: CASE_DEFINITION_ID NUMBER := FND_API.G_MISS_NUM,
57: COLUMN_NAME VARCHAR2(240) := FND_API.G_MISS_CHAR,
58: COLUMN_VALUE VARCHAR2(240) := FND_API.G_MISS_CHAR,
59: ACTIVE_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR,
60: TABLE_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,
61: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
62: CAS_ID NUMBER := FND_API.G_MISS_NUM,
55: (
56: CASE_DEFINITION_ID NUMBER := FND_API.G_MISS_NUM,
57: COLUMN_NAME VARCHAR2(240) := FND_API.G_MISS_CHAR,
58: COLUMN_VALUE VARCHAR2(240) := FND_API.G_MISS_CHAR,
59: ACTIVE_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR,
60: TABLE_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,
61: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
62: CAS_ID NUMBER := FND_API.G_MISS_NUM,
63: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
56: CASE_DEFINITION_ID NUMBER := FND_API.G_MISS_NUM,
57: COLUMN_NAME VARCHAR2(240) := FND_API.G_MISS_CHAR,
58: COLUMN_VALUE VARCHAR2(240) := FND_API.G_MISS_CHAR,
59: ACTIVE_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR,
60: TABLE_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,
61: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
62: CAS_ID NUMBER := FND_API.G_MISS_NUM,
63: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
64: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
57: COLUMN_NAME VARCHAR2(240) := FND_API.G_MISS_CHAR,
58: COLUMN_VALUE VARCHAR2(240) := FND_API.G_MISS_CHAR,
59: ACTIVE_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR,
60: TABLE_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,
61: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
62: CAS_ID NUMBER := FND_API.G_MISS_NUM,
63: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
64: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
65: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
58: COLUMN_VALUE VARCHAR2(240) := FND_API.G_MISS_CHAR,
59: ACTIVE_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR,
60: TABLE_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,
61: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
62: CAS_ID NUMBER := FND_API.G_MISS_NUM,
63: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
64: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
65: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
66: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
59: ACTIVE_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR,
60: TABLE_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,
61: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
62: CAS_ID NUMBER := FND_API.G_MISS_NUM,
63: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
64: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
65: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
66: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
67: ATTRIBUTE_CATEGORY VARCHAR2(240) := FND_API.G_MISS_CHAR,
60: TABLE_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,
61: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
62: CAS_ID NUMBER := FND_API.G_MISS_NUM,
63: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
64: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
65: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
66: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
67: ATTRIBUTE_CATEGORY VARCHAR2(240) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
61: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
62: CAS_ID NUMBER := FND_API.G_MISS_NUM,
63: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
64: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
65: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
66: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
67: ATTRIBUTE_CATEGORY VARCHAR2(240) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
62: CAS_ID NUMBER := FND_API.G_MISS_NUM,
63: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
64: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
65: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
66: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
67: ATTRIBUTE_CATEGORY VARCHAR2(240) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
63: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
64: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
65: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
66: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
67: ATTRIBUTE_CATEGORY VARCHAR2(240) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
64: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
65: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
66: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
67: ATTRIBUTE_CATEGORY VARCHAR2(240) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
65: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
66: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
67: ATTRIBUTE_CATEGORY VARCHAR2(240) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
66: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
67: ATTRIBUTE_CATEGORY VARCHAR2(240) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
67: ATTRIBUTE_CATEGORY VARCHAR2(240) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
83: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
76: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
83: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
84: CREATION_DATE DATE := FND_API.G_MISS_DATE,
77: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
83: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
84: CREATION_DATE DATE := FND_API.G_MISS_DATE,
85: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
78: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
83: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
84: CREATION_DATE DATE := FND_API.G_MISS_DATE,
85: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
86: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
79: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
83: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
84: CREATION_DATE DATE := FND_API.G_MISS_DATE,
85: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
86: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
87: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
80: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
83: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
84: CREATION_DATE DATE := FND_API.G_MISS_DATE,
85: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
86: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
87: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
88: );
81: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
83: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
84: CREATION_DATE DATE := FND_API.G_MISS_DATE,
85: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
86: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
87: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
88: );
89:
82: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
83: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
84: CREATION_DATE DATE := FND_API.G_MISS_DATE,
85: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
86: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
87: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
88: );
89:
90: G_MISS_CASE_DEFINITION_REC CASE_DEFINITION_Rec_Type;
83: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
84: CREATION_DATE DATE := FND_API.G_MISS_DATE,
85: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
86: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
87: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
88: );
89:
90: G_MISS_CASE_DEFINITION_REC CASE_DEFINITION_Rec_Type;
91: TYPE CASE_DEFINITION_Tbl_Type IS TABLE OF CASE_DEFINITION_Rec_Type
100: -- Pre-Req :
101: -- Parameters:
102: -- IN
103: -- p_api_version_number IN NUMBER Required
104: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
105: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
106: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
107: -- P_CASE_DEFINITION_Rec IN CASE_DEFINITION_Rec_Type Required
108:
101: -- Parameters:
102: -- IN
103: -- p_api_version_number IN NUMBER Required
104: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
105: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
106: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
107: -- P_CASE_DEFINITION_Rec IN CASE_DEFINITION_Rec_Type Required
108:
109: --
102: -- IN
103: -- p_api_version_number IN NUMBER Required
104: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
105: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
106: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
107: -- P_CASE_DEFINITION_Rec IN CASE_DEFINITION_Rec_Type Required
108:
109: --
110: -- OUT:
120: -- End of Comments
121: --
122: PROCEDURE Create_CASE_DEFINITIONS(
123: P_Api_Version_Number IN NUMBER,
124: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
125: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
126: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
127: P_CASE_DEFINITION_Rec IN CASE_DEFINITION_Rec_Type := G_MISS_CASE_DEFINITION_REC,
128: X_CASE_DEFINITION_ID OUT NOCOPY NUMBER,
121: --
122: PROCEDURE Create_CASE_DEFINITIONS(
123: P_Api_Version_Number IN NUMBER,
124: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
125: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
126: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
127: P_CASE_DEFINITION_Rec IN CASE_DEFINITION_Rec_Type := G_MISS_CASE_DEFINITION_REC,
128: X_CASE_DEFINITION_ID OUT NOCOPY NUMBER,
129: X_Return_Status OUT NOCOPY VARCHAR2,
122: PROCEDURE Create_CASE_DEFINITIONS(
123: P_Api_Version_Number IN NUMBER,
124: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
125: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
126: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
127: P_CASE_DEFINITION_Rec IN CASE_DEFINITION_Rec_Type := G_MISS_CASE_DEFINITION_REC,
128: X_CASE_DEFINITION_ID OUT NOCOPY NUMBER,
129: X_Return_Status OUT NOCOPY VARCHAR2,
130: X_Msg_Count OUT NOCOPY NUMBER,
139: -- Pre-Req :
140: -- Parameters:
141: -- IN
142: -- p_api_version_number IN NUMBER Required
143: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
144: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
145: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
146: -- P_CASE_DEFINITION_Rec IN CASE_DEFINITION_Rec_Type Required
147: --
140: -- Parameters:
141: -- IN
142: -- p_api_version_number IN NUMBER Required
143: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
144: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
145: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
146: -- P_CASE_DEFINITION_Rec IN CASE_DEFINITION_Rec_Type Required
147: --
148: -- OUT:
141: -- IN
142: -- p_api_version_number IN NUMBER Required
143: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
144: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
145: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
146: -- P_CASE_DEFINITION_Rec IN CASE_DEFINITION_Rec_Type Required
147: --
148: -- OUT:
149: -- x_return_status OUT NOCOPY VARCHAR2
154: --
155: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
156: PROCEDURE Update_CASE_DEFINITIONS(
157: P_Api_Version_Number IN NUMBER,
158: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
159: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
160: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
161: P_CASE_DEFINITION_Rec IN CASE_DEFINITION_Rec_Type,
162: X_Return_Status OUT NOCOPY VARCHAR2,
155: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
156: PROCEDURE Update_CASE_DEFINITIONS(
157: P_Api_Version_Number IN NUMBER,
158: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
159: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
160: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
161: P_CASE_DEFINITION_Rec IN CASE_DEFINITION_Rec_Type,
162: X_Return_Status OUT NOCOPY VARCHAR2,
163: X_Msg_Count OUT NOCOPY NUMBER,
156: PROCEDURE Update_CASE_DEFINITIONS(
157: P_Api_Version_Number IN NUMBER,
158: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
159: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
160: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
161: P_CASE_DEFINITION_Rec IN CASE_DEFINITION_Rec_Type,
162: X_Return_Status OUT NOCOPY VARCHAR2,
163: X_Msg_Count OUT NOCOPY NUMBER,
164: X_Msg_Data OUT NOCOPY VARCHAR2,
173: -- Pre-Req :
174: -- Parameters:
175: -- IN
176: -- p_api_version_number IN NUMBER Required
177: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
178: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
179: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
180: -- P_CASE_DEFINITION_Rec IN CASE_DEFINITION_Rec_Type Required
181: --
174: -- Parameters:
175: -- IN
176: -- p_api_version_number IN NUMBER Required
177: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
178: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
179: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
180: -- P_CASE_DEFINITION_Rec IN CASE_DEFINITION_Rec_Type Required
181: --
182: -- OUT:
175: -- IN
176: -- p_api_version_number IN NUMBER Required
177: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
178: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
179: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
180: -- P_CASE_DEFINITION_Rec IN CASE_DEFINITION_Rec_Type Required
181: --
182: -- OUT:
183: -- x_return_status OUT NOCOPY VARCHAR2
192: -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
193: -- The Master delete procedure may not be needed depends on different business requirements.
194: PROCEDURE Delete_CASE_DEFINITIONS(
195: P_Api_Version_Number IN NUMBER,
196: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
197: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
198: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
199: P_CASE_DEFINITION_Id IN NUMBER,
200: X_Return_Status OUT NOCOPY VARCHAR2,
193: -- The Master delete procedure may not be needed depends on different business requirements.
194: PROCEDURE Delete_CASE_DEFINITIONS(
195: P_Api_Version_Number IN NUMBER,
196: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
197: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
198: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
199: P_CASE_DEFINITION_Id IN NUMBER,
200: X_Return_Status OUT NOCOPY VARCHAR2,
201: X_Msg_Count OUT NOCOPY NUMBER,
194: PROCEDURE Delete_CASE_DEFINITIONS(
195: P_Api_Version_Number IN NUMBER,
196: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
197: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
198: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
199: P_CASE_DEFINITION_Id IN NUMBER,
200: X_Return_Status OUT NOCOPY VARCHAR2,
201: X_Msg_Count OUT NOCOPY NUMBER,
202: X_Msg_Data OUT NOCOPY VARCHAR2