DBA Data[Home] [Help]

APPS.CS_COST_DETAILS_PVT dependencies on CS_STD

Line 478: WHERE organization_id =cs_std.get_item_valdn_orgzn_id -- modified by bkanimoz on 21-jan-2007

474:
475: CURSOR c_inventory_item_id IS
476: SELECT 1
477: FROM mtl_system_items_b
478: WHERE organization_id =cs_std.get_item_valdn_orgzn_id -- modified by bkanimoz on 21-jan-2007
479: AND inventory_item_id =p_inventory_item_id;
480:
481: lv_exists_flag VARCHAR2(1) := 'N';
482: l_prog_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||'is_item_valid';

Line 603: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID', cs_std.get_item_valdn_orgzn_id);

599: WHEN OTHERS THEN
600:
601: FND_MESSAGE.Set_Name('CS', 'CS_CHG_GET_UOM_FAILED');
602: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID', p_inventory_item_id);
603: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID', cs_std.get_item_valdn_orgzn_id);
604: FND_MSG_PUB.add;
605: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
606:
607: END GET_PRIMARY_UOM;

Line 1303: AND organization_id = cs_std.get_item_valdn_orgzn_id

1299: SELECT ctbt.txn_billing_type_id
1300: FROM mtl_system_items_kfv kfv,
1301: cs_txn_billing_types ctbt
1302: WHERE kfv.inventory_item_id = p_inventory_item_id
1303: AND organization_id = cs_std.get_item_valdn_orgzn_id
1304: AND ctbt.transaction_type_id = p_txn_type_id
1305: AND ctbt.billing_type = kfv.material_billable_flag;
1306:
1307: lv_exists_flag VARCHAR2(1) := 'N';