12:
13: FUNCTION Get_Mkt_Segments ( 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:
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:
16: RETURN AMS_MKT_SEGMENTS_PVT.PartyMktSegTabTyp IS
17:
18: x_PartyMktSegTabTyp AMS_MKT_SEGMENTS_PVT.PartyMktSegTabTyp;
19:
20:
21: BEGIN
22:
19:
20:
21: BEGIN
22:
23: x_PartyMktSegTabTyp := AMS_MKT_SEGMENTS_PVT.Get_Mkt_Segments( p_party_id => p_party_id,
24: p_target_segment_id => p_target_segment_id);
25:
26: RETURN ( x_PartyMktSegTabTyp);
27: END ;