[Home] [Help]
23: -- If the site code is null, the mappings are not imported( error logged in the error log)
24: --
25: -- User may modify the following fields in the input xml file -->
26: --
27: --1) ProgrammaticAccessName(jtf_amv_items_b.access_name) --> Create a new template with this acces name
28: --2) Name(jtf_amv_items_tl.item_name)--> Update the existing template Name value to reflect the new value
29: --3) Description(jtf_amv_items_tl.description)-->Update the existing template Description value to reflect the new value
30: --4) Keywords(jtf_amv_items_keywords.keywords)-->pdate the existing template Keywords value to reflect the new value
31: --5) Seed flag--> No effect field is only for informational purpose
28: --2) Name(jtf_amv_items_tl.item_name)--> Update the existing template Name value to reflect the new value
29: --3) Description(jtf_amv_items_tl.description)-->Update the existing template Description value to reflect the new value
30: --4) Keywords(jtf_amv_items_keywords.keywords)-->pdate the existing template Keywords value to reflect the new value
31: --5) Seed flag--> No effect field is only for informational purpose
32: --6) Applicable_to(jtf_amv_items_b.applicable_to)-->Update the existing template 'applicable to' value to reflect the new value
33: --7) Seed map--> No effect, field is only for informational purpose
34: --8) Site code--> Create a new mapping for the template with this site id
35: --9) Site name--> No effect, field is only for informational purpose
36: --10)Language--> Create a new mapping for the template with this lang code
81: FROM DUAL;
82:
83: CURSOR c_get_template_csr(c_access_name VARCHAR2) IS
84: SELECT item_id,object_version_number
85: FROM jtf_amv_items_b
86: WHERE access_name = c_access_name
87: AND application_id = 671
88: AND deliverable_type_code = 'TEMPLATE';
89: