DBA Data[Home] [Help]

APPS.ASG_PUB_ITEM_PKG dependencies on FND_API

Line 153: decode(X_NAME,FND_API.G_MISS_CHAR, NULL, x_NAME),

149: LAST_UPDATE_DATE,
150: LAST_UPDATED_BY
151: ) values (
152: x_item_id,
153: decode(X_NAME,FND_API.G_MISS_CHAR, NULL, x_NAME),
154: decode(X_PUB_NAME, FND_API.G_MISS_CHAR, NULL, x_PUB_NAME),
155: decode(L_BASE_OWNER,FND_API.G_MISS_CHAR, NULL, L_BASE_OWNER),
156: decode(X_BASE_OBJECT_NAME,FND_API.G_MISS_CHAR, NULL, x_BASE_OBJECT_NAME),
157: decode(X_PRIMARY_KEY_COLUMN, FND_API.G_MISS_CHAR, NULL, x_PRIMARY_KEY_COLUMN),

Line 154: decode(X_PUB_NAME, FND_API.G_MISS_CHAR, NULL, x_PUB_NAME),

150: LAST_UPDATED_BY
151: ) values (
152: x_item_id,
153: decode(X_NAME,FND_API.G_MISS_CHAR, NULL, x_NAME),
154: decode(X_PUB_NAME, FND_API.G_MISS_CHAR, NULL, x_PUB_NAME),
155: decode(L_BASE_OWNER,FND_API.G_MISS_CHAR, NULL, L_BASE_OWNER),
156: decode(X_BASE_OBJECT_NAME,FND_API.G_MISS_CHAR, NULL, x_BASE_OBJECT_NAME),
157: decode(X_PRIMARY_KEY_COLUMN, FND_API.G_MISS_CHAR, NULL, x_PRIMARY_KEY_COLUMN),
158: decode(X_CONFLICT_RULE,FND_API.G_MISS_CHAR, NULL, x_CONFLICT_RULE),

Line 155: decode(L_BASE_OWNER,FND_API.G_MISS_CHAR, NULL, L_BASE_OWNER),

151: ) values (
152: x_item_id,
153: decode(X_NAME,FND_API.G_MISS_CHAR, NULL, x_NAME),
154: decode(X_PUB_NAME, FND_API.G_MISS_CHAR, NULL, x_PUB_NAME),
155: decode(L_BASE_OWNER,FND_API.G_MISS_CHAR, NULL, L_BASE_OWNER),
156: decode(X_BASE_OBJECT_NAME,FND_API.G_MISS_CHAR, NULL, x_BASE_OBJECT_NAME),
157: decode(X_PRIMARY_KEY_COLUMN, FND_API.G_MISS_CHAR, NULL, x_PRIMARY_KEY_COLUMN),
158: decode(X_CONFLICT_RULE,FND_API.G_MISS_CHAR, NULL, x_CONFLICT_RULE),
159: decode(X_RESTRICTING_PREDICATE,FND_API.G_MISS_CHAR, NULL, x_RESTRICTING_PREDICATE),

Line 156: decode(X_BASE_OBJECT_NAME,FND_API.G_MISS_CHAR, NULL, x_BASE_OBJECT_NAME),

152: x_item_id,
153: decode(X_NAME,FND_API.G_MISS_CHAR, NULL, x_NAME),
154: decode(X_PUB_NAME, FND_API.G_MISS_CHAR, NULL, x_PUB_NAME),
155: decode(L_BASE_OWNER,FND_API.G_MISS_CHAR, NULL, L_BASE_OWNER),
156: decode(X_BASE_OBJECT_NAME,FND_API.G_MISS_CHAR, NULL, x_BASE_OBJECT_NAME),
157: decode(X_PRIMARY_KEY_COLUMN, FND_API.G_MISS_CHAR, NULL, x_PRIMARY_KEY_COLUMN),
158: decode(X_CONFLICT_RULE,FND_API.G_MISS_CHAR, NULL, x_CONFLICT_RULE),
159: decode(X_RESTRICTING_PREDICATE,FND_API.G_MISS_CHAR, NULL, x_RESTRICTING_PREDICATE),
160: decode(X_HIGH_PRIORITY,FND_API.G_MISS_CHAR, NULL, x_HIGH_PRIORITY),

Line 157: decode(X_PRIMARY_KEY_COLUMN, FND_API.G_MISS_CHAR, NULL, x_PRIMARY_KEY_COLUMN),

153: decode(X_NAME,FND_API.G_MISS_CHAR, NULL, x_NAME),
154: decode(X_PUB_NAME, FND_API.G_MISS_CHAR, NULL, x_PUB_NAME),
155: decode(L_BASE_OWNER,FND_API.G_MISS_CHAR, NULL, L_BASE_OWNER),
156: decode(X_BASE_OBJECT_NAME,FND_API.G_MISS_CHAR, NULL, x_BASE_OBJECT_NAME),
157: decode(X_PRIMARY_KEY_COLUMN, FND_API.G_MISS_CHAR, NULL, x_PRIMARY_KEY_COLUMN),
158: decode(X_CONFLICT_RULE,FND_API.G_MISS_CHAR, NULL, x_CONFLICT_RULE),
159: decode(X_RESTRICTING_PREDICATE,FND_API.G_MISS_CHAR, NULL, x_RESTRICTING_PREDICATE),
160: decode(X_HIGH_PRIORITY,FND_API.G_MISS_CHAR, NULL, x_HIGH_PRIORITY),
161: decode(X_TABLE_WEIGHT,FND_API.G_MISS_CHAR, NULL, x_TABLE_WEIGHT),

Line 158: decode(X_CONFLICT_RULE,FND_API.G_MISS_CHAR, NULL, x_CONFLICT_RULE),

154: decode(X_PUB_NAME, FND_API.G_MISS_CHAR, NULL, x_PUB_NAME),
155: decode(L_BASE_OWNER,FND_API.G_MISS_CHAR, NULL, L_BASE_OWNER),
156: decode(X_BASE_OBJECT_NAME,FND_API.G_MISS_CHAR, NULL, x_BASE_OBJECT_NAME),
157: decode(X_PRIMARY_KEY_COLUMN, FND_API.G_MISS_CHAR, NULL, x_PRIMARY_KEY_COLUMN),
158: decode(X_CONFLICT_RULE,FND_API.G_MISS_CHAR, NULL, x_CONFLICT_RULE),
159: decode(X_RESTRICTING_PREDICATE,FND_API.G_MISS_CHAR, NULL, x_RESTRICTING_PREDICATE),
160: decode(X_HIGH_PRIORITY,FND_API.G_MISS_CHAR, NULL, x_HIGH_PRIORITY),
161: decode(X_TABLE_WEIGHT,FND_API.G_MISS_CHAR, NULL, x_TABLE_WEIGHT),
162: decode(X_PUB_ID,FND_API.G_MISS_CHAR, NULL, x_PUB_ID),

Line 159: decode(X_RESTRICTING_PREDICATE,FND_API.G_MISS_CHAR, NULL, x_RESTRICTING_PREDICATE),

155: decode(L_BASE_OWNER,FND_API.G_MISS_CHAR, NULL, L_BASE_OWNER),
156: decode(X_BASE_OBJECT_NAME,FND_API.G_MISS_CHAR, NULL, x_BASE_OBJECT_NAME),
157: decode(X_PRIMARY_KEY_COLUMN, FND_API.G_MISS_CHAR, NULL, x_PRIMARY_KEY_COLUMN),
158: decode(X_CONFLICT_RULE,FND_API.G_MISS_CHAR, NULL, x_CONFLICT_RULE),
159: decode(X_RESTRICTING_PREDICATE,FND_API.G_MISS_CHAR, NULL, x_RESTRICTING_PREDICATE),
160: decode(X_HIGH_PRIORITY,FND_API.G_MISS_CHAR, NULL, x_HIGH_PRIORITY),
161: decode(X_TABLE_WEIGHT,FND_API.G_MISS_CHAR, NULL, x_TABLE_WEIGHT),
162: decode(X_PUB_ID,FND_API.G_MISS_CHAR, NULL, x_PUB_ID),
163: 'N',

Line 160: decode(X_HIGH_PRIORITY,FND_API.G_MISS_CHAR, NULL, x_HIGH_PRIORITY),

156: decode(X_BASE_OBJECT_NAME,FND_API.G_MISS_CHAR, NULL, x_BASE_OBJECT_NAME),
157: decode(X_PRIMARY_KEY_COLUMN, FND_API.G_MISS_CHAR, NULL, x_PRIMARY_KEY_COLUMN),
158: decode(X_CONFLICT_RULE,FND_API.G_MISS_CHAR, NULL, x_CONFLICT_RULE),
159: decode(X_RESTRICTING_PREDICATE,FND_API.G_MISS_CHAR, NULL, x_RESTRICTING_PREDICATE),
160: decode(X_HIGH_PRIORITY,FND_API.G_MISS_CHAR, NULL, x_HIGH_PRIORITY),
161: decode(X_TABLE_WEIGHT,FND_API.G_MISS_CHAR, NULL, x_TABLE_WEIGHT),
162: decode(X_PUB_ID,FND_API.G_MISS_CHAR, NULL, x_PUB_ID),
163: 'N',
164: 0,

Line 161: decode(X_TABLE_WEIGHT,FND_API.G_MISS_CHAR, NULL, x_TABLE_WEIGHT),

157: decode(X_PRIMARY_KEY_COLUMN, FND_API.G_MISS_CHAR, NULL, x_PRIMARY_KEY_COLUMN),
158: decode(X_CONFLICT_RULE,FND_API.G_MISS_CHAR, NULL, x_CONFLICT_RULE),
159: decode(X_RESTRICTING_PREDICATE,FND_API.G_MISS_CHAR, NULL, x_RESTRICTING_PREDICATE),
160: decode(X_HIGH_PRIORITY,FND_API.G_MISS_CHAR, NULL, x_HIGH_PRIORITY),
161: decode(X_TABLE_WEIGHT,FND_API.G_MISS_CHAR, NULL, x_TABLE_WEIGHT),
162: decode(X_PUB_ID,FND_API.G_MISS_CHAR, NULL, x_PUB_ID),
163: 'N',
164: 0,
165: decode(x_CURRENT_release_version,FND_API.G_MISS_NUM, NULL, x_CURRENT_RELEASE_VERSION),

Line 162: decode(X_PUB_ID,FND_API.G_MISS_CHAR, NULL, x_PUB_ID),

158: decode(X_CONFLICT_RULE,FND_API.G_MISS_CHAR, NULL, x_CONFLICT_RULE),
159: decode(X_RESTRICTING_PREDICATE,FND_API.G_MISS_CHAR, NULL, x_RESTRICTING_PREDICATE),
160: decode(X_HIGH_PRIORITY,FND_API.G_MISS_CHAR, NULL, x_HIGH_PRIORITY),
161: decode(X_TABLE_WEIGHT,FND_API.G_MISS_CHAR, NULL, x_TABLE_WEIGHT),
162: decode(X_PUB_ID,FND_API.G_MISS_CHAR, NULL, x_PUB_ID),
163: 'N',
164: 0,
165: decode(x_CURRENT_release_version,FND_API.G_MISS_NUM, NULL, x_CURRENT_RELEASE_VERSION),
166: 0,

Line 165: decode(x_CURRENT_release_version,FND_API.G_MISS_NUM, NULL, x_CURRENT_RELEASE_VERSION),

161: decode(X_TABLE_WEIGHT,FND_API.G_MISS_CHAR, NULL, x_TABLE_WEIGHT),
162: decode(X_PUB_ID,FND_API.G_MISS_CHAR, NULL, x_PUB_ID),
163: 'N',
164: 0,
165: decode(x_CURRENT_release_version,FND_API.G_MISS_NUM, NULL, x_CURRENT_RELEASE_VERSION),
166: 0,
167: decode(x_ACC_CURRENT_release_version, FND_API.G_MISS_NUM, NULL, x_ACC_CURRENT_RELEASE_VERSION),
168: decode(X_PARENT_TABLE,FND_API.G_MISS_CHAR, NULL, x_PARENT_TABLE),
169: decode(X_PARENT_OWNER,FND_API.G_MISS_CHAR, NULL, x_PARENT_OWNER),

Line 167: decode(x_ACC_CURRENT_release_version, FND_API.G_MISS_NUM, NULL, x_ACC_CURRENT_RELEASE_VERSION),

163: 'N',
164: 0,
165: decode(x_CURRENT_release_version,FND_API.G_MISS_NUM, NULL, x_CURRENT_RELEASE_VERSION),
166: 0,
167: decode(x_ACC_CURRENT_release_version, FND_API.G_MISS_NUM, NULL, x_ACC_CURRENT_RELEASE_VERSION),
168: decode(X_PARENT_TABLE,FND_API.G_MISS_CHAR, NULL, x_PARENT_TABLE),
169: decode(X_PARENT_OWNER,FND_API.G_MISS_CHAR, NULL, x_PARENT_OWNER),
170: decode(x_enabled,FND_API.G_MISS_CHAR,NULL, x_ENABLED),
171: decode(x_updatable,FND_API.G_MISS_CHAR,NULL, x_updatable),

Line 168: decode(X_PARENT_TABLE,FND_API.G_MISS_CHAR, NULL, x_PARENT_TABLE),

164: 0,
165: decode(x_CURRENT_release_version,FND_API.G_MISS_NUM, NULL, x_CURRENT_RELEASE_VERSION),
166: 0,
167: decode(x_ACC_CURRENT_release_version, FND_API.G_MISS_NUM, NULL, x_ACC_CURRENT_RELEASE_VERSION),
168: decode(X_PARENT_TABLE,FND_API.G_MISS_CHAR, NULL, x_PARENT_TABLE),
169: decode(X_PARENT_OWNER,FND_API.G_MISS_CHAR, NULL, x_PARENT_OWNER),
170: decode(x_enabled,FND_API.G_MISS_CHAR,NULL, x_ENABLED),
171: decode(x_updatable,FND_API.G_MISS_CHAR,NULL, x_updatable),
172: decode(x_disabled_dml,FND_API.G_MISS_CHAR,NULL, x_disabled_dml),

Line 169: decode(X_PARENT_OWNER,FND_API.G_MISS_CHAR, NULL, x_PARENT_OWNER),

165: decode(x_CURRENT_release_version,FND_API.G_MISS_NUM, NULL, x_CURRENT_RELEASE_VERSION),
166: 0,
167: decode(x_ACC_CURRENT_release_version, FND_API.G_MISS_NUM, NULL, x_ACC_CURRENT_RELEASE_VERSION),
168: decode(X_PARENT_TABLE,FND_API.G_MISS_CHAR, NULL, x_PARENT_TABLE),
169: decode(X_PARENT_OWNER,FND_API.G_MISS_CHAR, NULL, x_PARENT_OWNER),
170: decode(x_enabled,FND_API.G_MISS_CHAR,NULL, x_ENABLED),
171: decode(x_updatable,FND_API.G_MISS_CHAR,NULL, x_updatable),
172: decode(x_disabled_dml,FND_API.G_MISS_CHAR,NULL, x_disabled_dml),
173: decode(x_where_clause,FND_API.G_MISS_CHAR,NULL, x_where_clause),

Line 170: decode(x_enabled,FND_API.G_MISS_CHAR,NULL, x_ENABLED),

166: 0,
167: decode(x_ACC_CURRENT_release_version, FND_API.G_MISS_NUM, NULL, x_ACC_CURRENT_RELEASE_VERSION),
168: decode(X_PARENT_TABLE,FND_API.G_MISS_CHAR, NULL, x_PARENT_TABLE),
169: decode(X_PARENT_OWNER,FND_API.G_MISS_CHAR, NULL, x_PARENT_OWNER),
170: decode(x_enabled,FND_API.G_MISS_CHAR,NULL, x_ENABLED),
171: decode(x_updatable,FND_API.G_MISS_CHAR,NULL, x_updatable),
172: decode(x_disabled_dml,FND_API.G_MISS_CHAR,NULL, x_disabled_dml),
173: decode(x_where_clause,FND_API.G_MISS_CHAR,NULL, x_where_clause),
174: decode(x_query1,FND_API.G_MISS_CHAR,NULL, x_query1),

Line 171: decode(x_updatable,FND_API.G_MISS_CHAR,NULL, x_updatable),

167: decode(x_ACC_CURRENT_release_version, FND_API.G_MISS_NUM, NULL, x_ACC_CURRENT_RELEASE_VERSION),
168: decode(X_PARENT_TABLE,FND_API.G_MISS_CHAR, NULL, x_PARENT_TABLE),
169: decode(X_PARENT_OWNER,FND_API.G_MISS_CHAR, NULL, x_PARENT_OWNER),
170: decode(x_enabled,FND_API.G_MISS_CHAR,NULL, x_ENABLED),
171: decode(x_updatable,FND_API.G_MISS_CHAR,NULL, x_updatable),
172: decode(x_disabled_dml,FND_API.G_MISS_CHAR,NULL, x_disabled_dml),
173: decode(x_where_clause,FND_API.G_MISS_CHAR,NULL, x_where_clause),
174: decode(x_query1,FND_API.G_MISS_CHAR,NULL, x_query1),
175: decode(x_query2,FND_API.G_MISS_CHAR,NULL, x_query2),

Line 172: decode(x_disabled_dml,FND_API.G_MISS_CHAR,NULL, x_disabled_dml),

168: decode(X_PARENT_TABLE,FND_API.G_MISS_CHAR, NULL, x_PARENT_TABLE),
169: decode(X_PARENT_OWNER,FND_API.G_MISS_CHAR, NULL, x_PARENT_OWNER),
170: decode(x_enabled,FND_API.G_MISS_CHAR,NULL, x_ENABLED),
171: decode(x_updatable,FND_API.G_MISS_CHAR,NULL, x_updatable),
172: decode(x_disabled_dml,FND_API.G_MISS_CHAR,NULL, x_disabled_dml),
173: decode(x_where_clause,FND_API.G_MISS_CHAR,NULL, x_where_clause),
174: decode(x_query1,FND_API.G_MISS_CHAR,NULL, x_query1),
175: decode(x_query2,FND_API.G_MISS_CHAR,NULL, x_query2),
176: decode(x_online_query,FND_API.G_MISS_CHAR,NULL, x_online_query),

Line 173: decode(x_where_clause,FND_API.G_MISS_CHAR,NULL, x_where_clause),

169: decode(X_PARENT_OWNER,FND_API.G_MISS_CHAR, NULL, x_PARENT_OWNER),
170: decode(x_enabled,FND_API.G_MISS_CHAR,NULL, x_ENABLED),
171: decode(x_updatable,FND_API.G_MISS_CHAR,NULL, x_updatable),
172: decode(x_disabled_dml,FND_API.G_MISS_CHAR,NULL, x_disabled_dml),
173: decode(x_where_clause,FND_API.G_MISS_CHAR,NULL, x_where_clause),
174: decode(x_query1,FND_API.G_MISS_CHAR,NULL, x_query1),
175: decode(x_query2,FND_API.G_MISS_CHAR,NULL, x_query2),
176: decode(x_online_query,FND_API.G_MISS_CHAR,NULL, x_online_query),
177: decode(x_inq_name,FND_API.G_MISS_CHAR,NULL, x_inq_name),

Line 174: decode(x_query1,FND_API.G_MISS_CHAR,NULL, x_query1),

170: decode(x_enabled,FND_API.G_MISS_CHAR,NULL, x_ENABLED),
171: decode(x_updatable,FND_API.G_MISS_CHAR,NULL, x_updatable),
172: decode(x_disabled_dml,FND_API.G_MISS_CHAR,NULL, x_disabled_dml),
173: decode(x_where_clause,FND_API.G_MISS_CHAR,NULL, x_where_clause),
174: decode(x_query1,FND_API.G_MISS_CHAR,NULL, x_query1),
175: decode(x_query2,FND_API.G_MISS_CHAR,NULL, x_query2),
176: decode(x_online_query,FND_API.G_MISS_CHAR,NULL, x_online_query),
177: decode(x_inq_name,FND_API.G_MISS_CHAR,NULL, x_inq_name),
178: decode(L_inq_owner,FND_API.G_MISS_CHAR,NULL, L_inq_owner),

Line 175: decode(x_query2,FND_API.G_MISS_CHAR,NULL, x_query2),

171: decode(x_updatable,FND_API.G_MISS_CHAR,NULL, x_updatable),
172: decode(x_disabled_dml,FND_API.G_MISS_CHAR,NULL, x_disabled_dml),
173: decode(x_where_clause,FND_API.G_MISS_CHAR,NULL, x_where_clause),
174: decode(x_query1,FND_API.G_MISS_CHAR,NULL, x_query1),
175: decode(x_query2,FND_API.G_MISS_CHAR,NULL, x_query2),
176: decode(x_online_query,FND_API.G_MISS_CHAR,NULL, x_online_query),
177: decode(x_inq_name,FND_API.G_MISS_CHAR,NULL, x_inq_name),
178: decode(L_inq_owner,FND_API.G_MISS_CHAR,NULL, L_inq_owner),
179: decode(x_force_complete_refresh,FND_API.G_MISS_CHAR,NULL, x_force_complete_refresh),

Line 176: decode(x_online_query,FND_API.G_MISS_CHAR,NULL, x_online_query),

172: decode(x_disabled_dml,FND_API.G_MISS_CHAR,NULL, x_disabled_dml),
173: decode(x_where_clause,FND_API.G_MISS_CHAR,NULL, x_where_clause),
174: decode(x_query1,FND_API.G_MISS_CHAR,NULL, x_query1),
175: decode(x_query2,FND_API.G_MISS_CHAR,NULL, x_query2),
176: decode(x_online_query,FND_API.G_MISS_CHAR,NULL, x_online_query),
177: decode(x_inq_name,FND_API.G_MISS_CHAR,NULL, x_inq_name),
178: decode(L_inq_owner,FND_API.G_MISS_CHAR,NULL, L_inq_owner),
179: decode(x_force_complete_refresh,FND_API.G_MISS_CHAR,NULL, x_force_complete_refresh),
180: decode(x_callout_procedure,FND_API.G_MISS_CHAR,NULL, x_callout_procedure),

Line 177: decode(x_inq_name,FND_API.G_MISS_CHAR,NULL, x_inq_name),

173: decode(x_where_clause,FND_API.G_MISS_CHAR,NULL, x_where_clause),
174: decode(x_query1,FND_API.G_MISS_CHAR,NULL, x_query1),
175: decode(x_query2,FND_API.G_MISS_CHAR,NULL, x_query2),
176: decode(x_online_query,FND_API.G_MISS_CHAR,NULL, x_online_query),
177: decode(x_inq_name,FND_API.G_MISS_CHAR,NULL, x_inq_name),
178: decode(L_inq_owner,FND_API.G_MISS_CHAR,NULL, L_inq_owner),
179: decode(x_force_complete_refresh,FND_API.G_MISS_CHAR,NULL, x_force_complete_refresh),
180: decode(x_callout_procedure,FND_API.G_MISS_CHAR,NULL, x_callout_procedure),
181: decode(l_access_owner, FND_API.G_MISS_CHAR, NULL, l_access_owner),

Line 178: decode(L_inq_owner,FND_API.G_MISS_CHAR,NULL, L_inq_owner),

174: decode(x_query1,FND_API.G_MISS_CHAR,NULL, x_query1),
175: decode(x_query2,FND_API.G_MISS_CHAR,NULL, x_query2),
176: decode(x_online_query,FND_API.G_MISS_CHAR,NULL, x_online_query),
177: decode(x_inq_name,FND_API.G_MISS_CHAR,NULL, x_inq_name),
178: decode(L_inq_owner,FND_API.G_MISS_CHAR,NULL, L_inq_owner),
179: decode(x_force_complete_refresh,FND_API.G_MISS_CHAR,NULL, x_force_complete_refresh),
180: decode(x_callout_procedure,FND_API.G_MISS_CHAR,NULL, x_callout_procedure),
181: decode(l_access_owner, FND_API.G_MISS_CHAR, NULL, l_access_owner),
182: decode(x_access_name, FND_API.G_MISS_CHAR, NULL, x_access_name),

Line 179: decode(x_force_complete_refresh,FND_API.G_MISS_CHAR,NULL, x_force_complete_refresh),

175: decode(x_query2,FND_API.G_MISS_CHAR,NULL, x_query2),
176: decode(x_online_query,FND_API.G_MISS_CHAR,NULL, x_online_query),
177: decode(x_inq_name,FND_API.G_MISS_CHAR,NULL, x_inq_name),
178: decode(L_inq_owner,FND_API.G_MISS_CHAR,NULL, L_inq_owner),
179: decode(x_force_complete_refresh,FND_API.G_MISS_CHAR,NULL, x_force_complete_refresh),
180: decode(x_callout_procedure,FND_API.G_MISS_CHAR,NULL, x_callout_procedure),
181: decode(l_access_owner, FND_API.G_MISS_CHAR, NULL, l_access_owner),
182: decode(x_access_name, FND_API.G_MISS_CHAR, NULL, x_access_name),
183: decode(x_APPLY_SYNCHRONOUS, FND_API.G_MISS_CHAR, NULL,x_APPLY_SYNCHRONOUS),

Line 180: decode(x_callout_procedure,FND_API.G_MISS_CHAR,NULL, x_callout_procedure),

176: decode(x_online_query,FND_API.G_MISS_CHAR,NULL, x_online_query),
177: decode(x_inq_name,FND_API.G_MISS_CHAR,NULL, x_inq_name),
178: decode(L_inq_owner,FND_API.G_MISS_CHAR,NULL, L_inq_owner),
179: decode(x_force_complete_refresh,FND_API.G_MISS_CHAR,NULL, x_force_complete_refresh),
180: decode(x_callout_procedure,FND_API.G_MISS_CHAR,NULL, x_callout_procedure),
181: decode(l_access_owner, FND_API.G_MISS_CHAR, NULL, l_access_owner),
182: decode(x_access_name, FND_API.G_MISS_CHAR, NULL, x_access_name),
183: decode(x_APPLY_SYNCHRONOUS, FND_API.G_MISS_CHAR, NULL,x_APPLY_SYNCHRONOUS),
184: decode(x_CALLOUT_PER_USER, FND_API.G_MISS_CHAR, NULL,x_CALLOUT_PER_USER),

Line 181: decode(l_access_owner, FND_API.G_MISS_CHAR, NULL, l_access_owner),

177: decode(x_inq_name,FND_API.G_MISS_CHAR,NULL, x_inq_name),
178: decode(L_inq_owner,FND_API.G_MISS_CHAR,NULL, L_inq_owner),
179: decode(x_force_complete_refresh,FND_API.G_MISS_CHAR,NULL, x_force_complete_refresh),
180: decode(x_callout_procedure,FND_API.G_MISS_CHAR,NULL, x_callout_procedure),
181: decode(l_access_owner, FND_API.G_MISS_CHAR, NULL, l_access_owner),
182: decode(x_access_name, FND_API.G_MISS_CHAR, NULL, x_access_name),
183: decode(x_APPLY_SYNCHRONOUS, FND_API.G_MISS_CHAR, NULL,x_APPLY_SYNCHRONOUS),
184: decode(x_CALLOUT_PER_USER, FND_API.G_MISS_CHAR, NULL,x_CALLOUT_PER_USER),
185: decode(x_COMPLETE_REFRESH_PUB_ITEMS, FND_API.G_MISS_CHAR, NULL,x_COMPLETE_REFRESH_PUB_ITEMS),

Line 182: decode(x_access_name, FND_API.G_MISS_CHAR, NULL, x_access_name),

178: decode(L_inq_owner,FND_API.G_MISS_CHAR,NULL, L_inq_owner),
179: decode(x_force_complete_refresh,FND_API.G_MISS_CHAR,NULL, x_force_complete_refresh),
180: decode(x_callout_procedure,FND_API.G_MISS_CHAR,NULL, x_callout_procedure),
181: decode(l_access_owner, FND_API.G_MISS_CHAR, NULL, l_access_owner),
182: decode(x_access_name, FND_API.G_MISS_CHAR, NULL, x_access_name),
183: decode(x_APPLY_SYNCHRONOUS, FND_API.G_MISS_CHAR, NULL,x_APPLY_SYNCHRONOUS),
184: decode(x_CALLOUT_PER_USER, FND_API.G_MISS_CHAR, NULL,x_CALLOUT_PER_USER),
185: decode(x_COMPLETE_REFRESH_PUB_ITEMS, FND_API.G_MISS_CHAR, NULL,x_COMPLETE_REFRESH_PUB_ITEMS),
186: decode(x_DETECT_CONFLICT, FND_API.G_MISS_CHAR, NULL,x_DETECT_CONFLICT),

Line 183: decode(x_APPLY_SYNCHRONOUS, FND_API.G_MISS_CHAR, NULL,x_APPLY_SYNCHRONOUS),

179: decode(x_force_complete_refresh,FND_API.G_MISS_CHAR,NULL, x_force_complete_refresh),
180: decode(x_callout_procedure,FND_API.G_MISS_CHAR,NULL, x_callout_procedure),
181: decode(l_access_owner, FND_API.G_MISS_CHAR, NULL, l_access_owner),
182: decode(x_access_name, FND_API.G_MISS_CHAR, NULL, x_access_name),
183: decode(x_APPLY_SYNCHRONOUS, FND_API.G_MISS_CHAR, NULL,x_APPLY_SYNCHRONOUS),
184: decode(x_CALLOUT_PER_USER, FND_API.G_MISS_CHAR, NULL,x_CALLOUT_PER_USER),
185: decode(x_COMPLETE_REFRESH_PUB_ITEMS, FND_API.G_MISS_CHAR, NULL,x_COMPLETE_REFRESH_PUB_ITEMS),
186: decode(x_DETECT_CONFLICT, FND_API.G_MISS_CHAR, NULL,x_DETECT_CONFLICT),
187: decode(x_CONFLICT_CALLOUT, FND_API.G_MISS_CHAR, NULL,x_CONFLICT_CALLOUT),

Line 184: decode(x_CALLOUT_PER_USER, FND_API.G_MISS_CHAR, NULL,x_CALLOUT_PER_USER),

180: decode(x_callout_procedure,FND_API.G_MISS_CHAR,NULL, x_callout_procedure),
181: decode(l_access_owner, FND_API.G_MISS_CHAR, NULL, l_access_owner),
182: decode(x_access_name, FND_API.G_MISS_CHAR, NULL, x_access_name),
183: decode(x_APPLY_SYNCHRONOUS, FND_API.G_MISS_CHAR, NULL,x_APPLY_SYNCHRONOUS),
184: decode(x_CALLOUT_PER_USER, FND_API.G_MISS_CHAR, NULL,x_CALLOUT_PER_USER),
185: decode(x_COMPLETE_REFRESH_PUB_ITEMS, FND_API.G_MISS_CHAR, NULL,x_COMPLETE_REFRESH_PUB_ITEMS),
186: decode(x_DETECT_CONFLICT, FND_API.G_MISS_CHAR, NULL,x_DETECT_CONFLICT),
187: decode(x_CONFLICT_CALLOUT, FND_API.G_MISS_CHAR, NULL,x_CONFLICT_CALLOUT),
188: decode(X_force_release_version,FND_API.G_MISS_NUM, NULL,x_force_release_version),

Line 185: decode(x_COMPLETE_REFRESH_PUB_ITEMS, FND_API.G_MISS_CHAR, NULL,x_COMPLETE_REFRESH_PUB_ITEMS),

181: decode(l_access_owner, FND_API.G_MISS_CHAR, NULL, l_access_owner),
182: decode(x_access_name, FND_API.G_MISS_CHAR, NULL, x_access_name),
183: decode(x_APPLY_SYNCHRONOUS, FND_API.G_MISS_CHAR, NULL,x_APPLY_SYNCHRONOUS),
184: decode(x_CALLOUT_PER_USER, FND_API.G_MISS_CHAR, NULL,x_CALLOUT_PER_USER),
185: decode(x_COMPLETE_REFRESH_PUB_ITEMS, FND_API.G_MISS_CHAR, NULL,x_COMPLETE_REFRESH_PUB_ITEMS),
186: decode(x_DETECT_CONFLICT, FND_API.G_MISS_CHAR, NULL,x_DETECT_CONFLICT),
187: decode(x_CONFLICT_CALLOUT, FND_API.G_MISS_CHAR, NULL,x_CONFLICT_CALLOUT),
188: decode(X_force_release_version,FND_API.G_MISS_NUM, NULL,x_force_release_version),
189: decode(X_alter_release_version,FND_API.G_MISS_NUM, NULL,x_alter_release_version),

Line 186: decode(x_DETECT_CONFLICT, FND_API.G_MISS_CHAR, NULL,x_DETECT_CONFLICT),

182: decode(x_access_name, FND_API.G_MISS_CHAR, NULL, x_access_name),
183: decode(x_APPLY_SYNCHRONOUS, FND_API.G_MISS_CHAR, NULL,x_APPLY_SYNCHRONOUS),
184: decode(x_CALLOUT_PER_USER, FND_API.G_MISS_CHAR, NULL,x_CALLOUT_PER_USER),
185: decode(x_COMPLETE_REFRESH_PUB_ITEMS, FND_API.G_MISS_CHAR, NULL,x_COMPLETE_REFRESH_PUB_ITEMS),
186: decode(x_DETECT_CONFLICT, FND_API.G_MISS_CHAR, NULL,x_DETECT_CONFLICT),
187: decode(x_CONFLICT_CALLOUT, FND_API.G_MISS_CHAR, NULL,x_CONFLICT_CALLOUT),
188: decode(X_force_release_version,FND_API.G_MISS_NUM, NULL,x_force_release_version),
189: decode(X_alter_release_version,FND_API.G_MISS_NUM, NULL,x_alter_release_version),
190: decode(x_QUERY_ACCESS_TABLE, FND_API.G_MISS_CHAR, NULL,x_QUERY_ACCESS_TABLE),

Line 187: decode(x_CONFLICT_CALLOUT, FND_API.G_MISS_CHAR, NULL,x_CONFLICT_CALLOUT),

183: decode(x_APPLY_SYNCHRONOUS, FND_API.G_MISS_CHAR, NULL,x_APPLY_SYNCHRONOUS),
184: decode(x_CALLOUT_PER_USER, FND_API.G_MISS_CHAR, NULL,x_CALLOUT_PER_USER),
185: decode(x_COMPLETE_REFRESH_PUB_ITEMS, FND_API.G_MISS_CHAR, NULL,x_COMPLETE_REFRESH_PUB_ITEMS),
186: decode(x_DETECT_CONFLICT, FND_API.G_MISS_CHAR, NULL,x_DETECT_CONFLICT),
187: decode(x_CONFLICT_CALLOUT, FND_API.G_MISS_CHAR, NULL,x_CONFLICT_CALLOUT),
188: decode(X_force_release_version,FND_API.G_MISS_NUM, NULL,x_force_release_version),
189: decode(X_alter_release_version,FND_API.G_MISS_NUM, NULL,x_alter_release_version),
190: decode(x_QUERY_ACCESS_TABLE, FND_API.G_MISS_CHAR, NULL,x_QUERY_ACCESS_TABLE),
191: decode(x_ACCESS_TABLE_PREDICATE_LIST, FND_API.G_MISS_CHAR, NULL,x_ACCESS_TABLE_PREDICATE_LIST),

Line 188: decode(X_force_release_version,FND_API.G_MISS_NUM, NULL,x_force_release_version),

184: decode(x_CALLOUT_PER_USER, FND_API.G_MISS_CHAR, NULL,x_CALLOUT_PER_USER),
185: decode(x_COMPLETE_REFRESH_PUB_ITEMS, FND_API.G_MISS_CHAR, NULL,x_COMPLETE_REFRESH_PUB_ITEMS),
186: decode(x_DETECT_CONFLICT, FND_API.G_MISS_CHAR, NULL,x_DETECT_CONFLICT),
187: decode(x_CONFLICT_CALLOUT, FND_API.G_MISS_CHAR, NULL,x_CONFLICT_CALLOUT),
188: decode(X_force_release_version,FND_API.G_MISS_NUM, NULL,x_force_release_version),
189: decode(X_alter_release_version,FND_API.G_MISS_NUM, NULL,x_alter_release_version),
190: decode(x_QUERY_ACCESS_TABLE, FND_API.G_MISS_CHAR, NULL,x_QUERY_ACCESS_TABLE),
191: decode(x_ACCESS_TABLE_PREDICATE_LIST, FND_API.G_MISS_CHAR, NULL,x_ACCESS_TABLE_PREDICATE_LIST),
192: nvl(x_ENABLE_DOWNLOAD_EVENTS, 'N'),

Line 189: decode(X_alter_release_version,FND_API.G_MISS_NUM, NULL,x_alter_release_version),

185: decode(x_COMPLETE_REFRESH_PUB_ITEMS, FND_API.G_MISS_CHAR, NULL,x_COMPLETE_REFRESH_PUB_ITEMS),
186: decode(x_DETECT_CONFLICT, FND_API.G_MISS_CHAR, NULL,x_DETECT_CONFLICT),
187: decode(x_CONFLICT_CALLOUT, FND_API.G_MISS_CHAR, NULL,x_CONFLICT_CALLOUT),
188: decode(X_force_release_version,FND_API.G_MISS_NUM, NULL,x_force_release_version),
189: decode(X_alter_release_version,FND_API.G_MISS_NUM, NULL,x_alter_release_version),
190: decode(x_QUERY_ACCESS_TABLE, FND_API.G_MISS_CHAR, NULL,x_QUERY_ACCESS_TABLE),
191: decode(x_ACCESS_TABLE_PREDICATE_LIST, FND_API.G_MISS_CHAR, NULL,x_ACCESS_TABLE_PREDICATE_LIST),
192: nvl(x_ENABLE_DOWNLOAD_EVENTS, 'N'),
193: decode(X_CREATION_DATE,FND_API.G_MISS_DATE, NULL, x_creation_date),

Line 190: decode(x_QUERY_ACCESS_TABLE, FND_API.G_MISS_CHAR, NULL,x_QUERY_ACCESS_TABLE),

186: decode(x_DETECT_CONFLICT, FND_API.G_MISS_CHAR, NULL,x_DETECT_CONFLICT),
187: decode(x_CONFLICT_CALLOUT, FND_API.G_MISS_CHAR, NULL,x_CONFLICT_CALLOUT),
188: decode(X_force_release_version,FND_API.G_MISS_NUM, NULL,x_force_release_version),
189: decode(X_alter_release_version,FND_API.G_MISS_NUM, NULL,x_alter_release_version),
190: decode(x_QUERY_ACCESS_TABLE, FND_API.G_MISS_CHAR, NULL,x_QUERY_ACCESS_TABLE),
191: decode(x_ACCESS_TABLE_PREDICATE_LIST, FND_API.G_MISS_CHAR, NULL,x_ACCESS_TABLE_PREDICATE_LIST),
192: nvl(x_ENABLE_DOWNLOAD_EVENTS, 'N'),
193: decode(X_CREATION_DATE,FND_API.G_MISS_DATE, NULL, x_creation_date),
194: decode(X_CREATED_BY,FND_API.G_MISS_NUM, NULL,x_created_by),

Line 191: decode(x_ACCESS_TABLE_PREDICATE_LIST, FND_API.G_MISS_CHAR, NULL,x_ACCESS_TABLE_PREDICATE_LIST),

187: decode(x_CONFLICT_CALLOUT, FND_API.G_MISS_CHAR, NULL,x_CONFLICT_CALLOUT),
188: decode(X_force_release_version,FND_API.G_MISS_NUM, NULL,x_force_release_version),
189: decode(X_alter_release_version,FND_API.G_MISS_NUM, NULL,x_alter_release_version),
190: decode(x_QUERY_ACCESS_TABLE, FND_API.G_MISS_CHAR, NULL,x_QUERY_ACCESS_TABLE),
191: decode(x_ACCESS_TABLE_PREDICATE_LIST, FND_API.G_MISS_CHAR, NULL,x_ACCESS_TABLE_PREDICATE_LIST),
192: nvl(x_ENABLE_DOWNLOAD_EVENTS, 'N'),
193: decode(X_CREATION_DATE,FND_API.G_MISS_DATE, NULL, x_creation_date),
194: decode(X_CREATED_BY,FND_API.G_MISS_NUM, NULL,x_created_by),
195: decode(X_LAST_UPDATE_DATE,FND_API.G_MISS_DATE, NULL, x_last_update_date),

Line 193: decode(X_CREATION_DATE,FND_API.G_MISS_DATE, NULL, x_creation_date),

189: decode(X_alter_release_version,FND_API.G_MISS_NUM, NULL,x_alter_release_version),
190: decode(x_QUERY_ACCESS_TABLE, FND_API.G_MISS_CHAR, NULL,x_QUERY_ACCESS_TABLE),
191: decode(x_ACCESS_TABLE_PREDICATE_LIST, FND_API.G_MISS_CHAR, NULL,x_ACCESS_TABLE_PREDICATE_LIST),
192: nvl(x_ENABLE_DOWNLOAD_EVENTS, 'N'),
193: decode(X_CREATION_DATE,FND_API.G_MISS_DATE, NULL, x_creation_date),
194: decode(X_CREATED_BY,FND_API.G_MISS_NUM, NULL,x_created_by),
195: decode(X_LAST_UPDATE_DATE,FND_API.G_MISS_DATE, NULL, x_last_update_date),
196: decode(X_LAST_UPDATED_BY,FND_API.G_MISS_NUM, NULL,x_last_updated_by)
197: );

Line 194: decode(X_CREATED_BY,FND_API.G_MISS_NUM, NULL,x_created_by),

190: decode(x_QUERY_ACCESS_TABLE, FND_API.G_MISS_CHAR, NULL,x_QUERY_ACCESS_TABLE),
191: decode(x_ACCESS_TABLE_PREDICATE_LIST, FND_API.G_MISS_CHAR, NULL,x_ACCESS_TABLE_PREDICATE_LIST),
192: nvl(x_ENABLE_DOWNLOAD_EVENTS, 'N'),
193: decode(X_CREATION_DATE,FND_API.G_MISS_DATE, NULL, x_creation_date),
194: decode(X_CREATED_BY,FND_API.G_MISS_NUM, NULL,x_created_by),
195: decode(X_LAST_UPDATE_DATE,FND_API.G_MISS_DATE, NULL, x_last_update_date),
196: decode(X_LAST_UPDATED_BY,FND_API.G_MISS_NUM, NULL,x_last_updated_by)
197: );
198:

Line 195: decode(X_LAST_UPDATE_DATE,FND_API.G_MISS_DATE, NULL, x_last_update_date),

191: decode(x_ACCESS_TABLE_PREDICATE_LIST, FND_API.G_MISS_CHAR, NULL,x_ACCESS_TABLE_PREDICATE_LIST),
192: nvl(x_ENABLE_DOWNLOAD_EVENTS, 'N'),
193: decode(X_CREATION_DATE,FND_API.G_MISS_DATE, NULL, x_creation_date),
194: decode(X_CREATED_BY,FND_API.G_MISS_NUM, NULL,x_created_by),
195: decode(X_LAST_UPDATE_DATE,FND_API.G_MISS_DATE, NULL, x_last_update_date),
196: decode(X_LAST_UPDATED_BY,FND_API.G_MISS_NUM, NULL,x_last_updated_by)
197: );
198:
199: /*

Line 196: decode(X_LAST_UPDATED_BY,FND_API.G_MISS_NUM, NULL,x_last_updated_by)

192: nvl(x_ENABLE_DOWNLOAD_EVENTS, 'N'),
193: decode(X_CREATION_DATE,FND_API.G_MISS_DATE, NULL, x_creation_date),
194: decode(X_CREATED_BY,FND_API.G_MISS_NUM, NULL,x_created_by),
195: decode(X_LAST_UPDATE_DATE,FND_API.G_MISS_DATE, NULL, x_last_update_date),
196: decode(X_LAST_UPDATED_BY,FND_API.G_MISS_NUM, NULL,x_last_updated_by)
197: );
198:
199: /*
200: open c;