112:
113: -- Check if the attachment status.
114: if (attchmt_status <> 'DISABLED') then
115: URL := fnd_web_config.plsql_agent || package_name
116: ||'.Summary?function_name=' || icx_call.encrypt2(g_function_name)
117: ||'&'||'entity_name='|| icx_call.encrypt2(g_entity_name)
118: ||'&'||'pk1_value='|| icx_call.encrypt2(g_pk1_value)
119: ||'&'||'pk2_value='|| icx_call.encrypt2(g_pk2_value)
120: ||'&'||'pk3_value='|| icx_call.encrypt2(g_pk3_value)
113: -- Check if the attachment status.
114: if (attchmt_status <> 'DISABLED') then
115: URL := fnd_web_config.plsql_agent || package_name
116: ||'.Summary?function_name=' || icx_call.encrypt2(g_function_name)
117: ||'&'||'entity_name='|| icx_call.encrypt2(g_entity_name)
118: ||'&'||'pk1_value='|| icx_call.encrypt2(g_pk1_value)
119: ||'&'||'pk2_value='|| icx_call.encrypt2(g_pk2_value)
120: ||'&'||'pk3_value='|| icx_call.encrypt2(g_pk3_value)
121: ||'&'||'pk4_value='|| icx_call.encrypt2(g_pk4_value)
114: if (attchmt_status <> 'DISABLED') then
115: URL := fnd_web_config.plsql_agent || package_name
116: ||'.Summary?function_name=' || icx_call.encrypt2(g_function_name)
117: ||'&'||'entity_name='|| icx_call.encrypt2(g_entity_name)
118: ||'&'||'pk1_value='|| icx_call.encrypt2(g_pk1_value)
119: ||'&'||'pk2_value='|| icx_call.encrypt2(g_pk2_value)
120: ||'&'||'pk3_value='|| icx_call.encrypt2(g_pk3_value)
121: ||'&'||'pk4_value='|| icx_call.encrypt2(g_pk4_value)
122: ||'&'||'pk5_value='|| icx_call.encrypt2(g_pk5_value)
115: URL := fnd_web_config.plsql_agent || package_name
116: ||'.Summary?function_name=' || icx_call.encrypt2(g_function_name)
117: ||'&'||'entity_name='|| icx_call.encrypt2(g_entity_name)
118: ||'&'||'pk1_value='|| icx_call.encrypt2(g_pk1_value)
119: ||'&'||'pk2_value='|| icx_call.encrypt2(g_pk2_value)
120: ||'&'||'pk3_value='|| icx_call.encrypt2(g_pk3_value)
121: ||'&'||'pk4_value='|| icx_call.encrypt2(g_pk4_value)
122: ||'&'||'pk5_value='|| icx_call.encrypt2(g_pk5_value)
123: ||'&'||'from_url=' || icx_call.encrypt2(from_url)
116: ||'.Summary?function_name=' || icx_call.encrypt2(g_function_name)
117: ||'&'||'entity_name='|| icx_call.encrypt2(g_entity_name)
118: ||'&'||'pk1_value='|| icx_call.encrypt2(g_pk1_value)
119: ||'&'||'pk2_value='|| icx_call.encrypt2(g_pk2_value)
120: ||'&'||'pk3_value='|| icx_call.encrypt2(g_pk3_value)
121: ||'&'||'pk4_value='|| icx_call.encrypt2(g_pk4_value)
122: ||'&'||'pk5_value='|| icx_call.encrypt2(g_pk5_value)
123: ||'&'||'from_url=' || icx_call.encrypt2(from_url)
124: ||'&'||'query_only='|| icx_call.encrypt2(query_only);
117: ||'&'||'entity_name='|| icx_call.encrypt2(g_entity_name)
118: ||'&'||'pk1_value='|| icx_call.encrypt2(g_pk1_value)
119: ||'&'||'pk2_value='|| icx_call.encrypt2(g_pk2_value)
120: ||'&'||'pk3_value='|| icx_call.encrypt2(g_pk3_value)
121: ||'&'||'pk4_value='|| icx_call.encrypt2(g_pk4_value)
122: ||'&'||'pk5_value='|| icx_call.encrypt2(g_pk5_value)
123: ||'&'||'from_url=' || icx_call.encrypt2(from_url)
124: ||'&'||'query_only='|| icx_call.encrypt2(query_only);
125: end if;
118: ||'&'||'pk1_value='|| icx_call.encrypt2(g_pk1_value)
119: ||'&'||'pk2_value='|| icx_call.encrypt2(g_pk2_value)
120: ||'&'||'pk3_value='|| icx_call.encrypt2(g_pk3_value)
121: ||'&'||'pk4_value='|| icx_call.encrypt2(g_pk4_value)
122: ||'&'||'pk5_value='|| icx_call.encrypt2(g_pk5_value)
123: ||'&'||'from_url=' || icx_call.encrypt2(from_url)
124: ||'&'||'query_only='|| icx_call.encrypt2(query_only);
125: end if;
126:
119: ||'&'||'pk2_value='|| icx_call.encrypt2(g_pk2_value)
120: ||'&'||'pk3_value='|| icx_call.encrypt2(g_pk3_value)
121: ||'&'||'pk4_value='|| icx_call.encrypt2(g_pk4_value)
122: ||'&'||'pk5_value='|| icx_call.encrypt2(g_pk5_value)
123: ||'&'||'from_url=' || icx_call.encrypt2(from_url)
124: ||'&'||'query_only='|| icx_call.encrypt2(query_only);
125: end if;
126:
127: end GetSummaryList;
120: ||'&'||'pk3_value='|| icx_call.encrypt2(g_pk3_value)
121: ||'&'||'pk4_value='|| icx_call.encrypt2(g_pk4_value)
122: ||'&'||'pk5_value='|| icx_call.encrypt2(g_pk5_value)
123: ||'&'||'from_url=' || icx_call.encrypt2(from_url)
124: ||'&'||'query_only='|| icx_call.encrypt2(query_only);
125: end if;
126:
127: end GetSummaryList;
128:
141: from_url in varchar2,
142: query_only in varchar2 default 'N'
143: ) as
144:
145: l_function_name varchar2(30) := icx_call.decrypt2(summary.function_name);
146: l_entity_name varchar2(40) := icx_call.decrypt2(summary.entity_name);
147: l_pk1_value varchar2(100) := icx_call.decrypt2(summary.pk1_value);
148: l_pk2_value varchar2(100) := icx_call.decrypt2(summary.pk2_value);
149: l_pk3_value varchar2(100) := icx_call.decrypt2(summary.pk3_value);
142: query_only in varchar2 default 'N'
143: ) as
144:
145: l_function_name varchar2(30) := icx_call.decrypt2(summary.function_name);
146: l_entity_name varchar2(40) := icx_call.decrypt2(summary.entity_name);
147: l_pk1_value varchar2(100) := icx_call.decrypt2(summary.pk1_value);
148: l_pk2_value varchar2(100) := icx_call.decrypt2(summary.pk2_value);
149: l_pk3_value varchar2(100) := icx_call.decrypt2(summary.pk3_value);
150: l_pk4_value varchar2(150) := icx_call.decrypt2(summary.pk4_value);
143: ) as
144:
145: l_function_name varchar2(30) := icx_call.decrypt2(summary.function_name);
146: l_entity_name varchar2(40) := icx_call.decrypt2(summary.entity_name);
147: l_pk1_value varchar2(100) := icx_call.decrypt2(summary.pk1_value);
148: l_pk2_value varchar2(100) := icx_call.decrypt2(summary.pk2_value);
149: l_pk3_value varchar2(100) := icx_call.decrypt2(summary.pk3_value);
150: l_pk4_value varchar2(150) := icx_call.decrypt2(summary.pk4_value);
151: l_pk5_value varchar2(150) := icx_call.decrypt2(summary.pk5_value);
144:
145: l_function_name varchar2(30) := icx_call.decrypt2(summary.function_name);
146: l_entity_name varchar2(40) := icx_call.decrypt2(summary.entity_name);
147: l_pk1_value varchar2(100) := icx_call.decrypt2(summary.pk1_value);
148: l_pk2_value varchar2(100) := icx_call.decrypt2(summary.pk2_value);
149: l_pk3_value varchar2(100) := icx_call.decrypt2(summary.pk3_value);
150: l_pk4_value varchar2(150) := icx_call.decrypt2(summary.pk4_value);
151: l_pk5_value varchar2(150) := icx_call.decrypt2(summary.pk5_value);
152: l_from_url varchar2(2000) := icx_call.decrypt2(summary.from_url);
145: l_function_name varchar2(30) := icx_call.decrypt2(summary.function_name);
146: l_entity_name varchar2(40) := icx_call.decrypt2(summary.entity_name);
147: l_pk1_value varchar2(100) := icx_call.decrypt2(summary.pk1_value);
148: l_pk2_value varchar2(100) := icx_call.decrypt2(summary.pk2_value);
149: l_pk3_value varchar2(100) := icx_call.decrypt2(summary.pk3_value);
150: l_pk4_value varchar2(150) := icx_call.decrypt2(summary.pk4_value);
151: l_pk5_value varchar2(150) := icx_call.decrypt2(summary.pk5_value);
152: l_from_url varchar2(2000) := icx_call.decrypt2(summary.from_url);
153: l_query_only varchar2(100) := icx_call.decrypt2(summary.query_only);
146: l_entity_name varchar2(40) := icx_call.decrypt2(summary.entity_name);
147: l_pk1_value varchar2(100) := icx_call.decrypt2(summary.pk1_value);
148: l_pk2_value varchar2(100) := icx_call.decrypt2(summary.pk2_value);
149: l_pk3_value varchar2(100) := icx_call.decrypt2(summary.pk3_value);
150: l_pk4_value varchar2(150) := icx_call.decrypt2(summary.pk4_value);
151: l_pk5_value varchar2(150) := icx_call.decrypt2(summary.pk5_value);
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);
147: l_pk1_value varchar2(100) := icx_call.decrypt2(summary.pk1_value);
148: l_pk2_value varchar2(100) := icx_call.decrypt2(summary.pk2_value);
149: l_pk3_value varchar2(100) := icx_call.decrypt2(summary.pk3_value);
150: l_pk4_value varchar2(150) := icx_call.decrypt2(summary.pk4_value);
151: l_pk5_value varchar2(150) := icx_call.decrypt2(summary.pk5_value);
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');
148: l_pk2_value varchar2(100) := icx_call.decrypt2(summary.pk2_value);
149: l_pk3_value varchar2(100) := icx_call.decrypt2(summary.pk3_value);
150: l_pk4_value varchar2(150) := icx_call.decrypt2(summary.pk4_value);
151: l_pk5_value varchar2(150) := icx_call.decrypt2(summary.pk5_value);
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';
149: l_pk3_value varchar2(100) := icx_call.decrypt2(summary.pk3_value);
150: l_pk4_value varchar2(150) := icx_call.decrypt2(summary.pk4_value);
151: l_pk5_value varchar2(150) := icx_call.decrypt2(summary.pk5_value);
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
393: l_lang := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
394:
395: -- Decrypt all parameters.
396: l_attached_document_id :=
397: icx_call.decrypt2(UpdateAttachment.attached_document_id);
398: l_function_name := icx_call.decrypt2(UpdateAttachment.function_name);
399: l_entity_name := icx_call.decrypt2(UpdateAttachment.entity_name);
400: l_pk1_value := icx_call.decrypt2(UpdateAttachment.pk1_value);
401: l_pk2_value := icx_call.decrypt2(UpdateAttachment.pk2_value);
394:
395: -- Decrypt all parameters.
396: l_attached_document_id :=
397: icx_call.decrypt2(UpdateAttachment.attached_document_id);
398: l_function_name := icx_call.decrypt2(UpdateAttachment.function_name);
399: l_entity_name := icx_call.decrypt2(UpdateAttachment.entity_name);
400: l_pk1_value := icx_call.decrypt2(UpdateAttachment.pk1_value);
401: l_pk2_value := icx_call.decrypt2(UpdateAttachment.pk2_value);
402: l_pk3_value := icx_call.decrypt2(UpdateAttachment.pk3_value);
395: -- Decrypt all parameters.
396: l_attached_document_id :=
397: icx_call.decrypt2(UpdateAttachment.attached_document_id);
398: l_function_name := icx_call.decrypt2(UpdateAttachment.function_name);
399: l_entity_name := icx_call.decrypt2(UpdateAttachment.entity_name);
400: l_pk1_value := icx_call.decrypt2(UpdateAttachment.pk1_value);
401: l_pk2_value := icx_call.decrypt2(UpdateAttachment.pk2_value);
402: l_pk3_value := icx_call.decrypt2(UpdateAttachment.pk3_value);
403: l_pk4_value := icx_call.decrypt2(UpdateAttachment.pk4_value);
396: l_attached_document_id :=
397: icx_call.decrypt2(UpdateAttachment.attached_document_id);
398: l_function_name := icx_call.decrypt2(UpdateAttachment.function_name);
399: l_entity_name := icx_call.decrypt2(UpdateAttachment.entity_name);
400: l_pk1_value := icx_call.decrypt2(UpdateAttachment.pk1_value);
401: l_pk2_value := icx_call.decrypt2(UpdateAttachment.pk2_value);
402: l_pk3_value := icx_call.decrypt2(UpdateAttachment.pk3_value);
403: l_pk4_value := icx_call.decrypt2(UpdateAttachment.pk4_value);
404: l_pk5_value := icx_call.decrypt2(UpdateAttachment.pk5_value);
397: icx_call.decrypt2(UpdateAttachment.attached_document_id);
398: l_function_name := icx_call.decrypt2(UpdateAttachment.function_name);
399: l_entity_name := icx_call.decrypt2(UpdateAttachment.entity_name);
400: l_pk1_value := icx_call.decrypt2(UpdateAttachment.pk1_value);
401: l_pk2_value := icx_call.decrypt2(UpdateAttachment.pk2_value);
402: l_pk3_value := icx_call.decrypt2(UpdateAttachment.pk3_value);
403: l_pk4_value := icx_call.decrypt2(UpdateAttachment.pk4_value);
404: l_pk5_value := icx_call.decrypt2(UpdateAttachment.pk5_value);
405: l_from_url := icx_call.decrypt2(UpdateAttachment.from_url);
398: l_function_name := icx_call.decrypt2(UpdateAttachment.function_name);
399: l_entity_name := icx_call.decrypt2(UpdateAttachment.entity_name);
400: l_pk1_value := icx_call.decrypt2(UpdateAttachment.pk1_value);
401: l_pk2_value := icx_call.decrypt2(UpdateAttachment.pk2_value);
402: l_pk3_value := icx_call.decrypt2(UpdateAttachment.pk3_value);
403: l_pk4_value := icx_call.decrypt2(UpdateAttachment.pk4_value);
404: l_pk5_value := icx_call.decrypt2(UpdateAttachment.pk5_value);
405: l_from_url := icx_call.decrypt2(UpdateAttachment.from_url);
406: l_query_only := icx_call.decrypt2(UpdateAttachment.query_only);
399: l_entity_name := icx_call.decrypt2(UpdateAttachment.entity_name);
400: l_pk1_value := icx_call.decrypt2(UpdateAttachment.pk1_value);
401: l_pk2_value := icx_call.decrypt2(UpdateAttachment.pk2_value);
402: l_pk3_value := icx_call.decrypt2(UpdateAttachment.pk3_value);
403: l_pk4_value := icx_call.decrypt2(UpdateAttachment.pk4_value);
404: l_pk5_value := icx_call.decrypt2(UpdateAttachment.pk5_value);
405: l_from_url := icx_call.decrypt2(UpdateAttachment.from_url);
406: l_query_only := icx_call.decrypt2(UpdateAttachment.query_only);
407:
400: l_pk1_value := icx_call.decrypt2(UpdateAttachment.pk1_value);
401: l_pk2_value := icx_call.decrypt2(UpdateAttachment.pk2_value);
402: l_pk3_value := icx_call.decrypt2(UpdateAttachment.pk3_value);
403: l_pk4_value := icx_call.decrypt2(UpdateAttachment.pk4_value);
404: l_pk5_value := icx_call.decrypt2(UpdateAttachment.pk5_value);
405: l_from_url := icx_call.decrypt2(UpdateAttachment.from_url);
406: l_query_only := icx_call.decrypt2(UpdateAttachment.query_only);
407:
408: -- Call the procedure that prints header
401: l_pk2_value := icx_call.decrypt2(UpdateAttachment.pk2_value);
402: l_pk3_value := icx_call.decrypt2(UpdateAttachment.pk3_value);
403: l_pk4_value := icx_call.decrypt2(UpdateAttachment.pk4_value);
404: l_pk5_value := icx_call.decrypt2(UpdateAttachment.pk5_value);
405: l_from_url := icx_call.decrypt2(UpdateAttachment.from_url);
406: l_query_only := icx_call.decrypt2(UpdateAttachment.query_only);
407:
408: -- Call the procedure that prints header
409: htp.htmlOpen;
402: l_pk3_value := icx_call.decrypt2(UpdateAttachment.pk3_value);
403: l_pk4_value := icx_call.decrypt2(UpdateAttachment.pk4_value);
404: l_pk5_value := icx_call.decrypt2(UpdateAttachment.pk5_value);
405: l_from_url := icx_call.decrypt2(UpdateAttachment.from_url);
406: l_query_only := icx_call.decrypt2(UpdateAttachment.query_only);
407:
408: -- Call the procedure that prints header
409: htp.htmlOpen;
410: htp.headOpen;
470: l_datatype_id number;
471: l_media_id number;
472: l_file_name varchar2(255);
473: l_attached_document_id varchar2(16) :=
474: icx_call.decrypt2(deleteattachment.attached_document_id);
475: begin
476:
477: -- Validate the session
478: if NOT (icx_sec.ValidateSession(null)) then
563: -- Set the language
564: l_lang := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
565:
566: -- Decrypt all the parameters.
567: l_function_name :=icx_call.decrypt2(AddAttachment.function_name);
568: l_entity_name := icx_call.decrypt2(AddAttachment.entity_name);
569: l_pk1_value := icx_call.decrypt2(AddAttachment.pk1_value);
570: l_pk2_value := icx_call.decrypt2(AddAttachment.pk2_value);
571: l_pk3_value := icx_call.decrypt2(AddAttachment.pk3_value);
564: l_lang := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
565:
566: -- Decrypt all the parameters.
567: l_function_name :=icx_call.decrypt2(AddAttachment.function_name);
568: l_entity_name := icx_call.decrypt2(AddAttachment.entity_name);
569: l_pk1_value := icx_call.decrypt2(AddAttachment.pk1_value);
570: l_pk2_value := icx_call.decrypt2(AddAttachment.pk2_value);
571: l_pk3_value := icx_call.decrypt2(AddAttachment.pk3_value);
572: l_pk4_value := icx_call.decrypt2(AddAttachment.pk4_value);
565:
566: -- Decrypt all the parameters.
567: l_function_name :=icx_call.decrypt2(AddAttachment.function_name);
568: l_entity_name := icx_call.decrypt2(AddAttachment.entity_name);
569: l_pk1_value := icx_call.decrypt2(AddAttachment.pk1_value);
570: l_pk2_value := icx_call.decrypt2(AddAttachment.pk2_value);
571: l_pk3_value := icx_call.decrypt2(AddAttachment.pk3_value);
572: l_pk4_value := icx_call.decrypt2(AddAttachment.pk4_value);
573: l_pk5_value := icx_call.decrypt2(AddAttachment.pk5_value);
566: -- Decrypt all the parameters.
567: l_function_name :=icx_call.decrypt2(AddAttachment.function_name);
568: l_entity_name := icx_call.decrypt2(AddAttachment.entity_name);
569: l_pk1_value := icx_call.decrypt2(AddAttachment.pk1_value);
570: l_pk2_value := icx_call.decrypt2(AddAttachment.pk2_value);
571: l_pk3_value := icx_call.decrypt2(AddAttachment.pk3_value);
572: l_pk4_value := icx_call.decrypt2(AddAttachment.pk4_value);
573: l_pk5_value := icx_call.decrypt2(AddAttachment.pk5_value);
574: l_from_url := icx_call.decrypt2(AddAttachment.from_url);
567: l_function_name :=icx_call.decrypt2(AddAttachment.function_name);
568: l_entity_name := icx_call.decrypt2(AddAttachment.entity_name);
569: l_pk1_value := icx_call.decrypt2(AddAttachment.pk1_value);
570: l_pk2_value := icx_call.decrypt2(AddAttachment.pk2_value);
571: l_pk3_value := icx_call.decrypt2(AddAttachment.pk3_value);
572: l_pk4_value := icx_call.decrypt2(AddAttachment.pk4_value);
573: l_pk5_value := icx_call.decrypt2(AddAttachment.pk5_value);
574: l_from_url := icx_call.decrypt2(AddAttachment.from_url);
575: l_query_only := icx_call.decrypt2(AddAttachment.query_only);
568: l_entity_name := icx_call.decrypt2(AddAttachment.entity_name);
569: l_pk1_value := icx_call.decrypt2(AddAttachment.pk1_value);
570: l_pk2_value := icx_call.decrypt2(AddAttachment.pk2_value);
571: l_pk3_value := icx_call.decrypt2(AddAttachment.pk3_value);
572: l_pk4_value := icx_call.decrypt2(AddAttachment.pk4_value);
573: l_pk5_value := icx_call.decrypt2(AddAttachment.pk5_value);
574: l_from_url := icx_call.decrypt2(AddAttachment.from_url);
575: l_query_only := icx_call.decrypt2(AddAttachment.query_only);
576:
569: l_pk1_value := icx_call.decrypt2(AddAttachment.pk1_value);
570: l_pk2_value := icx_call.decrypt2(AddAttachment.pk2_value);
571: l_pk3_value := icx_call.decrypt2(AddAttachment.pk3_value);
572: l_pk4_value := icx_call.decrypt2(AddAttachment.pk4_value);
573: l_pk5_value := icx_call.decrypt2(AddAttachment.pk5_value);
574: l_from_url := icx_call.decrypt2(AddAttachment.from_url);
575: l_query_only := icx_call.decrypt2(AddAttachment.query_only);
576:
577: -- Call the procedure that prints header
570: l_pk2_value := icx_call.decrypt2(AddAttachment.pk2_value);
571: l_pk3_value := icx_call.decrypt2(AddAttachment.pk3_value);
572: l_pk4_value := icx_call.decrypt2(AddAttachment.pk4_value);
573: l_pk5_value := icx_call.decrypt2(AddAttachment.pk5_value);
574: l_from_url := icx_call.decrypt2(AddAttachment.from_url);
575: l_query_only := icx_call.decrypt2(AddAttachment.query_only);
576:
577: -- Call the procedure that prints header
578: htp.htmlOpen;
571: l_pk3_value := icx_call.decrypt2(AddAttachment.pk3_value);
572: l_pk4_value := icx_call.decrypt2(AddAttachment.pk4_value);
573: l_pk5_value := icx_call.decrypt2(AddAttachment.pk5_value);
574: l_from_url := icx_call.decrypt2(AddAttachment.from_url);
575: l_query_only := icx_call.decrypt2(AddAttachment.query_only);
576:
577: -- Call the procedure that prints header
578: htp.htmlOpen;
579: htp.headOpen;
693: and ad.attached_document_id = to_number(l_attached_document_id);
694:
695: l_url varchar2(255);
696: l_file_name varchar2(255);
697: l_attached_document_id varchar2(16) := icx_call.decrypt2
698: (viewfiledocument.attached_document_id);
699: gfm_agent varchar2(255);
700: l_script_name varchar2(255);
701: l_media_id number;
1317: begin
1318:
1319: -- Redirect the URL to the file location
1320: owa_util.redirect_url (curl => owa_util.get_owa_service_path|| package_name||
1321: '.Summary?function_name='|| icx_call.encrypt2(function_name)
1322: ||'&'||'entity_name='||icx_call.encrypt2(entity_name)
1323: ||'&'||'pk1_value='||icx_call.encrypt2(pk1_value)
1324: ||'&'||'pk2_value='||icx_call.encrypt2(pk2_value)
1325: ||'&'||'pk3_value='||icx_call.encrypt2(pk3_value)
1318:
1319: -- Redirect the URL to the file location
1320: owa_util.redirect_url (curl => owa_util.get_owa_service_path|| package_name||
1321: '.Summary?function_name='|| icx_call.encrypt2(function_name)
1322: ||'&'||'entity_name='||icx_call.encrypt2(entity_name)
1323: ||'&'||'pk1_value='||icx_call.encrypt2(pk1_value)
1324: ||'&'||'pk2_value='||icx_call.encrypt2(pk2_value)
1325: ||'&'||'pk3_value='||icx_call.encrypt2(pk3_value)
1326: ||'&'||'pk4_value='||icx_call.encrypt2(pk4_value)
1319: -- Redirect the URL to the file location
1320: owa_util.redirect_url (curl => owa_util.get_owa_service_path|| package_name||
1321: '.Summary?function_name='|| icx_call.encrypt2(function_name)
1322: ||'&'||'entity_name='||icx_call.encrypt2(entity_name)
1323: ||'&'||'pk1_value='||icx_call.encrypt2(pk1_value)
1324: ||'&'||'pk2_value='||icx_call.encrypt2(pk2_value)
1325: ||'&'||'pk3_value='||icx_call.encrypt2(pk3_value)
1326: ||'&'||'pk4_value='||icx_call.encrypt2(pk4_value)
1327: ||'&'||'pk5_value='||icx_call.encrypt2(pk5_value)
1320: owa_util.redirect_url (curl => owa_util.get_owa_service_path|| package_name||
1321: '.Summary?function_name='|| icx_call.encrypt2(function_name)
1322: ||'&'||'entity_name='||icx_call.encrypt2(entity_name)
1323: ||'&'||'pk1_value='||icx_call.encrypt2(pk1_value)
1324: ||'&'||'pk2_value='||icx_call.encrypt2(pk2_value)
1325: ||'&'||'pk3_value='||icx_call.encrypt2(pk3_value)
1326: ||'&'||'pk4_value='||icx_call.encrypt2(pk4_value)
1327: ||'&'||'pk5_value='||icx_call.encrypt2(pk5_value)
1328: ||'&'||'from_url=' ||icx_call.encrypt2(from_url)
1321: '.Summary?function_name='|| icx_call.encrypt2(function_name)
1322: ||'&'||'entity_name='||icx_call.encrypt2(entity_name)
1323: ||'&'||'pk1_value='||icx_call.encrypt2(pk1_value)
1324: ||'&'||'pk2_value='||icx_call.encrypt2(pk2_value)
1325: ||'&'||'pk3_value='||icx_call.encrypt2(pk3_value)
1326: ||'&'||'pk4_value='||icx_call.encrypt2(pk4_value)
1327: ||'&'||'pk5_value='||icx_call.encrypt2(pk5_value)
1328: ||'&'||'from_url=' ||icx_call.encrypt2(from_url)
1329: ||'&'||'query_only='||icx_call.encrypt2(query_only));
1322: ||'&'||'entity_name='||icx_call.encrypt2(entity_name)
1323: ||'&'||'pk1_value='||icx_call.encrypt2(pk1_value)
1324: ||'&'||'pk2_value='||icx_call.encrypt2(pk2_value)
1325: ||'&'||'pk3_value='||icx_call.encrypt2(pk3_value)
1326: ||'&'||'pk4_value='||icx_call.encrypt2(pk4_value)
1327: ||'&'||'pk5_value='||icx_call.encrypt2(pk5_value)
1328: ||'&'||'from_url=' ||icx_call.encrypt2(from_url)
1329: ||'&'||'query_only='||icx_call.encrypt2(query_only));
1330:
1323: ||'&'||'pk1_value='||icx_call.encrypt2(pk1_value)
1324: ||'&'||'pk2_value='||icx_call.encrypt2(pk2_value)
1325: ||'&'||'pk3_value='||icx_call.encrypt2(pk3_value)
1326: ||'&'||'pk4_value='||icx_call.encrypt2(pk4_value)
1327: ||'&'||'pk5_value='||icx_call.encrypt2(pk5_value)
1328: ||'&'||'from_url=' ||icx_call.encrypt2(from_url)
1329: ||'&'||'query_only='||icx_call.encrypt2(query_only));
1330:
1331: end ReloadSummary;
1324: ||'&'||'pk2_value='||icx_call.encrypt2(pk2_value)
1325: ||'&'||'pk3_value='||icx_call.encrypt2(pk3_value)
1326: ||'&'||'pk4_value='||icx_call.encrypt2(pk4_value)
1327: ||'&'||'pk5_value='||icx_call.encrypt2(pk5_value)
1328: ||'&'||'from_url=' ||icx_call.encrypt2(from_url)
1329: ||'&'||'query_only='||icx_call.encrypt2(query_only));
1330:
1331: end ReloadSummary;
1332:
1325: ||'&'||'pk3_value='||icx_call.encrypt2(pk3_value)
1326: ||'&'||'pk4_value='||icx_call.encrypt2(pk4_value)
1327: ||'&'||'pk5_value='||icx_call.encrypt2(pk5_value)
1328: ||'&'||'from_url=' ||icx_call.encrypt2(from_url)
1329: ||'&'||'query_only='||icx_call.encrypt2(query_only));
1330:
1331: end ReloadSummary;
1332:
1333: -- Header
1558: if (atlstrec.datatype_id = 6) then
1559: htp.p('
1592: (atlstrec.datatype_id = 2) then
1593: htp.p('
1593: htp.p('
1594: htf.anchor2(owa_util.get_owa_service_path|| package_name
1595: ||'.ViewTextDocument?attached_document_id='||
1596: icx_call.encrypt2(to_char(atlstrec.attached_document_id))
1597: ||'&'||'function_name='||icx_call.encrypt2(function_name)
1598: ||'&'||'entity_name='||icx_call.encrypt2(entity_name)
1599: ||'&'||'pk1_value='||icx_call.encrypt2(pk1_value)
1600: ||'&'||'pk2_value='||icx_call.encrypt2(pk2_value)
1601: ||'&'||'pk3_value='||icx_call.encrypt2(pk3_value)
1602: ||'&'||'pk4_value='||icx_call.encrypt2(pk4_value)
1595: ||'.ViewTextDocument?attached_document_id='||
1596: icx_call.encrypt2(to_char(atlstrec.attached_document_id))
1597: ||'&'||'function_name='||icx_call.encrypt2(function_name)
1598: ||'&'||'entity_name='||icx_call.encrypt2(entity_name)
1599: ||'&'||'pk1_value='||icx_call.encrypt2(pk1_value)
1600: ||'&'||'pk2_value='||icx_call.encrypt2(pk2_value)
1601: ||'&'||'pk3_value='||icx_call.encrypt2(pk3_value)
1602: ||'&'||'pk4_value='||icx_call.encrypt2(pk4_value)
1603: ||'&'||'pk5_value='||icx_call.encrypt2(pk5_value)
1596: icx_call.encrypt2(to_char(atlstrec.attached_document_id))
1597: ||'&'||'function_name='||icx_call.encrypt2(function_name)
1598: ||'&'||'entity_name='||icx_call.encrypt2(entity_name)
1599: ||'&'||'pk1_value='||icx_call.encrypt2(pk1_value)
1600: ||'&'||'pk2_value='||icx_call.encrypt2(pk2_value)
1601: ||'&'||'pk3_value='||icx_call.encrypt2(pk3_value)
1602: ||'&'||'pk4_value='||icx_call.encrypt2(pk4_value)
1603: ||'&'||'pk5_value='||icx_call.encrypt2(pk5_value)
1604: ||'&'||'from_url='||icx_call.encrypt2(from_url)
1597: ||'&'||'function_name='||icx_call.encrypt2(function_name)
1598: ||'&'||'entity_name='||icx_call.encrypt2(entity_name)
1599: ||'&'||'pk1_value='||icx_call.encrypt2(pk1_value)
1600: ||'&'||'pk2_value='||icx_call.encrypt2(pk2_value)
1601: ||'&'||'pk3_value='||icx_call.encrypt2(pk3_value)
1602: ||'&'||'pk4_value='||icx_call.encrypt2(pk4_value)
1603: ||'&'||'pk5_value='||icx_call.encrypt2(pk5_value)
1604: ||'&'||'from_url='||icx_call.encrypt2(from_url)
1605: ||'&'||'query_only='||icx_call.encrypt2(query_only),
1598: ||'&'||'entity_name='||icx_call.encrypt2(entity_name)
1599: ||'&'||'pk1_value='||icx_call.encrypt2(pk1_value)
1600: ||'&'||'pk2_value='||icx_call.encrypt2(pk2_value)
1601: ||'&'||'pk3_value='||icx_call.encrypt2(pk3_value)
1602: ||'&'||'pk4_value='||icx_call.encrypt2(pk4_value)
1603: ||'&'||'pk5_value='||icx_call.encrypt2(pk5_value)
1604: ||'&'||'from_url='||icx_call.encrypt2(from_url)
1605: ||'&'||'query_only='||icx_call.encrypt2(query_only),
1606: htf.img2( '/OA_MEDIA/FNDIITMD.gif',
1599: ||'&'||'pk1_value='||icx_call.encrypt2(pk1_value)
1600: ||'&'||'pk2_value='||icx_call.encrypt2(pk2_value)
1601: ||'&'||'pk3_value='||icx_call.encrypt2(pk3_value)
1602: ||'&'||'pk4_value='||icx_call.encrypt2(pk4_value)
1603: ||'&'||'pk5_value='||icx_call.encrypt2(pk5_value)
1604: ||'&'||'from_url='||icx_call.encrypt2(from_url)
1605: ||'&'||'query_only='||icx_call.encrypt2(query_only),
1606: htf.img2( '/OA_MEDIA/FNDIITMD.gif',
1607: calt => fnd_message.get_string('FND','HE_VIEW')
1600: ||'&'||'pk2_value='||icx_call.encrypt2(pk2_value)
1601: ||'&'||'pk3_value='||icx_call.encrypt2(pk3_value)
1602: ||'&'||'pk4_value='||icx_call.encrypt2(pk4_value)
1603: ||'&'||'pk5_value='||icx_call.encrypt2(pk5_value)
1604: ||'&'||'from_url='||icx_call.encrypt2(from_url)
1605: ||'&'||'query_only='||icx_call.encrypt2(query_only),
1606: htf.img2( '/OA_MEDIA/FNDIITMD.gif',
1607: calt => fnd_message.get_string('FND','HE_VIEW')
1608: ||' '||atlstrec.datatype_name,
1601: ||'&'||'pk3_value='||icx_call.encrypt2(pk3_value)
1602: ||'&'||'pk4_value='||icx_call.encrypt2(pk4_value)
1603: ||'&'||'pk5_value='||icx_call.encrypt2(pk5_value)
1604: ||'&'||'from_url='||icx_call.encrypt2(from_url)
1605: ||'&'||'query_only='||icx_call.encrypt2(query_only),
1606: htf.img2( '/OA_MEDIA/FNDIITMD.gif',
1607: calt => fnd_message.get_string('FND','HE_VIEW')
1608: ||' '||atlstrec.datatype_name,
1609: cattributes => 'border=no'),
1621: (query_only <> 'Y') then
1622: htp.p('
1622: htp.p('
1623: htf.anchor2(owa_util.get_owa_service_path|| package_name
1624: ||'.UpdateAttachment?attached_document_id='||
1625: icx_call.encrypt2(to_char(atlstrec.attached_document_id))
1626: ||'&'||'function_name='||icx_call.encrypt2(function_name)
1627: ||'&'||'entity_name='||icx_call.encrypt2(entity_name)
1628: ||'&'||'pk1_value='||icx_call.encrypt2(pk1_value)
1629: ||'&'||'pk2_value='||icx_call.encrypt2(pk2_value)
1630: ||'&'||'pk3_value='||icx_call.encrypt2(pk3_value)
1631: ||'&'||'pk4_value='||icx_call.encrypt2(pk4_value)
1624: ||'.UpdateAttachment?attached_document_id='||
1625: icx_call.encrypt2(to_char(atlstrec.attached_document_id))
1626: ||'&'||'function_name='||icx_call.encrypt2(function_name)
1627: ||'&'||'entity_name='||icx_call.encrypt2(entity_name)
1628: ||'&'||'pk1_value='||icx_call.encrypt2(pk1_value)
1629: ||'&'||'pk2_value='||icx_call.encrypt2(pk2_value)
1630: ||'&'||'pk3_value='||icx_call.encrypt2(pk3_value)
1631: ||'&'||'pk4_value='||icx_call.encrypt2(pk4_value)
1632: ||'&'||'pk5_value='||icx_call.encrypt2(pk5_value)
1625: icx_call.encrypt2(to_char(atlstrec.attached_document_id))
1626: ||'&'||'function_name='||icx_call.encrypt2(function_name)
1627: ||'&'||'entity_name='||icx_call.encrypt2(entity_name)
1628: ||'&'||'pk1_value='||icx_call.encrypt2(pk1_value)
1629: ||'&'||'pk2_value='||icx_call.encrypt2(pk2_value)
1630: ||'&'||'pk3_value='||icx_call.encrypt2(pk3_value)
1631: ||'&'||'pk4_value='||icx_call.encrypt2(pk4_value)
1632: ||'&'||'pk5_value='||icx_call.encrypt2(pk5_value)
1633: ||'&'||'from_url='|| icx_call.encrypt2
1626: ||'&'||'function_name='||icx_call.encrypt2(function_name)
1627: ||'&'||'entity_name='||icx_call.encrypt2(entity_name)
1628: ||'&'||'pk1_value='||icx_call.encrypt2(pk1_value)
1629: ||'&'||'pk2_value='||icx_call.encrypt2(pk2_value)
1630: ||'&'||'pk3_value='||icx_call.encrypt2(pk3_value)
1631: ||'&'||'pk4_value='||icx_call.encrypt2(pk4_value)
1632: ||'&'||'pk5_value='||icx_call.encrypt2(pk5_value)
1633: ||'&'||'from_url='|| icx_call.encrypt2
1634: (replace(from_url,'&','%26'))
1627: ||'&'||'entity_name='||icx_call.encrypt2(entity_name)
1628: ||'&'||'pk1_value='||icx_call.encrypt2(pk1_value)
1629: ||'&'||'pk2_value='||icx_call.encrypt2(pk2_value)
1630: ||'&'||'pk3_value='||icx_call.encrypt2(pk3_value)
1631: ||'&'||'pk4_value='||icx_call.encrypt2(pk4_value)
1632: ||'&'||'pk5_value='||icx_call.encrypt2(pk5_value)
1633: ||'&'||'from_url='|| icx_call.encrypt2
1634: (replace(from_url,'&','%26'))
1635: ||'&'||'query_only='||icx_call.encrypt2(query_only),
1628: ||'&'||'pk1_value='||icx_call.encrypt2(pk1_value)
1629: ||'&'||'pk2_value='||icx_call.encrypt2(pk2_value)
1630: ||'&'||'pk3_value='||icx_call.encrypt2(pk3_value)
1631: ||'&'||'pk4_value='||icx_call.encrypt2(pk4_value)
1632: ||'&'||'pk5_value='||icx_call.encrypt2(pk5_value)
1633: ||'&'||'from_url='|| icx_call.encrypt2
1634: (replace(from_url,'&','%26'))
1635: ||'&'||'query_only='||icx_call.encrypt2(query_only),
1636: htf.img2( '/OA_MEDIA/FNDIEDIT.gif', calign => 'CENTER',
1629: ||'&'||'pk2_value='||icx_call.encrypt2(pk2_value)
1630: ||'&'||'pk3_value='||icx_call.encrypt2(pk3_value)
1631: ||'&'||'pk4_value='||icx_call.encrypt2(pk4_value)
1632: ||'&'||'pk5_value='||icx_call.encrypt2(pk5_value)
1633: ||'&'||'from_url='|| icx_call.encrypt2
1634: (replace(from_url,'&','%26'))
1635: ||'&'||'query_only='||icx_call.encrypt2(query_only),
1636: htf.img2( '/OA_MEDIA/FNDIEDIT.gif', calign => 'CENTER',
1637: calt => '''Edit Attachment''',
1631: ||'&'||'pk4_value='||icx_call.encrypt2(pk4_value)
1632: ||'&'||'pk5_value='||icx_call.encrypt2(pk5_value)
1633: ||'&'||'from_url='|| icx_call.encrypt2
1634: (replace(from_url,'&','%26'))
1635: ||'&'||'query_only='||icx_call.encrypt2(query_only),
1636: htf.img2( '/OA_MEDIA/FNDIEDIT.gif', calign => 'CENTER',
1637: calt => '''Edit Attachment''',
1638: cattributes => 'border=yes width=17 height=16'),
1639: cattributes=>'target="_top"')
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)
1652: ||'&'||'pk2_value='||icx_call.encrypt2(pk2_value)
1653: ||'&'||'pk4_value='||icx_call.encrypt2(pk4_value)
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)
1652: ||'&'||'pk2_value='||icx_call.encrypt2(pk2_value)
1653: ||'&'||'pk4_value='||icx_call.encrypt2(pk4_value)
1654: ||'&'||'pk5_value='||icx_call.encrypt2(pk5_value)
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)
1652: ||'&'||'pk2_value='||icx_call.encrypt2(pk2_value)
1653: ||'&'||'pk4_value='||icx_call.encrypt2(pk4_value)
1654: ||'&'||'pk5_value='||icx_call.encrypt2(pk5_value)
1655: ||'&'||'from_url='||
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)
1652: ||'&'||'pk2_value='||icx_call.encrypt2(pk2_value)
1653: ||'&'||'pk4_value='||icx_call.encrypt2(pk4_value)
1654: ||'&'||'pk5_value='||icx_call.encrypt2(pk5_value)
1655: ||'&'||'from_url='||
1656: icx_call.encrypt2(replace(from_url,'&','%26'))
1649: ||'&'||'function_name='||icx_call.encrypt2(function_name)
1650: ||'&'||'entity_name='||icx_call.encrypt2(entity_name)
1651: ||'&'||'pk1_value='||icx_call.encrypt2(pk1_value)
1652: ||'&'||'pk2_value='||icx_call.encrypt2(pk2_value)
1653: ||'&'||'pk4_value='||icx_call.encrypt2(pk4_value)
1654: ||'&'||'pk5_value='||icx_call.encrypt2(pk5_value)
1655: ||'&'||'from_url='||
1656: icx_call.encrypt2(replace(from_url,'&','%26'))
1657: ||'&'||'query_only='||icx_call.encrypt2(query_only)||''')',
1650: ||'&'||'entity_name='||icx_call.encrypt2(entity_name)
1651: ||'&'||'pk1_value='||icx_call.encrypt2(pk1_value)
1652: ||'&'||'pk2_value='||icx_call.encrypt2(pk2_value)
1653: ||'&'||'pk4_value='||icx_call.encrypt2(pk4_value)
1654: ||'&'||'pk5_value='||icx_call.encrypt2(pk5_value)
1655: ||'&'||'from_url='||
1656: icx_call.encrypt2(replace(from_url,'&','%26'))
1657: ||'&'||'query_only='||icx_call.encrypt2(query_only)||''')',
1658: htf.img2( '/OA_MEDIA/FNDIDELR.gif',
1652: ||'&'||'pk2_value='||icx_call.encrypt2(pk2_value)
1653: ||'&'||'pk4_value='||icx_call.encrypt2(pk4_value)
1654: ||'&'||'pk5_value='||icx_call.encrypt2(pk5_value)
1655: ||'&'||'from_url='||
1656: icx_call.encrypt2(replace(from_url,'&','%26'))
1657: ||'&'||'query_only='||icx_call.encrypt2(query_only)||''')',
1658: htf.img2( '/OA_MEDIA/FNDIDELR.gif',
1659: calign => 'CENTER', calt => '''Delete Attachment''',
1660: cattributes => 'border=yes width=17 height=16'))
1653: ||'&'||'pk4_value='||icx_call.encrypt2(pk4_value)
1654: ||'&'||'pk5_value='||icx_call.encrypt2(pk5_value)
1655: ||'&'||'from_url='||
1656: icx_call.encrypt2(replace(from_url,'&','%26'))
1657: ||'&'||'query_only='||icx_call.encrypt2(query_only)||''')',
1658: htf.img2( '/OA_MEDIA/FNDIDELR.gif',
1659: calign => 'CENTER', calt => '''Delete Attachment''',
1660: cattributes => 'border=yes width=17 height=16'))
1661: ||'
1705: htp.p('
1707:%20%20%20%20%20%20htp.p("
1711: ||'&'||'pk1_value='||icx_call.encrypt2(pk1_value)
1712: ||'&'||'pk2_value='||icx_call.encrypt2(pk2_value)
1713: ||'&'||'pk3_value='||icx_call.encrypt2(pk3_value)
1714: ||'&'||'pk4_value='||icx_call.encrypt2(pk4_value)
1715: ||'&'||'pk5_value='||icx_call.encrypt2(pk5_value)
1716: ||'&'||'from_url='||icx_call.encrypt2(replace(from_url,'&','%26'))
1717: ||'&'||'query_only='||icx_call.encrypt2(query_only)
1718: ||'"target="_parent">'
1719: ||fnd_message.get_string('FND','FND-WEBATCH-SUMMARY-ADD'));
1712: ||'&'||'pk2_value='||icx_call.encrypt2(pk2_value)
1713: ||'&'||'pk3_value='||icx_call.encrypt2(pk3_value)
1714: ||'&'||'pk4_value='||icx_call.encrypt2(pk4_value)
1715: ||'&'||'pk5_value='||icx_call.encrypt2(pk5_value)
1716: ||'&'||'from_url='||icx_call.encrypt2(replace(from_url,'&','%26'))
1717: ||'&'||'query_only='||icx_call.encrypt2(query_only)
1718: ||'"target="_parent">'
1719: ||fnd_message.get_string('FND','FND-WEBATCH-SUMMARY-ADD'));
1720: htp.p('
1713: ||'&'||'pk3_value='||icx_call.encrypt2(pk3_value)
1714: ||'&'||'pk4_value='||icx_call.encrypt2(pk4_value)
1715: ||'&'||'pk5_value='||icx_call.encrypt2(pk5_value)
1716: ||'&'||'from_url='||icx_call.encrypt2(replace(from_url,'&','%26'))
1717: ||'&'||'query_only='||icx_call.encrypt2(query_only)
1718: ||'"target="_parent">'
1719: ||fnd_message.get_string('FND','FND-WEBATCH-SUMMARY-ADD'));
1720: htp.p('');
1721: htp.p('