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 338: l_xml xmltype;

334: l_offset number;
335: l_amount number;
336: l_buffer varchar2(32767);
337: l_xml_doc clob;
338: l_xml xmltype;
339: l_date date;
340: l_date_offset number;
341: l_exchange_rate number;
342: xrate number;

Line 435: v_xml_1 xmltype;

431: and ba.BANK_ACCOUNT_ID = nvl(p_bank_acct_id, ba.BANK_ACCOUNT_ID)
432: and ba.CURRENCY_CODE = currency
433: and ba.ACCOUNT_OWNER_ORG_ID = nvl(p_legal_entity_id, ba.ACCOUNT_OWNER_ORG_ID);
434:
435: v_xml_1 xmltype;
436: v_xml_2 xmltype;
437: v_xml_3 xmltype;
438: v_exchange_rate number;
439: v_dummy number;

Line 436: v_xml_2 xmltype;

432: and ba.CURRENCY_CODE = currency
433: and ba.ACCOUNT_OWNER_ORG_ID = nvl(p_legal_entity_id, ba.ACCOUNT_OWNER_ORG_ID);
434:
435: v_xml_1 xmltype;
436: v_xml_2 xmltype;
437: v_xml_3 xmltype;
438: v_exchange_rate number;
439: v_dummy number;
440:

Line 437: v_xml_3 xmltype;

433: and ba.ACCOUNT_OWNER_ORG_ID = nvl(p_legal_entity_id, ba.ACCOUNT_OWNER_ORG_ID);
434:
435: v_xml_1 xmltype;
436: v_xml_2 xmltype;
437: v_xml_3 xmltype;
438: v_exchange_rate number;
439: v_dummy number;
440:
441: v_xml_seg1 xmltype;

Line 441: v_xml_seg1 xmltype;

437: v_xml_3 xmltype;
438: v_exchange_rate number;
439: v_dummy number;
440:
441: v_xml_seg1 xmltype;
442: v_xml_seg2 xmltype;
443: v_xml_seg3 xmltype;
444:
445: n_loop number :=0;

Line 442: v_xml_seg2 xmltype;

438: v_exchange_rate number;
439: v_dummy number;
440:
441: v_xml_seg1 xmltype;
442: v_xml_seg2 xmltype;
443: v_xml_seg3 xmltype;
444:
445: n_loop number :=0;
446:

Line 443: v_xml_seg3 xmltype;

439: v_dummy number;
440:
441: v_xml_seg1 xmltype;
442: v_xml_seg2 xmltype;
443: v_xml_seg3 xmltype;
444:
445: n_loop number :=0;
446:
447: begin

Line 1016: l_xml xmltype;

1012: l_offset number;
1013: l_amount number;
1014: l_buffer varchar2(32767);
1015: l_xml_doc clob;
1016: l_xml xmltype;
1017: l_exchange_rate number;
1018: xrate number;
1019: l_Bank_Branch_Name varchar2(100);
1020: l_Bank_ACCT_NAME varchar2(100);

Line 1199: l_xml xmltype;

1195: l_offset number;
1196: l_amount number;
1197: l_buffer varchar2(32767);
1198: l_xml_doc clob;
1199: l_xml xmltype;
1200: l_exchange_rate number;
1201: xrate number;
1202: l_Bank_Branch_Name varchar2(100);
1203: l_Bank_ACCT_NAME varchar2(100);