[Home] [Help]
31: /*
32: -- ***** Post Confirmation row for COUNTERPARTY confirmation *****
33: if p_cparty is NOT NULL then
34: l_party := p_cparty;
35: update XTR_CONFIRMATION_DETAILS
36: set DEAL_SUBTYPE = p_deal_subtype,
37: CURRENCY = p_currency,
38: AMOUNT = p_amount,
39: CONFO_PARTY_CODE = l_party
45: open GET_CONFO_ACTIONS;
46: fetch GET_CONFO_ACTIONS into l_action;
47: if GET_CONFO_ACTIONS%FOUND then
48: -- Insert row into Confirmation_details so confo can be generated
49: insert into XTR_CONFIRMATION_DETAILS
50: (deal_no,transaction_no,action_type,client_or_cparty,date_created,
51: company_code,confo_party_code,file_name,deal_type,
52: deal_subtype,currency,amount,confirmation_validated_by,
53: confirmation_validated_on,status_code)
62: --
63: -- ***** Post Confirmation row for CLIENT confirmation *****
64: if p_client is NOT NULL then
65: l_party := p_client;
66: update XTR_CONFIRMATION_DETAILS
67: set DEAL_SUBTYPE = p_deal_subtype,
68: STATUS_CODE = p_deal_status,
69: CURRENCY = p_currency,
70: AMOUNT = p_amount,
76: open GET_CONFO_ACTIONS;
77: fetch GET_CONFO_ACTIONS into l_action;
78: if GET_CONFO_ACTIONS%FOUND then
79: -- Insert row into Confirmation_details so confo can be generated
80: insert into XTR_CONFIRMATION_DETAILS
81: (deal_no,transaction_no,action_type,client_or_cparty,date_created,
82: company_code,confo_party_code,file_name,deal_type,
83: deal_subtype,currency,amount,confirmation_validated_by,
84: confirmation_validated_on,status_code)
96: PROCEDURE CANCEL_CONFO(p_deal_no IN NUMBER,
97: p_trans_no IN NUMBER) is
98: --
99: begin
100: delete from XTR_CONFIRMATION_DETAILS
101: where DEAL_NO = p_deal_no
102: and TRANSACTION_NO = nvl(p_trans_no,p_deal_no)
103: and FILE_NAME is NULL;
104: --
101: where DEAL_NO = p_deal_no
102: and TRANSACTION_NO = nvl(p_trans_no,p_deal_no)
103: and FILE_NAME is NULL;
104: --
105: update XTR_CONFIRMATION_DETAILS
106: set STATUS_CODE = 'CANCELLED'
107: where DEAL_NO = p_deal_no
108: and TRANSACTION_NO = p_trans_no
109: and FILE_NAME is NOT NULL;