40: X_Calling_Fn VARCHAR2,
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:
217: X_Calling_Fn VARCHAR2,
218: -- added for Depreciable Basis Formula
219: X_Deprn_Basis_Rule_Id NUMBER DEFAULT NULL,
220: x_jp_imp_calc_basis_flag VARCHAR2 DEFAULT NULL
221: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
222: CURSOR C IS
223: SELECT method_id,
224: method_code,
225: life_in_months,
393: X_Calling_Fn VARCHAR2,
394: -- added for Depreciable Basis Formula
395: X_Deprn_Basis_Rule_Id NUMBER DEFAULT NULL,
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.
563:
564: END Update_Row;
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;
619: X_GUARANTEE_RATE_METHOD_FLAG in VARCHAR2,
620: -- added for Depreciable Basis Formula
621: X_DEPRN_BASIS_RULE_ID in NUMBER DEFAULT NULL,
622: X_JP_IMP_CALC_BASIS_FLAG IN VARCHAR2 DEFAULT NULL
623: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) is
624:
625: h_record_exists number(15);
626: h_method_id number(15);
627:
791: X_GUARANTEE_RATE_METHOD_FLAG in VARCHAR2,
792: -- added for Depreciable Basis Formula
793: X_DEPRN_BASIS_RULE_ID in NUMBER DEFAULT NULL,
794: X_JP_IMP_CALC_BASIS_FLAG IN VARCHAR2 DEFAULT NULL,
795: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) is
796:
797: h_record_exists number(15);
798: h_method_id number(15);
799:
916: X_METHOD_CODE in VARCHAR2,
917: X_LIFE_IN_MONTHS in NUMBER,
918: X_OWNER in VARCHAR2,
919: X_NAME in VARCHAR2
920: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) is
921:
922: user_id number;
923:
924: begin
986: X_DB_LAST_UPDATE_DATE DATE,
987: X_OWNER in VARCHAR2,
988: X_LAST_UPDATE_DATE DATE,
989: X_NAME in VARCHAR2,
990: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) is
991:
992: user_id number;
993:
994: begin