79: -- the sequence.
80: -- 4. If a flag column is passed in, check if it is 'Y' or 'N'.
81: -- Raise exception for invalid flag.
82: -- 5. If a flag column is not passed in, default it to 'Y' or 'N'.
83: -- 6. Please don't pass in any FND_API.g_mess_char/num/date.
84: ---------------------------------------------------------------------
85: PROCEDURE Create_Claim_Type(
86: p_api_version IN NUMBER
87: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
83: -- 6. Please don't pass in any FND_API.g_mess_char/num/date.
84: ---------------------------------------------------------------------
85: PROCEDURE Create_Claim_Type(
86: p_api_version IN NUMBER
87: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
88: ,p_commit IN VARCHAR2 := FND_API.g_false
89: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
90:
91: ,x_return_status OUT NOCOPY VARCHAR2
84: ---------------------------------------------------------------------
85: PROCEDURE Create_Claim_Type(
86: p_api_version IN NUMBER
87: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
88: ,p_commit IN VARCHAR2 := FND_API.g_false
89: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
90:
91: ,x_return_status OUT NOCOPY VARCHAR2
92: ,x_msg_count OUT NOCOPY NUMBER
85: PROCEDURE Create_Claim_Type(
86: p_api_version IN NUMBER
87: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
88: ,p_commit IN VARCHAR2 := FND_API.g_false
89: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
90:
91: ,x_return_status OUT NOCOPY VARCHAR2
92: ,x_msg_count OUT NOCOPY NUMBER
93: ,x_msg_data OUT NOCOPY VARCHAR2
111: -- 1. Raise exception if the object_version_number doesn't match.
112: --------------------------------------------------------------------
113: PROCEDURE Delete_Claim_Type(
114: p_api_version IN NUMBER
115: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
116: ,p_commit IN VARCHAR2 := FND_API.g_false
117:
118: ,x_return_status OUT NOCOPY VARCHAR2
119: ,x_msg_count OUT NOCOPY NUMBER
112: --------------------------------------------------------------------
113: PROCEDURE Delete_Claim_Type(
114: p_api_version IN NUMBER
115: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
116: ,p_commit IN VARCHAR2 := FND_API.g_false
117:
118: ,x_return_status OUT NOCOPY VARCHAR2
119: ,x_msg_count OUT NOCOPY NUMBER
120: ,x_msg_data OUT NOCOPY VARCHAR2
137: -- p_mode : determines what sort of validation is to be performed during update.
138: --
139: -- NOTES
140: -- 1. Raise exception if the object_version_number doesn't match.
141: -- 2. If an attribute is passed in as FND_API.g_miss_char/num/date,
142: -- that column won't be updated.
143: ----------------------------------------------------------------------
144: PROCEDURE Update_Claim_Type(
145: p_api_version IN NUMBER
142: -- that column won't be updated.
143: ----------------------------------------------------------------------
144: PROCEDURE Update_Claim_Type(
145: p_api_version IN NUMBER
146: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
147: ,p_commit IN VARCHAR2 := FND_API.g_false
148: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
149:
150: ,x_return_status OUT NOCOPY VARCHAR2
143: ----------------------------------------------------------------------
144: PROCEDURE Update_Claim_Type(
145: p_api_version IN NUMBER
146: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
147: ,p_commit IN VARCHAR2 := FND_API.g_false
148: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
149:
150: ,x_return_status OUT NOCOPY VARCHAR2
151: ,x_msg_count OUT NOCOPY NUMBER
144: PROCEDURE Update_Claim_Type(
145: p_api_version IN NUMBER
146: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
147: ,p_commit IN VARCHAR2 := FND_API.g_false
148: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
149:
150: ,x_return_status OUT NOCOPY VARCHAR2
151: ,x_msg_count OUT NOCOPY NUMBER
152: ,x_msg_data OUT NOCOPY VARCHAR2
168: -- p_claim_rec: the claim_type record to be validated
169: --
170: -- NOTES
171: -- 1. p_claim_rec should be the complete fund record. There
172: -- should not be any FND_API.g_miss_char/num/date in it.
173: ----------------------------------------------------------------------
174: PROCEDURE Validate_Claim_Type(
175: p_api_version IN NUMBER
176: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
172: -- should not be any FND_API.g_miss_char/num/date in it.
173: ----------------------------------------------------------------------
174: PROCEDURE Validate_Claim_Type(
175: p_api_version IN NUMBER
176: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
177: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
178:
179: ,x_return_status OUT NOCOPY VARCHAR2
180: ,x_msg_count OUT NOCOPY NUMBER
173: ----------------------------------------------------------------------
174: PROCEDURE Validate_Claim_Type(
175: p_api_version IN NUMBER
176: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
177: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
178:
179: ,x_return_status OUT NOCOPY VARCHAR2
180: ,x_msg_count OUT NOCOPY NUMBER
181: ,x_msg_data OUT NOCOPY VARCHAR2
211: -- Check the record level business rules.
212: --
213: -- PARAMETERS
214: -- p_claim_rec: the record to be validated; may contain attributes
215: -- as FND_API.g_miss_char/num/date
216: -- p_complete_rec: the complete record after all "g_miss" items
217: -- have been replaced by current database values
218: ---------------------------------------------------------------------
219: PROCEDURE Check_Claim_Type_Record(
227: -- PROCEDURE
228: -- Init_Claim_Type_Rec
229: --
230: -- PURPOSE
231: -- Initialize all attributes to be FND_API.g_miss_char/num/date.
232: ---------------------------------------------------------------------
233: PROCEDURE Init_Claim_Type_Rec(
234: x_claim_rec OUT NOCOPY claim_rec_type
235: );
240: -- Complete_Claim_Type_Rec
241: --
242: -- PURPOSE
243: -- For update_claim_type, some attributes may be passed in as
244: -- FND_API.g_miss_char/num/date if the user doesn't want to
245: -- update those attributes. This procedure will replace the
246: -- "g_miss" attributes with current database values.
247: --
248: -- PARAMETERS
246: -- "g_miss" attributes with current database values.
247: --
248: -- PARAMETERS
249: -- p_claim_rec: the record which may contain attributes as
250: -- FND_API.g_miss_char/num/date
251: -- x_complete_rec: the complete record after all "g_miss" items
252: -- have been replaced by current database values
253: ---------------------------------------------------------------------
254: PROCEDURE Complete_Claim_Type_Rec(