5562: select application_short_name ,
5563: template_code ,
5564: default_language,
5565: default_territory
5566: from xdo_templates_b
5567: where template_id = c_xdo_id ;
5568:
5569: l_application_short_name xdo_templates_b.application_short_name%type ;
5570: l_template_code xdo_templates_b.template_code%type ;
5565: default_territory
5566: from xdo_templates_b
5567: where template_id = c_xdo_id ;
5568:
5569: l_application_short_name xdo_templates_b.application_short_name%type ;
5570: l_template_code xdo_templates_b.template_code%type ;
5571: l_default_language xdo_templates_b.default_language%type ;
5572: l_default_territory xdo_templates_b.default_territory%type ;
5573: l_fnd_out boolean ;
5566: from xdo_templates_b
5567: where template_id = c_xdo_id ;
5568:
5569: l_application_short_name xdo_templates_b.application_short_name%type ;
5570: l_template_code xdo_templates_b.template_code%type ;
5571: l_default_language xdo_templates_b.default_language%type ;
5572: l_default_territory xdo_templates_b.default_territory%type ;
5573: l_fnd_out boolean ;
5574:
5567: where template_id = c_xdo_id ;
5568:
5569: l_application_short_name xdo_templates_b.application_short_name%type ;
5570: l_template_code xdo_templates_b.template_code%type ;
5571: l_default_language xdo_templates_b.default_language%type ;
5572: l_default_territory xdo_templates_b.default_territory%type ;
5573: l_fnd_out boolean ;
5574:
5575: Begin
5568:
5569: l_application_short_name xdo_templates_b.application_short_name%type ;
5570: l_template_code xdo_templates_b.template_code%type ;
5571: l_default_language xdo_templates_b.default_language%type ;
5572: l_default_territory xdo_templates_b.default_territory%type ;
5573: l_fnd_out boolean ;
5574:
5575: Begin
5576: --