[Home] [Help]
2982: l_date DATE := nvl(p_term_date,(to_date('01/01/1776','mm/dd/yyyy')));
2983:
2984: CURSOR c1 IS
2985: SELECT constraint_id
2986: FROM PN_VAR_CONSTRAINTS_ALL
2987: WHERE period_id IN (SELECT period_id
2988: FROM PN_VAR_PERIODS_ALL
2989: WHERE var_rent_id = p_var_rent_id
2990: AND start_date > l_date
4011: SELECT 1
4012: INTO l_constr_exist
4013: FROM dual
4014: WHERE EXISTS ( SELECT constraint_id
4015: FROM pn_var_constraints_ALL
4016: WHERE period_id IN (SELECT period_id
4017: FROM PN_VAR_PERIODS_ALL
4018: WHERE var_rent_id = p_var_rent_id
4019: AND start_date > l_date
6049: ,p_called_from IN VARCHAR2) RETURN VARCHAR2
6050: IS
6051:
6052: TYPE constr_def_type IS TABLE OF pn_var_constr_defaults_all%ROWTYPE INDEX BY BINARY_INTEGER;
6053: TYPE constr_type IS TABLE OF pn_var_constraints_all%ROWTYPE INDEX BY BINARY_INTEGER;
6054: constr_def_tab constr_def_type;
6055: constr_tab constr_type;
6056: l_C1_start_date DATE;
6057: l_C1_end_date DATE;
6115: SELECT constraint_id
6116: ,constr_start_date
6117: ,constr_end_date
6118: ,type_code
6119: FROM pn_var_constraints_all
6120: WHERE period_id = p_period_id
6121: ORDER BY constr_start_date;
6122:
6123:
7881: FROM pn_var_grp_dates_all
7882: WHERE var_rent_id = p_var_rent_id
7883: AND grp_start_date > p_new_termn_date);
7884:
7885: DELETE pn_var_constraints_all
7886: WHERE constr_start_date > p_new_termn_date
7887: AND period_id IN (SELECT period_id
7888: FROM pn_var_periods_all
7889: WHERE var_rent_id = p_var_rent_id);
8433: inv_schedule_date = l_inv_sch_date
8434: WHERE var_rent_id = p_var_rent_id
8435: AND p_new_termn_date BETWEEN inv_start_date AND inv_end_date;
8436:
8437: UPDATE pn_var_constraints_all
8438: SET constr_end_date = p_new_termn_date
8439: WHERE period_id = p_period_id
8440: AND p_new_termn_date BETWEEN constr_start_date AND constr_end_date;
8441:
8774: WHERE grp_date_id IN (SELECT grp_date_id
8775: FROM pn_var_grp_dates_all
8776: WHERE var_rent_id = p_var_rent_id);
8777:
8778: DELETE pn_var_constraints_all
8779: WHERE period_id IN (SELECT period_id
8780: FROM pn_var_periods_all
8781: WHERE var_rent_id = p_var_rent_id);
8782:
9102: CURSOR constr_data_exists IS
9103: SELECT 'x'
9104: FROM DUAL
9105: WHERE EXISTS (SELECT constraint_id
9106: FROM pn_var_constraints_all
9107: WHERE period_id IN (SELECT PERIOD_ID
9108: FROM pn_var_periods_all
9109: WHERE var_rent_id = p_var_rent_id)
9110: AND constr_default_id IS NOT NULL);
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
9195: WHERE var_rent_id = p_var_rent_id);
9196:
9357: ,org_id
9358: ,agreement_template_id
9359: ,constr_template_id
9360: ,constr_default_id
9361: FROM pn_var_constraints_all
9362: WHERE period_id = p_period_id
9363: AND constr_end_date = p_end_date;
9364:
9365:
9623: SET bkpt_end_date = period_rec.end_date
9624: WHERE var_rent_id = p_var_rent_id
9625: AND bkpt_end_date = p_old_termn_date;
9626:
9627: UPDATE pn_var_constraints_all
9628: SET constr_end_date = period_rec.end_date
9629: WHERE period_id = p_period_id
9630: AND constr_end_date = p_old_termn_date;
9631:
10484: ,cons.constr_template_id
10485: ,cons.constr_default_id
10486: ,cons.constr_start_date
10487: ,cons.constr_end_date
10488: FROM pn_var_constraints_all cons,
10489: pn_var_periods_all per
10490: WHERE per.var_rent_id = p_var_rent_id
10491: AND cons.period_id = per.period_id;
10492:
10903: X_ATTRIBUTE14 => NULL,
10904: X_ATTRIBUTE15 => NULL
10905: );
10906:
10907: UPDATE pn_var_constraints_all
10908: SET constr_default_id = l_constrdefaultid
10909: WHERE constraint_id = constr_rec.constraint_id;
10910:
10911: