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.3 2006/05/26 15:47:24 blash 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 1230: package_name in varchar2 default 'FND_WEBATTCH',

1226: -- mode.
1227: --
1228:
1229: procedure ReloadSummary(
1230: package_name in varchar2 default 'FND_WEBATTCH',
1231: function_name in varchar2,
1232: entity_name in varchar2,
1233: pk1_value in varchar2,
1234: pk2_value in varchar2 default NULL,

Line 1304: package_name in varchar2 default 'FND_WEBATTCH',

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

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

1482: --Construct the one html line per row fetched.
1483: if (atlstrec.datatype_id = 6) then
1484: htp.p(''||
1485: htf.anchor2(owa_util.get_owa_service_path
1486: ||'fnd_webattch.ViewFileDocument?attached_document_id='
1487: ||icx_call.encrypt2(to_char(atlstrec.attached_document_id)),
1488: htf.img2( '/OA_MEDIA/FNDIITMD.gif',
1489: calt => fnd_message.get_string('FND','HE_VIEW')
1490: ||' '||atlstrec.datatype_name,

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

1568: if (query_only <> 'Y' ) then
1569: htp.p(''||
1570: htf.anchor2('javascript:delete_attachment('''
1571: || owa_util.get_owa_service_path
1572: ||'fnd_webattch.DeleteAttachment?attached_document_id='
1573: ||icx_call.encrypt2(to_char(atlstrec.attached_document_id))
1574: ||'&'||'function_name='||icx_call.encrypt2(function_name)
1575: ||'&'||'entity_name='||icx_call.encrypt2(entity_name)
1576: ||'&'||'pk1_value='||icx_call.encrypt2(pk1_value)

Line 1726: package_name in varchar2 default 'FND_WEBATTCH',

1722: -- mode.
1723: --
1724:
1725: procedure PrintTextDocument(
1726: package_name in varchar2 default 'FND_WEBATTCH',
1727: attached_document_id in varchar2,
1728: function_name in varchar2 ,
1729: entity_name in varchar2 ,
1730: pk1_value in varchar2 ,

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

1778: and fdfv.function_type = 'F';
1779: end if;
1780:
1781: -- Replace all newline character with
and newline character.
1782: l_html_text := substrb(replace(l_text, fnd_webattch.g_chr_newline,
1783: '
'||fnd_webattch.g_chr_newline),
1784: 1, 32000);
1785:
1786: htp.bodyClose;

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

1779: end if;
1780:
1781: -- Replace all newline character with
and newline character.
1782: l_html_text := substrb(replace(l_text, fnd_webattch.g_chr_newline,
1783: '
'||fnd_webattch.g_chr_newline),
1784: 1, 32000);
1785:
1786: htp.bodyClose;
1787: htp.htmlClose;

Line 1833: package_name in varchar2 default 'FND_WEBATTCH',

1829: -- mode.
1830: --
1831:
1832: procedure PrintUpdateAttachment (
1833: package_name in varchar2 default 'FND_WEBATTCH',
1834: attached_document_id in varchar2,
1835: function_name in varchar2,
1836: entity_name in varchar2,
1837: pk1_value in varchar2,

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

1970: close att_doc_cursor;
1971:
1972: -- GFM Preparation
1973: access_id := fnd_gfm.authorize(NULL);
1974: upload_action := 'fnd_webattch.update_attachment_gfm_wrapper';
1975:
1976: htp.formOpen( curl => upload_action, cattributes=>'NAME="UPDATE_ATCHMT"',
1977: cmethod => 'POST',cenctype=> 'multipart/form-data');
1978:

Line 2204: package_name in varchar2 default 'FND_WEBATTCH',

2200: -- mode.
2201: --
2202:
2203: Procedure PrintAddAttachment(
2204: package_name in varchar2 default 'FND_WEBATTCH',
2205: function_name in varchar2,
2206: entity_name in varchar2,
2207: pk1_value in varchar2,
2208: pk2_value in varchar2 default NULL,

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

2309: htp.br;
2310:
2311: -- GFM Preparation
2312: access_id := fnd_gfm.authorize(NULL);
2313: upload_action := 'fnd_webattch.add_attachment_gfm_wrapper';
2314:
2315: htp.formOpen( curl => upload_action , cattributes=>'NAME="ADD_ATCHMT"',
2316: cmethod => 'POST',cenctype=> 'multipart/form-data');
2317:

Line 2641: end FND_WEBATTCH;

2637: file_id := l_file_id;
2638:
2639: END;
2640:
2641: end FND_WEBATTCH;