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 2790: DELETE pn_var_bkhd_defaults_all

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;
2792:
2793: DELETE pn_var_line_defaults_all
2794: WHERE var_rent_id = p_var_rent_id;

Line 5505: FROM pn_var_bkhd_defaults_all

5501: CURSOR bkpt_hdr_defs_c(p_line_def_id IN NUMBER) IS
5502: SELECT bkhd_start_date
5503: ,bkhd_end_date
5504: ,bkhd_default_id
5505: FROM pn_var_bkhd_defaults_all
5506: WHERE line_default_id = p_line_def_id
5507: ORDER BY bkhd_start_date;
5508:
5509: CURSOR bkpt_dtl_defs_c(p_bkhd_def_id IN NUMBER) IS

Line 5769: FROM pn_var_bkhd_defaults_all

5765: END IF;
5766: ELSE
5767: SELECT min(bkhd_start_date)
5768: INTO l_hd_min_st_dt
5769: FROM pn_var_bkhd_defaults_all
5770: WHERE line_default_id = l_line_t(line_rec);
5771:
5772: IF l_hd_min_st_dt > l_vr_comm_dt THEN
5773: IF p_check_for = 'GAPS' THEN

Line 7036: FROM pn_var_bkhd_defaults_all

7032: SELECT 'Y'
7033: INTO l_default
7034: FROM DUAL
7035: WHERE EXISTS (SELECT var_rent_id
7036: FROM pn_var_bkhd_defaults_all
7037: WHERE var_rent_id = main_vr_rec.var_rent_id);
7038: EXCEPTION
7039: WHEN OTHERS THEN
7040: l_default := 'N';

Line 7416: pn_var_bkhd_defaults_all b

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
7420: AND ( (bkdt_start_date < p_start_date AND

Line 7450: FROM pn_var_bkhd_defaults_all

7446: CURSOR header_cur IS
7447: SELECT bkhd_default_id,
7448: bkhd_start_date,
7449: bkhd_end_date
7450: FROM pn_var_bkhd_defaults_all
7451: WHERE var_rent_id = p_var_rent_id
7452: AND line_default_id = p_line_default_id
7453: ORDER BY bkhd_start_date;
7454:

Line 7460: FROM pn_var_bkhd_defaults_all

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

Line 7910: DELETE pn_var_bkhd_defaults_all

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
7911: WHERE var_rent_id = p_var_rent_id
7912: AND bkhd_start_date > p_new_termn_date;
7913:
7914: DELETE pn_var_line_defaults_all

Line 8321: FROM pn_var_bkhd_defaults_all

8317:
8318: /* Get the details of breakpoint header default */
8319: CURSOR bkhd_default_cur IS
8320: SELECT bkhd_default_id
8321: FROM pn_var_bkhd_defaults_all
8322: WHERE var_rent_id = p_var_rent_id
8323: AND p_new_termn_date BETWEEN bkhd_start_date AND bkhd_end_date;
8324:
8325: /* Get the details of breakpoint details default */

Line 8810: DELETE pn_var_bkhd_defaults_all

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;
8812:
8813: DELETE pn_var_line_defaults_all
8814: WHERE var_rent_id = p_var_rent_id;

Line 8911: FROM pn_var_bkhd_defaults_all

8907:
8908: /* Get the details of breakpoint header default */
8909: CURSOR bkhd_default_cur (p_var_rent_id NUMBER) IS
8910: SELECT bkhd_default_id
8911: FROM pn_var_bkhd_defaults_all
8912: WHERE var_rent_id = p_var_rent_id
8913: AND p_new_termn_date BETWEEN bkhd_start_date AND bkhd_end_date;
8914:
8915: /* Get the details of breakpoint details default */

Line 9108: FROM pn_var_bkhd_defaults_all

9104: WHERE var_rent_id = p_var_rent_id;
9105:
9106: CURSOR exists_hd_def_cur (p_linedefid NUMBER) IS
9107: SELECT bkhd_default_id
9108: FROM pn_var_bkhd_defaults_all
9109: WHERE line_default_id = p_linedefid;
9110:
9111: CURSOR bkpt_data_exists IS
9112: SELECT 'x' bkpt_exists

Line 9132: FROM pn_var_bkhd_defaults_all

9128:
9129: /* Get the details of breakpoint header default */
9130: CURSOR bkhd_default_cur IS
9131: SELECT bkhd_default_id
9132: FROM pn_var_bkhd_defaults_all
9133: WHERE var_rent_id = p_var_rent_id
9134: AND bkhd_end_date = p_old_termn_date;
9135:
9136: /* Get the details of breakpoint details default */

Line 9143: FROM pn_var_bkhd_defaults_all

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
9144: WHERE var_rent_id = p_var_rent_id
9145: AND bkhd_end_date = p_new_termn_date
9146: AND break_type = 'ARTIFICIAL');
9147:

Line 10608: DELETE FROM PN_VAR_BKHD_DEFAULTS_ALL

10604:
10605: DELETE FROM PN_VAR_LINE_DEFAULTS_ALL
10606: WHERE var_rent_id = l_var_rent_id;
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;

Line 10796: from pn_var_bkhd_defaults_all

10792: END IF;
10793:
10794: UPDATE pn_var_line_defaults_all
10795: SET line_start_date = (select min(bkhd_start_date)
10796: from pn_var_bkhd_defaults_all
10797: where line_default_id = bkpt_rec.line_default_id)
10798: WHERE line_default_id = bkpt_rec.line_default_id;
10799:
10800:

Line 10803: from pn_var_bkhd_defaults_all

10799:
10800:
10801: UPDATE pn_var_line_defaults_all
10802: SET line_end_date = (select max(bkhd_end_date)
10803: from pn_var_bkhd_defaults_all
10804: where line_default_id = bkpt_rec.line_default_id)
10805: WHERE line_default_id = bkpt_rec.line_default_id;
10806:
10807: