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 175: pn_payment_schedules_all schedule

171: item.payment_schedule_id,
172: schedule.schedule_date,
173: schedule.payment_status_lookup_code
174: FROM pn_payment_items_all item,
175: pn_payment_schedules_all schedule
176: WHERE item.payment_term_id = p_term_id
177: AND item.payment_schedule_id = schedule.payment_schedule_id
178: AND item.payment_item_type_lookup_code = 'CASH'
179: AND item.last_adjustment_type_code IS NULL

Line 594: p_schedule_dt pn_payment_schedules.schedule_date%TYPE,

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

Line 840: pn_payment_schedules_all schedule

836: item.actual_amount amount,
837: schedule.payment_schedule_id,
838: schedule.schedule_date
839: FROM pn_payment_items_all item,
840: pn_payment_schedules_all schedule
841: WHERE schedule.payment_schedule_id = item.payment_schedule_id
842: AND schedule.payment_status_lookup_code = 'DRAFT'
843: AND item.payment_item_id IN
844: (SELECT payment_item_id

Line 959: l_sch_dt pn_payment_schedules.schedule_date%TYPE;

955: l_consolidate BOOLEAN;
956: l_use_crnt_month BOOLEAN;
957: l_trx_sysdate BOOLEAN;
958:
959: l_sch_dt pn_payment_schedules.schedule_date%TYPE;
960: l_trx_dt pn_payment_items.due_date%TYPE;
961: l_total_amt pn_payment_items.actual_amount%TYPE;
962:
963: l_info VARCHAR2(100);

Line 1062: p_schedule_date pn_payment_schedules.schedule_date%TYPE,

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

Line 1063: p_schedule_id OUT NOCOPY pn_payment_schedules.payment_schedule_id%TYPE

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
1066: CURSOR fetch_schedule IS
1067: SELECT payment_schedule_id

Line 1068: FROM pn_payment_schedules_all

1064: )
1065: IS
1066: CURSOR fetch_schedule IS
1067: SELECT payment_schedule_id
1068: FROM pn_payment_schedules_all
1069: WHERE schedule_date = p_schedule_date
1070: AND lease_id = p_lease_id
1071: AND payment_status_lookup_code = 'DRAFT';
1072:

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

1069: WHERE schedule_date = p_schedule_date
1070: AND lease_id = p_lease_id
1071: AND payment_status_lookup_code = 'DRAFT';
1072:
1073: CURSOR check_if_sch_belong_to_term(p_sch_id pn_payment_schedules.payment_schedule_id%TYPE) IS
1074: SELECT 'Y'
1075: FROM dual
1076: WHERE EXISTS (SELECT NULL
1077: FROM pn_payment_items_all

Line 1771: FROM pn_payment_schedules_all

1767: IS
1768:
1769: CURSOR schedules_draft_cur IS
1770: SELECT payment_schedule_id
1771: FROM pn_payment_schedules_all
1772: WHERE lease_id = p_lease_id
1773: AND payment_status_lookup_code IN ('DRAFT', 'ON_HOLD');
1774:
1775: CURSOR find_payment_items_cur (p_sch_id pn_payment_schedules.payment_schedule_id%TYPE)IS

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

1771: FROM pn_payment_schedules_all
1772: WHERE lease_id = p_lease_id
1773: AND payment_status_lookup_code IN ('DRAFT', 'ON_HOLD');
1774:
1775: CURSOR find_payment_items_cur (p_sch_id pn_payment_schedules.payment_schedule_id%TYPE)IS
1776: SELECT payment_item_id
1777: FROM pn_payment_items_all item
1778: WHERE item.payment_schedule_id = p_sch_id;
1779:

Line 1797: DELETE pn_payment_schedules_all

1793: IF(l_found = FALSE) THEN
1794:
1795: pnp_debug_pkg.log('Deleting schedule id ........'||schedules_draft_rec.payment_schedule_id);
1796:
1797: DELETE pn_payment_schedules_all
1798: WHERE payment_schedule_id = schedules_draft_rec.payment_schedule_id;
1799:
1800: END IF;
1801:

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

1820: p_adj_item_tbl payment_item_tbl_type
1821: )
1822: IS
1823:
1824: CURSOR find_cash_items (p_sch_id pn_payment_schedules.payment_schedule_id%TYPE)IS
1825: SELECT SUM(DECODE(item.payment_item_type_lookup_code, 'CASH', 1, 0)) num_cash
1826: FROM pn_payment_items_all item
1827: WHERE item.payment_schedule_id = p_sch_id;
1828:

Line 1994: DELETE pn_payment_schedules_all

1990:
1991: l_info := ' deleting schedule id : '||l_sched_id_tbl(i);
1992: pnp_debug_pkg.log(l_info);
1993:
1994: DELETE pn_payment_schedules_all
1995: WHERE payment_schedule_id = l_sched_id_tbl(i);
1996:
1997: END IF;
1998: END LOOP;

Line 2092: FROM pn_payment_schedules_all

2088: )
2089: IS
2090: CURSOR get_last_appr_sched IS
2091: SELECT max(schedule_date) schedule_date
2092: FROM pn_payment_schedules_all
2093: WHERE lease_id = p_lease_id
2094: AND payment_status_lookup_code = 'APPROVED';
2095:
2096: CURSOR org_id_cur IS