DBA Data[Home] [Help]

APPS.IGI_IAC_RETIREMENT dependencies on IGI_IAC_ADJUSTMENTS_PKG

Line 811: igi_iac_adjustments_pkg.insert_row(

807: debug( g_state_level,l_path_name,'done nbv ret ccid');
808:
809: l_rowid := NULL ;
810:
811: igi_iac_adjustments_pkg.insert_row(
812: X_rowid => l_rowid ,
813: X_adjustment_id => l_retirement_adjustment_id ,
814: X_book_type_code => P_Book_Type_Code ,
815: X_code_combination_id => l_nbv_retired_account_ccid,

Line 834: igi_iac_adjustments_pkg.insert_row(

830: debug( g_state_level,l_path_name,'NBV RETIRED...');
831:
832: l_rowid := NULL ;
833:
834: igi_iac_adjustments_pkg.insert_row(
835: X_rowid => l_rowid ,
836: X_adjustment_id => l_retirement_adjustment_id ,
837: X_book_type_code => P_Book_Type_Code ,
838: X_code_combination_id => l_nbv_retired_account_ccid,

Line 869: igi_iac_adjustments_pkg.insert_row(

865: RAISE e_no_account_ccid ;
866: END IF ;
867: debug( g_state_level,l_path_name,'done reval rsv ret ccid');
868: l_rowid := NULL ;
869: igi_iac_adjustments_pkg.insert_row(
870: X_rowid => l_rowid ,
871: X_adjustment_id => l_retirement_adjustment_id ,
872: X_book_type_code => P_Book_Type_Code ,
873: X_code_combination_id => l_reval_rsv_ret_acct_ccid,

Line 894: igi_iac_adjustments_pkg.insert_row(

890:
891: /* Create adjustment for new balances */
892: debug( g_state_level,l_path_name,'start new balances');
893: l_rowid := NULL ;
894: igi_iac_adjustments_pkg.insert_row(
895: X_rowid => l_rowid ,
896: X_adjustment_id => l_retirement_adjustment_id ,
897: X_book_type_code => P_Book_Type_Code ,
898: X_code_combination_id => l_cost_account_ccid,

Line 919: igi_iac_adjustments_pkg.insert_row(

915: debug( g_state_level,l_path_name,'COST...'|| l_detail_balances_retire.adjustment_cost);
916: IF l_detail_balances_retire.deprn_reserve <> 0 THEN
917:
918: l_rowid := NULL ;
919: igi_iac_adjustments_pkg.insert_row(
920: X_rowid => l_rowid ,
921: X_adjustment_id => l_retirement_adjustment_id ,
922: X_book_type_code => P_Book_Type_Code ,
923: X_code_combination_id => l_acc_deprn_account_ccid,

Line 951: igi_iac_adjustments_pkg.insert_row(

947: RAISE e_no_account_ccid ;
948: END IF ;
949:
950: l_rowid := NULL ;
951: igi_iac_adjustments_pkg.insert_row(
952: X_rowid => l_rowid ,
953: X_adjustment_id => l_retirement_adjustment_id ,
954: X_book_type_code => P_Book_Type_Code ,
955: X_code_combination_id => l_backlog_account_ccid,

Line 978: igi_iac_adjustments_pkg.insert_row(

974:
975: IF l_detail_balances_retire.reval_reserve_backlog <> 0 THEN
976:
977: l_rowid := NULL ;
978: igi_iac_adjustments_pkg.insert_row(
979: X_rowid => l_rowid ,
980: X_adjustment_id => l_retirement_adjustment_id ,
981: X_book_type_code => P_Book_Type_Code ,
982: X_code_combination_id => l_backlog_account_ccid,

Line 1007: igi_iac_adjustments_pkg.insert_row(

1003:
1004: IF l_detail_balances_retire.reval_reserve_net <> 0 THEN
1005:
1006: l_rowid := NULL ;
1007: igi_iac_adjustments_pkg.insert_row(
1008: X_rowid => l_rowid ,
1009: X_adjustment_id => l_retirement_adjustment_id ,
1010: X_book_type_code => P_Book_Type_Code ,
1011: X_code_combination_id => l_reval_rsv_account_ccid,

Line 1496: igi_iac_adjustments_pkg.insert_row(

1492: l_retire_amount := l_all_occ_reval.amount * P_retirement_factor;
1493: do_round(l_retire_amount,P_Book_Type_Code);
1494: l_ret:= igi_iac_common_utils.iac_round(l_retire_amount,P_Book_Type_Code) ;
1495: l_rowid := NULL ;
1496: igi_iac_adjustments_pkg.insert_row(
1497: X_rowid => l_rowid ,
1498: X_adjustment_id => l_retirement_adjustment_id ,
1499: X_book_type_code => P_Book_Type_Code ,
1500: X_code_combination_id => l_all_occ_reval.code_combination_id,

Line 1791: igi_iac_adjustments_pkg.insert_row(

1787: l_retire_amount := l_all_prd_reval.amount * P_retirement_factor;
1788: do_round(l_retire_amount,P_Book_Type_Code);
1789: l_ret:= igi_iac_common_utils.iac_round(l_retire_amount,P_Book_Type_Code) ;
1790: l_rowid := NULL ;
1791: igi_iac_adjustments_pkg.insert_row(
1792: X_rowid => l_rowid ,
1793: X_adjustment_id => l_retirement_adjustment_id ,
1794: X_book_type_code => P_Book_Type_Code ,
1795: X_code_combination_id => l_all_prd_reval.code_combination_id,

Line 2546: igi_iac_adjustments_pkg.insert_row(

2542: END IF ;
2543: debug( g_state_level,l_path_name,'done nbv ret ccid');
2544: l_rowid := NULL ;
2545:
2546: igi_iac_adjustments_pkg.insert_row(
2547: X_rowid => l_rowid ,
2548: X_adjustment_id => l_retirement_adjustment_id ,
2549: X_book_type_code => P_Book_Type_Code ,
2550: X_code_combination_id => l_nbv_retired_account_ccid,

Line 2569: igi_iac_adjustments_pkg.insert_row(

2565: debug( g_state_level,l_path_name,'done nbv ret insert');
2566:
2567: l_rowid := NULL ;
2568:
2569: igi_iac_adjustments_pkg.insert_row(
2570: X_rowid => l_rowid ,
2571: X_adjustment_id => l_retirement_adjustment_id ,
2572: X_book_type_code => P_Book_Type_Code ,
2573: X_code_combination_id => l_nbv_retired_account_ccid,

Line 2601: igi_iac_adjustments_pkg.insert_row(

2597: RAISE e_no_account_ccid ;
2598: END IF ;
2599: debug( g_state_level,l_path_name,'done reval rsv ret ccid');
2600: l_rowid := NULL ;
2601: igi_iac_adjustments_pkg.insert_row(
2602: X_rowid => l_rowid ,
2603: X_adjustment_id => l_retirement_adjustment_id ,
2604: X_book_type_code => P_Book_Type_Code ,
2605: X_code_combination_id => l_reval_rsv_ret_acct_ccid,

Line 2626: igi_iac_adjustments_pkg.insert_row(

2622:
2623: /* Create adjustment for new balances */
2624: debug( g_state_level,l_path_name,'start new balances');
2625: l_rowid := NULL ;
2626: igi_iac_adjustments_pkg.insert_row(
2627: X_rowid => l_rowid ,
2628: X_adjustment_id => l_retirement_adjustment_id ,
2629: X_book_type_code => P_Book_Type_Code ,
2630: X_code_combination_id => l_cost_account_ccid,

Line 2651: igi_iac_adjustments_pkg.insert_row(

2647: debug( g_state_level,l_path_name,'done new cost');
2648: IF l_detail_balances.deprn_reserve <> 0 THEN
2649:
2650: l_rowid := NULL ;
2651: igi_iac_adjustments_pkg.insert_row(
2652: X_rowid => l_rowid ,
2653: X_adjustment_id => l_retirement_adjustment_id ,
2654: X_book_type_code => P_Book_Type_Code ,
2655: X_code_combination_id => l_acc_deprn_account_ccid,

Line 2682: igi_iac_adjustments_pkg.insert_row(

2678: RAISE e_no_account_ccid ;
2679: END IF ;
2680:
2681: l_rowid := NULL ;
2682: igi_iac_adjustments_pkg.insert_row(
2683: X_rowid => l_rowid ,
2684: X_adjustment_id => l_retirement_adjustment_id ,
2685: X_book_type_code => P_Book_Type_Code ,
2686: X_code_combination_id => l_backlog_account_ccid,

Line 2709: igi_iac_adjustments_pkg.insert_row(

2705:
2706: IF l_detail_balances.reval_reserve_backlog <> 0 THEN
2707:
2708: l_rowid := NULL ;
2709: igi_iac_adjustments_pkg.insert_row(
2710: X_rowid => l_rowid ,
2711: X_adjustment_id => l_retirement_adjustment_id ,
2712: X_book_type_code => P_Book_Type_Code ,
2713: X_code_combination_id => l_backlog_account_ccid,

Line 2736: igi_iac_adjustments_pkg.insert_row(

2732:
2733: IF l_detail_balances.reval_reserve_net<> 0 THEN
2734:
2735: l_rowid := NULL ;
2736: igi_iac_adjustments_pkg.insert_row(
2737: X_rowid => l_rowid ,
2738: X_adjustment_id => l_retirement_adjustment_id ,
2739: X_book_type_code => P_Book_Type_Code ,
2740: X_code_combination_id => l_reval_rsv_account_ccid,

Line 2897: igi_iac_adjustments_pkg.insert_row(

2893:
2894: IF ((l_detail_balances_new.adjustment_cost-l_detail_balances_new.deprn_reserve<>0) OR (l_detail_balances_new.deprn_reserve_backlog <>0)) THEN -- Kaps
2895:
2896: l_rowid := NULL ;
2897: igi_iac_adjustments_pkg.insert_row(
2898: X_rowid => l_rowid ,
2899: X_adjustment_id => l_retirement_adjustment_id ,
2900: X_book_type_code => P_Book_Type_Code ,
2901: X_code_combination_id => l_nbv_retired_account_ccid,

Line 2920: igi_iac_adjustments_pkg.insert_row(

2916: debug( g_state_level,l_path_name,'done nbv ret insert');
2917:
2918: l_rowid := NULL ;
2919:
2920: igi_iac_adjustments_pkg.insert_row(
2921: X_rowid => l_rowid ,
2922: X_adjustment_id => l_retirement_adjustment_id ,
2923: X_book_type_code => P_Book_Type_Code ,
2924: X_code_combination_id => l_nbv_retired_account_ccid,

Line 2947: igi_iac_adjustments_pkg.insert_row(

2943: IF l_detail_balances_new.reval_reserve_net <> 0 THEN
2944:
2945: debug( g_state_level,l_path_name,'done reval rsv ret ccid');
2946: l_rowid := NULL ;
2947: igi_iac_adjustments_pkg.insert_row(
2948: X_rowid => l_rowid ,
2949: X_adjustment_id => l_retirement_adjustment_id ,
2950: X_book_type_code => P_Book_Type_Code ,
2951: X_code_combination_id => l_reval_rsv_ret_acct_ccid,

Line 2970: igi_iac_adjustments_pkg.insert_row(

2966: debug( g_state_level,l_path_name,'done reval rsv ret insert');
2967: END IF;
2968:
2969: l_rowid := NULL ;
2970: igi_iac_adjustments_pkg.insert_row(
2971: X_rowid => l_rowid ,
2972: X_adjustment_id => l_retirement_adjustment_id ,
2973: X_book_type_code => P_Book_Type_Code ,
2974: X_code_combination_id => l_cost_account_ccid,

Line 2991: igi_iac_adjustments_pkg.insert_row(

2987: X_event_id => P_Event_Id ) ;
2988:
2989: debug( g_state_level,l_path_name,'done new cost for new dist');
2990: l_rowid := NULL ;
2991: igi_iac_adjustments_pkg.insert_row(
2992: X_rowid => l_rowid ,
2993: X_adjustment_id => l_retirement_adjustment_id ,
2994: X_book_type_code => P_Book_Type_Code ,
2995: X_code_combination_id => l_acc_deprn_account_ccid,

Line 3010: igi_iac_adjustments_pkg.insert_row(

3006: X_report_ccid => NULL,
3007: X_mode => 'R',
3008: X_event_id => P_Event_Id ) ;
3009: l_rowid := NULL ;
3010: igi_iac_adjustments_pkg.insert_row(
3011: X_rowid => l_rowid ,
3012: X_adjustment_id => l_retirement_adjustment_id ,
3013: X_book_type_code => P_Book_Type_Code ,
3014: X_code_combination_id => l_backlog_account_ccid,

Line 3032: igi_iac_adjustments_pkg.insert_row(

3028:
3029:
3030: debug( g_state_level,l_path_name,'done BL reserve for new dist');
3031: l_rowid := NULL ;
3032: igi_iac_adjustments_pkg.insert_row(
3033: X_rowid => l_rowid ,
3034: X_adjustment_id => l_retirement_adjustment_id ,
3035: X_book_type_code => P_Book_Type_Code ,
3036: X_code_combination_id => l_reval_rsv_account_ccid,

Line 3592: igi_iac_adjustments_pkg.insert_row(

3588:
3589: l_retire_amount:=l_all_occ_reval.amount;
3590: --l_ret:= igi_iac_common_utils.iac_round(l_retire_amount,P_Book_Type_Code);
3591: l_rowid := NULL ;
3592: igi_iac_adjustments_pkg.insert_row(
3593: X_rowid => l_rowid ,
3594: X_adjustment_id => l_retirement_adjustment_id ,
3595: X_book_type_code => P_Book_Type_Code ,
3596: X_code_combination_id => l_all_occ_reval.code_combination_id,

Line 3623: igi_iac_adjustments_pkg.insert_row(

3619: do_round(l_retire_amount,P_Book_Type_Code);
3620: l_ret:= igi_iac_common_utils.iac_round(l_retire_amount,P_Book_Type_Code);
3621:
3622: l_rowid := NULL ;
3623: igi_iac_adjustments_pkg.insert_row(
3624: X_rowid => l_rowid ,
3625: X_adjustment_id => l_retirement_adjustment_id ,
3626: X_book_type_code => P_Book_Type_Code ,
3627: X_code_combination_id => l_all_occ_reval.code_combination_id,

Line 3987: igi_iac_adjustments_pkg.insert_row(

3983:
3984: l_retire_amount:=l_all_prd_reval.amount;
3985: --l_ret:= igi_iac_common_utils.iac_round(l_retire_amount,P_Book_Type_Code);
3986: l_rowid := NULL ;
3987: igi_iac_adjustments_pkg.insert_row(
3988: X_rowid => l_rowid ,
3989: X_adjustment_id => l_retirement_adjustment_id ,
3990: X_book_type_code => P_Book_Type_Code ,
3991: X_code_combination_id => l_all_prd_reval.code_combination_id,

Line 4018: igi_iac_adjustments_pkg.insert_row(

4014: do_round(l_retire_amount,P_Book_Type_Code);
4015: l_ret:= igi_iac_common_utils.iac_round(l_retire_amount,P_Book_Type_Code);
4016:
4017: l_rowid := NULL ;
4018: igi_iac_adjustments_pkg.insert_row(
4019: X_rowid => l_rowid ,
4020: X_adjustment_id => l_retirement_adjustment_id ,
4021: X_book_type_code => P_Book_Type_Code ,
4022: X_code_combination_id => l_all_prd_reval.code_combination_id,