11: ---------------------------------------------------------------------
12:
13: PROCEDURE Get_Mkt_Segments_W ( p_party_id ams_party_market_segments.party_id%TYPE := NULL ,
14: p_target_segment_id ams_party_market_segments.market_segment_id%TYPE := NULL,
15: x_PartyMktSegTabTyp OUT AMS_MKT_SEGMENTS_PVT.PartyMktSegTabTyp) IS
16: -- RETURN AMS_MKT_SEGMENTS_PVT.PartyMktSegTabTyp IS
17:
18: -- x_PartyMktSegTabTyp AMS_MKT_SEGMENTS_PVT.PartyMktSegTabTyp;
19:
12:
13: PROCEDURE Get_Mkt_Segments_W ( p_party_id ams_party_market_segments.party_id%TYPE := NULL ,
14: p_target_segment_id ams_party_market_segments.market_segment_id%TYPE := NULL,
15: x_PartyMktSegTabTyp OUT AMS_MKT_SEGMENTS_PVT.PartyMktSegTabTyp) IS
16: -- RETURN AMS_MKT_SEGMENTS_PVT.PartyMktSegTabTyp IS
17:
18: -- x_PartyMktSegTabTyp AMS_MKT_SEGMENTS_PVT.PartyMktSegTabTyp;
19:
20:
14: p_target_segment_id ams_party_market_segments.market_segment_id%TYPE := NULL,
15: x_PartyMktSegTabTyp OUT AMS_MKT_SEGMENTS_PVT.PartyMktSegTabTyp) IS
16: -- RETURN AMS_MKT_SEGMENTS_PVT.PartyMktSegTabTyp IS
17:
18: -- x_PartyMktSegTabTyp AMS_MKT_SEGMENTS_PVT.PartyMktSegTabTyp;
19:
20:
21: BEGIN
22: