APPS.AD_FEATURE_VERS_PKG dependencies on AD_FEATURE_VERSIONS

Line 63: from ad_feature_versions

59: end;
60:
61: select rcs_version
62: into l_curr_rcs_version
63: from ad_feature_versions
64: where feature_name = p_feature_name
65: for update;
66:
67: if l_curr_rcs_version = '0' then

Line 74: update ad_feature_versions

70: -- These columns were just added, we need to populate them (ODF defaults
71: -- the value of the FEATURE_NAME column into FILENAME, and '0' into
72: -- RCS_VERSION)
73:
74: update ad_feature_versions
75: set filename = l_actual_filename,
76: rcs_version = l_actual_rcs_version
77: where filename = p_feature_name;
78:

Line 85: update ad_feature_versions

81: -- then update it.
82:
83: -- Note: Dont touch ENABLED_FLAG.
84:
85: update ad_feature_versions
86: set current_db_version = p_db_version,
87: last_update_date = sysdate
88: where feature_name = p_feature_name
89: and p_db_version > current_db_version;

Line 113: update ad_feature_versions

109: -- (3) Leapfrogging not supported (ie. if a lower file version has
110: -- a higher feature version, the feature version wouldn't get
111: -- updated)
112:
113: update ad_feature_versions
114: set rcs_version = l_actual_rcs_version,
115: last_update_date = sysdate
116: where feature_name = p_feature_name;
117:

Line 121: update ad_feature_versions

117:
118:
119: -- Next, update the feature version if thats also newer.
120:
121: update ad_feature_versions
122: set current_db_version = p_db_version,
123: last_update_date = sysdate
124: where feature_name = p_feature_name
125: and p_db_version > current_db_version;

Line 132: insert into ad_feature_versions

128:
129: commit;
130:
131: exception when no_data_found then
132: insert into ad_feature_versions
133: (
134: feature_name, current_db_version, enabled_flag,
135: filename, rcs_version,
136: creation_date,last_update_date