APPS.OZF_CLAIM_PVT dependencies on WF_PARAMETER_LIST_T

Line 3694: l_parameter_list wf_parameter_list_t;

3690: --// 12970850 TPM Integration ER
3691: l_claim_data CLOB;
3692: l_item_key VARCHAR2(50);
3693: l_event_name VARCHAR2(80);
3694: l_parameter_list wf_parameter_list_t;
3695:
3696: CURSOR custom_setup_id_csr(p_claim_class in varchar2) IS
3697: SELECT custom_setup_id
3698: FROM ams_custom_setups_vl

Line 4931: l_parameter_list := WF_PARAMETER_LIST_T();

4927: IF G_TPM_PROCESS_ENABLED = 'Y' THEN
4928: IF(l_claim.claim_class = 'DEDUCTION' and l_claim.split_from_claim_id IS NULL) THEN
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,

Line 6375: l_parameter_list_update wf_parameter_list_t;

6371: --//For Upadte Status Business Event
6372: l_claim_update_data CLOB;
6373: l_item_key_update VARCHAR2(50);
6374: l_event_name_update VARCHAR2(80);
6375: l_parameter_list_update wf_parameter_list_t;
6376:
6377: --//For Upadte Amount Business Event
6378: l_claim_amount_data CLOB;
6379: l_item_key_amount VARCHAR2(50);

Line 6381: l_parameter_list_amount wf_parameter_list_t;

6377: --//For Upadte Amount Business Event
6378: l_claim_amount_data CLOB;
6379: l_item_key_amount VARCHAR2(50);
6380: l_event_name_amount VARCHAR2(80);
6381: l_parameter_list_amount wf_parameter_list_t;
6382:
6383: l_old_amount NUMBER;
6384:
6385: l_claim_rec1 claim_rec_type;

Line 8113: l_parameter_list_update := WF_PARAMETER_LIST_T();

8109: OR (l_claim_rec2.claim_class = 'DEDUCTION' AND l_claim_rec2.split_from_claim_id is not null AND l_claim_rec2.status_code = 'CLOSED')
8110: OR (l_claim_rec2.claim_class ='CLAIM' AND l_claim_rec2.status_code = 'CLOSED' AND l_claim_rec2.payment_method = 'CHECK')) THEN
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,

Line 8222: l_parameter_list_amount := WF_PARAMETER_LIST_T();

8218: IF((l_claim_rec2.claim_class = 'DEDUCTION' AND l_claim_rec2.status_code ='OPEN')
8219: OR (l_claim_rec2.claim_class = 'DEDUCTION' AND l_claim_rec2.amount <> 0 AND l_claim_rec2.status_code ='CANCELLED'))
8220: THEN
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,