APPS.PN_VAR_RENT_PKG dependencies on PN_VAR_LINE_DEFAULTS_ALL

Line 2789: DELETE pn_var_line_defaults_all

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

Line 5493: FROM pn_var_line_defaults_all

5489: WHERE var_rent_id = p_vr_id;
5490:
5491: CURSOR line_defs_c(p_vr_id IN NUMBER) IS
5492: SELECT line_default_id
5493: FROM pn_var_line_defaults_all
5494: WHERE var_rent_id = p_vr_id
5495: ORDER BY line_default_id;
5496:
5497: CURSOR bkpt_hdr_defs_c(p_line_def_id IN NUMBER) IS

Line 7041: UPDATE pn_var_line_defaults_all

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

Line 7908: DELETE pn_var_line_defaults_all

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
7909: WHERE line_start_date >= p_new_termn_date
7910: AND var_rent_id = p_var_rent_id;
7911:
7912: DELETE pn_var_constr_defaults_all

Line 8472: UPDATE pn_var_line_defaults_all

8468: SET constr_end_date = p_new_termn_date
8469: WHERE var_rent_id = p_var_rent_id
8470: AND p_new_termn_date BETWEEN constr_start_date AND constr_end_date;
8471:
8472: UPDATE pn_var_line_defaults_all
8473: SET line_end_date = p_new_termn_date
8474: WHERE var_rent_id = p_var_rent_id
8475: AND p_new_termn_date BETWEEN line_start_date AND line_end_date;
8476:

Line 8796: DELETE pn_var_line_defaults_all

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;
8798:
8799: DELETE pn_var_constr_defaults_all
8800: WHERE var_rent_id = p_var_rent_id;

Line 8990: UPDATE pn_var_line_defaults_all

8986: SET constr_end_date = p_new_termn_date
8987: WHERE var_rent_id = var_rent_rec.var_rent_id
8988: AND p_new_termn_date BETWEEN constr_start_date AND constr_end_date;
8989:
8990: UPDATE pn_var_line_defaults_all
8991: SET line_end_date = p_new_termn_date
8992: WHERE var_rent_id = var_rent_rec.var_rent_id
8993: AND p_new_termn_date BETWEEN line_start_date AND line_end_date;
8994:

Line 9086: FROM pn_var_line_defaults_all

9082: IS
9083:
9084: CURSOR exists_line_cur IS
9085: SELECT line_default_id
9086: FROM pn_var_line_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

Line 9143: UPDATE pn_var_line_defaults_all

9139: pnp_debug_pkg.debug ('p_var_rent_id .. '||p_var_rent_id);
9140: pnp_debug_pkg.debug ('p_old_termn_date ..'||p_old_termn_date);
9141: pnp_debug_pkg.debug ('p_new_termn_date ..'||p_new_termn_date);
9142:
9143: UPDATE pn_var_line_defaults_all
9144: SET line_end_date = p_new_termn_date
9145: WHERE var_rent_id = p_var_rent_id
9146: AND line_end_date = p_old_termn_date;
9147:

Line 9874: FROM pn_var_line_defaults_all

9870: CURSOR default_exists (p_var_rent_id NUMBER) IS
9871: SELECT 'Y'
9872: FROM DUAL
9873: WHERE EXISTS (SELECT var_rent_id
9874: FROM pn_var_line_defaults_all
9875: WHERE var_rent_id = p_var_rent_id)
9876: OR EXISTS (SELECT var_rent_id
9877: FROM pn_var_constr_defaults_all
9878: WHERE var_rent_id = p_var_rent_id);

Line 10588: DELETE FROM PN_VAR_LINE_DEFAULTS_ALL

10584: SELECT sysdate
10585: INTO l_date
10586: FROM dual;
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;

Line 10777: UPDATE pn_var_line_defaults_all

10773: WHERE bkpt_header_id = bkpt_rec.bkpt_header_id;
10774:
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;

Line 10784: UPDATE pn_var_line_defaults_all

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