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_HEADERS_ALL

Line 135: pn_var_trx_headers_all

131: CURSOR trx_header_exists_c IS
132: SELECT
133: trx_header_id
134: FROM
135: pn_var_trx_headers_all
136: WHERE
137: var_rent_id = p_vr_id AND
138: period_id = p_period_id AND
139: line_item_id = p_line_item_id AND

Line 243: INSERT INTO pn_var_trx_headers_all

239: ,p_last_update_login IN NUMBER) IS
240:
241: BEGIN
242:
243: INSERT INTO pn_var_trx_headers_all
244: (trx_header_id
245: ,var_rent_id
246: ,period_id
247: ,line_item_id

Line 423: pn_var_trx_headers_all

419: WHERE EXISTS
420: (SELECT
421: trx_header_id
422: FROM
423: pn_var_trx_headers_all
424: WHERE
425: var_rent_id = p_vr_id AND
426: line_item_group_id IS NULL
427: AND rownum = 1);

Line 461: pn_var_trx_headers_all

457:
458: FOR line_typ_rec IN line_type_cat_c(p_vr_id => p_var_rent_id) LOOP
459:
460: UPDATE
461: pn_var_trx_headers_all
462: SET
463: line_item_group_id = l_line_grp_id
464: WHERE
465: line_item_id IN

Line 509: pn_var_trx_headers_all

505: trx_header_id
506: ,calc_prd_start_date
507: ,line_item_group_id
508: FROM
509: pn_var_trx_headers_all
510: WHERE
511: var_rent_id = p_vr_id
512: ORDER BY
513: line_item_group_id

Line 620: pn_var_trx_headers_all

616:
617: /* update trx hdr, set reset grp ID */
618: FORALL hdr_rec IN 1..trx_hdr_tbl.COUNT
619: UPDATE
620: pn_var_trx_headers_all
621: SET
622: reset_group_id = reset_ctr_tbl(hdr_rec)
623: WHERE
624: trx_header_id = trx_hdr_tbl(hdr_rec);

Line 667: pn_var_trx_headers_all hdr

663: hdr.trx_header_id
664: ,hdr.calc_prd_start_date
665: ,hdr.calc_prd_end_date
666: FROM
667: pn_var_trx_headers_all hdr
668: WHERE
669: hdr.var_rent_id = p_vr_id AND
670: p_date BETWEEN (hdr.calc_prd_start_date + 1) AND hdr.calc_prd_end_date;
671:

Line 726: pn_var_trx_headers_all

722: END LOOP;
723:
724: /* init invoice flag */
725: UPDATE
726: pn_var_trx_headers_all
727: SET
728: invoice_flag = NULL
729: WHERE
730: var_rent_id = p_var_rent_id AND

Line 737: pn_var_trx_headers_all

733: IF l_partial_period = 'Y' THEN
734:
735: /* populate invoice flag = N */
736: UPDATE
737: pn_var_trx_headers_all
738: SET
739: invoice_flag = 'N'
740: WHERE
741: var_rent_id = p_var_rent_id AND

Line 746: pn_var_trx_headers_all

742: period_id = l_last_period_id;
743:
744: /* populate invoice flag = I */
745: UPDATE
746: pn_var_trx_headers_all
747: SET
748: invoice_flag = 'I'
749: WHERE
750: var_rent_id = p_var_rent_id AND

Line 768: pn_var_trx_headers_all

764: WHERE
765: trx_header_id IN (SELECT
766: trx_header_id
767: FROM
768: pn_var_trx_headers_all
769: WHERE
770: var_rent_id = p_var_rent_id);
771:
772: IF l_partial_period = 'Y' THEN

Line 784: pn_var_trx_headers_all

780: WHERE
781: trx_header_id IN (SELECT
782: trx_header_id
783: FROM
784: pn_var_trx_headers_all
785: WHERE
786: var_rent_id = p_var_rent_id AND
787: calc_prd_start_date >= l_ly_start_date);
788:

Line 854: pn_var_trx_headers_all hdr

850: hdr.trx_header_id
851: ,hdr.calc_prd_start_date
852: ,hdr.calc_prd_end_date
853: FROM
854: pn_var_trx_headers_all hdr
855: WHERE
856: hdr.var_rent_id = p_vr_id AND
857: p_date BETWEEN hdr.calc_prd_start_date AND (hdr.calc_prd_end_date - 1);
858:

Line 915: pn_var_trx_headers_all

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
916: SET
917: invoice_flag = NULL
918: WHERE
919: var_rent_id = p_var_rent_id AND

Line 928: pn_var_trx_headers_all

924: IF l_partial_period = 'Y' THEN
925:
926: /* populate invoice flag = N */
927: UPDATE
928: pn_var_trx_headers_all
929: SET
930: invoice_flag = 'N'
931: WHERE
932: var_rent_id = p_var_rent_id AND

Line 944: pn_var_trx_headers_all

940: prd.partial_period = 'Y');
941:
942: /* populate invoice flag = I */
943: UPDATE
944: pn_var_trx_headers_all
945: SET
946: invoice_flag = 'I'
947: WHERE
948: var_rent_id = p_var_rent_id AND

Line 963: pn_var_trx_headers_all

959: WHERE
960: trx_header_id IN (SELECT
961: trx_header_id
962: FROM
963: pn_var_trx_headers_all
964: WHERE
965: var_rent_id = p_var_rent_id);
966:
967: IF l_partial_period = 'Y' THEN

Line 978: pn_var_trx_headers_all

974: WHERE
975: trx_header_id IN (SELECT
976: trx_header_id
977: FROM
978: pn_var_trx_headers_all
979: WHERE
980: var_rent_id = p_var_rent_id AND
981: calc_prd_end_date <= l_fy_end_date);
982:

Line 1108: pn_var_trx_headers_all hdr

1104: ,dtl.bkpt_rate
1105: ,SUM(dtl.prorated_grp_vol_start) AS blended_period_vol_start
1106: ,SUM(dtl.prorated_grp_vol_end) AS blended_period_vol_end
1107: FROM
1108: pn_var_trx_headers_all hdr
1109: ,pn_var_trx_details_all dtl
1110: WHERE
1111: hdr.var_rent_id = p_vr_id AND
1112: hdr.period_id IN (p_part_prd_ID, p_full_prd_ID) AND

Line 1128: pn_var_trx_headers_all hdr

1124: ,grp.grp_date_id
1125: ,grp.proration_factor AS grp_prorat_factor
1126: ,hdr.proration_factor AS calc_prd_prorat_factor
1127: FROM
1128: pn_var_trx_headers_all hdr
1129: ,pn_var_grp_dates_all grp
1130: WHERE
1131: hdr.var_rent_id = p_vr_id AND
1132: hdr.period_id = p_prd_id /*AND

Line 1146: pn_var_trx_headers_all hdr

1142: ,grp.grp_date_id
1143: ,grp.proration_factor AS grp_prorat_factor
1144: ,hdr.proration_factor AS calc_prd_prorat_factor
1145: FROM
1146: pn_var_trx_headers_all hdr
1147: ,pn_var_grp_dates_all grp
1148: WHERE
1149: hdr.var_rent_id = p_vr_id AND
1150: hdr.period_id = p_prd_id /*AND

Line 1230: pn_var_trx_headers_all

1226:
1227: l_context := 'CYP - update invoice_flag';
1228: /* reset the invoice flag */
1229: UPDATE
1230: pn_var_trx_headers_all
1231: SET
1232: invoice_flag = NULL
1233: WHERE
1234: var_rent_id = p_var_rent_id AND

Line 1239: pn_var_trx_headers_all

1235: invoice_flag = 'P';
1236:
1237: /* populate invoice_flag */
1238: UPDATE
1239: pn_var_trx_headers_all
1240: SET
1241: invoice_flag = 'P'
1242: WHERE
1243: trx_header_id IN (SELECT

Line 1246: pn_var_trx_headers_all

1242: WHERE
1243: trx_header_id IN (SELECT
1244: trx_header_id
1245: FROM
1246: pn_var_trx_headers_all
1247: WHERE
1248: var_rent_id = p_var_rent_id AND
1249: period_id IN (l_part_prd_id, l_full_prd_id)
1250: );

Line 1267: pn_var_trx_headers_all

1263: WHERE
1264: trx_header_id IN (SELECT
1265: trx_header_id
1266: FROM
1267: pn_var_trx_headers_all
1268: WHERE
1269: var_rent_id = p_var_rent_id);
1270:
1271: /* populate pr_grp_blended_vol_start - pr_grp_blended_vol_end */

Line 1281: pn_var_trx_headers_all

1277: WHERE
1278: trx_header_id IN (SELECT
1279: trx_header_id
1280: FROM
1281: pn_var_trx_headers_all
1282: WHERE
1283: var_rent_id = p_var_rent_id AND
1284: period_id IN (l_part_prd_id, l_full_prd_id)
1285: );

Line 1307: pn_var_trx_headers_all

1303: WHERE
1304: trx_header_id IN (SELECT
1305: trx_header_id
1306: FROM
1307: pn_var_trx_headers_all
1308: WHERE
1309: var_rent_id = p_var_rent_id AND
1310: period_id IN (l_part_prd_id, l_full_prd_id) AND
1311: line_item_group_id = cyp_rec.line_item_group_id

Line 1326: pn_var_trx_headers_all

1322: l_context := 'CYNP - update invoice_flag';
1323:
1324: /* reset the invoice flag */
1325: UPDATE
1326: pn_var_trx_headers_all
1327: SET
1328: invoice_flag = NULL
1329: WHERE
1330: var_rent_id = p_var_rent_id AND

Line 1335: pn_var_trx_headers_all

1331: invoice_flag = 'P';
1332:
1333: /* populate fy_pr_grp_vol_start - fy_pr_grp_vol_end */
1334: UPDATE
1335: pn_var_trx_headers_all
1336: SET
1337: invoice_flag = 'P'
1338: WHERE
1339: trx_header_id IN (SELECT

Line 1342: pn_var_trx_headers_all

1338: WHERE
1339: trx_header_id IN (SELECT
1340: trx_header_id
1341: FROM
1342: pn_var_trx_headers_all
1343: WHERE
1344: var_rent_id = p_var_rent_id AND
1345: period_id IN (l_part_prd_id, l_full_prd_id)
1346: );

Line 1363: pn_var_trx_headers_all

1359: WHERE
1360: trx_header_id IN (SELECT
1361: trx_header_id
1362: FROM
1363: pn_var_trx_headers_all
1364: WHERE
1365: var_rent_id = p_var_rent_id);
1366:
1367: FOR cynp_rec IN blended_prd_vol_cs( p_vr_id => p_var_rent_id

Line 1391: pn_var_trx_headers_all

1387: WHERE
1388: trx_header_id IN (SELECT
1389: trx_header_id
1390: FROM
1391: pn_var_trx_headers_all
1392: WHERE
1393: var_rent_id = p_var_rent_id AND
1394: period_id IN (l_part_prd_id, l_full_prd_id)AND
1395: line_item_group_id = cynp_rec.line_item_group_id

Line 1583: pn_var_trx_headers_all hdr

1579: ORDER BY
1580: hdr.calc_prd_start_date
1581: ROWS UNBOUNDED PRECEDING) AS ytd_group_vol_end
1582: FROM
1583: pn_var_trx_headers_all hdr
1584: ,pn_var_trx_details_all dtl
1585: WHERE
1586: hdr.var_rent_id = p_vr_id AND
1587: hdr.period_id = p_prd_ID AND

Line 1616: pn_var_trx_headers_all hdr

1612: ORDER BY
1613: hdr.calc_prd_start_date
1614: ROWS UNBOUNDED PRECEDING) AS ytd_group_vol_end
1615: FROM
1616: pn_var_trx_headers_all hdr
1617: ,pn_var_trx_details_all dtl
1618: WHERE
1619: hdr.var_rent_id = p_vr_id AND
1620: hdr.period_id IN (p_part_prd_id, p_full_prd_id) AND

Line 1835: pn_var_trx_headers_all hdr

1831: ,dtl.bkpt_rate
1832: ,SUM(prorated_grp_vol_start) AS blended_period_vol_start
1833: ,SUM(prorated_grp_vol_end) AS blended_period_vol_end
1834: FROM
1835: pn_var_trx_headers_all hdr
1836: ,pn_var_trx_details_all dtl
1837: WHERE
1838: hdr.var_rent_id = p_vr_id AND
1839: hdr.period_id = p_prd_id AND

Line 1954: pn_var_trx_headers_all

1950: trx_header_id IN
1951: (SELECT
1952: trx_header_id
1953: FROM
1954: pn_var_trx_headers_all
1955: WHERE
1956: var_rent_id = p_var_rent_id AND
1957: period_id = rec.period_id AND
1958: line_item_id = rec.line_item_id AND

Line 2008: pn_var_trx_headers_all

2004: trx_header_id IN
2005: ( SELECT
2006: trx_header_id
2007: FROM
2008: pn_var_trx_headers_all
2009: WHERE
2010: var_rent_id = p_var_rent_id AND
2011: period_id = p_period_id AND
2012: line_item_id = p_line_item_id );

Line 2015: pn_var_trx_headers_all

2011: period_id = p_period_id AND
2012: line_item_id = p_line_item_id );
2013:
2014: DELETE
2015: pn_var_trx_headers_all
2016: WHERE
2017: var_rent_id = p_var_rent_id AND
2018: period_id = p_period_id AND
2019: line_item_id = p_line_item_id;

Line 2033: pn_var_trx_headers_all

2029: trx_header_id IN
2030: ( SELECT
2031: trx_header_id
2032: FROM
2033: pn_var_trx_headers_all
2034: WHERE
2035: var_rent_id = p_var_rent_id AND
2036: period_id = p_period_id);
2037:

Line 2039: pn_var_trx_headers_all

2035: var_rent_id = p_var_rent_id AND
2036: period_id = p_period_id);
2037:
2038: DELETE
2039: pn_var_trx_headers_all
2040: WHERE
2041: var_rent_id = p_var_rent_id AND
2042: period_id = p_period_id;
2043:

Line 2056: pn_var_trx_headers_all

2052: trx_header_id IN
2053: ( SELECT
2054: trx_header_id
2055: FROM
2056: pn_var_trx_headers_all
2057: WHERE
2058: var_rent_id = p_var_rent_id);
2059:
2060: DELETE

Line 2061: pn_var_trx_headers_all

2057: WHERE
2058: var_rent_id = p_var_rent_id);
2059:
2060: DELETE
2061: pn_var_trx_headers_all
2062: WHERE
2063: var_rent_id = p_var_rent_id;
2064:
2065: END IF;

Line 2113: pn_var_trx_headers_all

2109: CURSOR chk_for_del_prd_c(p_vr_id IN NUMBER) IS
2110: SELECT
2111: period_id
2112: FROM
2113: pn_var_trx_headers_all
2114: WHERE
2115: var_rent_id = p_vr_id
2116: MINUS
2117: SELECT

Line 2146: pn_var_trx_headers_all

2142: ,p_prd_id IN NUMBER) IS
2143: SELECT
2144: line_item_id
2145: FROM
2146: pn_var_trx_headers_all
2147: WHERE
2148: var_rent_id = p_vr_id AND
2149: period_id = p_prd_id
2150: MINUS

Line 2164: FROM pn_var_trx_headers_all

2160: CURSOR for_data_c(ip_vr_id IN NUMBER,
2161: ip_prd_id IN NUMBER
2162: ) IS
2163: SELECT *
2164: FROM pn_var_trx_headers_all
2165: WHERE var_rent_id = ip_vr_id
2166: AND period_id = ip_prd_id;
2167:
2168: TYPE for_data IS TABLE OF pn_var_trx_headers_all%ROWTYPE INDEX BY BINARY_INTEGER;

Line 2168: TYPE for_data IS TABLE OF pn_var_trx_headers_all%ROWTYPE INDEX BY BINARY_INTEGER;

2164: FROM pn_var_trx_headers_all
2165: WHERE var_rent_id = ip_vr_id
2166: AND period_id = ip_prd_id;
2167:
2168: TYPE for_data IS TABLE OF pn_var_trx_headers_all%ROWTYPE INDEX BY BINARY_INTEGER;
2169: for_data_t for_data;
2170:
2171:
2172: /* get all groups for a period */

Line 2278: pn_var_trx_headers_all hdr

2274: ,dtls.bkpt_rate
2275: ,hdr.reset_group_id
2276: ,hdr.trueup_rent_due
2277: FROM
2278: pn_var_trx_headers_all hdr
2279: ,pn_var_trx_details_all dtls
2280: WHERE
2281: hdr.trx_header_id = dtls.trx_header_id AND
2282: hdr.var_rent_id = p_var_rent_id

Line 2392: DELETE FROM pn_var_trx_headers_all

2388:
2389: /* delete trx records for a contracted period */
2390: BEGIN
2391:
2392: DELETE FROM pn_var_trx_headers_all
2393: WHERE
2394: var_rent_id = p_var_rent_id AND
2395: calc_prd_end_date > l_vr_termination_date;
2396:

Line 2756: pn_var_trx_headers_all

2752: pnp_debug_pkg.log('REPORTING_GROUP_SALES_FOR:'||for_data_t(i).REPORTING_GROUP_SALES_FOR);
2753: pnp_debug_pkg.log('CALCULATED_RENT_FOR:'||for_data_t(i).CALCULATED_RENT_FOR);
2754:
2755: UPDATE
2756: pn_var_trx_headers_all
2757: SET
2758: REPORTING_GROUP_SALES_FOR = for_data_t(i).REPORTING_GROUP_SALES_FOR
2759: ,PRORATED_GROUP_SALES_FOR = for_data_t(i).PRORATED_GROUP_SALES_FOR
2760: ,YTD_SALES_FOR = for_data_t(i).YTD_SALES_FOR

Line 2845: pn_var_trx_headers_all

2841: FOR i IN 1..trueup_table.COUNT LOOP
2842: IF periods_table(j).end_date = l_max_end_date THEN
2843: /* Added var_rent_id filter to improve the performance */
2844: UPDATE
2845: pn_var_trx_headers_all
2846: SET
2847: trueup_rent_due = round(trueup_table(i).trueup_rent_due,g_precision) /*Bug # 6031202*/
2848: WHERE
2849: var_rent_id = p_var_rent_id AND

Line 3237: pn_var_trx_headers_all

3233: END LOOP;
3234:
3235: /* init ly_proration_sales */
3236: UPDATE
3237: pn_var_trx_headers_all
3238: SET
3239: ly_proration_sales = NULL
3240: WHERE
3241: var_rent_id = p_var_rent_id;

Line 3247: pn_var_trx_headers_all hdr

3243: IF l_partial_period = 'Y' THEN
3244:
3245: /* populate ly_proration_sales */
3246: UPDATE
3247: pn_var_trx_headers_all hdr
3248: SET
3249: hdr.ly_proration_sales = hdr.prorated_group_sales
3250: WHERE
3251: hdr.var_rent_id = p_var_rent_id AND

Line 3257: pn_var_trx_headers_all

3253:
3254: /* populate ly_proration_sales if LY start date does not
3255: coincide with a calc prd start date */
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

Line 3360: pn_var_trx_headers_all

3356: END LOOP;
3357:
3358: /* init ly_proration_sales */
3359: UPDATE
3360: pn_var_trx_headers_all
3361: SET
3362: fy_proration_sales = NULL
3363: WHERE
3364: var_rent_id = p_var_rent_id;

Line 3369: pn_var_trx_headers_all hdr

3365:
3366: IF l_partial_period = 'Y' THEN
3367: /* populate ly_proration_sales */
3368: UPDATE
3369: pn_var_trx_headers_all hdr
3370: SET
3371: hdr.fy_proration_sales = hdr.prorated_group_sales
3372: WHERE
3373: hdr.var_rent_id = p_var_rent_id AND

Line 3379: pn_var_trx_headers_all

3375:
3376: /* populate fy_proration_sales if FY end date does not
3377: coincide with a calc prd end date */
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

Line 3498: pn_var_trx_headers_all hdr

3494: ORDER BY
3495: hdr.calc_prd_start_date
3496: ROWS UNBOUNDED PRECEDING) AS ytd_sales
3497: FROM
3498: pn_var_trx_headers_all hdr
3499: WHERE
3500: hdr.var_rent_id = p_vr_id AND
3501: hdr.period_id = p_prd_ID AND
3502: hdr.line_item_id = p_line_ID

Line 3521: pn_var_trx_headers_all hdr

3517: ORDER BY
3518: hdr.calc_prd_start_date
3519: ROWS UNBOUNDED PRECEDING) AS ytd_sales
3520: FROM
3521: pn_var_trx_headers_all hdr
3522: WHERE
3523: hdr.var_rent_id = p_vr_id AND
3524: hdr.period_id IN (p_part_prd_id, p_full_prd_id)
3525: ORDER BY

Line 3583: pn_var_trx_headers_all

3579: CLOSE ytd_sales_c;
3580:
3581: FORALL i IN 1..trx_hdr_t.COUNT
3582: UPDATE
3583: pn_var_trx_headers_all
3584: SET
3585: ytd_sales = ytd_sales_t(i)
3586: WHERE
3587: trx_header_id = trx_hdr_t(i);

Line 3634: pn_var_trx_headers_all

3630: CLOSE ytd_sales_cs_c;
3631:
3632: FORALL i IN 1..trx_hdr_t.COUNT
3633: UPDATE
3634: pn_var_trx_headers_all
3635: SET
3636: ytd_sales = ytd_sales_t(i)
3637: WHERE
3638: trx_header_id = trx_hdr_t(i);

Line 3661: pn_var_trx_headers_all

3657: CLOSE ytd_sales_c;
3658:
3659: FORALL i IN 1..trx_hdr_t.COUNT
3660: UPDATE
3661: pn_var_trx_headers_all
3662: SET
3663: ytd_sales = ytd_sales_t(i)
3664: WHERE
3665: trx_header_id = trx_hdr_t(i);

Line 3736: pn_var_trx_headers_all hdr

3732: ,hdr.grp_date_id
3733: ,hdr.calc_prd_start_date
3734: ,hdr.calc_prd_end_date
3735: FROM
3736: pn_var_trx_headers_all hdr
3737: WHERE
3738: hdr.var_rent_id = p_vr_id AND
3739: hdr.period_id = p_prd_id AND
3740: hdr.line_item_id = p_line_id

Line 3821: pn_var_trx_headers_all

3817: IF trx_hdr_t.COUNT > 0 THEN
3818:
3819: FORALL i IN trx_hdr_t.FIRST..trx_hdr_t.LAST
3820: UPDATE
3821: pn_var_trx_headers_all
3822: SET
3823: reporting_group_sales = reporting_grp_sales_t(i)
3824: ,prorated_group_sales = prorate_grp_sales_t(i)
3825: WHERE

Line 4223: pn_var_trx_headers_all hdr

4219: ORDER BY
4220: hdr.calc_prd_start_date
4221: ROWS UNBOUNDED PRECEDING) AS ytd_sales_for
4222: FROM
4223: pn_var_trx_headers_all hdr
4224: WHERE
4225: hdr.var_rent_id = p_vr_id AND
4226: hdr.period_id = p_prd_ID AND
4227: hdr.line_item_id = p_line_ID

Line 4271: pn_var_trx_headers_all

4267: CLOSE ytd_sales_c;
4268:
4269: FORALL i IN 1..trx_hdr_t.COUNT
4270: UPDATE
4271: pn_var_trx_headers_all
4272: SET
4273: ytd_sales_for = ytd_sales_for_t(i)
4274: WHERE
4275: trx_header_id = trx_hdr_t(i);

Line 4346: pn_var_trx_headers_all hdr

4342: ,hdr.grp_date_id
4343: ,hdr.calc_prd_start_date
4344: ,hdr.calc_prd_end_date
4345: FROM
4346: pn_var_trx_headers_all hdr
4347: WHERE
4348: hdr.var_rent_id = p_vr_id AND
4349: hdr.period_id = p_prd_id AND
4350: hdr.line_item_id = p_line_id

Line 4431: pn_var_trx_headers_all

4427: IF trx_hdr_t.COUNT > 0 THEN
4428:
4429: FORALL i IN trx_hdr_t.FIRST..trx_hdr_t.LAST
4430: UPDATE
4431: pn_var_trx_headers_all
4432: SET
4433: reporting_group_sales_for = reporting_grp_sales_t(i)
4434: ,prorated_group_sales_for = prorate_grp_sales_t(i)
4435: WHERE

Line 4797: pn_var_trx_headers_all

4793: ,pn_var_trx_pkg.G_PRORUL_FLY) THEN
4794:
4795: /* init ly_proration_sales */
4796: UPDATE
4797: pn_var_trx_headers_all
4798: SET
4799: ly_proration_deductions = NULL
4800: WHERE
4801: var_rent_id = p_var_rent_id;

Line 4805: pn_var_trx_headers_all hdr

4801: var_rent_id = p_var_rent_id;
4802:
4803: /* populate ly_proration_sales */
4804: UPDATE
4805: pn_var_trx_headers_all hdr
4806: SET
4807: hdr.ly_proration_deductions = hdr.prorated_group_deductions
4808: WHERE
4809: hdr.var_rent_id = p_var_rent_id AND

Line 4815: pn_var_trx_headers_all

4811:
4812: /* populate ly_proration_sales if LY start date does not
4813: coincide with a calc prd start date */
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

Line 4895: pn_var_trx_headers_all

4891: ,pn_var_trx_pkg.G_PRORUL_FLY) THEN
4892:
4893: /* init ly_proration_deductions */
4894: UPDATE
4895: pn_var_trx_headers_all
4896: SET
4897: fy_proration_deductions = NULL
4898: WHERE
4899: var_rent_id = p_var_rent_id;

Line 4903: pn_var_trx_headers_all hdr

4899: var_rent_id = p_var_rent_id;
4900:
4901: /* populate ly_proration_deductions */
4902: UPDATE
4903: pn_var_trx_headers_all hdr
4904: SET
4905: hdr.fy_proration_deductions = hdr.prorated_group_deductions
4906: WHERE
4907: hdr.var_rent_id = p_var_rent_id AND

Line 4913: pn_var_trx_headers_all

4909:
4910: /* populate fy_proration_deductions if FY end date does not
4911: coincide with a calc prd end date */
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

Line 5029: pn_var_trx_headers_all hdr

5025: ORDER BY
5026: hdr.calc_prd_start_date
5027: ROWS UNBOUNDED PRECEDING) AS ytd_deductions
5028: FROM
5029: pn_var_trx_headers_all hdr
5030: WHERE
5031: hdr.var_rent_id = p_vr_id AND
5032: hdr.period_id = p_prd_ID AND
5033: hdr.line_item_id = p_line_ID

Line 5052: pn_var_trx_headers_all hdr

5048: ORDER BY
5049: hdr.calc_prd_start_date
5050: ROWS UNBOUNDED PRECEDING) AS ytd_deductions
5051: FROM
5052: pn_var_trx_headers_all hdr
5053: WHERE
5054: hdr.var_rent_id = p_vr_id AND
5055: hdr.period_id IN (p_part_prd_id, p_full_prd_id)
5056: ORDER BY

Line 5114: pn_var_trx_headers_all

5110: CLOSE ytd_deductions_c;
5111:
5112: FORALL i IN 1..trx_hdr_t.COUNT
5113: UPDATE
5114: pn_var_trx_headers_all
5115: SET
5116: ytd_deductions = ytd_deductions_t(i)
5117: WHERE
5118: trx_header_id = trx_hdr_t(i);

Line 5165: pn_var_trx_headers_all

5161: CLOSE ytd_deductions_cs_c;
5162:
5163: FORALL i IN 1..trx_hdr_t.COUNT
5164: UPDATE
5165: pn_var_trx_headers_all
5166: SET
5167: ytd_deductions = ytd_deductions_t(i)
5168: WHERE
5169: trx_header_id = trx_hdr_t(i);

Line 5192: pn_var_trx_headers_all

5188: CLOSE ytd_deductions_c;
5189:
5190: FORALL i IN 1..trx_hdr_t.COUNT
5191: UPDATE
5192: pn_var_trx_headers_all
5193: SET
5194: ytd_deductions = ytd_deductions_t(i)
5195: WHERE
5196: trx_header_id = trx_hdr_t(i);

Line 5266: pn_var_trx_headers_all hdr

5262: ,hdr.grp_date_id
5263: ,hdr.calc_prd_start_date
5264: ,hdr.calc_prd_end_date
5265: FROM
5266: pn_var_trx_headers_all hdr
5267: WHERE
5268: hdr.var_rent_id = p_vr_id AND
5269: hdr.period_id = p_prd_id AND
5270: hdr.line_item_id = p_line_id

Line 5342: pn_var_trx_headers_all

5338: IF trx_hdr_t.COUNT > 0 THEN
5339:
5340: FORALL i IN trx_hdr_t.FIRST..trx_hdr_t.LAST
5341: UPDATE
5342: pn_var_trx_headers_all
5343: SET
5344: reporting_group_deductions = reporting_grp_dedc_t(i)
5345: ,prorated_group_deductions = prorate_grp_dedc_t(i)
5346: WHERE