462: --
463: ----------------------------------------------------------------------------
464: CURSOR c_get_context_org (cp_template_id IN NUMBER) IS
465: SELECT context_organization_id
466: FROM mtl_item_templates mit
467: WHERE mit.template_id = cp_template_id;
468:
469: CURSOR c_get_template_attributes (cp_template_id IN NUMBER) IS
470: SELECT attribute_name, attribute_value
528: GLOBAL_ATTRIBUTE7,
529: GLOBAL_ATTRIBUTE8,
530: GLOBAL_ATTRIBUTE9,
531: GLOBAL_ATTRIBUTE10
532: FROM MTL_ITEM_TEMPLATES MIT
533: WHERE MIT.template_id = cp_template_id;
534:
535: l_org_id mtl_item_templates.context_organization_id%TYPE;
536:
531: GLOBAL_ATTRIBUTE10
532: FROM MTL_ITEM_TEMPLATES MIT
533: WHERE MIT.template_id = cp_template_id;
534:
535: l_org_id mtl_item_templates.context_organization_id%TYPE;
536:
537: BEGIN
538: developer_debug ('::2960442::initialize_template_info::start');
539: l_org_id := NULL;