DBA Data[Home] [Help]

APPS.CST_ITEMRESOURCECOSTS_GRP dependencies on CST_ITEMRESOURCECOSTS_GRP

Line 1: PACKAGE BODY CST_ItemResourceCosts_GRP AS

1: PACKAGE BODY CST_ItemResourceCosts_GRP AS
2: /* $Header: CSTGIRCB.pls 120.3 2006/02/06 13:36:55 vtkamath noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CST_ItemResourceCosts_GRP';
5: G_LOG_HEAD CONSTANT VARCHAR2(40) := 'cst.plsql.'||G_PKG_NAME;

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CST_ItemResourceCosts_GRP';

1: PACKAGE BODY CST_ItemResourceCosts_GRP AS
2: /* $Header: CSTGIRCB.pls 120.3 2006/02/06 13:36:55 vtkamath noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CST_ItemResourceCosts_GRP';
5: G_LOG_HEAD CONSTANT VARCHAR2(40) := 'cst.plsql.'||G_PKG_NAME;
6: G_LOG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
7:
8: -------------------------------------------------------------------------------

Line 156: where rownum <= CST_ItemResourceCosts_GRP.LAST_N_PO_RECEIPTS);

152: and organization_id = p_organization_id
153: and inventory_item_id = p_item_id
154: and transaction_quantity > 0
155: order by transaction_id desc)
156: where rownum <= CST_ItemResourceCosts_GRP.LAST_N_PO_RECEIPTS);
157:
158: else
159: raise FND_API.g_exc_unexpected_error;
160: end if;

Line 416: END CST_ItemResourceCosts_GRP;

412: x_msg_data := substr(SQLERRM,1,200);
413:
414: END Get_ResourceRate;
415:
416: END CST_ItemResourceCosts_GRP;