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_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 298: PN_PAYMENT_TERMS_ALL pt, PN_LEASES_ALL le,

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

Line 597: l_tax_classification_code pn_payment_terms.tax_classification_code%TYPE;

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

Line 640: v_pn_cust_ship_site_id PN_PAYMENT_TERMS.cust_ship_site_id%TYPE;

636: v_pn_export_currency_code PN_PAYMENT_ITEMS.export_currency_code%TYPE;
637: v_pn_export_currency_amount PN_PAYMENT_ITEMS.export_currency_amount%TYPE;
638: v_pn_customer_id PN_PAYMENT_ITEMS.customer_id%TYPE;
639: v_pn_customer_site_use_id PN_PAYMENT_ITEMS.customer_site_use_id%TYPE;
640: v_pn_cust_ship_site_id PN_PAYMENT_TERMS.cust_ship_site_id%TYPE;
641: v_pn_tax_code_id PN_PAYMENT_TERMS.tax_code_id%TYPE;
642: v_pn_tax_classification_code PN_PAYMENT_TERMS.tax_classification_code%TYPE;
643: v_pn_legal_entity_id PN_PAYMENT_TERMS.legal_entity_id%TYPE;
644: v_pn_inv_rule_id PN_PAYMENT_TERMS.inv_rule_id%TYPE;

Line 641: v_pn_tax_code_id PN_PAYMENT_TERMS.tax_code_id%TYPE;

637: v_pn_export_currency_amount PN_PAYMENT_ITEMS.export_currency_amount%TYPE;
638: v_pn_customer_id PN_PAYMENT_ITEMS.customer_id%TYPE;
639: v_pn_customer_site_use_id PN_PAYMENT_ITEMS.customer_site_use_id%TYPE;
640: v_pn_cust_ship_site_id PN_PAYMENT_TERMS.cust_ship_site_id%TYPE;
641: v_pn_tax_code_id PN_PAYMENT_TERMS.tax_code_id%TYPE;
642: v_pn_tax_classification_code PN_PAYMENT_TERMS.tax_classification_code%TYPE;
643: v_pn_legal_entity_id PN_PAYMENT_TERMS.legal_entity_id%TYPE;
644: v_pn_inv_rule_id PN_PAYMENT_TERMS.inv_rule_id%TYPE;
645: v_pn_account_rule_id PN_PAYMENT_TERMS.account_rule_id%TYPE;

Line 642: v_pn_tax_classification_code PN_PAYMENT_TERMS.tax_classification_code%TYPE;

638: v_pn_customer_id PN_PAYMENT_ITEMS.customer_id%TYPE;
639: v_pn_customer_site_use_id PN_PAYMENT_ITEMS.customer_site_use_id%TYPE;
640: v_pn_cust_ship_site_id PN_PAYMENT_TERMS.cust_ship_site_id%TYPE;
641: v_pn_tax_code_id PN_PAYMENT_TERMS.tax_code_id%TYPE;
642: v_pn_tax_classification_code PN_PAYMENT_TERMS.tax_classification_code%TYPE;
643: v_pn_legal_entity_id PN_PAYMENT_TERMS.legal_entity_id%TYPE;
644: v_pn_inv_rule_id PN_PAYMENT_TERMS.inv_rule_id%TYPE;
645: v_pn_account_rule_id PN_PAYMENT_TERMS.account_rule_id%TYPE;
646: v_pn_term_id PN_PAYMENT_TERMS.ap_ar_term_id%TYPE;

Line 643: v_pn_legal_entity_id PN_PAYMENT_TERMS.legal_entity_id%TYPE;

639: v_pn_customer_site_use_id PN_PAYMENT_ITEMS.customer_site_use_id%TYPE;
640: v_pn_cust_ship_site_id PN_PAYMENT_TERMS.cust_ship_site_id%TYPE;
641: v_pn_tax_code_id PN_PAYMENT_TERMS.tax_code_id%TYPE;
642: v_pn_tax_classification_code PN_PAYMENT_TERMS.tax_classification_code%TYPE;
643: v_pn_legal_entity_id PN_PAYMENT_TERMS.legal_entity_id%TYPE;
644: v_pn_inv_rule_id PN_PAYMENT_TERMS.inv_rule_id%TYPE;
645: v_pn_account_rule_id PN_PAYMENT_TERMS.account_rule_id%TYPE;
646: v_pn_term_id PN_PAYMENT_TERMS.ap_ar_term_id%TYPE;
647: v_pn_trx_type_id PN_PAYMENT_TERMS.cust_trx_type_id%TYPE;

Line 644: v_pn_inv_rule_id PN_PAYMENT_TERMS.inv_rule_id%TYPE;

640: v_pn_cust_ship_site_id PN_PAYMENT_TERMS.cust_ship_site_id%TYPE;
641: v_pn_tax_code_id PN_PAYMENT_TERMS.tax_code_id%TYPE;
642: v_pn_tax_classification_code PN_PAYMENT_TERMS.tax_classification_code%TYPE;
643: v_pn_legal_entity_id PN_PAYMENT_TERMS.legal_entity_id%TYPE;
644: v_pn_inv_rule_id PN_PAYMENT_TERMS.inv_rule_id%TYPE;
645: v_pn_account_rule_id PN_PAYMENT_TERMS.account_rule_id%TYPE;
646: v_pn_term_id PN_PAYMENT_TERMS.ap_ar_term_id%TYPE;
647: v_pn_trx_type_id PN_PAYMENT_TERMS.cust_trx_type_id%TYPE;
648: v_pn_pay_method_id PN_PAYMENT_TERMS.receipt_method_id%TYPE;

Line 645: v_pn_account_rule_id PN_PAYMENT_TERMS.account_rule_id%TYPE;

641: v_pn_tax_code_id PN_PAYMENT_TERMS.tax_code_id%TYPE;
642: v_pn_tax_classification_code PN_PAYMENT_TERMS.tax_classification_code%TYPE;
643: v_pn_legal_entity_id PN_PAYMENT_TERMS.legal_entity_id%TYPE;
644: v_pn_inv_rule_id PN_PAYMENT_TERMS.inv_rule_id%TYPE;
645: v_pn_account_rule_id PN_PAYMENT_TERMS.account_rule_id%TYPE;
646: v_pn_term_id PN_PAYMENT_TERMS.ap_ar_term_id%TYPE;
647: v_pn_trx_type_id PN_PAYMENT_TERMS.cust_trx_type_id%TYPE;
648: v_pn_pay_method_id PN_PAYMENT_TERMS.receipt_method_id%TYPE;
649: v_pn_po_number PN_PAYMENT_TERMS.cust_po_number%TYPE;

Line 646: v_pn_term_id PN_PAYMENT_TERMS.ap_ar_term_id%TYPE;

642: v_pn_tax_classification_code PN_PAYMENT_TERMS.tax_classification_code%TYPE;
643: v_pn_legal_entity_id PN_PAYMENT_TERMS.legal_entity_id%TYPE;
644: v_pn_inv_rule_id PN_PAYMENT_TERMS.inv_rule_id%TYPE;
645: v_pn_account_rule_id PN_PAYMENT_TERMS.account_rule_id%TYPE;
646: v_pn_term_id PN_PAYMENT_TERMS.ap_ar_term_id%TYPE;
647: v_pn_trx_type_id PN_PAYMENT_TERMS.cust_trx_type_id%TYPE;
648: v_pn_pay_method_id PN_PAYMENT_TERMS.receipt_method_id%TYPE;
649: v_pn_po_number PN_PAYMENT_TERMS.cust_po_number%TYPE;
650: v_pn_tax_included PN_PAYMENT_TERMS.tax_included%TYPE;

Line 647: v_pn_trx_type_id PN_PAYMENT_TERMS.cust_trx_type_id%TYPE;

643: v_pn_legal_entity_id PN_PAYMENT_TERMS.legal_entity_id%TYPE;
644: v_pn_inv_rule_id PN_PAYMENT_TERMS.inv_rule_id%TYPE;
645: v_pn_account_rule_id PN_PAYMENT_TERMS.account_rule_id%TYPE;
646: v_pn_term_id PN_PAYMENT_TERMS.ap_ar_term_id%TYPE;
647: v_pn_trx_type_id PN_PAYMENT_TERMS.cust_trx_type_id%TYPE;
648: v_pn_pay_method_id PN_PAYMENT_TERMS.receipt_method_id%TYPE;
649: v_pn_po_number PN_PAYMENT_TERMS.cust_po_number%TYPE;
650: v_pn_tax_included PN_PAYMENT_TERMS.tax_included%TYPE;
651: v_pn_salesrep_id PN_PAYMENT_TERMS.salesrep_id%TYPE;

Line 648: v_pn_pay_method_id PN_PAYMENT_TERMS.receipt_method_id%TYPE;

644: v_pn_inv_rule_id PN_PAYMENT_TERMS.inv_rule_id%TYPE;
645: v_pn_account_rule_id PN_PAYMENT_TERMS.account_rule_id%TYPE;
646: v_pn_term_id PN_PAYMENT_TERMS.ap_ar_term_id%TYPE;
647: v_pn_trx_type_id PN_PAYMENT_TERMS.cust_trx_type_id%TYPE;
648: v_pn_pay_method_id PN_PAYMENT_TERMS.receipt_method_id%TYPE;
649: v_pn_po_number PN_PAYMENT_TERMS.cust_po_number%TYPE;
650: v_pn_tax_included PN_PAYMENT_TERMS.tax_included%TYPE;
651: v_pn_salesrep_id PN_PAYMENT_TERMS.salesrep_id%TYPE;
652: v_pn_proj_attr_catg PN_PAYMENT_TERMS.project_attribute_category%TYPE;

Line 649: v_pn_po_number PN_PAYMENT_TERMS.cust_po_number%TYPE;

645: v_pn_account_rule_id PN_PAYMENT_TERMS.account_rule_id%TYPE;
646: v_pn_term_id PN_PAYMENT_TERMS.ap_ar_term_id%TYPE;
647: v_pn_trx_type_id PN_PAYMENT_TERMS.cust_trx_type_id%TYPE;
648: v_pn_pay_method_id PN_PAYMENT_TERMS.receipt_method_id%TYPE;
649: v_pn_po_number PN_PAYMENT_TERMS.cust_po_number%TYPE;
650: v_pn_tax_included PN_PAYMENT_TERMS.tax_included%TYPE;
651: v_pn_salesrep_id PN_PAYMENT_TERMS.salesrep_id%TYPE;
652: v_pn_proj_attr_catg PN_PAYMENT_TERMS.project_attribute_category%TYPE;
653: v_pn_proj_attr3 PN_PAYMENT_TERMS.project_attribute3%TYPE;

Line 650: v_pn_tax_included PN_PAYMENT_TERMS.tax_included%TYPE;

646: v_pn_term_id PN_PAYMENT_TERMS.ap_ar_term_id%TYPE;
647: v_pn_trx_type_id PN_PAYMENT_TERMS.cust_trx_type_id%TYPE;
648: v_pn_pay_method_id PN_PAYMENT_TERMS.receipt_method_id%TYPE;
649: v_pn_po_number PN_PAYMENT_TERMS.cust_po_number%TYPE;
650: v_pn_tax_included PN_PAYMENT_TERMS.tax_included%TYPE;
651: v_pn_salesrep_id PN_PAYMENT_TERMS.salesrep_id%TYPE;
652: v_pn_proj_attr_catg PN_PAYMENT_TERMS.project_attribute_category%TYPE;
653: v_pn_proj_attr3 PN_PAYMENT_TERMS.project_attribute3%TYPE;
654: v_pn_proj_attr4 PN_PAYMENT_TERMS.project_attribute4%TYPE;

Line 651: v_pn_salesrep_id PN_PAYMENT_TERMS.salesrep_id%TYPE;

647: v_pn_trx_type_id PN_PAYMENT_TERMS.cust_trx_type_id%TYPE;
648: v_pn_pay_method_id PN_PAYMENT_TERMS.receipt_method_id%TYPE;
649: v_pn_po_number PN_PAYMENT_TERMS.cust_po_number%TYPE;
650: v_pn_tax_included PN_PAYMENT_TERMS.tax_included%TYPE;
651: v_pn_salesrep_id PN_PAYMENT_TERMS.salesrep_id%TYPE;
652: v_pn_proj_attr_catg PN_PAYMENT_TERMS.project_attribute_category%TYPE;
653: v_pn_proj_attr3 PN_PAYMENT_TERMS.project_attribute3%TYPE;
654: v_pn_proj_attr4 PN_PAYMENT_TERMS.project_attribute4%TYPE;
655: v_pn_proj_attr5 PN_PAYMENT_TERMS.project_attribute5%TYPE;

Line 652: v_pn_proj_attr_catg PN_PAYMENT_TERMS.project_attribute_category%TYPE;

648: v_pn_pay_method_id PN_PAYMENT_TERMS.receipt_method_id%TYPE;
649: v_pn_po_number PN_PAYMENT_TERMS.cust_po_number%TYPE;
650: v_pn_tax_included PN_PAYMENT_TERMS.tax_included%TYPE;
651: v_pn_salesrep_id PN_PAYMENT_TERMS.salesrep_id%TYPE;
652: v_pn_proj_attr_catg PN_PAYMENT_TERMS.project_attribute_category%TYPE;
653: v_pn_proj_attr3 PN_PAYMENT_TERMS.project_attribute3%TYPE;
654: v_pn_proj_attr4 PN_PAYMENT_TERMS.project_attribute4%TYPE;
655: v_pn_proj_attr5 PN_PAYMENT_TERMS.project_attribute5%TYPE;
656: v_pn_proj_attr6 PN_PAYMENT_TERMS.project_attribute6%TYPE;

Line 653: v_pn_proj_attr3 PN_PAYMENT_TERMS.project_attribute3%TYPE;

649: v_pn_po_number PN_PAYMENT_TERMS.cust_po_number%TYPE;
650: v_pn_tax_included PN_PAYMENT_TERMS.tax_included%TYPE;
651: v_pn_salesrep_id PN_PAYMENT_TERMS.salesrep_id%TYPE;
652: v_pn_proj_attr_catg PN_PAYMENT_TERMS.project_attribute_category%TYPE;
653: v_pn_proj_attr3 PN_PAYMENT_TERMS.project_attribute3%TYPE;
654: v_pn_proj_attr4 PN_PAYMENT_TERMS.project_attribute4%TYPE;
655: v_pn_proj_attr5 PN_PAYMENT_TERMS.project_attribute5%TYPE;
656: v_pn_proj_attr6 PN_PAYMENT_TERMS.project_attribute6%TYPE;
657: v_pn_proj_attr7 PN_PAYMENT_TERMS.project_attribute7%TYPE;

Line 654: v_pn_proj_attr4 PN_PAYMENT_TERMS.project_attribute4%TYPE;

650: v_pn_tax_included PN_PAYMENT_TERMS.tax_included%TYPE;
651: v_pn_salesrep_id PN_PAYMENT_TERMS.salesrep_id%TYPE;
652: v_pn_proj_attr_catg PN_PAYMENT_TERMS.project_attribute_category%TYPE;
653: v_pn_proj_attr3 PN_PAYMENT_TERMS.project_attribute3%TYPE;
654: v_pn_proj_attr4 PN_PAYMENT_TERMS.project_attribute4%TYPE;
655: v_pn_proj_attr5 PN_PAYMENT_TERMS.project_attribute5%TYPE;
656: v_pn_proj_attr6 PN_PAYMENT_TERMS.project_attribute6%TYPE;
657: v_pn_proj_attr7 PN_PAYMENT_TERMS.project_attribute7%TYPE;
658: v_pn_org_id PN_PAYMENT_TERMS.org_id%TYPE;

Line 655: v_pn_proj_attr5 PN_PAYMENT_TERMS.project_attribute5%TYPE;

651: v_pn_salesrep_id PN_PAYMENT_TERMS.salesrep_id%TYPE;
652: v_pn_proj_attr_catg PN_PAYMENT_TERMS.project_attribute_category%TYPE;
653: v_pn_proj_attr3 PN_PAYMENT_TERMS.project_attribute3%TYPE;
654: v_pn_proj_attr4 PN_PAYMENT_TERMS.project_attribute4%TYPE;
655: v_pn_proj_attr5 PN_PAYMENT_TERMS.project_attribute5%TYPE;
656: v_pn_proj_attr6 PN_PAYMENT_TERMS.project_attribute6%TYPE;
657: v_pn_proj_attr7 PN_PAYMENT_TERMS.project_attribute7%TYPE;
658: v_pn_org_id PN_PAYMENT_TERMS.org_id%TYPE;
659: v_pn_lease_num PN_LEASES.lease_num%TYPE;

Line 656: v_pn_proj_attr6 PN_PAYMENT_TERMS.project_attribute6%TYPE;

652: v_pn_proj_attr_catg PN_PAYMENT_TERMS.project_attribute_category%TYPE;
653: v_pn_proj_attr3 PN_PAYMENT_TERMS.project_attribute3%TYPE;
654: v_pn_proj_attr4 PN_PAYMENT_TERMS.project_attribute4%TYPE;
655: v_pn_proj_attr5 PN_PAYMENT_TERMS.project_attribute5%TYPE;
656: v_pn_proj_attr6 PN_PAYMENT_TERMS.project_attribute6%TYPE;
657: v_pn_proj_attr7 PN_PAYMENT_TERMS.project_attribute7%TYPE;
658: v_pn_org_id PN_PAYMENT_TERMS.org_id%TYPE;
659: v_pn_lease_num PN_LEASES.lease_num%TYPE;
660: v_pn_payment_schedule_id PN_PAYMENT_ITEMS.payment_schedule_id%TYPE;

Line 657: v_pn_proj_attr7 PN_PAYMENT_TERMS.project_attribute7%TYPE;

653: v_pn_proj_attr3 PN_PAYMENT_TERMS.project_attribute3%TYPE;
654: v_pn_proj_attr4 PN_PAYMENT_TERMS.project_attribute4%TYPE;
655: v_pn_proj_attr5 PN_PAYMENT_TERMS.project_attribute5%TYPE;
656: v_pn_proj_attr6 PN_PAYMENT_TERMS.project_attribute6%TYPE;
657: v_pn_proj_attr7 PN_PAYMENT_TERMS.project_attribute7%TYPE;
658: v_pn_org_id PN_PAYMENT_TERMS.org_id%TYPE;
659: v_pn_lease_num PN_LEASES.lease_num%TYPE;
660: v_pn_payment_schedule_id PN_PAYMENT_ITEMS.payment_schedule_id%TYPE;
661: v_pn_period_name PN_PAYMENT_SCHEDULES.period_name%TYPE;

Line 658: v_pn_org_id PN_PAYMENT_TERMS.org_id%TYPE;

654: v_pn_proj_attr4 PN_PAYMENT_TERMS.project_attribute4%TYPE;
655: v_pn_proj_attr5 PN_PAYMENT_TERMS.project_attribute5%TYPE;
656: v_pn_proj_attr6 PN_PAYMENT_TERMS.project_attribute6%TYPE;
657: v_pn_proj_attr7 PN_PAYMENT_TERMS.project_attribute7%TYPE;
658: v_pn_org_id PN_PAYMENT_TERMS.org_id%TYPE;
659: v_pn_lease_num PN_LEASES.lease_num%TYPE;
660: v_pn_payment_schedule_id PN_PAYMENT_ITEMS.payment_schedule_id%TYPE;
661: v_pn_period_name PN_PAYMENT_SCHEDULES.period_name%TYPE;
662: v_pn_description PN_PAYMENT_TERMS.payment_purpose_code%TYPE;

Line 662: v_pn_description PN_PAYMENT_TERMS.payment_purpose_code%TYPE;

658: v_pn_org_id PN_PAYMENT_TERMS.org_id%TYPE;
659: v_pn_lease_num PN_LEASES.lease_num%TYPE;
660: v_pn_payment_schedule_id PN_PAYMENT_ITEMS.payment_schedule_id%TYPE;
661: v_pn_period_name PN_PAYMENT_SCHEDULES.period_name%TYPE;
662: v_pn_description PN_PAYMENT_TERMS.payment_purpose_code%TYPE;
663: v_pn_lease_id PN_LEASES.lease_id%TYPE;
664: v_transaction_date PN_PAYMENT_ITEMS.due_date%TYPE;
665: v_normalize PN_PAYMENT_TERMS.normalize%TYPE;
666: v_pn_accounted_date PN_PAYMENT_ITEMS.accounted_date%TYPE;

Line 665: v_normalize PN_PAYMENT_TERMS.normalize%TYPE;

661: v_pn_period_name PN_PAYMENT_SCHEDULES.period_name%TYPE;
662: v_pn_description PN_PAYMENT_TERMS.payment_purpose_code%TYPE;
663: v_pn_lease_id PN_LEASES.lease_id%TYPE;
664: v_transaction_date PN_PAYMENT_ITEMS.due_date%TYPE;
665: v_normalize PN_PAYMENT_TERMS.normalize%TYPE;
666: v_pn_accounted_date PN_PAYMENT_ITEMS.accounted_date%TYPE;
667: v_pn_rate PN_PAYMENT_ITEMS.rate%TYPE;
668: v_location_id PN_LOCATIONS.LOCATION_ID%TYPE;
669: v_send_entries PN_LEASE_DETAILS.send_entries%TYPE;

Line 674: v_payment_purpose PN_PAYMENT_TERMS.payment_purpose_code%TYPE;

670: v_rec_account PN_DISTRIBUTIONS.account_id%TYPE;
671: v_gl_date RA_CUST_TRX_LINE_GL_DIST.gl_date%TYPE;
672: v_conv_rate_type PN_CURRENCIES.conversion_type%TYPE;
673: v_conv_rate PN_PAYMENT_ITEMS.rate%TYPE;
674: v_payment_purpose PN_PAYMENT_TERMS.payment_purpose_code%TYPE;
675: v_payment_type PN_PAYMENT_TERMS.payment_term_type_code%TYPE;
676: v_rule_gl_date RA_CUST_TRX_LINE_GL_DIST.gl_date%TYPE;
677: v_schedule_date PN_PAYMENT_SCHEDULES.schedule_date%TYPE;
678: v_pn_payment_term_id1 PN_PAYMENT_ITEMS.payment_term_id%TYPE;

Line 675: v_payment_type PN_PAYMENT_TERMS.payment_term_type_code%TYPE;

671: v_gl_date RA_CUST_TRX_LINE_GL_DIST.gl_date%TYPE;
672: v_conv_rate_type PN_CURRENCIES.conversion_type%TYPE;
673: v_conv_rate PN_PAYMENT_ITEMS.rate%TYPE;
674: v_payment_purpose PN_PAYMENT_TERMS.payment_purpose_code%TYPE;
675: v_payment_type PN_PAYMENT_TERMS.payment_term_type_code%TYPE;
676: v_rule_gl_date RA_CUST_TRX_LINE_GL_DIST.gl_date%TYPE;
677: v_schedule_date PN_PAYMENT_SCHEDULES.schedule_date%TYPE;
678: v_pn_payment_term_id1 PN_PAYMENT_ITEMS.payment_term_id%TYPE;
679: v_pn_le_id1 PN_PAYMENT_TERMS.legal_entity_id%TYPE;

Line 679: v_pn_le_id1 PN_PAYMENT_TERMS.legal_entity_id%TYPE;

675: v_payment_type PN_PAYMENT_TERMS.payment_term_type_code%TYPE;
676: v_rule_gl_date RA_CUST_TRX_LINE_GL_DIST.gl_date%TYPE;
677: v_schedule_date PN_PAYMENT_SCHEDULES.schedule_date%TYPE;
678: v_pn_payment_term_id1 PN_PAYMENT_ITEMS.payment_term_id%TYPE;
679: v_pn_le_id1 PN_PAYMENT_TERMS.legal_entity_id%TYPE;
680: v_pn_customer_id1 PN_PAYMENT_ITEMS.customer_id%TYPE;
681: v_pn_trx_type_id1 PN_PAYMENT_TERMS.cust_trx_type_id%TYPE;
682: v_pn_org_id1 PN_PAYMENT_TERMS.org_id%TYPE;
683: l_rows_select_grp NUMBER;

Line 681: v_pn_trx_type_id1 PN_PAYMENT_TERMS.cust_trx_type_id%TYPE;

677: v_schedule_date PN_PAYMENT_SCHEDULES.schedule_date%TYPE;
678: v_pn_payment_term_id1 PN_PAYMENT_ITEMS.payment_term_id%TYPE;
679: v_pn_le_id1 PN_PAYMENT_TERMS.legal_entity_id%TYPE;
680: v_pn_customer_id1 PN_PAYMENT_ITEMS.customer_id%TYPE;
681: v_pn_trx_type_id1 PN_PAYMENT_TERMS.cust_trx_type_id%TYPE;
682: v_pn_org_id1 PN_PAYMENT_TERMS.org_id%TYPE;
683: l_rows_select_grp NUMBER;
684: l_count_select_grp NUMBER;
685: TYPE le_ar_tbl_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;

Line 682: v_pn_org_id1 PN_PAYMENT_TERMS.org_id%TYPE;

678: v_pn_payment_term_id1 PN_PAYMENT_ITEMS.payment_term_id%TYPE;
679: v_pn_le_id1 PN_PAYMENT_TERMS.legal_entity_id%TYPE;
680: v_pn_customer_id1 PN_PAYMENT_ITEMS.customer_id%TYPE;
681: v_pn_trx_type_id1 PN_PAYMENT_TERMS.cust_trx_type_id%TYPE;
682: v_pn_org_id1 PN_PAYMENT_TERMS.org_id%TYPE;
683: l_rows_select_grp NUMBER;
684: l_count_select_grp NUMBER;
685: TYPE le_ar_tbl_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
686: TYPE term_ar_tbl_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;

Line 759: UPDATE pn_payment_terms_all

755: END;
756: END LOOP;
757:
758: FORALL i IN term_ar_tbl.FIRST..term_ar_tbl.LAST
759: UPDATE pn_payment_terms_all
760: SET legal_entity_id = le_ar_tbl(i)
761: WHERE payment_term_id = term_ar_tbl(i);
762:
763: IF dbms_sql.is_open (g_cursor_select_grp) THEN

Line 1874: v_pn_code_combination_id PN_PAYMENT_TERMS.code_combination_id%TYPE;

1870: IS
1871: v_pn_lease_num PN_LEASES.lease_num%TYPE;
1872: v_pn_lease_id PN_LEASES.lease_id%TYPE;
1873: v_pn_period_name PN_PAYMENT_SCHEDULES.period_name%TYPE;
1874: v_pn_code_combination_id PN_PAYMENT_TERMS.code_combination_id%TYPE;
1875: v_pn_cust_ship_site_id PN_PAYMENT_TERMS.cust_ship_site_id%TYPE;
1876: v_pn_tax_code_id PN_PAYMENT_TERMS.tax_code_id%TYPE;
1877: v_pn_tcc PN_PAYMENT_TERMS.tax_classification_code%TYPE;
1878: v_pn_le PN_PAYMENT_TERMS.legal_entity_id%TYPE;

Line 1875: v_pn_cust_ship_site_id PN_PAYMENT_TERMS.cust_ship_site_id%TYPE;

1871: v_pn_lease_num PN_LEASES.lease_num%TYPE;
1872: v_pn_lease_id PN_LEASES.lease_id%TYPE;
1873: v_pn_period_name PN_PAYMENT_SCHEDULES.period_name%TYPE;
1874: v_pn_code_combination_id PN_PAYMENT_TERMS.code_combination_id%TYPE;
1875: v_pn_cust_ship_site_id PN_PAYMENT_TERMS.cust_ship_site_id%TYPE;
1876: v_pn_tax_code_id PN_PAYMENT_TERMS.tax_code_id%TYPE;
1877: v_pn_tcc PN_PAYMENT_TERMS.tax_classification_code%TYPE;
1878: v_pn_le PN_PAYMENT_TERMS.legal_entity_id%TYPE;
1879: v_pn_inv_rule_id PN_PAYMENT_TERMS.inv_rule_id%TYPE;

Line 1876: v_pn_tax_code_id PN_PAYMENT_TERMS.tax_code_id%TYPE;

1872: v_pn_lease_id PN_LEASES.lease_id%TYPE;
1873: v_pn_period_name PN_PAYMENT_SCHEDULES.period_name%TYPE;
1874: v_pn_code_combination_id PN_PAYMENT_TERMS.code_combination_id%TYPE;
1875: v_pn_cust_ship_site_id PN_PAYMENT_TERMS.cust_ship_site_id%TYPE;
1876: v_pn_tax_code_id PN_PAYMENT_TERMS.tax_code_id%TYPE;
1877: v_pn_tcc PN_PAYMENT_TERMS.tax_classification_code%TYPE;
1878: v_pn_le PN_PAYMENT_TERMS.legal_entity_id%TYPE;
1879: v_pn_inv_rule_id PN_PAYMENT_TERMS.inv_rule_id%TYPE;
1880: v_pn_account_rule_id PN_PAYMENT_TERMS.account_rule_id%TYPE;

Line 1877: v_pn_tcc PN_PAYMENT_TERMS.tax_classification_code%TYPE;

1873: v_pn_period_name PN_PAYMENT_SCHEDULES.period_name%TYPE;
1874: v_pn_code_combination_id PN_PAYMENT_TERMS.code_combination_id%TYPE;
1875: v_pn_cust_ship_site_id PN_PAYMENT_TERMS.cust_ship_site_id%TYPE;
1876: v_pn_tax_code_id PN_PAYMENT_TERMS.tax_code_id%TYPE;
1877: v_pn_tcc PN_PAYMENT_TERMS.tax_classification_code%TYPE;
1878: v_pn_le PN_PAYMENT_TERMS.legal_entity_id%TYPE;
1879: v_pn_inv_rule_id PN_PAYMENT_TERMS.inv_rule_id%TYPE;
1880: v_pn_account_rule_id PN_PAYMENT_TERMS.account_rule_id%TYPE;
1881: v_pn_term_id PN_PAYMENT_TERMS.ap_ar_term_id%TYPE;

Line 1878: v_pn_le PN_PAYMENT_TERMS.legal_entity_id%TYPE;

1874: v_pn_code_combination_id PN_PAYMENT_TERMS.code_combination_id%TYPE;
1875: v_pn_cust_ship_site_id PN_PAYMENT_TERMS.cust_ship_site_id%TYPE;
1876: v_pn_tax_code_id PN_PAYMENT_TERMS.tax_code_id%TYPE;
1877: v_pn_tcc PN_PAYMENT_TERMS.tax_classification_code%TYPE;
1878: v_pn_le PN_PAYMENT_TERMS.legal_entity_id%TYPE;
1879: v_pn_inv_rule_id PN_PAYMENT_TERMS.inv_rule_id%TYPE;
1880: v_pn_account_rule_id PN_PAYMENT_TERMS.account_rule_id%TYPE;
1881: v_pn_term_id PN_PAYMENT_TERMS.ap_ar_term_id%TYPE;
1882: v_pn_trx_type_id PN_PAYMENT_TERMS.cust_trx_type_id%TYPE;

Line 1879: v_pn_inv_rule_id PN_PAYMENT_TERMS.inv_rule_id%TYPE;

1875: v_pn_cust_ship_site_id PN_PAYMENT_TERMS.cust_ship_site_id%TYPE;
1876: v_pn_tax_code_id PN_PAYMENT_TERMS.tax_code_id%TYPE;
1877: v_pn_tcc PN_PAYMENT_TERMS.tax_classification_code%TYPE;
1878: v_pn_le PN_PAYMENT_TERMS.legal_entity_id%TYPE;
1879: v_pn_inv_rule_id PN_PAYMENT_TERMS.inv_rule_id%TYPE;
1880: v_pn_account_rule_id PN_PAYMENT_TERMS.account_rule_id%TYPE;
1881: v_pn_term_id PN_PAYMENT_TERMS.ap_ar_term_id%TYPE;
1882: v_pn_trx_type_id PN_PAYMENT_TERMS.cust_trx_type_id%TYPE;
1883: v_pn_pay_method_id PN_PAYMENT_TERMS.receipt_method_id%TYPE;

Line 1880: v_pn_account_rule_id PN_PAYMENT_TERMS.account_rule_id%TYPE;

1876: v_pn_tax_code_id PN_PAYMENT_TERMS.tax_code_id%TYPE;
1877: v_pn_tcc PN_PAYMENT_TERMS.tax_classification_code%TYPE;
1878: v_pn_le PN_PAYMENT_TERMS.legal_entity_id%TYPE;
1879: v_pn_inv_rule_id PN_PAYMENT_TERMS.inv_rule_id%TYPE;
1880: v_pn_account_rule_id PN_PAYMENT_TERMS.account_rule_id%TYPE;
1881: v_pn_term_id PN_PAYMENT_TERMS.ap_ar_term_id%TYPE;
1882: v_pn_trx_type_id PN_PAYMENT_TERMS.cust_trx_type_id%TYPE;
1883: v_pn_pay_method_id PN_PAYMENT_TERMS.receipt_method_id%TYPE;
1884: v_pn_po_number PN_PAYMENT_TERMS.cust_po_number%TYPE;

Line 1881: v_pn_term_id PN_PAYMENT_TERMS.ap_ar_term_id%TYPE;

1877: v_pn_tcc PN_PAYMENT_TERMS.tax_classification_code%TYPE;
1878: v_pn_le PN_PAYMENT_TERMS.legal_entity_id%TYPE;
1879: v_pn_inv_rule_id PN_PAYMENT_TERMS.inv_rule_id%TYPE;
1880: v_pn_account_rule_id PN_PAYMENT_TERMS.account_rule_id%TYPE;
1881: v_pn_term_id PN_PAYMENT_TERMS.ap_ar_term_id%TYPE;
1882: v_pn_trx_type_id PN_PAYMENT_TERMS.cust_trx_type_id%TYPE;
1883: v_pn_pay_method_id PN_PAYMENT_TERMS.receipt_method_id%TYPE;
1884: v_pn_po_number PN_PAYMENT_TERMS.cust_po_number%TYPE;
1885: v_pn_tax_included PN_PAYMENT_TERMS.tax_included%TYPE;

Line 1882: v_pn_trx_type_id PN_PAYMENT_TERMS.cust_trx_type_id%TYPE;

1878: v_pn_le PN_PAYMENT_TERMS.legal_entity_id%TYPE;
1879: v_pn_inv_rule_id PN_PAYMENT_TERMS.inv_rule_id%TYPE;
1880: v_pn_account_rule_id PN_PAYMENT_TERMS.account_rule_id%TYPE;
1881: v_pn_term_id PN_PAYMENT_TERMS.ap_ar_term_id%TYPE;
1882: v_pn_trx_type_id PN_PAYMENT_TERMS.cust_trx_type_id%TYPE;
1883: v_pn_pay_method_id PN_PAYMENT_TERMS.receipt_method_id%TYPE;
1884: v_pn_po_number PN_PAYMENT_TERMS.cust_po_number%TYPE;
1885: v_pn_tax_included PN_PAYMENT_TERMS.tax_included%TYPE;
1886: v_pn_salesrep_id PN_PAYMENT_TERMS.salesrep_id%TYPE;

Line 1883: v_pn_pay_method_id PN_PAYMENT_TERMS.receipt_method_id%TYPE;

1879: v_pn_inv_rule_id PN_PAYMENT_TERMS.inv_rule_id%TYPE;
1880: v_pn_account_rule_id PN_PAYMENT_TERMS.account_rule_id%TYPE;
1881: v_pn_term_id PN_PAYMENT_TERMS.ap_ar_term_id%TYPE;
1882: v_pn_trx_type_id PN_PAYMENT_TERMS.cust_trx_type_id%TYPE;
1883: v_pn_pay_method_id PN_PAYMENT_TERMS.receipt_method_id%TYPE;
1884: v_pn_po_number PN_PAYMENT_TERMS.cust_po_number%TYPE;
1885: v_pn_tax_included PN_PAYMENT_TERMS.tax_included%TYPE;
1886: v_pn_salesrep_id PN_PAYMENT_TERMS.salesrep_id%TYPE;
1887: v_pn_proj_attr_catg PN_PAYMENT_TERMS.project_attribute_category%TYPE;

Line 1884: v_pn_po_number PN_PAYMENT_TERMS.cust_po_number%TYPE;

1880: v_pn_account_rule_id PN_PAYMENT_TERMS.account_rule_id%TYPE;
1881: v_pn_term_id PN_PAYMENT_TERMS.ap_ar_term_id%TYPE;
1882: v_pn_trx_type_id PN_PAYMENT_TERMS.cust_trx_type_id%TYPE;
1883: v_pn_pay_method_id PN_PAYMENT_TERMS.receipt_method_id%TYPE;
1884: v_pn_po_number PN_PAYMENT_TERMS.cust_po_number%TYPE;
1885: v_pn_tax_included PN_PAYMENT_TERMS.tax_included%TYPE;
1886: v_pn_salesrep_id PN_PAYMENT_TERMS.salesrep_id%TYPE;
1887: v_pn_proj_attr_catg PN_PAYMENT_TERMS.project_attribute_category%TYPE;
1888: v_pn_proj_attr1 PN_PAYMENT_TERMS.project_attribute1%TYPE;

Line 1885: v_pn_tax_included PN_PAYMENT_TERMS.tax_included%TYPE;

1881: v_pn_term_id PN_PAYMENT_TERMS.ap_ar_term_id%TYPE;
1882: v_pn_trx_type_id PN_PAYMENT_TERMS.cust_trx_type_id%TYPE;
1883: v_pn_pay_method_id PN_PAYMENT_TERMS.receipt_method_id%TYPE;
1884: v_pn_po_number PN_PAYMENT_TERMS.cust_po_number%TYPE;
1885: v_pn_tax_included PN_PAYMENT_TERMS.tax_included%TYPE;
1886: v_pn_salesrep_id PN_PAYMENT_TERMS.salesrep_id%TYPE;
1887: v_pn_proj_attr_catg PN_PAYMENT_TERMS.project_attribute_category%TYPE;
1888: v_pn_proj_attr1 PN_PAYMENT_TERMS.project_attribute1%TYPE;
1889: v_pn_proj_attr2 PN_PAYMENT_TERMS.project_attribute2%TYPE;

Line 1886: v_pn_salesrep_id PN_PAYMENT_TERMS.salesrep_id%TYPE;

1882: v_pn_trx_type_id PN_PAYMENT_TERMS.cust_trx_type_id%TYPE;
1883: v_pn_pay_method_id PN_PAYMENT_TERMS.receipt_method_id%TYPE;
1884: v_pn_po_number PN_PAYMENT_TERMS.cust_po_number%TYPE;
1885: v_pn_tax_included PN_PAYMENT_TERMS.tax_included%TYPE;
1886: v_pn_salesrep_id PN_PAYMENT_TERMS.salesrep_id%TYPE;
1887: v_pn_proj_attr_catg PN_PAYMENT_TERMS.project_attribute_category%TYPE;
1888: v_pn_proj_attr1 PN_PAYMENT_TERMS.project_attribute1%TYPE;
1889: v_pn_proj_attr2 PN_PAYMENT_TERMS.project_attribute2%TYPE;
1890: v_pn_proj_attr3 PN_PAYMENT_TERMS.project_attribute3%TYPE;

Line 1887: v_pn_proj_attr_catg PN_PAYMENT_TERMS.project_attribute_category%TYPE;

1883: v_pn_pay_method_id PN_PAYMENT_TERMS.receipt_method_id%TYPE;
1884: v_pn_po_number PN_PAYMENT_TERMS.cust_po_number%TYPE;
1885: v_pn_tax_included PN_PAYMENT_TERMS.tax_included%TYPE;
1886: v_pn_salesrep_id PN_PAYMENT_TERMS.salesrep_id%TYPE;
1887: v_pn_proj_attr_catg PN_PAYMENT_TERMS.project_attribute_category%TYPE;
1888: v_pn_proj_attr1 PN_PAYMENT_TERMS.project_attribute1%TYPE;
1889: v_pn_proj_attr2 PN_PAYMENT_TERMS.project_attribute2%TYPE;
1890: v_pn_proj_attr3 PN_PAYMENT_TERMS.project_attribute3%TYPE;
1891: v_pn_proj_attr4 PN_PAYMENT_TERMS.project_attribute4%TYPE;

Line 1888: v_pn_proj_attr1 PN_PAYMENT_TERMS.project_attribute1%TYPE;

1884: v_pn_po_number PN_PAYMENT_TERMS.cust_po_number%TYPE;
1885: v_pn_tax_included PN_PAYMENT_TERMS.tax_included%TYPE;
1886: v_pn_salesrep_id PN_PAYMENT_TERMS.salesrep_id%TYPE;
1887: v_pn_proj_attr_catg PN_PAYMENT_TERMS.project_attribute_category%TYPE;
1888: v_pn_proj_attr1 PN_PAYMENT_TERMS.project_attribute1%TYPE;
1889: v_pn_proj_attr2 PN_PAYMENT_TERMS.project_attribute2%TYPE;
1890: v_pn_proj_attr3 PN_PAYMENT_TERMS.project_attribute3%TYPE;
1891: v_pn_proj_attr4 PN_PAYMENT_TERMS.project_attribute4%TYPE;
1892: v_pn_proj_attr5 PN_PAYMENT_TERMS.project_attribute5%TYPE;

Line 1889: v_pn_proj_attr2 PN_PAYMENT_TERMS.project_attribute2%TYPE;

1885: v_pn_tax_included PN_PAYMENT_TERMS.tax_included%TYPE;
1886: v_pn_salesrep_id PN_PAYMENT_TERMS.salesrep_id%TYPE;
1887: v_pn_proj_attr_catg PN_PAYMENT_TERMS.project_attribute_category%TYPE;
1888: v_pn_proj_attr1 PN_PAYMENT_TERMS.project_attribute1%TYPE;
1889: v_pn_proj_attr2 PN_PAYMENT_TERMS.project_attribute2%TYPE;
1890: v_pn_proj_attr3 PN_PAYMENT_TERMS.project_attribute3%TYPE;
1891: v_pn_proj_attr4 PN_PAYMENT_TERMS.project_attribute4%TYPE;
1892: v_pn_proj_attr5 PN_PAYMENT_TERMS.project_attribute5%TYPE;
1893: v_pn_proj_attr6 PN_PAYMENT_TERMS.project_attribute6%TYPE;

Line 1890: v_pn_proj_attr3 PN_PAYMENT_TERMS.project_attribute3%TYPE;

1886: v_pn_salesrep_id PN_PAYMENT_TERMS.salesrep_id%TYPE;
1887: v_pn_proj_attr_catg PN_PAYMENT_TERMS.project_attribute_category%TYPE;
1888: v_pn_proj_attr1 PN_PAYMENT_TERMS.project_attribute1%TYPE;
1889: v_pn_proj_attr2 PN_PAYMENT_TERMS.project_attribute2%TYPE;
1890: v_pn_proj_attr3 PN_PAYMENT_TERMS.project_attribute3%TYPE;
1891: v_pn_proj_attr4 PN_PAYMENT_TERMS.project_attribute4%TYPE;
1892: v_pn_proj_attr5 PN_PAYMENT_TERMS.project_attribute5%TYPE;
1893: v_pn_proj_attr6 PN_PAYMENT_TERMS.project_attribute6%TYPE;
1894: v_pn_proj_attr7 PN_PAYMENT_TERMS.project_attribute7%TYPE;

Line 1891: v_pn_proj_attr4 PN_PAYMENT_TERMS.project_attribute4%TYPE;

1887: v_pn_proj_attr_catg PN_PAYMENT_TERMS.project_attribute_category%TYPE;
1888: v_pn_proj_attr1 PN_PAYMENT_TERMS.project_attribute1%TYPE;
1889: v_pn_proj_attr2 PN_PAYMENT_TERMS.project_attribute2%TYPE;
1890: v_pn_proj_attr3 PN_PAYMENT_TERMS.project_attribute3%TYPE;
1891: v_pn_proj_attr4 PN_PAYMENT_TERMS.project_attribute4%TYPE;
1892: v_pn_proj_attr5 PN_PAYMENT_TERMS.project_attribute5%TYPE;
1893: v_pn_proj_attr6 PN_PAYMENT_TERMS.project_attribute6%TYPE;
1894: v_pn_proj_attr7 PN_PAYMENT_TERMS.project_attribute7%TYPE;
1895: v_pn_org_id PN_PAYMENT_TERMS.org_id%TYPE;

Line 1892: v_pn_proj_attr5 PN_PAYMENT_TERMS.project_attribute5%TYPE;

1888: v_pn_proj_attr1 PN_PAYMENT_TERMS.project_attribute1%TYPE;
1889: v_pn_proj_attr2 PN_PAYMENT_TERMS.project_attribute2%TYPE;
1890: v_pn_proj_attr3 PN_PAYMENT_TERMS.project_attribute3%TYPE;
1891: v_pn_proj_attr4 PN_PAYMENT_TERMS.project_attribute4%TYPE;
1892: v_pn_proj_attr5 PN_PAYMENT_TERMS.project_attribute5%TYPE;
1893: v_pn_proj_attr6 PN_PAYMENT_TERMS.project_attribute6%TYPE;
1894: v_pn_proj_attr7 PN_PAYMENT_TERMS.project_attribute7%TYPE;
1895: v_pn_org_id PN_PAYMENT_TERMS.org_id%TYPE;
1896: v_pn_description PN_PAYMENT_TERMS.payment_purpose_code%TYPE;

Line 1893: v_pn_proj_attr6 PN_PAYMENT_TERMS.project_attribute6%TYPE;

1889: v_pn_proj_attr2 PN_PAYMENT_TERMS.project_attribute2%TYPE;
1890: v_pn_proj_attr3 PN_PAYMENT_TERMS.project_attribute3%TYPE;
1891: v_pn_proj_attr4 PN_PAYMENT_TERMS.project_attribute4%TYPE;
1892: v_pn_proj_attr5 PN_PAYMENT_TERMS.project_attribute5%TYPE;
1893: v_pn_proj_attr6 PN_PAYMENT_TERMS.project_attribute6%TYPE;
1894: v_pn_proj_attr7 PN_PAYMENT_TERMS.project_attribute7%TYPE;
1895: v_pn_org_id PN_PAYMENT_TERMS.org_id%TYPE;
1896: v_pn_description PN_PAYMENT_TERMS.payment_purpose_code%TYPE;
1897: v_transaction_date PN_PAYMENT_ITEMS.due_date%TYPE;

Line 1894: v_pn_proj_attr7 PN_PAYMENT_TERMS.project_attribute7%TYPE;

1890: v_pn_proj_attr3 PN_PAYMENT_TERMS.project_attribute3%TYPE;
1891: v_pn_proj_attr4 PN_PAYMENT_TERMS.project_attribute4%TYPE;
1892: v_pn_proj_attr5 PN_PAYMENT_TERMS.project_attribute5%TYPE;
1893: v_pn_proj_attr6 PN_PAYMENT_TERMS.project_attribute6%TYPE;
1894: v_pn_proj_attr7 PN_PAYMENT_TERMS.project_attribute7%TYPE;
1895: v_pn_org_id PN_PAYMENT_TERMS.org_id%TYPE;
1896: v_pn_description PN_PAYMENT_TERMS.payment_purpose_code%TYPE;
1897: v_transaction_date PN_PAYMENT_ITEMS.due_date%TYPE;
1898: v_normalize PN_PAYMENT_TERMS.normalize%TYPE;

Line 1895: v_pn_org_id PN_PAYMENT_TERMS.org_id%TYPE;

1891: v_pn_proj_attr4 PN_PAYMENT_TERMS.project_attribute4%TYPE;
1892: v_pn_proj_attr5 PN_PAYMENT_TERMS.project_attribute5%TYPE;
1893: v_pn_proj_attr6 PN_PAYMENT_TERMS.project_attribute6%TYPE;
1894: v_pn_proj_attr7 PN_PAYMENT_TERMS.project_attribute7%TYPE;
1895: v_pn_org_id PN_PAYMENT_TERMS.org_id%TYPE;
1896: v_pn_description PN_PAYMENT_TERMS.payment_purpose_code%TYPE;
1897: v_transaction_date PN_PAYMENT_ITEMS.due_date%TYPE;
1898: v_normalize PN_PAYMENT_TERMS.normalize%TYPE;
1899: v_pn_payment_item_id PN_PAYMENT_ITEMS.payment_item_id%TYPE;

Line 1896: v_pn_description PN_PAYMENT_TERMS.payment_purpose_code%TYPE;

1892: v_pn_proj_attr5 PN_PAYMENT_TERMS.project_attribute5%TYPE;
1893: v_pn_proj_attr6 PN_PAYMENT_TERMS.project_attribute6%TYPE;
1894: v_pn_proj_attr7 PN_PAYMENT_TERMS.project_attribute7%TYPE;
1895: v_pn_org_id PN_PAYMENT_TERMS.org_id%TYPE;
1896: v_pn_description PN_PAYMENT_TERMS.payment_purpose_code%TYPE;
1897: v_transaction_date PN_PAYMENT_ITEMS.due_date%TYPE;
1898: v_normalize PN_PAYMENT_TERMS.normalize%TYPE;
1899: v_pn_payment_item_id PN_PAYMENT_ITEMS.payment_item_id%TYPE;
1900: v_pn_payment_term_id PN_PAYMENT_ITEMS.payment_term_id%TYPE;

Line 1898: v_normalize PN_PAYMENT_TERMS.normalize%TYPE;

1894: v_pn_proj_attr7 PN_PAYMENT_TERMS.project_attribute7%TYPE;
1895: v_pn_org_id PN_PAYMENT_TERMS.org_id%TYPE;
1896: v_pn_description PN_PAYMENT_TERMS.payment_purpose_code%TYPE;
1897: v_transaction_date PN_PAYMENT_ITEMS.due_date%TYPE;
1898: v_normalize PN_PAYMENT_TERMS.normalize%TYPE;
1899: v_pn_payment_item_id PN_PAYMENT_ITEMS.payment_item_id%TYPE;
1900: v_pn_payment_term_id PN_PAYMENT_ITEMS.payment_term_id%TYPE;
1901: v_pn_export_currency_code PN_PAYMENT_ITEMS.export_currency_code%TYPE;
1902: v_pn_export_currency_amount PN_PAYMENT_ITEMS.export_currency_amount%TYPE;

Line 1962: v_pur_code PN_PAYMENT_TERMS.payment_purpose_code%TYPE;

1958: l_conv_rate PN_PAYMENT_ITEMS.rate%TYPE;
1959: v_location_id PN_LOCATIONS.location_id%TYPE;
1960: l_send_flag PN_LEASE_DETAILS_ALL.send_entries%TYPE := 'Y';
1961: l_lease_id NUMBER := 0;
1962: v_pur_code PN_PAYMENT_TERMS.payment_purpose_code%TYPE;
1963: v_pur_type_code PN_PAYMENT_TERMS.payment_term_type_code%TYPE;
1964: l_post_to_gl RA_CUST_TRX_TYPES_ALL.post_to_gl%TYPE;
1965: l_derive_date_flag RA_BATCH_SOURCES.derive_date_flag%TYPE;
1966: l_rule_start_date RA_INTERFACE_LINES.rule_start_date%TYPE := NULL;

Line 1963: v_pur_type_code PN_PAYMENT_TERMS.payment_term_type_code%TYPE;

1959: v_location_id PN_LOCATIONS.location_id%TYPE;
1960: l_send_flag PN_LEASE_DETAILS_ALL.send_entries%TYPE := 'Y';
1961: l_lease_id NUMBER := 0;
1962: v_pur_code PN_PAYMENT_TERMS.payment_purpose_code%TYPE;
1963: v_pur_type_code PN_PAYMENT_TERMS.payment_term_type_code%TYPE;
1964: l_post_to_gl RA_CUST_TRX_TYPES_ALL.post_to_gl%TYPE;
1965: l_derive_date_flag RA_BATCH_SOURCES.derive_date_flag%TYPE;
1966: l_rule_start_date RA_INTERFACE_LINES.rule_start_date%TYPE := NULL;
1967: l_rows_nogrp INTEGER;

Line 1970: v_pn_le_id1 PN_PAYMENT_TERMS_ALL.legal_entity_id%TYPE;

1966: l_rule_start_date RA_INTERFACE_LINES.rule_start_date%TYPE := NULL;
1967: l_rows_nogrp INTEGER;
1968: l_count_nogrp INTEGER;
1969: v_pn_payment_term_id1 PN_PAYMENT_ITEMS_ALL.payment_term_id%TYPE;
1970: v_pn_le_id1 PN_PAYMENT_TERMS_ALL.legal_entity_id%TYPE;
1971: v_pn_customer_id1 PN_PAYMENT_ITEMS_ALL.customer_id%TYPE;
1972: v_pn_trx_type_id1 PN_PAYMENT_TERMS.cust_trx_type_id%TYPE;
1973: v_pn_org_id1 PN_PAYMENT_TERMS_ALL.org_id%TYPE;
1974: v_schedule_date PN_PAYMENT_SCHEDULES_ALL.schedule_date%TYPE;

Line 1972: v_pn_trx_type_id1 PN_PAYMENT_TERMS.cust_trx_type_id%TYPE;

1968: l_count_nogrp INTEGER;
1969: v_pn_payment_term_id1 PN_PAYMENT_ITEMS_ALL.payment_term_id%TYPE;
1970: v_pn_le_id1 PN_PAYMENT_TERMS_ALL.legal_entity_id%TYPE;
1971: v_pn_customer_id1 PN_PAYMENT_ITEMS_ALL.customer_id%TYPE;
1972: v_pn_trx_type_id1 PN_PAYMENT_TERMS.cust_trx_type_id%TYPE;
1973: v_pn_org_id1 PN_PAYMENT_TERMS_ALL.org_id%TYPE;
1974: v_schedule_date PN_PAYMENT_SCHEDULES_ALL.schedule_date%TYPE;
1975:
1976: l_rows_select_nogrp NUMBER;

Line 1973: v_pn_org_id1 PN_PAYMENT_TERMS_ALL.org_id%TYPE;

1969: v_pn_payment_term_id1 PN_PAYMENT_ITEMS_ALL.payment_term_id%TYPE;
1970: v_pn_le_id1 PN_PAYMENT_TERMS_ALL.legal_entity_id%TYPE;
1971: v_pn_customer_id1 PN_PAYMENT_ITEMS_ALL.customer_id%TYPE;
1972: v_pn_trx_type_id1 PN_PAYMENT_TERMS.cust_trx_type_id%TYPE;
1973: v_pn_org_id1 PN_PAYMENT_TERMS_ALL.org_id%TYPE;
1974: v_schedule_date PN_PAYMENT_SCHEDULES_ALL.schedule_date%TYPE;
1975:
1976: l_rows_select_nogrp NUMBER;
1977: l_count_select_nogrp NUMBER;

Line 2061: UPDATE pn_payment_terms_all

2057: END;
2058: END LOOP;
2059:
2060: FORALL i IN term_ar_tbl.FIRST..term_ar_tbl.LAST
2061: UPDATE pn_payment_terms_all
2062: SET legal_entity_id = le_ar_tbl(i)
2063: WHERE payment_term_id = term_ar_tbl(i);
2064:
2065: IF dbms_sql.is_open (g_cursor_select_nogrp) THEN