APPS.PN_VAR_RENT_PKG dependencies on PN_VAR_CONSTR_DEFAULTS_ALL

Line 2796: DELETE pn_var_constr_defaults_all

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;
2798:
2799: IF SQL%NOTFOUND THEN
2800: NULL;

Line 4134: FROM pn_var_constr_defaults_all

4130: SELECT 1
4131: INTO l_constr_exist
4132: FROM dual
4133: WHERE EXISTS ( SELECT NULL
4134: FROM pn_var_constr_defaults_all
4135: WHERE var_rent_id = p_var_rent_id
4136: );
4137:
4138: RETURN l_constr_exist;

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

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

Line 6097: FROM pn_var_constr_defaults_all

6093: ,constr_start_date
6094: ,constr_end_date
6095: ,type_code
6096: ,amount
6097: FROM pn_var_constr_defaults_all
6098: WHERE var_rent_id = p_var_rent_id
6099: ORDER BY constr_start_date;
6100:
6101:

Line 7918: DELETE pn_var_constr_defaults_all

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
7919: WHERE constr_start_date > p_new_termn_date
7920: AND var_rent_id = p_var_rent_id;
7921:
7922: DELETE pn_var_abat_defaults_all

Line 8484: UPDATE pn_var_constr_defaults_all

8480:
8481: pn_var_defaults_pkg.create_setup_data (x_var_rent_id => p_var_rent_id);
8482: END LOOP;
8483:
8484: UPDATE pn_var_constr_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:

Line 8816: DELETE pn_var_constr_defaults_all

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;
8818:
8819: DELETE pn_payment_terms_all
8820: WHERE var_rent_inv_id IN (SELECT var_rent_inv_id

Line 9002: UPDATE pn_var_constr_defaults_all

8998: pn_var_bkhd_defaults_pkg.modify_row (x_bkhd_default_id => rec.bkhd_default_id,
8999: x_bkhd_end_date => p_new_termn_date);
9000: END LOOP;
9001:
9002: UPDATE pn_var_constr_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:

Line 9178: UPDATE pn_var_constr_defaults_all

9174: x_bkhd_default_id => bkdt_defaults_rec.bkhd_default_id,
9175: x_bkdt_end_date => p_new_termn_date);
9176: END LOOP;
9177:
9178: UPDATE pn_var_constr_defaults_all
9179: SET constr_end_date = p_new_termn_date
9180: WHERE var_rent_id = p_var_rent_id
9181: AND constr_end_date = p_old_termn_date;
9182:

Line 9894: FROM pn_var_constr_defaults_all

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);
9896:
9897: l_default_exists VARCHAR2 (1) := 'N';
9898: l_partial_flag VARCHAR2 (1);

Line 10614: DELETE FROM PN_VAR_CONSTR_DEFAULTS_ALL

10610:
10611: DELETE FROM PN_VAR_BKDT_DEFAULTS_ALL
10612: WHERE var_rent_id = l_var_rent_id;
10613:
10614: DELETE FROM PN_VAR_CONSTR_DEFAULTS_ALL
10615: WHERE var_rent_id = l_var_rent_id;
10616:
10617: l_sales_type_code := NULL;
10618: l_item_category_code := NULL;