APPS.PON_TEAM_SCORING_UTIL_PVT dependencies on PON_BID_ATTRIBUTE_VALUES

Line 72: l_stage := '35: update the pon bid attribute values table';

68: IF SQL%NOTFOUND THEN
69: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
70: END IF;
71:
72: l_stage := '35: update the pon bid attribute values table';
73: MERGE
74: INTO pon_bid_attribute_values pbav
75: USING
76: (

Line 74: INTO pon_bid_attribute_values pbav

70: END IF;
71:
72: l_stage := '35: update the pon bid attribute values table';
73: MERGE
74: INTO pon_bid_attribute_values pbav
75: USING
76: (
77: SELECT
78: ptmas.auction_header_id

Line 493: UPDATE pon_bid_attribute_values pbav

489:
490: -- if scores exist for manually scored attributes
491: -- update them to zero for this auction for all active bids
492: -- so that teams can start scoring
493: UPDATE pon_bid_attribute_values pbav
494: SET score = 0,
495: weighted_score = 0
496: WHERE pbav.auction_header_id = p_auction_header_id
497: AND pbav.auction_line_number = -1

Line 676: l_stage := '35: update the pon bid attribute values table';

672: IF SQL%NOTFOUND THEN
673: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
674: END IF;
675:
676: l_stage := '35: update the pon bid attribute values table';
677:
678: -- Wipe out the score data for all manually scored attributes if
679: -- scoring is unlocked
680:

Line 681: UPDATE pon_bid_attribute_values

677:
678: -- Wipe out the score data for all manually scored attributes if
679: -- scoring is unlocked
680:
681: UPDATE pon_bid_attribute_values
682: SET score = NULL
683: ,internal_note = NULL
684: ,weighted_score = NULL
685: ,last_update_date = SYSDATE