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_SCHEDULES

Line 7: TYPE sched_id_tbl_type IS TABLE OF pn_payment_schedules.payment_schedule_id%TYPE INDEX BY BINARY_INTEGER;

3:
4: ------------------------------ DECLARATIONS ----------------------------------+
5:
6: TYPE item_id_tbl_type IS TABLE OF pn_payment_items.payment_item_id%TYPE INDEX BY BINARY_INTEGER;
7: TYPE sched_id_tbl_type IS TABLE OF pn_payment_schedules.payment_schedule_id%TYPE INDEX BY BINARY_INTEGER;
8: TYPE amt_tbl_type IS TABLE OF pn_payment_items.actual_amount%TYPE INDEX BY BINARY_INTEGER;
9: TYPE date_tbl_type IS TABLE OF pn_payment_items.due_date%TYPE INDEX BY BINARY_INTEGER;
10:
11: bad_input_exception EXCEPTION;

Line 196: pn_payment_schedules_all schedule

192: item.payment_schedule_id,
193: schedule.schedule_date,
194: schedule.payment_status_lookup_code
195: FROM pn_payment_items_all item,
196: pn_payment_schedules_all schedule
197: WHERE item.payment_term_id = p_term_id
198: AND item.payment_schedule_id = schedule.payment_schedule_id
199: AND item.payment_item_type_lookup_code = 'CASH'
200: AND item.last_adjustment_type_code IS NULL

Line 615: p_schedule_dt pn_payment_schedules.schedule_date%TYPE,

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: )
619: IS

Line 861: pn_payment_schedules_all schedule

857: item.actual_amount amount,
858: schedule.payment_schedule_id,
859: schedule.schedule_date
860: FROM pn_payment_items_all item,
861: pn_payment_schedules_all schedule
862: WHERE schedule.payment_schedule_id = item.payment_schedule_id
863: AND schedule.payment_status_lookup_code = 'DRAFT'
864: AND item.payment_item_id IN
865: (SELECT payment_item_id

Line 980: l_sch_dt pn_payment_schedules.schedule_date%TYPE;

976: l_consolidate BOOLEAN;
977: l_use_crnt_month BOOLEAN;
978: l_trx_sysdate BOOLEAN;
979:
980: l_sch_dt pn_payment_schedules.schedule_date%TYPE;
981: l_trx_dt pn_payment_items.due_date%TYPE;
982: l_total_amt pn_payment_items.actual_amount%TYPE;
983:
984: l_info VARCHAR2(100);

Line 1083: p_schedule_date pn_payment_schedules.schedule_date%TYPE,

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
1087: CURSOR fetch_schedule IS

Line 1084: p_schedule_id OUT NOCOPY pn_payment_schedules.payment_schedule_id%TYPE

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
1087: CURSOR fetch_schedule IS
1088: SELECT payment_schedule_id

Line 1089: FROM pn_payment_schedules_all

1085: )
1086: IS
1087: CURSOR fetch_schedule IS
1088: SELECT payment_schedule_id
1089: FROM pn_payment_schedules_all
1090: WHERE schedule_date = p_schedule_date
1091: AND lease_id = p_lease_id
1092: AND payment_status_lookup_code = 'DRAFT';
1093:

Line 1094: CURSOR check_if_sch_belong_to_term(p_sch_id pn_payment_schedules.payment_schedule_id%TYPE) IS

1090: WHERE schedule_date = p_schedule_date
1091: AND lease_id = p_lease_id
1092: AND payment_status_lookup_code = 'DRAFT';
1093:
1094: CURSOR check_if_sch_belong_to_term(p_sch_id pn_payment_schedules.payment_schedule_id%TYPE) IS
1095: SELECT 'Y'
1096: FROM dual
1097: WHERE EXISTS (SELECT NULL
1098: FROM pn_payment_items_all

Line 1792: FROM pn_payment_schedules_all

1788: IS
1789:
1790: CURSOR schedules_draft_cur IS
1791: SELECT payment_schedule_id
1792: FROM pn_payment_schedules_all
1793: WHERE lease_id = p_lease_id
1794: AND payment_status_lookup_code IN ('DRAFT', 'ON_HOLD');
1795:
1796: CURSOR find_payment_items_cur (p_sch_id pn_payment_schedules.payment_schedule_id%TYPE)IS

Line 1796: CURSOR find_payment_items_cur (p_sch_id pn_payment_schedules.payment_schedule_id%TYPE)IS

1792: FROM pn_payment_schedules_all
1793: WHERE lease_id = p_lease_id
1794: AND payment_status_lookup_code IN ('DRAFT', 'ON_HOLD');
1795:
1796: CURSOR find_payment_items_cur (p_sch_id pn_payment_schedules.payment_schedule_id%TYPE)IS
1797: SELECT payment_item_id
1798: FROM pn_payment_items_all item
1799: WHERE item.payment_schedule_id = p_sch_id;
1800:

Line 1818: DELETE pn_payment_schedules_all

1814: IF(l_found = FALSE) THEN
1815:
1816: pnp_debug_pkg.log('Deleting schedule id ........'||schedules_draft_rec.payment_schedule_id);
1817:
1818: DELETE pn_payment_schedules_all
1819: WHERE payment_schedule_id = schedules_draft_rec.payment_schedule_id;
1820:
1821: END IF;
1822:

Line 1845: CURSOR find_cash_items (p_sch_id pn_payment_schedules.payment_schedule_id%TYPE)IS

1841: p_adj_item_tbl payment_item_tbl_type
1842: )
1843: IS
1844:
1845: CURSOR find_cash_items (p_sch_id pn_payment_schedules.payment_schedule_id%TYPE)IS
1846: SELECT SUM(DECODE(item.payment_item_type_lookup_code, 'CASH', 1, 0)) num_cash
1847: FROM pn_payment_items_all item
1848: WHERE item.payment_schedule_id = p_sch_id;
1849:

Line 2015: DELETE pn_payment_schedules_all

2011:
2012: l_info := ' deleting schedule id : '||l_sched_id_tbl(i);
2013: pnp_debug_pkg.log(l_info);
2014:
2015: DELETE pn_payment_schedules_all
2016: WHERE payment_schedule_id = l_sched_id_tbl(i);
2017:
2018: END IF;
2019: END LOOP;

Line 2113: FROM pn_payment_schedules_all

2109: )
2110: IS
2111: CURSOR get_last_appr_sched IS
2112: SELECT max(schedule_date) schedule_date
2113: FROM pn_payment_schedules_all
2114: WHERE lease_id = p_lease_id
2115: AND payment_status_lookup_code = 'APPROVED';
2116:
2117: CURSOR org_id_cur IS