DBA Data[Home] [Help]

APPS.EGO_ITEM_PVT dependencies on INV_ITEM_GRP

Line 1087: l_Item_rec_in INV_ITEM_GRP.Item_Rec_Type;

1083: FROM MTL_ITEM_REVISIONS_B
1084: WHERE INVENTORY_ITEM_ID = CP_ITEM_ID
1085: AND ORGANIZATION_ID = CP_ORG_ID ;
1086: -----------------------------------------------------------------------------
1087: l_Item_rec_in INV_ITEM_GRP.Item_Rec_Type;
1088: l_revision_rec INV_ITEM_GRP.Item_Revision_Rec_Type;
1089: l_rev_index_failure BOOLEAN := FALSE;
1090:
1091: l_Item_rec_out INV_ITEM_GRP.Item_Rec_Type;

Line 1088: l_revision_rec INV_ITEM_GRP.Item_Revision_Rec_Type;

1084: WHERE INVENTORY_ITEM_ID = CP_ITEM_ID
1085: AND ORGANIZATION_ID = CP_ORG_ID ;
1086: -----------------------------------------------------------------------------
1087: l_Item_rec_in INV_ITEM_GRP.Item_Rec_Type;
1088: l_revision_rec INV_ITEM_GRP.Item_Revision_Rec_Type;
1089: l_rev_index_failure BOOLEAN := FALSE;
1090:
1091: l_Item_rec_out INV_ITEM_GRP.Item_Rec_Type;
1092:

Line 1091: l_Item_rec_out INV_ITEM_GRP.Item_Rec_Type;

1087: l_Item_rec_in INV_ITEM_GRP.Item_Rec_Type;
1088: l_revision_rec INV_ITEM_GRP.Item_Revision_Rec_Type;
1089: l_rev_index_failure BOOLEAN := FALSE;
1090:
1091: l_Item_rec_out INV_ITEM_GRP.Item_Rec_Type;
1092:
1093: l_Template_Id NUMBER;
1094: l_Template_Name VARCHAR2(30);
1095: l_Error_tbl INV_ITEM_GRP.Error_Tbl_Type;

Line 1095: l_Error_tbl INV_ITEM_GRP.Error_Tbl_Type;

1091: l_Item_rec_out INV_ITEM_GRP.Item_Rec_Type;
1092:
1093: l_Template_Id NUMBER;
1094: l_Template_Name VARCHAR2(30);
1095: l_Error_tbl INV_ITEM_GRP.Error_Tbl_Type;
1096: --------------------------------------------------------------------------
1097: -- Business Event enhancement
1098: --------------------------------------------------------------------------
1099: l_event_return_status VARCHAR2(1) ;

Line 1641: INV_ITEM_GRP.Interface_Handler

1637: END;
1638: --End : Added revision record processing
1639:
1640: IF l_Process_Control = 'EGO_INTERFACE_HANDLER' THEN
1641: INV_ITEM_GRP.Interface_Handler
1642: (
1643: p_commit => FND_API.G_TRUE
1644: ,p_transaction_type => G_Item_Rec.Transaction_Type
1645: ,p_Item_rec => l_Item_rec_in

Line 1658: INV_ITEM_GRP.Create_Item

1654: FND_MESSAGE.set_name('INV', l_return_err); --Setting error message to be returned
1655:
1656: ELSIF ( G_Item_Rec.Transaction_Type = 'CREATE' ) THEN
1657:
1658: INV_ITEM_GRP.Create_Item
1659: (
1660: p_commit => p_commit
1661: , p_Item_rec => l_Item_rec_in
1662: , p_Revision_rec => l_revision_rec

Line 1769: INV_Item_GRP.Update_Item

1765: END LOOP;
1766: END IF;
1767: ---------------------------------------------------------------------------
1768:
1769: INV_Item_GRP.Update_Item
1770: (
1771: p_commit => p_commit
1772: , p_Item_rec => l_Item_rec_in
1773: , p_Revision_rec => l_revision_rec

Line 1795: code_debug('Process_Items ' || ' After calling INV_Item_GRP.Update_Item ' ||

1791: -- See bugdb for detailed explanation.
1792: -- sreharih. Fri May 13 16:05:48 PDT 2011 (oops ...i fixed it on friday the 13th)
1793: --
1794:
1795: code_debug('Process_Items ' || ' After calling INV_Item_GRP.Update_Item ' ||
1796: ' item_id = ' || l_Item_rec_out.inventory_item_id ||
1797: ' org_id = ' || l_Item_rec_out.organization_id ||
1798: ' return status = ' || l_return_status);
1799:

Line 2038: l_Item_rec_in INV_ITEM_GRP.Item_Rec_Type;

2034: l_api_name CONSTANT VARCHAR2(30) := 'Process_Item_Org_Assignments';
2035: l_return_status VARCHAR2(1) := G_MISS_CHAR;
2036: l_msg_count NUMBER := 0;
2037: l_Item_Org_Assignment_Rec EGO_Item_PUB.Item_Org_Assignment_Rec_Type;
2038: l_Item_rec_in INV_ITEM_GRP.Item_Rec_Type;
2039: l_revision_rec INV_ITEM_GRP.Item_Revision_Rec_Type;
2040: l_rev_index_failure BOOLEAN := FALSE;
2041: l_Item_rec_out INV_ITEM_GRP.Item_Rec_Type;
2042: l_Error_tbl INV_ITEM_GRP.Error_Tbl_Type;

Line 2039: l_revision_rec INV_ITEM_GRP.Item_Revision_Rec_Type;

2035: l_return_status VARCHAR2(1) := G_MISS_CHAR;
2036: l_msg_count NUMBER := 0;
2037: l_Item_Org_Assignment_Rec EGO_Item_PUB.Item_Org_Assignment_Rec_Type;
2038: l_Item_rec_in INV_ITEM_GRP.Item_Rec_Type;
2039: l_revision_rec INV_ITEM_GRP.Item_Revision_Rec_Type;
2040: l_rev_index_failure BOOLEAN := FALSE;
2041: l_Item_rec_out INV_ITEM_GRP.Item_Rec_Type;
2042: l_Error_tbl INV_ITEM_GRP.Error_Tbl_Type;
2043: l_master_org MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID%TYPE;

Line 2041: l_Item_rec_out INV_ITEM_GRP.Item_Rec_Type;

2037: l_Item_Org_Assignment_Rec EGO_Item_PUB.Item_Org_Assignment_Rec_Type;
2038: l_Item_rec_in INV_ITEM_GRP.Item_Rec_Type;
2039: l_revision_rec INV_ITEM_GRP.Item_Revision_Rec_Type;
2040: l_rev_index_failure BOOLEAN := FALSE;
2041: l_Item_rec_out INV_ITEM_GRP.Item_Rec_Type;
2042: l_Error_tbl INV_ITEM_GRP.Error_Tbl_Type;
2043: l_master_org MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID%TYPE;
2044: l_event_return_status VARCHAR2(1) ; --business event enhancement
2045: l_item_rev_rec c_get_item_rev_rec%ROWTYPE;

Line 2042: l_Error_tbl INV_ITEM_GRP.Error_Tbl_Type;

2038: l_Item_rec_in INV_ITEM_GRP.Item_Rec_Type;
2039: l_revision_rec INV_ITEM_GRP.Item_Revision_Rec_Type;
2040: l_rev_index_failure BOOLEAN := FALSE;
2041: l_Item_rec_out INV_ITEM_GRP.Item_Rec_Type;
2042: l_Error_tbl INV_ITEM_GRP.Error_Tbl_Type;
2043: l_master_org MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID%TYPE;
2044: l_event_return_status VARCHAR2(1) ; --business event enhancement
2045: l_item_rev_rec c_get_item_rev_rec%ROWTYPE;
2046: l_msg_data VARCHAR2(2000);

Line 2118: INV_ITEM_GRP.Create_Item

2114: END;
2115: --End : Added revision record processing
2116:
2117:
2118: INV_ITEM_GRP.Create_Item
2119: (
2120: p_commit => p_commit
2121: , p_Item_rec => l_Item_rec_in
2122: , p_Revision_rec => l_revision_rec