59: -- End of Comments
60:
61: TYPE cas_Rec_Type IS RECORD
62: (
63: CAS_ID NUMBER := FND_API.G_MISS_NUM,
64: CASE_NUMBER VARCHAR2(240) := FND_API.G_MISS_CHAR,
65: ACTIVE_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR,
66: PARTY_ID NUMBER := FND_API.G_MISS_NUM,
67: ORIG_CAS_ID NUMBER := FND_API.G_MISS_NUM,
60:
61: TYPE cas_Rec_Type IS RECORD
62: (
63: CAS_ID NUMBER := FND_API.G_MISS_NUM,
64: CASE_NUMBER VARCHAR2(240) := FND_API.G_MISS_CHAR,
65: ACTIVE_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR,
66: PARTY_ID NUMBER := FND_API.G_MISS_NUM,
67: ORIG_CAS_ID NUMBER := FND_API.G_MISS_NUM,
68: CASE_STATE VARCHAR2(240) := FND_API.G_MISS_CHAR,
61: TYPE cas_Rec_Type IS RECORD
62: (
63: CAS_ID NUMBER := FND_API.G_MISS_NUM,
64: CASE_NUMBER VARCHAR2(240) := FND_API.G_MISS_CHAR,
65: ACTIVE_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR,
66: PARTY_ID NUMBER := FND_API.G_MISS_NUM,
67: ORIG_CAS_ID NUMBER := FND_API.G_MISS_NUM,
68: CASE_STATE VARCHAR2(240) := FND_API.G_MISS_CHAR,
69: STATUS_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
62: (
63: CAS_ID NUMBER := FND_API.G_MISS_NUM,
64: CASE_NUMBER VARCHAR2(240) := FND_API.G_MISS_CHAR,
65: ACTIVE_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR,
66: PARTY_ID NUMBER := FND_API.G_MISS_NUM,
67: ORIG_CAS_ID NUMBER := FND_API.G_MISS_NUM,
68: CASE_STATE VARCHAR2(240) := FND_API.G_MISS_CHAR,
69: STATUS_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
70: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
63: CAS_ID NUMBER := FND_API.G_MISS_NUM,
64: CASE_NUMBER VARCHAR2(240) := FND_API.G_MISS_CHAR,
65: ACTIVE_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR,
66: PARTY_ID NUMBER := FND_API.G_MISS_NUM,
67: ORIG_CAS_ID NUMBER := FND_API.G_MISS_NUM,
68: CASE_STATE VARCHAR2(240) := FND_API.G_MISS_CHAR,
69: STATUS_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
70: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
71: CASE_ESTABLISHED_DATE DATE := FND_API.G_MISS_DATE,
64: CASE_NUMBER VARCHAR2(240) := FND_API.G_MISS_CHAR,
65: ACTIVE_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR,
66: PARTY_ID NUMBER := FND_API.G_MISS_NUM,
67: ORIG_CAS_ID NUMBER := FND_API.G_MISS_NUM,
68: CASE_STATE VARCHAR2(240) := FND_API.G_MISS_CHAR,
69: STATUS_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
70: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
71: CASE_ESTABLISHED_DATE DATE := FND_API.G_MISS_DATE,
72: CASE_CLOSING_DATE DATE := FND_API.G_MISS_DATE,
65: ACTIVE_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR,
66: PARTY_ID NUMBER := FND_API.G_MISS_NUM,
67: ORIG_CAS_ID NUMBER := FND_API.G_MISS_NUM,
68: CASE_STATE VARCHAR2(240) := FND_API.G_MISS_CHAR,
69: STATUS_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
70: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
71: CASE_ESTABLISHED_DATE DATE := FND_API.G_MISS_DATE,
72: CASE_CLOSING_DATE DATE := FND_API.G_MISS_DATE,
73: OWNER_RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
66: PARTY_ID NUMBER := FND_API.G_MISS_NUM,
67: ORIG_CAS_ID NUMBER := FND_API.G_MISS_NUM,
68: CASE_STATE VARCHAR2(240) := FND_API.G_MISS_CHAR,
69: STATUS_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
70: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
71: CASE_ESTABLISHED_DATE DATE := FND_API.G_MISS_DATE,
72: CASE_CLOSING_DATE DATE := FND_API.G_MISS_DATE,
73: OWNER_RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
74: ACCESS_RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
67: ORIG_CAS_ID NUMBER := FND_API.G_MISS_NUM,
68: CASE_STATE VARCHAR2(240) := FND_API.G_MISS_CHAR,
69: STATUS_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
70: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
71: CASE_ESTABLISHED_DATE DATE := FND_API.G_MISS_DATE,
72: CASE_CLOSING_DATE DATE := FND_API.G_MISS_DATE,
73: OWNER_RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
74: ACCESS_RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
75: PREDICTED_RECOVERY_AMOUNT NUMBER := FND_API.G_MISS_NUM,
68: CASE_STATE VARCHAR2(240) := FND_API.G_MISS_CHAR,
69: STATUS_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
70: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
71: CASE_ESTABLISHED_DATE DATE := FND_API.G_MISS_DATE,
72: CASE_CLOSING_DATE DATE := FND_API.G_MISS_DATE,
73: OWNER_RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
74: ACCESS_RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
75: PREDICTED_RECOVERY_AMOUNT NUMBER := FND_API.G_MISS_NUM,
76: PREDICTED_CHANCE NUMBER := FND_API.G_MISS_NUM,
69: STATUS_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
70: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
71: CASE_ESTABLISHED_DATE DATE := FND_API.G_MISS_DATE,
72: CASE_CLOSING_DATE DATE := FND_API.G_MISS_DATE,
73: OWNER_RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
74: ACCESS_RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
75: PREDICTED_RECOVERY_AMOUNT NUMBER := FND_API.G_MISS_NUM,
76: PREDICTED_CHANCE NUMBER := FND_API.G_MISS_NUM,
77: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
70: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
71: CASE_ESTABLISHED_DATE DATE := FND_API.G_MISS_DATE,
72: CASE_CLOSING_DATE DATE := FND_API.G_MISS_DATE,
73: OWNER_RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
74: ACCESS_RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
75: PREDICTED_RECOVERY_AMOUNT NUMBER := FND_API.G_MISS_NUM,
76: PREDICTED_CHANCE NUMBER := FND_API.G_MISS_NUM,
77: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
78: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
71: CASE_ESTABLISHED_DATE DATE := FND_API.G_MISS_DATE,
72: CASE_CLOSING_DATE DATE := FND_API.G_MISS_DATE,
73: OWNER_RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
74: ACCESS_RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
75: PREDICTED_RECOVERY_AMOUNT NUMBER := FND_API.G_MISS_NUM,
76: PREDICTED_CHANCE NUMBER := FND_API.G_MISS_NUM,
77: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
78: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
79: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
72: CASE_CLOSING_DATE DATE := FND_API.G_MISS_DATE,
73: OWNER_RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
74: ACCESS_RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
75: PREDICTED_RECOVERY_AMOUNT NUMBER := FND_API.G_MISS_NUM,
76: PREDICTED_CHANCE NUMBER := FND_API.G_MISS_NUM,
77: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
78: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
79: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
80: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
73: OWNER_RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
74: ACCESS_RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
75: PREDICTED_RECOVERY_AMOUNT NUMBER := FND_API.G_MISS_NUM,
76: PREDICTED_CHANCE NUMBER := FND_API.G_MISS_NUM,
77: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
78: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
79: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
80: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
81: ATTRIBUTE_CATEGORY VARCHAR2(240) := FND_API.G_MISS_CHAR,
74: ACCESS_RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
75: PREDICTED_RECOVERY_AMOUNT NUMBER := FND_API.G_MISS_NUM,
76: PREDICTED_CHANCE NUMBER := FND_API.G_MISS_NUM,
77: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
78: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
79: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
80: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
81: ATTRIBUTE_CATEGORY VARCHAR2(240) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
75: PREDICTED_RECOVERY_AMOUNT NUMBER := FND_API.G_MISS_NUM,
76: PREDICTED_CHANCE NUMBER := FND_API.G_MISS_NUM,
77: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
78: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
79: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
80: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
81: ATTRIBUTE_CATEGORY VARCHAR2(240) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
83: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
76: PREDICTED_CHANCE NUMBER := FND_API.G_MISS_NUM,
77: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
78: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
79: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
80: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
81: ATTRIBUTE_CATEGORY VARCHAR2(240) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
83: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
77: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
78: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
79: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
80: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
81: ATTRIBUTE_CATEGORY VARCHAR2(240) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
83: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
85: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
78: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
79: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
80: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
81: ATTRIBUTE_CATEGORY VARCHAR2(240) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
83: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
85: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
86: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
79: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
80: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
81: ATTRIBUTE_CATEGORY VARCHAR2(240) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
83: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
85: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
86: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
87: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
80: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
81: ATTRIBUTE_CATEGORY VARCHAR2(240) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
83: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
85: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
86: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
87: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
88: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE_CATEGORY VARCHAR2(240) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
83: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
85: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
86: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
87: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
88: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
89: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
83: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
85: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
86: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
87: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
88: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
89: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
90: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
83: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
85: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
86: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
87: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
88: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
89: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
90: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
91: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
85: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
86: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
87: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
88: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
89: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
90: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
91: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
92: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
85: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
86: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
87: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
88: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
89: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
90: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
91: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
92: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
93: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
86: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
87: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
88: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
89: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
90: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
91: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
92: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
93: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
94: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
87: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
88: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
89: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
90: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
91: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
92: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
93: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
94: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
95: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
88: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
89: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
90: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
91: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
92: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
93: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
94: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
95: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
96: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
89: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
90: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
91: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
92: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
93: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
94: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
95: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
96: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
97: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
90: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
91: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
92: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
93: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
94: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
95: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
96: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
97: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
98: CREATION_DATE DATE := FND_API.G_MISS_DATE,
91: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
92: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
93: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
94: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
95: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
96: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
97: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
98: CREATION_DATE DATE := FND_API.G_MISS_DATE,
99: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
92: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
93: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
94: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
95: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
96: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
97: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
98: CREATION_DATE DATE := FND_API.G_MISS_DATE,
99: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
100: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
93: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
94: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
95: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
96: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
97: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
98: CREATION_DATE DATE := FND_API.G_MISS_DATE,
99: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
100: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
101: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
94: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
95: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
96: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
97: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
98: CREATION_DATE DATE := FND_API.G_MISS_DATE,
99: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
100: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
101: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
102: ORG_ID NUMBER := FND_API.G_MISS_NUM,
95: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
96: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
97: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
98: CREATION_DATE DATE := FND_API.G_MISS_DATE,
99: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
100: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
101: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
102: ORG_ID NUMBER := FND_API.G_MISS_NUM,
103: CLOSE_REASON VARCHAR2(240) := FND_API.G_MISS_CHAR,
96: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
97: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
98: CREATION_DATE DATE := FND_API.G_MISS_DATE,
99: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
100: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
101: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
102: ORG_ID NUMBER := FND_API.G_MISS_NUM,
103: CLOSE_REASON VARCHAR2(240) := FND_API.G_MISS_CHAR,
104: COMMENTS VARCHAR2(240) := FND_API.G_MISS_CHAR
97: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
98: CREATION_DATE DATE := FND_API.G_MISS_DATE,
99: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
100: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
101: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
102: ORG_ID NUMBER := FND_API.G_MISS_NUM,
103: CLOSE_REASON VARCHAR2(240) := FND_API.G_MISS_CHAR,
104: COMMENTS VARCHAR2(240) := FND_API.G_MISS_CHAR
105: );
98: CREATION_DATE DATE := FND_API.G_MISS_DATE,
99: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
100: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
101: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
102: ORG_ID NUMBER := FND_API.G_MISS_NUM,
103: CLOSE_REASON VARCHAR2(240) := FND_API.G_MISS_CHAR,
104: COMMENTS VARCHAR2(240) := FND_API.G_MISS_CHAR
105: );
106:
99: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
100: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
101: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
102: ORG_ID NUMBER := FND_API.G_MISS_NUM,
103: CLOSE_REASON VARCHAR2(240) := FND_API.G_MISS_CHAR,
104: COMMENTS VARCHAR2(240) := FND_API.G_MISS_CHAR
105: );
106:
107: G_MISS_cas_REC cas_Rec_Type;
100: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
101: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
102: ORG_ID NUMBER := FND_API.G_MISS_NUM,
103: CLOSE_REASON VARCHAR2(240) := FND_API.G_MISS_CHAR,
104: COMMENTS VARCHAR2(240) := FND_API.G_MISS_CHAR
105: );
106:
107: G_MISS_cas_REC cas_Rec_Type;
108: TYPE cas_Tbl_Type IS TABLE OF cas_Rec_Type
119: -- Pre-Req :
120: -- Parameters:
121: -- IN
122: -- p_api_version_number IN NUMBER Required
123: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
124: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
125: -- P_cas_Rec IN case_object_Rec_Type Required
126: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
127: --
120: -- Parameters:
121: -- IN
122: -- p_api_version_number IN NUMBER Required
123: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
124: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
125: -- P_cas_Rec IN case_object_Rec_Type Required
126: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
127: --
128: -- OUT:
122: -- p_api_version_number IN NUMBER Required
123: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
124: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
125: -- P_cas_Rec IN case_object_Rec_Type Required
126: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
127: --
128: -- OUT:
129: -- x_case_id OUT NOCOPY NUMBER
130: -- x_return_status OUT NOCOPY VARCHAR2
135: -- End of Comments
136: --
137: PROCEDURE Create_CAS(
138: P_Api_Version_Number IN NUMBER,
139: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
140: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
141: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
142: P_CAS_Rec IN CAS_Rec_Type := G_MISS_CAS_REC,
143: X_CASE_ID OUT NOCOPY NUMBER,
136: --
137: PROCEDURE Create_CAS(
138: P_Api_Version_Number IN NUMBER,
139: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
140: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
141: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
142: P_CAS_Rec IN CAS_Rec_Type := G_MISS_CAS_REC,
143: X_CASE_ID OUT NOCOPY NUMBER,
144: X_Return_Status OUT NOCOPY VARCHAR2,
137: PROCEDURE Create_CAS(
138: P_Api_Version_Number IN NUMBER,
139: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
140: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
141: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
142: P_CAS_Rec IN CAS_Rec_Type := G_MISS_CAS_REC,
143: X_CASE_ID OUT NOCOPY NUMBER,
144: X_Return_Status OUT NOCOPY VARCHAR2,
145: X_Msg_Count OUT NOCOPY NUMBER,
154: -- Pre-Req :
155: -- Parameters:
156: -- IN
157: -- p_api_version_number IN NUMBER Required
158: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
159: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
160: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
161: -- P_CAS_Rec IN CAS_Rec_Type Required
162: -- OUT:
155: -- Parameters:
156: -- IN
157: -- p_api_version_number IN NUMBER Required
158: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
159: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
160: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
161: -- P_CAS_Rec IN CAS_Rec_Type Required
162: -- OUT:
163: -- x_return_status OUT NOCOPY VARCHAR2
156: -- IN
157: -- p_api_version_number IN NUMBER Required
158: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
159: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
160: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
161: -- P_CAS_Rec IN CAS_Rec_Type Required
162: -- OUT:
163: -- x_return_status OUT NOCOPY VARCHAR2
164: -- x_msg_count OUT NOCOPY NUMBER
171: --
172: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
173: PROCEDURE Update_CAS(
174: P_Api_Version_Number IN NUMBER,
175: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
176: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
177: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
178: P_CAS_Rec IN CAS_Rec_Type,
179: X_Return_Status OUT NOCOPY VARCHAR2,
172: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
173: PROCEDURE Update_CAS(
174: P_Api_Version_Number IN NUMBER,
175: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
176: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
177: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
178: P_CAS_Rec IN CAS_Rec_Type,
179: X_Return_Status OUT NOCOPY VARCHAR2,
180: X_Msg_Count OUT NOCOPY NUMBER,
173: PROCEDURE Update_CAS(
174: P_Api_Version_Number IN NUMBER,
175: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
176: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
177: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
178: P_CAS_Rec IN CAS_Rec_Type,
179: X_Return_Status OUT NOCOPY VARCHAR2,
180: X_Msg_Count OUT NOCOPY NUMBER,
181: X_Msg_Data OUT NOCOPY VARCHAR2,
191: -- Pre-Req :
192: -- Parameters:
193: -- IN
194: -- p_api_version_number IN NUMBER Required
195: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
196: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
197: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
198: -- OUT:
199: -- x_return_status OUT NOCOPY VARCHAR2
192: -- Parameters:
193: -- IN
194: -- p_api_version_number IN NUMBER Required
195: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
196: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
197: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
198: -- OUT:
199: -- x_return_status OUT NOCOPY VARCHAR2
200: -- x_msg_count OUT NOCOPY NUMBER
193: -- IN
194: -- p_api_version_number IN NUMBER Required
195: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
196: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
197: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
198: -- OUT:
199: -- x_return_status OUT NOCOPY VARCHAR2
200: -- x_msg_count OUT NOCOPY NUMBER
201: -- x_msg_data OUT NOCOPY VARCHAR2
208: -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
209: -- The Master delete procedure may not be needed depends on different business requirements.
210: PROCEDURE Delete_CAS(
211: P_Api_Version_Number IN NUMBER,
212: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
213: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
214: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
215: p_cas_id IN NUMBER ,
216: X_Return_Status OUT NOCOPY VARCHAR2,
209: -- The Master delete procedure may not be needed depends on different business requirements.
210: PROCEDURE Delete_CAS(
211: P_Api_Version_Number IN NUMBER,
212: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
213: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
214: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
215: p_cas_id IN NUMBER ,
216: X_Return_Status OUT NOCOPY VARCHAR2,
217: X_Msg_Count OUT NOCOPY NUMBER,
210: PROCEDURE Delete_CAS(
211: P_Api_Version_Number IN NUMBER,
212: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
213: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
214: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
215: p_cas_id IN NUMBER ,
216: X_Return_Status OUT NOCOPY VARCHAR2,
217: X_Msg_Count OUT NOCOPY NUMBER,
218: X_Msg_Data OUT NOCOPY VARCHAR2