64: x_return_status := fnd_api.g_ret_sts_success;
65:
66: FOR i in 1..p_index_constraint_tbl.count
67: LOOP
68: IF (p_index_constraint_tbl(i).attribute_category = pn_index_rent_utils.g_pn_miss_char)
69: THEN
70: p_index_constraint_tbl(i).attribute_category := NULL;
71: END IF;
72:
69: THEN
70: p_index_constraint_tbl(i).attribute_category := NULL;
71: END IF;
72:
73: IF (p_index_constraint_tbl(i).attribute1 = pn_index_rent_utils.g_pn_miss_char)
74: THEN
75: p_index_constraint_tbl(i).attribute1 := NULL;
76: END IF;
77:
74: THEN
75: p_index_constraint_tbl(i).attribute1 := NULL;
76: END IF;
77:
78: IF (p_index_constraint_tbl(i).attribute2 = pn_index_rent_utils.g_pn_miss_char)
79: THEN
80: p_index_constraint_tbl(i).attribute2 := NULL;
81: END IF;
82:
79: THEN
80: p_index_constraint_tbl(i).attribute2 := NULL;
81: END IF;
82:
83: IF (p_index_constraint_tbl(i).attribute3 = pn_index_rent_utils.g_pn_miss_char)
84: THEN
85: p_index_constraint_tbl(i).attribute3 := NULL;
86: END IF;
87:
84: THEN
85: p_index_constraint_tbl(i).attribute3 := NULL;
86: END IF;
87:
88: IF (p_index_constraint_tbl(i).attribute4 = pn_index_rent_utils.g_pn_miss_char)
89: THEN
90: p_index_constraint_tbl(i).attribute4 := NULL;
91: END IF;
92:
89: THEN
90: p_index_constraint_tbl(i).attribute4 := NULL;
91: END IF;
92:
93: IF (p_index_constraint_tbl(i).attribute5 = pn_index_rent_utils.g_pn_miss_char)
94: THEN
95: p_index_constraint_tbl(i).attribute5 := NULL;
96: END IF;
97:
94: THEN
95: p_index_constraint_tbl(i).attribute5 := NULL;
96: END IF;
97:
98: IF (p_index_constraint_tbl(i).attribute6 = pn_index_rent_utils.g_pn_miss_char)
99: THEN
100: p_index_constraint_tbl(i).attribute6 := NULL;
101: END IF;
102:
99: THEN
100: p_index_constraint_tbl(i).attribute6 := NULL;
101: END IF;
102:
103: IF (p_index_constraint_tbl(i).attribute7 = pn_index_rent_utils.g_pn_miss_char)
104: THEN
105: p_index_constraint_tbl(i).attribute7 := NULL;
106: END IF;
107:
104: THEN
105: p_index_constraint_tbl(i).attribute7 := NULL;
106: END IF;
107:
108: IF (p_index_constraint_tbl(i).attribute8 = pn_index_rent_utils.g_pn_miss_char)
109: THEN
110: p_index_constraint_tbl(i).attribute8 := NULL;
111: END IF;
112:
109: THEN
110: p_index_constraint_tbl(i).attribute8 := NULL;
111: END IF;
112:
113: IF (p_index_constraint_tbl(i).attribute9 = pn_index_rent_utils.g_pn_miss_char)
114: THEN
115: p_index_constraint_tbl(i).attribute9 := NULL;
116: END IF;
117:
114: THEN
115: p_index_constraint_tbl(i).attribute9 := NULL;
116: END IF;
117:
118: IF (p_index_constraint_tbl(i).attribute10 = pn_index_rent_utils.g_pn_miss_char)
119: THEN
120: p_index_constraint_tbl(i).attribute10 := NULL;
121: END IF;
122:
119: THEN
120: p_index_constraint_tbl(i).attribute10 := NULL;
121: END IF;
122:
123: IF (p_index_constraint_tbl(i).attribute11 = pn_index_rent_utils.g_pn_miss_char)
124: THEN
125: p_index_constraint_tbl(i).attribute11 := NULL;
126: END IF;
127:
124: THEN
125: p_index_constraint_tbl(i).attribute11 := NULL;
126: END IF;
127:
128: IF (p_index_constraint_tbl(i).attribute12 = pn_index_rent_utils.g_pn_miss_char)
129: THEN
130: p_index_constraint_tbl(i).attribute12 := NULL;
131: END IF;
132:
129: THEN
130: p_index_constraint_tbl(i).attribute12 := NULL;
131: END IF;
132:
133: IF (p_index_constraint_tbl(i).attribute13 = pn_index_rent_utils.g_pn_miss_char)
134: THEN
135: p_index_constraint_tbl(i).attribute13 := NULL;
136: END IF;
137:
134: THEN
135: p_index_constraint_tbl(i).attribute13 := NULL;
136: END IF;
137:
138: IF (p_index_constraint_tbl(i).attribute14 = pn_index_rent_utils.g_pn_miss_char)
139: THEN
140: p_index_constraint_tbl(i).attribute14 := NULL;
141: END IF;
142:
139: THEN
140: p_index_constraint_tbl(i).attribute14 := NULL;
141: END IF;
142:
143: IF (p_index_constraint_tbl(i).attribute15 = pn_index_rent_utils.g_pn_miss_char)
144: THEN
145: p_index_constraint_tbl(i).attribute15 := NULL;
146: END IF;
147:
147:
148:
149: IF (get_attribute_status('PN_INDEX_CONSTRAINTS') > 0)
150: THEN
151: IF NOT ((p_index_constraint_tbl(i).attribute_category = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute_category IS NULL)
152: AND (p_index_constraint_tbl(i).attribute1 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute1 IS NULL)
153: AND (p_index_constraint_tbl(i).attribute2 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute2 IS NULL)
154: AND (p_index_constraint_tbl(i).attribute3 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute3 IS NULL)
155: AND (p_index_constraint_tbl(i).attribute4 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute4 IS NULL)
148:
149: IF (get_attribute_status('PN_INDEX_CONSTRAINTS') > 0)
150: THEN
151: IF NOT ((p_index_constraint_tbl(i).attribute_category = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute_category IS NULL)
152: AND (p_index_constraint_tbl(i).attribute1 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute1 IS NULL)
153: AND (p_index_constraint_tbl(i).attribute2 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute2 IS NULL)
154: AND (p_index_constraint_tbl(i).attribute3 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute3 IS NULL)
155: AND (p_index_constraint_tbl(i).attribute4 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute4 IS NULL)
156: AND (p_index_constraint_tbl(i).attribute5 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute5 IS NULL)
149: IF (get_attribute_status('PN_INDEX_CONSTRAINTS') > 0)
150: THEN
151: IF NOT ((p_index_constraint_tbl(i).attribute_category = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute_category IS NULL)
152: AND (p_index_constraint_tbl(i).attribute1 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute1 IS NULL)
153: AND (p_index_constraint_tbl(i).attribute2 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute2 IS NULL)
154: AND (p_index_constraint_tbl(i).attribute3 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute3 IS NULL)
155: AND (p_index_constraint_tbl(i).attribute4 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute4 IS NULL)
156: AND (p_index_constraint_tbl(i).attribute5 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute5 IS NULL)
157: AND (p_index_constraint_tbl(i).attribute6 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute6 IS NULL)
150: THEN
151: IF NOT ((p_index_constraint_tbl(i).attribute_category = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute_category IS NULL)
152: AND (p_index_constraint_tbl(i).attribute1 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute1 IS NULL)
153: AND (p_index_constraint_tbl(i).attribute2 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute2 IS NULL)
154: AND (p_index_constraint_tbl(i).attribute3 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute3 IS NULL)
155: AND (p_index_constraint_tbl(i).attribute4 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute4 IS NULL)
156: AND (p_index_constraint_tbl(i).attribute5 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute5 IS NULL)
157: AND (p_index_constraint_tbl(i).attribute6 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute6 IS NULL)
158: AND (p_index_constraint_tbl(i).attribute7 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute7 IS NULL)
151: IF NOT ((p_index_constraint_tbl(i).attribute_category = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute_category IS NULL)
152: AND (p_index_constraint_tbl(i).attribute1 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute1 IS NULL)
153: AND (p_index_constraint_tbl(i).attribute2 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute2 IS NULL)
154: AND (p_index_constraint_tbl(i).attribute3 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute3 IS NULL)
155: AND (p_index_constraint_tbl(i).attribute4 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute4 IS NULL)
156: AND (p_index_constraint_tbl(i).attribute5 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute5 IS NULL)
157: AND (p_index_constraint_tbl(i).attribute6 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute6 IS NULL)
158: AND (p_index_constraint_tbl(i).attribute7 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute7 IS NULL)
159: AND (p_index_constraint_tbl(i).attribute8 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute8 IS NULL)
152: AND (p_index_constraint_tbl(i).attribute1 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute1 IS NULL)
153: AND (p_index_constraint_tbl(i).attribute2 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute2 IS NULL)
154: AND (p_index_constraint_tbl(i).attribute3 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute3 IS NULL)
155: AND (p_index_constraint_tbl(i).attribute4 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute4 IS NULL)
156: AND (p_index_constraint_tbl(i).attribute5 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute5 IS NULL)
157: AND (p_index_constraint_tbl(i).attribute6 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute6 IS NULL)
158: AND (p_index_constraint_tbl(i).attribute7 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute7 IS NULL)
159: AND (p_index_constraint_tbl(i).attribute8 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute8 IS NULL)
160: AND (p_index_constraint_tbl(i).attribute9 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute9 IS NULL)
153: AND (p_index_constraint_tbl(i).attribute2 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute2 IS NULL)
154: AND (p_index_constraint_tbl(i).attribute3 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute3 IS NULL)
155: AND (p_index_constraint_tbl(i).attribute4 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute4 IS NULL)
156: AND (p_index_constraint_tbl(i).attribute5 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute5 IS NULL)
157: AND (p_index_constraint_tbl(i).attribute6 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute6 IS NULL)
158: AND (p_index_constraint_tbl(i).attribute7 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute7 IS NULL)
159: AND (p_index_constraint_tbl(i).attribute8 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute8 IS NULL)
160: AND (p_index_constraint_tbl(i).attribute9 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute9 IS NULL)
161: AND (p_index_constraint_tbl(i).attribute10 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute10 IS NULL)
154: AND (p_index_constraint_tbl(i).attribute3 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute3 IS NULL)
155: AND (p_index_constraint_tbl(i).attribute4 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute4 IS NULL)
156: AND (p_index_constraint_tbl(i).attribute5 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute5 IS NULL)
157: AND (p_index_constraint_tbl(i).attribute6 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute6 IS NULL)
158: AND (p_index_constraint_tbl(i).attribute7 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute7 IS NULL)
159: AND (p_index_constraint_tbl(i).attribute8 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute8 IS NULL)
160: AND (p_index_constraint_tbl(i).attribute9 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute9 IS NULL)
161: AND (p_index_constraint_tbl(i).attribute10 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute10 IS NULL)
162: AND (p_index_constraint_tbl(i).attribute11 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute11 IS NULL)
155: AND (p_index_constraint_tbl(i).attribute4 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute4 IS NULL)
156: AND (p_index_constraint_tbl(i).attribute5 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute5 IS NULL)
157: AND (p_index_constraint_tbl(i).attribute6 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute6 IS NULL)
158: AND (p_index_constraint_tbl(i).attribute7 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute7 IS NULL)
159: AND (p_index_constraint_tbl(i).attribute8 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute8 IS NULL)
160: AND (p_index_constraint_tbl(i).attribute9 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute9 IS NULL)
161: AND (p_index_constraint_tbl(i).attribute10 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute10 IS NULL)
162: AND (p_index_constraint_tbl(i).attribute11 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute11 IS NULL)
163: AND (p_index_constraint_tbl(i).attribute12 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute12 IS NULL)
156: AND (p_index_constraint_tbl(i).attribute5 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute5 IS NULL)
157: AND (p_index_constraint_tbl(i).attribute6 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute6 IS NULL)
158: AND (p_index_constraint_tbl(i).attribute7 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute7 IS NULL)
159: AND (p_index_constraint_tbl(i).attribute8 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute8 IS NULL)
160: AND (p_index_constraint_tbl(i).attribute9 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute9 IS NULL)
161: AND (p_index_constraint_tbl(i).attribute10 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute10 IS NULL)
162: AND (p_index_constraint_tbl(i).attribute11 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute11 IS NULL)
163: AND (p_index_constraint_tbl(i).attribute12 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute12 IS NULL)
164: AND (p_index_constraint_tbl(i).attribute13 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute13 IS NULL)
157: AND (p_index_constraint_tbl(i).attribute6 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute6 IS NULL)
158: AND (p_index_constraint_tbl(i).attribute7 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute7 IS NULL)
159: AND (p_index_constraint_tbl(i).attribute8 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute8 IS NULL)
160: AND (p_index_constraint_tbl(i).attribute9 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute9 IS NULL)
161: AND (p_index_constraint_tbl(i).attribute10 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute10 IS NULL)
162: AND (p_index_constraint_tbl(i).attribute11 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute11 IS NULL)
163: AND (p_index_constraint_tbl(i).attribute12 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute12 IS NULL)
164: AND (p_index_constraint_tbl(i).attribute13 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute13 IS NULL)
165: AND (p_index_constraint_tbl(i).attribute14 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute14 IS NULL)
158: AND (p_index_constraint_tbl(i).attribute7 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute7 IS NULL)
159: AND (p_index_constraint_tbl(i).attribute8 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute8 IS NULL)
160: AND (p_index_constraint_tbl(i).attribute9 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute9 IS NULL)
161: AND (p_index_constraint_tbl(i).attribute10 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute10 IS NULL)
162: AND (p_index_constraint_tbl(i).attribute11 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute11 IS NULL)
163: AND (p_index_constraint_tbl(i).attribute12 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute12 IS NULL)
164: AND (p_index_constraint_tbl(i).attribute13 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute13 IS NULL)
165: AND (p_index_constraint_tbl(i).attribute14 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute14 IS NULL)
166: AND (p_index_constraint_tbl(i).attribute15 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute15 IS NULL)
159: AND (p_index_constraint_tbl(i).attribute8 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute8 IS NULL)
160: AND (p_index_constraint_tbl(i).attribute9 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute9 IS NULL)
161: AND (p_index_constraint_tbl(i).attribute10 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute10 IS NULL)
162: AND (p_index_constraint_tbl(i).attribute11 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute11 IS NULL)
163: AND (p_index_constraint_tbl(i).attribute12 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute12 IS NULL)
164: AND (p_index_constraint_tbl(i).attribute13 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute13 IS NULL)
165: AND (p_index_constraint_tbl(i).attribute14 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute14 IS NULL)
166: AND (p_index_constraint_tbl(i).attribute15 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute15 IS NULL)
167: )
160: AND (p_index_constraint_tbl(i).attribute9 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute9 IS NULL)
161: AND (p_index_constraint_tbl(i).attribute10 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute10 IS NULL)
162: AND (p_index_constraint_tbl(i).attribute11 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute11 IS NULL)
163: AND (p_index_constraint_tbl(i).attribute12 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute12 IS NULL)
164: AND (p_index_constraint_tbl(i).attribute13 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute13 IS NULL)
165: AND (p_index_constraint_tbl(i).attribute14 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute14 IS NULL)
166: AND (p_index_constraint_tbl(i).attribute15 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute15 IS NULL)
167: )
168: THEN
161: AND (p_index_constraint_tbl(i).attribute10 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute10 IS NULL)
162: AND (p_index_constraint_tbl(i).attribute11 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute11 IS NULL)
163: AND (p_index_constraint_tbl(i).attribute12 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute12 IS NULL)
164: AND (p_index_constraint_tbl(i).attribute13 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute13 IS NULL)
165: AND (p_index_constraint_tbl(i).attribute14 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute14 IS NULL)
166: AND (p_index_constraint_tbl(i).attribute15 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute15 IS NULL)
167: )
168: THEN
169:
162: AND (p_index_constraint_tbl(i).attribute11 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute11 IS NULL)
163: AND (p_index_constraint_tbl(i).attribute12 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute12 IS NULL)
164: AND (p_index_constraint_tbl(i).attribute13 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute13 IS NULL)
165: AND (p_index_constraint_tbl(i).attribute14 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute14 IS NULL)
166: AND (p_index_constraint_tbl(i).attribute15 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute15 IS NULL)
167: )
168: THEN
169:
170: pn_lease_utils.validate_desc_flex (p_api_name => g_pkg_name||'.'||g_program_unit
221: IS
222:
223: BEGIN
224:
225: IF (p_rent_index_rec.attribute_category = pn_index_rent_utils.g_pn_miss_char)
226: THEN
227: p_rent_index_rec.attribute_category := NULL;
228: END IF;
229:
226: THEN
227: p_rent_index_rec.attribute_category := NULL;
228: END IF;
229:
230: IF (p_rent_index_rec.attribute1 = pn_index_rent_utils.g_pn_miss_char)
231: THEN
232: p_rent_index_rec.attribute1 := NULL;
233: END IF;
234:
231: THEN
232: p_rent_index_rec.attribute1 := NULL;
233: END IF;
234:
235: IF (p_rent_index_rec.attribute2 = pn_index_rent_utils.g_pn_miss_char)
236: THEN
237: p_rent_index_rec.attribute2 := NULL;
238: END IF;
239:
236: THEN
237: p_rent_index_rec.attribute2 := NULL;
238: END IF;
239:
240: IF (p_rent_index_rec.attribute3 = pn_index_rent_utils.g_pn_miss_char)
241: THEN
242: p_rent_index_rec.attribute3 := NULL;
243: END IF;
244:
241: THEN
242: p_rent_index_rec.attribute3 := NULL;
243: END IF;
244:
245: IF (p_rent_index_rec.attribute4 = pn_index_rent_utils.g_pn_miss_char)
246: THEN
247: p_rent_index_rec.attribute4 := NULL;
248: END IF;
249:
246: THEN
247: p_rent_index_rec.attribute4 := NULL;
248: END IF;
249:
250: IF (p_rent_index_rec.attribute5 = pn_index_rent_utils.g_pn_miss_char)
251: THEN
252: p_rent_index_rec.attribute5 := NULL;
253: END IF;
254:
251: THEN
252: p_rent_index_rec.attribute5 := NULL;
253: END IF;
254:
255: IF (p_rent_index_rec.attribute6 = pn_index_rent_utils.g_pn_miss_char)
256: THEN
257: p_rent_index_rec.attribute6 := NULL;
258: END IF;
259:
256: THEN
257: p_rent_index_rec.attribute6 := NULL;
258: END IF;
259:
260: IF (p_rent_index_rec.attribute7 = pn_index_rent_utils.g_pn_miss_char)
261: THEN
262: p_rent_index_rec.attribute7 := NULL;
263: END IF;
264:
261: THEN
262: p_rent_index_rec.attribute7 := NULL;
263: END IF;
264:
265: IF (p_rent_index_rec.attribute8 = pn_index_rent_utils.g_pn_miss_char)
266: THEN
267: p_rent_index_rec.attribute8 := NULL;
268: END IF;
269:
266: THEN
267: p_rent_index_rec.attribute8 := NULL;
268: END IF;
269:
270: IF (p_rent_index_rec.attribute9 = pn_index_rent_utils.g_pn_miss_char)
271: THEN
272: p_rent_index_rec.attribute9 := NULL;
273: END IF;
274:
271: THEN
272: p_rent_index_rec.attribute9 := NULL;
273: END IF;
274:
275: IF (p_rent_index_rec.attribute10 = pn_index_rent_utils.g_pn_miss_char)
276: THEN
277: p_rent_index_rec.attribute10 := NULL;
278: END IF;
279:
276: THEN
277: p_rent_index_rec.attribute10 := NULL;
278: END IF;
279:
280: IF (p_rent_index_rec.attribute11 = pn_index_rent_utils.g_pn_miss_char)
281: THEN
282: p_rent_index_rec.attribute11 := NULL;
283: END IF;
284:
281: THEN
282: p_rent_index_rec.attribute11 := NULL;
283: END IF;
284:
285: IF (p_rent_index_rec.attribute12 = pn_index_rent_utils.g_pn_miss_char)
286: THEN
287: p_rent_index_rec.attribute12 := NULL;
288: END IF;
289:
286: THEN
287: p_rent_index_rec.attribute12 := NULL;
288: END IF;
289:
290: IF (p_rent_index_rec.attribute13 = pn_index_rent_utils.g_pn_miss_char)
291: THEN
292: p_rent_index_rec.attribute13 := NULL;
293: END IF;
294:
291: THEN
292: p_rent_index_rec.attribute13 := NULL;
293: END IF;
294:
295: IF (p_rent_index_rec.attribute14 = pn_index_rent_utils.g_pn_miss_char)
296: THEN
297: p_rent_index_rec.attribute14 := NULL;
298: END IF;
299:
296: THEN
297: p_rent_index_rec.attribute14 := NULL;
298: END IF;
299:
300: IF (p_rent_index_rec.attribute15 = pn_index_rent_utils.g_pn_miss_char)
301: THEN
302: p_rent_index_rec.attribute15 := NULL;
303: END IF;
304:
304:
305:
306: IF (get_attribute_status('PN_INDEX_RENT') > 0)
307: THEN
308: IF NOT ((p_rent_index_rec.attribute_category = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute_category IS NULL)
309: AND (p_rent_index_rec.attribute1 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute1 IS NULL)
310: AND (p_rent_index_rec.attribute2 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute2 IS NULL)
311: AND (p_rent_index_rec.attribute3 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute3 IS NULL)
312: AND (p_rent_index_rec.attribute4 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute4 IS NULL)
305:
306: IF (get_attribute_status('PN_INDEX_RENT') > 0)
307: THEN
308: IF NOT ((p_rent_index_rec.attribute_category = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute_category IS NULL)
309: AND (p_rent_index_rec.attribute1 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute1 IS NULL)
310: AND (p_rent_index_rec.attribute2 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute2 IS NULL)
311: AND (p_rent_index_rec.attribute3 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute3 IS NULL)
312: AND (p_rent_index_rec.attribute4 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute4 IS NULL)
313: AND (p_rent_index_rec.attribute5 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute5 IS NULL)
306: IF (get_attribute_status('PN_INDEX_RENT') > 0)
307: THEN
308: IF NOT ((p_rent_index_rec.attribute_category = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute_category IS NULL)
309: AND (p_rent_index_rec.attribute1 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute1 IS NULL)
310: AND (p_rent_index_rec.attribute2 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute2 IS NULL)
311: AND (p_rent_index_rec.attribute3 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute3 IS NULL)
312: AND (p_rent_index_rec.attribute4 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute4 IS NULL)
313: AND (p_rent_index_rec.attribute5 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute5 IS NULL)
314: AND (p_rent_index_rec.attribute6 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute6 IS NULL)
307: THEN
308: IF NOT ((p_rent_index_rec.attribute_category = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute_category IS NULL)
309: AND (p_rent_index_rec.attribute1 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute1 IS NULL)
310: AND (p_rent_index_rec.attribute2 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute2 IS NULL)
311: AND (p_rent_index_rec.attribute3 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute3 IS NULL)
312: AND (p_rent_index_rec.attribute4 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute4 IS NULL)
313: AND (p_rent_index_rec.attribute5 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute5 IS NULL)
314: AND (p_rent_index_rec.attribute6 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute6 IS NULL)
315: AND (p_rent_index_rec.attribute7 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute7 IS NULL)
308: IF NOT ((p_rent_index_rec.attribute_category = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute_category IS NULL)
309: AND (p_rent_index_rec.attribute1 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute1 IS NULL)
310: AND (p_rent_index_rec.attribute2 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute2 IS NULL)
311: AND (p_rent_index_rec.attribute3 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute3 IS NULL)
312: AND (p_rent_index_rec.attribute4 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute4 IS NULL)
313: AND (p_rent_index_rec.attribute5 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute5 IS NULL)
314: AND (p_rent_index_rec.attribute6 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute6 IS NULL)
315: AND (p_rent_index_rec.attribute7 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute7 IS NULL)
316: AND (p_rent_index_rec.attribute8 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute8 IS NULL)
309: AND (p_rent_index_rec.attribute1 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute1 IS NULL)
310: AND (p_rent_index_rec.attribute2 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute2 IS NULL)
311: AND (p_rent_index_rec.attribute3 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute3 IS NULL)
312: AND (p_rent_index_rec.attribute4 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute4 IS NULL)
313: AND (p_rent_index_rec.attribute5 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute5 IS NULL)
314: AND (p_rent_index_rec.attribute6 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute6 IS NULL)
315: AND (p_rent_index_rec.attribute7 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute7 IS NULL)
316: AND (p_rent_index_rec.attribute8 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute8 IS NULL)
317: AND (p_rent_index_rec.attribute9 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute9 IS NULL)
310: AND (p_rent_index_rec.attribute2 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute2 IS NULL)
311: AND (p_rent_index_rec.attribute3 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute3 IS NULL)
312: AND (p_rent_index_rec.attribute4 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute4 IS NULL)
313: AND (p_rent_index_rec.attribute5 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute5 IS NULL)
314: AND (p_rent_index_rec.attribute6 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute6 IS NULL)
315: AND (p_rent_index_rec.attribute7 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute7 IS NULL)
316: AND (p_rent_index_rec.attribute8 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute8 IS NULL)
317: AND (p_rent_index_rec.attribute9 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute9 IS NULL)
318: AND (p_rent_index_rec.attribute10 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute10 IS NULL)
311: AND (p_rent_index_rec.attribute3 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute3 IS NULL)
312: AND (p_rent_index_rec.attribute4 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute4 IS NULL)
313: AND (p_rent_index_rec.attribute5 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute5 IS NULL)
314: AND (p_rent_index_rec.attribute6 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute6 IS NULL)
315: AND (p_rent_index_rec.attribute7 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute7 IS NULL)
316: AND (p_rent_index_rec.attribute8 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute8 IS NULL)
317: AND (p_rent_index_rec.attribute9 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute9 IS NULL)
318: AND (p_rent_index_rec.attribute10 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute10 IS NULL)
319: AND (p_rent_index_rec.attribute11 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute11 IS NULL)
312: AND (p_rent_index_rec.attribute4 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute4 IS NULL)
313: AND (p_rent_index_rec.attribute5 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute5 IS NULL)
314: AND (p_rent_index_rec.attribute6 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute6 IS NULL)
315: AND (p_rent_index_rec.attribute7 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute7 IS NULL)
316: AND (p_rent_index_rec.attribute8 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute8 IS NULL)
317: AND (p_rent_index_rec.attribute9 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute9 IS NULL)
318: AND (p_rent_index_rec.attribute10 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute10 IS NULL)
319: AND (p_rent_index_rec.attribute11 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute11 IS NULL)
320: AND (p_rent_index_rec.attribute12 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute12 IS NULL)
313: AND (p_rent_index_rec.attribute5 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute5 IS NULL)
314: AND (p_rent_index_rec.attribute6 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute6 IS NULL)
315: AND (p_rent_index_rec.attribute7 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute7 IS NULL)
316: AND (p_rent_index_rec.attribute8 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute8 IS NULL)
317: AND (p_rent_index_rec.attribute9 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute9 IS NULL)
318: AND (p_rent_index_rec.attribute10 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute10 IS NULL)
319: AND (p_rent_index_rec.attribute11 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute11 IS NULL)
320: AND (p_rent_index_rec.attribute12 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute12 IS NULL)
321: AND (p_rent_index_rec.attribute13 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute13 IS NULL)
314: AND (p_rent_index_rec.attribute6 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute6 IS NULL)
315: AND (p_rent_index_rec.attribute7 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute7 IS NULL)
316: AND (p_rent_index_rec.attribute8 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute8 IS NULL)
317: AND (p_rent_index_rec.attribute9 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute9 IS NULL)
318: AND (p_rent_index_rec.attribute10 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute10 IS NULL)
319: AND (p_rent_index_rec.attribute11 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute11 IS NULL)
320: AND (p_rent_index_rec.attribute12 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute12 IS NULL)
321: AND (p_rent_index_rec.attribute13 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute13 IS NULL)
322: AND (p_rent_index_rec.attribute14 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute14 IS NULL)
315: AND (p_rent_index_rec.attribute7 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute7 IS NULL)
316: AND (p_rent_index_rec.attribute8 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute8 IS NULL)
317: AND (p_rent_index_rec.attribute9 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute9 IS NULL)
318: AND (p_rent_index_rec.attribute10 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute10 IS NULL)
319: AND (p_rent_index_rec.attribute11 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute11 IS NULL)
320: AND (p_rent_index_rec.attribute12 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute12 IS NULL)
321: AND (p_rent_index_rec.attribute13 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute13 IS NULL)
322: AND (p_rent_index_rec.attribute14 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute14 IS NULL)
323: AND (p_rent_index_rec.attribute15 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute15 IS NULL)
316: AND (p_rent_index_rec.attribute8 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute8 IS NULL)
317: AND (p_rent_index_rec.attribute9 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute9 IS NULL)
318: AND (p_rent_index_rec.attribute10 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute10 IS NULL)
319: AND (p_rent_index_rec.attribute11 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute11 IS NULL)
320: AND (p_rent_index_rec.attribute12 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute12 IS NULL)
321: AND (p_rent_index_rec.attribute13 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute13 IS NULL)
322: AND (p_rent_index_rec.attribute14 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute14 IS NULL)
323: AND (p_rent_index_rec.attribute15 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute15 IS NULL)
324: )
317: AND (p_rent_index_rec.attribute9 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute9 IS NULL)
318: AND (p_rent_index_rec.attribute10 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute10 IS NULL)
319: AND (p_rent_index_rec.attribute11 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute11 IS NULL)
320: AND (p_rent_index_rec.attribute12 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute12 IS NULL)
321: AND (p_rent_index_rec.attribute13 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute13 IS NULL)
322: AND (p_rent_index_rec.attribute14 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute14 IS NULL)
323: AND (p_rent_index_rec.attribute15 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute15 IS NULL)
324: )
325: THEN
318: AND (p_rent_index_rec.attribute10 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute10 IS NULL)
319: AND (p_rent_index_rec.attribute11 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute11 IS NULL)
320: AND (p_rent_index_rec.attribute12 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute12 IS NULL)
321: AND (p_rent_index_rec.attribute13 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute13 IS NULL)
322: AND (p_rent_index_rec.attribute14 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute14 IS NULL)
323: AND (p_rent_index_rec.attribute15 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute15 IS NULL)
324: )
325: THEN
326:
319: AND (p_rent_index_rec.attribute11 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute11 IS NULL)
320: AND (p_rent_index_rec.attribute12 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute12 IS NULL)
321: AND (p_rent_index_rec.attribute13 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute13 IS NULL)
322: AND (p_rent_index_rec.attribute14 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute14 IS NULL)
323: AND (p_rent_index_rec.attribute15 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute15 IS NULL)
324: )
325: THEN
326:
327: pn_lease_utils.validate_desc_flex ( p_api_name => g_pkg_name||'.'||g_program_unit
363: END IF;
364: END IF; -- End of attributes valitions in Index Rent attribute
365:
366:
367: IF (p_rent_index_rec.agreement_category = pn_index_rent_utils.g_pn_miss_char)
368: THEN
369: p_rent_index_rec.agreement_category := NULL;
370: END IF;
371:
368: THEN
369: p_rent_index_rec.agreement_category := NULL;
370: END IF;
371:
372: IF (p_rent_index_rec.agreement_attribute1 = pn_index_rent_utils.g_pn_miss_char)
373: THEN
374: p_rent_index_rec.agreement_attribute1 := NULL;
375: END IF;
376:
373: THEN
374: p_rent_index_rec.agreement_attribute1 := NULL;
375: END IF;
376:
377: IF (p_rent_index_rec.agreement_attribute2 = pn_index_rent_utils.g_pn_miss_char)
378: THEN
379: p_rent_index_rec.agreement_attribute2 := NULL;
380: END IF;
381:
378: THEN
379: p_rent_index_rec.agreement_attribute2 := NULL;
380: END IF;
381:
382: IF (p_rent_index_rec.agreement_attribute3 = pn_index_rent_utils.g_pn_miss_char)
383: THEN
384: p_rent_index_rec.agreement_attribute3 := NULL;
385: END IF;
386:
383: THEN
384: p_rent_index_rec.agreement_attribute3 := NULL;
385: END IF;
386:
387: IF (p_rent_index_rec.agreement_attribute4 = pn_index_rent_utils.g_pn_miss_char)
388: THEN
389: p_rent_index_rec.agreement_attribute4 := NULL;
390: END IF;
391:
388: THEN
389: p_rent_index_rec.agreement_attribute4 := NULL;
390: END IF;
391:
392: IF (p_rent_index_rec.agreement_attribute5 = pn_index_rent_utils.g_pn_miss_char)
393: THEN
394: p_rent_index_rec.agreement_attribute5 := NULL;
395: END IF;
396:
393: THEN
394: p_rent_index_rec.agreement_attribute5 := NULL;
395: END IF;
396:
397: IF (p_rent_index_rec.agreement_attribute6 = pn_index_rent_utils.g_pn_miss_char)
398: THEN
399: p_rent_index_rec.agreement_attribute6 := NULL;
400: END IF;
401:
398: THEN
399: p_rent_index_rec.agreement_attribute6 := NULL;
400: END IF;
401:
402: IF (p_rent_index_rec.agreement_attribute7 = pn_index_rent_utils.g_pn_miss_char)
403: THEN
404: p_rent_index_rec.agreement_attribute7 := NULL;
405: END IF;
406:
403: THEN
404: p_rent_index_rec.agreement_attribute7 := NULL;
405: END IF;
406:
407: IF (p_rent_index_rec.agreement_attribute8 = pn_index_rent_utils.g_pn_miss_char)
408: THEN
409: p_rent_index_rec.agreement_attribute8 := NULL;
410: END IF;
411:
408: THEN
409: p_rent_index_rec.agreement_attribute8 := NULL;
410: END IF;
411:
412: IF (p_rent_index_rec.agreement_attribute9 = pn_index_rent_utils.g_pn_miss_char)
413: THEN
414: p_rent_index_rec.agreement_attribute9 := NULL;
415: END IF;
416:
413: THEN
414: p_rent_index_rec.agreement_attribute9 := NULL;
415: END IF;
416:
417: IF (p_rent_index_rec.agreement_attribute10 = pn_index_rent_utils.g_pn_miss_char)
418: THEN
419: p_rent_index_rec.agreement_attribute10 := NULL;
420: END IF;
421:
418: THEN
419: p_rent_index_rec.agreement_attribute10 := NULL;
420: END IF;
421:
422: IF (p_rent_index_rec.agreement_attribute11 = pn_index_rent_utils.g_pn_miss_char)
423: THEN
424: p_rent_index_rec.agreement_attribute11 := NULL;
425: END IF;
426:
423: THEN
424: p_rent_index_rec.agreement_attribute11 := NULL;
425: END IF;
426:
427: IF (p_rent_index_rec.agreement_attribute12 = pn_index_rent_utils.g_pn_miss_char)
428: THEN
429: p_rent_index_rec.agreement_attribute12 := NULL;
430: END IF;
431:
428: THEN
429: p_rent_index_rec.agreement_attribute12 := NULL;
430: END IF;
431:
432: IF (p_rent_index_rec.agreement_attribute13 = pn_index_rent_utils.g_pn_miss_char)
433: THEN
434: p_rent_index_rec.agreement_attribute13 := NULL;
435: END IF;
436:
433: THEN
434: p_rent_index_rec.agreement_attribute13 := NULL;
435: END IF;
436:
437: IF (p_rent_index_rec.agreement_attribute14 = pn_index_rent_utils.g_pn_miss_char)
438: THEN
439: p_rent_index_rec.agreement_attribute14 := NULL;
440: END IF;
441:
438: THEN
439: p_rent_index_rec.agreement_attribute14 := NULL;
440: END IF;
441:
442: IF (p_rent_index_rec.agreement_attribute15 = pn_index_rent_utils.g_pn_miss_char)
443: THEN
444: p_rent_index_rec.agreement_attribute15 := NULL;
445: END IF;
446:
446:
447:
448: IF (get_attribute_status('PN_INDEX_AGREEMENT') > 0)
449: THEN
450: IF NOT ((p_rent_index_rec.agreement_category = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_category IS NULL)
451: AND (p_rent_index_rec.agreement_attribute1 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute1 IS NULL)
452: AND (p_rent_index_rec.agreement_attribute2 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute2 IS NULL)
453: AND (p_rent_index_rec.agreement_attribute3 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute3 IS NULL)
454: AND (p_rent_index_rec.agreement_attribute4 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute4 IS NULL)
447:
448: IF (get_attribute_status('PN_INDEX_AGREEMENT') > 0)
449: THEN
450: IF NOT ((p_rent_index_rec.agreement_category = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_category IS NULL)
451: AND (p_rent_index_rec.agreement_attribute1 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute1 IS NULL)
452: AND (p_rent_index_rec.agreement_attribute2 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute2 IS NULL)
453: AND (p_rent_index_rec.agreement_attribute3 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute3 IS NULL)
454: AND (p_rent_index_rec.agreement_attribute4 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute4 IS NULL)
455: AND (p_rent_index_rec.agreement_attribute5 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute5 IS NULL)
448: IF (get_attribute_status('PN_INDEX_AGREEMENT') > 0)
449: THEN
450: IF NOT ((p_rent_index_rec.agreement_category = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_category IS NULL)
451: AND (p_rent_index_rec.agreement_attribute1 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute1 IS NULL)
452: AND (p_rent_index_rec.agreement_attribute2 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute2 IS NULL)
453: AND (p_rent_index_rec.agreement_attribute3 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute3 IS NULL)
454: AND (p_rent_index_rec.agreement_attribute4 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute4 IS NULL)
455: AND (p_rent_index_rec.agreement_attribute5 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute5 IS NULL)
456: AND (p_rent_index_rec.agreement_attribute6 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute6 IS NULL)
449: THEN
450: IF NOT ((p_rent_index_rec.agreement_category = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_category IS NULL)
451: AND (p_rent_index_rec.agreement_attribute1 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute1 IS NULL)
452: AND (p_rent_index_rec.agreement_attribute2 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute2 IS NULL)
453: AND (p_rent_index_rec.agreement_attribute3 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute3 IS NULL)
454: AND (p_rent_index_rec.agreement_attribute4 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute4 IS NULL)
455: AND (p_rent_index_rec.agreement_attribute5 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute5 IS NULL)
456: AND (p_rent_index_rec.agreement_attribute6 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute6 IS NULL)
457: AND (p_rent_index_rec.agreement_attribute7 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute7 IS NULL)
450: IF NOT ((p_rent_index_rec.agreement_category = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_category IS NULL)
451: AND (p_rent_index_rec.agreement_attribute1 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute1 IS NULL)
452: AND (p_rent_index_rec.agreement_attribute2 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute2 IS NULL)
453: AND (p_rent_index_rec.agreement_attribute3 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute3 IS NULL)
454: AND (p_rent_index_rec.agreement_attribute4 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute4 IS NULL)
455: AND (p_rent_index_rec.agreement_attribute5 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute5 IS NULL)
456: AND (p_rent_index_rec.agreement_attribute6 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute6 IS NULL)
457: AND (p_rent_index_rec.agreement_attribute7 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute7 IS NULL)
458: AND (p_rent_index_rec.agreement_attribute8 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute8 IS NULL)
451: AND (p_rent_index_rec.agreement_attribute1 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute1 IS NULL)
452: AND (p_rent_index_rec.agreement_attribute2 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute2 IS NULL)
453: AND (p_rent_index_rec.agreement_attribute3 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute3 IS NULL)
454: AND (p_rent_index_rec.agreement_attribute4 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute4 IS NULL)
455: AND (p_rent_index_rec.agreement_attribute5 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute5 IS NULL)
456: AND (p_rent_index_rec.agreement_attribute6 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute6 IS NULL)
457: AND (p_rent_index_rec.agreement_attribute7 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute7 IS NULL)
458: AND (p_rent_index_rec.agreement_attribute8 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute8 IS NULL)
459: AND (p_rent_index_rec.agreement_attribute9 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute9 IS NULL)
452: AND (p_rent_index_rec.agreement_attribute2 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute2 IS NULL)
453: AND (p_rent_index_rec.agreement_attribute3 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute3 IS NULL)
454: AND (p_rent_index_rec.agreement_attribute4 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute4 IS NULL)
455: AND (p_rent_index_rec.agreement_attribute5 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute5 IS NULL)
456: AND (p_rent_index_rec.agreement_attribute6 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute6 IS NULL)
457: AND (p_rent_index_rec.agreement_attribute7 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute7 IS NULL)
458: AND (p_rent_index_rec.agreement_attribute8 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute8 IS NULL)
459: AND (p_rent_index_rec.agreement_attribute9 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute9 IS NULL)
460: AND (p_rent_index_rec.agreement_attribute10 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute10 IS NULL)
453: AND (p_rent_index_rec.agreement_attribute3 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute3 IS NULL)
454: AND (p_rent_index_rec.agreement_attribute4 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute4 IS NULL)
455: AND (p_rent_index_rec.agreement_attribute5 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute5 IS NULL)
456: AND (p_rent_index_rec.agreement_attribute6 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute6 IS NULL)
457: AND (p_rent_index_rec.agreement_attribute7 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute7 IS NULL)
458: AND (p_rent_index_rec.agreement_attribute8 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute8 IS NULL)
459: AND (p_rent_index_rec.agreement_attribute9 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute9 IS NULL)
460: AND (p_rent_index_rec.agreement_attribute10 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute10 IS NULL)
461: AND (p_rent_index_rec.agreement_attribute11 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute11 IS NULL)
454: AND (p_rent_index_rec.agreement_attribute4 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute4 IS NULL)
455: AND (p_rent_index_rec.agreement_attribute5 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute5 IS NULL)
456: AND (p_rent_index_rec.agreement_attribute6 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute6 IS NULL)
457: AND (p_rent_index_rec.agreement_attribute7 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute7 IS NULL)
458: AND (p_rent_index_rec.agreement_attribute8 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute8 IS NULL)
459: AND (p_rent_index_rec.agreement_attribute9 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute9 IS NULL)
460: AND (p_rent_index_rec.agreement_attribute10 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute10 IS NULL)
461: AND (p_rent_index_rec.agreement_attribute11 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute11 IS NULL)
462: AND (p_rent_index_rec.agreement_attribute12 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute12 IS NULL)
455: AND (p_rent_index_rec.agreement_attribute5 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute5 IS NULL)
456: AND (p_rent_index_rec.agreement_attribute6 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute6 IS NULL)
457: AND (p_rent_index_rec.agreement_attribute7 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute7 IS NULL)
458: AND (p_rent_index_rec.agreement_attribute8 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute8 IS NULL)
459: AND (p_rent_index_rec.agreement_attribute9 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute9 IS NULL)
460: AND (p_rent_index_rec.agreement_attribute10 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute10 IS NULL)
461: AND (p_rent_index_rec.agreement_attribute11 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute11 IS NULL)
462: AND (p_rent_index_rec.agreement_attribute12 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute12 IS NULL)
463: AND (p_rent_index_rec.agreement_attribute13 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute13 IS NULL)
456: AND (p_rent_index_rec.agreement_attribute6 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute6 IS NULL)
457: AND (p_rent_index_rec.agreement_attribute7 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute7 IS NULL)
458: AND (p_rent_index_rec.agreement_attribute8 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute8 IS NULL)
459: AND (p_rent_index_rec.agreement_attribute9 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute9 IS NULL)
460: AND (p_rent_index_rec.agreement_attribute10 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute10 IS NULL)
461: AND (p_rent_index_rec.agreement_attribute11 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute11 IS NULL)
462: AND (p_rent_index_rec.agreement_attribute12 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute12 IS NULL)
463: AND (p_rent_index_rec.agreement_attribute13 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute13 IS NULL)
464: AND (p_rent_index_rec.agreement_attribute14 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute14 IS NULL)
457: AND (p_rent_index_rec.agreement_attribute7 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute7 IS NULL)
458: AND (p_rent_index_rec.agreement_attribute8 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute8 IS NULL)
459: AND (p_rent_index_rec.agreement_attribute9 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute9 IS NULL)
460: AND (p_rent_index_rec.agreement_attribute10 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute10 IS NULL)
461: AND (p_rent_index_rec.agreement_attribute11 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute11 IS NULL)
462: AND (p_rent_index_rec.agreement_attribute12 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute12 IS NULL)
463: AND (p_rent_index_rec.agreement_attribute13 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute13 IS NULL)
464: AND (p_rent_index_rec.agreement_attribute14 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute14 IS NULL)
465: AND (p_rent_index_rec.agreement_attribute15 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute15 IS NULL)
458: AND (p_rent_index_rec.agreement_attribute8 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute8 IS NULL)
459: AND (p_rent_index_rec.agreement_attribute9 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute9 IS NULL)
460: AND (p_rent_index_rec.agreement_attribute10 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute10 IS NULL)
461: AND (p_rent_index_rec.agreement_attribute11 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute11 IS NULL)
462: AND (p_rent_index_rec.agreement_attribute12 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute12 IS NULL)
463: AND (p_rent_index_rec.agreement_attribute13 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute13 IS NULL)
464: AND (p_rent_index_rec.agreement_attribute14 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute14 IS NULL)
465: AND (p_rent_index_rec.agreement_attribute15 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute15 IS NULL)
466: )
459: AND (p_rent_index_rec.agreement_attribute9 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute9 IS NULL)
460: AND (p_rent_index_rec.agreement_attribute10 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute10 IS NULL)
461: AND (p_rent_index_rec.agreement_attribute11 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute11 IS NULL)
462: AND (p_rent_index_rec.agreement_attribute12 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute12 IS NULL)
463: AND (p_rent_index_rec.agreement_attribute13 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute13 IS NULL)
464: AND (p_rent_index_rec.agreement_attribute14 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute14 IS NULL)
465: AND (p_rent_index_rec.agreement_attribute15 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute15 IS NULL)
466: )
467: THEN
460: AND (p_rent_index_rec.agreement_attribute10 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute10 IS NULL)
461: AND (p_rent_index_rec.agreement_attribute11 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute11 IS NULL)
462: AND (p_rent_index_rec.agreement_attribute12 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute12 IS NULL)
463: AND (p_rent_index_rec.agreement_attribute13 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute13 IS NULL)
464: AND (p_rent_index_rec.agreement_attribute14 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute14 IS NULL)
465: AND (p_rent_index_rec.agreement_attribute15 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute15 IS NULL)
466: )
467: THEN
468:
461: AND (p_rent_index_rec.agreement_attribute11 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute11 IS NULL)
462: AND (p_rent_index_rec.agreement_attribute12 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute12 IS NULL)
463: AND (p_rent_index_rec.agreement_attribute13 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute13 IS NULL)
464: AND (p_rent_index_rec.agreement_attribute14 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute14 IS NULL)
465: AND (p_rent_index_rec.agreement_attribute15 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute15 IS NULL)
466: )
467: THEN
468:
469: pn_lease_utils.validate_desc_flex ( p_api_name => g_pkg_name||'.'||g_program_unit
521: g_program_unit := 'INIT_INDEX_CONSTRAINT_REC';
522:
523: x_return_status := fnd_api.g_ret_sts_success;
524:
525: IF p_index_constraint_rec.index_constraint_id = pn_index_rent_utils.g_pn_miss_num
526: THEN
527: p_index_constraint_rec.index_constraint_id := NULL;
528: END IF;
529:
526: THEN
527: p_index_constraint_rec.index_constraint_id := NULL;
528: END IF;
529:
530: IF p_index_constraint_rec.index_lease_id = pn_index_rent_utils.g_pn_miss_num
531: THEN
532: p_index_constraint_rec.index_lease_id := NULL;
533: END IF;
534:
531: THEN
532: p_index_constraint_rec.index_lease_id := NULL;
533: END IF;
534:
535: IF p_index_constraint_rec.index_lease_number = pn_index_rent_utils.g_pn_miss_char
536: THEN
537: p_index_constraint_rec.index_lease_number := NULL;
538: END IF;
539:
536: THEN
537: p_index_constraint_rec.index_lease_number := NULL;
538: END IF;
539:
540: IF p_index_constraint_rec.SCOPE = pn_index_rent_utils.g_pn_miss_char
541: THEN
542: p_index_constraint_rec.SCOPE := NULL;
543: END IF;
544:
541: THEN
542: p_index_constraint_rec.SCOPE := NULL;
543: END IF;
544:
545: IF p_index_constraint_rec.scope_meaning = pn_index_rent_utils.g_pn_miss_char
546: THEN
547: p_index_constraint_rec.scope_meaning := NULL;
548: END IF;
549:
546: THEN
547: p_index_constraint_rec.scope_meaning := NULL;
548: END IF;
549:
550: IF p_index_constraint_rec.minimum_amount = pn_index_rent_utils.g_pn_miss_num
551: THEN
552: p_index_constraint_rec.minimum_amount := NULL;
553: END IF;
554:
551: THEN
552: p_index_constraint_rec.minimum_amount := NULL;
553: END IF;
554:
555: IF p_index_constraint_rec.maximum_amount = pn_index_rent_utils.g_pn_miss_num
556: THEN
557: p_index_constraint_rec.maximum_amount := NULL;
558: END IF;
559:
556: THEN
557: p_index_constraint_rec.maximum_amount := NULL;
558: END IF;
559:
560: IF p_index_constraint_rec.minimum_percent = pn_index_rent_utils.g_pn_miss_num
561: THEN
562: p_index_constraint_rec.minimum_percent := NULL;
563: END IF;
564:
561: THEN
562: p_index_constraint_rec.minimum_percent := NULL;
563: END IF;
564:
565: IF p_index_constraint_rec.maximum_percent = pn_index_rent_utils.g_pn_miss_num
566: THEN
567: p_index_constraint_rec.maximum_percent := NULL;
568: END IF;
569:
566: THEN
567: p_index_constraint_rec.maximum_percent := NULL;
568: END IF;
569:
570: IF p_index_constraint_rec.last_update_date = pn_index_rent_utils.g_pn_miss_date
571: THEN
572: p_index_constraint_rec.last_update_date := NULL;
573: END IF;
574:
571: THEN
572: p_index_constraint_rec.last_update_date := NULL;
573: END IF;
574:
575: IF p_index_constraint_rec.last_updated_by = pn_index_rent_utils.g_pn_miss_num
576: THEN
577: p_index_constraint_rec.last_updated_by := NULL;
578: END IF;
579:
576: THEN
577: p_index_constraint_rec.last_updated_by := NULL;
578: END IF;
579:
580: IF p_index_constraint_rec.creation_date = pn_index_rent_utils.g_pn_miss_date
581: THEN
582: p_index_constraint_rec.creation_date := NULL;
583: END IF;
584:
581: THEN
582: p_index_constraint_rec.creation_date := NULL;
583: END IF;
584:
585: IF p_index_constraint_rec.created_by = pn_index_rent_utils.g_pn_miss_num
586: THEN
587: p_index_constraint_rec.created_by := NULL;
588: END IF;
589:
586: THEN
587: p_index_constraint_rec.created_by := NULL;
588: END IF;
589:
590: IF p_index_constraint_rec.last_update_login = pn_index_rent_utils.g_pn_miss_num
591: THEN
592: p_index_constraint_rec.last_update_login := NULL;
593: END IF;
594:
591: THEN
592: p_index_constraint_rec.last_update_login := NULL;
593: END IF;
594:
595: IF p_index_constraint_rec.attribute_category = pn_index_rent_utils.g_pn_miss_char
596: THEN
597: p_index_constraint_rec.attribute_category := NULL;
598: END IF;
599:
596: THEN
597: p_index_constraint_rec.attribute_category := NULL;
598: END IF;
599:
600: IF p_index_constraint_rec.attribute1 = pn_index_rent_utils.g_pn_miss_char
601: THEN
602: p_index_constraint_rec.attribute1 := NULL;
603: END IF;
604:
601: THEN
602: p_index_constraint_rec.attribute1 := NULL;
603: END IF;
604:
605: IF p_index_constraint_rec.attribute2 = pn_index_rent_utils.g_pn_miss_char
606: THEN
607: p_index_constraint_rec.attribute2 := NULL;
608: END IF;
609:
606: THEN
607: p_index_constraint_rec.attribute2 := NULL;
608: END IF;
609:
610: IF p_index_constraint_rec.attribute3 = pn_index_rent_utils.g_pn_miss_char
611: THEN
612: p_index_constraint_rec.attribute3 := NULL;
613: END IF;
614:
611: THEN
612: p_index_constraint_rec.attribute3 := NULL;
613: END IF;
614:
615: IF p_index_constraint_rec.attribute4 = pn_index_rent_utils.g_pn_miss_char
616: THEN
617: p_index_constraint_rec.attribute4 := NULL;
618: END IF;
619:
616: THEN
617: p_index_constraint_rec.attribute4 := NULL;
618: END IF;
619:
620: IF p_index_constraint_rec.attribute5 = pn_index_rent_utils.g_pn_miss_char
621: THEN
622: p_index_constraint_rec.attribute5 := NULL;
623: END IF;
624:
621: THEN
622: p_index_constraint_rec.attribute5 := NULL;
623: END IF;
624:
625: IF p_index_constraint_rec.attribute6 = pn_index_rent_utils.g_pn_miss_char
626: THEN
627: p_index_constraint_rec.attribute6 := NULL;
628: END IF;
629:
626: THEN
627: p_index_constraint_rec.attribute6 := NULL;
628: END IF;
629:
630: IF p_index_constraint_rec.attribute7 = pn_index_rent_utils.g_pn_miss_char
631: THEN
632: p_index_constraint_rec.attribute7 := NULL;
633: END IF;
634:
631: THEN
632: p_index_constraint_rec.attribute7 := NULL;
633: END IF;
634:
635: IF p_index_constraint_rec.attribute8 = pn_index_rent_utils.g_pn_miss_char
636: THEN
637: p_index_constraint_rec.attribute8 := NULL;
638: END IF;
639:
636: THEN
637: p_index_constraint_rec.attribute8 := NULL;
638: END IF;
639:
640: IF p_index_constraint_rec.attribute9 = pn_index_rent_utils.g_pn_miss_char
641: THEN
642: p_index_constraint_rec.attribute9 := NULL;
643: END IF;
644:
641: THEN
642: p_index_constraint_rec.attribute9 := NULL;
643: END IF;
644:
645: IF p_index_constraint_rec.attribute10 = pn_index_rent_utils.g_pn_miss_char
646: THEN
647: p_index_constraint_rec.attribute10 := NULL;
648: END IF;
649:
646: THEN
647: p_index_constraint_rec.attribute10 := NULL;
648: END IF;
649:
650: IF p_index_constraint_rec.attribute11 = pn_index_rent_utils.g_pn_miss_char
651: THEN
652: p_index_constraint_rec.attribute11 := NULL;
653: END IF;
654:
651: THEN
652: p_index_constraint_rec.attribute11 := NULL;
653: END IF;
654:
655: IF p_index_constraint_rec.attribute12 = pn_index_rent_utils.g_pn_miss_char
656: THEN
657: p_index_constraint_rec.attribute12 := NULL;
658: END IF;
659:
656: THEN
657: p_index_constraint_rec.attribute12 := NULL;
658: END IF;
659:
660: IF p_index_constraint_rec.attribute13 = pn_index_rent_utils.g_pn_miss_char
661: THEN
662: p_index_constraint_rec.attribute13 := NULL;
663: END IF;
664:
661: THEN
662: p_index_constraint_rec.attribute13 := NULL;
663: END IF;
664:
665: IF p_index_constraint_rec.attribute14 = pn_index_rent_utils.g_pn_miss_char
666: THEN
667: p_index_constraint_rec.attribute14 := NULL;
668: END IF;
669:
666: THEN
667: p_index_constraint_rec.attribute14 := NULL;
668: END IF;
669:
670: IF p_index_constraint_rec.attribute15 = pn_index_rent_utils.g_pn_miss_char
671: THEN
672: p_index_constraint_rec.attribute15 := NULL;
673: END IF;
674:
671: THEN
672: p_index_constraint_rec.attribute15 := NULL;
673: END IF;
674:
675: IF p_index_constraint_rec.org_id = pn_index_rent_utils.g_pn_miss_num
676: THEN
677: p_index_constraint_rec.org_id := NULL;
678: END IF;
679: EXCEPTION
710: BEGIN
711: g_program_unit := 'INIT_INDEX_RENT_REC';
712: x_return_status := fnd_api.g_ret_sts_success;
713:
714: IF p_rent_index_rec.index_lease_id = pn_index_rent_utils.g_pn_miss_num
715: THEN
716: p_rent_index_rec.index_lease_id := NULL;
717: END IF;
718:
715: THEN
716: p_rent_index_rec.index_lease_id := NULL;
717: END IF;
718:
719: IF p_rent_index_rec.org_id = pn_index_rent_utils.g_pn_miss_num
720: THEN
721: p_rent_index_rec.org_id := NULL;
722: END IF;
723:
720: THEN
721: p_rent_index_rec.org_id := NULL;
722: END IF;
723:
724: IF p_rent_index_rec.lease_id = pn_index_rent_utils.g_pn_miss_num
725: THEN
726: p_rent_index_rec.lease_id := NULL;
727: END IF;
728:
725: THEN
726: p_rent_index_rec.lease_id := NULL;
727: END IF;
728:
729: IF p_rent_index_rec.lease_num = pn_index_rent_utils.g_pn_miss_char
730: THEN
731: p_rent_index_rec.lease_num := NULL;
732: END IF;
733:
730: THEN
731: p_rent_index_rec.lease_num := NULL;
732: END IF;
733:
734: IF p_rent_index_rec.lease_name = pn_index_rent_utils.g_pn_miss_char
735: THEN
736: p_rent_index_rec.lease_name := NULL;
737: END IF;
738:
735: THEN
736: p_rent_index_rec.lease_name := NULL;
737: END IF;
738:
739: IF p_rent_index_rec.index_type = pn_index_rent_utils.g_pn_miss_char
740: THEN
741: p_rent_index_rec.index_type := NULL;
742: END IF;
743:
740: THEN
741: p_rent_index_rec.index_type := NULL;
742: END IF;
743:
744: IF p_rent_index_rec.index_id = pn_index_rent_utils.g_pn_miss_num
745: THEN
746: p_rent_index_rec.index_id := NULL;
747: END IF;
748:
745: THEN
746: p_rent_index_rec.index_id := NULL;
747: END IF;
748:
749: IF p_rent_index_rec.commencement_date = pn_index_rent_utils.g_pn_miss_date
750: THEN
751: p_rent_index_rec.commencement_date := NULL;
752: END IF;
753:
750: THEN
751: p_rent_index_rec.commencement_date := NULL;
752: END IF;
753:
754: IF p_rent_index_rec.termination_date = pn_index_rent_utils.g_pn_miss_date
755: THEN
756: p_rent_index_rec.termination_date := NULL;
757: END IF;
758:
755: THEN
756: p_rent_index_rec.termination_date := NULL;
757: END IF;
758:
759: IF p_rent_index_rec.index_lease_number = pn_index_rent_utils.g_pn_miss_char
760: THEN
761: p_rent_index_rec.index_lease_number := NULL;
762: END IF;
763:
760: THEN
761: p_rent_index_rec.index_lease_number := NULL;
762: END IF;
763:
764: IF p_rent_index_rec.last_update_date = pn_index_rent_utils.g_pn_miss_date
765: THEN
766: p_rent_index_rec.last_update_date := NULL;
767: END IF;
768:
765: THEN
766: p_rent_index_rec.last_update_date := NULL;
767: END IF;
768:
769: IF p_rent_index_rec.last_updated_by = pn_index_rent_utils.g_pn_miss_num
770: THEN
771: p_rent_index_rec.last_updated_by := NULL;
772: END IF;
773:
770: THEN
771: p_rent_index_rec.last_updated_by := NULL;
772: END IF;
773:
774: IF p_rent_index_rec.creation_date = pn_index_rent_utils.g_pn_miss_date
775: THEN
776: p_rent_index_rec.creation_date := NULL;
777: END IF;
778:
775: THEN
776: p_rent_index_rec.creation_date := NULL;
777: END IF;
778:
779: IF p_rent_index_rec.created_by = pn_index_rent_utils.g_pn_miss_num
780: THEN
781: p_rent_index_rec.created_by := NULL;
782: END IF;
783:
780: THEN
781: p_rent_index_rec.created_by := NULL;
782: END IF;
783:
784: IF p_rent_index_rec.location_id = pn_index_rent_utils.g_pn_miss_num
785: THEN
786: p_rent_index_rec.location_id := NULL;
787: END IF;
788:
785: THEN
786: p_rent_index_rec.location_id := NULL;
787: END IF;
788:
789: IF p_rent_index_rec.location_code = pn_index_rent_utils.g_pn_miss_char
790: THEN
791: p_rent_index_rec.location_code := NULL;
792: END IF;
793:
790: THEN
791: p_rent_index_rec.location_code := NULL;
792: END IF;
793:
794: IF p_rent_index_rec.term_template_name = pn_index_rent_utils.g_pn_miss_char
795: THEN
796: p_rent_index_rec.term_template_name := NULL;
797: END IF;
798:
795: THEN
796: p_rent_index_rec.term_template_name := NULL;
797: END IF;
798:
799: IF p_rent_index_rec.term_template_id = pn_index_rent_utils.g_pn_miss_num
800: THEN
801: p_rent_index_rec.term_template_id := NULL;
802: END IF;
803:
800: THEN
801: p_rent_index_rec.term_template_id := NULL;
802: END IF;
803:
804: IF p_rent_index_rec.abstracted_by = pn_index_rent_utils.g_pn_miss_num
805: THEN
806: p_rent_index_rec.abstracted_by := NULL;
807: END IF;
808:
805: THEN
806: p_rent_index_rec.abstracted_by := NULL;
807: END IF;
808:
809: IF p_rent_index_rec.abstracted_by_username = pn_index_rent_utils.g_pn_miss_char
810: THEN
811: p_rent_index_rec.abstracted_by_username := NULL;
812: END IF;
813:
810: THEN
811: p_rent_index_rec.abstracted_by_username := NULL;
812: END IF;
813:
814: IF p_rent_index_rec.assessment_date = pn_index_rent_utils.g_pn_miss_date
815: THEN
816: p_rent_index_rec.assessment_date := NULL;
817: END IF;
818:
815: THEN
816: p_rent_index_rec.assessment_date := NULL;
817: END IF;
818:
819: IF p_rent_index_rec.assessment_interval = pn_index_rent_utils.g_pn_miss_num
820: THEN
821: p_rent_index_rec.assessment_interval := NULL;
822: END IF;
823:
820: THEN
821: p_rent_index_rec.assessment_interval := NULL;
822: END IF;
823:
824: IF p_rent_index_rec.spread_frequency = pn_index_rent_utils.g_pn_miss_char
825: THEN
826: p_rent_index_rec.spread_frequency := NULL;
827: END IF;
828:
825: THEN
826: p_rent_index_rec.spread_frequency := NULL;
827: END IF;
828:
829: IF p_rent_index_rec.spread_frequency_meaning = pn_index_rent_utils.g_pn_miss_char
830: THEN
831: p_rent_index_rec.spread_frequency_meaning := NULL;
832: END IF;
833:
830: THEN
831: p_rent_index_rec.spread_frequency_meaning := NULL;
832: END IF;
833:
834: IF p_rent_index_rec.relationship_default = pn_index_rent_utils.g_pn_miss_char
835: THEN
836: p_rent_index_rec.relationship_default := NULL;
837: END IF;
838:
835: THEN
836: p_rent_index_rec.relationship_default := NULL;
837: END IF;
838:
839: IF p_rent_index_rec.relationship_default_meaning = pn_index_rent_utils.g_pn_miss_char
840: THEN
841: p_rent_index_rec.relationship_default_meaning := NULL;
842: END IF;
843:
840: THEN
841: p_rent_index_rec.relationship_default_meaning := NULL;
842: END IF;
843:
844: IF p_rent_index_rec.basis_percent_default = pn_index_rent_utils.g_pn_miss_num
845: THEN
846: p_rent_index_rec.basis_percent_default := NULL;
847: END IF;
848:
845: THEN
846: p_rent_index_rec.basis_percent_default := NULL;
847: END IF;
848:
849: IF p_rent_index_rec.initial_basis = pn_index_rent_utils.g_pn_miss_num
850: THEN
851: p_rent_index_rec.initial_basis := NULL;
852: END IF;
853:
850: THEN
851: p_rent_index_rec.initial_basis := NULL;
852: END IF;
853:
854: IF p_rent_index_rec.base_index = pn_index_rent_utils.g_pn_miss_num
855: THEN
856: p_rent_index_rec.base_index := NULL;
857: END IF;
858:
855: THEN
856: p_rent_index_rec.base_index := NULL;
857: END IF;
858:
859: IF p_rent_index_rec.base_index_line_id = pn_index_rent_utils.g_pn_miss_num
860: THEN
861: p_rent_index_rec.base_index_line_id := NULL;
862: END IF;
863:
860: THEN
861: p_rent_index_rec.base_index_line_id := NULL;
862: END IF;
863:
864: IF p_rent_index_rec.index_finder_method = pn_index_rent_utils.g_pn_miss_char
865: THEN
866: p_rent_index_rec.index_finder_method := NULL;
867: END IF;
868:
865: THEN
866: p_rent_index_rec.index_finder_method := NULL;
867: END IF;
868:
869: IF p_rent_index_rec.index_finder_method_meaning = pn_index_rent_utils.g_pn_miss_char
870: THEN
871: p_rent_index_rec.index_finder_method_meaning := NULL;
872: END IF;
873:
870: THEN
871: p_rent_index_rec.index_finder_method_meaning := NULL;
872: END IF;
873:
874: IF p_rent_index_rec.index_finder_months = pn_index_rent_utils.g_pn_miss_num
875: THEN
876: p_rent_index_rec.index_finder_months := NULL;
877: END IF;
878:
875: THEN
876: p_rent_index_rec.index_finder_months := NULL;
877: END IF;
878:
879: IF p_rent_index_rec.negative_rent_type = pn_index_rent_utils.g_pn_miss_char
880: THEN
881: p_rent_index_rec.negative_rent_type := NULL;
882: END IF;
883:
880: THEN
881: p_rent_index_rec.negative_rent_type := NULL;
882: END IF;
883:
884: IF p_rent_index_rec.negative_rent_type_meaning = pn_index_rent_utils.g_pn_miss_char
885: THEN
886: p_rent_index_rec.negative_rent_type_meaning := NULL;
887: END IF;
888:
885: THEN
886: p_rent_index_rec.negative_rent_type_meaning := NULL;
887: END IF;
888:
889: IF p_rent_index_rec.increase_on = pn_index_rent_utils.g_pn_miss_char
890: THEN
891: p_rent_index_rec.increase_on := NULL;
892: END IF;
893:
890: THEN
891: p_rent_index_rec.increase_on := NULL;
892: END IF;
893:
894: IF p_rent_index_rec.increase_on_meaning = pn_index_rent_utils.g_pn_miss_char
895: THEN
896: p_rent_index_rec.increase_on_meaning := NULL;
897: END IF;
898:
895: THEN
896: p_rent_index_rec.increase_on_meaning := NULL;
897: END IF;
898:
899: IF p_rent_index_rec.basis_type = pn_index_rent_utils.g_pn_miss_char
900: THEN
901: p_rent_index_rec.basis_type := NULL;
902: END IF;
903:
900: THEN
901: p_rent_index_rec.basis_type := NULL;
902: END IF;
903:
904: IF p_rent_index_rec.basis_type_meaning = pn_index_rent_utils.g_pn_miss_char
905: THEN
906: p_rent_index_rec.basis_type_meaning := NULL;
907: END IF;
908:
905: THEN
906: p_rent_index_rec.basis_type_meaning := NULL;
907: END IF;
908:
909: IF p_rent_index_rec.reference_period = pn_index_rent_utils.g_pn_miss_char
910: THEN
911: p_rent_index_rec.reference_period := NULL;
912: END IF;
913:
910: THEN
911: p_rent_index_rec.reference_period := NULL;
912: END IF;
913:
914: IF p_rent_index_rec.reference_period_meaning = pn_index_rent_utils.g_pn_miss_char
915: THEN
916: p_rent_index_rec.reference_period_meaning := NULL;
917: END IF;
918:
915: THEN
916: p_rent_index_rec.reference_period_meaning := NULL;
917: END IF;
918:
919: IF p_rent_index_rec.base_year = pn_index_rent_utils.g_pn_miss_date
920: THEN
921: p_rent_index_rec.base_year := NULL;
922: END IF;
923:
920: THEN
921: p_rent_index_rec.base_year := NULL;
922: END IF;
923:
924: IF p_rent_index_rec.leased_area = pn_index_rent_utils.g_pn_miss_num
925: THEN
926: p_rent_index_rec.leased_area := NULL;
927: END IF;
928:
925: THEN
926: p_rent_index_rec.leased_area := NULL;
927: END IF;
928:
929: IF p_rent_index_rec.rounding_flag = pn_index_rent_utils.g_pn_miss_char
930: THEN
931: p_rent_index_rec.rounding_flag := NULL;
932: END IF;
933:
930: THEN
931: p_rent_index_rec.rounding_flag := NULL;
932: END IF;
933:
934: IF p_rent_index_rec.aggregation_flag = pn_index_rent_utils.g_pn_miss_char
935: THEN
936: p_rent_index_rec.aggregation_flag := NULL;
937: END IF;
938:
935: THEN
936: p_rent_index_rec.aggregation_flag := NULL;
937: END IF;
938:
939: IF p_rent_index_rec.gross_flag = pn_index_rent_utils.g_pn_miss_char
940: THEN
941: p_rent_index_rec.gross_flag := NULL;
942: END IF;
943:
940: THEN
941: p_rent_index_rec.gross_flag := NULL;
942: END IF;
943:
944: IF p_rent_index_rec.last_update_login = pn_index_rent_utils.g_pn_miss_num
945: THEN
946: p_rent_index_rec.last_update_login := NULL;
947: END IF;
948:
945: THEN
946: p_rent_index_rec.last_update_login := NULL;
947: END IF;
948:
949: IF p_rent_index_rec.attribute_category = pn_index_rent_utils.g_pn_miss_char
950: THEN
951: p_rent_index_rec.attribute_category := NULL;
952: END IF;
953:
950: THEN
951: p_rent_index_rec.attribute_category := NULL;
952: END IF;
953:
954: IF p_rent_index_rec.attribute1 = pn_index_rent_utils.g_pn_miss_char
955: THEN
956: p_rent_index_rec.attribute1 := NULL;
957: END IF;
958:
955: THEN
956: p_rent_index_rec.attribute1 := NULL;
957: END IF;
958:
959: IF p_rent_index_rec.attribute2 = pn_index_rent_utils.g_pn_miss_char
960: THEN
961: p_rent_index_rec.attribute2 := NULL;
962: END IF;
963:
960: THEN
961: p_rent_index_rec.attribute2 := NULL;
962: END IF;
963:
964: IF p_rent_index_rec.attribute3 = pn_index_rent_utils.g_pn_miss_char
965: THEN
966: p_rent_index_rec.attribute3 := NULL;
967: END IF;
968:
965: THEN
966: p_rent_index_rec.attribute3 := NULL;
967: END IF;
968:
969: IF p_rent_index_rec.attribute4 = pn_index_rent_utils.g_pn_miss_char
970: THEN
971: p_rent_index_rec.attribute4 := NULL;
972: END IF;
973:
970: THEN
971: p_rent_index_rec.attribute4 := NULL;
972: END IF;
973:
974: IF p_rent_index_rec.attribute5 = pn_index_rent_utils.g_pn_miss_char
975: THEN
976: p_rent_index_rec.attribute5 := NULL;
977: END IF;
978:
975: THEN
976: p_rent_index_rec.attribute5 := NULL;
977: END IF;
978:
979: IF p_rent_index_rec.attribute6 = pn_index_rent_utils.g_pn_miss_char
980: THEN
981: p_rent_index_rec.attribute6 := NULL;
982: END IF;
983:
980: THEN
981: p_rent_index_rec.attribute6 := NULL;
982: END IF;
983:
984: IF p_rent_index_rec.attribute7 = pn_index_rent_utils.g_pn_miss_char
985: THEN
986: p_rent_index_rec.attribute7 := NULL;
987: END IF;
988:
985: THEN
986: p_rent_index_rec.attribute7 := NULL;
987: END IF;
988:
989: IF p_rent_index_rec.attribute8 = pn_index_rent_utils.g_pn_miss_char
990: THEN
991: p_rent_index_rec.attribute8 := NULL;
992: END IF;
993:
990: THEN
991: p_rent_index_rec.attribute8 := NULL;
992: END IF;
993:
994: IF p_rent_index_rec.attribute9 = pn_index_rent_utils.g_pn_miss_char
995: THEN
996: p_rent_index_rec.attribute9 := NULL;
997: END IF;
998:
995: THEN
996: p_rent_index_rec.attribute9 := NULL;
997: END IF;
998:
999: IF p_rent_index_rec.attribute10 = pn_index_rent_utils.g_pn_miss_char
1000: THEN
1001: p_rent_index_rec.attribute10 := NULL;
1002: END IF;
1003:
1000: THEN
1001: p_rent_index_rec.attribute10 := NULL;
1002: END IF;
1003:
1004: IF p_rent_index_rec.attribute11 = pn_index_rent_utils.g_pn_miss_char
1005: THEN
1006: p_rent_index_rec.attribute11 := NULL;
1007: END IF;
1008:
1005: THEN
1006: p_rent_index_rec.attribute11 := NULL;
1007: END IF;
1008:
1009: IF p_rent_index_rec.attribute12 = pn_index_rent_utils.g_pn_miss_char
1010: THEN
1011: p_rent_index_rec.attribute12 := NULL;
1012: END IF;
1013:
1010: THEN
1011: p_rent_index_rec.attribute12 := NULL;
1012: END IF;
1013:
1014: IF p_rent_index_rec.attribute13 = pn_index_rent_utils.g_pn_miss_char
1015: THEN
1016: p_rent_index_rec.attribute13 := NULL;
1017: END IF;
1018:
1015: THEN
1016: p_rent_index_rec.attribute13 := NULL;
1017: END IF;
1018:
1019: IF p_rent_index_rec.attribute14 = pn_index_rent_utils.g_pn_miss_char
1020: THEN
1021: p_rent_index_rec.attribute14 := NULL;
1022: END IF;
1023:
1020: THEN
1021: p_rent_index_rec.attribute14 := NULL;
1022: END IF;
1023:
1024: IF p_rent_index_rec.attribute15 = pn_index_rent_utils.g_pn_miss_char
1025: THEN
1026: p_rent_index_rec.attribute15 := NULL;
1027: END IF;
1028:
1025: THEN
1026: p_rent_index_rec.attribute15 := NULL;
1027: END IF;
1028:
1029: IF p_rent_index_rec.agreement_category = pn_index_rent_utils.g_pn_miss_char
1030: THEN
1031: p_rent_index_rec.agreement_category := NULL;
1032: END IF;
1033:
1030: THEN
1031: p_rent_index_rec.agreement_category := NULL;
1032: END IF;
1033:
1034: IF p_rent_index_rec.agreement_attribute1 = pn_index_rent_utils.g_pn_miss_char
1035: THEN
1036: p_rent_index_rec.agreement_attribute1 := NULL;
1037: END IF;
1038:
1035: THEN
1036: p_rent_index_rec.agreement_attribute1 := NULL;
1037: END IF;
1038:
1039: IF p_rent_index_rec.agreement_attribute2 = pn_index_rent_utils.g_pn_miss_char
1040: THEN
1041: p_rent_index_rec.agreement_attribute2 := NULL;
1042: END IF;
1043:
1040: THEN
1041: p_rent_index_rec.agreement_attribute2 := NULL;
1042: END IF;
1043:
1044: IF p_rent_index_rec.agreement_attribute3 = pn_index_rent_utils.g_pn_miss_char
1045: THEN
1046: p_rent_index_rec.agreement_attribute3 := NULL;
1047: END IF;
1048:
1045: THEN
1046: p_rent_index_rec.agreement_attribute3 := NULL;
1047: END IF;
1048:
1049: IF p_rent_index_rec.agreement_attribute4 = pn_index_rent_utils.g_pn_miss_char
1050: THEN
1051: p_rent_index_rec.agreement_attribute4 := NULL;
1052: END IF;
1053:
1050: THEN
1051: p_rent_index_rec.agreement_attribute4 := NULL;
1052: END IF;
1053:
1054: IF p_rent_index_rec.agreement_attribute5 = pn_index_rent_utils.g_pn_miss_char
1055: THEN
1056: p_rent_index_rec.agreement_attribute5 := NULL;
1057: END IF;
1058:
1055: THEN
1056: p_rent_index_rec.agreement_attribute5 := NULL;
1057: END IF;
1058:
1059: IF p_rent_index_rec.agreement_attribute6 = pn_index_rent_utils.g_pn_miss_char
1060: THEN
1061: p_rent_index_rec.agreement_attribute6 := NULL;
1062: END IF;
1063:
1060: THEN
1061: p_rent_index_rec.agreement_attribute6 := NULL;
1062: END IF;
1063:
1064: IF p_rent_index_rec.agreement_attribute7 = pn_index_rent_utils.g_pn_miss_char
1065: THEN
1066: p_rent_index_rec.agreement_attribute7 := NULL;
1067: END IF;
1068:
1065: THEN
1066: p_rent_index_rec.agreement_attribute7 := NULL;
1067: END IF;
1068:
1069: IF p_rent_index_rec.agreement_attribute8 = pn_index_rent_utils.g_pn_miss_char
1070: THEN
1071: p_rent_index_rec.agreement_attribute8 := NULL;
1072: END IF;
1073:
1070: THEN
1071: p_rent_index_rec.agreement_attribute8 := NULL;
1072: END IF;
1073:
1074: IF p_rent_index_rec.agreement_attribute9 = pn_index_rent_utils.g_pn_miss_char
1075: THEN
1076: p_rent_index_rec.agreement_attribute9 := NULL;
1077: END IF;
1078:
1075: THEN
1076: p_rent_index_rec.agreement_attribute9 := NULL;
1077: END IF;
1078:
1079: IF p_rent_index_rec.agreement_attribute10 = pn_index_rent_utils.g_pn_miss_char
1080: THEN
1081: p_rent_index_rec.agreement_attribute10 := NULL;
1082: END IF;
1083:
1080: THEN
1081: p_rent_index_rec.agreement_attribute10 := NULL;
1082: END IF;
1083:
1084: IF p_rent_index_rec.agreement_attribute11 = pn_index_rent_utils.g_pn_miss_char
1085: THEN
1086: p_rent_index_rec.agreement_attribute11 := NULL;
1087: END IF;
1088:
1085: THEN
1086: p_rent_index_rec.agreement_attribute11 := NULL;
1087: END IF;
1088:
1089: IF p_rent_index_rec.agreement_attribute12 = pn_index_rent_utils.g_pn_miss_char
1090: THEN
1091: p_rent_index_rec.agreement_attribute12 := NULL;
1092: END IF;
1093:
1090: THEN
1091: p_rent_index_rec.agreement_attribute12 := NULL;
1092: END IF;
1093:
1094: IF p_rent_index_rec.agreement_attribute13 = pn_index_rent_utils.g_pn_miss_char
1095: THEN
1096: p_rent_index_rec.agreement_attribute13 := NULL;
1097: END IF;
1098:
1095: THEN
1096: p_rent_index_rec.agreement_attribute13 := NULL;
1097: END IF;
1098:
1099: IF p_rent_index_rec.agreement_attribute14 = pn_index_rent_utils.g_pn_miss_char
1100: THEN
1101: p_rent_index_rec.agreement_attribute14 := NULL;
1102: END IF;
1103:
1100: THEN
1101: p_rent_index_rec.agreement_attribute14 := NULL;
1102: END IF;
1103:
1104: IF p_rent_index_rec.agreement_attribute15 = pn_index_rent_utils.g_pn_miss_char
1105: THEN
1106: p_rent_index_rec.agreement_attribute15 := NULL;
1107: END IF;
1108:
1105: THEN
1106: p_rent_index_rec.agreement_attribute15 := NULL;
1107: END IF;
1108:
1109: IF p_rent_index_rec.currency_code = pn_index_rent_utils.g_pn_miss_char
1110: THEN
1111: p_rent_index_rec.currency_code := NULL;
1112: END IF;
1113:
1110: THEN
1111: p_rent_index_rec.currency_code := NULL;
1112: END IF;
1113:
1114: IF p_rent_index_rec.carry_forward_flag = pn_index_rent_utils.g_pn_miss_char
1115: THEN
1116: p_rent_index_rec.carry_forward_flag := NULL;
1117: END IF;
1118:
1115: THEN
1116: p_rent_index_rec.carry_forward_flag := NULL;
1117: END IF;
1118:
1119: IF p_rent_index_rec.retain_initial_basis_flag = pn_index_rent_utils.g_pn_miss_char
1120: THEN
1121: p_rent_index_rec.retain_initial_basis_flag := NULL;
1122: END IF;
1123:
1120: THEN
1121: p_rent_index_rec.retain_initial_basis_flag := NULL;
1122: END IF;
1123:
1124: IF p_rent_index_rec.vr_nbp_flag = pn_index_rent_utils.g_pn_miss_char
1125: THEN
1126: p_rent_index_rec.vr_nbp_flag := NULL;
1127: END IF;
1128:
1125: THEN
1126: p_rent_index_rec.vr_nbp_flag := NULL;
1127: END IF;
1128:
1129: IF p_rent_index_rec.index_multiplier = pn_index_rent_utils.g_pn_miss_num
1130: THEN
1131: p_rent_index_rec.index_multiplier := NULL;
1132: END IF;
1133:
1130: THEN
1131: p_rent_index_rec.index_multiplier := NULL;
1132: END IF;
1133:
1134: IF p_rent_index_rec.proration_rule = pn_index_rent_utils.g_pn_miss_char
1135: THEN
1136: p_rent_index_rec.proration_rule := NULL;
1137: END IF;
1138:
1135: THEN
1136: p_rent_index_rec.proration_rule := NULL;
1137: END IF;
1138:
1139: IF p_rent_index_rec.proration_rule_meaning = pn_index_rent_utils.g_pn_miss_char
1140: THEN
1141: p_rent_index_rec.proration_rule_meaning := NULL;
1142: END IF;
1143:
1140: THEN
1141: p_rent_index_rec.proration_rule_meaning := NULL;
1142: END IF;
1143:
1144: IF p_rent_index_rec.proration_period_start_date = pn_index_rent_utils.g_pn_miss_date
1145: THEN
1146: p_rent_index_rec.proration_period_start_date := NULL;
1147: END IF;
1148: EXCEPTION
1546: --ELSE
1547: -- x_return_status := fnd_api.g_ret_sts_success;
1548: END IF;
1549:
1550: IF p_rent_index_rec.lease_id IS NULL OR p_rent_index_rec.lease_id =pn_index_rent_utils.g_pn_miss_num
1551: THEN
1552:
1553: p_rent_index_rec.lease_id := l_rent_index_rec_old.lease_id;
1554: END IF;
1553: p_rent_index_rec.lease_id := l_rent_index_rec_old.lease_id;
1554: END IF;
1555:
1556:
1557: IF p_rent_index_rec.index_lease_id IS NULL OR p_rent_index_rec.index_lease_id =pn_index_rent_utils.g_pn_miss_num
1558: THEN
1559: p_rent_index_rec.index_lease_id := l_rent_index_rec_old.index_lease_id;
1560: END IF;
1561:
1558: THEN
1559: p_rent_index_rec.index_lease_id := l_rent_index_rec_old.index_lease_id;
1560: END IF;
1561:
1562: IF p_rent_index_rec.index_id IS NULL OR p_rent_index_rec.index_id =pn_index_rent_utils.g_pn_miss_num
1563: THEN
1564: p_rent_index_rec.index_id := l_rent_index_rec_old.index_id;
1565: END IF;
1566:
1564: p_rent_index_rec.index_id := l_rent_index_rec_old.index_id;
1565: END IF;
1566:
1567:
1568: IF p_rent_index_rec.commencement_date IS NULL OR p_rent_index_rec.commencement_date = pn_index_rent_utils.g_pn_miss_date
1569: THEN
1570: p_rent_index_rec.commencement_date := l_rent_index_rec_old.commencement_date;
1571: END IF;
1572:
1569: THEN
1570: p_rent_index_rec.commencement_date := l_rent_index_rec_old.commencement_date;
1571: END IF;
1572:
1573: IF p_rent_index_rec.termination_date IS NULL OR p_rent_index_rec.termination_date = pn_index_rent_utils.g_pn_miss_date
1574: THEN
1575: p_rent_index_rec.termination_date := l_rent_index_rec_old.termination_date;
1576: END IF;
1577:
1578:
1579: IF p_rent_index_rec.termination_date <>l_rent_index_rec_old.termination_date
1580: THEN
1581: IF pn_index_lease_common_pkg.find_if_period_exists(p_rent_index_rec.index_lease_id) IS NOT NULL
1582: OR pn_index_lease_common_pkg.find_if_period_exists(p_rent_index_rec.index_lease_id)<> pn_index_rent_utils.g_pn_miss_num
1583: THEN
1584:
1585: pn_index_rent_periods_pkg.process_new_termination_date( p_index_lease_id => p_rent_index_rec.index_lease_id,
1586: p_new_termination_date => p_rent_index_rec.termination_date,
1588: p_msg => x_return_status);
1589: END IF;
1590: END IF;
1591:
1592: IF p_rent_index_rec.index_lease_number IS NULL OR p_rent_index_rec.index_lease_number = pn_index_rent_utils.g_pn_miss_char
1593: THEN
1594: p_rent_index_rec.index_lease_number := l_rent_index_rec_old.index_lease_number;
1595: END IF;
1596:
1593: THEN
1594: p_rent_index_rec.index_lease_number := l_rent_index_rec_old.index_lease_number;
1595: END IF;
1596:
1597: IF p_rent_index_rec.index_lease_number IS NULL OR p_rent_index_rec.index_lease_number = pn_index_rent_utils.g_pn_miss_char
1598: THEN
1599: p_rent_index_rec.index_lease_number := l_rent_index_rec_old.index_lease_number;
1600: END IF;
1601:
1600: END IF;
1601:
1602:
1603: /*
1604: IF p_rent_index_rec.location_id IS NULL OR p_rent_index_rec.location_id = pn_index_rent_utils.g_pn_miss_num
1605: THEN
1606: --IF NVL (p_rent_index_rec.index_lease_number, '~') =
1607: -- NVL (l_rent_index_rec_old.index_lease_number, '~')
1608: --THEN
1609: p_rent_index_rec.location_id := l_rent_index_rec_old.location_id;
1610: --END IF;
1611: END IF;
1612:
1613: IF p_rent_index_rec.term_template_id IS NULL OR p_rent_index_rec.term_template_id = pn_index_rent_utils.g_pn_miss_num
1614: THEN
1615: --IF NVL (p_rent_index_rec.index_lease_number, '~') =
1616: -- NVL (l_rent_index_rec_old.index_lease_number, '~')
1617: --THEN
1618: p_rent_index_rec.term_template_id := l_rent_index_rec_old.term_template_id;
1619: --END IF;
1620: END IF;
1621: */
1622: IF p_rent_index_rec.location_id IS NOT NULL AND p_rent_index_rec.location_id <> pn_index_rent_utils.g_pn_miss_num
1623: THEN
1624: IF p_rent_index_rec.index_lease_id IS NOT NULL AND p_rent_index_rec.index_lease_id <> pn_index_rent_utils.g_pn_miss_num
1625: AND (pn_index_lease_common_pkg.find_if_period_exists(l_rent_index_rec_old.index_lease_id) IS NOT NULL)
1626: THEN
1620: END IF;
1621: */
1622: IF p_rent_index_rec.location_id IS NOT NULL AND p_rent_index_rec.location_id <> pn_index_rent_utils.g_pn_miss_num
1623: THEN
1624: IF p_rent_index_rec.index_lease_id IS NOT NULL AND p_rent_index_rec.index_lease_id <> pn_index_rent_utils.g_pn_miss_num
1625: AND (pn_index_lease_common_pkg.find_if_period_exists(l_rent_index_rec_old.index_lease_id) IS NOT NULL)
1626: THEN
1627:
1628: IF p_rent_index_rec.location_id<> l_rent_index_rec_old.location_id
1643: p_rent_index_rec.location_id := l_rent_index_rec_old.location_id;
1644:
1645: END IF;
1646:
1647: IF p_rent_index_rec.term_template_id IS NOT NULL AND p_rent_index_rec.term_template_id <> pn_index_rent_utils.g_pn_miss_num
1648: THEN
1649: IF p_rent_index_rec.index_lease_id IS NOT NULL AND p_rent_index_rec.index_lease_id <> pn_index_rent_utils.g_pn_miss_num
1650: AND (pn_index_lease_common_pkg.find_if_period_exists(l_rent_index_rec_old.index_lease_id) IS NOT NULL)
1651: THEN
1645: END IF;
1646:
1647: IF p_rent_index_rec.term_template_id IS NOT NULL AND p_rent_index_rec.term_template_id <> pn_index_rent_utils.g_pn_miss_num
1648: THEN
1649: IF p_rent_index_rec.index_lease_id IS NOT NULL AND p_rent_index_rec.index_lease_id <> pn_index_rent_utils.g_pn_miss_num
1650: AND (pn_index_lease_common_pkg.find_if_period_exists(l_rent_index_rec_old.index_lease_id) IS NOT NULL)
1651: THEN
1652:
1653: IF p_rent_index_rec.location_id<> l_rent_index_rec_old.location_id
1672:
1673: END IF;
1674:
1675:
1676: IF p_rent_index_rec.abstracted_by IS NULL OR p_rent_index_rec.abstracted_by = pn_index_rent_utils.g_pn_miss_num
1677: THEN
1678: p_rent_index_rec.abstracted_by := l_rent_index_rec_old.abstracted_by;
1679: END IF;
1680:
1677: THEN
1678: p_rent_index_rec.abstracted_by := l_rent_index_rec_old.abstracted_by;
1679: END IF;
1680:
1681: IF p_rent_index_rec.assessment_date IS NULL OR p_rent_index_rec.assessment_date = pn_index_rent_utils.g_pn_miss_date
1682: THEN
1683: p_rent_index_rec.assessment_date := l_rent_index_rec_old.assessment_date;
1684: END IF;
1685:
1682: THEN
1683: p_rent_index_rec.assessment_date := l_rent_index_rec_old.assessment_date;
1684: END IF;
1685:
1686: IF p_rent_index_rec.assessment_interval IS NULL OR p_rent_index_rec.assessment_interval = pn_index_rent_utils.g_pn_miss_num
1687: THEN
1688: p_rent_index_rec.assessment_interval := l_rent_index_rec_old.assessment_interval;
1689: END IF;
1690:
1687: THEN
1688: p_rent_index_rec.assessment_interval := l_rent_index_rec_old.assessment_interval;
1689: END IF;
1690:
1691: IF p_rent_index_rec.spread_frequency IS NULL OR p_rent_index_rec.spread_frequency = pn_index_rent_utils.g_pn_miss_char
1692: THEN
1693: p_rent_index_rec.spread_frequency := l_rent_index_rec_old.spread_frequency;
1694: END IF;
1695:
1692: THEN
1693: p_rent_index_rec.spread_frequency := l_rent_index_rec_old.spread_frequency;
1694: END IF;
1695:
1696: IF p_rent_index_rec.relationship_default IS NULL OR p_rent_index_rec.relationship_default = pn_index_rent_utils.g_pn_miss_char
1697: THEN
1698: p_rent_index_rec.relationship_default := l_rent_index_rec_old.relationship_default;
1699: END IF;
1700:
1697: THEN
1698: p_rent_index_rec.relationship_default := l_rent_index_rec_old.relationship_default;
1699: END IF;
1700:
1701: IF p_rent_index_rec.basis_percent_default IS NULL OR p_rent_index_rec.basis_percent_default = pn_index_rent_utils.g_pn_miss_num
1702: THEN
1703: p_rent_index_rec.basis_percent_default := l_rent_index_rec_old.basis_percent_default;
1704: END IF;
1705:
1702: THEN
1703: p_rent_index_rec.basis_percent_default := l_rent_index_rec_old.basis_percent_default;
1704: END IF;
1705:
1706: IF p_rent_index_rec.initial_basis IS NULL OR p_rent_index_rec.initial_basis = pn_index_rent_utils.g_pn_miss_num
1707: THEN
1708: IF NVL (p_rent_index_rec.initial_basis, -1) = NVL (l_rent_index_rec_old.initial_basis
1709: , -1)
1710: THEN
1711: p_rent_index_rec.initial_basis := l_rent_index_rec_old.initial_basis;
1712: END IF;
1713: END IF;
1714:
1715: IF p_rent_index_rec.base_index IS NULL OR p_rent_index_rec.base_index = pn_index_rent_utils.g_pn_miss_num
1716: THEN
1717: p_rent_index_rec.base_index := l_rent_index_rec_old.base_index;
1718: END IF;
1719:
1716: THEN
1717: p_rent_index_rec.base_index := l_rent_index_rec_old.base_index;
1718: END IF;
1719:
1720: IF p_rent_index_rec.base_index_line_id IS NULL OR p_rent_index_rec.base_index_line_id = pn_index_rent_utils.g_pn_miss_num
1721: THEN
1722: p_rent_index_rec.base_index_line_id := l_rent_index_rec_old.base_index_line_id;
1723: END IF;
1724:
1721: THEN
1722: p_rent_index_rec.base_index_line_id := l_rent_index_rec_old.base_index_line_id;
1723: END IF;
1724:
1725: IF p_rent_index_rec.index_finder_method IS NULL OR p_rent_index_rec.index_finder_method = pn_index_rent_utils.g_pn_miss_char
1726: THEN
1727: p_rent_index_rec.index_finder_method := l_rent_index_rec_old.index_finder_method;
1728: END IF;
1729:
1726: THEN
1727: p_rent_index_rec.index_finder_method := l_rent_index_rec_old.index_finder_method;
1728: END IF;
1729:
1730: IF p_rent_index_rec.index_finder_months IS NULL OR p_rent_index_rec.index_finder_months = pn_index_rent_utils.g_pn_miss_num
1731: THEN
1732: p_rent_index_rec.index_finder_months := l_rent_index_rec_old.index_finder_months;
1733: END IF;
1734:
1731: THEN
1732: p_rent_index_rec.index_finder_months := l_rent_index_rec_old.index_finder_months;
1733: END IF;
1734:
1735: IF p_rent_index_rec.negative_rent_type IS NULL OR p_rent_index_rec.negative_rent_type = pn_index_rent_utils.g_pn_miss_char
1736: THEN
1737: p_rent_index_rec.negative_rent_type := l_rent_index_rec_old.negative_rent_type;
1738: END IF;
1739:
1736: THEN
1737: p_rent_index_rec.negative_rent_type := l_rent_index_rec_old.negative_rent_type;
1738: END IF;
1739:
1740: IF p_rent_index_rec.increase_on IS NULL OR p_rent_index_rec.increase_on = pn_index_rent_utils.g_pn_miss_char
1741: THEN
1742:
1743: IF p_rent_index_rec.gross_flag IS NULL OR p_rent_index_rec.gross_flag = pn_index_rent_utils.g_pn_miss_char
1744: THEN
1739:
1740: IF p_rent_index_rec.increase_on IS NULL OR p_rent_index_rec.increase_on = pn_index_rent_utils.g_pn_miss_char
1741: THEN
1742:
1743: IF p_rent_index_rec.gross_flag IS NULL OR p_rent_index_rec.gross_flag = pn_index_rent_utils.g_pn_miss_char
1744: THEN
1745: p_rent_index_rec.increase_on := l_rent_index_rec_old.increase_on;
1746:
1747: ELSE
1749: END IF;
1750:
1751: END IF;
1752:
1753: IF p_rent_index_rec.basis_type IS NULL OR p_rent_index_rec.basis_type = pn_index_rent_utils.g_pn_miss_char
1754: THEN
1755: p_rent_index_rec.basis_type := l_rent_index_rec_old.basis_type;
1756: END IF;
1757:
1754: THEN
1755: p_rent_index_rec.basis_type := l_rent_index_rec_old.basis_type;
1756: END IF;
1757:
1758: IF p_rent_index_rec.reference_period IS NULL OR p_rent_index_rec.reference_period = pn_index_rent_utils.g_pn_miss_char
1759: THEN
1760: p_rent_index_rec.reference_period := l_rent_index_rec_old.reference_period;
1761: END IF;
1762:
1759: THEN
1760: p_rent_index_rec.reference_period := l_rent_index_rec_old.reference_period;
1761: END IF;
1762:
1763: IF p_rent_index_rec.base_year IS NULL OR p_rent_index_rec.base_year = pn_index_rent_utils.g_pn_miss_date
1764: THEN
1765: p_rent_index_rec.base_year := l_rent_index_rec_old.base_year;
1766: END IF;
1767:
1764: THEN
1765: p_rent_index_rec.base_year := l_rent_index_rec_old.base_year;
1766: END IF;
1767:
1768: IF p_rent_index_rec.leased_area IS NULL OR p_rent_index_rec.leased_area = pn_index_rent_utils.g_pn_miss_num
1769: THEN
1770: p_rent_index_rec.leased_area := l_rent_index_rec_old.leased_area;
1771: END IF;
1772:
1769: THEN
1770: p_rent_index_rec.leased_area := l_rent_index_rec_old.leased_area;
1771: END IF;
1772:
1773: IF p_rent_index_rec.rounding_flag IS NULL OR p_rent_index_rec.rounding_flag = pn_index_rent_utils.g_pn_miss_char
1774: THEN
1775: p_rent_index_rec.rounding_flag := l_rent_index_rec_old.rounding_flag;
1776: END IF;
1777:
1774: THEN
1775: p_rent_index_rec.rounding_flag := l_rent_index_rec_old.rounding_flag;
1776: END IF;
1777:
1778: IF p_rent_index_rec.attribute_category IS NULL OR p_rent_index_rec.attribute_category = pn_index_rent_utils.g_pn_miss_char
1779: THEN
1780: p_rent_index_rec.attribute_category := l_rent_index_rec_old.attribute_category;
1781:
1782: END IF;
1780: p_rent_index_rec.attribute_category := l_rent_index_rec_old.attribute_category;
1781:
1782: END IF;
1783:
1784: IF p_rent_index_rec.attribute1 IS NULL OR p_rent_index_rec.attribute1 = pn_index_rent_utils.g_pn_miss_char
1785: THEN
1786: p_rent_index_rec.attribute1 := l_rent_index_rec_old.attribute1;
1787: END IF;
1788:
1785: THEN
1786: p_rent_index_rec.attribute1 := l_rent_index_rec_old.attribute1;
1787: END IF;
1788:
1789: IF p_rent_index_rec.attribute2 IS NULL OR p_rent_index_rec.attribute2 = pn_index_rent_utils.g_pn_miss_char
1790: THEN
1791: p_rent_index_rec.attribute2 := l_rent_index_rec_old.attribute2;
1792: END IF;
1793:
1790: THEN
1791: p_rent_index_rec.attribute2 := l_rent_index_rec_old.attribute2;
1792: END IF;
1793:
1794: IF p_rent_index_rec.attribute3 IS NULL OR p_rent_index_rec.attribute3 = pn_index_rent_utils.g_pn_miss_char
1795: THEN
1796: p_rent_index_rec.attribute3 := l_rent_index_rec_old.attribute3;
1797: END IF;
1798:
1795: THEN
1796: p_rent_index_rec.attribute3 := l_rent_index_rec_old.attribute3;
1797: END IF;
1798:
1799: IF p_rent_index_rec.attribute4 IS NULL OR p_rent_index_rec.attribute4 = pn_index_rent_utils.g_pn_miss_char
1800: THEN
1801: p_rent_index_rec.attribute4 := l_rent_index_rec_old.attribute4;
1802: END IF;
1803:
1800: THEN
1801: p_rent_index_rec.attribute4 := l_rent_index_rec_old.attribute4;
1802: END IF;
1803:
1804: IF p_rent_index_rec.attribute5 IS NULL OR p_rent_index_rec.attribute5 = pn_index_rent_utils.g_pn_miss_char
1805: THEN
1806: p_rent_index_rec.attribute5 := l_rent_index_rec_old.attribute5;
1807: END IF;
1808:
1805: THEN
1806: p_rent_index_rec.attribute5 := l_rent_index_rec_old.attribute5;
1807: END IF;
1808:
1809: IF p_rent_index_rec.attribute6 IS NULL OR p_rent_index_rec.attribute6 = pn_index_rent_utils.g_pn_miss_char
1810: THEN
1811: p_rent_index_rec.attribute6 := l_rent_index_rec_old.attribute6;
1812: END IF;
1813:
1810: THEN
1811: p_rent_index_rec.attribute6 := l_rent_index_rec_old.attribute6;
1812: END IF;
1813:
1814: IF p_rent_index_rec.attribute7 IS NULL OR p_rent_index_rec.attribute7 = pn_index_rent_utils.g_pn_miss_char
1815: THEN
1816: p_rent_index_rec.attribute7 := l_rent_index_rec_old.attribute7;
1817: END IF;
1818:
1815: THEN
1816: p_rent_index_rec.attribute7 := l_rent_index_rec_old.attribute7;
1817: END IF;
1818:
1819: IF p_rent_index_rec.attribute8 IS NULL OR p_rent_index_rec.attribute8 =pn_index_rent_utils.g_pn_miss_char
1820: THEN
1821: p_rent_index_rec.attribute8 := l_rent_index_rec_old.attribute8;
1822: END IF;
1823:
1820: THEN
1821: p_rent_index_rec.attribute8 := l_rent_index_rec_old.attribute8;
1822: END IF;
1823:
1824: IF p_rent_index_rec.attribute9 IS NULL OR p_rent_index_rec.attribute9 = pn_index_rent_utils.g_pn_miss_char
1825: THEN
1826: p_rent_index_rec.attribute9 := l_rent_index_rec_old.attribute9;
1827: END IF;
1828:
1825: THEN
1826: p_rent_index_rec.attribute9 := l_rent_index_rec_old.attribute9;
1827: END IF;
1828:
1829: IF p_rent_index_rec.attribute10 IS NULL OR p_rent_index_rec.attribute10 = pn_index_rent_utils.g_pn_miss_char
1830: THEN
1831: p_rent_index_rec.attribute10 := l_rent_index_rec_old.attribute10;
1832: END IF;
1833:
1830: THEN
1831: p_rent_index_rec.attribute10 := l_rent_index_rec_old.attribute10;
1832: END IF;
1833:
1834: IF p_rent_index_rec.attribute11 IS NULL OR p_rent_index_rec.attribute11 = pn_index_rent_utils.g_pn_miss_char
1835: THEN
1836: p_rent_index_rec.attribute11 := l_rent_index_rec_old.attribute11;
1837: END IF;
1838:
1835: THEN
1836: p_rent_index_rec.attribute11 := l_rent_index_rec_old.attribute11;
1837: END IF;
1838:
1839: IF p_rent_index_rec.attribute12 IS NULL OR p_rent_index_rec.attribute12 = pn_index_rent_utils.g_pn_miss_char
1840: THEN
1841: p_rent_index_rec.attribute12 := l_rent_index_rec_old.attribute12;
1842: END IF;
1843:
1840: THEN
1841: p_rent_index_rec.attribute12 := l_rent_index_rec_old.attribute12;
1842: END IF;
1843:
1844: IF p_rent_index_rec.attribute13 IS NULL OR p_rent_index_rec.attribute13 = pn_index_rent_utils.g_pn_miss_char
1845: THEN
1846: p_rent_index_rec.attribute13 := l_rent_index_rec_old.attribute13;
1847: END IF;
1848:
1845: THEN
1846: p_rent_index_rec.attribute13 := l_rent_index_rec_old.attribute13;
1847: END IF;
1848:
1849: IF p_rent_index_rec.attribute14 IS NULL OR p_rent_index_rec.attribute14 = pn_index_rent_utils.g_pn_miss_char
1850: THEN
1851: p_rent_index_rec.attribute14 := l_rent_index_rec_old.attribute14;
1852: END IF;
1853:
1850: THEN
1851: p_rent_index_rec.attribute14 := l_rent_index_rec_old.attribute14;
1852: END IF;
1853:
1854: IF p_rent_index_rec.attribute15 IS NULL OR p_rent_index_rec.attribute15 = pn_index_rent_utils.g_pn_miss_char
1855: THEN
1856: p_rent_index_rec.attribute15 := l_rent_index_rec_old.attribute15;
1857: END IF;
1858:
1855: THEN
1856: p_rent_index_rec.attribute15 := l_rent_index_rec_old.attribute15;
1857: END IF;
1858:
1859: IF p_rent_index_rec.agreement_category IS NULL OR p_rent_index_rec.agreement_category = pn_index_rent_utils.g_pn_miss_char
1860: THEN
1861: p_rent_index_rec.agreement_category := l_rent_index_rec_old.agreement_category;
1862: END IF;
1863:
1860: THEN
1861: p_rent_index_rec.agreement_category := l_rent_index_rec_old.agreement_category;
1862: END IF;
1863:
1864: IF p_rent_index_rec.agreement_attribute1 IS NULL OR p_rent_index_rec.agreement_attribute1 = pn_index_rent_utils.g_pn_miss_char
1865: THEN
1866: p_rent_index_rec.agreement_attribute1 := l_rent_index_rec_old.agreement_attribute1;
1867: END IF;
1868:
1865: THEN
1866: p_rent_index_rec.agreement_attribute1 := l_rent_index_rec_old.agreement_attribute1;
1867: END IF;
1868:
1869: IF p_rent_index_rec.agreement_attribute2 IS NULL OR p_rent_index_rec.agreement_attribute2 = pn_index_rent_utils.g_pn_miss_char
1870: THEN
1871: p_rent_index_rec.agreement_attribute2 := l_rent_index_rec_old.agreement_attribute2;
1872: END IF;
1873:
1870: THEN
1871: p_rent_index_rec.agreement_attribute2 := l_rent_index_rec_old.agreement_attribute2;
1872: END IF;
1873:
1874: IF p_rent_index_rec.agreement_attribute3 IS NULL OR p_rent_index_rec.agreement_attribute3 = pn_index_rent_utils.g_pn_miss_char
1875: THEN
1876: p_rent_index_rec.agreement_attribute3 := l_rent_index_rec_old.agreement_attribute3;
1877: END IF;
1878:
1875: THEN
1876: p_rent_index_rec.agreement_attribute3 := l_rent_index_rec_old.agreement_attribute3;
1877: END IF;
1878:
1879: IF p_rent_index_rec.agreement_attribute4 IS NULL OR p_rent_index_rec.agreement_attribute4 = pn_index_rent_utils.g_pn_miss_char
1880: THEN
1881: p_rent_index_rec.agreement_attribute4 := l_rent_index_rec_old.agreement_attribute4;
1882: END IF;
1883:
1880: THEN
1881: p_rent_index_rec.agreement_attribute4 := l_rent_index_rec_old.agreement_attribute4;
1882: END IF;
1883:
1884: IF p_rent_index_rec.agreement_attribute5 IS NULL OR p_rent_index_rec.agreement_attribute5 = pn_index_rent_utils.g_pn_miss_char
1885: THEN
1886: p_rent_index_rec.agreement_attribute5 := l_rent_index_rec_old.agreement_attribute5;
1887: END IF;
1888:
1885: THEN
1886: p_rent_index_rec.agreement_attribute5 := l_rent_index_rec_old.agreement_attribute5;
1887: END IF;
1888:
1889: IF p_rent_index_rec.agreement_attribute6 IS NULL OR p_rent_index_rec.agreement_attribute6 = pn_index_rent_utils.g_pn_miss_char
1890: THEN
1891: p_rent_index_rec.agreement_attribute6 := l_rent_index_rec_old.agreement_attribute6;
1892: END IF;
1893:
1890: THEN
1891: p_rent_index_rec.agreement_attribute6 := l_rent_index_rec_old.agreement_attribute6;
1892: END IF;
1893:
1894: IF p_rent_index_rec.agreement_attribute7 IS NULL OR p_rent_index_rec.agreement_attribute7 = pn_index_rent_utils.g_pn_miss_char
1895: THEN
1896: p_rent_index_rec.agreement_attribute7 := l_rent_index_rec_old.agreement_attribute7;
1897: END IF;
1898:
1895: THEN
1896: p_rent_index_rec.agreement_attribute7 := l_rent_index_rec_old.agreement_attribute7;
1897: END IF;
1898:
1899: IF p_rent_index_rec.agreement_attribute8 IS NULL OR p_rent_index_rec.agreement_attribute8 = pn_index_rent_utils.g_pn_miss_char
1900: THEN
1901: p_rent_index_rec.agreement_attribute8 := l_rent_index_rec_old.agreement_attribute8;
1902: END IF;
1903:
1900: THEN
1901: p_rent_index_rec.agreement_attribute8 := l_rent_index_rec_old.agreement_attribute8;
1902: END IF;
1903:
1904: IF p_rent_index_rec.agreement_attribute9 IS NULL OR p_rent_index_rec.agreement_attribute9 = pn_index_rent_utils.g_pn_miss_char
1905: THEN
1906: p_rent_index_rec.agreement_attribute9 := l_rent_index_rec_old.agreement_attribute9;
1907:
1908: END IF;
1906: p_rent_index_rec.agreement_attribute9 := l_rent_index_rec_old.agreement_attribute9;
1907:
1908: END IF;
1909:
1910: IF p_rent_index_rec.agreement_attribute10 IS NULL OR p_rent_index_rec.agreement_attribute10 = pn_index_rent_utils.g_pn_miss_char
1911: THEN
1912: p_rent_index_rec.agreement_attribute10 := l_rent_index_rec_old.agreement_attribute10;
1913:
1914: END IF;
1912: p_rent_index_rec.agreement_attribute10 := l_rent_index_rec_old.agreement_attribute10;
1913:
1914: END IF;
1915:
1916: IF p_rent_index_rec.agreement_attribute11 IS NULL OR p_rent_index_rec.agreement_attribute11 = pn_index_rent_utils.g_pn_miss_char
1917: THEN
1918: p_rent_index_rec.agreement_attribute11 := l_rent_index_rec_old.agreement_attribute11;
1919:
1920: END IF;
1918: p_rent_index_rec.agreement_attribute11 := l_rent_index_rec_old.agreement_attribute11;
1919:
1920: END IF;
1921:
1922: IF p_rent_index_rec.agreement_attribute12 IS NULL OR p_rent_index_rec.agreement_attribute12 = pn_index_rent_utils.g_pn_miss_char
1923: THEN
1924: p_rent_index_rec.agreement_attribute12 := l_rent_index_rec_old.agreement_attribute12;
1925: END IF;
1926:
1923: THEN
1924: p_rent_index_rec.agreement_attribute12 := l_rent_index_rec_old.agreement_attribute12;
1925: END IF;
1926:
1927: IF p_rent_index_rec.agreement_attribute13 IS NULL OR p_rent_index_rec.agreement_attribute13 = pn_index_rent_utils.g_pn_miss_char
1928: THEN
1929: p_rent_index_rec.agreement_attribute13 := l_rent_index_rec_old.agreement_attribute13;
1930:
1931: END IF;
1929: p_rent_index_rec.agreement_attribute13 := l_rent_index_rec_old.agreement_attribute13;
1930:
1931: END IF;
1932:
1933: IF p_rent_index_rec.agreement_attribute14 IS NULL OR p_rent_index_rec.agreement_attribute14 = pn_index_rent_utils.g_pn_miss_char
1934: THEN
1935: p_rent_index_rec.agreement_attribute14 := l_rent_index_rec_old.agreement_attribute14;
1936: END IF;
1937:
1934: THEN
1935: p_rent_index_rec.agreement_attribute14 := l_rent_index_rec_old.agreement_attribute14;
1936: END IF;
1937:
1938: IF p_rent_index_rec.agreement_attribute15 IS NULL OR p_rent_index_rec.agreement_attribute15 = pn_index_rent_utils.g_pn_miss_char
1939: THEN
1940: p_rent_index_rec.agreement_attribute15 := l_rent_index_rec_old.agreement_attribute15;
1941: END IF;
1942:
1940: p_rent_index_rec.agreement_attribute15 := l_rent_index_rec_old.agreement_attribute15;
1941: END IF;
1942:
1943:
1944: IF p_rent_index_rec.org_id IS NULL OR p_rent_index_rec.org_id = pn_index_rent_utils.g_pn_miss_num
1945: THEN
1946: p_rent_index_rec.org_id := l_rent_index_rec_old.org_id;
1947: END IF;
1948:
1947: END IF;
1948:
1949: -- Below Code has been commented by ViveK on 27NOV2010
1950: /*
1951: IF p_rent_index_rec.aggregation_flag IS NULL OR p_rent_index_rec.aggregation_flag = pn_index_rent_utils.g_pn_miss_char
1952: THEN
1953: IF
1954: p_rent_index_rec.aggregation_flag := l_rent_index_rec_old.aggregation_flag;
1955: END IF;
1953: IF
1954: p_rent_index_rec.aggregation_flag := l_rent_index_rec_old.aggregation_flag;
1955: END IF;
1956: */
1957: IF p_rent_index_rec.gross_flag IS NULL OR p_rent_index_rec.gross_flag = pn_index_rent_utils.g_pn_miss_char
1958: THEN
1959: p_rent_index_rec.gross_flag := l_rent_index_rec_old.gross_flag;
1960: END IF;
1961:
1958: THEN
1959: p_rent_index_rec.gross_flag := l_rent_index_rec_old.gross_flag;
1960: END IF;
1961:
1962: IF p_rent_index_rec.currency_code IS NULL OR p_rent_index_rec.currency_code = pn_index_rent_utils.g_pn_miss_char
1963: THEN
1964: p_rent_index_rec.currency_code := l_rent_index_rec_old.currency_code;
1965: END IF;
1966:
1963: THEN
1964: p_rent_index_rec.currency_code := l_rent_index_rec_old.currency_code;
1965: END IF;
1966:
1967: IF p_rent_index_rec.carry_forward_flag IS NULL OR p_rent_index_rec.carry_forward_flag = pn_index_rent_utils.g_pn_miss_char
1968: THEN
1969: p_rent_index_rec.carry_forward_flag := l_rent_index_rec_old.carry_forward_flag;
1970:
1971: END IF;
1969: p_rent_index_rec.carry_forward_flag := l_rent_index_rec_old.carry_forward_flag;
1970:
1971: END IF;
1972:
1973: IF p_rent_index_rec.retain_initial_basis_flag IS NULL OR p_rent_index_rec.retain_initial_basis_flag = pn_index_rent_utils.g_pn_miss_char
1974: THEN
1975: p_rent_index_rec.retain_initial_basis_flag :=
1976: l_rent_index_rec_old.retain_initial_basis_flag;
1977:
1976: l_rent_index_rec_old.retain_initial_basis_flag;
1977:
1978: END IF;
1979:
1980: IF p_rent_index_rec.index_multiplier IS NULL OR p_rent_index_rec.index_multiplier = pn_index_rent_utils.g_pn_miss_num
1981: THEN
1982: p_rent_index_rec.index_multiplier := l_rent_index_rec_old.index_multiplier;
1983: END IF;
1984:
1981: THEN
1982: p_rent_index_rec.index_multiplier := l_rent_index_rec_old.index_multiplier;
1983: END IF;
1984:
1985: IF p_rent_index_rec.vr_nbp_flag IS NULL OR p_rent_index_rec.vr_nbp_flag = pn_index_rent_utils.g_pn_miss_char
1986: THEN
1987:
1988: p_rent_index_rec.vr_nbp_flag := l_rent_index_rec_old.vr_nbp_flag;
1989:
1988: p_rent_index_rec.vr_nbp_flag := l_rent_index_rec_old.vr_nbp_flag;
1989:
1990: END IF;
1991:
1992: IF p_rent_index_rec.proration_rule IS NULL OR p_rent_index_rec.proration_rule = pn_index_rent_utils.g_pn_miss_char
1993: THEN
1994:
1995: p_rent_index_rec.proration_rule := l_rent_index_rec_old.proration_rule;
1996:
1995: p_rent_index_rec.proration_rule := l_rent_index_rec_old.proration_rule;
1996:
1997: END IF;
1998:
1999: IF p_rent_index_rec.proration_period_start_date IS NULL OR p_rent_index_rec.proration_period_start_date = pn_index_rent_utils.g_pn_miss_date
2000: THEN
2001:
2002: p_rent_index_rec.proration_period_start_date :=
2003: l_rent_index_rec_old.proration_period_start_date;
2091: , 3);
2092:
2093:
2094: IF p_rent_index_rec.org_id IS NOT NULL
2095: OR p_rent_index_rec.org_id <> pn_index_rent_utils.g_pn_miss_num
2096: THEN
2097: l_index_number_profile :=
2098: NVL (pn_mo_cache_utils.get_profile_value ('PN_AUTOMATIC_INDEX_RENT_NUMBERING'
2099: , p_rent_index_rec.org_id)
2113: THEN
2114:
2115: pn_index_rent_pvt.DEBUG ( g_pkg_name
2116: || g_program_unit
2117: || ' - Before calling PN_INDEX_RENT_UTILS.GET_INDEX_LEASE_ID index_lease_id - '|| p_rent_index_rec.index_lease_id
2118: , 3);
2119: --IF LTRIM (RTRIM (p_operation)) = 'UPDATE_INDEX_RENT'
2120: --THEN
2121: IF ( p_rent_index_rec.index_lease_number IS NOT NULL
2118: , 3);
2119: --IF LTRIM (RTRIM (p_operation)) = 'UPDATE_INDEX_RENT'
2120: --THEN
2121: IF ( p_rent_index_rec.index_lease_number IS NOT NULL
2122: AND p_rent_index_rec.index_lease_number <> pn_index_rent_utils.g_pn_miss_char)
2123: OR ( p_rent_index_rec.index_lease_id IS NOT NULL
2124: AND p_rent_index_rec.index_lease_id <> pn_index_rent_utils.g_pn_miss_num)
2125: THEN
2126: pn_index_rent_utils.get_index_lease_id
2120: --THEN
2121: IF ( p_rent_index_rec.index_lease_number IS NOT NULL
2122: AND p_rent_index_rec.index_lease_number <> pn_index_rent_utils.g_pn_miss_char)
2123: OR ( p_rent_index_rec.index_lease_id IS NOT NULL
2124: AND p_rent_index_rec.index_lease_id <> pn_index_rent_utils.g_pn_miss_num)
2125: THEN
2126: pn_index_rent_utils.get_index_lease_id
2127: (p_parameter_name => l_index_lease_id_param
2128: , p_operation => p_operation
2122: AND p_rent_index_rec.index_lease_number <> pn_index_rent_utils.g_pn_miss_char)
2123: OR ( p_rent_index_rec.index_lease_id IS NOT NULL
2124: AND p_rent_index_rec.index_lease_id <> pn_index_rent_utils.g_pn_miss_num)
2125: THEN
2126: pn_index_rent_utils.get_index_lease_id
2127: (p_parameter_name => l_index_lease_id_param
2128: , p_operation => p_operation
2129: , p_index_lease_number => p_rent_index_rec.index_lease_number
2130: , x_index_lease_id => p_rent_index_rec.index_lease_id
2134: , x_return_status => x_return_status);
2135:
2136: pn_index_rent_pvt.DEBUG ( g_pkg_name
2137: || g_program_unit
2138: || ' - PN_INDEX_RENT_UTILS.GET_INDEX_LEASE_ID returned index_lease_id - '|| p_rent_index_rec.index_lease_id
2139: , 3);
2140:
2141: IF x_return_status<>fnd_api.g_ret_sts_success
2142: THEN
2151:
2152:
2153: pn_index_rent_pvt.DEBUG ( g_pkg_name
2154: || g_program_unit
2155: || ' - Before calling PN_INDEX_RENT_UTILS.GET_INDEX_LEASE_ID index_lease_id - '|| p_rent_index_rec.index_lease_id
2156: , 3);
2157:
2158: IF LTRIM (RTRIM (p_operation)) <>'UPDATE_INDEX_RENT'
2159: THEN
2157:
2158: IF LTRIM (RTRIM (p_operation)) <>'UPDATE_INDEX_RENT'
2159: THEN
2160: IF ( p_rent_index_rec.index_lease_number IS NOT NULL
2161: AND p_rent_index_rec.index_lease_number <> pn_index_rent_utils.g_pn_miss_char)
2162: THEN
2163: IF l_index_number_profile = 'N'
2164: THEN
2165: --l_returnstatus := NULL;
2169: , x_index_lease_number => p_rent_index_rec.index_lease_number);
2170:
2171: pn_index_rent_pvt.DEBUG ( g_pkg_name
2172: || g_program_unit
2173: || ' - PN_INDEX_RENT_UTILS.GET_INDEX_LEASE_ID returned index_lease_id - 3'|| p_rent_index_rec.index_lease_id
2174: , 3);
2175:
2176:
2177: IF x_return_status IS NOT NULL AND x_return_status<>fnd_api.g_ret_sts_success
2204: -- Get the lease details for the passed Lease Number or Lease Id
2205: ------------------------------------------------------------------
2206: pn_index_rent_pvt.DEBUG ( g_pkg_name
2207: || g_program_unit||
2208: ' - Before calling pn_index_rent_utils.get_lease_id lease_id - '|| p_rent_index_rec.lease_id
2209: , 3);
2210: pn_index_rent_pvt.DEBUG ( g_pkg_name
2211: || g_program_unit ||
2212: ' - Before calling pn_index_rent_utils.get_lease_id lease_number - '|| p_rent_index_rec.lease_num
2208: ' - Before calling pn_index_rent_utils.get_lease_id lease_id - '|| p_rent_index_rec.lease_id
2209: , 3);
2210: pn_index_rent_pvt.DEBUG ( g_pkg_name
2211: || g_program_unit ||
2212: ' - Before calling pn_index_rent_utils.get_lease_id lease_number - '|| p_rent_index_rec.lease_num
2213: , 3);
2214: pn_index_rent_pvt.DEBUG ( g_pkg_name
2215: || g_program_unit||
2216: ' - Before calling pn_index_rent_utils.get_lease_id lease_name - '|| p_rent_index_rec.lease_name
2212: ' - Before calling pn_index_rent_utils.get_lease_id lease_number - '|| p_rent_index_rec.lease_num
2213: , 3);
2214: pn_index_rent_pvt.DEBUG ( g_pkg_name
2215: || g_program_unit||
2216: ' - Before calling pn_index_rent_utils.get_lease_id lease_name - '|| p_rent_index_rec.lease_name
2217: , 3);
2218:
2219: IF ( ( p_rent_index_rec.lease_id IS NOT NULL
2220: AND p_rent_index_rec.lease_id <> pn_index_rent_utils.g_pn_miss_num)
2216: ' - Before calling pn_index_rent_utils.get_lease_id lease_name - '|| p_rent_index_rec.lease_name
2217: , 3);
2218:
2219: IF ( ( p_rent_index_rec.lease_id IS NOT NULL
2220: AND p_rent_index_rec.lease_id <> pn_index_rent_utils.g_pn_miss_num)
2221: OR ( p_rent_index_rec.lease_num IS NOT NULL
2222: AND p_rent_index_rec.lease_num <> pn_index_rent_utils.g_pn_miss_char)
2223: OR ( p_rent_index_rec.lease_name IS NOT NULL
2224: AND p_rent_index_rec.lease_name <> pn_index_rent_utils.g_pn_miss_char))
2218:
2219: IF ( ( p_rent_index_rec.lease_id IS NOT NULL
2220: AND p_rent_index_rec.lease_id <> pn_index_rent_utils.g_pn_miss_num)
2221: OR ( p_rent_index_rec.lease_num IS NOT NULL
2222: AND p_rent_index_rec.lease_num <> pn_index_rent_utils.g_pn_miss_char)
2223: OR ( p_rent_index_rec.lease_name IS NOT NULL
2224: AND p_rent_index_rec.lease_name <> pn_index_rent_utils.g_pn_miss_char))
2225: THEN
2226: pn_index_rent_utils.get_lease_id
2220: AND p_rent_index_rec.lease_id <> pn_index_rent_utils.g_pn_miss_num)
2221: OR ( p_rent_index_rec.lease_num IS NOT NULL
2222: AND p_rent_index_rec.lease_num <> pn_index_rent_utils.g_pn_miss_char)
2223: OR ( p_rent_index_rec.lease_name IS NOT NULL
2224: AND p_rent_index_rec.lease_name <> pn_index_rent_utils.g_pn_miss_char))
2225: THEN
2226: pn_index_rent_utils.get_lease_id
2227: (p_parameter_name => l_lease_param
2228: , p_operation => p_operation
2222: AND p_rent_index_rec.lease_num <> pn_index_rent_utils.g_pn_miss_char)
2223: OR ( p_rent_index_rec.lease_name IS NOT NULL
2224: AND p_rent_index_rec.lease_name <> pn_index_rent_utils.g_pn_miss_char))
2225: THEN
2226: pn_index_rent_utils.get_lease_id
2227: (p_parameter_name => l_lease_param
2228: , p_operation => p_operation
2229: , p_lease_name => p_rent_index_rec.lease_name
2230: , p_lease_number => p_rent_index_rec.lease_num
2238: , x_return_status => x_return_status);
2239:
2240: pn_index_rent_pvt.DEBUG ( g_pkg_name
2241: || g_program_unit ||
2242: ' - After calling pn_index_rent_utils.get_lease_id lease_id - '|| p_rent_index_rec.lease_id
2243: , 3);
2244: pn_index_rent_pvt.DEBUG ( g_pkg_name
2245: || g_program_unit ||
2246: ' - After calling pn_index_rent_utils.get_lease_id lease_number - '|| p_rent_index_rec.lease_num
2242: ' - After calling pn_index_rent_utils.get_lease_id lease_id - '|| p_rent_index_rec.lease_id
2243: , 3);
2244: pn_index_rent_pvt.DEBUG ( g_pkg_name
2245: || g_program_unit ||
2246: ' - After calling pn_index_rent_utils.get_lease_id lease_number - '|| p_rent_index_rec.lease_num
2247: , 3);
2248: pn_index_rent_pvt.DEBUG ( g_pkg_name
2249: || g_program_unit ||
2250: ' - After calling pn_index_rent_utils.get_lease_id lease_name - '|| p_rent_index_rec.lease_name
2246: ' - After calling pn_index_rent_utils.get_lease_id lease_number - '|| p_rent_index_rec.lease_num
2247: , 3);
2248: pn_index_rent_pvt.DEBUG ( g_pkg_name
2249: || g_program_unit ||
2250: ' - After calling pn_index_rent_utils.get_lease_id lease_name - '|| p_rent_index_rec.lease_name
2251: , 3);
2252:
2253: IF x_return_status<>fnd_api.g_ret_sts_success
2254: THEN
2264: -- Get the location associated with Lease Number or Lease Id
2265: ------------------------------------------------------------------
2266: pn_index_rent_pvt.DEBUG ( g_pkg_name
2267: || g_program_unit ||
2268: ' - Before calling pn_index_rent_utils.get_location_id location_code - '|| p_rent_index_rec.location_id
2269: , 3);
2270:
2271: IF ( ( p_rent_index_rec.location_id IS NOT NULL
2272: AND p_rent_index_rec.location_id <> pn_index_rent_utils.g_pn_miss_num)
2268: ' - Before calling pn_index_rent_utils.get_location_id location_code - '|| p_rent_index_rec.location_id
2269: , 3);
2270:
2271: IF ( ( p_rent_index_rec.location_id IS NOT NULL
2272: AND p_rent_index_rec.location_id <> pn_index_rent_utils.g_pn_miss_num)
2273: OR ( p_rent_index_rec.location_code IS NOT NULL
2274: AND p_rent_index_rec.location_code <> pn_index_rent_utils.g_pn_miss_char))
2275: THEN
2276: pn_index_rent_utils.get_location_id (p_parameter_name => l_location_param
2270:
2271: IF ( ( p_rent_index_rec.location_id IS NOT NULL
2272: AND p_rent_index_rec.location_id <> pn_index_rent_utils.g_pn_miss_num)
2273: OR ( p_rent_index_rec.location_code IS NOT NULL
2274: AND p_rent_index_rec.location_code <> pn_index_rent_utils.g_pn_miss_char))
2275: THEN
2276: pn_index_rent_utils.get_location_id (p_parameter_name => l_location_param
2277: , p_operation => p_operation
2278: , p_lease_id => p_rent_index_rec.lease_id
2272: AND p_rent_index_rec.location_id <> pn_index_rent_utils.g_pn_miss_num)
2273: OR ( p_rent_index_rec.location_code IS NOT NULL
2274: AND p_rent_index_rec.location_code <> pn_index_rent_utils.g_pn_miss_char))
2275: THEN
2276: pn_index_rent_utils.get_location_id (p_parameter_name => l_location_param
2277: , p_operation => p_operation
2278: , p_lease_id => p_rent_index_rec.lease_id
2279: , p_location_code => p_rent_index_rec.location_code
2280: , p_org_id => p_rent_index_rec.org_id
2281: , x_location_id => p_rent_index_rec.location_id
2282: , x_return_status => x_return_status);
2283: pn_index_rent_pvt.DEBUG ( g_pkg_name
2284: || g_program_unit||
2285: ' - After calling pn_index_rent_utils.get_location_id location_code - '|| p_rent_index_rec.location_id
2286: , 3);
2287:
2288: IF x_return_status<>fnd_api.g_ret_sts_success
2289: THEN
2295: END IF;
2296:
2297: pn_index_rent_pvt.DEBUG ( g_pkg_name
2298: || g_program_unit||
2299: ' - Before calling pn_index_rent_utils.get_index_id index - '|| p_rent_index_rec.index_id
2300: , 3);
2301:
2302: -------------------------------------
2303: -- Validate the passed Index Id/Type
2302: -------------------------------------
2303: -- Validate the passed Index Id/Type
2304: -------------------------------------
2305: IF ( ( p_rent_index_rec.index_id IS NOT NULL
2306: AND p_rent_index_rec.index_id <> pn_index_rent_utils.g_pn_miss_num)
2307: OR ( p_rent_index_rec.index_type IS NOT NULL
2308: AND p_rent_index_rec.index_type <> pn_index_rent_utils.g_pn_miss_char))
2309: THEN
2310: pn_index_rent_utils.get_index_id (p_parameter_name => l_index_id_param
2304: -------------------------------------
2305: IF ( ( p_rent_index_rec.index_id IS NOT NULL
2306: AND p_rent_index_rec.index_id <> pn_index_rent_utils.g_pn_miss_num)
2307: OR ( p_rent_index_rec.index_type IS NOT NULL
2308: AND p_rent_index_rec.index_type <> pn_index_rent_utils.g_pn_miss_char))
2309: THEN
2310: pn_index_rent_utils.get_index_id (p_parameter_name => l_index_id_param
2311: , p_operation => p_operation
2312: , p_index_name => p_rent_index_rec.index_type
2306: AND p_rent_index_rec.index_id <> pn_index_rent_utils.g_pn_miss_num)
2307: OR ( p_rent_index_rec.index_type IS NOT NULL
2308: AND p_rent_index_rec.index_type <> pn_index_rent_utils.g_pn_miss_char))
2309: THEN
2310: pn_index_rent_utils.get_index_id (p_parameter_name => l_index_id_param
2311: , p_operation => p_operation
2312: , p_index_name => p_rent_index_rec.index_type
2313: , x_index_id => p_rent_index_rec.index_id
2314: , x_return_status => x_return_status);
2313: , x_index_id => p_rent_index_rec.index_id
2314: , x_return_status => x_return_status);
2315: pn_index_rent_pvt.DEBUG ( g_pkg_name
2316: || g_program_unit ||
2317: ' - After calling pn_index_rent_utils.get_index_id index - '|| p_rent_index_rec.index_id
2318: , 3);
2319:
2320: IF x_return_status<>fnd_api.g_ret_sts_success
2321: THEN
2340: ' - Before validating index termination date - '|| p_rent_index_rec.termination_date
2341: , 3);
2342:
2343: IF ( ( p_rent_index_rec.commencement_date IS NULL
2344: OR p_rent_index_rec.commencement_date = pn_index_rent_utils.g_pn_miss_date))
2345: THEN
2346:
2347: p_rent_index_rec.commencement_date := ADD_MONTHS (l_lease_commencement_date, 12);
2348:
2349: END IF;
2350:
2351:
2352: IF ( ( p_rent_index_rec.termination_date IS NULL
2353: OR p_rent_index_rec.termination_date = pn_index_rent_utils.g_pn_miss_date))
2354: THEN
2355:
2356: p_rent_index_rec.termination_date := GREATEST (l_lease_termination_date, NVL (l_lease_extension_end_date, l_lease_termination_date));
2357: END IF;
2356: p_rent_index_rec.termination_date := GREATEST (l_lease_termination_date, NVL (l_lease_extension_end_date, l_lease_termination_date));
2357: END IF;
2358:
2359: IF ( ( p_rent_index_rec.commencement_date IS NOT NULL
2360: AND p_rent_index_rec.commencement_date <> pn_index_rent_utils.g_pn_miss_date)
2361: AND ( p_rent_index_rec.termination_date IS NOT NULL
2362: AND p_rent_index_rec.termination_date <> pn_index_rent_utils.g_pn_miss_date))
2363: THEN
2364: IF ( (p_rent_index_rec.commencement_date < l_lease_commencement_date)
2358:
2359: IF ( ( p_rent_index_rec.commencement_date IS NOT NULL
2360: AND p_rent_index_rec.commencement_date <> pn_index_rent_utils.g_pn_miss_date)
2361: AND ( p_rent_index_rec.termination_date IS NOT NULL
2362: AND p_rent_index_rec.termination_date <> pn_index_rent_utils.g_pn_miss_date))
2363: THEN
2364: IF ( (p_rent_index_rec.commencement_date < l_lease_commencement_date)
2365: OR (p_rent_index_rec.commencement_date >
2366: GREATEST (l_lease_termination_date
2421: -- Validate the passed User Responsible
2422: ---------------------------------------
2423: pn_index_rent_pvt.DEBUG ( g_pkg_name
2424: || g_program_unit||
2425: ' - Before calling pn_index_rent_utils.get_user_id - '|| p_rent_index_rec.abstracted_by
2426: , 3);
2427:
2428: IF ( ( p_rent_index_rec.abstracted_by IS NOT NULL
2429: AND p_rent_index_rec.abstracted_by <> pn_index_rent_utils.g_pn_miss_num)
2425: ' - Before calling pn_index_rent_utils.get_user_id - '|| p_rent_index_rec.abstracted_by
2426: , 3);
2427:
2428: IF ( ( p_rent_index_rec.abstracted_by IS NOT NULL
2429: AND p_rent_index_rec.abstracted_by <> pn_index_rent_utils.g_pn_miss_num)
2430: OR ( p_rent_index_rec.abstracted_by_username IS NOT NULL
2431: AND p_rent_index_rec.abstracted_by_username <> pn_index_rent_utils.g_pn_miss_char))
2432: THEN
2433: pn_index_rent_utils.get_user_id (p_parameter_name => l_abstracted_by_param
2427:
2428: IF ( ( p_rent_index_rec.abstracted_by IS NOT NULL
2429: AND p_rent_index_rec.abstracted_by <> pn_index_rent_utils.g_pn_miss_num)
2430: OR ( p_rent_index_rec.abstracted_by_username IS NOT NULL
2431: AND p_rent_index_rec.abstracted_by_username <> pn_index_rent_utils.g_pn_miss_char))
2432: THEN
2433: pn_index_rent_utils.get_user_id (p_parameter_name => l_abstracted_by_param
2434: , p_operation => p_operation
2435: , p_user_name => p_rent_index_rec.abstracted_by_username
2429: AND p_rent_index_rec.abstracted_by <> pn_index_rent_utils.g_pn_miss_num)
2430: OR ( p_rent_index_rec.abstracted_by_username IS NOT NULL
2431: AND p_rent_index_rec.abstracted_by_username <> pn_index_rent_utils.g_pn_miss_char))
2432: THEN
2433: pn_index_rent_utils.get_user_id (p_parameter_name => l_abstracted_by_param
2434: , p_operation => p_operation
2435: , p_user_name => p_rent_index_rec.abstracted_by_username
2436: , x_user_id => p_rent_index_rec.abstracted_by
2437: , x_return_status => x_return_status);
2446: END IF;
2447:
2448: pn_index_rent_pvt.DEBUG ( g_pkg_name
2449: || g_program_unit||
2450: ' - After calling pn_index_rent_utils.get_user_id - '|| p_rent_index_rec.abstracted_by
2451: , 3);
2452:
2453: -------------------------------------
2454: -- Validate the passed Currency Code
2454: -- Validate the passed Currency Code
2455: -------------------------------------
2456: pn_index_rent_pvt.DEBUG ( g_pkg_name
2457: || g_program_unit||
2458: ' - Before pn_index_rent_utils.get_currency_code currency code - '|| p_rent_index_rec.currency_code
2459: , 3);
2460: /*
2461: IF ( p_rent_index_rec.currency_code IS NOT NULL
2462: AND p_rent_index_rec.currency_code <> pn_index_rent_utils.g_pn_miss_char)
2458: ' - Before pn_index_rent_utils.get_currency_code currency code - '|| p_rent_index_rec.currency_code
2459: , 3);
2460: /*
2461: IF ( p_rent_index_rec.currency_code IS NOT NULL
2462: AND p_rent_index_rec.currency_code <> pn_index_rent_utils.g_pn_miss_char)
2463: THEN
2464: pn_index_rent_utils.get_currency_code (p_parameter_name => l_currency_code_param
2465: , p_operation => p_operation
2466: , p_functional_currency_code => l_func_curr_code
2460: /*
2461: IF ( p_rent_index_rec.currency_code IS NOT NULL
2462: AND p_rent_index_rec.currency_code <> pn_index_rent_utils.g_pn_miss_char)
2463: THEN
2464: pn_index_rent_utils.get_currency_code (p_parameter_name => l_currency_code_param
2465: , p_operation => p_operation
2466: , p_functional_currency_code => l_func_curr_code
2467: , x_currency_code => p_rent_index_rec.currency_code
2468: , x_user_conversion_type => l_user_conversion_type
2479: p_rent_index_rec.currency_code:= l_func_curr_code;
2480:
2481: pn_index_rent_pvt.DEBUG ( g_pkg_name
2482: || g_program_unit||
2483: ' - After pn_index_rent_utils.get_currency_code currency code - '|| p_rent_index_rec.currency_code
2484: , 3);
2485:
2486: ------------------------------------------
2487: -- Validate the passed Assessment Interval
2491: ' - Before validation assessment_interval - '|| p_rent_index_rec.assessment_interval
2492: , 3);
2493:
2494: IF ( p_rent_index_rec.assessment_interval IS NOT NULL
2495: AND p_rent_index_rec.assessment_interval <> pn_index_rent_utils.g_pn_miss_num)
2496: THEN
2497: l_mod := MOD (p_rent_index_rec.assessment_interval, 1);
2498:
2499: IF p_rent_index_rec.assessment_interval <= 0
2515: ------------------------------------------
2516: -- Validate the passed Assessment Date
2517: ------------------------------------------
2518: IF ( p_rent_index_rec.assessment_date IS NOT NULL
2519: AND p_rent_index_rec.assessment_date <> pn_index_rent_utils.g_pn_miss_date)
2520: THEN
2521: -- MESSAGE NAME- PN_INVALID_ASSESS_DATE
2522: p_rent_index_rec.assessment_date := ADD_MONTHS (l_lease_commencement_date, 12);
2523: END IF;
2526: -- Validate the passed Increase On
2527: -----------------------------------
2528: pn_index_rent_pvt.DEBUG ( g_pkg_name
2529: || g_program_unit||
2530: ' - Before calling pn_index_rent_utils.get_increase_on increase_on - '|| p_rent_index_rec.increase_on
2531: , 3);
2532: IF ( p_rent_index_rec.increase_on IS NOT NULL
2533: AND p_rent_index_rec.increase_on <> pn_index_rent_utils.g_pn_miss_char)
2534: OR ( p_rent_index_rec.increase_on_meaning IS NOT NULL
2529: || g_program_unit||
2530: ' - Before calling pn_index_rent_utils.get_increase_on increase_on - '|| p_rent_index_rec.increase_on
2531: , 3);
2532: IF ( p_rent_index_rec.increase_on IS NOT NULL
2533: AND p_rent_index_rec.increase_on <> pn_index_rent_utils.g_pn_miss_char)
2534: OR ( p_rent_index_rec.increase_on_meaning IS NOT NULL
2535: AND p_rent_index_rec.increase_on_meaning <> pn_index_rent_utils.g_pn_miss_char)
2536: THEN
2537: pn_index_rent_utils.get_increase_on
2531: , 3);
2532: IF ( p_rent_index_rec.increase_on IS NOT NULL
2533: AND p_rent_index_rec.increase_on <> pn_index_rent_utils.g_pn_miss_char)
2534: OR ( p_rent_index_rec.increase_on_meaning IS NOT NULL
2535: AND p_rent_index_rec.increase_on_meaning <> pn_index_rent_utils.g_pn_miss_char)
2536: THEN
2537: pn_index_rent_utils.get_increase_on
2538: (p_parameter_name => l_increase_on_param
2539: , p_operation => p_operation
2533: AND p_rent_index_rec.increase_on <> pn_index_rent_utils.g_pn_miss_char)
2534: OR ( p_rent_index_rec.increase_on_meaning IS NOT NULL
2535: AND p_rent_index_rec.increase_on_meaning <> pn_index_rent_utils.g_pn_miss_char)
2536: THEN
2537: pn_index_rent_utils.get_increase_on
2538: (p_parameter_name => l_increase_on_param
2539: , p_operation => p_operation
2540: , p_lookup_meaning => p_rent_index_rec.increase_on_meaning
2541: , p_lease_id => p_rent_index_rec.lease_id
2554: END IF;
2555:
2556: pn_index_rent_pvt.DEBUG ( g_pkg_name
2557: || g_program_unit||
2558: ' - After calling pn_index_rent_utils.get_increase_on increase_on - '|| p_rent_index_rec.increase_on
2559: , 3);
2560:
2561: IF ( p_rent_index_rec.increase_on IS NOT NULL
2562: AND p_rent_index_rec.increase_on <> pn_index_rent_utils.g_pn_miss_char)
2558: ' - After calling pn_index_rent_utils.get_increase_on increase_on - '|| p_rent_index_rec.increase_on
2559: , 3);
2560:
2561: IF ( p_rent_index_rec.increase_on IS NOT NULL
2562: AND p_rent_index_rec.increase_on <> pn_index_rent_utils.g_pn_miss_char)
2563: THEN
2564: p_rent_index_rec.gross_flag := 'N';
2565: END IF;
2566:
2569: -- Validate the passed Reference Period
2570: ----------------------------------------
2571: pn_index_rent_pvt.DEBUG ( g_pkg_name
2572: || g_program_unit||
2573: ' - Before calling pn_index_rent_utils.get_lookup_code reference_period - '|| p_rent_index_rec.reference_period
2574: , 3);
2575:
2576:
2577: IF ( ( p_rent_index_rec.reference_period IS NOT NULL
2574: , 3);
2575:
2576:
2577: IF ( ( p_rent_index_rec.reference_period IS NOT NULL
2578: AND p_rent_index_rec.reference_period <> pn_index_rent_utils.g_pn_miss_char)
2579: OR ( p_rent_index_rec.reference_period_meaning IS NOT NULL
2580: AND p_rent_index_rec.reference_period_meaning <> pn_index_rent_utils.g_pn_miss_char))
2581: THEN
2582: pn_index_rent_utils.get_lookup_code
2576:
2577: IF ( ( p_rent_index_rec.reference_period IS NOT NULL
2578: AND p_rent_index_rec.reference_period <> pn_index_rent_utils.g_pn_miss_char)
2579: OR ( p_rent_index_rec.reference_period_meaning IS NOT NULL
2580: AND p_rent_index_rec.reference_period_meaning <> pn_index_rent_utils.g_pn_miss_char))
2581: THEN
2582: pn_index_rent_utils.get_lookup_code
2583: (p_parameter_name => l_reference_period_param
2584: , p_operation => p_operation
2578: AND p_rent_index_rec.reference_period <> pn_index_rent_utils.g_pn_miss_char)
2579: OR ( p_rent_index_rec.reference_period_meaning IS NOT NULL
2580: AND p_rent_index_rec.reference_period_meaning <> pn_index_rent_utils.g_pn_miss_char))
2581: THEN
2582: pn_index_rent_utils.get_lookup_code
2583: (p_parameter_name => l_reference_period_param
2584: , p_operation => p_operation
2585: , p_lookup_meaning => p_rent_index_rec.reference_period_meaning
2586: , p_lookup_type => l_reference_period_type
2601: END IF;
2602:
2603: pn_index_rent_pvt.DEBUG ( g_pkg_name
2604: || g_program_unit||
2605: ' - After calling pn_index_rent_utils.get_lookup_code reference_period - '|| p_rent_index_rec.reference_period
2606: , 3);
2607:
2608:
2609: ----------------------------------
2610: -- Validate the passed Basis Type
2611: ----------------------------------
2612: pn_index_rent_pvt.DEBUG ( g_pkg_name
2613: || g_program_unit||
2614: ' - Before calling pn_index_rent_utils.get_lookup_code basis_type - '|| p_rent_index_rec.basis_type
2615: , 3);
2616:
2617: IF ( ( p_rent_index_rec.basis_type IS NOT NULL
2618: AND p_rent_index_rec.basis_type <> pn_index_rent_utils.g_pn_miss_char)
2614: ' - Before calling pn_index_rent_utils.get_lookup_code basis_type - '|| p_rent_index_rec.basis_type
2615: , 3);
2616:
2617: IF ( ( p_rent_index_rec.basis_type IS NOT NULL
2618: AND p_rent_index_rec.basis_type <> pn_index_rent_utils.g_pn_miss_char)
2619: OR ( p_rent_index_rec.basis_type_meaning IS NOT NULL
2620: AND p_rent_index_rec.basis_type_meaning <> pn_index_rent_utils.g_pn_miss_char))
2621: THEN
2622: pn_index_rent_utils.get_lookup_code
2616:
2617: IF ( ( p_rent_index_rec.basis_type IS NOT NULL
2618: AND p_rent_index_rec.basis_type <> pn_index_rent_utils.g_pn_miss_char)
2619: OR ( p_rent_index_rec.basis_type_meaning IS NOT NULL
2620: AND p_rent_index_rec.basis_type_meaning <> pn_index_rent_utils.g_pn_miss_char))
2621: THEN
2622: pn_index_rent_utils.get_lookup_code
2623: (p_parameter_name => l_basis_type_param
2624: , p_operation => p_operation
2618: AND p_rent_index_rec.basis_type <> pn_index_rent_utils.g_pn_miss_char)
2619: OR ( p_rent_index_rec.basis_type_meaning IS NOT NULL
2620: AND p_rent_index_rec.basis_type_meaning <> pn_index_rent_utils.g_pn_miss_char))
2621: THEN
2622: pn_index_rent_utils.get_lookup_code
2623: (p_parameter_name => l_basis_type_param
2624: , p_operation => p_operation
2625: , p_lookup_meaning => p_rent_index_rec.basis_type_meaning
2626: , p_lookup_type => l_basis_type_type
2636: END IF;
2637:
2638: pn_index_rent_pvt.DEBUG ( g_pkg_name
2639: || g_program_unit||
2640: ' - After calling pn_index_rent_utils.get_lookup_code basis_type - '|| p_rent_index_rec.basis_type
2641: , 3);
2642:
2643: ------------------------------------------
2644: -- Validate the passed Index Finder Method
2644: -- Validate the passed Index Finder Method
2645: ------------------------------------------
2646: pn_index_rent_pvt.DEBUG ( g_pkg_name
2647: || g_program_unit||
2648: ' - Before calling pn_index_rent_utils.get_lookup_code index_finder_method - '|| p_rent_index_rec.index_finder_method
2649: , 3);
2650:
2651: IF ( ( p_rent_index_rec.index_finder_method IS NOT NULL
2652: AND p_rent_index_rec.index_finder_method <> pn_index_rent_utils.g_pn_miss_char)
2648: ' - Before calling pn_index_rent_utils.get_lookup_code index_finder_method - '|| p_rent_index_rec.index_finder_method
2649: , 3);
2650:
2651: IF ( ( p_rent_index_rec.index_finder_method IS NOT NULL
2652: AND p_rent_index_rec.index_finder_method <> pn_index_rent_utils.g_pn_miss_char)
2653: OR ( p_rent_index_rec.index_finder_method_meaning IS NOT NULL
2654: AND p_rent_index_rec.index_finder_method_meaning <> pn_index_rent_utils.g_pn_miss_char))
2655: THEN
2656: pn_index_rent_utils.get_lookup_code
2650:
2651: IF ( ( p_rent_index_rec.index_finder_method IS NOT NULL
2652: AND p_rent_index_rec.index_finder_method <> pn_index_rent_utils.g_pn_miss_char)
2653: OR ( p_rent_index_rec.index_finder_method_meaning IS NOT NULL
2654: AND p_rent_index_rec.index_finder_method_meaning <> pn_index_rent_utils.g_pn_miss_char))
2655: THEN
2656: pn_index_rent_utils.get_lookup_code
2657: (p_parameter_name => l_index_finder_param
2658: , p_operation => p_operation
2652: AND p_rent_index_rec.index_finder_method <> pn_index_rent_utils.g_pn_miss_char)
2653: OR ( p_rent_index_rec.index_finder_method_meaning IS NOT NULL
2654: AND p_rent_index_rec.index_finder_method_meaning <> pn_index_rent_utils.g_pn_miss_char))
2655: THEN
2656: pn_index_rent_utils.get_lookup_code
2657: (p_parameter_name => l_index_finder_param
2658: , p_operation => p_operation
2659: , p_lookup_meaning => p_rent_index_rec.index_finder_method_meaning
2660: , p_lookup_type => l_index_finder_method_type
2675: END IF;
2676:
2677: pn_index_rent_pvt.DEBUG ( g_pkg_name
2678: || g_program_unit||
2679: ' - After calling pn_index_rent_utils.get_lookup_code index_finder_method - '|| p_rent_index_rec.index_finder_method
2680: , 3);
2681:
2682: ----------------------------------------
2683: -- Validate the passed Default Relation
2683: -- Validate the passed Default Relation
2684: -----------------------------------------
2685: pn_index_rent_pvt.DEBUG ( g_pkg_name
2686: || g_program_unit||
2687: ' - Before calling pn_index_rent_utils.get_lookup_code relationship_default - '|| p_rent_index_rec.relationship_default
2688: , 3);
2689:
2690: IF ( ( p_rent_index_rec.relationship_default IS NOT NULL
2691: AND p_rent_index_rec.relationship_default <> pn_index_rent_utils.g_pn_miss_char)
2687: ' - Before calling pn_index_rent_utils.get_lookup_code relationship_default - '|| p_rent_index_rec.relationship_default
2688: , 3);
2689:
2690: IF ( ( p_rent_index_rec.relationship_default IS NOT NULL
2691: AND p_rent_index_rec.relationship_default <> pn_index_rent_utils.g_pn_miss_char)
2692: OR ( p_rent_index_rec.relationship_default_meaning IS NOT NULL
2693: AND p_rent_index_rec.relationship_default_meaning <>
2694: pn_index_rent_utils.g_pn_miss_char))
2695: THEN
2690: IF ( ( p_rent_index_rec.relationship_default IS NOT NULL
2691: AND p_rent_index_rec.relationship_default <> pn_index_rent_utils.g_pn_miss_char)
2692: OR ( p_rent_index_rec.relationship_default_meaning IS NOT NULL
2693: AND p_rent_index_rec.relationship_default_meaning <>
2694: pn_index_rent_utils.g_pn_miss_char))
2695: THEN
2696: pn_index_rent_utils.get_lookup_code
2697: (p_parameter_name => l_relationship_default_param
2698: , p_operation => p_operation
2692: OR ( p_rent_index_rec.relationship_default_meaning IS NOT NULL
2693: AND p_rent_index_rec.relationship_default_meaning <>
2694: pn_index_rent_utils.g_pn_miss_char))
2695: THEN
2696: pn_index_rent_utils.get_lookup_code
2697: (p_parameter_name => l_relationship_default_param
2698: , p_operation => p_operation
2699: , p_lookup_meaning => p_rent_index_rec.relationship_default_meaning
2700: , p_lookup_type => l_relationship_default_type
2709: END IF;
2710: END IF;
2711:
2712: IF LTRIM (RTRIM (p_operation)) <>'UPDATE_INDEX_RENT'
2713: AND (p_rent_index_rec.relationship_default IS NULL OR p_rent_index_rec.relationship_default =pn_index_rent_utils.g_pn_miss_char)
2714:
2715: THEN
2716: p_rent_index_rec.relationship_default := 'INDEX_ONLY';
2717: END IF;
2716: p_rent_index_rec.relationship_default := 'INDEX_ONLY';
2717: END IF;
2718: pn_index_rent_pvt.DEBUG ( g_pkg_name
2719: || g_program_unit||
2720: ' - After calling pn_index_rent_utils.get_lookup_code relationship_default - '|| p_rent_index_rec.relationship_default
2721: ,3);
2722:
2723: -------------------------------------
2724: -- Validate the passed Term Template
2814: -------------------------------------
2815:
2816: pn_index_rent_pvt.DEBUG ( g_pkg_name
2817: || g_program_unit||
2818: ' - Before calling pn_index_rent_utils.get_lookup_code negative_rent_type - '|| p_rent_index_rec.negative_rent_type
2819: ,3);
2820:
2821:
2822: IF ( ( p_rent_index_rec.negative_rent_type IS NOT NULL
2823: AND p_rent_index_rec.negative_rent_type <> pn_lease_utils.g_pn_miss_char)
2824: OR ( p_rent_index_rec.negative_rent_type_meaning IS NOT NULL
2825: AND p_rent_index_rec.negative_rent_type_meaning <> pn_lease_utils.g_pn_miss_char))
2826: THEN
2827: pn_index_rent_utils.get_lookup_code
2828: (p_parameter_name => l_negative_rent_type_param
2829: , p_operation => p_operation
2830: , p_lookup_meaning => p_rent_index_rec.negative_rent_type_meaning
2831: , p_lookup_type => l_negative_rent_type
2841: END IF;
2842:
2843:
2844: IF LTRIM (RTRIM (p_operation)) <>'UPDATE_INDEX_RENT'
2845: AND (p_rent_index_rec.negative_rent_type IS NULL OR p_rent_index_rec.negative_rent_type =pn_index_rent_utils.g_pn_miss_char)
2846:
2847: THEN
2848: p_rent_index_rec.negative_rent_type := 'IGNORE';
2849: END IF;
2849: END IF;
2850:
2851: pn_index_rent_pvt.DEBUG ( g_pkg_name
2852: || g_program_unit||
2853: ' - After calling pn_index_rent_utils.get_lookup_code negative_rent_type - '|| p_rent_index_rec.negative_rent_type
2854: ,3);
2855:
2856: ----------------------------------------
2857: -- Validate the passed Spread Frequency
2858: ----------------------------------------
2859:
2860: pn_index_rent_pvt.DEBUG ( g_pkg_name
2861: || g_program_unit||
2862: ' - Before calling pn_index_rent_utils.get_lookup_code spread_frequency - '|| p_rent_index_rec.spread_frequency
2863: ,3);
2864:
2865: IF ( ( p_rent_index_rec.spread_frequency IS NOT NULL
2866: AND p_rent_index_rec.spread_frequency <> pn_lease_utils.g_pn_miss_char)
2866: AND p_rent_index_rec.spread_frequency <> pn_lease_utils.g_pn_miss_char)
2867: OR ( p_rent_index_rec.spread_frequency_meaning IS NOT NULL
2868: AND p_rent_index_rec.spread_frequency_meaning <> pn_lease_utils.g_pn_miss_char))
2869: THEN
2870: pn_index_rent_utils.get_lookup_code
2871: (p_parameter_name => l_spread_frequency_param
2872: , p_operation => p_operation
2873: , p_lookup_meaning => p_rent_index_rec.spread_frequency_meaning
2874: , p_lookup_type => l_spread_frequency_type
2890: p_rent_index_rec.spread_frequency:='MON';
2891: END IF;
2892: pn_index_rent_pvt.DEBUG ( g_pkg_name
2893: || g_program_unit||
2894: ' - After calling pn_index_rent_utils.get_lookup_code spread_frequency - '|| p_rent_index_rec.spread_frequency
2895: ,3);
2896:
2897:
2898: ------------------------------------------
3009: ------------------------------------------
3010:
3011: pn_index_rent_pvt.DEBUG ( g_pkg_name
3012: || g_program_unit||
3013: ' - Before calling pn_index_rent_utils.get_lookup_code proration_rule - '|| p_rent_index_rec.proration_rule
3014: ,3);
3015:
3016: IF ( ( p_rent_index_rec.proration_rule IS NOT NULL
3017: AND p_rent_index_rec.proration_rule <> pn_lease_utils.g_pn_miss_char)
3017: AND p_rent_index_rec.proration_rule <> pn_lease_utils.g_pn_miss_char)
3018: OR ( p_rent_index_rec.proration_rule_meaning IS NOT NULL
3019: AND p_rent_index_rec.proration_rule_meaning <> pn_lease_utils.g_pn_miss_char))
3020: THEN
3021: pn_index_rent_utils.get_lookup_code
3022: (p_parameter_name => l_constraint_proration_param
3023: , p_operation => p_operation
3024: , p_lookup_meaning => p_rent_index_rec.proration_rule_meaning
3025: , p_lookup_type => l_constraint_proration_type
3035: END IF;
3036: END IF;
3037: pn_index_rent_pvt.DEBUG ( g_pkg_name
3038: || g_program_unit||
3039: ' - After calling pn_index_rent_utils.get_lookup_code proration_rule - '|| p_rent_index_rec.proration_rule
3040: ,3);
3041:
3042: IF ( ( p_rent_index_rec.index_id IS NOT NULL
3043: AND p_rent_index_rec.index_id <> pn_index_rent_utils.g_pn_miss_num)
3039: ' - After calling pn_index_rent_utils.get_lookup_code proration_rule - '|| p_rent_index_rec.proration_rule
3040: ,3);
3041:
3042: IF ( ( p_rent_index_rec.index_id IS NOT NULL
3043: AND p_rent_index_rec.index_id <> pn_index_rent_utils.g_pn_miss_num)
3044: AND ( p_rent_index_rec.commencement_date IS NOT NULL
3045: AND p_rent_index_rec.commencement_date <> pn_index_rent_utils.g_pn_miss_date))
3046: THEN
3047: IF p_rent_index_rec.base_year IS NULL OR p_rent_index_rec.base_year = pn_index_rent_utils.g_pn_miss_date
3041:
3042: IF ( ( p_rent_index_rec.index_id IS NOT NULL
3043: AND p_rent_index_rec.index_id <> pn_index_rent_utils.g_pn_miss_num)
3044: AND ( p_rent_index_rec.commencement_date IS NOT NULL
3045: AND p_rent_index_rec.commencement_date <> pn_index_rent_utils.g_pn_miss_date))
3046: THEN
3047: IF p_rent_index_rec.base_year IS NULL OR p_rent_index_rec.base_year = pn_index_rent_utils.g_pn_miss_date
3048: THEN
3049: IF LTRIM (RTRIM (p_operation)) <>'UPDATE_INDEX_RENT' -- Added by vivek on 22NOV2010
3043: AND p_rent_index_rec.index_id <> pn_index_rent_utils.g_pn_miss_num)
3044: AND ( p_rent_index_rec.commencement_date IS NOT NULL
3045: AND p_rent_index_rec.commencement_date <> pn_index_rent_utils.g_pn_miss_date))
3046: THEN
3047: IF p_rent_index_rec.base_year IS NULL OR p_rent_index_rec.base_year = pn_index_rent_utils.g_pn_miss_date
3048: THEN
3049: IF LTRIM (RTRIM (p_operation)) <>'UPDATE_INDEX_RENT' -- Added by vivek on 22NOV2010
3050: THEN
3051: p_rent_index_rec.base_year := p_rent_index_rec.commencement_date;
3061: ,3);
3062:
3063:
3064: IF (( p_rent_index_rec.base_year IS NOT NULL
3065: AND p_rent_index_rec.base_year <> pn_index_rent_utils.g_pn_miss_date)
3066: --AND ( p_rent_index_rec.base_index_line_id IS NOT NULL
3067: -- AND p_rent_index_rec.base_index_line_id <> pn_index_rent_utils.g_pn_miss_num))
3068: )
3069: THEN
3063:
3064: IF (( p_rent_index_rec.base_year IS NOT NULL
3065: AND p_rent_index_rec.base_year <> pn_index_rent_utils.g_pn_miss_date)
3066: --AND ( p_rent_index_rec.base_index_line_id IS NOT NULL
3067: -- AND p_rent_index_rec.base_index_line_id <> pn_index_rent_utils.g_pn_miss_num))
3068: )
3069: THEN
3070: pn_index_lease_common_pkg.lookup_index_history
3071: (p_index_history_id => p_rent_index_rec.index_id
3075: , op_msg => x_return_status);
3076: END IF;
3077:
3078: IF p_rent_index_rec.index_id IS NULL
3079: OR p_rent_index_rec.index_id = pn_index_rent_utils.g_pn_miss_num
3080: THEN
3081:
3082: p_rent_index_rec.index_id:=l_base_index;
3083: p_rent_index_rec.base_index_line_id:=l_base_index_line_id;
3084: END IF;
3085:
3086: -- Below IF statements uncommented by Vivek on 10-Nov-2010
3087: IF p_rent_index_rec.reference_period IS NOT NULL
3088: AND p_rent_index_rec.reference_period <> pn_index_rent_utils.g_pn_miss_char
3089: AND p_rent_index_rec.reference_period = 'BASE_YEAR'
3090: THEN
3091: IF LTRIM (RTRIM (p_operation)) <>'UPDATE_INDEX_RENT' -- Added by vivek on 19NOV2010
3092: THEN
3095: ELSE
3096: IF LTRIM (RTRIM (p_operation)) <>'UPDATE_INDEX_RENT' -- Added by vivek on 19NOV2010
3097: THEN
3098: IF p_rent_index_rec.basis_type IS NULL
3099: OR p_rent_index_rec.basis_type=pn_index_rent_utils.g_pn_miss_char
3100: THEN
3101: p_rent_index_rec.basis_type := 'COMPOUND';
3102: END IF;
3103: END IF;
3105: --END IF;
3106:
3107:
3108: IF p_rent_index_rec.reference_period IS NOT NULL
3109: AND p_rent_index_rec.reference_period <> pn_index_rent_utils.g_pn_miss_char
3110: AND p_rent_index_rec.reference_period <> 'BASE_YEAR'
3111: AND p_rent_index_rec.basis_type <> 'ROLLING'
3112: AND p_rent_index_rec.basis_type <> 'COMPOUND'
3113: THEN
3127: END IF;
3128:
3129: -- Added by Vivek on 22Nov2010
3130: IF p_rent_index_rec.basis_type IS NOT NULL
3131: AND p_rent_index_rec.basis_type <> pn_index_rent_utils.g_pn_miss_char
3132: THEN
3133: IF NVL(p_rent_index_rec.reference_period,'PREV_YEAR_PREV_CURRENT_CPI') = 'BASE_YEAR'
3134: AND p_rent_index_rec.basis_type <> 'FIXED'
3135: THEN
3150: END IF;
3151: -- End of code added by Vivek on 22Nov2010
3152:
3153: IF p_rent_index_rec.relationship_default IS NOT NULL
3154: AND p_rent_index_rec.relationship_default <> pn_index_rent_utils.g_pn_miss_char
3155: AND p_rent_index_rec.relationship_default = 'INDEX_ONLY'
3156: THEN
3157: IF LTRIM (RTRIM (p_operation)) <>'UPDATE_INDEX_RENT' -- Added by vivek on 19NOV2010
3158: THEN
3159: p_rent_index_rec.basis_percent_default := NULL;
3160: END IF;
3161:
3162: IF ( ( p_rent_index_rec.index_id IS NULL
3163: OR p_rent_index_rec.index_id = pn_index_rent_utils.g_pn_miss_num)
3164: OR ( p_rent_index_rec.base_index IS NULL
3165: OR p_rent_index_rec.base_index=pn_index_rent_utils.g_pn_miss_num)
3166: )
3167: THEN
3161:
3162: IF ( ( p_rent_index_rec.index_id IS NULL
3163: OR p_rent_index_rec.index_id = pn_index_rent_utils.g_pn_miss_num)
3164: OR ( p_rent_index_rec.base_index IS NULL
3165: OR p_rent_index_rec.base_index=pn_index_rent_utils.g_pn_miss_num)
3166: )
3167: THEN
3168:
3169: l_error_count:=l_error_count+1;
3175: END IF;
3176:
3177:
3178: IF ( p_rent_index_rec.base_year IS NULL
3179: OR p_rent_index_rec.base_year =pn_index_rent_utils.g_pn_miss_date)
3180: THEN
3181: l_error_count:=l_error_count+1;
3182: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
3183: fnd_message.set_token('ERR_MSG', 'Base Year should be provided when relationship default is '||p_rent_index_rec.relationship_default);
3185: RAISE fnd_api.g_exc_error;
3186: END IF;
3187:
3188: ELSIF p_rent_index_rec.relationship_default IS NOT NULL
3189: AND p_rent_index_rec.relationship_default <> pn_index_rent_utils.g_pn_miss_char
3190: AND p_rent_index_rec.relationship_default = 'BASIS_ONLY'
3191: THEN
3192: --Below IF block has been commented by Vivek as basis_percent_default should only happen for Create and it is taken care above
3193: --IF p_rent_index_rec.basis_percent_default IS NULL
3190: AND p_rent_index_rec.relationship_default = 'BASIS_ONLY'
3191: THEN
3192: --Below IF block has been commented by Vivek as basis_percent_default should only happen for Create and it is taken care above
3193: --IF p_rent_index_rec.basis_percent_default IS NULL
3194: -- OR p_rent_index_rec.basis_percent_default=pn_index_rent_utils.g_pn_miss_num
3195: --THEN
3196: --l_error_count:=l_error_count+1;
3197: --fnd_message.set_name ('PN', 'PN_INDEX_REQD_FLDS_BASIS_ONLY');
3198: --fnd_msg_pub.ADD;
3208: END IF;
3209:
3210: -- Below IF block has been added by vivek on 12-NOV-2010
3211: IF p_rent_index_rec.relationship_default IS NOT NULL
3212: AND p_rent_index_rec.relationship_default <> pn_index_rent_utils.g_pn_miss_char
3213: AND p_rent_index_rec.relationship_default IN('LESSER_OF','GREATER_OF')
3214: THEN
3215:
3216: IF ( p_rent_index_rec.basis_percent_default IS NULL
3213: AND p_rent_index_rec.relationship_default IN('LESSER_OF','GREATER_OF')
3214: THEN
3215:
3216: IF ( p_rent_index_rec.basis_percent_default IS NULL
3217: OR p_rent_index_rec.basis_percent_default=pn_index_rent_utils.g_pn_miss_num)
3218: THEN
3219: --IF LTRIM (RTRIM (p_operation)) <>'UPDATE_INDEX_RENT' -- Added by vivek on 19NOV2010
3220: --THEN
3221: p_rent_index_rec.basis_percent_default := 0;
3222: --END IF;
3223: END IF;
3224: --OR
3225: IF ( p_rent_index_rec.base_Index IS NULL
3226: OR p_rent_index_rec.base_Index =pn_index_rent_utils.g_pn_miss_num)
3227: THEN
3228: l_error_count:=l_error_count+1;
3229: fnd_message.set_name ('PN', 'PN_INDEX_REQD_FLDS_GT_LT_ONLY'); --PN_INVALID_BASIS_TYPE
3230: fnd_msg_pub.ADD;
3231: RAISE fnd_api.g_exc_error;
3232: END IF;
3233:
3234: IF ( p_rent_index_rec.base_year IS NULL
3235: OR p_rent_index_rec.base_year =pn_index_rent_utils.g_pn_miss_date)
3236: THEN
3237: l_error_count:=l_error_count+1;
3238: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
3239: fnd_message.set_token('ERR_MSG', 'Base Year should be provided when relationship_default is '||p_rent_index_rec.relationship_default);
3289: ,3);
3290:
3291:
3292: IF p_rent_index_rec.proration_rule IS NOT NULL
3293: AND p_rent_index_rec.proration_rule <> pn_index_rent_utils.g_pn_miss_char
3294: THEN
3295: IF p_rent_index_rec.proration_rule <> 'NO_PRORATION'
3296: THEN
3297: IF p_rent_index_rec.proration_period_start_date >= p_rent_index_rec.commencement_date
3310:
3311: -- Below IF has been commented and added new IF block by Vivek on 27NOV2010
3312: /*
3313: IF p_rent_index_rec.proration_period_start_date IS NULL
3314: OR p_rent_index_rec.proration_period_start_date = pn_index_rent_utils.g_pn_miss_date
3315: THEN
3316: p_rent_index_rec.proration_period_start_date := NULL;
3317: END IF;
3318: */
3317: END IF;
3318: */
3319:
3320: IF p_rent_index_rec.proration_period_start_date IS NOT NULL
3321: AND p_rent_index_rec.proration_period_start_date <> pn_index_rent_utils.g_pn_miss_date
3322: THEN
3323:
3324: l_error_count:=l_error_count+1;
3325: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
3343: -- Validate the passed Index Termination Date
3344: ----------------------------------------------
3345:
3346: IF p_rent_index_rec.termination_date IS NOT NULL
3347: AND p_rent_index_rec.termination_date<> pn_index_rent_utils.g_pn_miss_date
3348: THEN
3349:
3350:
3351: l_period_exists := pn_index_lease_common_pkg.find_if_period_exists( p_rent_index_rec.index_lease_id);
3372: END IF;
3373:
3374: END IF;
3375:
3376: IF p_rent_index_rec.rounding_flag IS NULL OR p_rent_index_rec.rounding_flag = pn_index_rent_utils.g_pn_miss_char
3377: THEN
3378:
3379: p_rent_index_rec.rounding_flag:='N';
3380: ELSIF p_rent_index_rec.rounding_flag NOT IN ('Y','N')
3386: fnd_msg_pub.ADD;
3387: RAISE fnd_api.g_exc_error;
3388: END IF;
3389:
3390: IF p_rent_index_rec.aggregation_flag IS NULL OR p_rent_index_rec.aggregation_flag = pn_index_rent_utils.g_pn_miss_char
3391: THEN
3392:
3393: p_rent_index_rec.aggregation_flag:='Y';
3394: ELSIF p_rent_index_rec.aggregation_flag NOT IN ('Y','N')
3401: RAISE fnd_api.g_exc_error;
3402: END IF;
3403:
3404:
3405: IF p_rent_index_rec.retain_initial_basis_flag IS NULL OR p_rent_index_rec.retain_initial_basis_flag = pn_index_rent_utils.g_pn_miss_char
3406: THEN
3407:
3408: p_rent_index_rec.retain_initial_basis_flag:='N';
3409: ELSIF p_rent_index_rec.retain_initial_basis_flag NOT IN ('Y','N')
3415: fnd_msg_pub.ADD;
3416: RAISE fnd_api.g_exc_error;
3417: END IF;
3418:
3419: IF p_rent_index_rec.vr_nbp_flag IS NOT NULL AND p_rent_index_rec.vr_nbp_flag <> pn_index_rent_utils.g_pn_miss_char
3420: THEN
3421:
3422:
3423: IF p_rent_index_rec.vr_nbp_flag NOT IN ('N')
3764: x_return_status := fnd_api.g_ret_sts_success;
3765: END IF;
3766:
3767:
3768: IF p_index_constraint_rec.SCOPE IS NULL OR p_index_constraint_rec.SCOPE =pn_index_rent_utils.g_pn_miss_char
3769: THEN
3770:
3771: p_index_constraint_rec.SCOPE := l_constraint_rec_old.SCOPE;
3772:
3772:
3773: END IF;
3774:
3775: /*
3776: IF p_index_constraint_rec.minimum_amount IS NULL OR p_index_constraint_rec.minimum_amount=pn_index_rent_utils.g_pn_miss_num
3777: THEN
3778:
3779: IF ( p_index_constraint_rec.minimum_percent IS NULL
3780: OR p_index_constraint_rec.minimum_percent = pn_index_rent_utils.g_pn_miss_num
3776: IF p_index_constraint_rec.minimum_amount IS NULL OR p_index_constraint_rec.minimum_amount=pn_index_rent_utils.g_pn_miss_num
3777: THEN
3778:
3779: IF ( p_index_constraint_rec.minimum_percent IS NULL
3780: OR p_index_constraint_rec.minimum_percent = pn_index_rent_utils.g_pn_miss_num
3781: )
3782: OR
3783: ( p_index_constraint_rec.maximum_percent IS NULL
3784: OR p_index_constraint_rec.maximum_percent = pn_index_rent_utils.g_pn_miss_num
3780: OR p_index_constraint_rec.minimum_percent = pn_index_rent_utils.g_pn_miss_num
3781: )
3782: OR
3783: ( p_index_constraint_rec.maximum_percent IS NULL
3784: OR p_index_constraint_rec.maximum_percent = pn_index_rent_utils.g_pn_miss_num
3785: )
3786: THEN
3787: p_index_constraint_rec.minimum_amount := l_constraint_rec_old.minimum_amount;
3788: p_index_constraint_rec.maximum_amount := l_constraint_rec_old.maximum_amount;
3793:
3794:
3795:
3796: IF NVL(p_index_constraint_rec.maximum_amount,p_index_constraint_rec.minimum_amount) IS NULL
3797: OR NVL(p_index_constraint_rec.maximum_amount,p_index_constraint_rec.minimum_amount)=pn_index_rent_utils.g_pn_miss_num
3798: THEN
3799:
3800:
3801: IF ( p_index_constraint_rec.minimum_percent IS NULL
3798: THEN
3799:
3800:
3801: IF ( p_index_constraint_rec.minimum_percent IS NULL
3802: OR p_index_constraint_rec.minimum_percent = pn_index_rent_utils.g_pn_miss_num
3803: )
3804: OR
3805: ( p_index_constraint_rec.maximum_percent IS NULL
3806: OR p_index_constraint_rec.maximum_percent = pn_index_rent_utils.g_pn_miss_num
3802: OR p_index_constraint_rec.minimum_percent = pn_index_rent_utils.g_pn_miss_num
3803: )
3804: OR
3805: ( p_index_constraint_rec.maximum_percent IS NULL
3806: OR p_index_constraint_rec.maximum_percent = pn_index_rent_utils.g_pn_miss_num
3807: )
3808: THEN
3809: p_index_constraint_rec.minimum_amount := l_constraint_rec_old.minimum_amount;
3810: p_index_constraint_rec.maximum_amount := l_constraint_rec_old.maximum_amount;
3812:
3813:
3814: END IF;
3815:
3816: IF p_index_constraint_rec.minimum_percent IS NULL OR p_index_constraint_rec.minimum_percent=pn_index_rent_utils.g_pn_miss_num
3817: THEN
3818:
3819:
3820: IF ( p_index_constraint_rec.minimum_amount IS NULL
3817: THEN
3818:
3819:
3820: IF ( p_index_constraint_rec.minimum_amount IS NULL
3821: OR p_index_constraint_rec.minimum_amount = pn_index_rent_utils.g_pn_miss_num
3822: )
3823: OR( p_index_constraint_rec.maximum_percent IS NULL
3824: OR p_index_constraint_rec.maximum_percent = pn_index_rent_utils.g_pn_miss_num
3825: )
3820: IF ( p_index_constraint_rec.minimum_amount IS NULL
3821: OR p_index_constraint_rec.minimum_amount = pn_index_rent_utils.g_pn_miss_num
3822: )
3823: OR( p_index_constraint_rec.maximum_percent IS NULL
3824: OR p_index_constraint_rec.maximum_percent = pn_index_rent_utils.g_pn_miss_num
3825: )
3826: THEN
3827: p_index_constraint_rec.minimum_percent := l_constraint_rec_old.minimum_percent;
3828: p_index_constraint_rec.maximum_percent := l_constraint_rec_old.maximum_percent;
3830:
3831: END IF;
3832:
3833: IF NVL(p_index_constraint_rec.maximum_percent,p_index_constraint_rec.minimum_percent) IS NULL
3834: OR NVL(p_index_constraint_rec.maximum_percent,p_index_constraint_rec.minimum_percent)= pn_index_rent_utils.g_pn_miss_num
3835: THEN
3836:
3837: IF ( p_index_constraint_rec.minimum_amount IS NULL
3838: OR p_index_constraint_rec.minimum_amount = pn_index_rent_utils.g_pn_miss_num
3834: OR NVL(p_index_constraint_rec.maximum_percent,p_index_constraint_rec.minimum_percent)= pn_index_rent_utils.g_pn_miss_num
3835: THEN
3836:
3837: IF ( p_index_constraint_rec.minimum_amount IS NULL
3838: OR p_index_constraint_rec.minimum_amount = pn_index_rent_utils.g_pn_miss_num
3839: )
3840: OR( p_index_constraint_rec.maximum_percent IS NULL
3841: OR p_index_constraint_rec.maximum_percent = pn_index_rent_utils.g_pn_miss_num
3842: )
3837: IF ( p_index_constraint_rec.minimum_amount IS NULL
3838: OR p_index_constraint_rec.minimum_amount = pn_index_rent_utils.g_pn_miss_num
3839: )
3840: OR( p_index_constraint_rec.maximum_percent IS NULL
3841: OR p_index_constraint_rec.maximum_percent = pn_index_rent_utils.g_pn_miss_num
3842: )
3843: THEN
3844: p_index_constraint_rec.minimum_percent := l_constraint_rec_old.minimum_percent;
3845: p_index_constraint_rec.maximum_percent := l_constraint_rec_old.maximum_percent;
3848: END IF;
3849: */
3850: --- The above code has been commented and below code added by Vivek on 27NOV2010
3851:
3852: IF (p_index_constraint_rec.minimum_amount IS NULL OR p_index_constraint_rec.minimum_amount=pn_index_rent_utils.g_pn_miss_num)
3853: AND (p_index_constraint_rec.maximum_amount IS NULL OR p_index_constraint_rec.maximum_amount=pn_index_rent_utils.g_pn_miss_num)
3854: AND (p_index_constraint_rec.minimum_percent IS NULL OR p_index_constraint_rec.minimum_percent=pn_index_rent_utils.g_pn_miss_num)
3855: AND (p_index_constraint_rec.maximum_percent IS NULL OR p_index_constraint_rec.maximum_percent=pn_index_rent_utils.g_pn_miss_num)
3856: THEN
3849: */
3850: --- The above code has been commented and below code added by Vivek on 27NOV2010
3851:
3852: IF (p_index_constraint_rec.minimum_amount IS NULL OR p_index_constraint_rec.minimum_amount=pn_index_rent_utils.g_pn_miss_num)
3853: AND (p_index_constraint_rec.maximum_amount IS NULL OR p_index_constraint_rec.maximum_amount=pn_index_rent_utils.g_pn_miss_num)
3854: AND (p_index_constraint_rec.minimum_percent IS NULL OR p_index_constraint_rec.minimum_percent=pn_index_rent_utils.g_pn_miss_num)
3855: AND (p_index_constraint_rec.maximum_percent IS NULL OR p_index_constraint_rec.maximum_percent=pn_index_rent_utils.g_pn_miss_num)
3856: THEN
3857:
3850: --- The above code has been commented and below code added by Vivek on 27NOV2010
3851:
3852: IF (p_index_constraint_rec.minimum_amount IS NULL OR p_index_constraint_rec.minimum_amount=pn_index_rent_utils.g_pn_miss_num)
3853: AND (p_index_constraint_rec.maximum_amount IS NULL OR p_index_constraint_rec.maximum_amount=pn_index_rent_utils.g_pn_miss_num)
3854: AND (p_index_constraint_rec.minimum_percent IS NULL OR p_index_constraint_rec.minimum_percent=pn_index_rent_utils.g_pn_miss_num)
3855: AND (p_index_constraint_rec.maximum_percent IS NULL OR p_index_constraint_rec.maximum_percent=pn_index_rent_utils.g_pn_miss_num)
3856: THEN
3857:
3858: p_index_constraint_rec.minimum_amount := l_constraint_rec_old.minimum_amount;
3851:
3852: IF (p_index_constraint_rec.minimum_amount IS NULL OR p_index_constraint_rec.minimum_amount=pn_index_rent_utils.g_pn_miss_num)
3853: AND (p_index_constraint_rec.maximum_amount IS NULL OR p_index_constraint_rec.maximum_amount=pn_index_rent_utils.g_pn_miss_num)
3854: AND (p_index_constraint_rec.minimum_percent IS NULL OR p_index_constraint_rec.minimum_percent=pn_index_rent_utils.g_pn_miss_num)
3855: AND (p_index_constraint_rec.maximum_percent IS NULL OR p_index_constraint_rec.maximum_percent=pn_index_rent_utils.g_pn_miss_num)
3856: THEN
3857:
3858: p_index_constraint_rec.minimum_amount := l_constraint_rec_old.minimum_amount;
3859: p_index_constraint_rec.maximum_amount := l_constraint_rec_old.maximum_amount;
3861: p_index_constraint_rec.maximum_percent := l_constraint_rec_old.maximum_percent;
3862: END IF;
3863: ---
3864:
3865: IF p_index_constraint_rec.attribute_category IS NULL OR p_index_constraint_rec.attribute_category=pn_index_rent_utils.g_pn_miss_char
3866: THEN
3867:
3868: p_index_constraint_rec.attribute_category := l_constraint_rec_old.attribute_category;
3869:
3868: p_index_constraint_rec.attribute_category := l_constraint_rec_old.attribute_category;
3869:
3870: END IF;
3871:
3872: IF p_index_constraint_rec.attribute1 IS NULL OR p_index_constraint_rec.attribute1=pn_index_rent_utils.g_pn_miss_char
3873: THEN
3874:
3875: p_index_constraint_rec.attribute1 := l_constraint_rec_old.attribute1;
3876:
3875: p_index_constraint_rec.attribute1 := l_constraint_rec_old.attribute1;
3876:
3877: END IF;
3878:
3879: IF p_index_constraint_rec.attribute2 IS NULL OR p_index_constraint_rec.attribute2=pn_index_rent_utils.g_pn_miss_char
3880: THEN
3881:
3882: p_index_constraint_rec.attribute2 := l_constraint_rec_old.attribute2;
3883:
3883:
3884: END IF;
3885:
3886:
3887: IF p_index_constraint_rec.attribute3 IS NULL OR p_index_constraint_rec.attribute3=pn_index_rent_utils.g_pn_miss_char
3888: THEN
3889:
3890: p_index_constraint_rec.attribute3 := l_constraint_rec_old.attribute3;
3891:
3890: p_index_constraint_rec.attribute3 := l_constraint_rec_old.attribute3;
3891:
3892: END IF;
3893:
3894: IF p_index_constraint_rec.attribute4 IS NULL OR p_index_constraint_rec.attribute4=pn_index_rent_utils.g_pn_miss_char
3895: THEN
3896:
3897: p_index_constraint_rec.attribute4 := l_constraint_rec_old.attribute4;
3898:
3897: p_index_constraint_rec.attribute4 := l_constraint_rec_old.attribute4;
3898:
3899: END IF;
3900:
3901: IF p_index_constraint_rec.attribute5 IS NULL OR p_index_constraint_rec.attribute5=pn_index_rent_utils.g_pn_miss_char
3902: THEN
3903:
3904: p_index_constraint_rec.attribute5 := l_constraint_rec_old.attribute5;
3905:
3904: p_index_constraint_rec.attribute5 := l_constraint_rec_old.attribute5;
3905:
3906: END IF;
3907:
3908: IF p_index_constraint_rec.attribute6 IS NULL OR p_index_constraint_rec.attribute6=pn_index_rent_utils.g_pn_miss_char
3909: THEN
3910:
3911: p_index_constraint_rec.attribute6 := l_constraint_rec_old.attribute6;
3912:
3911: p_index_constraint_rec.attribute6 := l_constraint_rec_old.attribute6;
3912:
3913: END IF;
3914:
3915: IF p_index_constraint_rec.attribute7 IS NULL OR p_index_constraint_rec.attribute7=pn_index_rent_utils.g_pn_miss_char
3916: THEN
3917:
3918: p_index_constraint_rec.attribute7 := l_constraint_rec_old.attribute7;
3919:
3918: p_index_constraint_rec.attribute7 := l_constraint_rec_old.attribute7;
3919:
3920: END IF;
3921:
3922: IF p_index_constraint_rec.attribute8 IS NULL OR p_index_constraint_rec.attribute8=pn_index_rent_utils.g_pn_miss_char
3923: THEN
3924:
3925: p_index_constraint_rec.attribute8 := l_constraint_rec_old.attribute8;
3926:
3925: p_index_constraint_rec.attribute8 := l_constraint_rec_old.attribute8;
3926:
3927: END IF;
3928:
3929: IF p_index_constraint_rec.attribute9 IS NULL OR p_index_constraint_rec.attribute9=pn_index_rent_utils.g_pn_miss_char
3930: THEN
3931:
3932: p_index_constraint_rec.attribute9 := l_constraint_rec_old.attribute9;
3933:
3932: p_index_constraint_rec.attribute9 := l_constraint_rec_old.attribute9;
3933:
3934: END IF;
3935:
3936: IF p_index_constraint_rec.attribute10 IS NULL OR p_index_constraint_rec.attribute10=pn_index_rent_utils.g_pn_miss_char
3937: THEN
3938:
3939: p_index_constraint_rec.attribute10 := l_constraint_rec_old.attribute10;
3940:
3939: p_index_constraint_rec.attribute10 := l_constraint_rec_old.attribute10;
3940:
3941: END IF;
3942:
3943: IF p_index_constraint_rec.attribute11 IS NULL OR p_index_constraint_rec.attribute11=pn_index_rent_utils.g_pn_miss_char
3944: THEN
3945:
3946: p_index_constraint_rec.attribute11 := l_constraint_rec_old.attribute11;
3947:
3946: p_index_constraint_rec.attribute11 := l_constraint_rec_old.attribute11;
3947:
3948: END IF;
3949:
3950: IF p_index_constraint_rec.attribute12 IS NULL OR p_index_constraint_rec.attribute12=pn_index_rent_utils.g_pn_miss_char
3951: THEN
3952:
3953: p_index_constraint_rec.attribute12 := l_constraint_rec_old.attribute12;
3954:
3954:
3955: END IF;
3956:
3957:
3958: IF p_index_constraint_rec.attribute13 IS NULL OR p_index_constraint_rec.attribute13=pn_index_rent_utils.g_pn_miss_char
3959: THEN
3960:
3961: p_index_constraint_rec.attribute13 := l_constraint_rec_old.attribute13;
3962:
3961: p_index_constraint_rec.attribute13 := l_constraint_rec_old.attribute13;
3962:
3963: END IF;
3964:
3965: IF p_index_constraint_rec.attribute14 IS NULL OR p_index_constraint_rec.attribute14=pn_index_rent_utils.g_pn_miss_char
3966: THEN
3967:
3968: p_index_constraint_rec.attribute14 := l_constraint_rec_old.attribute14;
3969:
3968: p_index_constraint_rec.attribute14 := l_constraint_rec_old.attribute14;
3969:
3970: END IF;
3971:
3972: IF p_index_constraint_rec.attribute15 IS NULL OR p_index_constraint_rec.attribute15=pn_index_rent_utils.g_pn_miss_char
3973: THEN
3974:
3975: p_index_constraint_rec.attribute15 := l_constraint_rec_old.attribute15;
3976:
3974:
3975: p_index_constraint_rec.attribute15 := l_constraint_rec_old.attribute15;
3976:
3977: END IF;
3978: IF p_index_constraint_rec.org_id IS NULL OR p_index_constraint_rec.org_id=pn_index_rent_utils.g_pn_miss_num
3979: THEN
3980:
3981: p_index_constraint_rec.org_id := l_constraint_rec_old.org_id;
3982:
4030:
4031: FOR i IN 1 .. p_index_constraint_tbl.COUNT
4032: LOOP
4033:
4034: IF p_index_constraint_tbl (i).org_id IS NULL OR p_index_constraint_tbl (i).org_id=pn_index_rent_utils.g_pn_miss_num
4035: THEN
4036: p_index_constraint_tbl (i).org_id:=FND_PROFILE.VALUE('ORG_ID');
4037: END IF;
4038:
4036: p_index_constraint_tbl (i).org_id:=FND_PROFILE.VALUE('ORG_ID');
4037: END IF;
4038:
4039: IF ( p_index_constraint_tbl (i).SCOPE IS NOT NULL
4040: AND p_index_constraint_tbl (i).SCOPE <> pn_index_rent_utils.g_pn_miss_char)
4041: OR ( p_index_constraint_tbl (i).scope_meaning IS NOT NULL
4042: AND p_index_constraint_tbl (i).scope_meaning <> pn_index_rent_utils.g_pn_miss_char)
4043: THEN
4044: pn_index_rent_utils.get_lookup_code
4038:
4039: IF ( p_index_constraint_tbl (i).SCOPE IS NOT NULL
4040: AND p_index_constraint_tbl (i).SCOPE <> pn_index_rent_utils.g_pn_miss_char)
4041: OR ( p_index_constraint_tbl (i).scope_meaning IS NOT NULL
4042: AND p_index_constraint_tbl (i).scope_meaning <> pn_index_rent_utils.g_pn_miss_char)
4043: THEN
4044: pn_index_rent_utils.get_lookup_code
4045: (p_parameter_name => l_constraint_proration_param
4046: , p_operation => p_operation
4040: AND p_index_constraint_tbl (i).SCOPE <> pn_index_rent_utils.g_pn_miss_char)
4041: OR ( p_index_constraint_tbl (i).scope_meaning IS NOT NULL
4042: AND p_index_constraint_tbl (i).scope_meaning <> pn_index_rent_utils.g_pn_miss_char)
4043: THEN
4044: pn_index_rent_utils.get_lookup_code
4045: (p_parameter_name => l_constraint_proration_param
4046: , p_operation => p_operation
4047: , p_lookup_meaning => p_index_constraint_tbl (i).scope_meaning
4048: , p_lookup_type => l_constraint_proration_type
4056: END IF;
4057: END IF;
4058:
4059:
4060: IF (p_index_constraint_tbl (i).minimum_amount IS NOT NULL AND p_index_constraint_tbl (i).minimum_amount<>pn_index_rent_utils.g_pn_miss_num)
4061: AND (p_index_constraint_tbl (i).maximum_amount IS NOT NULL AND p_index_constraint_tbl (i).maximum_amount<>pn_index_rent_utils.g_pn_miss_num)
4062: AND (p_index_constraint_tbl (i).minimum_percent IS NOT NULL AND p_index_constraint_tbl (i).minimum_percent<>pn_index_rent_utils.g_pn_miss_num)
4063: AND (p_index_constraint_tbl (i).maximum_percent IS NOT NULL AND p_index_constraint_tbl (i).maximum_percent<>pn_index_rent_utils.g_pn_miss_num)
4064: THEN
4057: END IF;
4058:
4059:
4060: IF (p_index_constraint_tbl (i).minimum_amount IS NOT NULL AND p_index_constraint_tbl (i).minimum_amount<>pn_index_rent_utils.g_pn_miss_num)
4061: AND (p_index_constraint_tbl (i).maximum_amount IS NOT NULL AND p_index_constraint_tbl (i).maximum_amount<>pn_index_rent_utils.g_pn_miss_num)
4062: AND (p_index_constraint_tbl (i).minimum_percent IS NOT NULL AND p_index_constraint_tbl (i).minimum_percent<>pn_index_rent_utils.g_pn_miss_num)
4063: AND (p_index_constraint_tbl (i).maximum_percent IS NOT NULL AND p_index_constraint_tbl (i).maximum_percent<>pn_index_rent_utils.g_pn_miss_num)
4064: THEN
4065:
4058:
4059:
4060: IF (p_index_constraint_tbl (i).minimum_amount IS NOT NULL AND p_index_constraint_tbl (i).minimum_amount<>pn_index_rent_utils.g_pn_miss_num)
4061: AND (p_index_constraint_tbl (i).maximum_amount IS NOT NULL AND p_index_constraint_tbl (i).maximum_amount<>pn_index_rent_utils.g_pn_miss_num)
4062: AND (p_index_constraint_tbl (i).minimum_percent IS NOT NULL AND p_index_constraint_tbl (i).minimum_percent<>pn_index_rent_utils.g_pn_miss_num)
4063: AND (p_index_constraint_tbl (i).maximum_percent IS NOT NULL AND p_index_constraint_tbl (i).maximum_percent<>pn_index_rent_utils.g_pn_miss_num)
4064: THEN
4065:
4066: l_error_count:=l_error_count+1;
4059:
4060: IF (p_index_constraint_tbl (i).minimum_amount IS NOT NULL AND p_index_constraint_tbl (i).minimum_amount<>pn_index_rent_utils.g_pn_miss_num)
4061: AND (p_index_constraint_tbl (i).maximum_amount IS NOT NULL AND p_index_constraint_tbl (i).maximum_amount<>pn_index_rent_utils.g_pn_miss_num)
4062: AND (p_index_constraint_tbl (i).minimum_percent IS NOT NULL AND p_index_constraint_tbl (i).minimum_percent<>pn_index_rent_utils.g_pn_miss_num)
4063: AND (p_index_constraint_tbl (i).maximum_percent IS NOT NULL AND p_index_constraint_tbl (i).maximum_percent<>pn_index_rent_utils.g_pn_miss_num)
4064: THEN
4065:
4066: l_error_count:=l_error_count+1;
4067: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
4070: RAISE fnd_api.g_exc_error;
4071: END IF;
4072:
4073: IF ( p_index_constraint_tbl (i).minimum_amount IS NOT NULL
4074: AND p_index_constraint_tbl (i).minimum_amount <> pn_index_rent_utils.g_pn_miss_num)
4075: THEN
4076: p_index_constraint_tbl (i).minimum_percent := NULL;
4077: p_index_constraint_tbl (i).maximum_percent := NULL;
4078:
4076: p_index_constraint_tbl (i).minimum_percent := NULL;
4077: p_index_constraint_tbl (i).maximum_percent := NULL;
4078:
4079: --IF ( p_index_constraint_tbl (i).maximum_amount IS NOT NULL
4080: -- AND p_index_constraint_tbl (i).maximum_amount <> pn_index_rent_utils.g_pn_miss_num
4081: -- )
4082: --THEN
4083: IF (p_index_constraint_tbl (i).maximum_amount < NVL(p_index_constraint_tbl (i).minimum_amount,pn_index_rent_utils.g_pn_miss_num))
4084: THEN
4079: --IF ( p_index_constraint_tbl (i).maximum_amount IS NOT NULL
4080: -- AND p_index_constraint_tbl (i).maximum_amount <> pn_index_rent_utils.g_pn_miss_num
4081: -- )
4082: --THEN
4083: IF (p_index_constraint_tbl (i).maximum_amount < NVL(p_index_constraint_tbl (i).minimum_amount,pn_index_rent_utils.g_pn_miss_num))
4084: THEN
4085: -- NULL;
4086: -- ELSE
4087: fnd_message.set_name ('PN', 'PN_INDEX_CONSTRAINT_AMOUNT');
4094: END IF;
4095:
4096: --
4097: IF ( p_index_constraint_tbl (i).maximum_amount IS NOT NULL
4098: AND p_index_constraint_tbl (i).maximum_amount <> pn_index_rent_utils.g_pn_miss_num)
4099: THEN
4100: p_index_constraint_tbl (i).minimum_percent := NULL;
4101: p_index_constraint_tbl (i).maximum_percent := NULL;
4102:
4102:
4103:
4104:
4105: --IF ( p_index_constraint_tbl (i).minimum_amount IS NOT NULL
4106: -- AND p_index_constraint_tbl (i).minimum_amount <> pn_index_rent_utils.g_pn_miss_num
4107: -- )
4108: --THEN
4109: IF (p_index_constraint_tbl (i).maximum_amount
4105: --IF ( p_index_constraint_tbl (i).minimum_amount IS NOT NULL
4106: -- AND p_index_constraint_tbl (i).minimum_amount <> pn_index_rent_utils.g_pn_miss_num
4107: -- )
4108: --THEN
4109: IF (p_index_constraint_tbl (i).maximum_amount
4111: -- NULL;
4112: --ELSE
4113:
4121: END IF;
4122:
4123: ---
4124: IF ( p_index_constraint_tbl (i).minimum_percent IS NOT NULL
4125: AND p_index_constraint_tbl (i).minimum_percent <> pn_index_rent_utils.g_pn_miss_num)
4126: THEN
4127: p_index_constraint_tbl (i).minimum_amount := NULL;
4128: p_index_constraint_tbl (i).maximum_amount := NULL;
4129:
4127: p_index_constraint_tbl (i).minimum_amount := NULL;
4128: p_index_constraint_tbl (i).maximum_amount := NULL;
4129:
4130: --IF ( p_index_constraint_tbl (i).maximum_percent IS NOT NULL
4131: -- AND p_index_constraint_tbl (i).maximum_percent <> pn_index_rent_utils.g_pn_miss_num
4132: -- )
4133: --THEN
4134: IF (p_index_constraint_tbl (i).maximum_percent
4130: --IF ( p_index_constraint_tbl (i).maximum_percent IS NOT NULL
4131: -- AND p_index_constraint_tbl (i).maximum_percent <> pn_index_rent_utils.g_pn_miss_num
4132: -- )
4133: --THEN
4134: IF (p_index_constraint_tbl (i).maximum_percent
4136: -- NULL;
4137: --ELSE
4138: fnd_message.set_name ('PN', 'PN_INDEX_CONSTRAINT_PERCENT');
4144: p_index_constraint_tbl (i).minimum_percent:=NULL;
4145: END IF;
4146:
4147: IF ( p_index_constraint_tbl (i).maximum_percent IS NOT NULL
4148: AND p_index_constraint_tbl (i).maximum_percent <> pn_index_rent_utils.g_pn_miss_num)
4149: THEN
4150: p_index_constraint_tbl (i).minimum_amount := NULL;
4151: p_index_constraint_tbl (i).maximum_amount := NULL;
4152:
4150: p_index_constraint_tbl (i).minimum_amount := NULL;
4151: p_index_constraint_tbl (i).maximum_amount := NULL;
4152:
4153: --IF ( p_index_constraint_tbl (i).minimum_percent IS NOT NULL
4154: -- AND p_index_constraint_tbl (i).minimum_percent <> pn_index_rent_utils.g_pn_miss_num
4155: -- )
4156: --THEN
4157: IF (p_index_constraint_tbl (i).maximum_percent
4153: --IF ( p_index_constraint_tbl (i).minimum_percent IS NOT NULL
4154: -- AND p_index_constraint_tbl (i).minimum_percent <> pn_index_rent_utils.g_pn_miss_num
4155: -- )
4156: --THEN
4157: IF (p_index_constraint_tbl (i).maximum_percent
4159: -- NULL;
4160: --ELSE
4161: fnd_message.set_name ('PN', 'PN_INDEX_CONSTRAINT_PERCENT');
4197: END IF;
4198:
4199: IF LTRIM(RTRIM (p_operation)) = 'UPDATE_INDEX_RENT_CONSTRAINTS'
4200: THEN
4201: IF ( p_index_constraint_tbl (i).index_constraint_id IS NOT NULL AND p_index_constraint_tbl (i).index_constraint_id <>pn_index_rent_utils.g_pn_miss_num)
4202: THEN
4203:
4204: pn_index_rent_pvt.DEBUG ( g_pkg_name
4205: || g_program_unit
4243: || g_program_unit
4244: || ' Calling update_constraint_row from validate_index_constraint_tbl procedure'
4245: , 3);
4246:
4247: IF ( p_index_constraint_tbl (i).index_constraint_id IS NOT NULL AND p_index_constraint_tbl (i).index_constraint_id <>pn_index_rent_utils.g_pn_miss_num)
4248: THEN
4249: update_constraint_row (p_index_constraint_rec => p_index_constraint_tbl (i)
4250: , p_rent_index_rec => p_rent_index_rec
4251: , x_return_status => x_return_status
4334: g_program_unit := 'CREATE_INDEX_RENT';
4335:
4336: x_return_status := fnd_api.g_ret_sts_success;
4337:
4338: IF p_rent_index_rec.org_id IS NOT NULL AND p_rent_index_rec.org_id<>pn_index_rent_utils.g_pn_miss_num
4339: THEN
4340: IF p_rent_index_rec.org_id<>fnd_global.org_id
4341: THEN
4342: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
4535: g_pkg_name := 'PN_INDEX_RENT_PVT.';
4536: g_program_unit := NULL;
4537: x_return_status := fnd_api.g_ret_sts_success;
4538:
4539: IF p_rent_index_rec.org_id IS NOT NULL AND p_rent_index_rec.org_id<>pn_index_rent_utils.g_pn_miss_num
4540: THEN
4541: IF p_rent_index_rec.org_id<>fnd_global.org_id
4542: THEN
4543: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');