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 29: PN_PAYMENT_ITEMS_ALL pi,

25: pi.export_currency_code,
26: pi.accounted_amount
27: FROM PN_PAYMENT_TERMS pt,
28: PN_LEASES_ALL le ,
29: PN_PAYMENT_ITEMS_ALL pi,
30: PN_PAYMENT_ITEMS_ALL pi1,
31: PN_PAYMENT_SCHEDULES_ALL ps
32: WHERE pt.lease_id = le.lease_id
33: AND le.lease_class_code in ('THIRD_PARTY','SUB_LEASE')

Line 30: PN_PAYMENT_ITEMS_ALL pi1,

26: pi.accounted_amount
27: FROM PN_PAYMENT_TERMS pt,
28: PN_LEASES_ALL le ,
29: PN_PAYMENT_ITEMS_ALL pi,
30: PN_PAYMENT_ITEMS_ALL pi1,
31: PN_PAYMENT_SCHEDULES_ALL ps
32: WHERE pt.lease_id = le.lease_id
33: AND le.lease_class_code in ('THIRD_PARTY','SUB_LEASE')
34: AND LE.LEASE_ID BETWEEN P_LOW_LEASE_ID AND P_HIGH_LEASE_ID

Line 68: PN_PAYMENT_ITEMS_ALL pi,

64: pt.customer_id customer_id,
65: pt.cust_trx_type_id cust_trx_type_id
66: FROM PN_PAYMENT_TERMS pt,
67: PN_LEASES_ALL le ,
68: PN_PAYMENT_ITEMS_ALL pi,
69: PN_PAYMENT_ITEMS_ALL pi1,
70: PN_PAYMENT_SCHEDULES_ALL ps
71: WHERE pt.lease_id = le.lease_id
72: AND le.lease_class_code in ('THIRD_PARTY','SUB_LEASE')

Line 69: PN_PAYMENT_ITEMS_ALL pi1,

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

Line 116: pn_payment_items_all pi,

112: pi.export_currency_code,
113: pi.accounted_amount
114: FROM pn_payment_terms pt,
115: pn_leases_all le ,
116: pn_payment_items_all pi,
117: pn_payment_items_all pi1,
118: pn_payment_schedules_all ps
119: WHERE pt.lease_id = le.lease_id
120: AND le.lease_class_code = 'DIRECT'

Line 117: pn_payment_items_all pi1,

113: pi.accounted_amount
114: FROM pn_payment_terms pt,
115: pn_leases_all le ,
116: pn_payment_items_all pi,
117: pn_payment_items_all pi1,
118: pn_payment_schedules_all ps
119: WHERE pt.lease_id = le.lease_id
120: AND le.lease_class_code = 'DIRECT'
121: and LE.LEASE_ID BETWEEN P_LOW_LEASE_ID AND P_HIGH_LEASE_ID

Line 156: pn_payment_items_all pi,

152: pt.vendor_id vendor_id,
153: pt.vendor_site_id vendor_site_id
154: FROM pn_payment_terms pt,
155: pn_leases_all le ,
156: pn_payment_items_all pi,
157: pn_payment_items_all pi1,
158: pn_payment_schedules_all ps
159: WHERE pt.lease_id = le.lease_id
160: AND le.lease_class_code = 'DIRECT'

Line 157: pn_payment_items_all pi1,

153: pt.vendor_site_id vendor_site_id
154: FROM pn_payment_terms pt,
155: pn_leases_all le ,
156: pn_payment_items_all pi,
157: pn_payment_items_all pi1,
158: pn_payment_schedules_all ps
159: WHERE pt.lease_id = le.lease_id
160: AND le.lease_class_code = 'DIRECT'
161: AND LE.LEASE_ID BETWEEN P_LOW_LEASE_ID AND P_HIGH_LEASE_ID

Line 363: p_export_currency_code PN_PAYMENT_ITEMS.export_currency_code%TYPE)

359: procedure distribute_amount(p_payment_item_id IN NUMBER,
360: p_payment_term_id IN NUMBER,
361: p_accounted_amount IN NUMBER,
362: p_export_currency_amount IN NUMBER,
363: p_export_currency_code PN_PAYMENT_ITEMS.export_currency_code%TYPE)
364: IS
365: CURSOR get_acnt_info(p_term_id NUMBER) IS
366: SELECT account_id,
367: account_class,

Line 611: -- Set transferred_to_ap_flag in PN_PAYMENT_ITEMS

607: -- HISTORY
608: -- 20-JUL-05 ftanudja o Created for SLA uptake #4527233.
609: -- 01-DEC-05 Hareesha o Changes for Lazy upgrade for LE uptake.
610: -- 12-MAY-06 sdmahesh o Bug # 5219481
611: -- Set transferred_to_ap_flag in PN_PAYMENT_ITEMS
612: -- Stamped xla_event_id PN_PAYMENT_ITEMS
613: -- Set transfer related information in PN_PAYMENT_SCHEDULES
614: -- 27-NOV-06 sdmahesh o Changed event_id_tbl_typ to NUMBER
615: -------------------------------------------------------------------------------

Line 612: -- Stamped xla_event_id PN_PAYMENT_ITEMS

608: -- 20-JUL-05 ftanudja o Created for SLA uptake #4527233.
609: -- 01-DEC-05 Hareesha o Changes for Lazy upgrade for LE uptake.
610: -- 12-MAY-06 sdmahesh o Bug # 5219481
611: -- Set transferred_to_ap_flag in PN_PAYMENT_ITEMS
612: -- Stamped xla_event_id PN_PAYMENT_ITEMS
613: -- Set transfer related information in PN_PAYMENT_SCHEDULES
614: -- 27-NOV-06 sdmahesh o Changed event_id_tbl_typ to NUMBER
615: -------------------------------------------------------------------------------
616:

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

637: l_creation_date DATE;
638: l_due_date DATE;
639:
640: TYPE NUMBER_tbl_typ IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
641: TYPE item_id_tbl_typ IS TABLE OF pn_payment_items_all.payment_item_id%TYPE INDEX BY BINARY_INTEGER;
642: TYPE schedule_id_tbl_typ IS TABLE OF pn_payment_schedules_all.payment_schedule_id%TYPE INDEX BY BINARY_INTEGER;
643: TYPE event_id_tbl_typ IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
644:
645: term_ID_tbl NUMBER_tbl_typ;

Line 801: UPDATE pn_payment_items_all

797:
798: pnp_debug_pkg.log('Updating payment items');
799:
800: FORALL i IN item_id_tbl.FIRST..item_id_tbl.LAST
801: UPDATE pn_payment_items_all
802: SET transferred_to_ap_flag = 'Y',
803: xla_event_id = event_id_tbl(i),
804: last_updated_by = l_last_updated_by,
805: last_update_login = l_last_update_login,

Line 856: UPDATE pn_payment_items_all

852:
853: IF item_id_tbl.COUNT > 0 THEN
854:
855: FORALL i IN item_id_tbl.FIRST..item_id_tbl.LAST
856: UPDATE pn_payment_items_all
857: SET transferred_to_ap_flag = 'Y' ,
858: xla_event_id = event_id_tbl(i),
859: last_updated_by = l_last_updated_by,
860: last_update_login = l_last_update_login,

Line 911: -- Set transferred_to_ar_flag in PN_PAYMENT_ITEMS

907: -- 01-DEC-05 Hareesha o Passed pn_mo_cache_utils.get_current_org_id
908: -- while inserting
909: -- 01-DEC-05 Hareesha o Changes for Lazy upgrade for LE uptake.
910: -- 12-MAY-06 sdmahesh o Bug # 5219481
911: -- Set transferred_to_ar_flag in PN_PAYMENT_ITEMS
912: -- Stamped xla_event_id PN_PAYMENT_ITEMS
913: -- Set transfer related information in PN_PAYMENT_SCHEDULES
914: -- 27-NOV-06 sdmahesh o Changed event_id_tbl_typ to NUMBER
915: -------------------------------------------------------------------------------

Line 912: -- Stamped xla_event_id PN_PAYMENT_ITEMS

908: -- while inserting
909: -- 01-DEC-05 Hareesha o Changes for Lazy upgrade for LE uptake.
910: -- 12-MAY-06 sdmahesh o Bug # 5219481
911: -- Set transferred_to_ar_flag in PN_PAYMENT_ITEMS
912: -- Stamped xla_event_id PN_PAYMENT_ITEMS
913: -- Set transfer related information in PN_PAYMENT_SCHEDULES
914: -- 27-NOV-06 sdmahesh o Changed event_id_tbl_typ to NUMBER
915: -------------------------------------------------------------------------------
916:

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

928: l_high_lease_id pn_leases.lease_id%TYPE;
929: l_sch_start_date pn_payment_schedules.schedule_date%TYPE;
930: l_sch_end_date pn_payment_schedules.schedule_date%TYPE;
931:
932: TYPE item_id_tbl_typ IS TABLE OF pn_payment_items_all.payment_item_id%TYPE INDEX BY BINARY_INTEGER;
933: TYPE schedule_id_tbl_typ IS TABLE OF pn_payment_schedules_all.payment_schedule_id%TYPE INDEX BY BINARY_INTEGER;
934: TYPE NUMBER_tbl_typ IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
935: TYPE event_id_tbl_typ IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
936:

Line 1093: UPDATE pn_payment_items_all

1089:
1090: pnp_debug_pkg.log('Updating payment items');
1091:
1092: FORALL i IN item_id_tbl.FIRST..item_id_tbl.LAST
1093: UPDATE pn_payment_items_all
1094: SET transferred_to_ar_flag = 'Y' ,
1095: xla_event_id = event_id_tbl(i),
1096: last_updated_by = l_last_updated_by,
1097: last_update_login = l_last_update_login,

Line 1148: UPDATE pn_payment_items_all

1144:
1145: IF item_id_tbl.COUNT > 0 THEN
1146:
1147: FORALL i IN item_id_tbl.FIRST..item_id_tbl.LAST
1148: UPDATE pn_payment_items_all
1149: SET transferred_to_ar_flag = 'Y' ,
1150: xla_event_id = event_id_tbl(i),
1151: last_updated_by = l_last_updated_by,
1152: last_update_login = l_last_update_login,

Line 1532: v_transaction_date PN_PAYMENT_ITEMS.due_date%TYPE;

1528: v_pn_period_name PN_PAYMENT_SCHEDULES.period_name%TYPE;
1529: v_pn_code_combination_id PN_PAYMENT_TERMS.code_combination_id%TYPE;
1530: v_pn_term_id PN_PAYMENT_TERMS.ap_ar_term_id%TYPE;
1531: v_pn_trx_type_id PN_PAYMENT_TERMS.cust_trx_type_id%TYPE;
1532: v_transaction_date PN_PAYMENT_ITEMS.due_date%TYPE;
1533: v_normalize PN_PAYMENT_TERMS.normalize%type;
1534: v_pn_payment_item_id PN_PAYMENT_ITEMS.payment_item_id%TYPE;
1535: v_pn_payment_term_id PN_PAYMENT_ITEMS.payment_term_id%TYPE;
1536: v_pn_currency_code PN_PAYMENT_ITEMS.currency_code%TYPE;

Line 1534: v_pn_payment_item_id PN_PAYMENT_ITEMS.payment_item_id%TYPE;

1530: v_pn_term_id PN_PAYMENT_TERMS.ap_ar_term_id%TYPE;
1531: v_pn_trx_type_id PN_PAYMENT_TERMS.cust_trx_type_id%TYPE;
1532: v_transaction_date PN_PAYMENT_ITEMS.due_date%TYPE;
1533: v_normalize PN_PAYMENT_TERMS.normalize%type;
1534: v_pn_payment_item_id PN_PAYMENT_ITEMS.payment_item_id%TYPE;
1535: v_pn_payment_term_id PN_PAYMENT_ITEMS.payment_term_id%TYPE;
1536: v_pn_currency_code PN_PAYMENT_ITEMS.currency_code%TYPE;
1537: v_pn_export_currency_code PN_PAYMENT_ITEMS.export_currency_code%TYPE;
1538: v_pn_export_currency_amount PN_PAYMENT_ITEMS.export_currency_amount%TYPE;

Line 1535: v_pn_payment_term_id PN_PAYMENT_ITEMS.payment_term_id%TYPE;

1531: v_pn_trx_type_id PN_PAYMENT_TERMS.cust_trx_type_id%TYPE;
1532: v_transaction_date PN_PAYMENT_ITEMS.due_date%TYPE;
1533: v_normalize PN_PAYMENT_TERMS.normalize%type;
1534: v_pn_payment_item_id PN_PAYMENT_ITEMS.payment_item_id%TYPE;
1535: v_pn_payment_term_id PN_PAYMENT_ITEMS.payment_term_id%TYPE;
1536: v_pn_currency_code PN_PAYMENT_ITEMS.currency_code%TYPE;
1537: v_pn_export_currency_code PN_PAYMENT_ITEMS.export_currency_code%TYPE;
1538: v_pn_export_currency_amount PN_PAYMENT_ITEMS.export_currency_amount%TYPE;
1539: v_pn_payment_schedule_id PN_PAYMENT_ITEMS.payment_schedule_id%TYPE;

Line 1536: v_pn_currency_code PN_PAYMENT_ITEMS.currency_code%TYPE;

1532: v_transaction_date PN_PAYMENT_ITEMS.due_date%TYPE;
1533: v_normalize PN_PAYMENT_TERMS.normalize%type;
1534: v_pn_payment_item_id PN_PAYMENT_ITEMS.payment_item_id%TYPE;
1535: v_pn_payment_term_id PN_PAYMENT_ITEMS.payment_term_id%TYPE;
1536: v_pn_currency_code PN_PAYMENT_ITEMS.currency_code%TYPE;
1537: v_pn_export_currency_code PN_PAYMENT_ITEMS.export_currency_code%TYPE;
1538: v_pn_export_currency_amount PN_PAYMENT_ITEMS.export_currency_amount%TYPE;
1539: v_pn_payment_schedule_id PN_PAYMENT_ITEMS.payment_schedule_id%TYPE;
1540: v_pn_accounted_date PN_PAYMENT_ITEMS.accounted_date%TYPE;

Line 1537: v_pn_export_currency_code PN_PAYMENT_ITEMS.export_currency_code%TYPE;

1533: v_normalize PN_PAYMENT_TERMS.normalize%type;
1534: v_pn_payment_item_id PN_PAYMENT_ITEMS.payment_item_id%TYPE;
1535: v_pn_payment_term_id PN_PAYMENT_ITEMS.payment_term_id%TYPE;
1536: v_pn_currency_code PN_PAYMENT_ITEMS.currency_code%TYPE;
1537: v_pn_export_currency_code PN_PAYMENT_ITEMS.export_currency_code%TYPE;
1538: v_pn_export_currency_amount PN_PAYMENT_ITEMS.export_currency_amount%TYPE;
1539: v_pn_payment_schedule_id PN_PAYMENT_ITEMS.payment_schedule_id%TYPE;
1540: v_pn_accounted_date PN_PAYMENT_ITEMS.accounted_date%TYPE;
1541: v_pn_rate PN_PAYMENT_ITEMS.rate%TYPE;

Line 1538: v_pn_export_currency_amount PN_PAYMENT_ITEMS.export_currency_amount%TYPE;

1534: v_pn_payment_item_id PN_PAYMENT_ITEMS.payment_item_id%TYPE;
1535: v_pn_payment_term_id PN_PAYMENT_ITEMS.payment_term_id%TYPE;
1536: v_pn_currency_code PN_PAYMENT_ITEMS.currency_code%TYPE;
1537: v_pn_export_currency_code PN_PAYMENT_ITEMS.export_currency_code%TYPE;
1538: v_pn_export_currency_amount PN_PAYMENT_ITEMS.export_currency_amount%TYPE;
1539: v_pn_payment_schedule_id PN_PAYMENT_ITEMS.payment_schedule_id%TYPE;
1540: v_pn_accounted_date PN_PAYMENT_ITEMS.accounted_date%TYPE;
1541: v_pn_rate PN_PAYMENT_ITEMS.rate%TYPE;
1542: l_amt NUMBER;

Line 1539: v_pn_payment_schedule_id PN_PAYMENT_ITEMS.payment_schedule_id%TYPE;

1535: v_pn_payment_term_id PN_PAYMENT_ITEMS.payment_term_id%TYPE;
1536: v_pn_currency_code PN_PAYMENT_ITEMS.currency_code%TYPE;
1537: v_pn_export_currency_code PN_PAYMENT_ITEMS.export_currency_code%TYPE;
1538: v_pn_export_currency_amount PN_PAYMENT_ITEMS.export_currency_amount%TYPE;
1539: v_pn_payment_schedule_id PN_PAYMENT_ITEMS.payment_schedule_id%TYPE;
1540: v_pn_accounted_date PN_PAYMENT_ITEMS.accounted_date%TYPE;
1541: v_pn_rate PN_PAYMENT_ITEMS.rate%TYPE;
1542: l_amt NUMBER;
1543: l_prior_payment_schedule_id NUMBER := -999;

Line 1540: v_pn_accounted_date PN_PAYMENT_ITEMS.accounted_date%TYPE;

1536: v_pn_currency_code PN_PAYMENT_ITEMS.currency_code%TYPE;
1537: v_pn_export_currency_code PN_PAYMENT_ITEMS.export_currency_code%TYPE;
1538: v_pn_export_currency_amount PN_PAYMENT_ITEMS.export_currency_amount%TYPE;
1539: v_pn_payment_schedule_id PN_PAYMENT_ITEMS.payment_schedule_id%TYPE;
1540: v_pn_accounted_date PN_PAYMENT_ITEMS.accounted_date%TYPE;
1541: v_pn_rate PN_PAYMENT_ITEMS.rate%TYPE;
1542: l_amt NUMBER;
1543: l_prior_payment_schedule_id NUMBER := -999;
1544: l_created_by NUMBER := FND_GLOBAL.user_id;

Line 1541: v_pn_rate PN_PAYMENT_ITEMS.rate%TYPE;

1537: v_pn_export_currency_code PN_PAYMENT_ITEMS.export_currency_code%TYPE;
1538: v_pn_export_currency_amount PN_PAYMENT_ITEMS.export_currency_amount%TYPE;
1539: v_pn_payment_schedule_id PN_PAYMENT_ITEMS.payment_schedule_id%TYPE;
1540: v_pn_accounted_date PN_PAYMENT_ITEMS.accounted_date%TYPE;
1541: v_pn_rate PN_PAYMENT_ITEMS.rate%TYPE;
1542: l_amt NUMBER;
1543: l_prior_payment_schedule_id NUMBER := -999;
1544: l_created_by NUMBER := FND_GLOBAL.user_id;
1545: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;

Line 1636: PN_PAYMENT_ITEMS_ALL pi,

1632: pi1.actual_amount,
1633: ps.schedule_date
1634: FROM PN_PAYMENT_TERMS pt,
1635: PN_LEASES_ALL le ,
1636: PN_PAYMENT_ITEMS_ALL pi,
1637: PN_PAYMENT_ITEMS_ALL pi1,
1638: PN_PAYMENT_SCHEDULES_ALL ps
1639: WHERE pt.lease_id = le.lease_id
1640: AND le.lease_class_code in ('THIRD_PARTY','SUB_LEASE')

Line 1637: PN_PAYMENT_ITEMS_ALL pi1,

1633: ps.schedule_date
1634: FROM PN_PAYMENT_TERMS pt,
1635: PN_LEASES_ALL le ,
1636: PN_PAYMENT_ITEMS_ALL pi,
1637: PN_PAYMENT_ITEMS_ALL pi1,
1638: PN_PAYMENT_SCHEDULES_ALL ps
1639: WHERE pt.lease_id = le.lease_id
1640: AND le.lease_class_code in ('THIRD_PARTY','SUB_LEASE')
1641: AND LE.LEASE_ID BETWEEN L_LOW_LEASE_ID AND L_HIGH_LEASE_ID

Line 2062: 'PN_PAYMENT_ITEMS',

2058: null,
2059: l_amt,
2060: null,
2061: l_accounted_amt,
2062: 'PN_PAYMENT_ITEMS',
2063: V_PN_PAYMENT_ITEM_ID,
2064: l_line_desc,
2065: NULL,
2066: pn_mo_cache_utils.get_current_org_id,

Line 2175: 'PN_PAYMENT_ITEMS',

2171: l_amt,
2172: null,
2173: l_accounted_amt,
2174: null,
2175: 'PN_PAYMENT_ITEMS',
2176: V_PN_PAYMENT_ITEM_ID,
2177: l_line_desc,
2178: null,
2179: pn_mo_cache_utils.get_current_org_id,

Line 2199: UPDATE pn_payment_items_all

2195: l_context := 'Updating Payment Items';
2196: pnp_debug_pkg.log('Updating payment items for payment item id : ' ||
2197: to_char(v_pn_payment_item_id) );
2198:
2199: UPDATE pn_payment_items_all
2200: SET transferred_to_ar_flag = 'Y' ,
2201: ar_ref_code = v_pn_payment_item_id,
2202: last_updated_by = l_last_updated_by,
2203: last_update_login = l_last_update_login,

Line 2285: v_transaction_date PN_PAYMENT_ITEMS.due_date%TYPE;

2281: v_pn_period_name PN_PAYMENT_SCHEDULES.period_name%TYPE;
2282: v_pn_code_combination_id PN_PAYMENT_TERMS.code_combination_id%TYPE;
2283: v_pn_distribution_set_id pn_payment_terms.distribution_set_id%TYPE;
2284: v_pn_project_id pn_payment_terms.project_id%type;
2285: v_transaction_date PN_PAYMENT_ITEMS.due_date%TYPE;
2286: v_normalize PN_PAYMENT_TERMS.normalize%type;
2287: v_pn_payment_item_id PN_PAYMENT_ITEMS.payment_item_id%TYPE;
2288: v_pn_payment_term_id PN_PAYMENT_ITEMS.payment_term_id%TYPE;
2289: v_pn_currency_code PN_PAYMENT_ITEMS.currency_code%TYPE;

Line 2287: v_pn_payment_item_id PN_PAYMENT_ITEMS.payment_item_id%TYPE;

2283: v_pn_distribution_set_id pn_payment_terms.distribution_set_id%TYPE;
2284: v_pn_project_id pn_payment_terms.project_id%type;
2285: v_transaction_date PN_PAYMENT_ITEMS.due_date%TYPE;
2286: v_normalize PN_PAYMENT_TERMS.normalize%type;
2287: v_pn_payment_item_id PN_PAYMENT_ITEMS.payment_item_id%TYPE;
2288: v_pn_payment_term_id PN_PAYMENT_ITEMS.payment_term_id%TYPE;
2289: v_pn_currency_code PN_PAYMENT_ITEMS.currency_code%TYPE;
2290: v_pn_export_currency_code PN_PAYMENT_ITEMS.export_currency_code%TYPE;
2291: v_pn_export_currency_amount PN_PAYMENT_ITEMS.export_currency_amount%TYPE;

Line 2288: v_pn_payment_term_id PN_PAYMENT_ITEMS.payment_term_id%TYPE;

2284: v_pn_project_id pn_payment_terms.project_id%type;
2285: v_transaction_date PN_PAYMENT_ITEMS.due_date%TYPE;
2286: v_normalize PN_PAYMENT_TERMS.normalize%type;
2287: v_pn_payment_item_id PN_PAYMENT_ITEMS.payment_item_id%TYPE;
2288: v_pn_payment_term_id PN_PAYMENT_ITEMS.payment_term_id%TYPE;
2289: v_pn_currency_code PN_PAYMENT_ITEMS.currency_code%TYPE;
2290: v_pn_export_currency_code PN_PAYMENT_ITEMS.export_currency_code%TYPE;
2291: v_pn_export_currency_amount PN_PAYMENT_ITEMS.export_currency_amount%TYPE;
2292: v_pn_payment_schedule_id PN_PAYMENT_ITEMS.payment_schedule_id%TYPE;

Line 2289: v_pn_currency_code PN_PAYMENT_ITEMS.currency_code%TYPE;

2285: v_transaction_date PN_PAYMENT_ITEMS.due_date%TYPE;
2286: v_normalize PN_PAYMENT_TERMS.normalize%type;
2287: v_pn_payment_item_id PN_PAYMENT_ITEMS.payment_item_id%TYPE;
2288: v_pn_payment_term_id PN_PAYMENT_ITEMS.payment_term_id%TYPE;
2289: v_pn_currency_code PN_PAYMENT_ITEMS.currency_code%TYPE;
2290: v_pn_export_currency_code PN_PAYMENT_ITEMS.export_currency_code%TYPE;
2291: v_pn_export_currency_amount PN_PAYMENT_ITEMS.export_currency_amount%TYPE;
2292: v_pn_payment_schedule_id PN_PAYMENT_ITEMS.payment_schedule_id%TYPE;
2293: v_pn_accounted_date PN_PAYMENT_ITEMS.accounted_date%TYPE;

Line 2290: v_pn_export_currency_code PN_PAYMENT_ITEMS.export_currency_code%TYPE;

2286: v_normalize PN_PAYMENT_TERMS.normalize%type;
2287: v_pn_payment_item_id PN_PAYMENT_ITEMS.payment_item_id%TYPE;
2288: v_pn_payment_term_id PN_PAYMENT_ITEMS.payment_term_id%TYPE;
2289: v_pn_currency_code PN_PAYMENT_ITEMS.currency_code%TYPE;
2290: v_pn_export_currency_code PN_PAYMENT_ITEMS.export_currency_code%TYPE;
2291: v_pn_export_currency_amount PN_PAYMENT_ITEMS.export_currency_amount%TYPE;
2292: v_pn_payment_schedule_id PN_PAYMENT_ITEMS.payment_schedule_id%TYPE;
2293: v_pn_accounted_date PN_PAYMENT_ITEMS.accounted_date%TYPE;
2294: v_pn_rate PN_PAYMENT_ITEMS.rate%TYPE;

Line 2291: v_pn_export_currency_amount PN_PAYMENT_ITEMS.export_currency_amount%TYPE;

2287: v_pn_payment_item_id PN_PAYMENT_ITEMS.payment_item_id%TYPE;
2288: v_pn_payment_term_id PN_PAYMENT_ITEMS.payment_term_id%TYPE;
2289: v_pn_currency_code PN_PAYMENT_ITEMS.currency_code%TYPE;
2290: v_pn_export_currency_code PN_PAYMENT_ITEMS.export_currency_code%TYPE;
2291: v_pn_export_currency_amount PN_PAYMENT_ITEMS.export_currency_amount%TYPE;
2292: v_pn_payment_schedule_id PN_PAYMENT_ITEMS.payment_schedule_id%TYPE;
2293: v_pn_accounted_date PN_PAYMENT_ITEMS.accounted_date%TYPE;
2294: v_pn_rate PN_PAYMENT_ITEMS.rate%TYPE;
2295: l_amt NUMBER;

Line 2292: v_pn_payment_schedule_id PN_PAYMENT_ITEMS.payment_schedule_id%TYPE;

2288: v_pn_payment_term_id PN_PAYMENT_ITEMS.payment_term_id%TYPE;
2289: v_pn_currency_code PN_PAYMENT_ITEMS.currency_code%TYPE;
2290: v_pn_export_currency_code PN_PAYMENT_ITEMS.export_currency_code%TYPE;
2291: v_pn_export_currency_amount PN_PAYMENT_ITEMS.export_currency_amount%TYPE;
2292: v_pn_payment_schedule_id PN_PAYMENT_ITEMS.payment_schedule_id%TYPE;
2293: v_pn_accounted_date PN_PAYMENT_ITEMS.accounted_date%TYPE;
2294: v_pn_rate PN_PAYMENT_ITEMS.rate%TYPE;
2295: l_amt NUMBER;
2296: l_prior_payment_schedule_id NUMBER := -999;

Line 2293: v_pn_accounted_date PN_PAYMENT_ITEMS.accounted_date%TYPE;

2289: v_pn_currency_code PN_PAYMENT_ITEMS.currency_code%TYPE;
2290: v_pn_export_currency_code PN_PAYMENT_ITEMS.export_currency_code%TYPE;
2291: v_pn_export_currency_amount PN_PAYMENT_ITEMS.export_currency_amount%TYPE;
2292: v_pn_payment_schedule_id PN_PAYMENT_ITEMS.payment_schedule_id%TYPE;
2293: v_pn_accounted_date PN_PAYMENT_ITEMS.accounted_date%TYPE;
2294: v_pn_rate PN_PAYMENT_ITEMS.rate%TYPE;
2295: l_amt NUMBER;
2296: l_prior_payment_schedule_id NUMBER := -999;
2297: l_created_by NUMBER := FND_GLOBAL.user_id;

Line 2294: v_pn_rate PN_PAYMENT_ITEMS.rate%TYPE;

2290: v_pn_export_currency_code PN_PAYMENT_ITEMS.export_currency_code%TYPE;
2291: v_pn_export_currency_amount PN_PAYMENT_ITEMS.export_currency_amount%TYPE;
2292: v_pn_payment_schedule_id PN_PAYMENT_ITEMS.payment_schedule_id%TYPE;
2293: v_pn_accounted_date PN_PAYMENT_ITEMS.accounted_date%TYPE;
2294: v_pn_rate PN_PAYMENT_ITEMS.rate%TYPE;
2295: l_amt NUMBER;
2296: l_prior_payment_schedule_id NUMBER := -999;
2297: l_created_by NUMBER := FND_GLOBAL.user_id;
2298: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;

Line 2389: pn_payment_items_all pi,

2385: pi1.actual_amount,
2386: ps.schedule_date
2387: FROM pn_payment_terms pt,
2388: pn_leases_all le ,
2389: pn_payment_items_all pi,
2390: pn_payment_items_all pi1,
2391: pn_payment_schedules_all ps
2392: WHERE pt.lease_id = le.lease_id
2393: AND le.lease_class_code = 'DIRECT'

Line 2390: pn_payment_items_all pi1,

2386: ps.schedule_date
2387: FROM pn_payment_terms pt,
2388: pn_leases_all le ,
2389: pn_payment_items_all pi,
2390: pn_payment_items_all pi1,
2391: pn_payment_schedules_all ps
2392: WHERE pt.lease_id = le.lease_id
2393: AND le.lease_class_code = 'DIRECT'
2394: and LE.LEASE_ID BETWEEN L_LOW_LEASE_ID AND L_HIGH_LEASE_ID

Line 2822: 'PN_PAYMENT_ITEMS',

2818: l_amt,
2819: null,
2820: l_accounted_amt,
2821: null,
2822: 'PN_PAYMENT_ITEMS',
2823: V_PN_PAYMENT_ITEM_ID,
2824: l_line_desc,
2825: NULL,
2826: pn_mo_cache_utils.get_current_org_id,

Line 2937: 'PN_PAYMENT_ITEMS',

2933: NULL,
2934: l_amt,
2935: NULL,
2936: l_accounted_amt,
2937: 'PN_PAYMENT_ITEMS',
2938: V_PN_PAYMENT_ITEM_ID,
2939: l_line_desc,
2940: NULL,
2941: pn_mo_cache_utils.get_current_org_id,

Line 2961: UPDATE pn_payment_items_all

2957: l_context := 'Updating Payment Items';
2958: pnp_debug_pkg.log('Updating payment items for payment item id : ' ||
2959: to_char(v_pn_payment_item_id) );
2960:
2961: UPDATE pn_payment_items_all
2962: SET transferred_to_ap_flag = 'Y' ,
2963: last_updated_by = l_last_updated_by,
2964: last_update_login = l_last_update_login,
2965: last_update_date = l_last_update_date