932: l_api_return_status NUMBER;
933: l_api_msg_count NUMBER;
934: l_api_msg_data VARCHAR2(2000);
935: TYPE DirectItemRec IS RECORD (
936: wip_entity_id eam_direct_item_recs_v.wip_entity_id%TYPE,
937: organization_id eam_direct_item_recs_v.organization_id%TYPE,
938: task_number eam_direct_item_recs_v.task_number%TYPE,
939: inventory_item_id eam_direct_item_recs_v.inventory_item_id%TYPE,
940: direct_item_sequence_id eam_direct_item_recs_v.direct_item_sequence_id%TYPE,
933: l_api_msg_count NUMBER;
934: l_api_msg_data VARCHAR2(2000);
935: TYPE DirectItemRec IS RECORD (
936: wip_entity_id eam_direct_item_recs_v.wip_entity_id%TYPE,
937: organization_id eam_direct_item_recs_v.organization_id%TYPE,
938: task_number eam_direct_item_recs_v.task_number%TYPE,
939: inventory_item_id eam_direct_item_recs_v.inventory_item_id%TYPE,
940: direct_item_sequence_id eam_direct_item_recs_v.direct_item_sequence_id%TYPE,
941: direct_item_type_id eam_direct_item_recs_v.direct_item_type_id%TYPE,
934: l_api_msg_data VARCHAR2(2000);
935: TYPE DirectItemRec IS RECORD (
936: wip_entity_id eam_direct_item_recs_v.wip_entity_id%TYPE,
937: organization_id eam_direct_item_recs_v.organization_id%TYPE,
938: task_number eam_direct_item_recs_v.task_number%TYPE,
939: inventory_item_id eam_direct_item_recs_v.inventory_item_id%TYPE,
940: direct_item_sequence_id eam_direct_item_recs_v.direct_item_sequence_id%TYPE,
941: direct_item_type_id eam_direct_item_recs_v.direct_item_type_id%TYPE,
942: description eam_direct_item_recs_v.description%TYPE,
935: TYPE DirectItemRec IS RECORD (
936: wip_entity_id eam_direct_item_recs_v.wip_entity_id%TYPE,
937: organization_id eam_direct_item_recs_v.organization_id%TYPE,
938: task_number eam_direct_item_recs_v.task_number%TYPE,
939: inventory_item_id eam_direct_item_recs_v.inventory_item_id%TYPE,
940: direct_item_sequence_id eam_direct_item_recs_v.direct_item_sequence_id%TYPE,
941: direct_item_type_id eam_direct_item_recs_v.direct_item_type_id%TYPE,
942: description eam_direct_item_recs_v.description%TYPE,
943: required_quantity eam_direct_item_recs_v.required_quantity%TYPE,
936: wip_entity_id eam_direct_item_recs_v.wip_entity_id%TYPE,
937: organization_id eam_direct_item_recs_v.organization_id%TYPE,
938: task_number eam_direct_item_recs_v.task_number%TYPE,
939: inventory_item_id eam_direct_item_recs_v.inventory_item_id%TYPE,
940: direct_item_sequence_id eam_direct_item_recs_v.direct_item_sequence_id%TYPE,
941: direct_item_type_id eam_direct_item_recs_v.direct_item_type_id%TYPE,
942: description eam_direct_item_recs_v.description%TYPE,
943: required_quantity eam_direct_item_recs_v.required_quantity%TYPE,
944: unit_price eam_direct_item_recs_v.unit_price%TYPE,
937: organization_id eam_direct_item_recs_v.organization_id%TYPE,
938: task_number eam_direct_item_recs_v.task_number%TYPE,
939: inventory_item_id eam_direct_item_recs_v.inventory_item_id%TYPE,
940: direct_item_sequence_id eam_direct_item_recs_v.direct_item_sequence_id%TYPE,
941: direct_item_type_id eam_direct_item_recs_v.direct_item_type_id%TYPE,
942: description eam_direct_item_recs_v.description%TYPE,
943: required_quantity eam_direct_item_recs_v.required_quantity%TYPE,
944: unit_price eam_direct_item_recs_v.unit_price%TYPE,
945: uom_code eam_direct_item_recs_v.uom_code%TYPE,
938: task_number eam_direct_item_recs_v.task_number%TYPE,
939: inventory_item_id eam_direct_item_recs_v.inventory_item_id%TYPE,
940: direct_item_sequence_id eam_direct_item_recs_v.direct_item_sequence_id%TYPE,
941: direct_item_type_id eam_direct_item_recs_v.direct_item_type_id%TYPE,
942: description eam_direct_item_recs_v.description%TYPE,
943: required_quantity eam_direct_item_recs_v.required_quantity%TYPE,
944: unit_price eam_direct_item_recs_v.unit_price%TYPE,
945: uom_code eam_direct_item_recs_v.uom_code%TYPE,
946: purchasing_category_id eam_direct_item_recs_v.purchasing_category_id%TYPE,
939: inventory_item_id eam_direct_item_recs_v.inventory_item_id%TYPE,
940: direct_item_sequence_id eam_direct_item_recs_v.direct_item_sequence_id%TYPE,
941: direct_item_type_id eam_direct_item_recs_v.direct_item_type_id%TYPE,
942: description eam_direct_item_recs_v.description%TYPE,
943: required_quantity eam_direct_item_recs_v.required_quantity%TYPE,
944: unit_price eam_direct_item_recs_v.unit_price%TYPE,
945: uom_code eam_direct_item_recs_v.uom_code%TYPE,
946: purchasing_category_id eam_direct_item_recs_v.purchasing_category_id%TYPE,
947: date_required eam_direct_item_recs_v.date_required%TYPE,
940: direct_item_sequence_id eam_direct_item_recs_v.direct_item_sequence_id%TYPE,
941: direct_item_type_id eam_direct_item_recs_v.direct_item_type_id%TYPE,
942: description eam_direct_item_recs_v.description%TYPE,
943: required_quantity eam_direct_item_recs_v.required_quantity%TYPE,
944: unit_price eam_direct_item_recs_v.unit_price%TYPE,
945: uom_code eam_direct_item_recs_v.uom_code%TYPE,
946: purchasing_category_id eam_direct_item_recs_v.purchasing_category_id%TYPE,
947: date_required eam_direct_item_recs_v.date_required%TYPE,
948: auto_request_material eam_direct_item_recs_v.auto_request_material%TYPE,
941: direct_item_type_id eam_direct_item_recs_v.direct_item_type_id%TYPE,
942: description eam_direct_item_recs_v.description%TYPE,
943: required_quantity eam_direct_item_recs_v.required_quantity%TYPE,
944: unit_price eam_direct_item_recs_v.unit_price%TYPE,
945: uom_code eam_direct_item_recs_v.uom_code%TYPE,
946: purchasing_category_id eam_direct_item_recs_v.purchasing_category_id%TYPE,
947: date_required eam_direct_item_recs_v.date_required%TYPE,
948: auto_request_material eam_direct_item_recs_v.auto_request_material%TYPE,
949: suggested_vendor_id eam_direct_item_recs_v.suggested_vendor_id%TYPE,
942: description eam_direct_item_recs_v.description%TYPE,
943: required_quantity eam_direct_item_recs_v.required_quantity%TYPE,
944: unit_price eam_direct_item_recs_v.unit_price%TYPE,
945: uom_code eam_direct_item_recs_v.uom_code%TYPE,
946: purchasing_category_id eam_direct_item_recs_v.purchasing_category_id%TYPE,
947: date_required eam_direct_item_recs_v.date_required%TYPE,
948: auto_request_material eam_direct_item_recs_v.auto_request_material%TYPE,
949: suggested_vendor_id eam_direct_item_recs_v.suggested_vendor_id%TYPE,
950: suggested_vendor_name eam_direct_item_recs_v.suggested_vendor_name%TYPE,
943: required_quantity eam_direct_item_recs_v.required_quantity%TYPE,
944: unit_price eam_direct_item_recs_v.unit_price%TYPE,
945: uom_code eam_direct_item_recs_v.uom_code%TYPE,
946: purchasing_category_id eam_direct_item_recs_v.purchasing_category_id%TYPE,
947: date_required eam_direct_item_recs_v.date_required%TYPE,
948: auto_request_material eam_direct_item_recs_v.auto_request_material%TYPE,
949: suggested_vendor_id eam_direct_item_recs_v.suggested_vendor_id%TYPE,
950: suggested_vendor_name eam_direct_item_recs_v.suggested_vendor_name%TYPE,
951: suggested_vendor_site eam_direct_item_recs_v.suggested_vendor_site%TYPE,
944: unit_price eam_direct_item_recs_v.unit_price%TYPE,
945: uom_code eam_direct_item_recs_v.uom_code%TYPE,
946: purchasing_category_id eam_direct_item_recs_v.purchasing_category_id%TYPE,
947: date_required eam_direct_item_recs_v.date_required%TYPE,
948: auto_request_material eam_direct_item_recs_v.auto_request_material%TYPE,
949: suggested_vendor_id eam_direct_item_recs_v.suggested_vendor_id%TYPE,
950: suggested_vendor_name eam_direct_item_recs_v.suggested_vendor_name%TYPE,
951: suggested_vendor_site eam_direct_item_recs_v.suggested_vendor_site%TYPE,
952: suggested_vendor_phone eam_direct_item_recs_v.suggested_vendor_phone%TYPE,
945: uom_code eam_direct_item_recs_v.uom_code%TYPE,
946: purchasing_category_id eam_direct_item_recs_v.purchasing_category_id%TYPE,
947: date_required eam_direct_item_recs_v.date_required%TYPE,
948: auto_request_material eam_direct_item_recs_v.auto_request_material%TYPE,
949: suggested_vendor_id eam_direct_item_recs_v.suggested_vendor_id%TYPE,
950: suggested_vendor_name eam_direct_item_recs_v.suggested_vendor_name%TYPE,
951: suggested_vendor_site eam_direct_item_recs_v.suggested_vendor_site%TYPE,
952: suggested_vendor_phone eam_direct_item_recs_v.suggested_vendor_phone%TYPE,
953: suggested_vendor_item_num eam_direct_item_recs_v.suggested_vendor_item_num%TYPE );
946: purchasing_category_id eam_direct_item_recs_v.purchasing_category_id%TYPE,
947: date_required eam_direct_item_recs_v.date_required%TYPE,
948: auto_request_material eam_direct_item_recs_v.auto_request_material%TYPE,
949: suggested_vendor_id eam_direct_item_recs_v.suggested_vendor_id%TYPE,
950: suggested_vendor_name eam_direct_item_recs_v.suggested_vendor_name%TYPE,
951: suggested_vendor_site eam_direct_item_recs_v.suggested_vendor_site%TYPE,
952: suggested_vendor_phone eam_direct_item_recs_v.suggested_vendor_phone%TYPE,
953: suggested_vendor_item_num eam_direct_item_recs_v.suggested_vendor_item_num%TYPE );
954:
947: date_required eam_direct_item_recs_v.date_required%TYPE,
948: auto_request_material eam_direct_item_recs_v.auto_request_material%TYPE,
949: suggested_vendor_id eam_direct_item_recs_v.suggested_vendor_id%TYPE,
950: suggested_vendor_name eam_direct_item_recs_v.suggested_vendor_name%TYPE,
951: suggested_vendor_site eam_direct_item_recs_v.suggested_vendor_site%TYPE,
952: suggested_vendor_phone eam_direct_item_recs_v.suggested_vendor_phone%TYPE,
953: suggested_vendor_item_num eam_direct_item_recs_v.suggested_vendor_item_num%TYPE );
954:
955: TYPE l_di_recs_type IS REF CURSOR RETURN DirectItemRec;
948: auto_request_material eam_direct_item_recs_v.auto_request_material%TYPE,
949: suggested_vendor_id eam_direct_item_recs_v.suggested_vendor_id%TYPE,
950: suggested_vendor_name eam_direct_item_recs_v.suggested_vendor_name%TYPE,
951: suggested_vendor_site eam_direct_item_recs_v.suggested_vendor_site%TYPE,
952: suggested_vendor_phone eam_direct_item_recs_v.suggested_vendor_phone%TYPE,
953: suggested_vendor_item_num eam_direct_item_recs_v.suggested_vendor_item_num%TYPE );
954:
955: TYPE l_di_recs_type IS REF CURSOR RETURN DirectItemRec;
956: l_di_recs l_di_recs_type;
949: suggested_vendor_id eam_direct_item_recs_v.suggested_vendor_id%TYPE,
950: suggested_vendor_name eam_direct_item_recs_v.suggested_vendor_name%TYPE,
951: suggested_vendor_site eam_direct_item_recs_v.suggested_vendor_site%TYPE,
952: suggested_vendor_phone eam_direct_item_recs_v.suggested_vendor_phone%TYPE,
953: suggested_vendor_item_num eam_direct_item_recs_v.suggested_vendor_item_num%TYPE );
954:
955: TYPE l_di_recs_type IS REF CURSOR RETURN DirectItemRec;
956: l_di_recs l_di_recs_type;
957: l_di_record l_di_recs%ROWTYPE;