[Home] [Help]
27: X_CREATED_BY in NUMBER,
28: X_LAST_UPDATE_DATE in DATE,
29: X_LAST_UPDATED_BY in NUMBER,
30: X_LAST_UPDATE_LOGIN in NUMBER
31: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) is
32:
33: CURSOR C is SELECT rowid FROM fa_flat_rates
34: where method_id = X_Method_Id
35: and basic_rate = X_Basic_Rate
127: X_ATTRIBUTE13 in VARCHAR2,
128: X_ATTRIBUTE14 in VARCHAR2,
129: X_ATTRIBUTE15 in VARCHAR2,
130: X_ATTRIBUTE_CATEGORY_CODE in VARCHAR2
131: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) is
132: CURSOR C is
133: SELECT method_id,
134: basic_rate,
135: adjusted_rate,
249: X_ATTRIBUTE_CATEGORY_CODE in VARCHAR2,
250: X_LAST_UPDATE_DATE in DATE,
251: X_LAST_UPDATED_BY in NUMBER,
252: X_LAST_UPDATE_LOGIN in NUMBER
253: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) is
254:
255: begin
256:
257: UPDATE fa_flat_rates
293: procedure DELETE_ROW (
294: X_METHOD_ID in NUMBER,
295: X_BASIC_RATE in NUMBER,
296: X_ADJUSTED_RATE in NUMBER
297: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) is
298:
299: begin
300:
301: DELETE FROM fa_flat_rates
336: X_ATTRIBUTE13 in VARCHAR2,
337: X_ATTRIBUTE14 in VARCHAR2,
338: X_ATTRIBUTE15 in VARCHAR2,
339: X_ATTRIBUTE_CATEGORY_CODE in VARCHAR2
340: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) is
341:
342: h_record_exists number(15);
343:
344: user_id number;
449: X_ATTRIBUTE13 in VARCHAR2,
450: X_ATTRIBUTE14 in VARCHAR2,
451: X_ATTRIBUTE15 in VARCHAR2,
452: X_ATTRIBUTE_CATEGORY_CODE in VARCHAR2,
453: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) is
454:
455: h_record_exists number(15);
456:
457: user_id number;
567: x_attribute13 IN VARCHAR2,
568: x_attribute14 IN VARCHAR2,
569: x_attribute15 IN VARCHAR2,
570: x_attribute_category_code IN VARCHAR2
571: ,p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
572:
573: methods_err exception;
574: h_method_id number(15);
575: h_last_update_date date;