196: --
197: -- Pre-reqs: None
198: --
199: -- Function: This procedure deletes the section assignement from the
200: -- pon_scoring_team_sections on section deletion during either create or manage
201: -- flow.
202: --
203: --
204: -- IN Parameters:
220: --------------------------------------------------------------------------------
221:
222: PROCEDURE delete_section_assignment(
223: p_api_version IN NUMBER
224: ,p_auction_header_id IN pon_scoring_team_sections.auction_header_id%TYPE
225: ,p_section_id IN pon_scoring_team_sections.section_id%TYPE
226: ,x_return_status OUT NOCOPY VARCHAR2
227: ,x_msg_data OUT NOCOPY VARCHAR2
228: ,x_msg_count OUT NOCOPY NUMBER
221:
222: PROCEDURE delete_section_assignment(
223: p_api_version IN NUMBER
224: ,p_auction_header_id IN pon_scoring_team_sections.auction_header_id%TYPE
225: ,p_section_id IN pon_scoring_team_sections.section_id%TYPE
226: ,x_return_status OUT NOCOPY VARCHAR2
227: ,x_msg_data OUT NOCOPY VARCHAR2
228: ,x_msg_count OUT NOCOPY NUMBER
229: );