APPS.PN_VAREN_PVT dependencies on PN_VAR_CONSTRAINTS_ALL

Line 351: -- PURPOSE : Remove Constraints i.e, delete records from pn_var_constraints_all

347:
348: --------------------------------------------------------------------------------
349: -- NAME : UNDO_CONSTRAINTS
350: -- DESCRIPTION :
351: -- PURPOSE : Remove Constraints i.e, delete records from pn_var_constraints_all
352: -- for that VRA
353: -- INVOKED FROM :
354: -- ARGUMENTS : p_var_rent_id, x_return_status
355: -- REFERENCE :

Line 371: DELETE FROM pn_var_constraints_all

367: pn_varen_util.pvt_debug ('PN_VAREN_PVT: Undo_Constraints : Starting of removing Constraint records: '
368: , 3
369: );
370:
371: DELETE FROM pn_var_constraints_all
372: WHERE constr_default_id IN (SELECT constr_default_id
373: FROM pn_var_constr_defaults_all
374: WHERE var_rent_id = p_var_rent_id);
375:

Line 10244: DELETE FROM pn_var_constraints_all

10240: WHERE period_id IN (SELECT period_id
10241: FROM pn_var_periods_all
10242: WHERE var_rent_id = l_varentid);
10243:
10244: DELETE FROM pn_var_constraints_all
10245: WHERE period_id IN (SELECT period_id
10246: FROM pn_var_periods_all
10247: WHERE var_rent_id = l_varentid);
10248:

Line 15270: FROM pn_var_constraints_all

15266: , 3);
15267:
15268: SELECT COUNT (1)
15269: INTO ln_const_count
15270: FROM pn_var_constraints_all
15271: WHERE constr_default_id IN (SELECT constr_default_id
15272: FROM pn_var_constr_defaults_all
15273: WHERE var_rent_id = p_constraints_tbl (uc).var_rent_id);
15274: