APPS.QP_ATTR_MAP_PVT dependencies on QP_FNA_UTIL

Line 1480: QP_Fna_Util.Convert_Miss_To_Null (l_old_FNA_rec);

1476:
1477: -- Set missing old record elements to NULL.
1478:
1479: l_old_FNA_rec :=
1480: QP_Fna_Util.Convert_Miss_To_Null (l_old_FNA_rec);
1481:
1482: ELSIF l_FNA_rec.operation = QP_GLOBALS.G_OPR_UPDATE
1483: OR l_FNA_rec.operation = QP_GLOBALS.G_OPR_DELETE
1484: THEN

Line 1493: l_old_FNA_rec := QP_Fna_Util.Query_Row

1489:
1490: IF l_old_FNA_rec.pte_sourcesystem_fnarea_id = FND_API.G_MISS_NUM
1491: THEN
1492:
1493: l_old_FNA_rec := QP_Fna_Util.Query_Row
1494: ( p_pte_sourcesystem_fnarea_id => l_FNA_rec.pte_sourcesystem_fnarea_id
1495: );
1496: ELSE
1497:

Line 1501: QP_Fna_Util.Convert_Miss_To_Null (l_old_FNA_rec);

1497:
1498: -- Set missing old record elements to NULL.
1499:
1500: l_old_FNA_rec :=
1501: QP_Fna_Util.Convert_Miss_To_Null (l_old_FNA_rec);
1502:
1503: END IF;
1504:
1505: -- Complete new record from old

Line 1507: l_FNA_rec := QP_Fna_Util.Complete_Record

1503: END IF;
1504:
1505: -- Complete new record from old
1506:
1507: l_FNA_rec := QP_Fna_Util.Complete_Record
1508: ( p_FNA_rec => l_FNA_rec
1509: , p_old_FNA_rec => l_old_FNA_rec
1510: );
1511:

Line 1542: QP_Fna_Util.Clear_Dependent_Attr

1538: -- Clear dependent attributes.
1539:
1540: IF l_control_rec.change_attributes THEN
1541: l_p_FNA_rec := l_FNA_rec;
1542: QP_Fna_Util.Clear_Dependent_Attr
1543: ( p_FNA_rec => l_p_FNA_rec
1544: , p_old_FNA_rec => l_old_FNA_rec
1545: , x_FNA_rec => l_FNA_rec
1546: );

Line 1568: QP_Fna_Util.Apply_Attribute_Changes

1564: IF l_control_rec.default_attributes
1565: OR l_control_rec.change_attributes
1566: THEN
1567: l_p_FNA_rec := l_FNA_rec;
1568: QP_Fna_Util.Apply_Attribute_Changes
1569: ( p_FNA_rec => l_p_FNA_rec
1570: , p_old_FNA_rec => l_old_FNA_rec
1571: , p_called_from_ui => l_control_rec.called_from_ui
1572: , x_FNA_rec => l_FNA_rec

Line 1612: QP_Fna_Util.Delete_Row

1608: IF l_control_rec.write_to_db THEN
1609:
1610: IF l_FNA_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN
1611:
1612: QP_Fna_Util.Delete_Row
1613: ( p_pte_sourcesystem_fnarea_id => l_FNA_rec.pte_sourcesystem_fnarea_id
1614: );
1615:
1616: qp_delayed_requests_PVT.log_request(

Line 1625: QP_Fna_Util.Warn_Disable_Delete_Fna

1621: p_request_type => QP_GLOBALS.G_CHECK_ENABLED_FUNC_AREAS,
1622: x_return_status => l_dummy_ret_status);
1623:
1624: IF l_control_rec.called_from_ui = 'N' THEN
1625: QP_Fna_Util.Warn_Disable_Delete_Fna
1626: ( p_action => 'DELETE'
1627: , p_called_from_ui => l_control_rec.called_from_ui
1628: , p_functional_area_id => l_FNA_rec.functional_area_id
1629: , p_pte_ss_id => l_FNA_rec.pte_source_system_id

Line 1643: QP_Fna_Util.Update_Row (l_FNA_rec);

1639: l_FNA_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
1640:
1641: IF l_FNA_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN
1642:
1643: QP_Fna_Util.Update_Row (l_FNA_rec);
1644:
1645: ELSIF l_FNA_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN
1646:
1647: l_FNA_rec.creation_date := SYSDATE;

Line 1650: QP_Fna_Util.Insert_Row (l_FNA_rec);

1646:
1647: l_FNA_rec.creation_date := SYSDATE;
1648: l_FNA_rec.created_by := FND_GLOBAL.USER_ID;
1649:
1650: QP_Fna_Util.Insert_Row (l_FNA_rec);
1651:
1652: END IF;
1653:
1654: END IF;

Line 2508: QP_Fna_Util.Lock_Row

2504: FOR I IN 1..p_FNA_tbl.COUNT LOOP
2505:
2506: IF p_FNA_tbl(I).operation = QP_GLOBALS.G_OPR_LOCK THEN
2507:
2508: QP_Fna_Util.Lock_Row
2509: ( p_FNA_rec => p_FNA_tbl(I)
2510: , x_FNA_rec => l_FNA_rec
2511: , x_return_status => l_return_status
2512: );

Line 2682: l_FNA_tbl := QP_Fna_Util.Query_Rows

2678: FOR I2 IN 1..l_SSC_tbl.COUNT LOOP
2679:
2680: -- Get FNA ( parent = SSC )
2681:
2682: l_FNA_tbl := QP_Fna_Util.Query_Rows
2683: ( p_pte_source_system_id => l_SSC_tbl(I2).pte_source_system_id
2684: );
2685:
2686: FOR I3 IN 1..l_FNA_tbl.COUNT LOOP