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.

[Home] [Help]

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.13 2011/03/11 02:40:24 saalampa ship $ */
3:
4: PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
5: X_Method_Id IN OUT NOCOPY NUMBER,

Line 45: CURSOR C IS SELECT rowid FROM fa_methods

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

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

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

Line 56: ad_zd_seed.prepare('fa_methods');

52: OPEN C2;
53: FETCH C2 INTO X_Method_Id;
54: CLOSE C2;
55: end if;
56: ad_zd_seed.prepare('fa_methods');
57: INSERT INTO fa_methods(
58: method_id,
59: method_code,
60: life_in_months,

Line 57: INSERT INTO fa_methods(

53: FETCH C2 INTO X_Method_Id;
54: CLOSE C2;
55: end if;
56: ad_zd_seed.prepare('fa_methods');
57: INSERT INTO fa_methods(
58: method_id,
59: method_code,
60: life_in_months,
61: depreciate_lastyear_flag,

Line 149: UPDATE fa_methods

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

Line 160: UPDATE fa_methods

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

Line 177: calling_fn => 'fa_methods_pkg.insert_row', p_log_level_rec => p_log_level_rec);

173: exception
174: when others then
175:
176: fa_srvr_msg.add_sql_error(
177: calling_fn => 'fa_methods_pkg.insert_row', p_log_level_rec => p_log_level_rec);
178:
179: FA_STANDARD_PKG.RAISE_ERROR(
180: CALLED_FN => 'fa_methods_pkg.insert_row',
181: CALLING_FN => X_Calling_Fn, p_log_level_rec => p_log_level_rec);

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

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

Line 259: FROM fa_methods

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

Line 400: ad_zd_seed.prepare('fa_methods');

396: x_jp_imp_calc_basis_flag VARCHAR2 DEFAULT NULL
397: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
398:
399: BEGIN
400: ad_zd_seed.prepare('fa_methods');
401: -- Split into separate statements for performance reasons.
402: if (X_Life_In_Months is not null) then
403:
404: UPDATE fa_methods

Line 404: UPDATE fa_methods

400: ad_zd_seed.prepare('fa_methods');
401: -- Split into separate statements for performance reasons.
402: if (X_Life_In_Months is not null) then
403:
404: UPDATE fa_methods
405: SET
406: depreciate_lastyear_flag = X_Depreciate_Lastyear_Flag,
407: stl_method_flag = X_Stl_Method_Flag,
408: rate_source_rule = X_Rate_Source_Rule,

Line 452: UPDATE fa_methods

448: (nvl(X_Deprn_Basis_Formula, 'STRICT_FLAT') = 'STRICT_FLAT') and
449: (X_Deprn_Basis_Rule_Id is null)) then
450:
451: -- For Depreciable Basis Formula logic
452: UPDATE fa_methods
453: SET deprn_basis_rule_id =
454: (SELECT deprn_basis_rule_id
455: FROM fa_deprn_basis_rules
456: WHERE RULE_NAME='TRANSACTION')

Line 464: UPDATE fa_methods

460: AND deprn_basis_rule_id IS NULL
461: AND method_code = X_Method_Code
462: AND life_in_months = X_Life_In_Months;
463:
464: UPDATE fa_methods
465: SET deprn_basis_rule_id =
466: (SELECT deprn_basis_rule_id
467: FROM fa_deprn_basis_rules
468: WHERE RULE_NAME='FYBEGIN')

Line 479: UPDATE fa_methods

475:
476: end if;
477: else
478:
479: UPDATE fa_methods
480: SET
481: depreciate_lastyear_flag = X_Depreciate_Lastyear_Flag,
482: stl_method_flag = X_Stl_Method_Flag,
483: rate_source_rule = X_Rate_Source_Rule,

Line 527: UPDATE fa_methods

523: (nvl(X_Deprn_Basis_Formula, 'STRICT_FLAT') = 'STRICT_FLAT') and
524: (X_Deprn_Basis_Rule_Id is null)) then
525:
526: -- For Depreciable Basis Formula logic
527: UPDATE fa_methods
528: SET deprn_basis_rule_id =
529: (SELECT deprn_basis_rule_id
530: FROM fa_deprn_basis_rules
531: WHERE RULE_NAME='TRANSACTION')

Line 539: UPDATE fa_methods

535: AND deprn_basis_rule_id IS NULL
536: AND method_code = X_Method_Code
537: AND life_in_months is null;
538:
539: UPDATE fa_methods
540: SET deprn_basis_rule_id =
541: (SELECT deprn_basis_rule_id
542: FROM fa_deprn_basis_rules
543: WHERE RULE_NAME='FYBEGIN')

Line 558: calling_fn => 'fa_methods_pkg.update_row', p_log_level_rec => p_log_level_rec);

554: exception
555: when others then
556:
557: fa_srvr_msg.add_sql_error(
558: calling_fn => 'fa_methods_pkg.update_row', p_log_level_rec => p_log_level_rec);
559:
560: FA_STANDARD_PKG.RAISE_ERROR(
561: CALLED_FN => 'fa_methods_pkg.update_row',
562: CALLING_FN => X_Calling_Fn, p_log_level_rec => p_log_level_rec);

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

557: fa_srvr_msg.add_sql_error(
558: calling_fn => 'fa_methods_pkg.update_row', p_log_level_rec => p_log_level_rec);
559:
560: FA_STANDARD_PKG.RAISE_ERROR(
561: CALLED_FN => 'fa_methods_pkg.update_row',
562: CALLING_FN => X_Calling_Fn, p_log_level_rec => p_log_level_rec);
563:
564: END Update_Row;
565:

Line 569: ad_zd_seed.prepare('fa_methods');

565:
566: PROCEDURE Delete_Row(X_Rowid VARCHAR2,
567: X_Calling_Fn VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
568: BEGIN
569: ad_zd_seed.prepare('fa_methods');
570: DELETE FROM fa_methods
571: WHERE rowid = X_Rowid;
572:
573: if (SQL%NOTFOUND) then

Line 570: DELETE FROM fa_methods

566: PROCEDURE Delete_Row(X_Rowid VARCHAR2,
567: X_Calling_Fn VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
568: BEGIN
569: ad_zd_seed.prepare('fa_methods');
570: DELETE FROM fa_methods
571: WHERE rowid = X_Rowid;
572:
573: if (SQL%NOTFOUND) then
574: Raise NO_DATA_FOUND;

Line 580: calling_fn => 'fa_methods_pkg.delete_row', p_log_level_rec => p_log_level_rec);

576: exception
577: when others then
578:
579: fa_srvr_msg.add_sql_error(
580: calling_fn => 'fa_methods_pkg.delete_row', p_log_level_rec => p_log_level_rec);
581:
582: FA_STANDARD_PKG.RAISE_ERROR(
583: CALLED_FN => 'fa_methods_pkg.delete_row',
584: CALLING_FN => X_Calling_Fn, p_log_level_rec => p_log_level_rec);

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

579: fa_srvr_msg.add_sql_error(
580: calling_fn => 'fa_methods_pkg.delete_row', p_log_level_rec => p_log_level_rec);
581:
582: FA_STANDARD_PKG.RAISE_ERROR(
583: CALLED_FN => 'fa_methods_pkg.delete_row',
584: CALLING_FN => X_Calling_Fn, p_log_level_rec => p_log_level_rec);
585:
586: end DELETE_ROW;
587:

Line 645: from fa_methods

641: if (X_Life_In_Months is not null) then
642:
643: select count(*)
644: into h_record_exists
645: from fa_methods
646: where method_code = X_Method_Code
647: and life_in_months = X_Life_In_Months;
648:
649: else

Line 653: from fa_methods

649: else
650:
651: select count(*)
652: into h_record_exists
653: from fa_methods
654: where method_code = X_Method_Code
655: and life_in_months is null;
656:
657: end if;

Line 660: fa_methods_pkg.update_row (

656:
657: end if;
658:
659: if (h_record_exists > 0 ) then
660: fa_methods_pkg.update_row (
661: X_Rowid => row_id,
662: X_Method_ID => h_method_id,
663: X_Method_Code => X_Method_Code,
664: X_Life_In_Months => X_Life_In_Months,

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

690: X_Exclude_Salvage_Value_Flag => X_Exclude_Salvage_Value_Flag,
691: X_Deprn_Basis_Formula => X_Deprn_Basis_Formula,
692: X_Polish_Adj_Calc_Basis_Flag => X_Polish_Adj_Calc_Basis_Flag,
693: X_Guarantee_Rate_Method_Flag => X_Guarantee_Rate_Method_Flag,
694: X_Calling_Fn => 'fa_methods_pkg.load_row',
695: X_Deprn_Basis_Rule_Id => X_Deprn_Basis_Rule_Id,
696: x_jp_imp_calc_basis_flag => x_jp_imp_calc_basis_flag
697: , p_log_level_rec => p_log_level_rec);
698: else

Line 702: fa_methods_pkg.insert_row (

698: else
699:
700: h_method_id := null;
701:
702: fa_methods_pkg.insert_row (
703: X_Rowid => row_id,
704: X_Method_ID => h_method_id,
705: X_Method_Code => X_Method_Code,
706: X_Life_In_Months => X_Life_In_Months,

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

734: X_Exclude_Salvage_Value_Flag => X_Exclude_Salvage_Value_Flag,
735: X_Deprn_Basis_Formula => X_Deprn_Basis_Formula,
736: X_Polish_Adj_Calc_Basis_Flag => X_Polish_Adj_Calc_Basis_Flag,
737: X_Guarantee_Rate_Method_Flag => X_Guarantee_Rate_Method_Flag,
738: X_Calling_Fn => 'fa_methods_pkg.load_row',
739: X_Deprn_Basis_Rule_Id => X_Deprn_Basis_Rule_Id,
740: x_jp_imp_calc_basis_flag => x_jp_imp_calc_basis_flag
741: , p_log_level_rec => p_log_level_rec);
742: end if;

Line 748: calling_fn => 'fa_methods_pkg.load_row', p_log_level_rec => p_log_level_rec);

744: exception
745: when others then
746:
747: fa_srvr_msg.add_sql_error(
748: calling_fn => 'fa_methods_pkg.load_row', p_log_level_rec => p_log_level_rec);
749:
750: FA_STANDARD_PKG.RAISE_ERROR(
751: CALLED_FN => 'fa_methods_pkg.load_row',
752: CALLING_FN => 'upload fa_methods:' || SQLERRM, p_log_level_rec => p_log_level_rec);

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

747: fa_srvr_msg.add_sql_error(
748: calling_fn => 'fa_methods_pkg.load_row', p_log_level_rec => p_log_level_rec);
749:
750: FA_STANDARD_PKG.RAISE_ERROR(
751: CALLED_FN => 'fa_methods_pkg.load_row',
752: CALLING_FN => 'upload fa_methods:' || SQLERRM, p_log_level_rec => p_log_level_rec);
753:
754: end LOAD_ROW;
755: /*Bug 8355119 overloading function for release specific signatures*/

Line 752: CALLING_FN => 'upload fa_methods:' || SQLERRM, p_log_level_rec => p_log_level_rec);

748: calling_fn => 'fa_methods_pkg.load_row', p_log_level_rec => p_log_level_rec);
749:
750: FA_STANDARD_PKG.RAISE_ERROR(
751: CALLED_FN => 'fa_methods_pkg.load_row',
752: CALLING_FN => 'upload fa_methods:' || SQLERRM, p_log_level_rec => p_log_level_rec);
753:
754: end LOAD_ROW;
755: /*Bug 8355119 overloading function for release specific signatures*/
756: procedure LOAD_ROW (

Line 813: fa_methods_pkg.update_row (

809: if (fnd_load_util.upload_test(user_id, x_last_update_date,
810: X_db_last_updated_by, X_db_last_update_date,
811: X_CUSTOM_MODE)) then
812:
813: fa_methods_pkg.update_row (
814: X_Rowid => row_id,
815: X_Method_ID => h_method_id,
816: X_Method_Code => X_Method_Code,
817: X_Life_In_Months => X_Life_In_Months,

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

843: X_Exclude_Salvage_Value_Flag => X_Exclude_Salvage_Value_Flag,
844: X_Deprn_Basis_Formula => X_Deprn_Basis_Formula,
845: X_Polish_Adj_Calc_Basis_Flag => X_Polish_Adj_Calc_Basis_Flag,
846: X_Guarantee_Rate_Method_Flag => X_Guarantee_Rate_Method_Flag,
847: X_Calling_Fn => 'fa_methods_pkg.load_row',
848: X_Deprn_Basis_Rule_Id => X_Deprn_Basis_Rule_Id,
849: x_jp_imp_calc_basis_flag => x_jp_imp_calc_basis_flag
850: ,p_log_level_rec => p_log_level_rec);
851: end if;

Line 856: fa_methods_pkg.insert_row (

852: else
853:
854: h_method_id := null;
855:
856: fa_methods_pkg.insert_row (
857: X_Rowid => row_id,
858: X_Method_ID => h_method_id,
859: X_Method_Code => X_Method_Code,
860: X_Life_In_Months => X_Life_In_Months,

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

888: X_Exclude_Salvage_Value_Flag => X_Exclude_Salvage_Value_Flag,
889: X_Deprn_Basis_Formula => X_Deprn_Basis_Formula,
890: X_Polish_Adj_Calc_Basis_Flag => X_Polish_Adj_Calc_Basis_Flag,
891: X_Guarantee_Rate_Method_Flag => X_Guarantee_Rate_Method_Flag,
892: X_Calling_Fn => 'fa_methods_pkg.load_row',
893: X_Deprn_Basis_Rule_Id => X_Deprn_Basis_Rule_Id,
894: x_jp_imp_calc_basis_flag => x_jp_imp_calc_basis_flag
895: ,p_log_level_rec => p_log_level_rec);
896: end if;

Line 902: calling_fn => 'fa_methods_pkg.load_row'

898: exception
899: when others then
900:
901: fa_srvr_msg.add_sql_error(
902: calling_fn => 'fa_methods_pkg.load_row'
903: ,p_log_level_rec => p_log_level_rec);
904:
905: FA_STANDARD_PKG.RAISE_ERROR(
906: CALLED_FN => 'fa_methods_pkg.load_row',

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

902: calling_fn => 'fa_methods_pkg.load_row'
903: ,p_log_level_rec => p_log_level_rec);
904:
905: FA_STANDARD_PKG.RAISE_ERROR(
906: CALLED_FN => 'fa_methods_pkg.load_row',
907: CALLING_FN => 'upload fa_methods:' || SQLERRM
908: ,p_log_level_rec => p_log_level_rec);
909:
910: end LOAD_ROW;

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

903: ,p_log_level_rec => p_log_level_rec);
904:
905: FA_STANDARD_PKG.RAISE_ERROR(
906: CALLED_FN => 'fa_methods_pkg.load_row',
907: CALLING_FN => 'upload fa_methods:' || SQLERRM
908: ,p_log_level_rec => p_log_level_rec);
909:
910: end LOAD_ROW;
911:

Line 941: update FA_METHODS set

937: * of method_code and life_in_months.
938: * */
939:
940: if (X_Life_In_Months is not null) then
941: update FA_METHODS set
942: NAME = nvl(X_Name, Name),
943: LAST_UPDATE_DATE = sysdate,
944: LAST_UPDATED_BY = user_id,
945: LAST_UPDATE_LOGIN = 0

Line 954: update FA_METHODS set

950: (select language_code
951: from FND_LANGUAGES
952: where installed_flag = 'B');
953: else
954: update FA_METHODS set
955: NAME = nvl(X_Name, Name),
956: LAST_UPDATE_DATE = sysdate,
957: LAST_UPDATED_BY = user_id,
958: LAST_UPDATE_LOGIN = 0

Line 972: calling_fn => 'fa_methods_pkg.translate_row', p_log_level_rec => p_log_level_rec);

968: exception
969: when others then
970:
971: fa_srvr_msg.add_sql_error(
972: calling_fn => 'fa_methods_pkg.translate_row', p_log_level_rec => p_log_level_rec);
973:
974: FA_STANDARD_PKG.RAISE_ERROR(
975: CALLED_FN => 'fa_methods_pkg.translate_row',
976: CALLING_FN => 'upload fa_methods', p_log_level_rec => p_log_level_rec);

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

971: fa_srvr_msg.add_sql_error(
972: calling_fn => 'fa_methods_pkg.translate_row', p_log_level_rec => p_log_level_rec);
973:
974: FA_STANDARD_PKG.RAISE_ERROR(
975: CALLED_FN => 'fa_methods_pkg.translate_row',
976: CALLING_FN => 'upload fa_methods', p_log_level_rec => p_log_level_rec);
977:
978: end TRANSLATE_ROW;
979: /*Bug 8355119 overloading function for release specific signatures*/

Line 976: CALLING_FN => 'upload fa_methods', p_log_level_rec => p_log_level_rec);

972: calling_fn => 'fa_methods_pkg.translate_row', p_log_level_rec => p_log_level_rec);
973:
974: FA_STANDARD_PKG.RAISE_ERROR(
975: CALLED_FN => 'fa_methods_pkg.translate_row',
976: CALLING_FN => 'upload fa_methods', p_log_level_rec => p_log_level_rec);
977:
978: end TRANSLATE_ROW;
979: /*Bug 8355119 overloading function for release specific signatures*/
980: procedure TRANSLATE_ROW (

Line 1011: update FA_METHODS

1007: * */
1008:
1009: if (X_Life_In_Months is not null) then
1010:
1011: update FA_METHODS
1012: set NAME = nvl(X_Name, Name),
1013: LAST_UPDATE_DATE = sysdate,
1014: LAST_UPDATED_BY = user_id
1015: --where METHOD_ID = X_Method_ID

Line 1024: update FA_METHODS set

1020: from FND_LANGUAGES
1021: where installed_flag = 'B');
1022: else
1023:
1024: update FA_METHODS set
1025: NAME = nvl(X_Name, Name),
1026: LAST_UPDATE_DATE = sysdate,
1027: LAST_UPDATED_BY = user_id,
1028: LAST_UPDATE_LOGIN = 0

Line 1044: calling_fn => 'fa_methods_pkg.translate_row'

1040: exception
1041: when others then
1042:
1043: fa_srvr_msg.add_sql_error(
1044: calling_fn => 'fa_methods_pkg.translate_row'
1045: ,p_log_level_rec => p_log_level_rec);
1046:
1047: FA_STANDARD_PKG.RAISE_ERROR(
1048: CALLED_FN => 'fa_methods_pkg.translate_row',

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

1044: calling_fn => 'fa_methods_pkg.translate_row'
1045: ,p_log_level_rec => p_log_level_rec);
1046:
1047: FA_STANDARD_PKG.RAISE_ERROR(
1048: CALLED_FN => 'fa_methods_pkg.translate_row',
1049: CALLING_FN => 'upload fa_methods'
1050: ,p_log_level_rec => p_log_level_rec);
1051:
1052: end TRANSLATE_ROW;

Line 1049: CALLING_FN => 'upload fa_methods'

1045: ,p_log_level_rec => p_log_level_rec);
1046:
1047: FA_STANDARD_PKG.RAISE_ERROR(
1048: CALLED_FN => 'fa_methods_pkg.translate_row',
1049: CALLING_FN => 'upload fa_methods'
1050: ,p_log_level_rec => p_log_level_rec);
1051:
1052: end TRANSLATE_ROW;
1053: /*bug 8355119 adding R12 specific funtion LOAD_SEED_ROW*/

Line 1112: fa_methods_pkg.TRANSLATE_ROW (

1108:
1109: end if;
1110:
1111: if (x_upload_mode = 'NLS') then
1112: fa_methods_pkg.TRANSLATE_ROW (
1113: x_custom_mode => x_custom_mode,
1114: x_method_id => h_method_id,
1115: x_method_code => x_method_code,
1116: x_life_in_months => x_life_in_months,

Line 1123: fa_methods_pkg.LOAD_ROW (

1119: x_owner => x_owner,
1120: x_last_update_date => x_last_update_date,
1121: x_name => x_name);
1122: else
1123: fa_methods_pkg.LOAD_ROW (
1124: x_custom_mode => x_custom_mode,
1125: x_method_id => h_method_id,
1126: x_db_last_update_date => h_last_update_date,
1127: x_db_last_updated_by => h_last_updated_by,

Line 1164: END FA_METHODS_PKG;

1160:
1161: end if;
1162:
1163: END LOAD_SEED_ROW;
1164: END FA_METHODS_PKG;