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) 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 400: update FA_DEPRN_BASIS_RULES set

396: else
397: user_id :=0;
398: end if;
399:
400: update FA_DEPRN_BASIS_RULES set
401: USER_RULE_NAME=nvl(X_USER_RULE_NAME, USER_RULE_NAME),
402: LAST_UPDATED_BY = user_id,
403: LAST_UPDATE_LOGIN =0,
404: DESCRIPTION = X_DESCRIPTION

Line 452: update FA_DEPRN_BASIS_RULES set

448: if (fnd_load_util.upload_test(user_id, x_last_update_date,
449: db_last_updated_by, db_last_update_date,
450: X_CUSTOM_MODE)) then
451:
452: update FA_DEPRN_BASIS_RULES set
453: USER_RULE_NAME =nvl(X_USER_RULE_NAME, USER_RULE_NAME),
454: LAST_UPDATED_BY = user_id,
455: LAST_UPDATE_LOGIN = 0,
456: DESCRIPTION = X_DESCRIPTION