DBA Data[Home] [Help]

APPS.FA_DEPRN_BASIS_RULES_PKG dependencies on FA_DEPRN_BASIS_RULES_S

Line 18: CURSOR C is SELECT FA_DEPRN_BASIS_RULES_S.nextval from sys.dual;

14: X_enabled_flag VARCHAR2,
15: X_program_name VARCHAR2,
16: X_description VARCHAR2,
17: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
18: CURSOR C is SELECT FA_DEPRN_BASIS_RULES_S.nextval from sys.dual;
19:
20: CURSOR C_MAX_SEQ
21: is
22: select nvl(max(deprn_basis_rule_id),0)+1

Line 334: update FA_DEPRN_BASIS_RULES set

330: if (fnd_load_util.upload_test(user_id, x_last_update_date,
331: db_last_updated_by, db_last_update_date,
332: X_CUSTOM_MODE)) then
333:
334: update FA_DEPRN_BASIS_RULES set
335: USER_RULE_NAME =nvl(X_USER_RULE_NAME, USER_RULE_NAME),
336: LAST_UPDATED_BY = user_id,
337: LAST_UPDATE_LOGIN = 0,
338: DESCRIPTION = X_DESCRIPTION