APPS.FND_WEBATTCH dependencies on ICX_CALL

Line 116: ||'.Summary?function_name=' || icx_call.encrypt2(g_function_name)

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)

Line 117: ||'&'||'entity_name='|| icx_call.encrypt2(g_entity_name)

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)

Line 118: ||'&'||'pk1_value='|| icx_call.encrypt2(g_pk1_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)

Line 119: ||'&'||'pk2_value='|| icx_call.encrypt2(g_pk2_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)

Line 120: ||'&'||'pk3_value='|| icx_call.encrypt2(g_pk3_value)

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);

Line 121: ||'&'||'pk4_value='|| icx_call.encrypt2(g_pk4_value)

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;

Line 122: ||'&'||'pk5_value='|| icx_call.encrypt2(g_pk5_value)

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:

Line 123: ||'&'||'from_url=' || icx_call.encrypt2(from_url)

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;

Line 124: ||'&'||'query_only='|| icx_call.encrypt2(query_only);

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:

Line 145: l_function_name varchar2(30) := icx_call.decrypt2(summary.function_name);

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);

Line 146: l_entity_name varchar2(40) := icx_call.decrypt2(summary.entity_name);

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);

Line 147: l_pk1_value varchar2(100) := icx_call.decrypt2(summary.pk1_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);

Line 148: l_pk2_value varchar2(100) := icx_call.decrypt2(summary.pk2_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);

Line 149: l_pk3_value varchar2(100) := icx_call.decrypt2(summary.pk3_value);

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);

Line 150: l_pk4_value varchar2(150) := icx_call.decrypt2(summary.pk4_value);

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);

Line 151: l_pk5_value varchar2(150) := icx_call.decrypt2(summary.pk5_value);

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');

Line 152: l_from_url varchar2(2000) := icx_call.decrypt2(summary.from_url);

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';

Line 153: l_query_only varchar2(100) := icx_call.decrypt2(summary.query_only);

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

Line 397: icx_call.decrypt2(UpdateAttachment.attached_document_id);

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);

Line 398: l_function_name := icx_call.decrypt2(UpdateAttachment.function_name);

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);

Line 399: l_entity_name := icx_call.decrypt2(UpdateAttachment.entity_name);

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);

Line 400: l_pk1_value := icx_call.decrypt2(UpdateAttachment.pk1_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);

Line 401: l_pk2_value := icx_call.decrypt2(UpdateAttachment.pk2_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);

Line 402: l_pk3_value := icx_call.decrypt2(UpdateAttachment.pk3_value);

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);

Line 403: l_pk4_value := icx_call.decrypt2(UpdateAttachment.pk4_value);

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:

Line 404: l_pk5_value := icx_call.decrypt2(UpdateAttachment.pk5_value);

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

Line 405: l_from_url := icx_call.decrypt2(UpdateAttachment.from_url);

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;

Line 406: l_query_only := icx_call.decrypt2(UpdateAttachment.query_only);

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;

Line 474: icx_call.decrypt2(deleteattachment.attached_document_id);

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

Line 567: l_function_name :=icx_call.decrypt2(AddAttachment.function_name);

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);

Line 568: l_entity_name := icx_call.decrypt2(AddAttachment.entity_name);

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);

Line 569: l_pk1_value := icx_call.decrypt2(AddAttachment.pk1_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);

Line 570: l_pk2_value := icx_call.decrypt2(AddAttachment.pk2_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);

Line 571: l_pk3_value := icx_call.decrypt2(AddAttachment.pk3_value);

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);

Line 572: l_pk4_value := icx_call.decrypt2(AddAttachment.pk4_value);

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:

Line 573: l_pk5_value := icx_call.decrypt2(AddAttachment.pk5_value);

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

Line 574: l_from_url := icx_call.decrypt2(AddAttachment.from_url);

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;

Line 575: l_query_only := icx_call.decrypt2(AddAttachment.query_only);

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;

Line 697: l_attached_document_id varchar2(16) := icx_call.decrypt2

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;

Line 1246: '.Summary?function_name='|| icx_call.encrypt2(function_name)

1242: begin
1243:
1244: -- Redirect the URL to the file location
1245: owa_util.redirect_url (curl => owa_util.get_owa_service_path|| package_name||
1246: '.Summary?function_name='|| icx_call.encrypt2(function_name)
1247: ||'&'||'entity_name='||icx_call.encrypt2(entity_name)
1248: ||'&'||'pk1_value='||icx_call.encrypt2(pk1_value)
1249: ||'&'||'pk2_value='||icx_call.encrypt2(pk2_value)
1250: ||'&'||'pk3_value='||icx_call.encrypt2(pk3_value)

Line 1247: ||'&'||'entity_name='||icx_call.encrypt2(entity_name)

1243:
1244: -- Redirect the URL to the file location
1245: owa_util.redirect_url (curl => owa_util.get_owa_service_path|| package_name||
1246: '.Summary?function_name='|| icx_call.encrypt2(function_name)
1247: ||'&'||'entity_name='||icx_call.encrypt2(entity_name)
1248: ||'&'||'pk1_value='||icx_call.encrypt2(pk1_value)
1249: ||'&'||'pk2_value='||icx_call.encrypt2(pk2_value)
1250: ||'&'||'pk3_value='||icx_call.encrypt2(pk3_value)
1251: ||'&'||'pk4_value='||icx_call.encrypt2(pk4_value)

Line 1248: ||'&'||'pk1_value='||icx_call.encrypt2(pk1_value)

1244: -- Redirect the URL to the file location
1245: owa_util.redirect_url (curl => owa_util.get_owa_service_path|| package_name||
1246: '.Summary?function_name='|| icx_call.encrypt2(function_name)
1247: ||'&'||'entity_name='||icx_call.encrypt2(entity_name)
1248: ||'&'||'pk1_value='||icx_call.encrypt2(pk1_value)
1249: ||'&'||'pk2_value='||icx_call.encrypt2(pk2_value)
1250: ||'&'||'pk3_value='||icx_call.encrypt2(pk3_value)
1251: ||'&'||'pk4_value='||icx_call.encrypt2(pk4_value)
1252: ||'&'||'pk5_value='||icx_call.encrypt2(pk5_value)

Line 1249: ||'&'||'pk2_value='||icx_call.encrypt2(pk2_value)

1245: owa_util.redirect_url (curl => owa_util.get_owa_service_path|| package_name||
1246: '.Summary?function_name='|| icx_call.encrypt2(function_name)
1247: ||'&'||'entity_name='||icx_call.encrypt2(entity_name)
1248: ||'&'||'pk1_value='||icx_call.encrypt2(pk1_value)
1249: ||'&'||'pk2_value='||icx_call.encrypt2(pk2_value)
1250: ||'&'||'pk3_value='||icx_call.encrypt2(pk3_value)
1251: ||'&'||'pk4_value='||icx_call.encrypt2(pk4_value)
1252: ||'&'||'pk5_value='||icx_call.encrypt2(pk5_value)
1253: ||'&'||'from_url=' ||icx_call.encrypt2(from_url)

Line 1250: ||'&'||'pk3_value='||icx_call.encrypt2(pk3_value)

1246: '.Summary?function_name='|| icx_call.encrypt2(function_name)
1247: ||'&'||'entity_name='||icx_call.encrypt2(entity_name)
1248: ||'&'||'pk1_value='||icx_call.encrypt2(pk1_value)
1249: ||'&'||'pk2_value='||icx_call.encrypt2(pk2_value)
1250: ||'&'||'pk3_value='||icx_call.encrypt2(pk3_value)
1251: ||'&'||'pk4_value='||icx_call.encrypt2(pk4_value)
1252: ||'&'||'pk5_value='||icx_call.encrypt2(pk5_value)
1253: ||'&'||'from_url=' ||icx_call.encrypt2(from_url)
1254: ||'&'||'query_only='||icx_call.encrypt2(query_only));

Line 1251: ||'&'||'pk4_value='||icx_call.encrypt2(pk4_value)

1247: ||'&'||'entity_name='||icx_call.encrypt2(entity_name)
1248: ||'&'||'pk1_value='||icx_call.encrypt2(pk1_value)
1249: ||'&'||'pk2_value='||icx_call.encrypt2(pk2_value)
1250: ||'&'||'pk3_value='||icx_call.encrypt2(pk3_value)
1251: ||'&'||'pk4_value='||icx_call.encrypt2(pk4_value)
1252: ||'&'||'pk5_value='||icx_call.encrypt2(pk5_value)
1253: ||'&'||'from_url=' ||icx_call.encrypt2(from_url)
1254: ||'&'||'query_only='||icx_call.encrypt2(query_only));
1255:

Line 1252: ||'&'||'pk5_value='||icx_call.encrypt2(pk5_value)

1248: ||'&'||'pk1_value='||icx_call.encrypt2(pk1_value)
1249: ||'&'||'pk2_value='||icx_call.encrypt2(pk2_value)
1250: ||'&'||'pk3_value='||icx_call.encrypt2(pk3_value)
1251: ||'&'||'pk4_value='||icx_call.encrypt2(pk4_value)
1252: ||'&'||'pk5_value='||icx_call.encrypt2(pk5_value)
1253: ||'&'||'from_url=' ||icx_call.encrypt2(from_url)
1254: ||'&'||'query_only='||icx_call.encrypt2(query_only));
1255:
1256: end ReloadSummary;

Line 1253: ||'&'||'from_url=' ||icx_call.encrypt2(from_url)

1249: ||'&'||'pk2_value='||icx_call.encrypt2(pk2_value)
1250: ||'&'||'pk3_value='||icx_call.encrypt2(pk3_value)
1251: ||'&'||'pk4_value='||icx_call.encrypt2(pk4_value)
1252: ||'&'||'pk5_value='||icx_call.encrypt2(pk5_value)
1253: ||'&'||'from_url=' ||icx_call.encrypt2(from_url)
1254: ||'&'||'query_only='||icx_call.encrypt2(query_only));
1255:
1256: end ReloadSummary;
1257:

Line 1254: ||'&'||'query_only='||icx_call.encrypt2(query_only));

1250: ||'&'||'pk3_value='||icx_call.encrypt2(pk3_value)
1251: ||'&'||'pk4_value='||icx_call.encrypt2(pk4_value)
1252: ||'&'||'pk5_value='||icx_call.encrypt2(pk5_value)
1253: ||'&'||'from_url=' ||icx_call.encrypt2(from_url)
1254: ||'&'||'query_only='||icx_call.encrypt2(query_only));
1255:
1256: end ReloadSummary;
1257:
1258: -- Header

Line 1487: ||icx_call.encrypt2(to_char(atlstrec.attached_document_id)),

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,
1491: cattributes => 'border=no'),