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
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
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
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
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;
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;
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
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';
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 ;
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
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';