[Home] [Help]
2986: l_date DATE := nvl(p_term_date,(to_date('01/01/1776','mm/dd/yyyy')));
2987:
2988: CURSOR c1 IS
2989: SELECT constraint_id
2990: FROM PN_VAR_CONSTRAINTS_ALL
2991: WHERE period_id IN (SELECT period_id
2992: FROM PN_VAR_PERIODS_ALL
2993: WHERE var_rent_id = p_var_rent_id
2994: AND start_date > l_date
4015: SELECT 1
4016: INTO l_constr_exist
4017: FROM dual
4018: WHERE EXISTS ( SELECT constraint_id
4019: FROM pn_var_constraints_ALL
4020: WHERE period_id IN (SELECT period_id
4021: FROM PN_VAR_PERIODS_ALL
4022: WHERE var_rent_id = p_var_rent_id
4023: AND start_date > l_date
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;
6061: l_C1_end_date DATE;
6119: SELECT constraint_id
6120: ,constr_start_date
6121: ,constr_end_date
6122: ,type_code
6123: FROM pn_var_constraints_all
6124: WHERE period_id = p_period_id
6125: ORDER BY constr_start_date;
6126:
6127:
7887: FROM pn_var_grp_dates_all
7888: WHERE var_rent_id = p_var_rent_id
7889: AND grp_start_date > p_new_termn_date);
7890:
7891: DELETE pn_var_constraints_all
7892: WHERE constr_start_date > p_new_termn_date
7893: AND period_id IN (SELECT period_id
7894: FROM pn_var_periods_all
7895: WHERE var_rent_id = p_var_rent_id);
8450: inv_schedule_date = l_inv_sch_date
8451: WHERE var_rent_id = p_var_rent_id
8452: AND p_new_termn_date BETWEEN inv_start_date AND inv_end_date;
8453:
8454: UPDATE pn_var_constraints_all
8455: SET constr_end_date = p_new_termn_date
8456: WHERE period_id = p_period_id
8457: AND p_new_termn_date BETWEEN constr_start_date AND constr_end_date;
8458:
8791: WHERE grp_date_id IN (SELECT grp_date_id
8792: FROM pn_var_grp_dates_all
8793: WHERE var_rent_id = p_var_rent_id);
8794:
8795: DELETE pn_var_constraints_all
8796: WHERE period_id IN (SELECT period_id
8797: FROM pn_var_periods_all
8798: WHERE var_rent_id = p_var_rent_id);
8799:
9119: CURSOR constr_data_exists IS
9120: SELECT 'x'
9121: FROM DUAL
9122: WHERE EXISTS (SELECT constraint_id
9123: FROM pn_var_constraints_all
9124: WHERE period_id IN (SELECT PERIOD_ID
9125: FROM pn_var_periods_all
9126: WHERE var_rent_id = p_var_rent_id)
9127: AND constr_default_id IS NOT NULL);
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
9212: WHERE var_rent_id = p_var_rent_id);
9213:
9374: ,org_id
9375: ,agreement_template_id
9376: ,constr_template_id
9377: ,constr_default_id
9378: FROM pn_var_constraints_all
9379: WHERE period_id = p_period_id
9380: AND constr_end_date = p_end_date;
9381:
9382:
9640: SET bkpt_end_date = period_rec.end_date
9641: WHERE var_rent_id = p_var_rent_id
9642: AND bkpt_end_date = p_old_termn_date;
9643:
9644: UPDATE pn_var_constraints_all
9645: SET constr_end_date = period_rec.end_date
9646: WHERE period_id = p_period_id
9647: AND constr_end_date = p_old_termn_date;
9648:
10501: ,cons.constr_template_id
10502: ,cons.constr_default_id
10503: ,cons.constr_start_date
10504: ,cons.constr_end_date
10505: FROM pn_var_constraints_all cons,
10506: pn_var_periods_all per
10507: WHERE per.var_rent_id = p_var_rent_id
10508: AND cons.period_id = per.period_id;
10509:
10920: X_ATTRIBUTE14 => NULL,
10921: X_ATTRIBUTE15 => NULL
10922: );
10923:
10924: UPDATE pn_var_constraints_all
10925: SET constr_default_id = l_constrdefaultid
10926: WHERE constraint_id = constr_rec.constraint_id;
10927:
10928: