DBA Data[Home] [Help]

APPS.OKL_SYP_PVT dependencies on MTL_ITEM_TEMPLATES

Line 1190: FROM MTL_ITEM_TEMPLATES

1186: p_REMK_ITEM_TEMPLATE_ID IN NUMBER) IS
1187:
1188: CURSOR l_mtlitemtempl_csr(cp_TEMPLATE_ID IN NUMBER) IS
1189: SELECT 'x'
1190: FROM MTL_ITEM_TEMPLATES
1191: WHERE TEMPLATE_ID = cp_TEMPLATE_ID;
1192:
1193: l_dummy VARCHAR2(1);
1194: BEGIN

Line 2255: FROM MTL_ITEM_TEMPLATES

2251: l_org_name mtl_organizations.organization_name%TYPE;
2252: -- SECHAWLA 29-SEP-04 3924244: Added the following cursor to validate item template
2253: CURSOR l_mtlitemtempl_csr(cp_TEMPLATE_ID IN NUMBER, cp_context_organization_id IN NUMBER) IS
2254: SELECT 'x'
2255: FROM MTL_ITEM_TEMPLATES
2256: WHERE TEMPLATE_ID = cp_TEMPLATE_ID
2257: AND (context_organization_id IS NULL OR context_organization_id = cp_context_organization_id);
2258:
2259: -- SECHAWLA 16-DEC-04 4067511 : added following cursors