APPS.PN_VAR_RENT_PKG dependencies on PN_VAR_DEFAULTS_PKG

Line 8464: pn_var_defaults_pkg.create_setup_data (x_var_rent_id => p_var_rent_id);

8460:
8461: DELETE FROM pn_var_bkpts_head_all
8462: WHERE var_rent_id = p_var_rent_id;
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

Line 9167: pnp_debug_pkg.debug ('calling procedure pn_var_defaults_pkg.create_default_lines ..');

9163: WHERE var_rent_id = p_var_rent_id
9164: AND constr_end_date = p_old_termn_date;
9165:
9166: /* This generates line items, breakpoint header and details in main tables */
9167: pnp_debug_pkg.debug ('calling procedure pn_var_defaults_pkg.create_default_lines ..');
9168: FOR rec IN bkpt_data_exists LOOP
9169: l_bkpt_exists := rec.bkpt_exists;
9170: END LOOP;
9171:

Line 9186: pn_var_defaults_pkg.create_setup_data (x_var_rent_id => p_var_rent_id);

9182:
9183: DELETE FROM pn_var_bkpts_head_all
9184: WHERE var_rent_id = p_var_rent_id;
9185:
9186: pn_var_defaults_pkg.create_setup_data (x_var_rent_id => p_var_rent_id);
9187: END IF;
9188:
9189: /* This generates constraint records in main tables */
9190: pnp_debug_pkg.debug ('calling procedure pn_var_defaults_pkg.create_default_constraints ..');

Line 9190: pnp_debug_pkg.debug ('calling procedure pn_var_defaults_pkg.create_default_constraints ..');

9186: pn_var_defaults_pkg.create_setup_data (x_var_rent_id => p_var_rent_id);
9187: END IF;
9188:
9189: /* This generates constraint records in main tables */
9190: pnp_debug_pkg.debug ('calling procedure pn_var_defaults_pkg.create_default_constraints ..');
9191: FOR rec IN constr_data_exists LOOP
9192: DELETE FROM pn_var_constraints_all
9193: WHERE period_id IN (SELECT period_id
9194: FROM pn_var_periods_all

Line 9197: pn_var_defaults_pkg.create_default_constraints (x_var_rent_id => p_var_rent_id);

9193: WHERE period_id IN (SELECT period_id
9194: FROM pn_var_periods_all
9195: WHERE var_rent_id = p_var_rent_id);
9196:
9197: pn_var_defaults_pkg.create_default_constraints (x_var_rent_id => p_var_rent_id);
9198: END LOOP;
9199:
9200: pnp_debug_pkg.debug ('pn_var_rent_pkg.extend_defaults (-)');
9201: END;

Line 9958: pn_var_defaults_pkg.delete_default_lines (main_vr_rec.var_rent_id);

9954: END IF;
9955:
9956: ELSE
9957: /* Undo the breakpoint setup */
9958: pn_var_defaults_pkg.delete_default_lines (main_vr_rec.var_rent_id);
9959: END IF;
9960:
9961: IF l_partial_flag = 'Y' THEN
9962: