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.LNS_FINANCIALS dependencies on DBMS_XMLDOM

Line 11805: l_doc dbms_xmldom.DOMDocument;

11801:
11802: l_api_name CONSTANT VARCHAR2(30) := 'LOAD_ORIGINAL_SCHEDULE';
11803: l_clob CLOB;
11804: l_parser dbms_xmlparser.Parser;
11805: l_doc dbms_xmldom.DOMDocument;
11806: l_nl dbms_xmldom.DOMNodeList;
11807: l_n dbms_xmldom.DOMNode;
11808: i number;
11809: l_data varchar2(2000);

Line 11806: l_nl dbms_xmldom.DOMNodeList;

11802: l_api_name CONSTANT VARCHAR2(30) := 'LOAD_ORIGINAL_SCHEDULE';
11803: l_clob CLOB;
11804: l_parser dbms_xmlparser.Parser;
11805: l_doc dbms_xmldom.DOMDocument;
11806: l_nl dbms_xmldom.DOMNodeList;
11807: l_n dbms_xmldom.DOMNode;
11808: i number;
11809: l_data varchar2(2000);
11810: l_loan_id number;

Line 11807: l_n dbms_xmldom.DOMNode;

11803: l_clob CLOB;
11804: l_parser dbms_xmlparser.Parser;
11805: l_doc dbms_xmldom.DOMDocument;
11806: l_nl dbms_xmldom.DOMNodeList;
11807: l_n dbms_xmldom.DOMNode;
11808: i number;
11809: l_data varchar2(2000);
11810: l_loan_id number;
11811: l_period_start_date date;

Line 11870: l_nl := dbms_xslprocessor.selectNodes(dbms_xmldom.makeNode(l_doc),'/LNSAGREEMENT/ROWSET/ROW/RATE_SCHEDULE/RATE_SCHEDULE_ROW');

11866: get_char2num_conv_chars(l_chars_to_replace, l_replace_chars);
11867:
11868: -- Get a list of all the RATE_SCHEDULE_ROW nodes in the document using the XPATH syntax.
11869: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Getting a list of all the RATE_SCHEDULE_ROW nodes...');
11870: l_nl := dbms_xslprocessor.selectNodes(dbms_xmldom.makeNode(l_doc),'/LNSAGREEMENT/ROWSET/ROW/RATE_SCHEDULE/RATE_SCHEDULE_ROW');
11871: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, ' ');
11872: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Rate schedule:');
11873: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'FROM TO RATE');
11874: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, '---- ---- ----');

Line 11878: FOR cur_emp IN 0 .. dbms_xmldom.getLength(l_nl) - 1 LOOP

11874: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, '---- ---- ----');
11875:
11876: i := 0;
11877: l_unknown_date_format := '?';
11878: FOR cur_emp IN 0 .. dbms_xmldom.getLength(l_nl) - 1 LOOP
11879: l_n := dbms_xmldom.item(l_nl, cur_emp);
11880: i := i+1;
11881:
11882: dbms_xslprocessor.valueOf(l_n,'INSTALLMENT_FROM/text()',l_data);

Line 11879: l_n := dbms_xmldom.item(l_nl, cur_emp);

11875:
11876: i := 0;
11877: l_unknown_date_format := '?';
11878: FOR cur_emp IN 0 .. dbms_xmldom.getLength(l_nl) - 1 LOOP
11879: l_n := dbms_xmldom.item(l_nl, cur_emp);
11880: i := i+1;
11881:
11882: dbms_xslprocessor.valueOf(l_n,'INSTALLMENT_FROM/text()',l_data);
11883: l_rate_schedule(i).BEGIN_INSTALLMENT_NUMBER := to_number(nvl(translate(l_data, l_chars_to_replace, l_replace_chars), 0));

Line 11897: l_nl := dbms_xslprocessor.selectNodes(dbms_xmldom.makeNode(l_doc),'/LNSAGREEMENT/ROWSET/ROW/AMORTIZATION/AMORTIZATION_ROW');

11893: END LOOP;
11894:
11895: -- Get a list of all the AMORTIZATION_ROW nodes in the document using the XPATH syntax.
11896: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Getting a list of all the AMORTIZATION_ROW nodes...');
11897: l_nl := dbms_xslprocessor.selectNodes(dbms_xmldom.makeNode(l_doc),'/LNSAGREEMENT/ROWSET/ROW/AMORTIZATION/AMORTIZATION_ROW');
11898:
11899: -- Loop through the list and create a new record in a tble collection
11900: -- for each EMP record.
11901:

Line 11905: FOR cur_emp IN 0 .. dbms_xmldom.getLength(l_nl) - 1 LOOP

11901:
11902: i := 0;
11903: l_period_start_date := p_loan_details.LOAN_START_DATE;
11904: l_FUNDED_AMOUNT := 0;
11905: FOR cur_emp IN 0 .. dbms_xmldom.getLength(l_nl) - 1 LOOP
11906: l_n := dbms_xmldom.item(l_nl, cur_emp);
11907: i := i+1;
11908:
11909: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, ' ');

Line 11906: l_n := dbms_xmldom.item(l_nl, cur_emp);

11902: i := 0;
11903: l_period_start_date := p_loan_details.LOAN_START_DATE;
11904: l_FUNDED_AMOUNT := 0;
11905: FOR cur_emp IN 0 .. dbms_xmldom.getLength(l_nl) - 1 LOOP
11906: l_n := dbms_xmldom.item(l_nl, cur_emp);
11907: i := i+1;
11908:
11909: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, ' ');
11910:

Line 12152: dbms_xmldom.freeDocument(l_doc);

12148:
12149: -- Free any resources associated with the document now it
12150: -- is no longer needed.
12151: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Freeing resources...');
12152: dbms_xmldom.freeDocument(l_doc);
12153: dbms_xmlparser.freeParser(l_parser);
12154:
12155: x_loan_amort_tbl := l_amort_tbl;
12156: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');

Line 12163: dbms_xmldom.freeDocument(l_doc);

12159: WHEN OTHERS THEN
12160: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, ' - in exception. Error: ' || sqlerrm);
12161: --dbms_lob.freetemporary(l_clob);
12162: dbms_xmlparser.freeParser(l_parser);
12163: dbms_xmldom.freeDocument(l_doc);
12164: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
12165: FND_MESSAGE.SET_TOKEN('ERROR' ,sqlerrm);
12166: FND_MSG_PUB.Add;
12167: END;