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_IG_TRANSFERS_PKG dependencies on XTR_INTERGROUP_TRANSFERS

Line 160: cursor mirror_deal(c_comp IN Xtr_Intergroup_Transfers.Company_Code%type,

156: function IS_MIRROR_DEAL(p_comp IN VARCHAR2,
157: p_cparty IN VARCHAR2,
158: p_curr IN VARCHAR2) return boolean is
159: -----------------------------------------------------------------------------------------------------
160: cursor mirror_deal(c_comp IN Xtr_Intergroup_Transfers.Company_Code%type,
161: c_cparty IN Xtr_Intergroup_Transfers.Party_Code%type,
162: c_curr IN Xtr_Intergroup_Transfers.Currency%type) is
163: select mirror_Deal
164: from xtr_intergroup_transfers

Line 161: c_cparty IN Xtr_Intergroup_Transfers.Party_Code%type,

157: p_cparty IN VARCHAR2,
158: p_curr IN VARCHAR2) return boolean is
159: -----------------------------------------------------------------------------------------------------
160: cursor mirror_deal(c_comp IN Xtr_Intergroup_Transfers.Company_Code%type,
161: c_cparty IN Xtr_Intergroup_Transfers.Party_Code%type,
162: c_curr IN Xtr_Intergroup_Transfers.Currency%type) is
163: select mirror_Deal
164: from xtr_intergroup_transfers
165: where company_Code = c_comp

Line 162: c_curr IN Xtr_Intergroup_Transfers.Currency%type) is

158: p_curr IN VARCHAR2) return boolean is
159: -----------------------------------------------------------------------------------------------------
160: cursor mirror_deal(c_comp IN Xtr_Intergroup_Transfers.Company_Code%type,
161: c_cparty IN Xtr_Intergroup_Transfers.Party_Code%type,
162: c_curr IN Xtr_Intergroup_Transfers.Currency%type) is
163: select mirror_Deal
164: from xtr_intergroup_transfers
165: where company_Code = c_comp
166: and party_Code = c_cparty

Line 164: from xtr_intergroup_transfers

160: cursor mirror_deal(c_comp IN Xtr_Intergroup_Transfers.Company_Code%type,
161: c_cparty IN Xtr_Intergroup_Transfers.Party_Code%type,
162: c_curr IN Xtr_Intergroup_Transfers.Currency%type) is
163: select mirror_Deal
164: from xtr_intergroup_transfers
165: where company_Code = c_comp
166: and party_Code = c_cparty
167: and currency = c_curr
168: and mirror_Deal = 'Y';

Line 199: from xtr_intergroup_transfers_v

195: p_pricing_model VARCHAR2) is
196: -----------------------------------------------------------------------------------------------------
197: cursor get_pricing_model is
198: select pricing_model, deal_number
199: from xtr_intergroup_transfers_v
200: where company_code = p_company_code
201: and party_code = p_party_code
202: and currency = p_currency;
203:

Line 213: UPDATE xtr_intergroup_transfers

209: fetch get_pricing_model into l_pricing_model, l_deal_number;
210: close get_pricing_model;
211:
212: if l_deal_number is not null AND p_pricing_model <> l_pricing_model then
213: UPDATE xtr_intergroup_transfers
214: SET pricing_model = p_pricing_model
215: WHERE deal_number = l_deal_number;
216: end if;
217: END;

Line 234: from xtr_intergroup_transfers_v

230: p_pricing_model OUT NOCOPY VARCHAR2) is
231: -----------------------------------------------------------------------------------------------------
232: cursor get_pricing_model is
233: select pricing_model
234: from xtr_intergroup_transfers_v
235: where company_code = p_company_code
236: and party_code = p_party_code
237: and currency = p_currency;
238:

Line 324: from XTR_INTERGROUP_TRANSFERS

320:
321: begin
322: select count(*)
323: into l_count
324: from XTR_INTERGROUP_TRANSFERS
325: where company_code = p_company_code
326: and party_code = p_party_code
327: and currency = p_currency
328: and transfer_date = p_transfer_Date

Line 849: FROM xtr_intergroup_transfers it,

845:
846: -- Find existing reval details for this deal.
847: cursor cur_reval_deal IS
848: SELECT rd.batch_id
849: FROM xtr_intergroup_transfers it,
850: xtr_revaluation_details rd
851: WHERE it.deal_number = l_deal_no
852: AND it.deal_number = rd.deal_no
853: AND period_to >= p_transfer_date; -- bug 4367386

Line 1107: from xtr_INTERGROUP_TRANSFERS_v a

1103: a.TRANSACTION_NUMBER,
1104: a.ACCRUAL_INTEREST,
1105: a.ROUNDING_TYPE, --* Add for Interest Project
1106: a.DAY_COUNT_TYPE --* Add for Interest Project
1107: from xtr_INTERGROUP_TRANSFERS_v a
1108: where a.PARTY_CODE = G_Ig_Main_Rec.PARTY_CODE
1109: and a.COMPANY_CODE = G_Ig_Main_Rec.COMPANY_CODE
1110: and a.CURRENCY = G_Ig_Main_Rec.CURRENCY
1111: and a.TRANSFER_DATE <= G_Ig_Main_Rec.TRANSFER_DATE

Line 1117: from xtr_intergroup_transfers

1113: --
1114: --* Add for Interest Project
1115: cursor OLDEST_DATE is
1116: select min(TRANSFER_DATE)
1117: from xtr_intergroup_transfers
1118: where party_code = G_Ig_Main_Rec.PARTY_CODE
1119: and company_code = G_Ig_Main_Rec.COMPANY_CODE
1120: and currency = G_Ig_Main_Rec.CURRENCY;
1121: --

Line 1124: from XTR_INTERGROUP_TRANSFERS

1120: and currency = G_Ig_Main_Rec.CURRENCY;
1121: --
1122: cursor PRV_DAY_COUNT_TYPE is
1123: SELECT DAY_COUNT_TYPE
1124: from XTR_INTERGROUP_TRANSFERS
1125: where company_code = G_Ig_Main_Rec.COMPANY_CODE
1126: and party_code = G_Ig_Main_Rec.PARTY_CODE
1127: and currency = G_Ig_Main_Rec.CURRENCY
1128: and transfer_date = (select max(transfer_date)

Line 1129: from xtr_intergroup_transfers

1125: where company_code = G_Ig_Main_Rec.COMPANY_CODE
1126: and party_code = G_Ig_Main_Rec.PARTY_CODE
1127: and currency = G_Ig_Main_Rec.CURRENCY
1128: and transfer_date = (select max(transfer_date)
1129: from xtr_intergroup_transfers
1130: where company_code = G_Ig_Main_Rec.COMPANY_CODE
1131: and party_code = G_Ig_Main_Rec.PARTY_CODE
1132: and currency = G_Ig_Main_Rec.CURRENCY
1133: and transfer_date < prv_date)

Line 1854: cursor deal_number_cursor(c_comp IN Xtr_Intergroup_Transfers.Company_Code%type,

1850: p_deal_no IN OUT NOCOPY NUMBER,
1851: p_tran_no IN OUT NOCOPY NUMBER,
1852: p_new_deal IN VARCHAR2) is
1853: -----------------------------------------------------------------------------------------------------
1854: cursor deal_number_cursor(c_comp IN Xtr_Intergroup_Transfers.Company_Code%type,
1855: c_cparty IN Xtr_Intergroup_Transfers.Party_Code%type,
1856: c_curr IN Xtr_Intergroup_Transfers.Currency%type) is
1857: select deal_number,
1858: transaction_number

Line 1855: c_cparty IN Xtr_Intergroup_Transfers.Party_Code%type,

1851: p_tran_no IN OUT NOCOPY NUMBER,
1852: p_new_deal IN VARCHAR2) is
1853: -----------------------------------------------------------------------------------------------------
1854: cursor deal_number_cursor(c_comp IN Xtr_Intergroup_Transfers.Company_Code%type,
1855: c_cparty IN Xtr_Intergroup_Transfers.Party_Code%type,
1856: c_curr IN Xtr_Intergroup_Transfers.Currency%type) is
1857: select deal_number,
1858: transaction_number
1859: from xtr_intergroup_transfers

Line 1856: c_curr IN Xtr_Intergroup_Transfers.Currency%type) is

1852: p_new_deal IN VARCHAR2) is
1853: -----------------------------------------------------------------------------------------------------
1854: cursor deal_number_cursor(c_comp IN Xtr_Intergroup_Transfers.Company_Code%type,
1855: c_cparty IN Xtr_Intergroup_Transfers.Party_Code%type,
1856: c_curr IN Xtr_Intergroup_Transfers.Currency%type) is
1857: select deal_number,
1858: transaction_number
1859: from xtr_intergroup_transfers
1860: where company_Code = c_comp

Line 1859: from xtr_intergroup_transfers

1855: c_cparty IN Xtr_Intergroup_Transfers.Party_Code%type,
1856: c_curr IN Xtr_Intergroup_Transfers.Currency%type) is
1857: select deal_number,
1858: transaction_number
1859: from xtr_intergroup_transfers
1860: where company_Code = c_comp
1861: and party_Code = c_cparty
1862: and currency = c_curr
1863: order by transaction_number desc;

Line 1897: procedure CREATE_IG_DEAL(ARec_IG IN XTR_INTERGROUP_TRANSFERS%rowtype ) is

1893:
1894:
1895: -----------------------------------------------------------------------------------------------------
1896: --* Table Handler For Xtr_Interroup_Transfers For Inserting Row
1897: procedure CREATE_IG_DEAL(ARec_IG IN XTR_INTERGROUP_TRANSFERS%rowtype ) is
1898: -----------------------------------------------------------------------------------------------------
1899: begin
1900:
1901: Insert into XTR_INTERGROUP_TRANSFERS(

Line 1901: Insert into XTR_INTERGROUP_TRANSFERS(

1897: procedure CREATE_IG_DEAL(ARec_IG IN XTR_INTERGROUP_TRANSFERS%rowtype ) is
1898: -----------------------------------------------------------------------------------------------------
1899: begin
1900:
1901: Insert into XTR_INTERGROUP_TRANSFERS(
1902: EXTERNAL_DEAL_ID ,
1903: ACCUM_INTEREST_BF ,
1904: ACCUM_INTEREST_BF_HCE ,
1905: BALANCE_BF ,

Line 2415: from XTR_INTERGROUP_TRANSFERS_v

2411: PORTFOLIO,
2412: nvl(ACCRUAL_INTEREST,0),
2413: ROUNDING_TYPE, --* Add for Interest Override
2414: DAY_COUNT_TYPE --* Add for Interest Override
2415: from XTR_INTERGROUP_TRANSFERS_v
2416: where PARTY_CODE = p_party_code
2417: and CURRENCY = p_currency
2418: and COMPANY_CODE = p_company_code
2419: and TRANSFER_DATE >= p_transfer_date

Line 2436: FROM XTR_INTERGROUP_TRANSFERS

2432:
2433: --* Add for Interest Override Project
2434: cursor PRV_DAY_COUNT_TYPE is
2435: SELECT DAY_COUNT_TYPE
2436: FROM XTR_INTERGROUP_TRANSFERS
2437: WHERE PARTY_CODE = p_party_code
2438: AND CURRENCY = p_currency
2439: AND COMPANY_CODE = p_company_code
2440: AND TRANSFER_DATE = (select max(transfer_date)

Line 2441: from xtr_intergroup_transfers

2437: WHERE PARTY_CODE = p_party_code
2438: AND CURRENCY = p_currency
2439: AND COMPANY_CODE = p_company_code
2440: AND TRANSFER_DATE = (select max(transfer_date)
2441: from xtr_intergroup_transfers
2442: where party_code = p_party_code
2443: and currency = p_currency
2444: and company_code = p_company_code
2445: and transfer_date < prv_date)

Line 2464: from XTR_INTERGROUP_TRANSFERS

2460: --* Add for Interest Project
2461: /* Get the oldest transfer date */
2462: select min(TRANSFER_DATE)
2463: into l_oldest_date
2464: from XTR_INTERGROUP_TRANSFERS
2465: where PARTY_CODE = p_party_code
2466: and CURRENCY = p_currency
2467: and COMPANY_CODE = p_company_code;
2468: --* Add End

Line 2541: update xtr_INTERGROUP_TRANSFERS_v

2537:
2538: l_accrual_int := nvl(prv_accrual_int,0) + nvl(l_interest,0);
2539:
2540: if p_update = 'Y' then
2541: update xtr_INTERGROUP_TRANSFERS_v
2542: set BALANCE_BF = prv_bal_out,
2543: BALANCE_BF_HCE = prv_bal_out_hce,
2544: BALANCE_OUT = l_bal_out,
2545: BALANCE_OUT_HCE = l_bal_out_hce,

Line 2564: update xtr_INTERGROUP_TRANSFERS_v

2560: --* Add for Interest Project
2561: --* When this flag is set, all transaction should be recalculated and replaced by new types.
2562:
2563: if p_types_update = 'Y' and p_update ='Y' and l_count = 0 then
2564: update xtr_INTERGROUP_TRANSFERS_v
2565: set DAY_COUNT_TYPE = nvl(p_day_count_type,l_day_count_type),
2566: ROUNDING_TYPE = nvl(p_rounding_type,l_rounding_type)
2567: where rowid=l_rowid;
2568: end if;

Line 3143: /* Call the insert procedure to insert into xtr_intergroup_transfers */

3139: tran_num:=G_Ig_Main_Rec.Transaction_number;
3140: --**********************************************************************************************************
3141:
3142: /*-------------------------------------------------------------------*/
3143: /* Call the insert procedure to insert into xtr_intergroup_transfers */
3144: /*-------------------------------------------------------------------*/
3145:
3146: CREATE_IG_DEAL(G_Ig_Main_Rec);
3147:

Line 3283: update xtr_intergroup_transfers

3279: G_Ig_Mirror_Rec.PRODUCT_TYPE,
3280: G_Ig_Mirror_Rec.PRICING_MODEL);
3281: end if;
3282:
3283: update xtr_intergroup_transfers
3284: set mirror_deal_number = G_Ig_Mirror_Rec.deal_number,
3285: mirror_transaction_number = G_Ig_Mirror_Rec.transaction_number
3286: where deal_number = G_Ig_Main_Rec.deal_number
3287: and transaction_number = G_Ig_Main_Rec.transaction_number;