eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XTR_UPDATE_SETTLEMENT_ACCOUNTS dependencies on XTR_DEAL_DATE_AMOUNTS

Line 12: * This procedure updates XTR_DEAL_DATE_AMOUNTS table and sets the

8: /**
9: * PROCEDURE process_settlement_accounts
10: *
11: * DESCRIPTION
12: * This procedure updates XTR_DEAL_DATE_AMOUNTS table and sets the
13: * company account or counterparty account specified as the
14: * account_number_from to the account specified as account_number_to.
15: *
16: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED

Line 78: select max (deal_number) from XTR_DEAL_DATE_AMOUNTS;

74: select party_code
75: from xtr_parties_v where party_type = 'C';
76:
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,

Line 82: p_int_deal_no_from XTR_DEAL_DATE_AMOUNTS.DEAL_NUMBER%TYPE,

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
86: SELECT deal_date_amount_id, deal_number,

Line 83: p_int_deal_no_to XTR_DEAL_DATE_AMOUNTS.DEAL_NUMBER%TYPE,

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
86: SELECT deal_date_amount_id, deal_number,
87: amount_date, amount_type, cashflow_amount,

Line 89: FROM xtr_deal_date_amounts

85: p_default_end_date DATE) IS
86: SELECT deal_date_amount_id, deal_number,
87: amount_date, amount_type, cashflow_amount,
88: settle, batch_id, transaction_number, deal_type
89: FROM xtr_deal_date_amounts
90: WHERE account_no = p_current_bank_account
91: AND amount_date >= p_date
92: AND amount_date <= p_default_end_date
93: AND deal_type = p_deal_type

Line 99: p_int_deal_no_from XTR_DEAL_DATE_AMOUNTS.DEAL_NUMBER%TYPE,

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
103: SELECT deal_date_amount_id, deal_number,

Line 100: p_int_deal_no_to XTR_DEAL_DATE_AMOUNTS.DEAL_NUMBER%TYPE,

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
103: SELECT deal_date_amount_id, deal_number,
104: amount_date, amount_type, cashflow_amount,

Line 106: FROM xtr_deal_date_amounts

102: p_default_end_date DATE) IS
103: SELECT deal_date_amount_id, deal_number,
104: amount_date, amount_type, cashflow_amount,
105: settle, batch_id, transaction_number, deal_type
106: FROM xtr_deal_date_amounts
107: WHERE account_no = p_current_bank_account
108: AND amount_date >= p_date
109: AND amount_date <= p_default_end_date
110: AND company_code = p_company_code

Line 116: p_int_deal_no_from XTR_DEAL_DATE_AMOUNTS.DEAL_NUMBER%TYPE,

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
120: SELECT deal_date_amount_id, deal_number,

Line 117: p_int_deal_no_to XTR_DEAL_DATE_AMOUNTS.DEAL_NUMBER%TYPE,

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
120: SELECT deal_date_amount_id, deal_number,
121: amount_date, amount_type, cashflow_amount,

Line 123: FROM xtr_deal_date_amounts

119: p_default_end_date DATE) IS
120: SELECT deal_date_amount_id, deal_number,
121: amount_date, amount_type, cashflow_amount,
122: settle, batch_id, transaction_number, deal_type
123: FROM xtr_deal_date_amounts
124: WHERE cparty_account_no = p_current_bank_account
125: AND amount_date >= p_date
126: AND amount_date <= p_default_end_date
127: AND company_code = p_company_code

Line 133: p_int_deal_no_from XTR_DEAL_DATE_AMOUNTS.DEAL_NUMBER%TYPE,

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
137: SELECT deal_date_amount_id, deal_number,

Line 134: p_int_deal_no_to XTR_DEAL_DATE_AMOUNTS.DEAL_NUMBER%TYPE,

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
137: SELECT deal_date_amount_id, deal_number,
138: amount_date, amount_type, cashflow_amount,

Line 140: FROM xtr_deal_date_amounts

136: p_default_end_date DATE) IS
137: SELECT deal_date_amount_id, deal_number,
138: amount_date, amount_type, cashflow_amount,
139: settle, batch_id, transaction_number, deal_type
140: FROM xtr_deal_date_amounts
141: WHERE cparty_account_no = p_current_bank_account
142: AND amount_date >= p_date
143: AND amount_date <= p_default_end_date
144: AND deal_type = p_deal_type

Line 148: CURSOR check_journal( p_batch_id XTR_DEAL_DATE_AMOUNTS.BATCH_ID%TYPE) IS

144: AND deal_type = p_deal_type
145: AND company_code = p_company_code
146: AND deal_number BETWEEN p_int_deal_no_from AND p_int_deal_no_to;
147:
148: CURSOR check_journal( p_batch_id XTR_DEAL_DATE_AMOUNTS.BATCH_ID%TYPE) IS
149: SELECT 'Y'
150: FROM xtr_batches b, xtr_batch_events e
151: WHERE b.batch_id = e.batch_id
152: AND e.event_code = 'JRNLGN'

Line 163: l_amount_type XTR_DEAL_DATE_AMOUNTS.AMOUNT_TYPE%TYPE;

159: l_new_currency XTR_BANK_ACCOUNTS.currency%TYPE;
160: l_new_authorized XTR_BANK_ACCOUNTS.AUTHORISED%TYPE;
161: l_reqid VARCHAR2(30);
162: l_request_id NUMBER;
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;

Line 164: l_amount_date XTR_DEAL_DATE_AMOUNTS.AMOUNT_DATE%TYPE;

160: l_new_authorized XTR_BANK_ACCOUNTS.AUTHORISED%TYPE;
161: l_reqid VARCHAR2(30);
162: l_request_id NUMBER;
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;

Line 165: l_settle XTR_DEAL_DATE_AMOUNTS.SETTLE%TYPE;

161: l_reqid VARCHAR2(30);
162: l_request_id NUMBER;
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;

Line 166: l_batch_id XTR_DEAL_DATE_AMOUNTS.BATCH_ID%TYPE;

162: l_request_id NUMBER;
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;

Line 169: l_deal_date_amount_id XTR_DEAL_DATE_AMOUNTS.DEAL_DATE_AMOUNT_ID%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;
172: l_transaction_number XTR_DEAL_DATE_AMOUNTS.TRANSACTION_NUMBER%TYPE;
173: l_deal_type XTR_DEAL_DATE_AMOUNTS.DEAL_TYPE%TYPE;

Line 171: l_cashflow_amount XTR_DEAL_DATE_AMOUNTS.CASHFLOW_AMOUNT%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);
175: l_journalized VARCHAR2(1);

Line 172: l_transaction_number XTR_DEAL_DATE_AMOUNTS.TRANSACTION_NUMBER%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);
175: l_journalized VARCHAR2(1);
176: l_message_name VARCHAR2(30);

Line 173: l_deal_type XTR_DEAL_DATE_AMOUNTS.DEAL_TYPE%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);
175: l_journalized VARCHAR2(1);
176: l_message_name VARCHAR2(30);
177:

Line 325: UPDATE xtr_deal_date_amounts

321: END IF;
322: END IF;
323: END IF;
324: IF l_updated_flag = 'Y' THEN
325: UPDATE xtr_deal_date_amounts
326: set account_no = p_new_bank_account
327: where deal_date_amount_id =
328: l_deal_date_amount_id;
329: END IF;

Line 395: UPDATE xtr_deal_date_amounts

391: END IF;
392: END IF;
393: END IF;
394: IF l_updated_flag = 'Y' THEN
395: UPDATE xtr_deal_date_amounts
396: set account_no = p_new_bank_account
397: where deal_date_amount_id =
398: l_deal_date_amount_id;
399: END IF;

Line 478: Update XTR_DEAL_DATE_AMOUNTS

474: END IF;
475: END IF;
476: END IF;
477: IF l_updated_flag = 'Y' THEN
478: Update XTR_DEAL_DATE_AMOUNTS
479: Set cparty_account_no =
480: p_new_bank_account
481: Where deal_date_amount_id =
482: l_deal_date_amount_id;

Line 565: Update XTR_DEAL_DATE_AMOUNTS

561: END IF;
562: END IF;
563: END IF;
564: IF l_updated_flag = 'Y' THEN
565: Update XTR_DEAL_DATE_AMOUNTS
566: Set cparty_account_no =
567: p_new_bank_account
568: Where deal_date_amount_id =
569: l_deal_date_amount_id;

Line 718: p_amount_type IN XTR_DEAL_DATE_AMOUNTS.AMOUNT_TYPE%TYPE,

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,
721: p_deal_type IN XTR_DEAL_DATE_AMOUNTS.DEAL_TYPE%TYPE,
722: p_deal_number IN XTR_DEALS.DEAL_NO%TYPE,

Line 720: XTR_DEAL_DATE_AMOUNTS.CASHFLOW_AMOUNT%TYPE,

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,
721: p_deal_type IN XTR_DEAL_DATE_AMOUNTS.DEAL_TYPE%TYPE,
722: p_deal_number IN XTR_DEALS.DEAL_NO%TYPE,
723: p_transaction_number IN
724: XTR_DEAL_DATE_AMOUNTS.TRANSACTION_NUMBER%TYPE,

Line 721: p_deal_type IN XTR_DEAL_DATE_AMOUNTS.DEAL_TYPE%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,
721: p_deal_type IN XTR_DEAL_DATE_AMOUNTS.DEAL_TYPE%TYPE,
722: p_deal_number IN XTR_DEALS.DEAL_NO%TYPE,
723: p_transaction_number IN
724: XTR_DEAL_DATE_AMOUNTS.TRANSACTION_NUMBER%TYPE,
725: p_updated_flag IN VARCHAR2,

Line 724: XTR_DEAL_DATE_AMOUNTS.TRANSACTION_NUMBER%TYPE,

720: XTR_DEAL_DATE_AMOUNTS.CASHFLOW_AMOUNT%TYPE,
721: p_deal_type IN XTR_DEAL_DATE_AMOUNTS.DEAL_TYPE%TYPE,
722: p_deal_number IN XTR_DEALS.DEAL_NO%TYPE,
723: p_transaction_number IN
724: XTR_DEAL_DATE_AMOUNTS.TRANSACTION_NUMBER%TYPE,
725: p_updated_flag IN VARCHAR2,
726: p_message_name IN VARCHAR2)
727: IS
728: BEGIN