[Home] [Help]
1: PACKAGE BODY EGO_UI_ITEM_PUB AS
2: /* $Header: EGOITUIB.pls 115.40 2004/06/07 00:11:16 absinha noship $ */
3:
4: G_FILE_NAME CONSTANT VARCHAR2(12) := 'EGOITUIB.pls';
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'EGO_UI_ITEM_PUB';
1: PACKAGE BODY EGO_UI_ITEM_PUB AS
2: /* $Header: EGOITUIB.pls 115.40 2004/06/07 00:11:16 absinha noship $ */
3:
4: G_FILE_NAME CONSTANT VARCHAR2(12) := 'EGOITUIB.pls';
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'EGO_UI_ITEM_PUB';
6: G_CREATE_TRANSACTION_TYPE CONSTANT VARCHAR2(10) := 'CREATE';
7: G_UPDATE_TRANSACTION_TYPE CONSTANT VARCHAR2(10) := 'UPDATE';
8: G_COPY_TRANSACTION_TYPE CONSTANT VARCHAR2(10) := 'COPY';
9: G_OBJECT_NAME CONSTANT VARCHAR2(10) := 'EGO_ITEM';
1256: developer_debug ('::2960442::Update_Item_Lifecycle::start');
1257: X_RETURN_STATUS := FND_API.g_RET_STS_SUCCESS;
1258: X_MSG_COUNT := 0;
1259:
1260: L_MASTER_ORGANIZATION_ID := EGO_UI_ITEM_PUB.Get_Master_Organization_Id(P_ORGANIZATION_ID => P_ORGANIZATION_ID);
1261:
1262: IF (P_ORGANIZATION_ID = L_MASTER_ORGANIZATION_ID) THEN
1263: IF (P_CATALOG_GROUP_ID IS NULL) THEN
1264: UPDATE MTL_SYSTEM_ITEMS_B SET LIFECYCLE_ID = NULL
1266:
1267: UPDATE MTL_SYSTEM_ITEMS_B SET CURRENT_PHASE_ID = NULL
1268: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID;
1269: ELSE
1270: L_CONTROL_LEVEL := EGO_UI_ITEM_PUB.Get_Item_Attr_Control_Level(P_ITEM_ATTRIBUTE => 'MTL_SYSTEM_ITEMS.INVENTORY_ITEM_STATUS_CODE');
1271:
1272: -- Insert a row to Mtl_Pending_Item_Status table with master organization id
1273: -- and pending_flag = N.
1274: INSERT INTO MTL_PENDING_ITEM_STATUS
1792: --, p_Grantee_Party_Name IN VARCHAR2
1793: --, p_Grant_Start_Date IN DATE
1794: --, p_Grant_End_Date IN DATE
1795:
1796: developer_debug (' Entered EGO_UI_ITEM_PUB.Process_item Input Parameters ' );
1797: developer_debug (' p_api_version '||to_char(p_api_version));
1798: developer_debug (' p_init_msg_list '|| p_init_msg_list);
1799: developer_debug (' p_commit '|| p_commit);
1800: developer_debug (' p_Transaction_Type '||p_transaction_type);
3264: ,p_data => x_msg_data);
3265: END Process_Item;
3266:
3267:
3268: END EGO_UI_ITEM_PUB;