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.

APPS.PN_INDEX_AMOUNT_PKG dependencies on PN_TERM_TEMPLATES

Line 4278: v_normalize pn_term_templates.normalize%TYPE;

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

Line 4356: FROM pn_term_templates_all

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

Line 5074: v_name pn_term_templates.name%TYPE;

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

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

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

Line 5076: v_schedule_day pn_term_templates.schedule_day%TYPE;

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

Line 5077: v_payment_purpose_code pn_term_templates.payment_purpose_code%TYPE;

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

Line 5078: v_payment_term_type_code pn_term_templates.payment_term_type_code%TYPE;

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

Line 5079: v_accrual_account_id pn_term_templates.accrual_account_id%TYPE;

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

Line 5080: v_project_id pn_term_templates.project_id%TYPE;

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

Line 5081: v_task_id pn_term_templates.task_id%TYPE;

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

Line 5082: v_organization_id pn_term_templates.organization_id%TYPE;

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

Line 5083: v_expenditure_type pn_term_templates.expenditure_type%TYPE;

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

Line 5084: v_expenditure_item_date pn_term_templates.expenditure_item_date%TYPE;

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

Line 5085: v_vendor_id pn_term_templates.vendor_id%TYPE;

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

Line 5086: v_vendor_site_id pn_term_templates.vendor_site_id%TYPE;

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

Line 5087: v_customer_id pn_term_templates.customer_id%TYPE;

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

Line 5088: v_customer_site_use_id pn_term_templates.customer_site_use_id%TYPE;

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

Line 5089: v_cust_ship_site_id pn_term_templates.cust_ship_site_id%TYPE;

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

Line 5090: v_ap_ar_term_id pn_term_templates.ap_ar_term_id%TYPE;

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

Line 5091: v_cust_trx_type_id pn_term_templates.cust_trx_type_id%TYPE;

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

Line 5092: v_tax_group_id pn_term_templates.tax_group_id%TYPE;

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

Line 5093: v_tax_code_id pn_term_templates.tax_code_id%TYPE;

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

Line 5094: v_tax_classification_code pn_term_templates.tax_classification_code%TYPE;

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

Line 5095: v_tax_included pn_term_templates.tax_included%TYPE;

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

Line 5096: v_distribution_set_id pn_term_templates.distribution_set_id%TYPE;

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

Line 5097: v_inv_rule_id pn_term_templates.inv_rule_id%TYPE;

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

Line 5098: v_account_rule_id pn_term_templates.account_rule_id%TYPE;

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

Line 5099: v_salesrep_id pn_term_templates.salesrep_id%TYPE;

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

Line 5100: v_set_of_books_id pn_term_templates.set_of_books_id%TYPE;

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

Line 5102: v_po_header_id pn_term_templates.po_header_id%TYPE;

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

Line 5103: v_cust_po_number pn_term_templates.cust_po_number%TYPE;

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

Line 5104: v_receipt_method_id pn_term_templates.receipt_method_id%TYPE;

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

Line 5105: v_attribute_category pn_term_templates.attribute_category%TYPE;

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

Line 5106: v_attribute1 pn_term_templates.attribute1%TYPE;

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

Line 5107: v_attribute2 pn_term_templates.attribute2%TYPE;

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

Line 5108: v_attribute3 pn_term_templates.attribute3%TYPE;

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

Line 5109: v_attribute4 pn_term_templates.attribute4%TYPE;

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

Line 5110: v_attribute5 pn_term_templates.attribute5%TYPE;

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

Line 5111: v_attribute6 pn_term_templates.attribute6%TYPE;

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

Line 5112: v_attribute7 pn_term_templates.attribute7%TYPE;

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

Line 5113: v_attribute8 pn_term_templates.attribute8%TYPE;

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

Line 5114: v_attribute9 pn_term_templates.attribute9%TYPE;

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

Line 5115: v_attribute10 pn_term_templates.attribute10%TYPE;

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

Line 5116: v_attribute11 pn_term_templates.attribute11%TYPE;

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

Line 5117: v_attribute12 pn_term_templates.attribute12%TYPE;

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

Line 5118: v_attribute13 pn_term_templates.attribute13%TYPE;

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

Line 5119: v_attribute14 pn_term_templates.attribute14%TYPE;

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

Line 5120: v_attribute15 pn_term_templates.attribute15%TYPE;

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

Line 5393: FROM pn_term_templates_all

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