DBA Data[Home] [Help]

APPS.FA_TRANSFER_XIT_PKG dependencies on FA_ADJUST_TYPE_PKG

Line 67: h_adj fa_adjust_type_pkg.fa_adj_row_struct;

63: h_msg_name VARCHAR2(30) := NULL;
64: h_cur_per_ctr NUMBER;
65: h_period_ctr NUMBER;
66:
67: h_adj fa_adjust_type_pkg.fa_adj_row_struct;
68: h_dpr fa_std_types.fa_deprn_row_struct;
69:
70: h_proceed BOOLEAN;
71: ERROR_FOUND EXCEPTION;

Line 409: FUNCTION fadotfr(X_adj_ptr IN OUT NOCOPY fa_adjust_type_pkg.fa_adj_row_struct,

405: --
406: -- FUNCTION fadotfr
407: --
408:
409: FUNCTION fadotfr(X_adj_ptr IN OUT NOCOPY fa_adjust_type_pkg.fa_adj_row_struct,
410: X_acctcode IN NUMBER,
411: X_old_cat_id IN NUMBER,
412: X_new_cat_id IN NUMBER,
413: X_asset_type IN VARCHAR2,

Line 438: X_select_mode => fa_adjust_type_pkg.FA_AJ_CLEAR,

434:
435: -- clear out the account for all distributions
436: if (NOT setacct(X_adj_ptr => X_adj_ptr,
437: X_acctcode => X_acctcode,
438: X_select_mode => fa_adjust_type_pkg.FA_AJ_CLEAR,
439: X_cat_id => X_old_cat_id,
440: X_asset_type => X_asset_type
441: ,p_log_level_rec => p_log_level_rec)) then
442: raise ERROR_FOUND;

Line 446: X_adj_ptr.selection_mode := fa_adjust_type_pkg.FA_AJ_CLEAR;

442: raise ERROR_FOUND;
443: end if;
444:
445: X_adj_ptr.selection_retid := X_old_cat_id;
446: X_adj_ptr.selection_mode := fa_adjust_type_pkg.FA_AJ_CLEAR;
447: X_adj_ptr.mrc_sob_type_code := X_mrc_sob_type_code;
448: X_adj_ptr.source_dest_code := 'SOURCE';
449:
450: if (NOT fa_ins_adjust_pkg.faxinaj(X_adj_ptr,

Line 483: X_select_mode => fa_adjust_type_pkg.FA_AJ_ACTIVE,

479:
480: -- transfer cleared amount to new account
481: if (NOT setacct(X_adj_ptr => X_adj_ptr,
482: X_acctcode => X_acctcode,
483: X_select_mode => fa_adjust_type_pkg.FA_AJ_ACTIVE,
484: X_cat_id => X_new_cat_id,
485: X_asset_type => X_asset_type
486: ,p_log_level_rec => p_log_level_rec)) then
487: raise ERROR_FOUND;

Line 491: X_adj_ptr.selection_mode := fa_adjust_type_pkg.FA_AJ_ACTIVE;

487: raise ERROR_FOUND;
488: end if;
489:
490: X_adj_ptr.selection_retid := X_new_cat_id;
491: X_adj_ptr.selection_mode := fa_adjust_type_pkg.FA_AJ_ACTIVE;
492: X_adj_ptr.mrc_sob_type_code := X_mrc_sob_type_code;
493: X_adj_ptr.source_dest_code := 'DEST';
494:
495: if (NOT fa_ins_adjust_pkg.faxinaj(X_adj_ptr,

Line 555: FUNCTION setacct(X_adj_ptr IN OUT NOCOPY fa_adjust_type_pkg.fa_adj_row_struct,

551: --
552: -- FUNCTION setacct
553: --
554:
555: FUNCTION setacct(X_adj_ptr IN OUT NOCOPY fa_adjust_type_pkg.fa_adj_row_struct,
556: X_acctcode IN NUMBER,
557: X_select_mode IN NUMBER,
558: X_cat_id IN NUMBER,
559: X_asset_type IN VARCHAR2

Line 613: if (X_select_mode = fa_adjust_type_pkg.FA_AJ_CLEAR) then

609: and category_id = h_category_id;
610:
611: end if;
612:
613: if (X_select_mode = fa_adjust_type_pkg.FA_AJ_CLEAR) then
614: X_adj_ptr.debit_credit_flag := 'CR';
615: else
616: X_adj_ptr.debit_credit_flag := 'DR';
617: end if;

Line 631: if (X_select_mode = fa_adjust_type_pkg.FA_AJ_CLEAR) then

627: from fa_category_books
628: where book_type_code = h_book
629: and category_id = h_category_id;
630:
631: if (X_select_mode = fa_adjust_type_pkg.FA_AJ_CLEAR) then
632: X_adj_ptr.debit_credit_flag := 'DR';
633: else
634: X_adj_ptr.debit_credit_flag := 'CR';
635: end if;

Line 650: if (X_select_mode = fa_adjust_type_pkg.FA_AJ_CLEAR) then

646: from fa_category_books
647: where book_type_code = h_book
648: and category_id = h_category_id;
649:
650: if (X_select_mode = fa_adjust_type_pkg.FA_AJ_CLEAR) then
651: X_adj_ptr.debit_credit_flag := 'DR';
652: else
653: X_adj_ptr.debit_credit_flag := 'CR';
654: end if;

Line 668: if (X_select_mode = fa_adjust_type_pkg.FA_AJ_CLEAR) then

664: from fa_category_books
665: where book_type_code = h_book
666: and category_id = h_category_id;
667:
668: if (X_select_mode = fa_adjust_type_pkg.FA_AJ_CLEAR) then
669: X_adj_ptr.debit_credit_flag := 'DR';
670: else
671: X_adj_ptr.debit_credit_flag := 'CR';
672: end if;

Line 685: if (X_select_mode = fa_adjust_type_pkg.FA_AJ_CLEAR) then

681: into X_adj_ptr.account
682: from fa_book_controls
683: where book_type_code = h_book;
684:
685: if (X_select_mode = fa_adjust_type_pkg.FA_AJ_CLEAR) then
686: X_adj_ptr.debit_credit_flag := 'DR';
687: else
688: X_adj_ptr.debit_credit_flag := 'CR';
689: end if;

Line 702: if (X_select_mode = fa_adjust_type_pkg.FA_AJ_CLEAR) then

698: into X_adj_ptr.account
699: from fa_book_controls
700: where book_type_code = h_book;
701:
702: if (X_select_mode = fa_adjust_type_pkg.FA_AJ_CLEAR) then
703: X_adj_ptr.debit_credit_flag := 'CR';
704: else
705: X_adj_ptr.debit_credit_flag := 'DR';
706: end if;

Line 710: if (X_select_mode = fa_adjust_type_pkg.FA_AJ_CLEAR) then

706: end if;
707:
708: end if;
709:
710: if (X_select_mode = fa_adjust_type_pkg.FA_AJ_CLEAR) then
711: X_adj_ptr.source_dest_code := 'SOURCE';
712: else
713: X_adj_ptr.source_dest_code := 'DEST';
714: end if;

Line 731: FUNCTION fatsgl(X_adj IN OUT NOCOPY fa_adjust_type_pkg.fa_adj_row_struct,

727: --
728: -- FUNCTION fatsgl
729: --
730:
731: FUNCTION fatsgl(X_adj IN OUT NOCOPY fa_adjust_type_pkg.fa_adj_row_struct,
732: X_cat_id IN NUMBER,
733: X_asset_type IN VARCHAR2,
734: X_last_update_date IN DATE default sysdate,
735: X_last_updated_by IN NUMBER default -1,

Line 820: X_adj.selection_mode := fa_adjust_type_pkg.FA_AJ_TRANSFER_SINGLE;

816:
817: -- call the insert into fa_adjusments funtion in SINGLE mode to insert the
818: -- individual fa_adjustments rows. other values already set in fautfr.
819:
820: X_adj.selection_mode := fa_adjust_type_pkg.FA_AJ_TRANSFER_SINGLE;
821: X_adj.gen_ccid_flag := TRUE;
822:
823: -- will process terminated rows first.
824: if (h_term_dist_flag = 1) then

Line 870: X_select_mode => fa_adjust_type_pkg.FA_AJ_CLEAR,

866: -- clear cost
867:
868: if (NOT setacct(X_adj_ptr => X_adj,
869: X_acctcode => FA_TFR_COST,
870: X_select_mode => fa_adjust_type_pkg.FA_AJ_CLEAR,
871: X_cat_id => X_cat_id,
872: X_asset_type => X_asset_type
873: ,p_log_level_rec => p_log_level_rec)) then
874: raise ERROR_FOUND;

Line 913: X_select_mode => fa_adjust_type_pkg.FA_AJ_CLEAR,

909: -- clear deprn_reserve
910:
911: if (NOT setacct(X_adj_ptr => X_adj,
912: X_acctcode => FA_TFR_DEPRN_RSV,
913: X_select_mode => fa_adjust_type_pkg.FA_AJ_CLEAR,
914: X_cat_id => X_cat_id,
915: X_asset_type => X_asset_type
916: ,p_log_level_rec => p_log_level_rec)) then
917: raise ERROR_FOUND;

Line 953: X_select_mode => fa_adjust_type_pkg.FA_AJ_CLEAR,

949: -- bonus: move the bonus deprn reserve if bonus reserve exist
950: if nvl(h_dpr.bonus_deprn_rsv,0) <> 0 then
951: if (NOT setacct(X_adj_ptr => X_adj,
952: X_acctcode => FA_TFR_BONUS_DEPRN_RSV,
953: X_select_mode => fa_adjust_type_pkg.FA_AJ_CLEAR,
954: X_cat_id => X_cat_id,
955: X_asset_type => X_asset_type
956: ,p_log_level_rec => p_log_level_rec)) then
957: raise ERROR_FOUND;

Line 998: X_select_mode => fa_adjust_type_pkg.FA_AJ_CLEAR,

994: X_adj.mrc_sob_type_code := X_mrc_sob_type_code;
995:
996: if (NOT setacct(X_adj_ptr => X_adj,
997: X_acctcode => FA_TFR_REVAL_RSV,
998: X_select_mode => fa_adjust_type_pkg.FA_AJ_CLEAR,
999: X_cat_id => X_cat_id,
1000: X_asset_type => X_asset_type
1001: ,p_log_level_rec => p_log_level_rec)) then
1002: raise ERROR_FOUND;

Line 1045: X_select_mode => fa_adjust_type_pkg.FA_AJ_ACTIVE,

1041:
1042: -- transfer cost
1043: if (NOT setacct(X_adj_ptr => X_adj,
1044: X_acctcode => FA_TFR_COST,
1045: X_select_mode => fa_adjust_type_pkg.FA_AJ_ACTIVE,
1046: X_cat_id => X_cat_id,
1047: X_asset_type => X_asset_type
1048: ,p_log_level_rec => p_log_level_rec)) then
1049: raise ERROR_FOUND;

Line 1095: X_select_mode => fa_adjust_type_pkg.FA_AJ_ACTIVE,

1091: -- transfer deprn reserve
1092:
1093: if (NOT setacct(X_adj_ptr => X_adj,
1094: X_acctcode => FA_TFR_DEPRN_RSV,
1095: X_select_mode => fa_adjust_type_pkg.FA_AJ_ACTIVE,
1096: X_cat_id => X_cat_id,
1097: X_asset_type => X_asset_type
1098: ,p_log_level_rec => p_log_level_rec)) then
1099: raise ERROR_FOUND;

Line 1149: X_select_mode => fa_adjust_type_pkg.FA_AJ_ACTIVE,

1145:
1146: if nvl(h_dpr.bonus_deprn_rsv,0) <> 0 then
1147: if (NOT setacct(X_adj_ptr => X_adj,
1148: X_acctcode => FA_TFR_BONUS_DEPRN_RSV,
1149: X_select_mode => fa_adjust_type_pkg.FA_AJ_ACTIVE,
1150: X_cat_id => X_cat_id,
1151: X_asset_type => X_asset_type
1152: ,p_log_level_rec => p_log_level_rec)) then
1153: raise ERROR_FOUND;

Line 1200: X_select_mode => fa_adjust_type_pkg.FA_AJ_ACTIVE,

1196: if (nvl(h_total_rev_to_prorate,0) <> 0) then
1197:
1198: if (NOT setacct(X_adj_ptr => X_adj,
1199: X_acctcode => FA_TFR_REVAL_RSV,
1200: X_select_mode => fa_adjust_type_pkg.FA_AJ_ACTIVE,
1201: X_cat_id => X_cat_id,
1202: X_asset_type => X_asset_type
1203: ,p_log_level_rec => p_log_level_rec)) then
1204: raise ERROR_FOUND;

Line 1254: X_select_mode => fa_adjust_type_pkg.FA_AJ_ACTIVE,

1250: X_adj.track_member_flag := null;
1251:
1252: if (NOT setacct(X_adj_ptr => X_adj,
1253: X_acctcode => FA_TFR_COST,
1254: X_select_mode => fa_adjust_type_pkg.FA_AJ_ACTIVE,
1255: X_cat_id => X_cat_id,
1256: X_asset_type => X_asset_type
1257: ,p_log_level_rec => p_log_level_rec)) then
1258: raise ERROR_FOUND;

Line 1295: X_select_mode => fa_adjust_type_pkg.FA_AJ_ACTIVE,

1291:
1292: -- move deprn reserve
1293: if (NOT setacct(X_adj_ptr => X_adj,
1294: X_acctcode => FA_TFR_DEPRN_RSV,
1295: X_select_mode => fa_adjust_type_pkg.FA_AJ_ACTIVE,
1296: X_cat_id => X_cat_id,
1297: X_asset_type => X_asset_type
1298: ,p_log_level_rec => p_log_level_rec)) then
1299: raise ERROR_FOUND;

Line 1335: X_select_mode => fa_adjust_type_pkg.FA_AJ_ACTIVE,

1331: -- bonus: move the bonus deprn reserve if bonus reserve exist
1332: if nvl(h_dpr.bonus_deprn_rsv,0) <> 0 then
1333: if (NOT setacct(X_adj_ptr => X_adj,
1334: X_acctcode => FA_TFR_BONUS_DEPRN_RSV,
1335: X_select_mode => fa_adjust_type_pkg.FA_AJ_ACTIVE,
1336: X_cat_id => X_cat_id,
1337: X_asset_type => X_asset_type
1338: ,p_log_level_rec => p_log_level_rec)) then
1339: raise ERROR_FOUND;

Line 1377: X_select_mode => fa_adjust_type_pkg.FA_AJ_ACTIVE,

1373: X_adj.flush_adj_flag := TRUE; -- flush to db
1374:
1375: if (NOT setacct(X_adj_ptr => X_adj,
1376: X_acctcode => FA_TFR_REVAL_RSV,
1377: X_select_mode => fa_adjust_type_pkg.FA_AJ_ACTIVE,
1378: X_cat_id => X_cat_id,
1379: X_asset_type => X_asset_type
1380: ,p_log_level_rec => p_log_level_rec)) then
1381: raise ERROR_FOUND;