DBA Data[Home] [Help]

APPS.ASG_ITEM_INDEX_PKG dependencies on FND_API

Line 42: decode(X_ITEM_ID,FND_API.G_MISS_CHAR, NULL, x_ITEM_ID),

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),

Line 43: decode(X_INDEX_NAME, FND_API.G_MISS_CHAR, NULL, X_INDEX_NAME),

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,

Line 44: decode(X_ENABLED, FND_API.G_MISS_CHAR, NULL, x_ENABLED),

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),

Line 46: decode(X_PMOD, FND_API.G_MISS_CHAR, NULL, X_PMOD),

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),

Line 48: -- decode(X_INDEX_COLUMNS,FND_API.G_MISS_CHAR, NULL, x_INDEX_COLUMNS),

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),

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

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)

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

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: );

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

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:

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

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:

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

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;