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_LINE_DEFAULTS_ALL

Line 2793: DELETE pn_var_line_defaults_all

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;
2795:
2796: DELETE pn_var_constr_defaults_all
2797: WHERE var_rent_id = p_var_rent_id;

Line 5497: FROM pn_var_line_defaults_all

5493: WHERE var_rent_id = p_vr_id;
5494:
5495: CURSOR line_defs_c(p_vr_id IN NUMBER) IS
5496: SELECT line_default_id
5497: FROM pn_var_line_defaults_all
5498: WHERE var_rent_id = p_vr_id
5499: ORDER BY line_default_id;
5500:
5501: CURSOR bkpt_hdr_defs_c(p_line_def_id IN NUMBER) IS

Line 7045: UPDATE pn_var_line_defaults_all

7041: END;
7042:
7043: put_log ('Defaults Exists:'||l_default);
7044: IF l_default = 'Y' THEN
7045: UPDATE pn_var_line_defaults_all
7046: SET line_end_date = p_extension_end_date,
7047: processed_flag = 0
7048: WHERE var_rent_id = main_vr_rec.var_rent_id
7049: AND line_end_date = p_old_end_date;

Line 7856: -- in DELETE pn_var_line_defaults_all

7852: -- HISTORY :
7853: -- 01-JUN-06 piagrawa o Created
7854: -- 20-MAR-07 lbala o Added code to delete from pn_var_abat_defaults_all
7855: -- 03-MAY-10 acprakas o Changed condition to line_start_date > p_new_termn_date
7856: -- in DELETE pn_var_line_defaults_all
7857: -------------------------------------------------------------------------------
7858: PROCEDURE delete_vr_setup ( p_var_rent_id IN NUMBER
7859: ,p_new_termn_date IN DATE)
7860: IS

Line 7914: DELETE pn_var_line_defaults_all

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
7915: WHERE line_start_date > p_new_termn_date
7916: AND var_rent_id = p_var_rent_id;
7917:
7918: DELETE pn_var_constr_defaults_all

Line 8489: UPDATE pn_var_line_defaults_all

8485: SET constr_end_date = p_new_termn_date
8486: WHERE var_rent_id = p_var_rent_id
8487: AND p_new_termn_date BETWEEN constr_start_date AND constr_end_date;
8488:
8489: UPDATE pn_var_line_defaults_all
8490: SET line_end_date = p_new_termn_date
8491: WHERE var_rent_id = p_var_rent_id
8492: AND p_new_termn_date BETWEEN line_start_date AND line_end_date;
8493:

Line 8813: DELETE pn_var_line_defaults_all

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;
8815:
8816: DELETE pn_var_constr_defaults_all
8817: WHERE var_rent_id = p_var_rent_id;

Line 9007: UPDATE pn_var_line_defaults_all

9003: SET constr_end_date = p_new_termn_date
9004: WHERE var_rent_id = var_rent_rec.var_rent_id
9005: AND p_new_termn_date BETWEEN constr_start_date AND constr_end_date;
9006:
9007: UPDATE pn_var_line_defaults_all
9008: SET line_end_date = p_new_termn_date
9009: WHERE var_rent_id = var_rent_rec.var_rent_id
9010: AND p_new_termn_date BETWEEN line_start_date AND line_end_date;
9011:

Line 9103: FROM pn_var_line_defaults_all

9099: IS
9100:
9101: CURSOR exists_line_cur IS
9102: SELECT line_default_id
9103: FROM pn_var_line_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

Line 9160: UPDATE pn_var_line_defaults_all

9156: pnp_debug_pkg.debug ('p_var_rent_id .. '||p_var_rent_id);
9157: pnp_debug_pkg.debug ('p_old_termn_date ..'||p_old_termn_date);
9158: pnp_debug_pkg.debug ('p_new_termn_date ..'||p_new_termn_date);
9159:
9160: UPDATE pn_var_line_defaults_all
9161: SET line_end_date = p_new_termn_date
9162: WHERE var_rent_id = p_var_rent_id
9163: AND line_end_date = p_old_termn_date;
9164:

Line 9891: FROM pn_var_line_defaults_all

9887: CURSOR default_exists (p_var_rent_id NUMBER) IS
9888: SELECT 'Y'
9889: FROM DUAL
9890: WHERE EXISTS (SELECT var_rent_id
9891: FROM pn_var_line_defaults_all
9892: WHERE var_rent_id = p_var_rent_id)
9893: OR EXISTS (SELECT var_rent_id
9894: FROM pn_var_constr_defaults_all
9895: WHERE var_rent_id = p_var_rent_id);

Line 10605: DELETE FROM PN_VAR_LINE_DEFAULTS_ALL

10601: SELECT sysdate
10602: INTO l_date
10603: FROM dual;
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;

Line 10794: UPDATE pn_var_line_defaults_all

10790: WHERE bkpt_header_id = bkpt_rec.bkpt_header_id;
10791:
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;

Line 10801: UPDATE pn_var_line_defaults_all

10797: where line_default_id = bkpt_rec.line_default_id)
10798: WHERE line_default_id = bkpt_rec.line_default_id;
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;