DBA Data[Home] [Help]

APPS.IGI_IAC_PROJ_PKG dependencies on IGI_IAC_TYPES

Line 38: P_prd_rec OUT NOCOPY igi_iac_types.prd_rec

34: -- information for the period counter
35: -- ===================================================================
36: FUNCTION Get_Period_Info_for_Counter( P_book_type_Code IN VARCHAR2 ,
37: P_period_Counter IN NUMBER ,
38: P_prd_rec OUT NOCOPY igi_iac_types.prd_rec
39: )
40: RETURN BOOLEAN AS
41: l_ret_flag BOOLEAN;
42: BEGIN

Line 285: l_prd_rec igi_iac_types.prd_rec;

281: FROM igi_iac_category_books
282: WHERE book_type_code = n_book_code
283: AND category_id= n_category_id));
284:
285: l_prd_rec igi_iac_types.prd_rec;
286: l_ret_flag BOOLEAN;
287: l_calendar fa_calendar_types.calendar_type%type;
288:
289:

Line 367: l_dpis_prd_rec igi_iac_types.prd_rec;

363:
364: l_dpis fa_books.date_placed_in_service%TYPE;
365: l_ret_flag BOOLEAN;
366: l_get_reval_period fa_deprn_summary.period_counter%TYPE;--c_get_reval_period%type;
367: l_dpis_prd_rec igi_iac_types.prd_rec;
368:
369:
370: BEGIN
371:

Line 413: PROCEDURE Get_Next_Period_Ctr(p_period_rec IN igi_iac_types.prd_rec,

409: -- ===================================================================
410: -- PROCEDURE Get_Next_Period_Ctr: Procedure will retrieve the next
411: -- period counter
412: -- ===================================================================
413: PROCEDURE Get_Next_Period_Ctr(p_period_rec IN igi_iac_types.prd_rec,
414: p_book_code IN fa_books.book_type_code%TYPE,
415: p_next_period_ctr OUT NOCOPY fa_deprn_periods.period_counter%TYPE)
416: IS
417:

Line 499: l_prd_rec_frm_ctr igi_iac_types.prd_rec;

495: FROM fa_book_controls
496: WHERE book_type_code = n_book_code);
497:
498:
499: l_prd_rec_frm_ctr igi_iac_types.prd_rec;
500: l_prd_rec_frm_date igi_iac_types.prd_rec;
501: l_end_date DATE;
502: l_asset_rec c_get_asset_det%ROWTYPE;
503: l_ret_flag BOOLEAN;

Line 500: l_prd_rec_frm_date igi_iac_types.prd_rec;

496: WHERE book_type_code = n_book_code);
497:
498:
499: l_prd_rec_frm_ctr igi_iac_types.prd_rec;
500: l_prd_rec_frm_date igi_iac_types.prd_rec;
501: l_end_date DATE;
502: l_asset_rec c_get_asset_det%ROWTYPE;
503: l_ret_flag BOOLEAN;
504: l_mess varchar2(255);

Line 507: l_dpis_prd_rec igi_iac_types.prd_rec;

503: l_ret_flag BOOLEAN;
504: l_mess varchar2(255);
505:
506: l_periods_in_year fa_calendar_types.number_per_fiscal_year%TYPE;
507: l_dpis_prd_rec igi_iac_types.prd_rec;
508: l_total_periods NUMBER;
509:
510: -- l_last_period_counter NUMBER;
511:

Line 915: l_period_info_rec igi_iac_types.prd_rec;

911: l_get_asset_bal_rec c_get_asset_all%ROWTYPE;
912: l_asset_dpis_date fa_books.date_placed_in_service%TYPE;
913:
914: l_next_period_ctr igi_iac_projections.start_period_counter%TYPE := 0;
915: l_period_info_rec igi_iac_types.prd_rec;
916: l_dpis_info_rec igi_iac_types.prd_rec;
917: l_ret_flag BOOLEAN;
918: l_fully_rsvd fa_books.period_counter_fully_reserved%TYPE;
919: l_company_seg VARCHAR2(30);

Line 916: l_dpis_info_rec igi_iac_types.prd_rec;

912: l_asset_dpis_date fa_books.date_placed_in_service%TYPE;
913:
914: l_next_period_ctr igi_iac_projections.start_period_counter%TYPE := 0;
915: l_period_info_rec igi_iac_types.prd_rec;
916: l_dpis_info_rec igi_iac_types.prd_rec;
917: l_ret_flag BOOLEAN;
918: l_fully_rsvd fa_books.period_counter_fully_reserved%TYPE;
919: l_company_seg VARCHAR2(30);
920: l_cc_seg VARCHAR2(30);

Line 950: l_prd_rec igi_iac_types.prd_rec;

946: l_count NUMBER := 1;
947: l_login_id NUMBER := fnd_profile.value('LOGIN_ID');
948: l_user_id NUMBER := fnd_profile.value('USER_ID');
949:
950: l_prd_rec igi_iac_types.prd_rec;
951: l_start_period_name VARCHAR2(30);
952: l_end_period_name VARCHAR2(30);
953: l_concat_cat VARCHAR2(500);
954: l_cat_segs fa_rx_shared_pkg.Seg_Array;