eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ASG_PUB_ITEM_PKG dependencies on FND_API

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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