DBA Data[Home] [Help]

APPS.OKS_AUTH_UTIL_PVT dependencies on OKC_CONTEXT

Line 1832: l_param_organization_id NUMBER := okc_context.get_okc_organization_id;

1828: PROCEDURE get_product_selection(p_clvl_filter_rec IN clvl_filter_rec,
1829: x_prod_selections_tbl OUT NOCOPY prod_selections_tbl)
1830: IS
1831:
1832: l_param_organization_id NUMBER := okc_context.get_okc_organization_id;
1833: l_find NUMBER := p_clvl_filter_rec.clvl_find_id;
1834:
1835:
1836: TYPE items_rec IS RECORD (inventory_item_id MTL_SYSTEM_ITEMS_KFV.inventory_item_id%TYPE,

Line 4725: l_org_id NUMBER := OKC_CONTEXT.GET_OKC_ORGANIZATION_ID;

4721: --ADDED FOR Bug# 2364507
4722: FUNCTION GetCoveragetemplate(p_item_id IN NUMBER) RETURN NUMBER
4723: IS
4724:
4725: l_org_id NUMBER := OKC_CONTEXT.GET_OKC_ORGANIZATION_ID;
4726:
4727: --Bug 5041682, modifed the cursor to have a lower parse time, current query takes 3 seconds
4728: CURSOR l_covtemp_csr IS
4729: --SELECT coverage_template_id

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

4728: CURSOR l_covtemp_csr IS
4729: --SELECT coverage_template_id
4730: --FROM okx_system_items_v
4731: --WHERE id1 = p_item_id
4732: --AND id2 = OKC_CONTEXT.GET_OKC_ORGANIZATION_ID;
4733: SELECT COVERAGE_SCHEDULE_ID
4734: FROM mtl_system_items_b
4735: WHERE inventory_item_id = p_item_id
4736: AND organization_id = nvl(l_org_id, -99) ;

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

6507:
6508:
6509: p_org_assignments_tbl(1).instance_ou_id := NULL;
6510: p_org_assignments_tbl(1).instance_id := NULL;
6511: p_org_assignments_tbl(1).operating_unit_id := okc_context.get_okc_org_id;
6512: p_org_assignments_tbl(1).relationship_type_code := 'SOLD_FROM';
6513: p_org_assignments_tbl(1).active_start_date := '';
6514: p_org_assignments_tbl(1).active_end_date := '';
6515: p_org_assignments_tbl(1).context := '';