DBA Data[Home] [Help]

APPS.WSH_USA_ACTIONS_PVT dependencies on WSH_USA_CATEGORIES_PVT

Line 1631: l_changed_detail WSH_USA_CATEGORIES_PVT.ChangedDetailRec;

1627: IS
1628: l_counter NUMBER;
1629: l_update_allowed VARCHAR2(1);
1630: l_rs VARCHAR2(1);
1631: l_changed_detail WSH_USA_CATEGORIES_PVT.ChangedDetailRec;
1632: --
1633: l_debug_on BOOLEAN;
1634: --
1635: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'UPDATE_RECORDS';

Line 1666: WSH_USA_CATEGORIES_PVT.Check_Attributes(

1662: -- always allow update during OM Interface without validation or further changes.
1663: l_update_allowed := 'Y';
1664: ELSE
1665: -- normal process requires validation and sometimes changes.
1666: WSH_USA_CATEGORIES_PVT.Check_Attributes(
1667: p_source_code => p_source_code,
1668: p_attributes_rec => p_changed_attributes(l_counter),
1669: x_changed_detail => l_changed_detail,
1670: x_update_allowed => l_update_allowed,

Line 1674: WSH_DEBUG_SV.log(l_module_name, 'AFTER CALLING WSH_USA_CATEGORIES_PVT.CHECK_ATTRIBUTES: L_RS', L_RS );

1670: x_update_allowed => l_update_allowed,
1671: x_return_status => l_rs);
1672:
1673: IF l_debug_on THEN
1674: WSH_DEBUG_SV.log(l_module_name, 'AFTER CALLING WSH_USA_CATEGORIES_PVT.CHECK_ATTRIBUTES: L_RS', L_RS );
1675: WSH_DEBUG_SV.log(l_module_name, 'L_UPDATE_ALLOWED', l_update_allowed);
1676: END IF;
1677:
1678: IF NVL(l_update_allowed, 'N') = 'N' THEN

Line 1739: p_changed_detail IN WSH_USA_CATEGORIES_PVT.ChangedDetailRec,

1735:
1736: Procedure Update_Attributes(
1737: p_source_code IN VARCHAR2,
1738: p_attributes_rec IN WSH_INTERFACE.ChangedAttributeRecType,
1739: p_changed_detail IN WSH_USA_CATEGORIES_PVT.ChangedDetailRec,
1740: x_return_status OUT NOCOPY VARCHAR2)
1741: IS
1742:
1743: --bug#6407943:Needs to change items org dependent attributes when org changes.