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.CE_BANK_ACCT_BALANCE_REPORT dependencies on XMLTYPE

Line 349: l_xml xmltype;

345: l_offset number;
346: l_amount number;
347: l_buffer varchar2(32767);
348: l_xml_doc clob;
349: l_xml xmltype;
350: l_date date;
351: l_date_offset number;
352: l_exchange_rate number;
353: xrate number;

Line 449: v_xml_1 xmltype;

445: and ba.BANK_ACCOUNT_ID = nvl(p_bank_acct_id, ba.BANK_ACCOUNT_ID)
446: and ba.CURRENCY_CODE = currency
447: and ba.ACCOUNT_OWNER_ORG_ID = nvl(p_legal_entity_id, ba.ACCOUNT_OWNER_ORG_ID);
448:
449: v_xml_1 xmltype;
450: v_xml_2 xmltype;
451: v_xml_3 xmltype;
452: v_exchange_rate number;
453: v_dummy number;

Line 450: v_xml_2 xmltype;

446: and ba.CURRENCY_CODE = currency
447: and ba.ACCOUNT_OWNER_ORG_ID = nvl(p_legal_entity_id, ba.ACCOUNT_OWNER_ORG_ID);
448:
449: v_xml_1 xmltype;
450: v_xml_2 xmltype;
451: v_xml_3 xmltype;
452: v_exchange_rate number;
453: v_dummy number;
454:

Line 451: v_xml_3 xmltype;

447: and ba.ACCOUNT_OWNER_ORG_ID = nvl(p_legal_entity_id, ba.ACCOUNT_OWNER_ORG_ID);
448:
449: v_xml_1 xmltype;
450: v_xml_2 xmltype;
451: v_xml_3 xmltype;
452: v_exchange_rate number;
453: v_dummy number;
454:
455: v_xml_seg1 xmltype;

Line 455: v_xml_seg1 xmltype;

451: v_xml_3 xmltype;
452: v_exchange_rate number;
453: v_dummy number;
454:
455: v_xml_seg1 xmltype;
456: v_xml_seg2 xmltype;
457: v_xml_seg3 xmltype;
458:
459: n_loop number :=0;

Line 456: v_xml_seg2 xmltype;

452: v_exchange_rate number;
453: v_dummy number;
454:
455: v_xml_seg1 xmltype;
456: v_xml_seg2 xmltype;
457: v_xml_seg3 xmltype;
458:
459: n_loop number :=0;
460:

Line 457: v_xml_seg3 xmltype;

453: v_dummy number;
454:
455: v_xml_seg1 xmltype;
456: v_xml_seg2 xmltype;
457: v_xml_seg3 xmltype;
458:
459: n_loop number :=0;
460:
461: begin

Line 1047: l_xml xmltype;

1043: l_offset number;
1044: l_amount number;
1045: l_buffer varchar2(32767);
1046: l_xml_doc clob;
1047: l_xml xmltype;
1048: l_exchange_rate number;
1049: xrate number;
1050: l_Bank_Branch_Name varchar2(100);
1051: l_Bank_ACCT_NAME varchar2(100);

Line 1230: l_xml xmltype;

1226: l_offset number;
1227: l_amount number;
1228: l_buffer varchar2(32767);
1229: l_xml_doc clob;
1230: l_xml xmltype;
1231: l_exchange_rate number;
1232: xrate number;
1233: l_Bank_Branch_Name varchar2(100);
1234: l_Bank_ACCT_NAME varchar2(100);