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: x_sched_tbl OUT NOCOPY payment_item_tbl_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: x_sched_tbl OUT NOCOPY payment_item_tbl_type
32: )

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: x_sched_tbl OUT NOCOPY payment_item_tbl_type
32: )
33: IS

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: x_sched_tbl OUT NOCOPY payment_item_tbl_type
32: )
33: IS
34: l_current_end_date pn_payment_terms.end_date%TYPE;

Line 34: l_current_end_date pn_payment_terms.end_date%TYPE;

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

Line 35: l_current_start_date pn_payment_terms.start_date%TYPE;

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

Line 36: l_current_amount pn_payment_terms.actual_amount%TYPE;

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

Line 37: l_dummy_amount pn_payment_terms.actual_amount%TYPE;

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

Line 163: p_term_id pn_payment_terms.payment_term_id%TYPE,

159: -- 27-SEP-04 ftanudja o Created.
160: -- 15-JUL-05 SatyaDeep o Replaced base views with their _ALL tables
161: ------------------------------------------------------------------------------+
162: PROCEDURE get_current_schedules(
163: p_term_id pn_payment_terms.payment_term_id%TYPE,
164: x_sched_tbl OUT NOCOPY payment_item_tbl_type
165: )
166: IS
167: -- NOTE: important that the cursor is ordered by date

Line 591: p_term_freq pn_payment_terms.frequency_code%TYPE,

587: -- 08-OCT-04 ftanudja o Created.
588: -- 14-JAN-05 atuppad o removed least of p_term_end_dt for x_end_date
589: ------------------------------------------------------------------------------+
590: PROCEDURE find_start_end_dates(
591: p_term_freq pn_payment_terms.frequency_code%TYPE,
592: p_term_start_dt pn_payment_terms.start_date%TYPE,
593: p_term_end_dt pn_payment_terms.end_date%TYPE,
594: p_schedule_dt pn_payment_schedules.schedule_date%TYPE,
595: x_start_date OUT NOCOPY pn_payment_items.adj_start_date%TYPE,

Line 592: p_term_start_dt pn_payment_terms.start_date%TYPE,

588: -- 14-JAN-05 atuppad o removed least of p_term_end_dt for x_end_date
589: ------------------------------------------------------------------------------+
590: PROCEDURE find_start_end_dates(
591: p_term_freq pn_payment_terms.frequency_code%TYPE,
592: p_term_start_dt pn_payment_terms.start_date%TYPE,
593: p_term_end_dt pn_payment_terms.end_date%TYPE,
594: p_schedule_dt pn_payment_schedules.schedule_date%TYPE,
595: x_start_date OUT NOCOPY pn_payment_items.adj_start_date%TYPE,
596: x_end_date OUT NOCOPY pn_payment_items.adj_end_date%TYPE

Line 593: p_term_end_dt pn_payment_terms.end_date%TYPE,

589: ------------------------------------------------------------------------------+
590: PROCEDURE find_start_end_dates(
591: p_term_freq pn_payment_terms.frequency_code%TYPE,
592: p_term_start_dt pn_payment_terms.start_date%TYPE,
593: p_term_end_dt pn_payment_terms.end_date%TYPE,
594: p_schedule_dt pn_payment_schedules.schedule_date%TYPE,
595: x_start_date OUT NOCOPY pn_payment_items.adj_start_date%TYPE,
596: x_end_date OUT NOCOPY pn_payment_items.adj_end_date%TYPE
597: )

Line 671: p_term_freq pn_payment_terms.frequency_code%TYPE,

667: ------------------------------------------------------------------------------+
668: PROCEDURE create_adjustment_tables (
669: p_sched_table payment_item_tbl_type,
670: p_last_appr_dt DATE,
671: p_term_freq pn_payment_terms.frequency_code%TYPE,
672: p_term_start_dt pn_payment_terms.start_date%TYPE,
673: p_term_end_dt pn_payment_terms.end_date%TYPE,
674: x_new_orig_table OUT NOCOPY payment_item_tbl_type,
675: x_upd_orig_table OUT NOCOPY payment_item_tbl_type,

Line 672: p_term_start_dt pn_payment_terms.start_date%TYPE,

668: PROCEDURE create_adjustment_tables (
669: p_sched_table payment_item_tbl_type,
670: p_last_appr_dt DATE,
671: p_term_freq pn_payment_terms.frequency_code%TYPE,
672: p_term_start_dt pn_payment_terms.start_date%TYPE,
673: p_term_end_dt pn_payment_terms.end_date%TYPE,
674: x_new_orig_table OUT NOCOPY payment_item_tbl_type,
675: x_upd_orig_table OUT NOCOPY payment_item_tbl_type,
676: x_del_orig_table OUT NOCOPY payment_item_tbl_type,

Line 673: p_term_end_dt pn_payment_terms.end_date%TYPE,

669: p_sched_table payment_item_tbl_type,
670: p_last_appr_dt DATE,
671: p_term_freq pn_payment_terms.frequency_code%TYPE,
672: p_term_start_dt pn_payment_terms.start_date%TYPE,
673: p_term_end_dt pn_payment_terms.end_date%TYPE,
674: x_new_orig_table OUT NOCOPY payment_item_tbl_type,
675: x_upd_orig_table OUT NOCOPY payment_item_tbl_type,
676: x_del_orig_table OUT NOCOPY payment_item_tbl_type,
677: x_adj_table OUT NOCOPY payment_item_tbl_type

Line 947: p_sch_day pn_payment_terms.schedule_day%TYPE,

943: -- 05-OCT-04 ftanudja o Created.
944: -- 10-AUG-05 piagrawa o Bug#4284035 - Modified the signature to pass org id
945: ------------------------------------------------------------------------------+
946: PROCEDURE prepare_new_items_from_adj (
947: p_sch_day pn_payment_terms.schedule_day%TYPE,
948: p_item_adj_tbl IN OUT NOCOPY payment_item_tbl_type,
949: p_org_id NUMBER
950: )
951: IS

Line 1061: p_term_id pn_payment_terms.payment_term_id%TYPE,

1057: ------------------------------------------------------------------------------+
1058: PROCEDURE find_schedule (
1059: p_lease_id pn_leases.lease_id%TYPE,
1060: p_lease_change_id pn_lease_changes.lease_change_id%TYPE,
1061: p_term_id pn_payment_terms.payment_term_id%TYPE,
1062: p_schedule_date pn_payment_schedules.schedule_date%TYPE,
1063: p_schedule_id OUT NOCOPY pn_payment_schedules.payment_schedule_id%TYPE
1064: )
1065: IS

Line 1190: p_term_id pn_payment_terms.payment_term_id%TYPE,

1186: -- 05-OCT-04 ftanudja o Created.
1187: ------------------------------------------------------------------------------+
1188: PROCEDURE get_schedule_id_for_new_items(
1189: p_lease_id pn_leases.lease_id%TYPE,
1190: p_term_id pn_payment_terms.payment_term_id%TYPE,
1191: p_lease_change_id pn_lease_changes.lease_change_id%TYPE,
1192: p_sched_tbl IN OUT NOCOPY payment_item_tbl_type
1193: )
1194: IS

Line 1288: p_term_id pn_payment_terms.payment_term_id%TYPE,

1284: -- 05-OCT-04 ftanudja o Created.
1285: -- 15-JUL-05 SatyaDeep o Replaced base views with their _ALL tables
1286: ------------------------------------------------------------------------------+
1287: PROCEDURE process_items(
1288: p_term_id pn_payment_terms.payment_term_id%TYPE,
1289: p_adj_type_cd pn_payment_items.last_adjustment_type_code%TYPE,
1290: p_upd_item_tbl payment_item_tbl_type,
1291: p_del_item_tbl payment_item_tbl_type,
1292: p_new_item_tbl IN OUT NOCOPY payment_item_tbl_type

Line 1307: FROM pn_payment_terms_all

1303: currency_code,
1304: rate,
1305: estimated_amount,
1306: org_id
1307: FROM pn_payment_terms_all
1308: WHERE payment_term_id = p_term_id;
1309:
1310: l_new_itm_id_tbl item_id_tbl_type;
1311: l_payment_id_tbl item_id_tbl_type;

Line 1319: l_vendor_id pn_payment_terms.vendor_id%TYPE;

1315: l_trx_date_tbl date_tbl_type;
1316: l_start_date_tbl date_tbl_type;
1317: l_end_date_tbl date_tbl_type;
1318:
1319: l_vendor_id pn_payment_terms.vendor_id%TYPE;
1320: l_vendor_site_id pn_payment_terms.vendor_site_id%TYPE;
1321: l_customer_id pn_payment_terms.customer_id%TYPE;
1322: l_customer_site_use_id pn_payment_terms.customer_site_use_id%TYPE;
1323: l_cust_ship_site_id pn_payment_terms.cust_ship_site_id%TYPE;

Line 1320: l_vendor_site_id pn_payment_terms.vendor_site_id%TYPE;

1316: l_start_date_tbl date_tbl_type;
1317: l_end_date_tbl date_tbl_type;
1318:
1319: l_vendor_id pn_payment_terms.vendor_id%TYPE;
1320: l_vendor_site_id pn_payment_terms.vendor_site_id%TYPE;
1321: l_customer_id pn_payment_terms.customer_id%TYPE;
1322: l_customer_site_use_id pn_payment_terms.customer_site_use_id%TYPE;
1323: l_cust_ship_site_id pn_payment_terms.cust_ship_site_id%TYPE;
1324: l_set_of_books_id pn_payment_terms.set_of_books_id%TYPE;

Line 1321: l_customer_id pn_payment_terms.customer_id%TYPE;

1317: l_end_date_tbl date_tbl_type;
1318:
1319: l_vendor_id pn_payment_terms.vendor_id%TYPE;
1320: l_vendor_site_id pn_payment_terms.vendor_site_id%TYPE;
1321: l_customer_id pn_payment_terms.customer_id%TYPE;
1322: l_customer_site_use_id pn_payment_terms.customer_site_use_id%TYPE;
1323: l_cust_ship_site_id pn_payment_terms.cust_ship_site_id%TYPE;
1324: l_set_of_books_id pn_payment_terms.set_of_books_id%TYPE;
1325: l_currency_code pn_payment_terms.currency_code%TYPE;

Line 1322: l_customer_site_use_id pn_payment_terms.customer_site_use_id%TYPE;

1318:
1319: l_vendor_id pn_payment_terms.vendor_id%TYPE;
1320: l_vendor_site_id pn_payment_terms.vendor_site_id%TYPE;
1321: l_customer_id pn_payment_terms.customer_id%TYPE;
1322: l_customer_site_use_id pn_payment_terms.customer_site_use_id%TYPE;
1323: l_cust_ship_site_id pn_payment_terms.cust_ship_site_id%TYPE;
1324: l_set_of_books_id pn_payment_terms.set_of_books_id%TYPE;
1325: l_currency_code pn_payment_terms.currency_code%TYPE;
1326: l_rate pn_payment_terms.rate%TYPE;

Line 1323: l_cust_ship_site_id pn_payment_terms.cust_ship_site_id%TYPE;

1319: l_vendor_id pn_payment_terms.vendor_id%TYPE;
1320: l_vendor_site_id pn_payment_terms.vendor_site_id%TYPE;
1321: l_customer_id pn_payment_terms.customer_id%TYPE;
1322: l_customer_site_use_id pn_payment_terms.customer_site_use_id%TYPE;
1323: l_cust_ship_site_id pn_payment_terms.cust_ship_site_id%TYPE;
1324: l_set_of_books_id pn_payment_terms.set_of_books_id%TYPE;
1325: l_currency_code pn_payment_terms.currency_code%TYPE;
1326: l_rate pn_payment_terms.rate%TYPE;
1327:

Line 1324: l_set_of_books_id pn_payment_terms.set_of_books_id%TYPE;

1320: l_vendor_site_id pn_payment_terms.vendor_site_id%TYPE;
1321: l_customer_id pn_payment_terms.customer_id%TYPE;
1322: l_customer_site_use_id pn_payment_terms.customer_site_use_id%TYPE;
1323: l_cust_ship_site_id pn_payment_terms.cust_ship_site_id%TYPE;
1324: l_set_of_books_id pn_payment_terms.set_of_books_id%TYPE;
1325: l_currency_code pn_payment_terms.currency_code%TYPE;
1326: l_rate pn_payment_terms.rate%TYPE;
1327:
1328: l_precision NUMBER;

Line 1325: l_currency_code pn_payment_terms.currency_code%TYPE;

1321: l_customer_id pn_payment_terms.customer_id%TYPE;
1322: l_customer_site_use_id pn_payment_terms.customer_site_use_id%TYPE;
1323: l_cust_ship_site_id pn_payment_terms.cust_ship_site_id%TYPE;
1324: l_set_of_books_id pn_payment_terms.set_of_books_id%TYPE;
1325: l_currency_code pn_payment_terms.currency_code%TYPE;
1326: l_rate pn_payment_terms.rate%TYPE;
1327:
1328: l_precision NUMBER;
1329: l_ext_precision NUMBER;

Line 1326: l_rate pn_payment_terms.rate%TYPE;

1322: l_customer_site_use_id pn_payment_terms.customer_site_use_id%TYPE;
1323: l_cust_ship_site_id pn_payment_terms.cust_ship_site_id%TYPE;
1324: l_set_of_books_id pn_payment_terms.set_of_books_id%TYPE;
1325: l_currency_code pn_payment_terms.currency_code%TYPE;
1326: l_rate pn_payment_terms.rate%TYPE;
1327:
1328: l_precision NUMBER;
1329: l_ext_precision NUMBER;
1330: l_min_acct_unit NUMBER;

Line 1595: p_term_id pn_payment_terms.payment_term_id%TYPE,

1591: -- 06-OCT-04 ftanudja o Created.
1592: -- 10-AUG-05 piagrawa o Bug#4284035 - Modified the signature to pass org id.
1593: ------------------------------------------------------------------------------+
1594: PROCEDURE create_adjustment_entries(
1595: p_term_id pn_payment_terms.payment_term_id%TYPE,
1596: p_term_freq pn_payment_terms.frequency_code%TYPE,
1597: p_term_start_dt pn_payment_terms.start_date%TYPE,
1598: p_term_end_dt pn_payment_terms.end_date%TYPE,
1599: p_term_hist_id pn_payment_terms_history.term_history_id%TYPE,

Line 1596: p_term_freq pn_payment_terms.frequency_code%TYPE,

1592: -- 10-AUG-05 piagrawa o Bug#4284035 - Modified the signature to pass org id.
1593: ------------------------------------------------------------------------------+
1594: PROCEDURE create_adjustment_entries(
1595: p_term_id pn_payment_terms.payment_term_id%TYPE,
1596: p_term_freq pn_payment_terms.frequency_code%TYPE,
1597: p_term_start_dt pn_payment_terms.start_date%TYPE,
1598: p_term_end_dt pn_payment_terms.end_date%TYPE,
1599: p_term_hist_id pn_payment_terms_history.term_history_id%TYPE,
1600: p_adj_table payment_item_tbl_type,

Line 1597: p_term_start_dt pn_payment_terms.start_date%TYPE,

1593: ------------------------------------------------------------------------------+
1594: PROCEDURE create_adjustment_entries(
1595: p_term_id pn_payment_terms.payment_term_id%TYPE,
1596: p_term_freq pn_payment_terms.frequency_code%TYPE,
1597: p_term_start_dt pn_payment_terms.start_date%TYPE,
1598: p_term_end_dt pn_payment_terms.end_date%TYPE,
1599: p_term_hist_id pn_payment_terms_history.term_history_id%TYPE,
1600: p_adj_table payment_item_tbl_type,
1601: p_org_id NUMBER

Line 1598: p_term_end_dt pn_payment_terms.end_date%TYPE,

1594: PROCEDURE create_adjustment_entries(
1595: p_term_id pn_payment_terms.payment_term_id%TYPE,
1596: p_term_freq pn_payment_terms.frequency_code%TYPE,
1597: p_term_start_dt pn_payment_terms.start_date%TYPE,
1598: p_term_end_dt pn_payment_terms.end_date%TYPE,
1599: p_term_hist_id pn_payment_terms_history.term_history_id%TYPE,
1600: p_adj_table payment_item_tbl_type,
1601: p_org_id NUMBER
1602: )

Line 1599: p_term_hist_id pn_payment_terms_history.term_history_id%TYPE,

1595: p_term_id pn_payment_terms.payment_term_id%TYPE,
1596: p_term_freq pn_payment_terms.frequency_code%TYPE,
1597: p_term_start_dt pn_payment_terms.start_date%TYPE,
1598: p_term_end_dt pn_payment_terms.end_date%TYPE,
1599: p_term_hist_id pn_payment_terms_history.term_history_id%TYPE,
1600: p_adj_table payment_item_tbl_type,
1601: p_org_id NUMBER
1602: )
1603: IS

Line 1818: p_term_id pn_payment_terms.payment_term_id%TYPE,

1814: -- 08-OCT-04 ftanudja o Created.
1815: -- 15-JUL-05 SatyaDeep o Replaced base views with their _ALL tables
1816: ------------------------------------------------------------------------------+
1817: PROCEDURE cleanup_schedules(
1818: p_term_id pn_payment_terms.payment_term_id%TYPE,
1819: p_orig_item_tbl payment_item_tbl_type,
1820: p_adj_item_tbl payment_item_tbl_type
1821: )
1822: IS

Line 1840: FROM pn_payment_terms_all

1836: currency_code,
1837: rate,
1838: estimated_amount,
1839: org_id
1840: FROM pn_payment_terms_all
1841: WHERE payment_term_id = p_term_id;
1842:
1843: l_vendor_id pn_payment_terms.vendor_id%TYPE;
1844: l_vendor_site_id pn_payment_terms.vendor_site_id%TYPE;

Line 1843: l_vendor_id pn_payment_terms.vendor_id%TYPE;

1839: org_id
1840: FROM pn_payment_terms_all
1841: WHERE payment_term_id = p_term_id;
1842:
1843: l_vendor_id pn_payment_terms.vendor_id%TYPE;
1844: l_vendor_site_id pn_payment_terms.vendor_site_id%TYPE;
1845: l_customer_id pn_payment_terms.customer_id%TYPE;
1846: l_customer_site_use_id pn_payment_terms.customer_site_use_id%TYPE;
1847: l_cust_ship_site_id pn_payment_terms.cust_ship_site_id%TYPE;

Line 1844: l_vendor_site_id pn_payment_terms.vendor_site_id%TYPE;

1840: FROM pn_payment_terms_all
1841: WHERE payment_term_id = p_term_id;
1842:
1843: l_vendor_id pn_payment_terms.vendor_id%TYPE;
1844: l_vendor_site_id pn_payment_terms.vendor_site_id%TYPE;
1845: l_customer_id pn_payment_terms.customer_id%TYPE;
1846: l_customer_site_use_id pn_payment_terms.customer_site_use_id%TYPE;
1847: l_cust_ship_site_id pn_payment_terms.cust_ship_site_id%TYPE;
1848: l_set_of_books_id pn_payment_terms.set_of_books_id%TYPE;

Line 1845: l_customer_id pn_payment_terms.customer_id%TYPE;

1841: WHERE payment_term_id = p_term_id;
1842:
1843: l_vendor_id pn_payment_terms.vendor_id%TYPE;
1844: l_vendor_site_id pn_payment_terms.vendor_site_id%TYPE;
1845: l_customer_id pn_payment_terms.customer_id%TYPE;
1846: l_customer_site_use_id pn_payment_terms.customer_site_use_id%TYPE;
1847: l_cust_ship_site_id pn_payment_terms.cust_ship_site_id%TYPE;
1848: l_set_of_books_id pn_payment_terms.set_of_books_id%TYPE;
1849: l_currency_code pn_payment_terms.currency_code%TYPE;

Line 1846: l_customer_site_use_id pn_payment_terms.customer_site_use_id%TYPE;

1842:
1843: l_vendor_id pn_payment_terms.vendor_id%TYPE;
1844: l_vendor_site_id pn_payment_terms.vendor_site_id%TYPE;
1845: l_customer_id pn_payment_terms.customer_id%TYPE;
1846: l_customer_site_use_id pn_payment_terms.customer_site_use_id%TYPE;
1847: l_cust_ship_site_id pn_payment_terms.cust_ship_site_id%TYPE;
1848: l_set_of_books_id pn_payment_terms.set_of_books_id%TYPE;
1849: l_currency_code pn_payment_terms.currency_code%TYPE;
1850: l_rate pn_payment_terms.rate%TYPE;

Line 1847: l_cust_ship_site_id pn_payment_terms.cust_ship_site_id%TYPE;

1843: l_vendor_id pn_payment_terms.vendor_id%TYPE;
1844: l_vendor_site_id pn_payment_terms.vendor_site_id%TYPE;
1845: l_customer_id pn_payment_terms.customer_id%TYPE;
1846: l_customer_site_use_id pn_payment_terms.customer_site_use_id%TYPE;
1847: l_cust_ship_site_id pn_payment_terms.cust_ship_site_id%TYPE;
1848: l_set_of_books_id pn_payment_terms.set_of_books_id%TYPE;
1849: l_currency_code pn_payment_terms.currency_code%TYPE;
1850: l_rate pn_payment_terms.rate%TYPE;
1851:

Line 1848: l_set_of_books_id pn_payment_terms.set_of_books_id%TYPE;

1844: l_vendor_site_id pn_payment_terms.vendor_site_id%TYPE;
1845: l_customer_id pn_payment_terms.customer_id%TYPE;
1846: l_customer_site_use_id pn_payment_terms.customer_site_use_id%TYPE;
1847: l_cust_ship_site_id pn_payment_terms.cust_ship_site_id%TYPE;
1848: l_set_of_books_id pn_payment_terms.set_of_books_id%TYPE;
1849: l_currency_code pn_payment_terms.currency_code%TYPE;
1850: l_rate pn_payment_terms.rate%TYPE;
1851:
1852: l_sched_id_tbl sched_id_tbl_type;

Line 1849: l_currency_code pn_payment_terms.currency_code%TYPE;

1845: l_customer_id pn_payment_terms.customer_id%TYPE;
1846: l_customer_site_use_id pn_payment_terms.customer_site_use_id%TYPE;
1847: l_cust_ship_site_id pn_payment_terms.cust_ship_site_id%TYPE;
1848: l_set_of_books_id pn_payment_terms.set_of_books_id%TYPE;
1849: l_currency_code pn_payment_terms.currency_code%TYPE;
1850: l_rate pn_payment_terms.rate%TYPE;
1851:
1852: l_sched_id_tbl sched_id_tbl_type;
1853: l_sched_dt_tbl date_tbl_type;

Line 1850: l_rate pn_payment_terms.rate%TYPE;

1846: l_customer_site_use_id pn_payment_terms.customer_site_use_id%TYPE;
1847: l_cust_ship_site_id pn_payment_terms.cust_ship_site_id%TYPE;
1848: l_set_of_books_id pn_payment_terms.set_of_books_id%TYPE;
1849: l_currency_code pn_payment_terms.currency_code%TYPE;
1850: l_rate pn_payment_terms.rate%TYPE;
1851:
1852: l_sched_id_tbl sched_id_tbl_type;
1853: l_sched_dt_tbl date_tbl_type;
1854: l_found BOOLEAN;

Line 2018: p_term_hist_id pn_payment_terms_history.term_history_id%TYPE,

2014: -- 14-OCT-04 ftanudja o Created.
2015: -- 14-JAN-05 atuppad o Added code to update total_adj_amount
2016: ------------------------------------------------------------------------------+
2017: PROCEDURE update_terms_history(
2018: p_term_hist_id pn_payment_terms_history.term_history_id%TYPE,
2019: p_adj_type_cd pn_payment_items.last_adjustment_type_code%TYPE,
2020: p_lease_change_id pn_lease_changes.lease_change_id%TYPE,
2021: p_term_id pn_payment_terms.payment_term_id%TYPE
2022: )

Line 2021: p_term_id pn_payment_terms.payment_term_id%TYPE

2017: PROCEDURE update_terms_history(
2018: p_term_hist_id pn_payment_terms_history.term_history_id%TYPE,
2019: p_adj_type_cd pn_payment_items.last_adjustment_type_code%TYPE,
2020: p_lease_change_id pn_lease_changes.lease_change_id%TYPE,
2021: p_term_id pn_payment_terms.payment_term_id%TYPE
2022: )
2023: IS
2024:
2025: -- Get total adj amount

Line 2029: pn_payment_terms_history pth

2025: -- Get total adj amount
2026: CURSOR get_total_adj_amt IS
2027: SELECT SUM(pad.adjustment_amount) total_adj_amount
2028: FROM pn_adjustment_details pad,
2029: pn_payment_terms_history pth
2030: WHERE pth.payment_term_id = p_term_id
2031: AND pth.lease_change_id = p_lease_change_id
2032: AND pad.term_history_id = pth.term_history_id;
2033:

Line 2046: UPDATE pn_payment_terms_history

2042: FOR amt_rec IN get_total_adj_amt LOOP
2043: l_amount := amt_rec.total_adj_amount;
2044: END LOOP;
2045:
2046: UPDATE pn_payment_terms_history
2047: SET adjustment_type_code = p_adj_type_cd,
2048: total_adj_amount = l_amount,
2049: last_update_date = SYSDATE,
2050: last_update_login = fnd_global.login_id,

Line 2078: p_lease_id pn_payment_terms.lease_id%TYPE,

2074: -- prepare_new_items_from_adj and create_adjustment_entries
2075: -- to pass org id.
2076: ------------------------------------------------------------------------------+
2077: PROCEDURE create_retro_adjustments(
2078: p_lease_id pn_payment_terms.lease_id%TYPE,
2079: p_lease_chg_id pn_lease_changes.lease_change_id%TYPE,
2080: p_term_id pn_payment_terms.payment_term_id%TYPE,
2081: p_term_start_dt pn_payment_terms.start_date%TYPE,
2082: p_term_end_dt pn_payment_terms.end_date%TYPE,

Line 2080: p_term_id pn_payment_terms.payment_term_id%TYPE,

2076: ------------------------------------------------------------------------------+
2077: PROCEDURE create_retro_adjustments(
2078: p_lease_id pn_payment_terms.lease_id%TYPE,
2079: p_lease_chg_id pn_lease_changes.lease_change_id%TYPE,
2080: p_term_id pn_payment_terms.payment_term_id%TYPE,
2081: p_term_start_dt pn_payment_terms.start_date%TYPE,
2082: p_term_end_dt pn_payment_terms.end_date%TYPE,
2083: p_term_sch_day pn_payment_terms.schedule_day%TYPE,
2084: p_term_act_amt pn_payment_terms.actual_amount%TYPE,

Line 2081: p_term_start_dt pn_payment_terms.start_date%TYPE,

2077: PROCEDURE create_retro_adjustments(
2078: p_lease_id pn_payment_terms.lease_id%TYPE,
2079: p_lease_chg_id pn_lease_changes.lease_change_id%TYPE,
2080: p_term_id pn_payment_terms.payment_term_id%TYPE,
2081: p_term_start_dt pn_payment_terms.start_date%TYPE,
2082: p_term_end_dt pn_payment_terms.end_date%TYPE,
2083: p_term_sch_day pn_payment_terms.schedule_day%TYPE,
2084: p_term_act_amt pn_payment_terms.actual_amount%TYPE,
2085: p_term_freq pn_payment_terms.frequency_code%TYPE,

Line 2082: p_term_end_dt pn_payment_terms.end_date%TYPE,

2078: p_lease_id pn_payment_terms.lease_id%TYPE,
2079: p_lease_chg_id pn_lease_changes.lease_change_id%TYPE,
2080: p_term_id pn_payment_terms.payment_term_id%TYPE,
2081: p_term_start_dt pn_payment_terms.start_date%TYPE,
2082: p_term_end_dt pn_payment_terms.end_date%TYPE,
2083: p_term_sch_day pn_payment_terms.schedule_day%TYPE,
2084: p_term_act_amt pn_payment_terms.actual_amount%TYPE,
2085: p_term_freq pn_payment_terms.frequency_code%TYPE,
2086: p_term_hist_id pn_payment_terms_history.term_history_id%TYPE,

Line 2083: p_term_sch_day pn_payment_terms.schedule_day%TYPE,

2079: p_lease_chg_id pn_lease_changes.lease_change_id%TYPE,
2080: p_term_id pn_payment_terms.payment_term_id%TYPE,
2081: p_term_start_dt pn_payment_terms.start_date%TYPE,
2082: p_term_end_dt pn_payment_terms.end_date%TYPE,
2083: p_term_sch_day pn_payment_terms.schedule_day%TYPE,
2084: p_term_act_amt pn_payment_terms.actual_amount%TYPE,
2085: p_term_freq pn_payment_terms.frequency_code%TYPE,
2086: p_term_hist_id pn_payment_terms_history.term_history_id%TYPE,
2087: p_adj_type_cd pn_payment_items.last_adjustment_type_code%TYPE

Line 2084: p_term_act_amt pn_payment_terms.actual_amount%TYPE,

2080: p_term_id pn_payment_terms.payment_term_id%TYPE,
2081: p_term_start_dt pn_payment_terms.start_date%TYPE,
2082: p_term_end_dt pn_payment_terms.end_date%TYPE,
2083: p_term_sch_day pn_payment_terms.schedule_day%TYPE,
2084: p_term_act_amt pn_payment_terms.actual_amount%TYPE,
2085: p_term_freq pn_payment_terms.frequency_code%TYPE,
2086: p_term_hist_id pn_payment_terms_history.term_history_id%TYPE,
2087: p_adj_type_cd pn_payment_items.last_adjustment_type_code%TYPE
2088: )

Line 2085: p_term_freq pn_payment_terms.frequency_code%TYPE,

2081: p_term_start_dt pn_payment_terms.start_date%TYPE,
2082: p_term_end_dt pn_payment_terms.end_date%TYPE,
2083: p_term_sch_day pn_payment_terms.schedule_day%TYPE,
2084: p_term_act_amt pn_payment_terms.actual_amount%TYPE,
2085: p_term_freq pn_payment_terms.frequency_code%TYPE,
2086: p_term_hist_id pn_payment_terms_history.term_history_id%TYPE,
2087: p_adj_type_cd pn_payment_items.last_adjustment_type_code%TYPE
2088: )
2089: IS

Line 2086: p_term_hist_id pn_payment_terms_history.term_history_id%TYPE,

2082: p_term_end_dt pn_payment_terms.end_date%TYPE,
2083: p_term_sch_day pn_payment_terms.schedule_day%TYPE,
2084: p_term_act_amt pn_payment_terms.actual_amount%TYPE,
2085: p_term_freq pn_payment_terms.frequency_code%TYPE,
2086: p_term_hist_id pn_payment_terms_history.term_history_id%TYPE,
2087: p_adj_type_cd pn_payment_items.last_adjustment_type_code%TYPE
2088: )
2089: IS
2090: CURSOR get_last_appr_sched IS