[Home] [Help]
222: l_idx NUMBER(10) := 0 ;
223:
224: BEGIN
225: /**********************************
226: * Standard Start of API savepoint *
227: **********************************/
228: SAVEPOINT CREATE_ITEM_COST_PVT ;
229:
230: /*************************************************************
235: FND_MSG_PUB.initialize;
236: END IF;
237:
238: /*************************************************
239: * Standard call to check for call compatibility. *
240: *************************************************/
241: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version, l_api_name, G_PKG_NAME)
242: THEN
243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
648: log_msg( x_costcmpnt_ids.count || ' Component cost row(s) inserted');
649: END IF;
650:
651: /******************************
652: * Standard check of p_commit. *
653: ******************************/
654: IF FND_API.To_Boolean (p_commit)
655: THEN
656: COMMIT WORK;
656: COMMIT WORK;
657: END IF;
658:
659: /**************************************************************************
660: * Standard call to get message count and if count is 1, get message info. *
661: **************************************************************************/
662: FND_MSG_PUB.Count_And_Get
663: (
664: p_count => x_msg_count,
754: l_api_name CONSTANT VARCHAR2(30) := 'Update_Item_Cost' ;
755: l_api_version CONSTANT NUMBER := 3.0 ;
756: BEGIN
757: /**********************************
758: * Standard Start of API savepoint *
759: **********************************/
760: SAVEPOINT UPDATE_ITEM_COST_PVT ;
761:
762: /*************************************************************
767: FND_MSG_PUB.initialize;
768: END IF;
769:
770: /*************************************************
771: * Standard call to check for call compatibility. *
772: *************************************************/
773: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version, l_api_name, G_PKG_NAME)
774: THEN
775: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1170: END ;
1171: END LOOP ;
1172:
1173: /******************************
1174: * Standard check of p_commit. *
1175: ******************************/
1176: IF FND_API.To_Boolean( p_commit )
1177: THEN
1178: COMMIT WORK;
1178: COMMIT WORK;
1179: END IF;
1180:
1181: /**************************************************************************
1182: * Standard call to get message count and if count is 1, get message info. *
1183: **************************************************************************/
1184: FND_MSG_PUB.Count_And_Get
1185: (
1186: p_count => x_msg_count,
1294: ORDER BY cd.cost_cmpntcls_id, cd.cost_analysis_code;
1295: BEGIN
1296:
1297: /**********************************
1298: * Standard Start of API savepoint *
1299: **********************************/
1300: SAVEPOINT GET_ITEM_COST_PVT;
1301:
1302: /*************************************************************
1307: FND_MSG_PUB.initialize;
1308: END IF;
1309:
1310: /*************************************************
1311: * Standard call to check for call compatibility. *
1312: *************************************************/
1313: IF NOT FND_API.Compatible_API_Call ( l_api_version, p_api_version, l_api_name, G_PKG_NAME)
1314: THEN
1315: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1388: END IF ;
1389: END LOOP ;
1390:
1391: /**************************************************************************
1392: * Standard call to get message count and if count is 1, get message info. *
1393: **************************************************************************/
1394: FND_MSG_PUB.Count_And_Get
1395: (
1396: p_count => x_msg_count,