eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IEX_PAYMENT_CAMP_RPT_PKG dependencies on IEX_UTILITIES

Line 211: l_collector :=iex_utilities.get_lookup_meaning('IEX_ALL_TYPE','ALL');

207: END IF;
208: END IF;
209:
210: if p_collector is null then
211: l_collector :=iex_utilities.get_lookup_meaning('IEX_ALL_TYPE','ALL');
212: elsif p_campaign is null then
213: l_campaign:=iex_utilities.get_lookup_meaning('IEX_ALL_TYPE','ALL');
214: end if;
215:

Line 213: l_campaign:=iex_utilities.get_lookup_meaning('IEX_ALL_TYPE','ALL');

209:
210: if p_collector is null then
211: l_collector :=iex_utilities.get_lookup_meaning('IEX_ALL_TYPE','ALL');
212: elsif p_campaign is null then
213: l_campaign:=iex_utilities.get_lookup_meaning('IEX_ALL_TYPE','ALL');
214: end if;
215:
216: IF p_payment_type IS NOT NULL THEN
217: -- FND_FILE.put_line( FND_FILE.LOG,'4.7');

Line 225: l_pay_typ_meaning:=iex_utilities.get_lookup_meaning('IEX_ALL_TYPE','ALL');

221: from iex_lookups_v
222: where lookup_type='IEX_PAYMENT_TYPES'
223: and lookup_code=p_payment_type;
224: else
225: l_pay_typ_meaning:=iex_utilities.get_lookup_meaning('IEX_ALL_TYPE','ALL');
226: END IF;
227: --end of get filters
228: --report mode DETAIL
229: IF p_summ_det = 'DETAIL' THEN

Line 231: l_query := 'SELECT l.meaning payment_method,p.ipayment_status payment_status,IEX_UTILITIES.REPLACE_SPECIAL_CHARS(c.source_code) campaign,p.campaign_sched_id campaign_schedule_id ,'||

227: --end of get filters
228: --report mode DETAIL
229: IF p_summ_det = 'DETAIL' THEN
230:
231: l_query := 'SELECT l.meaning payment_method,p.ipayment_status payment_status,IEX_UTILITIES.REPLACE_SPECIAL_CHARS(c.source_code) campaign,p.campaign_sched_id campaign_schedule_id ,'||
232: 'to_char(p.creation_date,''YYYY-MM-DD'') payment_date,gl_currency_api.convert_amount(r.currency_code,'''||p_currency||''',sysdate,'''||l_coll_rate||''',r.amount) amount,'||
233: 'p.payment_id,d.delinquency_id,p.resource_id,IEX_UTILITIES.REPLACE_SPECIAL_CHARS(j.source_name) collector,IEX_UTILITIES.REPLACE_SPECIAL_CHARS(hca.account_number) account_number,'||
234: 'IEX_UTILITIES.REPLACE_SPECIAL_CHARS(s.trx_number) invoice_id,d.payment_schedule_id,s.class,'||
235: /*'gl_currency_api.convert_amount(r.currency_code,'''||p_currency||''',sysdate,'''||l_coll_rate||''',s.amount_due_remaining) amount_due_remaining,'|| commented for bug 14753025

Line 233: 'p.payment_id,d.delinquency_id,p.resource_id,IEX_UTILITIES.REPLACE_SPECIAL_CHARS(j.source_name) collector,IEX_UTILITIES.REPLACE_SPECIAL_CHARS(hca.account_number) account_number,'||

229: IF p_summ_det = 'DETAIL' THEN
230:
231: l_query := 'SELECT l.meaning payment_method,p.ipayment_status payment_status,IEX_UTILITIES.REPLACE_SPECIAL_CHARS(c.source_code) campaign,p.campaign_sched_id campaign_schedule_id ,'||
232: 'to_char(p.creation_date,''YYYY-MM-DD'') payment_date,gl_currency_api.convert_amount(r.currency_code,'''||p_currency||''',sysdate,'''||l_coll_rate||''',r.amount) amount,'||
233: 'p.payment_id,d.delinquency_id,p.resource_id,IEX_UTILITIES.REPLACE_SPECIAL_CHARS(j.source_name) collector,IEX_UTILITIES.REPLACE_SPECIAL_CHARS(hca.account_number) account_number,'||
234: 'IEX_UTILITIES.REPLACE_SPECIAL_CHARS(s.trx_number) invoice_id,d.payment_schedule_id,s.class,'||
235: /*'gl_currency_api.convert_amount(r.currency_code,'''||p_currency||''',sysdate,'''||l_coll_rate||''',s.amount_due_remaining) amount_due_remaining,'|| commented for bug 14753025
236: 'gl_currency_api.convert_amount(r.currency_code,'''||p_currency||''',sysdate,'''||l_coll_rate||''',s.amount_due_original) amount_due_original,'||*/
237: 'gl_currency_api.convert_amount(s.invoice_currency_code,'''||p_currency||''',sysdate,'''||l_coll_rate||''',s.amount_due_remaining) amount_due_remaining,'|| --added for bug 14753025

Line 234: 'IEX_UTILITIES.REPLACE_SPECIAL_CHARS(s.trx_number) invoice_id,d.payment_schedule_id,s.class,'||

230:
231: l_query := 'SELECT l.meaning payment_method,p.ipayment_status payment_status,IEX_UTILITIES.REPLACE_SPECIAL_CHARS(c.source_code) campaign,p.campaign_sched_id campaign_schedule_id ,'||
232: 'to_char(p.creation_date,''YYYY-MM-DD'') payment_date,gl_currency_api.convert_amount(r.currency_code,'''||p_currency||''',sysdate,'''||l_coll_rate||''',r.amount) amount,'||
233: 'p.payment_id,d.delinquency_id,p.resource_id,IEX_UTILITIES.REPLACE_SPECIAL_CHARS(j.source_name) collector,IEX_UTILITIES.REPLACE_SPECIAL_CHARS(hca.account_number) account_number,'||
234: 'IEX_UTILITIES.REPLACE_SPECIAL_CHARS(s.trx_number) invoice_id,d.payment_schedule_id,s.class,'||
235: /*'gl_currency_api.convert_amount(r.currency_code,'''||p_currency||''',sysdate,'''||l_coll_rate||''',s.amount_due_remaining) amount_due_remaining,'|| commented for bug 14753025
236: 'gl_currency_api.convert_amount(r.currency_code,'''||p_currency||''',sysdate,'''||l_coll_rate||''',s.amount_due_original) amount_due_original,'||*/
237: 'gl_currency_api.convert_amount(s.invoice_currency_code,'''||p_currency||''',sysdate,'''||l_coll_rate||''',s.amount_due_remaining) amount_due_remaining,'|| --added for bug 14753025
238: 'gl_currency_api.convert_amount(s.invoice_currency_code,'''||p_currency||''',sysdate,'''||l_coll_rate||''',s.amount_due_original) amount_due_original,'||

Line 276: l_query:='SELECT IEX_UTILITIES.REPLACE_SPECIAL_CHARS(c.source_code) Campaign,IEX_UTILITIES.REPLACE_SPECIAL_CHARS(j.source_name) Collector,'||

272: END IF;
273: END IF;
274:
275: --FND_FILE.put_line( FND_FILE.LOG,'5');
276: l_query:='SELECT IEX_UTILITIES.REPLACE_SPECIAL_CHARS(c.source_code) Campaign,IEX_UTILITIES.REPLACE_SPECIAL_CHARS(j.source_name) Collector,'||
277: 'SUM(gl_currency_api.convert_amount(r.currency_code,'''||p_currency||''',sysdate,'''||l_coll_rate||''',r.amount)) Total_Amount_Collected,'||
278: 'ROUND((SUM(gl_currency_api.convert_amount(r.currency_code,'''||p_currency||''',sysdate,'''||l_coll_rate||''',r.amount))/((to_date('''||l_to_date||
279: ''',''DD-MON-RRRR'')-to_date('''||l_from_date||''',''DD-MON-RRRR''))+1))/8,2) Hourly_Average,'||l_hourly_goal||' Hourly_Goal,'||
280: 'ROUND(((((SUM(gl_currency_api.convert_amount(r.currency_code,'''||p_currency||''',sysdate,'''||l_coll_rate||''',r.amount))/((to_date('''||l_to_date||

Line 299: l_group_by :=' group by IEX_UTILITIES.REPLACE_SPECIAL_CHARS(c.source_code),'||

295: 'AND c.source_code_id(+) = p.campaign_sched_id '|| 'AND p.resource_id = j.resource_id(+) '|| 'AND p.payment_id = xpr.payment_id and d.org_id = asp.org_id '||
296: 'AND r.cash_receipt_id = xpr.cash_receipt_id '|| 'AND l.lookup_type = ''IEX_PAYMENT_TYPES'' '|| 'AND p.payment_method = l.lookup_code '||
297: 'AND s.class =''INV'' ';
298:
299: l_group_by :=' group by IEX_UTILITIES.REPLACE_SPECIAL_CHARS(c.source_code),'||
300: ' IEX_UTILITIES.REPLACE_SPECIAL_CHARS(j.source_name)' ;
301: l_query:=l_query||l_where;
302: l_query:=l_query||l_group_by;
303: --call procedure to calculate pmt_cnt and pmt_amt

Line 300: ' IEX_UTILITIES.REPLACE_SPECIAL_CHARS(j.source_name)' ;

296: 'AND r.cash_receipt_id = xpr.cash_receipt_id '|| 'AND l.lookup_type = ''IEX_PAYMENT_TYPES'' '|| 'AND p.payment_method = l.lookup_code '||
297: 'AND s.class =''INV'' ';
298:
299: l_group_by :=' group by IEX_UTILITIES.REPLACE_SPECIAL_CHARS(c.source_code),'||
300: ' IEX_UTILITIES.REPLACE_SPECIAL_CHARS(j.source_name)' ;
301: l_query:=l_query||l_where;
302: l_query:=l_query||l_group_by;
303: --call procedure to calculate pmt_cnt and pmt_amt
304: FND_FILE.put_line( FND_FILE.LOG,'l_query_summ-->'||l_query);

Line 362: l_xml_header := l_xml_header ||l_new_line||' ' ||iex_utilities.get_lookup_meaning('IEX_REPORT_LEVEL',p_report_level)||'';

358: l_xml_header := l_xml_header ||l_new_line||' ' ||TO_CHAR(l_to_date,'YYYY-MM-DD') ||'';
359: l_xml_header := l_xml_header ||l_new_line||' ' ||p_currency||'';
360: l_xml_header := l_xml_header ||l_new_line||' ' ||''||'';
361: l_xml_header := l_xml_header ||l_new_line||' ' ||''||'';
362: l_xml_header := l_xml_header ||l_new_line||' ' ||iex_utilities.get_lookup_meaning('IEX_REPORT_LEVEL',p_report_level)||'';
363: l_xml_header := l_xml_header ||l_new_line||' ' ||iex_utilities.get_lookup_meaning('IEX_REPORT_MODE',p_summ_det)||'';
364: l_xml_header := l_xml_header ||l_new_line||' ' ||l_pay_typ_meaning||'';
365: FND_FILE.put_line( FND_FILE.LOG, 'xml header '|| l_xml_header);
366: IF p_summ_det ='SUMMARY' THEN

Line 363: l_xml_header := l_xml_header ||l_new_line||' ' ||iex_utilities.get_lookup_meaning('IEX_REPORT_MODE',p_summ_det)||'';

359: l_xml_header := l_xml_header ||l_new_line||' ' ||p_currency||'';
360: l_xml_header := l_xml_header ||l_new_line||' ' ||''||'';
361: l_xml_header := l_xml_header ||l_new_line||' ' ||''||'';
362: l_xml_header := l_xml_header ||l_new_line||' ' ||iex_utilities.get_lookup_meaning('IEX_REPORT_LEVEL',p_report_level)||'';
363: l_xml_header := l_xml_header ||l_new_line||' ' ||iex_utilities.get_lookup_meaning('IEX_REPORT_MODE',p_summ_det)||'';
364: l_xml_header := l_xml_header ||l_new_line||' ' ||l_pay_typ_meaning||'';
365: FND_FILE.put_line( FND_FILE.LOG, 'xml header '|| l_xml_header);
366: IF p_summ_det ='SUMMARY' THEN
367: l_xml_header := l_xml_header ||l_new_line||' ' ||iex_utilities.get_lookup_meaning('IEX_GOAL_TYPES',p_goal)||'';

Line 367: l_xml_header := l_xml_header ||l_new_line||' ' ||iex_utilities.get_lookup_meaning('IEX_GOAL_TYPES',p_goal)||'';

363: l_xml_header := l_xml_header ||l_new_line||' ' ||iex_utilities.get_lookup_meaning('IEX_REPORT_MODE',p_summ_det)||'';
364: l_xml_header := l_xml_header ||l_new_line||' ' ||l_pay_typ_meaning||'';
365: FND_FILE.put_line( FND_FILE.LOG, 'xml header '|| l_xml_header);
366: IF p_summ_det ='SUMMARY' THEN
367: l_xml_header := l_xml_header ||l_new_line||' ' ||iex_utilities.get_lookup_meaning('IEX_GOAL_TYPES',p_goal)||'';
368: l_xml_header := l_xml_header ||l_new_line||' ' ||p_goal_amount||'';
369: END IF;
370: l_xml_header := l_xml_header ||l_new_line||' ' ||''||'';
371: l_xml_header := l_xml_header ||l_new_line||' ' ||TO_CHAR(l_sysdate,'YYYY-MM-DD')||'';