APPS.QP_LIST_HEADERS_PVT dependencies on QP_QUALIFIERS_UTIL

Line 883: QP_Qualifiers_Util.Convert_Miss_To_Null (l_old_QUALIFIERS_rec);

879:
880: -- Set missing old record elements to NULL.
881:
882: l_old_QUALIFIERS_rec :=
883: QP_Qualifiers_Util.Convert_Miss_To_Null (l_old_QUALIFIERS_rec);
884:
885: ELSIF l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_UPDATE
886: OR l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_DELETE
887: THEN

Line 896: l_old_QUALIFIERS_rec := QP_Qualifiers_Util.Query_Row

892:
893: IF l_old_QUALIFIERS_rec.qualifier_id = FND_API.G_MISS_NUM
894: THEN
895:
896: l_old_QUALIFIERS_rec := QP_Qualifiers_Util.Query_Row
897: ( p_qualifier_id => l_QUALIFIERS_rec.qualifier_id
898: );
899:
900: ELSE

Line 905: QP_Qualifiers_Util.Convert_Miss_To_Null (l_old_QUALIFIERS_rec);

901:
902: -- Set missing old record elements to NULL.
903:
904: l_old_QUALIFIERS_rec :=
905: QP_Qualifiers_Util.Convert_Miss_To_Null (l_old_QUALIFIERS_rec);
906:
907: END IF;
908:
909: -- Complete new record from old

Line 911: l_QUALIFIERS_rec := QP_Qualifiers_Util.Complete_Record

907: END IF;
908:
909: -- Complete new record from old
910:
911: l_QUALIFIERS_rec := QP_Qualifiers_Util.Complete_Record
912: ( p_QUALIFIERS_rec => l_QUALIFIERS_rec
913: , p_old_QUALIFIERS_rec => l_old_QUALIFIERS_rec
914: );
915:

Line 979: QP_Qualifiers_Util.Clear_Dependent_Attr

975: -- Clear dependent attributes.
976:
977: IF l_control_rec.change_attributes THEN
978: l_p_QUALIFIERS_rec := l_QUALIFIERS_rec;
979: QP_Qualifiers_Util.Clear_Dependent_Attr
980: ( p_QUALIFIERS_rec => l_p_QUALIFIERS_rec
981: , p_old_QUALIFIERS_rec => l_old_QUALIFIERS_rec
982: , x_QUALIFIERS_rec => l_QUALIFIERS_rec
983: );

Line 1040: QP_Qualifiers_Util.Apply_Attribute_Changes

1036: IF l_control_rec.default_attributes
1037: OR l_control_rec.change_attributes
1038: THEN
1039: l_p_QUALIFIERS_rec := l_QUALIFIERS_rec;
1040: QP_Qualifiers_Util.Apply_Attribute_Changes
1041: ( p_QUALIFIERS_rec => l_p_QUALIFIERS_rec
1042: , p_old_QUALIFIERS_rec => l_old_QUALIFIERS_rec
1043: , x_QUALIFIERS_rec => l_QUALIFIERS_rec
1044: );

Line 1157: QP_QUALIFIERS_UTIL.PRE_WRITE_PROCESS

1153: END IF;
1154:
1155: IF l_control_rec.write_to_db THEN
1156: l_p_QUALIFIERS_rec := l_QUALIFIERS_rec;
1157: QP_QUALIFIERS_UTIL.PRE_WRITE_PROCESS
1158: ( p_QUALIFIERS_rec => l_p_QUALIFIERS_rec
1159: , p_old_QUALIFIERS_rec => l_old_QUALIFIERS_rec
1160: , x_QUALIFIERS_rec => l_QUALIFIERS_rec);
1161:

Line 1181: QP_Qualifiers_Util.Delete_Row

1177: OE_MSG_PUB.ADD;
1178: RAISE FND_API.G_EXC_ERROR;
1179: ELSE
1180:
1181: QP_Qualifiers_Util.Delete_Row
1182: ( p_qualifier_id => l_QUALIFIERS_rec.qualifier_id
1183: );
1184: END IF;
1185:

Line 1196: QP_Qualifiers_Util.Update_Row (l_QUALIFIERS_rec);

1192: l_QUALIFIERS_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
1193:
1194: IF l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN
1195:
1196: QP_Qualifiers_Util.Update_Row (l_QUALIFIERS_rec);
1197: IF l_QUALIFIERS_rec.QUALIFIER_CONTEXT = 'MODLIST' AND
1198: l_QUALIFIERS_rec.QUALIFIER_ATTRIBUTE =
1199: 'QUALIFIER_ATTRIBUTE3' THEN
1200: QP_Qualifiers_Util.Update_Coupon_Row (l_QUALIFIERS_rec); ---Added for bug 7315016

Line 1200: QP_Qualifiers_Util.Update_Coupon_Row (l_QUALIFIERS_rec); ---Added for bug 7315016

1196: QP_Qualifiers_Util.Update_Row (l_QUALIFIERS_rec);
1197: IF l_QUALIFIERS_rec.QUALIFIER_CONTEXT = 'MODLIST' AND
1198: l_QUALIFIERS_rec.QUALIFIER_ATTRIBUTE =
1199: 'QUALIFIER_ATTRIBUTE3' THEN
1200: QP_Qualifiers_Util.Update_Coupon_Row (l_QUALIFIERS_rec); ---Added for bug 7315016
1201: END IF;
1202:
1203: ELSIF l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN
1204:

Line 1208: QP_Qualifiers_Util.Insert_Row (l_QUALIFIERS_rec);

1204:
1205: l_QUALIFIERS_rec.creation_date := SYSDATE;
1206: l_QUALIFIERS_rec.created_by := FND_GLOBAL.USER_ID;
1207:
1208: QP_Qualifiers_Util.Insert_Row (l_QUALIFIERS_rec);
1209:
1210: END IF;
1211:
1212: END IF;

Line 2476: QP_Qualifiers_Util.Lock_Row

2472: FOR I IN 1..p_QUALIFIERS_tbl.COUNT LOOP
2473:
2474: IF p_QUALIFIERS_tbl(I).operation = QP_GLOBALS.G_OPR_LOCK THEN
2475:
2476: QP_Qualifiers_Util.Lock_Row
2477: ( p_QUALIFIERS_rec => p_QUALIFIERS_tbl(I)
2478: , x_QUALIFIERS_rec => l_QUALIFIERS_rec
2479: , x_return_status => l_return_status
2480: );

Line 2679: l_QUALIFIERS_tbl := QP_Qualifiers_Util_Mod.Query_Rows

2675:
2676:
2677: -- Get QUALIFIERS ( parent = PRICE_LIST )
2678:
2679: l_QUALIFIERS_tbl := QP_Qualifiers_Util_Mod.Query_Rows
2680: ( p_list_header_id => l_PRICE_LIST_rec.list_header_id
2681: );
2682:
2683: