eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_QQL_PVT dependencies on FND_API

Line 97: IF l_qqlv_rec.attribute_category = FND_API.G_MISS_CHAR THEN

93: l_qqlv_rec := p_qqlv_rec;
94:
95: -- Not applicable to ID and OBJECT_VERSION_NUMBER
96:
97: IF l_qqlv_rec.attribute_category = FND_API.G_MISS_CHAR THEN
98: l_qqlv_rec.attribute_category := NULL;
99: END IF;
100: IF l_qqlv_rec.attribute1 = FND_API.G_MISS_CHAR THEN
101: l_qqlv_rec.attribute1 := NULL;

Line 100: IF l_qqlv_rec.attribute1 = FND_API.G_MISS_CHAR THEN

96:
97: IF l_qqlv_rec.attribute_category = FND_API.G_MISS_CHAR THEN
98: l_qqlv_rec.attribute_category := NULL;
99: END IF;
100: IF l_qqlv_rec.attribute1 = FND_API.G_MISS_CHAR THEN
101: l_qqlv_rec.attribute1 := NULL;
102: END IF;
103: IF l_qqlv_rec.attribute2 = FND_API.G_MISS_CHAR THEN
104: l_qqlv_rec.attribute2 := NULL;

Line 103: IF l_qqlv_rec.attribute2 = FND_API.G_MISS_CHAR THEN

99: END IF;
100: IF l_qqlv_rec.attribute1 = FND_API.G_MISS_CHAR THEN
101: l_qqlv_rec.attribute1 := NULL;
102: END IF;
103: IF l_qqlv_rec.attribute2 = FND_API.G_MISS_CHAR THEN
104: l_qqlv_rec.attribute2 := NULL;
105: END IF;
106: IF l_qqlv_rec.attribute3 = FND_API.G_MISS_CHAR THEN
107: l_qqlv_rec.attribute3 := NULL;

Line 106: IF l_qqlv_rec.attribute3 = FND_API.G_MISS_CHAR THEN

102: END IF;
103: IF l_qqlv_rec.attribute2 = FND_API.G_MISS_CHAR THEN
104: l_qqlv_rec.attribute2 := NULL;
105: END IF;
106: IF l_qqlv_rec.attribute3 = FND_API.G_MISS_CHAR THEN
107: l_qqlv_rec.attribute3 := NULL;
108: END IF;
109: IF l_qqlv_rec.attribute4 = FND_API.G_MISS_CHAR THEN
110: l_qqlv_rec.attribute4 := NULL;

Line 109: IF l_qqlv_rec.attribute4 = FND_API.G_MISS_CHAR THEN

105: END IF;
106: IF l_qqlv_rec.attribute3 = FND_API.G_MISS_CHAR THEN
107: l_qqlv_rec.attribute3 := NULL;
108: END IF;
109: IF l_qqlv_rec.attribute4 = FND_API.G_MISS_CHAR THEN
110: l_qqlv_rec.attribute4 := NULL;
111: END IF;
112: IF l_qqlv_rec.attribute5 = FND_API.G_MISS_CHAR THEN
113: l_qqlv_rec.attribute5 := NULL;

Line 112: IF l_qqlv_rec.attribute5 = FND_API.G_MISS_CHAR THEN

108: END IF;
109: IF l_qqlv_rec.attribute4 = FND_API.G_MISS_CHAR THEN
110: l_qqlv_rec.attribute4 := NULL;
111: END IF;
112: IF l_qqlv_rec.attribute5 = FND_API.G_MISS_CHAR THEN
113: l_qqlv_rec.attribute5 := NULL;
114: END IF;
115: IF l_qqlv_rec.attribute6 = FND_API.G_MISS_CHAR THEN
116: l_qqlv_rec.attribute6 := NULL;

Line 115: IF l_qqlv_rec.attribute6 = FND_API.G_MISS_CHAR THEN

111: END IF;
112: IF l_qqlv_rec.attribute5 = FND_API.G_MISS_CHAR THEN
113: l_qqlv_rec.attribute5 := NULL;
114: END IF;
115: IF l_qqlv_rec.attribute6 = FND_API.G_MISS_CHAR THEN
116: l_qqlv_rec.attribute6 := NULL;
117: END IF;
118: IF l_qqlv_rec.attribute7 = FND_API.G_MISS_CHAR THEN
119: l_qqlv_rec.attribute7 := NULL;

Line 118: IF l_qqlv_rec.attribute7 = FND_API.G_MISS_CHAR THEN

114: END IF;
115: IF l_qqlv_rec.attribute6 = FND_API.G_MISS_CHAR THEN
116: l_qqlv_rec.attribute6 := NULL;
117: END IF;
118: IF l_qqlv_rec.attribute7 = FND_API.G_MISS_CHAR THEN
119: l_qqlv_rec.attribute7 := NULL;
120: END IF;
121: IF l_qqlv_rec.attribute8 = FND_API.G_MISS_CHAR THEN
122: l_qqlv_rec.attribute8 := NULL;

Line 121: IF l_qqlv_rec.attribute8 = FND_API.G_MISS_CHAR THEN

117: END IF;
118: IF l_qqlv_rec.attribute7 = FND_API.G_MISS_CHAR THEN
119: l_qqlv_rec.attribute7 := NULL;
120: END IF;
121: IF l_qqlv_rec.attribute8 = FND_API.G_MISS_CHAR THEN
122: l_qqlv_rec.attribute8 := NULL;
123: END IF;
124: IF l_qqlv_rec.attribute9 = FND_API.G_MISS_CHAR THEN
125: l_qqlv_rec.attribute9 := NULL;

Line 124: IF l_qqlv_rec.attribute9 = FND_API.G_MISS_CHAR THEN

120: END IF;
121: IF l_qqlv_rec.attribute8 = FND_API.G_MISS_CHAR THEN
122: l_qqlv_rec.attribute8 := NULL;
123: END IF;
124: IF l_qqlv_rec.attribute9 = FND_API.G_MISS_CHAR THEN
125: l_qqlv_rec.attribute9 := NULL;
126: END IF;
127: IF l_qqlv_rec.attribute10 = FND_API.G_MISS_CHAR THEN
128: l_qqlv_rec.attribute10 := NULL;

Line 127: IF l_qqlv_rec.attribute10 = FND_API.G_MISS_CHAR THEN

123: END IF;
124: IF l_qqlv_rec.attribute9 = FND_API.G_MISS_CHAR THEN
125: l_qqlv_rec.attribute9 := NULL;
126: END IF;
127: IF l_qqlv_rec.attribute10 = FND_API.G_MISS_CHAR THEN
128: l_qqlv_rec.attribute10 := NULL;
129: END IF;
130: IF l_qqlv_rec.attribute11 = FND_API.G_MISS_CHAR THEN
131: l_qqlv_rec.attribute11 := NULL;

Line 130: IF l_qqlv_rec.attribute11 = FND_API.G_MISS_CHAR THEN

126: END IF;
127: IF l_qqlv_rec.attribute10 = FND_API.G_MISS_CHAR THEN
128: l_qqlv_rec.attribute10 := NULL;
129: END IF;
130: IF l_qqlv_rec.attribute11 = FND_API.G_MISS_CHAR THEN
131: l_qqlv_rec.attribute11 := NULL;
132: END IF;
133: IF l_qqlv_rec.attribute12 = FND_API.G_MISS_CHAR THEN
134: l_qqlv_rec.attribute12 := NULL;

Line 133: IF l_qqlv_rec.attribute12 = FND_API.G_MISS_CHAR THEN

129: END IF;
130: IF l_qqlv_rec.attribute11 = FND_API.G_MISS_CHAR THEN
131: l_qqlv_rec.attribute11 := NULL;
132: END IF;
133: IF l_qqlv_rec.attribute12 = FND_API.G_MISS_CHAR THEN
134: l_qqlv_rec.attribute12 := NULL;
135: END IF;
136: IF l_qqlv_rec.attribute13 = FND_API.G_MISS_CHAR THEN
137: l_qqlv_rec.attribute13 := NULL;

Line 136: IF l_qqlv_rec.attribute13 = FND_API.G_MISS_CHAR THEN

132: END IF;
133: IF l_qqlv_rec.attribute12 = FND_API.G_MISS_CHAR THEN
134: l_qqlv_rec.attribute12 := NULL;
135: END IF;
136: IF l_qqlv_rec.attribute13 = FND_API.G_MISS_CHAR THEN
137: l_qqlv_rec.attribute13 := NULL;
138: END IF;
139: IF l_qqlv_rec.attribute14 = FND_API.G_MISS_CHAR THEN
140: l_qqlv_rec.attribute14 := NULL;

Line 139: IF l_qqlv_rec.attribute14 = FND_API.G_MISS_CHAR THEN

135: END IF;
136: IF l_qqlv_rec.attribute13 = FND_API.G_MISS_CHAR THEN
137: l_qqlv_rec.attribute13 := NULL;
138: END IF;
139: IF l_qqlv_rec.attribute14 = FND_API.G_MISS_CHAR THEN
140: l_qqlv_rec.attribute14 := NULL;
141: END IF;
142: IF l_qqlv_rec.attribute15 = FND_API.G_MISS_CHAR THEN
143: l_qqlv_rec.attribute15 := NULL;

Line 142: IF l_qqlv_rec.attribute15 = FND_API.G_MISS_CHAR THEN

138: END IF;
139: IF l_qqlv_rec.attribute14 = FND_API.G_MISS_CHAR THEN
140: l_qqlv_rec.attribute14 := NULL;
141: END IF;
142: IF l_qqlv_rec.attribute15 = FND_API.G_MISS_CHAR THEN
143: l_qqlv_rec.attribute15 := NULL;
144: END IF;
145: IF l_qqlv_rec.quick_quote_id = FND_API.G_MISS_NUM THEN
146: l_qqlv_rec.quick_quote_id := NULL;

Line 145: IF l_qqlv_rec.quick_quote_id = FND_API.G_MISS_NUM THEN

141: END IF;
142: IF l_qqlv_rec.attribute15 = FND_API.G_MISS_CHAR THEN
143: l_qqlv_rec.attribute15 := NULL;
144: END IF;
145: IF l_qqlv_rec.quick_quote_id = FND_API.G_MISS_NUM THEN
146: l_qqlv_rec.quick_quote_id := NULL;
147: END IF;
148: IF l_qqlv_rec.type = FND_API.G_MISS_CHAR THEN
149: l_qqlv_rec.type := NULL;

Line 148: IF l_qqlv_rec.type = FND_API.G_MISS_CHAR THEN

144: END IF;
145: IF l_qqlv_rec.quick_quote_id = FND_API.G_MISS_NUM THEN
146: l_qqlv_rec.quick_quote_id := NULL;
147: END IF;
148: IF l_qqlv_rec.type = FND_API.G_MISS_CHAR THEN
149: l_qqlv_rec.type := NULL;
150: END IF;
151: IF l_qqlv_rec.basis = FND_API.G_MISS_CHAR THEN
152: l_qqlv_rec.basis := NULL;

Line 151: IF l_qqlv_rec.basis = FND_API.G_MISS_CHAR THEN

147: END IF;
148: IF l_qqlv_rec.type = FND_API.G_MISS_CHAR THEN
149: l_qqlv_rec.type := NULL;
150: END IF;
151: IF l_qqlv_rec.basis = FND_API.G_MISS_CHAR THEN
152: l_qqlv_rec.basis := NULL;
153: END IF;
154: IF l_qqlv_rec.value = FND_API.G_MISS_NUM THEN
155: l_qqlv_rec.value := NULL;

Line 154: IF l_qqlv_rec.value = FND_API.G_MISS_NUM THEN

150: END IF;
151: IF l_qqlv_rec.basis = FND_API.G_MISS_CHAR THEN
152: l_qqlv_rec.basis := NULL;
153: END IF;
154: IF l_qqlv_rec.value = FND_API.G_MISS_NUM THEN
155: l_qqlv_rec.value := NULL;
156: END IF;
157: IF l_qqlv_rec.end_of_term_value_default = FND_API.G_MISS_NUM THEN
158: l_qqlv_rec.end_of_term_value_default := NULL;

Line 157: IF l_qqlv_rec.end_of_term_value_default = FND_API.G_MISS_NUM THEN

153: END IF;
154: IF l_qqlv_rec.value = FND_API.G_MISS_NUM THEN
155: l_qqlv_rec.value := NULL;
156: END IF;
157: IF l_qqlv_rec.end_of_term_value_default = FND_API.G_MISS_NUM THEN
158: l_qqlv_rec.end_of_term_value_default := NULL;
159: END IF;
160: IF l_qqlv_rec.end_of_term_value = FND_API.G_MISS_NUM THEN
161: l_qqlv_rec.end_of_term_value := NULL;

Line 160: IF l_qqlv_rec.end_of_term_value = FND_API.G_MISS_NUM THEN

156: END IF;
157: IF l_qqlv_rec.end_of_term_value_default = FND_API.G_MISS_NUM THEN
158: l_qqlv_rec.end_of_term_value_default := NULL;
159: END IF;
160: IF l_qqlv_rec.end_of_term_value = FND_API.G_MISS_NUM THEN
161: l_qqlv_rec.end_of_term_value := NULL;
162: END IF;
163: IF l_qqlv_rec.percentage_of_total_cost = FND_API.G_MISS_NUM THEN
164: l_qqlv_rec.percentage_of_total_cost := NULL;

Line 163: IF l_qqlv_rec.percentage_of_total_cost = FND_API.G_MISS_NUM THEN

159: END IF;
160: IF l_qqlv_rec.end_of_term_value = FND_API.G_MISS_NUM THEN
161: l_qqlv_rec.end_of_term_value := NULL;
162: END IF;
163: IF l_qqlv_rec.percentage_of_total_cost = FND_API.G_MISS_NUM THEN
164: l_qqlv_rec.percentage_of_total_cost := NULL;
165: END IF;
166: IF l_qqlv_rec.item_category_id = FND_API.G_MISS_NUM THEN
167: l_qqlv_rec.item_category_id := NULL;

Line 166: IF l_qqlv_rec.item_category_id = FND_API.G_MISS_NUM THEN

162: END IF;
163: IF l_qqlv_rec.percentage_of_total_cost = FND_API.G_MISS_NUM THEN
164: l_qqlv_rec.percentage_of_total_cost := NULL;
165: END IF;
166: IF l_qqlv_rec.item_category_id = FND_API.G_MISS_NUM THEN
167: l_qqlv_rec.item_category_id := NULL;
168: END IF;
169: IF l_qqlv_rec.item_category_set_id = FND_API.G_MISS_NUM THEN
170: l_qqlv_rec.item_category_set_id := NULL;

Line 169: IF l_qqlv_rec.item_category_set_id = FND_API.G_MISS_NUM THEN

165: END IF;
166: IF l_qqlv_rec.item_category_id = FND_API.G_MISS_NUM THEN
167: l_qqlv_rec.item_category_id := NULL;
168: END IF;
169: IF l_qqlv_rec.item_category_set_id = FND_API.G_MISS_NUM THEN
170: l_qqlv_rec.item_category_set_id := NULL;
171: END IF;
172: IF l_qqlv_rec.lease_rate_factor = FND_API.G_MISS_NUM THEN
173: l_qqlv_rec.lease_rate_factor := NULL;

Line 172: IF l_qqlv_rec.lease_rate_factor = FND_API.G_MISS_NUM THEN

168: END IF;
169: IF l_qqlv_rec.item_category_set_id = FND_API.G_MISS_NUM THEN
170: l_qqlv_rec.item_category_set_id := NULL;
171: END IF;
172: IF l_qqlv_rec.lease_rate_factor = FND_API.G_MISS_NUM THEN
173: l_qqlv_rec.lease_rate_factor := NULL;
174: END IF;
175: IF l_qqlv_rec.short_description = FND_API.G_MISS_CHAR THEN
176: l_qqlv_rec.short_description := NULL;

Line 175: IF l_qqlv_rec.short_description = FND_API.G_MISS_CHAR THEN

171: END IF;
172: IF l_qqlv_rec.lease_rate_factor = FND_API.G_MISS_NUM THEN
173: l_qqlv_rec.lease_rate_factor := NULL;
174: END IF;
175: IF l_qqlv_rec.short_description = FND_API.G_MISS_CHAR THEN
176: l_qqlv_rec.short_description := NULL;
177: END IF;
178: IF l_qqlv_rec.description = FND_API.G_MISS_CHAR THEN
179: l_qqlv_rec.description := NULL;

Line 178: IF l_qqlv_rec.description = FND_API.G_MISS_CHAR THEN

174: END IF;
175: IF l_qqlv_rec.short_description = FND_API.G_MISS_CHAR THEN
176: l_qqlv_rec.short_description := NULL;
177: END IF;
178: IF l_qqlv_rec.description = FND_API.G_MISS_CHAR THEN
179: l_qqlv_rec.description := NULL;
180: END IF;
181: IF l_qqlv_rec.comments = FND_API.G_MISS_CHAR THEN
182: l_qqlv_rec.comments := NULL;

Line 181: IF l_qqlv_rec.comments = FND_API.G_MISS_CHAR THEN

177: END IF;
178: IF l_qqlv_rec.description = FND_API.G_MISS_CHAR THEN
179: l_qqlv_rec.description := NULL;
180: END IF;
181: IF l_qqlv_rec.comments = FND_API.G_MISS_CHAR THEN
182: l_qqlv_rec.comments := NULL;
183: END IF;
184:
185: RETURN l_qqlv_rec;

Line 1121: ELSIF x_qqlv_rec.attribute_category = FND_API.G_MISS_CHAR THEN

1117:
1118: -- smadhava - modified - G_MISS compliance - Start
1119: IF x_qqlv_rec.attribute_category IS NULL THEN
1120: x_qqlv_rec.attribute_category := l_db_qqlv_rec.attribute_category;
1121: ELSIF x_qqlv_rec.attribute_category = FND_API.G_MISS_CHAR THEN
1122: x_qqlv_rec.attribute_category := null;
1123: END IF;
1124:
1125: IF x_qqlv_rec.attribute1 IS NULL THEN

Line 1127: ELSIF x_qqlv_rec.attribute1 = FND_API.G_MISS_CHAR THEN

1123: END IF;
1124:
1125: IF x_qqlv_rec.attribute1 IS NULL THEN
1126: x_qqlv_rec.attribute1 := l_db_qqlv_rec.attribute1;
1127: ELSIF x_qqlv_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1128: x_qqlv_rec.attribute1 := null;
1129: END IF;
1130:
1131: IF x_qqlv_rec.attribute2 IS NULL THEN

Line 1133: ELSIF x_qqlv_rec.attribute2 = FND_API.G_MISS_CHAR THEN

1129: END IF;
1130:
1131: IF x_qqlv_rec.attribute2 IS NULL THEN
1132: x_qqlv_rec.attribute2 := l_db_qqlv_rec.attribute2;
1133: ELSIF x_qqlv_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1134: x_qqlv_rec.attribute2 := null;
1135: END IF;
1136:
1137: IF x_qqlv_rec.attribute3 IS NULL THEN

Line 1139: ELSIF x_qqlv_rec.attribute3 = FND_API.G_MISS_CHAR THEN

1135: END IF;
1136:
1137: IF x_qqlv_rec.attribute3 IS NULL THEN
1138: x_qqlv_rec.attribute3 := l_db_qqlv_rec.attribute3;
1139: ELSIF x_qqlv_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1140: x_qqlv_rec.attribute3 := null;
1141: END IF;
1142:
1143: IF x_qqlv_rec.attribute4 IS NULL THEN

Line 1145: ELSIF x_qqlv_rec.attribute4 = FND_API.G_MISS_CHAR THEN

1141: END IF;
1142:
1143: IF x_qqlv_rec.attribute4 IS NULL THEN
1144: x_qqlv_rec.attribute4 := l_db_qqlv_rec.attribute4;
1145: ELSIF x_qqlv_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1146: x_qqlv_rec.attribute4 := null;
1147: END IF;
1148:
1149: IF x_qqlv_rec.attribute5 IS NULL THEN

Line 1151: ELSIF x_qqlv_rec.attribute5 = FND_API.G_MISS_CHAR THEN

1147: END IF;
1148:
1149: IF x_qqlv_rec.attribute5 IS NULL THEN
1150: x_qqlv_rec.attribute5 := l_db_qqlv_rec.attribute5;
1151: ELSIF x_qqlv_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1152: x_qqlv_rec.attribute5 := null;
1153: END IF;
1154:
1155: IF x_qqlv_rec.attribute6 IS NULL THEN

Line 1157: ELSIF x_qqlv_rec.attribute6 = FND_API.G_MISS_CHAR THEN

1153: END IF;
1154:
1155: IF x_qqlv_rec.attribute6 IS NULL THEN
1156: x_qqlv_rec.attribute6 := l_db_qqlv_rec.attribute6;
1157: ELSIF x_qqlv_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1158: x_qqlv_rec.attribute6 := null;
1159: END IF;
1160:
1161: IF x_qqlv_rec.attribute7 IS NULL THEN

Line 1163: ELSIF x_qqlv_rec.attribute7 = FND_API.G_MISS_CHAR THEN

1159: END IF;
1160:
1161: IF x_qqlv_rec.attribute7 IS NULL THEN
1162: x_qqlv_rec.attribute7 := l_db_qqlv_rec.attribute7;
1163: ELSIF x_qqlv_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1164: x_qqlv_rec.attribute7 := null;
1165: END IF;
1166:
1167: IF x_qqlv_rec.attribute8 IS NULL THEN

Line 1169: ELSIF x_qqlv_rec.attribute8 = FND_API.G_MISS_CHAR THEN

1165: END IF;
1166:
1167: IF x_qqlv_rec.attribute8 IS NULL THEN
1168: x_qqlv_rec.attribute8 := l_db_qqlv_rec.attribute8;
1169: ELSIF x_qqlv_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1170: x_qqlv_rec.attribute8 := null;
1171: END IF;
1172:
1173: IF x_qqlv_rec.attribute9 IS NULL THEN

Line 1175: ELSIF x_qqlv_rec.attribute9 = FND_API.G_MISS_CHAR THEN

1171: END IF;
1172:
1173: IF x_qqlv_rec.attribute9 IS NULL THEN
1174: x_qqlv_rec.attribute9 := l_db_qqlv_rec.attribute9;
1175: ELSIF x_qqlv_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1176: x_qqlv_rec.attribute9 := null;
1177: END IF;
1178:
1179: IF x_qqlv_rec.attribute10 IS NULL THEN

Line 1181: ELSIF x_qqlv_rec.attribute10 = FND_API.G_MISS_CHAR THEN

1177: END IF;
1178:
1179: IF x_qqlv_rec.attribute10 IS NULL THEN
1180: x_qqlv_rec.attribute10 := l_db_qqlv_rec.attribute10;
1181: ELSIF x_qqlv_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1182: x_qqlv_rec.attribute10 := null;
1183: END IF;
1184:
1185: IF x_qqlv_rec.attribute11 IS NULL THEN

Line 1187: ELSIF x_qqlv_rec.attribute11 = FND_API.G_MISS_CHAR THEN

1183: END IF;
1184:
1185: IF x_qqlv_rec.attribute11 IS NULL THEN
1186: x_qqlv_rec.attribute11 := l_db_qqlv_rec.attribute11;
1187: ELSIF x_qqlv_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1188: x_qqlv_rec.attribute11 := null;
1189: END IF;
1190:
1191: IF x_qqlv_rec.attribute12 IS NULL THEN

Line 1193: ELSIF x_qqlv_rec.attribute12 = FND_API.G_MISS_CHAR THEN

1189: END IF;
1190:
1191: IF x_qqlv_rec.attribute12 IS NULL THEN
1192: x_qqlv_rec.attribute12 := l_db_qqlv_rec.attribute12;
1193: ELSIF x_qqlv_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1194: x_qqlv_rec.attribute12 := null;
1195: END IF;
1196:
1197: IF x_qqlv_rec.attribute13 IS NULL THEN

Line 1199: ELSIF x_qqlv_rec.attribute13 = FND_API.G_MISS_CHAR THEN

1195: END IF;
1196:
1197: IF x_qqlv_rec.attribute13 IS NULL THEN
1198: x_qqlv_rec.attribute13 := l_db_qqlv_rec.attribute13;
1199: ELSIF x_qqlv_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1200: x_qqlv_rec.attribute13 := null;
1201: END IF;
1202:
1203: IF x_qqlv_rec.attribute14 IS NULL THEN

Line 1205: ELSIF x_qqlv_rec.attribute14 = FND_API.G_MISS_CHAR THEN

1201: END IF;
1202:
1203: IF x_qqlv_rec.attribute14 IS NULL THEN
1204: x_qqlv_rec.attribute14 := l_db_qqlv_rec.attribute14;
1205: ELSIF x_qqlv_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1206: x_qqlv_rec.attribute14 := null;
1207: END IF;
1208:
1209: IF x_qqlv_rec.attribute15 IS NULL THEN

Line 1211: ELSIF x_qqlv_rec.attribute15 = FND_API.G_MISS_CHAR THEN

1207: END IF;
1208:
1209: IF x_qqlv_rec.attribute15 IS NULL THEN
1210: x_qqlv_rec.attribute15 := l_db_qqlv_rec.attribute15;
1211: ELSIF x_qqlv_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1212: x_qqlv_rec.attribute15 := null;
1213: END IF;
1214:
1215: IF x_qqlv_rec.quick_quote_id IS NULL THEN

Line 1217: ELSIF x_qqlv_rec.quick_quote_id = FND_API.G_MISS_NUM THEN

1213: END IF;
1214:
1215: IF x_qqlv_rec.quick_quote_id IS NULL THEN
1216: x_qqlv_rec.quick_quote_id := l_db_qqlv_rec.quick_quote_id;
1217: ELSIF x_qqlv_rec.quick_quote_id = FND_API.G_MISS_NUM THEN
1218: x_qqlv_rec.quick_quote_id := null;
1219: END IF;
1220:
1221: IF x_qqlv_rec.type IS NULL THEN

Line 1223: ELSIF x_qqlv_rec.type = FND_API.G_MISS_CHAR THEN

1219: END IF;
1220:
1221: IF x_qqlv_rec.type IS NULL THEN
1222: x_qqlv_rec.type := l_db_qqlv_rec.type;
1223: ELSIF x_qqlv_rec.type = FND_API.G_MISS_CHAR THEN
1224: x_qqlv_rec.type := null;
1225: END IF;
1226:
1227: IF x_qqlv_rec.basis IS NULL THEN

Line 1229: ELSIF x_qqlv_rec.basis = FND_API.G_MISS_CHAR THEN

1225: END IF;
1226:
1227: IF x_qqlv_rec.basis IS NULL THEN
1228: x_qqlv_rec.basis := l_db_qqlv_rec.basis;
1229: ELSIF x_qqlv_rec.basis = FND_API.G_MISS_CHAR THEN
1230: x_qqlv_rec.basis := null;
1231: END IF;
1232:
1233: IF x_qqlv_rec.value IS NULL THEN

Line 1235: ELSIF x_qqlv_rec.value = FND_API.G_MISS_NUM THEN

1231: END IF;
1232:
1233: IF x_qqlv_rec.value IS NULL THEN
1234: x_qqlv_rec.value := l_db_qqlv_rec.value;
1235: ELSIF x_qqlv_rec.value = FND_API.G_MISS_NUM THEN
1236: x_qqlv_rec.value := null;
1237: END IF;
1238:
1239: IF x_qqlv_rec.end_of_term_value_default IS NULL THEN

Line 1241: ELSIF x_qqlv_rec.end_of_term_value_default = FND_API.G_MISS_NUM THEN

1237: END IF;
1238:
1239: IF x_qqlv_rec.end_of_term_value_default IS NULL THEN
1240: x_qqlv_rec.end_of_term_value_default := l_db_qqlv_rec.end_of_term_value_default;
1241: ELSIF x_qqlv_rec.end_of_term_value_default = FND_API.G_MISS_NUM THEN
1242: x_qqlv_rec.end_of_term_value_default := null;
1243: END IF;
1244:
1245: IF x_qqlv_rec.end_of_term_value IS NULL THEN

Line 1247: ELSIF x_qqlv_rec.end_of_term_value = FND_API.G_MISS_NUM THEN

1243: END IF;
1244:
1245: IF x_qqlv_rec.end_of_term_value IS NULL THEN
1246: x_qqlv_rec.end_of_term_value := l_db_qqlv_rec.end_of_term_value;
1247: ELSIF x_qqlv_rec.end_of_term_value = FND_API.G_MISS_NUM THEN
1248: x_qqlv_rec.end_of_term_value := null;
1249: END IF;
1250:
1251: IF x_qqlv_rec.percentage_of_total_cost IS NULL THEN

Line 1253: ELSIF x_qqlv_rec.percentage_of_total_cost = FND_API.G_MISS_NUM THEN

1249: END IF;
1250:
1251: IF x_qqlv_rec.percentage_of_total_cost IS NULL THEN
1252: x_qqlv_rec.percentage_of_total_cost := l_db_qqlv_rec.percentage_of_total_cost;
1253: ELSIF x_qqlv_rec.percentage_of_total_cost = FND_API.G_MISS_NUM THEN
1254: x_qqlv_rec.percentage_of_total_cost := null;
1255: END IF;
1256:
1257: IF x_qqlv_rec.item_category_id IS NULL THEN

Line 1259: ELSIF x_qqlv_rec.item_category_id = FND_API.G_MISS_NUM THEN

1255: END IF;
1256:
1257: IF x_qqlv_rec.item_category_id IS NULL THEN
1258: x_qqlv_rec.item_category_id := l_db_qqlv_rec.item_category_id;
1259: ELSIF x_qqlv_rec.item_category_id = FND_API.G_MISS_NUM THEN
1260: x_qqlv_rec.item_category_id := null;
1261: END IF;
1262:
1263: IF x_qqlv_rec.item_category_set_id IS NULL THEN

Line 1265: ELSIF x_qqlv_rec.item_category_set_id = FND_API.G_MISS_NUM THEN

1261: END IF;
1262:
1263: IF x_qqlv_rec.item_category_set_id IS NULL THEN
1264: x_qqlv_rec.item_category_set_id := l_db_qqlv_rec.item_category_set_id;
1265: ELSIF x_qqlv_rec.item_category_set_id = FND_API.G_MISS_NUM THEN
1266: x_qqlv_rec.item_category_set_id := null;
1267: END IF;
1268:
1269: IF x_qqlv_rec.lease_rate_factor IS NULL THEN

Line 1271: ELSIF x_qqlv_rec.lease_rate_factor = FND_API.G_MISS_NUM THEN

1267: END IF;
1268:
1269: IF x_qqlv_rec.lease_rate_factor IS NULL THEN
1270: x_qqlv_rec.lease_rate_factor := l_db_qqlv_rec.lease_rate_factor;
1271: ELSIF x_qqlv_rec.lease_rate_factor = FND_API.G_MISS_NUM THEN
1272: x_qqlv_rec.lease_rate_factor := null;
1273: END IF;
1274:
1275: IF x_qqlv_rec.short_description IS NULL THEN

Line 1277: ELSIF x_qqlv_rec.short_description = FND_API.G_MISS_CHAR THEN

1273: END IF;
1274:
1275: IF x_qqlv_rec.short_description IS NULL THEN
1276: x_qqlv_rec.short_description := l_db_qqlv_rec.short_description;
1277: ELSIF x_qqlv_rec.short_description = FND_API.G_MISS_CHAR THEN
1278: x_qqlv_rec.short_description := null;
1279: END IF;
1280:
1281: IF x_qqlv_rec.description IS NULL THEN

Line 1283: ELSIF x_qqlv_rec.description = FND_API.G_MISS_CHAR THEN

1279: END IF;
1280:
1281: IF x_qqlv_rec.description IS NULL THEN
1282: x_qqlv_rec.description := l_db_qqlv_rec.description;
1283: ELSIF x_qqlv_rec.description = FND_API.G_MISS_CHAR THEN
1284: x_qqlv_rec.description := null;
1285: END IF;
1286:
1287: IF x_qqlv_rec.comments IS NULL THEN

Line 1289: ELSIF x_qqlv_rec.comments = FND_API.G_MISS_CHAR THEN

1285: END IF;
1286:
1287: IF x_qqlv_rec.comments IS NULL THEN
1288: x_qqlv_rec.comments := l_db_qqlv_rec.comments;
1289: ELSIF x_qqlv_rec.comments = FND_API.G_MISS_CHAR THEN
1290: x_qqlv_rec.comments := null;
1291: END IF;
1292: -- smadhava - modified - G_MISS compliance - End
1293: