APPS.OKS_TEMPLATE_SET_PUB dependencies on XDO_TEMPLATES_VL

Line 1688: FROM xdo_templates_vl

1684: WHERE chr_id = p_contract_id;
1685:
1686: CURSOR csr_xdo_template_name(p_attachment_template_id IN NUMBER)IS
1687: SELECT template_name
1688: FROM xdo_templates_vl
1689: WHERE template_id=p_attachment_template_id;
1690:
1691:
1692: BEGIN

Line 1832: -- if attachment name is NULL then get template name from xdo_templates_vl

1828: x_contract_update_status,
1829: x_attachment_name ;
1830: CLOSE csr_tmpl_set_dtls;
1831:
1832: -- if attachment name is NULL then get template name from xdo_templates_vl
1833: IF x_attachment_name IS NULL THEN
1834: OPEN csr_xdo_template_name(p_attachment_template_id => x_attachment_template_id);
1835: FETCH csr_xdo_template_name INTO x_attachment_name;
1836: CLOSE csr_xdo_template_name;