APPS.IBW_OE_PVT dependencies on IBE_DSP_ATTACHMENTS_V

Line 757: FROM ibe_dsp_attachments_v

753: ), NULL ) AS referrer
754: , pat.useragent AS useragent
755: , DECODE ( pat.attribute16
756: ,'I', NVL2 ( ( SELECT access_name
757: FROM ibe_dsp_attachments_v
758: WHERE UPPER(pat.attribute24) LIKE '%/' || UPPER(file_name) || '%' --Changed by Venky.
759: AND ROWNUM = 1 )
760: , 'R'
761: , NVL2 ( pat.attribute4

Line 776: FROM ibe_dsp_attachments_v

772: ) -- Matching criteria for non-EBS is similar to EBS but no template mapping involved
773: ) AS matching_criteria
774: , DECODE( pat.attribute16
775: ,'I', UPPER(NVL ( ( SELECT access_name
776: FROM ibe_dsp_attachments_v
777: WHERE UPPER(pat.attribute24) LIKE '%/' || UPPER(file_name) || '%' --Changed by Venky
778: AND ROWNUM = 1 )
779: , NVL ( pat.attribute4
780: , NVL ( pat.attribute5

Line 1929: l_template_access_name ibe_dsp_attachments_v.access_name%type;

1925: IS
1926: x_page_id NUMBER (30);
1927: l_rec_count NUMBER (30);
1928: l_error_message VARCHAR2(240);
1929: l_template_access_name ibe_dsp_attachments_v.access_name%type;
1930: l_template_description ibe_dsp_attachments_v.description%type;
1931: l_template_name jtf_amv_items_vl.item_name%type;
1932: l_appctx VARCHAR2(30);
1933: l_url VARCHAR2(3000);

Line 1930: l_template_description ibe_dsp_attachments_v.description%type;

1926: x_page_id NUMBER (30);
1927: l_rec_count NUMBER (30);
1928: l_error_message VARCHAR2(240);
1929: l_template_access_name ibe_dsp_attachments_v.access_name%type;
1930: l_template_description ibe_dsp_attachments_v.description%type;
1931: l_template_name jtf_amv_items_vl.item_name%type;
1932: l_appctx VARCHAR2(30);
1933: l_url VARCHAR2(3000);
1934: BEGIN

Line 1944: FROM ibe_dsp_attachments_v dsp,jtf_amv_items_vl item

1940:
1941: BEGIN --Changed by Venky. Added code to handle no_data_found exception
1942: SELECT dsp.access_name,item.item_name,dsp.description
1943: INTO l_template_access_name ,l_template_name,l_template_description
1944: FROM ibe_dsp_attachments_v dsp,jtf_amv_items_vl item
1945: WHERE UPPER(url) LIKE '%/' || UPPER(file_name) || '%' --Changed by Venky
1946: AND item.item_id = dsp.logical_id
1947: AND ROWNUM = 1;
1948: