eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FA_METHODS_PKG dependencies on FA_METHODS

Line 1: PACKAGE BODY FA_METHODS_PKG as

1: PACKAGE BODY FA_METHODS_PKG as
2: /* $Header: faximtb.pls 120.8.12010000.1 2008/07/28 13:25:54 appldev ship $ */
3:
4: PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
5: X_Method_Id IN OUT NOCOPY NUMBER,

Line 44: CURSOR C IS SELECT rowid FROM fa_methods

40: X_Calling_Fn VARCHAR2,
41: -- For Depreciable Basis Formula
42: X_Deprn_Basis_Rule_Id NUMBER DEFAULT NULL,
43: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
44: CURSOR C IS SELECT rowid FROM fa_methods
45: WHERE method_id = X_Method_Id;
46: CURSOR C2 IS SELECT fa_methods_s.nextval FROM dual;
47:
48: BEGIN

Line 46: CURSOR C2 IS SELECT fa_methods_s.nextval FROM dual;

42: X_Deprn_Basis_Rule_Id NUMBER DEFAULT NULL,
43: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
44: CURSOR C IS SELECT rowid FROM fa_methods
45: WHERE method_id = X_Method_Id;
46: CURSOR C2 IS SELECT fa_methods_s.nextval FROM dual;
47:
48: BEGIN
49:
50: if (X_Method_Id is NULL) then

Line 56: INSERT INTO fa_methods(

52: FETCH C2 INTO X_Method_Id;
53: CLOSE C2;
54: end if;
55:
56: INSERT INTO fa_methods(
57: method_id,
58: method_code,
59: life_in_months,
60: depreciate_lastyear_flag,

Line 146: UPDATE fa_methods

142: (nvl(X_Deprn_Basis_Formula, 'STRICT_FLAT') = 'STRICT_FLAT') and
143: (X_Deprn_Basis_Rule_Id is null)) then
144:
145: -- For Depreciable Basis Formula logic
146: UPDATE fa_methods
147: SET deprn_basis_rule_id =
148: (SELECT deprn_basis_rule_id
149: FROM fa_deprn_basis_rules
150: WHERE RULE_NAME='TRANSACTION')

Line 157: UPDATE fa_methods

153: AND deprn_basis_formula IS NULL
154: AND deprn_basis_rule_id IS NULL
155: AND method_id = X_Method_Id;
156:
157: UPDATE fa_methods
158: SET deprn_basis_rule_id =
159: (SELECT deprn_basis_rule_id
160: FROM fa_deprn_basis_rules
161: WHERE RULE_NAME='FYBEGIN')

Line 174: calling_fn => 'fa_methods_pkg.insert_row'

170: exception
171: when others then
172:
173: fa_srvr_msg.add_sql_error(
174: calling_fn => 'fa_methods_pkg.insert_row'
175: ,p_log_level_rec => p_log_level_rec);
176:
177: FA_STANDARD_PKG.RAISE_ERROR(
178: CALLED_FN => 'fa_methods_pkg.insert_row',

Line 178: CALLED_FN => 'fa_methods_pkg.insert_row',

174: calling_fn => 'fa_methods_pkg.insert_row'
175: ,p_log_level_rec => p_log_level_rec);
176:
177: FA_STANDARD_PKG.RAISE_ERROR(
178: CALLED_FN => 'fa_methods_pkg.insert_row',
179: CALLING_FN => X_Calling_Fn
180: ,p_log_level_rec => p_log_level_rec);
181:
182: END Insert_Row;

Line 256: FROM fa_methods

252: exclude_salvage_value_flag,
253: deprn_basis_rule_id,
254: polish_adj_calc_basis_flag,
255: guarantee_rate_method_flag
256: FROM fa_methods
257: WHERE method_code = X_Method_Code
258: AND ((life_in_months = X_Life_In_Months) or
259: ((life_in_months is null) and (X_Life_In_Months is null)))
260: FOR UPDATE of Method_Id NOWAIT;

Line 399: UPDATE fa_methods

395:
396: -- Split into separate statements for performance reasons.
397: if (X_Life_In_Months is not null) then
398:
399: UPDATE fa_methods
400: SET
401: depreciate_lastyear_flag = X_Depreciate_Lastyear_Flag,
402: stl_method_flag = X_Stl_Method_Flag,
403: rate_source_rule = X_Rate_Source_Rule,

Line 446: UPDATE fa_methods

442: (nvl(X_Deprn_Basis_Formula, 'STRICT_FLAT') = 'STRICT_FLAT') and
443: (X_Deprn_Basis_Rule_Id is null)) then
444:
445: -- For Depreciable Basis Formula logic
446: UPDATE fa_methods
447: SET deprn_basis_rule_id =
448: (SELECT deprn_basis_rule_id
449: FROM fa_deprn_basis_rules
450: WHERE RULE_NAME='TRANSACTION')

Line 458: UPDATE fa_methods

454: AND deprn_basis_rule_id IS NULL
455: AND method_code = X_Method_Code
456: AND life_in_months = X_Life_In_Months;
457:
458: UPDATE fa_methods
459: SET deprn_basis_rule_id =
460: (SELECT deprn_basis_rule_id
461: FROM fa_deprn_basis_rules
462: WHERE RULE_NAME='FYBEGIN')

Line 473: UPDATE fa_methods

469:
470: end if;
471: else
472:
473: UPDATE fa_methods
474: SET
475: depreciate_lastyear_flag = X_Depreciate_Lastyear_Flag,
476: stl_method_flag = X_Stl_Method_Flag,
477: rate_source_rule = X_Rate_Source_Rule,

Line 520: UPDATE fa_methods

516: (nvl(X_Deprn_Basis_Formula, 'STRICT_FLAT') = 'STRICT_FLAT') and
517: (X_Deprn_Basis_Rule_Id is null)) then
518:
519: -- For Depreciable Basis Formula logic
520: UPDATE fa_methods
521: SET deprn_basis_rule_id =
522: (SELECT deprn_basis_rule_id
523: FROM fa_deprn_basis_rules
524: WHERE RULE_NAME='TRANSACTION')

Line 532: UPDATE fa_methods

528: AND deprn_basis_rule_id IS NULL
529: AND method_code = X_Method_Code
530: AND life_in_months is null;
531:
532: UPDATE fa_methods
533: SET deprn_basis_rule_id =
534: (SELECT deprn_basis_rule_id
535: FROM fa_deprn_basis_rules
536: WHERE RULE_NAME='FYBEGIN')

Line 551: calling_fn => 'fa_methods_pkg.update_row'

547: exception
548: when others then
549:
550: fa_srvr_msg.add_sql_error(
551: calling_fn => 'fa_methods_pkg.update_row'
552: ,p_log_level_rec => p_log_level_rec);
553:
554: FA_STANDARD_PKG.RAISE_ERROR(
555: CALLED_FN => 'fa_methods_pkg.update_row',

Line 555: CALLED_FN => 'fa_methods_pkg.update_row',

551: calling_fn => 'fa_methods_pkg.update_row'
552: ,p_log_level_rec => p_log_level_rec);
553:
554: FA_STANDARD_PKG.RAISE_ERROR(
555: CALLED_FN => 'fa_methods_pkg.update_row',
556: CALLING_FN => X_Calling_Fn
557: ,p_log_level_rec => p_log_level_rec);
558:
559: END Update_Row;

Line 565: DELETE FROM fa_methods

561: PROCEDURE Delete_Row(X_Rowid VARCHAR2,
562: X_Calling_Fn VARCHAR2,
563: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
564: BEGIN
565: DELETE FROM fa_methods
566: WHERE rowid = X_Rowid;
567:
568: if (SQL%NOTFOUND) then
569: Raise NO_DATA_FOUND;

Line 575: calling_fn => 'fa_methods_pkg.delete_row'

571: exception
572: when others then
573:
574: fa_srvr_msg.add_sql_error(
575: calling_fn => 'fa_methods_pkg.delete_row'
576: ,p_log_level_rec => p_log_level_rec);
577:
578: FA_STANDARD_PKG.RAISE_ERROR(
579: CALLED_FN => 'fa_methods_pkg.delete_row',

Line 579: CALLED_FN => 'fa_methods_pkg.delete_row',

575: calling_fn => 'fa_methods_pkg.delete_row'
576: ,p_log_level_rec => p_log_level_rec);
577:
578: FA_STANDARD_PKG.RAISE_ERROR(
579: CALLED_FN => 'fa_methods_pkg.delete_row',
580: CALLING_FN => X_Calling_Fn
581: ,p_log_level_rec => p_log_level_rec);
582:
583: end DELETE_ROW;

Line 641: fa_methods_pkg.update_row (

637: if (fnd_load_util.upload_test(user_id, x_last_update_date,
638: X_db_last_updated_by, X_db_last_update_date,
639: X_CUSTOM_MODE)) then
640:
641: fa_methods_pkg.update_row (
642: X_Rowid => row_id,
643: X_Method_ID => h_method_id,
644: X_Method_Code => X_Method_Code,
645: X_Life_In_Months => X_Life_In_Months,

Line 675: X_Calling_Fn => 'fa_methods_pkg.load_row',

671: X_Exclude_Salvage_Value_Flag => X_Exclude_Salvage_Value_Flag,
672: X_Deprn_Basis_Formula => X_Deprn_Basis_Formula,
673: X_Polish_Adj_Calc_Basis_Flag => X_Polish_Adj_Calc_Basis_Flag,
674: X_Guarantee_Rate_Method_Flag => X_Guarantee_Rate_Method_Flag,
675: X_Calling_Fn => 'fa_methods_pkg.load_row',
676: X_Deprn_Basis_Rule_Id => X_Deprn_Basis_Rule_Id
677: ,p_log_level_rec => p_log_level_rec);
678: end if;
679: else

Line 683: fa_methods_pkg.insert_row (

679: else
680:
681: h_method_id := null;
682:
683: fa_methods_pkg.insert_row (
684: X_Rowid => row_id,
685: X_Method_ID => h_method_id,
686: X_Method_Code => X_Method_Code,
687: X_Life_In_Months => X_Life_In_Months,

Line 719: X_Calling_Fn => 'fa_methods_pkg.load_row',

715: X_Exclude_Salvage_Value_Flag => X_Exclude_Salvage_Value_Flag,
716: X_Deprn_Basis_Formula => X_Deprn_Basis_Formula,
717: X_Polish_Adj_Calc_Basis_Flag => X_Polish_Adj_Calc_Basis_Flag,
718: X_Guarantee_Rate_Method_Flag => X_Guarantee_Rate_Method_Flag,
719: X_Calling_Fn => 'fa_methods_pkg.load_row',
720: X_Deprn_Basis_Rule_Id => X_Deprn_Basis_Rule_Id
721: ,p_log_level_rec => p_log_level_rec);
722: end if;
723:

Line 728: calling_fn => 'fa_methods_pkg.load_row'

724: exception
725: when others then
726:
727: fa_srvr_msg.add_sql_error(
728: calling_fn => 'fa_methods_pkg.load_row'
729: ,p_log_level_rec => p_log_level_rec);
730:
731: FA_STANDARD_PKG.RAISE_ERROR(
732: CALLED_FN => 'fa_methods_pkg.load_row',

Line 732: CALLED_FN => 'fa_methods_pkg.load_row',

728: calling_fn => 'fa_methods_pkg.load_row'
729: ,p_log_level_rec => p_log_level_rec);
730:
731: FA_STANDARD_PKG.RAISE_ERROR(
732: CALLED_FN => 'fa_methods_pkg.load_row',
733: CALLING_FN => 'upload fa_methods:' || SQLERRM
734: ,p_log_level_rec => p_log_level_rec);
735:
736: end LOAD_ROW;

Line 733: CALLING_FN => 'upload fa_methods:' || SQLERRM

729: ,p_log_level_rec => p_log_level_rec);
730:
731: FA_STANDARD_PKG.RAISE_ERROR(
732: CALLED_FN => 'fa_methods_pkg.load_row',
733: CALLING_FN => 'upload fa_methods:' || SQLERRM
734: ,p_log_level_rec => p_log_level_rec);
735:
736: end LOAD_ROW;
737:

Line 771: update FA_METHODS

767: * */
768:
769: if (X_Life_In_Months is not null) then
770:
771: update FA_METHODS
772: set NAME = nvl(X_Name, Name),
773: LAST_UPDATE_DATE = sysdate,
774: LAST_UPDATED_BY = user_id
775: --where METHOD_ID = X_Method_ID

Line 784: update FA_METHODS set

780: from FND_LANGUAGES
781: where installed_flag = 'B');
782: else
783:
784: update FA_METHODS set
785: NAME = nvl(X_Name, Name),
786: LAST_UPDATE_DATE = sysdate,
787: LAST_UPDATED_BY = user_id,
788: LAST_UPDATE_LOGIN = 0

Line 804: calling_fn => 'fa_methods_pkg.translate_row'

800: exception
801: when others then
802:
803: fa_srvr_msg.add_sql_error(
804: calling_fn => 'fa_methods_pkg.translate_row'
805: ,p_log_level_rec => p_log_level_rec);
806:
807: FA_STANDARD_PKG.RAISE_ERROR(
808: CALLED_FN => 'fa_methods_pkg.translate_row',

Line 808: CALLED_FN => 'fa_methods_pkg.translate_row',

804: calling_fn => 'fa_methods_pkg.translate_row'
805: ,p_log_level_rec => p_log_level_rec);
806:
807: FA_STANDARD_PKG.RAISE_ERROR(
808: CALLED_FN => 'fa_methods_pkg.translate_row',
809: CALLING_FN => 'upload fa_methods'
810: ,p_log_level_rec => p_log_level_rec);
811:
812: end TRANSLATE_ROW;

Line 809: CALLING_FN => 'upload fa_methods'

805: ,p_log_level_rec => p_log_level_rec);
806:
807: FA_STANDARD_PKG.RAISE_ERROR(
808: CALLED_FN => 'fa_methods_pkg.translate_row',
809: CALLING_FN => 'upload fa_methods'
810: ,p_log_level_rec => p_log_level_rec);
811:
812: end TRANSLATE_ROW;
813:

Line 871: fa_methods_pkg.TRANSLATE_ROW (

867:
868: end if;
869:
870: if (x_upload_mode = 'NLS') then
871: fa_methods_pkg.TRANSLATE_ROW (
872: x_custom_mode => x_custom_mode,
873: x_method_id => h_method_id,
874: x_method_code => x_method_code,
875: x_life_in_months => x_life_in_months,

Line 882: fa_methods_pkg.LOAD_ROW (

878: x_owner => x_owner,
879: x_last_update_date => x_last_update_date,
880: x_name => x_name);
881: else
882: fa_methods_pkg.LOAD_ROW (
883: x_custom_mode => x_custom_mode,
884: x_method_id => h_method_id,
885: x_db_last_update_date => h_last_update_date,
886: x_db_last_updated_by => h_last_updated_by,

Line 923: END FA_METHODS_PKG;

919: end if;
920:
921: END LOAD_SEED_ROW;
922:
923: END FA_METHODS_PKG;