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.PA_BILLING dependencies on FND_NUMBER

Line 264: ''',''' || x_calling_place || ''',fnd_number.canonical_to_number('''

260:
261: proc_stmt := 'declare s varchar2(240):=null; begin ' ||
262: get_rec.proc_name || '(' || to_char(x_project_id) ||
263: ','''',''' || x_calling_process ||
264: ''',''' || x_calling_place || ''',fnd_number.canonical_to_number('''
265: || fnd_number.number_to_canonical(get_rec.amt) ||
266: '''),fnd_number.canonical_to_number(''' ||
267: fnd_number.number_to_canonical(get_rec.percent) || '''), to_date(''' ||
268: x_rev_or_bill_date || ''', , ''' || 'YYYY/MM/DD' ||'''),' || to_char(get_rec.bea_id) || ',' ||

Line 265: || fnd_number.number_to_canonical(get_rec.amt) ||

261: proc_stmt := 'declare s varchar2(240):=null; begin ' ||
262: get_rec.proc_name || '(' || to_char(x_project_id) ||
263: ','''',''' || x_calling_process ||
264: ''',''' || x_calling_place || ''',fnd_number.canonical_to_number('''
265: || fnd_number.number_to_canonical(get_rec.amt) ||
266: '''),fnd_number.canonical_to_number(''' ||
267: fnd_number.number_to_canonical(get_rec.percent) || '''), to_date(''' ||
268: x_rev_or_bill_date || ''', , ''' || 'YYYY/MM/DD' ||'''),' || to_char(get_rec.bea_id) || ',' ||
269: to_char(get_rec.be_id) || ',' || to_char(x_request_id) ||

Line 266: '''),fnd_number.canonical_to_number(''' ||

262: get_rec.proc_name || '(' || to_char(x_project_id) ||
263: ','''',''' || x_calling_process ||
264: ''',''' || x_calling_place || ''',fnd_number.canonical_to_number('''
265: || fnd_number.number_to_canonical(get_rec.amt) ||
266: '''),fnd_number.canonical_to_number(''' ||
267: fnd_number.number_to_canonical(get_rec.percent) || '''), to_date(''' ||
268: x_rev_or_bill_date || ''', , ''' || 'YYYY/MM/DD' ||'''),' || to_char(get_rec.bea_id) || ',' ||
269: to_char(get_rec.be_id) || ',' || to_char(x_request_id) ||
270: '); end;';

Line 267: fnd_number.number_to_canonical(get_rec.percent) || '''), to_date(''' ||

263: ','''',''' || x_calling_process ||
264: ''',''' || x_calling_place || ''',fnd_number.canonical_to_number('''
265: || fnd_number.number_to_canonical(get_rec.amt) ||
266: '''),fnd_number.canonical_to_number(''' ||
267: fnd_number.number_to_canonical(get_rec.percent) || '''), to_date(''' ||
268: x_rev_or_bill_date || ''', , ''' || 'YYYY/MM/DD' ||'''),' || to_char(get_rec.bea_id) || ',' ||
269: to_char(get_rec.be_id) || ',' || to_char(x_request_id) ||
270: '); end;';
271: ELSE

Line 279: ''',''' || x_calling_place || ''',fnd_number.canonical_to_number('''

275:
276: proc_stmt := 'declare s varchar2(240):=null; begin ' ||
277: get_rec.proc_name || '(' || to_char(x_project_id) ||
278: ',' || task_rec.tpid || ',''' || x_calling_process ||
279: ''',''' || x_calling_place || ''',fnd_number.canonical_to_number('''
280: || fnd_number.number_to_canonical(get_rec.amt) ||
281: '''),fnd_number.canonical_to_number(''' ||
282: fnd_number.number_to_canonical(get_rec.percent) || '''), to_date(''' ||
283: x_rev_or_bill_date || ''', ''' || 'YYYY/MM/DD' ||'''),' || to_char(get_rec.bea_id) || ',' ||

Line 280: || fnd_number.number_to_canonical(get_rec.amt) ||

276: proc_stmt := 'declare s varchar2(240):=null; begin ' ||
277: get_rec.proc_name || '(' || to_char(x_project_id) ||
278: ',' || task_rec.tpid || ',''' || x_calling_process ||
279: ''',''' || x_calling_place || ''',fnd_number.canonical_to_number('''
280: || fnd_number.number_to_canonical(get_rec.amt) ||
281: '''),fnd_number.canonical_to_number(''' ||
282: fnd_number.number_to_canonical(get_rec.percent) || '''), to_date(''' ||
283: x_rev_or_bill_date || ''', ''' || 'YYYY/MM/DD' ||'''),' || to_char(get_rec.bea_id) || ',' ||
284: to_char(get_rec.be_id) || ',' || to_char(x_request_id) ||

Line 281: '''),fnd_number.canonical_to_number(''' ||

277: get_rec.proc_name || '(' || to_char(x_project_id) ||
278: ',' || task_rec.tpid || ',''' || x_calling_process ||
279: ''',''' || x_calling_place || ''',fnd_number.canonical_to_number('''
280: || fnd_number.number_to_canonical(get_rec.amt) ||
281: '''),fnd_number.canonical_to_number(''' ||
282: fnd_number.number_to_canonical(get_rec.percent) || '''), to_date(''' ||
283: x_rev_or_bill_date || ''', ''' || 'YYYY/MM/DD' ||'''),' || to_char(get_rec.bea_id) || ',' ||
284: to_char(get_rec.be_id) || ',' || to_char(x_request_id) ||
285: '); end;';

Line 282: fnd_number.number_to_canonical(get_rec.percent) || '''), to_date(''' ||

278: ',' || task_rec.tpid || ',''' || x_calling_process ||
279: ''',''' || x_calling_place || ''',fnd_number.canonical_to_number('''
280: || fnd_number.number_to_canonical(get_rec.amt) ||
281: '''),fnd_number.canonical_to_number(''' ||
282: fnd_number.number_to_canonical(get_rec.percent) || '''), to_date(''' ||
283: x_rev_or_bill_date || ''', ''' || 'YYYY/MM/DD' ||'''),' || to_char(get_rec.bea_id) || ',' ||
284: to_char(get_rec.be_id) || ',' || to_char(x_request_id) ||
285: '); end;';
286: END IF; */

Line 306: DBMS_SQL.BIND_VARIABLE(c, ':amt',fnd_number.number_to_canonical(get_rec.amt));

302: DBMS_SQL.BIND_VARIABLE(c, ':project_id', x_project_id);
303: DBMS_SQL.BIND_VARIABLE(c, ':task_id', task_rec.tpid);
304: DBMS_SQL.BIND_VARIABLE(c, ':calling_process',x_calling_process);
305: DBMS_SQL.BIND_VARIABLE(c, ':calling_place',x_calling_place);
306: DBMS_SQL.BIND_VARIABLE(c, ':amt',fnd_number.number_to_canonical(get_rec.amt));
307: DBMS_SQL.BIND_VARIABLE(c, ':percent',fnd_number.number_to_canonical(get_rec.percent));
308: DBMS_SQL.BIND_VARIABLE(c, ':rev_or_bill_date',TO_DATE(x_rev_or_bill_date,'YYYY/MM/DD'));
309: DBMS_SQL.BIND_VARIABLE(c, ':bea_id',get_rec.bea_id);
310: DBMS_SQL.BIND_VARIABLE(c, ':be_id',get_rec.be_id);

Line 307: DBMS_SQL.BIND_VARIABLE(c, ':percent',fnd_number.number_to_canonical(get_rec.percent));

303: DBMS_SQL.BIND_VARIABLE(c, ':task_id', task_rec.tpid);
304: DBMS_SQL.BIND_VARIABLE(c, ':calling_process',x_calling_process);
305: DBMS_SQL.BIND_VARIABLE(c, ':calling_place',x_calling_place);
306: DBMS_SQL.BIND_VARIABLE(c, ':amt',fnd_number.number_to_canonical(get_rec.amt));
307: DBMS_SQL.BIND_VARIABLE(c, ':percent',fnd_number.number_to_canonical(get_rec.percent));
308: DBMS_SQL.BIND_VARIABLE(c, ':rev_or_bill_date',TO_DATE(x_rev_or_bill_date,'YYYY/MM/DD'));
309: DBMS_SQL.BIND_VARIABLE(c, ':bea_id',get_rec.bea_id);
310: DBMS_SQL.BIND_VARIABLE(c, ':be_id',get_rec.be_id);
311: DBMS_SQL.BIND_VARIABLE(c, ':request_id',x_request_id);