APPS.IBE_DELIVERABLE_EXPIMP_PVT dependencies on IBE_DSP_LGL_PHYS_MAP

Line 80: SELECT IBE_DSP_LGL_PHYS_MAP_S1.NEXTVAL

76: l_debugMsgBuf VARCHAR(2000);
77: l_next_val NUMBER;
78:
79: CURSOR c_lgl_phys_map_seq IS
80: SELECT IBE_DSP_LGL_PHYS_MAP_S1.NEXTVAL
81: FROM DUAL;
82:
83: CURSOR c_get_template_csr(c_access_name VARCHAR2) IS
84: SELECT item_id,object_version_number

Line 97: FROM ibe_dsp_lgl_phys_map

93: c_lang_code VARCHAR2,
94: c_default_site VARCHAR2,
95: c_default_lang VARCHAR2) IS
96: SELECT lgl_phys_map_id, attachment_id
97: FROM ibe_dsp_lgl_phys_map
98: WHERE item_id = c_item_id
99: AND msite_id = c_site_id
100: AND language_code = c_lang_code
101: AND default_site = c_default_site

Line 124: CURSOR c_get_attachment_id_csr(c_item_id ibe_dsp_lgl_phys_map.item_id%type,

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,
125: c_file_name jtf_amv_attachments.file_name%type) IS
126: SELECT
127: ibemap.attachment_id
128: FROM

Line 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

Line 290: is fetched from the IBE_DSP_LGL_PHYS_MAP and JTF_AMV_ATTACHMENTS tables.

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:

Line 375: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Step 7: inserting into ibe_dsp_lgl_phys_map');

371:
372: IF (l_lgl_phys_map_id IS NULL) THEN
373:
374: IF (p_enable_debug = 'Y') THEN
375: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Step 7: inserting into ibe_dsp_lgl_phys_map');
376: END IF;
377: -- OPEN c_lgl_phys_map_seq;
378: -- FETCH c_lgl_phys_map_seq into l_next_val;
379: -- close c_lgl_phys_map_seq;

Line 385: INSERT INTO IBE_DSP_LGL_PHYS_MAP(lgl_phys_map_id, item_id,

381: IF (p_enable_debug = 'Y') THEN
382: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Step 7a :value of next sequence='||l_next_val);
383: END IF;
384:
385: INSERT INTO IBE_DSP_LGL_PHYS_MAP(lgl_phys_map_id, item_id,
386: msite_id, language_code, default_site, default_language,
387: attachment_id, content_item_key,object_version_number,
388: created_by,creation_date,last_updated_by,last_update_date)
389: VALUES (IBE_DSP_LGL_PHYS_MAP_S1.NEXTVAL, l_item_id,

Line 389: VALUES (IBE_DSP_LGL_PHYS_MAP_S1.NEXTVAL, l_item_id,

385: INSERT INTO IBE_DSP_LGL_PHYS_MAP(lgl_phys_map_id, item_id,
386: msite_id, language_code, default_site, default_language,
387: attachment_id, content_item_key,object_version_number,
388: created_by,creation_date,last_updated_by,last_update_date)
389: VALUES (IBE_DSP_LGL_PHYS_MAP_S1.NEXTVAL, l_item_id,
390: p_minisite_ids(l_i), p_language_codes(l_i), p_default_sites(l_i),
391: p_default_languages(l_i), l_attachment_id, NULL,
392: 1,FND_GLOBAL.user_id,sysdate,FND_GLOBAL.user_id,sysdate);
393: