[Home] [Help]
66: p_deal_type IN XTR_DEALS.DEAL_TYPE%TYPE,
67: p_deal_number_from IN XTR_DEALS.DEAL_NO%TYPE,
68: p_deal_number_to IN XTR_DEALS.DEAL_NO%TYPE,
69: p_include_journalized IN
70: XTR_CFLOW_REQUEST_DETAILS.INCLUDE_JOURNALIZED_FLAG%TYPE)
71: IS
72:
73: CURSOR company_list IS
74: select party_code
166: l_batch_id XTR_DEAL_DATE_AMOUNTS.BATCH_ID%TYPE;
167: l_party_type XTR_PARTY_INFO.PARTY_TYPE%TYPE;
168: l_deal_number XTR_DEALS.DEAL_NO%TYPE;
169: l_deal_date_amount_id XTR_DEAL_DATE_AMOUNTS.DEAL_DATE_AMOUNT_ID%TYPE;
170: l_cf_req_details_id XTR_CFLOW_REQUEST_DETAILS.CASHFLOW_REQUEST_DETAILS_ID%TYPE;
171: l_cashflow_amount XTR_DEAL_DATE_AMOUNTS.CASHFLOW_AMOUNT%TYPE;
172: l_transaction_number XTR_DEAL_DATE_AMOUNTS.TRANSACTION_NUMBER%TYPE;
173: l_deal_type XTR_DEAL_DATE_AMOUNTS.DEAL_TYPE%TYPE;
174: l_updated_flag VARCHAR2(1);
210: WHERE account_number = p_new_bank_account
211: AND party_code = p_party_code;
212:
213: IF l_new_authorized <> 'Y' THEN
214: SELECT XTR_CFLOW_REQUEST_DETAILS_S.NEXTVAL
215: INTO l_cf_req_details_id
216: FROM DUAL;
217: insert_request_details( l_cf_req_details_id,
218: l_request_id, p_party_code,
232: END IF;
233:
234: IF (l_message_name IS NULL) THEN
235: IF l_current_currency <> l_new_currency THEN
236: SELECT XTR_CFLOW_REQUEST_DETAILS_S.NEXTVAL
237: INTO l_cf_req_details_id
238: FROM DUAL;
239: insert_request_details( l_cf_req_details_id,
240: l_request_id, p_party_code,
254: END IF;
255: END IF;
256:
257: IF l_message_name IS NULL THEN
258: SELECT XTR_CFLOW_REQUEST_DETAILS_S.NEXTVAL
259: INTO l_cf_req_details_id
260: FROM DUAL;
261: insert_request_details(l_cf_req_details_id, l_request_id,
262: p_party_code, p_current_bank_account,
609: /**
610: * PROCEDURE insert_request_details
611: *
612: * DESCRIPTION
613: * Inserts request details into XTR_CFLOW_REQUEST_DETAILS table so that
614: * the execution report can be run at any time.
615: *
616: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
617: *
645: * 06-Jun-2005 Rajesh Jose o Created.
646: */
647: PROCEDURE Insert_Request_Details(
648: p_cashflow_request_details_id IN
649: XTR_CFLOW_REQUEST_DETAILS.CASHFLOW_REQUEST_DETAILS_ID%TYPE,
650: p_request_id IN NUMBER,
651: p_party_code IN XTR_PARTY_INFO.PARTY_CODE%TYPE,
652: p_current_bank_account IN XTR_BANK_ACCOUNTS.ACCOUNT_NUMBER%TYPE,
653: p_new_bank_account IN XTR_BANK_ACCOUNTS.ACCOUNT_NUMBER%TYPE,
656: p_deal_number_to IN XTR_DEALS.DEAL_NO%TYPE,
657: p_start_date IN DATE,
658: p_end_date IN DATE,
659: p_inc_journalized IN
660: XTR_CFLOW_REQUEST_DETAILS.INCLUDE_JOURNALIZED_FLAG%TYPE)
661: IS
662: BEGIN
663: INSERT INTO XTR_CFLOW_REQUEST_DETAILS
664: (cashflow_request_details_id, request_id, party_code,
659: p_inc_journalized IN
660: XTR_CFLOW_REQUEST_DETAILS.INCLUDE_JOURNALIZED_FLAG%TYPE)
661: IS
662: BEGIN
663: INSERT INTO XTR_CFLOW_REQUEST_DETAILS
664: (cashflow_request_details_id, request_id, party_code,
665: account_no_from, account_no_to, deal_type,
666: deal_number_from, deal_number_to, starting_cflow_date,
667: ending_cflow_date, include_journalized_flag,
688: *
689: * ARGUMENTS
690: * IN:
691: * p_cashflow_request_details_id Foreign key reference from
692: * XTR_CFLOW_REQUEST_DETAILS.
693: * p_amount_date The amount date of the cashflow.
694: * p_amount_type The type of cashflow.
695: * p_cashflow_amount The amount of cash flow.
696: * p_deal_type The Deal Type for the record.
712: */
713:
714: PROCEDURE Insert_Transaction_Details(
715: p_cashflow_request_details_id IN
716: XTR_CFLOW_REQUEST_DETAILS.CASHFLOW_REQUEST_DETAILS_ID%TYPE,
717: p_amount_date IN DATE,
718: p_amount_type IN XTR_DEAL_DATE_AMOUNTS.AMOUNT_TYPE%TYPE,
719: p_cashflow_amount IN
720: XTR_DEAL_DATE_AMOUNTS.CASHFLOW_AMOUNT%TYPE,