APPS.PN_VAR_RENT_PKG dependencies on PN_VAR_DEFAULTS_PKG

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

8477:
8478: DELETE FROM pn_var_bkpts_head_all
8479: WHERE var_rent_id = p_var_rent_id;
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

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

9180: WHERE var_rent_id = p_var_rent_id
9181: AND constr_end_date = p_old_termn_date;
9182:
9183: /* This generates line items, breakpoint header and details in main tables */
9184: pnp_debug_pkg.debug ('calling procedure pn_var_defaults_pkg.create_default_lines ..');
9185: FOR rec IN bkpt_data_exists LOOP
9186: l_bkpt_exists := rec.bkpt_exists;
9187: END LOOP;
9188:

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

9199:
9200: DELETE FROM pn_var_bkpts_head_all
9201: WHERE var_rent_id = p_var_rent_id;
9202:
9203: pn_var_defaults_pkg.create_setup_data (x_var_rent_id => p_var_rent_id);
9204: END IF;
9205:
9206: /* This generates constraint records in main tables */
9207: pnp_debug_pkg.debug ('calling procedure pn_var_defaults_pkg.create_default_constraints ..');

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

9203: pn_var_defaults_pkg.create_setup_data (x_var_rent_id => p_var_rent_id);
9204: END IF;
9205:
9206: /* This generates constraint records in main tables */
9207: pnp_debug_pkg.debug ('calling procedure pn_var_defaults_pkg.create_default_constraints ..');
9208: FOR rec IN constr_data_exists LOOP
9209: DELETE FROM pn_var_constraints_all
9210: WHERE period_id IN (SELECT period_id
9211: FROM pn_var_periods_all

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

9210: WHERE period_id IN (SELECT period_id
9211: FROM pn_var_periods_all
9212: WHERE var_rent_id = p_var_rent_id);
9213:
9214: pn_var_defaults_pkg.create_default_constraints (x_var_rent_id => p_var_rent_id);
9215: END LOOP;
9216:
9217: pnp_debug_pkg.debug ('pn_var_rent_pkg.extend_defaults (-)');
9218: END;

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

9971: END IF;
9972:
9973: ELSE
9974: /* Undo the breakpoint setup */
9975: pn_var_defaults_pkg.delete_default_lines (main_vr_rec.var_rent_id);
9976: END IF;
9977:
9978: IF l_partial_flag = 'Y' THEN
9979: