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_RENT_PKG dependencies on PN_VAR_GRP_DATES_ALL

Line 275: FROM pn_var_grp_dates_all

271: SELECT GRP_DATE_ID,
272: GRP_START_DATE,
273: GRP_END_DATE,
274: ORG_ID
275: FROM pn_var_grp_dates_all
276: WHERE var_rent_id = p_var_rent_id;
277:
278:
279: CURSOR get_dates_frequency IS

Line 369: -- values in pn_var_grp_dates_all

365:
366: /*============================================================================+
367: -- NAME : INSERT_REPORT_DATE_ROW
368: -- DESCRIPTION : create records in the pn_var_report_dates table based on
369: -- values in pn_var_grp_dates_all
370: -- PURPOSE :
371: -- INVOKED FROM :
372: -- ARGUMENTS : IN:
373: -- X_ROWID

Line 407: -- in pn_var_grp_dates_all

403: -- X_REPORT_DATE_ID
404: --
405: -- REFERENCE : PN_COMMON.debug()
406: -- NOTES : create records in the pn_var_report_dates table based on values
407: -- in pn_var_grp_dates_all
408: -- HISTORY :
409: --
410: -- 09-JAN-2006 Prabhakar o Created.
411: +=============================================================================*/

Line 666: FROM PN_VAR_GRP_DATES_ALL

662: ) IS
663:
664: CURSOR C IS
665: SELECT ROWID
666: FROM PN_VAR_GRP_DATES_ALL
667: WHERE GRP_DATE_ID = X_GRP_DATE_ID;
668:
669: CURSOR org_id_cur IS
670: SELECT org_id

Line 697: INSERT INTO PN_VAR_GRP_DATES_ALL

693: ELSE
694: l_org_id := X_ORG_ID;
695: END IF;
696:
697: INSERT INTO PN_VAR_GRP_DATES_ALL
698: (
699: GRP_DATE_ID,
700: LAST_UPDATE_DATE,
701: LAST_UPDATED_BY,

Line 797: DELETE FROM PN_VAR_GRP_DATES_ALL

793: pnp_debug_pkg.debug ('PN_VAR_RENT_PKG.DELETE_GRP_DATE_ROW (+)');
794:
795: l_date := NVL(x_term_date,(TO_DATE('01/01/1776','mm/dd/yyyy')));
796:
797: DELETE FROM PN_VAR_GRP_DATES_ALL
798: WHERE VAR_RENT_ID = X_VAR_RENT_ID
799: AND GRP_START_DATE > l_date
800: AND GRP_END_DATE > l_date;
801:

Line 1029: FROM pn_var_grp_dates_all

1025:
1026: /* Fetches the group id which starts on a specified date for a VR agreement */
1027: CURSOR group_cur (p_start_date DATE) IS
1028: SELECT grp_end_date, grp_date_id
1029: FROM pn_var_grp_dates_all
1030: WHERE var_rent_id = p_var_rent_id
1031: AND grp_start_date = p_start_date;
1032:
1033: /* Fetches the period id which starts on a specified date for a VR agreement */

Line 1043: FROM pn_var_grp_dates_all

1039:
1040: /* Fetches the group id in which a specified invoice date lies for a VR agreement */
1041: CURSOR invoice_cur(p_inv_start_date DATE, p_inv_end_date DATE, p_period_id NUMBER) IS
1042: SELECT inv_start_date, inv_end_date
1043: FROM pn_var_grp_dates_all
1044: WHERE inv_start_date = p_inv_start_date
1045: AND inv_end_date = p_inv_end_date
1046: AND period_id = p_period_id;
1047:

Line 1418: UPDATE pn_var_grp_dates_all

1414: pnp_debug_pkg.debug ('updating end date as '||p_grp_end_date);
1415: pnp_debug_pkg.debug ('updating proration factor as '||p_proration_factor);
1416: pnp_debug_pkg.debug ('updating due date as '||p_due_date);
1417: /* Updte the end date and proration factor for the group */
1418: UPDATE pn_var_grp_dates_all
1419: SET grp_end_date = p_grp_end_date,
1420: proration_Factor = round(p_proration_factor,10),
1421: reptg_due_date = p_due_date --Bug # 5937888
1422: WHERE grp_date_id = l_grp_date_id;

Line 1525: UPDATE pn_var_grp_dates_all

1521: pnp_debug_pkg.debug ('updating end date as '||p_grp_end_date);
1522: pnp_debug_pkg.debug ('updating proration factor as '||p_proration_factor);
1523: pnp_debug_pkg.debug ('updating due date as '||p_due_date);
1524: /* Updte the end date and proration factor for the group */
1525: UPDATE pn_var_grp_dates_all
1526: SET grp_end_date = p_grp_end_date,
1527: proration_Factor = round(p_proration_factor,10),
1528: reptg_due_date = p_due_date --Bug # 5937888
1529: WHERE grp_date_id = l_grp_date_id;

Line 1634: UPDATE pn_var_grp_dates_all

1630: pnp_debug_pkg.debug ('updating end date as '||p_grp_end_date);
1631: pnp_debug_pkg.debug ('updating proration factor as '||p_proration_factor);
1632: pnp_debug_pkg.debug ('updating due date as '||p_due_date);
1633: /* Updte the end date and proration factor for the group */
1634: UPDATE pn_var_grp_dates_all
1635: SET grp_end_date = p_grp_end_date,
1636: proration_Factor = round(p_proration_factor,10),
1637: reptg_due_date = p_due_date --Bug # 5937888
1638: WHERE grp_date_id = l_grp_date_id;

Line 1742: UPDATE pn_var_grp_dates_all

1738: pnp_debug_pkg.debug ('updating end date as '||p_grp_end_date);
1739: pnp_debug_pkg.debug ('updating proration factor as '||p_proration_factor);
1740: pnp_debug_pkg.debug ('updating due date as '||p_due_date);
1741: /* Updte the end date and proration factor for the group */
1742: UPDATE pn_var_grp_dates_all
1743: SET grp_end_date = p_grp_end_date,
1744: proration_Factor = round(p_proration_factor,10),
1745: reptg_due_date = p_due_date --Bug # 5937888
1746: WHERE grp_date_id = l_grp_date_id;

Line 2206: FROM pn_var_grp_dates_all

2202:
2203: /* Fetches the group id which starts on a specified date for a VR agreement */
2204: CURSOR group_cur (p_start_date DATE) IS
2205: SELECT grp_end_date, grp_date_id
2206: FROM pn_var_grp_dates_all
2207: WHERE var_rent_id = p_var_rent_id
2208: AND grp_start_date = p_start_date;
2209:
2210: /* Fetches the period id which starts on a specified date for a VR agreement */

Line 2613: UPDATE pn_var_grp_dates_all

2609: pnp_debug_pkg.debug ('updating proration factor as '||l_proration_Factor);
2610: pnp_debug_pkg.debug ('updating due date of group '||VR_grp_dates(j).l_reptg_due_date);
2611: /* Updte the end date and proration factor for the group */
2612:
2613: UPDATE pn_var_grp_dates_all
2614: SET grp_end_date = VR_grp_dates(j).l_grp_end_date,
2615: proration_Factor = round(l_proration_Factor,10),
2616: reptg_due_date = VR_grp_dates(j).l_reptg_due_date --Bug # 5937888
2617: WHERE grp_date_id = l_grp_date_id;

Line 2892: FROM pn_var_grp_dates_all grp

2888: -- updated with the new proration factor after lease contraction
2889:
2890: SELECT grp.grp_start_date
2891: INTO p_grp_start_date
2892: FROM pn_var_grp_dates_all grp
2893: WHERE grp.var_rent_id = p_var_rent_id
2894: AND grp.grp_start_date <= p_term_date
2895: AND grp.grp_end_date >= p_term_date
2896: AND rownum < 2;

Line 2939: UPDATE pn_var_grp_dates_all

2935: END IF;
2936:
2937: --call to update PN_VAR_GRP_DATES;
2938:
2939: UPDATE pn_var_grp_dates_all
2940: SET grp_end_date = p_term_date,
2941: proration_factor = round(p_proration_factor,10),
2942: last_update_date = p_last_update_date,
2943: last_updated_by = p_last_updated_by,

Line 4308: FROM pn_var_grp_dates_all

4304: pnp_debug_pkg.debug ('PN_VAR_RENT_PKG.FIND_REPORTING_PERIODS (+)');
4305:
4306: SELECT count(GRP_START_DATE)
4307: INTO l_reporting_periods
4308: FROM pn_var_grp_dates_all
4309: WHERE period_id = p_period_id;
4310:
4311: RETURN l_reporting_periods;
4312:

Line 4541: FROM pn_var_grp_dates_all

4537: invoice_date,
4538: inv_schedule_date,
4539: forecasted_exp_code
4540: INTO l_grp_date_info
4541: FROM pn_var_grp_dates_all
4542: WHERE var_rent_id = p_var_rent_id
4543: AND period_id = p_period_id
4544: AND grp_start_date <= p_start_date
4545: AND grp_start_date <= p_end_date

Line 4611: pn_var_grp_dates_ALL g1, pn_var_grp_dates_ALL g2

4607: (g2.grp_end_date-g2.grp_start_date)+1 last_group_pro_days,
4608: g2.proration_factor last_group_gl_days
4609: INTO l_proration_factor
4610: FROM pn_var_periods_ALL p1, pn_var_periods_ALL p2,
4611: pn_var_grp_dates_ALL g1, pn_var_grp_dates_ALL g2
4612: WHERE p1.var_rent_id = p2.var_rent_id
4613: AND p1.var_rent_id = p_var_rent_id
4614: AND g1.var_rent_id = g2.var_rent_id
4615: AND g1.var_rent_id = p_var_rent_id

Line 4800: FROM pn_var_grp_dates_all

4796: SELECT 1
4797: INTO l_exported
4798: FROM dual
4799: WHERE EXISTS ( SELECT grp_date_id
4800: FROM pn_var_grp_dates_all
4801: WHERE var_rent_id = p_id
4802: AND (actual_exp_code = 'Y' OR
4803: forecasted_exp_code = 'Y')
4804: );

Line 4812: FROM pn_var_grp_dates_all

4808: SELECT 1
4809: INTO l_exported
4810: FROM dual
4811: WHERE EXISTS ( SELECT grp_date_id
4812: FROM pn_var_grp_dates_all
4813: WHERE period_id = p_id
4814: AND (actual_exp_code = 'Y' OR
4815: forecasted_exp_code = 'Y')
4816: );

Line 4824: FROM pn_var_grp_dates_all

4820: SELECT 1
4821: INTO l_exported
4822: FROM dual
4823: WHERE EXISTS ( SELECT grp_date_id
4824: FROM pn_var_grp_dates_all
4825: WHERE period_id IN (SELECT period_id
4826: FROM pn_var_lines_ALL
4827: WHERE line_item_id = p_id)
4828: AND (actual_exp_code = 'Y' OR

Line 4838: FROM pn_var_grp_dates_all

4834: SELECT 1
4835: INTO l_exported
4836: FROM dual
4837: WHERE EXISTS ( SELECT grp_date_id
4838: FROM pn_var_grp_dates_all
4839: WHERE period_id IN (SELECT period_id
4840: FROM pn_var_lines_ALL
4841: WHERE line_default_id = p_id)
4842: AND (actual_exp_code = 'Y' OR

Line 4851: FROM pn_var_grp_dates_all a,

4847: SELECT 1
4848: INTO l_exported
4849: FROM dual
4850: WHERE EXISTS ( SELECT grp_date_id
4851: FROM pn_var_grp_dates_all a,
4852: pn_var_periods_all b,
4853: pn_var_lines_all c
4854: WHERE a.period_id = b.period_id
4855: AND b.period_id = c.period_id

Line 5001: FROM pn_var_grp_dates_all

4997: INTO l_status
4998: FROM dual
4999: WHERE NOT EXISTS
5000: (SELECT grp_date_id
5001: FROM pn_var_grp_dates_all
5002: WHERE period_id = p_period_id
5003: AND ((actual_exp_code = 'N' AND FORECASTED_exp_code ='N' AND variance_exp_code = 'N') OR
5004: (actual_exp_code = 'N' AND FORECASTED_exp_code ='Y' AND variance_exp_code = 'Y')
5005: )

Line 5029: FROM pn_var_grp_dates_all

5025: SELECT 'RECONCILED'
5026: INTO l_status
5027: FROM dual
5028: WHERE NOT EXISTS(SELECT grp_date_id
5029: FROM pn_var_grp_dates_all
5030: WHERE period_id = p_period_id
5031: AND variance_exp_code = 'N')
5032: AND NOT EXISTS(SELECT vol_hist_id
5033: FROM pn_var_vol_hist_all

Line 5290: FROM pn_var_grp_dates_all grp

5286: FROM pn_var_vol_hist_all vh
5287: WHERE actual_exp_code = 'N'
5288: AND period_id = p_period_id
5289: AND EXISTS (SELECT grp.grp_date_id
5290: FROM pn_var_grp_dates_all grp
5291: WHERE actual_exp_code = 'Y'
5292: AND grp.grp_date_id = vh.grp_date_id));
5293:
5294: ELSIF p_invoice_on = 'FORECASTED' THEN

Line 5304: FROM pn_var_grp_dates_all grp

5300: FROM pn_var_vol_hist_all vh
5301: WHERE forecasted_exp_code = 'N'
5302: AND period_id = p_period_id
5303: AND EXISTS (SELECT grp.grp_date_id
5304: FROM pn_var_grp_dates_all grp
5305: WHERE forecasted_exp_code = 'Y'
5306: AND grp.grp_date_id = vh.grp_date_id));
5307:
5308: END IF;

Line 6565: FROM pn_var_grp_dates_all

6561:
6562: CURSOR pn_var_grp_dates_cur
6563: IS
6564: SELECT *
6565: FROM pn_var_grp_dates_all
6566: WHERE period_id = p_period_id
6567: ORDER BY grp_start_date;
6568:
6569: v_inv_dates_tbl group_dates_tbl;

Line 6864: UPDATE pn_var_grp_dates_all

6860: put_log(' Group Date While Updating Group Dates:'||vr_grp_dates(i).l_group_date);
6861: --vr_grp_dates(i).l_proration_factor := 1;
6862: END IF;
6863:
6864: UPDATE pn_var_grp_dates_all
6865: SET grp_end_date = vr_grp_dates(i).l_grp_end_date ,
6866: proration_factor = round(vr_grp_dates(i).l_proration_factor,10), --Chris.T. 20MAY2004
6867: last_update_date = sysdate,
6868: last_updated_by = FND_GLOBAL.USER_ID,

Line 7887: FROM pn_var_grp_dates_all

7883: WHERE var_rent_id = p_var_rent_id);
7884:
7885: DELETE pn_var_rent_summ_all
7886: WHERE grp_date_id IN (SELECT grp_date_id
7887: FROM pn_var_grp_dates_all
7888: WHERE var_rent_id = p_var_rent_id
7889: AND grp_start_date > p_new_termn_date);
7890:
7891: DELETE pn_var_constraints_all

Line 8130: DELETE pn_var_grp_dates_all

8126: ELSE
8127:
8128: pnp_debug_pkg.debug ('deleting group date and periods ...');
8129: /* Delete group dates and periods for which there exists no invoice */
8130: DELETE pn_var_grp_dates_all
8131: WHERE period_id = period_rec.period_id;
8132:
8133: DELETE pn_var_periods_all
8134: WHERE period_id = period_rec.period_id;

Line 8314: FROM pn_var_grp_dates_all

8310: inv_end_date,
8311: group_date,
8312: invoice_date,
8313: period_id
8314: FROM pn_var_grp_dates_all
8315: WHERE var_rent_id = p_var_rent_id
8316: AND p_new_termn_date BETWEEN grp_start_date AND grp_end_date;
8317:
8318: /* Get the details of breakpoint header default */

Line 8351: FROM pn_var_grp_dates_all

8347:
8348: /* Get the max invoice end date corresponding to the new termination date*/
8349: CURSOR inv_end_dt_cur(p_var_rent_id IN NUMBER) IS
8350: SELECT max(inv_end_date) inv_end_date
8351: FROM pn_var_grp_dates_all
8352: WHERE var_rent_id = p_var_rent_id
8353: AND inv_end_date <= p_new_termn_date;
8354:
8355: l_reptg_day_of_month NUMBER := 0;

Line 8407: DELETE pn_var_grp_dates_all

8403: l_inv_end_dt := grp_date_rec.inv_end_date;
8404: END LOOP;
8405:
8406: -- Bug13711733
8407: DELETE pn_var_grp_dates_all
8408: WHERE period_id = p_period_id
8409: and grp_start_date > p_new_termn_date
8410: and var_rent_id = p_var_rent_id;
8411:

Line 8428: UPDATE pn_var_grp_dates_all

8424: ,vr_id => p_var_rent_id
8425: ,p_period_id => l_period_id);*/
8426:
8427:
8428: UPDATE pn_var_grp_dates_all
8429: SET grp_end_date = p_new_termn_date,
8430: proration_factor = round(l_proration_factor,10),
8431: reptg_due_date = l_due_date
8432: WHERE var_rent_id = p_var_rent_id

Line 8448: UPDATE pn_var_grp_dates_all

8444: l_inv_sch_date := pn_var_rent_calc_pkg.inv_sch_date( inv_start_date => l_invoice_date
8445: ,vr_id => p_var_rent_id
8446: ,p_period_id => l_period_id);
8447:
8448: UPDATE pn_var_grp_dates_all
8449: SET inv_end_date = p_new_termn_date,
8450: inv_schedule_date = l_inv_sch_date
8451: WHERE var_rent_id = p_var_rent_id
8452: AND p_new_termn_date BETWEEN inv_start_date AND inv_end_date;

Line 8792: FROM pn_var_grp_dates_all

8788: WHERE var_rent_id = p_var_rent_id);
8789:
8790: DELETE pn_var_rent_summ_all
8791: WHERE grp_date_id IN (SELECT grp_date_id
8792: FROM pn_var_grp_dates_all
8793: WHERE var_rent_id = p_var_rent_id);
8794:
8795: DELETE pn_var_constraints_all
8796: WHERE period_id IN (SELECT period_id

Line 8827: DELETE pn_var_grp_dates_all

8823:
8824: DELETE pn_var_rent_inv_all
8825: WHERE var_rent_id = p_var_rent_id;
8826:
8827: DELETE pn_var_grp_dates_all
8828: WHERE var_rent_id = p_var_rent_id;
8829:
8830: DELETE pn_var_periods_all
8831: WHERE var_rent_id = p_var_rent_id;

Line 8925: FROM pn_var_grp_dates_all

8921:
8922: /* Get the max invoice end date corresponding to the new termination date*/
8923: CURSOR inv_end_dt_cur(p_var_rent_id IN NUMBER) IS
8924: SELECT max(inv_end_date) inv_end_date
8925: FROM pn_var_grp_dates_all
8926: WHERE var_rent_id = p_var_rent_id
8927: AND inv_end_date <= p_new_termn_date;
8928:
8929: BEGIN