APPS.QP_PRICE_LIST_LINE_UTIL dependencies on FND_API

Line 13: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM

9:
10: -- Procedure Clear_Dependent_Attr
11:
12: PROCEDURE Clear_Dependent_Attr
13: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
14: , p_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type
15: , p_old_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type :=
16: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_REC
17: , x_PRICE_LIST_LINE_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Rec_Type

Line 32: IF p_attr_id = FND_API.G_MISS_NUM THEN

28:
29: -- If attr_id is missing compare old and new records and for
30: -- every changed attribute clear its dependent fields.
31:
32: IF p_attr_id = FND_API.G_MISS_NUM THEN
33:
34: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.accrual_qty,p_old_PRICE_LIST_LINE_rec.accrual_qty)
35: THEN
36: l_index := l_index + 1;

Line 1078: IF l_PRICE_LIST_LINE_rec.accrual_qty = FND_API.G_MISS_NUM THEN

1074: IS
1075: l_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type := p_PRICE_LIST_LINE_rec;
1076: BEGIN
1077:
1078: IF l_PRICE_LIST_LINE_rec.accrual_qty = FND_API.G_MISS_NUM THEN
1079: l_PRICE_LIST_LINE_rec.accrual_qty := p_old_PRICE_LIST_LINE_rec.accrual_qty;
1080: END IF;
1081:
1082:

Line 1083: IF l_PRICE_LIST_LINE_rec.accrual_uom_code = FND_API.G_MISS_CHAR THEN

1079: l_PRICE_LIST_LINE_rec.accrual_qty := p_old_PRICE_LIST_LINE_rec.accrual_qty;
1080: END IF;
1081:
1082:
1083: IF l_PRICE_LIST_LINE_rec.accrual_uom_code = FND_API.G_MISS_CHAR THEN
1084: l_PRICE_LIST_LINE_rec.accrual_uom_code := p_old_PRICE_LIST_LINE_rec.accrual_uom_code;
1085: END IF;
1086:
1087: IF l_PRICE_LIST_LINE_rec.arithmetic_operator = FND_API.G_MISS_CHAR THEN

Line 1087: IF l_PRICE_LIST_LINE_rec.arithmetic_operator = FND_API.G_MISS_CHAR THEN

1083: IF l_PRICE_LIST_LINE_rec.accrual_uom_code = FND_API.G_MISS_CHAR THEN
1084: l_PRICE_LIST_LINE_rec.accrual_uom_code := p_old_PRICE_LIST_LINE_rec.accrual_uom_code;
1085: END IF;
1086:
1087: IF l_PRICE_LIST_LINE_rec.arithmetic_operator = FND_API.G_MISS_CHAR THEN
1088: l_PRICE_LIST_LINE_rec.arithmetic_operator := p_old_PRICE_LIST_LINE_rec.arithmetic_operator;
1089: END IF;
1090:
1091: IF l_PRICE_LIST_LINE_rec.attribute1 = FND_API.G_MISS_CHAR THEN

Line 1091: IF l_PRICE_LIST_LINE_rec.attribute1 = FND_API.G_MISS_CHAR THEN

1087: IF l_PRICE_LIST_LINE_rec.arithmetic_operator = FND_API.G_MISS_CHAR THEN
1088: l_PRICE_LIST_LINE_rec.arithmetic_operator := p_old_PRICE_LIST_LINE_rec.arithmetic_operator;
1089: END IF;
1090:
1091: IF l_PRICE_LIST_LINE_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1092: l_PRICE_LIST_LINE_rec.attribute1 := p_old_PRICE_LIST_LINE_rec.attribute1;
1093: END IF;
1094:
1095: IF l_PRICE_LIST_LINE_rec.attribute10 = FND_API.G_MISS_CHAR THEN

Line 1095: IF l_PRICE_LIST_LINE_rec.attribute10 = FND_API.G_MISS_CHAR THEN

1091: IF l_PRICE_LIST_LINE_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1092: l_PRICE_LIST_LINE_rec.attribute1 := p_old_PRICE_LIST_LINE_rec.attribute1;
1093: END IF;
1094:
1095: IF l_PRICE_LIST_LINE_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1096: l_PRICE_LIST_LINE_rec.attribute10 := p_old_PRICE_LIST_LINE_rec.attribute10;
1097: END IF;
1098:
1099: IF l_PRICE_LIST_LINE_rec.attribute11 = FND_API.G_MISS_CHAR THEN

Line 1099: IF l_PRICE_LIST_LINE_rec.attribute11 = FND_API.G_MISS_CHAR THEN

1095: IF l_PRICE_LIST_LINE_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1096: l_PRICE_LIST_LINE_rec.attribute10 := p_old_PRICE_LIST_LINE_rec.attribute10;
1097: END IF;
1098:
1099: IF l_PRICE_LIST_LINE_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1100: l_PRICE_LIST_LINE_rec.attribute11 := p_old_PRICE_LIST_LINE_rec.attribute11;
1101: END IF;
1102:
1103: IF l_PRICE_LIST_LINE_rec.attribute12 = FND_API.G_MISS_CHAR THEN

Line 1103: IF l_PRICE_LIST_LINE_rec.attribute12 = FND_API.G_MISS_CHAR THEN

1099: IF l_PRICE_LIST_LINE_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1100: l_PRICE_LIST_LINE_rec.attribute11 := p_old_PRICE_LIST_LINE_rec.attribute11;
1101: END IF;
1102:
1103: IF l_PRICE_LIST_LINE_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1104: l_PRICE_LIST_LINE_rec.attribute12 := p_old_PRICE_LIST_LINE_rec.attribute12;
1105: END IF;
1106:
1107: IF l_PRICE_LIST_LINE_rec.attribute13 = FND_API.G_MISS_CHAR THEN

Line 1107: IF l_PRICE_LIST_LINE_rec.attribute13 = FND_API.G_MISS_CHAR THEN

1103: IF l_PRICE_LIST_LINE_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1104: l_PRICE_LIST_LINE_rec.attribute12 := p_old_PRICE_LIST_LINE_rec.attribute12;
1105: END IF;
1106:
1107: IF l_PRICE_LIST_LINE_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1108: l_PRICE_LIST_LINE_rec.attribute13 := p_old_PRICE_LIST_LINE_rec.attribute13;
1109: END IF;
1110:
1111: IF l_PRICE_LIST_LINE_rec.attribute14 = FND_API.G_MISS_CHAR THEN

Line 1111: IF l_PRICE_LIST_LINE_rec.attribute14 = FND_API.G_MISS_CHAR THEN

1107: IF l_PRICE_LIST_LINE_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1108: l_PRICE_LIST_LINE_rec.attribute13 := p_old_PRICE_LIST_LINE_rec.attribute13;
1109: END IF;
1110:
1111: IF l_PRICE_LIST_LINE_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1112: l_PRICE_LIST_LINE_rec.attribute14 := p_old_PRICE_LIST_LINE_rec.attribute14;
1113: END IF;
1114:
1115: IF l_PRICE_LIST_LINE_rec.attribute15 = FND_API.G_MISS_CHAR THEN

Line 1115: IF l_PRICE_LIST_LINE_rec.attribute15 = FND_API.G_MISS_CHAR THEN

1111: IF l_PRICE_LIST_LINE_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1112: l_PRICE_LIST_LINE_rec.attribute14 := p_old_PRICE_LIST_LINE_rec.attribute14;
1113: END IF;
1114:
1115: IF l_PRICE_LIST_LINE_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1116: l_PRICE_LIST_LINE_rec.attribute15 := p_old_PRICE_LIST_LINE_rec.attribute15;
1117: END IF;
1118:
1119: IF l_PRICE_LIST_LINE_rec.attribute2 = FND_API.G_MISS_CHAR THEN

Line 1119: IF l_PRICE_LIST_LINE_rec.attribute2 = FND_API.G_MISS_CHAR THEN

1115: IF l_PRICE_LIST_LINE_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1116: l_PRICE_LIST_LINE_rec.attribute15 := p_old_PRICE_LIST_LINE_rec.attribute15;
1117: END IF;
1118:
1119: IF l_PRICE_LIST_LINE_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1120: l_PRICE_LIST_LINE_rec.attribute2 := p_old_PRICE_LIST_LINE_rec.attribute2;
1121: END IF;
1122:
1123: IF l_PRICE_LIST_LINE_rec.attribute3 = FND_API.G_MISS_CHAR THEN

Line 1123: IF l_PRICE_LIST_LINE_rec.attribute3 = FND_API.G_MISS_CHAR THEN

1119: IF l_PRICE_LIST_LINE_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1120: l_PRICE_LIST_LINE_rec.attribute2 := p_old_PRICE_LIST_LINE_rec.attribute2;
1121: END IF;
1122:
1123: IF l_PRICE_LIST_LINE_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1124: l_PRICE_LIST_LINE_rec.attribute3 := p_old_PRICE_LIST_LINE_rec.attribute3;
1125: END IF;
1126:
1127: IF l_PRICE_LIST_LINE_rec.attribute4 = FND_API.G_MISS_CHAR THEN

Line 1127: IF l_PRICE_LIST_LINE_rec.attribute4 = FND_API.G_MISS_CHAR THEN

1123: IF l_PRICE_LIST_LINE_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1124: l_PRICE_LIST_LINE_rec.attribute3 := p_old_PRICE_LIST_LINE_rec.attribute3;
1125: END IF;
1126:
1127: IF l_PRICE_LIST_LINE_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1128: l_PRICE_LIST_LINE_rec.attribute4 := p_old_PRICE_LIST_LINE_rec.attribute4;
1129: END IF;
1130:
1131: IF l_PRICE_LIST_LINE_rec.attribute5 = FND_API.G_MISS_CHAR THEN

Line 1131: IF l_PRICE_LIST_LINE_rec.attribute5 = FND_API.G_MISS_CHAR THEN

1127: IF l_PRICE_LIST_LINE_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1128: l_PRICE_LIST_LINE_rec.attribute4 := p_old_PRICE_LIST_LINE_rec.attribute4;
1129: END IF;
1130:
1131: IF l_PRICE_LIST_LINE_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1132: l_PRICE_LIST_LINE_rec.attribute5 := p_old_PRICE_LIST_LINE_rec.attribute5;
1133: END IF;
1134:
1135: IF l_PRICE_LIST_LINE_rec.attribute6 = FND_API.G_MISS_CHAR THEN

Line 1135: IF l_PRICE_LIST_LINE_rec.attribute6 = FND_API.G_MISS_CHAR THEN

1131: IF l_PRICE_LIST_LINE_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1132: l_PRICE_LIST_LINE_rec.attribute5 := p_old_PRICE_LIST_LINE_rec.attribute5;
1133: END IF;
1134:
1135: IF l_PRICE_LIST_LINE_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1136: l_PRICE_LIST_LINE_rec.attribute6 := p_old_PRICE_LIST_LINE_rec.attribute6;
1137: END IF;
1138:
1139: IF l_PRICE_LIST_LINE_rec.attribute7 = FND_API.G_MISS_CHAR THEN

Line 1139: IF l_PRICE_LIST_LINE_rec.attribute7 = FND_API.G_MISS_CHAR THEN

1135: IF l_PRICE_LIST_LINE_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1136: l_PRICE_LIST_LINE_rec.attribute6 := p_old_PRICE_LIST_LINE_rec.attribute6;
1137: END IF;
1138:
1139: IF l_PRICE_LIST_LINE_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1140: l_PRICE_LIST_LINE_rec.attribute7 := p_old_PRICE_LIST_LINE_rec.attribute7;
1141: END IF;
1142:
1143: IF l_PRICE_LIST_LINE_rec.attribute8 = FND_API.G_MISS_CHAR THEN

Line 1143: IF l_PRICE_LIST_LINE_rec.attribute8 = FND_API.G_MISS_CHAR THEN

1139: IF l_PRICE_LIST_LINE_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1140: l_PRICE_LIST_LINE_rec.attribute7 := p_old_PRICE_LIST_LINE_rec.attribute7;
1141: END IF;
1142:
1143: IF l_PRICE_LIST_LINE_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1144: l_PRICE_LIST_LINE_rec.attribute8 := p_old_PRICE_LIST_LINE_rec.attribute8;
1145: END IF;
1146:
1147: IF l_PRICE_LIST_LINE_rec.attribute9 = FND_API.G_MISS_CHAR THEN

Line 1147: IF l_PRICE_LIST_LINE_rec.attribute9 = FND_API.G_MISS_CHAR THEN

1143: IF l_PRICE_LIST_LINE_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1144: l_PRICE_LIST_LINE_rec.attribute8 := p_old_PRICE_LIST_LINE_rec.attribute8;
1145: END IF;
1146:
1147: IF l_PRICE_LIST_LINE_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1148: l_PRICE_LIST_LINE_rec.attribute9 := p_old_PRICE_LIST_LINE_rec.attribute9;
1149: END IF;
1150:
1151: IF l_PRICE_LIST_LINE_rec.automatic_flag = FND_API.G_MISS_CHAR THEN

Line 1151: IF l_PRICE_LIST_LINE_rec.automatic_flag = FND_API.G_MISS_CHAR THEN

1147: IF l_PRICE_LIST_LINE_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1148: l_PRICE_LIST_LINE_rec.attribute9 := p_old_PRICE_LIST_LINE_rec.attribute9;
1149: END IF;
1150:
1151: IF l_PRICE_LIST_LINE_rec.automatic_flag = FND_API.G_MISS_CHAR THEN
1152: l_PRICE_LIST_LINE_rec.automatic_flag := p_old_PRICE_LIST_LINE_rec.automatic_flag;
1153: END IF;
1154:
1155: IF l_PRICE_LIST_LINE_rec.base_qty = FND_API.G_MISS_NUM THEN

Line 1155: IF l_PRICE_LIST_LINE_rec.base_qty = FND_API.G_MISS_NUM THEN

1151: IF l_PRICE_LIST_LINE_rec.automatic_flag = FND_API.G_MISS_CHAR THEN
1152: l_PRICE_LIST_LINE_rec.automatic_flag := p_old_PRICE_LIST_LINE_rec.automatic_flag;
1153: END IF;
1154:
1155: IF l_PRICE_LIST_LINE_rec.base_qty = FND_API.G_MISS_NUM THEN
1156: l_PRICE_LIST_LINE_rec.base_qty := p_old_PRICE_LIST_LINE_rec.base_qty;
1157: END IF;
1158:
1159: IF l_PRICE_LIST_LINE_rec.base_uom_code = FND_API.G_MISS_CHAR THEN

Line 1159: IF l_PRICE_LIST_LINE_rec.base_uom_code = FND_API.G_MISS_CHAR THEN

1155: IF l_PRICE_LIST_LINE_rec.base_qty = FND_API.G_MISS_NUM THEN
1156: l_PRICE_LIST_LINE_rec.base_qty := p_old_PRICE_LIST_LINE_rec.base_qty;
1157: END IF;
1158:
1159: IF l_PRICE_LIST_LINE_rec.base_uom_code = FND_API.G_MISS_CHAR THEN
1160: l_PRICE_LIST_LINE_rec.base_uom_code := p_old_PRICE_LIST_LINE_rec.base_uom_code;
1161: END IF;
1162:
1163: IF l_PRICE_LIST_LINE_rec.comments = FND_API.G_MISS_CHAR THEN

Line 1163: IF l_PRICE_LIST_LINE_rec.comments = FND_API.G_MISS_CHAR THEN

1159: IF l_PRICE_LIST_LINE_rec.base_uom_code = FND_API.G_MISS_CHAR THEN
1160: l_PRICE_LIST_LINE_rec.base_uom_code := p_old_PRICE_LIST_LINE_rec.base_uom_code;
1161: END IF;
1162:
1163: IF l_PRICE_LIST_LINE_rec.comments = FND_API.G_MISS_CHAR THEN
1164: l_PRICE_LIST_LINE_rec.comments := p_old_PRICE_LIST_LINE_rec.comments;
1165: END IF;
1166:
1167: IF l_PRICE_LIST_LINE_rec.context = FND_API.G_MISS_CHAR THEN

Line 1167: IF l_PRICE_LIST_LINE_rec.context = FND_API.G_MISS_CHAR THEN

1163: IF l_PRICE_LIST_LINE_rec.comments = FND_API.G_MISS_CHAR THEN
1164: l_PRICE_LIST_LINE_rec.comments := p_old_PRICE_LIST_LINE_rec.comments;
1165: END IF;
1166:
1167: IF l_PRICE_LIST_LINE_rec.context = FND_API.G_MISS_CHAR THEN
1168: l_PRICE_LIST_LINE_rec.context := p_old_PRICE_LIST_LINE_rec.context;
1169: END IF;
1170:
1171: IF l_PRICE_LIST_LINE_rec.created_by = FND_API.G_MISS_NUM THEN

Line 1171: IF l_PRICE_LIST_LINE_rec.created_by = FND_API.G_MISS_NUM THEN

1167: IF l_PRICE_LIST_LINE_rec.context = FND_API.G_MISS_CHAR THEN
1168: l_PRICE_LIST_LINE_rec.context := p_old_PRICE_LIST_LINE_rec.context;
1169: END IF;
1170:
1171: IF l_PRICE_LIST_LINE_rec.created_by = FND_API.G_MISS_NUM THEN
1172: l_PRICE_LIST_LINE_rec.created_by := p_old_PRICE_LIST_LINE_rec.created_by;
1173: END IF;
1174:
1175: IF l_PRICE_LIST_LINE_rec.creation_date = FND_API.G_MISS_DATE THEN

Line 1175: IF l_PRICE_LIST_LINE_rec.creation_date = FND_API.G_MISS_DATE THEN

1171: IF l_PRICE_LIST_LINE_rec.created_by = FND_API.G_MISS_NUM THEN
1172: l_PRICE_LIST_LINE_rec.created_by := p_old_PRICE_LIST_LINE_rec.created_by;
1173: END IF;
1174:
1175: IF l_PRICE_LIST_LINE_rec.creation_date = FND_API.G_MISS_DATE THEN
1176: l_PRICE_LIST_LINE_rec.creation_date := p_old_PRICE_LIST_LINE_rec.creation_date;
1177: END IF;
1178:
1179: IF l_PRICE_LIST_LINE_rec.effective_period_uom = FND_API.G_MISS_CHAR THEN

Line 1179: IF l_PRICE_LIST_LINE_rec.effective_period_uom = FND_API.G_MISS_CHAR THEN

1175: IF l_PRICE_LIST_LINE_rec.creation_date = FND_API.G_MISS_DATE THEN
1176: l_PRICE_LIST_LINE_rec.creation_date := p_old_PRICE_LIST_LINE_rec.creation_date;
1177: END IF;
1178:
1179: IF l_PRICE_LIST_LINE_rec.effective_period_uom = FND_API.G_MISS_CHAR THEN
1180: l_PRICE_LIST_LINE_rec.effective_period_uom := p_old_PRICE_LIST_LINE_rec.effective_period_uom;
1181: END IF;
1182:
1183: IF l_PRICE_LIST_LINE_rec.end_date_active = FND_API.G_MISS_DATE THEN

Line 1183: IF l_PRICE_LIST_LINE_rec.end_date_active = FND_API.G_MISS_DATE THEN

1179: IF l_PRICE_LIST_LINE_rec.effective_period_uom = FND_API.G_MISS_CHAR THEN
1180: l_PRICE_LIST_LINE_rec.effective_period_uom := p_old_PRICE_LIST_LINE_rec.effective_period_uom;
1181: END IF;
1182:
1183: IF l_PRICE_LIST_LINE_rec.end_date_active = FND_API.G_MISS_DATE THEN
1184: l_PRICE_LIST_LINE_rec.end_date_active := p_old_PRICE_LIST_LINE_rec.end_date_active;
1185: END IF;
1186:
1187: IF l_PRICE_LIST_LINE_rec.estim_accrual_rate = FND_API.G_MISS_NUM THEN

Line 1187: IF l_PRICE_LIST_LINE_rec.estim_accrual_rate = FND_API.G_MISS_NUM THEN

1183: IF l_PRICE_LIST_LINE_rec.end_date_active = FND_API.G_MISS_DATE THEN
1184: l_PRICE_LIST_LINE_rec.end_date_active := p_old_PRICE_LIST_LINE_rec.end_date_active;
1185: END IF;
1186:
1187: IF l_PRICE_LIST_LINE_rec.estim_accrual_rate = FND_API.G_MISS_NUM THEN
1188: l_PRICE_LIST_LINE_rec.estim_accrual_rate := p_old_PRICE_LIST_LINE_rec.estim_accrual_rate;
1189: END IF;
1190:
1191: IF l_PRICE_LIST_LINE_rec.generate_using_formula_id = FND_API.G_MISS_NUM THEN

Line 1191: IF l_PRICE_LIST_LINE_rec.generate_using_formula_id = FND_API.G_MISS_NUM THEN

1187: IF l_PRICE_LIST_LINE_rec.estim_accrual_rate = FND_API.G_MISS_NUM THEN
1188: l_PRICE_LIST_LINE_rec.estim_accrual_rate := p_old_PRICE_LIST_LINE_rec.estim_accrual_rate;
1189: END IF;
1190:
1191: IF l_PRICE_LIST_LINE_rec.generate_using_formula_id = FND_API.G_MISS_NUM THEN
1192: l_PRICE_LIST_LINE_rec.generate_using_formula_id := p_old_PRICE_LIST_LINE_rec.generate_using_formula_id;
1193: END IF;
1194:
1195:

Line 1196: IF l_PRICE_LIST_LINE_rec.inventory_item_id = FND_API.G_MISS_NUM THEN

1192: l_PRICE_LIST_LINE_rec.generate_using_formula_id := p_old_PRICE_LIST_LINE_rec.generate_using_formula_id;
1193: END IF;
1194:
1195:
1196: IF l_PRICE_LIST_LINE_rec.inventory_item_id = FND_API.G_MISS_NUM THEN
1197: l_PRICE_LIST_LINE_rec.inventory_item_id := p_old_PRICE_LIST_LINE_rec.inventory_item_id;
1198: END IF;
1199:
1200: IF l_PRICE_LIST_LINE_rec.last_updated_by = FND_API.G_MISS_NUM THEN

Line 1200: IF l_PRICE_LIST_LINE_rec.last_updated_by = FND_API.G_MISS_NUM THEN

1196: IF l_PRICE_LIST_LINE_rec.inventory_item_id = FND_API.G_MISS_NUM THEN
1197: l_PRICE_LIST_LINE_rec.inventory_item_id := p_old_PRICE_LIST_LINE_rec.inventory_item_id;
1198: END IF;
1199:
1200: IF l_PRICE_LIST_LINE_rec.last_updated_by = FND_API.G_MISS_NUM THEN
1201: l_PRICE_LIST_LINE_rec.last_updated_by := p_old_PRICE_LIST_LINE_rec.last_updated_by;
1202: END IF;
1203:
1204: IF l_PRICE_LIST_LINE_rec.last_update_date = FND_API.G_MISS_DATE THEN

Line 1204: IF l_PRICE_LIST_LINE_rec.last_update_date = FND_API.G_MISS_DATE THEN

1200: IF l_PRICE_LIST_LINE_rec.last_updated_by = FND_API.G_MISS_NUM THEN
1201: l_PRICE_LIST_LINE_rec.last_updated_by := p_old_PRICE_LIST_LINE_rec.last_updated_by;
1202: END IF;
1203:
1204: IF l_PRICE_LIST_LINE_rec.last_update_date = FND_API.G_MISS_DATE THEN
1205: l_PRICE_LIST_LINE_rec.last_update_date := p_old_PRICE_LIST_LINE_rec.last_update_date;
1206: END IF;
1207:
1208: IF l_PRICE_LIST_LINE_rec.last_update_login = FND_API.G_MISS_NUM THEN

Line 1208: IF l_PRICE_LIST_LINE_rec.last_update_login = FND_API.G_MISS_NUM THEN

1204: IF l_PRICE_LIST_LINE_rec.last_update_date = FND_API.G_MISS_DATE THEN
1205: l_PRICE_LIST_LINE_rec.last_update_date := p_old_PRICE_LIST_LINE_rec.last_update_date;
1206: END IF;
1207:
1208: IF l_PRICE_LIST_LINE_rec.last_update_login = FND_API.G_MISS_NUM THEN
1209: l_PRICE_LIST_LINE_rec.last_update_login := p_old_PRICE_LIST_LINE_rec.last_update_login;
1210: END IF;
1211:
1212: IF l_PRICE_LIST_LINE_rec.list_header_id = FND_API.G_MISS_NUM THEN

Line 1212: IF l_PRICE_LIST_LINE_rec.list_header_id = FND_API.G_MISS_NUM THEN

1208: IF l_PRICE_LIST_LINE_rec.last_update_login = FND_API.G_MISS_NUM THEN
1209: l_PRICE_LIST_LINE_rec.last_update_login := p_old_PRICE_LIST_LINE_rec.last_update_login;
1210: END IF;
1211:
1212: IF l_PRICE_LIST_LINE_rec.list_header_id = FND_API.G_MISS_NUM THEN
1213: l_PRICE_LIST_LINE_rec.list_header_id := p_old_PRICE_LIST_LINE_rec.list_header_id;
1214: END IF;
1215:
1216: IF l_PRICE_LIST_LINE_rec.list_line_id = FND_API.G_MISS_NUM THEN

Line 1216: IF l_PRICE_LIST_LINE_rec.list_line_id = FND_API.G_MISS_NUM THEN

1212: IF l_PRICE_LIST_LINE_rec.list_header_id = FND_API.G_MISS_NUM THEN
1213: l_PRICE_LIST_LINE_rec.list_header_id := p_old_PRICE_LIST_LINE_rec.list_header_id;
1214: END IF;
1215:
1216: IF l_PRICE_LIST_LINE_rec.list_line_id = FND_API.G_MISS_NUM THEN
1217: l_PRICE_LIST_LINE_rec.list_line_id := p_old_PRICE_LIST_LINE_rec.list_line_id;
1218: END IF;
1219:
1220: IF l_PRICE_LIST_LINE_rec.list_line_no = FND_API.G_MISS_CHAR THEN -- bug 4751658, 4199398

Line 1220: IF l_PRICE_LIST_LINE_rec.list_line_no = FND_API.G_MISS_CHAR THEN -- bug 4751658, 4199398

1216: IF l_PRICE_LIST_LINE_rec.list_line_id = FND_API.G_MISS_NUM THEN
1217: l_PRICE_LIST_LINE_rec.list_line_id := p_old_PRICE_LIST_LINE_rec.list_line_id;
1218: END IF;
1219:
1220: IF l_PRICE_LIST_LINE_rec.list_line_no = FND_API.G_MISS_CHAR THEN -- bug 4751658, 4199398
1221: l_PRICE_LIST_LINE_rec.list_line_no := p_old_PRICE_LIST_LINE_rec.list_line_no;
1222: END IF;
1223:
1224: IF l_PRICE_LIST_LINE_rec.list_line_type_code = FND_API.G_MISS_CHAR THEN

Line 1224: IF l_PRICE_LIST_LINE_rec.list_line_type_code = FND_API.G_MISS_CHAR THEN

1220: IF l_PRICE_LIST_LINE_rec.list_line_no = FND_API.G_MISS_CHAR THEN -- bug 4751658, 4199398
1221: l_PRICE_LIST_LINE_rec.list_line_no := p_old_PRICE_LIST_LINE_rec.list_line_no;
1222: END IF;
1223:
1224: IF l_PRICE_LIST_LINE_rec.list_line_type_code = FND_API.G_MISS_CHAR THEN
1225: l_PRICE_LIST_LINE_rec.list_line_type_code := p_old_PRICE_LIST_LINE_rec.list_line_type_code;
1226: END IF;
1227:
1228: IF l_PRICE_LIST_LINE_rec.list_price = FND_API.G_MISS_NUM THEN

Line 1228: IF l_PRICE_LIST_LINE_rec.list_price = FND_API.G_MISS_NUM THEN

1224: IF l_PRICE_LIST_LINE_rec.list_line_type_code = FND_API.G_MISS_CHAR THEN
1225: l_PRICE_LIST_LINE_rec.list_line_type_code := p_old_PRICE_LIST_LINE_rec.list_line_type_code;
1226: END IF;
1227:
1228: IF l_PRICE_LIST_LINE_rec.list_price = FND_API.G_MISS_NUM THEN
1229: l_PRICE_LIST_LINE_rec.list_price := p_old_PRICE_LIST_LINE_rec.list_price;
1230: END IF;
1231:
1232: IF l_PRICE_LIST_LINE_rec.from_rltd_modifier_id = FND_API.G_MISS_NUM THEN

Line 1232: IF l_PRICE_LIST_LINE_rec.from_rltd_modifier_id = FND_API.G_MISS_NUM THEN

1228: IF l_PRICE_LIST_LINE_rec.list_price = FND_API.G_MISS_NUM THEN
1229: l_PRICE_LIST_LINE_rec.list_price := p_old_PRICE_LIST_LINE_rec.list_price;
1230: END IF;
1231:
1232: IF l_PRICE_LIST_LINE_rec.from_rltd_modifier_id = FND_API.G_MISS_NUM THEN
1233: l_PRICE_LIST_LINE_rec.from_rltd_modifier_id := p_old_PRICE_LIST_LINE_rec.from_rltd_modifier_id;
1234: END IF;
1235:
1236: IF l_PRICE_LIST_LINE_rec.rltd_modifier_group_no = FND_API.G_MISS_NUM THEN

Line 1236: IF l_PRICE_LIST_LINE_rec.rltd_modifier_group_no = FND_API.G_MISS_NUM THEN

1232: IF l_PRICE_LIST_LINE_rec.from_rltd_modifier_id = FND_API.G_MISS_NUM THEN
1233: l_PRICE_LIST_LINE_rec.from_rltd_modifier_id := p_old_PRICE_LIST_LINE_rec.from_rltd_modifier_id;
1234: END IF;
1235:
1236: IF l_PRICE_LIST_LINE_rec.rltd_modifier_group_no = FND_API.G_MISS_NUM THEN
1237: l_PRICE_LIST_LINE_rec.rltd_modifier_group_no := p_old_PRICE_LIST_LINE_rec.rltd_modifier_group_no;
1238: END IF;
1239:
1240: IF l_PRICE_LIST_LINE_rec.product_precedence = FND_API.G_MISS_NUM THEN

Line 1240: IF l_PRICE_LIST_LINE_rec.product_precedence = FND_API.G_MISS_NUM THEN

1236: IF l_PRICE_LIST_LINE_rec.rltd_modifier_group_no = FND_API.G_MISS_NUM THEN
1237: l_PRICE_LIST_LINE_rec.rltd_modifier_group_no := p_old_PRICE_LIST_LINE_rec.rltd_modifier_group_no;
1238: END IF;
1239:
1240: IF l_PRICE_LIST_LINE_rec.product_precedence = FND_API.G_MISS_NUM THEN
1241: l_PRICE_LIST_LINE_rec.product_precedence := p_old_PRICE_LIST_LINE_rec.product_precedence;
1242: END IF;
1243:
1244: IF l_PRICE_LIST_LINE_rec.modifier_level_code = FND_API.G_MISS_CHAR THEN

Line 1244: IF l_PRICE_LIST_LINE_rec.modifier_level_code = FND_API.G_MISS_CHAR THEN

1240: IF l_PRICE_LIST_LINE_rec.product_precedence = FND_API.G_MISS_NUM THEN
1241: l_PRICE_LIST_LINE_rec.product_precedence := p_old_PRICE_LIST_LINE_rec.product_precedence;
1242: END IF;
1243:
1244: IF l_PRICE_LIST_LINE_rec.modifier_level_code = FND_API.G_MISS_CHAR THEN
1245: l_PRICE_LIST_LINE_rec.modifier_level_code := p_old_PRICE_LIST_LINE_rec.modifier_level_code;
1246: END IF;
1247:
1248: IF l_PRICE_LIST_LINE_rec.number_effective_periods = FND_API.G_MISS_NUM THEN

Line 1248: IF l_PRICE_LIST_LINE_rec.number_effective_periods = FND_API.G_MISS_NUM THEN

1244: IF l_PRICE_LIST_LINE_rec.modifier_level_code = FND_API.G_MISS_CHAR THEN
1245: l_PRICE_LIST_LINE_rec.modifier_level_code := p_old_PRICE_LIST_LINE_rec.modifier_level_code;
1246: END IF;
1247:
1248: IF l_PRICE_LIST_LINE_rec.number_effective_periods = FND_API.G_MISS_NUM THEN
1249: l_PRICE_LIST_LINE_rec.number_effective_periods := p_old_PRICE_LIST_LINE_rec.number_effective_periods;
1250: END IF;
1251:
1252: IF l_PRICE_LIST_LINE_rec.operand = FND_API.G_MISS_NUM THEN

Line 1252: IF l_PRICE_LIST_LINE_rec.operand = FND_API.G_MISS_NUM THEN

1248: IF l_PRICE_LIST_LINE_rec.number_effective_periods = FND_API.G_MISS_NUM THEN
1249: l_PRICE_LIST_LINE_rec.number_effective_periods := p_old_PRICE_LIST_LINE_rec.number_effective_periods;
1250: END IF;
1251:
1252: IF l_PRICE_LIST_LINE_rec.operand = FND_API.G_MISS_NUM THEN
1253: l_PRICE_LIST_LINE_rec.operand := p_old_PRICE_LIST_LINE_rec.operand;
1254: END IF;
1255:
1256: IF l_PRICE_LIST_LINE_rec.organization_id = FND_API.G_MISS_NUM THEN

Line 1256: IF l_PRICE_LIST_LINE_rec.organization_id = FND_API.G_MISS_NUM THEN

1252: IF l_PRICE_LIST_LINE_rec.operand = FND_API.G_MISS_NUM THEN
1253: l_PRICE_LIST_LINE_rec.operand := p_old_PRICE_LIST_LINE_rec.operand;
1254: END IF;
1255:
1256: IF l_PRICE_LIST_LINE_rec.organization_id = FND_API.G_MISS_NUM THEN
1257: l_PRICE_LIST_LINE_rec.organization_id := p_old_PRICE_LIST_LINE_rec.organization_id;
1258: END IF;
1259:
1260: IF l_PRICE_LIST_LINE_rec.override_flag = FND_API.G_MISS_CHAR THEN

Line 1260: IF l_PRICE_LIST_LINE_rec.override_flag = FND_API.G_MISS_CHAR THEN

1256: IF l_PRICE_LIST_LINE_rec.organization_id = FND_API.G_MISS_NUM THEN
1257: l_PRICE_LIST_LINE_rec.organization_id := p_old_PRICE_LIST_LINE_rec.organization_id;
1258: END IF;
1259:
1260: IF l_PRICE_LIST_LINE_rec.override_flag = FND_API.G_MISS_CHAR THEN
1261: l_PRICE_LIST_LINE_rec.override_flag := p_old_PRICE_LIST_LINE_rec.override_flag;
1262: END IF;
1263:
1264: IF l_PRICE_LIST_LINE_rec.percent_price = FND_API.G_MISS_NUM THEN

Line 1264: IF l_PRICE_LIST_LINE_rec.percent_price = FND_API.G_MISS_NUM THEN

1260: IF l_PRICE_LIST_LINE_rec.override_flag = FND_API.G_MISS_CHAR THEN
1261: l_PRICE_LIST_LINE_rec.override_flag := p_old_PRICE_LIST_LINE_rec.override_flag;
1262: END IF;
1263:
1264: IF l_PRICE_LIST_LINE_rec.percent_price = FND_API.G_MISS_NUM THEN
1265: l_PRICE_LIST_LINE_rec.percent_price := p_old_PRICE_LIST_LINE_rec.percent_price;
1266: END IF;
1267:
1268: IF l_PRICE_LIST_LINE_rec.price_break_type_code = FND_API.G_MISS_CHAR THEN

Line 1268: IF l_PRICE_LIST_LINE_rec.price_break_type_code = FND_API.G_MISS_CHAR THEN

1264: IF l_PRICE_LIST_LINE_rec.percent_price = FND_API.G_MISS_NUM THEN
1265: l_PRICE_LIST_LINE_rec.percent_price := p_old_PRICE_LIST_LINE_rec.percent_price;
1266: END IF;
1267:
1268: IF l_PRICE_LIST_LINE_rec.price_break_type_code = FND_API.G_MISS_CHAR THEN
1269: l_PRICE_LIST_LINE_rec.price_break_type_code := p_old_PRICE_LIST_LINE_rec.price_break_type_code;
1270: END IF;
1271:
1272: IF l_PRICE_LIST_LINE_rec.price_by_formula_id = FND_API.G_MISS_NUM THEN

Line 1272: IF l_PRICE_LIST_LINE_rec.price_by_formula_id = FND_API.G_MISS_NUM THEN

1268: IF l_PRICE_LIST_LINE_rec.price_break_type_code = FND_API.G_MISS_CHAR THEN
1269: l_PRICE_LIST_LINE_rec.price_break_type_code := p_old_PRICE_LIST_LINE_rec.price_break_type_code;
1270: END IF;
1271:
1272: IF l_PRICE_LIST_LINE_rec.price_by_formula_id = FND_API.G_MISS_NUM THEN
1273: l_PRICE_LIST_LINE_rec.price_by_formula_id := p_old_PRICE_LIST_LINE_rec.price_by_formula_id;
1274: END IF;
1275:
1276: IF l_PRICE_LIST_LINE_rec.primary_uom_flag = FND_API.G_MISS_CHAR THEN

Line 1276: IF l_PRICE_LIST_LINE_rec.primary_uom_flag = FND_API.G_MISS_CHAR THEN

1272: IF l_PRICE_LIST_LINE_rec.price_by_formula_id = FND_API.G_MISS_NUM THEN
1273: l_PRICE_LIST_LINE_rec.price_by_formula_id := p_old_PRICE_LIST_LINE_rec.price_by_formula_id;
1274: END IF;
1275:
1276: IF l_PRICE_LIST_LINE_rec.primary_uom_flag = FND_API.G_MISS_CHAR THEN
1277: l_PRICE_LIST_LINE_rec.primary_uom_flag := p_old_PRICE_LIST_LINE_rec.primary_uom_flag;
1278: END IF;
1279:
1280: IF l_PRICE_LIST_LINE_rec.print_on_invoice_flag = FND_API.G_MISS_CHAR THEN

Line 1280: IF l_PRICE_LIST_LINE_rec.print_on_invoice_flag = FND_API.G_MISS_CHAR THEN

1276: IF l_PRICE_LIST_LINE_rec.primary_uom_flag = FND_API.G_MISS_CHAR THEN
1277: l_PRICE_LIST_LINE_rec.primary_uom_flag := p_old_PRICE_LIST_LINE_rec.primary_uom_flag;
1278: END IF;
1279:
1280: IF l_PRICE_LIST_LINE_rec.print_on_invoice_flag = FND_API.G_MISS_CHAR THEN
1281: l_PRICE_LIST_LINE_rec.print_on_invoice_flag := p_old_PRICE_LIST_LINE_rec.print_on_invoice_flag;
1282: END IF;
1283:
1284: IF l_PRICE_LIST_LINE_rec.program_application_id = FND_API.G_MISS_NUM THEN

Line 1284: IF l_PRICE_LIST_LINE_rec.program_application_id = FND_API.G_MISS_NUM THEN

1280: IF l_PRICE_LIST_LINE_rec.print_on_invoice_flag = FND_API.G_MISS_CHAR THEN
1281: l_PRICE_LIST_LINE_rec.print_on_invoice_flag := p_old_PRICE_LIST_LINE_rec.print_on_invoice_flag;
1282: END IF;
1283:
1284: IF l_PRICE_LIST_LINE_rec.program_application_id = FND_API.G_MISS_NUM THEN
1285: l_PRICE_LIST_LINE_rec.program_application_id := p_old_PRICE_LIST_LINE_rec.program_application_id;
1286: END IF;
1287:
1288: IF l_PRICE_LIST_LINE_rec.program_id = FND_API.G_MISS_NUM THEN

Line 1288: IF l_PRICE_LIST_LINE_rec.program_id = FND_API.G_MISS_NUM THEN

1284: IF l_PRICE_LIST_LINE_rec.program_application_id = FND_API.G_MISS_NUM THEN
1285: l_PRICE_LIST_LINE_rec.program_application_id := p_old_PRICE_LIST_LINE_rec.program_application_id;
1286: END IF;
1287:
1288: IF l_PRICE_LIST_LINE_rec.program_id = FND_API.G_MISS_NUM THEN
1289: l_PRICE_LIST_LINE_rec.program_id := p_old_PRICE_LIST_LINE_rec.program_id;
1290: END IF;
1291:
1292: IF l_PRICE_LIST_LINE_rec.program_update_date = FND_API.G_MISS_DATE THEN

Line 1292: IF l_PRICE_LIST_LINE_rec.program_update_date = FND_API.G_MISS_DATE THEN

1288: IF l_PRICE_LIST_LINE_rec.program_id = FND_API.G_MISS_NUM THEN
1289: l_PRICE_LIST_LINE_rec.program_id := p_old_PRICE_LIST_LINE_rec.program_id;
1290: END IF;
1291:
1292: IF l_PRICE_LIST_LINE_rec.program_update_date = FND_API.G_MISS_DATE THEN
1293: l_PRICE_LIST_LINE_rec.program_update_date := p_old_PRICE_LIST_LINE_rec.program_update_date;
1294: END IF;
1295:
1296: IF l_PRICE_LIST_LINE_rec.rebate_trxn_type_code = FND_API.G_MISS_CHAR THEN

Line 1296: IF l_PRICE_LIST_LINE_rec.rebate_trxn_type_code = FND_API.G_MISS_CHAR THEN

1292: IF l_PRICE_LIST_LINE_rec.program_update_date = FND_API.G_MISS_DATE THEN
1293: l_PRICE_LIST_LINE_rec.program_update_date := p_old_PRICE_LIST_LINE_rec.program_update_date;
1294: END IF;
1295:
1296: IF l_PRICE_LIST_LINE_rec.rebate_trxn_type_code = FND_API.G_MISS_CHAR THEN
1297: l_PRICE_LIST_LINE_rec.rebate_trxn_type_code := p_old_PRICE_LIST_LINE_rec.rebate_trxn_type_code;
1298: END IF;
1299:
1300: -- block pricing

Line 1301: IF l_PRICE_LIST_LINE_rec.recurring_value = FND_API.G_MISS_NUM THEN

1297: l_PRICE_LIST_LINE_rec.rebate_trxn_type_code := p_old_PRICE_LIST_LINE_rec.rebate_trxn_type_code;
1298: END IF;
1299:
1300: -- block pricing
1301: IF l_PRICE_LIST_LINE_rec.recurring_value = FND_API.G_MISS_NUM THEN
1302: l_PRICE_LIST_LINE_rec.recurring_value := p_old_PRICE_LIST_LINE_rec.recurring_value;
1303: END IF;
1304:
1305: IF l_PRICE_LIST_LINE_rec.related_item_id = FND_API.G_MISS_NUM THEN

Line 1305: IF l_PRICE_LIST_LINE_rec.related_item_id = FND_API.G_MISS_NUM THEN

1301: IF l_PRICE_LIST_LINE_rec.recurring_value = FND_API.G_MISS_NUM THEN
1302: l_PRICE_LIST_LINE_rec.recurring_value := p_old_PRICE_LIST_LINE_rec.recurring_value;
1303: END IF;
1304:
1305: IF l_PRICE_LIST_LINE_rec.related_item_id = FND_API.G_MISS_NUM THEN
1306: l_PRICE_LIST_LINE_rec.related_item_id := p_old_PRICE_LIST_LINE_rec.related_item_id;
1307: END IF;
1308:
1309: IF l_PRICE_LIST_LINE_rec.relationship_type_id = FND_API.G_MISS_NUM THEN

Line 1309: IF l_PRICE_LIST_LINE_rec.relationship_type_id = FND_API.G_MISS_NUM THEN

1305: IF l_PRICE_LIST_LINE_rec.related_item_id = FND_API.G_MISS_NUM THEN
1306: l_PRICE_LIST_LINE_rec.related_item_id := p_old_PRICE_LIST_LINE_rec.related_item_id;
1307: END IF;
1308:
1309: IF l_PRICE_LIST_LINE_rec.relationship_type_id = FND_API.G_MISS_NUM THEN
1310: l_PRICE_LIST_LINE_rec.relationship_type_id := p_old_PRICE_LIST_LINE_rec.relationship_type_id;
1311: END IF;
1312:
1313: IF l_PRICE_LIST_LINE_rec.reprice_flag = FND_API.G_MISS_CHAR THEN

Line 1313: IF l_PRICE_LIST_LINE_rec.reprice_flag = FND_API.G_MISS_CHAR THEN

1309: IF l_PRICE_LIST_LINE_rec.relationship_type_id = FND_API.G_MISS_NUM THEN
1310: l_PRICE_LIST_LINE_rec.relationship_type_id := p_old_PRICE_LIST_LINE_rec.relationship_type_id;
1311: END IF;
1312:
1313: IF l_PRICE_LIST_LINE_rec.reprice_flag = FND_API.G_MISS_CHAR THEN
1314: l_PRICE_LIST_LINE_rec.reprice_flag := p_old_PRICE_LIST_LINE_rec.reprice_flag;
1315: END IF;
1316:
1317: IF l_PRICE_LIST_LINE_rec.request_id = FND_API.G_MISS_NUM THEN

Line 1317: IF l_PRICE_LIST_LINE_rec.request_id = FND_API.G_MISS_NUM THEN

1313: IF l_PRICE_LIST_LINE_rec.reprice_flag = FND_API.G_MISS_CHAR THEN
1314: l_PRICE_LIST_LINE_rec.reprice_flag := p_old_PRICE_LIST_LINE_rec.reprice_flag;
1315: END IF;
1316:
1317: IF l_PRICE_LIST_LINE_rec.request_id = FND_API.G_MISS_NUM THEN
1318: l_PRICE_LIST_LINE_rec.request_id := p_old_PRICE_LIST_LINE_rec.request_id;
1319: END IF;
1320:
1321: IF l_PRICE_LIST_LINE_rec.revision = FND_API.G_MISS_CHAR THEN

Line 1321: IF l_PRICE_LIST_LINE_rec.revision = FND_API.G_MISS_CHAR THEN

1317: IF l_PRICE_LIST_LINE_rec.request_id = FND_API.G_MISS_NUM THEN
1318: l_PRICE_LIST_LINE_rec.request_id := p_old_PRICE_LIST_LINE_rec.request_id;
1319: END IF;
1320:
1321: IF l_PRICE_LIST_LINE_rec.revision = FND_API.G_MISS_CHAR THEN
1322: l_PRICE_LIST_LINE_rec.revision := p_old_PRICE_LIST_LINE_rec.revision;
1323: END IF;
1324:
1325: IF l_PRICE_LIST_LINE_rec.revision_date = FND_API.G_MISS_DATE THEN

Line 1325: IF l_PRICE_LIST_LINE_rec.revision_date = FND_API.G_MISS_DATE THEN

1321: IF l_PRICE_LIST_LINE_rec.revision = FND_API.G_MISS_CHAR THEN
1322: l_PRICE_LIST_LINE_rec.revision := p_old_PRICE_LIST_LINE_rec.revision;
1323: END IF;
1324:
1325: IF l_PRICE_LIST_LINE_rec.revision_date = FND_API.G_MISS_DATE THEN
1326: l_PRICE_LIST_LINE_rec.revision_date := p_old_PRICE_LIST_LINE_rec.revision_date;
1327: END IF;
1328:
1329: IF l_PRICE_LIST_LINE_rec.revision_reason_code = FND_API.G_MISS_CHAR THEN

Line 1329: IF l_PRICE_LIST_LINE_rec.revision_reason_code = FND_API.G_MISS_CHAR THEN

1325: IF l_PRICE_LIST_LINE_rec.revision_date = FND_API.G_MISS_DATE THEN
1326: l_PRICE_LIST_LINE_rec.revision_date := p_old_PRICE_LIST_LINE_rec.revision_date;
1327: END IF;
1328:
1329: IF l_PRICE_LIST_LINE_rec.revision_reason_code = FND_API.G_MISS_CHAR THEN
1330: l_PRICE_LIST_LINE_rec.revision_reason_code := p_old_PRICE_LIST_LINE_rec.revision_reason_code;
1331: END IF;
1332:
1333: IF l_PRICE_LIST_LINE_rec.start_date_active = FND_API.G_MISS_DATE THEN

Line 1333: IF l_PRICE_LIST_LINE_rec.start_date_active = FND_API.G_MISS_DATE THEN

1329: IF l_PRICE_LIST_LINE_rec.revision_reason_code = FND_API.G_MISS_CHAR THEN
1330: l_PRICE_LIST_LINE_rec.revision_reason_code := p_old_PRICE_LIST_LINE_rec.revision_reason_code;
1331: END IF;
1332:
1333: IF l_PRICE_LIST_LINE_rec.start_date_active = FND_API.G_MISS_DATE THEN
1334: l_PRICE_LIST_LINE_rec.start_date_active := p_old_PRICE_LIST_LINE_rec.start_date_active;
1335: END IF;
1336:
1337: IF l_PRICE_LIST_LINE_rec.substitution_attribute = FND_API.G_MISS_CHAR THEN

Line 1337: IF l_PRICE_LIST_LINE_rec.substitution_attribute = FND_API.G_MISS_CHAR THEN

1333: IF l_PRICE_LIST_LINE_rec.start_date_active = FND_API.G_MISS_DATE THEN
1334: l_PRICE_LIST_LINE_rec.start_date_active := p_old_PRICE_LIST_LINE_rec.start_date_active;
1335: END IF;
1336:
1337: IF l_PRICE_LIST_LINE_rec.substitution_attribute = FND_API.G_MISS_CHAR THEN
1338: l_PRICE_LIST_LINE_rec.substitution_attribute := p_old_PRICE_LIST_LINE_rec.substitution_attribute;
1339: END IF;
1340:
1341: IF l_PRICE_LIST_LINE_rec.substitution_context = FND_API.G_MISS_CHAR THEN

Line 1341: IF l_PRICE_LIST_LINE_rec.substitution_context = FND_API.G_MISS_CHAR THEN

1337: IF l_PRICE_LIST_LINE_rec.substitution_attribute = FND_API.G_MISS_CHAR THEN
1338: l_PRICE_LIST_LINE_rec.substitution_attribute := p_old_PRICE_LIST_LINE_rec.substitution_attribute;
1339: END IF;
1340:
1341: IF l_PRICE_LIST_LINE_rec.substitution_context = FND_API.G_MISS_CHAR THEN
1342: l_PRICE_LIST_LINE_rec.substitution_context := p_old_PRICE_LIST_LINE_rec.substitution_context;
1343: END IF;
1344:
1345: IF l_PRICE_LIST_LINE_rec.substitution_value = FND_API.G_MISS_CHAR THEN

Line 1345: IF l_PRICE_LIST_LINE_rec.substitution_value = FND_API.G_MISS_CHAR THEN

1341: IF l_PRICE_LIST_LINE_rec.substitution_context = FND_API.G_MISS_CHAR THEN
1342: l_PRICE_LIST_LINE_rec.substitution_context := p_old_PRICE_LIST_LINE_rec.substitution_context;
1343: END IF;
1344:
1345: IF l_PRICE_LIST_LINE_rec.substitution_value = FND_API.G_MISS_CHAR THEN
1346: l_PRICE_LIST_LINE_rec.substitution_value := p_old_PRICE_LIST_LINE_rec.substitution_value;
1347: END IF;
1348:
1349: IF l_PRICE_LIST_LINE_rec.qualification_ind = FND_API.G_MISS_NUM THEN

Line 1349: IF l_PRICE_LIST_LINE_rec.qualification_ind = FND_API.G_MISS_NUM THEN

1345: IF l_PRICE_LIST_LINE_rec.substitution_value = FND_API.G_MISS_CHAR THEN
1346: l_PRICE_LIST_LINE_rec.substitution_value := p_old_PRICE_LIST_LINE_rec.substitution_value;
1347: END IF;
1348:
1349: IF l_PRICE_LIST_LINE_rec.qualification_ind = FND_API.G_MISS_NUM THEN
1350: l_PRICE_LIST_LINE_rec.qualification_ind := p_old_PRICE_LIST_LINE_rec.qualification_ind;
1351: END IF;
1352:
1353: IF l_PRICE_LIST_LINE_rec.break_uom_code = FND_API.G_MISS_CHAR THEN

Line 1353: IF l_PRICE_LIST_LINE_rec.break_uom_code = FND_API.G_MISS_CHAR THEN

1349: IF l_PRICE_LIST_LINE_rec.qualification_ind = FND_API.G_MISS_NUM THEN
1350: l_PRICE_LIST_LINE_rec.qualification_ind := p_old_PRICE_LIST_LINE_rec.qualification_ind;
1351: END IF;
1352:
1353: IF l_PRICE_LIST_LINE_rec.break_uom_code = FND_API.G_MISS_CHAR THEN
1354: l_PRICE_LIST_LINE_rec.break_uom_code := p_old_PRICE_LIST_LINE_rec.break_uom_code;
1355: END IF;
1356:
1357: IF l_PRICE_LIST_LINE_rec.break_uom_context = FND_API.G_MISS_CHAR THEN

Line 1357: IF l_PRICE_LIST_LINE_rec.break_uom_context = FND_API.G_MISS_CHAR THEN

1353: IF l_PRICE_LIST_LINE_rec.break_uom_code = FND_API.G_MISS_CHAR THEN
1354: l_PRICE_LIST_LINE_rec.break_uom_code := p_old_PRICE_LIST_LINE_rec.break_uom_code;
1355: END IF;
1356:
1357: IF l_PRICE_LIST_LINE_rec.break_uom_context = FND_API.G_MISS_CHAR THEN
1358: l_PRICE_LIST_LINE_rec.break_uom_context := p_old_PRICE_LIST_LINE_rec.break_uom_context;
1359: END IF;
1360:
1361: IF l_PRICE_LIST_LINE_rec.break_uom_attribute = FND_API.G_MISS_CHAR THEN

Line 1361: IF l_PRICE_LIST_LINE_rec.break_uom_attribute = FND_API.G_MISS_CHAR THEN

1357: IF l_PRICE_LIST_LINE_rec.break_uom_context = FND_API.G_MISS_CHAR THEN
1358: l_PRICE_LIST_LINE_rec.break_uom_context := p_old_PRICE_LIST_LINE_rec.break_uom_context;
1359: END IF;
1360:
1361: IF l_PRICE_LIST_LINE_rec.break_uom_attribute = FND_API.G_MISS_CHAR THEN
1362: l_PRICE_LIST_LINE_rec.break_uom_attribute := p_old_PRICE_LIST_LINE_rec.break_uom_attribute;
1363: END IF;
1364:
1365: IF l_PRICE_LIST_LINE_rec.continuous_price_break_flag = FND_API.G_MISS_CHAR THEN

Line 1365: IF l_PRICE_LIST_LINE_rec.continuous_price_break_flag = FND_API.G_MISS_CHAR THEN

1361: IF l_PRICE_LIST_LINE_rec.break_uom_attribute = FND_API.G_MISS_CHAR THEN
1362: l_PRICE_LIST_LINE_rec.break_uom_attribute := p_old_PRICE_LIST_LINE_rec.break_uom_attribute;
1363: END IF;
1364:
1365: IF l_PRICE_LIST_LINE_rec.continuous_price_break_flag = FND_API.G_MISS_CHAR THEN
1366: l_PRICE_LIST_LINE_rec.continuous_price_break_flag := p_old_PRICE_LIST_LINE_rec.continuous_price_break_flag;
1367: END IF;
1368:
1369: RETURN l_PRICE_LIST_LINE_rec;

Line 1382: IF l_PRICE_LIST_LINE_rec.accrual_qty = FND_API.G_MISS_NUM THEN

1378: IS
1379: l_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type := p_PRICE_LIST_LINE_rec;
1380: BEGIN
1381:
1382: IF l_PRICE_LIST_LINE_rec.accrual_qty = FND_API.G_MISS_NUM THEN
1383: l_PRICE_LIST_LINE_rec.accrual_qty := NULL;
1384: END IF;
1385:
1386: IF l_PRICE_LIST_LINE_rec.accrual_uom_code = FND_API.G_MISS_CHAR THEN

Line 1386: IF l_PRICE_LIST_LINE_rec.accrual_uom_code = FND_API.G_MISS_CHAR THEN

1382: IF l_PRICE_LIST_LINE_rec.accrual_qty = FND_API.G_MISS_NUM THEN
1383: l_PRICE_LIST_LINE_rec.accrual_qty := NULL;
1384: END IF;
1385:
1386: IF l_PRICE_LIST_LINE_rec.accrual_uom_code = FND_API.G_MISS_CHAR THEN
1387: l_PRICE_LIST_LINE_rec.accrual_uom_code := NULL;
1388: END IF;
1389:
1390: IF l_PRICE_LIST_LINE_rec.arithmetic_operator = FND_API.G_MISS_CHAR THEN

Line 1390: IF l_PRICE_LIST_LINE_rec.arithmetic_operator = FND_API.G_MISS_CHAR THEN

1386: IF l_PRICE_LIST_LINE_rec.accrual_uom_code = FND_API.G_MISS_CHAR THEN
1387: l_PRICE_LIST_LINE_rec.accrual_uom_code := NULL;
1388: END IF;
1389:
1390: IF l_PRICE_LIST_LINE_rec.arithmetic_operator = FND_API.G_MISS_CHAR THEN
1391: l_PRICE_LIST_LINE_rec.arithmetic_operator := NULL;
1392: END IF;
1393:
1394: IF l_PRICE_LIST_LINE_rec.attribute1 = FND_API.G_MISS_CHAR THEN

Line 1394: IF l_PRICE_LIST_LINE_rec.attribute1 = FND_API.G_MISS_CHAR THEN

1390: IF l_PRICE_LIST_LINE_rec.arithmetic_operator = FND_API.G_MISS_CHAR THEN
1391: l_PRICE_LIST_LINE_rec.arithmetic_operator := NULL;
1392: END IF;
1393:
1394: IF l_PRICE_LIST_LINE_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1395: l_PRICE_LIST_LINE_rec.attribute1 := NULL;
1396: END IF;
1397:
1398: IF l_PRICE_LIST_LINE_rec.attribute10 = FND_API.G_MISS_CHAR THEN

Line 1398: IF l_PRICE_LIST_LINE_rec.attribute10 = FND_API.G_MISS_CHAR THEN

1394: IF l_PRICE_LIST_LINE_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1395: l_PRICE_LIST_LINE_rec.attribute1 := NULL;
1396: END IF;
1397:
1398: IF l_PRICE_LIST_LINE_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1399: l_PRICE_LIST_LINE_rec.attribute10 := NULL;
1400: END IF;
1401:
1402: IF l_PRICE_LIST_LINE_rec.attribute11 = FND_API.G_MISS_CHAR THEN

Line 1402: IF l_PRICE_LIST_LINE_rec.attribute11 = FND_API.G_MISS_CHAR THEN

1398: IF l_PRICE_LIST_LINE_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1399: l_PRICE_LIST_LINE_rec.attribute10 := NULL;
1400: END IF;
1401:
1402: IF l_PRICE_LIST_LINE_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1403: l_PRICE_LIST_LINE_rec.attribute11 := NULL;
1404: END IF;
1405:
1406: IF l_PRICE_LIST_LINE_rec.attribute12 = FND_API.G_MISS_CHAR THEN

Line 1406: IF l_PRICE_LIST_LINE_rec.attribute12 = FND_API.G_MISS_CHAR THEN

1402: IF l_PRICE_LIST_LINE_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1403: l_PRICE_LIST_LINE_rec.attribute11 := NULL;
1404: END IF;
1405:
1406: IF l_PRICE_LIST_LINE_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1407: l_PRICE_LIST_LINE_rec.attribute12 := NULL;
1408: END IF;
1409:
1410: IF l_PRICE_LIST_LINE_rec.attribute13 = FND_API.G_MISS_CHAR THEN

Line 1410: IF l_PRICE_LIST_LINE_rec.attribute13 = FND_API.G_MISS_CHAR THEN

1406: IF l_PRICE_LIST_LINE_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1407: l_PRICE_LIST_LINE_rec.attribute12 := NULL;
1408: END IF;
1409:
1410: IF l_PRICE_LIST_LINE_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1411: l_PRICE_LIST_LINE_rec.attribute13 := NULL;
1412: END IF;
1413:
1414: IF l_PRICE_LIST_LINE_rec.attribute14 = FND_API.G_MISS_CHAR THEN

Line 1414: IF l_PRICE_LIST_LINE_rec.attribute14 = FND_API.G_MISS_CHAR THEN

1410: IF l_PRICE_LIST_LINE_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1411: l_PRICE_LIST_LINE_rec.attribute13 := NULL;
1412: END IF;
1413:
1414: IF l_PRICE_LIST_LINE_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1415: l_PRICE_LIST_LINE_rec.attribute14 := NULL;
1416: END IF;
1417:
1418: IF l_PRICE_LIST_LINE_rec.attribute15 = FND_API.G_MISS_CHAR THEN

Line 1418: IF l_PRICE_LIST_LINE_rec.attribute15 = FND_API.G_MISS_CHAR THEN

1414: IF l_PRICE_LIST_LINE_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1415: l_PRICE_LIST_LINE_rec.attribute14 := NULL;
1416: END IF;
1417:
1418: IF l_PRICE_LIST_LINE_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1419: l_PRICE_LIST_LINE_rec.attribute15 := NULL;
1420: END IF;
1421:
1422: IF l_PRICE_LIST_LINE_rec.attribute2 = FND_API.G_MISS_CHAR THEN

Line 1422: IF l_PRICE_LIST_LINE_rec.attribute2 = FND_API.G_MISS_CHAR THEN

1418: IF l_PRICE_LIST_LINE_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1419: l_PRICE_LIST_LINE_rec.attribute15 := NULL;
1420: END IF;
1421:
1422: IF l_PRICE_LIST_LINE_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1423: l_PRICE_LIST_LINE_rec.attribute2 := NULL;
1424: END IF;
1425:
1426: IF l_PRICE_LIST_LINE_rec.attribute3 = FND_API.G_MISS_CHAR THEN

Line 1426: IF l_PRICE_LIST_LINE_rec.attribute3 = FND_API.G_MISS_CHAR THEN

1422: IF l_PRICE_LIST_LINE_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1423: l_PRICE_LIST_LINE_rec.attribute2 := NULL;
1424: END IF;
1425:
1426: IF l_PRICE_LIST_LINE_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1427: l_PRICE_LIST_LINE_rec.attribute3 := NULL;
1428: END IF;
1429:
1430: IF l_PRICE_LIST_LINE_rec.attribute4 = FND_API.G_MISS_CHAR THEN

Line 1430: IF l_PRICE_LIST_LINE_rec.attribute4 = FND_API.G_MISS_CHAR THEN

1426: IF l_PRICE_LIST_LINE_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1427: l_PRICE_LIST_LINE_rec.attribute3 := NULL;
1428: END IF;
1429:
1430: IF l_PRICE_LIST_LINE_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1431: l_PRICE_LIST_LINE_rec.attribute4 := NULL;
1432: END IF;
1433:
1434: IF l_PRICE_LIST_LINE_rec.attribute5 = FND_API.G_MISS_CHAR THEN

Line 1434: IF l_PRICE_LIST_LINE_rec.attribute5 = FND_API.G_MISS_CHAR THEN

1430: IF l_PRICE_LIST_LINE_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1431: l_PRICE_LIST_LINE_rec.attribute4 := NULL;
1432: END IF;
1433:
1434: IF l_PRICE_LIST_LINE_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1435: l_PRICE_LIST_LINE_rec.attribute5 := NULL;
1436: END IF;
1437:
1438: IF l_PRICE_LIST_LINE_rec.attribute6 = FND_API.G_MISS_CHAR THEN

Line 1438: IF l_PRICE_LIST_LINE_rec.attribute6 = FND_API.G_MISS_CHAR THEN

1434: IF l_PRICE_LIST_LINE_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1435: l_PRICE_LIST_LINE_rec.attribute5 := NULL;
1436: END IF;
1437:
1438: IF l_PRICE_LIST_LINE_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1439: l_PRICE_LIST_LINE_rec.attribute6 := NULL;
1440: END IF;
1441:
1442: IF l_PRICE_LIST_LINE_rec.attribute7 = FND_API.G_MISS_CHAR THEN

Line 1442: IF l_PRICE_LIST_LINE_rec.attribute7 = FND_API.G_MISS_CHAR THEN

1438: IF l_PRICE_LIST_LINE_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1439: l_PRICE_LIST_LINE_rec.attribute6 := NULL;
1440: END IF;
1441:
1442: IF l_PRICE_LIST_LINE_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1443: l_PRICE_LIST_LINE_rec.attribute7 := NULL;
1444: END IF;
1445:
1446: IF l_PRICE_LIST_LINE_rec.attribute8 = FND_API.G_MISS_CHAR THEN

Line 1446: IF l_PRICE_LIST_LINE_rec.attribute8 = FND_API.G_MISS_CHAR THEN

1442: IF l_PRICE_LIST_LINE_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1443: l_PRICE_LIST_LINE_rec.attribute7 := NULL;
1444: END IF;
1445:
1446: IF l_PRICE_LIST_LINE_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1447: l_PRICE_LIST_LINE_rec.attribute8 := NULL;
1448: END IF;
1449:
1450: IF l_PRICE_LIST_LINE_rec.attribute9 = FND_API.G_MISS_CHAR THEN

Line 1450: IF l_PRICE_LIST_LINE_rec.attribute9 = FND_API.G_MISS_CHAR THEN

1446: IF l_PRICE_LIST_LINE_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1447: l_PRICE_LIST_LINE_rec.attribute8 := NULL;
1448: END IF;
1449:
1450: IF l_PRICE_LIST_LINE_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1451: l_PRICE_LIST_LINE_rec.attribute9 := NULL;
1452: END IF;
1453:
1454: IF l_PRICE_LIST_LINE_rec.automatic_flag = FND_API.G_MISS_CHAR THEN

Line 1454: IF l_PRICE_LIST_LINE_rec.automatic_flag = FND_API.G_MISS_CHAR THEN

1450: IF l_PRICE_LIST_LINE_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1451: l_PRICE_LIST_LINE_rec.attribute9 := NULL;
1452: END IF;
1453:
1454: IF l_PRICE_LIST_LINE_rec.automatic_flag = FND_API.G_MISS_CHAR THEN
1455: l_PRICE_LIST_LINE_rec.automatic_flag := NULL;
1456: END IF;
1457:
1458: IF l_PRICE_LIST_LINE_rec.base_qty = FND_API.G_MISS_NUM THEN

Line 1458: IF l_PRICE_LIST_LINE_rec.base_qty = FND_API.G_MISS_NUM THEN

1454: IF l_PRICE_LIST_LINE_rec.automatic_flag = FND_API.G_MISS_CHAR THEN
1455: l_PRICE_LIST_LINE_rec.automatic_flag := NULL;
1456: END IF;
1457:
1458: IF l_PRICE_LIST_LINE_rec.base_qty = FND_API.G_MISS_NUM THEN
1459: l_PRICE_LIST_LINE_rec.base_qty := NULL;
1460: END IF;
1461:
1462: IF l_PRICE_LIST_LINE_rec.base_uom_code = FND_API.G_MISS_CHAR THEN

Line 1462: IF l_PRICE_LIST_LINE_rec.base_uom_code = FND_API.G_MISS_CHAR THEN

1458: IF l_PRICE_LIST_LINE_rec.base_qty = FND_API.G_MISS_NUM THEN
1459: l_PRICE_LIST_LINE_rec.base_qty := NULL;
1460: END IF;
1461:
1462: IF l_PRICE_LIST_LINE_rec.base_uom_code = FND_API.G_MISS_CHAR THEN
1463: l_PRICE_LIST_LINE_rec.base_uom_code := NULL;
1464: END IF;
1465:
1466: IF l_PRICE_LIST_LINE_rec.comments = FND_API.G_MISS_CHAR THEN

Line 1466: IF l_PRICE_LIST_LINE_rec.comments = FND_API.G_MISS_CHAR THEN

1462: IF l_PRICE_LIST_LINE_rec.base_uom_code = FND_API.G_MISS_CHAR THEN
1463: l_PRICE_LIST_LINE_rec.base_uom_code := NULL;
1464: END IF;
1465:
1466: IF l_PRICE_LIST_LINE_rec.comments = FND_API.G_MISS_CHAR THEN
1467: l_PRICE_LIST_LINE_rec.comments := NULL;
1468: END IF;
1469:
1470: IF l_PRICE_LIST_LINE_rec.context = FND_API.G_MISS_CHAR THEN

Line 1470: IF l_PRICE_LIST_LINE_rec.context = FND_API.G_MISS_CHAR THEN

1466: IF l_PRICE_LIST_LINE_rec.comments = FND_API.G_MISS_CHAR THEN
1467: l_PRICE_LIST_LINE_rec.comments := NULL;
1468: END IF;
1469:
1470: IF l_PRICE_LIST_LINE_rec.context = FND_API.G_MISS_CHAR THEN
1471: l_PRICE_LIST_LINE_rec.context := NULL;
1472: END IF;
1473:
1474: IF l_PRICE_LIST_LINE_rec.created_by = FND_API.G_MISS_NUM THEN

Line 1474: IF l_PRICE_LIST_LINE_rec.created_by = FND_API.G_MISS_NUM THEN

1470: IF l_PRICE_LIST_LINE_rec.context = FND_API.G_MISS_CHAR THEN
1471: l_PRICE_LIST_LINE_rec.context := NULL;
1472: END IF;
1473:
1474: IF l_PRICE_LIST_LINE_rec.created_by = FND_API.G_MISS_NUM THEN
1475: l_PRICE_LIST_LINE_rec.created_by := NULL;
1476: END IF;
1477:
1478: IF l_PRICE_LIST_LINE_rec.creation_date = FND_API.G_MISS_DATE THEN

Line 1478: IF l_PRICE_LIST_LINE_rec.creation_date = FND_API.G_MISS_DATE THEN

1474: IF l_PRICE_LIST_LINE_rec.created_by = FND_API.G_MISS_NUM THEN
1475: l_PRICE_LIST_LINE_rec.created_by := NULL;
1476: END IF;
1477:
1478: IF l_PRICE_LIST_LINE_rec.creation_date = FND_API.G_MISS_DATE THEN
1479: l_PRICE_LIST_LINE_rec.creation_date := NULL;
1480: END IF;
1481:
1482: IF l_PRICE_LIST_LINE_rec.effective_period_uom = FND_API.G_MISS_CHAR THEN

Line 1482: IF l_PRICE_LIST_LINE_rec.effective_period_uom = FND_API.G_MISS_CHAR THEN

1478: IF l_PRICE_LIST_LINE_rec.creation_date = FND_API.G_MISS_DATE THEN
1479: l_PRICE_LIST_LINE_rec.creation_date := NULL;
1480: END IF;
1481:
1482: IF l_PRICE_LIST_LINE_rec.effective_period_uom = FND_API.G_MISS_CHAR THEN
1483: l_PRICE_LIST_LINE_rec.effective_period_uom := NULL;
1484: END IF;
1485:
1486: IF l_PRICE_LIST_LINE_rec.end_date_active = FND_API.G_MISS_DATE THEN

Line 1486: IF l_PRICE_LIST_LINE_rec.end_date_active = FND_API.G_MISS_DATE THEN

1482: IF l_PRICE_LIST_LINE_rec.effective_period_uom = FND_API.G_MISS_CHAR THEN
1483: l_PRICE_LIST_LINE_rec.effective_period_uom := NULL;
1484: END IF;
1485:
1486: IF l_PRICE_LIST_LINE_rec.end_date_active = FND_API.G_MISS_DATE THEN
1487: l_PRICE_LIST_LINE_rec.end_date_active := NULL;
1488: END IF;
1489:
1490: IF l_PRICE_LIST_LINE_rec.estim_accrual_rate = FND_API.G_MISS_NUM THEN

Line 1490: IF l_PRICE_LIST_LINE_rec.estim_accrual_rate = FND_API.G_MISS_NUM THEN

1486: IF l_PRICE_LIST_LINE_rec.end_date_active = FND_API.G_MISS_DATE THEN
1487: l_PRICE_LIST_LINE_rec.end_date_active := NULL;
1488: END IF;
1489:
1490: IF l_PRICE_LIST_LINE_rec.estim_accrual_rate = FND_API.G_MISS_NUM THEN
1491: l_PRICE_LIST_LINE_rec.estim_accrual_rate := NULL;
1492: END IF;
1493:
1494: IF l_PRICE_LIST_LINE_rec.generate_using_formula_id = FND_API.G_MISS_NUM THEN

Line 1494: IF l_PRICE_LIST_LINE_rec.generate_using_formula_id = FND_API.G_MISS_NUM THEN

1490: IF l_PRICE_LIST_LINE_rec.estim_accrual_rate = FND_API.G_MISS_NUM THEN
1491: l_PRICE_LIST_LINE_rec.estim_accrual_rate := NULL;
1492: END IF;
1493:
1494: IF l_PRICE_LIST_LINE_rec.generate_using_formula_id = FND_API.G_MISS_NUM THEN
1495: l_PRICE_LIST_LINE_rec.generate_using_formula_id := NULL;
1496: END IF;
1497:
1498: IF l_PRICE_LIST_LINE_rec.inventory_item_id = FND_API.G_MISS_NUM THEN

Line 1498: IF l_PRICE_LIST_LINE_rec.inventory_item_id = FND_API.G_MISS_NUM THEN

1494: IF l_PRICE_LIST_LINE_rec.generate_using_formula_id = FND_API.G_MISS_NUM THEN
1495: l_PRICE_LIST_LINE_rec.generate_using_formula_id := NULL;
1496: END IF;
1497:
1498: IF l_PRICE_LIST_LINE_rec.inventory_item_id = FND_API.G_MISS_NUM THEN
1499: l_PRICE_LIST_LINE_rec.inventory_item_id := NULL;
1500: END IF;
1501:
1502: IF l_PRICE_LIST_LINE_rec.last_updated_by = FND_API.G_MISS_NUM THEN

Line 1502: IF l_PRICE_LIST_LINE_rec.last_updated_by = FND_API.G_MISS_NUM THEN

1498: IF l_PRICE_LIST_LINE_rec.inventory_item_id = FND_API.G_MISS_NUM THEN
1499: l_PRICE_LIST_LINE_rec.inventory_item_id := NULL;
1500: END IF;
1501:
1502: IF l_PRICE_LIST_LINE_rec.last_updated_by = FND_API.G_MISS_NUM THEN
1503: l_PRICE_LIST_LINE_rec.last_updated_by := NULL;
1504: END IF;
1505:
1506: IF l_PRICE_LIST_LINE_rec.last_update_date = FND_API.G_MISS_DATE THEN

Line 1506: IF l_PRICE_LIST_LINE_rec.last_update_date = FND_API.G_MISS_DATE THEN

1502: IF l_PRICE_LIST_LINE_rec.last_updated_by = FND_API.G_MISS_NUM THEN
1503: l_PRICE_LIST_LINE_rec.last_updated_by := NULL;
1504: END IF;
1505:
1506: IF l_PRICE_LIST_LINE_rec.last_update_date = FND_API.G_MISS_DATE THEN
1507: l_PRICE_LIST_LINE_rec.last_update_date := NULL;
1508: END IF;
1509:
1510: IF l_PRICE_LIST_LINE_rec.last_update_login = FND_API.G_MISS_NUM THEN

Line 1510: IF l_PRICE_LIST_LINE_rec.last_update_login = FND_API.G_MISS_NUM THEN

1506: IF l_PRICE_LIST_LINE_rec.last_update_date = FND_API.G_MISS_DATE THEN
1507: l_PRICE_LIST_LINE_rec.last_update_date := NULL;
1508: END IF;
1509:
1510: IF l_PRICE_LIST_LINE_rec.last_update_login = FND_API.G_MISS_NUM THEN
1511: l_PRICE_LIST_LINE_rec.last_update_login := NULL;
1512: END IF;
1513:
1514: IF l_PRICE_LIST_LINE_rec.list_header_id = FND_API.G_MISS_NUM THEN

Line 1514: IF l_PRICE_LIST_LINE_rec.list_header_id = FND_API.G_MISS_NUM THEN

1510: IF l_PRICE_LIST_LINE_rec.last_update_login = FND_API.G_MISS_NUM THEN
1511: l_PRICE_LIST_LINE_rec.last_update_login := NULL;
1512: END IF;
1513:
1514: IF l_PRICE_LIST_LINE_rec.list_header_id = FND_API.G_MISS_NUM THEN
1515: l_PRICE_LIST_LINE_rec.list_header_id := NULL;
1516: END IF;
1517:
1518: IF l_PRICE_LIST_LINE_rec.list_line_id = FND_API.G_MISS_NUM THEN

Line 1518: IF l_PRICE_LIST_LINE_rec.list_line_id = FND_API.G_MISS_NUM THEN

1514: IF l_PRICE_LIST_LINE_rec.list_header_id = FND_API.G_MISS_NUM THEN
1515: l_PRICE_LIST_LINE_rec.list_header_id := NULL;
1516: END IF;
1517:
1518: IF l_PRICE_LIST_LINE_rec.list_line_id = FND_API.G_MISS_NUM THEN
1519: l_PRICE_LIST_LINE_rec.list_line_id := NULL;
1520: END IF;
1521:
1522: IF l_PRICE_LIST_LINE_rec.list_line_no = FND_API.G_MISS_CHAR THEN -- bug 4751658, 4199398

Line 1522: IF l_PRICE_LIST_LINE_rec.list_line_no = FND_API.G_MISS_CHAR THEN -- bug 4751658, 4199398

1518: IF l_PRICE_LIST_LINE_rec.list_line_id = FND_API.G_MISS_NUM THEN
1519: l_PRICE_LIST_LINE_rec.list_line_id := NULL;
1520: END IF;
1521:
1522: IF l_PRICE_LIST_LINE_rec.list_line_no = FND_API.G_MISS_CHAR THEN -- bug 4751658, 4199398
1523: l_PRICE_LIST_LINE_rec.list_line_no := NULL;
1524: END IF;
1525:
1526: IF l_PRICE_LIST_LINE_rec.list_line_type_code = FND_API.G_MISS_CHAR THEN

Line 1526: IF l_PRICE_LIST_LINE_rec.list_line_type_code = FND_API.G_MISS_CHAR THEN

1522: IF l_PRICE_LIST_LINE_rec.list_line_no = FND_API.G_MISS_CHAR THEN -- bug 4751658, 4199398
1523: l_PRICE_LIST_LINE_rec.list_line_no := NULL;
1524: END IF;
1525:
1526: IF l_PRICE_LIST_LINE_rec.list_line_type_code = FND_API.G_MISS_CHAR THEN
1527: l_PRICE_LIST_LINE_rec.list_line_type_code := NULL;
1528: END IF;
1529:
1530: IF l_PRICE_LIST_LINE_rec.list_price = FND_API.G_MISS_NUM THEN

Line 1530: IF l_PRICE_LIST_LINE_rec.list_price = FND_API.G_MISS_NUM THEN

1526: IF l_PRICE_LIST_LINE_rec.list_line_type_code = FND_API.G_MISS_CHAR THEN
1527: l_PRICE_LIST_LINE_rec.list_line_type_code := NULL;
1528: END IF;
1529:
1530: IF l_PRICE_LIST_LINE_rec.list_price = FND_API.G_MISS_NUM THEN
1531: l_PRICE_LIST_LINE_rec.list_price := NULL;
1532: END IF;
1533:
1534: IF l_PRICE_LIST_LINE_rec.from_rltd_modifier_id = FND_API.G_MISS_NUM THEN

Line 1534: IF l_PRICE_LIST_LINE_rec.from_rltd_modifier_id = FND_API.G_MISS_NUM THEN

1530: IF l_PRICE_LIST_LINE_rec.list_price = FND_API.G_MISS_NUM THEN
1531: l_PRICE_LIST_LINE_rec.list_price := NULL;
1532: END IF;
1533:
1534: IF l_PRICE_LIST_LINE_rec.from_rltd_modifier_id = FND_API.G_MISS_NUM THEN
1535: l_PRICE_LIST_LINE_rec.from_rltd_modifier_id := NULL;
1536: END IF;
1537:
1538: IF l_PRICE_LIST_LINE_rec.rltd_modifier_group_no = FND_API.G_MISS_NUM THEN

Line 1538: IF l_PRICE_LIST_LINE_rec.rltd_modifier_group_no = FND_API.G_MISS_NUM THEN

1534: IF l_PRICE_LIST_LINE_rec.from_rltd_modifier_id = FND_API.G_MISS_NUM THEN
1535: l_PRICE_LIST_LINE_rec.from_rltd_modifier_id := NULL;
1536: END IF;
1537:
1538: IF l_PRICE_LIST_LINE_rec.rltd_modifier_group_no = FND_API.G_MISS_NUM THEN
1539: l_PRICE_LIST_LINE_rec.rltd_modifier_group_no := NULL;
1540: END IF;
1541:
1542: IF l_PRICE_LIST_LINE_rec.product_precedence = FND_API.G_MISS_NUM THEN

Line 1542: IF l_PRICE_LIST_LINE_rec.product_precedence = FND_API.G_MISS_NUM THEN

1538: IF l_PRICE_LIST_LINE_rec.rltd_modifier_group_no = FND_API.G_MISS_NUM THEN
1539: l_PRICE_LIST_LINE_rec.rltd_modifier_group_no := NULL;
1540: END IF;
1541:
1542: IF l_PRICE_LIST_LINE_rec.product_precedence = FND_API.G_MISS_NUM THEN
1543: l_PRICE_LIST_LINE_rec.product_precedence := NULL;
1544: END IF;
1545:
1546: IF l_PRICE_LIST_LINE_rec.modifier_level_code = FND_API.G_MISS_CHAR THEN

Line 1546: IF l_PRICE_LIST_LINE_rec.modifier_level_code = FND_API.G_MISS_CHAR THEN

1542: IF l_PRICE_LIST_LINE_rec.product_precedence = FND_API.G_MISS_NUM THEN
1543: l_PRICE_LIST_LINE_rec.product_precedence := NULL;
1544: END IF;
1545:
1546: IF l_PRICE_LIST_LINE_rec.modifier_level_code = FND_API.G_MISS_CHAR THEN
1547: l_PRICE_LIST_LINE_rec.modifier_level_code := NULL;
1548: END IF;
1549:
1550: IF l_PRICE_LIST_LINE_rec.number_effective_periods = FND_API.G_MISS_NUM THEN

Line 1550: IF l_PRICE_LIST_LINE_rec.number_effective_periods = FND_API.G_MISS_NUM THEN

1546: IF l_PRICE_LIST_LINE_rec.modifier_level_code = FND_API.G_MISS_CHAR THEN
1547: l_PRICE_LIST_LINE_rec.modifier_level_code := NULL;
1548: END IF;
1549:
1550: IF l_PRICE_LIST_LINE_rec.number_effective_periods = FND_API.G_MISS_NUM THEN
1551: l_PRICE_LIST_LINE_rec.number_effective_periods := NULL;
1552: END IF;
1553:
1554: IF l_PRICE_LIST_LINE_rec.operand = FND_API.G_MISS_NUM THEN

Line 1554: IF l_PRICE_LIST_LINE_rec.operand = FND_API.G_MISS_NUM THEN

1550: IF l_PRICE_LIST_LINE_rec.number_effective_periods = FND_API.G_MISS_NUM THEN
1551: l_PRICE_LIST_LINE_rec.number_effective_periods := NULL;
1552: END IF;
1553:
1554: IF l_PRICE_LIST_LINE_rec.operand = FND_API.G_MISS_NUM THEN
1555: l_PRICE_LIST_LINE_rec.operand := NULL;
1556: END IF;
1557:
1558: IF l_PRICE_LIST_LINE_rec.organization_id = FND_API.G_MISS_NUM THEN

Line 1558: IF l_PRICE_LIST_LINE_rec.organization_id = FND_API.G_MISS_NUM THEN

1554: IF l_PRICE_LIST_LINE_rec.operand = FND_API.G_MISS_NUM THEN
1555: l_PRICE_LIST_LINE_rec.operand := NULL;
1556: END IF;
1557:
1558: IF l_PRICE_LIST_LINE_rec.organization_id = FND_API.G_MISS_NUM THEN
1559: l_PRICE_LIST_LINE_rec.organization_id := NULL;
1560: END IF;
1561:
1562: IF l_PRICE_LIST_LINE_rec.override_flag = FND_API.G_MISS_CHAR THEN

Line 1562: IF l_PRICE_LIST_LINE_rec.override_flag = FND_API.G_MISS_CHAR THEN

1558: IF l_PRICE_LIST_LINE_rec.organization_id = FND_API.G_MISS_NUM THEN
1559: l_PRICE_LIST_LINE_rec.organization_id := NULL;
1560: END IF;
1561:
1562: IF l_PRICE_LIST_LINE_rec.override_flag = FND_API.G_MISS_CHAR THEN
1563: l_PRICE_LIST_LINE_rec.override_flag := NULL;
1564: END IF;
1565:
1566: IF l_PRICE_LIST_LINE_rec.percent_price = FND_API.G_MISS_NUM THEN

Line 1566: IF l_PRICE_LIST_LINE_rec.percent_price = FND_API.G_MISS_NUM THEN

1562: IF l_PRICE_LIST_LINE_rec.override_flag = FND_API.G_MISS_CHAR THEN
1563: l_PRICE_LIST_LINE_rec.override_flag := NULL;
1564: END IF;
1565:
1566: IF l_PRICE_LIST_LINE_rec.percent_price = FND_API.G_MISS_NUM THEN
1567: l_PRICE_LIST_LINE_rec.percent_price := NULL;
1568: END IF;
1569:
1570: IF l_PRICE_LIST_LINE_rec.price_break_type_code = FND_API.G_MISS_CHAR THEN

Line 1570: IF l_PRICE_LIST_LINE_rec.price_break_type_code = FND_API.G_MISS_CHAR THEN

1566: IF l_PRICE_LIST_LINE_rec.percent_price = FND_API.G_MISS_NUM THEN
1567: l_PRICE_LIST_LINE_rec.percent_price := NULL;
1568: END IF;
1569:
1570: IF l_PRICE_LIST_LINE_rec.price_break_type_code = FND_API.G_MISS_CHAR THEN
1571: l_PRICE_LIST_LINE_rec.price_break_type_code := NULL;
1572: END IF;
1573:
1574: IF l_PRICE_LIST_LINE_rec.price_by_formula_id = FND_API.G_MISS_NUM THEN

Line 1574: IF l_PRICE_LIST_LINE_rec.price_by_formula_id = FND_API.G_MISS_NUM THEN

1570: IF l_PRICE_LIST_LINE_rec.price_break_type_code = FND_API.G_MISS_CHAR THEN
1571: l_PRICE_LIST_LINE_rec.price_break_type_code := NULL;
1572: END IF;
1573:
1574: IF l_PRICE_LIST_LINE_rec.price_by_formula_id = FND_API.G_MISS_NUM THEN
1575: l_PRICE_LIST_LINE_rec.price_by_formula_id := NULL;
1576: END IF;
1577:
1578: IF l_PRICE_LIST_LINE_rec.primary_uom_flag = FND_API.G_MISS_CHAR THEN

Line 1578: IF l_PRICE_LIST_LINE_rec.primary_uom_flag = FND_API.G_MISS_CHAR THEN

1574: IF l_PRICE_LIST_LINE_rec.price_by_formula_id = FND_API.G_MISS_NUM THEN
1575: l_PRICE_LIST_LINE_rec.price_by_formula_id := NULL;
1576: END IF;
1577:
1578: IF l_PRICE_LIST_LINE_rec.primary_uom_flag = FND_API.G_MISS_CHAR THEN
1579: l_PRICE_LIST_LINE_rec.primary_uom_flag := NULL;
1580: END IF;
1581:
1582: IF l_PRICE_LIST_LINE_rec.print_on_invoice_flag = FND_API.G_MISS_CHAR THEN

Line 1582: IF l_PRICE_LIST_LINE_rec.print_on_invoice_flag = FND_API.G_MISS_CHAR THEN

1578: IF l_PRICE_LIST_LINE_rec.primary_uom_flag = FND_API.G_MISS_CHAR THEN
1579: l_PRICE_LIST_LINE_rec.primary_uom_flag := NULL;
1580: END IF;
1581:
1582: IF l_PRICE_LIST_LINE_rec.print_on_invoice_flag = FND_API.G_MISS_CHAR THEN
1583: l_PRICE_LIST_LINE_rec.print_on_invoice_flag := NULL;
1584: END IF;
1585:
1586: IF l_PRICE_LIST_LINE_rec.program_application_id = FND_API.G_MISS_NUM THEN

Line 1586: IF l_PRICE_LIST_LINE_rec.program_application_id = FND_API.G_MISS_NUM THEN

1582: IF l_PRICE_LIST_LINE_rec.print_on_invoice_flag = FND_API.G_MISS_CHAR THEN
1583: l_PRICE_LIST_LINE_rec.print_on_invoice_flag := NULL;
1584: END IF;
1585:
1586: IF l_PRICE_LIST_LINE_rec.program_application_id = FND_API.G_MISS_NUM THEN
1587: l_PRICE_LIST_LINE_rec.program_application_id := NULL;
1588: END IF;
1589:
1590: IF l_PRICE_LIST_LINE_rec.program_id = FND_API.G_MISS_NUM THEN

Line 1590: IF l_PRICE_LIST_LINE_rec.program_id = FND_API.G_MISS_NUM THEN

1586: IF l_PRICE_LIST_LINE_rec.program_application_id = FND_API.G_MISS_NUM THEN
1587: l_PRICE_LIST_LINE_rec.program_application_id := NULL;
1588: END IF;
1589:
1590: IF l_PRICE_LIST_LINE_rec.program_id = FND_API.G_MISS_NUM THEN
1591: l_PRICE_LIST_LINE_rec.program_id := NULL;
1592: END IF;
1593:
1594: IF l_PRICE_LIST_LINE_rec.program_update_date = FND_API.G_MISS_DATE THEN

Line 1594: IF l_PRICE_LIST_LINE_rec.program_update_date = FND_API.G_MISS_DATE THEN

1590: IF l_PRICE_LIST_LINE_rec.program_id = FND_API.G_MISS_NUM THEN
1591: l_PRICE_LIST_LINE_rec.program_id := NULL;
1592: END IF;
1593:
1594: IF l_PRICE_LIST_LINE_rec.program_update_date = FND_API.G_MISS_DATE THEN
1595: l_PRICE_LIST_LINE_rec.program_update_date := NULL;
1596: END IF;
1597:
1598: IF l_PRICE_LIST_LINE_rec.rebate_trxn_type_code = FND_API.G_MISS_CHAR THEN

Line 1598: IF l_PRICE_LIST_LINE_rec.rebate_trxn_type_code = FND_API.G_MISS_CHAR THEN

1594: IF l_PRICE_LIST_LINE_rec.program_update_date = FND_API.G_MISS_DATE THEN
1595: l_PRICE_LIST_LINE_rec.program_update_date := NULL;
1596: END IF;
1597:
1598: IF l_PRICE_LIST_LINE_rec.rebate_trxn_type_code = FND_API.G_MISS_CHAR THEN
1599: l_PRICE_LIST_LINE_rec.rebate_trxn_type_code := NULL;
1600: END IF;
1601:
1602: -- block pricing

Line 1603: IF l_PRICE_LIST_LINE_rec.recurring_value = FND_API.G_MISS_NUM THEN

1599: l_PRICE_LIST_LINE_rec.rebate_trxn_type_code := NULL;
1600: END IF;
1601:
1602: -- block pricing
1603: IF l_PRICE_LIST_LINE_rec.recurring_value = FND_API.G_MISS_NUM THEN
1604: l_PRICE_LIST_LINE_rec.recurring_value := NULL;
1605: END IF;
1606:
1607: IF l_PRICE_LIST_LINE_rec.related_item_id = FND_API.G_MISS_NUM THEN

Line 1607: IF l_PRICE_LIST_LINE_rec.related_item_id = FND_API.G_MISS_NUM THEN

1603: IF l_PRICE_LIST_LINE_rec.recurring_value = FND_API.G_MISS_NUM THEN
1604: l_PRICE_LIST_LINE_rec.recurring_value := NULL;
1605: END IF;
1606:
1607: IF l_PRICE_LIST_LINE_rec.related_item_id = FND_API.G_MISS_NUM THEN
1608: l_PRICE_LIST_LINE_rec.related_item_id := NULL;
1609: END IF;
1610:
1611: IF l_PRICE_LIST_LINE_rec.relationship_type_id = FND_API.G_MISS_NUM THEN

Line 1611: IF l_PRICE_LIST_LINE_rec.relationship_type_id = FND_API.G_MISS_NUM THEN

1607: IF l_PRICE_LIST_LINE_rec.related_item_id = FND_API.G_MISS_NUM THEN
1608: l_PRICE_LIST_LINE_rec.related_item_id := NULL;
1609: END IF;
1610:
1611: IF l_PRICE_LIST_LINE_rec.relationship_type_id = FND_API.G_MISS_NUM THEN
1612: l_PRICE_LIST_LINE_rec.relationship_type_id := NULL;
1613: END IF;
1614:
1615: IF l_PRICE_LIST_LINE_rec.reprice_flag = FND_API.G_MISS_CHAR THEN

Line 1615: IF l_PRICE_LIST_LINE_rec.reprice_flag = FND_API.G_MISS_CHAR THEN

1611: IF l_PRICE_LIST_LINE_rec.relationship_type_id = FND_API.G_MISS_NUM THEN
1612: l_PRICE_LIST_LINE_rec.relationship_type_id := NULL;
1613: END IF;
1614:
1615: IF l_PRICE_LIST_LINE_rec.reprice_flag = FND_API.G_MISS_CHAR THEN
1616: l_PRICE_LIST_LINE_rec.reprice_flag := NULL;
1617: END IF;
1618:
1619: IF l_PRICE_LIST_LINE_rec.request_id = FND_API.G_MISS_NUM THEN

Line 1619: IF l_PRICE_LIST_LINE_rec.request_id = FND_API.G_MISS_NUM THEN

1615: IF l_PRICE_LIST_LINE_rec.reprice_flag = FND_API.G_MISS_CHAR THEN
1616: l_PRICE_LIST_LINE_rec.reprice_flag := NULL;
1617: END IF;
1618:
1619: IF l_PRICE_LIST_LINE_rec.request_id = FND_API.G_MISS_NUM THEN
1620: l_PRICE_LIST_LINE_rec.request_id := NULL;
1621: END IF;
1622:
1623: IF l_PRICE_LIST_LINE_rec.revision = FND_API.G_MISS_CHAR THEN

Line 1623: IF l_PRICE_LIST_LINE_rec.revision = FND_API.G_MISS_CHAR THEN

1619: IF l_PRICE_LIST_LINE_rec.request_id = FND_API.G_MISS_NUM THEN
1620: l_PRICE_LIST_LINE_rec.request_id := NULL;
1621: END IF;
1622:
1623: IF l_PRICE_LIST_LINE_rec.revision = FND_API.G_MISS_CHAR THEN
1624: l_PRICE_LIST_LINE_rec.revision := NULL;
1625: END IF;
1626:
1627: IF l_PRICE_LIST_LINE_rec.revision_date = FND_API.G_MISS_DATE THEN

Line 1627: IF l_PRICE_LIST_LINE_rec.revision_date = FND_API.G_MISS_DATE THEN

1623: IF l_PRICE_LIST_LINE_rec.revision = FND_API.G_MISS_CHAR THEN
1624: l_PRICE_LIST_LINE_rec.revision := NULL;
1625: END IF;
1626:
1627: IF l_PRICE_LIST_LINE_rec.revision_date = FND_API.G_MISS_DATE THEN
1628: l_PRICE_LIST_LINE_rec.revision_date := NULL;
1629: END IF;
1630:
1631: IF l_PRICE_LIST_LINE_rec.revision_reason_code = FND_API.G_MISS_CHAR THEN

Line 1631: IF l_PRICE_LIST_LINE_rec.revision_reason_code = FND_API.G_MISS_CHAR THEN

1627: IF l_PRICE_LIST_LINE_rec.revision_date = FND_API.G_MISS_DATE THEN
1628: l_PRICE_LIST_LINE_rec.revision_date := NULL;
1629: END IF;
1630:
1631: IF l_PRICE_LIST_LINE_rec.revision_reason_code = FND_API.G_MISS_CHAR THEN
1632: l_PRICE_LIST_LINE_rec.revision_reason_code := NULL;
1633: END IF;
1634:
1635: IF l_PRICE_LIST_LINE_rec.start_date_active = FND_API.G_MISS_DATE THEN

Line 1635: IF l_PRICE_LIST_LINE_rec.start_date_active = FND_API.G_MISS_DATE THEN

1631: IF l_PRICE_LIST_LINE_rec.revision_reason_code = FND_API.G_MISS_CHAR THEN
1632: l_PRICE_LIST_LINE_rec.revision_reason_code := NULL;
1633: END IF;
1634:
1635: IF l_PRICE_LIST_LINE_rec.start_date_active = FND_API.G_MISS_DATE THEN
1636: l_PRICE_LIST_LINE_rec.start_date_active := NULL;
1637: END IF;
1638:
1639: IF l_PRICE_LIST_LINE_rec.substitution_attribute = FND_API.G_MISS_CHAR THEN

Line 1639: IF l_PRICE_LIST_LINE_rec.substitution_attribute = FND_API.G_MISS_CHAR THEN

1635: IF l_PRICE_LIST_LINE_rec.start_date_active = FND_API.G_MISS_DATE THEN
1636: l_PRICE_LIST_LINE_rec.start_date_active := NULL;
1637: END IF;
1638:
1639: IF l_PRICE_LIST_LINE_rec.substitution_attribute = FND_API.G_MISS_CHAR THEN
1640: l_PRICE_LIST_LINE_rec.substitution_attribute := NULL;
1641: END IF;
1642:
1643: IF l_PRICE_LIST_LINE_rec.substitution_context = FND_API.G_MISS_CHAR THEN

Line 1643: IF l_PRICE_LIST_LINE_rec.substitution_context = FND_API.G_MISS_CHAR THEN

1639: IF l_PRICE_LIST_LINE_rec.substitution_attribute = FND_API.G_MISS_CHAR THEN
1640: l_PRICE_LIST_LINE_rec.substitution_attribute := NULL;
1641: END IF;
1642:
1643: IF l_PRICE_LIST_LINE_rec.substitution_context = FND_API.G_MISS_CHAR THEN
1644: l_PRICE_LIST_LINE_rec.substitution_context := NULL;
1645: END IF;
1646:
1647: IF l_PRICE_LIST_LINE_rec.substitution_value = FND_API.G_MISS_CHAR THEN

Line 1647: IF l_PRICE_LIST_LINE_rec.substitution_value = FND_API.G_MISS_CHAR THEN

1643: IF l_PRICE_LIST_LINE_rec.substitution_context = FND_API.G_MISS_CHAR THEN
1644: l_PRICE_LIST_LINE_rec.substitution_context := NULL;
1645: END IF;
1646:
1647: IF l_PRICE_LIST_LINE_rec.substitution_value = FND_API.G_MISS_CHAR THEN
1648: l_PRICE_LIST_LINE_rec.substitution_value := NULL;
1649: END IF;
1650:
1651: IF l_PRICE_LIST_LINE_rec.qualification_ind = FND_API.G_MISS_NUM THEN

Line 1651: IF l_PRICE_LIST_LINE_rec.qualification_ind = FND_API.G_MISS_NUM THEN

1647: IF l_PRICE_LIST_LINE_rec.substitution_value = FND_API.G_MISS_CHAR THEN
1648: l_PRICE_LIST_LINE_rec.substitution_value := NULL;
1649: END IF;
1650:
1651: IF l_PRICE_LIST_LINE_rec.qualification_ind = FND_API.G_MISS_NUM THEN
1652: l_PRICE_LIST_LINE_rec.qualification_ind := NULL;
1653: END IF;
1654:
1655: IF l_PRICE_LIST_LINE_rec.break_uom_code = FND_API.G_MISS_CHAR THEN

Line 1655: IF l_PRICE_LIST_LINE_rec.break_uom_code = FND_API.G_MISS_CHAR THEN

1651: IF l_PRICE_LIST_LINE_rec.qualification_ind = FND_API.G_MISS_NUM THEN
1652: l_PRICE_LIST_LINE_rec.qualification_ind := NULL;
1653: END IF;
1654:
1655: IF l_PRICE_LIST_LINE_rec.break_uom_code = FND_API.G_MISS_CHAR THEN
1656: l_PRICE_LIST_LINE_rec.break_uom_code := NULL;
1657: END IF;
1658:
1659: IF l_PRICE_LIST_LINE_rec.break_uom_context = FND_API.G_MISS_CHAR THEN

Line 1659: IF l_PRICE_LIST_LINE_rec.break_uom_context = FND_API.G_MISS_CHAR THEN

1655: IF l_PRICE_LIST_LINE_rec.break_uom_code = FND_API.G_MISS_CHAR THEN
1656: l_PRICE_LIST_LINE_rec.break_uom_code := NULL;
1657: END IF;
1658:
1659: IF l_PRICE_LIST_LINE_rec.break_uom_context = FND_API.G_MISS_CHAR THEN
1660: l_PRICE_LIST_LINE_rec.break_uom_context := NULL;
1661: END IF;
1662:
1663: IF l_PRICE_LIST_LINE_rec.break_uom_attribute = FND_API.G_MISS_CHAR THEN

Line 1663: IF l_PRICE_LIST_LINE_rec.break_uom_attribute = FND_API.G_MISS_CHAR THEN

1659: IF l_PRICE_LIST_LINE_rec.break_uom_context = FND_API.G_MISS_CHAR THEN
1660: l_PRICE_LIST_LINE_rec.break_uom_context := NULL;
1661: END IF;
1662:
1663: IF l_PRICE_LIST_LINE_rec.break_uom_attribute = FND_API.G_MISS_CHAR THEN
1664: l_PRICE_LIST_LINE_rec.break_uom_attribute := NULL;
1665: END IF;
1666:
1667: IF l_PRICE_LIST_LINE_rec.continuous_price_break_flag = FND_API.G_MISS_CHAR THEN

Line 1667: IF l_PRICE_LIST_LINE_rec.continuous_price_break_flag = FND_API.G_MISS_CHAR THEN

1663: IF l_PRICE_LIST_LINE_rec.break_uom_attribute = FND_API.G_MISS_CHAR THEN
1664: l_PRICE_LIST_LINE_rec.break_uom_attribute := NULL;
1665: END IF;
1666:
1667: IF l_PRICE_LIST_LINE_rec.continuous_price_break_flag = FND_API.G_MISS_CHAR THEN
1668: l_PRICE_LIST_LINE_rec.continuous_price_break_flag := NULL;
1669: END IF;
1670:
1671: RETURN l_PRICE_LIST_LINE_rec;

Line 1835: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1831: , 'Update_Row'
1832: );
1833: END IF;
1834:
1835: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1836:
1837: END Update_Row;
1838:
1839: -- Procedure Insert_Row

Line 2074: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2070: , 'Insert_Row'
2071: );
2072: END IF;
2073:
2074: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2075:
2076: END Insert_Row;
2077:
2078: -- Procedure delete_Row

Line 2143: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2139: , 'Delete_Row'
2140: );
2141: END IF;
2142:
2143: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2144:
2145: END Delete_Row;
2146:
2147: -- Function Query_Row

Line 2167: FND_API.G_MISS_NUM

2163: --
2164:
2165: FUNCTION Query_Rows
2166: ( p_list_line_id IN NUMBER :=
2167: FND_API.G_MISS_NUM
2168: , p_list_header_id IN NUMBER :=
2169: FND_API.G_MISS_NUM
2170: ) RETURN QP_Price_List_PUB.Price_List_Line_Tbl_Type
2171: IS

Line 2169: FND_API.G_MISS_NUM

2165: FUNCTION Query_Rows
2166: ( p_list_line_id IN NUMBER :=
2167: FND_API.G_MISS_NUM
2168: , p_list_header_id IN NUMBER :=
2169: FND_API.G_MISS_NUM
2170: ) RETURN QP_Price_List_PUB.Price_List_Line_Tbl_Type
2171: IS
2172: l_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
2173: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;

Line 2337: p_list_line_id <> FND_API.G_MISS_NUM)

2333:
2334: IF
2335: (p_list_line_id IS NOT NULL
2336: AND
2337: p_list_line_id <> FND_API.G_MISS_NUM)
2338: AND
2339: (p_list_header_id IS NOT NULL
2340: AND
2341: p_list_header_id <> FND_API.G_MISS_NUM)

Line 2341: p_list_header_id <> FND_API.G_MISS_NUM)

2337: p_list_line_id <> FND_API.G_MISS_NUM)
2338: AND
2339: (p_list_header_id IS NOT NULL
2340: AND
2341: p_list_header_id <> FND_API.G_MISS_NUM)
2342: THEN
2343: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2344: THEN
2345: oe_msg_pub.Add_Exc_Msg

Line 2352: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2348: , 'Keys are mutually exclusive: list_line_id = '|| p_list_line_id || ', list_header_id = '|| p_list_header_id
2349: );
2350: END IF;
2351:
2352: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2353:
2354: END IF;
2355:
2356:

Line 2358: IF (p_list_line_id IS NOT NULL) AND (p_list_line_id <> FND_API.G_MISS_NUM) THEN --Added for performance bug2422019

2354: END IF;
2355:
2356:
2357: -- Loop over fetched records
2358: IF (p_list_line_id IS NOT NULL) AND (p_list_line_id <> FND_API.G_MISS_NUM) THEN --Added for performance bug2422019
2359: FOR l_implicit_rec IN l_PRICE_LIST_LINE_csr LOOP
2360:
2361: l_PRICE_LIST_LINE_rec.accrual_qty := l_implicit_rec.ACCRUAL_QTY;
2362: l_PRICE_LIST_LINE_rec.accrual_uom_code := l_implicit_rec.ACCRUAL_UOM_CODE;

Line 2462: ELSIF (p_list_header_id IS NOT NULL) AND (p_list_header_id <> FND_API.G_MISS_NUM) THEN

2458: END LOOP;
2459:
2460: /* Added for performance bug2422019 */
2461:
2462: ELSIF (p_list_header_id IS NOT NULL) AND (p_list_header_id <> FND_API.G_MISS_NUM) THEN
2463: FOR l_implicit_rec IN l_PRICE_LIST_LINE_hdr_csr LOOP
2464:
2465: l_PRICE_LIST_LINE_rec.accrual_qty := l_implicit_rec.ACCRUAL_QTY;
2466: l_PRICE_LIST_LINE_rec.accrual_uom_code := l_implicit_rec.ACCRUAL_UOM_CODE;

Line 2571: p_list_line_id <> FND_API.G_MISS_NUM)

2567:
2568: IF
2569: (p_list_line_id IS NOT NULL
2570: AND
2571: p_list_line_id <> FND_API.G_MISS_NUM)
2572: AND
2573: (l_PRICE_LIST_LINE_tbl.COUNT = 0)
2574: THEN
2575: RAISE NO_DATA_FOUND;

Line 2585: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2581: RETURN l_PRICE_LIST_LINE_tbl;
2582:
2583: EXCEPTION
2584:
2585: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2586:
2587: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2588:
2589: WHEN OTHERS THEN

Line 2587: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2583: EXCEPTION
2584:
2585: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2586:
2587: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2588:
2589: WHEN OTHERS THEN
2590:
2591: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)

Line 2599: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2595: , 'Query_Rows'
2596: );
2597: END IF;
2598:
2599: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2600:
2601: END Query_Rows;
2602:
2603: -- Procedure lock_Row

Line 2903: x_return_status := FND_API.G_RET_STS_SUCCESS;

2899: x_PRICE_LIST_LINE_rec := l_PRICE_LIST_LINE_rec;
2900:
2901: -- Set return status
2902:
2903: x_return_status := FND_API.G_RET_STS_SUCCESS;
2904: x_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_SUCCESS;
2905:
2906: ELSE
2907:

Line 2904: x_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_SUCCESS;

2900:
2901: -- Set return status
2902:
2903: x_return_status := FND_API.G_RET_STS_SUCCESS;
2904: x_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_SUCCESS;
2905:
2906: ELSE
2907:
2908: -- Row has changed by another user.

Line 2910: x_return_status := FND_API.G_RET_STS_ERROR;

2906: ELSE
2907:
2908: -- Row has changed by another user.
2909:
2910: x_return_status := FND_API.G_RET_STS_ERROR;
2911: x_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
2912:
2913: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
2914: THEN

Line 2911: x_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;

2907:
2908: -- Row has changed by another user.
2909:
2910: x_return_status := FND_API.G_RET_STS_ERROR;
2911: x_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
2912:
2913: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
2914: THEN
2915:

Line 2927: x_return_status := FND_API.G_RET_STS_ERROR;

2923: EXCEPTION
2924:
2925: WHEN NO_DATA_FOUND THEN
2926:
2927: x_return_status := FND_API.G_RET_STS_ERROR;
2928: x_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
2929:
2930: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
2931: THEN

Line 2928: x_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;

2924:
2925: WHEN NO_DATA_FOUND THEN
2926:
2927: x_return_status := FND_API.G_RET_STS_ERROR;
2928: x_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
2929:
2930: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
2931: THEN
2932:

Line 2939: x_return_status := FND_API.G_RET_STS_ERROR;

2935:
2936: END IF;
2937: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
2938:
2939: x_return_status := FND_API.G_RET_STS_ERROR;
2940: x_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
2941:
2942: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
2943: THEN

Line 2940: x_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;

2936: END IF;
2937: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
2938:
2939: x_return_status := FND_API.G_RET_STS_ERROR;
2940: x_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
2941:
2942: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
2943: THEN
2944:

Line 2951: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2947:
2948: END IF;
2949: WHEN OTHERS THEN
2950:
2951: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2952: x_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2953:
2954: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2955: THEN

Line 2952: x_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2948: END IF;
2949: WHEN OTHERS THEN
2950:
2951: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2952: x_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2953:
2954: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2955: THEN
2956: oe_msg_pub.Add_Exc_Msg

Line 2977: p_PRICE_LIST_LINE_rec.accrual_uom_code <> FND_API.G_MISS_CHAR AND

2973: BEGIN
2974:
2975: /*
2976: IF p_PRICE_LIST_LINE_rec.accrual_uom_code IS NOT NULL AND
2977: p_PRICE_LIST_LINE_rec.accrual_uom_code <> FND_API.G_MISS_CHAR AND
2978: NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.accrual_uom_code,
2979: p_old_PRICE_LIST_LINE_rec.accrual_uom_code)
2980: THEN
2981: l_PRICE_LIST_LINE_val_rec.accrual_uom := QP_Id_To_Value.Accrual_Uom

Line 2989: p_PRICE_LIST_LINE_rec.automatic_flag <> FND_API.G_MISS_CHAR AND

2985:
2986: */
2987:
2988: IF p_PRICE_LIST_LINE_rec.automatic_flag IS NOT NULL AND
2989: p_PRICE_LIST_LINE_rec.automatic_flag <> FND_API.G_MISS_CHAR AND
2990: NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.automatic_flag,
2991: p_old_PRICE_LIST_LINE_rec.automatic_flag)
2992: THEN
2993: l_PRICE_LIST_LINE_val_rec.automatic := QP_Id_To_Value.Automatic

Line 2999: p_PRICE_LIST_LINE_rec.base_uom_code <> FND_API.G_MISS_CHAR AND

2995: );
2996: END IF;
2997:
2998: IF p_PRICE_LIST_LINE_rec.base_uom_code IS NOT NULL AND
2999: p_PRICE_LIST_LINE_rec.base_uom_code <> FND_API.G_MISS_CHAR AND
3000: NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.base_uom_code,
3001: p_old_PRICE_LIST_LINE_rec.base_uom_code)
3002: THEN
3003: l_PRICE_LIST_LINE_val_rec.base_uom := QP_Id_To_Value.Base_Uom

Line 3009: p_PRICE_LIST_LINE_rec.generate_using_formula_id <> FND_API.G_MISS_NUM AND

3005: );
3006: END IF;
3007:
3008: IF p_PRICE_LIST_LINE_rec.generate_using_formula_id IS NOT NULL AND
3009: p_PRICE_LIST_LINE_rec.generate_using_formula_id <> FND_API.G_MISS_NUM AND
3010: NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.generate_using_formula_id,
3011: p_old_PRICE_LIST_LINE_rec.generate_using_formula_id)
3012: THEN
3013: l_PRICE_LIST_LINE_val_rec.generate_using_formula := QP_Id_To_Value.Generate_Using_Formula

Line 3020: p_PRICE_LIST_LINE_rec.inventory_item_id <> FND_API.G_MISS_NUM AND

3016: END IF;
3017:
3018:
3019: IF p_PRICE_LIST_LINE_rec.inventory_item_id IS NOT NULL AND
3020: p_PRICE_LIST_LINE_rec.inventory_item_id <> FND_API.G_MISS_NUM AND
3021: NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.inventory_item_id,
3022: p_old_PRICE_LIST_LINE_rec.inventory_item_id)
3023: THEN
3024: l_PRICE_LIST_LINE_val_rec.inventory_item := QP_Id_To_Value.Inventory_Item

Line 3030: p_PRICE_LIST_LINE_rec.list_header_id <> FND_API.G_MISS_NUM AND

3026: );
3027: END IF;
3028:
3029: IF p_PRICE_LIST_LINE_rec.list_header_id IS NOT NULL AND
3030: p_PRICE_LIST_LINE_rec.list_header_id <> FND_API.G_MISS_NUM AND
3031: NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.list_header_id,
3032: p_old_PRICE_LIST_LINE_rec.list_header_id)
3033: THEN
3034: l_PRICE_LIST_LINE_val_rec.list_header := QP_Id_To_Value.List_Header

Line 3040: p_PRICE_LIST_LINE_rec.list_line_id <> FND_API.G_MISS_NUM AND

3036: );
3037: END IF;
3038:
3039: IF p_PRICE_LIST_LINE_rec.list_line_id IS NOT NULL AND
3040: p_PRICE_LIST_LINE_rec.list_line_id <> FND_API.G_MISS_NUM AND
3041: NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.list_line_id,
3042: p_old_PRICE_LIST_LINE_rec.list_line_id)
3043: THEN
3044: l_PRICE_LIST_LINE_val_rec.list_line := QP_Id_To_Value.List_Line

Line 3050: p_PRICE_LIST_LINE_rec.list_line_type_code <> FND_API.G_MISS_CHAR AND

3046: );
3047: END IF;
3048:
3049: IF p_PRICE_LIST_LINE_rec.list_line_type_code IS NOT NULL AND
3050: p_PRICE_LIST_LINE_rec.list_line_type_code <> FND_API.G_MISS_CHAR AND
3051: NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.list_line_type_code,
3052: p_old_PRICE_LIST_LINE_rec.list_line_type_code)
3053: THEN
3054: l_PRICE_LIST_LINE_val_rec.list_line_type := QP_Id_To_Value.List_Line_Type

Line 3060: p_PRICE_LIST_LINE_rec.modifier_level_code <> FND_API.G_MISS_CHAR AND

3056: );
3057: END IF;
3058:
3059: IF p_PRICE_LIST_LINE_rec.modifier_level_code IS NOT NULL AND
3060: p_PRICE_LIST_LINE_rec.modifier_level_code <> FND_API.G_MISS_CHAR AND
3061: NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.modifier_level_code,
3062: p_old_PRICE_LIST_LINE_rec.modifier_level_code)
3063: THEN
3064: l_PRICE_LIST_LINE_val_rec.modifier_level := QP_Id_To_Value.Modifier_Level

Line 3070: p_PRICE_LIST_LINE_rec.organization_id <> FND_API.G_MISS_NUM AND

3066: );
3067: END IF;
3068:
3069: IF p_PRICE_LIST_LINE_rec.organization_id IS NOT NULL AND
3070: p_PRICE_LIST_LINE_rec.organization_id <> FND_API.G_MISS_NUM AND
3071: NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.organization_id,
3072: p_old_PRICE_LIST_LINE_rec.organization_id)
3073: THEN
3074: l_PRICE_LIST_LINE_val_rec.organization := QP_Id_To_Value.Organization

Line 3080: p_PRICE_LIST_LINE_rec.override_flag <> FND_API.G_MISS_CHAR AND

3076: );
3077: END IF;
3078:
3079: IF p_PRICE_LIST_LINE_rec.override_flag IS NOT NULL AND
3080: p_PRICE_LIST_LINE_rec.override_flag <> FND_API.G_MISS_CHAR AND
3081: NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.override_flag,
3082: p_old_PRICE_LIST_LINE_rec.override_flag)
3083: THEN
3084: l_PRICE_LIST_LINE_val_rec.override := QP_Id_To_Value.Override

Line 3090: p_PRICE_LIST_LINE_rec.price_break_type_code <> FND_API.G_MISS_CHAR AND

3086: );
3087: END IF;
3088:
3089: IF p_PRICE_LIST_LINE_rec.price_break_type_code IS NOT NULL AND
3090: p_PRICE_LIST_LINE_rec.price_break_type_code <> FND_API.G_MISS_CHAR AND
3091: NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.price_break_type_code,
3092: p_old_PRICE_LIST_LINE_rec.price_break_type_code)
3093: THEN
3094: l_PRICE_LIST_LINE_val_rec.price_break_type := QP_Id_To_Value.Price_Break_Type

Line 3100: p_PRICE_LIST_LINE_rec.price_by_formula_id <> FND_API.G_MISS_NUM AND

3096: );
3097: END IF;
3098:
3099: IF p_PRICE_LIST_LINE_rec.price_by_formula_id IS NOT NULL AND
3100: p_PRICE_LIST_LINE_rec.price_by_formula_id <> FND_API.G_MISS_NUM AND
3101: NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.price_by_formula_id,
3102: p_old_PRICE_LIST_LINE_rec.price_by_formula_id)
3103: THEN
3104: l_PRICE_LIST_LINE_val_rec.price_by_formula := QP_Id_To_Value.Price_By_Formula

Line 3110: p_PRICE_LIST_LINE_rec.primary_uom_flag <> FND_API.G_MISS_CHAR AND

3106: );
3107: END IF;
3108:
3109: IF p_PRICE_LIST_LINE_rec.primary_uom_flag IS NOT NULL AND
3110: p_PRICE_LIST_LINE_rec.primary_uom_flag <> FND_API.G_MISS_CHAR AND
3111: NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.primary_uom_flag,
3112: p_old_PRICE_LIST_LINE_rec.primary_uom_flag)
3113: THEN
3114: l_PRICE_LIST_LINE_val_rec.primary_uom := QP_Id_To_Value.Primary_Uom

Line 3120: p_PRICE_LIST_LINE_rec.print_on_invoice_flag <> FND_API.G_MISS_CHAR AND

3116: );
3117: END IF;
3118:
3119: IF p_PRICE_LIST_LINE_rec.print_on_invoice_flag IS NOT NULL AND
3120: p_PRICE_LIST_LINE_rec.print_on_invoice_flag <> FND_API.G_MISS_CHAR AND
3121: NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.print_on_invoice_flag,
3122: p_old_PRICE_LIST_LINE_rec.print_on_invoice_flag)
3123: THEN
3124: l_PRICE_LIST_LINE_val_rec.print_on_invoice := QP_Id_To_Value.Print_On_Invoice

Line 3130: p_PRICE_LIST_LINE_rec.rebate_trxn_type_code <> FND_API.G_MISS_CHAR AND

3126: );
3127: END IF;
3128:
3129: IF p_PRICE_LIST_LINE_rec.rebate_trxn_type_code IS NOT NULL AND
3130: p_PRICE_LIST_LINE_rec.rebate_trxn_type_code <> FND_API.G_MISS_CHAR AND
3131: NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.rebate_trxn_type_code,
3132: p_old_PRICE_LIST_LINE_rec.rebate_trxn_type_code)
3133: THEN
3134: l_PRICE_LIST_LINE_val_rec.rebate_transaction_type := QP_Id_To_Value.Rebate_Transaction_Type

Line 3140: p_PRICE_LIST_LINE_rec.related_item_id <> FND_API.G_MISS_NUM AND

3136: );
3137: END IF;
3138:
3139: IF p_PRICE_LIST_LINE_rec.related_item_id IS NOT NULL AND
3140: p_PRICE_LIST_LINE_rec.related_item_id <> FND_API.G_MISS_NUM AND
3141: NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.related_item_id,
3142: p_old_PRICE_LIST_LINE_rec.related_item_id)
3143: THEN
3144: l_PRICE_LIST_LINE_val_rec.related_item := QP_Id_To_Value.Related_Item

Line 3150: p_PRICE_LIST_LINE_rec.relationship_type_id <> FND_API.G_MISS_NUM AND

3146: );
3147: END IF;
3148:
3149: IF p_PRICE_LIST_LINE_rec.relationship_type_id IS NOT NULL AND
3150: p_PRICE_LIST_LINE_rec.relationship_type_id <> FND_API.G_MISS_NUM AND
3151: NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.relationship_type_id,
3152: p_old_PRICE_LIST_LINE_rec.relationship_type_id)
3153: THEN
3154: l_PRICE_LIST_LINE_val_rec.relationship_type := QP_Id_To_Value.Relationship_Type

Line 3160: p_PRICE_LIST_LINE_rec.reprice_flag <> FND_API.G_MISS_CHAR AND

3156: );
3157: END IF;
3158:
3159: IF p_PRICE_LIST_LINE_rec.reprice_flag IS NOT NULL AND
3160: p_PRICE_LIST_LINE_rec.reprice_flag <> FND_API.G_MISS_CHAR AND
3161: NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.reprice_flag,
3162: p_old_PRICE_LIST_LINE_rec.reprice_flag)
3163: THEN
3164: l_PRICE_LIST_LINE_val_rec.reprice := QP_Id_To_Value.Reprice

Line 3170: p_PRICE_LIST_LINE_rec.revision_reason_code <> FND_API.G_MISS_CHAR AND

3166: );
3167: END IF;
3168:
3169: IF p_PRICE_LIST_LINE_rec.revision_reason_code IS NOT NULL AND
3170: p_PRICE_LIST_LINE_rec.revision_reason_code <> FND_API.G_MISS_CHAR AND
3171: NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.revision_reason_code,
3172: p_old_PRICE_LIST_LINE_rec.revision_reason_code)
3173: THEN
3174: l_PRICE_LIST_LINE_val_rec.revision_reason := QP_Id_To_Value.Revision_Reason

Line 3195: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_SUCCESS;

3191: BEGIN
3192:
3193: -- initialize return_status.
3194:
3195: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_SUCCESS;
3196:
3197: -- initialize l_PRICE_LIST_LINE_rec.
3198:
3199: l_PRICE_LIST_LINE_rec := p_PRICE_LIST_LINE_rec;

Line 3201: IF p_PRICE_LIST_LINE_val_rec.accrual_uom <> FND_API.G_MISS_CHAR

3197: -- initialize l_PRICE_LIST_LINE_rec.
3198:
3199: l_PRICE_LIST_LINE_rec := p_PRICE_LIST_LINE_rec;
3200:
3201: IF p_PRICE_LIST_LINE_val_rec.accrual_uom <> FND_API.G_MISS_CHAR
3202: THEN
3203:
3204: IF p_PRICE_LIST_LINE_rec.accrual_uom_code <> FND_API.G_MISS_CHAR THEN
3205:

Line 3204: IF p_PRICE_LIST_LINE_rec.accrual_uom_code <> FND_API.G_MISS_CHAR THEN

3200:
3201: IF p_PRICE_LIST_LINE_val_rec.accrual_uom <> FND_API.G_MISS_CHAR
3202: THEN
3203:
3204: IF p_PRICE_LIST_LINE_rec.accrual_uom_code <> FND_API.G_MISS_CHAR THEN
3205:
3206: l_PRICE_LIST_LINE_rec.accrual_uom_code := p_PRICE_LIST_LINE_rec.accrual_uom_code;
3207:
3208: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

Line 3227: IF l_PRICE_LIST_LINE_rec.accrual_uom_code = FND_API.G_MISS_CHAR THEN

3223: );
3224:
3225: */
3226:
3227: IF l_PRICE_LIST_LINE_rec.accrual_uom_code = FND_API.G_MISS_CHAR THEN
3228: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
3229: END IF;
3230:
3231: END IF;

Line 3228: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;

3224:
3225: */
3226:
3227: IF l_PRICE_LIST_LINE_rec.accrual_uom_code = FND_API.G_MISS_CHAR THEN
3228: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
3229: END IF;
3230:
3231: END IF;
3232:

Line 3235: IF p_PRICE_LIST_LINE_val_rec.automatic <> FND_API.G_MISS_CHAR

3231: END IF;
3232:
3233: END IF;
3234:
3235: IF p_PRICE_LIST_LINE_val_rec.automatic <> FND_API.G_MISS_CHAR
3236: THEN
3237:
3238: IF p_PRICE_LIST_LINE_rec.automatic_flag <> FND_API.G_MISS_CHAR THEN
3239:

Line 3238: IF p_PRICE_LIST_LINE_rec.automatic_flag <> FND_API.G_MISS_CHAR THEN

3234:
3235: IF p_PRICE_LIST_LINE_val_rec.automatic <> FND_API.G_MISS_CHAR
3236: THEN
3237:
3238: IF p_PRICE_LIST_LINE_rec.automatic_flag <> FND_API.G_MISS_CHAR THEN
3239:
3240: l_PRICE_LIST_LINE_rec.automatic_flag := p_PRICE_LIST_LINE_rec.automatic_flag;
3241:
3242: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

Line 3257: IF l_PRICE_LIST_LINE_rec.automatic_flag = FND_API.G_MISS_CHAR THEN

3253: l_PRICE_LIST_LINE_rec.automatic_flag := QP_Value_To_Id.automatic
3254: ( p_automatic => p_PRICE_LIST_LINE_val_rec.automatic
3255: );
3256:
3257: IF l_PRICE_LIST_LINE_rec.automatic_flag = FND_API.G_MISS_CHAR THEN
3258: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
3259: END IF;
3260:
3261: END IF;

Line 3258: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;

3254: ( p_automatic => p_PRICE_LIST_LINE_val_rec.automatic
3255: );
3256:
3257: IF l_PRICE_LIST_LINE_rec.automatic_flag = FND_API.G_MISS_CHAR THEN
3258: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
3259: END IF;
3260:
3261: END IF;
3262:

Line 3265: IF p_PRICE_LIST_LINE_val_rec.base_uom <> FND_API.G_MISS_CHAR

3261: END IF;
3262:
3263: END IF;
3264:
3265: IF p_PRICE_LIST_LINE_val_rec.base_uom <> FND_API.G_MISS_CHAR
3266: THEN
3267:
3268: IF p_PRICE_LIST_LINE_rec.base_uom_code <> FND_API.G_MISS_CHAR THEN
3269:

Line 3268: IF p_PRICE_LIST_LINE_rec.base_uom_code <> FND_API.G_MISS_CHAR THEN

3264:
3265: IF p_PRICE_LIST_LINE_val_rec.base_uom <> FND_API.G_MISS_CHAR
3266: THEN
3267:
3268: IF p_PRICE_LIST_LINE_rec.base_uom_code <> FND_API.G_MISS_CHAR THEN
3269:
3270: l_PRICE_LIST_LINE_rec.base_uom_code := p_PRICE_LIST_LINE_rec.base_uom_code;
3271:
3272: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

Line 3287: IF l_PRICE_LIST_LINE_rec.base_uom_code = FND_API.G_MISS_CHAR THEN

3283: l_PRICE_LIST_LINE_rec.base_uom_code := QP_Value_To_Id.base_uom
3284: ( p_base_uom => p_PRICE_LIST_LINE_val_rec.base_uom
3285: );
3286:
3287: IF l_PRICE_LIST_LINE_rec.base_uom_code = FND_API.G_MISS_CHAR THEN
3288: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
3289: END IF;
3290:
3291: END IF;

Line 3288: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;

3284: ( p_base_uom => p_PRICE_LIST_LINE_val_rec.base_uom
3285: );
3286:
3287: IF l_PRICE_LIST_LINE_rec.base_uom_code = FND_API.G_MISS_CHAR THEN
3288: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
3289: END IF;
3290:
3291: END IF;
3292:

Line 3295: IF p_PRICE_LIST_LINE_val_rec.generate_using_formula <> FND_API.G_MISS_CHAR

3291: END IF;
3292:
3293: END IF;
3294:
3295: IF p_PRICE_LIST_LINE_val_rec.generate_using_formula <> FND_API.G_MISS_CHAR
3296: THEN
3297:
3298: IF p_PRICE_LIST_LINE_rec.generate_using_formula_id <> FND_API.G_MISS_NUM THEN
3299:

Line 3298: IF p_PRICE_LIST_LINE_rec.generate_using_formula_id <> FND_API.G_MISS_NUM THEN

3294:
3295: IF p_PRICE_LIST_LINE_val_rec.generate_using_formula <> FND_API.G_MISS_CHAR
3296: THEN
3297:
3298: IF p_PRICE_LIST_LINE_rec.generate_using_formula_id <> FND_API.G_MISS_NUM THEN
3299:
3300: l_PRICE_LIST_LINE_rec.generate_using_formula_id := p_PRICE_LIST_LINE_rec.generate_using_formula_id;
3301:
3302: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

Line 3317: IF l_PRICE_LIST_LINE_rec.generate_using_formula_id = FND_API.G_MISS_NUM THEN

3313: l_PRICE_LIST_LINE_rec.generate_using_formula_id := QP_Value_To_Id.generate_using_formula
3314: ( p_generate_using_formula => p_PRICE_LIST_LINE_val_rec.generate_using_formula
3315: );
3316:
3317: IF l_PRICE_LIST_LINE_rec.generate_using_formula_id = FND_API.G_MISS_NUM THEN
3318: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
3319: END IF;
3320:
3321: END IF;

Line 3318: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;

3314: ( p_generate_using_formula => p_PRICE_LIST_LINE_val_rec.generate_using_formula
3315: );
3316:
3317: IF l_PRICE_LIST_LINE_rec.generate_using_formula_id = FND_API.G_MISS_NUM THEN
3318: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
3319: END IF;
3320:
3321: END IF;
3322:

Line 3325: IF p_PRICE_LIST_LINE_val_rec.inventory_item <> FND_API.G_MISS_CHAR

3321: END IF;
3322:
3323: END IF;
3324:
3325: IF p_PRICE_LIST_LINE_val_rec.inventory_item <> FND_API.G_MISS_CHAR
3326: THEN
3327:
3328: IF p_PRICE_LIST_LINE_rec.inventory_item_id <> FND_API.G_MISS_NUM THEN
3329:

Line 3328: IF p_PRICE_LIST_LINE_rec.inventory_item_id <> FND_API.G_MISS_NUM THEN

3324:
3325: IF p_PRICE_LIST_LINE_val_rec.inventory_item <> FND_API.G_MISS_CHAR
3326: THEN
3327:
3328: IF p_PRICE_LIST_LINE_rec.inventory_item_id <> FND_API.G_MISS_NUM THEN
3329:
3330: l_PRICE_LIST_LINE_rec.inventory_item_id := p_PRICE_LIST_LINE_rec.inventory_item_id;
3331:
3332: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

Line 3347: IF l_PRICE_LIST_LINE_rec.inventory_item_id = FND_API.G_MISS_NUM THEN

3343: l_PRICE_LIST_LINE_rec.inventory_item_id := QP_Value_To_Id.inventory_item
3344: ( p_inventory_item => p_PRICE_LIST_LINE_val_rec.inventory_item
3345: );
3346:
3347: IF l_PRICE_LIST_LINE_rec.inventory_item_id = FND_API.G_MISS_NUM THEN
3348: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
3349: END IF;
3350:
3351: END IF;

Line 3348: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;

3344: ( p_inventory_item => p_PRICE_LIST_LINE_val_rec.inventory_item
3345: );
3346:
3347: IF l_PRICE_LIST_LINE_rec.inventory_item_id = FND_API.G_MISS_NUM THEN
3348: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
3349: END IF;
3350:
3351: END IF;
3352:

Line 3355: IF p_PRICE_LIST_LINE_val_rec.list_header <> FND_API.G_MISS_CHAR

3351: END IF;
3352:
3353: END IF;
3354:
3355: IF p_PRICE_LIST_LINE_val_rec.list_header <> FND_API.G_MISS_CHAR
3356: THEN
3357:
3358: IF p_PRICE_LIST_LINE_rec.list_header_id <> FND_API.G_MISS_NUM THEN
3359:

Line 3358: IF p_PRICE_LIST_LINE_rec.list_header_id <> FND_API.G_MISS_NUM THEN

3354:
3355: IF p_PRICE_LIST_LINE_val_rec.list_header <> FND_API.G_MISS_CHAR
3356: THEN
3357:
3358: IF p_PRICE_LIST_LINE_rec.list_header_id <> FND_API.G_MISS_NUM THEN
3359:
3360: l_PRICE_LIST_LINE_rec.list_header_id := p_PRICE_LIST_LINE_rec.list_header_id;
3361:
3362: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

Line 3377: IF l_PRICE_LIST_LINE_rec.list_header_id = FND_API.G_MISS_NUM THEN

3373: l_PRICE_LIST_LINE_rec.list_header_id := QP_Value_To_Id.list_header
3374: ( p_list_header => p_PRICE_LIST_LINE_val_rec.list_header
3375: );
3376:
3377: IF l_PRICE_LIST_LINE_rec.list_header_id = FND_API.G_MISS_NUM THEN
3378: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
3379: END IF;
3380:
3381: END IF;

Line 3378: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;

3374: ( p_list_header => p_PRICE_LIST_LINE_val_rec.list_header
3375: );
3376:
3377: IF l_PRICE_LIST_LINE_rec.list_header_id = FND_API.G_MISS_NUM THEN
3378: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
3379: END IF;
3380:
3381: END IF;
3382:

Line 3385: IF p_PRICE_LIST_LINE_val_rec.list_line <> FND_API.G_MISS_CHAR

3381: END IF;
3382:
3383: END IF;
3384:
3385: IF p_PRICE_LIST_LINE_val_rec.list_line <> FND_API.G_MISS_CHAR
3386: THEN
3387:
3388: IF p_PRICE_LIST_LINE_rec.list_line_id <> FND_API.G_MISS_NUM THEN
3389:

Line 3388: IF p_PRICE_LIST_LINE_rec.list_line_id <> FND_API.G_MISS_NUM THEN

3384:
3385: IF p_PRICE_LIST_LINE_val_rec.list_line <> FND_API.G_MISS_CHAR
3386: THEN
3387:
3388: IF p_PRICE_LIST_LINE_rec.list_line_id <> FND_API.G_MISS_NUM THEN
3389:
3390: l_PRICE_LIST_LINE_rec.list_line_id := p_PRICE_LIST_LINE_rec.list_line_id;
3391:
3392: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

Line 3407: IF l_PRICE_LIST_LINE_rec.list_line_id = FND_API.G_MISS_NUM THEN

3403: l_PRICE_LIST_LINE_rec.list_line_id := QP_Value_To_Id.list_line
3404: ( p_list_line => p_PRICE_LIST_LINE_val_rec.list_line
3405: );
3406:
3407: IF l_PRICE_LIST_LINE_rec.list_line_id = FND_API.G_MISS_NUM THEN
3408: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
3409: END IF;
3410:
3411: END IF;

Line 3408: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;

3404: ( p_list_line => p_PRICE_LIST_LINE_val_rec.list_line
3405: );
3406:
3407: IF l_PRICE_LIST_LINE_rec.list_line_id = FND_API.G_MISS_NUM THEN
3408: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
3409: END IF;
3410:
3411: END IF;
3412:

Line 3415: IF p_PRICE_LIST_LINE_val_rec.list_line_type <> FND_API.G_MISS_CHAR

3411: END IF;
3412:
3413: END IF;
3414:
3415: IF p_PRICE_LIST_LINE_val_rec.list_line_type <> FND_API.G_MISS_CHAR
3416: THEN
3417:
3418: IF p_PRICE_LIST_LINE_rec.list_line_type_code <> FND_API.G_MISS_CHAR THEN
3419:

Line 3418: IF p_PRICE_LIST_LINE_rec.list_line_type_code <> FND_API.G_MISS_CHAR THEN

3414:
3415: IF p_PRICE_LIST_LINE_val_rec.list_line_type <> FND_API.G_MISS_CHAR
3416: THEN
3417:
3418: IF p_PRICE_LIST_LINE_rec.list_line_type_code <> FND_API.G_MISS_CHAR THEN
3419:
3420: l_PRICE_LIST_LINE_rec.list_line_type_code := p_PRICE_LIST_LINE_rec.list_line_type_code;
3421:
3422: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

Line 3437: IF l_PRICE_LIST_LINE_rec.list_line_type_code = FND_API.G_MISS_CHAR THEN

3433: l_PRICE_LIST_LINE_rec.list_line_type_code := QP_Value_To_Id.list_line_type
3434: ( p_list_line_type => p_PRICE_LIST_LINE_val_rec.list_line_type
3435: );
3436:
3437: IF l_PRICE_LIST_LINE_rec.list_line_type_code = FND_API.G_MISS_CHAR THEN
3438: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
3439: END IF;
3440:
3441: END IF;

Line 3438: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;

3434: ( p_list_line_type => p_PRICE_LIST_LINE_val_rec.list_line_type
3435: );
3436:
3437: IF l_PRICE_LIST_LINE_rec.list_line_type_code = FND_API.G_MISS_CHAR THEN
3438: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
3439: END IF;
3440:
3441: END IF;
3442:

Line 3445: IF p_PRICE_LIST_LINE_val_rec.modifier_level <> FND_API.G_MISS_CHAR

3441: END IF;
3442:
3443: END IF;
3444:
3445: IF p_PRICE_LIST_LINE_val_rec.modifier_level <> FND_API.G_MISS_CHAR
3446: THEN
3447:
3448: IF p_PRICE_LIST_LINE_rec.modifier_level_code <> FND_API.G_MISS_CHAR THEN
3449:

Line 3448: IF p_PRICE_LIST_LINE_rec.modifier_level_code <> FND_API.G_MISS_CHAR THEN

3444:
3445: IF p_PRICE_LIST_LINE_val_rec.modifier_level <> FND_API.G_MISS_CHAR
3446: THEN
3447:
3448: IF p_PRICE_LIST_LINE_rec.modifier_level_code <> FND_API.G_MISS_CHAR THEN
3449:
3450: l_PRICE_LIST_LINE_rec.modifier_level_code := p_PRICE_LIST_LINE_rec.modifier_level_code;
3451:
3452: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

Line 3467: IF l_PRICE_LIST_LINE_rec.modifier_level_code = FND_API.G_MISS_CHAR THEN

3463: l_PRICE_LIST_LINE_rec.modifier_level_code := QP_Value_To_Id.modifier_level
3464: ( p_modifier_level => p_PRICE_LIST_LINE_val_rec.modifier_level
3465: );
3466:
3467: IF l_PRICE_LIST_LINE_rec.modifier_level_code = FND_API.G_MISS_CHAR THEN
3468: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
3469: END IF;
3470:
3471: END IF;

Line 3468: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;

3464: ( p_modifier_level => p_PRICE_LIST_LINE_val_rec.modifier_level
3465: );
3466:
3467: IF l_PRICE_LIST_LINE_rec.modifier_level_code = FND_API.G_MISS_CHAR THEN
3468: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
3469: END IF;
3470:
3471: END IF;
3472:

Line 3475: IF p_PRICE_LIST_LINE_val_rec.organization <> FND_API.G_MISS_CHAR

3471: END IF;
3472:
3473: END IF;
3474:
3475: IF p_PRICE_LIST_LINE_val_rec.organization <> FND_API.G_MISS_CHAR
3476: THEN
3477:
3478: IF p_PRICE_LIST_LINE_rec.organization_id <> FND_API.G_MISS_NUM THEN
3479:

Line 3478: IF p_PRICE_LIST_LINE_rec.organization_id <> FND_API.G_MISS_NUM THEN

3474:
3475: IF p_PRICE_LIST_LINE_val_rec.organization <> FND_API.G_MISS_CHAR
3476: THEN
3477:
3478: IF p_PRICE_LIST_LINE_rec.organization_id <> FND_API.G_MISS_NUM THEN
3479:
3480: l_PRICE_LIST_LINE_rec.organization_id := p_PRICE_LIST_LINE_rec.organization_id;
3481:
3482: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

Line 3497: IF l_PRICE_LIST_LINE_rec.organization_id = FND_API.G_MISS_NUM THEN

3493: l_PRICE_LIST_LINE_rec.organization_id := QP_Value_To_Id.organization
3494: ( p_organization => p_PRICE_LIST_LINE_val_rec.organization
3495: );
3496:
3497: IF l_PRICE_LIST_LINE_rec.organization_id = FND_API.G_MISS_NUM THEN
3498: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
3499: END IF;
3500:
3501: END IF;

Line 3498: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;

3494: ( p_organization => p_PRICE_LIST_LINE_val_rec.organization
3495: );
3496:
3497: IF l_PRICE_LIST_LINE_rec.organization_id = FND_API.G_MISS_NUM THEN
3498: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
3499: END IF;
3500:
3501: END IF;
3502:

Line 3505: IF p_PRICE_LIST_LINE_val_rec.override <> FND_API.G_MISS_CHAR

3501: END IF;
3502:
3503: END IF;
3504:
3505: IF p_PRICE_LIST_LINE_val_rec.override <> FND_API.G_MISS_CHAR
3506: THEN
3507:
3508: IF p_PRICE_LIST_LINE_rec.override_flag <> FND_API.G_MISS_CHAR THEN
3509:

Line 3508: IF p_PRICE_LIST_LINE_rec.override_flag <> FND_API.G_MISS_CHAR THEN

3504:
3505: IF p_PRICE_LIST_LINE_val_rec.override <> FND_API.G_MISS_CHAR
3506: THEN
3507:
3508: IF p_PRICE_LIST_LINE_rec.override_flag <> FND_API.G_MISS_CHAR THEN
3509:
3510: l_PRICE_LIST_LINE_rec.override_flag := p_PRICE_LIST_LINE_rec.override_flag;
3511:
3512: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

Line 3527: IF l_PRICE_LIST_LINE_rec.override_flag = FND_API.G_MISS_CHAR THEN

3523: l_PRICE_LIST_LINE_rec.override_flag := QP_Value_To_Id.override
3524: ( p_override => p_PRICE_LIST_LINE_val_rec.override
3525: );
3526:
3527: IF l_PRICE_LIST_LINE_rec.override_flag = FND_API.G_MISS_CHAR THEN
3528: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
3529: END IF;
3530:
3531: END IF;

Line 3528: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;

3524: ( p_override => p_PRICE_LIST_LINE_val_rec.override
3525: );
3526:
3527: IF l_PRICE_LIST_LINE_rec.override_flag = FND_API.G_MISS_CHAR THEN
3528: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
3529: END IF;
3530:
3531: END IF;
3532:

Line 3535: IF p_PRICE_LIST_LINE_val_rec.price_break_type <> FND_API.G_MISS_CHAR

3531: END IF;
3532:
3533: END IF;
3534:
3535: IF p_PRICE_LIST_LINE_val_rec.price_break_type <> FND_API.G_MISS_CHAR
3536: THEN
3537:
3538: IF p_PRICE_LIST_LINE_rec.price_break_type_code <> FND_API.G_MISS_CHAR THEN
3539:

Line 3538: IF p_PRICE_LIST_LINE_rec.price_break_type_code <> FND_API.G_MISS_CHAR THEN

3534:
3535: IF p_PRICE_LIST_LINE_val_rec.price_break_type <> FND_API.G_MISS_CHAR
3536: THEN
3537:
3538: IF p_PRICE_LIST_LINE_rec.price_break_type_code <> FND_API.G_MISS_CHAR THEN
3539:
3540: l_PRICE_LIST_LINE_rec.price_break_type_code := p_PRICE_LIST_LINE_rec.price_break_type_code;
3541:
3542: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

Line 3557: IF l_PRICE_LIST_LINE_rec.price_break_type_code = FND_API.G_MISS_CHAR THEN

3553: l_PRICE_LIST_LINE_rec.price_break_type_code := QP_Value_To_Id.price_break_type
3554: ( p_price_break_type => p_PRICE_LIST_LINE_val_rec.price_break_type
3555: );
3556:
3557: IF l_PRICE_LIST_LINE_rec.price_break_type_code = FND_API.G_MISS_CHAR THEN
3558: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
3559: END IF;
3560:
3561: END IF;

Line 3558: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;

3554: ( p_price_break_type => p_PRICE_LIST_LINE_val_rec.price_break_type
3555: );
3556:
3557: IF l_PRICE_LIST_LINE_rec.price_break_type_code = FND_API.G_MISS_CHAR THEN
3558: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
3559: END IF;
3560:
3561: END IF;
3562:

Line 3565: IF p_PRICE_LIST_LINE_val_rec.price_by_formula <> FND_API.G_MISS_CHAR

3561: END IF;
3562:
3563: END IF;
3564:
3565: IF p_PRICE_LIST_LINE_val_rec.price_by_formula <> FND_API.G_MISS_CHAR
3566: THEN
3567:
3568: IF p_PRICE_LIST_LINE_rec.price_by_formula_id <> FND_API.G_MISS_NUM THEN
3569:

Line 3568: IF p_PRICE_LIST_LINE_rec.price_by_formula_id <> FND_API.G_MISS_NUM THEN

3564:
3565: IF p_PRICE_LIST_LINE_val_rec.price_by_formula <> FND_API.G_MISS_CHAR
3566: THEN
3567:
3568: IF p_PRICE_LIST_LINE_rec.price_by_formula_id <> FND_API.G_MISS_NUM THEN
3569:
3570: l_PRICE_LIST_LINE_rec.price_by_formula_id := p_PRICE_LIST_LINE_rec.price_by_formula_id;
3571:
3572: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

Line 3587: IF l_PRICE_LIST_LINE_rec.price_by_formula_id = FND_API.G_MISS_NUM THEN

3583: l_PRICE_LIST_LINE_rec.price_by_formula_id := QP_Value_To_Id.price_by_formula
3584: ( p_price_by_formula => p_PRICE_LIST_LINE_val_rec.price_by_formula
3585: );
3586:
3587: IF l_PRICE_LIST_LINE_rec.price_by_formula_id = FND_API.G_MISS_NUM THEN
3588: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
3589: END IF;
3590:
3591: END IF;

Line 3588: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;

3584: ( p_price_by_formula => p_PRICE_LIST_LINE_val_rec.price_by_formula
3585: );
3586:
3587: IF l_PRICE_LIST_LINE_rec.price_by_formula_id = FND_API.G_MISS_NUM THEN
3588: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
3589: END IF;
3590:
3591: END IF;
3592:

Line 3595: IF p_PRICE_LIST_LINE_val_rec.primary_uom <> FND_API.G_MISS_CHAR

3591: END IF;
3592:
3593: END IF;
3594:
3595: IF p_PRICE_LIST_LINE_val_rec.primary_uom <> FND_API.G_MISS_CHAR
3596: THEN
3597:
3598: IF p_PRICE_LIST_LINE_rec.primary_uom_flag <> FND_API.G_MISS_CHAR THEN
3599:

Line 3598: IF p_PRICE_LIST_LINE_rec.primary_uom_flag <> FND_API.G_MISS_CHAR THEN

3594:
3595: IF p_PRICE_LIST_LINE_val_rec.primary_uom <> FND_API.G_MISS_CHAR
3596: THEN
3597:
3598: IF p_PRICE_LIST_LINE_rec.primary_uom_flag <> FND_API.G_MISS_CHAR THEN
3599:
3600: l_PRICE_LIST_LINE_rec.primary_uom_flag := p_PRICE_LIST_LINE_rec.primary_uom_flag;
3601:
3602: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

Line 3617: IF l_PRICE_LIST_LINE_rec.primary_uom_flag = FND_API.G_MISS_CHAR THEN

3613: l_PRICE_LIST_LINE_rec.primary_uom_flag := QP_Value_To_Id.primary_uom
3614: ( p_primary_uom => p_PRICE_LIST_LINE_val_rec.primary_uom
3615: );
3616:
3617: IF l_PRICE_LIST_LINE_rec.primary_uom_flag = FND_API.G_MISS_CHAR THEN
3618: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
3619: END IF;
3620:
3621: END IF;

Line 3618: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;

3614: ( p_primary_uom => p_PRICE_LIST_LINE_val_rec.primary_uom
3615: );
3616:
3617: IF l_PRICE_LIST_LINE_rec.primary_uom_flag = FND_API.G_MISS_CHAR THEN
3618: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
3619: END IF;
3620:
3621: END IF;
3622:

Line 3625: IF p_PRICE_LIST_LINE_val_rec.print_on_invoice <> FND_API.G_MISS_CHAR

3621: END IF;
3622:
3623: END IF;
3624:
3625: IF p_PRICE_LIST_LINE_val_rec.print_on_invoice <> FND_API.G_MISS_CHAR
3626: THEN
3627:
3628: IF p_PRICE_LIST_LINE_rec.print_on_invoice_flag <> FND_API.G_MISS_CHAR THEN
3629:

Line 3628: IF p_PRICE_LIST_LINE_rec.print_on_invoice_flag <> FND_API.G_MISS_CHAR THEN

3624:
3625: IF p_PRICE_LIST_LINE_val_rec.print_on_invoice <> FND_API.G_MISS_CHAR
3626: THEN
3627:
3628: IF p_PRICE_LIST_LINE_rec.print_on_invoice_flag <> FND_API.G_MISS_CHAR THEN
3629:
3630: l_PRICE_LIST_LINE_rec.print_on_invoice_flag := p_PRICE_LIST_LINE_rec.print_on_invoice_flag;
3631:
3632: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

Line 3647: IF l_PRICE_LIST_LINE_rec.print_on_invoice_flag = FND_API.G_MISS_CHAR THEN

3643: l_PRICE_LIST_LINE_rec.print_on_invoice_flag := QP_Value_To_Id.print_on_invoice
3644: ( p_print_on_invoice => p_PRICE_LIST_LINE_val_rec.print_on_invoice
3645: );
3646:
3647: IF l_PRICE_LIST_LINE_rec.print_on_invoice_flag = FND_API.G_MISS_CHAR THEN
3648: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
3649: END IF;
3650:
3651: END IF;

Line 3648: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;

3644: ( p_print_on_invoice => p_PRICE_LIST_LINE_val_rec.print_on_invoice
3645: );
3646:
3647: IF l_PRICE_LIST_LINE_rec.print_on_invoice_flag = FND_API.G_MISS_CHAR THEN
3648: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
3649: END IF;
3650:
3651: END IF;
3652:

Line 3655: IF p_PRICE_LIST_LINE_val_rec.rebate_transaction_type <> FND_API.G_MISS_CHAR

3651: END IF;
3652:
3653: END IF;
3654:
3655: IF p_PRICE_LIST_LINE_val_rec.rebate_transaction_type <> FND_API.G_MISS_CHAR
3656: THEN
3657:
3658: IF p_PRICE_LIST_LINE_rec.rebate_trxn_type_code <> FND_API.G_MISS_CHAR THEN
3659:

Line 3658: IF p_PRICE_LIST_LINE_rec.rebate_trxn_type_code <> FND_API.G_MISS_CHAR THEN

3654:
3655: IF p_PRICE_LIST_LINE_val_rec.rebate_transaction_type <> FND_API.G_MISS_CHAR
3656: THEN
3657:
3658: IF p_PRICE_LIST_LINE_rec.rebate_trxn_type_code <> FND_API.G_MISS_CHAR THEN
3659:
3660: l_PRICE_LIST_LINE_rec.rebate_trxn_type_code := p_PRICE_LIST_LINE_rec.rebate_trxn_type_code;
3661:
3662: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

Line 3677: IF l_PRICE_LIST_LINE_rec.rebate_trxn_type_code = FND_API.G_MISS_CHAR THEN

3673: l_PRICE_LIST_LINE_rec.rebate_trxn_type_code := QP_Value_To_Id.rebate_transaction_type
3674: ( p_rebate_transaction_type => p_PRICE_LIST_LINE_val_rec.rebate_transaction_type
3675: );
3676:
3677: IF l_PRICE_LIST_LINE_rec.rebate_trxn_type_code = FND_API.G_MISS_CHAR THEN
3678: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
3679: END IF;
3680:
3681: END IF;

Line 3678: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;

3674: ( p_rebate_transaction_type => p_PRICE_LIST_LINE_val_rec.rebate_transaction_type
3675: );
3676:
3677: IF l_PRICE_LIST_LINE_rec.rebate_trxn_type_code = FND_API.G_MISS_CHAR THEN
3678: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
3679: END IF;
3680:
3681: END IF;
3682:

Line 3685: IF p_PRICE_LIST_LINE_val_rec.related_item <> FND_API.G_MISS_CHAR

3681: END IF;
3682:
3683: END IF;
3684:
3685: IF p_PRICE_LIST_LINE_val_rec.related_item <> FND_API.G_MISS_CHAR
3686: THEN
3687:
3688: IF p_PRICE_LIST_LINE_rec.related_item_id <> FND_API.G_MISS_NUM THEN
3689:

Line 3688: IF p_PRICE_LIST_LINE_rec.related_item_id <> FND_API.G_MISS_NUM THEN

3684:
3685: IF p_PRICE_LIST_LINE_val_rec.related_item <> FND_API.G_MISS_CHAR
3686: THEN
3687:
3688: IF p_PRICE_LIST_LINE_rec.related_item_id <> FND_API.G_MISS_NUM THEN
3689:
3690: l_PRICE_LIST_LINE_rec.related_item_id := p_PRICE_LIST_LINE_rec.related_item_id;
3691:
3692: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

Line 3707: IF l_PRICE_LIST_LINE_rec.related_item_id = FND_API.G_MISS_NUM THEN

3703: l_PRICE_LIST_LINE_rec.related_item_id := QP_Value_To_Id.related_item
3704: ( p_related_item => p_PRICE_LIST_LINE_val_rec.related_item
3705: );
3706:
3707: IF l_PRICE_LIST_LINE_rec.related_item_id = FND_API.G_MISS_NUM THEN
3708: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
3709: END IF;
3710:
3711: END IF;

Line 3708: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;

3704: ( p_related_item => p_PRICE_LIST_LINE_val_rec.related_item
3705: );
3706:
3707: IF l_PRICE_LIST_LINE_rec.related_item_id = FND_API.G_MISS_NUM THEN
3708: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
3709: END IF;
3710:
3711: END IF;
3712:

Line 3715: IF p_PRICE_LIST_LINE_val_rec.relationship_type <> FND_API.G_MISS_CHAR

3711: END IF;
3712:
3713: END IF;
3714:
3715: IF p_PRICE_LIST_LINE_val_rec.relationship_type <> FND_API.G_MISS_CHAR
3716: THEN
3717:
3718: IF p_PRICE_LIST_LINE_rec.relationship_type_id <> FND_API.G_MISS_NUM THEN
3719:

Line 3718: IF p_PRICE_LIST_LINE_rec.relationship_type_id <> FND_API.G_MISS_NUM THEN

3714:
3715: IF p_PRICE_LIST_LINE_val_rec.relationship_type <> FND_API.G_MISS_CHAR
3716: THEN
3717:
3718: IF p_PRICE_LIST_LINE_rec.relationship_type_id <> FND_API.G_MISS_NUM THEN
3719:
3720: l_PRICE_LIST_LINE_rec.relationship_type_id := p_PRICE_LIST_LINE_rec.relationship_type_id;
3721:
3722: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

Line 3737: IF l_PRICE_LIST_LINE_rec.relationship_type_id = FND_API.G_MISS_NUM THEN

3733: l_PRICE_LIST_LINE_rec.relationship_type_id := QP_Value_To_Id.relationship_type
3734: ( p_relationship_type => p_PRICE_LIST_LINE_val_rec.relationship_type
3735: );
3736:
3737: IF l_PRICE_LIST_LINE_rec.relationship_type_id = FND_API.G_MISS_NUM THEN
3738: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
3739: END IF;
3740:
3741: END IF;

Line 3738: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;

3734: ( p_relationship_type => p_PRICE_LIST_LINE_val_rec.relationship_type
3735: );
3736:
3737: IF l_PRICE_LIST_LINE_rec.relationship_type_id = FND_API.G_MISS_NUM THEN
3738: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
3739: END IF;
3740:
3741: END IF;
3742:

Line 3745: IF p_PRICE_LIST_LINE_val_rec.reprice <> FND_API.G_MISS_CHAR

3741: END IF;
3742:
3743: END IF;
3744:
3745: IF p_PRICE_LIST_LINE_val_rec.reprice <> FND_API.G_MISS_CHAR
3746: THEN
3747:
3748: IF p_PRICE_LIST_LINE_rec.reprice_flag <> FND_API.G_MISS_CHAR THEN
3749:

Line 3748: IF p_PRICE_LIST_LINE_rec.reprice_flag <> FND_API.G_MISS_CHAR THEN

3744:
3745: IF p_PRICE_LIST_LINE_val_rec.reprice <> FND_API.G_MISS_CHAR
3746: THEN
3747:
3748: IF p_PRICE_LIST_LINE_rec.reprice_flag <> FND_API.G_MISS_CHAR THEN
3749:
3750: l_PRICE_LIST_LINE_rec.reprice_flag := p_PRICE_LIST_LINE_rec.reprice_flag;
3751:
3752: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

Line 3767: IF l_PRICE_LIST_LINE_rec.reprice_flag = FND_API.G_MISS_CHAR THEN

3763: l_PRICE_LIST_LINE_rec.reprice_flag := QP_Value_To_Id.reprice
3764: ( p_reprice => p_PRICE_LIST_LINE_val_rec.reprice
3765: );
3766:
3767: IF l_PRICE_LIST_LINE_rec.reprice_flag = FND_API.G_MISS_CHAR THEN
3768: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
3769: END IF;
3770:
3771: END IF;

Line 3768: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;

3764: ( p_reprice => p_PRICE_LIST_LINE_val_rec.reprice
3765: );
3766:
3767: IF l_PRICE_LIST_LINE_rec.reprice_flag = FND_API.G_MISS_CHAR THEN
3768: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
3769: END IF;
3770:
3771: END IF;
3772:

Line 3775: IF p_PRICE_LIST_LINE_val_rec.revision_reason <> FND_API.G_MISS_CHAR

3771: END IF;
3772:
3773: END IF;
3774:
3775: IF p_PRICE_LIST_LINE_val_rec.revision_reason <> FND_API.G_MISS_CHAR
3776: THEN
3777:
3778: IF p_PRICE_LIST_LINE_rec.revision_reason_code <> FND_API.G_MISS_CHAR THEN
3779:

Line 3778: IF p_PRICE_LIST_LINE_rec.revision_reason_code <> FND_API.G_MISS_CHAR THEN

3774:
3775: IF p_PRICE_LIST_LINE_val_rec.revision_reason <> FND_API.G_MISS_CHAR
3776: THEN
3777:
3778: IF p_PRICE_LIST_LINE_rec.revision_reason_code <> FND_API.G_MISS_CHAR THEN
3779:
3780: l_PRICE_LIST_LINE_rec.revision_reason_code := p_PRICE_LIST_LINE_rec.revision_reason_code;
3781:
3782: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

Line 3797: IF l_PRICE_LIST_LINE_rec.revision_reason_code = FND_API.G_MISS_CHAR THEN

3793: l_PRICE_LIST_LINE_rec.revision_reason_code := QP_Value_To_Id.revision_reason
3794: ( p_revision_reason => p_PRICE_LIST_LINE_val_rec.revision_reason
3795: );
3796:
3797: IF l_PRICE_LIST_LINE_rec.revision_reason_code = FND_API.G_MISS_CHAR THEN
3798: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
3799: END IF;
3800:
3801: END IF;

Line 3798: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;

3794: ( p_revision_reason => p_PRICE_LIST_LINE_val_rec.revision_reason
3795: );
3796:
3797: IF l_PRICE_LIST_LINE_rec.revision_reason_code = FND_API.G_MISS_CHAR THEN
3798: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
3799: END IF;
3800:
3801: END IF;
3802: