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),
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),
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),
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),
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),
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),
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',
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,
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),
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,
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),
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),
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),
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),
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),
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),
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),
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),
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),
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),
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),
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),
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),
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),
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),
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),
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),
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),
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),
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),
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),
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),
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'),
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),
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),
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),
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: );
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:
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: /*
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;