DBA Data[Home] [Help]

APPS.EGO_ITEM_PVT dependencies on INV_ITEM_GRP

Line 891: l_Item_rec_in INV_ITEM_GRP.Item_Rec_Type;

887: FROM MTL_ITEM_REVISIONS_B
888: WHERE INVENTORY_ITEM_ID = CP_ITEM_ID
889: AND ORGANIZATION_ID = CP_ORG_ID ;
890: -----------------------------------------------------------------------------
891: l_Item_rec_in INV_ITEM_GRP.Item_Rec_Type;
892: l_revision_rec INV_ITEM_GRP.Item_Revision_Rec_Type;
893: l_rev_index_failure BOOLEAN := FALSE;
894:
895: l_Item_rec_out INV_ITEM_GRP.Item_Rec_Type;

Line 892: l_revision_rec INV_ITEM_GRP.Item_Revision_Rec_Type;

888: WHERE INVENTORY_ITEM_ID = CP_ITEM_ID
889: AND ORGANIZATION_ID = CP_ORG_ID ;
890: -----------------------------------------------------------------------------
891: l_Item_rec_in INV_ITEM_GRP.Item_Rec_Type;
892: l_revision_rec INV_ITEM_GRP.Item_Revision_Rec_Type;
893: l_rev_index_failure BOOLEAN := FALSE;
894:
895: l_Item_rec_out INV_ITEM_GRP.Item_Rec_Type;
896:

Line 895: l_Item_rec_out INV_ITEM_GRP.Item_Rec_Type;

891: l_Item_rec_in INV_ITEM_GRP.Item_Rec_Type;
892: l_revision_rec INV_ITEM_GRP.Item_Revision_Rec_Type;
893: l_rev_index_failure BOOLEAN := FALSE;
894:
895: l_Item_rec_out INV_ITEM_GRP.Item_Rec_Type;
896:
897: l_Template_Id NUMBER;
898: l_Template_Name VARCHAR2(30);
899: l_Error_tbl INV_ITEM_GRP.Error_Tbl_Type;

Line 899: l_Error_tbl INV_ITEM_GRP.Error_Tbl_Type;

895: l_Item_rec_out INV_ITEM_GRP.Item_Rec_Type;
896:
897: l_Template_Id NUMBER;
898: l_Template_Name VARCHAR2(30);
899: l_Error_tbl INV_ITEM_GRP.Error_Tbl_Type;
900: --------------------------------------------------------------------------
901: -- Business Event enhancement
902: --------------------------------------------------------------------------
903: l_event_return_status VARCHAR2(1) ;

Line 1414: INV_ITEM_GRP.Interface_Handler

1410: END;
1411: --End : Added revision record processing
1412:
1413: IF l_Process_Control = 'EGO_INTERFACE_HANDLER' THEN
1414: INV_ITEM_GRP.Interface_Handler
1415: (
1416: p_commit => FND_API.G_TRUE
1417: ,p_transaction_type => G_Item_Rec.Transaction_Type
1418: ,p_Item_rec => l_Item_rec_in

Line 1431: INV_ITEM_GRP.Create_Item

1427: FND_MESSAGE.set_name('INV', l_return_err); --Setting error message to be returned
1428:
1429: ELSIF ( G_Item_Rec.Transaction_Type = 'CREATE' ) THEN
1430:
1431: INV_ITEM_GRP.Create_Item
1432: (
1433: p_commit => p_commit
1434: , p_Item_rec => l_Item_rec_in
1435: , p_Revision_rec => l_revision_rec

Line 1588: INV_Item_GRP.Update_Item

1584: l_cat_tab_index := l_cat_tab_index + 1 ;
1585: END LOOP;
1586: END IF;
1587: ---------------------------------------------------------------------------
1588: INV_Item_GRP.Update_Item
1589: (
1590: p_commit => p_commit
1591: , p_Item_rec => l_Item_rec_in
1592: , p_Revision_rec => l_revision_rec

Line 1812: l_Item_rec_in INV_ITEM_GRP.Item_Rec_Type;

1808: l_api_name CONSTANT VARCHAR2(30) := 'Process_Item_Org_Assignments';
1809: l_return_status VARCHAR2(1) := G_MISS_CHAR;
1810: l_msg_count NUMBER := 0;
1811: l_Item_Org_Assignment_Rec EGO_Item_PUB.Item_Org_Assignment_Rec_Type;
1812: l_Item_rec_in INV_ITEM_GRP.Item_Rec_Type;
1813: l_revision_rec INV_ITEM_GRP.Item_Revision_Rec_Type;
1814: l_rev_index_failure BOOLEAN := FALSE;
1815: l_Item_rec_out INV_ITEM_GRP.Item_Rec_Type;
1816: l_Error_tbl INV_ITEM_GRP.Error_Tbl_Type;

Line 1813: l_revision_rec INV_ITEM_GRP.Item_Revision_Rec_Type;

1809: l_return_status VARCHAR2(1) := G_MISS_CHAR;
1810: l_msg_count NUMBER := 0;
1811: l_Item_Org_Assignment_Rec EGO_Item_PUB.Item_Org_Assignment_Rec_Type;
1812: l_Item_rec_in INV_ITEM_GRP.Item_Rec_Type;
1813: l_revision_rec INV_ITEM_GRP.Item_Revision_Rec_Type;
1814: l_rev_index_failure BOOLEAN := FALSE;
1815: l_Item_rec_out INV_ITEM_GRP.Item_Rec_Type;
1816: l_Error_tbl INV_ITEM_GRP.Error_Tbl_Type;
1817: l_master_org INV.MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID%TYPE;

Line 1815: l_Item_rec_out INV_ITEM_GRP.Item_Rec_Type;

1811: l_Item_Org_Assignment_Rec EGO_Item_PUB.Item_Org_Assignment_Rec_Type;
1812: l_Item_rec_in INV_ITEM_GRP.Item_Rec_Type;
1813: l_revision_rec INV_ITEM_GRP.Item_Revision_Rec_Type;
1814: l_rev_index_failure BOOLEAN := FALSE;
1815: l_Item_rec_out INV_ITEM_GRP.Item_Rec_Type;
1816: l_Error_tbl INV_ITEM_GRP.Error_Tbl_Type;
1817: l_master_org INV.MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID%TYPE;
1818: l_event_return_status VARCHAR2(1) ; --business event enhancement
1819: l_item_rev_rec c_get_item_rev_rec%ROWTYPE;

Line 1816: l_Error_tbl INV_ITEM_GRP.Error_Tbl_Type;

1812: l_Item_rec_in INV_ITEM_GRP.Item_Rec_Type;
1813: l_revision_rec INV_ITEM_GRP.Item_Revision_Rec_Type;
1814: l_rev_index_failure BOOLEAN := FALSE;
1815: l_Item_rec_out INV_ITEM_GRP.Item_Rec_Type;
1816: l_Error_tbl INV_ITEM_GRP.Error_Tbl_Type;
1817: l_master_org INV.MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID%TYPE;
1818: l_event_return_status VARCHAR2(1) ; --business event enhancement
1819: l_item_rev_rec c_get_item_rev_rec%ROWTYPE;
1820: l_msg_data VARCHAR2(2000);

Line 1892: INV_ITEM_GRP.Create_Item

1888: END;
1889: --End : Added revision record processing
1890:
1891:
1892: INV_ITEM_GRP.Create_Item
1893: (
1894: p_commit => p_commit
1895: , p_Item_rec => l_Item_rec_in
1896: , p_Revision_rec => l_revision_rec