DBA Data[Home] [Help]

APPS.EAM_ENABLE_WF_PKG dependencies on EAM_ENABLE_WORKFLOW

Line 42: from EAM_ENABLE_WORKFLOW

38: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
39:
40: select LAST_UPDATED_BY, LAST_UPDATE_DATE
41: into db_luby, db_ludate
42: from EAM_ENABLE_WORKFLOW
43: where MAINTENANCE_OBJECT_SOURCE = x_maintenance_object_source;
44:
45: if (fnd_load_util.upload_test(user_id, f_ludate, db_luby,
46: db_ludate, x_custom_mode)) then

Line 47: update EAM_ENABLE_WORKFLOW set

43: where MAINTENANCE_OBJECT_SOURCE = x_maintenance_object_source;
44:
45: if (fnd_load_util.upload_test(user_id, f_ludate, db_luby,
46: db_ludate, x_custom_mode)) then
47: update EAM_ENABLE_WORKFLOW set
48: MAINTENANCE_OBJECT_SOURCE = x_maintenance_object_source,
49: ENABLE_WORKFLOW = x_enable_workflow,
50: LAST_UPDATE_DATE = f_ludate,
51: LAST_UPDATED_BY = user_id,

Line 59: insert into EAM_ENABLE_WORKFLOW (

55:
56: exception
57: when no_data_found then
58: -- Row doesn't exist yet. Now this insert statement is placed here.
59: insert into EAM_ENABLE_WORKFLOW (
60: MAINTENANCE_OBJECT_SOURCE,
61: ENABLE_WORKFLOW,
62: LAST_UPDATE_DATE,
63: LAST_UPDATED_BY,