APPS.DPP_CLAIMS_PVT dependencies on DBMS_XMLQUERY

Line 106: l_queryCtx dbms_xmlquery.ctxType;

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

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

1155: END IF;
1156: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1157: l_status := 'SUCCESS';
1158: --Output XML Generation Code.
1159: l_queryCtx := dbms_xmlquery.newContext('SELECT '||l_transaction_number||'Txnnumber,
1160: CURSOR (SELECT DISTINCT claim_number claimnumber
1161: FROM DPP_CUSTOMER_CLAIMS_GT) TRANSACTION
1162: FROM dual');
1163: ELSE

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

1162: FROM dual');
1163: ELSE
1164: l_status := 'WARNING';
1165: --Output XML Generation Code.
1166: l_queryCtx := dbms_xmlquery.newContext('SELECT '||l_transaction_number||'Txnnumber,
1167: CURSOR(SELECT claim_number claimnumber,
1168: customer_name customername,
1169: currency,
1170: item_number itemnumber ,

Line 1174: dbms_xmlquery.setRowTag(l_queryCtx

1170: item_number itemnumber ,
1171: reason_for_failure reason
1172: FROM DPP_CUSTOMER_CLAIMS_GT) transaction FROM dual');
1173: END IF;
1174: dbms_xmlquery.setRowTag(l_queryCtx
1175: ,'ROOT'
1176: );
1177: l_output_xml := dbms_xmlquery.getXml(l_queryCtx);
1178: dbms_xmlquery.closeContext(l_queryCtx);

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

1173: END IF;
1174: dbms_xmlquery.setRowTag(l_queryCtx
1175: ,'ROOT'
1176: );
1177: l_output_xml := dbms_xmlquery.getXml(l_queryCtx);
1178: dbms_xmlquery.closeContext(l_queryCtx);
1179: --Call the Update_Executiondetails Procedure to update the execution details table and commit the transaction
1180: Update_Executiondetails(l_status,
1181: l_txn_hdr_rec,

Line 1178: dbms_xmlquery.closeContext(l_queryCtx);

1174: dbms_xmlquery.setRowTag(l_queryCtx
1175: ,'ROOT'
1176: );
1177: l_output_xml := dbms_xmlquery.getXml(l_queryCtx);
1178: dbms_xmlquery.closeContext(l_queryCtx);
1179: --Call the Update_Executiondetails Procedure to update the execution details table and commit the transaction
1180: Update_Executiondetails(l_status,
1181: l_txn_hdr_rec,
1182: l_output_xml,

Line 1333: l_queryCtx dbms_xmlquery.ctxType;

1329: l_claim_pub_rec OZF_Claim_PUB.claim_rec_type;
1330: l_claim_line_pub_tbl OZF_Claim_PUB.claim_line_tbl_type;
1331:
1332: l_output_xml CLOB;
1333: l_queryCtx dbms_xmlquery.ctxType;
1334:
1335: l_object_version_number NUMBER := 1.0;
1336: l_claim_line_id NUMBER;
1337: l_claim_line_number NUMBER;

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

1599: ELSE
1600: l_status := 'WARNING';
1601: END IF;
1602: --Output XML Generation Code
1603: l_queryCtx := dbms_xmlquery.newContext('SELECT '||l_transaction_number||'txnnumber,
1604: claim_number claimnumber,'
1605: ||l_reason||'reason
1606: FROM ozf_claims_all
1607: WHERE claim_id = '||l_txn_hdr_rec.claim_id);

Line 1608: dbms_xmlquery.setRowTag(l_queryCtx

1604: claim_number claimnumber,'
1605: ||l_reason||'reason
1606: FROM ozf_claims_all
1607: WHERE claim_id = '||l_txn_hdr_rec.claim_id);
1608: dbms_xmlquery.setRowTag(l_queryCtx
1609: ,'ROOT'
1610: );
1611: l_output_xml := dbms_xmlquery.getXml(l_queryCtx);
1612: dbms_xmlquery.closeContext(l_queryCtx);

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

1607: WHERE claim_id = '||l_txn_hdr_rec.claim_id);
1608: dbms_xmlquery.setRowTag(l_queryCtx
1609: ,'ROOT'
1610: );
1611: l_output_xml := dbms_xmlquery.getXml(l_queryCtx);
1612: dbms_xmlquery.closeContext(l_queryCtx);
1613: --Call the Update_Executiondetails Procedure to update the execution details table and commit the transaction
1614: Update_Executiondetails(l_status,
1615: l_txn_hdr_rec,

Line 1612: dbms_xmlquery.closeContext(l_queryCtx);

1608: dbms_xmlquery.setRowTag(l_queryCtx
1609: ,'ROOT'
1610: );
1611: l_output_xml := dbms_xmlquery.getXml(l_queryCtx);
1612: dbms_xmlquery.closeContext(l_queryCtx);
1613: --Call the Update_Executiondetails Procedure to update the execution details table and commit the transaction
1614: Update_Executiondetails(l_status,
1615: l_txn_hdr_rec,
1616: l_output_xml,