DBA Data[Home] [Help]

APPS.IGI_IAC_RETIREMENT dependencies on IGI_IAC_ADJUSTMENTS_PKG

Line 740: igi_iac_adjustments_pkg.insert_row(

736: debug( g_state_level,l_path_name,'done nbv ret ccid');
737:
738: l_rowid := NULL ;
739:
740: igi_iac_adjustments_pkg.insert_row(
741: X_rowid => l_rowid ,
742: X_adjustment_id => l_retirement_adjustment_id ,
743: X_book_type_code => P_Book_Type_Code ,
744: X_code_combination_id => l_nbv_retired_account_ccid,

Line 763: igi_iac_adjustments_pkg.insert_row(

759: debug( g_state_level,l_path_name,'NBV RETIRED...');
760:
761: l_rowid := NULL ;
762:
763: igi_iac_adjustments_pkg.insert_row(
764: X_rowid => l_rowid ,
765: X_adjustment_id => l_retirement_adjustment_id ,
766: X_book_type_code => P_Book_Type_Code ,
767: X_code_combination_id => l_nbv_retired_account_ccid,

Line 798: igi_iac_adjustments_pkg.insert_row(

794: RAISE e_no_account_ccid ;
795: END IF ;
796: debug( g_state_level,l_path_name,'done reval rsv ret ccid');
797: l_rowid := NULL ;
798: igi_iac_adjustments_pkg.insert_row(
799: X_rowid => l_rowid ,
800: X_adjustment_id => l_retirement_adjustment_id ,
801: X_book_type_code => P_Book_Type_Code ,
802: X_code_combination_id => l_reval_rsv_ret_acct_ccid,

Line 823: igi_iac_adjustments_pkg.insert_row(

819:
820: /* Create adjustment for new balances */
821: debug( g_state_level,l_path_name,'start new balances');
822: l_rowid := NULL ;
823: igi_iac_adjustments_pkg.insert_row(
824: X_rowid => l_rowid ,
825: X_adjustment_id => l_retirement_adjustment_id ,
826: X_book_type_code => P_Book_Type_Code ,
827: X_code_combination_id => l_cost_account_ccid,

Line 848: igi_iac_adjustments_pkg.insert_row(

844: debug( g_state_level,l_path_name,'COST...'|| l_detail_balances_retire.adjustment_cost);
845: IF l_detail_balances_retire.deprn_reserve <> 0 THEN
846:
847: l_rowid := NULL ;
848: igi_iac_adjustments_pkg.insert_row(
849: X_rowid => l_rowid ,
850: X_adjustment_id => l_retirement_adjustment_id ,
851: X_book_type_code => P_Book_Type_Code ,
852: X_code_combination_id => l_acc_deprn_account_ccid,

Line 880: igi_iac_adjustments_pkg.insert_row(

876: RAISE e_no_account_ccid ;
877: END IF ;
878:
879: l_rowid := NULL ;
880: igi_iac_adjustments_pkg.insert_row(
881: X_rowid => l_rowid ,
882: X_adjustment_id => l_retirement_adjustment_id ,
883: X_book_type_code => P_Book_Type_Code ,
884: X_code_combination_id => l_backlog_account_ccid,

Line 907: igi_iac_adjustments_pkg.insert_row(

903:
904: IF l_detail_balances_retire.reval_reserve_backlog <> 0 THEN
905:
906: l_rowid := NULL ;
907: igi_iac_adjustments_pkg.insert_row(
908: X_rowid => l_rowid ,
909: X_adjustment_id => l_retirement_adjustment_id ,
910: X_book_type_code => P_Book_Type_Code ,
911: X_code_combination_id => l_backlog_account_ccid,

Line 936: igi_iac_adjustments_pkg.insert_row(

932:
933: IF l_detail_balances_retire.reval_reserve_net <> 0 THEN
934:
935: l_rowid := NULL ;
936: igi_iac_adjustments_pkg.insert_row(
937: X_rowid => l_rowid ,
938: X_adjustment_id => l_retirement_adjustment_id ,
939: X_book_type_code => P_Book_Type_Code ,
940: X_code_combination_id => l_reval_rsv_account_ccid,

Line 1422: igi_iac_adjustments_pkg.insert_row(

1418:
1419: l_retire_amount := l_all_occ_reval.amount * P_retirement_factor;
1420: l_ret:= igi_iac_common_utils.iac_round(l_retire_amount,P_Book_Type_Code) ;
1421: l_rowid := NULL ;
1422: igi_iac_adjustments_pkg.insert_row(
1423: X_rowid => l_rowid ,
1424: X_adjustment_id => l_retirement_adjustment_id ,
1425: X_book_type_code => P_Book_Type_Code ,
1426: X_code_combination_id => l_all_occ_reval.code_combination_id,

Line 1716: igi_iac_adjustments_pkg.insert_row(

1712:
1713: l_retire_amount := l_all_prd_reval.amount * P_retirement_factor;
1714: l_ret:= igi_iac_common_utils.iac_round(l_retire_amount,P_Book_Type_Code) ;
1715: l_rowid := NULL ;
1716: igi_iac_adjustments_pkg.insert_row(
1717: X_rowid => l_rowid ,
1718: X_adjustment_id => l_retirement_adjustment_id ,
1719: X_book_type_code => P_Book_Type_Code ,
1720: X_code_combination_id => l_all_prd_reval.code_combination_id,

Line 2423: igi_iac_adjustments_pkg.insert_row(

2419: END IF ;
2420: debug( g_state_level,l_path_name,'done nbv ret ccid');
2421: l_rowid := NULL ;
2422:
2423: igi_iac_adjustments_pkg.insert_row(
2424: X_rowid => l_rowid ,
2425: X_adjustment_id => l_retirement_adjustment_id ,
2426: X_book_type_code => P_Book_Type_Code ,
2427: X_code_combination_id => l_nbv_retired_account_ccid,

Line 2446: igi_iac_adjustments_pkg.insert_row(

2442: debug( g_state_level,l_path_name,'done nbv ret insert');
2443:
2444: l_rowid := NULL ;
2445:
2446: igi_iac_adjustments_pkg.insert_row(
2447: X_rowid => l_rowid ,
2448: X_adjustment_id => l_retirement_adjustment_id ,
2449: X_book_type_code => P_Book_Type_Code ,
2450: X_code_combination_id => l_nbv_retired_account_ccid,

Line 2478: igi_iac_adjustments_pkg.insert_row(

2474: RAISE e_no_account_ccid ;
2475: END IF ;
2476: debug( g_state_level,l_path_name,'done reval rsv ret ccid');
2477: l_rowid := NULL ;
2478: igi_iac_adjustments_pkg.insert_row(
2479: X_rowid => l_rowid ,
2480: X_adjustment_id => l_retirement_adjustment_id ,
2481: X_book_type_code => P_Book_Type_Code ,
2482: X_code_combination_id => l_reval_rsv_ret_acct_ccid,

Line 2503: igi_iac_adjustments_pkg.insert_row(

2499:
2500: /* Create adjustment for new balances */
2501: debug( g_state_level,l_path_name,'start new balances');
2502: l_rowid := NULL ;
2503: igi_iac_adjustments_pkg.insert_row(
2504: X_rowid => l_rowid ,
2505: X_adjustment_id => l_retirement_adjustment_id ,
2506: X_book_type_code => P_Book_Type_Code ,
2507: X_code_combination_id => l_cost_account_ccid,

Line 2528: igi_iac_adjustments_pkg.insert_row(

2524: debug( g_state_level,l_path_name,'done new cost');
2525: IF l_detail_balances.deprn_reserve <> 0 THEN
2526:
2527: l_rowid := NULL ;
2528: igi_iac_adjustments_pkg.insert_row(
2529: X_rowid => l_rowid ,
2530: X_adjustment_id => l_retirement_adjustment_id ,
2531: X_book_type_code => P_Book_Type_Code ,
2532: X_code_combination_id => l_acc_deprn_account_ccid,

Line 2559: igi_iac_adjustments_pkg.insert_row(

2555: RAISE e_no_account_ccid ;
2556: END IF ;
2557:
2558: l_rowid := NULL ;
2559: igi_iac_adjustments_pkg.insert_row(
2560: X_rowid => l_rowid ,
2561: X_adjustment_id => l_retirement_adjustment_id ,
2562: X_book_type_code => P_Book_Type_Code ,
2563: X_code_combination_id => l_backlog_account_ccid,

Line 2586: igi_iac_adjustments_pkg.insert_row(

2582:
2583: IF l_detail_balances.reval_reserve_backlog <> 0 THEN
2584:
2585: l_rowid := NULL ;
2586: igi_iac_adjustments_pkg.insert_row(
2587: X_rowid => l_rowid ,
2588: X_adjustment_id => l_retirement_adjustment_id ,
2589: X_book_type_code => P_Book_Type_Code ,
2590: X_code_combination_id => l_backlog_account_ccid,

Line 2613: igi_iac_adjustments_pkg.insert_row(

2609:
2610: IF l_detail_balances.reval_reserve_net<> 0 THEN
2611:
2612: l_rowid := NULL ;
2613: igi_iac_adjustments_pkg.insert_row(
2614: X_rowid => l_rowid ,
2615: X_adjustment_id => l_retirement_adjustment_id ,
2616: X_book_type_code => P_Book_Type_Code ,
2617: X_code_combination_id => l_reval_rsv_account_ccid,

Line 2772: igi_iac_adjustments_pkg.insert_row(

2768:
2769: 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
2770:
2771: l_rowid := NULL ;
2772: igi_iac_adjustments_pkg.insert_row(
2773: X_rowid => l_rowid ,
2774: X_adjustment_id => l_retirement_adjustment_id ,
2775: X_book_type_code => P_Book_Type_Code ,
2776: X_code_combination_id => l_nbv_retired_account_ccid,

Line 2795: igi_iac_adjustments_pkg.insert_row(

2791: debug( g_state_level,l_path_name,'done nbv ret insert');
2792:
2793: l_rowid := NULL ;
2794:
2795: igi_iac_adjustments_pkg.insert_row(
2796: X_rowid => l_rowid ,
2797: X_adjustment_id => l_retirement_adjustment_id ,
2798: X_book_type_code => P_Book_Type_Code ,
2799: X_code_combination_id => l_nbv_retired_account_ccid,

Line 2822: igi_iac_adjustments_pkg.insert_row(

2818: IF l_detail_balances_new.reval_reserve_net <> 0 THEN
2819:
2820: debug( g_state_level,l_path_name,'done reval rsv ret ccid');
2821: l_rowid := NULL ;
2822: igi_iac_adjustments_pkg.insert_row(
2823: X_rowid => l_rowid ,
2824: X_adjustment_id => l_retirement_adjustment_id ,
2825: X_book_type_code => P_Book_Type_Code ,
2826: X_code_combination_id => l_reval_rsv_ret_acct_ccid,

Line 2845: igi_iac_adjustments_pkg.insert_row(

2841: debug( g_state_level,l_path_name,'done reval rsv ret insert');
2842: END IF;
2843:
2844: l_rowid := NULL ;
2845: igi_iac_adjustments_pkg.insert_row(
2846: X_rowid => l_rowid ,
2847: X_adjustment_id => l_retirement_adjustment_id ,
2848: X_book_type_code => P_Book_Type_Code ,
2849: X_code_combination_id => l_cost_account_ccid,

Line 2866: igi_iac_adjustments_pkg.insert_row(

2862: X_event_id => P_Event_Id ) ;
2863:
2864: debug( g_state_level,l_path_name,'done new cost for new dist');
2865: l_rowid := NULL ;
2866: igi_iac_adjustments_pkg.insert_row(
2867: X_rowid => l_rowid ,
2868: X_adjustment_id => l_retirement_adjustment_id ,
2869: X_book_type_code => P_Book_Type_Code ,
2870: X_code_combination_id => l_acc_deprn_account_ccid,

Line 2885: igi_iac_adjustments_pkg.insert_row(

2881: X_report_ccid => NULL,
2882: X_mode => 'R',
2883: X_event_id => P_Event_Id ) ;
2884: l_rowid := NULL ;
2885: igi_iac_adjustments_pkg.insert_row(
2886: X_rowid => l_rowid ,
2887: X_adjustment_id => l_retirement_adjustment_id ,
2888: X_book_type_code => P_Book_Type_Code ,
2889: X_code_combination_id => l_backlog_account_ccid,

Line 2907: igi_iac_adjustments_pkg.insert_row(

2903:
2904:
2905: debug( g_state_level,l_path_name,'done BL reserve for new dist');
2906: l_rowid := NULL ;
2907: igi_iac_adjustments_pkg.insert_row(
2908: X_rowid => l_rowid ,
2909: X_adjustment_id => l_retirement_adjustment_id ,
2910: X_book_type_code => P_Book_Type_Code ,
2911: X_code_combination_id => l_reval_rsv_account_ccid,

Line 3467: igi_iac_adjustments_pkg.insert_row(

3463:
3464: l_retire_amount:=l_all_occ_reval.amount;
3465: --l_ret:= igi_iac_common_utils.iac_round(l_retire_amount,P_Book_Type_Code);
3466: l_rowid := NULL ;
3467: igi_iac_adjustments_pkg.insert_row(
3468: X_rowid => l_rowid ,
3469: X_adjustment_id => l_retirement_adjustment_id ,
3470: X_book_type_code => P_Book_Type_Code ,
3471: X_code_combination_id => l_all_occ_reval.code_combination_id,

Line 3497: igi_iac_adjustments_pkg.insert_row(

3493: l_retire_amount:=l_all_occ_reval.amount * l_retirement_factor ;
3494: l_ret:= igi_iac_common_utils.iac_round(l_retire_amount,P_Book_Type_Code);
3495:
3496: l_rowid := NULL ;
3497: igi_iac_adjustments_pkg.insert_row(
3498: X_rowid => l_rowid ,
3499: X_adjustment_id => l_retirement_adjustment_id ,
3500: X_book_type_code => P_Book_Type_Code ,
3501: X_code_combination_id => l_all_occ_reval.code_combination_id,

Line 3861: igi_iac_adjustments_pkg.insert_row(

3857:
3858: l_retire_amount:=l_all_prd_reval.amount;
3859: --l_ret:= igi_iac_common_utils.iac_round(l_retire_amount,P_Book_Type_Code);
3860: l_rowid := NULL ;
3861: igi_iac_adjustments_pkg.insert_row(
3862: X_rowid => l_rowid ,
3863: X_adjustment_id => l_retirement_adjustment_id ,
3864: X_book_type_code => P_Book_Type_Code ,
3865: X_code_combination_id => l_all_prd_reval.code_combination_id,

Line 3891: igi_iac_adjustments_pkg.insert_row(

3887: l_retire_amount:=l_all_prd_reval.amount * l_retirement_factor ;
3888: l_ret:= igi_iac_common_utils.iac_round(l_retire_amount,P_Book_Type_Code);
3889:
3890: l_rowid := NULL ;
3891: igi_iac_adjustments_pkg.insert_row(
3892: X_rowid => l_rowid ,
3893: X_adjustment_id => l_retirement_adjustment_id ,
3894: X_book_type_code => P_Book_Type_Code ,
3895: X_code_combination_id => l_all_prd_reval.code_combination_id,