DBA Data[Home] [Help]

APPS.OKL_AM_REMARKET_ASSET_PVT dependencies on MTL_PARAMETERS

Line 699: FROM mtl_parameters a , ORG_ORGANIZATION_DEFINITIONS b

695:
696: -- SECHAWLA 08-MAR-04 3492490 : Added master org name
697: CURSOR l_mtlparam_csr(p_org_id NUMBER) IS
698: SELECT a.master_organization_id, b.organization_name master_org_name
699: FROM mtl_parameters a , ORG_ORGANIZATION_DEFINITIONS b
700: WHERE a.organization_id = p_org_id
701: AND a.master_organization_id = b.organization_id ;
702:
703:

Line 1213: -- Inventory organization is not set up in MTL Parameters.

1209: -- SECAHWLA 08-MAR-04 3492490 : Added master org name
1210: FETCH l_mtlparam_csr INTO l_master_org_id, l_master_org_name;
1211: IF l_mtlparam_csr%NOTFOUND THEN
1212: x_return_status := OKL_API.G_RET_STS_ERROR;
1213: -- Inventory organization is not set up in MTL Parameters.
1214: OKL_API.set_message( p_app_name => 'OKL',
1215: p_msg_name => 'OKL_AM_NO_ORG_PARAM'
1216: );
1217: RAISE OKL_API.G_EXCEPTION_ERROR;