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_EXP_TO_AR dependencies on PN_PAYMENT_TERMS

Line 244: PN_PAYMENT_TERMS_ALL pt, PN_LEASES_ALL le,

240: , ''MM/DD/YYYY''))
241: ,''MM/DD/YYYY'') as rule_gl_date,
242: ps.schedule_date as schedule_date
243: FROM PN_PAYMENT_ITEMS pi, PN_PAYMENT_SCHEDULES_ALL ps,
244: PN_PAYMENT_TERMS_ALL pt, PN_LEASES_ALL le,
245: PN_LEASE_DETAILS_ALL pld, HZ_CUST_SITE_USES_ALL hzc,
246: HZ_CUST_SITE_USES_ALL hzc1, HZ_PARTIES party,
247: HZ_CUST_ACCOUNTS_ALL cust_acc, FND_LOOKUPS type_lookup,
248: FND_LOOKUPS purpose_lookup, HR_OPERATING_UNITS ou,

Line 297: PN_PAYMENT_TERMS_ALL pt, PN_LEASES_ALL le,

293: pt.payment_purpose_code as payment_purpose,
294: pt.payment_term_type_code as payment_type,
295: ps.schedule_date as schedule_date
296: FROM PN_PAYMENT_ITEMS pi, PN_PAYMENT_SCHEDULES_ALL ps,
297: PN_PAYMENT_TERMS_ALL pt, PN_LEASES_ALL le,
298: HZ_CUST_SITE_USES_ALL hzc, HZ_CUST_SITE_USES_ALL hzc1,
299: hz_parties party, hz_cust_accounts_ALL cust_acc,
300: fnd_lookups type_lookup, fnd_lookups purpose_lookup,
301: hr_operating_units ou

Line 593: l_tax_classification_code pn_payment_terms.tax_classification_code%TYPE;

589: t_count NUMBER := 0;
590: e_count NUMBER := 0;
591: s_count NUMBER := 0;
592: l_tax_code AR_VAT_TAX.tax_code%TYPE;
593: l_tax_classification_code pn_payment_terms.tax_classification_code%TYPE;
594: l_rev_acc_alloc_rule RA_BATCH_SOURCES.rev_acc_allocation_rule%TYPE;
595: l_rev_flag VARCHAR2(1);
596: l_rec_flag VARCHAR2(1);
597: l_ast_flag VARCHAR2(1);

Line 634: v_pn_cust_ship_site_id PN_PAYMENT_TERMS.cust_ship_site_id%TYPE;

630: v_pn_export_currency_code PN_PAYMENT_ITEMS.export_currency_code%TYPE;
631: v_pn_export_currency_amount PN_PAYMENT_ITEMS.export_currency_amount%TYPE;
632: v_pn_customer_id PN_PAYMENT_ITEMS.customer_id%TYPE;
633: v_pn_customer_site_use_id PN_PAYMENT_ITEMS.customer_site_use_id%TYPE;
634: v_pn_cust_ship_site_id PN_PAYMENT_TERMS.cust_ship_site_id%TYPE;
635: v_pn_tax_code_id PN_PAYMENT_TERMS.tax_code_id%TYPE;
636: v_pn_tax_classification_code PN_PAYMENT_TERMS.tax_classification_code%TYPE;
637: v_pn_legal_entity_id PN_PAYMENT_TERMS.legal_entity_id%TYPE;
638: v_pn_inv_rule_id PN_PAYMENT_TERMS.inv_rule_id%TYPE;

Line 635: v_pn_tax_code_id PN_PAYMENT_TERMS.tax_code_id%TYPE;

631: v_pn_export_currency_amount PN_PAYMENT_ITEMS.export_currency_amount%TYPE;
632: v_pn_customer_id PN_PAYMENT_ITEMS.customer_id%TYPE;
633: v_pn_customer_site_use_id PN_PAYMENT_ITEMS.customer_site_use_id%TYPE;
634: v_pn_cust_ship_site_id PN_PAYMENT_TERMS.cust_ship_site_id%TYPE;
635: v_pn_tax_code_id PN_PAYMENT_TERMS.tax_code_id%TYPE;
636: v_pn_tax_classification_code PN_PAYMENT_TERMS.tax_classification_code%TYPE;
637: v_pn_legal_entity_id PN_PAYMENT_TERMS.legal_entity_id%TYPE;
638: v_pn_inv_rule_id PN_PAYMENT_TERMS.inv_rule_id%TYPE;
639: v_pn_account_rule_id PN_PAYMENT_TERMS.account_rule_id%TYPE;

Line 636: v_pn_tax_classification_code PN_PAYMENT_TERMS.tax_classification_code%TYPE;

632: v_pn_customer_id PN_PAYMENT_ITEMS.customer_id%TYPE;
633: v_pn_customer_site_use_id PN_PAYMENT_ITEMS.customer_site_use_id%TYPE;
634: v_pn_cust_ship_site_id PN_PAYMENT_TERMS.cust_ship_site_id%TYPE;
635: v_pn_tax_code_id PN_PAYMENT_TERMS.tax_code_id%TYPE;
636: v_pn_tax_classification_code PN_PAYMENT_TERMS.tax_classification_code%TYPE;
637: v_pn_legal_entity_id PN_PAYMENT_TERMS.legal_entity_id%TYPE;
638: v_pn_inv_rule_id PN_PAYMENT_TERMS.inv_rule_id%TYPE;
639: v_pn_account_rule_id PN_PAYMENT_TERMS.account_rule_id%TYPE;
640: v_pn_term_id PN_PAYMENT_TERMS.ap_ar_term_id%TYPE;

Line 637: v_pn_legal_entity_id PN_PAYMENT_TERMS.legal_entity_id%TYPE;

633: v_pn_customer_site_use_id PN_PAYMENT_ITEMS.customer_site_use_id%TYPE;
634: v_pn_cust_ship_site_id PN_PAYMENT_TERMS.cust_ship_site_id%TYPE;
635: v_pn_tax_code_id PN_PAYMENT_TERMS.tax_code_id%TYPE;
636: v_pn_tax_classification_code PN_PAYMENT_TERMS.tax_classification_code%TYPE;
637: v_pn_legal_entity_id PN_PAYMENT_TERMS.legal_entity_id%TYPE;
638: v_pn_inv_rule_id PN_PAYMENT_TERMS.inv_rule_id%TYPE;
639: v_pn_account_rule_id PN_PAYMENT_TERMS.account_rule_id%TYPE;
640: v_pn_term_id PN_PAYMENT_TERMS.ap_ar_term_id%TYPE;
641: v_pn_trx_type_id PN_PAYMENT_TERMS.cust_trx_type_id%TYPE;

Line 638: v_pn_inv_rule_id PN_PAYMENT_TERMS.inv_rule_id%TYPE;

634: v_pn_cust_ship_site_id PN_PAYMENT_TERMS.cust_ship_site_id%TYPE;
635: v_pn_tax_code_id PN_PAYMENT_TERMS.tax_code_id%TYPE;
636: v_pn_tax_classification_code PN_PAYMENT_TERMS.tax_classification_code%TYPE;
637: v_pn_legal_entity_id PN_PAYMENT_TERMS.legal_entity_id%TYPE;
638: v_pn_inv_rule_id PN_PAYMENT_TERMS.inv_rule_id%TYPE;
639: v_pn_account_rule_id PN_PAYMENT_TERMS.account_rule_id%TYPE;
640: v_pn_term_id PN_PAYMENT_TERMS.ap_ar_term_id%TYPE;
641: v_pn_trx_type_id PN_PAYMENT_TERMS.cust_trx_type_id%TYPE;
642: v_pn_pay_method_id PN_PAYMENT_TERMS.receipt_method_id%TYPE;

Line 639: v_pn_account_rule_id PN_PAYMENT_TERMS.account_rule_id%TYPE;

635: v_pn_tax_code_id PN_PAYMENT_TERMS.tax_code_id%TYPE;
636: v_pn_tax_classification_code PN_PAYMENT_TERMS.tax_classification_code%TYPE;
637: v_pn_legal_entity_id PN_PAYMENT_TERMS.legal_entity_id%TYPE;
638: v_pn_inv_rule_id PN_PAYMENT_TERMS.inv_rule_id%TYPE;
639: v_pn_account_rule_id PN_PAYMENT_TERMS.account_rule_id%TYPE;
640: v_pn_term_id PN_PAYMENT_TERMS.ap_ar_term_id%TYPE;
641: v_pn_trx_type_id PN_PAYMENT_TERMS.cust_trx_type_id%TYPE;
642: v_pn_pay_method_id PN_PAYMENT_TERMS.receipt_method_id%TYPE;
643: v_pn_po_number PN_PAYMENT_TERMS.cust_po_number%TYPE;

Line 640: v_pn_term_id PN_PAYMENT_TERMS.ap_ar_term_id%TYPE;

636: v_pn_tax_classification_code PN_PAYMENT_TERMS.tax_classification_code%TYPE;
637: v_pn_legal_entity_id PN_PAYMENT_TERMS.legal_entity_id%TYPE;
638: v_pn_inv_rule_id PN_PAYMENT_TERMS.inv_rule_id%TYPE;
639: v_pn_account_rule_id PN_PAYMENT_TERMS.account_rule_id%TYPE;
640: v_pn_term_id PN_PAYMENT_TERMS.ap_ar_term_id%TYPE;
641: v_pn_trx_type_id PN_PAYMENT_TERMS.cust_trx_type_id%TYPE;
642: v_pn_pay_method_id PN_PAYMENT_TERMS.receipt_method_id%TYPE;
643: v_pn_po_number PN_PAYMENT_TERMS.cust_po_number%TYPE;
644: v_pn_tax_included PN_PAYMENT_TERMS.tax_included%TYPE;

Line 641: v_pn_trx_type_id PN_PAYMENT_TERMS.cust_trx_type_id%TYPE;

637: v_pn_legal_entity_id PN_PAYMENT_TERMS.legal_entity_id%TYPE;
638: v_pn_inv_rule_id PN_PAYMENT_TERMS.inv_rule_id%TYPE;
639: v_pn_account_rule_id PN_PAYMENT_TERMS.account_rule_id%TYPE;
640: v_pn_term_id PN_PAYMENT_TERMS.ap_ar_term_id%TYPE;
641: v_pn_trx_type_id PN_PAYMENT_TERMS.cust_trx_type_id%TYPE;
642: v_pn_pay_method_id PN_PAYMENT_TERMS.receipt_method_id%TYPE;
643: v_pn_po_number PN_PAYMENT_TERMS.cust_po_number%TYPE;
644: v_pn_tax_included PN_PAYMENT_TERMS.tax_included%TYPE;
645: v_pn_salesrep_id PN_PAYMENT_TERMS.salesrep_id%TYPE;

Line 642: v_pn_pay_method_id PN_PAYMENT_TERMS.receipt_method_id%TYPE;

638: v_pn_inv_rule_id PN_PAYMENT_TERMS.inv_rule_id%TYPE;
639: v_pn_account_rule_id PN_PAYMENT_TERMS.account_rule_id%TYPE;
640: v_pn_term_id PN_PAYMENT_TERMS.ap_ar_term_id%TYPE;
641: v_pn_trx_type_id PN_PAYMENT_TERMS.cust_trx_type_id%TYPE;
642: v_pn_pay_method_id PN_PAYMENT_TERMS.receipt_method_id%TYPE;
643: v_pn_po_number PN_PAYMENT_TERMS.cust_po_number%TYPE;
644: v_pn_tax_included PN_PAYMENT_TERMS.tax_included%TYPE;
645: v_pn_salesrep_id PN_PAYMENT_TERMS.salesrep_id%TYPE;
646: v_pn_proj_attr_catg PN_PAYMENT_TERMS.project_attribute_category%TYPE;

Line 643: v_pn_po_number PN_PAYMENT_TERMS.cust_po_number%TYPE;

639: v_pn_account_rule_id PN_PAYMENT_TERMS.account_rule_id%TYPE;
640: v_pn_term_id PN_PAYMENT_TERMS.ap_ar_term_id%TYPE;
641: v_pn_trx_type_id PN_PAYMENT_TERMS.cust_trx_type_id%TYPE;
642: v_pn_pay_method_id PN_PAYMENT_TERMS.receipt_method_id%TYPE;
643: v_pn_po_number PN_PAYMENT_TERMS.cust_po_number%TYPE;
644: v_pn_tax_included PN_PAYMENT_TERMS.tax_included%TYPE;
645: v_pn_salesrep_id PN_PAYMENT_TERMS.salesrep_id%TYPE;
646: v_pn_proj_attr_catg PN_PAYMENT_TERMS.project_attribute_category%TYPE;
647: v_pn_proj_attr3 PN_PAYMENT_TERMS.project_attribute3%TYPE;

Line 644: v_pn_tax_included PN_PAYMENT_TERMS.tax_included%TYPE;

640: v_pn_term_id PN_PAYMENT_TERMS.ap_ar_term_id%TYPE;
641: v_pn_trx_type_id PN_PAYMENT_TERMS.cust_trx_type_id%TYPE;
642: v_pn_pay_method_id PN_PAYMENT_TERMS.receipt_method_id%TYPE;
643: v_pn_po_number PN_PAYMENT_TERMS.cust_po_number%TYPE;
644: v_pn_tax_included PN_PAYMENT_TERMS.tax_included%TYPE;
645: v_pn_salesrep_id PN_PAYMENT_TERMS.salesrep_id%TYPE;
646: v_pn_proj_attr_catg PN_PAYMENT_TERMS.project_attribute_category%TYPE;
647: v_pn_proj_attr3 PN_PAYMENT_TERMS.project_attribute3%TYPE;
648: v_pn_proj_attr4 PN_PAYMENT_TERMS.project_attribute4%TYPE;

Line 645: v_pn_salesrep_id PN_PAYMENT_TERMS.salesrep_id%TYPE;

641: v_pn_trx_type_id PN_PAYMENT_TERMS.cust_trx_type_id%TYPE;
642: v_pn_pay_method_id PN_PAYMENT_TERMS.receipt_method_id%TYPE;
643: v_pn_po_number PN_PAYMENT_TERMS.cust_po_number%TYPE;
644: v_pn_tax_included PN_PAYMENT_TERMS.tax_included%TYPE;
645: v_pn_salesrep_id PN_PAYMENT_TERMS.salesrep_id%TYPE;
646: v_pn_proj_attr_catg PN_PAYMENT_TERMS.project_attribute_category%TYPE;
647: v_pn_proj_attr3 PN_PAYMENT_TERMS.project_attribute3%TYPE;
648: v_pn_proj_attr4 PN_PAYMENT_TERMS.project_attribute4%TYPE;
649: v_pn_proj_attr5 PN_PAYMENT_TERMS.project_attribute5%TYPE;

Line 646: v_pn_proj_attr_catg PN_PAYMENT_TERMS.project_attribute_category%TYPE;

642: v_pn_pay_method_id PN_PAYMENT_TERMS.receipt_method_id%TYPE;
643: v_pn_po_number PN_PAYMENT_TERMS.cust_po_number%TYPE;
644: v_pn_tax_included PN_PAYMENT_TERMS.tax_included%TYPE;
645: v_pn_salesrep_id PN_PAYMENT_TERMS.salesrep_id%TYPE;
646: v_pn_proj_attr_catg PN_PAYMENT_TERMS.project_attribute_category%TYPE;
647: v_pn_proj_attr3 PN_PAYMENT_TERMS.project_attribute3%TYPE;
648: v_pn_proj_attr4 PN_PAYMENT_TERMS.project_attribute4%TYPE;
649: v_pn_proj_attr5 PN_PAYMENT_TERMS.project_attribute5%TYPE;
650: v_pn_proj_attr6 PN_PAYMENT_TERMS.project_attribute6%TYPE;

Line 647: v_pn_proj_attr3 PN_PAYMENT_TERMS.project_attribute3%TYPE;

643: v_pn_po_number PN_PAYMENT_TERMS.cust_po_number%TYPE;
644: v_pn_tax_included PN_PAYMENT_TERMS.tax_included%TYPE;
645: v_pn_salesrep_id PN_PAYMENT_TERMS.salesrep_id%TYPE;
646: v_pn_proj_attr_catg PN_PAYMENT_TERMS.project_attribute_category%TYPE;
647: v_pn_proj_attr3 PN_PAYMENT_TERMS.project_attribute3%TYPE;
648: v_pn_proj_attr4 PN_PAYMENT_TERMS.project_attribute4%TYPE;
649: v_pn_proj_attr5 PN_PAYMENT_TERMS.project_attribute5%TYPE;
650: v_pn_proj_attr6 PN_PAYMENT_TERMS.project_attribute6%TYPE;
651: v_pn_proj_attr7 PN_PAYMENT_TERMS.project_attribute7%TYPE;

Line 648: v_pn_proj_attr4 PN_PAYMENT_TERMS.project_attribute4%TYPE;

644: v_pn_tax_included PN_PAYMENT_TERMS.tax_included%TYPE;
645: v_pn_salesrep_id PN_PAYMENT_TERMS.salesrep_id%TYPE;
646: v_pn_proj_attr_catg PN_PAYMENT_TERMS.project_attribute_category%TYPE;
647: v_pn_proj_attr3 PN_PAYMENT_TERMS.project_attribute3%TYPE;
648: v_pn_proj_attr4 PN_PAYMENT_TERMS.project_attribute4%TYPE;
649: v_pn_proj_attr5 PN_PAYMENT_TERMS.project_attribute5%TYPE;
650: v_pn_proj_attr6 PN_PAYMENT_TERMS.project_attribute6%TYPE;
651: v_pn_proj_attr7 PN_PAYMENT_TERMS.project_attribute7%TYPE;
652: v_pn_org_id PN_PAYMENT_TERMS.org_id%TYPE;

Line 649: v_pn_proj_attr5 PN_PAYMENT_TERMS.project_attribute5%TYPE;

645: v_pn_salesrep_id PN_PAYMENT_TERMS.salesrep_id%TYPE;
646: v_pn_proj_attr_catg PN_PAYMENT_TERMS.project_attribute_category%TYPE;
647: v_pn_proj_attr3 PN_PAYMENT_TERMS.project_attribute3%TYPE;
648: v_pn_proj_attr4 PN_PAYMENT_TERMS.project_attribute4%TYPE;
649: v_pn_proj_attr5 PN_PAYMENT_TERMS.project_attribute5%TYPE;
650: v_pn_proj_attr6 PN_PAYMENT_TERMS.project_attribute6%TYPE;
651: v_pn_proj_attr7 PN_PAYMENT_TERMS.project_attribute7%TYPE;
652: v_pn_org_id PN_PAYMENT_TERMS.org_id%TYPE;
653: v_pn_lease_num PN_LEASES.lease_num%TYPE;

Line 650: v_pn_proj_attr6 PN_PAYMENT_TERMS.project_attribute6%TYPE;

646: v_pn_proj_attr_catg PN_PAYMENT_TERMS.project_attribute_category%TYPE;
647: v_pn_proj_attr3 PN_PAYMENT_TERMS.project_attribute3%TYPE;
648: v_pn_proj_attr4 PN_PAYMENT_TERMS.project_attribute4%TYPE;
649: v_pn_proj_attr5 PN_PAYMENT_TERMS.project_attribute5%TYPE;
650: v_pn_proj_attr6 PN_PAYMENT_TERMS.project_attribute6%TYPE;
651: v_pn_proj_attr7 PN_PAYMENT_TERMS.project_attribute7%TYPE;
652: v_pn_org_id PN_PAYMENT_TERMS.org_id%TYPE;
653: v_pn_lease_num PN_LEASES.lease_num%TYPE;
654: v_pn_payment_schedule_id PN_PAYMENT_ITEMS.payment_schedule_id%TYPE;

Line 651: v_pn_proj_attr7 PN_PAYMENT_TERMS.project_attribute7%TYPE;

647: v_pn_proj_attr3 PN_PAYMENT_TERMS.project_attribute3%TYPE;
648: v_pn_proj_attr4 PN_PAYMENT_TERMS.project_attribute4%TYPE;
649: v_pn_proj_attr5 PN_PAYMENT_TERMS.project_attribute5%TYPE;
650: v_pn_proj_attr6 PN_PAYMENT_TERMS.project_attribute6%TYPE;
651: v_pn_proj_attr7 PN_PAYMENT_TERMS.project_attribute7%TYPE;
652: v_pn_org_id PN_PAYMENT_TERMS.org_id%TYPE;
653: v_pn_lease_num PN_LEASES.lease_num%TYPE;
654: v_pn_payment_schedule_id PN_PAYMENT_ITEMS.payment_schedule_id%TYPE;
655: v_pn_period_name PN_PAYMENT_SCHEDULES.period_name%TYPE;

Line 652: v_pn_org_id PN_PAYMENT_TERMS.org_id%TYPE;

648: v_pn_proj_attr4 PN_PAYMENT_TERMS.project_attribute4%TYPE;
649: v_pn_proj_attr5 PN_PAYMENT_TERMS.project_attribute5%TYPE;
650: v_pn_proj_attr6 PN_PAYMENT_TERMS.project_attribute6%TYPE;
651: v_pn_proj_attr7 PN_PAYMENT_TERMS.project_attribute7%TYPE;
652: v_pn_org_id PN_PAYMENT_TERMS.org_id%TYPE;
653: v_pn_lease_num PN_LEASES.lease_num%TYPE;
654: v_pn_payment_schedule_id PN_PAYMENT_ITEMS.payment_schedule_id%TYPE;
655: v_pn_period_name PN_PAYMENT_SCHEDULES.period_name%TYPE;
656: v_pn_description PN_PAYMENT_TERMS.payment_purpose_code%TYPE;

Line 656: v_pn_description PN_PAYMENT_TERMS.payment_purpose_code%TYPE;

652: v_pn_org_id PN_PAYMENT_TERMS.org_id%TYPE;
653: v_pn_lease_num PN_LEASES.lease_num%TYPE;
654: v_pn_payment_schedule_id PN_PAYMENT_ITEMS.payment_schedule_id%TYPE;
655: v_pn_period_name PN_PAYMENT_SCHEDULES.period_name%TYPE;
656: v_pn_description PN_PAYMENT_TERMS.payment_purpose_code%TYPE;
657: v_pn_lease_id PN_LEASES.lease_id%TYPE;
658: v_transaction_date PN_PAYMENT_ITEMS.due_date%TYPE;
659: v_normalize PN_PAYMENT_TERMS.normalize%TYPE;
660: v_pn_accounted_date PN_PAYMENT_ITEMS.accounted_date%TYPE;

Line 659: v_normalize PN_PAYMENT_TERMS.normalize%TYPE;

655: v_pn_period_name PN_PAYMENT_SCHEDULES.period_name%TYPE;
656: v_pn_description PN_PAYMENT_TERMS.payment_purpose_code%TYPE;
657: v_pn_lease_id PN_LEASES.lease_id%TYPE;
658: v_transaction_date PN_PAYMENT_ITEMS.due_date%TYPE;
659: v_normalize PN_PAYMENT_TERMS.normalize%TYPE;
660: v_pn_accounted_date PN_PAYMENT_ITEMS.accounted_date%TYPE;
661: v_pn_rate PN_PAYMENT_ITEMS.rate%TYPE;
662: v_location_id PN_LOCATIONS.LOCATION_ID%TYPE;
663: v_send_entries PN_LEASE_DETAILS.send_entries%TYPE;

Line 668: v_payment_purpose PN_PAYMENT_TERMS.payment_purpose_code%TYPE;

664: v_rec_account PN_DISTRIBUTIONS.account_id%TYPE;
665: v_gl_date RA_CUST_TRX_LINE_GL_DIST.gl_date%TYPE;
666: v_conv_rate_type PN_CURRENCIES.conversion_type%TYPE;
667: v_conv_rate PN_PAYMENT_ITEMS.rate%TYPE;
668: v_payment_purpose PN_PAYMENT_TERMS.payment_purpose_code%TYPE;
669: v_payment_type PN_PAYMENT_TERMS.payment_term_type_code%TYPE;
670: v_rule_gl_date RA_CUST_TRX_LINE_GL_DIST.gl_date%TYPE;
671: v_schedule_date PN_PAYMENT_SCHEDULES.schedule_date%TYPE;
672: v_pn_payment_term_id1 PN_PAYMENT_ITEMS.payment_term_id%TYPE;

Line 669: v_payment_type PN_PAYMENT_TERMS.payment_term_type_code%TYPE;

665: v_gl_date RA_CUST_TRX_LINE_GL_DIST.gl_date%TYPE;
666: v_conv_rate_type PN_CURRENCIES.conversion_type%TYPE;
667: v_conv_rate PN_PAYMENT_ITEMS.rate%TYPE;
668: v_payment_purpose PN_PAYMENT_TERMS.payment_purpose_code%TYPE;
669: v_payment_type PN_PAYMENT_TERMS.payment_term_type_code%TYPE;
670: v_rule_gl_date RA_CUST_TRX_LINE_GL_DIST.gl_date%TYPE;
671: v_schedule_date PN_PAYMENT_SCHEDULES.schedule_date%TYPE;
672: v_pn_payment_term_id1 PN_PAYMENT_ITEMS.payment_term_id%TYPE;
673: v_pn_le_id1 PN_PAYMENT_TERMS.legal_entity_id%TYPE;

Line 673: v_pn_le_id1 PN_PAYMENT_TERMS.legal_entity_id%TYPE;

669: v_payment_type PN_PAYMENT_TERMS.payment_term_type_code%TYPE;
670: v_rule_gl_date RA_CUST_TRX_LINE_GL_DIST.gl_date%TYPE;
671: v_schedule_date PN_PAYMENT_SCHEDULES.schedule_date%TYPE;
672: v_pn_payment_term_id1 PN_PAYMENT_ITEMS.payment_term_id%TYPE;
673: v_pn_le_id1 PN_PAYMENT_TERMS.legal_entity_id%TYPE;
674: v_pn_customer_id1 PN_PAYMENT_ITEMS.customer_id%TYPE;
675: v_pn_trx_type_id1 PN_PAYMENT_TERMS.cust_trx_type_id%TYPE;
676: v_pn_org_id1 PN_PAYMENT_TERMS.org_id%TYPE;
677: l_rows_select_grp NUMBER;

Line 675: v_pn_trx_type_id1 PN_PAYMENT_TERMS.cust_trx_type_id%TYPE;

671: v_schedule_date PN_PAYMENT_SCHEDULES.schedule_date%TYPE;
672: v_pn_payment_term_id1 PN_PAYMENT_ITEMS.payment_term_id%TYPE;
673: v_pn_le_id1 PN_PAYMENT_TERMS.legal_entity_id%TYPE;
674: v_pn_customer_id1 PN_PAYMENT_ITEMS.customer_id%TYPE;
675: v_pn_trx_type_id1 PN_PAYMENT_TERMS.cust_trx_type_id%TYPE;
676: v_pn_org_id1 PN_PAYMENT_TERMS.org_id%TYPE;
677: l_rows_select_grp NUMBER;
678: l_count_select_grp NUMBER;
679: TYPE le_ar_tbl_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;

Line 676: v_pn_org_id1 PN_PAYMENT_TERMS.org_id%TYPE;

672: v_pn_payment_term_id1 PN_PAYMENT_ITEMS.payment_term_id%TYPE;
673: v_pn_le_id1 PN_PAYMENT_TERMS.legal_entity_id%TYPE;
674: v_pn_customer_id1 PN_PAYMENT_ITEMS.customer_id%TYPE;
675: v_pn_trx_type_id1 PN_PAYMENT_TERMS.cust_trx_type_id%TYPE;
676: v_pn_org_id1 PN_PAYMENT_TERMS.org_id%TYPE;
677: l_rows_select_grp NUMBER;
678: l_count_select_grp NUMBER;
679: TYPE le_ar_tbl_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
680: TYPE term_ar_tbl_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;

Line 750: UPDATE pn_payment_terms_all

746: END;
747: END LOOP;
748:
749: FORALL i IN term_ar_tbl.FIRST..term_ar_tbl.LAST
750: UPDATE pn_payment_terms_all
751: SET legal_entity_id = le_ar_tbl(i)
752: WHERE payment_term_id = term_ar_tbl(i);
753:
754: IF dbms_sql.is_open (g_cursor_select_grp) THEN

Line 1828: v_pn_code_combination_id PN_PAYMENT_TERMS.code_combination_id%TYPE;

1824: IS
1825: v_pn_lease_num PN_LEASES.lease_num%TYPE;
1826: v_pn_lease_id PN_LEASES.lease_id%TYPE;
1827: v_pn_period_name PN_PAYMENT_SCHEDULES.period_name%TYPE;
1828: v_pn_code_combination_id PN_PAYMENT_TERMS.code_combination_id%TYPE;
1829: v_pn_cust_ship_site_id PN_PAYMENT_TERMS.cust_ship_site_id%TYPE;
1830: v_pn_tax_code_id PN_PAYMENT_TERMS.tax_code_id%TYPE;
1831: v_pn_tcc PN_PAYMENT_TERMS.tax_classification_code%TYPE;
1832: v_pn_le PN_PAYMENT_TERMS.legal_entity_id%TYPE;

Line 1829: v_pn_cust_ship_site_id PN_PAYMENT_TERMS.cust_ship_site_id%TYPE;

1825: v_pn_lease_num PN_LEASES.lease_num%TYPE;
1826: v_pn_lease_id PN_LEASES.lease_id%TYPE;
1827: v_pn_period_name PN_PAYMENT_SCHEDULES.period_name%TYPE;
1828: v_pn_code_combination_id PN_PAYMENT_TERMS.code_combination_id%TYPE;
1829: v_pn_cust_ship_site_id PN_PAYMENT_TERMS.cust_ship_site_id%TYPE;
1830: v_pn_tax_code_id PN_PAYMENT_TERMS.tax_code_id%TYPE;
1831: v_pn_tcc PN_PAYMENT_TERMS.tax_classification_code%TYPE;
1832: v_pn_le PN_PAYMENT_TERMS.legal_entity_id%TYPE;
1833: v_pn_inv_rule_id PN_PAYMENT_TERMS.inv_rule_id%TYPE;

Line 1830: v_pn_tax_code_id PN_PAYMENT_TERMS.tax_code_id%TYPE;

1826: v_pn_lease_id PN_LEASES.lease_id%TYPE;
1827: v_pn_period_name PN_PAYMENT_SCHEDULES.period_name%TYPE;
1828: v_pn_code_combination_id PN_PAYMENT_TERMS.code_combination_id%TYPE;
1829: v_pn_cust_ship_site_id PN_PAYMENT_TERMS.cust_ship_site_id%TYPE;
1830: v_pn_tax_code_id PN_PAYMENT_TERMS.tax_code_id%TYPE;
1831: v_pn_tcc PN_PAYMENT_TERMS.tax_classification_code%TYPE;
1832: v_pn_le PN_PAYMENT_TERMS.legal_entity_id%TYPE;
1833: v_pn_inv_rule_id PN_PAYMENT_TERMS.inv_rule_id%TYPE;
1834: v_pn_account_rule_id PN_PAYMENT_TERMS.account_rule_id%TYPE;

Line 1831: v_pn_tcc PN_PAYMENT_TERMS.tax_classification_code%TYPE;

1827: v_pn_period_name PN_PAYMENT_SCHEDULES.period_name%TYPE;
1828: v_pn_code_combination_id PN_PAYMENT_TERMS.code_combination_id%TYPE;
1829: v_pn_cust_ship_site_id PN_PAYMENT_TERMS.cust_ship_site_id%TYPE;
1830: v_pn_tax_code_id PN_PAYMENT_TERMS.tax_code_id%TYPE;
1831: v_pn_tcc PN_PAYMENT_TERMS.tax_classification_code%TYPE;
1832: v_pn_le PN_PAYMENT_TERMS.legal_entity_id%TYPE;
1833: v_pn_inv_rule_id PN_PAYMENT_TERMS.inv_rule_id%TYPE;
1834: v_pn_account_rule_id PN_PAYMENT_TERMS.account_rule_id%TYPE;
1835: v_pn_term_id PN_PAYMENT_TERMS.ap_ar_term_id%TYPE;

Line 1832: v_pn_le PN_PAYMENT_TERMS.legal_entity_id%TYPE;

1828: v_pn_code_combination_id PN_PAYMENT_TERMS.code_combination_id%TYPE;
1829: v_pn_cust_ship_site_id PN_PAYMENT_TERMS.cust_ship_site_id%TYPE;
1830: v_pn_tax_code_id PN_PAYMENT_TERMS.tax_code_id%TYPE;
1831: v_pn_tcc PN_PAYMENT_TERMS.tax_classification_code%TYPE;
1832: v_pn_le PN_PAYMENT_TERMS.legal_entity_id%TYPE;
1833: v_pn_inv_rule_id PN_PAYMENT_TERMS.inv_rule_id%TYPE;
1834: v_pn_account_rule_id PN_PAYMENT_TERMS.account_rule_id%TYPE;
1835: v_pn_term_id PN_PAYMENT_TERMS.ap_ar_term_id%TYPE;
1836: v_pn_trx_type_id PN_PAYMENT_TERMS.cust_trx_type_id%TYPE;

Line 1833: v_pn_inv_rule_id PN_PAYMENT_TERMS.inv_rule_id%TYPE;

1829: v_pn_cust_ship_site_id PN_PAYMENT_TERMS.cust_ship_site_id%TYPE;
1830: v_pn_tax_code_id PN_PAYMENT_TERMS.tax_code_id%TYPE;
1831: v_pn_tcc PN_PAYMENT_TERMS.tax_classification_code%TYPE;
1832: v_pn_le PN_PAYMENT_TERMS.legal_entity_id%TYPE;
1833: v_pn_inv_rule_id PN_PAYMENT_TERMS.inv_rule_id%TYPE;
1834: v_pn_account_rule_id PN_PAYMENT_TERMS.account_rule_id%TYPE;
1835: v_pn_term_id PN_PAYMENT_TERMS.ap_ar_term_id%TYPE;
1836: v_pn_trx_type_id PN_PAYMENT_TERMS.cust_trx_type_id%TYPE;
1837: v_pn_pay_method_id PN_PAYMENT_TERMS.receipt_method_id%TYPE;

Line 1834: v_pn_account_rule_id PN_PAYMENT_TERMS.account_rule_id%TYPE;

1830: v_pn_tax_code_id PN_PAYMENT_TERMS.tax_code_id%TYPE;
1831: v_pn_tcc PN_PAYMENT_TERMS.tax_classification_code%TYPE;
1832: v_pn_le PN_PAYMENT_TERMS.legal_entity_id%TYPE;
1833: v_pn_inv_rule_id PN_PAYMENT_TERMS.inv_rule_id%TYPE;
1834: v_pn_account_rule_id PN_PAYMENT_TERMS.account_rule_id%TYPE;
1835: v_pn_term_id PN_PAYMENT_TERMS.ap_ar_term_id%TYPE;
1836: v_pn_trx_type_id PN_PAYMENT_TERMS.cust_trx_type_id%TYPE;
1837: v_pn_pay_method_id PN_PAYMENT_TERMS.receipt_method_id%TYPE;
1838: v_pn_po_number PN_PAYMENT_TERMS.cust_po_number%TYPE;

Line 1835: v_pn_term_id PN_PAYMENT_TERMS.ap_ar_term_id%TYPE;

1831: v_pn_tcc PN_PAYMENT_TERMS.tax_classification_code%TYPE;
1832: v_pn_le PN_PAYMENT_TERMS.legal_entity_id%TYPE;
1833: v_pn_inv_rule_id PN_PAYMENT_TERMS.inv_rule_id%TYPE;
1834: v_pn_account_rule_id PN_PAYMENT_TERMS.account_rule_id%TYPE;
1835: v_pn_term_id PN_PAYMENT_TERMS.ap_ar_term_id%TYPE;
1836: v_pn_trx_type_id PN_PAYMENT_TERMS.cust_trx_type_id%TYPE;
1837: v_pn_pay_method_id PN_PAYMENT_TERMS.receipt_method_id%TYPE;
1838: v_pn_po_number PN_PAYMENT_TERMS.cust_po_number%TYPE;
1839: v_pn_tax_included PN_PAYMENT_TERMS.tax_included%TYPE;

Line 1836: v_pn_trx_type_id PN_PAYMENT_TERMS.cust_trx_type_id%TYPE;

1832: v_pn_le PN_PAYMENT_TERMS.legal_entity_id%TYPE;
1833: v_pn_inv_rule_id PN_PAYMENT_TERMS.inv_rule_id%TYPE;
1834: v_pn_account_rule_id PN_PAYMENT_TERMS.account_rule_id%TYPE;
1835: v_pn_term_id PN_PAYMENT_TERMS.ap_ar_term_id%TYPE;
1836: v_pn_trx_type_id PN_PAYMENT_TERMS.cust_trx_type_id%TYPE;
1837: v_pn_pay_method_id PN_PAYMENT_TERMS.receipt_method_id%TYPE;
1838: v_pn_po_number PN_PAYMENT_TERMS.cust_po_number%TYPE;
1839: v_pn_tax_included PN_PAYMENT_TERMS.tax_included%TYPE;
1840: v_pn_salesrep_id PN_PAYMENT_TERMS.salesrep_id%TYPE;

Line 1837: v_pn_pay_method_id PN_PAYMENT_TERMS.receipt_method_id%TYPE;

1833: v_pn_inv_rule_id PN_PAYMENT_TERMS.inv_rule_id%TYPE;
1834: v_pn_account_rule_id PN_PAYMENT_TERMS.account_rule_id%TYPE;
1835: v_pn_term_id PN_PAYMENT_TERMS.ap_ar_term_id%TYPE;
1836: v_pn_trx_type_id PN_PAYMENT_TERMS.cust_trx_type_id%TYPE;
1837: v_pn_pay_method_id PN_PAYMENT_TERMS.receipt_method_id%TYPE;
1838: v_pn_po_number PN_PAYMENT_TERMS.cust_po_number%TYPE;
1839: v_pn_tax_included PN_PAYMENT_TERMS.tax_included%TYPE;
1840: v_pn_salesrep_id PN_PAYMENT_TERMS.salesrep_id%TYPE;
1841: v_pn_proj_attr_catg PN_PAYMENT_TERMS.project_attribute_category%TYPE;

Line 1838: v_pn_po_number PN_PAYMENT_TERMS.cust_po_number%TYPE;

1834: v_pn_account_rule_id PN_PAYMENT_TERMS.account_rule_id%TYPE;
1835: v_pn_term_id PN_PAYMENT_TERMS.ap_ar_term_id%TYPE;
1836: v_pn_trx_type_id PN_PAYMENT_TERMS.cust_trx_type_id%TYPE;
1837: v_pn_pay_method_id PN_PAYMENT_TERMS.receipt_method_id%TYPE;
1838: v_pn_po_number PN_PAYMENT_TERMS.cust_po_number%TYPE;
1839: v_pn_tax_included PN_PAYMENT_TERMS.tax_included%TYPE;
1840: v_pn_salesrep_id PN_PAYMENT_TERMS.salesrep_id%TYPE;
1841: v_pn_proj_attr_catg PN_PAYMENT_TERMS.project_attribute_category%TYPE;
1842: v_pn_proj_attr1 PN_PAYMENT_TERMS.project_attribute1%TYPE;

Line 1839: v_pn_tax_included PN_PAYMENT_TERMS.tax_included%TYPE;

1835: v_pn_term_id PN_PAYMENT_TERMS.ap_ar_term_id%TYPE;
1836: v_pn_trx_type_id PN_PAYMENT_TERMS.cust_trx_type_id%TYPE;
1837: v_pn_pay_method_id PN_PAYMENT_TERMS.receipt_method_id%TYPE;
1838: v_pn_po_number PN_PAYMENT_TERMS.cust_po_number%TYPE;
1839: v_pn_tax_included PN_PAYMENT_TERMS.tax_included%TYPE;
1840: v_pn_salesrep_id PN_PAYMENT_TERMS.salesrep_id%TYPE;
1841: v_pn_proj_attr_catg PN_PAYMENT_TERMS.project_attribute_category%TYPE;
1842: v_pn_proj_attr1 PN_PAYMENT_TERMS.project_attribute1%TYPE;
1843: v_pn_proj_attr2 PN_PAYMENT_TERMS.project_attribute2%TYPE;

Line 1840: v_pn_salesrep_id PN_PAYMENT_TERMS.salesrep_id%TYPE;

1836: v_pn_trx_type_id PN_PAYMENT_TERMS.cust_trx_type_id%TYPE;
1837: v_pn_pay_method_id PN_PAYMENT_TERMS.receipt_method_id%TYPE;
1838: v_pn_po_number PN_PAYMENT_TERMS.cust_po_number%TYPE;
1839: v_pn_tax_included PN_PAYMENT_TERMS.tax_included%TYPE;
1840: v_pn_salesrep_id PN_PAYMENT_TERMS.salesrep_id%TYPE;
1841: v_pn_proj_attr_catg PN_PAYMENT_TERMS.project_attribute_category%TYPE;
1842: v_pn_proj_attr1 PN_PAYMENT_TERMS.project_attribute1%TYPE;
1843: v_pn_proj_attr2 PN_PAYMENT_TERMS.project_attribute2%TYPE;
1844: v_pn_proj_attr3 PN_PAYMENT_TERMS.project_attribute3%TYPE;

Line 1841: v_pn_proj_attr_catg PN_PAYMENT_TERMS.project_attribute_category%TYPE;

1837: v_pn_pay_method_id PN_PAYMENT_TERMS.receipt_method_id%TYPE;
1838: v_pn_po_number PN_PAYMENT_TERMS.cust_po_number%TYPE;
1839: v_pn_tax_included PN_PAYMENT_TERMS.tax_included%TYPE;
1840: v_pn_salesrep_id PN_PAYMENT_TERMS.salesrep_id%TYPE;
1841: v_pn_proj_attr_catg PN_PAYMENT_TERMS.project_attribute_category%TYPE;
1842: v_pn_proj_attr1 PN_PAYMENT_TERMS.project_attribute1%TYPE;
1843: v_pn_proj_attr2 PN_PAYMENT_TERMS.project_attribute2%TYPE;
1844: v_pn_proj_attr3 PN_PAYMENT_TERMS.project_attribute3%TYPE;
1845: v_pn_proj_attr4 PN_PAYMENT_TERMS.project_attribute4%TYPE;

Line 1842: v_pn_proj_attr1 PN_PAYMENT_TERMS.project_attribute1%TYPE;

1838: v_pn_po_number PN_PAYMENT_TERMS.cust_po_number%TYPE;
1839: v_pn_tax_included PN_PAYMENT_TERMS.tax_included%TYPE;
1840: v_pn_salesrep_id PN_PAYMENT_TERMS.salesrep_id%TYPE;
1841: v_pn_proj_attr_catg PN_PAYMENT_TERMS.project_attribute_category%TYPE;
1842: v_pn_proj_attr1 PN_PAYMENT_TERMS.project_attribute1%TYPE;
1843: v_pn_proj_attr2 PN_PAYMENT_TERMS.project_attribute2%TYPE;
1844: v_pn_proj_attr3 PN_PAYMENT_TERMS.project_attribute3%TYPE;
1845: v_pn_proj_attr4 PN_PAYMENT_TERMS.project_attribute4%TYPE;
1846: v_pn_proj_attr5 PN_PAYMENT_TERMS.project_attribute5%TYPE;

Line 1843: v_pn_proj_attr2 PN_PAYMENT_TERMS.project_attribute2%TYPE;

1839: v_pn_tax_included PN_PAYMENT_TERMS.tax_included%TYPE;
1840: v_pn_salesrep_id PN_PAYMENT_TERMS.salesrep_id%TYPE;
1841: v_pn_proj_attr_catg PN_PAYMENT_TERMS.project_attribute_category%TYPE;
1842: v_pn_proj_attr1 PN_PAYMENT_TERMS.project_attribute1%TYPE;
1843: v_pn_proj_attr2 PN_PAYMENT_TERMS.project_attribute2%TYPE;
1844: v_pn_proj_attr3 PN_PAYMENT_TERMS.project_attribute3%TYPE;
1845: v_pn_proj_attr4 PN_PAYMENT_TERMS.project_attribute4%TYPE;
1846: v_pn_proj_attr5 PN_PAYMENT_TERMS.project_attribute5%TYPE;
1847: v_pn_proj_attr6 PN_PAYMENT_TERMS.project_attribute6%TYPE;

Line 1844: v_pn_proj_attr3 PN_PAYMENT_TERMS.project_attribute3%TYPE;

1840: v_pn_salesrep_id PN_PAYMENT_TERMS.salesrep_id%TYPE;
1841: v_pn_proj_attr_catg PN_PAYMENT_TERMS.project_attribute_category%TYPE;
1842: v_pn_proj_attr1 PN_PAYMENT_TERMS.project_attribute1%TYPE;
1843: v_pn_proj_attr2 PN_PAYMENT_TERMS.project_attribute2%TYPE;
1844: v_pn_proj_attr3 PN_PAYMENT_TERMS.project_attribute3%TYPE;
1845: v_pn_proj_attr4 PN_PAYMENT_TERMS.project_attribute4%TYPE;
1846: v_pn_proj_attr5 PN_PAYMENT_TERMS.project_attribute5%TYPE;
1847: v_pn_proj_attr6 PN_PAYMENT_TERMS.project_attribute6%TYPE;
1848: v_pn_proj_attr7 PN_PAYMENT_TERMS.project_attribute7%TYPE;

Line 1845: v_pn_proj_attr4 PN_PAYMENT_TERMS.project_attribute4%TYPE;

1841: v_pn_proj_attr_catg PN_PAYMENT_TERMS.project_attribute_category%TYPE;
1842: v_pn_proj_attr1 PN_PAYMENT_TERMS.project_attribute1%TYPE;
1843: v_pn_proj_attr2 PN_PAYMENT_TERMS.project_attribute2%TYPE;
1844: v_pn_proj_attr3 PN_PAYMENT_TERMS.project_attribute3%TYPE;
1845: v_pn_proj_attr4 PN_PAYMENT_TERMS.project_attribute4%TYPE;
1846: v_pn_proj_attr5 PN_PAYMENT_TERMS.project_attribute5%TYPE;
1847: v_pn_proj_attr6 PN_PAYMENT_TERMS.project_attribute6%TYPE;
1848: v_pn_proj_attr7 PN_PAYMENT_TERMS.project_attribute7%TYPE;
1849: v_pn_org_id PN_PAYMENT_TERMS.org_id%TYPE;

Line 1846: v_pn_proj_attr5 PN_PAYMENT_TERMS.project_attribute5%TYPE;

1842: v_pn_proj_attr1 PN_PAYMENT_TERMS.project_attribute1%TYPE;
1843: v_pn_proj_attr2 PN_PAYMENT_TERMS.project_attribute2%TYPE;
1844: v_pn_proj_attr3 PN_PAYMENT_TERMS.project_attribute3%TYPE;
1845: v_pn_proj_attr4 PN_PAYMENT_TERMS.project_attribute4%TYPE;
1846: v_pn_proj_attr5 PN_PAYMENT_TERMS.project_attribute5%TYPE;
1847: v_pn_proj_attr6 PN_PAYMENT_TERMS.project_attribute6%TYPE;
1848: v_pn_proj_attr7 PN_PAYMENT_TERMS.project_attribute7%TYPE;
1849: v_pn_org_id PN_PAYMENT_TERMS.org_id%TYPE;
1850: v_pn_description PN_PAYMENT_TERMS.payment_purpose_code%TYPE;

Line 1847: v_pn_proj_attr6 PN_PAYMENT_TERMS.project_attribute6%TYPE;

1843: v_pn_proj_attr2 PN_PAYMENT_TERMS.project_attribute2%TYPE;
1844: v_pn_proj_attr3 PN_PAYMENT_TERMS.project_attribute3%TYPE;
1845: v_pn_proj_attr4 PN_PAYMENT_TERMS.project_attribute4%TYPE;
1846: v_pn_proj_attr5 PN_PAYMENT_TERMS.project_attribute5%TYPE;
1847: v_pn_proj_attr6 PN_PAYMENT_TERMS.project_attribute6%TYPE;
1848: v_pn_proj_attr7 PN_PAYMENT_TERMS.project_attribute7%TYPE;
1849: v_pn_org_id PN_PAYMENT_TERMS.org_id%TYPE;
1850: v_pn_description PN_PAYMENT_TERMS.payment_purpose_code%TYPE;
1851: v_transaction_date PN_PAYMENT_ITEMS.due_date%TYPE;

Line 1848: v_pn_proj_attr7 PN_PAYMENT_TERMS.project_attribute7%TYPE;

1844: v_pn_proj_attr3 PN_PAYMENT_TERMS.project_attribute3%TYPE;
1845: v_pn_proj_attr4 PN_PAYMENT_TERMS.project_attribute4%TYPE;
1846: v_pn_proj_attr5 PN_PAYMENT_TERMS.project_attribute5%TYPE;
1847: v_pn_proj_attr6 PN_PAYMENT_TERMS.project_attribute6%TYPE;
1848: v_pn_proj_attr7 PN_PAYMENT_TERMS.project_attribute7%TYPE;
1849: v_pn_org_id PN_PAYMENT_TERMS.org_id%TYPE;
1850: v_pn_description PN_PAYMENT_TERMS.payment_purpose_code%TYPE;
1851: v_transaction_date PN_PAYMENT_ITEMS.due_date%TYPE;
1852: v_normalize PN_PAYMENT_TERMS.normalize%TYPE;

Line 1849: v_pn_org_id PN_PAYMENT_TERMS.org_id%TYPE;

1845: v_pn_proj_attr4 PN_PAYMENT_TERMS.project_attribute4%TYPE;
1846: v_pn_proj_attr5 PN_PAYMENT_TERMS.project_attribute5%TYPE;
1847: v_pn_proj_attr6 PN_PAYMENT_TERMS.project_attribute6%TYPE;
1848: v_pn_proj_attr7 PN_PAYMENT_TERMS.project_attribute7%TYPE;
1849: v_pn_org_id PN_PAYMENT_TERMS.org_id%TYPE;
1850: v_pn_description PN_PAYMENT_TERMS.payment_purpose_code%TYPE;
1851: v_transaction_date PN_PAYMENT_ITEMS.due_date%TYPE;
1852: v_normalize PN_PAYMENT_TERMS.normalize%TYPE;
1853: v_pn_payment_item_id PN_PAYMENT_ITEMS.payment_item_id%TYPE;

Line 1850: v_pn_description PN_PAYMENT_TERMS.payment_purpose_code%TYPE;

1846: v_pn_proj_attr5 PN_PAYMENT_TERMS.project_attribute5%TYPE;
1847: v_pn_proj_attr6 PN_PAYMENT_TERMS.project_attribute6%TYPE;
1848: v_pn_proj_attr7 PN_PAYMENT_TERMS.project_attribute7%TYPE;
1849: v_pn_org_id PN_PAYMENT_TERMS.org_id%TYPE;
1850: v_pn_description PN_PAYMENT_TERMS.payment_purpose_code%TYPE;
1851: v_transaction_date PN_PAYMENT_ITEMS.due_date%TYPE;
1852: v_normalize PN_PAYMENT_TERMS.normalize%TYPE;
1853: v_pn_payment_item_id PN_PAYMENT_ITEMS.payment_item_id%TYPE;
1854: v_pn_payment_term_id PN_PAYMENT_ITEMS.payment_term_id%TYPE;

Line 1852: v_normalize PN_PAYMENT_TERMS.normalize%TYPE;

1848: v_pn_proj_attr7 PN_PAYMENT_TERMS.project_attribute7%TYPE;
1849: v_pn_org_id PN_PAYMENT_TERMS.org_id%TYPE;
1850: v_pn_description PN_PAYMENT_TERMS.payment_purpose_code%TYPE;
1851: v_transaction_date PN_PAYMENT_ITEMS.due_date%TYPE;
1852: v_normalize PN_PAYMENT_TERMS.normalize%TYPE;
1853: v_pn_payment_item_id PN_PAYMENT_ITEMS.payment_item_id%TYPE;
1854: v_pn_payment_term_id PN_PAYMENT_ITEMS.payment_term_id%TYPE;
1855: v_pn_export_currency_code PN_PAYMENT_ITEMS.export_currency_code%TYPE;
1856: v_pn_export_currency_amount PN_PAYMENT_ITEMS.export_currency_amount%TYPE;

Line 1916: v_pur_code PN_PAYMENT_TERMS.payment_purpose_code%TYPE;

1912: l_conv_rate PN_PAYMENT_ITEMS.rate%TYPE;
1913: v_location_id PN_LOCATIONS.location_id%TYPE;
1914: l_send_flag PN_LEASE_DETAILS_ALL.send_entries%TYPE := 'Y';
1915: l_lease_id NUMBER := 0;
1916: v_pur_code PN_PAYMENT_TERMS.payment_purpose_code%TYPE;
1917: v_pur_type_code PN_PAYMENT_TERMS.payment_term_type_code%TYPE;
1918: l_post_to_gl RA_CUST_TRX_TYPES_ALL.post_to_gl%TYPE;
1919: l_derive_date_flag RA_BATCH_SOURCES.derive_date_flag%TYPE;
1920: l_rule_start_date RA_INTERFACE_LINES.rule_start_date%TYPE := NULL;

Line 1917: v_pur_type_code PN_PAYMENT_TERMS.payment_term_type_code%TYPE;

1913: v_location_id PN_LOCATIONS.location_id%TYPE;
1914: l_send_flag PN_LEASE_DETAILS_ALL.send_entries%TYPE := 'Y';
1915: l_lease_id NUMBER := 0;
1916: v_pur_code PN_PAYMENT_TERMS.payment_purpose_code%TYPE;
1917: v_pur_type_code PN_PAYMENT_TERMS.payment_term_type_code%TYPE;
1918: l_post_to_gl RA_CUST_TRX_TYPES_ALL.post_to_gl%TYPE;
1919: l_derive_date_flag RA_BATCH_SOURCES.derive_date_flag%TYPE;
1920: l_rule_start_date RA_INTERFACE_LINES.rule_start_date%TYPE := NULL;
1921: l_rows_nogrp INTEGER;

Line 1924: v_pn_le_id1 PN_PAYMENT_TERMS_ALL.legal_entity_id%TYPE;

1920: l_rule_start_date RA_INTERFACE_LINES.rule_start_date%TYPE := NULL;
1921: l_rows_nogrp INTEGER;
1922: l_count_nogrp INTEGER;
1923: v_pn_payment_term_id1 PN_PAYMENT_ITEMS_ALL.payment_term_id%TYPE;
1924: v_pn_le_id1 PN_PAYMENT_TERMS_ALL.legal_entity_id%TYPE;
1925: v_pn_customer_id1 PN_PAYMENT_ITEMS_ALL.customer_id%TYPE;
1926: v_pn_trx_type_id1 PN_PAYMENT_TERMS.cust_trx_type_id%TYPE;
1927: v_pn_org_id1 PN_PAYMENT_TERMS_ALL.org_id%TYPE;
1928: v_schedule_date PN_PAYMENT_SCHEDULES_ALL.schedule_date%TYPE;

Line 1926: v_pn_trx_type_id1 PN_PAYMENT_TERMS.cust_trx_type_id%TYPE;

1922: l_count_nogrp INTEGER;
1923: v_pn_payment_term_id1 PN_PAYMENT_ITEMS_ALL.payment_term_id%TYPE;
1924: v_pn_le_id1 PN_PAYMENT_TERMS_ALL.legal_entity_id%TYPE;
1925: v_pn_customer_id1 PN_PAYMENT_ITEMS_ALL.customer_id%TYPE;
1926: v_pn_trx_type_id1 PN_PAYMENT_TERMS.cust_trx_type_id%TYPE;
1927: v_pn_org_id1 PN_PAYMENT_TERMS_ALL.org_id%TYPE;
1928: v_schedule_date PN_PAYMENT_SCHEDULES_ALL.schedule_date%TYPE;
1929:
1930: l_rows_select_nogrp NUMBER;

Line 1927: v_pn_org_id1 PN_PAYMENT_TERMS_ALL.org_id%TYPE;

1923: v_pn_payment_term_id1 PN_PAYMENT_ITEMS_ALL.payment_term_id%TYPE;
1924: v_pn_le_id1 PN_PAYMENT_TERMS_ALL.legal_entity_id%TYPE;
1925: v_pn_customer_id1 PN_PAYMENT_ITEMS_ALL.customer_id%TYPE;
1926: v_pn_trx_type_id1 PN_PAYMENT_TERMS.cust_trx_type_id%TYPE;
1927: v_pn_org_id1 PN_PAYMENT_TERMS_ALL.org_id%TYPE;
1928: v_schedule_date PN_PAYMENT_SCHEDULES_ALL.schedule_date%TYPE;
1929:
1930: l_rows_select_nogrp NUMBER;
1931: l_count_select_nogrp NUMBER;

Line 2010: UPDATE pn_payment_terms_all

2006: END;
2007: END LOOP;
2008:
2009: FORALL i IN term_ar_tbl.FIRST..term_ar_tbl.LAST
2010: UPDATE pn_payment_terms_all
2011: SET legal_entity_id = le_ar_tbl(i)
2012: WHERE payment_term_id = term_ar_tbl(i);
2013:
2014: IF dbms_sql.is_open (g_cursor_select_nogrp) THEN