57: p_primary_key => 'ICX_RQS_HISTORY_PK',
58: p1 => c_inputs1);
59:
60: if l_session_id is null then
61: url := c_dcdname || '/OracleOn.IC?Y=' || icx_call.encrypt2(l_param,-999);
62: else
63: url := c_dcdname || '/OracleOn.IC?Y=' || icx_call.encrypt2(l_param,l_session_id);
64: end if;
65: */
59:
60: if l_session_id is null then
61: url := c_dcdname || '/OracleOn.IC?Y=' || icx_call.encrypt2(l_param,-999);
62: else
63: url := c_dcdname || '/OracleOn.IC?Y=' || icx_call.encrypt2(l_param,l_session_id);
64: end if;
65: */
66:
67: fnd_webattch.Summary (function_name=>icx_call.encrypt2('ICX_REQS'),
63: url := c_dcdname || '/OracleOn.IC?Y=' || icx_call.encrypt2(l_param,l_session_id);
64: end if;
65: */
66:
67: fnd_webattch.Summary (function_name=>icx_call.encrypt2('ICX_REQS'),
68: entity_name=>icx_call.encrypt2('REQ_HEADERS'),
69: pk1_value=>icx_call.encrypt2(c_inputs1),
70: pk2_value=>icx_call.encrypt2(NULL),
71: pk3_value=>icx_call.encrypt2(NULL),
64: end if;
65: */
66:
67: fnd_webattch.Summary (function_name=>icx_call.encrypt2('ICX_REQS'),
68: entity_name=>icx_call.encrypt2('REQ_HEADERS'),
69: pk1_value=>icx_call.encrypt2(c_inputs1),
70: pk2_value=>icx_call.encrypt2(NULL),
71: pk3_value=>icx_call.encrypt2(NULL),
72: pk4_value=>icx_call.encrypt2( NULL),
65: */
66:
67: fnd_webattch.Summary (function_name=>icx_call.encrypt2('ICX_REQS'),
68: entity_name=>icx_call.encrypt2('REQ_HEADERS'),
69: pk1_value=>icx_call.encrypt2(c_inputs1),
70: pk2_value=>icx_call.encrypt2(NULL),
71: pk3_value=>icx_call.encrypt2(NULL),
72: pk4_value=>icx_call.encrypt2( NULL),
73: pk5_value=>icx_call.encrypt2(NULL),
66:
67: fnd_webattch.Summary (function_name=>icx_call.encrypt2('ICX_REQS'),
68: entity_name=>icx_call.encrypt2('REQ_HEADERS'),
69: pk1_value=>icx_call.encrypt2(c_inputs1),
70: pk2_value=>icx_call.encrypt2(NULL),
71: pk3_value=>icx_call.encrypt2(NULL),
72: pk4_value=>icx_call.encrypt2( NULL),
73: pk5_value=>icx_call.encrypt2(NULL),
74: from_url=>icx_call.encrypt2(NULL),
67: fnd_webattch.Summary (function_name=>icx_call.encrypt2('ICX_REQS'),
68: entity_name=>icx_call.encrypt2('REQ_HEADERS'),
69: pk1_value=>icx_call.encrypt2(c_inputs1),
70: pk2_value=>icx_call.encrypt2(NULL),
71: pk3_value=>icx_call.encrypt2(NULL),
72: pk4_value=>icx_call.encrypt2( NULL),
73: pk5_value=>icx_call.encrypt2(NULL),
74: from_url=>icx_call.encrypt2(NULL),
75: query_only=>icx_call.encrypt2('Y'));
68: entity_name=>icx_call.encrypt2('REQ_HEADERS'),
69: pk1_value=>icx_call.encrypt2(c_inputs1),
70: pk2_value=>icx_call.encrypt2(NULL),
71: pk3_value=>icx_call.encrypt2(NULL),
72: pk4_value=>icx_call.encrypt2( NULL),
73: pk5_value=>icx_call.encrypt2(NULL),
74: from_url=>icx_call.encrypt2(NULL),
75: query_only=>icx_call.encrypt2('Y'));
76:
69: pk1_value=>icx_call.encrypt2(c_inputs1),
70: pk2_value=>icx_call.encrypt2(NULL),
71: pk3_value=>icx_call.encrypt2(NULL),
72: pk4_value=>icx_call.encrypt2( NULL),
73: pk5_value=>icx_call.encrypt2(NULL),
74: from_url=>icx_call.encrypt2(NULL),
75: query_only=>icx_call.encrypt2('Y'));
76:
77: end if;
70: pk2_value=>icx_call.encrypt2(NULL),
71: pk3_value=>icx_call.encrypt2(NULL),
72: pk4_value=>icx_call.encrypt2( NULL),
73: pk5_value=>icx_call.encrypt2(NULL),
74: from_url=>icx_call.encrypt2(NULL),
75: query_only=>icx_call.encrypt2('Y'));
76:
77: end if;
78: end;
71: pk3_value=>icx_call.encrypt2(NULL),
72: pk4_value=>icx_call.encrypt2( NULL),
73: pk5_value=>icx_call.encrypt2(NULL),
74: from_url=>icx_call.encrypt2(NULL),
75: query_only=>icx_call.encrypt2('Y'));
76:
77: end if;
78: end;
79:
133: p_primary_key => 'ICX_RQS_HISTORY_PK',
134: p1 => c_inputs1);
135:
136: if l_session_id is null then
137: url := c_dcdname || '/OracleOn.IC?Y=' || icx_call.encrypt2(l_param,-999);
138: else
139: url := c_dcdname || '/OracleOn.IC?Y=' || icx_call.encrypt2(l_param,l_session_id);
140: end if;
141:
135:
136: if l_session_id is null then
137: url := c_dcdname || '/OracleOn.IC?Y=' || icx_call.encrypt2(l_param,-999);
138: else
139: url := c_dcdname || '/OracleOn.IC?Y=' || icx_call.encrypt2(l_param,l_session_id);
140: end if;
141:
142: */
143: fnd_webattch.Summary (function_name=>icx_call.encrypt2('ICX_REQS'),
139: url := c_dcdname || '/OracleOn.IC?Y=' || icx_call.encrypt2(l_param,l_session_id);
140: end if;
141:
142: */
143: fnd_webattch.Summary (function_name=>icx_call.encrypt2('ICX_REQS'),
144: entity_name=>icx_call.encrypt2('REQ_LINES'),
145: pk1_value=>icx_call.encrypt2(c_inputs2),
146: pk2_value=>icx_call.encrypt2(NULL),
147: pk3_value=>icx_call.encrypt2(NULL),
140: end if;
141:
142: */
143: fnd_webattch.Summary (function_name=>icx_call.encrypt2('ICX_REQS'),
144: entity_name=>icx_call.encrypt2('REQ_LINES'),
145: pk1_value=>icx_call.encrypt2(c_inputs2),
146: pk2_value=>icx_call.encrypt2(NULL),
147: pk3_value=>icx_call.encrypt2(NULL),
148: pk4_value=>icx_call.encrypt2( NULL),
141:
142: */
143: fnd_webattch.Summary (function_name=>icx_call.encrypt2('ICX_REQS'),
144: entity_name=>icx_call.encrypt2('REQ_LINES'),
145: pk1_value=>icx_call.encrypt2(c_inputs2),
146: pk2_value=>icx_call.encrypt2(NULL),
147: pk3_value=>icx_call.encrypt2(NULL),
148: pk4_value=>icx_call.encrypt2( NULL),
149: pk5_value=>icx_call.encrypt2(NULL),
142: */
143: fnd_webattch.Summary (function_name=>icx_call.encrypt2('ICX_REQS'),
144: entity_name=>icx_call.encrypt2('REQ_LINES'),
145: pk1_value=>icx_call.encrypt2(c_inputs2),
146: pk2_value=>icx_call.encrypt2(NULL),
147: pk3_value=>icx_call.encrypt2(NULL),
148: pk4_value=>icx_call.encrypt2( NULL),
149: pk5_value=>icx_call.encrypt2(NULL),
150: from_url=>icx_call.encrypt2(NULL),
143: fnd_webattch.Summary (function_name=>icx_call.encrypt2('ICX_REQS'),
144: entity_name=>icx_call.encrypt2('REQ_LINES'),
145: pk1_value=>icx_call.encrypt2(c_inputs2),
146: pk2_value=>icx_call.encrypt2(NULL),
147: pk3_value=>icx_call.encrypt2(NULL),
148: pk4_value=>icx_call.encrypt2( NULL),
149: pk5_value=>icx_call.encrypt2(NULL),
150: from_url=>icx_call.encrypt2(NULL),
151: query_only=>icx_call.encrypt2('Y'));
144: entity_name=>icx_call.encrypt2('REQ_LINES'),
145: pk1_value=>icx_call.encrypt2(c_inputs2),
146: pk2_value=>icx_call.encrypt2(NULL),
147: pk3_value=>icx_call.encrypt2(NULL),
148: pk4_value=>icx_call.encrypt2( NULL),
149: pk5_value=>icx_call.encrypt2(NULL),
150: from_url=>icx_call.encrypt2(NULL),
151: query_only=>icx_call.encrypt2('Y'));
152:
145: pk1_value=>icx_call.encrypt2(c_inputs2),
146: pk2_value=>icx_call.encrypt2(NULL),
147: pk3_value=>icx_call.encrypt2(NULL),
148: pk4_value=>icx_call.encrypt2( NULL),
149: pk5_value=>icx_call.encrypt2(NULL),
150: from_url=>icx_call.encrypt2(NULL),
151: query_only=>icx_call.encrypt2('Y'));
152:
153: end if;
146: pk2_value=>icx_call.encrypt2(NULL),
147: pk3_value=>icx_call.encrypt2(NULL),
148: pk4_value=>icx_call.encrypt2( NULL),
149: pk5_value=>icx_call.encrypt2(NULL),
150: from_url=>icx_call.encrypt2(NULL),
151: query_only=>icx_call.encrypt2('Y'));
152:
153: end if;
154: end;
147: pk3_value=>icx_call.encrypt2(NULL),
148: pk4_value=>icx_call.encrypt2( NULL),
149: pk5_value=>icx_call.encrypt2(NULL),
150: from_url=>icx_call.encrypt2(NULL),
151: query_only=>icx_call.encrypt2('Y'));
152:
153: end if;
154: end;
155:
212: p_primary_key => 'ICX_RQS_HISTORY_PK',
213: p1 => c_inputs1);
214:
215: if l_session_id is null then
216: url := c_dcdname || '/OracleOn.IC?Y=' || icx_call.encrypt2(l_param,-999);
217: else
218: url := c_dcdname || '/OracleOn.IC?Y=' || icx_call.encrypt2(l_param,l_session_id);
219: end if;
220: */
214:
215: if l_session_id is null then
216: url := c_dcdname || '/OracleOn.IC?Y=' || icx_call.encrypt2(l_param,-999);
217: else
218: url := c_dcdname || '/OracleOn.IC?Y=' || icx_call.encrypt2(l_param,l_session_id);
219: end if;
220: */
221: select REQUISITION_HEADER_ID into pk1
222: from icx_po_requisition_open_v
221: select REQUISITION_HEADER_ID into pk1
222: from icx_po_requisition_open_v
223: where REQUISITION_LINE_ID = c_inputs1;
224:
225: fnd_webattch.Summary (function_name=>icx_call.encrypt2('ICX_REQS'),
226: entity_name=>icx_call.encrypt2('REQ_LINES'),
227: pk1_value=>icx_call.encrypt2(c_inputs1),
228: pk2_value=>icx_call.encrypt2(NULL),
229: pk3_value=>icx_call.encrypt2(NULL),
222: from icx_po_requisition_open_v
223: where REQUISITION_LINE_ID = c_inputs1;
224:
225: fnd_webattch.Summary (function_name=>icx_call.encrypt2('ICX_REQS'),
226: entity_name=>icx_call.encrypt2('REQ_LINES'),
227: pk1_value=>icx_call.encrypt2(c_inputs1),
228: pk2_value=>icx_call.encrypt2(NULL),
229: pk3_value=>icx_call.encrypt2(NULL),
230: pk4_value=>icx_call.encrypt2( NULL),
223: where REQUISITION_LINE_ID = c_inputs1;
224:
225: fnd_webattch.Summary (function_name=>icx_call.encrypt2('ICX_REQS'),
226: entity_name=>icx_call.encrypt2('REQ_LINES'),
227: pk1_value=>icx_call.encrypt2(c_inputs1),
228: pk2_value=>icx_call.encrypt2(NULL),
229: pk3_value=>icx_call.encrypt2(NULL),
230: pk4_value=>icx_call.encrypt2( NULL),
231: pk5_value=>icx_call.encrypt2(NULL),
224:
225: fnd_webattch.Summary (function_name=>icx_call.encrypt2('ICX_REQS'),
226: entity_name=>icx_call.encrypt2('REQ_LINES'),
227: pk1_value=>icx_call.encrypt2(c_inputs1),
228: pk2_value=>icx_call.encrypt2(NULL),
229: pk3_value=>icx_call.encrypt2(NULL),
230: pk4_value=>icx_call.encrypt2( NULL),
231: pk5_value=>icx_call.encrypt2(NULL),
232: from_url=>icx_call.encrypt2(NULL),
225: fnd_webattch.Summary (function_name=>icx_call.encrypt2('ICX_REQS'),
226: entity_name=>icx_call.encrypt2('REQ_LINES'),
227: pk1_value=>icx_call.encrypt2(c_inputs1),
228: pk2_value=>icx_call.encrypt2(NULL),
229: pk3_value=>icx_call.encrypt2(NULL),
230: pk4_value=>icx_call.encrypt2( NULL),
231: pk5_value=>icx_call.encrypt2(NULL),
232: from_url=>icx_call.encrypt2(NULL),
233: query_only=>icx_call.encrypt2('Y'));
226: entity_name=>icx_call.encrypt2('REQ_LINES'),
227: pk1_value=>icx_call.encrypt2(c_inputs1),
228: pk2_value=>icx_call.encrypt2(NULL),
229: pk3_value=>icx_call.encrypt2(NULL),
230: pk4_value=>icx_call.encrypt2( NULL),
231: pk5_value=>icx_call.encrypt2(NULL),
232: from_url=>icx_call.encrypt2(NULL),
233: query_only=>icx_call.encrypt2('Y'));
234:
227: pk1_value=>icx_call.encrypt2(c_inputs1),
228: pk2_value=>icx_call.encrypt2(NULL),
229: pk3_value=>icx_call.encrypt2(NULL),
230: pk4_value=>icx_call.encrypt2( NULL),
231: pk5_value=>icx_call.encrypt2(NULL),
232: from_url=>icx_call.encrypt2(NULL),
233: query_only=>icx_call.encrypt2('Y'));
234:
235: end if;
228: pk2_value=>icx_call.encrypt2(NULL),
229: pk3_value=>icx_call.encrypt2(NULL),
230: pk4_value=>icx_call.encrypt2( NULL),
231: pk5_value=>icx_call.encrypt2(NULL),
232: from_url=>icx_call.encrypt2(NULL),
233: query_only=>icx_call.encrypt2('Y'));
234:
235: end if;
236: end;
229: pk3_value=>icx_call.encrypt2(NULL),
230: pk4_value=>icx_call.encrypt2( NULL),
231: pk5_value=>icx_call.encrypt2(NULL),
232: from_url=>icx_call.encrypt2(NULL),
233: query_only=>icx_call.encrypt2('Y'));
234:
235: end if;
236: end;
237: