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_CREATE_ACC dependencies on PN_PAYMENT_ITEMS

Line 25: PN_PAYMENT_ITEMS_ALL pi,

21: ps.payment_schedule_id,
22: pi1.actual_amount
23: FROM PN_PAYMENT_TERMS pt,
24: PN_LEASES_ALL le ,
25: PN_PAYMENT_ITEMS_ALL pi,
26: PN_PAYMENT_ITEMS_ALL pi1,
27: PN_PAYMENT_SCHEDULES_ALL ps
28: WHERE pt.lease_id = le.lease_id
29: AND le.lease_class_code in ('THIRD_PARTY','SUB_LEASE')

Line 26: PN_PAYMENT_ITEMS_ALL pi1,

22: pi1.actual_amount
23: FROM PN_PAYMENT_TERMS pt,
24: PN_LEASES_ALL le ,
25: PN_PAYMENT_ITEMS_ALL pi,
26: PN_PAYMENT_ITEMS_ALL pi1,
27: PN_PAYMENT_SCHEDULES_ALL ps
28: WHERE pt.lease_id = le.lease_id
29: AND le.lease_class_code in ('THIRD_PARTY','SUB_LEASE')
30: AND LE.LEASE_ID BETWEEN P_LOW_LEASE_ID AND P_HIGH_LEASE_ID

Line 64: PN_PAYMENT_ITEMS_ALL pi,

60: pt.customer_id customer_id,
61: pt.cust_trx_type_id cust_trx_type_id
62: FROM PN_PAYMENT_TERMS pt,
63: PN_LEASES_ALL le ,
64: PN_PAYMENT_ITEMS_ALL pi,
65: PN_PAYMENT_ITEMS_ALL pi1,
66: PN_PAYMENT_SCHEDULES_ALL ps
67: WHERE pt.lease_id = le.lease_id
68: AND le.lease_class_code in ('THIRD_PARTY','SUB_LEASE')

Line 65: PN_PAYMENT_ITEMS_ALL pi1,

61: pt.cust_trx_type_id cust_trx_type_id
62: FROM PN_PAYMENT_TERMS pt,
63: PN_LEASES_ALL le ,
64: PN_PAYMENT_ITEMS_ALL pi,
65: PN_PAYMENT_ITEMS_ALL pi1,
66: PN_PAYMENT_SCHEDULES_ALL ps
67: WHERE pt.lease_id = le.lease_id
68: AND le.lease_class_code in ('THIRD_PARTY','SUB_LEASE')
69: AND LE.LEASE_ID BETWEEN P_LOW_LEASE_ID AND P_HIGH_LEASE_ID

Line 109: pn_payment_items_all pi,

105: ps.payment_schedule_id,
106: pi1.actual_amount
107: FROM pn_payment_terms pt,
108: pn_leases_all le ,
109: pn_payment_items_all pi,
110: pn_payment_items_all pi1,
111: pn_payment_schedules_all ps
112: WHERE pt.lease_id = le.lease_id
113: AND le.lease_class_code = 'DIRECT'

Line 110: pn_payment_items_all pi1,

106: pi1.actual_amount
107: FROM pn_payment_terms pt,
108: pn_leases_all le ,
109: pn_payment_items_all pi,
110: pn_payment_items_all pi1,
111: pn_payment_schedules_all ps
112: WHERE pt.lease_id = le.lease_id
113: AND le.lease_class_code = 'DIRECT'
114: and LE.LEASE_ID BETWEEN P_LOW_LEASE_ID AND P_HIGH_LEASE_ID

Line 149: pn_payment_items_all pi,

145: pt.vendor_id vendor_id,
146: pt.vendor_site_id vendor_site_id
147: FROM pn_payment_terms pt,
148: pn_leases_all le ,
149: pn_payment_items_all pi,
150: pn_payment_items_all pi1,
151: pn_payment_schedules_all ps
152: WHERE pt.lease_id = le.lease_id
153: AND le.lease_class_code = 'DIRECT'

Line 150: pn_payment_items_all pi1,

146: pt.vendor_site_id vendor_site_id
147: FROM pn_payment_terms pt,
148: pn_leases_all le ,
149: pn_payment_items_all pi,
150: pn_payment_items_all pi1,
151: pn_payment_schedules_all ps
152: WHERE pt.lease_id = le.lease_id
153: AND le.lease_class_code = 'DIRECT'
154: AND LE.LEASE_ID BETWEEN P_LOW_LEASE_ID AND P_HIGH_LEASE_ID

Line 188: -- Set transferred_to_ap_flag in PN_PAYMENT_ITEMS

184: -- HISTORY
185: -- 20-JUL-05 ftanudja o Created for SLA uptake #4527233.
186: -- 01-DEC-05 Hareesha o Changes for Lazy upgrade for LE uptake.
187: -- 12-MAY-06 sdmahesh o Bug # 5219481
188: -- Set transferred_to_ap_flag in PN_PAYMENT_ITEMS
189: -- Stamped xla_event_id PN_PAYMENT_ITEMS
190: -- Set transfer related information in PN_PAYMENT_SCHEDULES
191: -- 27-NOV-06 sdmahesh o Changed event_id_tbl_typ to NUMBER
192: -------------------------------------------------------------------------------

Line 189: -- Stamped xla_event_id PN_PAYMENT_ITEMS

185: -- 20-JUL-05 ftanudja o Created for SLA uptake #4527233.
186: -- 01-DEC-05 Hareesha o Changes for Lazy upgrade for LE uptake.
187: -- 12-MAY-06 sdmahesh o Bug # 5219481
188: -- Set transferred_to_ap_flag in PN_PAYMENT_ITEMS
189: -- Stamped xla_event_id PN_PAYMENT_ITEMS
190: -- Set transfer related information in PN_PAYMENT_SCHEDULES
191: -- 27-NOV-06 sdmahesh o Changed event_id_tbl_typ to NUMBER
192: -------------------------------------------------------------------------------
193:

Line 217: TYPE item_id_tbl_typ IS TABLE OF pn_payment_items_all.payment_item_id%TYPE INDEX BY BINARY_INTEGER;

213: l_last_update_date DATE;
214: l_creation_date DATE;
215:
216: TYPE NUMBER_tbl_typ IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
217: TYPE item_id_tbl_typ IS TABLE OF pn_payment_items_all.payment_item_id%TYPE INDEX BY BINARY_INTEGER;
218: TYPE schedule_id_tbl_typ IS TABLE OF pn_payment_schedules_all.payment_schedule_id%TYPE INDEX BY BINARY_INTEGER;
219: TYPE event_id_tbl_typ IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
220:
221: term_ID_tbl NUMBER_tbl_typ;

Line 356: UPDATE pn_payment_items_all

352:
353: pnp_debug_pkg.log('Updating payment items');
354:
355: FORALL i IN item_id_tbl.FIRST..item_id_tbl.LAST
356: UPDATE pn_payment_items_all
357: SET transferred_to_ap_flag = 'Y',
358: xla_event_id = event_id_tbl(i),
359: last_updated_by = l_last_updated_by,
360: last_update_login = l_last_update_login,

Line 410: UPDATE pn_payment_items_all

406:
407: IF item_id_tbl.COUNT > 0 THEN
408:
409: FORALL i IN item_id_tbl.FIRST..item_id_tbl.LAST
410: UPDATE pn_payment_items_all
411: SET transferred_to_ap_flag = 'Y' ,
412: xla_event_id = event_id_tbl(i),
413: last_updated_by = l_last_updated_by,
414: last_update_login = l_last_update_login,

Line 465: -- Set transferred_to_ar_flag in PN_PAYMENT_ITEMS

461: -- 01-DEC-05 Hareesha o Passed pn_mo_cache_utils.get_current_org_id
462: -- while inserting
463: -- 01-DEC-05 Hareesha o Changes for Lazy upgrade for LE uptake.
464: -- 12-MAY-06 sdmahesh o Bug # 5219481
465: -- Set transferred_to_ar_flag in PN_PAYMENT_ITEMS
466: -- Stamped xla_event_id PN_PAYMENT_ITEMS
467: -- Set transfer related information in PN_PAYMENT_SCHEDULES
468: -- 27-NOV-06 sdmahesh o Changed event_id_tbl_typ to NUMBER
469: -------------------------------------------------------------------------------

Line 466: -- Stamped xla_event_id PN_PAYMENT_ITEMS

462: -- while inserting
463: -- 01-DEC-05 Hareesha o Changes for Lazy upgrade for LE uptake.
464: -- 12-MAY-06 sdmahesh o Bug # 5219481
465: -- Set transferred_to_ar_flag in PN_PAYMENT_ITEMS
466: -- Stamped xla_event_id PN_PAYMENT_ITEMS
467: -- Set transfer related information in PN_PAYMENT_SCHEDULES
468: -- 27-NOV-06 sdmahesh o Changed event_id_tbl_typ to NUMBER
469: -------------------------------------------------------------------------------
470:

Line 486: TYPE item_id_tbl_typ IS TABLE OF pn_payment_items_all.payment_item_id%TYPE INDEX BY BINARY_INTEGER;

482: l_high_lease_id pn_leases.lease_id%TYPE;
483: l_sch_start_date pn_payment_schedules.schedule_date%TYPE;
484: l_sch_end_date pn_payment_schedules.schedule_date%TYPE;
485:
486: TYPE item_id_tbl_typ IS TABLE OF pn_payment_items_all.payment_item_id%TYPE INDEX BY BINARY_INTEGER;
487: TYPE schedule_id_tbl_typ IS TABLE OF pn_payment_schedules_all.payment_schedule_id%TYPE INDEX BY BINARY_INTEGER;
488: TYPE NUMBER_tbl_typ IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
489: TYPE event_id_tbl_typ IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
490:

Line 625: UPDATE pn_payment_items_all

621:
622: pnp_debug_pkg.log('Updating payment items');
623:
624: FORALL i IN item_id_tbl.FIRST..item_id_tbl.LAST
625: UPDATE pn_payment_items_all
626: SET transferred_to_ar_flag = 'Y' ,
627: xla_event_id = event_id_tbl(i),
628: last_updated_by = l_last_updated_by,
629: last_update_login = l_last_update_login,

Line 680: UPDATE pn_payment_items_all

676:
677: IF item_id_tbl.COUNT > 0 THEN
678:
679: FORALL i IN item_id_tbl.FIRST..item_id_tbl.LAST
680: UPDATE pn_payment_items_all
681: SET transferred_to_ar_flag = 'Y' ,
682: xla_event_id = event_id_tbl(i),
683: last_updated_by = l_last_updated_by,
684: last_update_login = l_last_update_login,

Line 1064: v_transaction_date PN_PAYMENT_ITEMS.due_date%TYPE;

1060: v_pn_period_name PN_PAYMENT_SCHEDULES.period_name%TYPE;
1061: v_pn_code_combination_id PN_PAYMENT_TERMS.code_combination_id%TYPE;
1062: v_pn_term_id PN_PAYMENT_TERMS.ap_ar_term_id%TYPE;
1063: v_pn_trx_type_id PN_PAYMENT_TERMS.cust_trx_type_id%TYPE;
1064: v_transaction_date PN_PAYMENT_ITEMS.due_date%TYPE;
1065: v_normalize PN_PAYMENT_TERMS.normalize%type;
1066: v_pn_payment_item_id PN_PAYMENT_ITEMS.payment_item_id%TYPE;
1067: v_pn_payment_term_id PN_PAYMENT_ITEMS.payment_term_id%TYPE;
1068: v_pn_currency_code PN_PAYMENT_ITEMS.currency_code%TYPE;

Line 1066: v_pn_payment_item_id PN_PAYMENT_ITEMS.payment_item_id%TYPE;

1062: v_pn_term_id PN_PAYMENT_TERMS.ap_ar_term_id%TYPE;
1063: v_pn_trx_type_id PN_PAYMENT_TERMS.cust_trx_type_id%TYPE;
1064: v_transaction_date PN_PAYMENT_ITEMS.due_date%TYPE;
1065: v_normalize PN_PAYMENT_TERMS.normalize%type;
1066: v_pn_payment_item_id PN_PAYMENT_ITEMS.payment_item_id%TYPE;
1067: v_pn_payment_term_id PN_PAYMENT_ITEMS.payment_term_id%TYPE;
1068: v_pn_currency_code PN_PAYMENT_ITEMS.currency_code%TYPE;
1069: v_pn_export_currency_code PN_PAYMENT_ITEMS.export_currency_code%TYPE;
1070: v_pn_export_currency_amount PN_PAYMENT_ITEMS.export_currency_amount%TYPE;

Line 1067: v_pn_payment_term_id PN_PAYMENT_ITEMS.payment_term_id%TYPE;

1063: v_pn_trx_type_id PN_PAYMENT_TERMS.cust_trx_type_id%TYPE;
1064: v_transaction_date PN_PAYMENT_ITEMS.due_date%TYPE;
1065: v_normalize PN_PAYMENT_TERMS.normalize%type;
1066: v_pn_payment_item_id PN_PAYMENT_ITEMS.payment_item_id%TYPE;
1067: v_pn_payment_term_id PN_PAYMENT_ITEMS.payment_term_id%TYPE;
1068: v_pn_currency_code PN_PAYMENT_ITEMS.currency_code%TYPE;
1069: v_pn_export_currency_code PN_PAYMENT_ITEMS.export_currency_code%TYPE;
1070: v_pn_export_currency_amount PN_PAYMENT_ITEMS.export_currency_amount%TYPE;
1071: v_pn_payment_schedule_id PN_PAYMENT_ITEMS.payment_schedule_id%TYPE;

Line 1068: v_pn_currency_code PN_PAYMENT_ITEMS.currency_code%TYPE;

1064: v_transaction_date PN_PAYMENT_ITEMS.due_date%TYPE;
1065: v_normalize PN_PAYMENT_TERMS.normalize%type;
1066: v_pn_payment_item_id PN_PAYMENT_ITEMS.payment_item_id%TYPE;
1067: v_pn_payment_term_id PN_PAYMENT_ITEMS.payment_term_id%TYPE;
1068: v_pn_currency_code PN_PAYMENT_ITEMS.currency_code%TYPE;
1069: v_pn_export_currency_code PN_PAYMENT_ITEMS.export_currency_code%TYPE;
1070: v_pn_export_currency_amount PN_PAYMENT_ITEMS.export_currency_amount%TYPE;
1071: v_pn_payment_schedule_id PN_PAYMENT_ITEMS.payment_schedule_id%TYPE;
1072: v_pn_accounted_date PN_PAYMENT_ITEMS.accounted_date%TYPE;

Line 1069: v_pn_export_currency_code PN_PAYMENT_ITEMS.export_currency_code%TYPE;

1065: v_normalize PN_PAYMENT_TERMS.normalize%type;
1066: v_pn_payment_item_id PN_PAYMENT_ITEMS.payment_item_id%TYPE;
1067: v_pn_payment_term_id PN_PAYMENT_ITEMS.payment_term_id%TYPE;
1068: v_pn_currency_code PN_PAYMENT_ITEMS.currency_code%TYPE;
1069: v_pn_export_currency_code PN_PAYMENT_ITEMS.export_currency_code%TYPE;
1070: v_pn_export_currency_amount PN_PAYMENT_ITEMS.export_currency_amount%TYPE;
1071: v_pn_payment_schedule_id PN_PAYMENT_ITEMS.payment_schedule_id%TYPE;
1072: v_pn_accounted_date PN_PAYMENT_ITEMS.accounted_date%TYPE;
1073: v_pn_rate PN_PAYMENT_ITEMS.rate%TYPE;

Line 1070: v_pn_export_currency_amount PN_PAYMENT_ITEMS.export_currency_amount%TYPE;

1066: v_pn_payment_item_id PN_PAYMENT_ITEMS.payment_item_id%TYPE;
1067: v_pn_payment_term_id PN_PAYMENT_ITEMS.payment_term_id%TYPE;
1068: v_pn_currency_code PN_PAYMENT_ITEMS.currency_code%TYPE;
1069: v_pn_export_currency_code PN_PAYMENT_ITEMS.export_currency_code%TYPE;
1070: v_pn_export_currency_amount PN_PAYMENT_ITEMS.export_currency_amount%TYPE;
1071: v_pn_payment_schedule_id PN_PAYMENT_ITEMS.payment_schedule_id%TYPE;
1072: v_pn_accounted_date PN_PAYMENT_ITEMS.accounted_date%TYPE;
1073: v_pn_rate PN_PAYMENT_ITEMS.rate%TYPE;
1074: l_amt NUMBER;

Line 1071: v_pn_payment_schedule_id PN_PAYMENT_ITEMS.payment_schedule_id%TYPE;

1067: v_pn_payment_term_id PN_PAYMENT_ITEMS.payment_term_id%TYPE;
1068: v_pn_currency_code PN_PAYMENT_ITEMS.currency_code%TYPE;
1069: v_pn_export_currency_code PN_PAYMENT_ITEMS.export_currency_code%TYPE;
1070: v_pn_export_currency_amount PN_PAYMENT_ITEMS.export_currency_amount%TYPE;
1071: v_pn_payment_schedule_id PN_PAYMENT_ITEMS.payment_schedule_id%TYPE;
1072: v_pn_accounted_date PN_PAYMENT_ITEMS.accounted_date%TYPE;
1073: v_pn_rate PN_PAYMENT_ITEMS.rate%TYPE;
1074: l_amt NUMBER;
1075: l_prior_payment_schedule_id NUMBER := -999;

Line 1072: v_pn_accounted_date PN_PAYMENT_ITEMS.accounted_date%TYPE;

1068: v_pn_currency_code PN_PAYMENT_ITEMS.currency_code%TYPE;
1069: v_pn_export_currency_code PN_PAYMENT_ITEMS.export_currency_code%TYPE;
1070: v_pn_export_currency_amount PN_PAYMENT_ITEMS.export_currency_amount%TYPE;
1071: v_pn_payment_schedule_id PN_PAYMENT_ITEMS.payment_schedule_id%TYPE;
1072: v_pn_accounted_date PN_PAYMENT_ITEMS.accounted_date%TYPE;
1073: v_pn_rate PN_PAYMENT_ITEMS.rate%TYPE;
1074: l_amt NUMBER;
1075: l_prior_payment_schedule_id NUMBER := -999;
1076: l_created_by NUMBER := FND_GLOBAL.user_id;

Line 1073: v_pn_rate PN_PAYMENT_ITEMS.rate%TYPE;

1069: v_pn_export_currency_code PN_PAYMENT_ITEMS.export_currency_code%TYPE;
1070: v_pn_export_currency_amount PN_PAYMENT_ITEMS.export_currency_amount%TYPE;
1071: v_pn_payment_schedule_id PN_PAYMENT_ITEMS.payment_schedule_id%TYPE;
1072: v_pn_accounted_date PN_PAYMENT_ITEMS.accounted_date%TYPE;
1073: v_pn_rate PN_PAYMENT_ITEMS.rate%TYPE;
1074: l_amt NUMBER;
1075: l_prior_payment_schedule_id NUMBER := -999;
1076: l_created_by NUMBER := FND_GLOBAL.user_id;
1077: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;

Line 1168: PN_PAYMENT_ITEMS_ALL pi,

1164: pi1.actual_amount,
1165: ps.schedule_date
1166: FROM PN_PAYMENT_TERMS pt,
1167: PN_LEASES_ALL le ,
1168: PN_PAYMENT_ITEMS_ALL pi,
1169: PN_PAYMENT_ITEMS_ALL pi1,
1170: PN_PAYMENT_SCHEDULES_ALL ps
1171: WHERE pt.lease_id = le.lease_id
1172: AND le.lease_class_code in ('THIRD_PARTY','SUB_LEASE')

Line 1169: PN_PAYMENT_ITEMS_ALL pi1,

1165: ps.schedule_date
1166: FROM PN_PAYMENT_TERMS pt,
1167: PN_LEASES_ALL le ,
1168: PN_PAYMENT_ITEMS_ALL pi,
1169: PN_PAYMENT_ITEMS_ALL pi1,
1170: PN_PAYMENT_SCHEDULES_ALL ps
1171: WHERE pt.lease_id = le.lease_id
1172: AND le.lease_class_code in ('THIRD_PARTY','SUB_LEASE')
1173: AND LE.LEASE_ID BETWEEN L_LOW_LEASE_ID AND L_HIGH_LEASE_ID

Line 1594: 'PN_PAYMENT_ITEMS',

1590: null,
1591: l_amt,
1592: null,
1593: l_accounted_amt,
1594: 'PN_PAYMENT_ITEMS',
1595: V_PN_PAYMENT_ITEM_ID,
1596: l_line_desc,
1597: NULL,
1598: pn_mo_cache_utils.get_current_org_id,

Line 1707: 'PN_PAYMENT_ITEMS',

1703: l_amt,
1704: null,
1705: l_accounted_amt,
1706: null,
1707: 'PN_PAYMENT_ITEMS',
1708: V_PN_PAYMENT_ITEM_ID,
1709: l_line_desc,
1710: null,
1711: pn_mo_cache_utils.get_current_org_id,

Line 1731: UPDATE pn_payment_items_all

1727: l_context := 'Updating Payment Items';
1728: pnp_debug_pkg.log('Updating payment items for payment item id : ' ||
1729: to_char(v_pn_payment_item_id) );
1730:
1731: UPDATE pn_payment_items_all
1732: SET transferred_to_ar_flag = 'Y' ,
1733: ar_ref_code = v_pn_payment_item_id,
1734: last_updated_by = l_last_updated_by,
1735: last_update_login = l_last_update_login,

Line 1817: v_transaction_date PN_PAYMENT_ITEMS.due_date%TYPE;

1813: v_pn_period_name PN_PAYMENT_SCHEDULES.period_name%TYPE;
1814: v_pn_code_combination_id PN_PAYMENT_TERMS.code_combination_id%TYPE;
1815: v_pn_distribution_set_id pn_payment_terms.distribution_set_id%TYPE;
1816: v_pn_project_id pn_payment_terms.project_id%type;
1817: v_transaction_date PN_PAYMENT_ITEMS.due_date%TYPE;
1818: v_normalize PN_PAYMENT_TERMS.normalize%type;
1819: v_pn_payment_item_id PN_PAYMENT_ITEMS.payment_item_id%TYPE;
1820: v_pn_payment_term_id PN_PAYMENT_ITEMS.payment_term_id%TYPE;
1821: v_pn_currency_code PN_PAYMENT_ITEMS.currency_code%TYPE;

Line 1819: v_pn_payment_item_id PN_PAYMENT_ITEMS.payment_item_id%TYPE;

1815: v_pn_distribution_set_id pn_payment_terms.distribution_set_id%TYPE;
1816: v_pn_project_id pn_payment_terms.project_id%type;
1817: v_transaction_date PN_PAYMENT_ITEMS.due_date%TYPE;
1818: v_normalize PN_PAYMENT_TERMS.normalize%type;
1819: v_pn_payment_item_id PN_PAYMENT_ITEMS.payment_item_id%TYPE;
1820: v_pn_payment_term_id PN_PAYMENT_ITEMS.payment_term_id%TYPE;
1821: v_pn_currency_code PN_PAYMENT_ITEMS.currency_code%TYPE;
1822: v_pn_export_currency_code PN_PAYMENT_ITEMS.export_currency_code%TYPE;
1823: v_pn_export_currency_amount PN_PAYMENT_ITEMS.export_currency_amount%TYPE;

Line 1820: v_pn_payment_term_id PN_PAYMENT_ITEMS.payment_term_id%TYPE;

1816: v_pn_project_id pn_payment_terms.project_id%type;
1817: v_transaction_date PN_PAYMENT_ITEMS.due_date%TYPE;
1818: v_normalize PN_PAYMENT_TERMS.normalize%type;
1819: v_pn_payment_item_id PN_PAYMENT_ITEMS.payment_item_id%TYPE;
1820: v_pn_payment_term_id PN_PAYMENT_ITEMS.payment_term_id%TYPE;
1821: v_pn_currency_code PN_PAYMENT_ITEMS.currency_code%TYPE;
1822: v_pn_export_currency_code PN_PAYMENT_ITEMS.export_currency_code%TYPE;
1823: v_pn_export_currency_amount PN_PAYMENT_ITEMS.export_currency_amount%TYPE;
1824: v_pn_payment_schedule_id PN_PAYMENT_ITEMS.payment_schedule_id%TYPE;

Line 1821: v_pn_currency_code PN_PAYMENT_ITEMS.currency_code%TYPE;

1817: v_transaction_date PN_PAYMENT_ITEMS.due_date%TYPE;
1818: v_normalize PN_PAYMENT_TERMS.normalize%type;
1819: v_pn_payment_item_id PN_PAYMENT_ITEMS.payment_item_id%TYPE;
1820: v_pn_payment_term_id PN_PAYMENT_ITEMS.payment_term_id%TYPE;
1821: v_pn_currency_code PN_PAYMENT_ITEMS.currency_code%TYPE;
1822: v_pn_export_currency_code PN_PAYMENT_ITEMS.export_currency_code%TYPE;
1823: v_pn_export_currency_amount PN_PAYMENT_ITEMS.export_currency_amount%TYPE;
1824: v_pn_payment_schedule_id PN_PAYMENT_ITEMS.payment_schedule_id%TYPE;
1825: v_pn_accounted_date PN_PAYMENT_ITEMS.accounted_date%TYPE;

Line 1822: v_pn_export_currency_code PN_PAYMENT_ITEMS.export_currency_code%TYPE;

1818: v_normalize PN_PAYMENT_TERMS.normalize%type;
1819: v_pn_payment_item_id PN_PAYMENT_ITEMS.payment_item_id%TYPE;
1820: v_pn_payment_term_id PN_PAYMENT_ITEMS.payment_term_id%TYPE;
1821: v_pn_currency_code PN_PAYMENT_ITEMS.currency_code%TYPE;
1822: v_pn_export_currency_code PN_PAYMENT_ITEMS.export_currency_code%TYPE;
1823: v_pn_export_currency_amount PN_PAYMENT_ITEMS.export_currency_amount%TYPE;
1824: v_pn_payment_schedule_id PN_PAYMENT_ITEMS.payment_schedule_id%TYPE;
1825: v_pn_accounted_date PN_PAYMENT_ITEMS.accounted_date%TYPE;
1826: v_pn_rate PN_PAYMENT_ITEMS.rate%TYPE;

Line 1823: v_pn_export_currency_amount PN_PAYMENT_ITEMS.export_currency_amount%TYPE;

1819: v_pn_payment_item_id PN_PAYMENT_ITEMS.payment_item_id%TYPE;
1820: v_pn_payment_term_id PN_PAYMENT_ITEMS.payment_term_id%TYPE;
1821: v_pn_currency_code PN_PAYMENT_ITEMS.currency_code%TYPE;
1822: v_pn_export_currency_code PN_PAYMENT_ITEMS.export_currency_code%TYPE;
1823: v_pn_export_currency_amount PN_PAYMENT_ITEMS.export_currency_amount%TYPE;
1824: v_pn_payment_schedule_id PN_PAYMENT_ITEMS.payment_schedule_id%TYPE;
1825: v_pn_accounted_date PN_PAYMENT_ITEMS.accounted_date%TYPE;
1826: v_pn_rate PN_PAYMENT_ITEMS.rate%TYPE;
1827: l_amt NUMBER;

Line 1824: v_pn_payment_schedule_id PN_PAYMENT_ITEMS.payment_schedule_id%TYPE;

1820: v_pn_payment_term_id PN_PAYMENT_ITEMS.payment_term_id%TYPE;
1821: v_pn_currency_code PN_PAYMENT_ITEMS.currency_code%TYPE;
1822: v_pn_export_currency_code PN_PAYMENT_ITEMS.export_currency_code%TYPE;
1823: v_pn_export_currency_amount PN_PAYMENT_ITEMS.export_currency_amount%TYPE;
1824: v_pn_payment_schedule_id PN_PAYMENT_ITEMS.payment_schedule_id%TYPE;
1825: v_pn_accounted_date PN_PAYMENT_ITEMS.accounted_date%TYPE;
1826: v_pn_rate PN_PAYMENT_ITEMS.rate%TYPE;
1827: l_amt NUMBER;
1828: l_prior_payment_schedule_id NUMBER := -999;

Line 1825: v_pn_accounted_date PN_PAYMENT_ITEMS.accounted_date%TYPE;

1821: v_pn_currency_code PN_PAYMENT_ITEMS.currency_code%TYPE;
1822: v_pn_export_currency_code PN_PAYMENT_ITEMS.export_currency_code%TYPE;
1823: v_pn_export_currency_amount PN_PAYMENT_ITEMS.export_currency_amount%TYPE;
1824: v_pn_payment_schedule_id PN_PAYMENT_ITEMS.payment_schedule_id%TYPE;
1825: v_pn_accounted_date PN_PAYMENT_ITEMS.accounted_date%TYPE;
1826: v_pn_rate PN_PAYMENT_ITEMS.rate%TYPE;
1827: l_amt NUMBER;
1828: l_prior_payment_schedule_id NUMBER := -999;
1829: l_created_by NUMBER := FND_GLOBAL.user_id;

Line 1826: v_pn_rate PN_PAYMENT_ITEMS.rate%TYPE;

1822: v_pn_export_currency_code PN_PAYMENT_ITEMS.export_currency_code%TYPE;
1823: v_pn_export_currency_amount PN_PAYMENT_ITEMS.export_currency_amount%TYPE;
1824: v_pn_payment_schedule_id PN_PAYMENT_ITEMS.payment_schedule_id%TYPE;
1825: v_pn_accounted_date PN_PAYMENT_ITEMS.accounted_date%TYPE;
1826: v_pn_rate PN_PAYMENT_ITEMS.rate%TYPE;
1827: l_amt NUMBER;
1828: l_prior_payment_schedule_id NUMBER := -999;
1829: l_created_by NUMBER := FND_GLOBAL.user_id;
1830: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;

Line 1921: pn_payment_items_all pi,

1917: pi1.actual_amount,
1918: ps.schedule_date
1919: FROM pn_payment_terms pt,
1920: pn_leases_all le ,
1921: pn_payment_items_all pi,
1922: pn_payment_items_all pi1,
1923: pn_payment_schedules_all ps
1924: WHERE pt.lease_id = le.lease_id
1925: AND le.lease_class_code = 'DIRECT'

Line 1922: pn_payment_items_all pi1,

1918: ps.schedule_date
1919: FROM pn_payment_terms pt,
1920: pn_leases_all le ,
1921: pn_payment_items_all pi,
1922: pn_payment_items_all pi1,
1923: pn_payment_schedules_all ps
1924: WHERE pt.lease_id = le.lease_id
1925: AND le.lease_class_code = 'DIRECT'
1926: and LE.LEASE_ID BETWEEN L_LOW_LEASE_ID AND L_HIGH_LEASE_ID

Line 2354: 'PN_PAYMENT_ITEMS',

2350: l_amt,
2351: null,
2352: l_accounted_amt,
2353: null,
2354: 'PN_PAYMENT_ITEMS',
2355: V_PN_PAYMENT_ITEM_ID,
2356: l_line_desc,
2357: NULL,
2358: pn_mo_cache_utils.get_current_org_id,

Line 2469: 'PN_PAYMENT_ITEMS',

2465: NULL,
2466: l_amt,
2467: NULL,
2468: l_accounted_amt,
2469: 'PN_PAYMENT_ITEMS',
2470: V_PN_PAYMENT_ITEM_ID,
2471: l_line_desc,
2472: NULL,
2473: pn_mo_cache_utils.get_current_org_id,

Line 2493: UPDATE pn_payment_items_all

2489: l_context := 'Updating Payment Items';
2490: pnp_debug_pkg.log('Updating payment items for payment item id : ' ||
2491: to_char(v_pn_payment_item_id) );
2492:
2493: UPDATE pn_payment_items_all
2494: SET transferred_to_ap_flag = 'Y' ,
2495: last_updated_by = l_last_updated_by,
2496: last_update_login = l_last_update_login,
2497: last_update_date = l_last_update_date