DBA Data[Home] [Help]

APPS.QP_MODIFIERS_PVT dependencies on QP_QUALIFIERS

Line 1119: QP_Qualifiers_Util.Convert_Miss_To_Null (l_old_QUALIFIERS_rec);

1115:
1116: -- Set missing old record elements to NULL.
1117:
1118: l_old_QUALIFIERS_rec :=
1119: QP_Qualifiers_Util.Convert_Miss_To_Null (l_old_QUALIFIERS_rec);
1120:
1121: ELSIF l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_UPDATE
1122: OR l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_DELETE
1123: THEN

Line 1132: l_old_QUALIFIERS_rec := QP_Qualifiers_Util.Query_Row

1128:
1129: IF l_old_QUALIFIERS_rec.qualifier_id = FND_API.G_MISS_NUM
1130: THEN
1131:
1132: l_old_QUALIFIERS_rec := QP_Qualifiers_Util.Query_Row
1133: ( p_qualifier_id => l_QUALIFIERS_rec.qualifier_id
1134: );
1135:
1136: ELSE

Line 1141: QP_Qualifiers_Util.Convert_Miss_To_Null (l_old_QUALIFIERS_rec);

1137:
1138: -- Set missing old record elements to NULL.
1139:
1140: l_old_QUALIFIERS_rec :=
1141: QP_Qualifiers_Util.Convert_Miss_To_Null (l_old_QUALIFIERS_rec);
1142:
1143: END IF;
1144:
1145: -- Complete new record from old

Line 1148: l_QUALIFIERS_rec := QP_Qualifiers_Util.Complete_Record

1144:
1145: -- Complete new record from old
1146:
1147: oe_debug_pub.add('before complete rec ');
1148: l_QUALIFIERS_rec := QP_Qualifiers_Util.Complete_Record
1149: ( p_QUALIFIERS_rec => l_QUALIFIERS_rec
1150: , p_old_QUALIFIERS_rec => l_old_QUALIFIERS_rec
1151: );
1152:

Line 1188: QP_Qualifiers_Util.Clear_Dependent_Attr

1184: IF l_control_rec.change_attributes THEN
1185:
1186: oe_debug_pub.add('before clear depen');
1187: l_p_QUALIFIERS_rec := l_QUALIFIERS_rec;
1188: QP_Qualifiers_Util.Clear_Dependent_Attr
1189: ( p_QUALIFIERS_rec => l_p_QUALIFIERS_rec
1190: , p_old_QUALIFIERS_rec => l_old_QUALIFIERS_rec
1191: , x_QUALIFIERS_rec => l_QUALIFIERS_rec
1192: );

Line 1217: QP_Qualifiers_Util.Apply_Attribute_Changes

1213: IF l_control_rec.default_attributes
1214: OR l_control_rec.change_attributes
1215: THEN
1216: l_p_QUALIFIERS_rec := l_QUALIFIERS_rec;
1217: QP_Qualifiers_Util.Apply_Attribute_Changes
1218: ( p_QUALIFIERS_rec => l_p_QUALIFIERS_rec
1219: , p_old_QUALIFIERS_rec => l_old_QUALIFIERS_rec
1220: , x_QUALIFIERS_rec => l_QUALIFIERS_rec
1221: );

Line 1262: QP_QUALIFIERS_UTIL.PRE_WRITE_PROCESS

1258: -- writing to the DB (like Scheduling).
1259:
1260: IF l_control_rec.write_to_db THEN
1261: l_p_QUALIFIERS_rec := l_QUALIFIERS_rec;
1262: QP_QUALIFIERS_UTIL.PRE_WRITE_PROCESS
1263: ( p_QUALIFIERS_rec => l_p_QUALIFIERS_rec
1264: , p_old_QUALIFIERS_rec => l_old_QUALIFIERS_rec
1265: , x_QUALIFIERS_rec => l_QUALIFIERS_rec);
1266:

Line 1275: QP_Qualifiers_Util.Delete_Row

1271: IF l_control_rec.write_to_db THEN
1272:
1273: IF l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN
1274:
1275: QP_Qualifiers_Util.Delete_Row
1276: ( p_qualifier_id => l_QUALIFIERS_rec.qualifier_id
1277: );
1278:
1279: ELSE

Line 1289: QP_Qualifiers_Util.Update_Row (l_QUALIFIERS_rec);

1285: l_QUALIFIERS_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
1286:
1287: IF l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN
1288:
1289: QP_Qualifiers_Util.Update_Row (l_QUALIFIERS_rec);
1290:
1291: ELSIF l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN
1292:
1293: l_QUALIFIERS_rec.creation_date := SYSDATE;

Line 1297: QP_Qualifiers_Util.Insert_Row (l_QUALIFIERS_rec);

1293: l_QUALIFIERS_rec.creation_date := SYSDATE;
1294: l_QUALIFIERS_rec.created_by := FND_GLOBAL.USER_ID;
1295:
1296: oe_debug_pub.add('util . Insert');
1297: QP_Qualifiers_Util.Insert_Row (l_QUALIFIERS_rec);
1298:
1299: END IF;
1300:
1301: END IF;

Line 2502: from qp_qualifiers

2498: oe_debug_pub.add('inside create qualifier for blanket modifier');
2499:
2500: BEGIN
2501: select 'Y' into l_qual_exists
2502: from qp_qualifiers
2503: where list_header_id = x_MODIFIER_LIST_rec.list_header_id
2504: and qualifier_context = 'ORDER'
2505: and qualifier_attribute = 'QUALIFIER_ATTRIBUTE5'
2506: and qualifier_attr_value = x_MODIFIER_LIST_rec.orig_system_header_ref;

Line 2727: QP_Qualifiers_Util.Lock_Row

2723: FOR I IN 1..p_QUALIFIERS_tbl.COUNT LOOP
2724:
2725: IF p_QUALIFIERS_tbl(I).operation = QP_GLOBALS.G_OPR_LOCK THEN
2726:
2727: QP_Qualifiers_Util.Lock_Row
2728: ( p_QUALIFIERS_rec => p_QUALIFIERS_tbl(I)
2729: , x_QUALIFIERS_rec => l_QUALIFIERS_rec
2730: , x_return_status => l_return_status
2731: );

Line 2931: l_QUALIFIERS_tbl := QP_Qualifiers_Util_Mod.Query_Rows

2927:
2928:
2929: -- Get QUALIFIERS ( parent = MODIFIER_LIST )
2930:
2931: l_QUALIFIERS_tbl := QP_Qualifiers_Util_Mod.Query_Rows
2932: ( p_list_header_id => l_MODIFIER_LIST_rec.list_header_id
2933: );
2934:
2935: