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_ITEMS

Line 243: FROM PN_PAYMENT_ITEMS pi, PN_PAYMENT_SCHEDULES_ALL ps,

239: pn_mo_cache_utils.get_current_org_id)
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,

Line 297: FROM PN_PAYMENT_ITEMS pi, PN_PAYMENT_SCHEDULES_ALL ps,

293: PT.Location_id,
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,

Line 634: v_pn_payment_item_id PN_PAYMENT_ITEMS.payment_item_id%TYPE;

630: l_derive_date_flag RA_BATCH_SOURCES.derive_date_flag%TYPE;
631: l_rule_start_date RA_INTERFACE_LINES.RULE_START_DATE%TYPE := NULL;
632: l_count_grp INTEGER;
633: l_rows_grp INTEGER;
634: v_pn_payment_item_id PN_PAYMENT_ITEMS.payment_item_id%TYPE;
635: v_pn_payment_term_id PN_PAYMENT_ITEMS.payment_term_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;

Line 635: v_pn_payment_term_id PN_PAYMENT_ITEMS.payment_term_id%TYPE;

631: l_rule_start_date RA_INTERFACE_LINES.RULE_START_DATE%TYPE := NULL;
632: l_count_grp INTEGER;
633: l_rows_grp INTEGER;
634: v_pn_payment_item_id PN_PAYMENT_ITEMS.payment_item_id%TYPE;
635: v_pn_payment_term_id PN_PAYMENT_ITEMS.payment_term_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;

Line 636: v_pn_export_currency_code PN_PAYMENT_ITEMS.export_currency_code%TYPE;

632: l_count_grp INTEGER;
633: l_rows_grp INTEGER;
634: v_pn_payment_item_id PN_PAYMENT_ITEMS.payment_item_id%TYPE;
635: v_pn_payment_term_id PN_PAYMENT_ITEMS.payment_term_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;

Line 637: v_pn_export_currency_amount PN_PAYMENT_ITEMS.export_currency_amount%TYPE;

633: l_rows_grp INTEGER;
634: v_pn_payment_item_id PN_PAYMENT_ITEMS.payment_item_id%TYPE;
635: v_pn_payment_term_id PN_PAYMENT_ITEMS.payment_term_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;

Line 638: v_pn_customer_id PN_PAYMENT_ITEMS.customer_id%TYPE;

634: v_pn_payment_item_id PN_PAYMENT_ITEMS.payment_item_id%TYPE;
635: v_pn_payment_term_id PN_PAYMENT_ITEMS.payment_term_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;

Line 639: v_pn_customer_site_use_id PN_PAYMENT_ITEMS.customer_site_use_id%TYPE;

635: v_pn_payment_term_id PN_PAYMENT_ITEMS.payment_term_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;

Line 660: v_pn_payment_schedule_id PN_PAYMENT_ITEMS.payment_schedule_id%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;
663: v_pn_lease_id PN_LEASES.lease_id%TYPE;
664: v_transaction_date PN_PAYMENT_ITEMS.due_date%TYPE;

Line 664: v_transaction_date PN_PAYMENT_ITEMS.due_date%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;
667: v_pn_rate PN_PAYMENT_ITEMS.rate%TYPE;
668: v_location_id PN_LOCATIONS.LOCATION_ID%TYPE;

Line 666: v_pn_accounted_date PN_PAYMENT_ITEMS.accounted_date%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;
670: v_rec_account PN_DISTRIBUTIONS.account_id%TYPE;

Line 667: v_pn_rate PN_PAYMENT_ITEMS.rate%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;
670: v_rec_account PN_DISTRIBUTIONS.account_id%TYPE;
671: v_gl_date RA_CUST_TRX_LINE_GL_DIST.gl_date%TYPE;

Line 673: v_conv_rate PN_PAYMENT_ITEMS.rate%TYPE;

669: v_send_entries PN_LEASE_DETAILS.send_entries%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;

Line 678: v_pn_payment_term_id1 PN_PAYMENT_ITEMS.payment_term_id%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;
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;

Line 680: v_pn_customer_id1 PN_PAYMENT_ITEMS.customer_id%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;
684: l_count_select_grp NUMBER;

Line 1697: UPDATE PN_PAYMENT_ITEMS_ALL

1693: l_context := 'Updating Payment Items';
1694: pnp_debug_pkg.log('Updating payment items for payment item id : ' ||
1695: to_char(exp_ar_tbl(l_grp).pn_payment_item_id) );
1696:
1697: UPDATE PN_PAYMENT_ITEMS_ALL
1698: SET transferred_to_ar_flag = 'Y' ,
1699: ar_ref_code = exp_ar_tbl(l_grp).pn_payment_item_id,
1700: last_updated_by = l_last_updated_by,
1701: last_update_login = l_last_update_login,

Line 1788: from pn_payment_items_all

1784:
1785: FOR i IN 1..l_index_2-1
1786: LOOP
1787: select actual_amount into l_actual_amount
1788: from pn_payment_items_all
1789: where payment_item_id=err_ar_tbl(i).pn_payment_item_id;
1790:
1791: fnd_message.set_name ('PN','PN_LEASE_NUMBER');
1792: l_message := fnd_message.get || ' ' || err_ar_tbl(i).pn_lease_num || ' ';

Line 1897: v_transaction_date PN_PAYMENT_ITEMS.due_date%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;
1901: v_pn_export_currency_code PN_PAYMENT_ITEMS.export_currency_code%TYPE;

Line 1899: v_pn_payment_item_id PN_PAYMENT_ITEMS.payment_item_id%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;
1903: v_pn_customer_id PN_PAYMENT_ITEMS.customer_id%TYPE ;

Line 1900: v_pn_payment_term_id PN_PAYMENT_ITEMS.payment_term_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;
1903: v_pn_customer_id PN_PAYMENT_ITEMS.customer_id%TYPE ;
1904: v_pn_customer_site_use_id PN_PAYMENT_ITEMS.customer_site_use_id%TYPE;

Line 1901: v_pn_export_currency_code PN_PAYMENT_ITEMS.export_currency_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;
1903: v_pn_customer_id PN_PAYMENT_ITEMS.customer_id%TYPE ;
1904: v_pn_customer_site_use_id PN_PAYMENT_ITEMS.customer_site_use_id%TYPE;
1905: v_pn_payment_schedule_id PN_PAYMENT_ITEMS.payment_schedule_id%TYPE;

Line 1902: v_pn_export_currency_amount PN_PAYMENT_ITEMS.export_currency_amount%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;
1903: v_pn_customer_id PN_PAYMENT_ITEMS.customer_id%TYPE ;
1904: v_pn_customer_site_use_id PN_PAYMENT_ITEMS.customer_site_use_id%TYPE;
1905: v_pn_payment_schedule_id PN_PAYMENT_ITEMS.payment_schedule_id%TYPE;
1906: v_pn_accounted_date PN_PAYMENT_ITEMS.accounted_date%TYPE;

Line 1903: v_pn_customer_id PN_PAYMENT_ITEMS.customer_id%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;
1903: v_pn_customer_id PN_PAYMENT_ITEMS.customer_id%TYPE ;
1904: v_pn_customer_site_use_id PN_PAYMENT_ITEMS.customer_site_use_id%TYPE;
1905: v_pn_payment_schedule_id PN_PAYMENT_ITEMS.payment_schedule_id%TYPE;
1906: v_pn_accounted_date PN_PAYMENT_ITEMS.accounted_date%TYPE;
1907: v_pn_rate PN_PAYMENT_ITEMS.rate%TYPE;

Line 1904: v_pn_customer_site_use_id PN_PAYMENT_ITEMS.customer_site_use_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;
1903: v_pn_customer_id PN_PAYMENT_ITEMS.customer_id%TYPE ;
1904: v_pn_customer_site_use_id PN_PAYMENT_ITEMS.customer_site_use_id%TYPE;
1905: v_pn_payment_schedule_id PN_PAYMENT_ITEMS.payment_schedule_id%TYPE;
1906: v_pn_accounted_date PN_PAYMENT_ITEMS.accounted_date%TYPE;
1907: v_pn_rate PN_PAYMENT_ITEMS.rate%TYPE;
1908: l_acnt_cls PN_DISTRIBUTIONS.account_class%TYPE;

Line 1905: v_pn_payment_schedule_id PN_PAYMENT_ITEMS.payment_schedule_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;
1903: v_pn_customer_id PN_PAYMENT_ITEMS.customer_id%TYPE ;
1904: v_pn_customer_site_use_id PN_PAYMENT_ITEMS.customer_site_use_id%TYPE;
1905: v_pn_payment_schedule_id PN_PAYMENT_ITEMS.payment_schedule_id%TYPE;
1906: v_pn_accounted_date PN_PAYMENT_ITEMS.accounted_date%TYPE;
1907: v_pn_rate PN_PAYMENT_ITEMS.rate%TYPE;
1908: l_acnt_cls PN_DISTRIBUTIONS.account_class%TYPE;
1909: l_percent PN_DISTRIBUTIONS.percentage%TYPE;

Line 1906: v_pn_accounted_date PN_PAYMENT_ITEMS.accounted_date%TYPE;

1902: v_pn_export_currency_amount PN_PAYMENT_ITEMS.export_currency_amount%TYPE;
1903: v_pn_customer_id PN_PAYMENT_ITEMS.customer_id%TYPE ;
1904: v_pn_customer_site_use_id PN_PAYMENT_ITEMS.customer_site_use_id%TYPE;
1905: v_pn_payment_schedule_id PN_PAYMENT_ITEMS.payment_schedule_id%TYPE;
1906: v_pn_accounted_date PN_PAYMENT_ITEMS.accounted_date%TYPE;
1907: v_pn_rate PN_PAYMENT_ITEMS.rate%TYPE;
1908: l_acnt_cls PN_DISTRIBUTIONS.account_class%TYPE;
1909: l_percent PN_DISTRIBUTIONS.percentage%TYPE;
1910: l_location_code PN_LOCATIONS.location_code%TYPE;

Line 1907: v_pn_rate PN_PAYMENT_ITEMS.rate%TYPE;

1903: v_pn_customer_id PN_PAYMENT_ITEMS.customer_id%TYPE ;
1904: v_pn_customer_site_use_id PN_PAYMENT_ITEMS.customer_site_use_id%TYPE;
1905: v_pn_payment_schedule_id PN_PAYMENT_ITEMS.payment_schedule_id%TYPE;
1906: v_pn_accounted_date PN_PAYMENT_ITEMS.accounted_date%TYPE;
1907: v_pn_rate PN_PAYMENT_ITEMS.rate%TYPE;
1908: l_acnt_cls PN_DISTRIBUTIONS.account_class%TYPE;
1909: l_percent PN_DISTRIBUTIONS.percentage%TYPE;
1910: l_location_code PN_LOCATIONS.location_code%TYPE;
1911: l_inv_rule_name RA_RULES.name%TYPE;

Line 1958: l_conv_rate PN_PAYMENT_ITEMS.rate%TYPE;

1954: l_set_of_books_id NUMBER := to_number(pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',
1955: pn_mo_cache_utils.get_current_org_id));
1956: l_func_curr_code GL_SETS_OF_BOOKS.currency_code%TYPE;
1957: l_conv_rate_type PN_CURRENCIES.conversion_type%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;

Line 1969: v_pn_payment_term_id1 PN_PAYMENT_ITEMS_ALL.payment_term_id%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;
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;

Line 1971: v_pn_customer_id1 PN_PAYMENT_ITEMS_ALL.customer_id%TYPE;

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;
1975:

Line 2799: UPDATE PN_PAYMENT_ITEMS_ALL

2795: l_context := 'Updating Payment Items';
2796: pnp_debug_pkg.log('Updating payment items for payment item id : ' ||
2797: to_char(v_pn_payment_item_id) );
2798:
2799: UPDATE PN_PAYMENT_ITEMS_ALL
2800: SET transferred_to_ar_flag = 'Y' ,
2801: ar_ref_code = v_pn_payment_item_id,
2802: last_updated_by = l_last_updated_by,
2803: last_update_login = l_last_update_login,

Line 2900: from pn_payment_items_all

2896:
2897: FOR i IN 1..l_index_2-1
2898: LOOP
2899: select actual_amount into l_actual_amount
2900: from pn_payment_items_all
2901: where payment_item_id=err_ar_tbl(i).pn_payment_item_id;
2902:
2903: fnd_message.set_name ('PN','PN_LEASE_NUMBER');
2904: l_message := fnd_message.get || ' ' || err_ar_tbl(i).pn_lease_num || ' ';