DBA Data[Home] [Help]

APPS.WSH_USA_ACTIONS_PVT dependencies on WSH_USA_CATEGORIES_PVT

Line 1923: l_changed_detail WSH_USA_CATEGORIES_PVT.ChangedDetailRec;

1919: IS
1920: l_counter NUMBER;
1921: l_update_allowed VARCHAR2(1);
1922: l_rs VARCHAR2(1);
1923: l_changed_detail WSH_USA_CATEGORIES_PVT.ChangedDetailRec;
1924: --
1925: l_debug_on BOOLEAN;
1926: --
1927: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'UPDATE_RECORDS';

Line 1958: WSH_USA_CATEGORIES_PVT.Check_Attributes(

1954: -- always allow update during OM Interface without validation or further changes.
1955: l_update_allowed := 'Y';
1956: ELSE
1957: -- normal process requires validation and sometimes changes.
1958: WSH_USA_CATEGORIES_PVT.Check_Attributes(
1959: p_source_code => p_source_code,
1960: p_attributes_rec => p_changed_attributes(l_counter),
1961: x_changed_detail => l_changed_detail,
1962: x_update_allowed => l_update_allowed,

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

1962: x_update_allowed => l_update_allowed,
1963: x_return_status => l_rs);
1964:
1965: IF l_debug_on THEN
1966: WSH_DEBUG_SV.log(l_module_name, 'AFTER CALLING WSH_USA_CATEGORIES_PVT.CHECK_ATTRIBUTES: L_RS', L_RS );
1967: WSH_DEBUG_SV.log(l_module_name, 'L_UPDATE_ALLOWED', l_update_allowed);
1968: END IF;
1969:
1970: IF NVL(l_update_allowed, 'N') = 'N' THEN

Line 2032: p_changed_detail IN WSH_USA_CATEGORIES_PVT.ChangedDetailRec,

2028:
2029: Procedure Update_Attributes(
2030: p_source_code IN VARCHAR2,
2031: p_attributes_rec IN WSH_INTERFACE.ChangedAttributeRecType,
2032: p_changed_detail IN WSH_USA_CATEGORIES_PVT.ChangedDetailRec,
2033: p_interface_flag IN VARCHAR2 , --bugfix 10175902
2034: x_return_status OUT NOCOPY VARCHAR2)
2035: IS
2036: