1093: h_last_updated_by number;
1094:
1095: BEGIN
1096:
1097: if not fa_cache_pkg.fazccmt (
1098: X_method => x_method_code,
1099: X_life => x_life_in_months) then
1100:
1101: h_method_id := null;
1101: h_method_id := null;
1102:
1103: else
1104:
1105: h_method_id := fa_cache_pkg.fazccmt_record.method_id;
1106: h_last_update_date := fa_cache_pkg.fazccmt_record.last_update_date;
1107: h_last_updated_by := fa_cache_pkg.fazccmt_record.last_updated_by;
1108:
1109: end if;
1102:
1103: else
1104:
1105: h_method_id := fa_cache_pkg.fazccmt_record.method_id;
1106: h_last_update_date := fa_cache_pkg.fazccmt_record.last_update_date;
1107: h_last_updated_by := fa_cache_pkg.fazccmt_record.last_updated_by;
1108:
1109: end if;
1110:
1103: else
1104:
1105: h_method_id := fa_cache_pkg.fazccmt_record.method_id;
1106: h_last_update_date := fa_cache_pkg.fazccmt_record.last_update_date;
1107: h_last_updated_by := fa_cache_pkg.fazccmt_record.last_updated_by;
1108:
1109: end if;
1110:
1111: if (x_upload_mode = 'NLS') then