APPS.PN_VAREN_PVT dependencies on PN_VAR_CONSTR_DEFAULTS_ALL

Line 303: FROM pn_var_constr_defaults_all

299: CURSOR c_constr_created
300: IS
301: SELECT COUNT (*)
302: , constr_default_id
303: FROM pn_var_constr_defaults_all
304: WHERE var_rent_id = p_var_rent_id
305: GROUP BY constr_default_id;
306: -- AND ( constr_default_id = p_constr_default_id
307: -- OR constr_default_num = p_constr_default_num

Line 373: FROM pn_var_constr_defaults_all

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:
376: pn_varen_util.pvt_debug ('PN_VAREN_PVT: Undo_Constraints :Removing of Constraint record has been success '
377: , 3

Line 2493: l_first_constr_type_code pn_var_constr_defaults_all.type_code%TYPE;

2489: l_st_date_exist VARCHAR2 (1) := NULL;
2490: l_return_msg VARCHAR2 (10);
2491: l_variable_rent_exists VARCHAR2 (30);
2492: l_var_rent_id NUMBER;
2493: l_first_constr_type_code pn_var_constr_defaults_all.type_code%TYPE;
2494: l_first_constr_amount pn_var_constr_defaults_all.amount%TYPE;
2495:
2496: l_val_ins_error_count NUMBER := 0;
2497: BEGIN

Line 2494: l_first_constr_amount pn_var_constr_defaults_all.amount%TYPE;

2490: l_return_msg VARCHAR2 (10);
2491: l_variable_rent_exists VARCHAR2 (30);
2492: l_var_rent_id NUMBER;
2493: l_first_constr_type_code pn_var_constr_defaults_all.type_code%TYPE;
2494: l_first_constr_amount pn_var_constr_defaults_all.amount%TYPE;
2495:
2496: l_val_ins_error_count NUMBER := 0;
2497: BEGIN
2498: pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Val_Ins_Constraints: Value of g_var_rent_id befor constraints loop: '

Line 9896: FROM pn_var_constr_defaults_all

9892:
9893: CURSOR c_def_con_exist
9894: IS
9895: SELECT COUNT (*)
9896: FROM pn_var_constr_defaults_all
9897: WHERE var_rent_id = p_var_rent_id;
9898:
9899: CURSOR c_def_bkdtexist
9900: IS

Line 10280: DELETE pn_var_constr_defaults_all

10276:
10277: DELETE pn_var_line_defaults_all
10278: WHERE var_rent_id = l_varentid;
10279:
10280: DELETE pn_var_constr_defaults_all
10281: WHERE var_rent_id = l_varentid;
10282:
10283: pn_varen_util.pvt_debug ('PN_VAREN_PVT: Undo_Periods: All the periods were deleted : '
10284: , 3

Line 10796: FROM pn_var_constr_defaults_all

10792: , attribute13
10793: , attribute14
10794: , attribute15
10795: , org_id
10796: FROM pn_var_constr_defaults_all
10797: --WHERE var_rent_id = p_upd_var_rent_rec.var_rent_id;
10798: WHERE constr_default_id = p_constr_default_id
10799: AND var_rent_id = p_var_rent_id;
10800:

Line 15272: FROM pn_var_constr_defaults_all

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:
15275: --l_pn_var_constraints.var_rent_id;
15276: pn_varen_util.pvt_debug