APPS.CN_PMT_PLANS_PKG dependencies on FND_API

Line 207: ,x_name cn_pmt_plans.name%TYPE := fnd_api.g_miss_char

203:
204: PROCEDURE Update_Record(
205: x_org_id cn_pmt_plans.org_id%TYPE
206: ,x_pmt_plan_id NUMBER
207: ,x_name cn_pmt_plans.name%TYPE := fnd_api.g_miss_char
208: ,x_minimum_amount cn_pmt_plans.minimum_amount%TYPE := fnd_api.g_miss_num
209: ,x_maximum_amount cn_pmt_plans.maximum_amount%TYPE := fnd_api.g_miss_num
210: ,x_max_recovery_amount cn_pmt_plans.max_recovery_amount%TYPE := fnd_api.g_miss_num
211: ,x_min_rec_flag cn_pmt_plans.min_rec_flag%TYPE := fnd_api.g_miss_char

Line 208: ,x_minimum_amount cn_pmt_plans.minimum_amount%TYPE := fnd_api.g_miss_num

204: PROCEDURE Update_Record(
205: x_org_id cn_pmt_plans.org_id%TYPE
206: ,x_pmt_plan_id NUMBER
207: ,x_name cn_pmt_plans.name%TYPE := fnd_api.g_miss_char
208: ,x_minimum_amount cn_pmt_plans.minimum_amount%TYPE := fnd_api.g_miss_num
209: ,x_maximum_amount cn_pmt_plans.maximum_amount%TYPE := fnd_api.g_miss_num
210: ,x_max_recovery_amount cn_pmt_plans.max_recovery_amount%TYPE := fnd_api.g_miss_num
211: ,x_min_rec_flag cn_pmt_plans.min_rec_flag%TYPE := fnd_api.g_miss_char
212: ,x_max_rec_flag cn_pmt_plans.max_rec_flag%TYPE := fnd_api.g_miss_char

Line 209: ,x_maximum_amount cn_pmt_plans.maximum_amount%TYPE := fnd_api.g_miss_num

205: x_org_id cn_pmt_plans.org_id%TYPE
206: ,x_pmt_plan_id NUMBER
207: ,x_name cn_pmt_plans.name%TYPE := fnd_api.g_miss_char
208: ,x_minimum_amount cn_pmt_plans.minimum_amount%TYPE := fnd_api.g_miss_num
209: ,x_maximum_amount cn_pmt_plans.maximum_amount%TYPE := fnd_api.g_miss_num
210: ,x_max_recovery_amount cn_pmt_plans.max_recovery_amount%TYPE := fnd_api.g_miss_num
211: ,x_min_rec_flag cn_pmt_plans.min_rec_flag%TYPE := fnd_api.g_miss_char
212: ,x_max_rec_flag cn_pmt_plans.max_rec_flag%TYPE := fnd_api.g_miss_char
213: ,x_credit_type_id cn_pmt_plans.credit_type_id%TYPE := cn_api.g_miss_id

Line 210: ,x_max_recovery_amount cn_pmt_plans.max_recovery_amount%TYPE := fnd_api.g_miss_num

206: ,x_pmt_plan_id NUMBER
207: ,x_name cn_pmt_plans.name%TYPE := fnd_api.g_miss_char
208: ,x_minimum_amount cn_pmt_plans.minimum_amount%TYPE := fnd_api.g_miss_num
209: ,x_maximum_amount cn_pmt_plans.maximum_amount%TYPE := fnd_api.g_miss_num
210: ,x_max_recovery_amount cn_pmt_plans.max_recovery_amount%TYPE := fnd_api.g_miss_num
211: ,x_min_rec_flag cn_pmt_plans.min_rec_flag%TYPE := fnd_api.g_miss_char
212: ,x_max_rec_flag cn_pmt_plans.max_rec_flag%TYPE := fnd_api.g_miss_char
213: ,x_credit_type_id cn_pmt_plans.credit_type_id%TYPE := cn_api.g_miss_id
214: ,x_pay_interval_type_id cn_pmt_plans.pay_interval_type_id%TYPE := cn_api.g_miss_id

Line 211: ,x_min_rec_flag cn_pmt_plans.min_rec_flag%TYPE := fnd_api.g_miss_char

207: ,x_name cn_pmt_plans.name%TYPE := fnd_api.g_miss_char
208: ,x_minimum_amount cn_pmt_plans.minimum_amount%TYPE := fnd_api.g_miss_num
209: ,x_maximum_amount cn_pmt_plans.maximum_amount%TYPE := fnd_api.g_miss_num
210: ,x_max_recovery_amount cn_pmt_plans.max_recovery_amount%TYPE := fnd_api.g_miss_num
211: ,x_min_rec_flag cn_pmt_plans.min_rec_flag%TYPE := fnd_api.g_miss_char
212: ,x_max_rec_flag cn_pmt_plans.max_rec_flag%TYPE := fnd_api.g_miss_char
213: ,x_credit_type_id cn_pmt_plans.credit_type_id%TYPE := cn_api.g_miss_id
214: ,x_pay_interval_type_id cn_pmt_plans.pay_interval_type_id%TYPE := cn_api.g_miss_id
215: ,x_start_date cn_pmt_plans.start_date%TYPE := fnd_api.g_miss_date

Line 212: ,x_max_rec_flag cn_pmt_plans.max_rec_flag%TYPE := fnd_api.g_miss_char

208: ,x_minimum_amount cn_pmt_plans.minimum_amount%TYPE := fnd_api.g_miss_num
209: ,x_maximum_amount cn_pmt_plans.maximum_amount%TYPE := fnd_api.g_miss_num
210: ,x_max_recovery_amount cn_pmt_plans.max_recovery_amount%TYPE := fnd_api.g_miss_num
211: ,x_min_rec_flag cn_pmt_plans.min_rec_flag%TYPE := fnd_api.g_miss_char
212: ,x_max_rec_flag cn_pmt_plans.max_rec_flag%TYPE := fnd_api.g_miss_char
213: ,x_credit_type_id cn_pmt_plans.credit_type_id%TYPE := cn_api.g_miss_id
214: ,x_pay_interval_type_id cn_pmt_plans.pay_interval_type_id%TYPE := cn_api.g_miss_id
215: ,x_start_date cn_pmt_plans.start_date%TYPE := fnd_api.g_miss_date
216: ,x_end_date cn_pmt_plans.end_date%TYPE := fnd_api.g_miss_date

Line 215: ,x_start_date cn_pmt_plans.start_date%TYPE := fnd_api.g_miss_date

211: ,x_min_rec_flag cn_pmt_plans.min_rec_flag%TYPE := fnd_api.g_miss_char
212: ,x_max_rec_flag cn_pmt_plans.max_rec_flag%TYPE := fnd_api.g_miss_char
213: ,x_credit_type_id cn_pmt_plans.credit_type_id%TYPE := cn_api.g_miss_id
214: ,x_pay_interval_type_id cn_pmt_plans.pay_interval_type_id%TYPE := cn_api.g_miss_id
215: ,x_start_date cn_pmt_plans.start_date%TYPE := fnd_api.g_miss_date
216: ,x_end_date cn_pmt_plans.end_date%TYPE := fnd_api.g_miss_date
217: ,x_object_version_number IN OUT NOCOPY cn_pmt_plans.object_version_number%TYPE
218: ,x_recoverable_interval_type_id cn_pmt_plans.recoverable_interval_type_id%TYPE := fnd_api.g_miss_char
219: ,x_pay_against_commission cn_pmt_plans.pay_against_commission%TYPE := fnd_api.g_miss_char

Line 216: ,x_end_date cn_pmt_plans.end_date%TYPE := fnd_api.g_miss_date

212: ,x_max_rec_flag cn_pmt_plans.max_rec_flag%TYPE := fnd_api.g_miss_char
213: ,x_credit_type_id cn_pmt_plans.credit_type_id%TYPE := cn_api.g_miss_id
214: ,x_pay_interval_type_id cn_pmt_plans.pay_interval_type_id%TYPE := cn_api.g_miss_id
215: ,x_start_date cn_pmt_plans.start_date%TYPE := fnd_api.g_miss_date
216: ,x_end_date cn_pmt_plans.end_date%TYPE := fnd_api.g_miss_date
217: ,x_object_version_number IN OUT NOCOPY cn_pmt_plans.object_version_number%TYPE
218: ,x_recoverable_interval_type_id cn_pmt_plans.recoverable_interval_type_id%TYPE := fnd_api.g_miss_char
219: ,x_pay_against_commission cn_pmt_plans.pay_against_commission%TYPE := fnd_api.g_miss_char
220: ,x_attribute_category cn_pmt_plans.attribute_category%TYPE := fnd_api.g_miss_char

Line 218: ,x_recoverable_interval_type_id cn_pmt_plans.recoverable_interval_type_id%TYPE := fnd_api.g_miss_char

214: ,x_pay_interval_type_id cn_pmt_plans.pay_interval_type_id%TYPE := cn_api.g_miss_id
215: ,x_start_date cn_pmt_plans.start_date%TYPE := fnd_api.g_miss_date
216: ,x_end_date cn_pmt_plans.end_date%TYPE := fnd_api.g_miss_date
217: ,x_object_version_number IN OUT NOCOPY cn_pmt_plans.object_version_number%TYPE
218: ,x_recoverable_interval_type_id cn_pmt_plans.recoverable_interval_type_id%TYPE := fnd_api.g_miss_char
219: ,x_pay_against_commission cn_pmt_plans.pay_against_commission%TYPE := fnd_api.g_miss_char
220: ,x_attribute_category cn_pmt_plans.attribute_category%TYPE := fnd_api.g_miss_char
221: ,x_attribute1 cn_pmt_plans.attribute1%TYPE := fnd_api.g_miss_char
222: ,x_attribute2 cn_pmt_plans.attribute2%TYPE := fnd_api.g_miss_char

Line 219: ,x_pay_against_commission cn_pmt_plans.pay_against_commission%TYPE := fnd_api.g_miss_char

215: ,x_start_date cn_pmt_plans.start_date%TYPE := fnd_api.g_miss_date
216: ,x_end_date cn_pmt_plans.end_date%TYPE := fnd_api.g_miss_date
217: ,x_object_version_number IN OUT NOCOPY cn_pmt_plans.object_version_number%TYPE
218: ,x_recoverable_interval_type_id cn_pmt_plans.recoverable_interval_type_id%TYPE := fnd_api.g_miss_char
219: ,x_pay_against_commission cn_pmt_plans.pay_against_commission%TYPE := fnd_api.g_miss_char
220: ,x_attribute_category cn_pmt_plans.attribute_category%TYPE := fnd_api.g_miss_char
221: ,x_attribute1 cn_pmt_plans.attribute1%TYPE := fnd_api.g_miss_char
222: ,x_attribute2 cn_pmt_plans.attribute2%TYPE := fnd_api.g_miss_char
223: ,x_attribute3 cn_pmt_plans.attribute3%TYPE := fnd_api.g_miss_char

Line 220: ,x_attribute_category cn_pmt_plans.attribute_category%TYPE := fnd_api.g_miss_char

216: ,x_end_date cn_pmt_plans.end_date%TYPE := fnd_api.g_miss_date
217: ,x_object_version_number IN OUT NOCOPY cn_pmt_plans.object_version_number%TYPE
218: ,x_recoverable_interval_type_id cn_pmt_plans.recoverable_interval_type_id%TYPE := fnd_api.g_miss_char
219: ,x_pay_against_commission cn_pmt_plans.pay_against_commission%TYPE := fnd_api.g_miss_char
220: ,x_attribute_category cn_pmt_plans.attribute_category%TYPE := fnd_api.g_miss_char
221: ,x_attribute1 cn_pmt_plans.attribute1%TYPE := fnd_api.g_miss_char
222: ,x_attribute2 cn_pmt_plans.attribute2%TYPE := fnd_api.g_miss_char
223: ,x_attribute3 cn_pmt_plans.attribute3%TYPE := fnd_api.g_miss_char
224: ,x_attribute4 cn_pmt_plans.attribute4%TYPE := fnd_api.g_miss_char

Line 221: ,x_attribute1 cn_pmt_plans.attribute1%TYPE := fnd_api.g_miss_char

217: ,x_object_version_number IN OUT NOCOPY cn_pmt_plans.object_version_number%TYPE
218: ,x_recoverable_interval_type_id cn_pmt_plans.recoverable_interval_type_id%TYPE := fnd_api.g_miss_char
219: ,x_pay_against_commission cn_pmt_plans.pay_against_commission%TYPE := fnd_api.g_miss_char
220: ,x_attribute_category cn_pmt_plans.attribute_category%TYPE := fnd_api.g_miss_char
221: ,x_attribute1 cn_pmt_plans.attribute1%TYPE := fnd_api.g_miss_char
222: ,x_attribute2 cn_pmt_plans.attribute2%TYPE := fnd_api.g_miss_char
223: ,x_attribute3 cn_pmt_plans.attribute3%TYPE := fnd_api.g_miss_char
224: ,x_attribute4 cn_pmt_plans.attribute4%TYPE := fnd_api.g_miss_char
225: ,x_attribute5 cn_pmt_plans.attribute5%TYPE := fnd_api.g_miss_char

Line 222: ,x_attribute2 cn_pmt_plans.attribute2%TYPE := fnd_api.g_miss_char

218: ,x_recoverable_interval_type_id cn_pmt_plans.recoverable_interval_type_id%TYPE := fnd_api.g_miss_char
219: ,x_pay_against_commission cn_pmt_plans.pay_against_commission%TYPE := fnd_api.g_miss_char
220: ,x_attribute_category cn_pmt_plans.attribute_category%TYPE := fnd_api.g_miss_char
221: ,x_attribute1 cn_pmt_plans.attribute1%TYPE := fnd_api.g_miss_char
222: ,x_attribute2 cn_pmt_plans.attribute2%TYPE := fnd_api.g_miss_char
223: ,x_attribute3 cn_pmt_plans.attribute3%TYPE := fnd_api.g_miss_char
224: ,x_attribute4 cn_pmt_plans.attribute4%TYPE := fnd_api.g_miss_char
225: ,x_attribute5 cn_pmt_plans.attribute5%TYPE := fnd_api.g_miss_char
226: ,x_attribute6 cn_pmt_plans.attribute6%TYPE := fnd_api.g_miss_char

Line 223: ,x_attribute3 cn_pmt_plans.attribute3%TYPE := fnd_api.g_miss_char

219: ,x_pay_against_commission cn_pmt_plans.pay_against_commission%TYPE := fnd_api.g_miss_char
220: ,x_attribute_category cn_pmt_plans.attribute_category%TYPE := fnd_api.g_miss_char
221: ,x_attribute1 cn_pmt_plans.attribute1%TYPE := fnd_api.g_miss_char
222: ,x_attribute2 cn_pmt_plans.attribute2%TYPE := fnd_api.g_miss_char
223: ,x_attribute3 cn_pmt_plans.attribute3%TYPE := fnd_api.g_miss_char
224: ,x_attribute4 cn_pmt_plans.attribute4%TYPE := fnd_api.g_miss_char
225: ,x_attribute5 cn_pmt_plans.attribute5%TYPE := fnd_api.g_miss_char
226: ,x_attribute6 cn_pmt_plans.attribute6%TYPE := fnd_api.g_miss_char
227: ,x_attribute7 cn_pmt_plans.attribute7%TYPE := fnd_api.g_miss_char

Line 224: ,x_attribute4 cn_pmt_plans.attribute4%TYPE := fnd_api.g_miss_char

220: ,x_attribute_category cn_pmt_plans.attribute_category%TYPE := fnd_api.g_miss_char
221: ,x_attribute1 cn_pmt_plans.attribute1%TYPE := fnd_api.g_miss_char
222: ,x_attribute2 cn_pmt_plans.attribute2%TYPE := fnd_api.g_miss_char
223: ,x_attribute3 cn_pmt_plans.attribute3%TYPE := fnd_api.g_miss_char
224: ,x_attribute4 cn_pmt_plans.attribute4%TYPE := fnd_api.g_miss_char
225: ,x_attribute5 cn_pmt_plans.attribute5%TYPE := fnd_api.g_miss_char
226: ,x_attribute6 cn_pmt_plans.attribute6%TYPE := fnd_api.g_miss_char
227: ,x_attribute7 cn_pmt_plans.attribute7%TYPE := fnd_api.g_miss_char
228: ,x_attribute8 cn_pmt_plans.attribute8%TYPE := fnd_api.g_miss_char

Line 225: ,x_attribute5 cn_pmt_plans.attribute5%TYPE := fnd_api.g_miss_char

221: ,x_attribute1 cn_pmt_plans.attribute1%TYPE := fnd_api.g_miss_char
222: ,x_attribute2 cn_pmt_plans.attribute2%TYPE := fnd_api.g_miss_char
223: ,x_attribute3 cn_pmt_plans.attribute3%TYPE := fnd_api.g_miss_char
224: ,x_attribute4 cn_pmt_plans.attribute4%TYPE := fnd_api.g_miss_char
225: ,x_attribute5 cn_pmt_plans.attribute5%TYPE := fnd_api.g_miss_char
226: ,x_attribute6 cn_pmt_plans.attribute6%TYPE := fnd_api.g_miss_char
227: ,x_attribute7 cn_pmt_plans.attribute7%TYPE := fnd_api.g_miss_char
228: ,x_attribute8 cn_pmt_plans.attribute8%TYPE := fnd_api.g_miss_char
229: ,x_attribute9 cn_pmt_plans.attribute9%TYPE := fnd_api.g_miss_char

Line 226: ,x_attribute6 cn_pmt_plans.attribute6%TYPE := fnd_api.g_miss_char

222: ,x_attribute2 cn_pmt_plans.attribute2%TYPE := fnd_api.g_miss_char
223: ,x_attribute3 cn_pmt_plans.attribute3%TYPE := fnd_api.g_miss_char
224: ,x_attribute4 cn_pmt_plans.attribute4%TYPE := fnd_api.g_miss_char
225: ,x_attribute5 cn_pmt_plans.attribute5%TYPE := fnd_api.g_miss_char
226: ,x_attribute6 cn_pmt_plans.attribute6%TYPE := fnd_api.g_miss_char
227: ,x_attribute7 cn_pmt_plans.attribute7%TYPE := fnd_api.g_miss_char
228: ,x_attribute8 cn_pmt_plans.attribute8%TYPE := fnd_api.g_miss_char
229: ,x_attribute9 cn_pmt_plans.attribute9%TYPE := fnd_api.g_miss_char
230: ,x_attribute10 cn_pmt_plans.attribute10%TYPE := fnd_api.g_miss_char

Line 227: ,x_attribute7 cn_pmt_plans.attribute7%TYPE := fnd_api.g_miss_char

223: ,x_attribute3 cn_pmt_plans.attribute3%TYPE := fnd_api.g_miss_char
224: ,x_attribute4 cn_pmt_plans.attribute4%TYPE := fnd_api.g_miss_char
225: ,x_attribute5 cn_pmt_plans.attribute5%TYPE := fnd_api.g_miss_char
226: ,x_attribute6 cn_pmt_plans.attribute6%TYPE := fnd_api.g_miss_char
227: ,x_attribute7 cn_pmt_plans.attribute7%TYPE := fnd_api.g_miss_char
228: ,x_attribute8 cn_pmt_plans.attribute8%TYPE := fnd_api.g_miss_char
229: ,x_attribute9 cn_pmt_plans.attribute9%TYPE := fnd_api.g_miss_char
230: ,x_attribute10 cn_pmt_plans.attribute10%TYPE := fnd_api.g_miss_char
231: ,x_attribute11 cn_pmt_plans.attribute11%TYPE := fnd_api.g_miss_char

Line 228: ,x_attribute8 cn_pmt_plans.attribute8%TYPE := fnd_api.g_miss_char

224: ,x_attribute4 cn_pmt_plans.attribute4%TYPE := fnd_api.g_miss_char
225: ,x_attribute5 cn_pmt_plans.attribute5%TYPE := fnd_api.g_miss_char
226: ,x_attribute6 cn_pmt_plans.attribute6%TYPE := fnd_api.g_miss_char
227: ,x_attribute7 cn_pmt_plans.attribute7%TYPE := fnd_api.g_miss_char
228: ,x_attribute8 cn_pmt_plans.attribute8%TYPE := fnd_api.g_miss_char
229: ,x_attribute9 cn_pmt_plans.attribute9%TYPE := fnd_api.g_miss_char
230: ,x_attribute10 cn_pmt_plans.attribute10%TYPE := fnd_api.g_miss_char
231: ,x_attribute11 cn_pmt_plans.attribute11%TYPE := fnd_api.g_miss_char
232: ,x_attribute12 cn_pmt_plans.attribute12%TYPE := fnd_api.g_miss_char

Line 229: ,x_attribute9 cn_pmt_plans.attribute9%TYPE := fnd_api.g_miss_char

225: ,x_attribute5 cn_pmt_plans.attribute5%TYPE := fnd_api.g_miss_char
226: ,x_attribute6 cn_pmt_plans.attribute6%TYPE := fnd_api.g_miss_char
227: ,x_attribute7 cn_pmt_plans.attribute7%TYPE := fnd_api.g_miss_char
228: ,x_attribute8 cn_pmt_plans.attribute8%TYPE := fnd_api.g_miss_char
229: ,x_attribute9 cn_pmt_plans.attribute9%TYPE := fnd_api.g_miss_char
230: ,x_attribute10 cn_pmt_plans.attribute10%TYPE := fnd_api.g_miss_char
231: ,x_attribute11 cn_pmt_plans.attribute11%TYPE := fnd_api.g_miss_char
232: ,x_attribute12 cn_pmt_plans.attribute12%TYPE := fnd_api.g_miss_char
233: ,x_attribute13 cn_pmt_plans.attribute13%TYPE := fnd_api.g_miss_char

Line 230: ,x_attribute10 cn_pmt_plans.attribute10%TYPE := fnd_api.g_miss_char

226: ,x_attribute6 cn_pmt_plans.attribute6%TYPE := fnd_api.g_miss_char
227: ,x_attribute7 cn_pmt_plans.attribute7%TYPE := fnd_api.g_miss_char
228: ,x_attribute8 cn_pmt_plans.attribute8%TYPE := fnd_api.g_miss_char
229: ,x_attribute9 cn_pmt_plans.attribute9%TYPE := fnd_api.g_miss_char
230: ,x_attribute10 cn_pmt_plans.attribute10%TYPE := fnd_api.g_miss_char
231: ,x_attribute11 cn_pmt_plans.attribute11%TYPE := fnd_api.g_miss_char
232: ,x_attribute12 cn_pmt_plans.attribute12%TYPE := fnd_api.g_miss_char
233: ,x_attribute13 cn_pmt_plans.attribute13%TYPE := fnd_api.g_miss_char
234: ,x_attribute14 cn_pmt_plans.attribute14%TYPE := fnd_api.g_miss_char

Line 231: ,x_attribute11 cn_pmt_plans.attribute11%TYPE := fnd_api.g_miss_char

227: ,x_attribute7 cn_pmt_plans.attribute7%TYPE := fnd_api.g_miss_char
228: ,x_attribute8 cn_pmt_plans.attribute8%TYPE := fnd_api.g_miss_char
229: ,x_attribute9 cn_pmt_plans.attribute9%TYPE := fnd_api.g_miss_char
230: ,x_attribute10 cn_pmt_plans.attribute10%TYPE := fnd_api.g_miss_char
231: ,x_attribute11 cn_pmt_plans.attribute11%TYPE := fnd_api.g_miss_char
232: ,x_attribute12 cn_pmt_plans.attribute12%TYPE := fnd_api.g_miss_char
233: ,x_attribute13 cn_pmt_plans.attribute13%TYPE := fnd_api.g_miss_char
234: ,x_attribute14 cn_pmt_plans.attribute14%TYPE := fnd_api.g_miss_char
235: ,x_attribute15 cn_pmt_plans.attribute15%TYPE := fnd_api.g_miss_char

Line 232: ,x_attribute12 cn_pmt_plans.attribute12%TYPE := fnd_api.g_miss_char

228: ,x_attribute8 cn_pmt_plans.attribute8%TYPE := fnd_api.g_miss_char
229: ,x_attribute9 cn_pmt_plans.attribute9%TYPE := fnd_api.g_miss_char
230: ,x_attribute10 cn_pmt_plans.attribute10%TYPE := fnd_api.g_miss_char
231: ,x_attribute11 cn_pmt_plans.attribute11%TYPE := fnd_api.g_miss_char
232: ,x_attribute12 cn_pmt_plans.attribute12%TYPE := fnd_api.g_miss_char
233: ,x_attribute13 cn_pmt_plans.attribute13%TYPE := fnd_api.g_miss_char
234: ,x_attribute14 cn_pmt_plans.attribute14%TYPE := fnd_api.g_miss_char
235: ,x_attribute15 cn_pmt_plans.attribute15%TYPE := fnd_api.g_miss_char
236: ,x_Last_Updated_By cn_pmt_plans.last_updated_by%TYPE

Line 233: ,x_attribute13 cn_pmt_plans.attribute13%TYPE := fnd_api.g_miss_char

229: ,x_attribute9 cn_pmt_plans.attribute9%TYPE := fnd_api.g_miss_char
230: ,x_attribute10 cn_pmt_plans.attribute10%TYPE := fnd_api.g_miss_char
231: ,x_attribute11 cn_pmt_plans.attribute11%TYPE := fnd_api.g_miss_char
232: ,x_attribute12 cn_pmt_plans.attribute12%TYPE := fnd_api.g_miss_char
233: ,x_attribute13 cn_pmt_plans.attribute13%TYPE := fnd_api.g_miss_char
234: ,x_attribute14 cn_pmt_plans.attribute14%TYPE := fnd_api.g_miss_char
235: ,x_attribute15 cn_pmt_plans.attribute15%TYPE := fnd_api.g_miss_char
236: ,x_Last_Updated_By cn_pmt_plans.last_updated_by%TYPE
237: ,x_Last_Update_Date cn_pmt_plans.last_update_date%TYPE

Line 234: ,x_attribute14 cn_pmt_plans.attribute14%TYPE := fnd_api.g_miss_char

230: ,x_attribute10 cn_pmt_plans.attribute10%TYPE := fnd_api.g_miss_char
231: ,x_attribute11 cn_pmt_plans.attribute11%TYPE := fnd_api.g_miss_char
232: ,x_attribute12 cn_pmt_plans.attribute12%TYPE := fnd_api.g_miss_char
233: ,x_attribute13 cn_pmt_plans.attribute13%TYPE := fnd_api.g_miss_char
234: ,x_attribute14 cn_pmt_plans.attribute14%TYPE := fnd_api.g_miss_char
235: ,x_attribute15 cn_pmt_plans.attribute15%TYPE := fnd_api.g_miss_char
236: ,x_Last_Updated_By cn_pmt_plans.last_updated_by%TYPE
237: ,x_Last_Update_Date cn_pmt_plans.last_update_date%TYPE
238: ,x_Last_Update_Login cn_pmt_plans.last_update_login%TYPE

Line 235: ,x_attribute15 cn_pmt_plans.attribute15%TYPE := fnd_api.g_miss_char

231: ,x_attribute11 cn_pmt_plans.attribute11%TYPE := fnd_api.g_miss_char
232: ,x_attribute12 cn_pmt_plans.attribute12%TYPE := fnd_api.g_miss_char
233: ,x_attribute13 cn_pmt_plans.attribute13%TYPE := fnd_api.g_miss_char
234: ,x_attribute14 cn_pmt_plans.attribute14%TYPE := fnd_api.g_miss_char
235: ,x_attribute15 cn_pmt_plans.attribute15%TYPE := fnd_api.g_miss_char
236: ,x_Last_Updated_By cn_pmt_plans.last_updated_by%TYPE
237: ,x_Last_Update_Date cn_pmt_plans.last_update_date%TYPE
238: ,x_Last_Update_Login cn_pmt_plans.last_update_login%TYPE
239: ,x_Payment_Group_Code cn_pmt_plans.payment_group_code%TYPE := fnd_api.g_miss_char

Line 239: ,x_Payment_Group_Code cn_pmt_plans.payment_group_code%TYPE := fnd_api.g_miss_char

235: ,x_attribute15 cn_pmt_plans.attribute15%TYPE := fnd_api.g_miss_char
236: ,x_Last_Updated_By cn_pmt_plans.last_updated_by%TYPE
237: ,x_Last_Update_Date cn_pmt_plans.last_update_date%TYPE
238: ,x_Last_Update_Login cn_pmt_plans.last_update_login%TYPE
239: ,x_Payment_Group_Code cn_pmt_plans.payment_group_code%TYPE := fnd_api.g_miss_char
240: ) IS
241:
242: l_org_id cn_pmt_plans.org_id%TYPE;
243: l_name cn_pmt_plans.name%TYPE;

Line 287: fnd_api.g_miss_char, l_pmt_plan_rec.name,

283: FETCH pmt_plan_cur INTO l_pmt_plan_rec;
284: CLOSE pmt_plan_cur;
285:
286: SELECT decode(x_name,
287: fnd_api.g_miss_char, l_pmt_plan_rec.name,
288: x_name),
289: decode(x_minimum_amount,
290: fnd_api.g_miss_num, l_pmt_plan_rec.minimum_amount,
291: x_minimum_amount),

Line 290: fnd_api.g_miss_num, l_pmt_plan_rec.minimum_amount,

286: SELECT decode(x_name,
287: fnd_api.g_miss_char, l_pmt_plan_rec.name,
288: x_name),
289: decode(x_minimum_amount,
290: fnd_api.g_miss_num, l_pmt_plan_rec.minimum_amount,
291: x_minimum_amount),
292: decode(x_maximum_amount,
293: fnd_api.g_miss_num, l_pmt_plan_rec.maximum_amount,
294: x_maximum_amount),

Line 293: fnd_api.g_miss_num, l_pmt_plan_rec.maximum_amount,

289: decode(x_minimum_amount,
290: fnd_api.g_miss_num, l_pmt_plan_rec.minimum_amount,
291: x_minimum_amount),
292: decode(x_maximum_amount,
293: fnd_api.g_miss_num, l_pmt_plan_rec.maximum_amount,
294: x_maximum_amount),
295: decode(x_min_rec_flag,
296: fnd_api.g_miss_char, l_pmt_plan_rec.min_rec_flag,
297: x_min_rec_flag),

Line 296: fnd_api.g_miss_char, l_pmt_plan_rec.min_rec_flag,

292: decode(x_maximum_amount,
293: fnd_api.g_miss_num, l_pmt_plan_rec.maximum_amount,
294: x_maximum_amount),
295: decode(x_min_rec_flag,
296: fnd_api.g_miss_char, l_pmt_plan_rec.min_rec_flag,
297: x_min_rec_flag),
298: decode(x_max_rec_flag,
299: fnd_api.g_miss_char, l_pmt_plan_rec.max_rec_flag,
300: x_max_rec_flag),

Line 299: fnd_api.g_miss_char, l_pmt_plan_rec.max_rec_flag,

295: decode(x_min_rec_flag,
296: fnd_api.g_miss_char, l_pmt_plan_rec.min_rec_flag,
297: x_min_rec_flag),
298: decode(x_max_rec_flag,
299: fnd_api.g_miss_char, l_pmt_plan_rec.max_rec_flag,
300: x_max_rec_flag),
301: decode(x_max_recovery_amount,
302: fnd_api.g_miss_num, l_pmt_plan_rec.max_recovery_amount,
303: x_max_recovery_amount),

Line 302: fnd_api.g_miss_num, l_pmt_plan_rec.max_recovery_amount,

298: decode(x_max_rec_flag,
299: fnd_api.g_miss_char, l_pmt_plan_rec.max_rec_flag,
300: x_max_rec_flag),
301: decode(x_max_recovery_amount,
302: fnd_api.g_miss_num, l_pmt_plan_rec.max_recovery_amount,
303: x_max_recovery_amount),
304: decode(x_credit_type_id,
305: cn_api.g_miss_id, l_pmt_plan_rec.credit_type_id,
306: x_credit_type_id),

Line 311: fnd_api.g_miss_date, l_pmt_plan_rec.start_date,

307: decode(x_pay_interval_type_id,
308: cn_api.g_miss_id, l_pmt_plan_rec.pay_interval_type_id,
309: x_pay_interval_type_id),
310: decode(x_start_date,
311: fnd_api.g_miss_date, l_pmt_plan_rec.start_date,
312: x_start_date),
313: decode(x_end_date,
314: fnd_api.g_miss_date, l_pmt_plan_rec.end_date,
315: x_end_date),

Line 314: fnd_api.g_miss_date, l_pmt_plan_rec.end_date,

310: decode(x_start_date,
311: fnd_api.g_miss_date, l_pmt_plan_rec.start_date,
312: x_start_date),
313: decode(x_end_date,
314: fnd_api.g_miss_date, l_pmt_plan_rec.end_date,
315: x_end_date),
316: decode(x_recoverable_interval_type_id,
317: fnd_api.g_miss_char, l_pmt_plan_rec.recoverable_interval_type_id,
318: x_recoverable_interval_type_id),

Line 317: fnd_api.g_miss_char, l_pmt_plan_rec.recoverable_interval_type_id,

313: decode(x_end_date,
314: fnd_api.g_miss_date, l_pmt_plan_rec.end_date,
315: x_end_date),
316: decode(x_recoverable_interval_type_id,
317: fnd_api.g_miss_char, l_pmt_plan_rec.recoverable_interval_type_id,
318: x_recoverable_interval_type_id),
319: decode(x_pay_against_commission,
320: fnd_api.g_miss_char, l_pmt_plan_rec.pay_against_commission,
321: x_pay_against_commission),

Line 320: fnd_api.g_miss_char, l_pmt_plan_rec.pay_against_commission,

316: decode(x_recoverable_interval_type_id,
317: fnd_api.g_miss_char, l_pmt_plan_rec.recoverable_interval_type_id,
318: x_recoverable_interval_type_id),
319: decode(x_pay_against_commission,
320: fnd_api.g_miss_char, l_pmt_plan_rec.pay_against_commission,
321: x_pay_against_commission),
322: decode(x_attribute_category,
323: fnd_api.g_miss_char, l_pmt_plan_rec.attribute_category,
324: x_attribute_category),

Line 323: fnd_api.g_miss_char, l_pmt_plan_rec.attribute_category,

319: decode(x_pay_against_commission,
320: fnd_api.g_miss_char, l_pmt_plan_rec.pay_against_commission,
321: x_pay_against_commission),
322: decode(x_attribute_category,
323: fnd_api.g_miss_char, l_pmt_plan_rec.attribute_category,
324: x_attribute_category),
325: decode(x_attribute1,
326: fnd_api.g_miss_char, l_pmt_plan_rec.attribute1,
327: x_attribute1),

Line 326: fnd_api.g_miss_char, l_pmt_plan_rec.attribute1,

322: decode(x_attribute_category,
323: fnd_api.g_miss_char, l_pmt_plan_rec.attribute_category,
324: x_attribute_category),
325: decode(x_attribute1,
326: fnd_api.g_miss_char, l_pmt_plan_rec.attribute1,
327: x_attribute1),
328: decode(x_attribute2,
329: fnd_api.g_miss_char, l_pmt_plan_rec.attribute2,
330: x_attribute2),

Line 329: fnd_api.g_miss_char, l_pmt_plan_rec.attribute2,

325: decode(x_attribute1,
326: fnd_api.g_miss_char, l_pmt_plan_rec.attribute1,
327: x_attribute1),
328: decode(x_attribute2,
329: fnd_api.g_miss_char, l_pmt_plan_rec.attribute2,
330: x_attribute2),
331: decode(x_attribute3,
332: fnd_api.g_miss_char, l_pmt_plan_rec.attribute3,
333: x_attribute3),

Line 332: fnd_api.g_miss_char, l_pmt_plan_rec.attribute3,

328: decode(x_attribute2,
329: fnd_api.g_miss_char, l_pmt_plan_rec.attribute2,
330: x_attribute2),
331: decode(x_attribute3,
332: fnd_api.g_miss_char, l_pmt_plan_rec.attribute3,
333: x_attribute3),
334: decode(x_attribute4,
335: fnd_api.g_miss_char, l_pmt_plan_rec.attribute4,
336: x_attribute4),

Line 335: fnd_api.g_miss_char, l_pmt_plan_rec.attribute4,

331: decode(x_attribute3,
332: fnd_api.g_miss_char, l_pmt_plan_rec.attribute3,
333: x_attribute3),
334: decode(x_attribute4,
335: fnd_api.g_miss_char, l_pmt_plan_rec.attribute4,
336: x_attribute4),
337: decode(x_attribute5,
338: fnd_api.g_miss_char, l_pmt_plan_rec.attribute5,
339: x_attribute5),

Line 338: fnd_api.g_miss_char, l_pmt_plan_rec.attribute5,

334: decode(x_attribute4,
335: fnd_api.g_miss_char, l_pmt_plan_rec.attribute4,
336: x_attribute4),
337: decode(x_attribute5,
338: fnd_api.g_miss_char, l_pmt_plan_rec.attribute5,
339: x_attribute5),
340: decode(x_attribute6,
341: fnd_api.g_miss_char, l_pmt_plan_rec.attribute6,
342: x_attribute6),

Line 341: fnd_api.g_miss_char, l_pmt_plan_rec.attribute6,

337: decode(x_attribute5,
338: fnd_api.g_miss_char, l_pmt_plan_rec.attribute5,
339: x_attribute5),
340: decode(x_attribute6,
341: fnd_api.g_miss_char, l_pmt_plan_rec.attribute6,
342: x_attribute6),
343: decode(x_attribute7,
344: fnd_api.g_miss_char, l_pmt_plan_rec.attribute7,
345: x_attribute7),

Line 344: fnd_api.g_miss_char, l_pmt_plan_rec.attribute7,

340: decode(x_attribute6,
341: fnd_api.g_miss_char, l_pmt_plan_rec.attribute6,
342: x_attribute6),
343: decode(x_attribute7,
344: fnd_api.g_miss_char, l_pmt_plan_rec.attribute7,
345: x_attribute7),
346: decode(x_attribute8,
347: fnd_api.g_miss_char, l_pmt_plan_rec.attribute8,
348: x_attribute8),

Line 347: fnd_api.g_miss_char, l_pmt_plan_rec.attribute8,

343: decode(x_attribute7,
344: fnd_api.g_miss_char, l_pmt_plan_rec.attribute7,
345: x_attribute7),
346: decode(x_attribute8,
347: fnd_api.g_miss_char, l_pmt_plan_rec.attribute8,
348: x_attribute8),
349: decode(x_attribute9,
350: fnd_api.g_miss_char, l_pmt_plan_rec.attribute9,
351: x_attribute9),

Line 350: fnd_api.g_miss_char, l_pmt_plan_rec.attribute9,

346: decode(x_attribute8,
347: fnd_api.g_miss_char, l_pmt_plan_rec.attribute8,
348: x_attribute8),
349: decode(x_attribute9,
350: fnd_api.g_miss_char, l_pmt_plan_rec.attribute9,
351: x_attribute9),
352: decode(x_attribute10,
353: fnd_api.g_miss_char, l_pmt_plan_rec.attribute10,
354: x_attribute10),

Line 353: fnd_api.g_miss_char, l_pmt_plan_rec.attribute10,

349: decode(x_attribute9,
350: fnd_api.g_miss_char, l_pmt_plan_rec.attribute9,
351: x_attribute9),
352: decode(x_attribute10,
353: fnd_api.g_miss_char, l_pmt_plan_rec.attribute10,
354: x_attribute10),
355: decode(x_attribute11,
356: fnd_api.g_miss_char, l_pmt_plan_rec.attribute11,
357: x_attribute11),

Line 356: fnd_api.g_miss_char, l_pmt_plan_rec.attribute11,

352: decode(x_attribute10,
353: fnd_api.g_miss_char, l_pmt_plan_rec.attribute10,
354: x_attribute10),
355: decode(x_attribute11,
356: fnd_api.g_miss_char, l_pmt_plan_rec.attribute11,
357: x_attribute11),
358: decode(x_attribute12,
359: fnd_api.g_miss_char, l_pmt_plan_rec.attribute12,
360: x_attribute12),

Line 359: fnd_api.g_miss_char, l_pmt_plan_rec.attribute12,

355: decode(x_attribute11,
356: fnd_api.g_miss_char, l_pmt_plan_rec.attribute11,
357: x_attribute11),
358: decode(x_attribute12,
359: fnd_api.g_miss_char, l_pmt_plan_rec.attribute12,
360: x_attribute12),
361: decode(x_attribute13,
362: fnd_api.g_miss_char, l_pmt_plan_rec.attribute13,
363: x_attribute13),

Line 362: fnd_api.g_miss_char, l_pmt_plan_rec.attribute13,

358: decode(x_attribute12,
359: fnd_api.g_miss_char, l_pmt_plan_rec.attribute12,
360: x_attribute12),
361: decode(x_attribute13,
362: fnd_api.g_miss_char, l_pmt_plan_rec.attribute13,
363: x_attribute13),
364: decode(x_attribute14,
365: fnd_api.g_miss_char, l_pmt_plan_rec.attribute14,
366: x_attribute14),

Line 365: fnd_api.g_miss_char, l_pmt_plan_rec.attribute14,

361: decode(x_attribute13,
362: fnd_api.g_miss_char, l_pmt_plan_rec.attribute13,
363: x_attribute13),
364: decode(x_attribute14,
365: fnd_api.g_miss_char, l_pmt_plan_rec.attribute14,
366: x_attribute14),
367: decode(x_attribute15,
368: fnd_api.g_miss_char, l_pmt_plan_rec.attribute15,
369: x_attribute15),

Line 368: fnd_api.g_miss_char, l_pmt_plan_rec.attribute15,

364: decode(x_attribute14,
365: fnd_api.g_miss_char, l_pmt_plan_rec.attribute14,
366: x_attribute14),
367: decode(x_attribute15,
368: fnd_api.g_miss_char, l_pmt_plan_rec.attribute15,
369: x_attribute15),
370: decode(x_payment_group_code,
371: fnd_api.g_miss_char, l_pmt_plan_rec.payment_group_code,
372: x_payment_group_code)

Line 371: fnd_api.g_miss_char, l_pmt_plan_rec.payment_group_code,

367: decode(x_attribute15,
368: fnd_api.g_miss_char, l_pmt_plan_rec.attribute15,
369: x_attribute15),
370: decode(x_payment_group_code,
371: fnd_api.g_miss_char, l_pmt_plan_rec.payment_group_code,
372: x_payment_group_code)
373: INTO l_name,
374: l_minimum_amount,
375: l_maximum_amount,