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 1584: ,pn_var_trx_details_all dtl

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

Line 1617: ,pn_var_trx_details_all dtl

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

Line 1674: pn_var_trx_details_all

1670: CLOSE ytd_group_vol_c;
1671:
1672: FORALL i IN 1..trx_detail_t.COUNT
1673: UPDATE
1674: pn_var_trx_details_all
1675: SET
1676: ytd_group_vol_start = ytd_grp_vol_start_t(i)
1677: ,ytd_group_vol_end = ytd_grp_vol_end_t(i)
1678: WHERE

Line 1727: pn_var_trx_details_all

1723: CLOSE ytd_group_vol_cs_c;
1724:
1725: FORALL i IN 1..trx_detail_t.COUNT
1726: UPDATE
1727: pn_var_trx_details_all
1728: SET
1729: ytd_group_vol_start = ytd_grp_vol_start_t(i)
1730: ,ytd_group_vol_end = ytd_grp_vol_end_t(i)
1731: WHERE

Line 1755: pn_var_trx_details_all

1751: CLOSE ytd_group_vol_c;
1752:
1753: FORALL i IN 1..trx_detail_t.COUNT
1754: UPDATE
1755: pn_var_trx_details_all
1756: SET
1757: ytd_group_vol_start = ytd_grp_vol_start_t(i)
1758: ,ytd_group_vol_end = ytd_grp_vol_end_t(i)
1759: WHERE

Line 1836: ,pn_var_trx_details_all dtl

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

Line 1945: pn_var_trx_details_all

1941: FOR rec IN blended_prd_vol_c( p_vr_id => p_var_rent_id
1942: ,p_prd_id => l_period_t(prd_rec)) LOOP
1943:
1944: UPDATE
1945: pn_var_trx_details_all
1946: SET
1947: blended_period_vol_start = rec.blended_period_vol_start
1948: ,blended_period_vol_end = rec.blended_period_vol_end
1949: WHERE

Line 2002: pn_var_trx_details_all

1998: p_var_rent_id IS NOT NULL
1999: THEN
2000: pnp_debug_pkg.log('Deleting for lines');
2001: DELETE
2002: pn_var_trx_details_all
2003: WHERE
2004: trx_header_id IN
2005: ( SELECT
2006: trx_header_id

Line 2027: pn_var_trx_details_all

2023: p_var_rent_id IS NOT NULL
2024: THEN
2025: pnp_debug_pkg.log('Deleting for periods');
2026: DELETE
2027: pn_var_trx_details_all
2028: WHERE
2029: trx_header_id IN
2030: ( SELECT
2031: trx_header_id

Line 2050: pn_var_trx_details_all

2046: p_var_rent_id IS NOT NULL
2047: THEN
2048: pnp_debug_pkg.log('Deleting for VR');
2049: DELETE
2050: pn_var_trx_details_all
2051: WHERE
2052: trx_header_id IN
2053: ( SELECT
2054: trx_header_id

Line 2279: ,pn_var_trx_details_all dtls

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