[Home] [Help]
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,
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,
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;
665: v_normalize PN_PAYMENT_TERMS.normalize%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;
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;
1722: pnp_debug_pkg.log('Updating payment schedules for payment sch id : ' ||
1723: to_char(exp_ar_tbl(l_grp).PN_Payment_Schedule_Id) );
1724:
1725:
1726: UPDATE PN_PAYMENT_SCHEDULES_ALL
1727: SET Transferred_By_User_Id = l_last_updated_by,
1728: Transfer_Date = l_last_update_date
1729: WHERE Payment_Schedule_Id = exp_ar_tbl(l_grp).PN_Payment_Schedule_Id;
1730:
1869: )
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;
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;
1978: TYPE le_ar_tbl_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
2824:
2825: pnp_debug_pkg.log('Updating payment schedules for payment sch id : ' ||
2826: to_char(V_PN_Payment_Schedule_Id) );
2827:
2828: UPDATE PN_PAYMENT_SCHEDULES_ALL
2829: SET Transferred_By_User_Id = l_last_updated_by,
2830: Transfer_Date = l_last_update_date
2831: WHERE Payment_Schedule_Id = V_PN_Payment_Schedule_Id;
2832: