DBA Data[Home] [Help]

APPS.ASO_PRICING_CORE_PVT dependencies on ASO_VALIDATE_PVT

Line 825: AND ('S' = (ASO_VALIDATE_PVT.Validate_ShipMethods('T', l_req_ship_method_code,

821: SET aso.ship_method_code = l_req_ship_method_code
822: WHERE quote_header_id = p_quote_header_id
823: AND (p_quote_header_id IS NOT NULL AND p_quote_header_id <> FND_API.G_MISS_NUM)
824: AND quote_line_id IS NULL
825: AND ('S' = (ASO_VALIDATE_PVT.Validate_ShipMethods('T', l_req_ship_method_code,
826: aso.ship_from_org_id, p_quote_header_id, NULL)));
827: END IF;
828: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
829: aso_debug_pub.add('ASO_PRICING_CORE_PVT: No of Ship Method Code Rows Updated : '||sql%ROWCOUNT,1,'Y');

Line 1253: AND ('S' = (ASO_VALIDATE_PVT.Validate_ShipMethods('T', l_req_ship_method_code,

1249: AND (p_quote_header_id IS NOT NULL AND p_quote_header_id <> FND_API.G_MISS_NUM)
1250: AND aso.quote_line_id = l_qte_ln_rec.quote_line_id
1251: AND (l_qte_ln_rec.quote_line_id IS NOT NULL AND l_qte_ln_rec.quote_line_id <> FND_API.G_MISS_NUM)
1252: AND aso.quote_line_id IS NOT NULL
1253: AND ('S' = (ASO_VALIDATE_PVT.Validate_ShipMethods('T', l_req_ship_method_code,
1254: aso.ship_from_org_id, p_quote_header_id, l_qte_ln_rec.quote_line_id)));
1255: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1256: aso_debug_pub.add('ASO_PRICING_CORE_PVT: No of Ship Method Code Rows Updated : '||sql%ROWCOUNT,1,'Y');
1257: END IF;

Line 1463: AND ('S' = (ASO_VALIDATE_PVT.Validate_ShipMethods('T', l_req_ship_method_code,

1459: AND (p_quote_header_id IS NOT NULL AND p_quote_header_id <> FND_API.G_MISS_NUM)
1460: AND aso.quote_line_id = l_qte_ln_rec.quote_line_id
1461: AND (l_qte_ln_rec.quote_line_id IS NOT NULL AND l_qte_ln_rec.quote_line_id <> FND_API.G_MISS_NUM)
1462: AND aso.quote_line_id IS NOT NULL
1463: AND ('S' = (ASO_VALIDATE_PVT.Validate_ShipMethods('T', l_req_ship_method_code,
1464: aso.ship_from_org_id, p_quote_header_id, l_qte_ln_rec.quote_line_id)));
1465: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1466: aso_debug_pub.add('ASO_PRICING_CORE_PVT: No of Ship Method Code Rows Updated : '||sql%ROWCOUNT,1,'Y');
1467: END IF;