DBA Data[Home] [Help]

APPS.IEX_CASES_PVT dependencies on FND_API

Line 63: CAS_ID NUMBER := FND_API.G_MISS_NUM,

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,

Line 64: CASE_NUMBER VARCHAR2(240) := FND_API.G_MISS_CHAR,

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,

Line 65: ACTIVE_FLAG 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,

Line 66: PARTY_ID NUMBER := FND_API.G_MISS_NUM,

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,

Line 67: ORIG_CAS_ID 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,

Line 68: CASE_STATE VARCHAR2(240) := FND_API.G_MISS_CHAR,

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,

Line 69: STATUS_CODE 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,
73: OWNER_RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,

Line 70: OBJECT_VERSION_NUMBER 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,

Line 71: CASE_ESTABLISHED_DATE DATE := FND_API.G_MISS_DATE,

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,

Line 72: CASE_CLOSING_DATE DATE := FND_API.G_MISS_DATE,

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,

Line 73: OWNER_RESOURCE_ID 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,

Line 74: ACCESS_RESOURCE_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,

Line 75: PREDICTED_RECOVERY_AMOUNT 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,

Line 76: PREDICTED_CHANCE 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,

Line 77: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,

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,

Line 78: PROGRAM_APPLICATION_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,
82: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 79: PROGRAM_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,
83: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 80: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

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,

Line 81: ATTRIBUTE_CATEGORY 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,

Line 82: ATTRIBUTE1 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,

Line 83: ATTRIBUTE2 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,

Line 84: ATTRIBUTE3 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,

Line 85: ATTRIBUTE4 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,

Line 86: ATTRIBUTE5 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,

Line 87: ATTRIBUTE6 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,

Line 88: ATTRIBUTE7 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,

Line 89: ATTRIBUTE8 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,

Line 90: ATTRIBUTE9 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,

Line 91: ATTRIBUTE10 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,

Line 92: ATTRIBUTE11 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,

Line 93: ATTRIBUTE12 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,

Line 94: ATTRIBUTE13 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,
98: CREATION_DATE DATE := FND_API.G_MISS_DATE,

Line 95: ATTRIBUTE14 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,
99: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,

Line 96: ATTRIBUTE15 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,
100: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

Line 97: CREATED_BY NUMBER := FND_API.G_MISS_NUM,

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,

Line 98: CREATION_DATE DATE := FND_API.G_MISS_DATE,

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,

Line 99: LAST_UPDATED_BY 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,

Line 100: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

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

Line 101: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,

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: );

Line 102: ORG_ID 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: );
106:

Line 103: CLOSE_REASON VARCHAR2(240) := FND_API.G_MISS_CHAR,

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;

Line 104: COMMENTS VARCHAR2(240) := FND_API.G_MISS_CHAR

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

Line 123: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

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: --

Line 124: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

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:

Line 126: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

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

Line 139: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 140: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 141: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,

Line 158: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

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:

Line 159: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

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

Line 160: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

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

Line 175: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 176: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 177: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,

Line 195: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

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

Line 196: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

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

Line 197: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

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

Line 212: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 213: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 214: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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