DBA Data[Home] [Help]

APPS.OZF_OFFER_PVT dependencies on QP_ATTR_MAPPING_PUB

Line 562: RETURN Qp_Attr_Mapping_Pub.t_multirecord

558: END LOOP;
559: END add_message;
560:
561: FUNCTION find_territories( aso_party_id IN NUMBER,oe_sold_to_org IN NUMBER)
562: RETURN Qp_Attr_Mapping_Pub.t_multirecord
563: IS
564:
565: l_multirecord Qp_Attr_Mapping_Pub.t_multirecord;
566:

Line 565: l_multirecord Qp_Attr_Mapping_Pub.t_multirecord;

561: FUNCTION find_territories( aso_party_id IN NUMBER,oe_sold_to_org IN NUMBER)
562: RETURN Qp_Attr_Mapping_Pub.t_multirecord
563: IS
564:
565: l_multirecord Qp_Attr_Mapping_Pub.t_multirecord;
566:
567: BEGIN
568:
569: oe_debug_pub.add('Before Calling OZF_QP_QUAL_PVT.Find_SA_Territories: ');

Line 582: RETURN Qp_Attr_Mapping_Pub.t_multirecord

578: END find_territories;
579:
580:
581: FUNCTION find_sections( aso_inventory_item_id IN NUMBER, oe_inventory_item_id IN NUMBER)
582: RETURN Qp_Attr_Mapping_Pub.t_multirecord
583: IS
584: p_inventory_item_id NUMBER;
585:
586: CURSOR cur_item_sections IS

Line 591: l_multirecord Qp_Attr_Mapping_Pub.t_multirecord;

587: SELECT jsi.section_id
588: FROM ibe_dsp_section_items jsi
589: WHERE jsi.inventory_item_id = p_inventory_item_id;
590:
591: l_multirecord Qp_Attr_Mapping_Pub.t_multirecord;
592: l_count NUMBER := 1;
593:
594: BEGIN
595: IF aso_inventory_item_id = Fnd_Api.g_miss_num THEN