DBA Data[Home] [Help]

APPS.FND_WEBATTCH dependencies on FND_WEBATTCH

Line 1: package body FND_WEBATTCH as

1: package body FND_WEBATTCH as
2: /* $Header: AFATCHMB.pls 120.5.12020000.2 2012/08/30 17:58:50 ctilley ship $ */
3:
4:
5: -- Package Variables which stores the seed data for attachments.

Line 107: package_name in varchar2 default 'FND_WEBATTCH',

103: procedure GetSummaryList (
104: attchmt_status in varchar2 default 'DISABLED',
105: from_url in varchar2,
106: query_only in varchar2 default 'N',
107: package_name in varchar2 default 'FND_WEBATTCH',
108: URL out NOCOPY varchar2
109: )
110: as
111: begin

Line 156: l_packagename varchar2(80) := 'FND_WEBATTCH';

152: l_from_url varchar2(2000) := icx_call.decrypt2(summary.from_url);
153: l_query_only varchar2(100) := icx_call.decrypt2(summary.query_only);
154: l_lang varchar2(24);
155: l_dcdname varchar2(80):= owa_util.get_cgi_env('SCRIPT_NAME');
156: l_packagename varchar2(80) := 'FND_WEBATTCH';
157: begin
158:
159: -- Validate the session
160: if NOT (icx_sec.ValidateSession(null)) then

Line 175: htp.frame (csrc => l_dcdname || '/fnd_webattch.Header?Lang='||l_lang,

171:
172: htp.framesetopen(crows=>'60, *, *', cattributes =>'frameborder=no border=0');
173:
174: -- Call the procedure that prints header
175: htp.frame (csrc => l_dcdname || '/fnd_webattch.Header?Lang='||l_lang,
176: cname => 'header_frame', cmarginheight=>'0',
177: cmarginwidth=> '0', cscrolling => 'NO',
178: cnoresize => 'NORESIZE', cattributes => 'FRAMEBORDER=NO');
179:

Line 182: 'fnd_webattch.PrintSummary?package_name='|| l_packagename ||

178: cnoresize => 'NORESIZE', cattributes => 'FRAMEBORDER=NO');
179:
180: -- Print The Body of the Summary page.
181: htp.frame (csrc => l_dcdname ||'/'||
182: 'fnd_webattch.PrintSummary?package_name='|| l_packagename ||
183: '&'||'function_name='||l_function_name ||
184: '&'||'entity_name='||l_entity_name ||
185: '&'||'pk1_value='||l_pk1_value ||
186: '&'||'pk2_value='||l_pk2_value ||

Line 197: htp.frame (csrc => l_dcdname || '/'||'fnd_webattch.PrintBlankPage',

193: cmarginheight=>'0', cmarginwidth=> '10', cscrolling => 'AUTO',
194: cnoresize => 'NORESIZE', cattributes => 'FRAMEBORDER=NO');
195:
196: -- Make an empty frame for document data.
197: htp.frame (csrc => l_dcdname || '/'||'fnd_webattch.PrintBlankPage',
198: cname => 'document_frame', cmarginheight=>'0',
199: cmarginwidth=> '10', cscrolling => 'AUTO',
200: cnoresize => 'NORESIZE', cattributes => 'FRAMEBORDER=NO');
201:

Line 383: l_packagename varchar2(80) := 'FND_WEBATTCH';

379: l_from_url varchar2(2000);
380: l_query_only varchar2(1);
381: l_lang varchar2(24);
382: l_dcdname varchar2(80):= owa_util.get_cgi_env('SCRIPT_NAME');
383: l_packagename varchar2(80) := 'FND_WEBATTCH';
384:
385: begin
386:
387: -- Validate the session

Line 415: htp.frame (csrc => l_dcdname || '/fnd_webattch.Header?Lang='||l_lang,

411:
412: htp.framesetopen(crows=>'60, *', cattributes =>'frameborder=no border=0');
413:
414: -- Call the procedure that prints header
415: htp.frame (csrc => l_dcdname || '/fnd_webattch.Header?Lang='||l_lang,
416: cname => 'top_frame', cmarginheight=>'0',
417: cmarginwidth=> '0', cscrolling => 'NO',
418: cnoresize => 'NORESIZE', cattributes => 'FRAMEBORDER=NO');
419:

Line 422: '/fnd_webattch.PrintUpdateAttachment?attached_document_id='||

418: cnoresize => 'NORESIZE', cattributes => 'FRAMEBORDER=NO');
419:
420: -- Print The Body of the Add Attachment page.
421: htp.frame (csrc => l_dcdname ||
422: '/fnd_webattch.PrintUpdateAttachment?attached_document_id='||
423: l_attached_document_id ||
424: '&'||'package_name='|| l_packagename ||
425: '&'||'function_name='||l_function_name ||
426: '&'||'entity_name='||l_entity_name ||

Line 504: 'fnd_webattch.Summary?function_name=' || function_name

500: end if;
501:
502: -- Redirect the URL to the file location
503: owa_util.redirect_url (curl => owa_util.get_owa_service_path||
504: 'fnd_webattch.Summary?function_name=' || function_name
505: ||'&'||'entity_name='||entity_name
506: ||'&'||'pk1_value='||pk1_value
507: ||'&'||'pk2_value='||pk2_value
508: ||'&'||'pk3_value='||pk3_value

Line 554: l_packagename varchar2(80) := 'FND_WEBATTCH';

550: l_from_url varchar2(2000);
551: l_query_only varchar2(1);
552: l_lang varchar2(24);
553: l_dcdname varchar2(80):= owa_util.get_cgi_env('SCRIPT_NAME');
554: l_packagename varchar2(80) := 'FND_WEBATTCH';
555:
556: begin
557:
558: -- Validate the session

Line 584: htp.frame (csrc => l_dcdname || '/fnd_webattch.Header?Lang='||l_lang,

580:
581: htp.framesetopen(crows=>'60, *', cattributes =>'frameborder=no border=0');
582:
583: -- Call the procedure that prints header
584: htp.frame (csrc => l_dcdname || '/fnd_webattch.Header?Lang='||l_lang,
585: cname => 'tooolbar_frame', cmarginheight=>'0',
586: cmarginwidth=> '0', cscrolling => 'NO',
587: cnoresize => 'NORESIZE', cattributes => 'FRAMEBORDER=NO');
588:

Line 591: '/fnd_webattch.PrintAddAttachment?package_name='||

587: cnoresize => 'NORESIZE', cattributes => 'FRAMEBORDER=NO');
588:
589: -- Print The Body of the Add Attachment page.
590: htp.frame (csrc => l_dcdname ||
591: '/fnd_webattch.PrintAddAttachment?package_name='||
592: l_packagename ||
593: '&'||'function_name='||l_function_name ||
594: '&'||'entity_name='||l_entity_name ||
595: '&'||'pk1_value='||l_pk1_value ||

Line 656: package_name => 'FND_WEBATTCH' ,

652: --Header(fnd_message.get_string('FND', 'FND-WEBATCH-VIEWTEXT-TITLE'),l_lang);
653:
654: -- Call PrintTextDocument with the packagename
655: PrintTextDocument (
656: package_name => 'FND_WEBATTCH' ,
657: attached_document_id => attached_document_id ,
658: function_name => function_name ,
659: entity_name => entity_name ,
660: pk1_value => pk1_value ,

Line 1305: package_name in varchar2 default 'FND_WEBATTCH',

1301: -- mode.
1302: --
1303:
1304: procedure ReloadSummary(
1305: package_name in varchar2 default 'FND_WEBATTCH',
1306: function_name in varchar2,
1307: entity_name in varchar2,
1308: pk1_value in varchar2,
1309: pk2_value in varchar2 default NULL,

Line 1379: package_name in varchar2 default 'FND_WEBATTCH',

1375: -- mode.
1376: --
1377:
1378: procedure PrintSummary(
1379: package_name in varchar2 default 'FND_WEBATTCH',
1380: function_name in varchar2,
1381: entity_name in varchar2,
1382: pk1_value in varchar2,
1383: pk2_value in varchar2 default NULL,

Line 1561: ||'fnd_webattch.ViewFileDocument?attached_document_id='

1557: --Construct the one html line per row fetched.
1558: if (atlstrec.datatype_id = 6) then
1559: htp.p(''||
1560: htf.anchor2(owa_util.get_owa_service_path
1561: ||'fnd_webattch.ViewFileDocument?attached_document_id='
1562: ||icx_call.encrypt2(to_char(atlstrec.attached_document_id)),
1563: htf.img2( '/OA_MEDIA/FNDIITMD.gif',
1564: calt => fnd_message.get_string('FND','HE_VIEW')
1565: ||' '||atlstrec.datatype_name,

Line 1647: ||'fnd_webattch.DeleteAttachment?attached_document_id='

1643: if (query_only <> 'Y' ) then
1644: htp.p(''||
1645: htf.anchor2('javascript:delete_attachment('''
1646: || owa_util.get_owa_service_path
1647: ||'fnd_webattch.DeleteAttachment?attached_document_id='
1648: ||icx_call.encrypt2(to_char(atlstrec.attached_document_id))
1649: ||'&'||'function_name='||icx_call.encrypt2(function_name)
1650: ||'&'||'entity_name='||icx_call.encrypt2(entity_name)
1651: ||'&'||'pk1_value='||icx_call.encrypt2(pk1_value)

Line 1801: package_name in varchar2 default 'FND_WEBATTCH',

1797: -- mode.
1798: --
1799:
1800: procedure PrintTextDocument(
1801: package_name in varchar2 default 'FND_WEBATTCH',
1802: attached_document_id in varchar2,
1803: function_name in varchar2 ,
1804: entity_name in varchar2 ,
1805: pk1_value in varchar2 ,

Line 1857: l_html_text := substrb(replace(l_text, fnd_webattch.g_chr_newline,

1853: and fdfv.function_type = 'F';
1854: end if;
1855:
1856: -- Replace all newline character with
and newline character.
1857: l_html_text := substrb(replace(l_text, fnd_webattch.g_chr_newline,
1858: '
'||fnd_webattch.g_chr_newline),
1859: 1, 32000);
1860:
1861: htp.bodyClose;

Line 1858: '
'||fnd_webattch.g_chr_newline),

1854: end if;
1855:
1856: -- Replace all newline character with
and newline character.
1857: l_html_text := substrb(replace(l_text, fnd_webattch.g_chr_newline,
1858: '
'||fnd_webattch.g_chr_newline),
1859: 1, 32000);
1860:
1861: htp.bodyClose;
1862: htp.htmlClose;

Line 1908: package_name in varchar2 default 'FND_WEBATTCH',

1904: -- mode.
1905: --
1906:
1907: procedure PrintUpdateAttachment (
1908: package_name in varchar2 default 'FND_WEBATTCH',
1909: attached_document_id in varchar2,
1910: function_name in varchar2,
1911: entity_name in varchar2,
1912: pk1_value in varchar2,

Line 2049: upload_action := 'fnd_webattch.update_attachment_gfm_wrapper';

2045: close att_doc_cursor;
2046:
2047: -- GFM Preparation
2048: access_id := fnd_gfm.authorize(NULL);
2049: upload_action := 'fnd_webattch.update_attachment_gfm_wrapper';
2050:
2051: htp.formOpen( curl => upload_action, cattributes=>'NAME="UPDATE_ATCHMT"',
2052: cmethod => 'POST',cenctype=> 'multipart/form-data');
2053:

Line 2279: package_name in varchar2 default 'FND_WEBATTCH',

2275: -- mode.
2276: --
2277:
2278: Procedure PrintAddAttachment(
2279: package_name in varchar2 default 'FND_WEBATTCH',
2280: function_name in varchar2,
2281: entity_name in varchar2,
2282: pk1_value in varchar2,
2283: pk2_value in varchar2 default NULL,

Line 2388: upload_action := 'fnd_webattch.add_attachment_gfm_wrapper';

2384: htp.br;
2385:
2386: -- GFM Preparation
2387: access_id := fnd_gfm.authorize(NULL);
2388: upload_action := 'fnd_webattch.add_attachment_gfm_wrapper';
2389:
2390: htp.formOpen( curl => upload_action , cattributes=>'NAME="ADD_ATCHMT"',
2391: cmethod => 'POST',cenctype=> 'multipart/form-data');
2392:

Line 2716: end FND_WEBATTCH;

2712: file_id := l_file_id;
2713:
2714: END;
2715:
2716: end FND_WEBATTCH;