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_REP_UTILS dependencies on DBMS_XMLQUERY

Line 206: ctx DBMS_XMLQUERY.ctxType;

202: ,INCLUDE_CHARTS IN VARCHAR2
203: ) IS
204: l_api_name CONSTANT VARCHAR2(30) := 'PROCESS_PORTFOLIO_REPORT';
205: l_api_version CONSTANT NUMBER := 1.0;
206: ctx DBMS_XMLQUERY.ctxType;
207: result CLOB;
208: qryCtx DBMS_XMLGEN.ctxHandle;
209: l_result CLOB;
210: tempResult CLOB;

Line 220: queryCtx DBMS_XMLquery.ctxType;

216: l_xml_header varchar2(3000);
217: l_xml_header_length number;
218: l_errNo NUMBER;
219: l_errMsg VARCHAR2(200);
220: queryCtx DBMS_XMLquery.ctxType;
221: l_xml_query VARCHAR2(32767);
222: TYPE ref_cur IS REF CURSOR;
223: l_xml_stmt ref_cur;
224: l_rows_processed NUMBER;

Line 483: ctx := DBMS_XMLQUERY.newContext(l_query);

479: INTO l_loan_officer
480: FROM jtf_rs_resource_extns
481: WHERE resource_id = loan_assigned_to;
482: END IF;
483: ctx := DBMS_XMLQUERY.newContext(l_query);
484: LogMessage(FND_LOG.LEVEL_STATEMENT, 'after DBMS_XMLQUERY.newContext');
485:
486: -- Bind Mandatory Variables
487: DBMS_XMLQuery.setBindValue(ctx, 'LOAN_CLASS', loan_class);

Line 484: LogMessage(FND_LOG.LEVEL_STATEMENT, 'after DBMS_XMLQUERY.newContext');

480: FROM jtf_rs_resource_extns
481: WHERE resource_id = loan_assigned_to;
482: END IF;
483: ctx := DBMS_XMLQUERY.newContext(l_query);
484: LogMessage(FND_LOG.LEVEL_STATEMENT, 'after DBMS_XMLQUERY.newContext');
485:
486: -- Bind Mandatory Variables
487: DBMS_XMLQuery.setBindValue(ctx, 'LOAN_CLASS', loan_class);
488: DBMS_XMLQuery.setBindValue(ctx, 'LOAN_TYPE_ID', loan_type_id);

Line 487: DBMS_XMLQuery.setBindValue(ctx, 'LOAN_CLASS', loan_class);

483: ctx := DBMS_XMLQUERY.newContext(l_query);
484: LogMessage(FND_LOG.LEVEL_STATEMENT, 'after DBMS_XMLQUERY.newContext');
485:
486: -- Bind Mandatory Variables
487: DBMS_XMLQuery.setBindValue(ctx, 'LOAN_CLASS', loan_class);
488: DBMS_XMLQuery.setBindValue(ctx, 'LOAN_TYPE_ID', loan_type_id);
489: DBMS_XMLQuery.setBindValue(ctx, 'CURRENCY_CODE', currency_code);
490: DBMS_XMLQuery.setBindValue(ctx, 'ORG_ID', l_org_id);
491: LogMessage(FND_LOG.LEVEL_STATEMENT, 'after DBMS_XMLQuery.setBindValue');

Line 488: DBMS_XMLQuery.setBindValue(ctx, 'LOAN_TYPE_ID', loan_type_id);

484: LogMessage(FND_LOG.LEVEL_STATEMENT, 'after DBMS_XMLQUERY.newContext');
485:
486: -- Bind Mandatory Variables
487: DBMS_XMLQuery.setBindValue(ctx, 'LOAN_CLASS', loan_class);
488: DBMS_XMLQuery.setBindValue(ctx, 'LOAN_TYPE_ID', loan_type_id);
489: DBMS_XMLQuery.setBindValue(ctx, 'CURRENCY_CODE', currency_code);
490: DBMS_XMLQuery.setBindValue(ctx, 'ORG_ID', l_org_id);
491: LogMessage(FND_LOG.LEVEL_STATEMENT, 'after DBMS_XMLQuery.setBindValue');
492:

Line 489: DBMS_XMLQuery.setBindValue(ctx, 'CURRENCY_CODE', currency_code);

485:
486: -- Bind Mandatory Variables
487: DBMS_XMLQuery.setBindValue(ctx, 'LOAN_CLASS', loan_class);
488: DBMS_XMLQuery.setBindValue(ctx, 'LOAN_TYPE_ID', loan_type_id);
489: DBMS_XMLQuery.setBindValue(ctx, 'CURRENCY_CODE', currency_code);
490: DBMS_XMLQuery.setBindValue(ctx, 'ORG_ID', l_org_id);
491: LogMessage(FND_LOG.LEVEL_STATEMENT, 'after DBMS_XMLQuery.setBindValue');
492:
493: -- Bind Optional Variables if they are NOT NULL

Line 490: DBMS_XMLQuery.setBindValue(ctx, 'ORG_ID', l_org_id);

486: -- Bind Mandatory Variables
487: DBMS_XMLQuery.setBindValue(ctx, 'LOAN_CLASS', loan_class);
488: DBMS_XMLQuery.setBindValue(ctx, 'LOAN_TYPE_ID', loan_type_id);
489: DBMS_XMLQuery.setBindValue(ctx, 'CURRENCY_CODE', currency_code);
490: DBMS_XMLQuery.setBindValue(ctx, 'ORG_ID', l_org_id);
491: LogMessage(FND_LOG.LEVEL_STATEMENT, 'after DBMS_XMLQuery.setBindValue');
492:
493: -- Bind Optional Variables if they are NOT NULL
494: IF borrower_id is NOT NULL

Line 491: LogMessage(FND_LOG.LEVEL_STATEMENT, 'after DBMS_XMLQuery.setBindValue');

487: DBMS_XMLQuery.setBindValue(ctx, 'LOAN_CLASS', loan_class);
488: DBMS_XMLQuery.setBindValue(ctx, 'LOAN_TYPE_ID', loan_type_id);
489: DBMS_XMLQuery.setBindValue(ctx, 'CURRENCY_CODE', currency_code);
490: DBMS_XMLQuery.setBindValue(ctx, 'ORG_ID', l_org_id);
491: LogMessage(FND_LOG.LEVEL_STATEMENT, 'after DBMS_XMLQuery.setBindValue');
492:
493: -- Bind Optional Variables if they are NOT NULL
494: IF borrower_id is NOT NULL
495: THEN

Line 496: DBMS_XMLQuery.setBindValue(ctx, 'BORROWER_ID', borrower_id);

492:
493: -- Bind Optional Variables if they are NOT NULL
494: IF borrower_id is NOT NULL
495: THEN
496: DBMS_XMLQuery.setBindValue(ctx, 'BORROWER_ID', borrower_id);
497: END IF;
498: IF loan_number is NOT NULL
499: THEN
500: DBMS_XMLQuery.setBindValue(ctx, 'LOAN_NUMBER', loan_number);

Line 500: DBMS_XMLQuery.setBindValue(ctx, 'LOAN_NUMBER', loan_number);

496: DBMS_XMLQuery.setBindValue(ctx, 'BORROWER_ID', borrower_id);
497: END IF;
498: IF loan_number is NOT NULL
499: THEN
500: DBMS_XMLQuery.setBindValue(ctx, 'LOAN_NUMBER', loan_number);
501: END IF;
502: IF cust_account_id is NOT NULL
503: THEN
504: DBMS_XMLQuery.setBindValue(ctx, 'CUST_ACCOUNT_ID', cust_account_id);

Line 504: DBMS_XMLQuery.setBindValue(ctx, 'CUST_ACCOUNT_ID', cust_account_id);

500: DBMS_XMLQuery.setBindValue(ctx, 'LOAN_NUMBER', loan_number);
501: END IF;
502: IF cust_account_id is NOT NULL
503: THEN
504: DBMS_XMLQuery.setBindValue(ctx, 'CUST_ACCOUNT_ID', cust_account_id);
505: END IF;
506: IF legal_entity_id is NOT NULL
507: THEN
508: DBMS_XMLQuery.setBindValue(ctx, 'LEGAL_ENTITY_ID', legal_entity_id);

Line 508: DBMS_XMLQuery.setBindValue(ctx, 'LEGAL_ENTITY_ID', legal_entity_id);

504: DBMS_XMLQuery.setBindValue(ctx, 'CUST_ACCOUNT_ID', cust_account_id);
505: END IF;
506: IF legal_entity_id is NOT NULL
507: THEN
508: DBMS_XMLQuery.setBindValue(ctx, 'LEGAL_ENTITY_ID', legal_entity_id);
509: END IF;
510: IF loan_assigned_to is NOT NULL
511: THEN
512: DBMS_XMLQuery.setBindValue(ctx, 'LOAN_ASSIGNED_TO', loan_assigned_to);

Line 512: DBMS_XMLQuery.setBindValue(ctx, 'LOAN_ASSIGNED_TO', loan_assigned_to);

508: DBMS_XMLQuery.setBindValue(ctx, 'LEGAL_ENTITY_ID', legal_entity_id);
509: END IF;
510: IF loan_assigned_to is NOT NULL
511: THEN
512: DBMS_XMLQuery.setBindValue(ctx, 'LOAN_ASSIGNED_TO', loan_assigned_to);
513: END IF;
514: IF product_id is NOT NULL
515: THEN
516: DBMS_XMLQuery.setBindValue(ctx, 'PRODUCT_ID', product_id);

Line 516: DBMS_XMLQuery.setBindValue(ctx, 'PRODUCT_ID', product_id);

512: DBMS_XMLQuery.setBindValue(ctx, 'LOAN_ASSIGNED_TO', loan_assigned_to);
513: END IF;
514: IF product_id is NOT NULL
515: THEN
516: DBMS_XMLQuery.setBindValue(ctx, 'PRODUCT_ID', product_id);
517: END IF;
518:
519: -- now get the result
520: BEGIN

Line 521: l_result := DBMS_XMLQUERY.getXML(ctx);

517: END IF;
518:
519: -- now get the result
520: BEGIN
521: l_result := DBMS_XMLQUERY.getXML(ctx);
522: LogMessage(FND_LOG.LEVEL_STATEMENT, 'after DBMS_XMLQUERY.getXML');
523: DBMS_XMLQuery.closeContext(ctx);
524: l_rows_processed := 1;
525: EXCEPTION

Line 522: LogMessage(FND_LOG.LEVEL_STATEMENT, 'after DBMS_XMLQUERY.getXML');

518:
519: -- now get the result
520: BEGIN
521: l_result := DBMS_XMLQUERY.getXML(ctx);
522: LogMessage(FND_LOG.LEVEL_STATEMENT, 'after DBMS_XMLQUERY.getXML');
523: DBMS_XMLQuery.closeContext(ctx);
524: l_rows_processed := 1;
525: EXCEPTION
526: WHEN OTHERS THEN

Line 523: DBMS_XMLQuery.closeContext(ctx);

519: -- now get the result
520: BEGIN
521: l_result := DBMS_XMLQUERY.getXML(ctx);
522: LogMessage(FND_LOG.LEVEL_STATEMENT, 'after DBMS_XMLQUERY.getXML');
523: DBMS_XMLQuery.closeContext(ctx);
524: l_rows_processed := 1;
525: EXCEPTION
526: WHEN OTHERS THEN
527: LogMessage(FND_LOG.LEVEL_STATEMENT, 'in exception');

Line 528: DBMS_XMLQuery.getExceptionContent(ctx,l_errNo,l_errMsg);

524: l_rows_processed := 1;
525: EXCEPTION
526: WHEN OTHERS THEN
527: LogMessage(FND_LOG.LEVEL_STATEMENT, 'in exception');
528: DBMS_XMLQuery.getExceptionContent(ctx,l_errNo,l_errMsg);
529: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_errNo = ' || l_errNo);
530: IF l_errNo = 1403 THEN
531: l_rows_processed := 0;
532: END IF;

Line 533: DBMS_XMLQuery.closeContext(ctx);

529: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_errNo = ' || l_errNo);
530: IF l_errNo = 1403 THEN
531: l_rows_processed := 0;
532: END IF;
533: DBMS_XMLQuery.closeContext(ctx);
534: END;
535: -- We are adding the LNSPORTFOLIO and PARAMETERS TAGs so we have
536: -- to offset the first line.
537: IF l_rows_processed <> 0 THEN

Line 609: ctx DBMS_XMLQUERY.ctxType;

605: ,LOAN_ASSIGNED_TO IN NUMBER
606: ) IS
607: l_api_name CONSTANT VARCHAR2(30) := 'PROCESS_RECON_REPORT';
608: l_api_version CONSTANT NUMBER := 1.0;
609: ctx DBMS_XMLQUERY.ctxType;
610: result CLOB;
611: qryCtx DBMS_XMLGEN.ctxHandle;
612: l_result CLOB;
613: tempResult CLOB;

Line 623: queryCtx DBMS_XMLquery.ctxType;

619: l_xml_header varchar2(3000);
620: l_xml_header_length number;
621: l_errNo NUMBER;
622: l_errMsg VARCHAR2(200);
623: queryCtx DBMS_XMLquery.ctxType;
624: l_xml_query VARCHAR2(32767);
625: TYPE ref_cur IS REF CURSOR;
626: l_xml_stmt ref_cur;
627: l_rows_processed NUMBER;

Line 959: ctx := DBMS_XMLQUERY.newContext(l_query);

955: INTO l_loan_officer
956: FROM jtf_rs_resource_extns
957: WHERE resource_id = loan_assigned_to;
958: END IF;
959: ctx := DBMS_XMLQUERY.newContext(l_query);
960: DBMS_XMLQuery.setRaiseNoRowsException(ctx,TRUE);
961: -- Bind Mandatory Variables
962: DBMS_XMLQuery.setBindValue(ctx, 'LOAN_CLASS', loan_class);
963: DBMS_XMLQuery.setBindValue(ctx, 'LOAN_TYPE_ID', loan_type_id);

Line 960: DBMS_XMLQuery.setRaiseNoRowsException(ctx,TRUE);

956: FROM jtf_rs_resource_extns
957: WHERE resource_id = loan_assigned_to;
958: END IF;
959: ctx := DBMS_XMLQUERY.newContext(l_query);
960: DBMS_XMLQuery.setRaiseNoRowsException(ctx,TRUE);
961: -- Bind Mandatory Variables
962: DBMS_XMLQuery.setBindValue(ctx, 'LOAN_CLASS', loan_class);
963: DBMS_XMLQuery.setBindValue(ctx, 'LOAN_TYPE_ID', loan_type_id);
964: DBMS_XMLQuery.setBindValue(ctx, 'CURRENCY_CODE', currency_code);

Line 962: DBMS_XMLQuery.setBindValue(ctx, 'LOAN_CLASS', loan_class);

958: END IF;
959: ctx := DBMS_XMLQUERY.newContext(l_query);
960: DBMS_XMLQuery.setRaiseNoRowsException(ctx,TRUE);
961: -- Bind Mandatory Variables
962: DBMS_XMLQuery.setBindValue(ctx, 'LOAN_CLASS', loan_class);
963: DBMS_XMLQuery.setBindValue(ctx, 'LOAN_TYPE_ID', loan_type_id);
964: DBMS_XMLQuery.setBindValue(ctx, 'CURRENCY_CODE', currency_code);
965: DBMS_XMLQuery.setBindValue(ctx, 'ORG_ID', l_org_id);
966:

Line 963: DBMS_XMLQuery.setBindValue(ctx, 'LOAN_TYPE_ID', loan_type_id);

959: ctx := DBMS_XMLQUERY.newContext(l_query);
960: DBMS_XMLQuery.setRaiseNoRowsException(ctx,TRUE);
961: -- Bind Mandatory Variables
962: DBMS_XMLQuery.setBindValue(ctx, 'LOAN_CLASS', loan_class);
963: DBMS_XMLQuery.setBindValue(ctx, 'LOAN_TYPE_ID', loan_type_id);
964: DBMS_XMLQuery.setBindValue(ctx, 'CURRENCY_CODE', currency_code);
965: DBMS_XMLQuery.setBindValue(ctx, 'ORG_ID', l_org_id);
966:
967: -- Bind Optional Variables if they are NOT NULL

Line 964: DBMS_XMLQuery.setBindValue(ctx, 'CURRENCY_CODE', currency_code);

960: DBMS_XMLQuery.setRaiseNoRowsException(ctx,TRUE);
961: -- Bind Mandatory Variables
962: DBMS_XMLQuery.setBindValue(ctx, 'LOAN_CLASS', loan_class);
963: DBMS_XMLQuery.setBindValue(ctx, 'LOAN_TYPE_ID', loan_type_id);
964: DBMS_XMLQuery.setBindValue(ctx, 'CURRENCY_CODE', currency_code);
965: DBMS_XMLQuery.setBindValue(ctx, 'ORG_ID', l_org_id);
966:
967: -- Bind Optional Variables if they are NOT NULL
968: IF borrower_id is NOT NULL

Line 965: DBMS_XMLQuery.setBindValue(ctx, 'ORG_ID', l_org_id);

961: -- Bind Mandatory Variables
962: DBMS_XMLQuery.setBindValue(ctx, 'LOAN_CLASS', loan_class);
963: DBMS_XMLQuery.setBindValue(ctx, 'LOAN_TYPE_ID', loan_type_id);
964: DBMS_XMLQuery.setBindValue(ctx, 'CURRENCY_CODE', currency_code);
965: DBMS_XMLQuery.setBindValue(ctx, 'ORG_ID', l_org_id);
966:
967: -- Bind Optional Variables if they are NOT NULL
968: IF borrower_id is NOT NULL
969: THEN

Line 970: DBMS_XMLQuery.setBindValue(ctx, 'BORROWER_ID', borrower_id);

966:
967: -- Bind Optional Variables if they are NOT NULL
968: IF borrower_id is NOT NULL
969: THEN
970: DBMS_XMLQuery.setBindValue(ctx, 'BORROWER_ID', borrower_id);
971: END IF;
972: IF loan_number is NOT NULL
973: THEN
974: DBMS_XMLQuery.setBindValue(ctx, 'LOAN_NUMBER', loan_number);

Line 974: DBMS_XMLQuery.setBindValue(ctx, 'LOAN_NUMBER', loan_number);

970: DBMS_XMLQuery.setBindValue(ctx, 'BORROWER_ID', borrower_id);
971: END IF;
972: IF loan_number is NOT NULL
973: THEN
974: DBMS_XMLQuery.setBindValue(ctx, 'LOAN_NUMBER', loan_number);
975: END IF;
976: IF cust_account_id is NOT NULL
977: THEN
978: DBMS_XMLQuery.setBindValue(ctx, 'CUST_ACCOUNT_ID', cust_account_id);

Line 978: DBMS_XMLQuery.setBindValue(ctx, 'CUST_ACCOUNT_ID', cust_account_id);

974: DBMS_XMLQuery.setBindValue(ctx, 'LOAN_NUMBER', loan_number);
975: END IF;
976: IF cust_account_id is NOT NULL
977: THEN
978: DBMS_XMLQuery.setBindValue(ctx, 'CUST_ACCOUNT_ID', cust_account_id);
979: END IF;
980: IF legal_entity_id is NOT NULL
981: THEN
982: DBMS_XMLQuery.setBindValue(ctx, 'LEGAL_ENTITY_ID', legal_entity_id);

Line 982: DBMS_XMLQuery.setBindValue(ctx, 'LEGAL_ENTITY_ID', legal_entity_id);

978: DBMS_XMLQuery.setBindValue(ctx, 'CUST_ACCOUNT_ID', cust_account_id);
979: END IF;
980: IF legal_entity_id is NOT NULL
981: THEN
982: DBMS_XMLQuery.setBindValue(ctx, 'LEGAL_ENTITY_ID', legal_entity_id);
983: END IF;
984: IF loan_assigned_to is NOT NULL
985: THEN
986: DBMS_XMLQuery.setBindValue(ctx, 'LOAN_ASSIGNED_TO', loan_assigned_to);

Line 986: DBMS_XMLQuery.setBindValue(ctx, 'LOAN_ASSIGNED_TO', loan_assigned_to);

982: DBMS_XMLQuery.setBindValue(ctx, 'LEGAL_ENTITY_ID', legal_entity_id);
983: END IF;
984: IF loan_assigned_to is NOT NULL
985: THEN
986: DBMS_XMLQuery.setBindValue(ctx, 'LOAN_ASSIGNED_TO', loan_assigned_to);
987: END IF;
988:
989: -- now get the result
990: BEGIN

Line 991: l_result := DBMS_XMLQUERY.getXML(ctx);

987: END IF;
988:
989: -- now get the result
990: BEGIN
991: l_result := DBMS_XMLQUERY.getXML(ctx);
992: DBMS_XMLQuery.closeContext(ctx);
993: l_rows_processed := 1;
994: EXCEPTION
995: WHEN OTHERS THEN

Line 992: DBMS_XMLQuery.closeContext(ctx);

988:
989: -- now get the result
990: BEGIN
991: l_result := DBMS_XMLQUERY.getXML(ctx);
992: DBMS_XMLQuery.closeContext(ctx);
993: l_rows_processed := 1;
994: EXCEPTION
995: WHEN OTHERS THEN
996: DBMS_XMLQuery.getExceptionContent(ctx,l_errNo,l_errMsg);

Line 996: DBMS_XMLQuery.getExceptionContent(ctx,l_errNo,l_errMsg);

992: DBMS_XMLQuery.closeContext(ctx);
993: l_rows_processed := 1;
994: EXCEPTION
995: WHEN OTHERS THEN
996: DBMS_XMLQuery.getExceptionContent(ctx,l_errNo,l_errMsg);
997: IF l_errNo = 1403 THEN
998: l_rows_processed := 0;
999: END IF;
1000: DBMS_XMLQuery.closeContext(ctx);

Line 1000: DBMS_XMLQuery.closeContext(ctx);

996: DBMS_XMLQuery.getExceptionContent(ctx,l_errNo,l_errMsg);
997: IF l_errNo = 1403 THEN
998: l_rows_processed := 0;
999: END IF;
1000: DBMS_XMLQuery.closeContext(ctx);
1001: END;
1002: -- We are adding the LNSPORTFOLIO and PARAMETERS TAGs so we have
1003: -- to offset the first line.
1004: IF l_rows_processed <> 0 THEN

Line 1059: ctx DBMS_XMLQUERY.ctxType;

1055: ,p_based_on_terms IN VARCHAR2)
1056: IS
1057: l_api_name CONSTANT VARCHAR2(30) := 'GEN_AGREEMENT_XML';
1058: l_api_version CONSTANT NUMBER := 1.0;
1059: ctx DBMS_XMLQUERY.ctxType;
1060: result CLOB;
1061: qryCtx DBMS_XMLGEN.ctxHandle;
1062: l_result CLOB;
1063: tempResult CLOB;

Line 1074: queryCtx DBMS_XMLquery.ctxType;

1070: l_xml_header_length number;
1071: l_close_tag VARCHAR2(100);
1072: l_errNo NUMBER;
1073: l_errMsg VARCHAR2(200);
1074: queryCtx DBMS_XMLquery.ctxType;
1075: l_xml_query VARCHAR2(32767);
1076: TYPE ref_cur IS REF CURSOR;
1077: l_xml_stmt ref_cur;
1078: l_rows_processed NUMBER;