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 2006/04/05 22:21:33 appldev noship $ */
3:
4: ------------------------------ DECLARATIONS ----------------------------------+
5:

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

39: l_count NUMBER;
40: l_freq_num NUMBER;
41:
42: l_info VARCHAR2(100);
43: l_desc VARCHAR2(100) := 'pn_retro_adjustment_pkg.create_virtual_schedules';
44:
45: BEGIN
46:
47: pnp_debug_pkg.log(l_desc ||' (+)');

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

194: l_count_adj NUMBER;
195: l_count_orig NUMBER;
196: l_count_summ NUMBER;
197: l_info VARCHAR2(300);
198: l_desc VARCHAR2(100) := 'pn_retro_adjustment_pkg.get_current_schedules';
199:
200: BEGIN
201:
202: pnp_debug_pkg.log(l_desc ||' (+)');

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

405: l_count_curnt NUMBER;
406: l_count_merge NUMBER;
407:
408: l_info VARCHAR2(200);
409: l_desc VARCHAR2(100) := 'pn_retro_adjustment_pkg.merge_schedules';
410:
411: BEGIN
412:
413: pnp_debug_pkg.log(l_desc ||' (+)');

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

598: IS
599: l_freq_num NUMBER;
600: l_start_day NUMBER;
601: l_info VARCHAR2(100);
602: l_desc VARCHAR2(100) := 'pn_retro_adjustment_pkg.find_start_end_dates';
603:
604: BEGIN
605:
606: pnp_debug_pkg.log(l_desc ||' (+)');

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

686: l_start_date pn_adjustment_details.adj_start_date%TYPE;
687: l_end_date pn_adjustment_details.adj_end_date%TYPE;
688:
689: l_info VARCHAR2(100);
690: l_desc VARCHAR2(100) := 'pn_retro_adjustment_pkg.create_adjustment_tables';
691:
692: BEGIN
693:
694: pnp_debug_pkg.log(l_desc ||' (+)');

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

857: l_temp_amt NUMBER;
858: l_exist_draft_adj BOOLEAN;
859:
860: l_info VARCHAR2(100);
861: l_desc VARCHAR2(100) := 'pn_retro_adjustment_pkg.calculate_adjustment_details';
862:
863: BEGIN
864:
865: pnp_debug_pkg.log(l_desc ||' (+)');

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

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);
964: l_desc VARCHAR2(100) := 'pn_retro_adjustment_pkg.prepare_new_items_from_adj';
965:
966: BEGIN
967:
968: pnp_debug_pkg.log(l_desc ||' (+)');

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

1086: l_rowid VARCHAR2(100);
1087: l_found BOOLEAN := FALSE;
1088:
1089: l_info VARCHAR2(100);
1090: l_desc VARCHAR2(100) := 'pn_retro_adjustment_pkg.find_schedule';
1091: l_org_id NUMBER;
1092:
1093: BEGIN
1094:

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

1192: p_sched_tbl IN OUT NOCOPY payment_item_tbl_type
1193: )
1194: IS
1195: l_info VARCHAR2(100);
1196: l_desc VARCHAR2(100) := 'pn_retro_adjustment_pkg.get_schedule_id_for_new_items';
1197:
1198: BEGIN
1199:
1200: pnp_debug_pkg.log(l_desc ||' (+)');

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

1241:
1242: l_payment_id_tbl item_id_tbl_type;
1243:
1244: l_info VARCHAR2(100);
1245: l_desc VARCHAR2(100) := 'pn_retro_adjustment_pkg.remove_item_reference';
1246:
1247: BEGIN
1248:
1249: pnp_debug_pkg.log(l_desc ||' (+)');

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

1331:
1332: l_has_est_amt BOOLEAN;
1333:
1334: l_info VARCHAR2(100);
1335: l_desc VARCHAR2(100) := 'pn_retro_adjustment_pkg.process_items';
1336: l_org_id NUMBER;
1337:
1338: BEGIN
1339:

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

1535: IS
1536: l_mark NUMBER := 0;
1537:
1538: l_info VARCHAR2(100);
1539: l_desc VARCHAR2(100) := 'pn_retro_adjustment_pkg.populate_new_item_id';
1540:
1541: BEGIN
1542:
1543: pnp_debug_pkg.log(l_desc ||' (+)');

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

1608: l_group_num NUMBER := 0;
1609: l_consolidate BOOLEAN;
1610:
1611: l_info VARCHAR2(100);
1612: l_desc VARCHAR2(100) := 'pn_retro_adjustment_pkg.create_adjustment_entries';
1613:
1614: BEGIN
1615:
1616: pnp_debug_pkg.log(l_desc ||' (+)');

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

1854: l_found BOOLEAN;
1855: l_num_item NUMBER;
1856:
1857: l_info VARCHAR2(100);
1858: l_desc VARCHAR2(100) := 'pn_retro_adjustment_pkg.cleanup_schedules';
1859: l_org_id NUMBER;
1860:
1861: BEGIN
1862:

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

2031: AND pth.lease_change_id = p_lease_change_id
2032: AND pad.term_history_id = pth.term_history_id;
2033:
2034: l_info VARCHAR2(100);
2035: l_desc VARCHAR2(100) := 'pn_retro_adjustment_pkg.update_terms_history';
2036: l_amount NUMBER;
2037:
2038: BEGIN
2039:

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

2113: l_adj_table payment_item_tbl_type;
2114:
2115: l_last_appr_dt DATE;
2116: l_info VARCHAR2(100);
2117: l_desc VARCHAR2(100) := 'pn_retro_adjustment_pkg.create_retro_adjustments';
2118: l_org_id NUMBER;
2119:
2120: BEGIN
2121:

Line 2262: END pn_retro_adjustment_pkg;

2258:
2259: END create_retro_adjustments;
2260:
2261:
2262: END pn_retro_adjustment_pkg;