DBA Data[Home] [Help]

APPS.IGI_IAC_COMMON_UTILS dependencies on IGI_IAC_TYPES

Line 43: P_prd_rec OUT NOCOPY igi_iac_types.prd_rec

39: -- DMahajan Start
40:
41: Function Get_Period_Info_for_Counter( P_book_type_Code IN VARCHAR2 ,
42: P_period_Counter IN NUMBER ,
43: P_prd_rec OUT NOCOPY igi_iac_types.prd_rec
44: )
45: RETURN BOOLEAN AS
46: l_path_name VARCHAR2(150);
47: BEGIN

Line 94: p_prd_rec OUT NOCOPY igi_iac_types.prd_rec

90:
91:
92: Function Get_Period_Info_for_Date( P_book_type_Code IN VARCHAR2 ,
93: P_date IN DATE ,
94: p_prd_rec OUT NOCOPY igi_iac_types.prd_rec
95: )
96: RETURN BOOLEAN AS
97: l_path_name VARCHAR2(150);
98: BEGIN

Line 142: p_prd_rec OUT NOCOPY igi_iac_types.prd_rec

138:
139:
140: Function Get_Period_Info_for_Name( P_book_type_Code IN VARCHAR2 ,
141: P_Prd_Name IN VARCHAR2 ,
142: p_prd_rec OUT NOCOPY igi_iac_types.prd_rec
143: )
144: RETURN BOOLEAN AS
145: l_path_name VARCHAR2(150);
146: BEGIN

Line 188: p_prd_rec OUT NOCOPY igi_iac_types.prd_rec

184:
185:
186:
187: Function Get_Open_Period_Info ( P_book_type_Code IN VARCHAR2 ,
188: p_prd_rec OUT NOCOPY igi_iac_types.prd_rec
189: )
190: RETURN BOOLEAN AS
191: l_path_name VARCHAR2(150);
192: BEGIN

Line 381: P_out_tab OUT NOCOPY igi_iac_types.dist_amt_tab

377:
378: Function Prorate_Amt_to_Active_Dists( P_book_type_Code IN VARCHAR2 ,
379: P_Asset_id IN NUMBER ,
380: P_Amount IN NUMBER ,
381: P_out_tab OUT NOCOPY igi_iac_types.dist_amt_tab
382: )
383: RETURN BOOLEAN AS
384: l_tot_units NUMBER;
385: l_dist_amount NUMBER;

Line 448: P_dh_tab OUT NOCOPY igi_iac_types.dh_tab

444:
445:
446: Function Get_Active_Distributions ( P_book_type_Code IN VARCHAR2 ,
447: P_Asset_id IN NUMBER ,
448: P_dh_tab OUT NOCOPY igi_iac_types.dh_tab
449: )
450: RETURN BOOLEAN AS
451:
452: l_index NUMBER;

Line 496: l_curr_prd_tab igi_iac_types.prd_rec ;

492: P_PY_Ratio OUT NOCOPY NUMBER ,
493: P_CY_Ratio OUT NOCOPY NUMBER
494: )
495: RETURN BOOLEAN AS
496: l_curr_prd_tab igi_iac_types.prd_rec ;
497: l_dpis_prd_tab igi_iac_types.prd_rec ;
498: l_dpis DATE ;
499: l_path_name VARCHAR2(150);
500: BEGIN

Line 497: l_dpis_prd_tab igi_iac_types.prd_rec ;

493: P_CY_Ratio OUT NOCOPY NUMBER
494: )
495: RETURN BOOLEAN AS
496: l_curr_prd_tab igi_iac_types.prd_rec ;
497: l_dpis_prd_tab igi_iac_types.prd_rec ;
498: l_dpis DATE ;
499: l_path_name VARCHAR2(150);
500: BEGIN
501: l_path_name := g_path||'get_cy_py_factors';

Line 692: l_prd_tab igi_iac_types.prd_rec ;

688: P_Asset_id IN NUMBER ,
689: P_retirements OUT NOCOPY VARCHAR2
690: )
691: RETURN BOOLEAN AS
692: l_prd_tab igi_iac_types.prd_rec ;
693: l_calendar VARCHAR2(30);
694: l_fiscal_year_name VARCHAR2(30);
695: l_fy_start_date DATE ;
696: l_tot_retirements NUMBER ;

Line 809: l_prd_rec igi_iac_types.prd_rec;

805: AND fb.book_type_code = X_book_type_code
806: AND fb.asset_id = X_asset_id
807: AND fb.date_ineffective is null;
808:
809: l_prd_rec igi_iac_types.prd_rec;
810: l_dpis DATE;
811: l_path_name VARCHAR2(150);
812:
813: Begin

Line 2208: l_prd_rec IGI_IAC_TYPES.prd_rec;

2204: AND nvl(active_flag, 'N') = 'N')
2205: ;
2206:
2207: l_get_asset_adj c_get_asset_adj%rowtype;
2208: l_prd_rec IGI_IAC_TYPES.prd_rec;
2209: l_path_name VARCHAR2(250);
2210:
2211: BEGIN
2212: l_path_name := g_path||'Is_Asset_Adjustment_Done';