DBA Data[Home] [Help]

APPS.ASO_PRICING_CORE_PVT dependencies on ASO_VALIDATE_PVT

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

806: SET aso.ship_method_code = l_req_ship_method_code
807: WHERE quote_header_id = p_quote_header_id
808: AND (p_quote_header_id IS NOT NULL AND p_quote_header_id <> FND_API.G_MISS_NUM)
809: AND quote_line_id IS NULL
810: AND ('S' = (ASO_VALIDATE_PVT.Validate_ShipMethods('T', l_req_ship_method_code,
811: aso.ship_from_org_id, p_quote_header_id, NULL)));
812: END IF;
813: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
814: aso_debug_pub.add('ASO_PRICING_CORE_PVT: No of Ship Method Code Rows Updated : '||sql%ROWCOUNT,1,'Y');

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

1234: AND (p_quote_header_id IS NOT NULL AND p_quote_header_id <> FND_API.G_MISS_NUM)
1235: AND aso.quote_line_id = l_qte_ln_rec.quote_line_id
1236: AND (l_qte_ln_rec.quote_line_id IS NOT NULL AND l_qte_ln_rec.quote_line_id <> FND_API.G_MISS_NUM)
1237: AND aso.quote_line_id IS NOT NULL
1238: AND ('S' = (ASO_VALIDATE_PVT.Validate_ShipMethods('T', l_req_ship_method_code,
1239: aso.ship_from_org_id, p_quote_header_id, l_qte_ln_rec.quote_line_id)));
1240: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1241: aso_debug_pub.add('ASO_PRICING_CORE_PVT: No of Ship Method Code Rows Updated : '||sql%ROWCOUNT,1,'Y');
1242: END IF;

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

1444: AND (p_quote_header_id IS NOT NULL AND p_quote_header_id <> FND_API.G_MISS_NUM)
1445: AND aso.quote_line_id = l_qte_ln_rec.quote_line_id
1446: AND (l_qte_ln_rec.quote_line_id IS NOT NULL AND l_qte_ln_rec.quote_line_id <> FND_API.G_MISS_NUM)
1447: AND aso.quote_line_id IS NOT NULL
1448: AND ('S' = (ASO_VALIDATE_PVT.Validate_ShipMethods('T', l_req_ship_method_code,
1449: aso.ship_from_org_id, p_quote_header_id, l_qte_ln_rec.quote_line_id)));
1450: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1451: aso_debug_pub.add('ASO_PRICING_CORE_PVT: No of Ship Method Code Rows Updated : '||sql%ROWCOUNT,1,'Y');
1452: END IF;