5: | PROCEDURE COPY_PARENT_CONSTRAINTS
6: |
7: |
8: | DESCRIPTION
9: | Create records in the change calendar PN_VAR_CONSTRAINTS_ALL table from
10: | records in the parent variable rent agreement.
11: |
12: | SCOPE - PUBLIC
13: |
52:
53:
54: cursor c_old_constraints (p_old_periodId NUMBER) is
55: select *
56: from pn_var_constraints
57: where period_id = p_old_periodId
58: ORDER BY constr_cat_code, type_code, amount;
59:
60: BEGIN
79: NULL;
80: ELSE
81: l_constr_num := l_constr_num + 1;
82:
83: INSERT INTO pn_var_constraints_all (
84: constraint_id,
85: constraint_num,
86: last_update_date,
87: last_updated_by,
113: constr_template_id,
114: agreement_template_id,
115: constr_default_id
116: ) values (
117: pn_var_constraints_s.nextval,
118: l_constr_num,
119: sysdate,
120: NVL(fnd_profile.value('USER_ID'),0),
121: sysdate,