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_RETRO_ADJUSTMENT_PKG dependencies on PN_PAYMENT_TERMS

Line 26: p_start_date pn_payment_terms.start_date%TYPE,

22: -- equal to end date
23: ------------------------------------------------------------------------------+
24:
25: PROCEDURE create_virtual_schedules(
26: p_start_date pn_payment_terms.start_date%TYPE,
27: p_end_date pn_payment_terms.end_date%TYPE,
28: p_sch_day pn_payment_terms.schedule_day%TYPE,
29: p_amount pn_payment_terms.actual_amount%TYPE,
30: p_term_freq pn_payment_terms.frequency_code%TYPE,

Line 27: p_end_date pn_payment_terms.end_date%TYPE,

23: ------------------------------------------------------------------------------+
24:
25: PROCEDURE create_virtual_schedules(
26: p_start_date pn_payment_terms.start_date%TYPE,
27: p_end_date pn_payment_terms.end_date%TYPE,
28: p_sch_day pn_payment_terms.schedule_day%TYPE,
29: p_amount pn_payment_terms.actual_amount%TYPE,
30: p_term_freq pn_payment_terms.frequency_code%TYPE,
31: p_payment_term_id pn_payment_terms_all.payment_term_id%TYPE,

Line 28: p_sch_day pn_payment_terms.schedule_day%TYPE,

24:
25: PROCEDURE create_virtual_schedules(
26: p_start_date pn_payment_terms.start_date%TYPE,
27: p_end_date pn_payment_terms.end_date%TYPE,
28: p_sch_day pn_payment_terms.schedule_day%TYPE,
29: p_amount pn_payment_terms.actual_amount%TYPE,
30: p_term_freq pn_payment_terms.frequency_code%TYPE,
31: p_payment_term_id pn_payment_terms_all.payment_term_id%TYPE,
32: x_sched_tbl OUT NOCOPY payment_item_tbl_type

Line 29: p_amount pn_payment_terms.actual_amount%TYPE,

25: PROCEDURE create_virtual_schedules(
26: p_start_date pn_payment_terms.start_date%TYPE,
27: p_end_date pn_payment_terms.end_date%TYPE,
28: p_sch_day pn_payment_terms.schedule_day%TYPE,
29: p_amount pn_payment_terms.actual_amount%TYPE,
30: p_term_freq pn_payment_terms.frequency_code%TYPE,
31: p_payment_term_id pn_payment_terms_all.payment_term_id%TYPE,
32: x_sched_tbl OUT NOCOPY payment_item_tbl_type
33: )

Line 30: p_term_freq pn_payment_terms.frequency_code%TYPE,

26: p_start_date pn_payment_terms.start_date%TYPE,
27: p_end_date pn_payment_terms.end_date%TYPE,
28: p_sch_day pn_payment_terms.schedule_day%TYPE,
29: p_amount pn_payment_terms.actual_amount%TYPE,
30: p_term_freq pn_payment_terms.frequency_code%TYPE,
31: p_payment_term_id pn_payment_terms_all.payment_term_id%TYPE,
32: x_sched_tbl OUT NOCOPY payment_item_tbl_type
33: )
34: IS

Line 31: p_payment_term_id pn_payment_terms_all.payment_term_id%TYPE,

27: p_end_date pn_payment_terms.end_date%TYPE,
28: p_sch_day pn_payment_terms.schedule_day%TYPE,
29: p_amount pn_payment_terms.actual_amount%TYPE,
30: p_term_freq pn_payment_terms.frequency_code%TYPE,
31: p_payment_term_id pn_payment_terms_all.payment_term_id%TYPE,
32: x_sched_tbl OUT NOCOPY payment_item_tbl_type
33: )
34: IS
35: l_current_end_date pn_payment_terms.end_date%TYPE;

Line 35: l_current_end_date pn_payment_terms.end_date%TYPE;

31: p_payment_term_id pn_payment_terms_all.payment_term_id%TYPE,
32: x_sched_tbl OUT NOCOPY payment_item_tbl_type
33: )
34: IS
35: l_current_end_date pn_payment_terms.end_date%TYPE;
36: l_current_start_date pn_payment_terms.start_date%TYPE;
37: l_current_amount pn_payment_terms.actual_amount%TYPE;
38: l_dummy_amount pn_payment_terms.actual_amount%TYPE;
39:

Line 36: l_current_start_date pn_payment_terms.start_date%TYPE;

32: x_sched_tbl OUT NOCOPY payment_item_tbl_type
33: )
34: IS
35: l_current_end_date pn_payment_terms.end_date%TYPE;
36: l_current_start_date pn_payment_terms.start_date%TYPE;
37: l_current_amount pn_payment_terms.actual_amount%TYPE;
38: l_dummy_amount pn_payment_terms.actual_amount%TYPE;
39:
40: l_count NUMBER;

Line 37: l_current_amount pn_payment_terms.actual_amount%TYPE;

33: )
34: IS
35: l_current_end_date pn_payment_terms.end_date%TYPE;
36: l_current_start_date pn_payment_terms.start_date%TYPE;
37: l_current_amount pn_payment_terms.actual_amount%TYPE;
38: l_dummy_amount pn_payment_terms.actual_amount%TYPE;
39:
40: l_count NUMBER;
41: l_freq_num NUMBER;

Line 38: l_dummy_amount pn_payment_terms.actual_amount%TYPE;

34: IS
35: l_current_end_date pn_payment_terms.end_date%TYPE;
36: l_current_start_date pn_payment_terms.start_date%TYPE;
37: l_current_amount pn_payment_terms.actual_amount%TYPE;
38: l_dummy_amount pn_payment_terms.actual_amount%TYPE;
39:
40: l_count NUMBER;
41: l_freq_num NUMBER;
42:

Line 74: WHERE LEASE_ID = (select distinct lease_id from pn_payment_terms_all where payment_term_id = p_payment_term_id);

70:
71: SELECT cal_start
72: INTO l_cal_yr_st_dt
73: FROM PN_LEASES_ALL
74: WHERE LEASE_ID = (select distinct lease_id from pn_payment_terms_all where payment_term_id = p_payment_term_id);
75:
76:
77: IF l_cal_yr_st_dt IS NOT NULL THEN
78: l_yr_start_dt := to_date(l_cal_yr_st_dt || '-' || to_char(p_start_date,'YYYY'),'DD-MM-YYYY');

Line 184: p_term_id pn_payment_terms.payment_term_id%TYPE,

180: -- 27-SEP-04 ftanudja o Created.
181: -- 15-JUL-05 SatyaDeep o Replaced base views with their _ALL tables
182: ------------------------------------------------------------------------------+
183: PROCEDURE get_current_schedules(
184: p_term_id pn_payment_terms.payment_term_id%TYPE,
185: x_sched_tbl OUT NOCOPY payment_item_tbl_type
186: )
187: IS
188: -- NOTE: important that the cursor is ordered by date

Line 612: p_term_freq pn_payment_terms.frequency_code%TYPE,

608: -- 08-OCT-04 ftanudja o Created.
609: -- 14-JAN-05 atuppad o removed least of p_term_end_dt for x_end_date
610: ------------------------------------------------------------------------------+
611: PROCEDURE find_start_end_dates(
612: p_term_freq pn_payment_terms.frequency_code%TYPE,
613: p_term_start_dt pn_payment_terms.start_date%TYPE,
614: p_term_end_dt pn_payment_terms.end_date%TYPE,
615: p_schedule_dt pn_payment_schedules.schedule_date%TYPE,
616: x_start_date OUT NOCOPY pn_payment_items.adj_start_date%TYPE,

Line 613: p_term_start_dt pn_payment_terms.start_date%TYPE,

609: -- 14-JAN-05 atuppad o removed least of p_term_end_dt for x_end_date
610: ------------------------------------------------------------------------------+
611: PROCEDURE find_start_end_dates(
612: p_term_freq pn_payment_terms.frequency_code%TYPE,
613: p_term_start_dt pn_payment_terms.start_date%TYPE,
614: p_term_end_dt pn_payment_terms.end_date%TYPE,
615: p_schedule_dt pn_payment_schedules.schedule_date%TYPE,
616: x_start_date OUT NOCOPY pn_payment_items.adj_start_date%TYPE,
617: x_end_date OUT NOCOPY pn_payment_items.adj_end_date%TYPE

Line 614: p_term_end_dt pn_payment_terms.end_date%TYPE,

610: ------------------------------------------------------------------------------+
611: PROCEDURE find_start_end_dates(
612: p_term_freq pn_payment_terms.frequency_code%TYPE,
613: p_term_start_dt pn_payment_terms.start_date%TYPE,
614: p_term_end_dt pn_payment_terms.end_date%TYPE,
615: p_schedule_dt pn_payment_schedules.schedule_date%TYPE,
616: x_start_date OUT NOCOPY pn_payment_items.adj_start_date%TYPE,
617: x_end_date OUT NOCOPY pn_payment_items.adj_end_date%TYPE
618: )

Line 692: p_term_freq pn_payment_terms.frequency_code%TYPE,

688: ------------------------------------------------------------------------------+
689: PROCEDURE create_adjustment_tables (
690: p_sched_table payment_item_tbl_type,
691: p_last_appr_dt DATE,
692: p_term_freq pn_payment_terms.frequency_code%TYPE,
693: p_term_start_dt pn_payment_terms.start_date%TYPE,
694: p_term_end_dt pn_payment_terms.end_date%TYPE,
695: x_new_orig_table OUT NOCOPY payment_item_tbl_type,
696: x_upd_orig_table OUT NOCOPY payment_item_tbl_type,

Line 693: p_term_start_dt pn_payment_terms.start_date%TYPE,

689: PROCEDURE create_adjustment_tables (
690: p_sched_table payment_item_tbl_type,
691: p_last_appr_dt DATE,
692: p_term_freq pn_payment_terms.frequency_code%TYPE,
693: p_term_start_dt pn_payment_terms.start_date%TYPE,
694: p_term_end_dt pn_payment_terms.end_date%TYPE,
695: x_new_orig_table OUT NOCOPY payment_item_tbl_type,
696: x_upd_orig_table OUT NOCOPY payment_item_tbl_type,
697: x_del_orig_table OUT NOCOPY payment_item_tbl_type,

Line 694: p_term_end_dt pn_payment_terms.end_date%TYPE,

690: p_sched_table payment_item_tbl_type,
691: p_last_appr_dt DATE,
692: p_term_freq pn_payment_terms.frequency_code%TYPE,
693: p_term_start_dt pn_payment_terms.start_date%TYPE,
694: p_term_end_dt pn_payment_terms.end_date%TYPE,
695: x_new_orig_table OUT NOCOPY payment_item_tbl_type,
696: x_upd_orig_table OUT NOCOPY payment_item_tbl_type,
697: x_del_orig_table OUT NOCOPY payment_item_tbl_type,
698: x_adj_table OUT NOCOPY payment_item_tbl_type

Line 968: p_sch_day pn_payment_terms.schedule_day%TYPE,

964: -- 05-OCT-04 ftanudja o Created.
965: -- 10-AUG-05 piagrawa o Bug#4284035 - Modified the signature to pass org id
966: ------------------------------------------------------------------------------+
967: PROCEDURE prepare_new_items_from_adj (
968: p_sch_day pn_payment_terms.schedule_day%TYPE,
969: p_item_adj_tbl IN OUT NOCOPY payment_item_tbl_type,
970: p_org_id NUMBER
971: )
972: IS

Line 1082: p_term_id pn_payment_terms.payment_term_id%TYPE,

1078: ------------------------------------------------------------------------------+
1079: PROCEDURE find_schedule (
1080: p_lease_id pn_leases.lease_id%TYPE,
1081: p_lease_change_id pn_lease_changes.lease_change_id%TYPE,
1082: p_term_id pn_payment_terms.payment_term_id%TYPE,
1083: p_schedule_date pn_payment_schedules.schedule_date%TYPE,
1084: p_schedule_id OUT NOCOPY pn_payment_schedules.payment_schedule_id%TYPE
1085: )
1086: IS

Line 1211: p_term_id pn_payment_terms.payment_term_id%TYPE,

1207: -- 05-OCT-04 ftanudja o Created.
1208: ------------------------------------------------------------------------------+
1209: PROCEDURE get_schedule_id_for_new_items(
1210: p_lease_id pn_leases.lease_id%TYPE,
1211: p_term_id pn_payment_terms.payment_term_id%TYPE,
1212: p_lease_change_id pn_lease_changes.lease_change_id%TYPE,
1213: p_sched_tbl IN OUT NOCOPY payment_item_tbl_type
1214: )
1215: IS

Line 1309: p_term_id pn_payment_terms.payment_term_id%TYPE,

1305: -- 05-OCT-04 ftanudja o Created.
1306: -- 15-JUL-05 SatyaDeep o Replaced base views with their _ALL tables
1307: ------------------------------------------------------------------------------+
1308: PROCEDURE process_items(
1309: p_term_id pn_payment_terms.payment_term_id%TYPE,
1310: p_adj_type_cd pn_payment_items.last_adjustment_type_code%TYPE,
1311: p_upd_item_tbl payment_item_tbl_type,
1312: p_del_item_tbl payment_item_tbl_type,
1313: p_new_item_tbl IN OUT NOCOPY payment_item_tbl_type

Line 1328: FROM pn_payment_terms_all

1324: currency_code,
1325: rate,
1326: estimated_amount,
1327: org_id
1328: FROM pn_payment_terms_all
1329: WHERE payment_term_id = p_term_id;
1330:
1331: l_new_itm_id_tbl item_id_tbl_type;
1332: l_payment_id_tbl item_id_tbl_type;

Line 1340: l_vendor_id pn_payment_terms.vendor_id%TYPE;

1336: l_trx_date_tbl date_tbl_type;
1337: l_start_date_tbl date_tbl_type;
1338: l_end_date_tbl date_tbl_type;
1339:
1340: l_vendor_id pn_payment_terms.vendor_id%TYPE;
1341: l_vendor_site_id pn_payment_terms.vendor_site_id%TYPE;
1342: l_customer_id pn_payment_terms.customer_id%TYPE;
1343: l_customer_site_use_id pn_payment_terms.customer_site_use_id%TYPE;
1344: l_cust_ship_site_id pn_payment_terms.cust_ship_site_id%TYPE;

Line 1341: l_vendor_site_id pn_payment_terms.vendor_site_id%TYPE;

1337: l_start_date_tbl date_tbl_type;
1338: l_end_date_tbl date_tbl_type;
1339:
1340: l_vendor_id pn_payment_terms.vendor_id%TYPE;
1341: l_vendor_site_id pn_payment_terms.vendor_site_id%TYPE;
1342: l_customer_id pn_payment_terms.customer_id%TYPE;
1343: l_customer_site_use_id pn_payment_terms.customer_site_use_id%TYPE;
1344: l_cust_ship_site_id pn_payment_terms.cust_ship_site_id%TYPE;
1345: l_set_of_books_id pn_payment_terms.set_of_books_id%TYPE;

Line 1342: l_customer_id pn_payment_terms.customer_id%TYPE;

1338: l_end_date_tbl date_tbl_type;
1339:
1340: l_vendor_id pn_payment_terms.vendor_id%TYPE;
1341: l_vendor_site_id pn_payment_terms.vendor_site_id%TYPE;
1342: l_customer_id pn_payment_terms.customer_id%TYPE;
1343: l_customer_site_use_id pn_payment_terms.customer_site_use_id%TYPE;
1344: l_cust_ship_site_id pn_payment_terms.cust_ship_site_id%TYPE;
1345: l_set_of_books_id pn_payment_terms.set_of_books_id%TYPE;
1346: l_currency_code pn_payment_terms.currency_code%TYPE;

Line 1343: l_customer_site_use_id pn_payment_terms.customer_site_use_id%TYPE;

1339:
1340: l_vendor_id pn_payment_terms.vendor_id%TYPE;
1341: l_vendor_site_id pn_payment_terms.vendor_site_id%TYPE;
1342: l_customer_id pn_payment_terms.customer_id%TYPE;
1343: l_customer_site_use_id pn_payment_terms.customer_site_use_id%TYPE;
1344: l_cust_ship_site_id pn_payment_terms.cust_ship_site_id%TYPE;
1345: l_set_of_books_id pn_payment_terms.set_of_books_id%TYPE;
1346: l_currency_code pn_payment_terms.currency_code%TYPE;
1347: l_rate pn_payment_terms.rate%TYPE;

Line 1344: l_cust_ship_site_id pn_payment_terms.cust_ship_site_id%TYPE;

1340: l_vendor_id pn_payment_terms.vendor_id%TYPE;
1341: l_vendor_site_id pn_payment_terms.vendor_site_id%TYPE;
1342: l_customer_id pn_payment_terms.customer_id%TYPE;
1343: l_customer_site_use_id pn_payment_terms.customer_site_use_id%TYPE;
1344: l_cust_ship_site_id pn_payment_terms.cust_ship_site_id%TYPE;
1345: l_set_of_books_id pn_payment_terms.set_of_books_id%TYPE;
1346: l_currency_code pn_payment_terms.currency_code%TYPE;
1347: l_rate pn_payment_terms.rate%TYPE;
1348:

Line 1345: l_set_of_books_id pn_payment_terms.set_of_books_id%TYPE;

1341: l_vendor_site_id pn_payment_terms.vendor_site_id%TYPE;
1342: l_customer_id pn_payment_terms.customer_id%TYPE;
1343: l_customer_site_use_id pn_payment_terms.customer_site_use_id%TYPE;
1344: l_cust_ship_site_id pn_payment_terms.cust_ship_site_id%TYPE;
1345: l_set_of_books_id pn_payment_terms.set_of_books_id%TYPE;
1346: l_currency_code pn_payment_terms.currency_code%TYPE;
1347: l_rate pn_payment_terms.rate%TYPE;
1348:
1349: l_precision NUMBER;

Line 1346: l_currency_code pn_payment_terms.currency_code%TYPE;

1342: l_customer_id pn_payment_terms.customer_id%TYPE;
1343: l_customer_site_use_id pn_payment_terms.customer_site_use_id%TYPE;
1344: l_cust_ship_site_id pn_payment_terms.cust_ship_site_id%TYPE;
1345: l_set_of_books_id pn_payment_terms.set_of_books_id%TYPE;
1346: l_currency_code pn_payment_terms.currency_code%TYPE;
1347: l_rate pn_payment_terms.rate%TYPE;
1348:
1349: l_precision NUMBER;
1350: l_ext_precision NUMBER;

Line 1347: l_rate pn_payment_terms.rate%TYPE;

1343: l_customer_site_use_id pn_payment_terms.customer_site_use_id%TYPE;
1344: l_cust_ship_site_id pn_payment_terms.cust_ship_site_id%TYPE;
1345: l_set_of_books_id pn_payment_terms.set_of_books_id%TYPE;
1346: l_currency_code pn_payment_terms.currency_code%TYPE;
1347: l_rate pn_payment_terms.rate%TYPE;
1348:
1349: l_precision NUMBER;
1350: l_ext_precision NUMBER;
1351: l_min_acct_unit NUMBER;

Line 1616: p_term_id pn_payment_terms.payment_term_id%TYPE,

1612: -- 06-OCT-04 ftanudja o Created.
1613: -- 10-AUG-05 piagrawa o Bug#4284035 - Modified the signature to pass org id.
1614: ------------------------------------------------------------------------------+
1615: PROCEDURE create_adjustment_entries(
1616: p_term_id pn_payment_terms.payment_term_id%TYPE,
1617: p_term_freq pn_payment_terms.frequency_code%TYPE,
1618: p_term_start_dt pn_payment_terms.start_date%TYPE,
1619: p_term_end_dt pn_payment_terms.end_date%TYPE,
1620: p_term_hist_id pn_payment_terms_history.term_history_id%TYPE,

Line 1617: p_term_freq pn_payment_terms.frequency_code%TYPE,

1613: -- 10-AUG-05 piagrawa o Bug#4284035 - Modified the signature to pass org id.
1614: ------------------------------------------------------------------------------+
1615: PROCEDURE create_adjustment_entries(
1616: p_term_id pn_payment_terms.payment_term_id%TYPE,
1617: p_term_freq pn_payment_terms.frequency_code%TYPE,
1618: p_term_start_dt pn_payment_terms.start_date%TYPE,
1619: p_term_end_dt pn_payment_terms.end_date%TYPE,
1620: p_term_hist_id pn_payment_terms_history.term_history_id%TYPE,
1621: p_adj_table payment_item_tbl_type,

Line 1618: p_term_start_dt pn_payment_terms.start_date%TYPE,

1614: ------------------------------------------------------------------------------+
1615: PROCEDURE create_adjustment_entries(
1616: p_term_id pn_payment_terms.payment_term_id%TYPE,
1617: p_term_freq pn_payment_terms.frequency_code%TYPE,
1618: p_term_start_dt pn_payment_terms.start_date%TYPE,
1619: p_term_end_dt pn_payment_terms.end_date%TYPE,
1620: p_term_hist_id pn_payment_terms_history.term_history_id%TYPE,
1621: p_adj_table payment_item_tbl_type,
1622: p_org_id NUMBER

Line 1619: p_term_end_dt pn_payment_terms.end_date%TYPE,

1615: PROCEDURE create_adjustment_entries(
1616: p_term_id pn_payment_terms.payment_term_id%TYPE,
1617: p_term_freq pn_payment_terms.frequency_code%TYPE,
1618: p_term_start_dt pn_payment_terms.start_date%TYPE,
1619: p_term_end_dt pn_payment_terms.end_date%TYPE,
1620: p_term_hist_id pn_payment_terms_history.term_history_id%TYPE,
1621: p_adj_table payment_item_tbl_type,
1622: p_org_id NUMBER
1623: )

Line 1620: p_term_hist_id pn_payment_terms_history.term_history_id%TYPE,

1616: p_term_id pn_payment_terms.payment_term_id%TYPE,
1617: p_term_freq pn_payment_terms.frequency_code%TYPE,
1618: p_term_start_dt pn_payment_terms.start_date%TYPE,
1619: p_term_end_dt pn_payment_terms.end_date%TYPE,
1620: p_term_hist_id pn_payment_terms_history.term_history_id%TYPE,
1621: p_adj_table payment_item_tbl_type,
1622: p_org_id NUMBER
1623: )
1624: IS

Line 1839: p_term_id pn_payment_terms.payment_term_id%TYPE,

1835: -- 08-OCT-04 ftanudja o Created.
1836: -- 15-JUL-05 SatyaDeep o Replaced base views with their _ALL tables
1837: ------------------------------------------------------------------------------+
1838: PROCEDURE cleanup_schedules(
1839: p_term_id pn_payment_terms.payment_term_id%TYPE,
1840: p_orig_item_tbl payment_item_tbl_type,
1841: p_adj_item_tbl payment_item_tbl_type
1842: )
1843: IS

Line 1861: FROM pn_payment_terms_all

1857: currency_code,
1858: rate,
1859: estimated_amount,
1860: org_id
1861: FROM pn_payment_terms_all
1862: WHERE payment_term_id = p_term_id;
1863:
1864: l_vendor_id pn_payment_terms.vendor_id%TYPE;
1865: l_vendor_site_id pn_payment_terms.vendor_site_id%TYPE;

Line 1864: l_vendor_id pn_payment_terms.vendor_id%TYPE;

1860: org_id
1861: FROM pn_payment_terms_all
1862: WHERE payment_term_id = p_term_id;
1863:
1864: l_vendor_id pn_payment_terms.vendor_id%TYPE;
1865: l_vendor_site_id pn_payment_terms.vendor_site_id%TYPE;
1866: l_customer_id pn_payment_terms.customer_id%TYPE;
1867: l_customer_site_use_id pn_payment_terms.customer_site_use_id%TYPE;
1868: l_cust_ship_site_id pn_payment_terms.cust_ship_site_id%TYPE;

Line 1865: l_vendor_site_id pn_payment_terms.vendor_site_id%TYPE;

1861: FROM pn_payment_terms_all
1862: WHERE payment_term_id = p_term_id;
1863:
1864: l_vendor_id pn_payment_terms.vendor_id%TYPE;
1865: l_vendor_site_id pn_payment_terms.vendor_site_id%TYPE;
1866: l_customer_id pn_payment_terms.customer_id%TYPE;
1867: l_customer_site_use_id pn_payment_terms.customer_site_use_id%TYPE;
1868: l_cust_ship_site_id pn_payment_terms.cust_ship_site_id%TYPE;
1869: l_set_of_books_id pn_payment_terms.set_of_books_id%TYPE;

Line 1866: l_customer_id pn_payment_terms.customer_id%TYPE;

1862: WHERE payment_term_id = p_term_id;
1863:
1864: l_vendor_id pn_payment_terms.vendor_id%TYPE;
1865: l_vendor_site_id pn_payment_terms.vendor_site_id%TYPE;
1866: l_customer_id pn_payment_terms.customer_id%TYPE;
1867: l_customer_site_use_id pn_payment_terms.customer_site_use_id%TYPE;
1868: l_cust_ship_site_id pn_payment_terms.cust_ship_site_id%TYPE;
1869: l_set_of_books_id pn_payment_terms.set_of_books_id%TYPE;
1870: l_currency_code pn_payment_terms.currency_code%TYPE;

Line 1867: l_customer_site_use_id pn_payment_terms.customer_site_use_id%TYPE;

1863:
1864: l_vendor_id pn_payment_terms.vendor_id%TYPE;
1865: l_vendor_site_id pn_payment_terms.vendor_site_id%TYPE;
1866: l_customer_id pn_payment_terms.customer_id%TYPE;
1867: l_customer_site_use_id pn_payment_terms.customer_site_use_id%TYPE;
1868: l_cust_ship_site_id pn_payment_terms.cust_ship_site_id%TYPE;
1869: l_set_of_books_id pn_payment_terms.set_of_books_id%TYPE;
1870: l_currency_code pn_payment_terms.currency_code%TYPE;
1871: l_rate pn_payment_terms.rate%TYPE;

Line 1868: l_cust_ship_site_id pn_payment_terms.cust_ship_site_id%TYPE;

1864: l_vendor_id pn_payment_terms.vendor_id%TYPE;
1865: l_vendor_site_id pn_payment_terms.vendor_site_id%TYPE;
1866: l_customer_id pn_payment_terms.customer_id%TYPE;
1867: l_customer_site_use_id pn_payment_terms.customer_site_use_id%TYPE;
1868: l_cust_ship_site_id pn_payment_terms.cust_ship_site_id%TYPE;
1869: l_set_of_books_id pn_payment_terms.set_of_books_id%TYPE;
1870: l_currency_code pn_payment_terms.currency_code%TYPE;
1871: l_rate pn_payment_terms.rate%TYPE;
1872:

Line 1869: l_set_of_books_id pn_payment_terms.set_of_books_id%TYPE;

1865: l_vendor_site_id pn_payment_terms.vendor_site_id%TYPE;
1866: l_customer_id pn_payment_terms.customer_id%TYPE;
1867: l_customer_site_use_id pn_payment_terms.customer_site_use_id%TYPE;
1868: l_cust_ship_site_id pn_payment_terms.cust_ship_site_id%TYPE;
1869: l_set_of_books_id pn_payment_terms.set_of_books_id%TYPE;
1870: l_currency_code pn_payment_terms.currency_code%TYPE;
1871: l_rate pn_payment_terms.rate%TYPE;
1872:
1873: l_sched_id_tbl sched_id_tbl_type;

Line 1870: l_currency_code pn_payment_terms.currency_code%TYPE;

1866: l_customer_id pn_payment_terms.customer_id%TYPE;
1867: l_customer_site_use_id pn_payment_terms.customer_site_use_id%TYPE;
1868: l_cust_ship_site_id pn_payment_terms.cust_ship_site_id%TYPE;
1869: l_set_of_books_id pn_payment_terms.set_of_books_id%TYPE;
1870: l_currency_code pn_payment_terms.currency_code%TYPE;
1871: l_rate pn_payment_terms.rate%TYPE;
1872:
1873: l_sched_id_tbl sched_id_tbl_type;
1874: l_sched_dt_tbl date_tbl_type;

Line 1871: l_rate pn_payment_terms.rate%TYPE;

1867: l_customer_site_use_id pn_payment_terms.customer_site_use_id%TYPE;
1868: l_cust_ship_site_id pn_payment_terms.cust_ship_site_id%TYPE;
1869: l_set_of_books_id pn_payment_terms.set_of_books_id%TYPE;
1870: l_currency_code pn_payment_terms.currency_code%TYPE;
1871: l_rate pn_payment_terms.rate%TYPE;
1872:
1873: l_sched_id_tbl sched_id_tbl_type;
1874: l_sched_dt_tbl date_tbl_type;
1875: l_found BOOLEAN;

Line 2039: p_term_hist_id pn_payment_terms_history.term_history_id%TYPE,

2035: -- 14-OCT-04 ftanudja o Created.
2036: -- 14-JAN-05 atuppad o Added code to update total_adj_amount
2037: ------------------------------------------------------------------------------+
2038: PROCEDURE update_terms_history(
2039: p_term_hist_id pn_payment_terms_history.term_history_id%TYPE,
2040: p_adj_type_cd pn_payment_items.last_adjustment_type_code%TYPE,
2041: p_lease_change_id pn_lease_changes.lease_change_id%TYPE,
2042: p_term_id pn_payment_terms.payment_term_id%TYPE
2043: )

Line 2042: p_term_id pn_payment_terms.payment_term_id%TYPE

2038: PROCEDURE update_terms_history(
2039: p_term_hist_id pn_payment_terms_history.term_history_id%TYPE,
2040: p_adj_type_cd pn_payment_items.last_adjustment_type_code%TYPE,
2041: p_lease_change_id pn_lease_changes.lease_change_id%TYPE,
2042: p_term_id pn_payment_terms.payment_term_id%TYPE
2043: )
2044: IS
2045:
2046: -- Get total adj amount

Line 2050: pn_payment_terms_history pth

2046: -- Get total adj amount
2047: CURSOR get_total_adj_amt IS
2048: SELECT SUM(pad.adjustment_amount) total_adj_amount
2049: FROM pn_adjustment_details pad,
2050: pn_payment_terms_history pth
2051: WHERE pth.payment_term_id = p_term_id
2052: AND pth.lease_change_id = p_lease_change_id
2053: AND pad.term_history_id = pth.term_history_id;
2054:

Line 2067: UPDATE pn_payment_terms_history

2063: FOR amt_rec IN get_total_adj_amt LOOP
2064: l_amount := amt_rec.total_adj_amount;
2065: END LOOP;
2066:
2067: UPDATE pn_payment_terms_history
2068: SET adjustment_type_code = p_adj_type_cd,
2069: total_adj_amount = l_amount,
2070: last_update_date = SYSDATE,
2071: last_update_login = fnd_global.login_id,

Line 2099: p_lease_id pn_payment_terms.lease_id%TYPE,

2095: -- prepare_new_items_from_adj and create_adjustment_entries
2096: -- to pass org id.
2097: ------------------------------------------------------------------------------+
2098: PROCEDURE create_retro_adjustments(
2099: p_lease_id pn_payment_terms.lease_id%TYPE,
2100: p_lease_chg_id pn_lease_changes.lease_change_id%TYPE,
2101: p_term_id pn_payment_terms.payment_term_id%TYPE,
2102: p_term_start_dt pn_payment_terms.start_date%TYPE,
2103: p_term_end_dt pn_payment_terms.end_date%TYPE,

Line 2101: p_term_id pn_payment_terms.payment_term_id%TYPE,

2097: ------------------------------------------------------------------------------+
2098: PROCEDURE create_retro_adjustments(
2099: p_lease_id pn_payment_terms.lease_id%TYPE,
2100: p_lease_chg_id pn_lease_changes.lease_change_id%TYPE,
2101: p_term_id pn_payment_terms.payment_term_id%TYPE,
2102: p_term_start_dt pn_payment_terms.start_date%TYPE,
2103: p_term_end_dt pn_payment_terms.end_date%TYPE,
2104: p_term_sch_day pn_payment_terms.schedule_day%TYPE,
2105: p_term_act_amt pn_payment_terms.actual_amount%TYPE,

Line 2102: p_term_start_dt pn_payment_terms.start_date%TYPE,

2098: PROCEDURE create_retro_adjustments(
2099: p_lease_id pn_payment_terms.lease_id%TYPE,
2100: p_lease_chg_id pn_lease_changes.lease_change_id%TYPE,
2101: p_term_id pn_payment_terms.payment_term_id%TYPE,
2102: p_term_start_dt pn_payment_terms.start_date%TYPE,
2103: p_term_end_dt pn_payment_terms.end_date%TYPE,
2104: p_term_sch_day pn_payment_terms.schedule_day%TYPE,
2105: p_term_act_amt pn_payment_terms.actual_amount%TYPE,
2106: p_term_freq pn_payment_terms.frequency_code%TYPE,

Line 2103: p_term_end_dt pn_payment_terms.end_date%TYPE,

2099: p_lease_id pn_payment_terms.lease_id%TYPE,
2100: p_lease_chg_id pn_lease_changes.lease_change_id%TYPE,
2101: p_term_id pn_payment_terms.payment_term_id%TYPE,
2102: p_term_start_dt pn_payment_terms.start_date%TYPE,
2103: p_term_end_dt pn_payment_terms.end_date%TYPE,
2104: p_term_sch_day pn_payment_terms.schedule_day%TYPE,
2105: p_term_act_amt pn_payment_terms.actual_amount%TYPE,
2106: p_term_freq pn_payment_terms.frequency_code%TYPE,
2107: p_term_hist_id pn_payment_terms_history.term_history_id%TYPE,

Line 2104: p_term_sch_day pn_payment_terms.schedule_day%TYPE,

2100: p_lease_chg_id pn_lease_changes.lease_change_id%TYPE,
2101: p_term_id pn_payment_terms.payment_term_id%TYPE,
2102: p_term_start_dt pn_payment_terms.start_date%TYPE,
2103: p_term_end_dt pn_payment_terms.end_date%TYPE,
2104: p_term_sch_day pn_payment_terms.schedule_day%TYPE,
2105: p_term_act_amt pn_payment_terms.actual_amount%TYPE,
2106: p_term_freq pn_payment_terms.frequency_code%TYPE,
2107: p_term_hist_id pn_payment_terms_history.term_history_id%TYPE,
2108: p_adj_type_cd pn_payment_items.last_adjustment_type_code%TYPE

Line 2105: p_term_act_amt pn_payment_terms.actual_amount%TYPE,

2101: p_term_id pn_payment_terms.payment_term_id%TYPE,
2102: p_term_start_dt pn_payment_terms.start_date%TYPE,
2103: p_term_end_dt pn_payment_terms.end_date%TYPE,
2104: p_term_sch_day pn_payment_terms.schedule_day%TYPE,
2105: p_term_act_amt pn_payment_terms.actual_amount%TYPE,
2106: p_term_freq pn_payment_terms.frequency_code%TYPE,
2107: p_term_hist_id pn_payment_terms_history.term_history_id%TYPE,
2108: p_adj_type_cd pn_payment_items.last_adjustment_type_code%TYPE
2109: )

Line 2106: p_term_freq pn_payment_terms.frequency_code%TYPE,

2102: p_term_start_dt pn_payment_terms.start_date%TYPE,
2103: p_term_end_dt pn_payment_terms.end_date%TYPE,
2104: p_term_sch_day pn_payment_terms.schedule_day%TYPE,
2105: p_term_act_amt pn_payment_terms.actual_amount%TYPE,
2106: p_term_freq pn_payment_terms.frequency_code%TYPE,
2107: p_term_hist_id pn_payment_terms_history.term_history_id%TYPE,
2108: p_adj_type_cd pn_payment_items.last_adjustment_type_code%TYPE
2109: )
2110: IS

Line 2107: p_term_hist_id pn_payment_terms_history.term_history_id%TYPE,

2103: p_term_end_dt pn_payment_terms.end_date%TYPE,
2104: p_term_sch_day pn_payment_terms.schedule_day%TYPE,
2105: p_term_act_amt pn_payment_terms.actual_amount%TYPE,
2106: p_term_freq pn_payment_terms.frequency_code%TYPE,
2107: p_term_hist_id pn_payment_terms_history.term_history_id%TYPE,
2108: p_adj_type_cd pn_payment_items.last_adjustment_type_code%TYPE
2109: )
2110: IS
2111: CURSOR get_last_appr_sched IS