DBA Data[Home] [Help]

APPS.OKL_SVC_PVT dependencies on FND_API

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 145: IF l_svcv_rec.inv_item_id = FND_API.G_MISS_NUM THEN

141: END IF;
142: IF l_svcv_rec.attribute15 = FND_API.G_MISS_CHAR THEN
143: l_svcv_rec.attribute15 := NULL;
144: END IF;
145: IF l_svcv_rec.inv_item_id = FND_API.G_MISS_NUM THEN
146: l_svcv_rec.inv_item_id := NULL;
147: END IF;
148: IF l_svcv_rec.parent_object_code = FND_API.G_MISS_CHAR THEN
149: l_svcv_rec.parent_object_code := NULL;

Line 148: IF l_svcv_rec.parent_object_code = FND_API.G_MISS_CHAR THEN

144: END IF;
145: IF l_svcv_rec.inv_item_id = FND_API.G_MISS_NUM THEN
146: l_svcv_rec.inv_item_id := NULL;
147: END IF;
148: IF l_svcv_rec.parent_object_code = FND_API.G_MISS_CHAR THEN
149: l_svcv_rec.parent_object_code := NULL;
150: END IF;
151: IF l_svcv_rec.parent_object_id = FND_API.G_MISS_NUM THEN
152: l_svcv_rec.parent_object_id := NULL;

Line 151: IF l_svcv_rec.parent_object_id = FND_API.G_MISS_NUM THEN

147: END IF;
148: IF l_svcv_rec.parent_object_code = FND_API.G_MISS_CHAR THEN
149: l_svcv_rec.parent_object_code := NULL;
150: END IF;
151: IF l_svcv_rec.parent_object_id = FND_API.G_MISS_NUM THEN
152: l_svcv_rec.parent_object_id := NULL;
153: END IF;
154: IF l_svcv_rec.effective_from = FND_API.G_MISS_DATE THEN
155: l_svcv_rec.effective_from := NULL;

Line 154: IF l_svcv_rec.effective_from = FND_API.G_MISS_DATE THEN

150: END IF;
151: IF l_svcv_rec.parent_object_id = FND_API.G_MISS_NUM THEN
152: l_svcv_rec.parent_object_id := NULL;
153: END IF;
154: IF l_svcv_rec.effective_from = FND_API.G_MISS_DATE THEN
155: l_svcv_rec.effective_from := NULL;
156: END IF;
157: IF l_svcv_rec.supplier_id = FND_API.G_MISS_NUM THEN
158: l_svcv_rec.supplier_id := NULL;

Line 157: IF l_svcv_rec.supplier_id = FND_API.G_MISS_NUM THEN

153: END IF;
154: IF l_svcv_rec.effective_from = FND_API.G_MISS_DATE THEN
155: l_svcv_rec.effective_from := NULL;
156: END IF;
157: IF l_svcv_rec.supplier_id = FND_API.G_MISS_NUM THEN
158: l_svcv_rec.supplier_id := NULL;
159: END IF;
160: IF l_svcv_rec.short_description = FND_API.G_MISS_CHAR THEN
161: l_svcv_rec.short_description := NULL;

Line 160: IF l_svcv_rec.short_description = FND_API.G_MISS_CHAR THEN

156: END IF;
157: IF l_svcv_rec.supplier_id = FND_API.G_MISS_NUM THEN
158: l_svcv_rec.supplier_id := NULL;
159: END IF;
160: IF l_svcv_rec.short_description = FND_API.G_MISS_CHAR THEN
161: l_svcv_rec.short_description := NULL;
162: END IF;
163: IF l_svcv_rec.description = FND_API.G_MISS_CHAR THEN
164: l_svcv_rec.description := NULL;

Line 163: IF l_svcv_rec.description = FND_API.G_MISS_CHAR THEN

159: END IF;
160: IF l_svcv_rec.short_description = FND_API.G_MISS_CHAR THEN
161: l_svcv_rec.short_description := NULL;
162: END IF;
163: IF l_svcv_rec.description = FND_API.G_MISS_CHAR THEN
164: l_svcv_rec.description := NULL;
165: END IF;
166: IF l_svcv_rec.comments = FND_API.G_MISS_CHAR THEN
167: l_svcv_rec.comments := NULL;

Line 166: IF l_svcv_rec.comments = FND_API.G_MISS_CHAR THEN

162: END IF;
163: IF l_svcv_rec.description = FND_API.G_MISS_CHAR THEN
164: l_svcv_rec.description := NULL;
165: END IF;
166: IF l_svcv_rec.comments = FND_API.G_MISS_CHAR THEN
167: l_svcv_rec.comments := NULL;
168: END IF;
169:
170: RETURN l_svcv_rec;

Line 1110: IF x_svcv_rec.attribute_category = FND_API.G_MISS_CHAR THEN

1106: ELSIF l_return_status = G_RET_STS_ERROR THEN
1107: RAISE OKL_API.G_EXCEPTION_ERROR;
1108: END IF;
1109:
1110: IF x_svcv_rec.attribute_category = FND_API.G_MISS_CHAR THEN
1111: x_svcv_rec.attribute_category := l_db_svcv_rec.attribute_category;
1112: END IF;
1113: IF x_svcv_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1114: x_svcv_rec.attribute1 := l_db_svcv_rec.attribute1;

Line 1113: IF x_svcv_rec.attribute1 = FND_API.G_MISS_CHAR THEN

1109:
1110: IF x_svcv_rec.attribute_category = FND_API.G_MISS_CHAR THEN
1111: x_svcv_rec.attribute_category := l_db_svcv_rec.attribute_category;
1112: END IF;
1113: IF x_svcv_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1114: x_svcv_rec.attribute1 := l_db_svcv_rec.attribute1;
1115: END IF;
1116: IF x_svcv_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1117: x_svcv_rec.attribute2 := l_db_svcv_rec.attribute2;

Line 1116: IF x_svcv_rec.attribute2 = FND_API.G_MISS_CHAR THEN

1112: END IF;
1113: IF x_svcv_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1114: x_svcv_rec.attribute1 := l_db_svcv_rec.attribute1;
1115: END IF;
1116: IF x_svcv_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1117: x_svcv_rec.attribute2 := l_db_svcv_rec.attribute2;
1118: END IF;
1119: IF x_svcv_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1120: x_svcv_rec.attribute3 := l_db_svcv_rec.attribute3;

Line 1119: IF x_svcv_rec.attribute3 = FND_API.G_MISS_CHAR THEN

1115: END IF;
1116: IF x_svcv_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1117: x_svcv_rec.attribute2 := l_db_svcv_rec.attribute2;
1118: END IF;
1119: IF x_svcv_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1120: x_svcv_rec.attribute3 := l_db_svcv_rec.attribute3;
1121: END IF;
1122: IF x_svcv_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1123: x_svcv_rec.attribute4 := l_db_svcv_rec.attribute4;

Line 1122: IF x_svcv_rec.attribute4 = FND_API.G_MISS_CHAR THEN

1118: END IF;
1119: IF x_svcv_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1120: x_svcv_rec.attribute3 := l_db_svcv_rec.attribute3;
1121: END IF;
1122: IF x_svcv_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1123: x_svcv_rec.attribute4 := l_db_svcv_rec.attribute4;
1124: END IF;
1125: IF x_svcv_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1126: x_svcv_rec.attribute5 := l_db_svcv_rec.attribute5;

Line 1125: IF x_svcv_rec.attribute5 = FND_API.G_MISS_CHAR THEN

1121: END IF;
1122: IF x_svcv_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1123: x_svcv_rec.attribute4 := l_db_svcv_rec.attribute4;
1124: END IF;
1125: IF x_svcv_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1126: x_svcv_rec.attribute5 := l_db_svcv_rec.attribute5;
1127: END IF;
1128: IF x_svcv_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1129: x_svcv_rec.attribute6 := l_db_svcv_rec.attribute6;

Line 1128: IF x_svcv_rec.attribute6 = FND_API.G_MISS_CHAR THEN

1124: END IF;
1125: IF x_svcv_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1126: x_svcv_rec.attribute5 := l_db_svcv_rec.attribute5;
1127: END IF;
1128: IF x_svcv_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1129: x_svcv_rec.attribute6 := l_db_svcv_rec.attribute6;
1130: END IF;
1131: IF x_svcv_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1132: x_svcv_rec.attribute7 := l_db_svcv_rec.attribute7;

Line 1131: IF x_svcv_rec.attribute7 = FND_API.G_MISS_CHAR THEN

1127: END IF;
1128: IF x_svcv_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1129: x_svcv_rec.attribute6 := l_db_svcv_rec.attribute6;
1130: END IF;
1131: IF x_svcv_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1132: x_svcv_rec.attribute7 := l_db_svcv_rec.attribute7;
1133: END IF;
1134: IF x_svcv_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1135: x_svcv_rec.attribute8 := l_db_svcv_rec.attribute8;

Line 1134: IF x_svcv_rec.attribute8 = FND_API.G_MISS_CHAR THEN

1130: END IF;
1131: IF x_svcv_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1132: x_svcv_rec.attribute7 := l_db_svcv_rec.attribute7;
1133: END IF;
1134: IF x_svcv_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1135: x_svcv_rec.attribute8 := l_db_svcv_rec.attribute8;
1136: END IF;
1137: IF x_svcv_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1138: x_svcv_rec.attribute9 := l_db_svcv_rec.attribute9;

Line 1137: IF x_svcv_rec.attribute9 = FND_API.G_MISS_CHAR THEN

1133: END IF;
1134: IF x_svcv_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1135: x_svcv_rec.attribute8 := l_db_svcv_rec.attribute8;
1136: END IF;
1137: IF x_svcv_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1138: x_svcv_rec.attribute9 := l_db_svcv_rec.attribute9;
1139: END IF;
1140: IF x_svcv_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1141: x_svcv_rec.attribute10 := l_db_svcv_rec.attribute10;

Line 1140: IF x_svcv_rec.attribute10 = FND_API.G_MISS_CHAR THEN

1136: END IF;
1137: IF x_svcv_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1138: x_svcv_rec.attribute9 := l_db_svcv_rec.attribute9;
1139: END IF;
1140: IF x_svcv_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1141: x_svcv_rec.attribute10 := l_db_svcv_rec.attribute10;
1142: END IF;
1143: IF x_svcv_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1144: x_svcv_rec.attribute11 := l_db_svcv_rec.attribute11;

Line 1143: IF x_svcv_rec.attribute11 = FND_API.G_MISS_CHAR THEN

1139: END IF;
1140: IF x_svcv_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1141: x_svcv_rec.attribute10 := l_db_svcv_rec.attribute10;
1142: END IF;
1143: IF x_svcv_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1144: x_svcv_rec.attribute11 := l_db_svcv_rec.attribute11;
1145: END IF;
1146: IF x_svcv_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1147: x_svcv_rec.attribute12 := l_db_svcv_rec.attribute12;

Line 1146: IF x_svcv_rec.attribute12 = FND_API.G_MISS_CHAR THEN

1142: END IF;
1143: IF x_svcv_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1144: x_svcv_rec.attribute11 := l_db_svcv_rec.attribute11;
1145: END IF;
1146: IF x_svcv_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1147: x_svcv_rec.attribute12 := l_db_svcv_rec.attribute12;
1148: END IF;
1149: IF x_svcv_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1150: x_svcv_rec.attribute13 := l_db_svcv_rec.attribute13;

Line 1149: IF x_svcv_rec.attribute13 = FND_API.G_MISS_CHAR THEN

1145: END IF;
1146: IF x_svcv_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1147: x_svcv_rec.attribute12 := l_db_svcv_rec.attribute12;
1148: END IF;
1149: IF x_svcv_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1150: x_svcv_rec.attribute13 := l_db_svcv_rec.attribute13;
1151: END IF;
1152: IF x_svcv_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1153: x_svcv_rec.attribute14 := l_db_svcv_rec.attribute14;

Line 1152: IF x_svcv_rec.attribute14 = FND_API.G_MISS_CHAR THEN

1148: END IF;
1149: IF x_svcv_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1150: x_svcv_rec.attribute13 := l_db_svcv_rec.attribute13;
1151: END IF;
1152: IF x_svcv_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1153: x_svcv_rec.attribute14 := l_db_svcv_rec.attribute14;
1154: END IF;
1155: IF x_svcv_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1156: x_svcv_rec.attribute15 := l_db_svcv_rec.attribute15;

Line 1155: IF x_svcv_rec.attribute15 = FND_API.G_MISS_CHAR THEN

1151: END IF;
1152: IF x_svcv_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1153: x_svcv_rec.attribute14 := l_db_svcv_rec.attribute14;
1154: END IF;
1155: IF x_svcv_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1156: x_svcv_rec.attribute15 := l_db_svcv_rec.attribute15;
1157: END IF;
1158: IF x_svcv_rec.inv_item_id = FND_API.G_MISS_NUM THEN
1159: x_svcv_rec.inv_item_id := l_db_svcv_rec.inv_item_id;

Line 1158: IF x_svcv_rec.inv_item_id = FND_API.G_MISS_NUM THEN

1154: END IF;
1155: IF x_svcv_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1156: x_svcv_rec.attribute15 := l_db_svcv_rec.attribute15;
1157: END IF;
1158: IF x_svcv_rec.inv_item_id = FND_API.G_MISS_NUM THEN
1159: x_svcv_rec.inv_item_id := l_db_svcv_rec.inv_item_id;
1160: END IF;
1161: IF x_svcv_rec.parent_object_code = FND_API.G_MISS_CHAR THEN
1162: x_svcv_rec.parent_object_code := l_db_svcv_rec.parent_object_code;

Line 1161: IF x_svcv_rec.parent_object_code = FND_API.G_MISS_CHAR THEN

1157: END IF;
1158: IF x_svcv_rec.inv_item_id = FND_API.G_MISS_NUM THEN
1159: x_svcv_rec.inv_item_id := l_db_svcv_rec.inv_item_id;
1160: END IF;
1161: IF x_svcv_rec.parent_object_code = FND_API.G_MISS_CHAR THEN
1162: x_svcv_rec.parent_object_code := l_db_svcv_rec.parent_object_code;
1163: END IF;
1164: IF x_svcv_rec.parent_object_id = FND_API.G_MISS_NUM THEN
1165: x_svcv_rec.parent_object_id := l_db_svcv_rec.parent_object_id;

Line 1164: IF x_svcv_rec.parent_object_id = FND_API.G_MISS_NUM THEN

1160: END IF;
1161: IF x_svcv_rec.parent_object_code = FND_API.G_MISS_CHAR THEN
1162: x_svcv_rec.parent_object_code := l_db_svcv_rec.parent_object_code;
1163: END IF;
1164: IF x_svcv_rec.parent_object_id = FND_API.G_MISS_NUM THEN
1165: x_svcv_rec.parent_object_id := l_db_svcv_rec.parent_object_id;
1166: END IF;
1167: IF x_svcv_rec.effective_from = FND_API.G_MISS_DATE THEN
1168: x_svcv_rec.effective_from := l_db_svcv_rec.effective_from;

Line 1167: IF x_svcv_rec.effective_from = FND_API.G_MISS_DATE THEN

1163: END IF;
1164: IF x_svcv_rec.parent_object_id = FND_API.G_MISS_NUM THEN
1165: x_svcv_rec.parent_object_id := l_db_svcv_rec.parent_object_id;
1166: END IF;
1167: IF x_svcv_rec.effective_from = FND_API.G_MISS_DATE THEN
1168: x_svcv_rec.effective_from := l_db_svcv_rec.effective_from;
1169: END IF;
1170: IF x_svcv_rec.supplier_id = FND_API.G_MISS_NUM THEN
1171: x_svcv_rec.supplier_id := l_db_svcv_rec.supplier_id;

Line 1170: IF x_svcv_rec.supplier_id = FND_API.G_MISS_NUM THEN

1166: END IF;
1167: IF x_svcv_rec.effective_from = FND_API.G_MISS_DATE THEN
1168: x_svcv_rec.effective_from := l_db_svcv_rec.effective_from;
1169: END IF;
1170: IF x_svcv_rec.supplier_id = FND_API.G_MISS_NUM THEN
1171: x_svcv_rec.supplier_id := l_db_svcv_rec.supplier_id;
1172: END IF;
1173: IF x_svcv_rec.short_description = FND_API.G_MISS_CHAR THEN
1174: x_svcv_rec.short_description := l_db_svcv_rec.short_description;

Line 1173: IF x_svcv_rec.short_description = FND_API.G_MISS_CHAR THEN

1169: END IF;
1170: IF x_svcv_rec.supplier_id = FND_API.G_MISS_NUM THEN
1171: x_svcv_rec.supplier_id := l_db_svcv_rec.supplier_id;
1172: END IF;
1173: IF x_svcv_rec.short_description = FND_API.G_MISS_CHAR THEN
1174: x_svcv_rec.short_description := l_db_svcv_rec.short_description;
1175: END IF;
1176: IF x_svcv_rec.description = FND_API.G_MISS_CHAR THEN
1177: x_svcv_rec.description := l_db_svcv_rec.description;

Line 1176: IF x_svcv_rec.description = FND_API.G_MISS_CHAR THEN

1172: END IF;
1173: IF x_svcv_rec.short_description = FND_API.G_MISS_CHAR THEN
1174: x_svcv_rec.short_description := l_db_svcv_rec.short_description;
1175: END IF;
1176: IF x_svcv_rec.description = FND_API.G_MISS_CHAR THEN
1177: x_svcv_rec.description := l_db_svcv_rec.description;
1178: END IF;
1179: IF x_svcv_rec.comments = FND_API.G_MISS_CHAR THEN
1180: x_svcv_rec.comments := l_db_svcv_rec.comments;

Line 1179: IF x_svcv_rec.comments = FND_API.G_MISS_CHAR THEN

1175: END IF;
1176: IF x_svcv_rec.description = FND_API.G_MISS_CHAR THEN
1177: x_svcv_rec.description := l_db_svcv_rec.description;
1178: END IF;
1179: IF x_svcv_rec.comments = FND_API.G_MISS_CHAR THEN
1180: x_svcv_rec.comments := l_db_svcv_rec.comments;
1181: END IF;
1182:
1183: RETURN l_return_status;