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_DETAILS_ALL

Line 179: pn_var_trx_details_all

175: CURSOR trx_detail_exists_c IS
176: SELECT
177: trx_detail_id
178: FROM
179: pn_var_trx_details_all
180: WHERE
181: trx_header_id = p_trx_hdr_id AND
182: bkpt_detail_id = p_bkpt_dtl_id;
183:

Line 342: INSERT INTO pn_var_trx_details_all

338: ,p_last_update_login IN NUMBER) IS
339:
340: BEGIN
341:
342: INSERT INTO pn_var_trx_details_all
343: (trx_detail_id
344: ,trx_header_id
345: ,bkpt_detail_id
346: ,bkpt_rate

Line 523: pn_var_trx_details_all

519: CURSOR bkpt_rates_c(p_trx_hrd_id IN NUMBER) IS
520: SELECT
521: bkpt_rate
522: FROM
523: pn_var_trx_details_all
524: WHERE
525: trx_header_id = p_trx_hrd_id
526: ORDER BY
527: prorated_grp_vol_start;

Line 760: pn_var_trx_details_all

756: /* -- POPULATE ly_pr_grp_vol_start - ly_pr_grp_vol_end - START -- */
757:
758: /* init ly_pr_grp_vol_start - ly_pr_grp_vol_end */
759: UPDATE
760: pn_var_trx_details_all
761: SET
762: ly_pr_grp_vol_start = NULL
763: ,ly_pr_grp_vol_end = NULL
764: WHERE

Line 776: pn_var_trx_details_all

772: IF l_partial_period = 'Y' THEN
773:
774: /* populate ly_pr_grp_vol_start - ly_pr_grp_vol_end */
775: UPDATE
776: pn_var_trx_details_all
777: SET
778: ly_pr_grp_vol_start = prorated_grp_vol_start
779: ,ly_pr_grp_vol_end = prorated_grp_vol_end
780: WHERE

Line 798: pn_var_trx_details_all

794: := ((trx_rec.calc_prd_end_date - l_ly_start_date) + 1)
795: / ((trx_rec.calc_prd_end_date - trx_rec.calc_prd_start_date) + 1);
796:
797: UPDATE
798: pn_var_trx_details_all
799: SET
800: ly_pr_grp_vol_start = prorated_grp_vol_start * l_proration_factor
801: ,ly_pr_grp_vol_end = prorated_grp_vol_end * l_proration_factor
802: WHERE

Line 955: pn_var_trx_details_all

951: END IF;
952:
953: /* init fy_pr_grp_vol_start - fy_pr_grp_vol_end */
954: UPDATE
955: pn_var_trx_details_all
956: SET
957: fy_pr_grp_vol_start = NULL
958: ,fy_pr_grp_vol_end = NULL
959: WHERE

Line 970: pn_var_trx_details_all

966:
967: IF l_partial_period = 'Y' THEN
968: /* populate fy_pr_grp_vol_start - fy_pr_grp_vol_end */
969: UPDATE
970: pn_var_trx_details_all
971: SET
972: fy_pr_grp_vol_start = prorated_grp_vol_start
973: ,fy_pr_grp_vol_end = prorated_grp_vol_end
974: WHERE

Line 994: pn_var_trx_details_all

990: / ((trx_rec.calc_prd_end_date - trx_rec.calc_prd_start_date) + 1);
991:
992: /* populate fy_pr_grp_vol_start - fy_pr_grp_vol_end */
993: UPDATE
994: pn_var_trx_details_all
995: SET
996: fy_pr_grp_vol_start = prorated_grp_vol_start * l_proration_factor
997: ,fy_pr_grp_vol_end = prorated_grp_vol_end * l_proration_factor
998: WHERE

Line 1109: ,pn_var_trx_details_all dtl

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
1113: dtl.trx_header_id = hdr.trx_header_id

Line 1259: pn_var_trx_details_all

1255:
1256: l_context := 'CYP - update pr_grp_blended_vol_start - end';
1257: /* reset pr_grp_blended_vol_start - pr_grp_blended_vol_end */
1258: UPDATE
1259: pn_var_trx_details_all
1260: SET
1261: pr_grp_blended_vol_start = NULL
1262: ,pr_grp_blended_vol_end = NULL
1263: WHERE

Line 1273: pn_var_trx_details_all

1269: var_rent_id = p_var_rent_id);
1270:
1271: /* populate pr_grp_blended_vol_start - pr_grp_blended_vol_end */
1272: UPDATE
1273: pn_var_trx_details_all
1274: SET
1275: pr_grp_blended_vol_start = prorated_grp_vol_start
1276: ,pr_grp_blended_vol_end = prorated_grp_vol_end
1277: WHERE

Line 1299: pn_var_trx_details_all

1295: ,p_full_prd_ID => l_full_prd_id)
1296: LOOP
1297:
1298: UPDATE
1299: pn_var_trx_details_all
1300: SET
1301: blended_period_vol_start = cyp_rec.blended_period_vol_start
1302: ,blended_period_vol_end = cyp_rec.blended_period_vol_end
1303: WHERE

Line 1355: pn_var_trx_details_all

1351: l_context
1352: := 'CYNP - update pr_grp_blended_vol_start - end, blended_period_vol_start - end';
1353: /* reset pr_grp_blended_vol_start - pr_grp_blended_vol_end */
1354: UPDATE
1355: pn_var_trx_details_all
1356: SET
1357: pr_grp_blended_vol_start = NULL
1358: ,pr_grp_blended_vol_end = NULL
1359: WHERE

Line 1373: pn_var_trx_details_all

1369: ,p_full_prd_ID => l_full_prd_id)
1370: LOOP
1371:
1372: UPDATE
1373: pn_var_trx_details_all
1374: SET
1375: blended_period_vol_start
1376: = (cynp_rec.blended_period_vol_start / (l_part_prd_length + l_full_prd_length))
1377: * l_full_prd_length

Line 1414: pn_var_trx_details_all

1410: ,p_prd_st_dt => l_part_prd_start_dt)
1411: LOOP
1412:
1413: UPDATE
1414: pn_var_trx_details_all
1415: SET
1416: pr_grp_blended_vol_start
1417: = pr_grp_blended_vol_start
1418: * first_part_rec.grp_prorat_factor

Line 1436: pn_var_trx_details_all

1432: ,p_prd_end_dt => l_full_prd_end_dt)
1433: LOOP
1434:
1435: UPDATE
1436: pn_var_trx_details_all
1437: SET
1438: pr_grp_blended_vol_start
1439: = pr_grp_blended_vol_start
1440: * last_part_rec.grp_prorat_factor

Line 1589: ,pn_var_trx_details_all dtl

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
1593: hdr.var_rent_id = p_vr_id AND

Line 1633: ,pn_var_trx_details_all dtl

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
1637: hdr.line_item_id = p_line_ID AND

Line 1667: ,pn_var_trx_details_all dtl

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
1671: dtl.trx_header_id = hdr.trx_header_id

Line 1760: pn_var_trx_details_all

1756:
1757:
1758: FORALL i IN 1..trx_detail_t.COUNT
1759: UPDATE
1760: pn_var_trx_details_all
1761: SET
1762: ytd_group_vol_start = ytd_grp_vol_start_t(i)
1763: ,ytd_group_vol_end = ytd_grp_vol_end_t(i)
1764: WHERE

Line 1813: pn_var_trx_details_all

1809: CLOSE ytd_group_vol_cs_c;
1810:
1811: FORALL i IN 1..trx_detail_t.COUNT
1812: UPDATE
1813: pn_var_trx_details_all
1814: SET
1815: ytd_group_vol_start = ytd_grp_vol_start_t(i)
1816: ,ytd_group_vol_end = ytd_grp_vol_end_t(i)
1817: WHERE

Line 1841: pn_var_trx_details_all

1837: CLOSE ytd_group_vol_c;
1838:
1839: FORALL i IN 1..trx_detail_t.COUNT
1840: UPDATE
1841: pn_var_trx_details_all
1842: SET
1843: ytd_group_vol_start = ytd_grp_vol_start_t(i)
1844: ,ytd_group_vol_end = ytd_grp_vol_end_t(i)
1845: WHERE

Line 1923: ,pn_var_trx_details_all dtl

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
1927: hdr.line_item_id IN (SELECT

Line 2033: pn_var_trx_details_all

2029: FOR rec IN blended_prd_vol_c( p_vr_id => p_var_rent_id
2030: ,p_prd_id => l_period_t(prd_rec)) LOOP
2031:
2032: UPDATE
2033: pn_var_trx_details_all
2034: SET
2035: blended_period_vol_start = rec.blended_period_vol_start
2036: ,blended_period_vol_end = rec.blended_period_vol_end
2037: WHERE

Line 2091: pn_var_trx_details_all

2087: p_var_rent_id IS NOT NULL
2088: THEN
2089: pnp_debug_pkg.log('Deleting for lines');
2090: DELETE
2091: pn_var_trx_details_all
2092: WHERE
2093: trx_header_id IN
2094: ( SELECT
2095: trx_header_id

Line 2116: pn_var_trx_details_all

2112: p_var_rent_id IS NOT NULL
2113: THEN
2114: pnp_debug_pkg.log('Deleting for periods');
2115: DELETE
2116: pn_var_trx_details_all
2117: WHERE
2118: trx_header_id IN
2119: ( SELECT
2120: trx_header_id

Line 2139: pn_var_trx_details_all

2135: p_var_rent_id IS NOT NULL
2136: THEN
2137: pnp_debug_pkg.log('Deleting for VR');
2138: DELETE
2139: pn_var_trx_details_all
2140: WHERE
2141: trx_header_id IN
2142: ( SELECT
2143: trx_header_id

Line 2368: ,pn_var_trx_details_all dtls

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
2372: ORDER BY