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_RETRO_ADJUSTMENT_PKG

Line 1: PACKAGE BODY pn_retro_adjustment_pkg AS

1: PACKAGE BODY pn_retro_adjustment_pkg AS
2: /* $Header: PNRTADJB.pls 120.5.12010000.2 2009/05/26 07:08:33 rthumma ship $ */
3:
4: ------------------------------ DECLARATIONS ----------------------------------+
5:

Line 44: l_desc VARCHAR2(100) := 'pn_retro_adjustment_pkg.create_virtual_schedules';

40: l_count NUMBER;
41: l_freq_num NUMBER;
42:
43: l_info VARCHAR2(100);
44: l_desc VARCHAR2(100) := 'pn_retro_adjustment_pkg.create_virtual_schedules';
45: l_cal_yr_st_dt pn_leases_all.cal_start%type;
46: l_yr_start_dt DATE;
47: l_sch_str_dt DATE := NULL;
48:

Line 219: l_desc VARCHAR2(100) := 'pn_retro_adjustment_pkg.get_current_schedules';

215: l_count_adj NUMBER;
216: l_count_orig NUMBER;
217: l_count_summ NUMBER;
218: l_info VARCHAR2(300);
219: l_desc VARCHAR2(100) := 'pn_retro_adjustment_pkg.get_current_schedules';
220:
221: BEGIN
222:
223: pnp_debug_pkg.log(l_desc ||' (+)');

Line 430: l_desc VARCHAR2(100) := 'pn_retro_adjustment_pkg.merge_schedules';

426: l_count_curnt NUMBER;
427: l_count_merge NUMBER;
428:
429: l_info VARCHAR2(200);
430: l_desc VARCHAR2(100) := 'pn_retro_adjustment_pkg.merge_schedules';
431:
432: BEGIN
433:
434: pnp_debug_pkg.log(l_desc ||' (+)');

Line 623: l_desc VARCHAR2(100) := 'pn_retro_adjustment_pkg.find_start_end_dates';

619: IS
620: l_freq_num NUMBER;
621: l_start_day NUMBER;
622: l_info VARCHAR2(100);
623: l_desc VARCHAR2(100) := 'pn_retro_adjustment_pkg.find_start_end_dates';
624:
625: BEGIN
626:
627: pnp_debug_pkg.log(l_desc ||' (+)');

Line 711: l_desc VARCHAR2(100) := 'pn_retro_adjustment_pkg.create_adjustment_tables';

707: l_start_date pn_adjustment_details.adj_start_date%TYPE;
708: l_end_date pn_adjustment_details.adj_end_date%TYPE;
709:
710: l_info VARCHAR2(100);
711: l_desc VARCHAR2(100) := 'pn_retro_adjustment_pkg.create_adjustment_tables';
712:
713: BEGIN
714:
715: pnp_debug_pkg.log(l_desc ||' (+)');

Line 882: l_desc VARCHAR2(100) := 'pn_retro_adjustment_pkg.calculate_adjustment_details';

878: l_temp_amt NUMBER;
879: l_exist_draft_adj BOOLEAN;
880:
881: l_info VARCHAR2(100);
882: l_desc VARCHAR2(100) := 'pn_retro_adjustment_pkg.calculate_adjustment_details';
883:
884: BEGIN
885:
886: pnp_debug_pkg.log(l_desc ||' (+)');

Line 985: l_desc VARCHAR2(100) := 'pn_retro_adjustment_pkg.prepare_new_items_from_adj';

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);
985: l_desc VARCHAR2(100) := 'pn_retro_adjustment_pkg.prepare_new_items_from_adj';
986:
987: BEGIN
988:
989: pnp_debug_pkg.log(l_desc ||' (+)');

Line 1111: l_desc VARCHAR2(100) := 'pn_retro_adjustment_pkg.find_schedule';

1107: l_rowid VARCHAR2(100);
1108: l_found BOOLEAN := FALSE;
1109:
1110: l_info VARCHAR2(100);
1111: l_desc VARCHAR2(100) := 'pn_retro_adjustment_pkg.find_schedule';
1112: l_org_id NUMBER;
1113:
1114: BEGIN
1115:

Line 1217: l_desc VARCHAR2(100) := 'pn_retro_adjustment_pkg.get_schedule_id_for_new_items';

1213: p_sched_tbl IN OUT NOCOPY payment_item_tbl_type
1214: )
1215: IS
1216: l_info VARCHAR2(100);
1217: l_desc VARCHAR2(100) := 'pn_retro_adjustment_pkg.get_schedule_id_for_new_items';
1218:
1219: BEGIN
1220:
1221: pnp_debug_pkg.log(l_desc ||' (+)');

Line 1266: l_desc VARCHAR2(100) := 'pn_retro_adjustment_pkg.remove_item_reference';

1262:
1263: l_payment_id_tbl item_id_tbl_type;
1264:
1265: l_info VARCHAR2(100);
1266: l_desc VARCHAR2(100) := 'pn_retro_adjustment_pkg.remove_item_reference';
1267:
1268: BEGIN
1269:
1270: pnp_debug_pkg.log(l_desc ||' (+)');

Line 1356: l_desc VARCHAR2(100) := 'pn_retro_adjustment_pkg.process_items';

1352:
1353: l_has_est_amt BOOLEAN;
1354:
1355: l_info VARCHAR2(100);
1356: l_desc VARCHAR2(100) := 'pn_retro_adjustment_pkg.process_items';
1357: l_org_id NUMBER;
1358:
1359: BEGIN
1360:

Line 1560: l_desc VARCHAR2(100) := 'pn_retro_adjustment_pkg.populate_new_item_id';

1556: IS
1557: l_mark NUMBER := 0;
1558:
1559: l_info VARCHAR2(100);
1560: l_desc VARCHAR2(100) := 'pn_retro_adjustment_pkg.populate_new_item_id';
1561:
1562: BEGIN
1563:
1564: pnp_debug_pkg.log(l_desc ||' (+)');

Line 1633: l_desc VARCHAR2(100) := 'pn_retro_adjustment_pkg.create_adjustment_entries';

1629: l_group_num NUMBER := 0;
1630: l_consolidate BOOLEAN;
1631:
1632: l_info VARCHAR2(100);
1633: l_desc VARCHAR2(100) := 'pn_retro_adjustment_pkg.create_adjustment_entries';
1634:
1635: BEGIN
1636:
1637: pnp_debug_pkg.log(l_desc ||' (+)');

Line 1879: l_desc VARCHAR2(100) := 'pn_retro_adjustment_pkg.cleanup_schedules';

1875: l_found BOOLEAN;
1876: l_num_item NUMBER;
1877:
1878: l_info VARCHAR2(100);
1879: l_desc VARCHAR2(100) := 'pn_retro_adjustment_pkg.cleanup_schedules';
1880: l_org_id NUMBER;
1881:
1882: BEGIN
1883:

Line 2056: l_desc VARCHAR2(100) := 'pn_retro_adjustment_pkg.update_terms_history';

2052: AND pth.lease_change_id = p_lease_change_id
2053: AND pad.term_history_id = pth.term_history_id;
2054:
2055: l_info VARCHAR2(100);
2056: l_desc VARCHAR2(100) := 'pn_retro_adjustment_pkg.update_terms_history';
2057: l_amount NUMBER;
2058:
2059: BEGIN
2060:

Line 2138: l_desc VARCHAR2(100) := 'pn_retro_adjustment_pkg.create_retro_adjustments';

2134: l_adj_table payment_item_tbl_type;
2135:
2136: l_last_appr_dt DATE;
2137: l_info VARCHAR2(100);
2138: l_desc VARCHAR2(100) := 'pn_retro_adjustment_pkg.create_retro_adjustments';
2139: l_org_id NUMBER;
2140:
2141: BEGIN
2142:

Line 2284: END pn_retro_adjustment_pkg;

2280:
2281: END create_retro_adjustments;
2282:
2283:
2284: END pn_retro_adjustment_pkg;