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_CASHPOOL_UTLS dependencies on XTR_CASHPOOL_ATTRIBUTES

Line 5: /* Insert record into XTR_CASHPOOL_ATTRIBUTES table for IAC */

1: PACKAGE BODY XTR_CASHPOOL_UTLS as
2: /* $Header: xtrpoolb.pls 120.0.12010000.2 2008/08/06 10:43:50 srsampat ship $ */
3:
4: /****************************************************************/
5: /* Insert record into XTR_CASHPOOL_ATTRIBUTES table for IAC */
6: /* deal attributes */
7: /****************************************************************/
8: PROCEDURE INSERT_IAC_CASHPOOL (p_cashpool_id NUMBER,
9: p_party_code VARCHAR2,

Line 14: INSERT INTO XTR_CASHPOOL_ATTRIBUTES

10: p_iac_portfolio VARCHAR2,
11: p_iac_product_type VARCHAR2)IS
12: BEGIN
13: If p_cashpool_id is NOT NULL then
14: INSERT INTO XTR_CASHPOOL_ATTRIBUTES
15: (CASHPOOL_ATTRIBUTE_ID,
16: CASHPOOL_ID,
17: IAC_PORTFOLIO,
18: IAC_PRODUCT_TYPE,

Line 38: (xtr_cashpool_attributes_s.nextval,

34: LAST_UPDATED_BY,
35: LAST_UPDATE_DATE,
36: LAST_UPDATE_LOGIN)
37: VALUES
38: (xtr_cashpool_attributes_s.nextval,
39: p_cashpool_id,
40: p_iac_portfolio,
41: p_iac_product_type,
42: null,

Line 64: /* Insert record into XTR_CASHPOOL_ATTRIBUTES table for IG */

60: End if;
61: END;
62:
63: /****************************************************************/
64: /* Insert record into XTR_CASHPOOL_ATTRIBUTES table for IG */
65: /* deal attributes */
66: /****************************************************************/
67: PROCEDURE INSERT_IG_CASHPOOL (p_cashpool_id NUMBER,
68: p_portfolio VARCHAR2,

Line 83: INSERT INTO XTR_CASHPOOL_ATTRIBUTES

79: p_party_fund_limit VARCHAR2,
80: p_party_invest_limit VARCHAR2)IS
81: BEGIN
82: If p_cashpool_id is NOT NULL then
83: INSERT INTO XTR_CASHPOOL_ATTRIBUTES
84: (CASHPOOL_ATTRIBUTE_ID,
85: CASHPOOL_ID,
86: IAC_PORTFOLIO,
87: IAC_PRODUCT_TYPE,

Line 107: (xtr_cashpool_attributes_s.nextval,

103: LAST_UPDATED_BY,
104: LAST_UPDATE_DATE,
105: LAST_UPDATE_LOGIN)
106: VALUES
107: (xtr_cashpool_attributes_s.nextval,
108: p_cashpool_id,
109: null,
110: null,
111: p_portfolio,

Line 134: /* Update XTR_CASHPOOL_ATTRIBUTES table for IAC deal attributes */

130:
131: END;
132:
133: /****************************************************************/
134: /* Update XTR_CASHPOOL_ATTRIBUTES table for IAC deal attributes */
135: /****************************************************************/
136:
137: PROCEDURE UPDATE_IAC_CASHPOOL (p_cashpool_id NUMBER,
138: p_iac_portfolio VARCHAR2,

Line 141: Update XTR_CASHPOOL_ATTRIBUTES

137: PROCEDURE UPDATE_IAC_CASHPOOL (p_cashpool_id NUMBER,
138: p_iac_portfolio VARCHAR2,
139: p_iac_product_type VARCHAR2)IS
140: BEGIN
141: Update XTR_CASHPOOL_ATTRIBUTES
142: set IAC_PORTFOLIO = p_iac_portfolio,
143: IAC_PRODUCT_TYPE = p_iac_product_type
144: Where cashpool_id = p_cashpool_id
145: and IAC_PORTFOLIO is NOT NULL;

Line 149: /* Update XTR_CASHPOOL_ATTRIBUTES table for IG deal attributes */

145: and IAC_PORTFOLIO is NOT NULL;
146: END;
147:
148: /****************************************************************/
149: /* Update XTR_CASHPOOL_ATTRIBUTES table for IG deal attributes */
150: /* for Company */
151: /****************************************************************/
152: PROCEDURE UPDATE_IG_CASHPOOL (p_cashpool_id NUMBER,
153: p_portfolio VARCHAR2,

Line 167: Update XTR_CASHPOOL_ATTRIBUTES

163: p_party_pricing_model VARCHAR2,
164: p_party_fund_limit VARCHAR2,
165: p_party_invest_limit VARCHAR2)IS
166: BEGIN
167: Update XTR_CASHPOOL_ATTRIBUTES
168: Set PORTFOLIO = p_portfolio,
169: PRODUCT_TYPE = p_product_type,
170: ROUNDING_TYPE = p_rounding_type,
171: DAY_COUNT_TYPE = p_day_count_type,

Line 189: /* Update XTR_CASHPOOL_ATTRIBUTES table for IG deal attributes */

185: and iac_portfolio is NULL;
186: END;
187:
188: /****************************************************************/
189: /* Update XTR_CASHPOOL_ATTRIBUTES table for IG deal attributes */
190: /* for Intercompany */
191: /****************************************************************/
192: PROCEDURE UPDATE_IG_ROW_CASHPOOL (p_cashpool_id NUMBER,
193: p_fund_limit VARCHAR2,

Line 202: Update XTR_CASHPOOL_ATTRIBUTES

198: p_party_pricing_model VARCHAR2,
199: p_party_fund_limit VARCHAR2,
200: p_party_invest_limit VARCHAR2)IS
201: BEGIN
202: Update XTR_CASHPOOL_ATTRIBUTES
203: Set FUND_LIMIT_CODE = p_fund_limit,
204: INVEST_LIMIT_CODE = p_invest_limit,
205: PARTY_PORTFOLIO = p_party_portfolio,
206: PARTY_PRODUCT_TYPE = p_party_product_type,

Line 218: /* delete record from XTR_CASHPOOL_ATTRIBUTES table when user */

214: and party_code = p_party_code;
215: END;
216:
217: /****************************************************************/
218: /* delete record from XTR_CASHPOOL_ATTRIBUTES table when user */
219: /* remove sub-account from the cashpool */
220: /****************************************************************/
221: PROCEDURE DELETE_XTR_CASHPOOL (p_cashpool_id NUMBER,
222: p_party_code VARCHAR2) IS

Line 224: Delete from XTR_CASHPOOL_ATTRIBUTES

220: /****************************************************************/
221: PROCEDURE DELETE_XTR_CASHPOOL (p_cashpool_id NUMBER,
222: p_party_code VARCHAR2) IS
223: BEGIN
224: Delete from XTR_CASHPOOL_ATTRIBUTES
225: Where CASHPOOL_ATTRIBUTE_ID = p_cashpool_id
226: and party_code = p_party_code;
227: END;
228:

Line 245: from xtr_cashpool_attributes

241: x_pricing_model OUT NOCOPY VARCHAR2) is
242:
243: Cursor C_IAC_ATT is
244: select iac_portfolio, iac_product_type
245: from xtr_cashpool_attributes
246: where party_code = p_company_code
247: and iac_portfolio is NOT NULL
248: order by creation_date desc;
249:

Line 253: from xtr_cashpool_attributes

249:
250: Cursor C_IG_ATT is
251: select portfolio, product_type,
252: rounding_type, day_count_type, pricing_model
253: from xtr_cashpool_attributes
254: where party_code = p_company_code
255: and portfolio is NOT NULL
256: order by creation_date desc;
257: