[Home] [Help]
647: l_api_return_status NUMBER;
648: l_api_msg_count NUMBER;
649: l_api_msg_data VARCHAR2(2000);
650: TYPE DirectItemRec IS RECORD (
651: wip_entity_id eam_direct_item_recs_v.wip_entity_id%TYPE,
652: organization_id eam_direct_item_recs_v.organization_id%TYPE,
653: task_number eam_direct_item_recs_v.task_number%TYPE,
654: inventory_item_id eam_direct_item_recs_v.inventory_item_id%TYPE,
655: direct_item_sequence_id eam_direct_item_recs_v.direct_item_sequence_id%TYPE,
648: l_api_msg_count NUMBER;
649: l_api_msg_data VARCHAR2(2000);
650: TYPE DirectItemRec IS RECORD (
651: wip_entity_id eam_direct_item_recs_v.wip_entity_id%TYPE,
652: organization_id eam_direct_item_recs_v.organization_id%TYPE,
653: task_number eam_direct_item_recs_v.task_number%TYPE,
654: inventory_item_id eam_direct_item_recs_v.inventory_item_id%TYPE,
655: direct_item_sequence_id eam_direct_item_recs_v.direct_item_sequence_id%TYPE,
656: direct_item_type_id eam_direct_item_recs_v.direct_item_type_id%TYPE,
649: l_api_msg_data VARCHAR2(2000);
650: TYPE DirectItemRec IS RECORD (
651: wip_entity_id eam_direct_item_recs_v.wip_entity_id%TYPE,
652: organization_id eam_direct_item_recs_v.organization_id%TYPE,
653: task_number eam_direct_item_recs_v.task_number%TYPE,
654: inventory_item_id eam_direct_item_recs_v.inventory_item_id%TYPE,
655: direct_item_sequence_id eam_direct_item_recs_v.direct_item_sequence_id%TYPE,
656: direct_item_type_id eam_direct_item_recs_v.direct_item_type_id%TYPE,
657: description eam_direct_item_recs_v.description%TYPE,
650: TYPE DirectItemRec IS RECORD (
651: wip_entity_id eam_direct_item_recs_v.wip_entity_id%TYPE,
652: organization_id eam_direct_item_recs_v.organization_id%TYPE,
653: task_number eam_direct_item_recs_v.task_number%TYPE,
654: inventory_item_id eam_direct_item_recs_v.inventory_item_id%TYPE,
655: direct_item_sequence_id eam_direct_item_recs_v.direct_item_sequence_id%TYPE,
656: direct_item_type_id eam_direct_item_recs_v.direct_item_type_id%TYPE,
657: description eam_direct_item_recs_v.description%TYPE,
658: required_quantity eam_direct_item_recs_v.required_quantity%TYPE,
651: wip_entity_id eam_direct_item_recs_v.wip_entity_id%TYPE,
652: organization_id eam_direct_item_recs_v.organization_id%TYPE,
653: task_number eam_direct_item_recs_v.task_number%TYPE,
654: inventory_item_id eam_direct_item_recs_v.inventory_item_id%TYPE,
655: direct_item_sequence_id eam_direct_item_recs_v.direct_item_sequence_id%TYPE,
656: direct_item_type_id eam_direct_item_recs_v.direct_item_type_id%TYPE,
657: description eam_direct_item_recs_v.description%TYPE,
658: required_quantity eam_direct_item_recs_v.required_quantity%TYPE,
659: unit_price eam_direct_item_recs_v.unit_price%TYPE,
652: organization_id eam_direct_item_recs_v.organization_id%TYPE,
653: task_number eam_direct_item_recs_v.task_number%TYPE,
654: inventory_item_id eam_direct_item_recs_v.inventory_item_id%TYPE,
655: direct_item_sequence_id eam_direct_item_recs_v.direct_item_sequence_id%TYPE,
656: direct_item_type_id eam_direct_item_recs_v.direct_item_type_id%TYPE,
657: description eam_direct_item_recs_v.description%TYPE,
658: required_quantity eam_direct_item_recs_v.required_quantity%TYPE,
659: unit_price eam_direct_item_recs_v.unit_price%TYPE,
660: uom_code eam_direct_item_recs_v.uom_code%TYPE,
653: task_number eam_direct_item_recs_v.task_number%TYPE,
654: inventory_item_id eam_direct_item_recs_v.inventory_item_id%TYPE,
655: direct_item_sequence_id eam_direct_item_recs_v.direct_item_sequence_id%TYPE,
656: direct_item_type_id eam_direct_item_recs_v.direct_item_type_id%TYPE,
657: description eam_direct_item_recs_v.description%TYPE,
658: required_quantity eam_direct_item_recs_v.required_quantity%TYPE,
659: unit_price eam_direct_item_recs_v.unit_price%TYPE,
660: uom_code eam_direct_item_recs_v.uom_code%TYPE,
661: purchasing_category_id eam_direct_item_recs_v.purchasing_category_id%TYPE,
654: inventory_item_id eam_direct_item_recs_v.inventory_item_id%TYPE,
655: direct_item_sequence_id eam_direct_item_recs_v.direct_item_sequence_id%TYPE,
656: direct_item_type_id eam_direct_item_recs_v.direct_item_type_id%TYPE,
657: description eam_direct_item_recs_v.description%TYPE,
658: required_quantity eam_direct_item_recs_v.required_quantity%TYPE,
659: unit_price eam_direct_item_recs_v.unit_price%TYPE,
660: uom_code eam_direct_item_recs_v.uom_code%TYPE,
661: purchasing_category_id eam_direct_item_recs_v.purchasing_category_id%TYPE,
662: date_required eam_direct_item_recs_v.date_required%TYPE,
655: direct_item_sequence_id eam_direct_item_recs_v.direct_item_sequence_id%TYPE,
656: direct_item_type_id eam_direct_item_recs_v.direct_item_type_id%TYPE,
657: description eam_direct_item_recs_v.description%TYPE,
658: required_quantity eam_direct_item_recs_v.required_quantity%TYPE,
659: unit_price eam_direct_item_recs_v.unit_price%TYPE,
660: uom_code eam_direct_item_recs_v.uom_code%TYPE,
661: purchasing_category_id eam_direct_item_recs_v.purchasing_category_id%TYPE,
662: date_required eam_direct_item_recs_v.date_required%TYPE,
663: auto_request_material eam_direct_item_recs_v.auto_request_material%TYPE,
656: direct_item_type_id eam_direct_item_recs_v.direct_item_type_id%TYPE,
657: description eam_direct_item_recs_v.description%TYPE,
658: required_quantity eam_direct_item_recs_v.required_quantity%TYPE,
659: unit_price eam_direct_item_recs_v.unit_price%TYPE,
660: uom_code eam_direct_item_recs_v.uom_code%TYPE,
661: purchasing_category_id eam_direct_item_recs_v.purchasing_category_id%TYPE,
662: date_required eam_direct_item_recs_v.date_required%TYPE,
663: auto_request_material eam_direct_item_recs_v.auto_request_material%TYPE,
664: suggested_vendor_id eam_direct_item_recs_v.suggested_vendor_id%TYPE,
657: description eam_direct_item_recs_v.description%TYPE,
658: required_quantity eam_direct_item_recs_v.required_quantity%TYPE,
659: unit_price eam_direct_item_recs_v.unit_price%TYPE,
660: uom_code eam_direct_item_recs_v.uom_code%TYPE,
661: purchasing_category_id eam_direct_item_recs_v.purchasing_category_id%TYPE,
662: date_required eam_direct_item_recs_v.date_required%TYPE,
663: auto_request_material eam_direct_item_recs_v.auto_request_material%TYPE,
664: suggested_vendor_id eam_direct_item_recs_v.suggested_vendor_id%TYPE,
665: suggested_vendor_name eam_direct_item_recs_v.suggested_vendor_name%TYPE,
658: required_quantity eam_direct_item_recs_v.required_quantity%TYPE,
659: unit_price eam_direct_item_recs_v.unit_price%TYPE,
660: uom_code eam_direct_item_recs_v.uom_code%TYPE,
661: purchasing_category_id eam_direct_item_recs_v.purchasing_category_id%TYPE,
662: date_required eam_direct_item_recs_v.date_required%TYPE,
663: auto_request_material eam_direct_item_recs_v.auto_request_material%TYPE,
664: suggested_vendor_id eam_direct_item_recs_v.suggested_vendor_id%TYPE,
665: suggested_vendor_name eam_direct_item_recs_v.suggested_vendor_name%TYPE,
666: suggested_vendor_site eam_direct_item_recs_v.suggested_vendor_site%TYPE,
659: unit_price eam_direct_item_recs_v.unit_price%TYPE,
660: uom_code eam_direct_item_recs_v.uom_code%TYPE,
661: purchasing_category_id eam_direct_item_recs_v.purchasing_category_id%TYPE,
662: date_required eam_direct_item_recs_v.date_required%TYPE,
663: auto_request_material eam_direct_item_recs_v.auto_request_material%TYPE,
664: suggested_vendor_id eam_direct_item_recs_v.suggested_vendor_id%TYPE,
665: suggested_vendor_name eam_direct_item_recs_v.suggested_vendor_name%TYPE,
666: suggested_vendor_site eam_direct_item_recs_v.suggested_vendor_site%TYPE,
667: suggested_vendor_phone eam_direct_item_recs_v.suggested_vendor_phone%TYPE,
660: uom_code eam_direct_item_recs_v.uom_code%TYPE,
661: purchasing_category_id eam_direct_item_recs_v.purchasing_category_id%TYPE,
662: date_required eam_direct_item_recs_v.date_required%TYPE,
663: auto_request_material eam_direct_item_recs_v.auto_request_material%TYPE,
664: suggested_vendor_id eam_direct_item_recs_v.suggested_vendor_id%TYPE,
665: suggested_vendor_name eam_direct_item_recs_v.suggested_vendor_name%TYPE,
666: suggested_vendor_site eam_direct_item_recs_v.suggested_vendor_site%TYPE,
667: suggested_vendor_phone eam_direct_item_recs_v.suggested_vendor_phone%TYPE,
668: suggested_vendor_item_num eam_direct_item_recs_v.suggested_vendor_item_num%TYPE );
661: purchasing_category_id eam_direct_item_recs_v.purchasing_category_id%TYPE,
662: date_required eam_direct_item_recs_v.date_required%TYPE,
663: auto_request_material eam_direct_item_recs_v.auto_request_material%TYPE,
664: suggested_vendor_id eam_direct_item_recs_v.suggested_vendor_id%TYPE,
665: suggested_vendor_name eam_direct_item_recs_v.suggested_vendor_name%TYPE,
666: suggested_vendor_site eam_direct_item_recs_v.suggested_vendor_site%TYPE,
667: suggested_vendor_phone eam_direct_item_recs_v.suggested_vendor_phone%TYPE,
668: suggested_vendor_item_num eam_direct_item_recs_v.suggested_vendor_item_num%TYPE );
669:
662: date_required eam_direct_item_recs_v.date_required%TYPE,
663: auto_request_material eam_direct_item_recs_v.auto_request_material%TYPE,
664: suggested_vendor_id eam_direct_item_recs_v.suggested_vendor_id%TYPE,
665: suggested_vendor_name eam_direct_item_recs_v.suggested_vendor_name%TYPE,
666: suggested_vendor_site eam_direct_item_recs_v.suggested_vendor_site%TYPE,
667: suggested_vendor_phone eam_direct_item_recs_v.suggested_vendor_phone%TYPE,
668: suggested_vendor_item_num eam_direct_item_recs_v.suggested_vendor_item_num%TYPE );
669:
670: TYPE l_di_recs_type IS REF CURSOR RETURN DirectItemRec;
663: auto_request_material eam_direct_item_recs_v.auto_request_material%TYPE,
664: suggested_vendor_id eam_direct_item_recs_v.suggested_vendor_id%TYPE,
665: suggested_vendor_name eam_direct_item_recs_v.suggested_vendor_name%TYPE,
666: suggested_vendor_site eam_direct_item_recs_v.suggested_vendor_site%TYPE,
667: suggested_vendor_phone eam_direct_item_recs_v.suggested_vendor_phone%TYPE,
668: suggested_vendor_item_num eam_direct_item_recs_v.suggested_vendor_item_num%TYPE );
669:
670: TYPE l_di_recs_type IS REF CURSOR RETURN DirectItemRec;
671: l_di_recs l_di_recs_type;
664: suggested_vendor_id eam_direct_item_recs_v.suggested_vendor_id%TYPE,
665: suggested_vendor_name eam_direct_item_recs_v.suggested_vendor_name%TYPE,
666: suggested_vendor_site eam_direct_item_recs_v.suggested_vendor_site%TYPE,
667: suggested_vendor_phone eam_direct_item_recs_v.suggested_vendor_phone%TYPE,
668: suggested_vendor_item_num eam_direct_item_recs_v.suggested_vendor_item_num%TYPE );
669:
670: TYPE l_di_recs_type IS REF CURSOR RETURN DirectItemRec;
671: l_di_recs l_di_recs_type;
672: l_di_record l_di_recs%ROWTYPE;