APPS.FLM_EKB_PREF_LEVEL_PKG dependencies on FLM_EKB_PREFERENCE_LEVELS

Line 48: from FLM_EKB_PREFERENCE_LEVELS

44: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
45:
46: select LAST_UPDATED_BY, LAST_UPDATE_DATE
47: into db_luby, db_ludate
48: from FLM_EKB_PREFERENCE_LEVELS
49: where LEVEL_ID = x_level_id;
50:
51: if (fnd_load_util.upload_test(user_id, f_ludate, db_luby,
52: db_ludate, x_custom_mode)) then

Line 53: update FLM_EKB_PREFERENCE_LEVELS set

49: where LEVEL_ID = x_level_id;
50:
51: if (fnd_load_util.upload_test(user_id, f_ludate, db_luby,
52: db_ludate, x_custom_mode)) then
53: update FLM_EKB_PREFERENCE_LEVELS set
54: LEVEL_CODE = x_level_code,
55: ORGANIZATION_ID = x_organization_id,
56: MODULE_ID = x_module_id,
57: LAST_UPDATE_DATE = f_ludate,

Line 66: insert into FLM_EKB_PREFERENCE_LEVELS (

62:
63: exception
64: when no_data_found then
65: -- Row doesn't exist yet. Now this insert statement is placed here.
66: insert into FLM_EKB_PREFERENCE_LEVELS (
67: LEVEL_ID,
68: LEVEL_CODE,
69: ORGANIZATION_ID,
70: MODULE_ID,