DBA Data[Home] [Help]

APPS.OKS_AUTH_UTIL_PVT dependencies on OKC_CONTEXT

Line 1305: l_param_organization_id NUMBER := okc_context.get_okc_organization_id;

1301: PROCEDURE get_product_selection(p_clvl_filter_rec IN clvl_filter_rec,
1302: x_prod_selections_tbl OUT NOCOPY prod_selections_tbl)
1303: IS
1304:
1305: l_param_organization_id NUMBER := okc_context.get_okc_organization_id;
1306: l_find NUMBER := p_clvl_filter_rec.clvl_find_id;
1307:
1308: TYPE items_rec IS RECORD (inventory_item_id MTL_SYSTEM_ITEMS_KFV.inventory_item_id%TYPE,
1309: description VARCHAR2(10000),

Line 4185: l_org_id NUMBER := OKC_CONTEXT.GET_OKC_ORGANIZATION_ID;

4181: --ADDED FOR Bug# 2364507
4182: FUNCTION GetCoveragetemplate(p_item_id IN NUMBER) RETURN NUMBER
4183: IS
4184:
4185: l_org_id NUMBER := OKC_CONTEXT.GET_OKC_ORGANIZATION_ID;
4186:
4187: --Bug 5041682, modifed the cursor to have a lower parse time, current query takes 3 seconds
4188: CURSOR l_covtemp_csr IS
4189: --SELECT coverage_template_id

Line 4192: --AND id2 = OKC_CONTEXT.GET_OKC_ORGANIZATION_ID;

4188: CURSOR l_covtemp_csr IS
4189: --SELECT coverage_template_id
4190: --FROM okx_system_items_v
4191: --WHERE id1 = p_item_id
4192: --AND id2 = OKC_CONTEXT.GET_OKC_ORGANIZATION_ID;
4193: SELECT COVERAGE_SCHEDULE_ID
4194: FROM mtl_system_items_b
4195: WHERE inventory_item_id = p_item_id
4196: AND organization_id = nvl(l_org_id, -99) ;

Line 5891: p_org_assignments_tbl(1).operating_unit_id := okc_context.get_okc_org_id;

5887:
5888:
5889: p_org_assignments_tbl(1).instance_ou_id := NULL;
5890: p_org_assignments_tbl(1).instance_id := NULL;
5891: p_org_assignments_tbl(1).operating_unit_id := okc_context.get_okc_org_id;
5892: p_org_assignments_tbl(1).relationship_type_code := 'SOLD_FROM';
5893: p_org_assignments_tbl(1).active_start_date := '';
5894: p_org_assignments_tbl(1).active_end_date := '';
5895: p_org_assignments_tbl(1).context := '';