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.

[Home] [Help]

APPS.PN_VAR_RENT_PKG dependencies on PN_VAR_BKDT_DEFAULTS_ALL

Line 2787: DELETE FROM pn_var_bkdt_defaults_all

2783:
2784: DELETE FROM pn_var_abatements_all abat
2785: where abat.var_rent_id=p_var_rent_id;
2786:
2787: DELETE FROM pn_var_bkdt_defaults_all
2788: WHERE var_rent_id = p_var_rent_id;
2789:
2790: DELETE pn_var_bkhd_defaults_all
2791: WHERE var_rent_id = p_var_rent_id;

Line 5513: FROM pn_var_bkdt_defaults_all

5509: CURSOR bkpt_dtl_defs_c(p_bkhd_def_id IN NUMBER) IS
5510: SELECT bkdt_start_date
5511: ,bkdt_end_date
5512: ,COUNT(bkdt_default_id) AS bkpt_count
5513: FROM pn_var_bkdt_defaults_all
5514: WHERE bkhd_default_id = p_bkhd_def_id
5515: GROUP BY bkdt_start_date, bkdt_end_date
5516: ORDER BY bkdt_start_date;
5517:

Line 5523: FROM pn_var_bkdt_defaults_all

5519: ,p_st_dt IN DATE
5520: ,p_end_dt IN DATE) IS
5521: SELECT period_bkpt_vol_start
5522: ,period_bkpt_vol_end
5523: FROM pn_var_bkdt_defaults_all
5524: WHERE bkhd_default_id = p_bkhd_def_id
5525: AND bkdt_start_date = p_st_dt
5526: AND bkdt_end_date = p_end_dt
5527: ORDER BY period_bkpt_vol_start;

Line 5531: FROM pn_var_bkdt_defaults_all

5527: ORDER BY period_bkpt_vol_start;
5528:
5529: CURSOR null_def_vols(p_bkhd_def_id IN NUMBER, p_start_date IN DATE) IS
5530: SELECT count(*)
5531: FROM pn_var_bkdt_defaults_all
5532: WHERE bkhd_default_id = p_bkhd_def_id
5533: AND bkdt_start_date = p_start_date
5534: AND period_bkpt_vol_end IS NULL;
5535:

Line 5638: FROM pn_var_bkdt_defaults_all

5634: l_bkdt_counter := 1;
5635:
5636: SELECT count(*)
5637: INTO l_bktd_num
5638: FROM pn_var_bkdt_defaults_all
5639: WHERE bkhd_default_id = bkhd_rec.bkhd_default_id;
5640:
5641: IF l_bktd_num = 0 THEN
5642: l_return_status := 'GAP_FOUND_EXCEPTION';

Line 5742: FROM pn_var_bkdt_defaults_all

5738: END IF;
5739: ELSE
5740: SELECT min(bkdt_start_date)
5741: INTO l_dt_min_st_dt
5742: FROM pn_var_bkdt_defaults_all
5743: WHERE bkhd_default_id = bkhd_rec.bkhd_default_id;
5744:
5745: IF l_dt_min_st_dt > bkhd_rec.bkhd_start_date THEN
5746: IF p_check_for = 'GAPS' THEN

Line 7415: FROM pn_var_bkdt_defaults_all a,

7411: CURSOR c_1 IS
7412: SELECT 'z'
7413: FROM DUAL
7414: WHERE EXISTS ( SELECT a.var_rent_id
7415: FROM pn_var_bkdt_defaults_all a,
7416: pn_var_bkhd_defaults_all b
7417: WHERE a.var_rent_id = p_var_rent_id
7418: AND a.bkhd_default_id = b.bkhd_default_id
7419: AND b.line_default_id = p_line_default_id

Line 7469: FROM pn_var_bkdt_defaults_all

7465: CURSOR detail_cur (p_header_id NUMBER) IS
7466: SELECT
7467: bkdt_start_date,
7468: bkdt_end_date
7469: FROM pn_var_bkdt_defaults_all
7470: WHERE var_rent_id = p_var_rent_id
7471: AND bkhd_default_id = p_header_id
7472: ORDER BY bkdt_start_date;
7473:

Line 7478: FROM pn_var_bkdt_defaults_all

7474: CURSOR exist_next_detail_date (p_header_id NUMBER,p_end_date DATE) IS
7475: SELECT 'x'
7476: FROM dual
7477: WHERE EXISTS ( SELECT var_Rent_id
7478: FROM pn_var_bkdt_defaults_all
7479: WHERE var_rent_id = p_var_rent_id
7480: AND bkhd_default_id = p_header_id
7481: AND bkdt_start_date = p_end_date + 1);
7482:

Line 7833: Update pn_var_bkdt_defaults_all

7829: p_bkdt_end_date IN DATE)
7830: IS
7831: BEGIN
7832:
7833: Update pn_var_bkdt_defaults_all
7834: SET bkdt_start_date = p_bkdt_st_date,
7835: bkdt_end_date = p_bkdt_end_date
7836: where bkhd_default_id = p_bkhd_default_id
7837: and bkdt_start_date = p_bkdt_st_date_old

Line 7906: DELETE pn_var_bkdt_defaults_all

7902: AND start_date > p_new_termn_date);
7903:
7904: /* Delete data from defaults table */
7905:
7906: DELETE pn_var_bkdt_defaults_all
7907: WHERE var_rent_id = p_var_rent_id
7908: AND bkdt_start_date > p_new_termn_date;
7909:
7910: DELETE pn_var_bkhd_defaults_all

Line 8328: FROM pn_var_bkdt_defaults_all

8324:
8325: /* Get the details of breakpoint details default */
8326: CURSOR bkdt_defaults_cur IS
8327: SELECT bkdt_default_id, bkhd_default_id
8328: FROM pn_var_bkdt_defaults_all
8329: WHERE var_rent_id = p_var_rent_id
8330: AND p_new_termn_date BETWEEN bkdt_start_date AND bkdt_end_date;
8331:
8332: /* Get the details of volume history */

Line 8807: DELETE pn_var_bkdt_defaults_all

8803: WHERE var_rent_id = p_var_rent_id);
8804:
8805: /* Delete data from defaults table */
8806:
8807: DELETE pn_var_bkdt_defaults_all
8808: WHERE var_rent_id = p_var_rent_id;
8809:
8810: DELETE pn_var_bkhd_defaults_all
8811: WHERE var_rent_id = p_var_rent_id;

Line 8918: FROM pn_var_bkdt_defaults_all

8914:
8915: /* Get the details of breakpoint details default */
8916: CURSOR bkdt_defaults_cur(p_var_rent_id NUMBER) IS
8917: SELECT bkdt_default_id, bkhd_default_id
8918: FROM pn_var_bkdt_defaults_all
8919: WHERE var_rent_id = p_var_rent_id
8920: AND p_new_termn_date BETWEEN bkdt_start_date AND bkdt_end_date;
8921:
8922: /* Get the max invoice end date corresponding to the new termination date*/

Line 9139: FROM pn_var_bkdt_defaults_all

9135:
9136: /* Get the details of breakpoint details default */
9137: CURSOR bkdt_defaults_cur IS
9138: SELECT bkdt_default_id, bkhd_default_id
9139: FROM pn_var_bkdt_defaults_all
9140: WHERE var_rent_id = p_var_rent_id
9141: AND bkdt_end_date = p_old_termn_date
9142: AND bkhd_default_id IN ( SELECT bkhd_default_id
9143: FROM pn_var_bkhd_defaults_all

Line 10611: DELETE FROM PN_VAR_BKDT_DEFAULTS_ALL

10607:
10608: DELETE FROM PN_VAR_BKHD_DEFAULTS_ALL
10609: WHERE var_rent_id = l_var_rent_id;
10610:
10611: DELETE FROM PN_VAR_BKDT_DEFAULTS_ALL
10612: WHERE var_rent_id = l_var_rent_id;
10613:
10614: DELETE FROM PN_VAR_CONSTR_DEFAULTS_ALL
10615: WHERE var_rent_id = l_var_rent_id;

Line 11093: FROM pn_var_bkdt_defaults_all

11089: bkdt_end_date,
11090: period_bkpt_vol_start,
11091: period_bkpt_vol_end,
11092: bkpt_rate
11093: FROM pn_var_bkdt_defaults_all
11094: WHERE var_rent_id = p_vr_id
11095: AND bkdt_start_date BETWEEN p_start_date AND p_end_date;
11096:
11097: /* Cursor to select Breakpoints whose end date

Line 11108: FROM pn_var_bkdt_defaults_all

11104: bkdt_end_date,
11105: period_bkpt_vol_start,
11106: period_bkpt_vol_end,
11107: bkpt_rate
11108: FROM pn_var_bkdt_defaults_all
11109: WHERE var_rent_id = p_vr_id
11110: AND bkdt_end_date BETWEEN p_start_date AND p_end_date;
11111:
11112: BEGIN