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 325: ''',''' || x_calling_place || ''',fnd_number.canonical_to_number('''

321:
322: proc_stmt := 'declare s varchar2(240):=null; begin ' ||
323: get_rec.proc_name || '(' || to_char(x_project_id) ||
324: ','''',''' || x_calling_process ||
325: ''',''' || x_calling_place || ''',fnd_number.canonical_to_number('''
326: || fnd_number.number_to_canonical(get_rec.amt) ||
327: '''),fnd_number.canonical_to_number(''' ||
328: fnd_number.number_to_canonical(get_rec.percent) || '''), to_date(''' ||
329: x_rev_or_bill_date || ''', , ''' || 'YYYY/MM/DD' ||'''),' || to_char(get_rec.bea_id) || ',' ||

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

322: proc_stmt := 'declare s varchar2(240):=null; begin ' ||
323: get_rec.proc_name || '(' || to_char(x_project_id) ||
324: ','''',''' || x_calling_process ||
325: ''',''' || x_calling_place || ''',fnd_number.canonical_to_number('''
326: || fnd_number.number_to_canonical(get_rec.amt) ||
327: '''),fnd_number.canonical_to_number(''' ||
328: fnd_number.number_to_canonical(get_rec.percent) || '''), to_date(''' ||
329: x_rev_or_bill_date || ''', , ''' || 'YYYY/MM/DD' ||'''),' || to_char(get_rec.bea_id) || ',' ||
330: to_char(get_rec.be_id) || ',' || to_char(x_request_id) ||

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

323: get_rec.proc_name || '(' || to_char(x_project_id) ||
324: ','''',''' || x_calling_process ||
325: ''',''' || x_calling_place || ''',fnd_number.canonical_to_number('''
326: || fnd_number.number_to_canonical(get_rec.amt) ||
327: '''),fnd_number.canonical_to_number(''' ||
328: fnd_number.number_to_canonical(get_rec.percent) || '''), to_date(''' ||
329: x_rev_or_bill_date || ''', , ''' || 'YYYY/MM/DD' ||'''),' || to_char(get_rec.bea_id) || ',' ||
330: to_char(get_rec.be_id) || ',' || to_char(x_request_id) ||
331: '); end;';

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

324: ','''',''' || x_calling_process ||
325: ''',''' || x_calling_place || ''',fnd_number.canonical_to_number('''
326: || fnd_number.number_to_canonical(get_rec.amt) ||
327: '''),fnd_number.canonical_to_number(''' ||
328: fnd_number.number_to_canonical(get_rec.percent) || '''), to_date(''' ||
329: x_rev_or_bill_date || ''', , ''' || 'YYYY/MM/DD' ||'''),' || to_char(get_rec.bea_id) || ',' ||
330: to_char(get_rec.be_id) || ',' || to_char(x_request_id) ||
331: '); end;';
332: ELSE

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

336:
337: proc_stmt := 'declare s varchar2(240):=null; begin ' ||
338: get_rec.proc_name || '(' || to_char(x_project_id) ||
339: ',' || task_rec.tpid || ',''' || x_calling_process ||
340: ''',''' || x_calling_place || ''',fnd_number.canonical_to_number('''
341: || fnd_number.number_to_canonical(get_rec.amt) ||
342: '''),fnd_number.canonical_to_number(''' ||
343: fnd_number.number_to_canonical(get_rec.percent) || '''), to_date(''' ||
344: x_rev_or_bill_date || ''', ''' || 'YYYY/MM/DD' ||'''),' || to_char(get_rec.bea_id) || ',' ||

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

337: proc_stmt := 'declare s varchar2(240):=null; begin ' ||
338: get_rec.proc_name || '(' || to_char(x_project_id) ||
339: ',' || task_rec.tpid || ',''' || x_calling_process ||
340: ''',''' || x_calling_place || ''',fnd_number.canonical_to_number('''
341: || fnd_number.number_to_canonical(get_rec.amt) ||
342: '''),fnd_number.canonical_to_number(''' ||
343: fnd_number.number_to_canonical(get_rec.percent) || '''), to_date(''' ||
344: x_rev_or_bill_date || ''', ''' || 'YYYY/MM/DD' ||'''),' || to_char(get_rec.bea_id) || ',' ||
345: to_char(get_rec.be_id) || ',' || to_char(x_request_id) ||

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

338: get_rec.proc_name || '(' || to_char(x_project_id) ||
339: ',' || task_rec.tpid || ',''' || x_calling_process ||
340: ''',''' || x_calling_place || ''',fnd_number.canonical_to_number('''
341: || fnd_number.number_to_canonical(get_rec.amt) ||
342: '''),fnd_number.canonical_to_number(''' ||
343: fnd_number.number_to_canonical(get_rec.percent) || '''), to_date(''' ||
344: x_rev_or_bill_date || ''', ''' || 'YYYY/MM/DD' ||'''),' || to_char(get_rec.bea_id) || ',' ||
345: to_char(get_rec.be_id) || ',' || to_char(x_request_id) ||
346: '); end;';

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

339: ',' || task_rec.tpid || ',''' || x_calling_process ||
340: ''',''' || x_calling_place || ''',fnd_number.canonical_to_number('''
341: || fnd_number.number_to_canonical(get_rec.amt) ||
342: '''),fnd_number.canonical_to_number(''' ||
343: fnd_number.number_to_canonical(get_rec.percent) || '''), to_date(''' ||
344: x_rev_or_bill_date || ''', ''' || 'YYYY/MM/DD' ||'''),' || to_char(get_rec.bea_id) || ',' ||
345: to_char(get_rec.be_id) || ',' || to_char(x_request_id) ||
346: '); end;';
347: END IF; */

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

363: DBMS_SQL.BIND_VARIABLE(c, ':project_id', x_project_id);
364: DBMS_SQL.BIND_VARIABLE(c, ':task_id', task_rec.tpid);
365: DBMS_SQL.BIND_VARIABLE(c, ':calling_process',x_calling_process);
366: DBMS_SQL.BIND_VARIABLE(c, ':calling_place',x_calling_place);
367: DBMS_SQL.BIND_VARIABLE(c, ':amt',fnd_number.number_to_canonical(get_rec.amt));
368: DBMS_SQL.BIND_VARIABLE(c, ':percent',fnd_number.number_to_canonical(get_rec.percent));
369: DBMS_SQL.BIND_VARIABLE(c, ':rev_or_bill_date',TO_DATE(x_rev_or_bill_date,'YYYY/MM/DD'));
370: DBMS_SQL.BIND_VARIABLE(c, ':bea_id',get_rec.bea_id);
371: DBMS_SQL.BIND_VARIABLE(c, ':be_id',get_rec.be_id);

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

364: DBMS_SQL.BIND_VARIABLE(c, ':task_id', task_rec.tpid);
365: DBMS_SQL.BIND_VARIABLE(c, ':calling_process',x_calling_process);
366: DBMS_SQL.BIND_VARIABLE(c, ':calling_place',x_calling_place);
367: DBMS_SQL.BIND_VARIABLE(c, ':amt',fnd_number.number_to_canonical(get_rec.amt));
368: DBMS_SQL.BIND_VARIABLE(c, ':percent',fnd_number.number_to_canonical(get_rec.percent));
369: DBMS_SQL.BIND_VARIABLE(c, ':rev_or_bill_date',TO_DATE(x_rev_or_bill_date,'YYYY/MM/DD'));
370: DBMS_SQL.BIND_VARIABLE(c, ':bea_id',get_rec.bea_id);
371: DBMS_SQL.BIND_VARIABLE(c, ':be_id',get_rec.be_id);
372: DBMS_SQL.BIND_VARIABLE(c, ':request_id',x_request_id);