[Home] [Help]
74: p_deal_type IN XTR_DEALS.DEAL_TYPE%TYPE,
75: p_deal_number_from IN XTR_DEALS.DEAL_NO%TYPE,
76: p_deal_number_to IN XTR_DEALS.DEAL_NO%TYPE,
77: p_include_journalized IN
78: XTR_CFLOW_REQUEST_DETAILS.INCLUDE_JOURNALIZED_FLAG%TYPE);
79:
80:
81: /**
82: * PROCEDURE insert_request_details
81: /**
82: * PROCEDURE insert_request_details
83: *
84: * DESCRIPTION
85: * Inserts request details into XTR_CFLOW_REQUEST_DETAILS table so that
86: * the execution report can be run at any time.
87: *
88: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
89: *
117: * 06-Jun-2005 Rajesh Jose o Created.
118: */
119: PROCEDURE Insert_Request_Details(
120: p_cashflow_request_details_id IN
121: XTR_CFLOW_REQUEST_DETAILS.CASHFLOW_REQUEST_DETAILS_ID%TYPE,
122: p_request_id IN NUMBER,
123: p_party_code IN XTR_PARTY_INFO.PARTY_CODE%TYPE,
124: p_current_bank_account IN XTR_BANK_ACCOUNTS.ACCOUNT_NUMBER%TYPE,
125: p_new_bank_account IN XTR_BANK_ACCOUNTS.ACCOUNT_NUMBER%TYPE,
128: p_deal_number_to IN XTR_DEALS.DEAL_NO%TYPE,
129: p_start_date IN DATE,
130: p_end_date IN DATE,
131: p_inc_journalized IN
132: XTR_CFLOW_REQUEST_DETAILS.INCLUDE_JOURNALIZED_FLAG%TYPE);
133:
134:
135: /**
136: * PROCEDURE insert_transaction_details
143: *
144: * ARGUMENTS
145: * IN:
146: * p_cashflow_request_details_id Foreign key reference from
147: * XTR_CFLOW_REQUEST_DETAILS.
148: * p_amount_date The amount date of the cashflow.
149: * p_amount_type The type of cashflow.
150: * p_cashflow_amount The amount of cash flow.
151: * p_deal_type The Deal Type for the record.
167: */
168:
169: PROCEDURE Insert_Transaction_Details(
170: p_cashflow_request_details_id IN
171: XTR_CFLOW_REQUEST_DETAILS.CASHFLOW_REQUEST_DETAILS_ID%TYPE,
172: p_amount_date IN DATE,
173: p_amount_type IN XTR_DEAL_DATE_AMOUNTS.AMOUNT_TYPE%TYPE,
174: p_cashflow_amount IN
175: XTR_DEAL_DATE_AMOUNTS.CASHFLOW_AMOUNT%TYPE,