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.0 2007/10/03 14:30:10 rthumma noship $
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 1649: IF l_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_FY

1645: END IF;
1646:
1647: l_counter1 := 1;
1648:
1649: IF l_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_FY
1650: ,pn_var_trx_pkg.G_PRORUL_LY
1651: ,pn_var_trx_pkg.G_PRORUL_FLY
1652: ,pn_var_trx_pkg.G_PRORUL_NP
1653: ,pn_var_trx_pkg.G_PRORUL_STD) THEN

Line 1650: ,pn_var_trx_pkg.G_PRORUL_LY

1646:
1647: l_counter1 := 1;
1648:
1649: IF l_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_FY
1650: ,pn_var_trx_pkg.G_PRORUL_LY
1651: ,pn_var_trx_pkg.G_PRORUL_FLY
1652: ,pn_var_trx_pkg.G_PRORUL_NP
1653: ,pn_var_trx_pkg.G_PRORUL_STD) THEN
1654:

Line 1651: ,pn_var_trx_pkg.G_PRORUL_FLY

1647: l_counter1 := 1;
1648:
1649: IF l_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_FY
1650: ,pn_var_trx_pkg.G_PRORUL_LY
1651: ,pn_var_trx_pkg.G_PRORUL_FLY
1652: ,pn_var_trx_pkg.G_PRORUL_NP
1653: ,pn_var_trx_pkg.G_PRORUL_STD) THEN
1654:
1655: FOR line_rec IN lines_c(p_vr_id => p_var_rent_id) LOOP

Line 1652: ,pn_var_trx_pkg.G_PRORUL_NP

1648:
1649: IF l_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_FY
1650: ,pn_var_trx_pkg.G_PRORUL_LY
1651: ,pn_var_trx_pkg.G_PRORUL_FLY
1652: ,pn_var_trx_pkg.G_PRORUL_NP
1653: ,pn_var_trx_pkg.G_PRORUL_STD) THEN
1654:
1655: FOR line_rec IN lines_c(p_vr_id => p_var_rent_id) LOOP
1656:

Line 1653: ,pn_var_trx_pkg.G_PRORUL_STD) THEN

1649: IF l_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_FY
1650: ,pn_var_trx_pkg.G_PRORUL_LY
1651: ,pn_var_trx_pkg.G_PRORUL_FLY
1652: ,pn_var_trx_pkg.G_PRORUL_NP
1653: ,pn_var_trx_pkg.G_PRORUL_STD) THEN
1654:
1655: FOR line_rec IN lines_c(p_vr_id => p_var_rent_id) LOOP
1656:
1657: trx_detail_t.DELETE;

Line 1683: ELSIF l_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_CYP

1679: trx_detail_id = trx_detail_t(i);
1680:
1681: END LOOP;
1682:
1683: ELSIF l_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_CYP
1684: ,pn_var_trx_pkg.G_PRORUL_CYNP) THEN
1685:
1686: /* fetch partial and full period details */
1687: FOR prd_rec IN periods_c(p_vr_id => p_var_rent_id) LOOP

Line 1684: ,pn_var_trx_pkg.G_PRORUL_CYNP) THEN

1680:
1681: END LOOP;
1682:
1683: ELSIF l_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_CYP
1684: ,pn_var_trx_pkg.G_PRORUL_CYNP) THEN
1685:
1686: /* fetch partial and full period details */
1687: FOR prd_rec IN periods_c(p_vr_id => p_var_rent_id) LOOP
1688:

Line 1905: IF l_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_CYP

1901:
1902: BEGIN
1903:
1904: IF prd_rec = 1 THEN
1905: IF l_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_CYP
1906: ,pn_var_trx_pkg.G_PRORUL_CYNP)
1907: THEN
1908: RAISE DO_NOT_PROCESS;
1909:

Line 1906: ,pn_var_trx_pkg.G_PRORUL_CYNP)

1902: BEGIN
1903:
1904: IF prd_rec = 1 THEN
1905: IF l_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_CYP
1906: ,pn_var_trx_pkg.G_PRORUL_CYNP)
1907: THEN
1908: RAISE DO_NOT_PROCESS;
1909:
1910: END IF;

Line 1912: IF l_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_FY

1908: RAISE DO_NOT_PROCESS;
1909:
1910: END IF;
1911:
1912: IF l_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_FY
1913: ,pn_var_trx_pkg.G_PRORUL_FLY)
1914: THEN
1915: FOR fst_rec IN check_fst_partial_prd(l_period_t(prd_rec)) LOOP
1916: RAISE DO_NOT_PROCESS;

Line 1913: ,pn_var_trx_pkg.G_PRORUL_FLY)

1909:
1910: END IF;
1911:
1912: IF l_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_FY
1913: ,pn_var_trx_pkg.G_PRORUL_FLY)
1914: THEN
1915: FOR fst_rec IN check_fst_partial_prd(l_period_t(prd_rec)) LOOP
1916: RAISE DO_NOT_PROCESS;
1917: END LOOP;

Line 1922: IF l_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_CYP

1918: END IF;
1919:
1920: ELSIF prd_rec = 2 THEN
1921:
1922: IF l_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_CYP
1923: ,pn_var_trx_pkg.G_PRORUL_CYNP)
1924: THEN
1925: RAISE DO_NOT_PROCESS;
1926:

Line 1923: ,pn_var_trx_pkg.G_PRORUL_CYNP)

1919:
1920: ELSIF prd_rec = 2 THEN
1921:
1922: IF l_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_CYP
1923: ,pn_var_trx_pkg.G_PRORUL_CYNP)
1924: THEN
1925: RAISE DO_NOT_PROCESS;
1926:
1927: END IF;

Line 1931: IF l_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_LY

1927: END IF;
1928:
1929: ELSIF prd_rec = l_period_t.COUNT THEN
1930:
1931: IF l_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_LY
1932: ,pn_var_trx_pkg.G_PRORUL_FLY)
1933: THEN
1934: FOR fst_rec IN last_period_c(l_period_t(prd_rec)) LOOP
1935: RAISE DO_NOT_PROCESS;

Line 1932: ,pn_var_trx_pkg.G_PRORUL_FLY)

1928:
1929: ELSIF prd_rec = l_period_t.COUNT THEN
1930:
1931: IF l_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_LY
1932: ,pn_var_trx_pkg.G_PRORUL_FLY)
1933: THEN
1934: FOR fst_rec IN last_period_c(l_period_t(prd_rec)) LOOP
1935: RAISE DO_NOT_PROCESS;
1936: END LOOP;

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

2334:
2335: BEGIN
2336:
2337: pnp_debug_pkg.log
2338: ('+++++++++++++ pn_var_trx_pkg.populate_transactions START +++++++++++++');
2339:
2340: /* lock the line items */
2341: l_line_items_lock4bkpt_t.DELETE;
2342:

Line 2383: pn_var_trx_pkg.delete_transactions

2379: FOR del_rec IN chk_for_del_prd_c(p_vr_id => p_var_rent_id) LOOP
2380:
2381: l_trx_create_upd_flag := TRUE;
2382:
2383: pn_var_trx_pkg.delete_transactions
2384: ( p_var_rent_id => p_var_rent_id
2385: ,p_period_id => del_rec.period_id
2386: ,p_line_item_id => NULL);
2387: END LOOP;

Line 2418: pn_var_trx_pkg.delete_transactions

2414: ,p_prd_id => period_rec.period_id) LOOP
2415:
2416: l_trx_create_upd_flag := TRUE;
2417:
2418: pn_var_trx_pkg.delete_transactions
2419: ( p_var_rent_id => p_var_rent_id
2420: ,p_period_id => period_rec.period_id
2421: ,p_line_item_id => del_rec.line_item_id);
2422: END LOOP;

Line 2436: pn_var_trx_pkg.delete_transactions

2432: /* create trx for all line items that have bkpts updated */
2433: FOR line_item_rec IN line_items_c(p_prd_id => period_rec.period_id) LOOP
2434:
2435: l_trx_create_upd_flag := TRUE;
2436: pn_var_trx_pkg.delete_transactions
2437: ( p_var_rent_id => p_var_rent_id
2438: ,p_period_id => period_rec.period_id
2439: ,p_line_item_id => line_item_rec.line_item_id);
2440:

Line 2521: pn_var_trx_pkg.insert_trx_hdr

2517:
2518: /* need to create TRX headers and details */
2519:
2520: /* create header */
2521: pn_var_trx_pkg.insert_trx_hdr
2522: (p_trx_header_id => l_trx_hdr_id
2523: ,p_var_rent_id => period_rec.var_rent_id
2524: ,p_period_id => period_rec.period_id
2525: ,p_line_item_id => line_item_rec.line_item_id

Line 2554: IF l_proration_rule = pn_var_trx_pkg.G_PRORUL_NP THEN

2550: /* create details */
2551: FOR bkpt_dtl_rec IN 1..bkpts_tbl(bkpt_rec - 1).bkpt_dtls_tbl.COUNT
2552: LOOP
2553:
2554: IF l_proration_rule = pn_var_trx_pkg.G_PRORUL_NP THEN
2555: IF l_calculation_method = pn_var_trx_pkg.G_CALC_CUMULATIVE THEN
2556: l_prorated_grp_vol_start
2557: := bkpts_tbl(bkpt_rec - 1).bkpt_dtls_tbl(bkpt_dtl_rec).period_bkpt_vol_start;
2558:

Line 2555: IF l_calculation_method = pn_var_trx_pkg.G_CALC_CUMULATIVE THEN

2551: FOR bkpt_dtl_rec IN 1..bkpts_tbl(bkpt_rec - 1).bkpt_dtls_tbl.COUNT
2552: LOOP
2553:
2554: IF l_proration_rule = pn_var_trx_pkg.G_PRORUL_NP THEN
2555: IF l_calculation_method = pn_var_trx_pkg.G_CALC_CUMULATIVE THEN
2556: l_prorated_grp_vol_start
2557: := bkpts_tbl(bkpt_rec - 1).bkpt_dtls_tbl(bkpt_dtl_rec).period_bkpt_vol_start;
2558:
2559: l_prorated_grp_vol_end

Line 2585: pn_var_trx_pkg.insert_trx_dtl

2581: * l_proration_factor;
2582:
2583: END IF;
2584:
2585: pn_var_trx_pkg.insert_trx_dtl
2586: (p_trx_detail_id => l_trx_dtl_id
2587: ,p_trx_header_id => l_trx_hdr_id
2588: ,p_bkpt_detail_id => bkpts_tbl(bkpt_rec - 1).
2589: bkpt_dtls_tbl(bkpt_dtl_rec).

Line 2631: pn_var_trx_pkg.insert_trx_hdr

2627:
2628: /* need to create TRX headers and details */
2629:
2630: /* create header */
2631: pn_var_trx_pkg.insert_trx_hdr
2632: (p_trx_header_id => l_trx_hdr_id
2633: ,p_var_rent_id => period_rec.var_rent_id
2634: ,p_period_id => period_rec.period_id
2635: ,p_line_item_id => line_item_rec.line_item_id

Line 2663: IF l_proration_rule = pn_var_trx_pkg.G_PRORUL_NP THEN

2659:
2660: /* create details */
2661: FOR bkpt_dtl_rec IN 1..bkpts_tbl(l_curr_bkpt_ctr).bkpt_dtls_tbl.COUNT LOOP
2662:
2663: IF l_proration_rule = pn_var_trx_pkg.G_PRORUL_NP THEN
2664: IF l_calculation_method = pn_var_trx_pkg.G_CALC_CUMULATIVE THEN
2665: l_prorated_grp_vol_start
2666: := bkpts_tbl(l_curr_bkpt_ctr).bkpt_dtls_tbl(bkpt_dtl_rec).period_bkpt_vol_start;
2667: l_prorated_grp_vol_end

Line 2664: IF l_calculation_method = pn_var_trx_pkg.G_CALC_CUMULATIVE THEN

2660: /* create details */
2661: FOR bkpt_dtl_rec IN 1..bkpts_tbl(l_curr_bkpt_ctr).bkpt_dtls_tbl.COUNT LOOP
2662:
2663: IF l_proration_rule = pn_var_trx_pkg.G_PRORUL_NP THEN
2664: IF l_calculation_method = pn_var_trx_pkg.G_CALC_CUMULATIVE THEN
2665: l_prorated_grp_vol_start
2666: := bkpts_tbl(l_curr_bkpt_ctr).bkpt_dtls_tbl(bkpt_dtl_rec).period_bkpt_vol_start;
2667: l_prorated_grp_vol_end
2668: := NVL(bkpts_tbl(l_curr_bkpt_ctr).bkpt_dtls_tbl(bkpt_dtl_rec).period_bkpt_vol_end, 0);

Line 2692: pn_var_trx_pkg.insert_trx_dtl

2688: * l_proration_factor;
2689:
2690: END IF;
2691:
2692: pn_var_trx_pkg.insert_trx_dtl
2693: (p_trx_detail_id => l_trx_dtl_id
2694: ,p_trx_header_id => l_trx_hdr_id
2695: ,p_bkpt_detail_id => bkpts_tbl(l_curr_bkpt_ctr).
2696: bkpt_dtls_tbl(bkpt_dtl_rec).

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

2735: /* get the grp IDs right if any trx was updated */
2736: IF l_trx_create_upd_flag THEN
2737: pnp_debug_pkg.log('Trx updated');
2738: /* groups the lines across the periods */
2739: pn_var_trx_pkg.populate_line_grp_id(p_var_rent_id => p_var_rent_id);
2740:
2741: /* populate the reset group IDs */
2742: pn_var_trx_pkg.populate_reset_grp_id(p_var_rent_id => p_var_rent_id);
2743: /* populate fy_pr_grp_vol_start - end,

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

2738: /* groups the lines across the periods */
2739: pn_var_trx_pkg.populate_line_grp_id(p_var_rent_id => p_var_rent_id);
2740:
2741: /* populate the reset group IDs */
2742: pn_var_trx_pkg.populate_reset_grp_id(p_var_rent_id => p_var_rent_id);
2743: /* populate fy_pr_grp_vol_start - end,
2744: ly_pr_grp_vol_start - end,
2745: invoice_flag
2746: for FY, LY, FLY */

Line 2770: IF l_proration_rule = pn_var_trx_pkg.G_PRORUL_LY THEN

2766: line_item_id = for_data_t(i).line_item_id AND
2767: reset_group_id = for_data_t(i).reset_group_id;
2768: END LOOP;
2769:
2770: IF l_proration_rule = pn_var_trx_pkg.G_PRORUL_LY THEN
2771:
2772: /* populate ly_pr_grp_vol_start - end, invoice_flag */
2773: pn_var_trx_pkg.populate_ly_pro_vol
2774: ( p_var_rent_id => p_var_rent_id

Line 2773: pn_var_trx_pkg.populate_ly_pro_vol

2769:
2770: IF l_proration_rule = pn_var_trx_pkg.G_PRORUL_LY THEN
2771:
2772: /* populate ly_pr_grp_vol_start - end, invoice_flag */
2773: pn_var_trx_pkg.populate_ly_pro_vol
2774: ( p_var_rent_id => p_var_rent_id
2775: ,p_proration_rule => l_proration_rule
2776: ,p_vr_commencement_dt => l_vr_commencement_date
2777: ,p_vr_termination_dt => l_vr_termination_date);

Line 2779: ELSIF l_proration_rule = pn_var_trx_pkg.G_PRORUL_FY THEN

2775: ,p_proration_rule => l_proration_rule
2776: ,p_vr_commencement_dt => l_vr_commencement_date
2777: ,p_vr_termination_dt => l_vr_termination_date);
2778:
2779: ELSIF l_proration_rule = pn_var_trx_pkg.G_PRORUL_FY THEN
2780:
2781: /* populate fy_pr_grp_vol_start - end, invoice_flag */
2782: pn_var_trx_pkg.populate_fy_pro_vol
2783: ( p_var_rent_id => p_var_rent_id

Line 2782: pn_var_trx_pkg.populate_fy_pro_vol

2778:
2779: ELSIF l_proration_rule = pn_var_trx_pkg.G_PRORUL_FY THEN
2780:
2781: /* populate fy_pr_grp_vol_start - end, invoice_flag */
2782: pn_var_trx_pkg.populate_fy_pro_vol
2783: ( p_var_rent_id => p_var_rent_id
2784: ,p_proration_rule => l_proration_rule
2785: ,p_vr_commencement_dt => l_vr_commencement_date
2786: ,p_vr_termination_dt => l_vr_termination_date);

Line 2788: ELSIF l_proration_rule = pn_var_trx_pkg.G_PRORUL_FLY THEN

2784: ,p_proration_rule => l_proration_rule
2785: ,p_vr_commencement_dt => l_vr_commencement_date
2786: ,p_vr_termination_dt => l_vr_termination_date);
2787:
2788: ELSIF l_proration_rule = pn_var_trx_pkg.G_PRORUL_FLY THEN
2789:
2790: /* populate ly_pr_grp_vol_start - end, invoice_flag */
2791: pn_var_trx_pkg.populate_ly_pro_vol
2792: ( p_var_rent_id => p_var_rent_id

Line 2791: pn_var_trx_pkg.populate_ly_pro_vol

2787:
2788: ELSIF l_proration_rule = pn_var_trx_pkg.G_PRORUL_FLY THEN
2789:
2790: /* populate ly_pr_grp_vol_start - end, invoice_flag */
2791: pn_var_trx_pkg.populate_ly_pro_vol
2792: ( p_var_rent_id => p_var_rent_id
2793: ,p_proration_rule => l_proration_rule
2794: ,p_vr_commencement_dt => l_vr_commencement_date
2795: ,p_vr_termination_dt => l_vr_termination_date);

Line 2798: pn_var_trx_pkg.populate_fy_pro_vol

2794: ,p_vr_commencement_dt => l_vr_commencement_date
2795: ,p_vr_termination_dt => l_vr_termination_date);
2796:
2797: /* populate fy_pr_grp_vol_start - end, invoice_flag */
2798: pn_var_trx_pkg.populate_fy_pro_vol
2799: ( p_var_rent_id => p_var_rent_id
2800: ,p_proration_rule => l_proration_rule
2801: ,p_vr_commencement_dt => l_vr_commencement_date
2802: ,p_vr_termination_dt => l_vr_termination_date);

Line 2804: ELSIF l_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_CYP

2800: ,p_proration_rule => l_proration_rule
2801: ,p_vr_commencement_dt => l_vr_commencement_date
2802: ,p_vr_termination_dt => l_vr_termination_date);
2803:
2804: ELSIF l_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_CYP
2805: ,pn_var_trx_pkg.G_PRORUL_CYNP) THEN
2806:
2807: /* populate blended_period/grp_vol_start - end */
2808: pn_var_trx_pkg.populate_blended_grp_vol

Line 2805: ,pn_var_trx_pkg.G_PRORUL_CYNP) THEN

2801: ,p_vr_commencement_dt => l_vr_commencement_date
2802: ,p_vr_termination_dt => l_vr_termination_date);
2803:
2804: ELSIF l_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_CYP
2805: ,pn_var_trx_pkg.G_PRORUL_CYNP) THEN
2806:
2807: /* populate blended_period/grp_vol_start - end */
2808: pn_var_trx_pkg.populate_blended_grp_vol
2809: ( p_var_rent_id => p_var_rent_id

Line 2808: pn_var_trx_pkg.populate_blended_grp_vol

2804: ELSIF l_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_CYP
2805: ,pn_var_trx_pkg.G_PRORUL_CYNP) THEN
2806:
2807: /* populate blended_period/grp_vol_start - end */
2808: pn_var_trx_pkg.populate_blended_grp_vol
2809: ( p_var_rent_id => p_var_rent_id
2810: ,p_proration_rule => l_proration_rule);
2811:
2812: END IF;

Line 2815: pn_var_trx_pkg.populate_ytd_pro_vol

2811:
2812: END IF;
2813:
2814: /* ALWAYS populate the ytd_group_vol_start - end - useful */
2815: pn_var_trx_pkg.populate_ytd_pro_vol
2816: ( p_var_rent_id => p_var_rent_id
2817: ,p_proration_rule => l_proration_rule);
2818:
2819: IF l_calculation_method = pn_var_trx_pkg.G_CALC_CUMULATIVE THEN

Line 2819: IF l_calculation_method = pn_var_trx_pkg.G_CALC_CUMULATIVE THEN

2815: pn_var_trx_pkg.populate_ytd_pro_vol
2816: ( p_var_rent_id => p_var_rent_id
2817: ,p_proration_rule => l_proration_rule);
2818:
2819: IF l_calculation_method = pn_var_trx_pkg.G_CALC_CUMULATIVE THEN
2820: /* populate the blended_period_vol_start - end */
2821: pn_var_trx_pkg.populate_blended_period_vol
2822: ( p_var_rent_id => p_var_rent_id
2823: ,p_proration_rule => l_proration_rule

Line 2821: pn_var_trx_pkg.populate_blended_period_vol

2817: ,p_proration_rule => l_proration_rule);
2818:
2819: IF l_calculation_method = pn_var_trx_pkg.G_CALC_CUMULATIVE THEN
2820: /* populate the blended_period_vol_start - end */
2821: pn_var_trx_pkg.populate_blended_period_vol
2822: ( p_var_rent_id => p_var_rent_id
2823: ,p_proration_rule => l_proration_rule
2824: ,p_calc_method => l_calculation_method);
2825:

Line 2914: vol_hist_status_code = pn_var_trx_pkg.G_SALESVOL_STATUS_APPROVED;

2910: WHERE
2911: sales.period_id = p_prd_id AND
2912: sales.line_item_id = p_line_id AND
2913: sales.grp_date_id = p_grp_id AND
2914: vol_hist_status_code = pn_var_trx_pkg.G_SALESVOL_STATUS_APPROVED;
2915:
2916: /* get volumes for a calculation sub-period */
2917: CURSOR vol_hist_c2 ( p_prd_id IN NUMBER
2918: ,p_line_id IN NUMBER

Line 2934: vol_hist_status_code = pn_var_trx_pkg.G_SALESVOL_STATUS_APPROVED;

2930: sales.line_item_id = p_line_id AND
2931: sales.grp_date_id = p_grp_id AND
2932: sales.start_date <= p_end_dt AND
2933: sales.end_date >= p_start_dt AND
2934: vol_hist_status_code = pn_var_trx_pkg.G_SALESVOL_STATUS_APPROVED;
2935:
2936: /* get grp dates */
2937: CURSOR grp_dates_c(p_grp_id IN NUMBER) IS
2938: SELECT

Line 3053: vol_hist_status_code = pn_var_trx_pkg.G_SALESVOL_STATUS_APPROVED;

3049: WHERE
3050: sales.period_id = p_prd_id AND
3051: sales.line_item_id = p_line_id AND
3052: sales.grp_date_id = p_grp_id AND
3053: vol_hist_status_code = pn_var_trx_pkg.G_SALESVOL_STATUS_APPROVED;
3054:
3055: /* get volumes for a calculation sub-period */
3056: CURSOR vol_hist_c2 ( p_prd_id IN NUMBER
3057: ,p_line_id IN NUMBER

Line 3073: vol_hist_status_code = pn_var_trx_pkg.G_SALESVOL_STATUS_APPROVED;

3069: sales.line_item_id = p_line_id AND
3070: sales.grp_date_id = p_grp_id AND
3071: sales.start_date <= p_end_dt AND
3072: sales.end_date >= p_start_dt AND
3073: vol_hist_status_code = pn_var_trx_pkg.G_SALESVOL_STATUS_APPROVED;
3074:
3075: /* get grp dates */
3076: CURSOR grp_dates_c(p_grp_id IN NUMBER) IS
3077: SELECT

Line 3225: IF l_vr_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_LY

3221: END IF;
3222:
3223: l_ly_start_date := ADD_MONTHS(l_vr_termination_date, -12) + 1;
3224:
3225: IF l_vr_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_LY
3226: ,pn_var_trx_pkg.G_PRORUL_FLY) THEN
3227:
3228: FOR prd_rec IN last_period_c( p_vr_id => p_var_rent_id
3229: ,p_term_date => l_vr_termination_date)

Line 3226: ,pn_var_trx_pkg.G_PRORUL_FLY) THEN

3222:
3223: l_ly_start_date := ADD_MONTHS(l_vr_termination_date, -12) + 1;
3224:
3225: IF l_vr_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_LY
3226: ,pn_var_trx_pkg.G_PRORUL_FLY) THEN
3227:
3228: FOR prd_rec IN last_period_c( p_vr_id => p_var_rent_id
3229: ,p_term_date => l_vr_termination_date)
3230: LOOP

Line 3260: = pn_var_trx_pkg.get_calc_prd_sales( var_rent_id

3256: UPDATE
3257: pn_var_trx_headers_all
3258: SET
3259: ly_proration_sales
3260: = pn_var_trx_pkg.get_calc_prd_sales( var_rent_id
3261: ,period_id
3262: ,line_item_id
3263: ,grp_date_id
3264: ,l_ly_start_date

Line 3348: IF l_vr_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_FY

3344: END IF;
3345:
3346: l_fy_end_date := ADD_MONTHS(l_vr_commencement_date, 12) - 1;
3347:
3348: IF l_vr_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_FY
3349: ,pn_var_trx_pkg.G_PRORUL_FLY) THEN
3350:
3351: FOR prd_rec IN first_period_c( p_vr_id => p_var_rent_id
3352: ,p_comm_date => l_vr_commencement_date)

Line 3349: ,pn_var_trx_pkg.G_PRORUL_FLY) THEN

3345:
3346: l_fy_end_date := ADD_MONTHS(l_vr_commencement_date, 12) - 1;
3347:
3348: IF l_vr_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_FY
3349: ,pn_var_trx_pkg.G_PRORUL_FLY) THEN
3350:
3351: FOR prd_rec IN first_period_c( p_vr_id => p_var_rent_id
3352: ,p_comm_date => l_vr_commencement_date)
3353: LOOP

Line 3382: = pn_var_trx_pkg.get_calc_prd_sales( var_rent_id

3378: UPDATE
3379: pn_var_trx_headers_all
3380: SET
3381: fy_proration_sales
3382: = pn_var_trx_pkg.get_calc_prd_sales( var_rent_id
3383: ,period_id
3384: ,line_item_id
3385: ,grp_date_id
3386: ,calc_prd_start_date

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

3534: ytd_sales_t NUM_T;
3535:
3536: BEGIN
3537:
3538: pnp_debug_pkg.log('++++ pn_var_trx_pkg.populate_ytd_sales START ++++');
3539:
3540: /* get VR details */
3541: IF p_proration_rule IS NULL THEN
3542:

Line 3560: IF l_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_FY

3556: pnp_debug_pkg.log(' p_var_rent_id: '||p_var_rent_id);
3557: pnp_debug_pkg.log(' l_proration_rule: '||l_proration_rule);
3558:
3559: /* l_proration_rule based decisions */
3560: IF l_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_FY
3561: ,pn_var_trx_pkg.G_PRORUL_LY
3562: ,pn_var_trx_pkg.G_PRORUL_FLY
3563: ,pn_var_trx_pkg.G_PRORUL_NP
3564: ,pn_var_trx_pkg.G_PRORUL_STD) THEN

Line 3561: ,pn_var_trx_pkg.G_PRORUL_LY

3557: pnp_debug_pkg.log(' l_proration_rule: '||l_proration_rule);
3558:
3559: /* l_proration_rule based decisions */
3560: IF l_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_FY
3561: ,pn_var_trx_pkg.G_PRORUL_LY
3562: ,pn_var_trx_pkg.G_PRORUL_FLY
3563: ,pn_var_trx_pkg.G_PRORUL_NP
3564: ,pn_var_trx_pkg.G_PRORUL_STD) THEN
3565:

Line 3562: ,pn_var_trx_pkg.G_PRORUL_FLY

3558:
3559: /* l_proration_rule based decisions */
3560: IF l_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_FY
3561: ,pn_var_trx_pkg.G_PRORUL_LY
3562: ,pn_var_trx_pkg.G_PRORUL_FLY
3563: ,pn_var_trx_pkg.G_PRORUL_NP
3564: ,pn_var_trx_pkg.G_PRORUL_STD) THEN
3565:
3566: FOR line_rec IN lines_c(p_vr_id => p_var_rent_id) LOOP

Line 3563: ,pn_var_trx_pkg.G_PRORUL_NP

3559: /* l_proration_rule based decisions */
3560: IF l_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_FY
3561: ,pn_var_trx_pkg.G_PRORUL_LY
3562: ,pn_var_trx_pkg.G_PRORUL_FLY
3563: ,pn_var_trx_pkg.G_PRORUL_NP
3564: ,pn_var_trx_pkg.G_PRORUL_STD) THEN
3565:
3566: FOR line_rec IN lines_c(p_vr_id => p_var_rent_id) LOOP
3567:

Line 3564: ,pn_var_trx_pkg.G_PRORUL_STD) THEN

3560: IF l_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_FY
3561: ,pn_var_trx_pkg.G_PRORUL_LY
3562: ,pn_var_trx_pkg.G_PRORUL_FLY
3563: ,pn_var_trx_pkg.G_PRORUL_NP
3564: ,pn_var_trx_pkg.G_PRORUL_STD) THEN
3565:
3566: FOR line_rec IN lines_c(p_vr_id => p_var_rent_id) LOOP
3567:
3568: trx_hdr_t.DELETE;

Line 3591: ELSIF l_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_CYP

3587: trx_header_id = trx_hdr_t(i);
3588:
3589: END LOOP;
3590:
3591: ELSIF l_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_CYP
3592: ,pn_var_trx_pkg.G_PRORUL_CYNP) THEN
3593:
3594: /* fetch partial and full period details */
3595: l_counter1 := 0;

Line 3592: ,pn_var_trx_pkg.G_PRORUL_CYNP) THEN

3588:
3589: END LOOP;
3590:
3591: ELSIF l_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_CYP
3592: ,pn_var_trx_pkg.G_PRORUL_CYNP) THEN
3593:
3594: /* fetch partial and full period details */
3595: l_counter1 := 0;
3596: FOR prd_rec IN periods_c(p_vr_id => p_var_rent_id) LOOP

Line 3803: pn_var_trx_pkg.get_calc_prd_sales

3799: l_counter := l_counter + 1;
3800:
3801: trx_hdr_t(l_counter) := trx_rec.trx_header_id;
3802:
3803: pn_var_trx_pkg.get_calc_prd_sales
3804: ( p_var_rent_id => trx_rec.var_rent_id
3805: ,p_period_id => trx_rec.period_id
3806: ,p_line_item_id => trx_rec.line_item_id
3807: ,p_grp_date_id => trx_rec.grp_date_id

Line 3834: IF l_proration_rule = pn_var_trx_pkg.G_PRORUL_LY THEN

3830: END LOOP;
3831:
3832: IF l_sales_create_upd_flag THEN
3833:
3834: IF l_proration_rule = pn_var_trx_pkg.G_PRORUL_LY THEN
3835:
3836: pn_var_trx_pkg.populate_ly_pro_sales
3837: ( p_var_rent_id => p_var_rent_id
3838: ,p_proration_rule => l_proration_rule

Line 3836: pn_var_trx_pkg.populate_ly_pro_sales

3832: IF l_sales_create_upd_flag THEN
3833:
3834: IF l_proration_rule = pn_var_trx_pkg.G_PRORUL_LY THEN
3835:
3836: pn_var_trx_pkg.populate_ly_pro_sales
3837: ( p_var_rent_id => p_var_rent_id
3838: ,p_proration_rule => l_proration_rule
3839: ,p_vr_commencement_dt => l_vr_commencement_date
3840: ,p_vr_termination_dt => l_vr_termination_date);

Line 3842: ELSIF l_proration_rule = pn_var_trx_pkg.G_PRORUL_FY THEN

3838: ,p_proration_rule => l_proration_rule
3839: ,p_vr_commencement_dt => l_vr_commencement_date
3840: ,p_vr_termination_dt => l_vr_termination_date);
3841:
3842: ELSIF l_proration_rule = pn_var_trx_pkg.G_PRORUL_FY THEN
3843:
3844: pn_var_trx_pkg.populate_fy_pro_sales
3845: ( p_var_rent_id => p_var_rent_id
3846: ,p_proration_rule => l_proration_rule

Line 3844: pn_var_trx_pkg.populate_fy_pro_sales

3840: ,p_vr_termination_dt => l_vr_termination_date);
3841:
3842: ELSIF l_proration_rule = pn_var_trx_pkg.G_PRORUL_FY THEN
3843:
3844: pn_var_trx_pkg.populate_fy_pro_sales
3845: ( p_var_rent_id => p_var_rent_id
3846: ,p_proration_rule => l_proration_rule
3847: ,p_vr_commencement_dt => l_vr_commencement_date
3848: ,p_vr_termination_dt => l_vr_termination_date);

Line 3850: ELSIF l_proration_rule = pn_var_trx_pkg.G_PRORUL_FLY THEN

3846: ,p_proration_rule => l_proration_rule
3847: ,p_vr_commencement_dt => l_vr_commencement_date
3848: ,p_vr_termination_dt => l_vr_termination_date);
3849:
3850: ELSIF l_proration_rule = pn_var_trx_pkg.G_PRORUL_FLY THEN
3851:
3852: pn_var_trx_pkg.populate_ly_pro_sales
3853: ( p_var_rent_id => p_var_rent_id
3854: ,p_proration_rule => l_proration_rule

Line 3852: pn_var_trx_pkg.populate_ly_pro_sales

3848: ,p_vr_termination_dt => l_vr_termination_date);
3849:
3850: ELSIF l_proration_rule = pn_var_trx_pkg.G_PRORUL_FLY THEN
3851:
3852: pn_var_trx_pkg.populate_ly_pro_sales
3853: ( p_var_rent_id => p_var_rent_id
3854: ,p_proration_rule => l_proration_rule
3855: ,p_vr_commencement_dt => l_vr_commencement_date
3856: ,p_vr_termination_dt => l_vr_termination_date);

Line 3858: pn_var_trx_pkg.populate_fy_pro_sales

3854: ,p_proration_rule => l_proration_rule
3855: ,p_vr_commencement_dt => l_vr_commencement_date
3856: ,p_vr_termination_dt => l_vr_termination_date);
3857:
3858: pn_var_trx_pkg.populate_fy_pro_sales
3859: ( p_var_rent_id => p_var_rent_id
3860: ,p_proration_rule => l_proration_rule
3861: ,p_vr_commencement_dt => l_vr_commencement_date
3862: ,p_vr_termination_dt => l_vr_termination_date);

Line 3867: pn_var_trx_pkg.populate_ytd_sales

3863:
3864: END IF;
3865:
3866: /* always populate YTD sales - very useful */
3867: pn_var_trx_pkg.populate_ytd_sales
3868: ( p_var_rent_id => p_var_rent_id
3869: ,p_proration_rule => l_proration_rule);
3870:
3871: END IF;

Line 4251: IF l_calculation_method IN ( pn_var_trx_pkg.G_CALC_YTD

4247: ELSE
4248: l_calculation_method := p_calc_method;
4249: END IF;
4250:
4251: IF l_calculation_method IN ( pn_var_trx_pkg.G_CALC_YTD
4252: ,pn_var_trx_pkg.G_CALC_CUMULATIVE) THEN
4253:
4254: FOR line_rec IN lines_c(p_vr_id => p_var_rent_id) LOOP
4255:

Line 4252: ,pn_var_trx_pkg.G_CALC_CUMULATIVE) THEN

4248: l_calculation_method := p_calc_method;
4249: END IF;
4250:
4251: IF l_calculation_method IN ( pn_var_trx_pkg.G_CALC_YTD
4252: ,pn_var_trx_pkg.G_CALC_CUMULATIVE) THEN
4253:
4254: FOR line_rec IN lines_c(p_vr_id => p_var_rent_id) LOOP
4255:
4256: trx_hdr_t.DELETE;

Line 4414: pn_var_trx_pkg.get_calc_prd_sales_for

4410: l_counter := l_counter + 1;
4411:
4412: trx_hdr_t(l_counter) := trx_rec.trx_header_id;
4413:
4414: pn_var_trx_pkg.get_calc_prd_sales_for
4415: ( p_var_rent_id => trx_rec.var_rent_id
4416: ,p_period_id => trx_rec.period_id
4417: ,p_line_item_id => trx_rec.line_item_id
4418: ,p_grp_date_id => trx_rec.grp_date_id

Line 4444: pn_var_trx_pkg.populate_ytd_sales_for

4440: END LOOP;
4441:
4442: /*Similar to actuals - We always populate YTD sales*/
4443:
4444: pn_var_trx_pkg.populate_ytd_sales_for
4445: ( p_var_rent_id => p_var_rent_id
4446: ,p_calc_method => l_calculation_method);
4447:
4448: /*This would be needed in actual sales, but not for forecasted.

Line 4792: IF l_vr_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_LY

4788: END IF;
4789:
4790: l_ly_start_date := ADD_MONTHS(l_vr_termination_date, -12) + 1;
4791:
4792: IF l_vr_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_LY
4793: ,pn_var_trx_pkg.G_PRORUL_FLY) THEN
4794:
4795: /* init ly_proration_sales */
4796: UPDATE

Line 4793: ,pn_var_trx_pkg.G_PRORUL_FLY) THEN

4789:
4790: l_ly_start_date := ADD_MONTHS(l_vr_termination_date, -12) + 1;
4791:
4792: IF l_vr_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_LY
4793: ,pn_var_trx_pkg.G_PRORUL_FLY) THEN
4794:
4795: /* init ly_proration_sales */
4796: UPDATE
4797: pn_var_trx_headers_all

Line 4818: = pn_var_trx_pkg.get_calc_prd_dedc( var_rent_id

4814: UPDATE
4815: pn_var_trx_headers_all
4816: SET
4817: ly_proration_deductions
4818: = pn_var_trx_pkg.get_calc_prd_dedc( var_rent_id
4819: ,period_id
4820: ,line_item_id
4821: ,grp_date_id
4822: ,l_ly_start_date

Line 4890: IF l_vr_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_FY

4886: END IF;
4887:
4888: l_fy_end_date := ADD_MONTHS(l_vr_commencement_date, 12) - 1;
4889:
4890: IF l_vr_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_FY
4891: ,pn_var_trx_pkg.G_PRORUL_FLY) THEN
4892:
4893: /* init ly_proration_deductions */
4894: UPDATE

Line 4891: ,pn_var_trx_pkg.G_PRORUL_FLY) THEN

4887:
4888: l_fy_end_date := ADD_MONTHS(l_vr_commencement_date, 12) - 1;
4889:
4890: IF l_vr_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_FY
4891: ,pn_var_trx_pkg.G_PRORUL_FLY) THEN
4892:
4893: /* init ly_proration_deductions */
4894: UPDATE
4895: pn_var_trx_headers_all

Line 4916: = pn_var_trx_pkg.get_calc_prd_dedc( var_rent_id

4912: UPDATE
4913: pn_var_trx_headers_all
4914: SET
4915: fy_proration_deductions
4916: = pn_var_trx_pkg.get_calc_prd_dedc( var_rent_id
4917: ,period_id
4918: ,line_item_id
4919: ,grp_date_id
4920: ,calc_prd_start_date

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

5065: ytd_deductions_t NUM_T;
5066:
5067: BEGIN
5068:
5069: pnp_debug_pkg.log('++++ pn_var_trx_pkg.populate_ytd_deductions START ++++');
5070:
5071: /* get VR details */
5072: IF p_proration_rule IS NULL THEN
5073:

Line 5091: IF l_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_FY

5087: pnp_debug_pkg.log(' p_var_rent_id: '||p_var_rent_id);
5088: pnp_debug_pkg.log(' l_proration_rule: '||l_proration_rule);
5089:
5090: /* l_proration_rule based decisions */
5091: IF l_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_FY
5092: ,pn_var_trx_pkg.G_PRORUL_LY
5093: ,pn_var_trx_pkg.G_PRORUL_FLY
5094: ,pn_var_trx_pkg.G_PRORUL_NP
5095: ,pn_var_trx_pkg.G_PRORUL_STD) THEN

Line 5092: ,pn_var_trx_pkg.G_PRORUL_LY

5088: pnp_debug_pkg.log(' l_proration_rule: '||l_proration_rule);
5089:
5090: /* l_proration_rule based decisions */
5091: IF l_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_FY
5092: ,pn_var_trx_pkg.G_PRORUL_LY
5093: ,pn_var_trx_pkg.G_PRORUL_FLY
5094: ,pn_var_trx_pkg.G_PRORUL_NP
5095: ,pn_var_trx_pkg.G_PRORUL_STD) THEN
5096:

Line 5093: ,pn_var_trx_pkg.G_PRORUL_FLY

5089:
5090: /* l_proration_rule based decisions */
5091: IF l_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_FY
5092: ,pn_var_trx_pkg.G_PRORUL_LY
5093: ,pn_var_trx_pkg.G_PRORUL_FLY
5094: ,pn_var_trx_pkg.G_PRORUL_NP
5095: ,pn_var_trx_pkg.G_PRORUL_STD) THEN
5096:
5097: FOR line_rec IN lines_c(p_vr_id => p_var_rent_id) LOOP

Line 5094: ,pn_var_trx_pkg.G_PRORUL_NP

5090: /* l_proration_rule based decisions */
5091: IF l_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_FY
5092: ,pn_var_trx_pkg.G_PRORUL_LY
5093: ,pn_var_trx_pkg.G_PRORUL_FLY
5094: ,pn_var_trx_pkg.G_PRORUL_NP
5095: ,pn_var_trx_pkg.G_PRORUL_STD) THEN
5096:
5097: FOR line_rec IN lines_c(p_vr_id => p_var_rent_id) LOOP
5098:

Line 5095: ,pn_var_trx_pkg.G_PRORUL_STD) THEN

5091: IF l_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_FY
5092: ,pn_var_trx_pkg.G_PRORUL_LY
5093: ,pn_var_trx_pkg.G_PRORUL_FLY
5094: ,pn_var_trx_pkg.G_PRORUL_NP
5095: ,pn_var_trx_pkg.G_PRORUL_STD) THEN
5096:
5097: FOR line_rec IN lines_c(p_vr_id => p_var_rent_id) LOOP
5098:
5099: trx_hdr_t.DELETE;

Line 5122: ELSIF l_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_CYP

5118: trx_header_id = trx_hdr_t(i);
5119:
5120: END LOOP;
5121:
5122: ELSIF l_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_CYP
5123: ,pn_var_trx_pkg.G_PRORUL_CYNP) THEN
5124:
5125: /* fetch partial and full period details */
5126: l_counter1 := 0;

Line 5123: ,pn_var_trx_pkg.G_PRORUL_CYNP) THEN

5119:
5120: END LOOP;
5121:
5122: ELSIF l_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_CYP
5123: ,pn_var_trx_pkg.G_PRORUL_CYNP) THEN
5124:
5125: /* fetch partial and full period details */
5126: l_counter1 := 0;
5127: FOR prd_rec IN periods_c(p_vr_id => p_var_rent_id) LOOP

Line 5324: pn_var_trx_pkg.get_calc_prd_dedc

5320: l_counter := l_counter + 1;
5321:
5322: trx_hdr_t(l_counter) := trx_rec.trx_header_id;
5323:
5324: pn_var_trx_pkg.get_calc_prd_dedc
5325: ( p_var_rent_id => trx_rec.var_rent_id
5326: ,p_period_id => trx_rec.period_id
5327: ,p_line_item_id => trx_rec.line_item_id
5328: ,p_grp_date_id => trx_rec.grp_date_id

Line 5354: IF l_proration_rule = pn_var_trx_pkg.G_PRORUL_LY THEN

5350:
5351: END LOOP;
5352:
5353:
5354: IF l_proration_rule = pn_var_trx_pkg.G_PRORUL_LY THEN
5355:
5356: pn_var_trx_pkg.populate_ly_pro_dedc
5357: ( p_var_rent_id => p_var_rent_id
5358: ,p_proration_rule => l_proration_rule

Line 5356: pn_var_trx_pkg.populate_ly_pro_dedc

5352:
5353:
5354: IF l_proration_rule = pn_var_trx_pkg.G_PRORUL_LY THEN
5355:
5356: pn_var_trx_pkg.populate_ly_pro_dedc
5357: ( p_var_rent_id => p_var_rent_id
5358: ,p_proration_rule => l_proration_rule
5359: ,p_vr_commencement_dt => l_vr_commencement_date
5360: ,p_vr_termination_dt => l_vr_termination_date);

Line 5362: ELSIF l_proration_rule = pn_var_trx_pkg.G_PRORUL_FY THEN

5358: ,p_proration_rule => l_proration_rule
5359: ,p_vr_commencement_dt => l_vr_commencement_date
5360: ,p_vr_termination_dt => l_vr_termination_date);
5361:
5362: ELSIF l_proration_rule = pn_var_trx_pkg.G_PRORUL_FY THEN
5363:
5364: pn_var_trx_pkg.populate_fy_pro_dedc
5365: ( p_var_rent_id => p_var_rent_id
5366: ,p_proration_rule => l_proration_rule

Line 5364: pn_var_trx_pkg.populate_fy_pro_dedc

5360: ,p_vr_termination_dt => l_vr_termination_date);
5361:
5362: ELSIF l_proration_rule = pn_var_trx_pkg.G_PRORUL_FY THEN
5363:
5364: pn_var_trx_pkg.populate_fy_pro_dedc
5365: ( p_var_rent_id => p_var_rent_id
5366: ,p_proration_rule => l_proration_rule
5367: ,p_vr_commencement_dt => l_vr_commencement_date
5368: ,p_vr_termination_dt => l_vr_termination_date);

Line 5370: ELSIF l_proration_rule = pn_var_trx_pkg.G_PRORUL_FLY THEN

5366: ,p_proration_rule => l_proration_rule
5367: ,p_vr_commencement_dt => l_vr_commencement_date
5368: ,p_vr_termination_dt => l_vr_termination_date);
5369:
5370: ELSIF l_proration_rule = pn_var_trx_pkg.G_PRORUL_FLY THEN
5371:
5372: pn_var_trx_pkg.populate_ly_pro_dedc
5373: ( p_var_rent_id => p_var_rent_id
5374: ,p_proration_rule => l_proration_rule

Line 5372: pn_var_trx_pkg.populate_ly_pro_dedc

5368: ,p_vr_termination_dt => l_vr_termination_date);
5369:
5370: ELSIF l_proration_rule = pn_var_trx_pkg.G_PRORUL_FLY THEN
5371:
5372: pn_var_trx_pkg.populate_ly_pro_dedc
5373: ( p_var_rent_id => p_var_rent_id
5374: ,p_proration_rule => l_proration_rule
5375: ,p_vr_commencement_dt => l_vr_commencement_date
5376: ,p_vr_termination_dt => l_vr_termination_date);

Line 5378: pn_var_trx_pkg.populate_fy_pro_dedc

5374: ,p_proration_rule => l_proration_rule
5375: ,p_vr_commencement_dt => l_vr_commencement_date
5376: ,p_vr_termination_dt => l_vr_termination_date);
5377:
5378: pn_var_trx_pkg.populate_fy_pro_dedc
5379: ( p_var_rent_id => p_var_rent_id
5380: ,p_proration_rule => l_proration_rule
5381: ,p_vr_commencement_dt => l_vr_commencement_date
5382: ,p_vr_termination_dt => l_vr_termination_date);

Line 5387: pn_var_trx_pkg.populate_ytd_deductions

5383:
5384: END IF;
5385:
5386: /* always populate YTD deductions - Because we always populate YTD sales */
5387: pn_var_trx_pkg.populate_ytd_deductions
5388: ( p_var_rent_id => p_var_rent_id
5389: ,p_proration_rule => l_proration_rule);
5390:
5391: EXCEPTION

Line 5399: END pn_var_trx_pkg;

5395:
5396:
5397:
5398:
5399: END pn_var_trx_pkg;