APPS.PON_TEAM_SCORING_UTIL_PVT dependencies on PON_BID_HEADERS

Line 98: ,pon_bid_headers pbh

94: ,null old_value
95: FROM pon_team_member_attr_scores ptmas
96: ,pon_auction_attributes paa
97: ,pon_team_member_bid_scores ptmbs
98: ,pon_bid_headers pbh
99: ,pon_auction_headers_all paha
100: ,pon_auction_sections pas
101: WHERE ptmas.auction_header_id = p_auction_header_id
102: AND ptmas.auction_header_id = paa.auction_header_id

Line 509: FROM pon_bid_headers pbh

505: AND paa.scoring_method = 'MANUAL')
506: AND pbav.bid_number IN
507: (SELECT --only active bids for this auction
508: pbh.bid_number
509: FROM pon_bid_headers pbh
510: WHERE pbh.auction_header_id = pbav.auction_header_id
511: AND pbh.bid_status = 'ACTIVE');
512:
513:

Line 705: l_stage := '40: update the pon bid headers table';

701: AND (NVL(paha.two_part_flag,'N') = 'N' OR -- Non 2 Stage negotiations
702: (paha.two_part_flag = 'Y' AND paha.sealed_auction_status = 'LOCKED') OR -- 2 Stage negotiations in technical phase
703: (paha.two_part_flag = 'Y' AND paha.sealed_auction_status <> 'LOCKED' AND pas.two_part_section_type = 'COMMERCIAL'))); --2 stage negotiations in commercial phase will clear only commercial scores
704:
705: l_stage := '40: update the pon bid headers table';
706:
707: UPDATE pon_bid_headers
708: SET score_overriden_flag = NULL
709: ,score_overriden_date = NULL

Line 707: UPDATE pon_bid_headers

703: (paha.two_part_flag = 'Y' AND paha.sealed_auction_status <> 'LOCKED' AND pas.two_part_section_type = 'COMMERCIAL'))); --2 stage negotiations in commercial phase will clear only commercial scores
704:
705: l_stage := '40: update the pon bid headers table';
706:
707: UPDATE pon_bid_headers
708: SET score_overriden_flag = NULL
709: ,score_overriden_date = NULL
710: ,score_override_tp_contact_id = NULL
711: ,last_update_date = SYSDATE