51: -- End of Comments
52:
53: TYPE case_object_Rec_Type IS RECORD
54: (
55: CASE_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
56: object_id NUMBER := FND_API.G_MISS_NUM,
57: OBJECT_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
58: ACTIVE_FLAG VARCHAR2(30) := FND_API.G_MISS_CHAR,
59: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
52:
53: TYPE case_object_Rec_Type IS RECORD
54: (
55: CASE_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
56: object_id NUMBER := FND_API.G_MISS_NUM,
57: OBJECT_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
58: ACTIVE_FLAG VARCHAR2(30) := FND_API.G_MISS_CHAR,
59: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
60: CAS_ID NUMBER := FND_API.G_MISS_NUM,
53: TYPE case_object_Rec_Type IS RECORD
54: (
55: CASE_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
56: object_id NUMBER := FND_API.G_MISS_NUM,
57: OBJECT_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
58: ACTIVE_FLAG VARCHAR2(30) := FND_API.G_MISS_CHAR,
59: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
60: CAS_ID NUMBER := FND_API.G_MISS_NUM,
61: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
54: (
55: CASE_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
56: object_id NUMBER := FND_API.G_MISS_NUM,
57: OBJECT_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
58: ACTIVE_FLAG VARCHAR2(30) := FND_API.G_MISS_CHAR,
59: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
60: CAS_ID NUMBER := FND_API.G_MISS_NUM,
61: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
62: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
55: CASE_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
56: object_id NUMBER := FND_API.G_MISS_NUM,
57: OBJECT_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
58: ACTIVE_FLAG VARCHAR2(30) := FND_API.G_MISS_CHAR,
59: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
60: CAS_ID NUMBER := FND_API.G_MISS_NUM,
61: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
62: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
63: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
56: object_id NUMBER := FND_API.G_MISS_NUM,
57: OBJECT_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
58: ACTIVE_FLAG VARCHAR2(30) := FND_API.G_MISS_CHAR,
59: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
60: CAS_ID NUMBER := FND_API.G_MISS_NUM,
61: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
62: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
63: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
64: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
57: OBJECT_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
58: ACTIVE_FLAG VARCHAR2(30) := FND_API.G_MISS_CHAR,
59: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
60: CAS_ID NUMBER := FND_API.G_MISS_NUM,
61: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
62: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
63: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
64: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
65: ATTRIBUTE_CATEGORY VARCHAR2(240) := FND_API.G_MISS_CHAR,
58: ACTIVE_FLAG VARCHAR2(30) := FND_API.G_MISS_CHAR,
59: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
60: CAS_ID NUMBER := FND_API.G_MISS_NUM,
61: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
62: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
63: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
64: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
65: ATTRIBUTE_CATEGORY VARCHAR2(240) := FND_API.G_MISS_CHAR,
66: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
59: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
60: CAS_ID NUMBER := FND_API.G_MISS_NUM,
61: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
62: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
63: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
64: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
65: ATTRIBUTE_CATEGORY VARCHAR2(240) := FND_API.G_MISS_CHAR,
66: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
67: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
60: CAS_ID NUMBER := FND_API.G_MISS_NUM,
61: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
62: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
63: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
64: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
65: ATTRIBUTE_CATEGORY VARCHAR2(240) := FND_API.G_MISS_CHAR,
66: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
67: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
61: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
62: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
63: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
64: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
65: ATTRIBUTE_CATEGORY VARCHAR2(240) := FND_API.G_MISS_CHAR,
66: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
67: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
62: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
63: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
64: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
65: ATTRIBUTE_CATEGORY VARCHAR2(240) := FND_API.G_MISS_CHAR,
66: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
67: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
63: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
64: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
65: ATTRIBUTE_CATEGORY VARCHAR2(240) := FND_API.G_MISS_CHAR,
66: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
67: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
64: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
65: ATTRIBUTE_CATEGORY VARCHAR2(240) := FND_API.G_MISS_CHAR,
66: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
67: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
65: ATTRIBUTE_CATEGORY VARCHAR2(240) := FND_API.G_MISS_CHAR,
66: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
67: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
66: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
67: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
67: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
81: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
74: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
81: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
82: CREATION_DATE DATE := FND_API.G_MISS_DATE,
75: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
81: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
82: CREATION_DATE DATE := FND_API.G_MISS_DATE,
83: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
76: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
81: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
82: CREATION_DATE DATE := FND_API.G_MISS_DATE,
83: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
84: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
77: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
81: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
82: CREATION_DATE DATE := FND_API.G_MISS_DATE,
83: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
84: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
85: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
78: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
81: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
82: CREATION_DATE DATE := FND_API.G_MISS_DATE,
83: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
84: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
85: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
86: );
79: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
81: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
82: CREATION_DATE DATE := FND_API.G_MISS_DATE,
83: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
84: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
85: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
86: );
87:
80: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
81: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
82: CREATION_DATE DATE := FND_API.G_MISS_DATE,
83: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
84: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
85: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
86: );
87:
88: G_MISS_case_object_REC case_object_Rec_Type;
81: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
82: CREATION_DATE DATE := FND_API.G_MISS_DATE,
83: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
84: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
85: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
86: );
87:
88: G_MISS_case_object_REC case_object_Rec_Type;
89: TYPE case_object_Tbl_Type IS TABLE OF case_object_Rec_Type
98: -- Pre-Req :
99: -- Parameters:
100: -- IN
101: -- p_api_version_number IN NUMBER Required
102: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
103: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
104: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
105: -- P_case_object_Rec IN case_object_Rec_Type Required
106:
99: -- Parameters:
100: -- IN
101: -- p_api_version_number IN NUMBER Required
102: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
103: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
104: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
105: -- P_case_object_Rec IN case_object_Rec_Type Required
106:
107: --
100: -- IN
101: -- p_api_version_number IN NUMBER Required
102: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
103: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
104: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
105: -- P_case_object_Rec IN case_object_Rec_Type Required
106:
107: --
108: -- OUT:
118: -- End of Comments
119: --
120: PROCEDURE Create_case_objects(
121: P_Api_Version_Number IN NUMBER,
122: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
123: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
124: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
125: P_case_object_Rec IN case_object_Rec_Type := G_MISS_case_object_REC,
126: X_CASE_OBJECT_ID OUT NOCOPY NUMBER,
119: --
120: PROCEDURE Create_case_objects(
121: P_Api_Version_Number IN NUMBER,
122: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
123: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
124: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
125: P_case_object_Rec IN case_object_Rec_Type := G_MISS_case_object_REC,
126: X_CASE_OBJECT_ID OUT NOCOPY NUMBER,
127: X_Return_Status OUT NOCOPY VARCHAR2,
120: PROCEDURE Create_case_objects(
121: P_Api_Version_Number IN NUMBER,
122: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
123: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
124: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
125: P_case_object_Rec IN case_object_Rec_Type := G_MISS_case_object_REC,
126: X_CASE_OBJECT_ID OUT NOCOPY NUMBER,
127: X_Return_Status OUT NOCOPY VARCHAR2,
128: X_Msg_Count OUT NOCOPY NUMBER,
137: -- Pre-Req :
138: -- Parameters:
139: -- IN
140: -- p_api_version_number IN NUMBER Required
141: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
142: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
143: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
144: -- P_case_object_Rec IN case_object_Rec_Type Required
145: --
138: -- Parameters:
139: -- IN
140: -- p_api_version_number IN NUMBER Required
141: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
142: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
143: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
144: -- P_case_object_Rec IN case_object_Rec_Type Required
145: --
146: -- OUT:
139: -- IN
140: -- p_api_version_number IN NUMBER Required
141: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
142: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
143: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
144: -- P_case_object_Rec IN case_object_Rec_Type Required
145: --
146: -- OUT:
147: -- x_return_status OUT NOCOPY VARCHAR2
152: --
153: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
154: PROCEDURE Update_case_objects(
155: P_Api_Version_Number IN NUMBER,
156: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
157: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
158: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
159: P_case_object_Rec IN case_object_Rec_Type,
160: X_Return_Status OUT NOCOPY VARCHAR2,
153: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
154: PROCEDURE Update_case_objects(
155: P_Api_Version_Number IN NUMBER,
156: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
157: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
158: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
159: P_case_object_Rec IN case_object_Rec_Type,
160: X_Return_Status OUT NOCOPY VARCHAR2,
161: X_Msg_Count OUT NOCOPY NUMBER,
154: PROCEDURE Update_case_objects(
155: P_Api_Version_Number IN NUMBER,
156: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
157: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
158: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
159: P_case_object_Rec IN case_object_Rec_Type,
160: X_Return_Status OUT NOCOPY VARCHAR2,
161: X_Msg_Count OUT NOCOPY NUMBER,
162: X_Msg_Data OUT NOCOPY VARCHAR2,
171: -- Pre-Req :
172: -- Parameters:
173: -- IN
174: -- p_api_version_number IN NUMBER Required
175: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
176: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
177: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
178: -- P_case_object_Rec IN case_object_Rec_Type Required
179: --
172: -- Parameters:
173: -- IN
174: -- p_api_version_number IN NUMBER Required
175: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
176: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
177: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
178: -- P_case_object_Rec IN case_object_Rec_Type Required
179: --
180: -- OUT:
173: -- IN
174: -- p_api_version_number IN NUMBER Required
175: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
176: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
177: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
178: -- P_case_object_Rec IN case_object_Rec_Type Required
179: --
180: -- OUT:
181: -- x_return_status OUT NOCOPY VARCHAR2
190: -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
191: -- The Master delete procedure may not be needed depends on different business requirements.
192: PROCEDURE Delete_case_objects(
193: P_Api_Version_Number IN NUMBER,
194: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
195: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
196: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
197: P_case_object_Id IN NUMBER,
198: X_Return_Status OUT NOCOPY VARCHAR2,
191: -- The Master delete procedure may not be needed depends on different business requirements.
192: PROCEDURE Delete_case_objects(
193: P_Api_Version_Number IN NUMBER,
194: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
195: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
196: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
197: P_case_object_Id IN NUMBER,
198: X_Return_Status OUT NOCOPY VARCHAR2,
199: X_Msg_Count OUT NOCOPY NUMBER,
192: PROCEDURE Delete_case_objects(
193: P_Api_Version_Number IN NUMBER,
194: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
195: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
196: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
197: P_case_object_Id IN NUMBER,
198: X_Return_Status OUT NOCOPY VARCHAR2,
199: X_Msg_Count OUT NOCOPY NUMBER,
200: X_Msg_Data OUT NOCOPY VARCHAR2