38: LAST_UPDATE_DATE,
39: LAST_UPDATED_BY
40: ) values (
41: x_index_id,
42: decode(X_ITEM_ID,FND_API.G_MISS_CHAR, NULL, x_ITEM_ID),
43: decode(X_INDEX_NAME, FND_API.G_MISS_CHAR, NULL, X_INDEX_NAME),
44: decode(X_ENABLED, FND_API.G_MISS_CHAR, NULL, x_ENABLED),
45: 'N',
46: decode(X_PMOD, FND_API.G_MISS_CHAR, NULL, X_PMOD),
39: LAST_UPDATED_BY
40: ) values (
41: x_index_id,
42: decode(X_ITEM_ID,FND_API.G_MISS_CHAR, NULL, x_ITEM_ID),
43: decode(X_INDEX_NAME, FND_API.G_MISS_CHAR, NULL, X_INDEX_NAME),
44: decode(X_ENABLED, FND_API.G_MISS_CHAR, NULL, x_ENABLED),
45: 'N',
46: decode(X_PMOD, FND_API.G_MISS_CHAR, NULL, X_PMOD),
47: x_INDEX_COLUMNS,
40: ) values (
41: x_index_id,
42: decode(X_ITEM_ID,FND_API.G_MISS_CHAR, NULL, x_ITEM_ID),
43: decode(X_INDEX_NAME, FND_API.G_MISS_CHAR, NULL, X_INDEX_NAME),
44: decode(X_ENABLED, FND_API.G_MISS_CHAR, NULL, x_ENABLED),
45: 'N',
46: decode(X_PMOD, FND_API.G_MISS_CHAR, NULL, X_PMOD),
47: x_INDEX_COLUMNS,
48: -- decode(X_INDEX_COLUMNS,FND_API.G_MISS_CHAR, NULL, x_INDEX_COLUMNS),
42: decode(X_ITEM_ID,FND_API.G_MISS_CHAR, NULL, x_ITEM_ID),
43: decode(X_INDEX_NAME, FND_API.G_MISS_CHAR, NULL, X_INDEX_NAME),
44: decode(X_ENABLED, FND_API.G_MISS_CHAR, NULL, x_ENABLED),
45: 'N',
46: decode(X_PMOD, FND_API.G_MISS_CHAR, NULL, X_PMOD),
47: x_INDEX_COLUMNS,
48: -- decode(X_INDEX_COLUMNS,FND_API.G_MISS_CHAR, NULL, x_INDEX_COLUMNS),
49: 0,
50: decode(x_CURRENT_release_version,FND_API.G_MISS_NUM, NULL, x_CURRENT_RELEASE_VERSION),
44: decode(X_ENABLED, FND_API.G_MISS_CHAR, NULL, x_ENABLED),
45: 'N',
46: decode(X_PMOD, FND_API.G_MISS_CHAR, NULL, X_PMOD),
47: x_INDEX_COLUMNS,
48: -- decode(X_INDEX_COLUMNS,FND_API.G_MISS_CHAR, NULL, x_INDEX_COLUMNS),
49: 0,
50: decode(x_CURRENT_release_version,FND_API.G_MISS_NUM, NULL, x_CURRENT_RELEASE_VERSION),
51: decode(X_CREATION_DATE,FND_API.G_MISS_DATE, NULL, x_creation_date),
52: decode(X_CREATED_BY,FND_API.G_MISS_NUM, NULL,x_created_by),
46: decode(X_PMOD, FND_API.G_MISS_CHAR, NULL, X_PMOD),
47: x_INDEX_COLUMNS,
48: -- decode(X_INDEX_COLUMNS,FND_API.G_MISS_CHAR, NULL, x_INDEX_COLUMNS),
49: 0,
50: decode(x_CURRENT_release_version,FND_API.G_MISS_NUM, NULL, x_CURRENT_RELEASE_VERSION),
51: decode(X_CREATION_DATE,FND_API.G_MISS_DATE, NULL, x_creation_date),
52: decode(X_CREATED_BY,FND_API.G_MISS_NUM, NULL,x_created_by),
53: decode(X_LAST_UPDATE_DATE,FND_API.G_MISS_DATE, NULL, x_last_update_date),
54: decode(X_LAST_UPDATED_BY,FND_API.G_MISS_NUM, NULL,x_last_updated_by)
47: x_INDEX_COLUMNS,
48: -- decode(X_INDEX_COLUMNS,FND_API.G_MISS_CHAR, NULL, x_INDEX_COLUMNS),
49: 0,
50: decode(x_CURRENT_release_version,FND_API.G_MISS_NUM, NULL, x_CURRENT_RELEASE_VERSION),
51: decode(X_CREATION_DATE,FND_API.G_MISS_DATE, NULL, x_creation_date),
52: decode(X_CREATED_BY,FND_API.G_MISS_NUM, NULL,x_created_by),
53: decode(X_LAST_UPDATE_DATE,FND_API.G_MISS_DATE, NULL, x_last_update_date),
54: decode(X_LAST_UPDATED_BY,FND_API.G_MISS_NUM, NULL,x_last_updated_by)
55: );
48: -- decode(X_INDEX_COLUMNS,FND_API.G_MISS_CHAR, NULL, x_INDEX_COLUMNS),
49: 0,
50: decode(x_CURRENT_release_version,FND_API.G_MISS_NUM, NULL, x_CURRENT_RELEASE_VERSION),
51: decode(X_CREATION_DATE,FND_API.G_MISS_DATE, NULL, x_creation_date),
52: decode(X_CREATED_BY,FND_API.G_MISS_NUM, NULL,x_created_by),
53: decode(X_LAST_UPDATE_DATE,FND_API.G_MISS_DATE, NULL, x_last_update_date),
54: decode(X_LAST_UPDATED_BY,FND_API.G_MISS_NUM, NULL,x_last_updated_by)
55: );
56:
49: 0,
50: decode(x_CURRENT_release_version,FND_API.G_MISS_NUM, NULL, x_CURRENT_RELEASE_VERSION),
51: decode(X_CREATION_DATE,FND_API.G_MISS_DATE, NULL, x_creation_date),
52: decode(X_CREATED_BY,FND_API.G_MISS_NUM, NULL,x_created_by),
53: decode(X_LAST_UPDATE_DATE,FND_API.G_MISS_DATE, NULL, x_last_update_date),
54: decode(X_LAST_UPDATED_BY,FND_API.G_MISS_NUM, NULL,x_last_updated_by)
55: );
56:
57:
50: decode(x_CURRENT_release_version,FND_API.G_MISS_NUM, NULL, x_CURRENT_RELEASE_VERSION),
51: decode(X_CREATION_DATE,FND_API.G_MISS_DATE, NULL, x_creation_date),
52: decode(X_CREATED_BY,FND_API.G_MISS_NUM, NULL,x_created_by),
53: decode(X_LAST_UPDATE_DATE,FND_API.G_MISS_DATE, NULL, x_last_update_date),
54: decode(X_LAST_UPDATED_BY,FND_API.G_MISS_NUM, NULL,x_last_updated_by)
55: );
56:
57:
58: end insert_row;