352:
353:
354:
355: TYPE lease_insurance_rec IS RECORD (
356: insurance_requirement_id pn_insurance_requirements_all.insurance_requirement_id%TYPE := pn_lease_utils.g_pn_miss_num
357: , status fnd_lookups.meaning%TYPE := pn_lease_utils.g_pn_miss_char
358: , status_code pn_insurance_requirements_all.status%TYPE := pn_lease_utils.g_pn_miss_char
359: , insurance_type fnd_lookups.meaning%TYPE := pn_lease_utils.g_pn_miss_char
360: , insurance_type_lookup_code pn_insurance_requirements_all.insurance_type_lookup_code%TYPE := pn_lease_utils.g_pn_miss_char
354:
355: TYPE lease_insurance_rec IS RECORD (
356: insurance_requirement_id pn_insurance_requirements_all.insurance_requirement_id%TYPE := pn_lease_utils.g_pn_miss_num
357: , status fnd_lookups.meaning%TYPE := pn_lease_utils.g_pn_miss_char
358: , status_code pn_insurance_requirements_all.status%TYPE := pn_lease_utils.g_pn_miss_char
359: , insurance_type fnd_lookups.meaning%TYPE := pn_lease_utils.g_pn_miss_char
360: , insurance_type_lookup_code pn_insurance_requirements_all.insurance_type_lookup_code%TYPE := pn_lease_utils.g_pn_miss_char
361: , policy_start_date DATE := pn_lease_utils.g_pn_miss_date
362: , policy_expiration_date DATE := pn_lease_utils.g_pn_miss_date
356: insurance_requirement_id pn_insurance_requirements_all.insurance_requirement_id%TYPE := pn_lease_utils.g_pn_miss_num
357: , status fnd_lookups.meaning%TYPE := pn_lease_utils.g_pn_miss_char
358: , status_code pn_insurance_requirements_all.status%TYPE := pn_lease_utils.g_pn_miss_char
359: , insurance_type fnd_lookups.meaning%TYPE := pn_lease_utils.g_pn_miss_char
360: , insurance_type_lookup_code pn_insurance_requirements_all.insurance_type_lookup_code%TYPE := pn_lease_utils.g_pn_miss_char
361: , policy_start_date DATE := pn_lease_utils.g_pn_miss_date
362: , policy_expiration_date DATE := pn_lease_utils.g_pn_miss_date
363: , insurer_name pn_insurance_requirements_all.insurer_name%TYPE := pn_lease_utils.g_pn_miss_char
364: , policy_number pn_insurance_requirements_all.policy_number%TYPE := pn_lease_utils.g_pn_miss_char
359: , insurance_type fnd_lookups.meaning%TYPE := pn_lease_utils.g_pn_miss_char
360: , insurance_type_lookup_code pn_insurance_requirements_all.insurance_type_lookup_code%TYPE := pn_lease_utils.g_pn_miss_char
361: , policy_start_date DATE := pn_lease_utils.g_pn_miss_date
362: , policy_expiration_date DATE := pn_lease_utils.g_pn_miss_date
363: , insurer_name pn_insurance_requirements_all.insurer_name%TYPE := pn_lease_utils.g_pn_miss_char
364: , policy_number pn_insurance_requirements_all.policy_number%TYPE := pn_lease_utils.g_pn_miss_char
365: , insured_amount NUMBER := pn_lease_utils.g_pn_miss_num
366: , required_amount NUMBER := pn_lease_utils.g_pn_miss_num
367: , attribute_category pn_insurance_requirements_all.attribute_category%TYPE := pn_lease_utils.g_pn_miss_char
360: , insurance_type_lookup_code pn_insurance_requirements_all.insurance_type_lookup_code%TYPE := pn_lease_utils.g_pn_miss_char
361: , policy_start_date DATE := pn_lease_utils.g_pn_miss_date
362: , policy_expiration_date DATE := pn_lease_utils.g_pn_miss_date
363: , insurer_name pn_insurance_requirements_all.insurer_name%TYPE := pn_lease_utils.g_pn_miss_char
364: , policy_number pn_insurance_requirements_all.policy_number%TYPE := pn_lease_utils.g_pn_miss_char
365: , insured_amount NUMBER := pn_lease_utils.g_pn_miss_num
366: , required_amount NUMBER := pn_lease_utils.g_pn_miss_num
367: , attribute_category pn_insurance_requirements_all.attribute_category%TYPE := pn_lease_utils.g_pn_miss_char
368: , attribute1 pn_insurance_requirements_all.attribute1%TYPE := pn_lease_utils.g_pn_miss_char
363: , insurer_name pn_insurance_requirements_all.insurer_name%TYPE := pn_lease_utils.g_pn_miss_char
364: , policy_number pn_insurance_requirements_all.policy_number%TYPE := pn_lease_utils.g_pn_miss_char
365: , insured_amount NUMBER := pn_lease_utils.g_pn_miss_num
366: , required_amount NUMBER := pn_lease_utils.g_pn_miss_num
367: , attribute_category pn_insurance_requirements_all.attribute_category%TYPE := pn_lease_utils.g_pn_miss_char
368: , attribute1 pn_insurance_requirements_all.attribute1%TYPE := pn_lease_utils.g_pn_miss_char
369: , attribute2 pn_insurance_requirements_all.attribute2%TYPE := pn_lease_utils.g_pn_miss_char
370: , attribute3 pn_insurance_requirements_all.attribute3%TYPE := pn_lease_utils.g_pn_miss_char
371: , attribute4 pn_insurance_requirements_all.attribute4%TYPE := pn_lease_utils.g_pn_miss_char
364: , policy_number pn_insurance_requirements_all.policy_number%TYPE := pn_lease_utils.g_pn_miss_char
365: , insured_amount NUMBER := pn_lease_utils.g_pn_miss_num
366: , required_amount NUMBER := pn_lease_utils.g_pn_miss_num
367: , attribute_category pn_insurance_requirements_all.attribute_category%TYPE := pn_lease_utils.g_pn_miss_char
368: , attribute1 pn_insurance_requirements_all.attribute1%TYPE := pn_lease_utils.g_pn_miss_char
369: , attribute2 pn_insurance_requirements_all.attribute2%TYPE := pn_lease_utils.g_pn_miss_char
370: , attribute3 pn_insurance_requirements_all.attribute3%TYPE := pn_lease_utils.g_pn_miss_char
371: , attribute4 pn_insurance_requirements_all.attribute4%TYPE := pn_lease_utils.g_pn_miss_char
372: , attribute5 pn_insurance_requirements_all.attribute5%TYPE := pn_lease_utils.g_pn_miss_char
365: , insured_amount NUMBER := pn_lease_utils.g_pn_miss_num
366: , required_amount NUMBER := pn_lease_utils.g_pn_miss_num
367: , attribute_category pn_insurance_requirements_all.attribute_category%TYPE := pn_lease_utils.g_pn_miss_char
368: , attribute1 pn_insurance_requirements_all.attribute1%TYPE := pn_lease_utils.g_pn_miss_char
369: , attribute2 pn_insurance_requirements_all.attribute2%TYPE := pn_lease_utils.g_pn_miss_char
370: , attribute3 pn_insurance_requirements_all.attribute3%TYPE := pn_lease_utils.g_pn_miss_char
371: , attribute4 pn_insurance_requirements_all.attribute4%TYPE := pn_lease_utils.g_pn_miss_char
372: , attribute5 pn_insurance_requirements_all.attribute5%TYPE := pn_lease_utils.g_pn_miss_char
373: , attribute6 pn_insurance_requirements_all.attribute6%TYPE := pn_lease_utils.g_pn_miss_char
366: , required_amount NUMBER := pn_lease_utils.g_pn_miss_num
367: , attribute_category pn_insurance_requirements_all.attribute_category%TYPE := pn_lease_utils.g_pn_miss_char
368: , attribute1 pn_insurance_requirements_all.attribute1%TYPE := pn_lease_utils.g_pn_miss_char
369: , attribute2 pn_insurance_requirements_all.attribute2%TYPE := pn_lease_utils.g_pn_miss_char
370: , attribute3 pn_insurance_requirements_all.attribute3%TYPE := pn_lease_utils.g_pn_miss_char
371: , attribute4 pn_insurance_requirements_all.attribute4%TYPE := pn_lease_utils.g_pn_miss_char
372: , attribute5 pn_insurance_requirements_all.attribute5%TYPE := pn_lease_utils.g_pn_miss_char
373: , attribute6 pn_insurance_requirements_all.attribute6%TYPE := pn_lease_utils.g_pn_miss_char
374: , attribute7 pn_insurance_requirements_all.attribute7%TYPE := pn_lease_utils.g_pn_miss_char
367: , attribute_category pn_insurance_requirements_all.attribute_category%TYPE := pn_lease_utils.g_pn_miss_char
368: , attribute1 pn_insurance_requirements_all.attribute1%TYPE := pn_lease_utils.g_pn_miss_char
369: , attribute2 pn_insurance_requirements_all.attribute2%TYPE := pn_lease_utils.g_pn_miss_char
370: , attribute3 pn_insurance_requirements_all.attribute3%TYPE := pn_lease_utils.g_pn_miss_char
371: , attribute4 pn_insurance_requirements_all.attribute4%TYPE := pn_lease_utils.g_pn_miss_char
372: , attribute5 pn_insurance_requirements_all.attribute5%TYPE := pn_lease_utils.g_pn_miss_char
373: , attribute6 pn_insurance_requirements_all.attribute6%TYPE := pn_lease_utils.g_pn_miss_char
374: , attribute7 pn_insurance_requirements_all.attribute7%TYPE := pn_lease_utils.g_pn_miss_char
375: , attribute8 pn_insurance_requirements_all.attribute8%TYPE := pn_lease_utils.g_pn_miss_char
368: , attribute1 pn_insurance_requirements_all.attribute1%TYPE := pn_lease_utils.g_pn_miss_char
369: , attribute2 pn_insurance_requirements_all.attribute2%TYPE := pn_lease_utils.g_pn_miss_char
370: , attribute3 pn_insurance_requirements_all.attribute3%TYPE := pn_lease_utils.g_pn_miss_char
371: , attribute4 pn_insurance_requirements_all.attribute4%TYPE := pn_lease_utils.g_pn_miss_char
372: , attribute5 pn_insurance_requirements_all.attribute5%TYPE := pn_lease_utils.g_pn_miss_char
373: , attribute6 pn_insurance_requirements_all.attribute6%TYPE := pn_lease_utils.g_pn_miss_char
374: , attribute7 pn_insurance_requirements_all.attribute7%TYPE := pn_lease_utils.g_pn_miss_char
375: , attribute8 pn_insurance_requirements_all.attribute8%TYPE := pn_lease_utils.g_pn_miss_char
376: , attribute9 pn_insurance_requirements_all.attribute8%TYPE := pn_lease_utils.g_pn_miss_char
369: , attribute2 pn_insurance_requirements_all.attribute2%TYPE := pn_lease_utils.g_pn_miss_char
370: , attribute3 pn_insurance_requirements_all.attribute3%TYPE := pn_lease_utils.g_pn_miss_char
371: , attribute4 pn_insurance_requirements_all.attribute4%TYPE := pn_lease_utils.g_pn_miss_char
372: , attribute5 pn_insurance_requirements_all.attribute5%TYPE := pn_lease_utils.g_pn_miss_char
373: , attribute6 pn_insurance_requirements_all.attribute6%TYPE := pn_lease_utils.g_pn_miss_char
374: , attribute7 pn_insurance_requirements_all.attribute7%TYPE := pn_lease_utils.g_pn_miss_char
375: , attribute8 pn_insurance_requirements_all.attribute8%TYPE := pn_lease_utils.g_pn_miss_char
376: , attribute9 pn_insurance_requirements_all.attribute8%TYPE := pn_lease_utils.g_pn_miss_char
377: , attribute10 pn_insurance_requirements_all.attribute10%TYPE := pn_lease_utils.g_pn_miss_char
370: , attribute3 pn_insurance_requirements_all.attribute3%TYPE := pn_lease_utils.g_pn_miss_char
371: , attribute4 pn_insurance_requirements_all.attribute4%TYPE := pn_lease_utils.g_pn_miss_char
372: , attribute5 pn_insurance_requirements_all.attribute5%TYPE := pn_lease_utils.g_pn_miss_char
373: , attribute6 pn_insurance_requirements_all.attribute6%TYPE := pn_lease_utils.g_pn_miss_char
374: , attribute7 pn_insurance_requirements_all.attribute7%TYPE := pn_lease_utils.g_pn_miss_char
375: , attribute8 pn_insurance_requirements_all.attribute8%TYPE := pn_lease_utils.g_pn_miss_char
376: , attribute9 pn_insurance_requirements_all.attribute8%TYPE := pn_lease_utils.g_pn_miss_char
377: , attribute10 pn_insurance_requirements_all.attribute10%TYPE := pn_lease_utils.g_pn_miss_char
378: , attribute11 pn_insurance_requirements_all.attribute11%TYPE := pn_lease_utils.g_pn_miss_char
371: , attribute4 pn_insurance_requirements_all.attribute4%TYPE := pn_lease_utils.g_pn_miss_char
372: , attribute5 pn_insurance_requirements_all.attribute5%TYPE := pn_lease_utils.g_pn_miss_char
373: , attribute6 pn_insurance_requirements_all.attribute6%TYPE := pn_lease_utils.g_pn_miss_char
374: , attribute7 pn_insurance_requirements_all.attribute7%TYPE := pn_lease_utils.g_pn_miss_char
375: , attribute8 pn_insurance_requirements_all.attribute8%TYPE := pn_lease_utils.g_pn_miss_char
376: , attribute9 pn_insurance_requirements_all.attribute8%TYPE := pn_lease_utils.g_pn_miss_char
377: , attribute10 pn_insurance_requirements_all.attribute10%TYPE := pn_lease_utils.g_pn_miss_char
378: , attribute11 pn_insurance_requirements_all.attribute11%TYPE := pn_lease_utils.g_pn_miss_char
379: , attribute12 pn_insurance_requirements_all.attribute12%TYPE := pn_lease_utils.g_pn_miss_char
372: , attribute5 pn_insurance_requirements_all.attribute5%TYPE := pn_lease_utils.g_pn_miss_char
373: , attribute6 pn_insurance_requirements_all.attribute6%TYPE := pn_lease_utils.g_pn_miss_char
374: , attribute7 pn_insurance_requirements_all.attribute7%TYPE := pn_lease_utils.g_pn_miss_char
375: , attribute8 pn_insurance_requirements_all.attribute8%TYPE := pn_lease_utils.g_pn_miss_char
376: , attribute9 pn_insurance_requirements_all.attribute8%TYPE := pn_lease_utils.g_pn_miss_char
377: , attribute10 pn_insurance_requirements_all.attribute10%TYPE := pn_lease_utils.g_pn_miss_char
378: , attribute11 pn_insurance_requirements_all.attribute11%TYPE := pn_lease_utils.g_pn_miss_char
379: , attribute12 pn_insurance_requirements_all.attribute12%TYPE := pn_lease_utils.g_pn_miss_char
380: , attribute13 pn_insurance_requirements_all.attribute13%TYPE := pn_lease_utils.g_pn_miss_char
373: , attribute6 pn_insurance_requirements_all.attribute6%TYPE := pn_lease_utils.g_pn_miss_char
374: , attribute7 pn_insurance_requirements_all.attribute7%TYPE := pn_lease_utils.g_pn_miss_char
375: , attribute8 pn_insurance_requirements_all.attribute8%TYPE := pn_lease_utils.g_pn_miss_char
376: , attribute9 pn_insurance_requirements_all.attribute8%TYPE := pn_lease_utils.g_pn_miss_char
377: , attribute10 pn_insurance_requirements_all.attribute10%TYPE := pn_lease_utils.g_pn_miss_char
378: , attribute11 pn_insurance_requirements_all.attribute11%TYPE := pn_lease_utils.g_pn_miss_char
379: , attribute12 pn_insurance_requirements_all.attribute12%TYPE := pn_lease_utils.g_pn_miss_char
380: , attribute13 pn_insurance_requirements_all.attribute13%TYPE := pn_lease_utils.g_pn_miss_char
381: , attribute14 pn_insurance_requirements_all.attribute14%TYPE := pn_lease_utils.g_pn_miss_char
374: , attribute7 pn_insurance_requirements_all.attribute7%TYPE := pn_lease_utils.g_pn_miss_char
375: , attribute8 pn_insurance_requirements_all.attribute8%TYPE := pn_lease_utils.g_pn_miss_char
376: , attribute9 pn_insurance_requirements_all.attribute8%TYPE := pn_lease_utils.g_pn_miss_char
377: , attribute10 pn_insurance_requirements_all.attribute10%TYPE := pn_lease_utils.g_pn_miss_char
378: , attribute11 pn_insurance_requirements_all.attribute11%TYPE := pn_lease_utils.g_pn_miss_char
379: , attribute12 pn_insurance_requirements_all.attribute12%TYPE := pn_lease_utils.g_pn_miss_char
380: , attribute13 pn_insurance_requirements_all.attribute13%TYPE := pn_lease_utils.g_pn_miss_char
381: , attribute14 pn_insurance_requirements_all.attribute14%TYPE := pn_lease_utils.g_pn_miss_char
382: , attribute15 pn_insurance_requirements_all.attribute15%TYPE := pn_lease_utils.g_pn_miss_char
375: , attribute8 pn_insurance_requirements_all.attribute8%TYPE := pn_lease_utils.g_pn_miss_char
376: , attribute9 pn_insurance_requirements_all.attribute8%TYPE := pn_lease_utils.g_pn_miss_char
377: , attribute10 pn_insurance_requirements_all.attribute10%TYPE := pn_lease_utils.g_pn_miss_char
378: , attribute11 pn_insurance_requirements_all.attribute11%TYPE := pn_lease_utils.g_pn_miss_char
379: , attribute12 pn_insurance_requirements_all.attribute12%TYPE := pn_lease_utils.g_pn_miss_char
380: , attribute13 pn_insurance_requirements_all.attribute13%TYPE := pn_lease_utils.g_pn_miss_char
381: , attribute14 pn_insurance_requirements_all.attribute14%TYPE := pn_lease_utils.g_pn_miss_char
382: , attribute15 pn_insurance_requirements_all.attribute15%TYPE := pn_lease_utils.g_pn_miss_char
383: , insurance_comments pn_insurance_requirements_all.insurance_comments%TYPE := pn_lease_utils.g_pn_miss_char
376: , attribute9 pn_insurance_requirements_all.attribute8%TYPE := pn_lease_utils.g_pn_miss_char
377: , attribute10 pn_insurance_requirements_all.attribute10%TYPE := pn_lease_utils.g_pn_miss_char
378: , attribute11 pn_insurance_requirements_all.attribute11%TYPE := pn_lease_utils.g_pn_miss_char
379: , attribute12 pn_insurance_requirements_all.attribute12%TYPE := pn_lease_utils.g_pn_miss_char
380: , attribute13 pn_insurance_requirements_all.attribute13%TYPE := pn_lease_utils.g_pn_miss_char
381: , attribute14 pn_insurance_requirements_all.attribute14%TYPE := pn_lease_utils.g_pn_miss_char
382: , attribute15 pn_insurance_requirements_all.attribute15%TYPE := pn_lease_utils.g_pn_miss_char
383: , insurance_comments pn_insurance_requirements_all.insurance_comments%TYPE := pn_lease_utils.g_pn_miss_char
384: --, p_null_id VARCHAR(1) := pn_lease_utils.g_pn_miss_char
377: , attribute10 pn_insurance_requirements_all.attribute10%TYPE := pn_lease_utils.g_pn_miss_char
378: , attribute11 pn_insurance_requirements_all.attribute11%TYPE := pn_lease_utils.g_pn_miss_char
379: , attribute12 pn_insurance_requirements_all.attribute12%TYPE := pn_lease_utils.g_pn_miss_char
380: , attribute13 pn_insurance_requirements_all.attribute13%TYPE := pn_lease_utils.g_pn_miss_char
381: , attribute14 pn_insurance_requirements_all.attribute14%TYPE := pn_lease_utils.g_pn_miss_char
382: , attribute15 pn_insurance_requirements_all.attribute15%TYPE := pn_lease_utils.g_pn_miss_char
383: , insurance_comments pn_insurance_requirements_all.insurance_comments%TYPE := pn_lease_utils.g_pn_miss_char
384: --, p_null_id VARCHAR(1) := pn_lease_utils.g_pn_miss_char
385: , insurance_milestone_tbl lease_milestone_tbl_type
378: , attribute11 pn_insurance_requirements_all.attribute11%TYPE := pn_lease_utils.g_pn_miss_char
379: , attribute12 pn_insurance_requirements_all.attribute12%TYPE := pn_lease_utils.g_pn_miss_char
380: , attribute13 pn_insurance_requirements_all.attribute13%TYPE := pn_lease_utils.g_pn_miss_char
381: , attribute14 pn_insurance_requirements_all.attribute14%TYPE := pn_lease_utils.g_pn_miss_char
382: , attribute15 pn_insurance_requirements_all.attribute15%TYPE := pn_lease_utils.g_pn_miss_char
383: , insurance_comments pn_insurance_requirements_all.insurance_comments%TYPE := pn_lease_utils.g_pn_miss_char
384: --, p_null_id VARCHAR(1) := pn_lease_utils.g_pn_miss_char
385: , insurance_milestone_tbl lease_milestone_tbl_type
386: );
379: , attribute12 pn_insurance_requirements_all.attribute12%TYPE := pn_lease_utils.g_pn_miss_char
380: , attribute13 pn_insurance_requirements_all.attribute13%TYPE := pn_lease_utils.g_pn_miss_char
381: , attribute14 pn_insurance_requirements_all.attribute14%TYPE := pn_lease_utils.g_pn_miss_char
382: , attribute15 pn_insurance_requirements_all.attribute15%TYPE := pn_lease_utils.g_pn_miss_char
383: , insurance_comments pn_insurance_requirements_all.insurance_comments%TYPE := pn_lease_utils.g_pn_miss_char
384: --, p_null_id VARCHAR(1) := pn_lease_utils.g_pn_miss_char
385: , insurance_milestone_tbl lease_milestone_tbl_type
386: );
387: