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_TRX_PKG dependencies on PN_VAR_TRX_PKG

Line 1: PACKAGE BODY pn_var_trx_pkg AS

1: PACKAGE BODY pn_var_trx_pkg AS
2: -- $Header: PNVRTRXB.pls 120.3 2011/04/09 16:40:32 asahoo ship $
3: /*
4: need to fix the following in PNVRFUNB - replace existing code with the
5: code below

Line 713: IF l_vr_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_LY

709: END IF;
710:
711: l_ly_start_date := ADD_MONTHS(l_vr_termination_date, -12) + 1;
712:
713: IF l_vr_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_LY
714: ,pn_var_trx_pkg.G_PRORUL_FLY) THEN
715:
716: /* -- POPULATE INVOICE FLAG - START -- */
717: FOR prd_rec IN last_period_c( p_vr_id => p_var_rent_id

Line 714: ,pn_var_trx_pkg.G_PRORUL_FLY) THEN

710:
711: l_ly_start_date := ADD_MONTHS(l_vr_termination_date, -12) + 1;
712:
713: IF l_vr_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_LY
714: ,pn_var_trx_pkg.G_PRORUL_FLY) THEN
715:
716: /* -- POPULATE INVOICE FLAG - START -- */
717: FOR prd_rec IN last_period_c( p_vr_id => p_var_rent_id
718: ,p_term_date => l_vr_termination_date)

Line 900: IF l_vr_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_FY

896: END IF;
897:
898: l_fy_end_date := ADD_MONTHS(l_vr_commencement_date, 12) - 1;
899:
900: IF l_vr_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_FY
901: ,pn_var_trx_pkg.G_PRORUL_FLY) THEN
902:
903: FOR prd_rec IN first_period_c( p_vr_id => p_var_rent_id
904: ,p_comm_date => l_vr_commencement_date)

Line 901: ,pn_var_trx_pkg.G_PRORUL_FLY) THEN

897:
898: l_fy_end_date := ADD_MONTHS(l_vr_commencement_date, 12) - 1;
899:
900: IF l_vr_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_FY
901: ,pn_var_trx_pkg.G_PRORUL_FLY) THEN
902:
903: FOR prd_rec IN first_period_c( p_vr_id => p_var_rent_id
904: ,p_comm_date => l_vr_commencement_date)
905: LOOP

Line 911: IF l_vr_proration_rule = pn_var_trx_pkg.G_PRORUL_FY THEN

907: l_partial_period := NVL(prd_rec.partial_period, 'N');
908: END LOOP;
909:
910: /* -- POPULATE INVOICE FLAG - START -- */
911: IF l_vr_proration_rule = pn_var_trx_pkg.G_PRORUL_FY THEN
912:
913: /* init invoice flag */
914: UPDATE
915: pn_var_trx_headers_all

Line 1162: pnp_debug_pkg.log('--- pn_var_trx_pkg.populate_blended_grp_vol START ---');

1158:
1159: BEGIN
1160:
1161: pnp_debug_pkg.log('');
1162: pnp_debug_pkg.log('--- pn_var_trx_pkg.populate_blended_grp_vol START ---');
1163: pnp_debug_pkg.log('');
1164:
1165: /* get proration RULE */
1166: IF p_proration_rule IS NULL THEN

Line 1225: IF l_vr_proration_rule = pn_var_trx_pkg.G_PRORUL_CYP THEN

1221: pnp_debug_pkg.log('Full period Start Date: '||l_full_prd_start_dt);
1222: pnp_debug_pkg.log('Full period Length: '||l_part_prd_start_dt);
1223: pnp_debug_pkg.log('');
1224:
1225: IF l_vr_proration_rule = pn_var_trx_pkg.G_PRORUL_CYP THEN
1226:
1227: l_context := 'CYP - update invoice_flag';
1228: /* reset the invoice flag */
1229: UPDATE

Line 1320: ELSIF l_vr_proration_rule = pn_var_trx_pkg.G_PRORUL_CYNP THEN

1316:
1317: pnp_debug_pkg.log(l_context||' COMPLETE');
1318: pnp_debug_pkg.log('');
1319:
1320: ELSIF l_vr_proration_rule = pn_var_trx_pkg.G_PRORUL_CYNP THEN
1321:
1322: l_context := 'CYNP - update invoice_flag';
1323:
1324: /* reset the invoice flag */

Line 1457: pnp_debug_pkg.log('--- pn_var_trx_pkg.populate_blended_grp_vol START ---');

1453:
1454: END IF;
1455:
1456: pnp_debug_pkg.log('');
1457: pnp_debug_pkg.log('--- pn_var_trx_pkg.populate_blended_grp_vol START ---');
1458: pnp_debug_pkg.log('');
1459:
1460: EXCEPTION
1461: WHEN OTHERS THEN

Line 1719: IF l_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_FY

1715: END IF;
1716:
1717: l_counter1 := 1;
1718:
1719: IF l_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_FY
1720: ,pn_var_trx_pkg.G_PRORUL_LY
1721: ,pn_var_trx_pkg.G_PRORUL_FLY
1722: ,pn_var_trx_pkg.G_PRORUL_NP
1723: ,pn_var_trx_pkg.G_PRORUL_STD) THEN

Line 1720: ,pn_var_trx_pkg.G_PRORUL_LY

1716:
1717: l_counter1 := 1;
1718:
1719: IF l_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_FY
1720: ,pn_var_trx_pkg.G_PRORUL_LY
1721: ,pn_var_trx_pkg.G_PRORUL_FLY
1722: ,pn_var_trx_pkg.G_PRORUL_NP
1723: ,pn_var_trx_pkg.G_PRORUL_STD) THEN
1724:

Line 1721: ,pn_var_trx_pkg.G_PRORUL_FLY

1717: l_counter1 := 1;
1718:
1719: IF l_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_FY
1720: ,pn_var_trx_pkg.G_PRORUL_LY
1721: ,pn_var_trx_pkg.G_PRORUL_FLY
1722: ,pn_var_trx_pkg.G_PRORUL_NP
1723: ,pn_var_trx_pkg.G_PRORUL_STD) THEN
1724:
1725: FOR line_rec IN lines_c(p_vr_id => p_var_rent_id) LOOP

Line 1722: ,pn_var_trx_pkg.G_PRORUL_NP

1718:
1719: IF l_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_FY
1720: ,pn_var_trx_pkg.G_PRORUL_LY
1721: ,pn_var_trx_pkg.G_PRORUL_FLY
1722: ,pn_var_trx_pkg.G_PRORUL_NP
1723: ,pn_var_trx_pkg.G_PRORUL_STD) THEN
1724:
1725: FOR line_rec IN lines_c(p_vr_id => p_var_rent_id) LOOP
1726:

Line 1723: ,pn_var_trx_pkg.G_PRORUL_STD) THEN

1719: IF l_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_FY
1720: ,pn_var_trx_pkg.G_PRORUL_LY
1721: ,pn_var_trx_pkg.G_PRORUL_FLY
1722: ,pn_var_trx_pkg.G_PRORUL_NP
1723: ,pn_var_trx_pkg.G_PRORUL_STD) THEN
1724:
1725: FOR line_rec IN lines_c(p_vr_id => p_var_rent_id) LOOP
1726:
1727: trx_detail_t.DELETE;

Line 1769: ELSIF l_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_CYP

1765: trx_detail_id = trx_detail_t(i);
1766:
1767: END LOOP;
1768:
1769: ELSIF l_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_CYP
1770: ,pn_var_trx_pkg.G_PRORUL_CYNP) THEN
1771:
1772: /* fetch partial and full period details */
1773: FOR prd_rec IN periods_c(p_vr_id => p_var_rent_id) LOOP

Line 1770: ,pn_var_trx_pkg.G_PRORUL_CYNP) THEN

1766:
1767: END LOOP;
1768:
1769: ELSIF l_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_CYP
1770: ,pn_var_trx_pkg.G_PRORUL_CYNP) THEN
1771:
1772: /* fetch partial and full period details */
1773: FOR prd_rec IN periods_c(p_vr_id => p_var_rent_id) LOOP
1774:

Line 1993: IF l_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_CYP

1989:
1990: BEGIN
1991:
1992: IF prd_rec = 1 THEN
1993: IF l_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_CYP
1994: ,pn_var_trx_pkg.G_PRORUL_CYNP)
1995: THEN
1996: RAISE DO_NOT_PROCESS;
1997:

Line 1994: ,pn_var_trx_pkg.G_PRORUL_CYNP)

1990: BEGIN
1991:
1992: IF prd_rec = 1 THEN
1993: IF l_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_CYP
1994: ,pn_var_trx_pkg.G_PRORUL_CYNP)
1995: THEN
1996: RAISE DO_NOT_PROCESS;
1997:
1998: END IF;

Line 2000: IF l_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_FY

1996: RAISE DO_NOT_PROCESS;
1997:
1998: END IF;
1999:
2000: IF l_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_FY
2001: ,pn_var_trx_pkg.G_PRORUL_FLY)
2002: THEN
2003: FOR fst_rec IN check_fst_partial_prd(l_period_t(prd_rec)) LOOP
2004: RAISE DO_NOT_PROCESS;

Line 2001: ,pn_var_trx_pkg.G_PRORUL_FLY)

1997:
1998: END IF;
1999:
2000: IF l_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_FY
2001: ,pn_var_trx_pkg.G_PRORUL_FLY)
2002: THEN
2003: FOR fst_rec IN check_fst_partial_prd(l_period_t(prd_rec)) LOOP
2004: RAISE DO_NOT_PROCESS;
2005: END LOOP;

Line 2010: IF l_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_CYP

2006: END IF;
2007:
2008: ELSIF prd_rec = 2 THEN
2009:
2010: IF l_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_CYP
2011: ,pn_var_trx_pkg.G_PRORUL_CYNP)
2012: THEN
2013: RAISE DO_NOT_PROCESS;
2014:

Line 2011: ,pn_var_trx_pkg.G_PRORUL_CYNP)

2007:
2008: ELSIF prd_rec = 2 THEN
2009:
2010: IF l_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_CYP
2011: ,pn_var_trx_pkg.G_PRORUL_CYNP)
2012: THEN
2013: RAISE DO_NOT_PROCESS;
2014:
2015: END IF;

Line 2019: IF l_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_LY

2015: END IF;
2016:
2017: ELSIF prd_rec = l_period_t.COUNT THEN
2018:
2019: IF l_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_LY
2020: ,pn_var_trx_pkg.G_PRORUL_FLY)
2021: THEN
2022: FOR fst_rec IN last_period_c(l_period_t(prd_rec)) LOOP
2023: RAISE DO_NOT_PROCESS;

Line 2020: ,pn_var_trx_pkg.G_PRORUL_FLY)

2016:
2017: ELSIF prd_rec = l_period_t.COUNT THEN
2018:
2019: IF l_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_LY
2020: ,pn_var_trx_pkg.G_PRORUL_FLY)
2021: THEN
2022: FOR fst_rec IN last_period_c(l_period_t(prd_rec)) LOOP
2023: RAISE DO_NOT_PROCESS;
2024: END LOOP;

Line 2427: ('+++++++++++++ pn_var_trx_pkg.populate_transactions START +++++++++++++');

2423:
2424: BEGIN
2425:
2426: pnp_debug_pkg.log
2427: ('+++++++++++++ pn_var_trx_pkg.populate_transactions START +++++++++++++');
2428:
2429: /* lock the line items */
2430: l_line_items_lock4bkpt_t.DELETE;
2431:

Line 2472: pn_var_trx_pkg.delete_transactions

2468: FOR del_rec IN chk_for_del_prd_c(p_vr_id => p_var_rent_id) LOOP
2469:
2470: l_trx_create_upd_flag := TRUE;
2471:
2472: pn_var_trx_pkg.delete_transactions
2473: ( p_var_rent_id => p_var_rent_id
2474: ,p_period_id => del_rec.period_id
2475: ,p_line_item_id => NULL);
2476: END LOOP;

Line 2507: pn_var_trx_pkg.delete_transactions

2503: ,p_prd_id => period_rec.period_id) LOOP
2504:
2505: l_trx_create_upd_flag := TRUE;
2506:
2507: pn_var_trx_pkg.delete_transactions
2508: ( p_var_rent_id => p_var_rent_id
2509: ,p_period_id => period_rec.period_id
2510: ,p_line_item_id => del_rec.line_item_id);
2511: END LOOP;

Line 2525: pn_var_trx_pkg.delete_transactions

2521: /* create trx for all line items that have bkpts updated */
2522: FOR line_item_rec IN line_items_c(p_prd_id => period_rec.period_id) LOOP
2523:
2524: l_trx_create_upd_flag := TRUE;
2525: pn_var_trx_pkg.delete_transactions
2526: ( p_var_rent_id => p_var_rent_id
2527: ,p_period_id => period_rec.period_id
2528: ,p_line_item_id => line_item_rec.line_item_id);
2529:

Line 2610: pn_var_trx_pkg.insert_trx_hdr

2606:
2607: /* need to create TRX headers and details */
2608:
2609: /* create header */
2610: pn_var_trx_pkg.insert_trx_hdr
2611: (p_trx_header_id => l_trx_hdr_id
2612: ,p_var_rent_id => period_rec.var_rent_id
2613: ,p_period_id => period_rec.period_id
2614: ,p_line_item_id => line_item_rec.line_item_id

Line 2643: IF l_proration_rule = pn_var_trx_pkg.G_PRORUL_NP THEN

2639: /* create details */
2640: FOR bkpt_dtl_rec IN 1..bkpts_tbl(bkpt_rec - 1).bkpt_dtls_tbl.COUNT
2641: LOOP
2642:
2643: IF l_proration_rule = pn_var_trx_pkg.G_PRORUL_NP THEN
2644: IF l_calculation_method = pn_var_trx_pkg.G_CALC_CUMULATIVE THEN
2645: l_prorated_grp_vol_start
2646: := bkpts_tbl(bkpt_rec - 1).bkpt_dtls_tbl(bkpt_dtl_rec).period_bkpt_vol_start;
2647:

Line 2644: IF l_calculation_method = pn_var_trx_pkg.G_CALC_CUMULATIVE THEN

2640: FOR bkpt_dtl_rec IN 1..bkpts_tbl(bkpt_rec - 1).bkpt_dtls_tbl.COUNT
2641: LOOP
2642:
2643: IF l_proration_rule = pn_var_trx_pkg.G_PRORUL_NP THEN
2644: IF l_calculation_method = pn_var_trx_pkg.G_CALC_CUMULATIVE THEN
2645: l_prorated_grp_vol_start
2646: := bkpts_tbl(bkpt_rec - 1).bkpt_dtls_tbl(bkpt_dtl_rec).period_bkpt_vol_start;
2647:
2648: l_prorated_grp_vol_end

Line 2674: pn_var_trx_pkg.insert_trx_dtl

2670: * l_proration_factor;
2671:
2672: END IF;
2673:
2674: pn_var_trx_pkg.insert_trx_dtl
2675: (p_trx_detail_id => l_trx_dtl_id
2676: ,p_trx_header_id => l_trx_hdr_id
2677: ,p_bkpt_detail_id => bkpts_tbl(bkpt_rec - 1).
2678: bkpt_dtls_tbl(bkpt_dtl_rec).

Line 2720: pn_var_trx_pkg.insert_trx_hdr

2716:
2717: /* need to create TRX headers and details */
2718:
2719: /* create header */
2720: pn_var_trx_pkg.insert_trx_hdr
2721: (p_trx_header_id => l_trx_hdr_id
2722: ,p_var_rent_id => period_rec.var_rent_id
2723: ,p_period_id => period_rec.period_id
2724: ,p_line_item_id => line_item_rec.line_item_id

Line 2752: IF l_proration_rule = pn_var_trx_pkg.G_PRORUL_NP THEN

2748:
2749: /* create details */
2750: FOR bkpt_dtl_rec IN 1..bkpts_tbl(l_curr_bkpt_ctr).bkpt_dtls_tbl.COUNT LOOP
2751:
2752: IF l_proration_rule = pn_var_trx_pkg.G_PRORUL_NP THEN
2753: IF l_calculation_method = pn_var_trx_pkg.G_CALC_CUMULATIVE THEN
2754: l_prorated_grp_vol_start
2755: := bkpts_tbl(l_curr_bkpt_ctr).bkpt_dtls_tbl(bkpt_dtl_rec).period_bkpt_vol_start;
2756: l_prorated_grp_vol_end

Line 2753: IF l_calculation_method = pn_var_trx_pkg.G_CALC_CUMULATIVE THEN

2749: /* create details */
2750: FOR bkpt_dtl_rec IN 1..bkpts_tbl(l_curr_bkpt_ctr).bkpt_dtls_tbl.COUNT LOOP
2751:
2752: IF l_proration_rule = pn_var_trx_pkg.G_PRORUL_NP THEN
2753: IF l_calculation_method = pn_var_trx_pkg.G_CALC_CUMULATIVE THEN
2754: l_prorated_grp_vol_start
2755: := bkpts_tbl(l_curr_bkpt_ctr).bkpt_dtls_tbl(bkpt_dtl_rec).period_bkpt_vol_start;
2756: l_prorated_grp_vol_end
2757: := NVL(bkpts_tbl(l_curr_bkpt_ctr).bkpt_dtls_tbl(bkpt_dtl_rec).period_bkpt_vol_end, 0);

Line 2781: pn_var_trx_pkg.insert_trx_dtl

2777: * l_proration_factor;
2778:
2779: END IF;
2780:
2781: pn_var_trx_pkg.insert_trx_dtl
2782: (p_trx_detail_id => l_trx_dtl_id
2783: ,p_trx_header_id => l_trx_hdr_id
2784: ,p_bkpt_detail_id => bkpts_tbl(l_curr_bkpt_ctr).
2785: bkpt_dtls_tbl(bkpt_dtl_rec).

Line 2828: pn_var_trx_pkg.populate_line_grp_id(p_var_rent_id => p_var_rent_id);

2824: /* get the grp IDs right if any trx was updated */
2825: IF l_trx_create_upd_flag THEN
2826: pnp_debug_pkg.log('Trx updated');
2827: /* groups the lines across the periods */
2828: pn_var_trx_pkg.populate_line_grp_id(p_var_rent_id => p_var_rent_id);
2829:
2830: /* populate the reset group IDs */
2831: pn_var_trx_pkg.populate_reset_grp_id(p_var_rent_id => p_var_rent_id);
2832: /* populate fy_pr_grp_vol_start - end,

Line 2831: pn_var_trx_pkg.populate_reset_grp_id(p_var_rent_id => p_var_rent_id);

2827: /* groups the lines across the periods */
2828: pn_var_trx_pkg.populate_line_grp_id(p_var_rent_id => p_var_rent_id);
2829:
2830: /* populate the reset group IDs */
2831: pn_var_trx_pkg.populate_reset_grp_id(p_var_rent_id => p_var_rent_id);
2832: /* populate fy_pr_grp_vol_start - end,
2833: ly_pr_grp_vol_start - end,
2834: invoice_flag
2835: for FY, LY, FLY */

Line 2859: IF l_proration_rule = pn_var_trx_pkg.G_PRORUL_LY THEN

2855: line_item_id = for_data_t(i).line_item_id AND
2856: reset_group_id = for_data_t(i).reset_group_id;
2857: END LOOP;
2858:
2859: IF l_proration_rule = pn_var_trx_pkg.G_PRORUL_LY THEN
2860:
2861: /* populate ly_pr_grp_vol_start - end, invoice_flag */
2862: pn_var_trx_pkg.populate_ly_pro_vol
2863: ( p_var_rent_id => p_var_rent_id

Line 2862: pn_var_trx_pkg.populate_ly_pro_vol

2858:
2859: IF l_proration_rule = pn_var_trx_pkg.G_PRORUL_LY THEN
2860:
2861: /* populate ly_pr_grp_vol_start - end, invoice_flag */
2862: pn_var_trx_pkg.populate_ly_pro_vol
2863: ( p_var_rent_id => p_var_rent_id
2864: ,p_proration_rule => l_proration_rule
2865: ,p_vr_commencement_dt => l_vr_commencement_date
2866: ,p_vr_termination_dt => l_vr_termination_date);

Line 2868: ELSIF l_proration_rule = pn_var_trx_pkg.G_PRORUL_FY THEN

2864: ,p_proration_rule => l_proration_rule
2865: ,p_vr_commencement_dt => l_vr_commencement_date
2866: ,p_vr_termination_dt => l_vr_termination_date);
2867:
2868: ELSIF l_proration_rule = pn_var_trx_pkg.G_PRORUL_FY THEN
2869:
2870: /* populate fy_pr_grp_vol_start - end, invoice_flag */
2871: pn_var_trx_pkg.populate_fy_pro_vol
2872: ( p_var_rent_id => p_var_rent_id

Line 2871: pn_var_trx_pkg.populate_fy_pro_vol

2867:
2868: ELSIF l_proration_rule = pn_var_trx_pkg.G_PRORUL_FY THEN
2869:
2870: /* populate fy_pr_grp_vol_start - end, invoice_flag */
2871: pn_var_trx_pkg.populate_fy_pro_vol
2872: ( p_var_rent_id => p_var_rent_id
2873: ,p_proration_rule => l_proration_rule
2874: ,p_vr_commencement_dt => l_vr_commencement_date
2875: ,p_vr_termination_dt => l_vr_termination_date);

Line 2877: ELSIF l_proration_rule = pn_var_trx_pkg.G_PRORUL_FLY THEN

2873: ,p_proration_rule => l_proration_rule
2874: ,p_vr_commencement_dt => l_vr_commencement_date
2875: ,p_vr_termination_dt => l_vr_termination_date);
2876:
2877: ELSIF l_proration_rule = pn_var_trx_pkg.G_PRORUL_FLY THEN
2878:
2879: /* populate ly_pr_grp_vol_start - end, invoice_flag */
2880: pn_var_trx_pkg.populate_ly_pro_vol
2881: ( p_var_rent_id => p_var_rent_id

Line 2880: pn_var_trx_pkg.populate_ly_pro_vol

2876:
2877: ELSIF l_proration_rule = pn_var_trx_pkg.G_PRORUL_FLY THEN
2878:
2879: /* populate ly_pr_grp_vol_start - end, invoice_flag */
2880: pn_var_trx_pkg.populate_ly_pro_vol
2881: ( p_var_rent_id => p_var_rent_id
2882: ,p_proration_rule => l_proration_rule
2883: ,p_vr_commencement_dt => l_vr_commencement_date
2884: ,p_vr_termination_dt => l_vr_termination_date);

Line 2887: pn_var_trx_pkg.populate_fy_pro_vol

2883: ,p_vr_commencement_dt => l_vr_commencement_date
2884: ,p_vr_termination_dt => l_vr_termination_date);
2885:
2886: /* populate fy_pr_grp_vol_start - end, invoice_flag */
2887: pn_var_trx_pkg.populate_fy_pro_vol
2888: ( p_var_rent_id => p_var_rent_id
2889: ,p_proration_rule => l_proration_rule
2890: ,p_vr_commencement_dt => l_vr_commencement_date
2891: ,p_vr_termination_dt => l_vr_termination_date);

Line 2893: ELSIF l_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_CYP

2889: ,p_proration_rule => l_proration_rule
2890: ,p_vr_commencement_dt => l_vr_commencement_date
2891: ,p_vr_termination_dt => l_vr_termination_date);
2892:
2893: ELSIF l_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_CYP
2894: ,pn_var_trx_pkg.G_PRORUL_CYNP) THEN
2895:
2896: /* populate blended_period/grp_vol_start - end */
2897: pn_var_trx_pkg.populate_blended_grp_vol

Line 2894: ,pn_var_trx_pkg.G_PRORUL_CYNP) THEN

2890: ,p_vr_commencement_dt => l_vr_commencement_date
2891: ,p_vr_termination_dt => l_vr_termination_date);
2892:
2893: ELSIF l_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_CYP
2894: ,pn_var_trx_pkg.G_PRORUL_CYNP) THEN
2895:
2896: /* populate blended_period/grp_vol_start - end */
2897: pn_var_trx_pkg.populate_blended_grp_vol
2898: ( p_var_rent_id => p_var_rent_id

Line 2897: pn_var_trx_pkg.populate_blended_grp_vol

2893: ELSIF l_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_CYP
2894: ,pn_var_trx_pkg.G_PRORUL_CYNP) THEN
2895:
2896: /* populate blended_period/grp_vol_start - end */
2897: pn_var_trx_pkg.populate_blended_grp_vol
2898: ( p_var_rent_id => p_var_rent_id
2899: ,p_proration_rule => l_proration_rule);
2900:
2901: END IF;

Line 2903: pnp_debug_pkg.log(' call pn_var_trx_pkg.populate_ytd_pro_vol'); /* 8616530 */

2899: ,p_proration_rule => l_proration_rule);
2900:
2901: END IF;
2902:
2903: pnp_debug_pkg.log(' call pn_var_trx_pkg.populate_ytd_pro_vol'); /* 8616530 */
2904: /* ALWAYS populate the ytd_group_vol_start - end - useful */
2905: pn_var_trx_pkg.populate_ytd_pro_vol
2906: ( p_var_rent_id => p_var_rent_id
2907: ,p_proration_rule => l_proration_rule);

Line 2905: pn_var_trx_pkg.populate_ytd_pro_vol

2901: END IF;
2902:
2903: pnp_debug_pkg.log(' call pn_var_trx_pkg.populate_ytd_pro_vol'); /* 8616530 */
2904: /* ALWAYS populate the ytd_group_vol_start - end - useful */
2905: pn_var_trx_pkg.populate_ytd_pro_vol
2906: ( p_var_rent_id => p_var_rent_id
2907: ,p_proration_rule => l_proration_rule);
2908:
2909: IF l_calculation_method = pn_var_trx_pkg.G_CALC_CUMULATIVE THEN

Line 2909: IF l_calculation_method = pn_var_trx_pkg.G_CALC_CUMULATIVE THEN

2905: pn_var_trx_pkg.populate_ytd_pro_vol
2906: ( p_var_rent_id => p_var_rent_id
2907: ,p_proration_rule => l_proration_rule);
2908:
2909: IF l_calculation_method = pn_var_trx_pkg.G_CALC_CUMULATIVE THEN
2910: /* populate the blended_period_vol_start - end */
2911: pn_var_trx_pkg.populate_blended_period_vol
2912: ( p_var_rent_id => p_var_rent_id
2913: ,p_proration_rule => l_proration_rule

Line 2911: pn_var_trx_pkg.populate_blended_period_vol

2907: ,p_proration_rule => l_proration_rule);
2908:
2909: IF l_calculation_method = pn_var_trx_pkg.G_CALC_CUMULATIVE THEN
2910: /* populate the blended_period_vol_start - end */
2911: pn_var_trx_pkg.populate_blended_period_vol
2912: ( p_var_rent_id => p_var_rent_id
2913: ,p_proration_rule => l_proration_rule
2914: ,p_calc_method => l_calculation_method);
2915:

Line 3004: vol_hist_status_code = pn_var_trx_pkg.G_SALESVOL_STATUS_APPROVED;

3000: WHERE
3001: sales.period_id = p_prd_id AND
3002: sales.line_item_id = p_line_id AND
3003: sales.grp_date_id = p_grp_id AND
3004: vol_hist_status_code = pn_var_trx_pkg.G_SALESVOL_STATUS_APPROVED;
3005:
3006: /* get volumes for a calculation sub-period */
3007: CURSOR vol_hist_c2 ( p_prd_id IN NUMBER
3008: ,p_line_id IN NUMBER

Line 3024: vol_hist_status_code = pn_var_trx_pkg.G_SALESVOL_STATUS_APPROVED;

3020: sales.line_item_id = p_line_id AND
3021: sales.grp_date_id = p_grp_id AND
3022: sales.start_date <= p_end_dt AND
3023: sales.end_date >= p_start_dt AND
3024: vol_hist_status_code = pn_var_trx_pkg.G_SALESVOL_STATUS_APPROVED;
3025:
3026: /* get grp dates */
3027: CURSOR grp_dates_c(p_grp_id IN NUMBER) IS
3028: SELECT

Line 3143: vol_hist_status_code = pn_var_trx_pkg.G_SALESVOL_STATUS_APPROVED;

3139: WHERE
3140: sales.period_id = p_prd_id AND
3141: sales.line_item_id = p_line_id AND
3142: sales.grp_date_id = p_grp_id AND
3143: vol_hist_status_code = pn_var_trx_pkg.G_SALESVOL_STATUS_APPROVED;
3144:
3145: /* get volumes for a calculation sub-period */
3146: CURSOR vol_hist_c2 ( p_prd_id IN NUMBER
3147: ,p_line_id IN NUMBER

Line 3163: vol_hist_status_code = pn_var_trx_pkg.G_SALESVOL_STATUS_APPROVED;

3159: sales.line_item_id = p_line_id AND
3160: sales.grp_date_id = p_grp_id AND
3161: sales.start_date <= p_end_dt AND
3162: sales.end_date >= p_start_dt AND
3163: vol_hist_status_code = pn_var_trx_pkg.G_SALESVOL_STATUS_APPROVED;
3164:
3165: /* get grp dates */
3166: CURSOR grp_dates_c(p_grp_id IN NUMBER) IS
3167: SELECT

Line 3315: IF l_vr_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_LY

3311: END IF;
3312:
3313: l_ly_start_date := ADD_MONTHS(l_vr_termination_date, -12) + 1;
3314:
3315: IF l_vr_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_LY
3316: ,pn_var_trx_pkg.G_PRORUL_FLY) THEN
3317:
3318: FOR prd_rec IN last_period_c( p_vr_id => p_var_rent_id
3319: ,p_term_date => l_vr_termination_date)

Line 3316: ,pn_var_trx_pkg.G_PRORUL_FLY) THEN

3312:
3313: l_ly_start_date := ADD_MONTHS(l_vr_termination_date, -12) + 1;
3314:
3315: IF l_vr_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_LY
3316: ,pn_var_trx_pkg.G_PRORUL_FLY) THEN
3317:
3318: FOR prd_rec IN last_period_c( p_vr_id => p_var_rent_id
3319: ,p_term_date => l_vr_termination_date)
3320: LOOP

Line 3350: = pn_var_trx_pkg.get_calc_prd_sales( var_rent_id

3346: UPDATE
3347: pn_var_trx_headers_all
3348: SET
3349: ly_proration_sales
3350: = pn_var_trx_pkg.get_calc_prd_sales( var_rent_id
3351: ,period_id
3352: ,line_item_id
3353: ,grp_date_id
3354: ,l_ly_start_date

Line 3438: IF l_vr_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_FY

3434: END IF;
3435:
3436: l_fy_end_date := ADD_MONTHS(l_vr_commencement_date, 12) - 1;
3437:
3438: IF l_vr_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_FY
3439: ,pn_var_trx_pkg.G_PRORUL_FLY) THEN
3440:
3441: FOR prd_rec IN first_period_c( p_vr_id => p_var_rent_id
3442: ,p_comm_date => l_vr_commencement_date)

Line 3439: ,pn_var_trx_pkg.G_PRORUL_FLY) THEN

3435:
3436: l_fy_end_date := ADD_MONTHS(l_vr_commencement_date, 12) - 1;
3437:
3438: IF l_vr_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_FY
3439: ,pn_var_trx_pkg.G_PRORUL_FLY) THEN
3440:
3441: FOR prd_rec IN first_period_c( p_vr_id => p_var_rent_id
3442: ,p_comm_date => l_vr_commencement_date)
3443: LOOP

Line 3472: = pn_var_trx_pkg.get_calc_prd_sales( var_rent_id

3468: UPDATE
3469: pn_var_trx_headers_all
3470: SET
3471: fy_proration_sales
3472: = pn_var_trx_pkg.get_calc_prd_sales( var_rent_id
3473: ,period_id
3474: ,line_item_id
3475: ,grp_date_id
3476: ,calc_prd_start_date

Line 3628: pnp_debug_pkg.log('++++ pn_var_trx_pkg.populate_ytd_sales START ++++');

3624: ytd_sales_t NUM_T;
3625:
3626: BEGIN
3627:
3628: pnp_debug_pkg.log('++++ pn_var_trx_pkg.populate_ytd_sales START ++++');
3629:
3630: /* get VR details */
3631: IF p_proration_rule IS NULL THEN
3632:

Line 3650: IF l_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_FY

3646: pnp_debug_pkg.log(' p_var_rent_id: '||p_var_rent_id);
3647: pnp_debug_pkg.log(' l_proration_rule: '||l_proration_rule);
3648:
3649: /* l_proration_rule based decisions */
3650: IF l_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_FY
3651: ,pn_var_trx_pkg.G_PRORUL_LY
3652: ,pn_var_trx_pkg.G_PRORUL_FLY
3653: ,pn_var_trx_pkg.G_PRORUL_NP
3654: ,pn_var_trx_pkg.G_PRORUL_STD) THEN

Line 3651: ,pn_var_trx_pkg.G_PRORUL_LY

3647: pnp_debug_pkg.log(' l_proration_rule: '||l_proration_rule);
3648:
3649: /* l_proration_rule based decisions */
3650: IF l_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_FY
3651: ,pn_var_trx_pkg.G_PRORUL_LY
3652: ,pn_var_trx_pkg.G_PRORUL_FLY
3653: ,pn_var_trx_pkg.G_PRORUL_NP
3654: ,pn_var_trx_pkg.G_PRORUL_STD) THEN
3655:

Line 3652: ,pn_var_trx_pkg.G_PRORUL_FLY

3648:
3649: /* l_proration_rule based decisions */
3650: IF l_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_FY
3651: ,pn_var_trx_pkg.G_PRORUL_LY
3652: ,pn_var_trx_pkg.G_PRORUL_FLY
3653: ,pn_var_trx_pkg.G_PRORUL_NP
3654: ,pn_var_trx_pkg.G_PRORUL_STD) THEN
3655:
3656: FOR line_rec IN lines_c(p_vr_id => p_var_rent_id) LOOP

Line 3653: ,pn_var_trx_pkg.G_PRORUL_NP

3649: /* l_proration_rule based decisions */
3650: IF l_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_FY
3651: ,pn_var_trx_pkg.G_PRORUL_LY
3652: ,pn_var_trx_pkg.G_PRORUL_FLY
3653: ,pn_var_trx_pkg.G_PRORUL_NP
3654: ,pn_var_trx_pkg.G_PRORUL_STD) THEN
3655:
3656: FOR line_rec IN lines_c(p_vr_id => p_var_rent_id) LOOP
3657:

Line 3654: ,pn_var_trx_pkg.G_PRORUL_STD) THEN

3650: IF l_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_FY
3651: ,pn_var_trx_pkg.G_PRORUL_LY
3652: ,pn_var_trx_pkg.G_PRORUL_FLY
3653: ,pn_var_trx_pkg.G_PRORUL_NP
3654: ,pn_var_trx_pkg.G_PRORUL_STD) THEN
3655:
3656: FOR line_rec IN lines_c(p_vr_id => p_var_rent_id) LOOP
3657:
3658: trx_hdr_t.DELETE;

Line 3681: ELSIF l_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_CYP

3677: trx_header_id = trx_hdr_t(i);
3678:
3679: END LOOP;
3680:
3681: ELSIF l_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_CYP
3682: ,pn_var_trx_pkg.G_PRORUL_CYNP) THEN
3683:
3684: /* fetch partial and full period details */
3685: l_counter1 := 0;

Line 3682: ,pn_var_trx_pkg.G_PRORUL_CYNP) THEN

3678:
3679: END LOOP;
3680:
3681: ELSIF l_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_CYP
3682: ,pn_var_trx_pkg.G_PRORUL_CYNP) THEN
3683:
3684: /* fetch partial and full period details */
3685: l_counter1 := 0;
3686: FOR prd_rec IN periods_c(p_vr_id => p_var_rent_id) LOOP

Line 3893: pn_var_trx_pkg.get_calc_prd_sales

3889: l_counter := l_counter + 1;
3890:
3891: trx_hdr_t(l_counter) := trx_rec.trx_header_id;
3892:
3893: pn_var_trx_pkg.get_calc_prd_sales
3894: ( p_var_rent_id => trx_rec.var_rent_id
3895: ,p_period_id => trx_rec.period_id
3896: ,p_line_item_id => trx_rec.line_item_id
3897: ,p_grp_date_id => trx_rec.grp_date_id

Line 3924: IF l_proration_rule = pn_var_trx_pkg.G_PRORUL_LY THEN

3920: END LOOP;
3921:
3922: IF l_sales_create_upd_flag THEN
3923:
3924: IF l_proration_rule = pn_var_trx_pkg.G_PRORUL_LY THEN
3925:
3926: pn_var_trx_pkg.populate_ly_pro_sales
3927: ( p_var_rent_id => p_var_rent_id
3928: ,p_proration_rule => l_proration_rule

Line 3926: pn_var_trx_pkg.populate_ly_pro_sales

3922: IF l_sales_create_upd_flag THEN
3923:
3924: IF l_proration_rule = pn_var_trx_pkg.G_PRORUL_LY THEN
3925:
3926: pn_var_trx_pkg.populate_ly_pro_sales
3927: ( p_var_rent_id => p_var_rent_id
3928: ,p_proration_rule => l_proration_rule
3929: ,p_vr_commencement_dt => l_vr_commencement_date
3930: ,p_vr_termination_dt => l_vr_termination_date);

Line 3932: ELSIF l_proration_rule = pn_var_trx_pkg.G_PRORUL_FY THEN

3928: ,p_proration_rule => l_proration_rule
3929: ,p_vr_commencement_dt => l_vr_commencement_date
3930: ,p_vr_termination_dt => l_vr_termination_date);
3931:
3932: ELSIF l_proration_rule = pn_var_trx_pkg.G_PRORUL_FY THEN
3933:
3934: pn_var_trx_pkg.populate_fy_pro_sales
3935: ( p_var_rent_id => p_var_rent_id
3936: ,p_proration_rule => l_proration_rule

Line 3934: pn_var_trx_pkg.populate_fy_pro_sales

3930: ,p_vr_termination_dt => l_vr_termination_date);
3931:
3932: ELSIF l_proration_rule = pn_var_trx_pkg.G_PRORUL_FY THEN
3933:
3934: pn_var_trx_pkg.populate_fy_pro_sales
3935: ( p_var_rent_id => p_var_rent_id
3936: ,p_proration_rule => l_proration_rule
3937: ,p_vr_commencement_dt => l_vr_commencement_date
3938: ,p_vr_termination_dt => l_vr_termination_date);

Line 3940: ELSIF l_proration_rule = pn_var_trx_pkg.G_PRORUL_FLY THEN

3936: ,p_proration_rule => l_proration_rule
3937: ,p_vr_commencement_dt => l_vr_commencement_date
3938: ,p_vr_termination_dt => l_vr_termination_date);
3939:
3940: ELSIF l_proration_rule = pn_var_trx_pkg.G_PRORUL_FLY THEN
3941:
3942: pn_var_trx_pkg.populate_ly_pro_sales
3943: ( p_var_rent_id => p_var_rent_id
3944: ,p_proration_rule => l_proration_rule

Line 3942: pn_var_trx_pkg.populate_ly_pro_sales

3938: ,p_vr_termination_dt => l_vr_termination_date);
3939:
3940: ELSIF l_proration_rule = pn_var_trx_pkg.G_PRORUL_FLY THEN
3941:
3942: pn_var_trx_pkg.populate_ly_pro_sales
3943: ( p_var_rent_id => p_var_rent_id
3944: ,p_proration_rule => l_proration_rule
3945: ,p_vr_commencement_dt => l_vr_commencement_date
3946: ,p_vr_termination_dt => l_vr_termination_date);

Line 3948: pn_var_trx_pkg.populate_fy_pro_sales

3944: ,p_proration_rule => l_proration_rule
3945: ,p_vr_commencement_dt => l_vr_commencement_date
3946: ,p_vr_termination_dt => l_vr_termination_date);
3947:
3948: pn_var_trx_pkg.populate_fy_pro_sales
3949: ( p_var_rent_id => p_var_rent_id
3950: ,p_proration_rule => l_proration_rule
3951: ,p_vr_commencement_dt => l_vr_commencement_date
3952: ,p_vr_termination_dt => l_vr_termination_date);

Line 3957: pn_var_trx_pkg.populate_ytd_sales

3953:
3954: END IF;
3955:
3956: /* always populate YTD sales - very useful */
3957: pn_var_trx_pkg.populate_ytd_sales
3958: ( p_var_rent_id => p_var_rent_id
3959: ,p_proration_rule => l_proration_rule);
3960:
3961: END IF;

Line 4341: IF l_calculation_method IN ( pn_var_trx_pkg.G_CALC_YTD

4337: ELSE
4338: l_calculation_method := p_calc_method;
4339: END IF;
4340:
4341: IF l_calculation_method IN ( pn_var_trx_pkg.G_CALC_YTD
4342: ,pn_var_trx_pkg.G_CALC_CUMULATIVE) THEN
4343:
4344: FOR line_rec IN lines_c(p_vr_id => p_var_rent_id) LOOP
4345:

Line 4342: ,pn_var_trx_pkg.G_CALC_CUMULATIVE) THEN

4338: l_calculation_method := p_calc_method;
4339: END IF;
4340:
4341: IF l_calculation_method IN ( pn_var_trx_pkg.G_CALC_YTD
4342: ,pn_var_trx_pkg.G_CALC_CUMULATIVE) THEN
4343:
4344: FOR line_rec IN lines_c(p_vr_id => p_var_rent_id) LOOP
4345:
4346: trx_hdr_t.DELETE;

Line 4504: pn_var_trx_pkg.get_calc_prd_sales_for

4500: l_counter := l_counter + 1;
4501:
4502: trx_hdr_t(l_counter) := trx_rec.trx_header_id;
4503:
4504: pn_var_trx_pkg.get_calc_prd_sales_for
4505: ( p_var_rent_id => trx_rec.var_rent_id
4506: ,p_period_id => trx_rec.period_id
4507: ,p_line_item_id => trx_rec.line_item_id
4508: ,p_grp_date_id => trx_rec.grp_date_id

Line 4534: pn_var_trx_pkg.populate_ytd_sales_for

4530: END LOOP;
4531:
4532: /*Similar to actuals - We always populate YTD sales*/
4533:
4534: pn_var_trx_pkg.populate_ytd_sales_for
4535: ( p_var_rent_id => p_var_rent_id
4536: ,p_calc_method => l_calculation_method);
4537:
4538: /*This would be needed in actual sales, but not for forecasted.

Line 4882: IF l_vr_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_LY

4878: END IF;
4879:
4880: l_ly_start_date := ADD_MONTHS(l_vr_termination_date, -12) + 1;
4881:
4882: IF l_vr_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_LY
4883: ,pn_var_trx_pkg.G_PRORUL_FLY) THEN
4884:
4885: /* init ly_proration_sales */
4886: UPDATE

Line 4883: ,pn_var_trx_pkg.G_PRORUL_FLY) THEN

4879:
4880: l_ly_start_date := ADD_MONTHS(l_vr_termination_date, -12) + 1;
4881:
4882: IF l_vr_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_LY
4883: ,pn_var_trx_pkg.G_PRORUL_FLY) THEN
4884:
4885: /* init ly_proration_sales */
4886: UPDATE
4887: pn_var_trx_headers_all

Line 4908: = pn_var_trx_pkg.get_calc_prd_dedc( var_rent_id

4904: UPDATE
4905: pn_var_trx_headers_all
4906: SET
4907: ly_proration_deductions
4908: = pn_var_trx_pkg.get_calc_prd_dedc( var_rent_id
4909: ,period_id
4910: ,line_item_id
4911: ,grp_date_id
4912: ,l_ly_start_date

Line 4980: IF l_vr_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_FY

4976: END IF;
4977:
4978: l_fy_end_date := ADD_MONTHS(l_vr_commencement_date, 12) - 1;
4979:
4980: IF l_vr_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_FY
4981: ,pn_var_trx_pkg.G_PRORUL_FLY) THEN
4982:
4983: /* init ly_proration_deductions */
4984: UPDATE

Line 4981: ,pn_var_trx_pkg.G_PRORUL_FLY) THEN

4977:
4978: l_fy_end_date := ADD_MONTHS(l_vr_commencement_date, 12) - 1;
4979:
4980: IF l_vr_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_FY
4981: ,pn_var_trx_pkg.G_PRORUL_FLY) THEN
4982:
4983: /* init ly_proration_deductions */
4984: UPDATE
4985: pn_var_trx_headers_all

Line 5006: = pn_var_trx_pkg.get_calc_prd_dedc( var_rent_id

5002: UPDATE
5003: pn_var_trx_headers_all
5004: SET
5005: fy_proration_deductions
5006: = pn_var_trx_pkg.get_calc_prd_dedc( var_rent_id
5007: ,period_id
5008: ,line_item_id
5009: ,grp_date_id
5010: ,calc_prd_start_date

Line 5159: pnp_debug_pkg.log('++++ pn_var_trx_pkg.populate_ytd_deductions START ++++');

5155: ytd_deductions_t NUM_T;
5156:
5157: BEGIN
5158:
5159: pnp_debug_pkg.log('++++ pn_var_trx_pkg.populate_ytd_deductions START ++++');
5160:
5161: /* get VR details */
5162: IF p_proration_rule IS NULL THEN
5163:

Line 5181: IF l_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_FY

5177: pnp_debug_pkg.log(' p_var_rent_id: '||p_var_rent_id);
5178: pnp_debug_pkg.log(' l_proration_rule: '||l_proration_rule);
5179:
5180: /* l_proration_rule based decisions */
5181: IF l_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_FY
5182: ,pn_var_trx_pkg.G_PRORUL_LY
5183: ,pn_var_trx_pkg.G_PRORUL_FLY
5184: ,pn_var_trx_pkg.G_PRORUL_NP
5185: ,pn_var_trx_pkg.G_PRORUL_STD) THEN

Line 5182: ,pn_var_trx_pkg.G_PRORUL_LY

5178: pnp_debug_pkg.log(' l_proration_rule: '||l_proration_rule);
5179:
5180: /* l_proration_rule based decisions */
5181: IF l_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_FY
5182: ,pn_var_trx_pkg.G_PRORUL_LY
5183: ,pn_var_trx_pkg.G_PRORUL_FLY
5184: ,pn_var_trx_pkg.G_PRORUL_NP
5185: ,pn_var_trx_pkg.G_PRORUL_STD) THEN
5186:

Line 5183: ,pn_var_trx_pkg.G_PRORUL_FLY

5179:
5180: /* l_proration_rule based decisions */
5181: IF l_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_FY
5182: ,pn_var_trx_pkg.G_PRORUL_LY
5183: ,pn_var_trx_pkg.G_PRORUL_FLY
5184: ,pn_var_trx_pkg.G_PRORUL_NP
5185: ,pn_var_trx_pkg.G_PRORUL_STD) THEN
5186:
5187: FOR line_rec IN lines_c(p_vr_id => p_var_rent_id) LOOP

Line 5184: ,pn_var_trx_pkg.G_PRORUL_NP

5180: /* l_proration_rule based decisions */
5181: IF l_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_FY
5182: ,pn_var_trx_pkg.G_PRORUL_LY
5183: ,pn_var_trx_pkg.G_PRORUL_FLY
5184: ,pn_var_trx_pkg.G_PRORUL_NP
5185: ,pn_var_trx_pkg.G_PRORUL_STD) THEN
5186:
5187: FOR line_rec IN lines_c(p_vr_id => p_var_rent_id) LOOP
5188:

Line 5185: ,pn_var_trx_pkg.G_PRORUL_STD) THEN

5181: IF l_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_FY
5182: ,pn_var_trx_pkg.G_PRORUL_LY
5183: ,pn_var_trx_pkg.G_PRORUL_FLY
5184: ,pn_var_trx_pkg.G_PRORUL_NP
5185: ,pn_var_trx_pkg.G_PRORUL_STD) THEN
5186:
5187: FOR line_rec IN lines_c(p_vr_id => p_var_rent_id) LOOP
5188:
5189: trx_hdr_t.DELETE;

Line 5212: ELSIF l_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_CYP

5208: trx_header_id = trx_hdr_t(i);
5209:
5210: END LOOP;
5211:
5212: ELSIF l_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_CYP
5213: ,pn_var_trx_pkg.G_PRORUL_CYNP) THEN
5214:
5215: /* fetch partial and full period details */
5216: l_counter1 := 0;

Line 5213: ,pn_var_trx_pkg.G_PRORUL_CYNP) THEN

5209:
5210: END LOOP;
5211:
5212: ELSIF l_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_CYP
5213: ,pn_var_trx_pkg.G_PRORUL_CYNP) THEN
5214:
5215: /* fetch partial and full period details */
5216: l_counter1 := 0;
5217: FOR prd_rec IN periods_c(p_vr_id => p_var_rent_id) LOOP

Line 5414: pn_var_trx_pkg.get_calc_prd_dedc

5410: l_counter := l_counter + 1;
5411:
5412: trx_hdr_t(l_counter) := trx_rec.trx_header_id;
5413:
5414: pn_var_trx_pkg.get_calc_prd_dedc
5415: ( p_var_rent_id => trx_rec.var_rent_id
5416: ,p_period_id => trx_rec.period_id
5417: ,p_line_item_id => trx_rec.line_item_id
5418: ,p_grp_date_id => trx_rec.grp_date_id

Line 5444: IF l_proration_rule = pn_var_trx_pkg.G_PRORUL_LY THEN

5440:
5441: END LOOP;
5442:
5443:
5444: IF l_proration_rule = pn_var_trx_pkg.G_PRORUL_LY THEN
5445:
5446: pn_var_trx_pkg.populate_ly_pro_dedc
5447: ( p_var_rent_id => p_var_rent_id
5448: ,p_proration_rule => l_proration_rule

Line 5446: pn_var_trx_pkg.populate_ly_pro_dedc

5442:
5443:
5444: IF l_proration_rule = pn_var_trx_pkg.G_PRORUL_LY THEN
5445:
5446: pn_var_trx_pkg.populate_ly_pro_dedc
5447: ( p_var_rent_id => p_var_rent_id
5448: ,p_proration_rule => l_proration_rule
5449: ,p_vr_commencement_dt => l_vr_commencement_date
5450: ,p_vr_termination_dt => l_vr_termination_date);

Line 5452: ELSIF l_proration_rule = pn_var_trx_pkg.G_PRORUL_FY THEN

5448: ,p_proration_rule => l_proration_rule
5449: ,p_vr_commencement_dt => l_vr_commencement_date
5450: ,p_vr_termination_dt => l_vr_termination_date);
5451:
5452: ELSIF l_proration_rule = pn_var_trx_pkg.G_PRORUL_FY THEN
5453:
5454: pn_var_trx_pkg.populate_fy_pro_dedc
5455: ( p_var_rent_id => p_var_rent_id
5456: ,p_proration_rule => l_proration_rule

Line 5454: pn_var_trx_pkg.populate_fy_pro_dedc

5450: ,p_vr_termination_dt => l_vr_termination_date);
5451:
5452: ELSIF l_proration_rule = pn_var_trx_pkg.G_PRORUL_FY THEN
5453:
5454: pn_var_trx_pkg.populate_fy_pro_dedc
5455: ( p_var_rent_id => p_var_rent_id
5456: ,p_proration_rule => l_proration_rule
5457: ,p_vr_commencement_dt => l_vr_commencement_date
5458: ,p_vr_termination_dt => l_vr_termination_date);

Line 5460: ELSIF l_proration_rule = pn_var_trx_pkg.G_PRORUL_FLY THEN

5456: ,p_proration_rule => l_proration_rule
5457: ,p_vr_commencement_dt => l_vr_commencement_date
5458: ,p_vr_termination_dt => l_vr_termination_date);
5459:
5460: ELSIF l_proration_rule = pn_var_trx_pkg.G_PRORUL_FLY THEN
5461:
5462: pn_var_trx_pkg.populate_ly_pro_dedc
5463: ( p_var_rent_id => p_var_rent_id
5464: ,p_proration_rule => l_proration_rule

Line 5462: pn_var_trx_pkg.populate_ly_pro_dedc

5458: ,p_vr_termination_dt => l_vr_termination_date);
5459:
5460: ELSIF l_proration_rule = pn_var_trx_pkg.G_PRORUL_FLY THEN
5461:
5462: pn_var_trx_pkg.populate_ly_pro_dedc
5463: ( p_var_rent_id => p_var_rent_id
5464: ,p_proration_rule => l_proration_rule
5465: ,p_vr_commencement_dt => l_vr_commencement_date
5466: ,p_vr_termination_dt => l_vr_termination_date);

Line 5468: pn_var_trx_pkg.populate_fy_pro_dedc

5464: ,p_proration_rule => l_proration_rule
5465: ,p_vr_commencement_dt => l_vr_commencement_date
5466: ,p_vr_termination_dt => l_vr_termination_date);
5467:
5468: pn_var_trx_pkg.populate_fy_pro_dedc
5469: ( p_var_rent_id => p_var_rent_id
5470: ,p_proration_rule => l_proration_rule
5471: ,p_vr_commencement_dt => l_vr_commencement_date
5472: ,p_vr_termination_dt => l_vr_termination_date);

Line 5477: pn_var_trx_pkg.populate_ytd_deductions

5473:
5474: END IF;
5475:
5476: /* always populate YTD deductions - Because we always populate YTD sales */
5477: pn_var_trx_pkg.populate_ytd_deductions
5478: ( p_var_rent_id => p_var_rent_id
5479: ,p_proration_rule => l_proration_rule);
5480:
5481: EXCEPTION

Line 5489: END pn_var_trx_pkg;

5485:
5486:
5487:
5488:
5489: END pn_var_trx_pkg;