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_VAR_ABATEMENT_AMOUNT_PKG dependencies on PN_VAR_ABATEMENT_AMOUNT_PKG

Line 1: PACKAGE BODY pn_var_abatement_amount_pkg AS

1: PACKAGE BODY pn_var_abatement_amount_pkg AS
2: -- $Header: PNVRCABB.pls 120.8 2007/05/31 11:40:21 sraaj noship $
3:
4: -------------------------------------------------------------------------------
5: -- FUNCTION : calc_abatement

Line 35: AND abt.include_term = pn_var_abatement_amount_pkg.G_INCLUDE_TERM_YES

31: AND inv1.invoice_date = inv2.invoice_date
32: AND inv1.var_rent_inv_id = p_var_rent_inv_id
33: AND inv2.true_up_amt IS NULL
34: AND inv2.adjust_num =0)
35: AND abt.include_term = pn_var_abatement_amount_pkg.G_INCLUDE_TERM_YES
36: AND inv.var_rent_inv_id = p_var_rent_inv_id --BUG#2452909,
37: AND var.var_rent_id = inv.var_rent_id --BUG#2452909
38: AND ppi.currency_code = var.currency_code --BUG#2452909
39: AND ppi.payment_schedule_id = pps.payment_schedule_id

Line 59: AND abt.include_term = pn_var_abatement_amount_pkg.G_INCLUDE_TERM_YES

55: AND inv1.invoice_date = inv2.invoice_date
56: AND inv1.var_rent_inv_id = p_var_rent_inv_id
57: AND inv2.true_up_amt IS NOT NULL
58: AND inv2.adjust_num =0)
59: AND abt.include_term = pn_var_abatement_amount_pkg.G_INCLUDE_TERM_YES
60: AND inv.var_rent_inv_id = p_var_rent_inv_id --BUG#2452909,
61: AND var.var_rent_id = inv.var_rent_id --BUG#2452909
62: AND ppi.currency_code = var.currency_code --BUG#2452909
63: AND ppi.payment_schedule_id = pps.payment_schedule_id

Line 79: pnp_debug_pkg.log('pn_var_abatement_amount_pkg.calc_abatement (+) :');

75: l_abt_amt NUMBER;
76: l_true_up_amt NUMBER;
77:
78: BEGIN
79: pnp_debug_pkg.log('pn_var_abatement_amount_pkg.calc_abatement (+) :');
80: --
81: FOR tu_rec IN is_inv_tu_c(p_var_rent_inv_id) LOOP
82: l_true_up_amt := tu_rec.true_up_amt;
83: pnp_debug_pkg.log('l_true_up_amt'||l_true_up_amt);

Line 100: pnp_debug_pkg.log('pn_var_abatement_amount_pkg.calc_abatement (-) :');

96: FETCH csr_get_tu_amt INTO l_abt_amt;
97: CLOSE csr_get_tu_amt;
98: END IF;
99: pnp_debug_pkg.log('Amount:'||l_abt_amt);
100: pnp_debug_pkg.log('pn_var_abatement_amount_pkg.calc_abatement (-) :');
101: RETURN l_abt_amt;
102: EXCEPTION
103: WHEN no_data_found THEN
104: return 0;

Line 106: pnp_debug_pkg.log('Error IN pn_var_abatement_amount_pkg.calc_abatement -'||TO_CHAR(sqlcode)||' - '||sqlerrm);

102: EXCEPTION
103: WHEN no_data_found THEN
104: return 0;
105: WHEN others THEN
106: pnp_debug_pkg.log('Error IN pn_var_abatement_amount_pkg.calc_abatement -'||TO_CHAR(sqlcode)||' - '||sqlerrm);
107: RAISE;
108:
109: END calc_abatement;
110:

Line 144: AND abt.include_term = pn_var_abatement_amount_pkg.G_INCLUDE_TERM_YES

140: AND inv1.invoice_date = inv2.invoice_date
141: AND inv1.var_rent_inv_id = ip_var_rent_inv_id
142: AND inv2.true_up_amt IS NULL
143: AND inv2.adjust_num =0)
144: AND abt.include_term = pn_var_abatement_amount_pkg.G_INCLUDE_TERM_YES
145: AND inv.var_rent_inv_id = ip_var_rent_inv_id --BUG#2452909,
146: AND var.var_rent_id = inv.var_rent_id --BUG#2452909
147: AND ppi.currency_code = var.currency_code --BUG#2452909
148: AND ppi.payment_schedule_id = pps.payment_schedule_id

Line 168: AND abt.include_term = pn_var_abatement_amount_pkg.G_INCLUDE_TERM_YES

164: AND inv1.invoice_date = inv2.invoice_date
165: AND inv1.var_rent_inv_id = p_var_rent_inv_id
166: AND inv2.true_up_amt IS NOT NULL
167: AND inv2.adjust_num =0)
168: AND abt.include_term = pn_var_abatement_amount_pkg.G_INCLUDE_TERM_YES
169: AND inv.var_rent_inv_id = p_var_rent_inv_id --BUG#2452909,
170: AND var.var_rent_id = inv.var_rent_id --BUG#2452909
171: AND ppi.currency_code = var.currency_code --BUG#2452909
172: AND ppi.payment_schedule_id = pps.payment_schedule_id

Line 230: pnp_debug_pkg.log('pn_var_abatement_amount_pkg.calc_abatement (+) :');

226: l_min_prd_id NUMBER;
227:
228: BEGIN
229: l_true_up_amt := 0;
230: pnp_debug_pkg.log('pn_var_abatement_amount_pkg.calc_abatement (+) :');
231: --
232: FOR rec IN proration_type_c(p_var_rent_id) LOOP
233: l_proration_type := rec.proration_rule;
234: END LOOP;

Line 290: pnp_debug_pkg.log('pn_var_abatement_amount_pkg.calc_abatement (-) :');

286: END LOOP;
287:
288: END IF;
289: pnp_debug_pkg.log('Amount:'||l_abt_amt);
290: pnp_debug_pkg.log('pn_var_abatement_amount_pkg.calc_abatement (-) :');
291: RETURN l_abt_amt;
292: EXCEPTION
293: WHEN no_data_found THEN
294: return 0;

Line 296: pnp_debug_pkg.log('Error IN pn_var_abatement_amount_pkg.calc_abatement -'||TO_CHAR(sqlcode)||' - '||sqlerrm);

292: EXCEPTION
293: WHEN no_data_found THEN
294: return 0;
295: WHEN others THEN
296: pnp_debug_pkg.log('Error IN pn_var_abatement_amount_pkg.calc_abatement -'||TO_CHAR(sqlcode)||' - '||sqlerrm);
297: RAISE;
298:
299: END calc_abatement;
300:

Line 323: pnp_debug_pkg.log('pn_var_abatement_amount_pkg.process_abatement (+) :');

319: IS
320: l_abt_amt NUMBER := 0;
321: l_exported NUMBER := null;
322: BEGIN
323: pnp_debug_pkg.log('pn_var_abatement_amount_pkg.process_abatement (+) :');
324:
325: /* Calculate the recurring abatement amount */
326:
327: --Fix for bug # 2722191

Line 364: pnp_debug_pkg.log('pn_var_abatement_amount_pkg.process_abatement (-) :');

360:
361: END IF;
362:
363:
364: pnp_debug_pkg.log('pn_var_abatement_amount_pkg.process_abatement (-) :');
365:
366: EXCEPTION
367: WHEN OTHERS THEN
368: pnp_debug_pkg.log('Error IN pn_var_abatement_amount_pkg.process_abatement -'||TO_CHAR(sqlcode)||' - '||sqlerrm);

Line 368: pnp_debug_pkg.log('Error IN pn_var_abatement_amount_pkg.process_abatement -'||TO_CHAR(sqlcode)||' - '||sqlerrm);

364: pnp_debug_pkg.log('pn_var_abatement_amount_pkg.process_abatement (-) :');
365:
366: EXCEPTION
367: WHEN OTHERS THEN
368: pnp_debug_pkg.log('Error IN pn_var_abatement_amount_pkg.process_abatement -'||TO_CHAR(sqlcode)||' - '||sqlerrm);
369: raise;
370:
371: END process_abatement;
372:

Line 402: pnp_debug_pkg.log('pn_var_abatement_amount_pkg.get_group_dt (-) :');

398: l_grp_date DATE;
399:
400: BEGIN
401:
402: pnp_debug_pkg.log('pn_var_abatement_amount_pkg.get_group_dt (-) :');
403:
404: IF p_date_type ='MIN' THEN
405: OPEN csr_min_gd;
406: FETCH csr_min_gd INTO l_grp_date;

Line 416: pnp_debug_pkg.log('pn_var_abatement_amount_pkg.get_group_dt (-) :');

412: END IF;
413:
414: RETURN l_grp_date;
415:
416: pnp_debug_pkg.log('pn_var_abatement_amount_pkg.get_group_dt (-) :');
417:
418: END get_group_dt;
419:
420: ---------------------------------------------------------------------------------------------------------------

Line 459: END pn_var_abatement_amount_pkg;

455:
456: END get_term_exists;
457:
458:
459: END pn_var_abatement_amount_pkg;
460:
461: