APPS.OE_CONTRACT_UTIL dependencies on OE_PRICING_CONTRACTS

Line 585: UPDATE OE_PRICING_CONTRACTS

581: )
582: IS
583: BEGIN
584:
585: UPDATE OE_PRICING_CONTRACTS
586: SET AGREEMENT_ID = p_Contract_rec.agreement_id
587: , ATTRIBUTE1 = p_Contract_rec.attribute1
588: , ATTRIBUTE10 = p_Contract_rec.attribute10
589: , ATTRIBUTE11 = p_Contract_rec.attribute11

Line 640: INSERT INTO OE_PRICING_CONTRACTS

636: BEGIN
637:
638: oe_debug_pub.add('Entering OE_Contract_Util.Insert_Row');
639:
640: INSERT INTO OE_PRICING_CONTRACTS
641: ( AGREEMENT_ID
642: , ATTRIBUTE1
643: , ATTRIBUTE10
644: , ATTRIBUTE11

Line 721: DELETE FROM OE_PRICING_CONTRACTS

717: )
718: IS
719: BEGIN
720:
721: DELETE FROM OE_PRICING_CONTRACTS
722: WHERE PRICING_CONTRACT_ID = p_pricing_contract_id
723: ;
724:
725: EXCEPTION

Line 800: FROM OE_PRICING_CONTRACTS

796: , l_Contract_rec.last_update_date
797: , l_Contract_rec.last_update_login
798: , l_Contract_rec.price_list_id
799: , l_Contract_rec.pricing_contract_id
800: FROM OE_PRICING_CONTRACTS
801: WHERE PRICING_CONTRACT_ID = p_pricing_contract_id
802: ;
803:
804: RETURN l_Contract_rec;

Line 884: FROM OE_PRICING_CONTRACTS

880: , l_Contract_rec.last_update_date
881: , l_Contract_rec.last_update_login
882: , l_Contract_rec.price_list_id
883: , l_Contract_rec.pricing_contract_id
884: FROM OE_PRICING_CONTRACTS
885: WHERE PRICING_CONTRACT_ID = p_Contract_rec.pricing_contract_id
886: FOR UPDATE NOWAIT;
887:
888: -- Row locked. Compare IN attributes to DB attributes.