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.OZF_CLAIM_PVT dependencies on DBMS_XMLGEN

Line 4933: --//The DBMS_XMLGEN package converts the results of a SQL query to a canonical XML format. The package takes an arbitrary SQL query as input, converts it to XML format, and returns the result as a CLOB

4929:
4930: l_item_key := l_claim_id || TO_CHAR(SYSDATE,'DDMMRRRRHH24MISS');
4931: l_parameter_list := WF_PARAMETER_LIST_T();
4932:
4933: --//The DBMS_XMLGEN package converts the results of a SQL query to a canonical XML format. The package takes an arbitrary SQL query as input, converts it to XML format, and returns the result as a CLOB
4934: l_claim_data := DBMS_XMLGEN.getXml('select claim.claim_id ClaimID,
4935: claim.claim_number ClaimNumber,
4936: claim.owner_id ClaimOwner,
4937: TO_CHAR(claim.claim_date, ''YYYY-MM-DD"T"HH24:MI:SS'')ClaimDate,

Line 4934: l_claim_data := DBMS_XMLGEN.getXml('select claim.claim_id ClaimID,

4930: l_item_key := l_claim_id || TO_CHAR(SYSDATE,'DDMMRRRRHH24MISS');
4931: l_parameter_list := WF_PARAMETER_LIST_T();
4932:
4933: --//The DBMS_XMLGEN package converts the results of a SQL query to a canonical XML format. The package takes an arbitrary SQL query as input, converts it to XML format, and returns the result as a CLOB
4934: l_claim_data := DBMS_XMLGEN.getXml('select claim.claim_id ClaimID,
4935: claim.claim_number ClaimNumber,
4936: claim.owner_id ClaimOwner,
4937: TO_CHAR(claim.claim_date, ''YYYY-MM-DD"T"HH24:MI:SS'')ClaimDate,
4938: claim.claim_type_id ClaimTypeID,

Line 8115: l_claim_update_data := dbms_xmlgen.getXml('select claim.claim_id ClaimID,

8111:
8112: l_item_key_update := l_claim.claim_id || TO_CHAR(SYSDATE,'DDMMRRRRHH24MISS');
8113: l_parameter_list_update := WF_PARAMETER_LIST_T();
8114:
8115: l_claim_update_data := dbms_xmlgen.getXml('select claim.claim_id ClaimID,
8116: claim.amount ClaimAmount,
8117: claim.status_code ClaimStatus,
8118: (claim.cust_account_id || '':'' || cust.party_id)
8119: ClaimCustAcctID,

Line 8161: l_claim_update_data := dbms_xmlgen.getXml('select claim.claim_id ClaimID,

8157: claim.cust_account_id = cust.cust_account_id AND
8158: claim.claim_id = ' || l_claim.claim_id);
8159:
8160: IF(l_claim_rec2.status_code = 'CANCELLED')THEN
8161: l_claim_update_data := dbms_xmlgen.getXml('select claim.claim_id ClaimID,
8162: ''0'' ClaimAmount,
8163: claim.status_code ClaimStatus,
8164: (claim.cust_account_id || '':'' || cust.party_id)
8165: ClaimCustAcctID,

Line 8225: l_claim_amount_data := dbms_xmlgen.getXml('select claim.claim_id ClaimID,

8221: l_item_key_amount := l_claim.claim_id || TO_CHAR(SYSDATE,'DDMMRRRRHH24MISS');
8222: l_parameter_list_amount := WF_PARAMETER_LIST_T();
8223:
8224: -- Changed the Cust Account ID as per the standard
8225: l_claim_amount_data := dbms_xmlgen.getXml('select claim.claim_id ClaimID,
8226: claim.amount ClaimAmount,
8227: claim.status_code ClaimStatus,
8228: (claim.cust_account_id || '':'' || cust.party_id)
8229: ClaimCustAcctID,