274: AND attribute_sequence_number IN
275: (SELECT paa.sequence_number
276: FROM pon_auction_attributes paa
277: ,pon_auction_sections pas
278: ,pon_scoring_team_sections psts
279: WHERE paa.auction_header_id = pas.auction_header_id
280: AND paa.attr_group_seq_number = pas.attr_group_seq_number
281: AND pas.auction_header_id = psts.auction_header_id
282: AND pas.section_id = psts.section_id
375: AND (user_id, attribute_sequence_number) IN
376: (SELECT pstm.user_id, paa.sequence_number
377: FROM pon_auction_attributes paa
378: ,pon_auction_sections pas
379: ,pon_scoring_team_sections psts
380: ,pon_scoring_team_members pstm
381: WHERE paa.auction_header_id = pas.auction_header_id
382: AND paa.attr_group_seq_number = pas.attr_group_seq_number
383: AND paa.attribute_list_id = -1
543: --------------------------------------------------------------------------------
544:
545: PROCEDURE delete_section_assignment(
546: p_api_version IN NUMBER
547: ,p_auction_header_id IN pon_scoring_team_sections.auction_header_id%TYPE
548: ,p_section_id IN pon_scoring_team_sections.section_id%TYPE
549: ,x_return_status OUT NOCOPY VARCHAR2
550: ,x_msg_data OUT NOCOPY VARCHAR2
551: ,x_msg_count OUT NOCOPY NUMBER
544:
545: PROCEDURE delete_section_assignment(
546: p_api_version IN NUMBER
547: ,p_auction_header_id IN pon_scoring_team_sections.auction_header_id%TYPE
548: ,p_section_id IN pon_scoring_team_sections.section_id%TYPE
549: ,x_return_status OUT NOCOPY VARCHAR2
550: ,x_msg_data OUT NOCOPY VARCHAR2
551: ,x_msg_count OUT NOCOPY NUMBER
552: )IS
580: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
581: END IF;
582:
583: -- delete the section assignment row
584: DELETE FROM pon_scoring_team_sections
585: WHERE auction_header_id = p_auction_header_id
586: AND section_id = p_section_id;
587:
588: