[Home] [Help]
57: */
58: PROCEDURE Process_Settlement_Accounts(
59: p_error_buf OUT NOCOPY VARCHAR2,
60: p_retcode OUT NOCOPY NUMBER,
61: p_party_code IN XTR_PARTY_INFO.PARTY_CODE%TYPE,
62: p_current_bank_account IN XTR_BANK_ACCOUNTS.ACCOUNT_NUMBER%TYPE,
63: p_new_bank_account IN XTR_BANK_ACCOUNTS.ACCOUNT_NUMBER%TYPE,
64: p_start_date IN VARCHAR2,
65: p_end_date IN VARCHAR2,
77: CURSOR max_deal_no IS
78: select max (deal_number) from XTR_DEAL_DATE_AMOUNTS;
79:
80: CURSOR comp_accts_with_deal_type (
81: p_company_code XTR_PARTY_INFO.PARTY_CODE%TYPE,
82: p_int_deal_no_from XTR_DEAL_DATE_AMOUNTS.DEAL_NUMBER%TYPE,
83: p_int_deal_no_to XTR_DEAL_DATE_AMOUNTS.DEAL_NUMBER%TYPE,
84: p_date DATE,
85: p_default_end_date DATE) IS
94: AND company_code = p_company_code
95: AND deal_number BETWEEN p_int_deal_no_from AND p_int_deal_no_to;
96:
97: CURSOR comp_accts_with_deal_no (
98: p_company_code XTR_PARTY_INFO.PARTY_CODE%TYPE,
99: p_int_deal_no_from XTR_DEAL_DATE_AMOUNTS.DEAL_NUMBER%TYPE,
100: p_int_deal_no_to XTR_DEAL_DATE_AMOUNTS.DEAL_NUMBER%TYPE,
101: p_date DATE,
102: p_default_end_date DATE) IS
111: AND deal_type NOT IN ('CA', 'IAC')
112: AND deal_number BETWEEN p_int_deal_no_from AND p_int_deal_no_to;
113:
114: Cursor cparty_accts_with_deal_no(
115: p_company_code XTR_PARTY_INFO.PARTY_CODE%TYPE,
116: p_int_deal_no_from XTR_DEAL_DATE_AMOUNTS.DEAL_NUMBER%TYPE,
117: p_int_deal_no_to XTR_DEAL_DATE_AMOUNTS.DEAL_NUMBER%TYPE,
118: p_date DATE,
119: p_default_end_date DATE) IS
128: AND deal_type NOT IN ('CA', 'IAC')
129: AND deal_number BETWEEN p_int_deal_no_from AND p_int_deal_no_to;
130:
131: CURSOR cparty_accts_with_deal_type (
132: p_company_code XTR_PARTY_INFO.PARTY_CODE%TYPE,
133: p_int_deal_no_from XTR_DEAL_DATE_AMOUNTS.DEAL_NUMBER%TYPE,
134: p_int_deal_no_to XTR_DEAL_DATE_AMOUNTS.DEAL_NUMBER%TYPE,
135: p_date DATE,
136: p_default_end_date DATE) IS
152: AND e.event_code = 'JRNLGN'
153: AND b.batch_id = p_batch_id;
154:
155: l_commit_counter NUMBER;
156: l_company_code XTR_PARTY_INFO.PARTY_CODE%TYPE;
157: l_current_currency XTR_BANK_ACCOUNTS.currency%TYPE;
158: l_current_party_code XTR_BANK_ACCOUNTS.PARTY_CODE%TYPE;
159: l_new_currency XTR_BANK_ACCOUNTS.currency%TYPE;
160: l_new_authorized XTR_BANK_ACCOUNTS.AUTHORISED%TYPE;
163: l_amount_type XTR_DEAL_DATE_AMOUNTS.AMOUNT_TYPE%TYPE;
164: l_amount_date XTR_DEAL_DATE_AMOUNTS.AMOUNT_DATE%TYPE;
165: l_settle XTR_DEAL_DATE_AMOUNTS.SETTLE%TYPE;
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;
178: p_int_start_date DATE;
179: p_int_end_date DATE;
180: p_int_deal_number_from NUMBER;
181: p_int_deal_number_to NUMBER;
182: p_company_code XTR_PARTY_INFO.PARTY_CODE%TYPE;
183:
184: BEGIN
185:
186: G_user_id := FND_GLOBAL.USER_ID;
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,
654: p_deal_type IN XTR_DEALS.DEAL_TYPE%TYPE,
655: p_deal_number_from IN XTR_DEALS.DEAL_NO%TYPE,