[Home] [Help]
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
37: --11)File name--> Update the filename in the jtf_amv_attachments table
38: --12)Def site--> Create a new mapping for the template with this flag
39: --13)Def lang--> Create a new mapping for the template with this flag
40: --*******************************************************************************
41:
116: attachment_type,
117: language_code,
118: application_id,
119: description
120: FROM JTF_AMV_ATTACHMENTS
121: WHERE attachment_id=c_attachment_id;
122:
123: -- Bug5882497
124: CURSOR c_get_attachment_id_csr(c_item_id ibe_dsp_lgl_phys_map.item_id%type,
121: WHERE attachment_id=c_attachment_id;
122:
123: -- Bug5882497
124: CURSOR c_get_attachment_id_csr(c_item_id ibe_dsp_lgl_phys_map.item_id%type,
125: c_file_name jtf_amv_attachments.file_name%type) IS
126: SELECT
127: ibemap.attachment_id
128: FROM
129: jtf_amv_attachments jtfach,ibe_dsp_lgl_phys_map ibemap
125: c_file_name jtf_amv_attachments.file_name%type) IS
126: SELECT
127: ibemap.attachment_id
128: FROM
129: jtf_amv_attachments jtfach,ibe_dsp_lgl_phys_map ibemap
130: WHERE
131: ibemap.attachment_id = jtfach.attachment_id
132: and ibemap.item_id = c_item_id
133: and jtfach.file_name = c_file_name
286: l_attachment_rec.application_id:=l_appl_id;
287:
288: /* Bug#5882497, scnagara
289: a) The attachment_id present for another site which corresponds to the file
290: is fetched from the IBE_DSP_LGL_PHYS_MAP and JTF_AMV_ATTACHMENTS tables.
291: b) The attachment_id is also passed to the IBE_Attachment_GRP.save_attachment
292: through the variable of type IBE_ATTACHMENT_GRP.ATTACHMENT_REC_TYPE.
293: */
294: