DBA Data[Home] [Help]

APPS.XTR_COF_P dependencies on XTR_INTERGROUP_TRANSFERS

Line 5: P_DEAL_NUMBER IN XTR_INTERGROUP_TRANSFERS.DEAL_NUMBER%TYPE,

1: PACKAGE BODY XTR_COF_P as
2: /* $Header: xtrcostb.pls 120.12 2005/10/24 10:47:31 eaggarwa ship $ */
3: ----------------------------------------------------------------------------------------------------------------
4: PROCEDURE SET_CURR_IG_DEAL_DETAILS(
5: P_DEAL_NUMBER IN XTR_INTERGROUP_TRANSFERS.DEAL_NUMBER%TYPE,
6: P_TRANSACTION_NUMBER IN XTR_INTERGROUP_TRANSFERS.TRANSACTION_NUMBER%TYPE,
7: P_MATURITY_DATE IN DATE) IS
8: BEGIN
9: g_ig_curr_deal_number := p_deal_number;

Line 6: P_TRANSACTION_NUMBER IN XTR_INTERGROUP_TRANSFERS.TRANSACTION_NUMBER%TYPE,

2: /* $Header: xtrcostb.pls 120.12 2005/10/24 10:47:31 eaggarwa ship $ */
3: ----------------------------------------------------------------------------------------------------------------
4: PROCEDURE SET_CURR_IG_DEAL_DETAILS(
5: P_DEAL_NUMBER IN XTR_INTERGROUP_TRANSFERS.DEAL_NUMBER%TYPE,
6: P_TRANSACTION_NUMBER IN XTR_INTERGROUP_TRANSFERS.TRANSACTION_NUMBER%TYPE,
7: P_MATURITY_DATE IN DATE) IS
8: BEGIN
9: g_ig_curr_deal_number := p_deal_number;
10: g_ig_curr_transaction_number := p_transaction_number;

Line 15: P_DEAL_NUMBER IN XTR_INTERGROUP_TRANSFERS.DEAL_NUMBER%TYPE,

11: g_ig_curr_maturity_date := p_maturity_date;
12: END SET_CURR_IG_DEAL_DETAILS;
13:
14: PROCEDURE GET_CURR_IG_DEAL_DETAILS(
15: P_DEAL_NUMBER IN XTR_INTERGROUP_TRANSFERS.DEAL_NUMBER%TYPE,
16: P_TRANSACTION_NUMBER IN XTR_INTERGROUP_TRANSFERS.TRANSACTION_NUMBER%TYPE,
17: P_MATURITY_DATE OUT NOCOPY DATE) IS
18: BEGIN
19: if (p_deal_number = g_ig_curr_deal_number and

Line 16: P_TRANSACTION_NUMBER IN XTR_INTERGROUP_TRANSFERS.TRANSACTION_NUMBER%TYPE,

12: END SET_CURR_IG_DEAL_DETAILS;
13:
14: PROCEDURE GET_CURR_IG_DEAL_DETAILS(
15: P_DEAL_NUMBER IN XTR_INTERGROUP_TRANSFERS.DEAL_NUMBER%TYPE,
16: P_TRANSACTION_NUMBER IN XTR_INTERGROUP_TRANSFERS.TRANSACTION_NUMBER%TYPE,
17: P_MATURITY_DATE OUT NOCOPY DATE) IS
18: BEGIN
19: if (p_deal_number = g_ig_curr_deal_number and
20: p_transaction_number = g_ig_curr_transaction_number) then

Line 2399: from xtr_intergroup_transfers

2395: cursor get_ig_row is
2396: select nvl(balance_out,0) base_amount,
2397: interest_rate,
2398: day_count_type -- Added for Interest Override feature
2399: from xtr_intergroup_transfers
2400: where company_code = L_COMPANY_CODE
2401: and party_code= L_CPARTY_CODE
2402: and currency = L_CURRENCY
2403: and deal_number = L_DEAL_NUMBER