APPS.PN_VAR_RENT_PKG dependencies on PN_VAR_CONSTR_DEFAULTS_ALL

Line 2792: DELETE pn_var_constr_defaults_all

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;
2794:
2795: IF SQL%NOTFOUND THEN
2796: NULL;

Line 4130: FROM pn_var_constr_defaults_all

4126: SELECT 1
4127: INTO l_constr_exist
4128: FROM dual
4129: WHERE EXISTS ( SELECT NULL
4130: FROM pn_var_constr_defaults_all
4131: WHERE var_rent_id = p_var_rent_id
4132: );
4133:
4134: RETURN l_constr_exist;

Line 6052: TYPE constr_def_type IS TABLE OF pn_var_constr_defaults_all%ROWTYPE INDEX BY BINARY_INTEGER;

6048: FUNCTION CONSTR_DATES_VALIDATION (p_var_rent_id IN NUMBER
6049: ,p_called_from IN VARCHAR2) RETURN VARCHAR2
6050: IS
6051:
6052: TYPE constr_def_type IS TABLE OF pn_var_constr_defaults_all%ROWTYPE INDEX BY BINARY_INTEGER;
6053: TYPE constr_type IS TABLE OF pn_var_constraints_all%ROWTYPE INDEX BY BINARY_INTEGER;
6054: constr_def_tab constr_def_type;
6055: constr_tab constr_type;
6056: l_C1_start_date DATE;

Line 6093: FROM pn_var_constr_defaults_all

6089: ,constr_start_date
6090: ,constr_end_date
6091: ,type_code
6092: ,amount
6093: FROM pn_var_constr_defaults_all
6094: WHERE var_rent_id = p_var_rent_id
6095: ORDER BY constr_start_date;
6096:
6097:

Line 7912: DELETE pn_var_constr_defaults_all

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
7913: WHERE constr_start_date > p_new_termn_date
7914: AND var_rent_id = p_var_rent_id;
7915:
7916: DELETE pn_var_abat_defaults_all

Line 8467: UPDATE pn_var_constr_defaults_all

8463:
8464: pn_var_defaults_pkg.create_setup_data (x_var_rent_id => p_var_rent_id);
8465: END LOOP;
8466:
8467: UPDATE pn_var_constr_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:

Line 8799: DELETE pn_var_constr_defaults_all

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;
8801:
8802: DELETE pn_payment_terms_all
8803: WHERE var_rent_inv_id IN (SELECT var_rent_inv_id

Line 8985: UPDATE pn_var_constr_defaults_all

8981: pn_var_bkhd_defaults_pkg.modify_row (x_bkhd_default_id => rec.bkhd_default_id,
8982: x_bkhd_end_date => p_new_termn_date);
8983: END LOOP;
8984:
8985: UPDATE pn_var_constr_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:

Line 9161: UPDATE pn_var_constr_defaults_all

9157: x_bkhd_default_id => bkdt_defaults_rec.bkhd_default_id,
9158: x_bkdt_end_date => p_new_termn_date);
9159: END LOOP;
9160:
9161: UPDATE pn_var_constr_defaults_all
9162: SET constr_end_date = p_new_termn_date
9163: WHERE var_rent_id = p_var_rent_id
9164: AND constr_end_date = p_old_termn_date;
9165:

Line 9877: FROM pn_var_constr_defaults_all

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);
9879:
9880: l_default_exists VARCHAR2 (1) := 'N';
9881: l_partial_flag VARCHAR2 (1);

Line 10597: DELETE FROM PN_VAR_CONSTR_DEFAULTS_ALL

10593:
10594: DELETE FROM PN_VAR_BKDT_DEFAULTS_ALL
10595: WHERE var_rent_id = l_var_rent_id;
10596:
10597: DELETE FROM PN_VAR_CONSTR_DEFAULTS_ALL
10598: WHERE var_rent_id = l_var_rent_id;
10599:
10600: l_sales_type_code := NULL;
10601: l_item_category_code := NULL;