eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EGO_IMPORT_PVT dependencies on MTL_ITEM_REVISIONS_INTERFACE

Line 201: -- (MTL_ITEM_REVISIONS_INTERFACE)

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

Line 604: p_batch_id IN MTL_ITEM_REVISIONS_INTERFACE.SET_PROCESS_ID%TYPE

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

Line 605: , p_source_system_id IN MTL_ITEM_REVISIONS_INTERFACE.SOURCE_SYSTEM_ID%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
609: , p_request_id IN MTL_ITEM_REVISIONS_INTERFACE.REQUEST_ID%TYPE DEFAULT NULL

Line 606: , p_source_system_reference IN MTL_ITEM_REVISIONS_INTERFACE.SOURCE_SYSTEM_REFERENCE%TYPE

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: )

Line 607: , p_organization_id IN MTL_ITEM_REVISIONS_INTERFACE.ORGANIZATION_ID%TYPE

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;

Line 609: , p_request_id IN MTL_ITEM_REVISIONS_INTERFACE.REQUEST_ID%TYPE DEFAULT NULL

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

Line 611: RETURN MTL_ITEM_REVISIONS_INTERFACE.REVISION%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
614: (
615: p_batch_id IN MTL_ITEM_REVISIONS_INTERFACE.SET_PROCESS_ID%TYPE

Line 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

Line 616: , p_inventory_item_id IN MTL_ITEM_REVISIONS_INTERFACE.INVENTORY_ITEM_ID%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
620: , p_request_id IN MTL_ITEM_REVISIONS_INTERFACE.REQUEST_ID%TYPE DEFAULT NULL

Line 617: , p_item_number IN MTL_ITEM_REVISIONS_INTERFACE.ITEM_NUMBER%TYPE

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: )

Line 618: , p_organization_id IN MTL_ITEM_REVISIONS_INTERFACE.ORGANIZATION_ID%TYPE

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;

Line 620: , p_request_id IN MTL_ITEM_REVISIONS_INTERFACE.REQUEST_ID%TYPE DEFAULT NULL

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: -----------------------------------------------------------------------------------------

Line 622: RETURN MTL_ITEM_REVISIONS_INTERFACE.REVISION%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: -----------------------------------------------------------------------------------------
625: -- Get_Tokens --
626: -- Takes a string and breaks it into tokens, returning them in another space-delimited --