DBA Data[Home] [Help]

APPS.OKL_IPY_PVT dependencies on DUAL

Line 3459: FROM dual;

3455: x_ipy_rec.program_application_id,
3456: x_ipy_rec.program_id,
3457: x_ipy_rec.program_update_date,
3458: l_org_id -- Change by zrehman for Bug#6363652 9-Oct-2007
3459: FROM dual;
3460: IF (x_ipy_rec.org_id IS NULL OR x_ipy_rec.org_id = OKC_API.G_MISS_NUM) THEN
3461: x_ipy_rec.org_id := l_org_id;
3462: END IF;
3463:

Line 3848: FROM dual;

3844: x_ipyv_rec.program_application_id,
3845: x_ipyv_rec.program_id,
3846: x_ipyv_rec.program_update_date,
3847: l_org_id ---- Change by zrehman for Bug#6363652 9-Oct-2007
3848: FROM dual;
3849: IF(x_ipyv_rec.org_id IS NULL OR x_ipyv_rec.org_id = OKC_API.G_MISS_NUM) THEN
3850: x_ipyv_rec.org_id := l_org_id;
3851: END IF;
3852: RETURN(l_return_status);

Line 4927: x_ipy_rec.org_id FROM dual;

4923: MO_GLOBAL.GET_CURRENT_ORG_ID() INTO x_ipy_rec.request_id,
4924: x_ipy_rec.program_application_id,
4925: x_ipy_rec.program_id,
4926: x_ipy_rec.program_update_date,
4927: x_ipy_rec.org_id FROM dual;
4928: RETURN(l_return_status);
4929: END Set_Attributes;
4930: BEGIN
4931: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 5620: x_ipyv_rec.org_id FROM dual;

5616: MO_GLOBAL.GET_CURRENT_ORG_ID() INTO x_ipyv_rec.request_id,
5617: x_ipyv_rec.program_application_id,
5618: x_ipyv_rec.program_id,
5619: x_ipyv_rec.program_update_date,
5620: x_ipyv_rec.org_id FROM dual;
5621:
5622: RETURN(l_return_status);
5623: END Set_Attributes;
5624: BEGIN