DBA Data[Home] [Help]

APPS.OZF_OFFER_PVT dependencies on QP_ATTR_MAPPING_PUB

Line 471: RETURN Qp_Attr_Mapping_Pub.t_multirecord

467: END LOOP;
468: END add_message;
469:
470: FUNCTION find_territories( aso_party_id IN NUMBER,oe_sold_to_org IN NUMBER)
471: RETURN Qp_Attr_Mapping_Pub.t_multirecord
472: IS
473:
474: l_multirecord Qp_Attr_Mapping_Pub.t_multirecord;
475:

Line 474: l_multirecord Qp_Attr_Mapping_Pub.t_multirecord;

470: FUNCTION find_territories( aso_party_id IN NUMBER,oe_sold_to_org IN NUMBER)
471: RETURN Qp_Attr_Mapping_Pub.t_multirecord
472: IS
473:
474: l_multirecord Qp_Attr_Mapping_Pub.t_multirecord;
475:
476: BEGIN
477:
478: oe_debug_pub.add('Before Calling OZF_QP_QUAL_PVT.Find_SA_Territories: ');

Line 491: RETURN Qp_Attr_Mapping_Pub.t_multirecord

487: END find_territories;
488:
489:
490: FUNCTION find_sections( aso_inventory_item_id IN NUMBER, oe_inventory_item_id IN NUMBER)
491: RETURN Qp_Attr_Mapping_Pub.t_multirecord
492: IS
493: p_inventory_item_id NUMBER;
494:
495: CURSOR cur_item_sections IS

Line 500: l_multirecord Qp_Attr_Mapping_Pub.t_multirecord;

496: SELECT jsi.section_id
497: FROM ibe_dsp_section_items jsi
498: WHERE jsi.inventory_item_id = p_inventory_item_id;
499:
500: l_multirecord Qp_Attr_Mapping_Pub.t_multirecord;
501: l_count NUMBER := 1;
502:
503: BEGIN
504: IF aso_inventory_item_id = Fnd_Api.g_miss_num THEN