DBA Data[Home] [Help]

APPS.OKL_INR_PVT dependencies on OKL_SYSTEM_PARAMS_ALL_PUB

Line 1346: G_INV_ORG_ID := OKL_SYSTEM_PARAMS_ALL_PUB.get_system_param_value(OKL_SYSTEM_PARAMS_ALL_PUB.G_ITEM_INV_ORG_ID);

1342: AND INRV.DATE_FROM <= p_inrv_rec.DATE_FROM --Added for bug 4056611
1343: AND NVL(INRV.DATE_TO,to_date('31-12-9999','dd-mm-rrrr')) >= p_inrv_rec.DATE_FROM; --Added for bug 4056611
1344:
1345: BEGIN
1346: G_INV_ORG_ID := OKL_SYSTEM_PARAMS_ALL_PUB.get_system_param_value(OKL_SYSTEM_PARAMS_ALL_PUB.G_ITEM_INV_ORG_ID);
1347: --initialize the return status
1348: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
1349: -- enforce foreign key
1350: OPEN l_inrv_csr(G_INV_ORG_ID);

Line 1406: G_INV_ORG_ID := OKL_SYSTEM_PARAMS_ALL_PUB.get_system_param_value(OKL_SYSTEM_PARAMS_ALL_PUB.G_ITEM_INV_ORG_ID);

1402:
1403: BEGIN
1404: --initialize the return status
1405: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
1406: G_INV_ORG_ID := OKL_SYSTEM_PARAMS_ALL_PUB.get_system_param_value(OKL_SYSTEM_PARAMS_ALL_PUB.G_ITEM_INV_ORG_ID);
1407: -- enforce foreign key
1408: OPEN l_inrv_csr(G_INV_ORG_ID );
1409: FETCH l_inrv_csr INTO l_dummy_var,l_factor_min,l_factor_max;
1410: CLOSE l_inrv_csr;