146: IS
147: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
148: l_MODIFIERS_val_rec QP_Modifiers_PUB.Modifiers_Val_Rec_Type;
149: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
150: l_control_rec QP_GLOBALS.Control_Rec_Type;
151: l_return_status VARCHAR2(1);
152: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
153: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
154: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
201: l_MODIFIERS_rec.context := NULL;
202:
203: -- Set Operation to Create
204:
205: l_MODIFIERS_rec.operation := QP_GLOBALS.G_OPR_CREATE;
206:
207: -- Populate MODIFIERS table
208:
209: l_MODIFIERS_tbl(1) := l_MODIFIERS_rec;
554: l_old_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
555: l_MODIFIERS_val_rec QP_Modifiers_PUB.Modifiers_Val_Rec_Type;
556: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
557: l_old_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
558: l_control_rec QP_GLOBALS.Control_Rec_Type;
559: l_return_status VARCHAR2(1);
560: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
561: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
562: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
784:
785: -- Set Operation.
786:
787: IF FND_API.To_Boolean(l_MODIFIERS_rec.db_flag) THEN
788: l_MODIFIERS_rec.operation := QP_GLOBALS.G_OPR_UPDATE;
789: ELSE
790: l_MODIFIERS_rec.operation := QP_GLOBALS.G_OPR_CREATE;
791: END IF;
792:
786:
787: IF FND_API.To_Boolean(l_MODIFIERS_rec.db_flag) THEN
788: l_MODIFIERS_rec.operation := QP_GLOBALS.G_OPR_UPDATE;
789: ELSE
790: l_MODIFIERS_rec.operation := QP_GLOBALS.G_OPR_CREATE;
791: END IF;
792:
793: -- Populate MODIFIERS table
794:
940: );
941:
942: -- Return changed attributes.
943:
944: IF NOT QP_GLOBALS.Equal(l_x_MODIFIERS_rec.arithmetic_operator,
945: l_MODIFIERS_rec.arithmetic_operator)
946: THEN
947: x_arithmetic_operator := l_x_MODIFIERS_rec.arithmetic_operator;
948: END IF;
946: THEN
947: x_arithmetic_operator := l_x_MODIFIERS_rec.arithmetic_operator;
948: END IF;
949:
950: IF NOT QP_GLOBALS.Equal(l_x_MODIFIERS_rec.attribute1,
951: l_MODIFIERS_rec.attribute1)
952: THEN
953: x_attribute1 := l_x_MODIFIERS_rec.attribute1;
954: END IF;
952: THEN
953: x_attribute1 := l_x_MODIFIERS_rec.attribute1;
954: END IF;
955:
956: IF NOT QP_GLOBALS.Equal(l_x_MODIFIERS_rec.attribute10,
957: l_MODIFIERS_rec.attribute10)
958: THEN
959: x_attribute10 := l_x_MODIFIERS_rec.attribute10;
960: END IF;
958: THEN
959: x_attribute10 := l_x_MODIFIERS_rec.attribute10;
960: END IF;
961:
962: IF NOT QP_GLOBALS.Equal(l_x_MODIFIERS_rec.attribute11,
963: l_MODIFIERS_rec.attribute11)
964: THEN
965: x_attribute11 := l_x_MODIFIERS_rec.attribute11;
966: END IF;
964: THEN
965: x_attribute11 := l_x_MODIFIERS_rec.attribute11;
966: END IF;
967:
968: IF NOT QP_GLOBALS.Equal(l_x_MODIFIERS_rec.attribute12,
969: l_MODIFIERS_rec.attribute12)
970: THEN
971: x_attribute12 := l_x_MODIFIERS_rec.attribute12;
972: END IF;
970: THEN
971: x_attribute12 := l_x_MODIFIERS_rec.attribute12;
972: END IF;
973:
974: IF NOT QP_GLOBALS.Equal(l_x_MODIFIERS_rec.attribute13,
975: l_MODIFIERS_rec.attribute13)
976: THEN
977: x_attribute13 := l_x_MODIFIERS_rec.attribute13;
978: END IF;
976: THEN
977: x_attribute13 := l_x_MODIFIERS_rec.attribute13;
978: END IF;
979:
980: IF NOT QP_GLOBALS.Equal(l_x_MODIFIERS_rec.attribute14,
981: l_MODIFIERS_rec.attribute14)
982: THEN
983: x_attribute14 := l_x_MODIFIERS_rec.attribute14;
984: END IF;
982: THEN
983: x_attribute14 := l_x_MODIFIERS_rec.attribute14;
984: END IF;
985:
986: IF NOT QP_GLOBALS.Equal(l_x_MODIFIERS_rec.attribute15,
987: l_MODIFIERS_rec.attribute15)
988: THEN
989: x_attribute15 := l_x_MODIFIERS_rec.attribute15;
990: END IF;
988: THEN
989: x_attribute15 := l_x_MODIFIERS_rec.attribute15;
990: END IF;
991:
992: IF NOT QP_GLOBALS.Equal(l_x_MODIFIERS_rec.attribute2,
993: l_MODIFIERS_rec.attribute2)
994: THEN
995: x_attribute2 := l_x_MODIFIERS_rec.attribute2;
996: END IF;
994: THEN
995: x_attribute2 := l_x_MODIFIERS_rec.attribute2;
996: END IF;
997:
998: IF NOT QP_GLOBALS.Equal(l_x_MODIFIERS_rec.attribute3,
999: l_MODIFIERS_rec.attribute3)
1000: THEN
1001: x_attribute3 := l_x_MODIFIERS_rec.attribute3;
1002: END IF;
1000: THEN
1001: x_attribute3 := l_x_MODIFIERS_rec.attribute3;
1002: END IF;
1003:
1004: IF NOT QP_GLOBALS.Equal(l_x_MODIFIERS_rec.attribute4,
1005: l_MODIFIERS_rec.attribute4)
1006: THEN
1007: x_attribute4 := l_x_MODIFIERS_rec.attribute4;
1008: END IF;
1006: THEN
1007: x_attribute4 := l_x_MODIFIERS_rec.attribute4;
1008: END IF;
1009:
1010: IF NOT QP_GLOBALS.Equal(l_x_MODIFIERS_rec.attribute5,
1011: l_MODIFIERS_rec.attribute5)
1012: THEN
1013: x_attribute5 := l_x_MODIFIERS_rec.attribute5;
1014: END IF;
1012: THEN
1013: x_attribute5 := l_x_MODIFIERS_rec.attribute5;
1014: END IF;
1015:
1016: IF NOT QP_GLOBALS.Equal(l_x_MODIFIERS_rec.attribute6,
1017: l_MODIFIERS_rec.attribute6)
1018: THEN
1019: x_attribute6 := l_x_MODIFIERS_rec.attribute6;
1020: END IF;
1018: THEN
1019: x_attribute6 := l_x_MODIFIERS_rec.attribute6;
1020: END IF;
1021:
1022: IF NOT QP_GLOBALS.Equal(l_x_MODIFIERS_rec.attribute7,
1023: l_MODIFIERS_rec.attribute7)
1024: THEN
1025: x_attribute7 := l_x_MODIFIERS_rec.attribute7;
1026: END IF;
1024: THEN
1025: x_attribute7 := l_x_MODIFIERS_rec.attribute7;
1026: END IF;
1027:
1028: IF NOT QP_GLOBALS.Equal(l_x_MODIFIERS_rec.attribute8,
1029: l_MODIFIERS_rec.attribute8)
1030: THEN
1031: x_attribute8 := l_x_MODIFIERS_rec.attribute8;
1032: END IF;
1030: THEN
1031: x_attribute8 := l_x_MODIFIERS_rec.attribute8;
1032: END IF;
1033:
1034: IF NOT QP_GLOBALS.Equal(l_x_MODIFIERS_rec.attribute9,
1035: l_MODIFIERS_rec.attribute9)
1036: THEN
1037: x_attribute9 := l_x_MODIFIERS_rec.attribute9;
1038: END IF;
1036: THEN
1037: x_attribute9 := l_x_MODIFIERS_rec.attribute9;
1038: END IF;
1039:
1040: IF NOT QP_GLOBALS.Equal(l_x_MODIFIERS_rec.automatic_flag,
1041: l_MODIFIERS_rec.automatic_flag)
1042: THEN
1043: x_automatic_flag := l_x_MODIFIERS_rec.automatic_flag;
1044: x_automatic := l_MODIFIERS_val_rec.automatic;
1043: x_automatic_flag := l_x_MODIFIERS_rec.automatic_flag;
1044: x_automatic := l_MODIFIERS_val_rec.automatic;
1045: END IF;
1046:
1047: /* IF NOT QP_GLOBALS.Equal(l_x_MODIFIERS_rec.base_qty,
1048: l_MODIFIERS_rec.base_qty)
1049: THEN
1050: x_base_qty := l_x_MODIFIERS_rec.base_qty;
1051: END IF;
1049: THEN
1050: x_base_qty := l_x_MODIFIERS_rec.base_qty;
1051: END IF;
1052: */
1053: IF NOT QP_GLOBALS.Equal(l_x_MODIFIERS_rec.pricing_phase_id,
1054: l_MODIFIERS_rec.pricing_phase_id)
1055: THEN
1056: x_pricing_phase_id := l_x_MODIFIERS_rec.pricing_phase_id;
1057: END IF;
1055: THEN
1056: x_pricing_phase_id := l_x_MODIFIERS_rec.pricing_phase_id;
1057: END IF;
1058:
1059: /* IF NOT QP_GLOBALS.Equal(l_x_MODIFIERS_rec.base_uom_code,
1060: l_MODIFIERS_rec.base_uom_code)
1061: THEN
1062: x_base_uom_code := l_x_MODIFIERS_rec.base_uom_code;
1063: x_base_uom := l_MODIFIERS_val_rec.base_uom;
1062: x_base_uom_code := l_x_MODIFIERS_rec.base_uom_code;
1063: x_base_uom := l_MODIFIERS_val_rec.base_uom;
1064: END IF;
1065: */
1066: IF NOT QP_GLOBALS.Equal(l_x_MODIFIERS_rec.comments,
1067: l_MODIFIERS_rec.comments)
1068: THEN
1069: x_comments := l_x_MODIFIERS_rec.comments;
1070: END IF;
1068: THEN
1069: x_comments := l_x_MODIFIERS_rec.comments;
1070: END IF;
1071:
1072: IF NOT QP_GLOBALS.Equal(l_x_MODIFIERS_rec.context,
1073: l_MODIFIERS_rec.context)
1074: THEN
1075: x_context := l_x_MODIFIERS_rec.context;
1076: END IF;
1074: THEN
1075: x_context := l_x_MODIFIERS_rec.context;
1076: END IF;
1077:
1078: IF NOT QP_GLOBALS.Equal(l_x_MODIFIERS_rec.effective_period_uom,
1079: l_MODIFIERS_rec.effective_period_uom)
1080: THEN
1081: x_effective_period_uom := l_x_MODIFIERS_rec.effective_period_uom;
1082: END IF;
1080: THEN
1081: x_effective_period_uom := l_x_MODIFIERS_rec.effective_period_uom;
1082: END IF;
1083:
1084: IF NOT QP_GLOBALS.Equal(l_x_MODIFIERS_rec.end_date_active,
1085: l_MODIFIERS_rec.end_date_active)
1086: THEN
1087: x_end_date_active := l_x_MODIFIERS_rec.end_date_active;
1088: END IF;
1086: THEN
1087: x_end_date_active := l_x_MODIFIERS_rec.end_date_active;
1088: END IF;
1089:
1090: IF NOT QP_GLOBALS.Equal(l_x_MODIFIERS_rec.estim_accrual_rate,
1091: l_MODIFIERS_rec.estim_accrual_rate)
1092: THEN
1093: x_estim_accrual_rate := l_x_MODIFIERS_rec.estim_accrual_rate;
1094: END IF;
1092: THEN
1093: x_estim_accrual_rate := l_x_MODIFIERS_rec.estim_accrual_rate;
1094: END IF;
1095:
1096: IF NOT QP_GLOBALS.Equal(l_x_MODIFIERS_rec.generate_using_formula_id,
1097: l_MODIFIERS_rec.generate_using_formula_id)
1098: THEN
1099: x_generate_using_formula_id := l_x_MODIFIERS_rec.generate_using_formula_id;
1100: x_generate_using_formula := l_MODIFIERS_val_rec.generate_using_formula;
1099: x_generate_using_formula_id := l_x_MODIFIERS_rec.generate_using_formula_id;
1100: x_generate_using_formula := l_MODIFIERS_val_rec.generate_using_formula;
1101: END IF;
1102:
1103: /* IF NOT QP_GLOBALS.Equal(l_x_MODIFIERS_rec.gl_class_id,
1104: l_MODIFIERS_rec.gl_class_id)
1105: THEN
1106: x_gl_class_id := l_x_MODIFIERS_rec.gl_class_id;
1107: x_gl_class := l_MODIFIERS_val_rec.gl_class;
1106: x_gl_class_id := l_x_MODIFIERS_rec.gl_class_id;
1107: x_gl_class := l_MODIFIERS_val_rec.gl_class;
1108: END IF;
1109: */
1110: IF NOT QP_GLOBALS.Equal(l_x_MODIFIERS_rec.inventory_item_id,
1111: l_MODIFIERS_rec.inventory_item_id)
1112: THEN
1113: x_inventory_item_id := l_x_MODIFIERS_rec.inventory_item_id;
1114: x_inventory_item := l_MODIFIERS_val_rec.inventory_item;
1113: x_inventory_item_id := l_x_MODIFIERS_rec.inventory_item_id;
1114: x_inventory_item := l_MODIFIERS_val_rec.inventory_item;
1115: END IF;
1116:
1117: IF NOT QP_GLOBALS.Equal(l_x_MODIFIERS_rec.list_header_id,
1118: l_MODIFIERS_rec.list_header_id)
1119: THEN
1120: x_list_header_id := l_x_MODIFIERS_rec.list_header_id;
1121: x_list_header := l_MODIFIERS_val_rec.list_header;
1120: x_list_header_id := l_x_MODIFIERS_rec.list_header_id;
1121: x_list_header := l_MODIFIERS_val_rec.list_header;
1122: END IF;
1123:
1124: IF NOT QP_GLOBALS.Equal(l_x_MODIFIERS_rec.list_line_id,
1125: l_MODIFIERS_rec.list_line_id)
1126: THEN
1127: x_list_line_id := l_x_MODIFIERS_rec.list_line_id;
1128: x_list_line := l_MODIFIERS_val_rec.list_line;
1127: x_list_line_id := l_x_MODIFIERS_rec.list_line_id;
1128: x_list_line := l_MODIFIERS_val_rec.list_line;
1129: END IF;
1130:
1131: IF NOT QP_GLOBALS.Equal(l_x_MODIFIERS_rec.list_line_type_code,
1132: l_MODIFIERS_rec.list_line_type_code)
1133: THEN
1134: x_list_line_type_code := l_x_MODIFIERS_rec.list_line_type_code;
1135: x_list_line_type := l_MODIFIERS_val_rec.list_line_type;
1134: x_list_line_type_code := l_x_MODIFIERS_rec.list_line_type_code;
1135: x_list_line_type := l_MODIFIERS_val_rec.list_line_type;
1136: END IF;
1137:
1138: IF NOT QP_GLOBALS.Equal(l_x_MODIFIERS_rec.list_price,
1139: l_MODIFIERS_rec.list_price)
1140: THEN
1141: x_list_price := l_x_MODIFIERS_rec.list_price;
1142: END IF;
1140: THEN
1141: x_list_price := l_x_MODIFIERS_rec.list_price;
1142: END IF;
1143:
1144: /* IF NOT QP_GLOBALS.Equal(l_x_MODIFIERS_rec.list_price_uom_code,
1145: l_MODIFIERS_rec.list_price_uom_code)
1146: THEN
1147: x_list_price_uom_code := l_x_MODIFIERS_rec.list_price_uom_code;
1148: x_list_price_uom := l_MODIFIERS_val_rec.list_price_uom;
1147: x_list_price_uom_code := l_x_MODIFIERS_rec.list_price_uom_code;
1148: x_list_price_uom := l_MODIFIERS_val_rec.list_price_uom;
1149: END IF;
1150:
1151: IF NOT QP_GLOBALS.Equal(l_x_MODIFIERS_rec.modifier_level_code,
1152: l_MODIFIERS_rec.modifier_level_code)
1153: THEN
1154: x_modifier_level_code := l_x_MODIFIERS_rec.modifier_level_code;
1155: x_modifier_level := l_MODIFIERS_val_rec.modifier_level;
1154: x_modifier_level_code := l_x_MODIFIERS_rec.modifier_level_code;
1155: x_modifier_level := l_MODIFIERS_val_rec.modifier_level;
1156: END IF;
1157:
1158: /* IF NOT QP_GLOBALS.Equal(l_x_MODIFIERS_rec.new_price,
1159: l_MODIFIERS_rec.new_price)
1160: THEN
1161: x_new_price := l_x_MODIFIERS_rec.new_price;
1162: END IF;
1160: THEN
1161: x_new_price := l_x_MODIFIERS_rec.new_price;
1162: END IF;
1163: */
1164: IF NOT QP_GLOBALS.Equal(l_x_MODIFIERS_rec.number_effective_periods,
1165: l_MODIFIERS_rec.number_effective_periods)
1166: THEN
1167: x_number_effective_periods := l_x_MODIFIERS_rec.number_effective_periods;
1168: END IF;
1166: THEN
1167: x_number_effective_periods := l_x_MODIFIERS_rec.number_effective_periods;
1168: END IF;
1169:
1170: IF NOT QP_GLOBALS.Equal(l_x_MODIFIERS_rec.operand,
1171: l_MODIFIERS_rec.operand)
1172: THEN
1173: x_operand := l_x_MODIFIERS_rec.operand;
1174: END IF;
1172: THEN
1173: x_operand := l_x_MODIFIERS_rec.operand;
1174: END IF;
1175:
1176: IF NOT QP_GLOBALS.Equal(l_x_MODIFIERS_rec.organization_id,
1177: l_MODIFIERS_rec.organization_id)
1178: THEN
1179: x_organization_id := l_x_MODIFIERS_rec.organization_id;
1180: x_organization := l_MODIFIERS_val_rec.organization;
1179: x_organization_id := l_x_MODIFIERS_rec.organization_id;
1180: x_organization := l_MODIFIERS_val_rec.organization;
1181: END IF;
1182:
1183: IF NOT QP_GLOBALS.Equal(l_x_MODIFIERS_rec.override_flag,
1184: l_MODIFIERS_rec.override_flag)
1185: THEN
1186: x_override_flag := l_x_MODIFIERS_rec.override_flag;
1187: x_override := l_MODIFIERS_val_rec.override;
1186: x_override_flag := l_x_MODIFIERS_rec.override_flag;
1187: x_override := l_MODIFIERS_val_rec.override;
1188: END IF;
1189:
1190: IF NOT QP_GLOBALS.Equal(l_x_MODIFIERS_rec.percent_price,
1191: l_MODIFIERS_rec.percent_price)
1192: THEN
1193: x_percent_price := l_x_MODIFIERS_rec.percent_price;
1194: END IF;
1192: THEN
1193: x_percent_price := l_x_MODIFIERS_rec.percent_price;
1194: END IF;
1195:
1196: IF NOT QP_GLOBALS.Equal(l_x_MODIFIERS_rec.price_break_type_code,
1197: l_MODIFIERS_rec.price_break_type_code)
1198: THEN
1199: x_price_break_type_code := l_x_MODIFIERS_rec.price_break_type_code;
1200: x_price_break_type := l_MODIFIERS_val_rec.price_break_type;
1199: x_price_break_type_code := l_x_MODIFIERS_rec.price_break_type_code;
1200: x_price_break_type := l_MODIFIERS_val_rec.price_break_type;
1201: END IF;
1202:
1203: IF NOT QP_GLOBALS.Equal(l_x_MODIFIERS_rec.price_by_formula_id,
1204: l_MODIFIERS_rec.price_by_formula_id)
1205: THEN
1206: x_price_by_formula_id := l_x_MODIFIERS_rec.price_by_formula_id;
1207: x_price_by_formula := l_MODIFIERS_val_rec.price_by_formula;
1206: x_price_by_formula_id := l_x_MODIFIERS_rec.price_by_formula_id;
1207: x_price_by_formula := l_MODIFIERS_val_rec.price_by_formula;
1208: END IF;
1209:
1210: IF NOT QP_GLOBALS.Equal(l_x_MODIFIERS_rec.primary_uom_flag,
1211: l_MODIFIERS_rec.primary_uom_flag)
1212: THEN
1213: x_primary_uom_flag := l_x_MODIFIERS_rec.primary_uom_flag;
1214: x_primary_uom := l_MODIFIERS_val_rec.primary_uom;
1213: x_primary_uom_flag := l_x_MODIFIERS_rec.primary_uom_flag;
1214: x_primary_uom := l_MODIFIERS_val_rec.primary_uom;
1215: END IF;
1216:
1217: IF NOT QP_GLOBALS.Equal(l_x_MODIFIERS_rec.print_on_invoice_flag,
1218: l_MODIFIERS_rec.print_on_invoice_flag)
1219: THEN
1220: x_print_on_invoice_flag := l_x_MODIFIERS_rec.print_on_invoice_flag;
1221: x_print_on_invoice := l_MODIFIERS_val_rec.print_on_invoice;
1220: x_print_on_invoice_flag := l_x_MODIFIERS_rec.print_on_invoice_flag;
1221: x_print_on_invoice := l_MODIFIERS_val_rec.print_on_invoice;
1222: END IF;
1223:
1224: /* IF NOT QP_GLOBALS.Equal(l_x_MODIFIERS_rec.rebate_subtype_code,
1225: l_MODIFIERS_rec.rebate_subtype_code)
1226: THEN
1227: x_rebate_subtype_code := l_x_MODIFIERS_rec.rebate_subtype_code;
1228: x_rebate_subtype := l_MODIFIERS_val_rec.rebate_subtype;
1227: x_rebate_subtype_code := l_x_MODIFIERS_rec.rebate_subtype_code;
1228: x_rebate_subtype := l_MODIFIERS_val_rec.rebate_subtype;
1229: END IF;
1230: */
1231: IF NOT QP_GLOBALS.Equal(l_x_MODIFIERS_rec.rebate_trxn_type_code,
1232: l_MODIFIERS_rec.rebate_trxn_type_code)
1233: THEN
1234: x_rebate_trxn_type_code := l_x_MODIFIERS_rec.rebate_trxn_type_code;
1235: x_rebate_transaction_type := l_MODIFIERS_val_rec.rebate_transaction_type;
1234: x_rebate_trxn_type_code := l_x_MODIFIERS_rec.rebate_trxn_type_code;
1235: x_rebate_transaction_type := l_MODIFIERS_val_rec.rebate_transaction_type;
1236: END IF;
1237:
1238: IF NOT QP_GLOBALS.Equal(l_x_MODIFIERS_rec.related_item_id,
1239: l_MODIFIERS_rec.related_item_id)
1240: THEN
1241: x_related_item_id := l_x_MODIFIERS_rec.related_item_id;
1242: x_related_item := l_MODIFIERS_val_rec.related_item;
1241: x_related_item_id := l_x_MODIFIERS_rec.related_item_id;
1242: x_related_item := l_MODIFIERS_val_rec.related_item;
1243: END IF;
1244:
1245: IF NOT QP_GLOBALS.Equal(l_x_MODIFIERS_rec.relationship_type_id,
1246: l_MODIFIERS_rec.relationship_type_id)
1247: THEN
1248: x_relationship_type_id := l_x_MODIFIERS_rec.relationship_type_id;
1249: x_relationship_type := l_MODIFIERS_val_rec.relationship_type;
1248: x_relationship_type_id := l_x_MODIFIERS_rec.relationship_type_id;
1249: x_relationship_type := l_MODIFIERS_val_rec.relationship_type;
1250: END IF;
1251:
1252: IF NOT QP_GLOBALS.Equal(l_x_MODIFIERS_rec.reprice_flag,
1253: l_MODIFIERS_rec.reprice_flag)
1254: THEN
1255: x_reprice_flag := l_x_MODIFIERS_rec.reprice_flag;
1256: x_reprice := l_MODIFIERS_val_rec.reprice;
1255: x_reprice_flag := l_x_MODIFIERS_rec.reprice_flag;
1256: x_reprice := l_MODIFIERS_val_rec.reprice;
1257: END IF;
1258:
1259: IF NOT QP_GLOBALS.Equal(l_x_MODIFIERS_rec.revision,
1260: l_MODIFIERS_rec.revision)
1261: THEN
1262: x_revision := l_x_MODIFIERS_rec.revision;
1263: END IF;
1261: THEN
1262: x_revision := l_x_MODIFIERS_rec.revision;
1263: END IF;
1264:
1265: IF NOT QP_GLOBALS.Equal(l_x_MODIFIERS_rec.revision_date,
1266: l_MODIFIERS_rec.revision_date)
1267: THEN
1268: x_revision_date := l_x_MODIFIERS_rec.revision_date;
1269: END IF;
1267: THEN
1268: x_revision_date := l_x_MODIFIERS_rec.revision_date;
1269: END IF;
1270:
1271: IF NOT QP_GLOBALS.Equal(l_x_MODIFIERS_rec.revision_reason_code,
1272: l_MODIFIERS_rec.revision_reason_code)
1273: THEN
1274: x_revision_reason_code := l_x_MODIFIERS_rec.revision_reason_code;
1275: x_revision_reason := l_MODIFIERS_val_rec.revision_reason;
1274: x_revision_reason_code := l_x_MODIFIERS_rec.revision_reason_code;
1275: x_revision_reason := l_MODIFIERS_val_rec.revision_reason;
1276: END IF;
1277:
1278: IF NOT QP_GLOBALS.Equal(l_x_MODIFIERS_rec.start_date_active,
1279: l_MODIFIERS_rec.start_date_active)
1280: THEN
1281: x_start_date_active := l_x_MODIFIERS_rec.start_date_active;
1282: END IF;
1280: THEN
1281: x_start_date_active := l_x_MODIFIERS_rec.start_date_active;
1282: END IF;
1283:
1284: IF NOT QP_GLOBALS.Equal(l_x_MODIFIERS_rec.substitution_attribute,
1285: l_MODIFIERS_rec.substitution_attribute)
1286: THEN
1287: x_substitution_attribute := l_x_MODIFIERS_rec.substitution_attribute;
1288: END IF;
1286: THEN
1287: x_substitution_attribute := l_x_MODIFIERS_rec.substitution_attribute;
1288: END IF;
1289:
1290: IF NOT QP_GLOBALS.Equal(l_x_MODIFIERS_rec.substitution_context,
1291: l_MODIFIERS_rec.substitution_context)
1292: THEN
1293: x_substitution_context := l_x_MODIFIERS_rec.substitution_context;
1294: END IF;
1292: THEN
1293: x_substitution_context := l_x_MODIFIERS_rec.substitution_context;
1294: END IF;
1295:
1296: IF NOT QP_GLOBALS.Equal(l_x_MODIFIERS_rec.substitution_value,
1297: l_MODIFIERS_rec.substitution_value)
1298: THEN
1299: x_substitution_value := l_x_MODIFIERS_rec.substitution_value;
1300: END IF;
1298: THEN
1299: x_substitution_value := l_x_MODIFIERS_rec.substitution_value;
1300: END IF;
1301:
1302: IF NOT QP_GLOBALS.Equal(l_x_MODIFIERS_rec.accrual_flag,
1303: l_MODIFIERS_rec.accrual_flag)
1304: THEN
1305: x_accrual_flag := l_x_MODIFIERS_rec.accrual_flag;
1306: END IF;
1304: THEN
1305: x_accrual_flag := l_x_MODIFIERS_rec.accrual_flag;
1306: END IF;
1307:
1308: IF NOT QP_GLOBALS.Equal(l_x_MODIFIERS_rec.pricing_group_sequence,
1309: l_MODIFIERS_rec.pricing_group_sequence)
1310: THEN
1311: x_pricing_group_sequence := l_x_MODIFIERS_rec.pricing_group_sequence;
1312: END IF;
1310: THEN
1311: x_pricing_group_sequence := l_x_MODIFIERS_rec.pricing_group_sequence;
1312: END IF;
1313:
1314: IF NOT QP_GLOBALS.Equal(l_x_MODIFIERS_rec.incompatibility_grp_code,
1315: l_MODIFIERS_rec.incompatibility_grp_code)
1316: THEN
1317: x_incompatibility_grp_code := l_x_MODIFIERS_rec.incompatibility_grp_code;
1318: END IF;
1316: THEN
1317: x_incompatibility_grp_code := l_x_MODIFIERS_rec.incompatibility_grp_code;
1318: END IF;
1319:
1320: IF NOT QP_GLOBALS.Equal(l_x_MODIFIERS_rec.pricing_phase_id,
1321: l_MODIFIERS_rec.pricing_phase_id)
1322: THEN
1323: x_pricing_phase_id := l_x_MODIFIERS_rec.pricing_phase_id;
1324: END IF;
1322: THEN
1323: x_pricing_phase_id := l_x_MODIFIERS_rec.pricing_phase_id;
1324: END IF;
1325:
1326: IF NOT QP_GLOBALS.Equal(l_x_MODIFIERS_rec.list_line_no,
1327: l_MODIFIERS_rec.list_line_no)
1328: THEN
1329: x_list_line_no := l_x_MODIFIERS_rec.list_line_no;
1330: END IF;
1328: THEN
1329: x_list_line_no := l_x_MODIFIERS_rec.list_line_no;
1330: END IF;
1331:
1332: IF NOT QP_GLOBALS.Equal(l_x_MODIFIERS_rec.product_precedence,
1333: l_MODIFIERS_rec.product_precedence)
1334: THEN
1335: x_product_precedence := l_x_MODIFIERS_rec.product_precedence;
1336: END IF;
1334: THEN
1335: x_product_precedence := l_x_MODIFIERS_rec.product_precedence;
1336: END IF;
1337:
1338: IF NOT QP_GLOBALS.Equal(l_x_MODIFIERS_rec.expiration_period_start_date,
1339: l_MODIFIERS_rec.expiration_period_start_date)
1340: THEN
1341: x_expiration_period_start_date := l_x_MODIFIERS_rec.expiration_period_start_date;
1342: END IF;
1340: THEN
1341: x_expiration_period_start_date := l_x_MODIFIERS_rec.expiration_period_start_date;
1342: END IF;
1343:
1344: IF NOT QP_GLOBALS.Equal(l_x_MODIFIERS_rec.number_expiration_periods,
1345: l_MODIFIERS_rec.number_expiration_periods)
1346: THEN
1347: x_number_expiration_periods := l_x_MODIFIERS_rec.number_expiration_periods;
1348: END IF;
1346: THEN
1347: x_number_expiration_periods := l_x_MODIFIERS_rec.number_expiration_periods;
1348: END IF;
1349:
1350: IF NOT QP_GLOBALS.Equal(l_x_MODIFIERS_rec.expiration_period_uom,
1351: l_MODIFIERS_rec.expiration_period_uom)
1352: THEN
1353: x_expiration_period_uom := l_x_MODIFIERS_rec.expiration_period_uom;
1354: END IF;
1352: THEN
1353: x_expiration_period_uom := l_x_MODIFIERS_rec.expiration_period_uom;
1354: END IF;
1355:
1356: IF NOT QP_GLOBALS.Equal(l_x_MODIFIERS_rec.expiration_date,
1357: l_MODIFIERS_rec.expiration_date)
1358: THEN
1359: x_expiration_date := l_x_MODIFIERS_rec.expiration_date;
1360: END IF;
1358: THEN
1359: x_expiration_date := l_x_MODIFIERS_rec.expiration_date;
1360: END IF;
1361:
1362: IF NOT QP_GLOBALS.Equal(l_x_MODIFIERS_rec.estim_gl_value,
1363: l_MODIFIERS_rec.estim_gl_value)
1364: THEN
1365: x_estim_gl_value := l_x_MODIFIERS_rec.estim_gl_value;
1366: END IF;
1364: THEN
1365: x_estim_gl_value := l_x_MODIFIERS_rec.estim_gl_value;
1366: END IF;
1367:
1368: IF NOT QP_GLOBALS.Equal(l_x_MODIFIERS_rec.benefit_price_list_line_id,
1369: l_MODIFIERS_rec.benefit_price_list_line_id)
1370: THEN
1371: x_benefit_price_list_line_id := l_x_MODIFIERS_rec.benefit_price_list_line_id;
1372: END IF;
1370: THEN
1371: x_benefit_price_list_line_id := l_x_MODIFIERS_rec.benefit_price_list_line_id;
1372: END IF;
1373:
1374: /* IF NOT QP_GLOBALS.Equal(l_x_MODIFIERS_rec.recurring_flag,
1375: l_MODIFIERS_rec.recurring_flag)
1376: THEN
1377: x_recurring_flag := l_x_MODIFIERS_rec.recurring_flag;
1378: END IF;
1376: THEN
1377: x_recurring_flag := l_x_MODIFIERS_rec.recurring_flag;
1378: END IF;
1379: */
1380: IF NOT QP_GLOBALS.Equal(l_x_MODIFIERS_rec.benefit_limit,
1381: l_MODIFIERS_rec.benefit_limit)
1382: THEN
1383: x_benefit_limit := l_x_MODIFIERS_rec.benefit_limit;
1384: END IF;
1382: THEN
1383: x_benefit_limit := l_x_MODIFIERS_rec.benefit_limit;
1384: END IF;
1385:
1386: IF NOT QP_GLOBALS.Equal(l_x_MODIFIERS_rec.charge_type_code,
1387: l_MODIFIERS_rec.charge_type_code)
1388: THEN
1389: x_charge_type_code := l_x_MODIFIERS_rec.charge_type_code;
1390: END IF;
1388: THEN
1389: x_charge_type_code := l_x_MODIFIERS_rec.charge_type_code;
1390: END IF;
1391:
1392: IF NOT QP_GLOBALS.Equal(l_x_MODIFIERS_rec.charge_subtype_code,
1393: l_MODIFIERS_rec.charge_subtype_code)
1394: THEN
1395: x_charge_subtype_code := l_x_MODIFIERS_rec.charge_subtype_code;
1396: END IF;
1394: THEN
1395: x_charge_subtype_code := l_x_MODIFIERS_rec.charge_subtype_code;
1396: END IF;
1397:
1398: IF NOT QP_GLOBALS.Equal(l_x_MODIFIERS_rec.benefit_qty,
1399: l_MODIFIERS_rec.benefit_qty)
1400: THEN
1401: x_benefit_qty := l_x_MODIFIERS_rec.benefit_qty;
1402: END IF;
1400: THEN
1401: x_benefit_qty := l_x_MODIFIERS_rec.benefit_qty;
1402: END IF;
1403:
1404: IF NOT QP_GLOBALS.Equal(l_x_MODIFIERS_rec.benefit_uom_code,
1405: l_MODIFIERS_rec.benefit_uom_code)
1406: THEN
1407: x_benefit_uom_code := l_x_MODIFIERS_rec.benefit_uom_code;
1408: END IF;
1406: THEN
1407: x_benefit_uom_code := l_x_MODIFIERS_rec.benefit_uom_code;
1408: END IF;
1409:
1410: IF NOT QP_GLOBALS.Equal(l_x_MODIFIERS_rec.accrual_conversion_rate,
1411: l_MODIFIERS_rec.accrual_conversion_rate)
1412: THEN
1413: x_accrual_conversion_rate := l_x_MODIFIERS_rec.accrual_conversion_rate;
1414: END IF;
1412: THEN
1413: x_accrual_conversion_rate := l_x_MODIFIERS_rec.accrual_conversion_rate;
1414: END IF;
1415:
1416: IF NOT QP_GLOBALS.Equal(l_x_MODIFIERS_rec.proration_type_code,
1417: l_MODIFIERS_rec.proration_type_code)
1418: THEN
1419: x_proration_type_code := l_x_MODIFIERS_rec.proration_type_code;
1420: END IF;
1418: THEN
1419: x_proration_type_code := l_x_MODIFIERS_rec.proration_type_code;
1420: END IF;
1421:
1422: IF NOT QP_GLOBALS.Equal(l_x_MODIFIERS_rec.include_on_returns_flag,
1423: l_MODIFIERS_rec.include_on_returns_flag)
1424: THEN
1425: x_include_on_returns_flag := l_x_MODIFIERS_rec.include_on_returns_flag;
1426: END IF;
1424: THEN
1425: x_include_on_returns_flag := l_x_MODIFIERS_rec.include_on_returns_flag;
1426: END IF;
1427:
1428: IF NOT QP_GLOBALS.Equal(l_x_MODIFIERS_rec.from_rltd_modifier_id,
1429: l_MODIFIERS_rec.from_rltd_modifier_id)
1430: THEN
1431: x_from_rltd_modifier_id := l_x_MODIFIERS_rec.from_rltd_modifier_id;
1432: END IF;
1430: THEN
1431: x_from_rltd_modifier_id := l_x_MODIFIERS_rec.from_rltd_modifier_id;
1432: END IF;
1433:
1434: IF NOT QP_GLOBALS.Equal(l_x_MODIFIERS_rec.to_rltd_modifier_id,
1435: l_MODIFIERS_rec.to_rltd_modifier_id)
1436: THEN
1437: x_to_rltd_modifier_id := l_x_MODIFIERS_rec.to_rltd_modifier_id;
1438: END IF;
1436: THEN
1437: x_to_rltd_modifier_id := l_x_MODIFIERS_rec.to_rltd_modifier_id;
1438: END IF;
1439:
1440: IF NOT QP_GLOBALS.Equal(l_x_MODIFIERS_rec.rltd_modifier_grp_no,
1441: l_MODIFIERS_rec.rltd_modifier_grp_no)
1442: THEN
1443: x_rltd_modifier_grp_no := l_x_MODIFIERS_rec.rltd_modifier_grp_no;
1444: END IF;
1442: THEN
1443: x_rltd_modifier_grp_no := l_x_MODIFIERS_rec.rltd_modifier_grp_no;
1444: END IF;
1445:
1446: IF NOT QP_GLOBALS.Equal(l_x_MODIFIERS_rec.rltd_modifier_grp_type,
1447: l_MODIFIERS_rec.rltd_modifier_grp_type)
1448: THEN
1449: x_rltd_modifier_grp_type := l_x_MODIFIERS_rec.rltd_modifier_grp_type;
1450: END IF;
1448: THEN
1449: x_rltd_modifier_grp_type := l_x_MODIFIERS_rec.rltd_modifier_grp_type;
1450: END IF;
1451:
1452: IF NOT QP_GLOBALS.Equal(l_x_MODIFIERS_rec.net_amount_flag,
1453: l_MODIFIERS_rec.net_amount_flag)
1454: THEN
1455: x_net_amount_flag := l_x_MODIFIERS_rec.net_amount_flag;
1456: END IF;
1454: THEN
1455: x_net_amount_flag := l_x_MODIFIERS_rec.net_amount_flag;
1456: END IF;
1457:
1458: IF NOT QP_GLOBALS.Equal(l_x_MODIFIERS_rec.accum_attribute,
1459: l_MODIFIERS_rec.accum_attribute)
1460: THEN
1461: x_accum_attribute := l_x_MODIFIERS_rec.accum_attribute;
1462: END IF;
1461: x_accum_attribute := l_x_MODIFIERS_rec.accum_attribute;
1462: END IF;
1463:
1464: --Continuous Price Breaks
1465: IF NOT QP_GLOBALS.Equal(l_x_MODIFIERS_rec.continuous_price_break_flag,
1466: l_MODIFIERS_rec.continuous_price_break_flag)
1467: THEN
1468: x_continuous_price_break_flag := l_x_MODIFIERS_rec.continuous_price_break_flag;
1469: END IF;
1552: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
1553: l_old_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
1554: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1555: l_old_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1556: l_control_rec QP_GLOBALS.Control_Rec_Type;
1557: l_return_status VARCHAR2(1);
1558: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
1559: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
1560: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1595:
1596: -- Set Operation.
1597:
1598: IF FND_API.To_Boolean(l_MODIFIERS_rec.db_flag) THEN
1599: l_MODIFIERS_rec.operation := QP_GLOBALS.G_OPR_UPDATE;
1600: ELSE
1601: l_MODIFIERS_rec.operation := QP_GLOBALS.G_OPR_CREATE;
1602: END IF;
1603:
1597:
1598: IF FND_API.To_Boolean(l_MODIFIERS_rec.db_flag) THEN
1599: l_MODIFIERS_rec.operation := QP_GLOBALS.G_OPR_UPDATE;
1600: ELSE
1601: l_MODIFIERS_rec.operation := QP_GLOBALS.G_OPR_CREATE;
1602: END IF;
1603:
1604: -- Populate MODIFIERS table
1605:
1719: )
1720: IS
1721: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
1722: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1723: l_control_rec QP_GLOBALS.Control_Rec_Type;
1724: l_return_status VARCHAR2(1);
1725: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
1726: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
1727: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1757: );
1758:
1759: -- Set Operation.
1760:
1761: l_MODIFIERS_rec.operation := QP_GLOBALS.G_OPR_DELETE;
1762:
1763: -- Populate MODIFIERS table
1764:
1765: l_MODIFIERS_tbl(1) := l_MODIFIERS_rec;
1857: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
1858: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1859: )
1860: IS
1861: l_control_rec QP_GLOBALS.Control_Rec_Type;
1862: l_return_status VARCHAR2(1);
1863: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
1864: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
1865: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1874: -- Set control flags.
1875:
1876: l_control_rec.controlled_operation := TRUE;
1877: l_control_rec.process := TRUE;
1878: l_control_rec.process_entity := QP_GLOBALS.G_ENTITY_MODIFIERS;
1879:
1880: l_control_rec.default_attributes := FALSE;
1881: l_control_rec.change_attributes := FALSE;
1882: l_control_rec.validate_entity := FALSE;
2173: -- l_MODIFIERS_rec.from_rltd_modifier_id := p_from_rltd_modifier_id;
2174: -- l_MODIFIERS_rec.to_rltd_modifier_id := p_to_rltd_modifier_id;
2175: -- l_MODIFIERS_rec.rltd_modifier_grp_no := p_rltd_modifier_grp_no;
2176: -- l_MODIFIERS_rec.rltd_modifier_grp_type := p_rltd_modifier_grp_type;
2177: l_MODIFIERS_rec.operation := QP_GLOBALS.G_OPR_LOCK;
2178: l_MODIFIERS_rec.net_amount_flag := p_net_amount_flag;
2179: l_MODIFIERS_rec.accum_attribute := p_accum_attribute;
2180: l_MODIFIERS_rec.continuous_price_break_flag := p_continuous_price_break_flag;
2181: --Continuous Price Breaks
2343: BEGIN
2344: OE_MSG_PUB.initialize;
2345: x_return_status := FND_API.G_RET_STS_SUCCESS;
2346: QP_DELAYED_REQUESTS_PVT.Delete_Reqs_for_Deleted_Entity(
2347: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS
2348: ,p_entity_id => p_list_line_id
2349: ,x_return_status => l_return_status);
2350:
2351: OE_MSG_PUB.Count_And_Get
2392: l_new_pricing_attribute_id Number;
2393: l_new_list_line_id Number;
2394: l_new_qualifier_id Number;
2395: l_number_of_lines Number := 1;
2396: l_control_rec QP_GLOBALS.Control_Rec_Type;
2397: l_return_status VARCHAR2(1);
2398: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
2399: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
2400: l_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
2729: l_PRICING_ATTR_rec.pricing_attr_value_to_number := l_implicit_rec.PRICING_ATTR_VALUE_TO_NUMBER;
2730: l_PRICING_ATTR_rec.qualification_ind := l_implicit_rec.QUALIFICATION_IND;
2731: l_PRICING_ATTR_rec.MODIFIERS_INDEX := 1;
2732:
2733: l_PRICING_ATTR_rec.operation := QP_GLOBALS.G_OPR_CREATE;
2734:
2735: l_PRICING_ATTR_tbl(l_PRICING_ATTR_tbl.COUNT + 1) := l_PRICING_ATTR_rec;
2736:
2737: END LOOP;
2841: l_MODIFIERS_rec.RLTD_MODIFIER_GRP_NO := l_implicit_rec.RLTD_MODIFIER_GRP_NO;
2842: l_MODIFIERS_rec.RLTD_MODIFIER_GRP_TYPE := l_implicit_rec.RLTD_MODIFIER_GRP_TYPE;
2843:
2844: l_MODIFIERS_rec.db_flag := FND_API.G_TRUE;
2845: l_MODIFIERS_rec.operation := QP_GLOBALS.G_OPR_CREATE;
2846:
2847: l_MODIFIERS_tbl(l_MODIFIERS_tbl.COUNT + 1) := l_MODIFIERS_rec;
2848: l_number_of_lines := l_number_of_lines + 1;
2849:
2904: l_PRICING_ATTR_rec.pricing_attr_value_from_number := l_implicit_attr_rec.PRICING_ATTR_VALUE_FROM_NUMBER;
2905: l_PRICING_ATTR_rec.pricing_attr_value_to_number := l_implicit_attr_rec.PRICING_ATTR_VALUE_TO_NUMBER;
2906: l_PRICING_ATTR_rec.qualification_ind := l_implicit_attr_rec.QUALIFICATION_IND;
2907: l_PRICING_ATTR_rec.MODIFIERS_INDEX := l_number_of_lines;
2908: l_PRICING_ATTR_rec.operation := QP_GLOBALS.G_OPR_CREATE;
2909:
2910: l_PRICING_ATTR_tbl(l_PRICING_ATTR_tbl.COUNT + 1) := l_PRICING_ATTR_rec;
2911:
2912: END LOOP;
2971: l_QUALIFIERS_rec.REQUEST_ID := l_implicit_rec.REQUEST_ID;
2972: l_QUALIFIERS_rec.SEARCH_IND := l_implicit_rec.SEARCH_IND;
2973: l_QUALIFIERS_rec.START_DATE_ACTIVE := l_implicit_rec.START_DATE_ACTIVE;
2974:
2975: l_QUALIFIERS_rec.operation := QP_GLOBALS.G_OPR_CREATE;
2976:
2977: l_QUALIFIERS_tbl(l_QUALIFIERS_tbl.COUNT + 1) := l_QUALIFIERS_rec;
2978:
2979: END LOOP;
3024: -- Upgrade Non Continuous Price Break Lines into Continuous Price Break Lines.
3025: IF (l_continuous_price_break_flag<>'Y' OR l_continuous_price_break_flag IS NULL )and p_list_line_type_code='PBH' THEN
3026:
3027: qp_delayed_requests_PVT.log_request
3028: ( p_entity_code => QP_GLOBALS.G_ENTITY_PRICING_ATTR
3029: , p_entity_id =>p_new_list_line_id
3030: , p_requesting_entity_code => QP_GLOBALS.G_ENTITY_PRICING_ATTR
3031: , p_requesting_entity_id => p_new_list_line_id
3032: , p_request_type => QP_Globals.G_UPGRADE_PRICE_BREAKS
3026:
3027: qp_delayed_requests_PVT.log_request
3028: ( p_entity_code => QP_GLOBALS.G_ENTITY_PRICING_ATTR
3029: , p_entity_id =>p_new_list_line_id
3030: , p_requesting_entity_code => QP_GLOBALS.G_ENTITY_PRICING_ATTR
3031: , p_requesting_entity_id => p_new_list_line_id
3032: , p_request_type => QP_Globals.G_UPGRADE_PRICE_BREAKS
3033: , p_param1 => null
3034: , p_param2 => null
3028: ( p_entity_code => QP_GLOBALS.G_ENTITY_PRICING_ATTR
3029: , p_entity_id =>p_new_list_line_id
3030: , p_requesting_entity_code => QP_GLOBALS.G_ENTITY_PRICING_ATTR
3031: , p_requesting_entity_id => p_new_list_line_id
3032: , p_request_type => QP_Globals.G_UPGRADE_PRICE_BREAKS
3033: , p_param1 => null
3034: , p_param2 => null
3035: , p_param3 => null
3036: , x_return_status => l_return_status);
3036: , x_return_status => l_return_status);
3037:
3038:
3039: QP_DELAYED_REQUESTS_PVT.Process_Request_for_Entity
3040: ( p_entity_code => QP_GLOBALS.G_ENTITY_PRICING_ATTR
3041: , x_return_status => l_return_status);
3042:
3043: fnd_message.set_name('QP','QP_CONT_DUPLICATE_LINE');
3044: OE_MSG_PUB.Add;