16: G_NUMBER CONSTANT NUMBER := 1; -- data type is number
17: G_VARCHAR2 CONSTANT NUMBER := 2; -- data type is varchar2
18:
19: TYPE cas_Rec_Type IS RECORD
20: ( CAS_ID NUMBER := FND_API.G_MISS_NUM,
21: CASE_NUMBER VARCHAR2(240) := FND_API.G_MISS_CHAR,
22: ACTIVE_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR,
23: PARTY_ID NUMBER := FND_API.G_MISS_NUM,
24: ORIG_CAS_ID NUMBER := FND_API.G_MISS_NUM,
17: G_VARCHAR2 CONSTANT NUMBER := 2; -- data type is varchar2
18:
19: TYPE cas_Rec_Type IS RECORD
20: ( CAS_ID NUMBER := FND_API.G_MISS_NUM,
21: CASE_NUMBER VARCHAR2(240) := FND_API.G_MISS_CHAR,
22: ACTIVE_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR,
23: PARTY_ID NUMBER := FND_API.G_MISS_NUM,
24: ORIG_CAS_ID NUMBER := FND_API.G_MISS_NUM,
25: CASE_STATE VARCHAR2(240) := FND_API.G_MISS_CHAR,
18:
19: TYPE cas_Rec_Type IS RECORD
20: ( CAS_ID NUMBER := FND_API.G_MISS_NUM,
21: CASE_NUMBER VARCHAR2(240) := FND_API.G_MISS_CHAR,
22: ACTIVE_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR,
23: PARTY_ID NUMBER := FND_API.G_MISS_NUM,
24: ORIG_CAS_ID NUMBER := FND_API.G_MISS_NUM,
25: CASE_STATE VARCHAR2(240) := FND_API.G_MISS_CHAR,
26: STATUS_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
19: TYPE cas_Rec_Type IS RECORD
20: ( CAS_ID NUMBER := FND_API.G_MISS_NUM,
21: CASE_NUMBER VARCHAR2(240) := FND_API.G_MISS_CHAR,
22: ACTIVE_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR,
23: PARTY_ID NUMBER := FND_API.G_MISS_NUM,
24: ORIG_CAS_ID NUMBER := FND_API.G_MISS_NUM,
25: CASE_STATE VARCHAR2(240) := FND_API.G_MISS_CHAR,
26: STATUS_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
27: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
20: ( CAS_ID NUMBER := FND_API.G_MISS_NUM,
21: CASE_NUMBER VARCHAR2(240) := FND_API.G_MISS_CHAR,
22: ACTIVE_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR,
23: PARTY_ID NUMBER := FND_API.G_MISS_NUM,
24: ORIG_CAS_ID NUMBER := FND_API.G_MISS_NUM,
25: CASE_STATE VARCHAR2(240) := FND_API.G_MISS_CHAR,
26: STATUS_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
27: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
28: CASE_ESTABLISHED_DATE DATE := FND_API.G_MISS_DATE,
21: CASE_NUMBER VARCHAR2(240) := FND_API.G_MISS_CHAR,
22: ACTIVE_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR,
23: PARTY_ID NUMBER := FND_API.G_MISS_NUM,
24: ORIG_CAS_ID NUMBER := FND_API.G_MISS_NUM,
25: CASE_STATE VARCHAR2(240) := FND_API.G_MISS_CHAR,
26: STATUS_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
27: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
28: CASE_ESTABLISHED_DATE DATE := FND_API.G_MISS_DATE,
29: CASE_CLOSING_DATE DATE := FND_API.G_MISS_DATE,
22: ACTIVE_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR,
23: PARTY_ID NUMBER := FND_API.G_MISS_NUM,
24: ORIG_CAS_ID NUMBER := FND_API.G_MISS_NUM,
25: CASE_STATE VARCHAR2(240) := FND_API.G_MISS_CHAR,
26: STATUS_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
27: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
28: CASE_ESTABLISHED_DATE DATE := FND_API.G_MISS_DATE,
29: CASE_CLOSING_DATE DATE := FND_API.G_MISS_DATE,
30: OWNER_RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
23: PARTY_ID NUMBER := FND_API.G_MISS_NUM,
24: ORIG_CAS_ID NUMBER := FND_API.G_MISS_NUM,
25: CASE_STATE VARCHAR2(240) := FND_API.G_MISS_CHAR,
26: STATUS_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
27: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
28: CASE_ESTABLISHED_DATE DATE := FND_API.G_MISS_DATE,
29: CASE_CLOSING_DATE DATE := FND_API.G_MISS_DATE,
30: OWNER_RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
31: ACCESS_RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
24: ORIG_CAS_ID NUMBER := FND_API.G_MISS_NUM,
25: CASE_STATE VARCHAR2(240) := FND_API.G_MISS_CHAR,
26: STATUS_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
27: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
28: CASE_ESTABLISHED_DATE DATE := FND_API.G_MISS_DATE,
29: CASE_CLOSING_DATE DATE := FND_API.G_MISS_DATE,
30: OWNER_RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
31: ACCESS_RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
32: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
25: CASE_STATE VARCHAR2(240) := FND_API.G_MISS_CHAR,
26: STATUS_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
27: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
28: CASE_ESTABLISHED_DATE DATE := FND_API.G_MISS_DATE,
29: CASE_CLOSING_DATE DATE := FND_API.G_MISS_DATE,
30: OWNER_RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
31: ACCESS_RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
32: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
33: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
26: STATUS_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
27: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
28: CASE_ESTABLISHED_DATE DATE := FND_API.G_MISS_DATE,
29: CASE_CLOSING_DATE DATE := FND_API.G_MISS_DATE,
30: OWNER_RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
31: ACCESS_RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
32: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
33: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
34: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
27: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
28: CASE_ESTABLISHED_DATE DATE := FND_API.G_MISS_DATE,
29: CASE_CLOSING_DATE DATE := FND_API.G_MISS_DATE,
30: OWNER_RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
31: ACCESS_RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
32: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
33: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
34: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
35: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
28: CASE_ESTABLISHED_DATE DATE := FND_API.G_MISS_DATE,
29: CASE_CLOSING_DATE DATE := FND_API.G_MISS_DATE,
30: OWNER_RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
31: ACCESS_RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
32: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
33: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
34: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
35: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
36: ATTRIBUTE_CATEGORY VARCHAR2(240) := FND_API.G_MISS_CHAR,
29: CASE_CLOSING_DATE DATE := FND_API.G_MISS_DATE,
30: OWNER_RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
31: ACCESS_RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
32: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
33: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
34: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
35: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
36: ATTRIBUTE_CATEGORY VARCHAR2(240) := FND_API.G_MISS_CHAR,
37: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
30: OWNER_RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
31: ACCESS_RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
32: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
33: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
34: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
35: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
36: ATTRIBUTE_CATEGORY VARCHAR2(240) := FND_API.G_MISS_CHAR,
37: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
38: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
31: ACCESS_RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
32: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
33: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
34: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
35: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
36: ATTRIBUTE_CATEGORY VARCHAR2(240) := FND_API.G_MISS_CHAR,
37: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
38: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
39: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
32: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
33: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
34: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
35: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
36: ATTRIBUTE_CATEGORY VARCHAR2(240) := FND_API.G_MISS_CHAR,
37: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
38: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
39: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
40: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
33: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
34: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
35: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
36: ATTRIBUTE_CATEGORY VARCHAR2(240) := FND_API.G_MISS_CHAR,
37: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
38: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
39: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
40: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
41: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
34: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
35: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
36: ATTRIBUTE_CATEGORY VARCHAR2(240) := FND_API.G_MISS_CHAR,
37: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
38: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
39: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
40: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
41: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
42: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
35: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
36: ATTRIBUTE_CATEGORY VARCHAR2(240) := FND_API.G_MISS_CHAR,
37: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
38: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
39: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
40: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
41: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
42: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
43: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
36: ATTRIBUTE_CATEGORY VARCHAR2(240) := FND_API.G_MISS_CHAR,
37: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
38: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
39: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
40: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
41: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
42: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
43: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
44: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
37: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
38: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
39: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
40: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
41: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
42: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
43: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
44: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
45: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
38: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
39: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
40: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
41: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
42: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
43: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
44: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
45: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
46: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
39: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
40: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
41: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
42: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
43: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
44: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
45: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
46: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
47: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
40: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
41: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
42: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
43: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
44: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
45: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
46: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
47: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
48: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
41: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
42: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
43: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
44: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
45: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
46: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
47: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
48: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
49: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
42: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
43: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
44: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
45: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
46: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
47: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
48: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
49: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
50: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
43: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
44: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
45: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
46: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
47: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
48: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
49: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
50: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
51: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
44: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
45: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
46: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
47: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
48: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
49: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
50: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
51: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
52: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
45: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
46: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
47: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
48: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
49: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
50: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
51: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
52: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
53: CREATION_DATE DATE := FND_API.G_MISS_DATE,
46: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
47: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
48: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
49: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
50: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
51: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
52: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
53: CREATION_DATE DATE := FND_API.G_MISS_DATE,
54: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
47: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
48: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
49: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
50: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
51: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
52: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
53: CREATION_DATE DATE := FND_API.G_MISS_DATE,
54: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
55: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
48: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
49: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
50: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
51: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
52: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
53: CREATION_DATE DATE := FND_API.G_MISS_DATE,
54: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
55: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
56: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
49: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
50: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
51: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
52: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
53: CREATION_DATE DATE := FND_API.G_MISS_DATE,
54: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
55: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
56: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
57: CLOSE_REASON VARCHAR2(240) := FND_API.G_MISS_CHAR,
50: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
51: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
52: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
53: CREATION_DATE DATE := FND_API.G_MISS_DATE,
54: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
55: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
56: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
57: CLOSE_REASON VARCHAR2(240) := FND_API.G_MISS_CHAR,
58: ORG_ID NUMBER := FND_API.G_MISS_NUM,
51: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
52: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
53: CREATION_DATE DATE := FND_API.G_MISS_DATE,
54: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
55: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
56: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
57: CLOSE_REASON VARCHAR2(240) := FND_API.G_MISS_CHAR,
58: ORG_ID NUMBER := FND_API.G_MISS_NUM,
59: COMMENTS VARCHAR2(240) := FND_API.G_MISS_CHAR,
52: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
53: CREATION_DATE DATE := FND_API.G_MISS_DATE,
54: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
55: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
56: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
57: CLOSE_REASON VARCHAR2(240) := FND_API.G_MISS_CHAR,
58: ORG_ID NUMBER := FND_API.G_MISS_NUM,
59: COMMENTS VARCHAR2(240) := FND_API.G_MISS_CHAR,
60: PREDICTED_RECOVERY_AMOUNT NUMBER := FND_API.G_MISS_NUM,
53: CREATION_DATE DATE := FND_API.G_MISS_DATE,
54: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
55: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
56: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
57: CLOSE_REASON VARCHAR2(240) := FND_API.G_MISS_CHAR,
58: ORG_ID NUMBER := FND_API.G_MISS_NUM,
59: COMMENTS VARCHAR2(240) := FND_API.G_MISS_CHAR,
60: PREDICTED_RECOVERY_AMOUNT NUMBER := FND_API.G_MISS_NUM,
61: PREDICTED_CHANCE NUMBER := FND_API.G_MISS_NUM
54: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
55: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
56: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
57: CLOSE_REASON VARCHAR2(240) := FND_API.G_MISS_CHAR,
58: ORG_ID NUMBER := FND_API.G_MISS_NUM,
59: COMMENTS VARCHAR2(240) := FND_API.G_MISS_CHAR,
60: PREDICTED_RECOVERY_AMOUNT NUMBER := FND_API.G_MISS_NUM,
61: PREDICTED_CHANCE NUMBER := FND_API.G_MISS_NUM
62: );
55: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
56: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
57: CLOSE_REASON VARCHAR2(240) := FND_API.G_MISS_CHAR,
58: ORG_ID NUMBER := FND_API.G_MISS_NUM,
59: COMMENTS VARCHAR2(240) := FND_API.G_MISS_CHAR,
60: PREDICTED_RECOVERY_AMOUNT NUMBER := FND_API.G_MISS_NUM,
61: PREDICTED_CHANCE NUMBER := FND_API.G_MISS_NUM
62: );
63:
56: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
57: CLOSE_REASON VARCHAR2(240) := FND_API.G_MISS_CHAR,
58: ORG_ID NUMBER := FND_API.G_MISS_NUM,
59: COMMENTS VARCHAR2(240) := FND_API.G_MISS_CHAR,
60: PREDICTED_RECOVERY_AMOUNT NUMBER := FND_API.G_MISS_NUM,
61: PREDICTED_CHANCE NUMBER := FND_API.G_MISS_NUM
62: );
63:
64: G_MISS_cas_REC cas_Rec_Type;
57: CLOSE_REASON VARCHAR2(240) := FND_API.G_MISS_CHAR,
58: ORG_ID NUMBER := FND_API.G_MISS_NUM,
59: COMMENTS VARCHAR2(240) := FND_API.G_MISS_CHAR,
60: PREDICTED_RECOVERY_AMOUNT NUMBER := FND_API.G_MISS_NUM,
61: PREDICTED_CHANCE NUMBER := FND_API.G_MISS_NUM
62: );
63:
64: G_MISS_cas_REC cas_Rec_Type;
65: TYPE cas_Tbl_Type IS TABLE OF cas_Rec_Type INDEX BY BINARY_INTEGER;