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_BKHD_DEFAULTS_ALL

Line 2786: DELETE pn_var_bkhd_defaults_all

2782:
2783: DELETE FROM pn_var_bkdt_defaults_all
2784: WHERE var_rent_id = p_var_rent_id;
2785:
2786: DELETE pn_var_bkhd_defaults_all
2787: WHERE var_rent_id = p_var_rent_id;
2788:
2789: DELETE pn_var_line_defaults_all
2790: WHERE var_rent_id = p_var_rent_id;

Line 5501: FROM pn_var_bkhd_defaults_all

5497: CURSOR bkpt_hdr_defs_c(p_line_def_id IN NUMBER) IS
5498: SELECT bkhd_start_date
5499: ,bkhd_end_date
5500: ,bkhd_default_id
5501: FROM pn_var_bkhd_defaults_all
5502: WHERE line_default_id = p_line_def_id
5503: ORDER BY bkhd_start_date;
5504:
5505: CURSOR bkpt_dtl_defs_c(p_bkhd_def_id IN NUMBER) IS

Line 5765: FROM pn_var_bkhd_defaults_all

5761: END IF;
5762: ELSE
5763: SELECT min(bkhd_start_date)
5764: INTO l_hd_min_st_dt
5765: FROM pn_var_bkhd_defaults_all
5766: WHERE line_default_id = l_line_t(line_rec);
5767:
5768: IF l_hd_min_st_dt > l_vr_comm_dt THEN
5769: IF p_check_for = 'GAPS' THEN

Line 7032: FROM pn_var_bkhd_defaults_all

7028: SELECT 'Y'
7029: INTO l_default
7030: FROM DUAL
7031: WHERE EXISTS (SELECT var_rent_id
7032: FROM pn_var_bkhd_defaults_all
7033: WHERE var_rent_id = main_vr_rec.var_rent_id);
7034: EXCEPTION
7035: WHEN OTHERS THEN
7036: l_default := 'N';

Line 7412: pn_var_bkhd_defaults_all b

7408: SELECT 'z'
7409: FROM DUAL
7410: WHERE EXISTS ( SELECT a.var_rent_id
7411: FROM pn_var_bkdt_defaults_all a,
7412: pn_var_bkhd_defaults_all b
7413: WHERE a.var_rent_id = p_var_rent_id
7414: AND a.bkhd_default_id = b.bkhd_default_id
7415: AND b.line_default_id = p_line_default_id
7416: AND ( (bkdt_start_date < p_start_date AND

Line 7446: FROM pn_var_bkhd_defaults_all

7442: CURSOR header_cur IS
7443: SELECT bkhd_default_id,
7444: bkhd_start_date,
7445: bkhd_end_date
7446: FROM pn_var_bkhd_defaults_all
7447: WHERE var_rent_id = p_var_rent_id
7448: AND line_default_id = p_line_default_id
7449: ORDER BY bkhd_start_date;
7450:

Line 7456: FROM pn_var_bkhd_defaults_all

7452: CURSOR exist_next_header_date (p_end_date DATE) IS
7453: SELECT 'x'
7454: FROM dual
7455: WHERE EXISTS ( SELECT var_Rent_id
7456: FROM pn_var_bkhd_defaults_all
7457: WHERE var_rent_id = p_var_rent_id
7458: AND line_default_id = p_line_default_id
7459: AND bkhd_start_date = p_end_date + 1);
7460:

Line 7904: DELETE pn_var_bkhd_defaults_all

7900: DELETE pn_var_bkdt_defaults_all
7901: WHERE var_rent_id = p_var_rent_id
7902: AND bkdt_start_date > p_new_termn_date;
7903:
7904: DELETE pn_var_bkhd_defaults_all
7905: WHERE var_rent_id = p_var_rent_id
7906: AND bkhd_start_date > p_new_termn_date;
7907:
7908: DELETE pn_var_line_defaults_all

Line 8311: FROM pn_var_bkhd_defaults_all

8307:
8308: /* Get the details of breakpoint header default */
8309: CURSOR bkhd_default_cur IS
8310: SELECT bkhd_default_id
8311: FROM pn_var_bkhd_defaults_all
8312: WHERE var_rent_id = p_var_rent_id
8313: AND p_new_termn_date BETWEEN bkhd_start_date AND bkhd_end_date;
8314:
8315: /* Get the details of breakpoint details default */

Line 8793: DELETE pn_var_bkhd_defaults_all

8789:
8790: DELETE pn_var_bkdt_defaults_all
8791: WHERE var_rent_id = p_var_rent_id;
8792:
8793: DELETE pn_var_bkhd_defaults_all
8794: WHERE var_rent_id = p_var_rent_id;
8795:
8796: DELETE pn_var_line_defaults_all
8797: WHERE var_rent_id = p_var_rent_id;

Line 8894: FROM pn_var_bkhd_defaults_all

8890:
8891: /* Get the details of breakpoint header default */
8892: CURSOR bkhd_default_cur (p_var_rent_id NUMBER) IS
8893: SELECT bkhd_default_id
8894: FROM pn_var_bkhd_defaults_all
8895: WHERE var_rent_id = p_var_rent_id
8896: AND p_new_termn_date BETWEEN bkhd_start_date AND bkhd_end_date;
8897:
8898: /* Get the details of breakpoint details default */

Line 9091: FROM pn_var_bkhd_defaults_all

9087: WHERE var_rent_id = p_var_rent_id;
9088:
9089: CURSOR exists_hd_def_cur (p_linedefid NUMBER) IS
9090: SELECT bkhd_default_id
9091: FROM pn_var_bkhd_defaults_all
9092: WHERE line_default_id = p_linedefid;
9093:
9094: CURSOR bkpt_data_exists IS
9095: SELECT 'x' bkpt_exists

Line 9115: FROM pn_var_bkhd_defaults_all

9111:
9112: /* Get the details of breakpoint header default */
9113: CURSOR bkhd_default_cur IS
9114: SELECT bkhd_default_id
9115: FROM pn_var_bkhd_defaults_all
9116: WHERE var_rent_id = p_var_rent_id
9117: AND bkhd_end_date = p_old_termn_date;
9118:
9119: /* Get the details of breakpoint details default */

Line 9126: FROM pn_var_bkhd_defaults_all

9122: FROM pn_var_bkdt_defaults_all
9123: WHERE var_rent_id = p_var_rent_id
9124: AND bkdt_end_date = p_old_termn_date
9125: AND bkhd_default_id IN ( SELECT bkhd_default_id
9126: FROM pn_var_bkhd_defaults_all
9127: WHERE var_rent_id = p_var_rent_id
9128: AND bkhd_end_date = p_new_termn_date
9129: AND break_type = 'ARTIFICIAL');
9130:

Line 10591: DELETE FROM PN_VAR_BKHD_DEFAULTS_ALL

10587:
10588: DELETE FROM PN_VAR_LINE_DEFAULTS_ALL
10589: WHERE var_rent_id = l_var_rent_id;
10590:
10591: DELETE FROM PN_VAR_BKHD_DEFAULTS_ALL
10592: WHERE var_rent_id = l_var_rent_id;
10593:
10594: DELETE FROM PN_VAR_BKDT_DEFAULTS_ALL
10595: WHERE var_rent_id = l_var_rent_id;

Line 10779: from pn_var_bkhd_defaults_all

10775: END IF;
10776:
10777: UPDATE pn_var_line_defaults_all
10778: SET line_start_date = (select min(bkhd_start_date)
10779: from pn_var_bkhd_defaults_all
10780: where line_default_id = bkpt_rec.line_default_id)
10781: WHERE line_default_id = bkpt_rec.line_default_id;
10782:
10783:

Line 10786: from pn_var_bkhd_defaults_all

10782:
10783:
10784: UPDATE pn_var_line_defaults_all
10785: SET line_end_date = (select max(bkhd_end_date)
10786: from pn_var_bkhd_defaults_all
10787: where line_default_id = bkpt_rec.line_default_id)
10788: WHERE line_default_id = bkpt_rec.line_default_id;
10789:
10790: