DBA Data[Home] [Help]

APPS.QP_ATTR_MAP_PVT dependencies on QP_SOU_UTIL

Line 1186: QP_Sou_Util.Convert_Miss_To_Null (l_old_SOU_rec);

1182:
1183: -- Set missing old record elements to NULL.
1184:
1185: l_old_SOU_rec :=
1186: QP_Sou_Util.Convert_Miss_To_Null (l_old_SOU_rec);
1187:
1188: ELSIF l_SOU_rec.operation = QP_GLOBALS.G_OPR_UPDATE
1189: OR l_SOU_rec.operation = QP_GLOBALS.G_OPR_DELETE
1190: THEN

Line 1200: l_old_SOU_rec := QP_Sou_Util.Query_Row

1196: IF l_old_SOU_rec.attribute_sourcing_id = FND_API.G_MISS_NUM
1197: THEN
1198:
1199: oe_debug_pub.add('attribute_sou is missing');
1200: l_old_SOU_rec := QP_Sou_Util.Query_Row
1201: ( p_attribute_sourcing_id => l_SOU_rec.attribute_sourcing_id
1202: );
1203:
1204: ELSE

Line 1209: QP_Sou_Util.Convert_Miss_To_Null (l_old_SOU_rec);

1205:
1206: -- Set missing old record elements to NULL.
1207:
1208: l_old_SOU_rec :=
1209: QP_Sou_Util.Convert_Miss_To_Null (l_old_SOU_rec);
1210:
1211: END IF;
1212:
1213: -- Complete new record from old

Line 1215: l_SOU_rec := QP_Sou_Util.Complete_Record

1211: END IF;
1212:
1213: -- Complete new record from old
1214:
1215: l_SOU_rec := QP_Sou_Util.Complete_Record
1216: ( p_SOU_rec => l_SOU_rec
1217: , p_old_SOU_rec => l_old_SOU_rec
1218: );
1219:

Line 1250: QP_Sou_Util.Clear_Dependent_Attr

1246: -- Clear dependent attributes.
1247:
1248: IF l_control_rec.change_attributes THEN
1249: l_p_SOU_rec := l_SOU_rec;
1250: QP_Sou_Util.Clear_Dependent_Attr
1251: ( p_SOU_rec => l_p_SOU_rec
1252: , p_old_SOU_rec => l_old_SOU_rec
1253: , x_SOU_rec => l_SOU_rec
1254: );

Line 1277: QP_Sou_Util.Apply_Attribute_Changes

1273: IF l_control_rec.default_attributes
1274: OR l_control_rec.change_attributes
1275: THEN
1276: l_p_SOU_rec := l_SOU_rec;
1277: QP_Sou_Util.Apply_Attribute_Changes
1278: ( p_SOU_rec => l_p_SOU_rec
1279: , p_old_SOU_rec => l_old_SOU_rec
1280: , x_SOU_rec => l_SOU_rec
1281: );

Line 1320: QP_Sou_Util.Delete_Row

1316: IF l_control_rec.write_to_db THEN
1317:
1318: IF l_SOU_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN
1319:
1320: QP_Sou_Util.Delete_Row
1321: ( p_attribute_sourcing_id => l_SOU_rec.attribute_sourcing_id
1322: );
1323:
1324: ELSE

Line 1334: QP_Sou_Util.Update_Row (l_SOU_rec);

1330: l_SOU_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
1331:
1332: IF l_SOU_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN
1333:
1334: QP_Sou_Util.Update_Row (l_SOU_rec);
1335:
1336: ELSIF l_SOU_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN
1337:
1338: l_SOU_rec.creation_date := SYSDATE;

Line 1341: QP_Sou_Util.Insert_Row (l_SOU_rec);

1337:
1338: l_SOU_rec.creation_date := SYSDATE;
1339: l_SOU_rec.created_by := FND_GLOBAL.USER_ID;
1340:
1341: QP_Sou_Util.Insert_Row (l_SOU_rec);
1342:
1343: END IF;
1344:
1345: END IF;

Line 2484: QP_Sou_Util.Lock_Row

2480: FOR I IN 1..p_SOU_tbl.COUNT LOOP
2481:
2482: IF p_SOU_tbl(I).operation = QP_GLOBALS.G_OPR_LOCK THEN
2483:
2484: QP_Sou_Util.Lock_Row
2485: ( p_SOU_rec => p_SOU_tbl(I)
2486: , x_SOU_rec => l_SOU_rec
2487: , x_return_status => l_return_status
2488: );

Line 2708: l_SOU_tbl := QP_Sou_Util.Query_Rows

2704:
2705: -- Get SOU ( parent = PSG )
2706:
2707: oe_debug_pub.add('qp_attr_mapping_pvt count='||l_PSG_tbl.count);
2708: l_SOU_tbl := QP_Sou_Util.Query_Rows
2709: ( p_segment_pte_id => l_PSG_tbl(I2).segment_pte_id
2710: );
2711:
2712: FOR I3 IN 1..l_SOU_tbl.COUNT LOOP