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 1588: pn_var_trx_headers_all hdr

1584: ORDER BY
1585: hdr.calc_prd_start_date
1586: ROWS UNBOUNDED PRECEDING) AS ytd_group_vol_end
1587: FROM
1588: pn_var_trx_headers_all hdr
1589: ,pn_var_trx_details_all dtl
1590: ,PN_VAR_BKPTS_DET_ALL pbd
1591: ,pn_var_bkpts_head_all pbh
1592: WHERE

Line 1632: pn_var_trx_headers_all hdr

1628: ORDER BY
1629: hdr.calc_prd_start_date
1630: ROWS UNBOUNDED PRECEDING) AS ytd_group_vol_end
1631: FROM
1632: pn_var_trx_headers_all hdr
1633: ,pn_var_trx_details_all dtl
1634: WHERE
1635: hdr.var_rent_id = p_vr_id AND
1636: hdr.period_id = p_prd_ID AND

Line 1666: pn_var_trx_headers_all hdr

1662: ORDER BY
1663: hdr.calc_prd_start_date
1664: ROWS UNBOUNDED PRECEDING) AS ytd_group_vol_end
1665: FROM
1666: pn_var_trx_headers_all hdr
1667: ,pn_var_trx_details_all dtl
1668: WHERE
1669: hdr.var_rent_id = p_vr_id AND
1670: hdr.period_id IN (p_part_prd_id, p_full_prd_id) AND

Line 1922: pn_var_trx_headers_all hdr

1918: ,dtl.bkpt_detail_id
1919: ,SUM(prorated_grp_vol_start) AS blended_period_vol_start
1920: ,SUM(prorated_grp_vol_end) AS blended_period_vol_end
1921: FROM
1922: pn_var_trx_headers_all hdr
1923: ,pn_var_trx_details_all dtl
1924: WHERE
1925: hdr.var_rent_id = p_vr_id AND
1926: hdr.period_id = p_prd_id AND

Line 2042: pn_var_trx_headers_all

2038: trx_header_id IN
2039: (SELECT
2040: trx_header_id
2041: FROM
2042: pn_var_trx_headers_all
2043: WHERE
2044: var_rent_id = p_var_rent_id AND
2045: period_id = rec.period_id AND
2046: line_item_id = rec.line_item_id AND

Line 2097: pn_var_trx_headers_all

2093: trx_header_id IN
2094: ( SELECT
2095: trx_header_id
2096: FROM
2097: pn_var_trx_headers_all
2098: WHERE
2099: var_rent_id = p_var_rent_id AND
2100: period_id = p_period_id AND
2101: line_item_id = p_line_item_id );

Line 2104: pn_var_trx_headers_all

2100: period_id = p_period_id AND
2101: line_item_id = p_line_item_id );
2102:
2103: DELETE
2104: pn_var_trx_headers_all
2105: WHERE
2106: var_rent_id = p_var_rent_id AND
2107: period_id = p_period_id AND
2108: line_item_id = p_line_item_id;

Line 2122: pn_var_trx_headers_all

2118: trx_header_id IN
2119: ( SELECT
2120: trx_header_id
2121: FROM
2122: pn_var_trx_headers_all
2123: WHERE
2124: var_rent_id = p_var_rent_id AND
2125: period_id = p_period_id);
2126:

Line 2128: pn_var_trx_headers_all

2124: var_rent_id = p_var_rent_id AND
2125: period_id = p_period_id);
2126:
2127: DELETE
2128: pn_var_trx_headers_all
2129: WHERE
2130: var_rent_id = p_var_rent_id AND
2131: period_id = p_period_id;
2132:

Line 2145: pn_var_trx_headers_all

2141: trx_header_id IN
2142: ( SELECT
2143: trx_header_id
2144: FROM
2145: pn_var_trx_headers_all
2146: WHERE
2147: var_rent_id = p_var_rent_id);
2148:
2149: DELETE

Line 2150: pn_var_trx_headers_all

2146: WHERE
2147: var_rent_id = p_var_rent_id);
2148:
2149: DELETE
2150: pn_var_trx_headers_all
2151: WHERE
2152: var_rent_id = p_var_rent_id;
2153:
2154: END IF;

Line 2202: pn_var_trx_headers_all

2198: CURSOR chk_for_del_prd_c(p_vr_id IN NUMBER) IS
2199: SELECT
2200: period_id
2201: FROM
2202: pn_var_trx_headers_all
2203: WHERE
2204: var_rent_id = p_vr_id
2205: MINUS
2206: SELECT

Line 2235: pn_var_trx_headers_all

2231: ,p_prd_id IN NUMBER) IS
2232: SELECT
2233: line_item_id
2234: FROM
2235: pn_var_trx_headers_all
2236: WHERE
2237: var_rent_id = p_vr_id AND
2238: period_id = p_prd_id
2239: MINUS

Line 2253: FROM pn_var_trx_headers_all

2249: CURSOR for_data_c(ip_vr_id IN NUMBER,
2250: ip_prd_id IN NUMBER
2251: ) IS
2252: SELECT *
2253: FROM pn_var_trx_headers_all
2254: WHERE var_rent_id = ip_vr_id
2255: AND period_id = ip_prd_id;
2256:
2257: TYPE for_data IS TABLE OF pn_var_trx_headers_all%ROWTYPE INDEX BY BINARY_INTEGER;

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

2253: FROM pn_var_trx_headers_all
2254: WHERE var_rent_id = ip_vr_id
2255: AND period_id = ip_prd_id;
2256:
2257: TYPE for_data IS TABLE OF pn_var_trx_headers_all%ROWTYPE INDEX BY BINARY_INTEGER;
2258: for_data_t for_data;
2259:
2260:
2261: /* get all groups for a period */

Line 2367: pn_var_trx_headers_all hdr

2363: ,dtls.bkpt_rate
2364: ,hdr.reset_group_id
2365: ,hdr.trueup_rent_due
2366: FROM
2367: pn_var_trx_headers_all hdr
2368: ,pn_var_trx_details_all dtls
2369: WHERE
2370: hdr.trx_header_id = dtls.trx_header_id AND
2371: hdr.var_rent_id = p_var_rent_id

Line 2481: DELETE FROM pn_var_trx_headers_all

2477:
2478: /* delete trx records for a contracted period */
2479: BEGIN
2480:
2481: DELETE FROM pn_var_trx_headers_all
2482: WHERE
2483: var_rent_id = p_var_rent_id AND
2484: calc_prd_end_date > l_vr_termination_date;
2485:

Line 2845: pn_var_trx_headers_all

2841: pnp_debug_pkg.log('REPORTING_GROUP_SALES_FOR:'||for_data_t(i).REPORTING_GROUP_SALES_FOR);
2842: pnp_debug_pkg.log('CALCULATED_RENT_FOR:'||for_data_t(i).CALCULATED_RENT_FOR);
2843:
2844: UPDATE
2845: pn_var_trx_headers_all
2846: SET
2847: REPORTING_GROUP_SALES_FOR = for_data_t(i).REPORTING_GROUP_SALES_FOR
2848: ,PRORATED_GROUP_SALES_FOR = for_data_t(i).PRORATED_GROUP_SALES_FOR
2849: ,YTD_SALES_FOR = for_data_t(i).YTD_SALES_FOR

Line 2935: pn_var_trx_headers_all

2931: FOR i IN 1..trueup_table.COUNT LOOP
2932: IF periods_table(j).end_date = l_max_end_date THEN
2933: /* Added var_rent_id filter to improve the performance */
2934: UPDATE
2935: pn_var_trx_headers_all
2936: SET
2937: trueup_rent_due = round(trueup_table(i).trueup_rent_due,g_precision) /*Bug # 6031202*/
2938: WHERE
2939: var_rent_id = p_var_rent_id AND

Line 3327: pn_var_trx_headers_all

3323: END LOOP;
3324:
3325: /* init ly_proration_sales */
3326: UPDATE
3327: pn_var_trx_headers_all
3328: SET
3329: ly_proration_sales = NULL
3330: WHERE
3331: var_rent_id = p_var_rent_id;

Line 3337: pn_var_trx_headers_all hdr

3333: IF l_partial_period = 'Y' THEN
3334:
3335: /* populate ly_proration_sales */
3336: UPDATE
3337: pn_var_trx_headers_all hdr
3338: SET
3339: hdr.ly_proration_sales = hdr.prorated_group_sales
3340: WHERE
3341: hdr.var_rent_id = p_var_rent_id AND

Line 3347: pn_var_trx_headers_all

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

Line 3450: pn_var_trx_headers_all

3446: END LOOP;
3447:
3448: /* init ly_proration_sales */
3449: UPDATE
3450: pn_var_trx_headers_all
3451: SET
3452: fy_proration_sales = NULL
3453: WHERE
3454: var_rent_id = p_var_rent_id;

Line 3459: pn_var_trx_headers_all hdr

3455:
3456: IF l_partial_period = 'Y' THEN
3457: /* populate ly_proration_sales */
3458: UPDATE
3459: pn_var_trx_headers_all hdr
3460: SET
3461: hdr.fy_proration_sales = hdr.prorated_group_sales
3462: WHERE
3463: hdr.var_rent_id = p_var_rent_id AND

Line 3469: pn_var_trx_headers_all

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

Line 3588: pn_var_trx_headers_all hdr

3584: ORDER BY
3585: hdr.calc_prd_start_date
3586: ROWS UNBOUNDED PRECEDING) AS ytd_sales
3587: FROM
3588: pn_var_trx_headers_all hdr
3589: WHERE
3590: hdr.var_rent_id = p_vr_id AND
3591: hdr.period_id = p_prd_ID AND
3592: hdr.line_item_id = p_line_ID

Line 3611: pn_var_trx_headers_all hdr

3607: ORDER BY
3608: hdr.calc_prd_start_date
3609: ROWS UNBOUNDED PRECEDING) AS ytd_sales
3610: FROM
3611: pn_var_trx_headers_all hdr
3612: WHERE
3613: hdr.var_rent_id = p_vr_id AND
3614: hdr.period_id IN (p_part_prd_id, p_full_prd_id)
3615: ORDER BY

Line 3673: pn_var_trx_headers_all

3669: CLOSE ytd_sales_c;
3670:
3671: FORALL i IN 1..trx_hdr_t.COUNT
3672: UPDATE
3673: pn_var_trx_headers_all
3674: SET
3675: ytd_sales = ytd_sales_t(i)
3676: WHERE
3677: trx_header_id = trx_hdr_t(i);

Line 3724: pn_var_trx_headers_all

3720: CLOSE ytd_sales_cs_c;
3721:
3722: FORALL i IN 1..trx_hdr_t.COUNT
3723: UPDATE
3724: pn_var_trx_headers_all
3725: SET
3726: ytd_sales = ytd_sales_t(i)
3727: WHERE
3728: trx_header_id = trx_hdr_t(i);

Line 3751: pn_var_trx_headers_all

3747: CLOSE ytd_sales_c;
3748:
3749: FORALL i IN 1..trx_hdr_t.COUNT
3750: UPDATE
3751: pn_var_trx_headers_all
3752: SET
3753: ytd_sales = ytd_sales_t(i)
3754: WHERE
3755: trx_header_id = trx_hdr_t(i);

Line 3826: pn_var_trx_headers_all hdr

3822: ,hdr.grp_date_id
3823: ,hdr.calc_prd_start_date
3824: ,hdr.calc_prd_end_date
3825: FROM
3826: pn_var_trx_headers_all hdr
3827: WHERE
3828: hdr.var_rent_id = p_vr_id AND
3829: hdr.period_id = p_prd_id AND
3830: hdr.line_item_id = p_line_id

Line 3911: pn_var_trx_headers_all

3907: IF trx_hdr_t.COUNT > 0 THEN
3908:
3909: FORALL i IN trx_hdr_t.FIRST..trx_hdr_t.LAST
3910: UPDATE
3911: pn_var_trx_headers_all
3912: SET
3913: reporting_group_sales = reporting_grp_sales_t(i)
3914: ,prorated_group_sales = prorate_grp_sales_t(i)
3915: WHERE

Line 4313: pn_var_trx_headers_all hdr

4309: ORDER BY
4310: hdr.calc_prd_start_date
4311: ROWS UNBOUNDED PRECEDING) AS ytd_sales_for
4312: FROM
4313: pn_var_trx_headers_all hdr
4314: WHERE
4315: hdr.var_rent_id = p_vr_id AND
4316: hdr.period_id = p_prd_ID AND
4317: hdr.line_item_id = p_line_ID

Line 4361: pn_var_trx_headers_all

4357: CLOSE ytd_sales_c;
4358:
4359: FORALL i IN 1..trx_hdr_t.COUNT
4360: UPDATE
4361: pn_var_trx_headers_all
4362: SET
4363: ytd_sales_for = ytd_sales_for_t(i)
4364: WHERE
4365: trx_header_id = trx_hdr_t(i);

Line 4436: pn_var_trx_headers_all hdr

4432: ,hdr.grp_date_id
4433: ,hdr.calc_prd_start_date
4434: ,hdr.calc_prd_end_date
4435: FROM
4436: pn_var_trx_headers_all hdr
4437: WHERE
4438: hdr.var_rent_id = p_vr_id AND
4439: hdr.period_id = p_prd_id AND
4440: hdr.line_item_id = p_line_id

Line 4521: pn_var_trx_headers_all

4517: IF trx_hdr_t.COUNT > 0 THEN
4518:
4519: FORALL i IN trx_hdr_t.FIRST..trx_hdr_t.LAST
4520: UPDATE
4521: pn_var_trx_headers_all
4522: SET
4523: reporting_group_sales_for = reporting_grp_sales_t(i)
4524: ,prorated_group_sales_for = prorate_grp_sales_t(i)
4525: WHERE

Line 4887: pn_var_trx_headers_all

4883: ,pn_var_trx_pkg.G_PRORUL_FLY) THEN
4884:
4885: /* init ly_proration_sales */
4886: UPDATE
4887: pn_var_trx_headers_all
4888: SET
4889: ly_proration_deductions = NULL
4890: WHERE
4891: var_rent_id = p_var_rent_id;

Line 4895: pn_var_trx_headers_all hdr

4891: var_rent_id = p_var_rent_id;
4892:
4893: /* populate ly_proration_sales */
4894: UPDATE
4895: pn_var_trx_headers_all hdr
4896: SET
4897: hdr.ly_proration_deductions = hdr.prorated_group_deductions
4898: WHERE
4899: hdr.var_rent_id = p_var_rent_id AND

Line 4905: pn_var_trx_headers_all

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

Line 4985: pn_var_trx_headers_all

4981: ,pn_var_trx_pkg.G_PRORUL_FLY) THEN
4982:
4983: /* init ly_proration_deductions */
4984: UPDATE
4985: pn_var_trx_headers_all
4986: SET
4987: fy_proration_deductions = NULL
4988: WHERE
4989: var_rent_id = p_var_rent_id;

Line 4993: pn_var_trx_headers_all hdr

4989: var_rent_id = p_var_rent_id;
4990:
4991: /* populate ly_proration_deductions */
4992: UPDATE
4993: pn_var_trx_headers_all hdr
4994: SET
4995: hdr.fy_proration_deductions = hdr.prorated_group_deductions
4996: WHERE
4997: hdr.var_rent_id = p_var_rent_id AND

Line 5003: pn_var_trx_headers_all

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

Line 5119: pn_var_trx_headers_all hdr

5115: ORDER BY
5116: hdr.calc_prd_start_date
5117: ROWS UNBOUNDED PRECEDING) AS ytd_deductions
5118: FROM
5119: pn_var_trx_headers_all hdr
5120: WHERE
5121: hdr.var_rent_id = p_vr_id AND
5122: hdr.period_id = p_prd_ID AND
5123: hdr.line_item_id = p_line_ID

Line 5142: pn_var_trx_headers_all hdr

5138: ORDER BY
5139: hdr.calc_prd_start_date
5140: ROWS UNBOUNDED PRECEDING) AS ytd_deductions
5141: FROM
5142: pn_var_trx_headers_all hdr
5143: WHERE
5144: hdr.var_rent_id = p_vr_id AND
5145: hdr.period_id IN (p_part_prd_id, p_full_prd_id)
5146: ORDER BY

Line 5204: pn_var_trx_headers_all

5200: CLOSE ytd_deductions_c;
5201:
5202: FORALL i IN 1..trx_hdr_t.COUNT
5203: UPDATE
5204: pn_var_trx_headers_all
5205: SET
5206: ytd_deductions = ytd_deductions_t(i)
5207: WHERE
5208: trx_header_id = trx_hdr_t(i);

Line 5255: pn_var_trx_headers_all

5251: CLOSE ytd_deductions_cs_c;
5252:
5253: FORALL i IN 1..trx_hdr_t.COUNT
5254: UPDATE
5255: pn_var_trx_headers_all
5256: SET
5257: ytd_deductions = ytd_deductions_t(i)
5258: WHERE
5259: trx_header_id = trx_hdr_t(i);

Line 5282: pn_var_trx_headers_all

5278: CLOSE ytd_deductions_c;
5279:
5280: FORALL i IN 1..trx_hdr_t.COUNT
5281: UPDATE
5282: pn_var_trx_headers_all
5283: SET
5284: ytd_deductions = ytd_deductions_t(i)
5285: WHERE
5286: trx_header_id = trx_hdr_t(i);

Line 5356: pn_var_trx_headers_all hdr

5352: ,hdr.grp_date_id
5353: ,hdr.calc_prd_start_date
5354: ,hdr.calc_prd_end_date
5355: FROM
5356: pn_var_trx_headers_all hdr
5357: WHERE
5358: hdr.var_rent_id = p_vr_id AND
5359: hdr.period_id = p_prd_id AND
5360: hdr.line_item_id = p_line_id

Line 5432: pn_var_trx_headers_all

5428: IF trx_hdr_t.COUNT > 0 THEN
5429:
5430: FORALL i IN trx_hdr_t.FIRST..trx_hdr_t.LAST
5431: UPDATE
5432: pn_var_trx_headers_all
5433: SET
5434: reporting_group_deductions = reporting_grp_dedc_t(i)
5435: ,prorated_group_deductions = prorate_grp_dedc_t(i)
5436: WHERE