471: TYPE TERMS_LIAB_RCVL_ACCOUNT_TBL IS TABLE OF TERMS_ACCOUNT_REC
472: INDEX BY BINARY_INTEGER;
473:
474:
475: -- Record Type for PN_PAYMENT_TERMS_ALL.
476:
477: TYPE LEASE_TERMS_REC IS RECORD
478: (
479: payment_term_id pn_payment_terms_all.payment_term_id%TYPE := NULL
475: -- Record Type for PN_PAYMENT_TERMS_ALL.
476:
477: TYPE LEASE_TERMS_REC IS RECORD
478: (
479: payment_term_id pn_payment_terms_all.payment_term_id%TYPE := NULL
480: , term_template_name pn_term_templates_all.name%TYPE := NULL
481: , last_update_date pn_payment_terms_all.last_update_date%TYPE := SYSDATE
482: , last_updated_by pn_payment_terms_all.last_updated_by%TYPE := FND_GLOBAL.USER_ID
483: , creation_date pn_payment_terms_all.creation_date%TYPE := SYSDATE
477: TYPE LEASE_TERMS_REC IS RECORD
478: (
479: payment_term_id pn_payment_terms_all.payment_term_id%TYPE := NULL
480: , term_template_name pn_term_templates_all.name%TYPE := NULL
481: , last_update_date pn_payment_terms_all.last_update_date%TYPE := SYSDATE
482: , last_updated_by pn_payment_terms_all.last_updated_by%TYPE := FND_GLOBAL.USER_ID
483: , creation_date pn_payment_terms_all.creation_date%TYPE := SYSDATE
484: , created_by pn_payment_terms_all.created_by%TYPE := FND_GLOBAL.USER_ID
485: , last_update_login pn_payment_terms_all.last_update_login%TYPE := FND_GLOBAL.LOGIN_ID
478: (
479: payment_term_id pn_payment_terms_all.payment_term_id%TYPE := NULL
480: , term_template_name pn_term_templates_all.name%TYPE := NULL
481: , last_update_date pn_payment_terms_all.last_update_date%TYPE := SYSDATE
482: , last_updated_by pn_payment_terms_all.last_updated_by%TYPE := FND_GLOBAL.USER_ID
483: , creation_date pn_payment_terms_all.creation_date%TYPE := SYSDATE
484: , created_by pn_payment_terms_all.created_by%TYPE := FND_GLOBAL.USER_ID
485: , last_update_login pn_payment_terms_all.last_update_login%TYPE := FND_GLOBAL.LOGIN_ID
486: , payment_purpose_code pn_payment_terms_all.payment_purpose_code%TYPE := NULL
479: payment_term_id pn_payment_terms_all.payment_term_id%TYPE := NULL
480: , term_template_name pn_term_templates_all.name%TYPE := NULL
481: , last_update_date pn_payment_terms_all.last_update_date%TYPE := SYSDATE
482: , last_updated_by pn_payment_terms_all.last_updated_by%TYPE := FND_GLOBAL.USER_ID
483: , creation_date pn_payment_terms_all.creation_date%TYPE := SYSDATE
484: , created_by pn_payment_terms_all.created_by%TYPE := FND_GLOBAL.USER_ID
485: , last_update_login pn_payment_terms_all.last_update_login%TYPE := FND_GLOBAL.LOGIN_ID
486: , payment_purpose_code pn_payment_terms_all.payment_purpose_code%TYPE := NULL
487: , payment_purpose VARCHAR2(80) := NULL
480: , term_template_name pn_term_templates_all.name%TYPE := NULL
481: , last_update_date pn_payment_terms_all.last_update_date%TYPE := SYSDATE
482: , last_updated_by pn_payment_terms_all.last_updated_by%TYPE := FND_GLOBAL.USER_ID
483: , creation_date pn_payment_terms_all.creation_date%TYPE := SYSDATE
484: , created_by pn_payment_terms_all.created_by%TYPE := FND_GLOBAL.USER_ID
485: , last_update_login pn_payment_terms_all.last_update_login%TYPE := FND_GLOBAL.LOGIN_ID
486: , payment_purpose_code pn_payment_terms_all.payment_purpose_code%TYPE := NULL
487: , payment_purpose VARCHAR2(80) := NULL
488: , payment_term_type_code pn_payment_terms_all.payment_term_type_code %TYPE := NULL
481: , last_update_date pn_payment_terms_all.last_update_date%TYPE := SYSDATE
482: , last_updated_by pn_payment_terms_all.last_updated_by%TYPE := FND_GLOBAL.USER_ID
483: , creation_date pn_payment_terms_all.creation_date%TYPE := SYSDATE
484: , created_by pn_payment_terms_all.created_by%TYPE := FND_GLOBAL.USER_ID
485: , last_update_login pn_payment_terms_all.last_update_login%TYPE := FND_GLOBAL.LOGIN_ID
486: , payment_purpose_code pn_payment_terms_all.payment_purpose_code%TYPE := NULL
487: , payment_purpose VARCHAR2(80) := NULL
488: , payment_term_type_code pn_payment_terms_all.payment_term_type_code %TYPE := NULL
489: , payment_term_type VARCHAR2(80) := NULL
482: , last_updated_by pn_payment_terms_all.last_updated_by%TYPE := FND_GLOBAL.USER_ID
483: , creation_date pn_payment_terms_all.creation_date%TYPE := SYSDATE
484: , created_by pn_payment_terms_all.created_by%TYPE := FND_GLOBAL.USER_ID
485: , last_update_login pn_payment_terms_all.last_update_login%TYPE := FND_GLOBAL.LOGIN_ID
486: , payment_purpose_code pn_payment_terms_all.payment_purpose_code%TYPE := NULL
487: , payment_purpose VARCHAR2(80) := NULL
488: , payment_term_type_code pn_payment_terms_all.payment_term_type_code %TYPE := NULL
489: , payment_term_type VARCHAR2(80) := NULL
490: , frequency VARCHAR2(80) := NULL
484: , created_by pn_payment_terms_all.created_by%TYPE := FND_GLOBAL.USER_ID
485: , last_update_login pn_payment_terms_all.last_update_login%TYPE := FND_GLOBAL.LOGIN_ID
486: , payment_purpose_code pn_payment_terms_all.payment_purpose_code%TYPE := NULL
487: , payment_purpose VARCHAR2(80) := NULL
488: , payment_term_type_code pn_payment_terms_all.payment_term_type_code %TYPE := NULL
489: , payment_term_type VARCHAR2(80) := NULL
490: , frequency VARCHAR2(80) := NULL
491: , frequency_code pn_payment_terms_all.frequency_code%TYPE := NULL
492: , lease_id pn_payment_terms_all.lease_id %TYPE := NULL
487: , payment_purpose VARCHAR2(80) := NULL
488: , payment_term_type_code pn_payment_terms_all.payment_term_type_code %TYPE := NULL
489: , payment_term_type VARCHAR2(80) := NULL
490: , frequency VARCHAR2(80) := NULL
491: , frequency_code pn_payment_terms_all.frequency_code%TYPE := NULL
492: , lease_id pn_payment_terms_all.lease_id %TYPE := NULL
493: , lease_change_id pn_payment_terms_all.lease_change_id%TYPE := NULL
494: , start_date pn_payment_terms_all.start_date%TYPE := NULL
495: , end_date pn_payment_terms_all.end_date%TYPE := NULL
488: , payment_term_type_code pn_payment_terms_all.payment_term_type_code %TYPE := NULL
489: , payment_term_type VARCHAR2(80) := NULL
490: , frequency VARCHAR2(80) := NULL
491: , frequency_code pn_payment_terms_all.frequency_code%TYPE := NULL
492: , lease_id pn_payment_terms_all.lease_id %TYPE := NULL
493: , lease_change_id pn_payment_terms_all.lease_change_id%TYPE := NULL
494: , start_date pn_payment_terms_all.start_date%TYPE := NULL
495: , end_date pn_payment_terms_all.end_date%TYPE := NULL
496: , code_combination_id pn_payment_terms_all.code_combination_id%TYPE := NULL
489: , payment_term_type VARCHAR2(80) := NULL
490: , frequency VARCHAR2(80) := NULL
491: , frequency_code pn_payment_terms_all.frequency_code%TYPE := NULL
492: , lease_id pn_payment_terms_all.lease_id %TYPE := NULL
493: , lease_change_id pn_payment_terms_all.lease_change_id%TYPE := NULL
494: , start_date pn_payment_terms_all.start_date%TYPE := NULL
495: , end_date pn_payment_terms_all.end_date%TYPE := NULL
496: , code_combination_id pn_payment_terms_all.code_combination_id%TYPE := NULL
497: , vendor_id pn_payment_terms_all.vendor_id%TYPE := NULL
490: , frequency VARCHAR2(80) := NULL
491: , frequency_code pn_payment_terms_all.frequency_code%TYPE := NULL
492: , lease_id pn_payment_terms_all.lease_id %TYPE := NULL
493: , lease_change_id pn_payment_terms_all.lease_change_id%TYPE := NULL
494: , start_date pn_payment_terms_all.start_date%TYPE := NULL
495: , end_date pn_payment_terms_all.end_date%TYPE := NULL
496: , code_combination_id pn_payment_terms_all.code_combination_id%TYPE := NULL
497: , vendor_id pn_payment_terms_all.vendor_id%TYPE := NULL
498: , vendor_name po_vendors.vendor_name%TYPE := NULL
491: , frequency_code pn_payment_terms_all.frequency_code%TYPE := NULL
492: , lease_id pn_payment_terms_all.lease_id %TYPE := NULL
493: , lease_change_id pn_payment_terms_all.lease_change_id%TYPE := NULL
494: , start_date pn_payment_terms_all.start_date%TYPE := NULL
495: , end_date pn_payment_terms_all.end_date%TYPE := NULL
496: , code_combination_id pn_payment_terms_all.code_combination_id%TYPE := NULL
497: , vendor_id pn_payment_terms_all.vendor_id%TYPE := NULL
498: , vendor_name po_vendors.vendor_name%TYPE := NULL
499: , vendor_site_code VARCHAR2 (30) := NULL
492: , lease_id pn_payment_terms_all.lease_id %TYPE := NULL
493: , lease_change_id pn_payment_terms_all.lease_change_id%TYPE := NULL
494: , start_date pn_payment_terms_all.start_date%TYPE := NULL
495: , end_date pn_payment_terms_all.end_date%TYPE := NULL
496: , code_combination_id pn_payment_terms_all.code_combination_id%TYPE := NULL
497: , vendor_id pn_payment_terms_all.vendor_id%TYPE := NULL
498: , vendor_name po_vendors.vendor_name%TYPE := NULL
499: , vendor_site_code VARCHAR2 (30) := NULL
500: , vendor_site_id pn_payment_terms_all.vendor_site_id%TYPE := NULL
493: , lease_change_id pn_payment_terms_all.lease_change_id%TYPE := NULL
494: , start_date pn_payment_terms_all.start_date%TYPE := NULL
495: , end_date pn_payment_terms_all.end_date%TYPE := NULL
496: , code_combination_id pn_payment_terms_all.code_combination_id%TYPE := NULL
497: , vendor_id pn_payment_terms_all.vendor_id%TYPE := NULL
498: , vendor_name po_vendors.vendor_name%TYPE := NULL
499: , vendor_site_code VARCHAR2 (30) := NULL
500: , vendor_site_id pn_payment_terms_all.vendor_site_id%TYPE := NULL
501: , target_date pn_payment_terms_all.target_date%TYPE := NULL
496: , code_combination_id pn_payment_terms_all.code_combination_id%TYPE := NULL
497: , vendor_id pn_payment_terms_all.vendor_id%TYPE := NULL
498: , vendor_name po_vendors.vendor_name%TYPE := NULL
499: , vendor_site_code VARCHAR2 (30) := NULL
500: , vendor_site_id pn_payment_terms_all.vendor_site_id%TYPE := NULL
501: , target_date pn_payment_terms_all.target_date%TYPE := NULL
502: , actual_amount pn_payment_terms_all.actual_amount%TYPE := NULL
503: , estimated_amount pn_payment_terms_all.estimated_amount%TYPE := NULL
504: , set_of_books_id pn_payment_terms_all.set_of_books_id%TYPE := NULL
497: , vendor_id pn_payment_terms_all.vendor_id%TYPE := NULL
498: , vendor_name po_vendors.vendor_name%TYPE := NULL
499: , vendor_site_code VARCHAR2 (30) := NULL
500: , vendor_site_id pn_payment_terms_all.vendor_site_id%TYPE := NULL
501: , target_date pn_payment_terms_all.target_date%TYPE := NULL
502: , actual_amount pn_payment_terms_all.actual_amount%TYPE := NULL
503: , estimated_amount pn_payment_terms_all.estimated_amount%TYPE := NULL
504: , set_of_books_id pn_payment_terms_all.set_of_books_id%TYPE := NULL
505: , currency_code pn_payment_terms_all.currency_code%TYPE := NULL
498: , vendor_name po_vendors.vendor_name%TYPE := NULL
499: , vendor_site_code VARCHAR2 (30) := NULL
500: , vendor_site_id pn_payment_terms_all.vendor_site_id%TYPE := NULL
501: , target_date pn_payment_terms_all.target_date%TYPE := NULL
502: , actual_amount pn_payment_terms_all.actual_amount%TYPE := NULL
503: , estimated_amount pn_payment_terms_all.estimated_amount%TYPE := NULL
504: , set_of_books_id pn_payment_terms_all.set_of_books_id%TYPE := NULL
505: , currency_code pn_payment_terms_all.currency_code%TYPE := NULL
506: , rate pn_payment_terms_all.rate %TYPE := NULL
499: , vendor_site_code VARCHAR2 (30) := NULL
500: , vendor_site_id pn_payment_terms_all.vendor_site_id%TYPE := NULL
501: , target_date pn_payment_terms_all.target_date%TYPE := NULL
502: , actual_amount pn_payment_terms_all.actual_amount%TYPE := NULL
503: , estimated_amount pn_payment_terms_all.estimated_amount%TYPE := NULL
504: , set_of_books_id pn_payment_terms_all.set_of_books_id%TYPE := NULL
505: , currency_code pn_payment_terms_all.currency_code%TYPE := NULL
506: , rate pn_payment_terms_all.rate %TYPE := NULL
507: , attribute_category pn_payment_terms_all.attribute_category%TYPE := NULL
500: , vendor_site_id pn_payment_terms_all.vendor_site_id%TYPE := NULL
501: , target_date pn_payment_terms_all.target_date%TYPE := NULL
502: , actual_amount pn_payment_terms_all.actual_amount%TYPE := NULL
503: , estimated_amount pn_payment_terms_all.estimated_amount%TYPE := NULL
504: , set_of_books_id pn_payment_terms_all.set_of_books_id%TYPE := NULL
505: , currency_code pn_payment_terms_all.currency_code%TYPE := NULL
506: , rate pn_payment_terms_all.rate %TYPE := NULL
507: , attribute_category pn_payment_terms_all.attribute_category%TYPE := NULL
508: , attribute1 pn_payment_terms_all.attribute1%TYPE := NULL
501: , target_date pn_payment_terms_all.target_date%TYPE := NULL
502: , actual_amount pn_payment_terms_all.actual_amount%TYPE := NULL
503: , estimated_amount pn_payment_terms_all.estimated_amount%TYPE := NULL
504: , set_of_books_id pn_payment_terms_all.set_of_books_id%TYPE := NULL
505: , currency_code pn_payment_terms_all.currency_code%TYPE := NULL
506: , rate pn_payment_terms_all.rate %TYPE := NULL
507: , attribute_category pn_payment_terms_all.attribute_category%TYPE := NULL
508: , attribute1 pn_payment_terms_all.attribute1%TYPE := NULL
509: , attribute2 pn_payment_terms_all.attribute2%TYPE := NULL
502: , actual_amount pn_payment_terms_all.actual_amount%TYPE := NULL
503: , estimated_amount pn_payment_terms_all.estimated_amount%TYPE := NULL
504: , set_of_books_id pn_payment_terms_all.set_of_books_id%TYPE := NULL
505: , currency_code pn_payment_terms_all.currency_code%TYPE := NULL
506: , rate pn_payment_terms_all.rate %TYPE := NULL
507: , attribute_category pn_payment_terms_all.attribute_category%TYPE := NULL
508: , attribute1 pn_payment_terms_all.attribute1%TYPE := NULL
509: , attribute2 pn_payment_terms_all.attribute2%TYPE := NULL
510: , attribute3 pn_payment_terms_all.attribute3%TYPE := NULL
503: , estimated_amount pn_payment_terms_all.estimated_amount%TYPE := NULL
504: , set_of_books_id pn_payment_terms_all.set_of_books_id%TYPE := NULL
505: , currency_code pn_payment_terms_all.currency_code%TYPE := NULL
506: , rate pn_payment_terms_all.rate %TYPE := NULL
507: , attribute_category pn_payment_terms_all.attribute_category%TYPE := NULL
508: , attribute1 pn_payment_terms_all.attribute1%TYPE := NULL
509: , attribute2 pn_payment_terms_all.attribute2%TYPE := NULL
510: , attribute3 pn_payment_terms_all.attribute3%TYPE := NULL
511: , attribute4 pn_payment_terms_all.attribute4%TYPE := NULL
504: , set_of_books_id pn_payment_terms_all.set_of_books_id%TYPE := NULL
505: , currency_code pn_payment_terms_all.currency_code%TYPE := NULL
506: , rate pn_payment_terms_all.rate %TYPE := NULL
507: , attribute_category pn_payment_terms_all.attribute_category%TYPE := NULL
508: , attribute1 pn_payment_terms_all.attribute1%TYPE := NULL
509: , attribute2 pn_payment_terms_all.attribute2%TYPE := NULL
510: , attribute3 pn_payment_terms_all.attribute3%TYPE := NULL
511: , attribute4 pn_payment_terms_all.attribute4%TYPE := NULL
512: , attribute5 pn_payment_terms_all.attribute5%TYPE := NULL
505: , currency_code pn_payment_terms_all.currency_code%TYPE := NULL
506: , rate pn_payment_terms_all.rate %TYPE := NULL
507: , attribute_category pn_payment_terms_all.attribute_category%TYPE := NULL
508: , attribute1 pn_payment_terms_all.attribute1%TYPE := NULL
509: , attribute2 pn_payment_terms_all.attribute2%TYPE := NULL
510: , attribute3 pn_payment_terms_all.attribute3%TYPE := NULL
511: , attribute4 pn_payment_terms_all.attribute4%TYPE := NULL
512: , attribute5 pn_payment_terms_all.attribute5%TYPE := NULL
513: , attribute6 pn_payment_terms_all.attribute6%TYPE := NULL
506: , rate pn_payment_terms_all.rate %TYPE := NULL
507: , attribute_category pn_payment_terms_all.attribute_category%TYPE := NULL
508: , attribute1 pn_payment_terms_all.attribute1%TYPE := NULL
509: , attribute2 pn_payment_terms_all.attribute2%TYPE := NULL
510: , attribute3 pn_payment_terms_all.attribute3%TYPE := NULL
511: , attribute4 pn_payment_terms_all.attribute4%TYPE := NULL
512: , attribute5 pn_payment_terms_all.attribute5%TYPE := NULL
513: , attribute6 pn_payment_terms_all.attribute6%TYPE := NULL
514: , attribute7 pn_payment_terms_all.attribute7 %TYPE := NULL
507: , attribute_category pn_payment_terms_all.attribute_category%TYPE := NULL
508: , attribute1 pn_payment_terms_all.attribute1%TYPE := NULL
509: , attribute2 pn_payment_terms_all.attribute2%TYPE := NULL
510: , attribute3 pn_payment_terms_all.attribute3%TYPE := NULL
511: , attribute4 pn_payment_terms_all.attribute4%TYPE := NULL
512: , attribute5 pn_payment_terms_all.attribute5%TYPE := NULL
513: , attribute6 pn_payment_terms_all.attribute6%TYPE := NULL
514: , attribute7 pn_payment_terms_all.attribute7 %TYPE := NULL
515: , attribute8 pn_payment_terms_all.attribute8%TYPE := NULL
508: , attribute1 pn_payment_terms_all.attribute1%TYPE := NULL
509: , attribute2 pn_payment_terms_all.attribute2%TYPE := NULL
510: , attribute3 pn_payment_terms_all.attribute3%TYPE := NULL
511: , attribute4 pn_payment_terms_all.attribute4%TYPE := NULL
512: , attribute5 pn_payment_terms_all.attribute5%TYPE := NULL
513: , attribute6 pn_payment_terms_all.attribute6%TYPE := NULL
514: , attribute7 pn_payment_terms_all.attribute7 %TYPE := NULL
515: , attribute8 pn_payment_terms_all.attribute8%TYPE := NULL
516: , attribute9 pn_payment_terms_all.attribute9 %TYPE := NULL
509: , attribute2 pn_payment_terms_all.attribute2%TYPE := NULL
510: , attribute3 pn_payment_terms_all.attribute3%TYPE := NULL
511: , attribute4 pn_payment_terms_all.attribute4%TYPE := NULL
512: , attribute5 pn_payment_terms_all.attribute5%TYPE := NULL
513: , attribute6 pn_payment_terms_all.attribute6%TYPE := NULL
514: , attribute7 pn_payment_terms_all.attribute7 %TYPE := NULL
515: , attribute8 pn_payment_terms_all.attribute8%TYPE := NULL
516: , attribute9 pn_payment_terms_all.attribute9 %TYPE := NULL
517: , attribute10 pn_payment_terms_all.attribute10 %TYPE := NULL
510: , attribute3 pn_payment_terms_all.attribute3%TYPE := NULL
511: , attribute4 pn_payment_terms_all.attribute4%TYPE := NULL
512: , attribute5 pn_payment_terms_all.attribute5%TYPE := NULL
513: , attribute6 pn_payment_terms_all.attribute6%TYPE := NULL
514: , attribute7 pn_payment_terms_all.attribute7 %TYPE := NULL
515: , attribute8 pn_payment_terms_all.attribute8%TYPE := NULL
516: , attribute9 pn_payment_terms_all.attribute9 %TYPE := NULL
517: , attribute10 pn_payment_terms_all.attribute10 %TYPE := NULL
518: , attribute11 pn_payment_terms_all.attribute11%TYPE := NULL
511: , attribute4 pn_payment_terms_all.attribute4%TYPE := NULL
512: , attribute5 pn_payment_terms_all.attribute5%TYPE := NULL
513: , attribute6 pn_payment_terms_all.attribute6%TYPE := NULL
514: , attribute7 pn_payment_terms_all.attribute7 %TYPE := NULL
515: , attribute8 pn_payment_terms_all.attribute8%TYPE := NULL
516: , attribute9 pn_payment_terms_all.attribute9 %TYPE := NULL
517: , attribute10 pn_payment_terms_all.attribute10 %TYPE := NULL
518: , attribute11 pn_payment_terms_all.attribute11%TYPE := NULL
519: , attribute12 pn_payment_terms_all.attribute12%TYPE := NULL
512: , attribute5 pn_payment_terms_all.attribute5%TYPE := NULL
513: , attribute6 pn_payment_terms_all.attribute6%TYPE := NULL
514: , attribute7 pn_payment_terms_all.attribute7 %TYPE := NULL
515: , attribute8 pn_payment_terms_all.attribute8%TYPE := NULL
516: , attribute9 pn_payment_terms_all.attribute9 %TYPE := NULL
517: , attribute10 pn_payment_terms_all.attribute10 %TYPE := NULL
518: , attribute11 pn_payment_terms_all.attribute11%TYPE := NULL
519: , attribute12 pn_payment_terms_all.attribute12%TYPE := NULL
520: , attribute13 pn_payment_terms_all.attribute13 %TYPE := NULL
513: , attribute6 pn_payment_terms_all.attribute6%TYPE := NULL
514: , attribute7 pn_payment_terms_all.attribute7 %TYPE := NULL
515: , attribute8 pn_payment_terms_all.attribute8%TYPE := NULL
516: , attribute9 pn_payment_terms_all.attribute9 %TYPE := NULL
517: , attribute10 pn_payment_terms_all.attribute10 %TYPE := NULL
518: , attribute11 pn_payment_terms_all.attribute11%TYPE := NULL
519: , attribute12 pn_payment_terms_all.attribute12%TYPE := NULL
520: , attribute13 pn_payment_terms_all.attribute13 %TYPE := NULL
521: , attribute14 pn_payment_terms_all.attribute14 %TYPE := NULL
514: , attribute7 pn_payment_terms_all.attribute7 %TYPE := NULL
515: , attribute8 pn_payment_terms_all.attribute8%TYPE := NULL
516: , attribute9 pn_payment_terms_all.attribute9 %TYPE := NULL
517: , attribute10 pn_payment_terms_all.attribute10 %TYPE := NULL
518: , attribute11 pn_payment_terms_all.attribute11%TYPE := NULL
519: , attribute12 pn_payment_terms_all.attribute12%TYPE := NULL
520: , attribute13 pn_payment_terms_all.attribute13 %TYPE := NULL
521: , attribute14 pn_payment_terms_all.attribute14 %TYPE := NULL
522: , attribute15 pn_payment_terms_all.attribute15%TYPE := NULL
515: , attribute8 pn_payment_terms_all.attribute8%TYPE := NULL
516: , attribute9 pn_payment_terms_all.attribute9 %TYPE := NULL
517: , attribute10 pn_payment_terms_all.attribute10 %TYPE := NULL
518: , attribute11 pn_payment_terms_all.attribute11%TYPE := NULL
519: , attribute12 pn_payment_terms_all.attribute12%TYPE := NULL
520: , attribute13 pn_payment_terms_all.attribute13 %TYPE := NULL
521: , attribute14 pn_payment_terms_all.attribute14 %TYPE := NULL
522: , attribute15 pn_payment_terms_all.attribute15%TYPE := NULL
523: , org_id NUMBER := nvl(pn_mo_cache_utils.get_current_org_id,fnd_profile.value ('org_id'))
516: , attribute9 pn_payment_terms_all.attribute9 %TYPE := NULL
517: , attribute10 pn_payment_terms_all.attribute10 %TYPE := NULL
518: , attribute11 pn_payment_terms_all.attribute11%TYPE := NULL
519: , attribute12 pn_payment_terms_all.attribute12%TYPE := NULL
520: , attribute13 pn_payment_terms_all.attribute13 %TYPE := NULL
521: , attribute14 pn_payment_terms_all.attribute14 %TYPE := NULL
522: , attribute15 pn_payment_terms_all.attribute15%TYPE := NULL
523: , org_id NUMBER := nvl(pn_mo_cache_utils.get_current_org_id,fnd_profile.value ('org_id'))
524: , customer_id NUMBER := NULL
517: , attribute10 pn_payment_terms_all.attribute10 %TYPE := NULL
518: , attribute11 pn_payment_terms_all.attribute11%TYPE := NULL
519: , attribute12 pn_payment_terms_all.attribute12%TYPE := NULL
520: , attribute13 pn_payment_terms_all.attribute13 %TYPE := NULL
521: , attribute14 pn_payment_terms_all.attribute14 %TYPE := NULL
522: , attribute15 pn_payment_terms_all.attribute15%TYPE := NULL
523: , org_id NUMBER := nvl(pn_mo_cache_utils.get_current_org_id,fnd_profile.value ('org_id'))
524: , customer_id NUMBER := NULL
525: , customer_name VARCHAR2 (50) := NULL
518: , attribute11 pn_payment_terms_all.attribute11%TYPE := NULL
519: , attribute12 pn_payment_terms_all.attribute12%TYPE := NULL
520: , attribute13 pn_payment_terms_all.attribute13 %TYPE := NULL
521: , attribute14 pn_payment_terms_all.attribute14 %TYPE := NULL
522: , attribute15 pn_payment_terms_all.attribute15%TYPE := NULL
523: , org_id NUMBER := nvl(pn_mo_cache_utils.get_current_org_id,fnd_profile.value ('org_id'))
524: , customer_id NUMBER := NULL
525: , customer_name VARCHAR2 (50) := NULL
526: , customer_site_use_id pn_payment_terms_all.customer_site_use_id%TYPE := NULL
522: , attribute15 pn_payment_terms_all.attribute15%TYPE := NULL
523: , org_id NUMBER := nvl(pn_mo_cache_utils.get_current_org_id,fnd_profile.value ('org_id'))
524: , customer_id NUMBER := NULL
525: , customer_name VARCHAR2 (50) := NULL
526: , customer_site_use_id pn_payment_terms_all.customer_site_use_id%TYPE := NULL
527: , customer_site_code VARCHAR2 (30) := NULL
528: , normalize pn_payment_terms_all.normalize%TYPE := NULL
529: , location_code VARCHAR2(80) := NULL
530: , location_id NUMBER := NULL
524: , customer_id NUMBER := NULL
525: , customer_name VARCHAR2 (50) := NULL
526: , customer_site_use_id pn_payment_terms_all.customer_site_use_id%TYPE := NULL
527: , customer_site_code VARCHAR2 (30) := NULL
528: , normalize pn_payment_terms_all.normalize%TYPE := NULL
529: , location_code VARCHAR2(80) := NULL
530: , location_id NUMBER := NULL
531: , schedule_day pn_payment_terms_all.schedule_day%TYPE := NULL
532: , cust_ship_site_id pn_payment_terms_all.cust_ship_site_id%TYPE := NULL
527: , customer_site_code VARCHAR2 (30) := NULL
528: , normalize pn_payment_terms_all.normalize%TYPE := NULL
529: , location_code VARCHAR2(80) := NULL
530: , location_id NUMBER := NULL
531: , schedule_day pn_payment_terms_all.schedule_day%TYPE := NULL
532: , cust_ship_site_id pn_payment_terms_all.cust_ship_site_id%TYPE := NULL
533: , ap_ar_term_id pn_payment_terms_all.ap_ar_term_id%TYPE := NULL
534: , cust_trx_type_id pn_payment_terms_all.cust_trx_type_id %TYPE := NULL
535: , project_id pn_payment_terms_all.project_id%TYPE := NULL
528: , normalize pn_payment_terms_all.normalize%TYPE := NULL
529: , location_code VARCHAR2(80) := NULL
530: , location_id NUMBER := NULL
531: , schedule_day pn_payment_terms_all.schedule_day%TYPE := NULL
532: , cust_ship_site_id pn_payment_terms_all.cust_ship_site_id%TYPE := NULL
533: , ap_ar_term_id pn_payment_terms_all.ap_ar_term_id%TYPE := NULL
534: , cust_trx_type_id pn_payment_terms_all.cust_trx_type_id %TYPE := NULL
535: , project_id pn_payment_terms_all.project_id%TYPE := NULL
536: , task_id pn_payment_terms_all.task_id%TYPE := NULL
529: , location_code VARCHAR2(80) := NULL
530: , location_id NUMBER := NULL
531: , schedule_day pn_payment_terms_all.schedule_day%TYPE := NULL
532: , cust_ship_site_id pn_payment_terms_all.cust_ship_site_id%TYPE := NULL
533: , ap_ar_term_id pn_payment_terms_all.ap_ar_term_id%TYPE := NULL
534: , cust_trx_type_id pn_payment_terms_all.cust_trx_type_id %TYPE := NULL
535: , project_id pn_payment_terms_all.project_id%TYPE := NULL
536: , task_id pn_payment_terms_all.task_id%TYPE := NULL
537: , organization_id pn_payment_terms_all.organization_id%TYPE := NULL
530: , location_id NUMBER := NULL
531: , schedule_day pn_payment_terms_all.schedule_day%TYPE := NULL
532: , cust_ship_site_id pn_payment_terms_all.cust_ship_site_id%TYPE := NULL
533: , ap_ar_term_id pn_payment_terms_all.ap_ar_term_id%TYPE := NULL
534: , cust_trx_type_id pn_payment_terms_all.cust_trx_type_id %TYPE := NULL
535: , project_id pn_payment_terms_all.project_id%TYPE := NULL
536: , task_id pn_payment_terms_all.task_id%TYPE := NULL
537: , organization_id pn_payment_terms_all.organization_id%TYPE := NULL
538: , expenditure_type pn_payment_terms_all.expenditure_type%TYPE := NULL
531: , schedule_day pn_payment_terms_all.schedule_day%TYPE := NULL
532: , cust_ship_site_id pn_payment_terms_all.cust_ship_site_id%TYPE := NULL
533: , ap_ar_term_id pn_payment_terms_all.ap_ar_term_id%TYPE := NULL
534: , cust_trx_type_id pn_payment_terms_all.cust_trx_type_id %TYPE := NULL
535: , project_id pn_payment_terms_all.project_id%TYPE := NULL
536: , task_id pn_payment_terms_all.task_id%TYPE := NULL
537: , organization_id pn_payment_terms_all.organization_id%TYPE := NULL
538: , expenditure_type pn_payment_terms_all.expenditure_type%TYPE := NULL
539: , expenditure_item_date pn_payment_terms_all.expenditure_item_date%TYPE := NULL
532: , cust_ship_site_id pn_payment_terms_all.cust_ship_site_id%TYPE := NULL
533: , ap_ar_term_id pn_payment_terms_all.ap_ar_term_id%TYPE := NULL
534: , cust_trx_type_id pn_payment_terms_all.cust_trx_type_id %TYPE := NULL
535: , project_id pn_payment_terms_all.project_id%TYPE := NULL
536: , task_id pn_payment_terms_all.task_id%TYPE := NULL
537: , organization_id pn_payment_terms_all.organization_id%TYPE := NULL
538: , expenditure_type pn_payment_terms_all.expenditure_type%TYPE := NULL
539: , expenditure_item_date pn_payment_terms_all.expenditure_item_date%TYPE := NULL
540: , tax_group_id pn_payment_terms_all.tax_group_id%TYPE := NULL
533: , ap_ar_term_id pn_payment_terms_all.ap_ar_term_id%TYPE := NULL
534: , cust_trx_type_id pn_payment_terms_all.cust_trx_type_id %TYPE := NULL
535: , project_id pn_payment_terms_all.project_id%TYPE := NULL
536: , task_id pn_payment_terms_all.task_id%TYPE := NULL
537: , organization_id pn_payment_terms_all.organization_id%TYPE := NULL
538: , expenditure_type pn_payment_terms_all.expenditure_type%TYPE := NULL
539: , expenditure_item_date pn_payment_terms_all.expenditure_item_date%TYPE := NULL
540: , tax_group_id pn_payment_terms_all.tax_group_id%TYPE := NULL
541: , tax_code_id pn_payment_terms_all.tax_code_id%TYPE := NULL
534: , cust_trx_type_id pn_payment_terms_all.cust_trx_type_id %TYPE := NULL
535: , project_id pn_payment_terms_all.project_id%TYPE := NULL
536: , task_id pn_payment_terms_all.task_id%TYPE := NULL
537: , organization_id pn_payment_terms_all.organization_id%TYPE := NULL
538: , expenditure_type pn_payment_terms_all.expenditure_type%TYPE := NULL
539: , expenditure_item_date pn_payment_terms_all.expenditure_item_date%TYPE := NULL
540: , tax_group_id pn_payment_terms_all.tax_group_id%TYPE := NULL
541: , tax_code_id pn_payment_terms_all.tax_code_id%TYPE := NULL
542: , tax_included pn_payment_terms_all.tax_included%TYPE := NULL
535: , project_id pn_payment_terms_all.project_id%TYPE := NULL
536: , task_id pn_payment_terms_all.task_id%TYPE := NULL
537: , organization_id pn_payment_terms_all.organization_id%TYPE := NULL
538: , expenditure_type pn_payment_terms_all.expenditure_type%TYPE := NULL
539: , expenditure_item_date pn_payment_terms_all.expenditure_item_date%TYPE := NULL
540: , tax_group_id pn_payment_terms_all.tax_group_id%TYPE := NULL
541: , tax_code_id pn_payment_terms_all.tax_code_id%TYPE := NULL
542: , tax_included pn_payment_terms_all.tax_included%TYPE := NULL
543: , distribution_set_id pn_payment_terms_all.distribution_set_id%TYPE := NULL
536: , task_id pn_payment_terms_all.task_id%TYPE := NULL
537: , organization_id pn_payment_terms_all.organization_id%TYPE := NULL
538: , expenditure_type pn_payment_terms_all.expenditure_type%TYPE := NULL
539: , expenditure_item_date pn_payment_terms_all.expenditure_item_date%TYPE := NULL
540: , tax_group_id pn_payment_terms_all.tax_group_id%TYPE := NULL
541: , tax_code_id pn_payment_terms_all.tax_code_id%TYPE := NULL
542: , tax_included pn_payment_terms_all.tax_included%TYPE := NULL
543: , distribution_set_id pn_payment_terms_all.distribution_set_id%TYPE := NULL
544: , inv_rule_id pn_payment_terms_all.inv_rule_id%TYPE := NULL
537: , organization_id pn_payment_terms_all.organization_id%TYPE := NULL
538: , expenditure_type pn_payment_terms_all.expenditure_type%TYPE := NULL
539: , expenditure_item_date pn_payment_terms_all.expenditure_item_date%TYPE := NULL
540: , tax_group_id pn_payment_terms_all.tax_group_id%TYPE := NULL
541: , tax_code_id pn_payment_terms_all.tax_code_id%TYPE := NULL
542: , tax_included pn_payment_terms_all.tax_included%TYPE := NULL
543: , distribution_set_id pn_payment_terms_all.distribution_set_id%TYPE := NULL
544: , inv_rule_id pn_payment_terms_all.inv_rule_id%TYPE := NULL
545: , account_rule_id pn_payment_terms_all.account_rule_id%TYPE := NULL
538: , expenditure_type pn_payment_terms_all.expenditure_type%TYPE := NULL
539: , expenditure_item_date pn_payment_terms_all.expenditure_item_date%TYPE := NULL
540: , tax_group_id pn_payment_terms_all.tax_group_id%TYPE := NULL
541: , tax_code_id pn_payment_terms_all.tax_code_id%TYPE := NULL
542: , tax_included pn_payment_terms_all.tax_included%TYPE := NULL
543: , distribution_set_id pn_payment_terms_all.distribution_set_id%TYPE := NULL
544: , inv_rule_id pn_payment_terms_all.inv_rule_id%TYPE := NULL
545: , account_rule_id pn_payment_terms_all.account_rule_id%TYPE := NULL
546: , salesrep_id pn_payment_terms_all.salesrep_id%TYPE := NULL
539: , expenditure_item_date pn_payment_terms_all.expenditure_item_date%TYPE := NULL
540: , tax_group_id pn_payment_terms_all.tax_group_id%TYPE := NULL
541: , tax_code_id pn_payment_terms_all.tax_code_id%TYPE := NULL
542: , tax_included pn_payment_terms_all.tax_included%TYPE := NULL
543: , distribution_set_id pn_payment_terms_all.distribution_set_id%TYPE := NULL
544: , inv_rule_id pn_payment_terms_all.inv_rule_id%TYPE := NULL
545: , account_rule_id pn_payment_terms_all.account_rule_id%TYPE := NULL
546: , salesrep_id pn_payment_terms_all.salesrep_id%TYPE := NULL
547: , approved_by pn_payment_terms_all.approved_by%TYPE := NULL
540: , tax_group_id pn_payment_terms_all.tax_group_id%TYPE := NULL
541: , tax_code_id pn_payment_terms_all.tax_code_id%TYPE := NULL
542: , tax_included pn_payment_terms_all.tax_included%TYPE := NULL
543: , distribution_set_id pn_payment_terms_all.distribution_set_id%TYPE := NULL
544: , inv_rule_id pn_payment_terms_all.inv_rule_id%TYPE := NULL
545: , account_rule_id pn_payment_terms_all.account_rule_id%TYPE := NULL
546: , salesrep_id pn_payment_terms_all.salesrep_id%TYPE := NULL
547: , approved_by pn_payment_terms_all.approved_by%TYPE := NULL
548: , status pn_payment_terms_all.status%TYPE := NULL
541: , tax_code_id pn_payment_terms_all.tax_code_id%TYPE := NULL
542: , tax_included pn_payment_terms_all.tax_included%TYPE := NULL
543: , distribution_set_id pn_payment_terms_all.distribution_set_id%TYPE := NULL
544: , inv_rule_id pn_payment_terms_all.inv_rule_id%TYPE := NULL
545: , account_rule_id pn_payment_terms_all.account_rule_id%TYPE := NULL
546: , salesrep_id pn_payment_terms_all.salesrep_id%TYPE := NULL
547: , approved_by pn_payment_terms_all.approved_by%TYPE := NULL
548: , status pn_payment_terms_all.status%TYPE := NULL
549: , index_period_id pn_payment_terms_all.index_period_id%TYPE := NULL
542: , tax_included pn_payment_terms_all.tax_included%TYPE := NULL
543: , distribution_set_id pn_payment_terms_all.distribution_set_id%TYPE := NULL
544: , inv_rule_id pn_payment_terms_all.inv_rule_id%TYPE := NULL
545: , account_rule_id pn_payment_terms_all.account_rule_id%TYPE := NULL
546: , salesrep_id pn_payment_terms_all.salesrep_id%TYPE := NULL
547: , approved_by pn_payment_terms_all.approved_by%TYPE := NULL
548: , status pn_payment_terms_all.status%TYPE := NULL
549: , index_period_id pn_payment_terms_all.index_period_id%TYPE := NULL
550: , index_term_indicator pn_payment_terms_all.index_term_indicator%TYPE := NULL
543: , distribution_set_id pn_payment_terms_all.distribution_set_id%TYPE := NULL
544: , inv_rule_id pn_payment_terms_all.inv_rule_id%TYPE := NULL
545: , account_rule_id pn_payment_terms_all.account_rule_id%TYPE := NULL
546: , salesrep_id pn_payment_terms_all.salesrep_id%TYPE := NULL
547: , approved_by pn_payment_terms_all.approved_by%TYPE := NULL
548: , status pn_payment_terms_all.status%TYPE := NULL
549: , index_period_id pn_payment_terms_all.index_period_id%TYPE := NULL
550: , index_term_indicator pn_payment_terms_all.index_term_indicator%TYPE := NULL
551: , po_header_id pn_payment_terms_all.po_header_id%TYPE := NULL
544: , inv_rule_id pn_payment_terms_all.inv_rule_id%TYPE := NULL
545: , account_rule_id pn_payment_terms_all.account_rule_id%TYPE := NULL
546: , salesrep_id pn_payment_terms_all.salesrep_id%TYPE := NULL
547: , approved_by pn_payment_terms_all.approved_by%TYPE := NULL
548: , status pn_payment_terms_all.status%TYPE := NULL
549: , index_period_id pn_payment_terms_all.index_period_id%TYPE := NULL
550: , index_term_indicator pn_payment_terms_all.index_term_indicator%TYPE := NULL
551: , po_header_id pn_payment_terms_all.po_header_id%TYPE := NULL
552: , cust_po_number pn_payment_terms_all.cust_po_number%TYPE := NULL
545: , account_rule_id pn_payment_terms_all.account_rule_id%TYPE := NULL
546: , salesrep_id pn_payment_terms_all.salesrep_id%TYPE := NULL
547: , approved_by pn_payment_terms_all.approved_by%TYPE := NULL
548: , status pn_payment_terms_all.status%TYPE := NULL
549: , index_period_id pn_payment_terms_all.index_period_id%TYPE := NULL
550: , index_term_indicator pn_payment_terms_all.index_term_indicator%TYPE := NULL
551: , po_header_id pn_payment_terms_all.po_header_id%TYPE := NULL
552: , cust_po_number pn_payment_terms_all.cust_po_number%TYPE := NULL
553: , receipt_method_id pn_payment_terms_all.receipt_method_id %TYPE := NULL
546: , salesrep_id pn_payment_terms_all.salesrep_id%TYPE := NULL
547: , approved_by pn_payment_terms_all.approved_by%TYPE := NULL
548: , status pn_payment_terms_all.status%TYPE := NULL
549: , index_period_id pn_payment_terms_all.index_period_id%TYPE := NULL
550: , index_term_indicator pn_payment_terms_all.index_term_indicator%TYPE := NULL
551: , po_header_id pn_payment_terms_all.po_header_id%TYPE := NULL
552: , cust_po_number pn_payment_terms_all.cust_po_number%TYPE := NULL
553: , receipt_method_id pn_payment_terms_all.receipt_method_id %TYPE := NULL
554: , project_attribute_category VARCHAR2 (30) := NULL
547: , approved_by pn_payment_terms_all.approved_by%TYPE := NULL
548: , status pn_payment_terms_all.status%TYPE := NULL
549: , index_period_id pn_payment_terms_all.index_period_id%TYPE := NULL
550: , index_term_indicator pn_payment_terms_all.index_term_indicator%TYPE := NULL
551: , po_header_id pn_payment_terms_all.po_header_id%TYPE := NULL
552: , cust_po_number pn_payment_terms_all.cust_po_number%TYPE := NULL
553: , receipt_method_id pn_payment_terms_all.receipt_method_id %TYPE := NULL
554: , project_attribute_category VARCHAR2 (30) := NULL
555: , project_attribute1 VARCHAR2 (150) := NULL
548: , status pn_payment_terms_all.status%TYPE := NULL
549: , index_period_id pn_payment_terms_all.index_period_id%TYPE := NULL
550: , index_term_indicator pn_payment_terms_all.index_term_indicator%TYPE := NULL
551: , po_header_id pn_payment_terms_all.po_header_id%TYPE := NULL
552: , cust_po_number pn_payment_terms_all.cust_po_number%TYPE := NULL
553: , receipt_method_id pn_payment_terms_all.receipt_method_id %TYPE := NULL
554: , project_attribute_category VARCHAR2 (30) := NULL
555: , project_attribute1 VARCHAR2 (150) := NULL
556: , project_attribute2 VARCHAR2 (150) := NULL
549: , index_period_id pn_payment_terms_all.index_period_id%TYPE := NULL
550: , index_term_indicator pn_payment_terms_all.index_term_indicator%TYPE := NULL
551: , po_header_id pn_payment_terms_all.po_header_id%TYPE := NULL
552: , cust_po_number pn_payment_terms_all.cust_po_number%TYPE := NULL
553: , receipt_method_id pn_payment_terms_all.receipt_method_id %TYPE := NULL
554: , project_attribute_category VARCHAR2 (30) := NULL
555: , project_attribute1 VARCHAR2 (150) := NULL
556: , project_attribute2 VARCHAR2 (150) := NULL
557: , project_attribute3 VARCHAR2 (150) := NULL
566: , project_attribute12 VARCHAR2 (150) := NULL
567: , project_attribute13 VARCHAR2 (150) := NULL
568: , project_attribute14 VARCHAR2 (150) := NULL
569: , project_attribute15 VARCHAR2 (150) := NULL
570: , var_rent_inv_id pn_payment_terms_all.var_rent_inv_id%TYPE := NULL
571: , var_rent_type pn_payment_terms_all.var_rent_type%TYPE := NULL
572: , changed_flag pn_payment_terms_all.changed_flag%TYPE := NULL
573: , norm_start_date pn_payment_terms_all.norm_start_date%TYPE := NULL
574: , term_template_id pn_payment_terms_all.term_template_id%TYPE := NULL
567: , project_attribute13 VARCHAR2 (150) := NULL
568: , project_attribute14 VARCHAR2 (150) := NULL
569: , project_attribute15 VARCHAR2 (150) := NULL
570: , var_rent_inv_id pn_payment_terms_all.var_rent_inv_id%TYPE := NULL
571: , var_rent_type pn_payment_terms_all.var_rent_type%TYPE := NULL
572: , changed_flag pn_payment_terms_all.changed_flag%TYPE := NULL
573: , norm_start_date pn_payment_terms_all.norm_start_date%TYPE := NULL
574: , term_template_id pn_payment_terms_all.term_template_id%TYPE := NULL
575: , event_type_code pn_payment_terms_all.event_type_code %TYPE := NULL
568: , project_attribute14 VARCHAR2 (150) := NULL
569: , project_attribute15 VARCHAR2 (150) := NULL
570: , var_rent_inv_id pn_payment_terms_all.var_rent_inv_id%TYPE := NULL
571: , var_rent_type pn_payment_terms_all.var_rent_type%TYPE := NULL
572: , changed_flag pn_payment_terms_all.changed_flag%TYPE := NULL
573: , norm_start_date pn_payment_terms_all.norm_start_date%TYPE := NULL
574: , term_template_id pn_payment_terms_all.term_template_id%TYPE := NULL
575: , event_type_code pn_payment_terms_all.event_type_code %TYPE := NULL
576: , lease_status pn_payment_terms_all.lease_status%TYPE := NULL
569: , project_attribute15 VARCHAR2 (150) := NULL
570: , var_rent_inv_id pn_payment_terms_all.var_rent_inv_id%TYPE := NULL
571: , var_rent_type pn_payment_terms_all.var_rent_type%TYPE := NULL
572: , changed_flag pn_payment_terms_all.changed_flag%TYPE := NULL
573: , norm_start_date pn_payment_terms_all.norm_start_date%TYPE := NULL
574: , term_template_id pn_payment_terms_all.term_template_id%TYPE := NULL
575: , event_type_code pn_payment_terms_all.event_type_code %TYPE := NULL
576: , lease_status pn_payment_terms_all.lease_status%TYPE := NULL
577: , norm_end_date pn_payment_terms_all.norm_end_date%TYPE := NULL
570: , var_rent_inv_id pn_payment_terms_all.var_rent_inv_id%TYPE := NULL
571: , var_rent_type pn_payment_terms_all.var_rent_type%TYPE := NULL
572: , changed_flag pn_payment_terms_all.changed_flag%TYPE := NULL
573: , norm_start_date pn_payment_terms_all.norm_start_date%TYPE := NULL
574: , term_template_id pn_payment_terms_all.term_template_id%TYPE := NULL
575: , event_type_code pn_payment_terms_all.event_type_code %TYPE := NULL
576: , lease_status pn_payment_terms_all.lease_status%TYPE := NULL
577: , norm_end_date pn_payment_terms_all.norm_end_date%TYPE := NULL
578: , recoverable_flag pn_payment_terms_all.recoverable_flag%TYPE := NULL
571: , var_rent_type pn_payment_terms_all.var_rent_type%TYPE := NULL
572: , changed_flag pn_payment_terms_all.changed_flag%TYPE := NULL
573: , norm_start_date pn_payment_terms_all.norm_start_date%TYPE := NULL
574: , term_template_id pn_payment_terms_all.term_template_id%TYPE := NULL
575: , event_type_code pn_payment_terms_all.event_type_code %TYPE := NULL
576: , lease_status pn_payment_terms_all.lease_status%TYPE := NULL
577: , norm_end_date pn_payment_terms_all.norm_end_date%TYPE := NULL
578: , recoverable_flag pn_payment_terms_all.recoverable_flag%TYPE := NULL
579: , period_billrec_id pn_payment_terms_all.period_billrec_id%TYPE := NULL
572: , changed_flag pn_payment_terms_all.changed_flag%TYPE := NULL
573: , norm_start_date pn_payment_terms_all.norm_start_date%TYPE := NULL
574: , term_template_id pn_payment_terms_all.term_template_id%TYPE := NULL
575: , event_type_code pn_payment_terms_all.event_type_code %TYPE := NULL
576: , lease_status pn_payment_terms_all.lease_status%TYPE := NULL
577: , norm_end_date pn_payment_terms_all.norm_end_date%TYPE := NULL
578: , recoverable_flag pn_payment_terms_all.recoverable_flag%TYPE := NULL
579: , period_billrec_id pn_payment_terms_all.period_billrec_id%TYPE := NULL
580: , amount_type pn_payment_terms_all.amount_type%TYPE := NULL
573: , norm_start_date pn_payment_terms_all.norm_start_date%TYPE := NULL
574: , term_template_id pn_payment_terms_all.term_template_id%TYPE := NULL
575: , event_type_code pn_payment_terms_all.event_type_code %TYPE := NULL
576: , lease_status pn_payment_terms_all.lease_status%TYPE := NULL
577: , norm_end_date pn_payment_terms_all.norm_end_date%TYPE := NULL
578: , recoverable_flag pn_payment_terms_all.recoverable_flag%TYPE := NULL
579: , period_billrec_id pn_payment_terms_all.period_billrec_id%TYPE := NULL
580: , amount_type pn_payment_terms_all.amount_type%TYPE := NULL
581: , rec_agr_line_id pn_payment_terms_all.rec_agr_line_id%TYPE := NULL
574: , term_template_id pn_payment_terms_all.term_template_id%TYPE := NULL
575: , event_type_code pn_payment_terms_all.event_type_code %TYPE := NULL
576: , lease_status pn_payment_terms_all.lease_status%TYPE := NULL
577: , norm_end_date pn_payment_terms_all.norm_end_date%TYPE := NULL
578: , recoverable_flag pn_payment_terms_all.recoverable_flag%TYPE := NULL
579: , period_billrec_id pn_payment_terms_all.period_billrec_id%TYPE := NULL
580: , amount_type pn_payment_terms_all.amount_type%TYPE := NULL
581: , rec_agr_line_id pn_payment_terms_all.rec_agr_line_id%TYPE := NULL
582: , grouping_rule_id pn_payment_terms_all.grouping_rule_id%TYPE := NULL
575: , event_type_code pn_payment_terms_all.event_type_code %TYPE := NULL
576: , lease_status pn_payment_terms_all.lease_status%TYPE := NULL
577: , norm_end_date pn_payment_terms_all.norm_end_date%TYPE := NULL
578: , recoverable_flag pn_payment_terms_all.recoverable_flag%TYPE := NULL
579: , period_billrec_id pn_payment_terms_all.period_billrec_id%TYPE := NULL
580: , amount_type pn_payment_terms_all.amount_type%TYPE := NULL
581: , rec_agr_line_id pn_payment_terms_all.rec_agr_line_id%TYPE := NULL
582: , grouping_rule_id pn_payment_terms_all.grouping_rule_id%TYPE := NULL
583: , area_type_code pn_payment_terms_all.area_type_code%TYPE := NULL
576: , lease_status pn_payment_terms_all.lease_status%TYPE := NULL
577: , norm_end_date pn_payment_terms_all.norm_end_date%TYPE := NULL
578: , recoverable_flag pn_payment_terms_all.recoverable_flag%TYPE := NULL
579: , period_billrec_id pn_payment_terms_all.period_billrec_id%TYPE := NULL
580: , amount_type pn_payment_terms_all.amount_type%TYPE := NULL
581: , rec_agr_line_id pn_payment_terms_all.rec_agr_line_id%TYPE := NULL
582: , grouping_rule_id pn_payment_terms_all.grouping_rule_id%TYPE := NULL
583: , area_type_code pn_payment_terms_all.area_type_code%TYPE := NULL
584: , area pn_payment_terms_all.area%TYPE := NULL
577: , norm_end_date pn_payment_terms_all.norm_end_date%TYPE := NULL
578: , recoverable_flag pn_payment_terms_all.recoverable_flag%TYPE := NULL
579: , period_billrec_id pn_payment_terms_all.period_billrec_id%TYPE := NULL
580: , amount_type pn_payment_terms_all.amount_type%TYPE := NULL
581: , rec_agr_line_id pn_payment_terms_all.rec_agr_line_id%TYPE := NULL
582: , grouping_rule_id pn_payment_terms_all.grouping_rule_id%TYPE := NULL
583: , area_type_code pn_payment_terms_all.area_type_code%TYPE := NULL
584: , area pn_payment_terms_all.area%TYPE := NULL
585: , term_altered_flag pn_payment_terms_all.term_altered_flag%TYPE := NULL
578: , recoverable_flag pn_payment_terms_all.recoverable_flag%TYPE := NULL
579: , period_billrec_id pn_payment_terms_all.period_billrec_id%TYPE := NULL
580: , amount_type pn_payment_terms_all.amount_type%TYPE := NULL
581: , rec_agr_line_id pn_payment_terms_all.rec_agr_line_id%TYPE := NULL
582: , grouping_rule_id pn_payment_terms_all.grouping_rule_id%TYPE := NULL
583: , area_type_code pn_payment_terms_all.area_type_code%TYPE := NULL
584: , area pn_payment_terms_all.area%TYPE := NULL
585: , term_altered_flag pn_payment_terms_all.term_altered_flag%TYPE := NULL
586: , source_code pn_payment_terms_all.source_code%TYPE := NULL
579: , period_billrec_id pn_payment_terms_all.period_billrec_id%TYPE := NULL
580: , amount_type pn_payment_terms_all.amount_type%TYPE := NULL
581: , rec_agr_line_id pn_payment_terms_all.rec_agr_line_id%TYPE := NULL
582: , grouping_rule_id pn_payment_terms_all.grouping_rule_id%TYPE := NULL
583: , area_type_code pn_payment_terms_all.area_type_code%TYPE := NULL
584: , area pn_payment_terms_all.area%TYPE := NULL
585: , term_altered_flag pn_payment_terms_all.term_altered_flag%TYPE := NULL
586: , source_code pn_payment_terms_all.source_code%TYPE := NULL
587: , source_name VARCHAR2(80) := NULL
580: , amount_type pn_payment_terms_all.amount_type%TYPE := NULL
581: , rec_agr_line_id pn_payment_terms_all.rec_agr_line_id%TYPE := NULL
582: , grouping_rule_id pn_payment_terms_all.grouping_rule_id%TYPE := NULL
583: , area_type_code pn_payment_terms_all.area_type_code%TYPE := NULL
584: , area pn_payment_terms_all.area%TYPE := NULL
585: , term_altered_flag pn_payment_terms_all.term_altered_flag%TYPE := NULL
586: , source_code pn_payment_terms_all.source_code%TYPE := NULL
587: , source_name VARCHAR2(80) := NULL
588: , term_comments pn_payment_terms_all.term_comments%TYPE := NULL
581: , rec_agr_line_id pn_payment_terms_all.rec_agr_line_id%TYPE := NULL
582: , grouping_rule_id pn_payment_terms_all.grouping_rule_id%TYPE := NULL
583: , area_type_code pn_payment_terms_all.area_type_code%TYPE := NULL
584: , area pn_payment_terms_all.area%TYPE := NULL
585: , term_altered_flag pn_payment_terms_all.term_altered_flag%TYPE := NULL
586: , source_code pn_payment_terms_all.source_code%TYPE := NULL
587: , source_name VARCHAR2(80) := NULL
588: , term_comments pn_payment_terms_all.term_comments%TYPE := NULL
589: , legal_entity_id pn_payment_terms_all.legal_entity_id%TYPE := NULL
582: , grouping_rule_id pn_payment_terms_all.grouping_rule_id%TYPE := NULL
583: , area_type_code pn_payment_terms_all.area_type_code%TYPE := NULL
584: , area pn_payment_terms_all.area%TYPE := NULL
585: , term_altered_flag pn_payment_terms_all.term_altered_flag%TYPE := NULL
586: , source_code pn_payment_terms_all.source_code%TYPE := NULL
587: , source_name VARCHAR2(80) := NULL
588: , term_comments pn_payment_terms_all.term_comments%TYPE := NULL
589: , legal_entity_id pn_payment_terms_all.legal_entity_id%TYPE := NULL
590: , tax_classification_code pn_payment_terms_all.tax_classification_code%TYPE := NULL
584: , area pn_payment_terms_all.area%TYPE := NULL
585: , term_altered_flag pn_payment_terms_all.term_altered_flag%TYPE := NULL
586: , source_code pn_payment_terms_all.source_code%TYPE := NULL
587: , source_name VARCHAR2(80) := NULL
588: , term_comments pn_payment_terms_all.term_comments%TYPE := NULL
589: , legal_entity_id pn_payment_terms_all.legal_entity_id%TYPE := NULL
590: , tax_classification_code pn_payment_terms_all.tax_classification_code%TYPE := NULL
591: , index_norm_flag pn_payment_terms_all.index_norm_flag%TYPE := NULL
592: , parent_term_id pn_payment_terms_all.parent_term_id%TYPE := NULL
585: , term_altered_flag pn_payment_terms_all.term_altered_flag%TYPE := NULL
586: , source_code pn_payment_terms_all.source_code%TYPE := NULL
587: , source_name VARCHAR2(80) := NULL
588: , term_comments pn_payment_terms_all.term_comments%TYPE := NULL
589: , legal_entity_id pn_payment_terms_all.legal_entity_id%TYPE := NULL
590: , tax_classification_code pn_payment_terms_all.tax_classification_code%TYPE := NULL
591: , index_norm_flag pn_payment_terms_all.index_norm_flag%TYPE := NULL
592: , parent_term_id pn_payment_terms_all.parent_term_id%TYPE := NULL
593: , include_in_var_rent pn_payment_terms_all.include_in_var_rent%TYPE := NULL
586: , source_code pn_payment_terms_all.source_code%TYPE := NULL
587: , source_name VARCHAR2(80) := NULL
588: , term_comments pn_payment_terms_all.term_comments%TYPE := NULL
589: , legal_entity_id pn_payment_terms_all.legal_entity_id%TYPE := NULL
590: , tax_classification_code pn_payment_terms_all.tax_classification_code%TYPE := NULL
591: , index_norm_flag pn_payment_terms_all.index_norm_flag%TYPE := NULL
592: , parent_term_id pn_payment_terms_all.parent_term_id%TYPE := NULL
593: , include_in_var_rent pn_payment_terms_all.include_in_var_rent%TYPE := NULL
594: , update_nbp_flag pn_payment_terms_all.update_nbp_flag%TYPE := NULL
587: , source_name VARCHAR2(80) := NULL
588: , term_comments pn_payment_terms_all.term_comments%TYPE := NULL
589: , legal_entity_id pn_payment_terms_all.legal_entity_id%TYPE := NULL
590: , tax_classification_code pn_payment_terms_all.tax_classification_code%TYPE := NULL
591: , index_norm_flag pn_payment_terms_all.index_norm_flag%TYPE := NULL
592: , parent_term_id pn_payment_terms_all.parent_term_id%TYPE := NULL
593: , include_in_var_rent pn_payment_terms_all.include_in_var_rent%TYPE := NULL
594: , update_nbp_flag pn_payment_terms_all.update_nbp_flag%TYPE := NULL
595: , recur_bb_calc_date pn_payment_terms_all.recur_bb_calc_date%TYPE := NULL
588: , term_comments pn_payment_terms_all.term_comments%TYPE := NULL
589: , legal_entity_id pn_payment_terms_all.legal_entity_id%TYPE := NULL
590: , tax_classification_code pn_payment_terms_all.tax_classification_code%TYPE := NULL
591: , index_norm_flag pn_payment_terms_all.index_norm_flag%TYPE := NULL
592: , parent_term_id pn_payment_terms_all.parent_term_id%TYPE := NULL
593: , include_in_var_rent pn_payment_terms_all.include_in_var_rent%TYPE := NULL
594: , update_nbp_flag pn_payment_terms_all.update_nbp_flag%TYPE := NULL
595: , recur_bb_calc_date pn_payment_terms_all.recur_bb_calc_date%TYPE := NULL
596: , opex_type pn_payment_terms_all.opex_type%TYPE := NULL
589: , legal_entity_id pn_payment_terms_all.legal_entity_id%TYPE := NULL
590: , tax_classification_code pn_payment_terms_all.tax_classification_code%TYPE := NULL
591: , index_norm_flag pn_payment_terms_all.index_norm_flag%TYPE := NULL
592: , parent_term_id pn_payment_terms_all.parent_term_id%TYPE := NULL
593: , include_in_var_rent pn_payment_terms_all.include_in_var_rent%TYPE := NULL
594: , update_nbp_flag pn_payment_terms_all.update_nbp_flag%TYPE := NULL
595: , recur_bb_calc_date pn_payment_terms_all.recur_bb_calc_date%TYPE := NULL
596: , opex_type pn_payment_terms_all.opex_type%TYPE := NULL
597: , opex_agr_id pn_payment_terms_all.opex_agr_id%TYPE := NULL
590: , tax_classification_code pn_payment_terms_all.tax_classification_code%TYPE := NULL
591: , index_norm_flag pn_payment_terms_all.index_norm_flag%TYPE := NULL
592: , parent_term_id pn_payment_terms_all.parent_term_id%TYPE := NULL
593: , include_in_var_rent pn_payment_terms_all.include_in_var_rent%TYPE := NULL
594: , update_nbp_flag pn_payment_terms_all.update_nbp_flag%TYPE := NULL
595: , recur_bb_calc_date pn_payment_terms_all.recur_bb_calc_date%TYPE := NULL
596: , opex_type pn_payment_terms_all.opex_type%TYPE := NULL
597: , opex_agr_id pn_payment_terms_all.opex_agr_id%TYPE := NULL
598: , opex_recon_id pn_payment_terms_all.opex_recon_id%TYPE := NULL
591: , index_norm_flag pn_payment_terms_all.index_norm_flag%TYPE := NULL
592: , parent_term_id pn_payment_terms_all.parent_term_id%TYPE := NULL
593: , include_in_var_rent pn_payment_terms_all.include_in_var_rent%TYPE := NULL
594: , update_nbp_flag pn_payment_terms_all.update_nbp_flag%TYPE := NULL
595: , recur_bb_calc_date pn_payment_terms_all.recur_bb_calc_date%TYPE := NULL
596: , opex_type pn_payment_terms_all.opex_type%TYPE := NULL
597: , opex_agr_id pn_payment_terms_all.opex_agr_id%TYPE := NULL
598: , opex_recon_id pn_payment_terms_all.opex_recon_id%TYPE := NULL
599: , error_flag VARCHAR2(1) := NULL
592: , parent_term_id pn_payment_terms_all.parent_term_id%TYPE := NULL
593: , include_in_var_rent pn_payment_terms_all.include_in_var_rent%TYPE := NULL
594: , update_nbp_flag pn_payment_terms_all.update_nbp_flag%TYPE := NULL
595: , recur_bb_calc_date pn_payment_terms_all.recur_bb_calc_date%TYPE := NULL
596: , opex_type pn_payment_terms_all.opex_type%TYPE := NULL
597: , opex_agr_id pn_payment_terms_all.opex_agr_id%TYPE := NULL
598: , opex_recon_id pn_payment_terms_all.opex_recon_id%TYPE := NULL
599: , error_flag VARCHAR2(1) := NULL
600: , p_terms_exp_rev_accounts_tbl terms_exp_rev_accounts_tbl
593: , include_in_var_rent pn_payment_terms_all.include_in_var_rent%TYPE := NULL
594: , update_nbp_flag pn_payment_terms_all.update_nbp_flag%TYPE := NULL
595: , recur_bb_calc_date pn_payment_terms_all.recur_bb_calc_date%TYPE := NULL
596: , opex_type pn_payment_terms_all.opex_type%TYPE := NULL
597: , opex_agr_id pn_payment_terms_all.opex_agr_id%TYPE := NULL
598: , opex_recon_id pn_payment_terms_all.opex_recon_id%TYPE := NULL
599: , error_flag VARCHAR2(1) := NULL
600: , p_terms_exp_rev_accounts_tbl terms_exp_rev_accounts_tbl
601: , p_terms_liab_rcvl_account_tbl terms_exp_rev_accounts_tbl
594: , update_nbp_flag pn_payment_terms_all.update_nbp_flag%TYPE := NULL
595: , recur_bb_calc_date pn_payment_terms_all.recur_bb_calc_date%TYPE := NULL
596: , opex_type pn_payment_terms_all.opex_type%TYPE := NULL
597: , opex_agr_id pn_payment_terms_all.opex_agr_id%TYPE := NULL
598: , opex_recon_id pn_payment_terms_all.opex_recon_id%TYPE := NULL
599: , error_flag VARCHAR2(1) := NULL
600: , p_terms_exp_rev_accounts_tbl terms_exp_rev_accounts_tbl
601: , p_terms_liab_rcvl_account_tbl terms_exp_rev_accounts_tbl
602: , p_terms_accrual_account_tbl terms_exp_rev_accounts_tbl