eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PON_TEAM_SCORING_UTIL_PVT dependencies on PON_AUCTION_HEADERS_ALL

Line 20: ,p_auction_header_id IN pon_auction_headers_all.auction_header_id%TYPE

16: --------------------------------------------------------------------------------
17:
18: PROCEDURE lock_scoring(
19: p_api_version IN NUMBER
20: ,p_auction_header_id IN pon_auction_headers_all.auction_header_id%TYPE
21: ,p_tpc_id IN pon_auction_headers_all.trading_partner_contact_id%TYPE
22: ,x_return_status OUT NOCOPY VARCHAR2
23: ,x_msg_data OUT NOCOPY VARCHAR2
24: ,x_msg_count OUT NOCOPY NUMBER

Line 21: ,p_tpc_id IN pon_auction_headers_all.trading_partner_contact_id%TYPE

17:
18: PROCEDURE lock_scoring(
19: p_api_version IN NUMBER
20: ,p_auction_header_id IN pon_auction_headers_all.auction_header_id%TYPE
21: ,p_tpc_id IN pon_auction_headers_all.trading_partner_contact_id%TYPE
22: ,x_return_status OUT NOCOPY VARCHAR2
23: ,x_msg_data OUT NOCOPY VARCHAR2
24: ,x_msg_count OUT NOCOPY NUMBER
25: ) IS

Line 60: UPDATE pon_auction_headers_all

56:
57: -- update auction header
58: l_stage := '30: update auction header';
59:
60: UPDATE pon_auction_headers_all
61: SET scoring_lock_date = SYSDATE
62: ,scoring_lock_tp_contact_id = p_tpc_id
63: ,last_update_date = SYSDATE
64: ,last_updated_by = fnd_global.user_id

Line 99: ,pon_auction_headers_all paha

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
103: AND paa.line_number = -1

Line 230: pon_auction_headers_all.auction_header_id%TYPE

226:
227: PROCEDURE delete_member_scores(
228: p_api_version IN NUMBER
229: ,p_auction_header_id IN
230: pon_auction_headers_all.auction_header_id%TYPE
231: ,p_team_id IN pon_scoring_teams.team_id%TYPE
232: ,p_user_id IN fnd_user.user_id%TYPE
233: ,x_return_status OUT NOCOPY VARCHAR2
234: ,x_msg_data OUT NOCOPY VARCHAR2

Line 336: pon_auction_headers_all.auction_header_id%TYPE

332:
333: PROCEDURE delete_team_scores(
334: p_api_version IN NUMBER
335: ,p_auction_header_id IN
336: pon_auction_headers_all.auction_header_id%TYPE
337: ,p_team_id IN pon_scoring_teams.team_id%TYPE
338: ,x_return_status OUT NOCOPY VARCHAR2
339: ,x_msg_data OUT NOCOPY VARCHAR2
340: ,x_msg_count OUT NOCOPY NUMBER

Line 455: pon_auction_headers_all.auction_header_id%TYPE

451:
452: PROCEDURE delete_subjective_scores(
453: p_api_version IN NUMBER
454: ,p_auction_header_id IN
455: pon_auction_headers_all.auction_header_id%TYPE
456: ,x_return_status OUT NOCOPY VARCHAR2
457: ,x_msg_data OUT NOCOPY VARCHAR2
458: ,x_msg_count OUT NOCOPY NUMBER
459: )IS

Line 624: ,p_auction_header_id IN pon_auction_headers_all.auction_header_id%TYPE

620: --- unlock_scoring --
621: --------------------------------------------------------------------------------
622: PROCEDURE unlock_scoring(
623: p_api_version IN NUMBER
624: ,p_auction_header_id IN pon_auction_headers_all.auction_header_id%TYPE
625: ,p_tpc_id IN pon_auction_headers_all.trading_partner_contact_id%TYPE
626: ,x_return_status OUT NOCOPY VARCHAR2
627: ,x_msg_data OUT NOCOPY VARCHAR2
628: ,x_msg_count OUT NOCOPY NUMBER

Line 625: ,p_tpc_id IN pon_auction_headers_all.trading_partner_contact_id%TYPE

621: --------------------------------------------------------------------------------
622: PROCEDURE unlock_scoring(
623: p_api_version IN NUMBER
624: ,p_auction_header_id IN pon_auction_headers_all.auction_header_id%TYPE
625: ,p_tpc_id IN pon_auction_headers_all.trading_partner_contact_id%TYPE
626: ,x_return_status OUT NOCOPY VARCHAR2
627: ,x_msg_data OUT NOCOPY VARCHAR2
628: ,x_msg_count OUT NOCOPY NUMBER
629: ) IS

Line 664: UPDATE pon_auction_headers_all

660:
661: -- update auction header
662: l_stage := '30: update auction header';
663:
664: UPDATE pon_auction_headers_all
665: SET scoring_lock_date = null
666: ,scoring_lock_tp_contact_id = p_tpc_id
667: ,last_update_date = SYSDATE
668: ,last_updated_by = fnd_global.user_id

Line 691: FROM pon_auction_attributes paa, pon_auction_headers_all paha, pon_auction_sections pas

687: WHERE auction_header_id = p_auction_header_id
688: AND line_number = -1
689: AND sequence_number IN
690: (SELECT paa.sequence_number
691: FROM pon_auction_attributes paa, pon_auction_headers_all paha, pon_auction_sections pas
692: WHERE paa.auction_header_id = p_auction_header_id
693: AND paa.attribute_list_id = -1
694: AND paa.line_number = -1
695: AND paa.scoring_method = 'MANUAL'