197: );
198: --------------------------------------------------------------------------------------------
199: -- Procedure MERGE_REVS
200: -- Merges unprocessed revisions found in the revisions interface table
201: -- (MTL_ITEM_REVISIONS_INTERFACE)
202: --------------------------------------------------------------------------------------------
203: PROCEDURE merge_revs( p_batch_id IN NUMBER
204: , p_is_pdh_batch IN FLAG DEFAULT NULL
205: , p_ss_id IN NUMBER DEFAULT NULL
600: RETURN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE;
601:
602: FUNCTION GET_LATEST_MIRI_REV_SS
603: (
604: p_batch_id IN MTL_ITEM_REVISIONS_INTERFACE.SET_PROCESS_ID%TYPE
605: , p_source_system_id IN MTL_ITEM_REVISIONS_INTERFACE.SOURCE_SYSTEM_ID%TYPE
606: , p_source_system_reference IN MTL_ITEM_REVISIONS_INTERFACE.SOURCE_SYSTEM_REFERENCE%TYPE
607: , p_organization_id IN MTL_ITEM_REVISIONS_INTERFACE.ORGANIZATION_ID%TYPE
608: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
601:
602: FUNCTION GET_LATEST_MIRI_REV_SS
603: (
604: p_batch_id IN MTL_ITEM_REVISIONS_INTERFACE.SET_PROCESS_ID%TYPE
605: , p_source_system_id IN MTL_ITEM_REVISIONS_INTERFACE.SOURCE_SYSTEM_ID%TYPE
606: , p_source_system_reference IN MTL_ITEM_REVISIONS_INTERFACE.SOURCE_SYSTEM_REFERENCE%TYPE
607: , p_organization_id IN MTL_ITEM_REVISIONS_INTERFACE.ORGANIZATION_ID%TYPE
608: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
609: , p_request_id IN MTL_ITEM_REVISIONS_INTERFACE.REQUEST_ID%TYPE DEFAULT NULL
602: FUNCTION GET_LATEST_MIRI_REV_SS
603: (
604: p_batch_id IN MTL_ITEM_REVISIONS_INTERFACE.SET_PROCESS_ID%TYPE
605: , p_source_system_id IN MTL_ITEM_REVISIONS_INTERFACE.SOURCE_SYSTEM_ID%TYPE
606: , p_source_system_reference IN MTL_ITEM_REVISIONS_INTERFACE.SOURCE_SYSTEM_REFERENCE%TYPE
607: , p_organization_id IN MTL_ITEM_REVISIONS_INTERFACE.ORGANIZATION_ID%TYPE
608: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
609: , p_request_id IN MTL_ITEM_REVISIONS_INTERFACE.REQUEST_ID%TYPE DEFAULT NULL
610: )
603: (
604: p_batch_id IN MTL_ITEM_REVISIONS_INTERFACE.SET_PROCESS_ID%TYPE
605: , p_source_system_id IN MTL_ITEM_REVISIONS_INTERFACE.SOURCE_SYSTEM_ID%TYPE
606: , p_source_system_reference IN MTL_ITEM_REVISIONS_INTERFACE.SOURCE_SYSTEM_REFERENCE%TYPE
607: , p_organization_id IN MTL_ITEM_REVISIONS_INTERFACE.ORGANIZATION_ID%TYPE
608: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
609: , p_request_id IN MTL_ITEM_REVISIONS_INTERFACE.REQUEST_ID%TYPE DEFAULT NULL
610: )
611: RETURN MTL_ITEM_REVISIONS_INTERFACE.REVISION%TYPE;
605: , p_source_system_id IN MTL_ITEM_REVISIONS_INTERFACE.SOURCE_SYSTEM_ID%TYPE
606: , p_source_system_reference IN MTL_ITEM_REVISIONS_INTERFACE.SOURCE_SYSTEM_REFERENCE%TYPE
607: , p_organization_id IN MTL_ITEM_REVISIONS_INTERFACE.ORGANIZATION_ID%TYPE
608: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
609: , p_request_id IN MTL_ITEM_REVISIONS_INTERFACE.REQUEST_ID%TYPE DEFAULT NULL
610: )
611: RETURN MTL_ITEM_REVISIONS_INTERFACE.REVISION%TYPE;
612:
613: FUNCTION GET_LATEST_MIRI_REV_PDH
607: , p_organization_id IN MTL_ITEM_REVISIONS_INTERFACE.ORGANIZATION_ID%TYPE
608: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
609: , p_request_id IN MTL_ITEM_REVISIONS_INTERFACE.REQUEST_ID%TYPE DEFAULT NULL
610: )
611: RETURN MTL_ITEM_REVISIONS_INTERFACE.REVISION%TYPE;
612:
613: FUNCTION GET_LATEST_MIRI_REV_PDH
614: (
615: p_batch_id IN MTL_ITEM_REVISIONS_INTERFACE.SET_PROCESS_ID%TYPE
611: RETURN MTL_ITEM_REVISIONS_INTERFACE.REVISION%TYPE;
612:
613: FUNCTION GET_LATEST_MIRI_REV_PDH
614: (
615: p_batch_id IN MTL_ITEM_REVISIONS_INTERFACE.SET_PROCESS_ID%TYPE
616: , p_inventory_item_id IN MTL_ITEM_REVISIONS_INTERFACE.INVENTORY_ITEM_ID%TYPE
617: , p_item_number IN MTL_ITEM_REVISIONS_INTERFACE.ITEM_NUMBER%TYPE
618: , p_organization_id IN MTL_ITEM_REVISIONS_INTERFACE.ORGANIZATION_ID%TYPE
619: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
612:
613: FUNCTION GET_LATEST_MIRI_REV_PDH
614: (
615: p_batch_id IN MTL_ITEM_REVISIONS_INTERFACE.SET_PROCESS_ID%TYPE
616: , p_inventory_item_id IN MTL_ITEM_REVISIONS_INTERFACE.INVENTORY_ITEM_ID%TYPE
617: , p_item_number IN MTL_ITEM_REVISIONS_INTERFACE.ITEM_NUMBER%TYPE
618: , p_organization_id IN MTL_ITEM_REVISIONS_INTERFACE.ORGANIZATION_ID%TYPE
619: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
620: , p_request_id IN MTL_ITEM_REVISIONS_INTERFACE.REQUEST_ID%TYPE DEFAULT NULL
613: FUNCTION GET_LATEST_MIRI_REV_PDH
614: (
615: p_batch_id IN MTL_ITEM_REVISIONS_INTERFACE.SET_PROCESS_ID%TYPE
616: , p_inventory_item_id IN MTL_ITEM_REVISIONS_INTERFACE.INVENTORY_ITEM_ID%TYPE
617: , p_item_number IN MTL_ITEM_REVISIONS_INTERFACE.ITEM_NUMBER%TYPE
618: , p_organization_id IN MTL_ITEM_REVISIONS_INTERFACE.ORGANIZATION_ID%TYPE
619: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
620: , p_request_id IN MTL_ITEM_REVISIONS_INTERFACE.REQUEST_ID%TYPE DEFAULT NULL
621: )
614: (
615: p_batch_id IN MTL_ITEM_REVISIONS_INTERFACE.SET_PROCESS_ID%TYPE
616: , p_inventory_item_id IN MTL_ITEM_REVISIONS_INTERFACE.INVENTORY_ITEM_ID%TYPE
617: , p_item_number IN MTL_ITEM_REVISIONS_INTERFACE.ITEM_NUMBER%TYPE
618: , p_organization_id IN MTL_ITEM_REVISIONS_INTERFACE.ORGANIZATION_ID%TYPE
619: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
620: , p_request_id IN MTL_ITEM_REVISIONS_INTERFACE.REQUEST_ID%TYPE DEFAULT NULL
621: )
622: RETURN MTL_ITEM_REVISIONS_INTERFACE.REVISION%TYPE;
616: , p_inventory_item_id IN MTL_ITEM_REVISIONS_INTERFACE.INVENTORY_ITEM_ID%TYPE
617: , p_item_number IN MTL_ITEM_REVISIONS_INTERFACE.ITEM_NUMBER%TYPE
618: , p_organization_id IN MTL_ITEM_REVISIONS_INTERFACE.ORGANIZATION_ID%TYPE
619: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
620: , p_request_id IN MTL_ITEM_REVISIONS_INTERFACE.REQUEST_ID%TYPE DEFAULT NULL
621: )
622: RETURN MTL_ITEM_REVISIONS_INTERFACE.REVISION%TYPE;
623:
624: -----------------------------------------------------------------------------------------
618: , p_organization_id IN MTL_ITEM_REVISIONS_INTERFACE.ORGANIZATION_ID%TYPE
619: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
620: , p_request_id IN MTL_ITEM_REVISIONS_INTERFACE.REQUEST_ID%TYPE DEFAULT NULL
621: )
622: RETURN MTL_ITEM_REVISIONS_INTERFACE.REVISION%TYPE;
623:
624: -----------------------------------------------------------------------------------------
625: -- Get_Tokens --
626: -- Takes a string and breaks it into tokens, returning them in another space-delimited --