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.DPP_CLAIMS_PVT dependencies on DBMS_XMLQUERY

Line 105: l_queryCtx dbms_xmlquery.ctxType;

101: l_claim_line_pub_tbl OZF_Claim_PUB.claim_line_tbl_type;
102: l_claim_line_pub_tbl_updt OZF_Claim_PUB.claim_line_tbl_type;
103:
104: l_output_xml CLOB;
105: l_queryCtx dbms_xmlquery.ctxType;
106: l_status VARCHAR2(20);
107: l_transaction_number VARCHAR2(240);
108:
109: l_approval_flag VARCHAR2(1);

Line 1143: l_queryCtx := dbms_xmlquery.newContext('SELECT '||l_transaction_number||'Txnnumber,

1139: END IF;
1140: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1141: l_status := 'SUCCESS';
1142: --Output XML Generation Code.
1143: l_queryCtx := dbms_xmlquery.newContext('SELECT '||l_transaction_number||'Txnnumber,
1144: CURSOR (SELECT DISTINCT claim_number claimnumber
1145: FROM DPP_CUSTOMER_CLAIMS_GT) TRANSACTION
1146: FROM dual');
1147: ELSE

Line 1150: l_queryCtx := dbms_xmlquery.newContext('SELECT '||l_transaction_number||'Txnnumber,

1146: FROM dual');
1147: ELSE
1148: l_status := 'WARNING';
1149: --Output XML Generation Code.
1150: l_queryCtx := dbms_xmlquery.newContext('SELECT '||l_transaction_number||'Txnnumber,
1151: CURSOR(SELECT claim_number claimnumber,
1152: customer_name customername,
1153: currency,
1154: item_number itemnumber ,

Line 1158: dbms_xmlquery.setRowTag(l_queryCtx

1154: item_number itemnumber ,
1155: reason_for_failure reason
1156: FROM DPP_CUSTOMER_CLAIMS_GT) transaction FROM dual');
1157: END IF;
1158: dbms_xmlquery.setRowTag(l_queryCtx
1159: ,'ROOT'
1160: );
1161: l_output_xml := dbms_xmlquery.getXml(l_queryCtx);
1162: dbms_xmlquery.closeContext(l_queryCtx);

Line 1161: l_output_xml := dbms_xmlquery.getXml(l_queryCtx);

1157: END IF;
1158: dbms_xmlquery.setRowTag(l_queryCtx
1159: ,'ROOT'
1160: );
1161: l_output_xml := dbms_xmlquery.getXml(l_queryCtx);
1162: dbms_xmlquery.closeContext(l_queryCtx);
1163: --Call the Update_Executiondetails Procedure to update the execution details table and commit the transaction
1164: Update_Executiondetails(l_status,
1165: l_txn_hdr_rec,

Line 1162: dbms_xmlquery.closeContext(l_queryCtx);

1158: dbms_xmlquery.setRowTag(l_queryCtx
1159: ,'ROOT'
1160: );
1161: l_output_xml := dbms_xmlquery.getXml(l_queryCtx);
1162: dbms_xmlquery.closeContext(l_queryCtx);
1163: --Call the Update_Executiondetails Procedure to update the execution details table and commit the transaction
1164: Update_Executiondetails(l_status,
1165: l_txn_hdr_rec,
1166: l_output_xml,

Line 1317: l_queryCtx dbms_xmlquery.ctxType;

1313: l_claim_pub_rec OZF_Claim_PUB.claim_rec_type;
1314: l_claim_line_pub_tbl OZF_Claim_PUB.claim_line_tbl_type;
1315:
1316: l_output_xml CLOB;
1317: l_queryCtx dbms_xmlquery.ctxType;
1318:
1319: l_object_version_number NUMBER := 1.0;
1320: l_claim_line_id NUMBER;
1321: l_claim_line_number NUMBER;

Line 1590: l_queryCtx := dbms_xmlquery.newContext('SELECT '||l_transaction_number||'txnnumber,

1586: ELSE
1587: l_status := 'WARNING';
1588: END IF;
1589: --Output XML Generation Code
1590: l_queryCtx := dbms_xmlquery.newContext('SELECT '||l_transaction_number||'txnnumber,
1591: claim_number claimnumber,'
1592: ||l_reason||'reason
1593: FROM ozf_claims_all
1594: WHERE claim_id = '||l_txn_hdr_rec.claim_id);

Line 1595: dbms_xmlquery.setRowTag(l_queryCtx

1591: claim_number claimnumber,'
1592: ||l_reason||'reason
1593: FROM ozf_claims_all
1594: WHERE claim_id = '||l_txn_hdr_rec.claim_id);
1595: dbms_xmlquery.setRowTag(l_queryCtx
1596: ,'ROOT'
1597: );
1598: l_output_xml := dbms_xmlquery.getXml(l_queryCtx);
1599: dbms_xmlquery.closeContext(l_queryCtx);

Line 1598: l_output_xml := dbms_xmlquery.getXml(l_queryCtx);

1594: WHERE claim_id = '||l_txn_hdr_rec.claim_id);
1595: dbms_xmlquery.setRowTag(l_queryCtx
1596: ,'ROOT'
1597: );
1598: l_output_xml := dbms_xmlquery.getXml(l_queryCtx);
1599: dbms_xmlquery.closeContext(l_queryCtx);
1600: --Call the Update_Executiondetails Procedure to update the execution details table and commit the transaction
1601: Update_Executiondetails(l_status,
1602: l_txn_hdr_rec,

Line 1599: dbms_xmlquery.closeContext(l_queryCtx);

1595: dbms_xmlquery.setRowTag(l_queryCtx
1596: ,'ROOT'
1597: );
1598: l_output_xml := dbms_xmlquery.getXml(l_queryCtx);
1599: dbms_xmlquery.closeContext(l_queryCtx);
1600: --Call the Update_Executiondetails Procedure to update the execution details table and commit the transaction
1601: Update_Executiondetails(l_status,
1602: l_txn_hdr_rec,
1603: l_output_xml,