eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.PN_INDEX_AMOUNT_PKG dependencies on PN_TERM_TEMPLATES

Line 4280: v_normalize pn_term_templates.normalize%TYPE;

4276: ,p_prorate_factor IN NUMBER
4277: ,op_msg OUT NOCOPY VARCHAR2
4278: ) IS
4279: v_msg VARCHAR2 (1000);
4280: v_normalize pn_term_templates.normalize%TYPE;
4281: v_index_amount pn_index_lease_periods.constraint_rent_due%TYPE;
4282: v_uncontrained_index_amount NUMBER;
4283: v_constrained_rent_amount NUMBER := 0;
4284: v_normalized_amount_annual NUMBER;

Line 4358: FROM pn_term_templates_all

4354:
4355: IF p_term_template_id IS NOT NULL THEN
4356: SELECT normalize
4357: INTO v_normalize
4358: FROM pn_term_templates_all
4359: WHERE term_template_id = p_term_template_id;
4360: ELSE
4361: /* if p_term_template_id is null, then payment term aggregation will be done */
4362: v_normalize := 'Y';

Line 5076: v_name pn_term_templates.name%TYPE;

5072: ,op_payment_term_id OUT NOCOPY NUMBER
5073: ,op_msg OUT NOCOPY VARCHAR2
5074: ,p_include_in_var_rent IN VARCHAR2
5075: ) IS
5076: v_name pn_term_templates.name%TYPE;
5077: v_normalize pn_term_templates.normalize%TYPE := 'N';
5078: v_schedule_day pn_term_templates.schedule_day%TYPE;
5079: v_payment_purpose_code pn_term_templates.payment_purpose_code%TYPE;
5080: v_payment_term_type_code pn_term_templates.payment_term_type_code%TYPE;

Line 5077: v_normalize pn_term_templates.normalize%TYPE := 'N';

5073: ,op_msg OUT NOCOPY VARCHAR2
5074: ,p_include_in_var_rent IN VARCHAR2
5075: ) IS
5076: v_name pn_term_templates.name%TYPE;
5077: v_normalize pn_term_templates.normalize%TYPE := 'N';
5078: v_schedule_day pn_term_templates.schedule_day%TYPE;
5079: v_payment_purpose_code pn_term_templates.payment_purpose_code%TYPE;
5080: v_payment_term_type_code pn_term_templates.payment_term_type_code%TYPE;
5081: v_accrual_account_id pn_term_templates.accrual_account_id%TYPE;

Line 5078: v_schedule_day pn_term_templates.schedule_day%TYPE;

5074: ,p_include_in_var_rent IN VARCHAR2
5075: ) IS
5076: v_name pn_term_templates.name%TYPE;
5077: v_normalize pn_term_templates.normalize%TYPE := 'N';
5078: v_schedule_day pn_term_templates.schedule_day%TYPE;
5079: v_payment_purpose_code pn_term_templates.payment_purpose_code%TYPE;
5080: v_payment_term_type_code pn_term_templates.payment_term_type_code%TYPE;
5081: v_accrual_account_id pn_term_templates.accrual_account_id%TYPE;
5082: v_project_id pn_term_templates.project_id%TYPE;

Line 5079: v_payment_purpose_code pn_term_templates.payment_purpose_code%TYPE;

5075: ) IS
5076: v_name pn_term_templates.name%TYPE;
5077: v_normalize pn_term_templates.normalize%TYPE := 'N';
5078: v_schedule_day pn_term_templates.schedule_day%TYPE;
5079: v_payment_purpose_code pn_term_templates.payment_purpose_code%TYPE;
5080: v_payment_term_type_code pn_term_templates.payment_term_type_code%TYPE;
5081: v_accrual_account_id pn_term_templates.accrual_account_id%TYPE;
5082: v_project_id pn_term_templates.project_id%TYPE;
5083: v_task_id pn_term_templates.task_id%TYPE;

Line 5080: v_payment_term_type_code pn_term_templates.payment_term_type_code%TYPE;

5076: v_name pn_term_templates.name%TYPE;
5077: v_normalize pn_term_templates.normalize%TYPE := 'N';
5078: v_schedule_day pn_term_templates.schedule_day%TYPE;
5079: v_payment_purpose_code pn_term_templates.payment_purpose_code%TYPE;
5080: v_payment_term_type_code pn_term_templates.payment_term_type_code%TYPE;
5081: v_accrual_account_id pn_term_templates.accrual_account_id%TYPE;
5082: v_project_id pn_term_templates.project_id%TYPE;
5083: v_task_id pn_term_templates.task_id%TYPE;
5084: v_organization_id pn_term_templates.organization_id%TYPE;

Line 5081: v_accrual_account_id pn_term_templates.accrual_account_id%TYPE;

5077: v_normalize pn_term_templates.normalize%TYPE := 'N';
5078: v_schedule_day pn_term_templates.schedule_day%TYPE;
5079: v_payment_purpose_code pn_term_templates.payment_purpose_code%TYPE;
5080: v_payment_term_type_code pn_term_templates.payment_term_type_code%TYPE;
5081: v_accrual_account_id pn_term_templates.accrual_account_id%TYPE;
5082: v_project_id pn_term_templates.project_id%TYPE;
5083: v_task_id pn_term_templates.task_id%TYPE;
5084: v_organization_id pn_term_templates.organization_id%TYPE;
5085: v_expenditure_type pn_term_templates.expenditure_type%TYPE;

Line 5082: v_project_id pn_term_templates.project_id%TYPE;

5078: v_schedule_day pn_term_templates.schedule_day%TYPE;
5079: v_payment_purpose_code pn_term_templates.payment_purpose_code%TYPE;
5080: v_payment_term_type_code pn_term_templates.payment_term_type_code%TYPE;
5081: v_accrual_account_id pn_term_templates.accrual_account_id%TYPE;
5082: v_project_id pn_term_templates.project_id%TYPE;
5083: v_task_id pn_term_templates.task_id%TYPE;
5084: v_organization_id pn_term_templates.organization_id%TYPE;
5085: v_expenditure_type pn_term_templates.expenditure_type%TYPE;
5086: v_expenditure_item_date pn_term_templates.expenditure_item_date%TYPE;

Line 5083: v_task_id pn_term_templates.task_id%TYPE;

5079: v_payment_purpose_code pn_term_templates.payment_purpose_code%TYPE;
5080: v_payment_term_type_code pn_term_templates.payment_term_type_code%TYPE;
5081: v_accrual_account_id pn_term_templates.accrual_account_id%TYPE;
5082: v_project_id pn_term_templates.project_id%TYPE;
5083: v_task_id pn_term_templates.task_id%TYPE;
5084: v_organization_id pn_term_templates.organization_id%TYPE;
5085: v_expenditure_type pn_term_templates.expenditure_type%TYPE;
5086: v_expenditure_item_date pn_term_templates.expenditure_item_date%TYPE;
5087: v_vendor_id pn_term_templates.vendor_id%TYPE;

Line 5084: v_organization_id pn_term_templates.organization_id%TYPE;

5080: v_payment_term_type_code pn_term_templates.payment_term_type_code%TYPE;
5081: v_accrual_account_id pn_term_templates.accrual_account_id%TYPE;
5082: v_project_id pn_term_templates.project_id%TYPE;
5083: v_task_id pn_term_templates.task_id%TYPE;
5084: v_organization_id pn_term_templates.organization_id%TYPE;
5085: v_expenditure_type pn_term_templates.expenditure_type%TYPE;
5086: v_expenditure_item_date pn_term_templates.expenditure_item_date%TYPE;
5087: v_vendor_id pn_term_templates.vendor_id%TYPE;
5088: v_vendor_site_id pn_term_templates.vendor_site_id%TYPE;

Line 5085: v_expenditure_type pn_term_templates.expenditure_type%TYPE;

5081: v_accrual_account_id pn_term_templates.accrual_account_id%TYPE;
5082: v_project_id pn_term_templates.project_id%TYPE;
5083: v_task_id pn_term_templates.task_id%TYPE;
5084: v_organization_id pn_term_templates.organization_id%TYPE;
5085: v_expenditure_type pn_term_templates.expenditure_type%TYPE;
5086: v_expenditure_item_date pn_term_templates.expenditure_item_date%TYPE;
5087: v_vendor_id pn_term_templates.vendor_id%TYPE;
5088: v_vendor_site_id pn_term_templates.vendor_site_id%TYPE;
5089: v_customer_id pn_term_templates.customer_id%TYPE;

Line 5086: v_expenditure_item_date pn_term_templates.expenditure_item_date%TYPE;

5082: v_project_id pn_term_templates.project_id%TYPE;
5083: v_task_id pn_term_templates.task_id%TYPE;
5084: v_organization_id pn_term_templates.organization_id%TYPE;
5085: v_expenditure_type pn_term_templates.expenditure_type%TYPE;
5086: v_expenditure_item_date pn_term_templates.expenditure_item_date%TYPE;
5087: v_vendor_id pn_term_templates.vendor_id%TYPE;
5088: v_vendor_site_id pn_term_templates.vendor_site_id%TYPE;
5089: v_customer_id pn_term_templates.customer_id%TYPE;
5090: v_customer_site_use_id pn_term_templates.customer_site_use_id%TYPE;

Line 5087: v_vendor_id pn_term_templates.vendor_id%TYPE;

5083: v_task_id pn_term_templates.task_id%TYPE;
5084: v_organization_id pn_term_templates.organization_id%TYPE;
5085: v_expenditure_type pn_term_templates.expenditure_type%TYPE;
5086: v_expenditure_item_date pn_term_templates.expenditure_item_date%TYPE;
5087: v_vendor_id pn_term_templates.vendor_id%TYPE;
5088: v_vendor_site_id pn_term_templates.vendor_site_id%TYPE;
5089: v_customer_id pn_term_templates.customer_id%TYPE;
5090: v_customer_site_use_id pn_term_templates.customer_site_use_id%TYPE;
5091: v_cust_ship_site_id pn_term_templates.cust_ship_site_id%TYPE;

Line 5088: v_vendor_site_id pn_term_templates.vendor_site_id%TYPE;

5084: v_organization_id pn_term_templates.organization_id%TYPE;
5085: v_expenditure_type pn_term_templates.expenditure_type%TYPE;
5086: v_expenditure_item_date pn_term_templates.expenditure_item_date%TYPE;
5087: v_vendor_id pn_term_templates.vendor_id%TYPE;
5088: v_vendor_site_id pn_term_templates.vendor_site_id%TYPE;
5089: v_customer_id pn_term_templates.customer_id%TYPE;
5090: v_customer_site_use_id pn_term_templates.customer_site_use_id%TYPE;
5091: v_cust_ship_site_id pn_term_templates.cust_ship_site_id%TYPE;
5092: v_ap_ar_term_id pn_term_templates.ap_ar_term_id%TYPE;

Line 5089: v_customer_id pn_term_templates.customer_id%TYPE;

5085: v_expenditure_type pn_term_templates.expenditure_type%TYPE;
5086: v_expenditure_item_date pn_term_templates.expenditure_item_date%TYPE;
5087: v_vendor_id pn_term_templates.vendor_id%TYPE;
5088: v_vendor_site_id pn_term_templates.vendor_site_id%TYPE;
5089: v_customer_id pn_term_templates.customer_id%TYPE;
5090: v_customer_site_use_id pn_term_templates.customer_site_use_id%TYPE;
5091: v_cust_ship_site_id pn_term_templates.cust_ship_site_id%TYPE;
5092: v_ap_ar_term_id pn_term_templates.ap_ar_term_id%TYPE;
5093: v_cust_trx_type_id pn_term_templates.cust_trx_type_id%TYPE;

Line 5090: v_customer_site_use_id pn_term_templates.customer_site_use_id%TYPE;

5086: v_expenditure_item_date pn_term_templates.expenditure_item_date%TYPE;
5087: v_vendor_id pn_term_templates.vendor_id%TYPE;
5088: v_vendor_site_id pn_term_templates.vendor_site_id%TYPE;
5089: v_customer_id pn_term_templates.customer_id%TYPE;
5090: v_customer_site_use_id pn_term_templates.customer_site_use_id%TYPE;
5091: v_cust_ship_site_id pn_term_templates.cust_ship_site_id%TYPE;
5092: v_ap_ar_term_id pn_term_templates.ap_ar_term_id%TYPE;
5093: v_cust_trx_type_id pn_term_templates.cust_trx_type_id%TYPE;
5094: v_tax_group_id pn_term_templates.tax_group_id%TYPE;

Line 5091: v_cust_ship_site_id pn_term_templates.cust_ship_site_id%TYPE;

5087: v_vendor_id pn_term_templates.vendor_id%TYPE;
5088: v_vendor_site_id pn_term_templates.vendor_site_id%TYPE;
5089: v_customer_id pn_term_templates.customer_id%TYPE;
5090: v_customer_site_use_id pn_term_templates.customer_site_use_id%TYPE;
5091: v_cust_ship_site_id pn_term_templates.cust_ship_site_id%TYPE;
5092: v_ap_ar_term_id pn_term_templates.ap_ar_term_id%TYPE;
5093: v_cust_trx_type_id pn_term_templates.cust_trx_type_id%TYPE;
5094: v_tax_group_id pn_term_templates.tax_group_id%TYPE;
5095: v_tax_code_id pn_term_templates.tax_code_id%TYPE;

Line 5092: v_ap_ar_term_id pn_term_templates.ap_ar_term_id%TYPE;

5088: v_vendor_site_id pn_term_templates.vendor_site_id%TYPE;
5089: v_customer_id pn_term_templates.customer_id%TYPE;
5090: v_customer_site_use_id pn_term_templates.customer_site_use_id%TYPE;
5091: v_cust_ship_site_id pn_term_templates.cust_ship_site_id%TYPE;
5092: v_ap_ar_term_id pn_term_templates.ap_ar_term_id%TYPE;
5093: v_cust_trx_type_id pn_term_templates.cust_trx_type_id%TYPE;
5094: v_tax_group_id pn_term_templates.tax_group_id%TYPE;
5095: v_tax_code_id pn_term_templates.tax_code_id%TYPE;
5096: v_tax_classification_code pn_term_templates.tax_classification_code%TYPE;

Line 5093: v_cust_trx_type_id pn_term_templates.cust_trx_type_id%TYPE;

5089: v_customer_id pn_term_templates.customer_id%TYPE;
5090: v_customer_site_use_id pn_term_templates.customer_site_use_id%TYPE;
5091: v_cust_ship_site_id pn_term_templates.cust_ship_site_id%TYPE;
5092: v_ap_ar_term_id pn_term_templates.ap_ar_term_id%TYPE;
5093: v_cust_trx_type_id pn_term_templates.cust_trx_type_id%TYPE;
5094: v_tax_group_id pn_term_templates.tax_group_id%TYPE;
5095: v_tax_code_id pn_term_templates.tax_code_id%TYPE;
5096: v_tax_classification_code pn_term_templates.tax_classification_code%TYPE;
5097: v_tax_included pn_term_templates.tax_included%TYPE;

Line 5094: v_tax_group_id pn_term_templates.tax_group_id%TYPE;

5090: v_customer_site_use_id pn_term_templates.customer_site_use_id%TYPE;
5091: v_cust_ship_site_id pn_term_templates.cust_ship_site_id%TYPE;
5092: v_ap_ar_term_id pn_term_templates.ap_ar_term_id%TYPE;
5093: v_cust_trx_type_id pn_term_templates.cust_trx_type_id%TYPE;
5094: v_tax_group_id pn_term_templates.tax_group_id%TYPE;
5095: v_tax_code_id pn_term_templates.tax_code_id%TYPE;
5096: v_tax_classification_code pn_term_templates.tax_classification_code%TYPE;
5097: v_tax_included pn_term_templates.tax_included%TYPE;
5098: v_distribution_set_id pn_term_templates.distribution_set_id%TYPE;

Line 5095: v_tax_code_id pn_term_templates.tax_code_id%TYPE;

5091: v_cust_ship_site_id pn_term_templates.cust_ship_site_id%TYPE;
5092: v_ap_ar_term_id pn_term_templates.ap_ar_term_id%TYPE;
5093: v_cust_trx_type_id pn_term_templates.cust_trx_type_id%TYPE;
5094: v_tax_group_id pn_term_templates.tax_group_id%TYPE;
5095: v_tax_code_id pn_term_templates.tax_code_id%TYPE;
5096: v_tax_classification_code pn_term_templates.tax_classification_code%TYPE;
5097: v_tax_included pn_term_templates.tax_included%TYPE;
5098: v_distribution_set_id pn_term_templates.distribution_set_id%TYPE;
5099: v_inv_rule_id pn_term_templates.inv_rule_id%TYPE;

Line 5096: v_tax_classification_code pn_term_templates.tax_classification_code%TYPE;

5092: v_ap_ar_term_id pn_term_templates.ap_ar_term_id%TYPE;
5093: v_cust_trx_type_id pn_term_templates.cust_trx_type_id%TYPE;
5094: v_tax_group_id pn_term_templates.tax_group_id%TYPE;
5095: v_tax_code_id pn_term_templates.tax_code_id%TYPE;
5096: v_tax_classification_code pn_term_templates.tax_classification_code%TYPE;
5097: v_tax_included pn_term_templates.tax_included%TYPE;
5098: v_distribution_set_id pn_term_templates.distribution_set_id%TYPE;
5099: v_inv_rule_id pn_term_templates.inv_rule_id%TYPE;
5100: v_account_rule_id pn_term_templates.account_rule_id%TYPE;

Line 5097: v_tax_included pn_term_templates.tax_included%TYPE;

5093: v_cust_trx_type_id pn_term_templates.cust_trx_type_id%TYPE;
5094: v_tax_group_id pn_term_templates.tax_group_id%TYPE;
5095: v_tax_code_id pn_term_templates.tax_code_id%TYPE;
5096: v_tax_classification_code pn_term_templates.tax_classification_code%TYPE;
5097: v_tax_included pn_term_templates.tax_included%TYPE;
5098: v_distribution_set_id pn_term_templates.distribution_set_id%TYPE;
5099: v_inv_rule_id pn_term_templates.inv_rule_id%TYPE;
5100: v_account_rule_id pn_term_templates.account_rule_id%TYPE;
5101: v_salesrep_id pn_term_templates.salesrep_id%TYPE;

Line 5098: v_distribution_set_id pn_term_templates.distribution_set_id%TYPE;

5094: v_tax_group_id pn_term_templates.tax_group_id%TYPE;
5095: v_tax_code_id pn_term_templates.tax_code_id%TYPE;
5096: v_tax_classification_code pn_term_templates.tax_classification_code%TYPE;
5097: v_tax_included pn_term_templates.tax_included%TYPE;
5098: v_distribution_set_id pn_term_templates.distribution_set_id%TYPE;
5099: v_inv_rule_id pn_term_templates.inv_rule_id%TYPE;
5100: v_account_rule_id pn_term_templates.account_rule_id%TYPE;
5101: v_salesrep_id pn_term_templates.salesrep_id%TYPE;
5102: v_set_of_books_id pn_term_templates.set_of_books_id%TYPE;

Line 5099: v_inv_rule_id pn_term_templates.inv_rule_id%TYPE;

5095: v_tax_code_id pn_term_templates.tax_code_id%TYPE;
5096: v_tax_classification_code pn_term_templates.tax_classification_code%TYPE;
5097: v_tax_included pn_term_templates.tax_included%TYPE;
5098: v_distribution_set_id pn_term_templates.distribution_set_id%TYPE;
5099: v_inv_rule_id pn_term_templates.inv_rule_id%TYPE;
5100: v_account_rule_id pn_term_templates.account_rule_id%TYPE;
5101: v_salesrep_id pn_term_templates.salesrep_id%TYPE;
5102: v_set_of_books_id pn_term_templates.set_of_books_id%TYPE;
5103: v_currency_code pn_payment_terms.currency_code%TYPE;

Line 5100: v_account_rule_id pn_term_templates.account_rule_id%TYPE;

5096: v_tax_classification_code pn_term_templates.tax_classification_code%TYPE;
5097: v_tax_included pn_term_templates.tax_included%TYPE;
5098: v_distribution_set_id pn_term_templates.distribution_set_id%TYPE;
5099: v_inv_rule_id pn_term_templates.inv_rule_id%TYPE;
5100: v_account_rule_id pn_term_templates.account_rule_id%TYPE;
5101: v_salesrep_id pn_term_templates.salesrep_id%TYPE;
5102: v_set_of_books_id pn_term_templates.set_of_books_id%TYPE;
5103: v_currency_code pn_payment_terms.currency_code%TYPE;
5104: v_po_header_id pn_term_templates.po_header_id%TYPE;

Line 5101: v_salesrep_id pn_term_templates.salesrep_id%TYPE;

5097: v_tax_included pn_term_templates.tax_included%TYPE;
5098: v_distribution_set_id pn_term_templates.distribution_set_id%TYPE;
5099: v_inv_rule_id pn_term_templates.inv_rule_id%TYPE;
5100: v_account_rule_id pn_term_templates.account_rule_id%TYPE;
5101: v_salesrep_id pn_term_templates.salesrep_id%TYPE;
5102: v_set_of_books_id pn_term_templates.set_of_books_id%TYPE;
5103: v_currency_code pn_payment_terms.currency_code%TYPE;
5104: v_po_header_id pn_term_templates.po_header_id%TYPE;
5105: v_cust_po_number pn_term_templates.cust_po_number%TYPE;

Line 5102: v_set_of_books_id pn_term_templates.set_of_books_id%TYPE;

5098: v_distribution_set_id pn_term_templates.distribution_set_id%TYPE;
5099: v_inv_rule_id pn_term_templates.inv_rule_id%TYPE;
5100: v_account_rule_id pn_term_templates.account_rule_id%TYPE;
5101: v_salesrep_id pn_term_templates.salesrep_id%TYPE;
5102: v_set_of_books_id pn_term_templates.set_of_books_id%TYPE;
5103: v_currency_code pn_payment_terms.currency_code%TYPE;
5104: v_po_header_id pn_term_templates.po_header_id%TYPE;
5105: v_cust_po_number pn_term_templates.cust_po_number%TYPE;
5106: v_receipt_method_id pn_term_templates.receipt_method_id%TYPE;

Line 5104: v_po_header_id pn_term_templates.po_header_id%TYPE;

5100: v_account_rule_id pn_term_templates.account_rule_id%TYPE;
5101: v_salesrep_id pn_term_templates.salesrep_id%TYPE;
5102: v_set_of_books_id pn_term_templates.set_of_books_id%TYPE;
5103: v_currency_code pn_payment_terms.currency_code%TYPE;
5104: v_po_header_id pn_term_templates.po_header_id%TYPE;
5105: v_cust_po_number pn_term_templates.cust_po_number%TYPE;
5106: v_receipt_method_id pn_term_templates.receipt_method_id%TYPE;
5107: v_attribute_category pn_term_templates.attribute_category%TYPE;
5108: v_attribute1 pn_term_templates.attribute1%TYPE;

Line 5105: v_cust_po_number pn_term_templates.cust_po_number%TYPE;

5101: v_salesrep_id pn_term_templates.salesrep_id%TYPE;
5102: v_set_of_books_id pn_term_templates.set_of_books_id%TYPE;
5103: v_currency_code pn_payment_terms.currency_code%TYPE;
5104: v_po_header_id pn_term_templates.po_header_id%TYPE;
5105: v_cust_po_number pn_term_templates.cust_po_number%TYPE;
5106: v_receipt_method_id pn_term_templates.receipt_method_id%TYPE;
5107: v_attribute_category pn_term_templates.attribute_category%TYPE;
5108: v_attribute1 pn_term_templates.attribute1%TYPE;
5109: v_attribute2 pn_term_templates.attribute2%TYPE;

Line 5106: v_receipt_method_id pn_term_templates.receipt_method_id%TYPE;

5102: v_set_of_books_id pn_term_templates.set_of_books_id%TYPE;
5103: v_currency_code pn_payment_terms.currency_code%TYPE;
5104: v_po_header_id pn_term_templates.po_header_id%TYPE;
5105: v_cust_po_number pn_term_templates.cust_po_number%TYPE;
5106: v_receipt_method_id pn_term_templates.receipt_method_id%TYPE;
5107: v_attribute_category pn_term_templates.attribute_category%TYPE;
5108: v_attribute1 pn_term_templates.attribute1%TYPE;
5109: v_attribute2 pn_term_templates.attribute2%TYPE;
5110: v_attribute3 pn_term_templates.attribute3%TYPE;

Line 5107: v_attribute_category pn_term_templates.attribute_category%TYPE;

5103: v_currency_code pn_payment_terms.currency_code%TYPE;
5104: v_po_header_id pn_term_templates.po_header_id%TYPE;
5105: v_cust_po_number pn_term_templates.cust_po_number%TYPE;
5106: v_receipt_method_id pn_term_templates.receipt_method_id%TYPE;
5107: v_attribute_category pn_term_templates.attribute_category%TYPE;
5108: v_attribute1 pn_term_templates.attribute1%TYPE;
5109: v_attribute2 pn_term_templates.attribute2%TYPE;
5110: v_attribute3 pn_term_templates.attribute3%TYPE;
5111: v_attribute4 pn_term_templates.attribute4%TYPE;

Line 5108: v_attribute1 pn_term_templates.attribute1%TYPE;

5104: v_po_header_id pn_term_templates.po_header_id%TYPE;
5105: v_cust_po_number pn_term_templates.cust_po_number%TYPE;
5106: v_receipt_method_id pn_term_templates.receipt_method_id%TYPE;
5107: v_attribute_category pn_term_templates.attribute_category%TYPE;
5108: v_attribute1 pn_term_templates.attribute1%TYPE;
5109: v_attribute2 pn_term_templates.attribute2%TYPE;
5110: v_attribute3 pn_term_templates.attribute3%TYPE;
5111: v_attribute4 pn_term_templates.attribute4%TYPE;
5112: v_attribute5 pn_term_templates.attribute5%TYPE;

Line 5109: v_attribute2 pn_term_templates.attribute2%TYPE;

5105: v_cust_po_number pn_term_templates.cust_po_number%TYPE;
5106: v_receipt_method_id pn_term_templates.receipt_method_id%TYPE;
5107: v_attribute_category pn_term_templates.attribute_category%TYPE;
5108: v_attribute1 pn_term_templates.attribute1%TYPE;
5109: v_attribute2 pn_term_templates.attribute2%TYPE;
5110: v_attribute3 pn_term_templates.attribute3%TYPE;
5111: v_attribute4 pn_term_templates.attribute4%TYPE;
5112: v_attribute5 pn_term_templates.attribute5%TYPE;
5113: v_attribute6 pn_term_templates.attribute6%TYPE;

Line 5110: v_attribute3 pn_term_templates.attribute3%TYPE;

5106: v_receipt_method_id pn_term_templates.receipt_method_id%TYPE;
5107: v_attribute_category pn_term_templates.attribute_category%TYPE;
5108: v_attribute1 pn_term_templates.attribute1%TYPE;
5109: v_attribute2 pn_term_templates.attribute2%TYPE;
5110: v_attribute3 pn_term_templates.attribute3%TYPE;
5111: v_attribute4 pn_term_templates.attribute4%TYPE;
5112: v_attribute5 pn_term_templates.attribute5%TYPE;
5113: v_attribute6 pn_term_templates.attribute6%TYPE;
5114: v_attribute7 pn_term_templates.attribute7%TYPE;

Line 5111: v_attribute4 pn_term_templates.attribute4%TYPE;

5107: v_attribute_category pn_term_templates.attribute_category%TYPE;
5108: v_attribute1 pn_term_templates.attribute1%TYPE;
5109: v_attribute2 pn_term_templates.attribute2%TYPE;
5110: v_attribute3 pn_term_templates.attribute3%TYPE;
5111: v_attribute4 pn_term_templates.attribute4%TYPE;
5112: v_attribute5 pn_term_templates.attribute5%TYPE;
5113: v_attribute6 pn_term_templates.attribute6%TYPE;
5114: v_attribute7 pn_term_templates.attribute7%TYPE;
5115: v_attribute8 pn_term_templates.attribute8%TYPE;

Line 5112: v_attribute5 pn_term_templates.attribute5%TYPE;

5108: v_attribute1 pn_term_templates.attribute1%TYPE;
5109: v_attribute2 pn_term_templates.attribute2%TYPE;
5110: v_attribute3 pn_term_templates.attribute3%TYPE;
5111: v_attribute4 pn_term_templates.attribute4%TYPE;
5112: v_attribute5 pn_term_templates.attribute5%TYPE;
5113: v_attribute6 pn_term_templates.attribute6%TYPE;
5114: v_attribute7 pn_term_templates.attribute7%TYPE;
5115: v_attribute8 pn_term_templates.attribute8%TYPE;
5116: v_attribute9 pn_term_templates.attribute9%TYPE;

Line 5113: v_attribute6 pn_term_templates.attribute6%TYPE;

5109: v_attribute2 pn_term_templates.attribute2%TYPE;
5110: v_attribute3 pn_term_templates.attribute3%TYPE;
5111: v_attribute4 pn_term_templates.attribute4%TYPE;
5112: v_attribute5 pn_term_templates.attribute5%TYPE;
5113: v_attribute6 pn_term_templates.attribute6%TYPE;
5114: v_attribute7 pn_term_templates.attribute7%TYPE;
5115: v_attribute8 pn_term_templates.attribute8%TYPE;
5116: v_attribute9 pn_term_templates.attribute9%TYPE;
5117: v_attribute10 pn_term_templates.attribute10%TYPE;

Line 5114: v_attribute7 pn_term_templates.attribute7%TYPE;

5110: v_attribute3 pn_term_templates.attribute3%TYPE;
5111: v_attribute4 pn_term_templates.attribute4%TYPE;
5112: v_attribute5 pn_term_templates.attribute5%TYPE;
5113: v_attribute6 pn_term_templates.attribute6%TYPE;
5114: v_attribute7 pn_term_templates.attribute7%TYPE;
5115: v_attribute8 pn_term_templates.attribute8%TYPE;
5116: v_attribute9 pn_term_templates.attribute9%TYPE;
5117: v_attribute10 pn_term_templates.attribute10%TYPE;
5118: v_attribute11 pn_term_templates.attribute11%TYPE;

Line 5115: v_attribute8 pn_term_templates.attribute8%TYPE;

5111: v_attribute4 pn_term_templates.attribute4%TYPE;
5112: v_attribute5 pn_term_templates.attribute5%TYPE;
5113: v_attribute6 pn_term_templates.attribute6%TYPE;
5114: v_attribute7 pn_term_templates.attribute7%TYPE;
5115: v_attribute8 pn_term_templates.attribute8%TYPE;
5116: v_attribute9 pn_term_templates.attribute9%TYPE;
5117: v_attribute10 pn_term_templates.attribute10%TYPE;
5118: v_attribute11 pn_term_templates.attribute11%TYPE;
5119: v_attribute12 pn_term_templates.attribute12%TYPE;

Line 5116: v_attribute9 pn_term_templates.attribute9%TYPE;

5112: v_attribute5 pn_term_templates.attribute5%TYPE;
5113: v_attribute6 pn_term_templates.attribute6%TYPE;
5114: v_attribute7 pn_term_templates.attribute7%TYPE;
5115: v_attribute8 pn_term_templates.attribute8%TYPE;
5116: v_attribute9 pn_term_templates.attribute9%TYPE;
5117: v_attribute10 pn_term_templates.attribute10%TYPE;
5118: v_attribute11 pn_term_templates.attribute11%TYPE;
5119: v_attribute12 pn_term_templates.attribute12%TYPE;
5120: v_attribute13 pn_term_templates.attribute13%TYPE;

Line 5117: v_attribute10 pn_term_templates.attribute10%TYPE;

5113: v_attribute6 pn_term_templates.attribute6%TYPE;
5114: v_attribute7 pn_term_templates.attribute7%TYPE;
5115: v_attribute8 pn_term_templates.attribute8%TYPE;
5116: v_attribute9 pn_term_templates.attribute9%TYPE;
5117: v_attribute10 pn_term_templates.attribute10%TYPE;
5118: v_attribute11 pn_term_templates.attribute11%TYPE;
5119: v_attribute12 pn_term_templates.attribute12%TYPE;
5120: v_attribute13 pn_term_templates.attribute13%TYPE;
5121: v_attribute14 pn_term_templates.attribute14%TYPE;

Line 5118: v_attribute11 pn_term_templates.attribute11%TYPE;

5114: v_attribute7 pn_term_templates.attribute7%TYPE;
5115: v_attribute8 pn_term_templates.attribute8%TYPE;
5116: v_attribute9 pn_term_templates.attribute9%TYPE;
5117: v_attribute10 pn_term_templates.attribute10%TYPE;
5118: v_attribute11 pn_term_templates.attribute11%TYPE;
5119: v_attribute12 pn_term_templates.attribute12%TYPE;
5120: v_attribute13 pn_term_templates.attribute13%TYPE;
5121: v_attribute14 pn_term_templates.attribute14%TYPE;
5122: v_attribute15 pn_term_templates.attribute15%TYPE;

Line 5119: v_attribute12 pn_term_templates.attribute12%TYPE;

5115: v_attribute8 pn_term_templates.attribute8%TYPE;
5116: v_attribute9 pn_term_templates.attribute9%TYPE;
5117: v_attribute10 pn_term_templates.attribute10%TYPE;
5118: v_attribute11 pn_term_templates.attribute11%TYPE;
5119: v_attribute12 pn_term_templates.attribute12%TYPE;
5120: v_attribute13 pn_term_templates.attribute13%TYPE;
5121: v_attribute14 pn_term_templates.attribute14%TYPE;
5122: v_attribute15 pn_term_templates.attribute15%TYPE;
5123: v_lease_termination_date pn_lease_details.lease_termination_date%TYPE;

Line 5120: v_attribute13 pn_term_templates.attribute13%TYPE;

5116: v_attribute9 pn_term_templates.attribute9%TYPE;
5117: v_attribute10 pn_term_templates.attribute10%TYPE;
5118: v_attribute11 pn_term_templates.attribute11%TYPE;
5119: v_attribute12 pn_term_templates.attribute12%TYPE;
5120: v_attribute13 pn_term_templates.attribute13%TYPE;
5121: v_attribute14 pn_term_templates.attribute14%TYPE;
5122: v_attribute15 pn_term_templates.attribute15%TYPE;
5123: v_lease_termination_date pn_lease_details.lease_termination_date%TYPE;
5124: v_lease_change_id pn_lease_details.lease_change_id%TYPE;

Line 5121: v_attribute14 pn_term_templates.attribute14%TYPE;

5117: v_attribute10 pn_term_templates.attribute10%TYPE;
5118: v_attribute11 pn_term_templates.attribute11%TYPE;
5119: v_attribute12 pn_term_templates.attribute12%TYPE;
5120: v_attribute13 pn_term_templates.attribute13%TYPE;
5121: v_attribute14 pn_term_templates.attribute14%TYPE;
5122: v_attribute15 pn_term_templates.attribute15%TYPE;
5123: v_lease_termination_date pn_lease_details.lease_termination_date%TYPE;
5124: v_lease_change_id pn_lease_details.lease_change_id%TYPE;
5125: v_lease_class_code pn_leases.lease_class_code%TYPE;

Line 5122: v_attribute15 pn_term_templates.attribute15%TYPE;

5118: v_attribute11 pn_term_templates.attribute11%TYPE;
5119: v_attribute12 pn_term_templates.attribute12%TYPE;
5120: v_attribute13 pn_term_templates.attribute13%TYPE;
5121: v_attribute14 pn_term_templates.attribute14%TYPE;
5122: v_attribute15 pn_term_templates.attribute15%TYPE;
5123: v_lease_termination_date pn_lease_details.lease_termination_date%TYPE;
5124: v_lease_change_id pn_lease_details.lease_change_id%TYPE;
5125: v_lease_class_code pn_leases.lease_class_code%TYPE;
5126: v_distribution_id pn_distributions.distribution_id%TYPE;

Line 5395: FROM pn_term_templates_all

5391: ,v_attribute13
5392: ,v_attribute14
5393: ,v_attribute15
5394: ,v_org_id
5395: FROM pn_term_templates_all
5396: WHERE term_template_id = p_term_template_id;
5397:
5398: IF p_term_template_id is NOT NULL THEN
5399: FOR nbp_rec IN get_vr_nbp_flag