APPS.ASG_ITEM_INDEX_PKG dependencies on FND_API

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

39: LAST_UPDATE_DATE,
40: LAST_UPDATED_BY
41: ) values (
42: x_index_id,
43: decode(X_ITEM_ID,FND_API.G_MISS_CHAR, NULL, x_ITEM_ID),
44: decode(X_INDEX_NAME, FND_API.G_MISS_CHAR, NULL, X_INDEX_NAME),
45: decode(X_ENABLED, FND_API.G_MISS_CHAR, NULL, x_ENABLED),
46: 'N',
47: decode(X_PMOD, FND_API.G_MISS_CHAR, NULL, X_PMOD),

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

40: LAST_UPDATED_BY
41: ) values (
42: x_index_id,
43: decode(X_ITEM_ID,FND_API.G_MISS_CHAR, NULL, x_ITEM_ID),
44: decode(X_INDEX_NAME, FND_API.G_MISS_CHAR, NULL, X_INDEX_NAME),
45: decode(X_ENABLED, FND_API.G_MISS_CHAR, NULL, x_ENABLED),
46: 'N',
47: decode(X_PMOD, FND_API.G_MISS_CHAR, NULL, X_PMOD),
48: x_INDEX_COLUMNS,

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

41: ) values (
42: x_index_id,
43: decode(X_ITEM_ID,FND_API.G_MISS_CHAR, NULL, x_ITEM_ID),
44: decode(X_INDEX_NAME, FND_API.G_MISS_CHAR, NULL, X_INDEX_NAME),
45: decode(X_ENABLED, FND_API.G_MISS_CHAR, NULL, x_ENABLED),
46: 'N',
47: decode(X_PMOD, FND_API.G_MISS_CHAR, NULL, X_PMOD),
48: x_INDEX_COLUMNS,
49: -- decode(X_INDEX_COLUMNS,FND_API.G_MISS_CHAR, NULL, x_INDEX_COLUMNS),

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

43: decode(X_ITEM_ID,FND_API.G_MISS_CHAR, NULL, x_ITEM_ID),
44: decode(X_INDEX_NAME, FND_API.G_MISS_CHAR, NULL, X_INDEX_NAME),
45: decode(X_ENABLED, FND_API.G_MISS_CHAR, NULL, x_ENABLED),
46: 'N',
47: decode(X_PMOD, FND_API.G_MISS_CHAR, NULL, X_PMOD),
48: x_INDEX_COLUMNS,
49: -- decode(X_INDEX_COLUMNS,FND_API.G_MISS_CHAR, NULL, x_INDEX_COLUMNS),
50: 0,
51: decode(x_CURRENT_release_version,FND_API.G_MISS_NUM, NULL, x_CURRENT_RELEASE_VERSION),

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

45: decode(X_ENABLED, FND_API.G_MISS_CHAR, NULL, x_ENABLED),
46: 'N',
47: decode(X_PMOD, FND_API.G_MISS_CHAR, NULL, X_PMOD),
48: x_INDEX_COLUMNS,
49: -- decode(X_INDEX_COLUMNS,FND_API.G_MISS_CHAR, NULL, x_INDEX_COLUMNS),
50: 0,
51: decode(x_CURRENT_release_version,FND_API.G_MISS_NUM, NULL, x_CURRENT_RELEASE_VERSION),
52: decode(X_CREATION_DATE,FND_API.G_MISS_DATE, NULL, x_creation_date),
53: decode(X_CREATED_BY,FND_API.G_MISS_NUM, NULL,x_created_by),

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

47: decode(X_PMOD, FND_API.G_MISS_CHAR, NULL, X_PMOD),
48: x_INDEX_COLUMNS,
49: -- decode(X_INDEX_COLUMNS,FND_API.G_MISS_CHAR, NULL, x_INDEX_COLUMNS),
50: 0,
51: decode(x_CURRENT_release_version,FND_API.G_MISS_NUM, NULL, x_CURRENT_RELEASE_VERSION),
52: decode(X_CREATION_DATE,FND_API.G_MISS_DATE, NULL, x_creation_date),
53: decode(X_CREATED_BY,FND_API.G_MISS_NUM, NULL,x_created_by),
54: decode(X_LAST_UPDATE_DATE,FND_API.G_MISS_DATE, NULL, x_last_update_date),
55: decode(X_LAST_UPDATED_BY,FND_API.G_MISS_NUM, NULL,x_last_updated_by)

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

48: x_INDEX_COLUMNS,
49: -- decode(X_INDEX_COLUMNS,FND_API.G_MISS_CHAR, NULL, x_INDEX_COLUMNS),
50: 0,
51: decode(x_CURRENT_release_version,FND_API.G_MISS_NUM, NULL, x_CURRENT_RELEASE_VERSION),
52: decode(X_CREATION_DATE,FND_API.G_MISS_DATE, NULL, x_creation_date),
53: decode(X_CREATED_BY,FND_API.G_MISS_NUM, NULL,x_created_by),
54: decode(X_LAST_UPDATE_DATE,FND_API.G_MISS_DATE, NULL, x_last_update_date),
55: decode(X_LAST_UPDATED_BY,FND_API.G_MISS_NUM, NULL,x_last_updated_by)
56: );

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

49: -- decode(X_INDEX_COLUMNS,FND_API.G_MISS_CHAR, NULL, x_INDEX_COLUMNS),
50: 0,
51: decode(x_CURRENT_release_version,FND_API.G_MISS_NUM, NULL, x_CURRENT_RELEASE_VERSION),
52: decode(X_CREATION_DATE,FND_API.G_MISS_DATE, NULL, x_creation_date),
53: decode(X_CREATED_BY,FND_API.G_MISS_NUM, NULL,x_created_by),
54: decode(X_LAST_UPDATE_DATE,FND_API.G_MISS_DATE, NULL, x_last_update_date),
55: decode(X_LAST_UPDATED_BY,FND_API.G_MISS_NUM, NULL,x_last_updated_by)
56: );
57:

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

50: 0,
51: decode(x_CURRENT_release_version,FND_API.G_MISS_NUM, NULL, x_CURRENT_RELEASE_VERSION),
52: decode(X_CREATION_DATE,FND_API.G_MISS_DATE, NULL, x_creation_date),
53: decode(X_CREATED_BY,FND_API.G_MISS_NUM, NULL,x_created_by),
54: decode(X_LAST_UPDATE_DATE,FND_API.G_MISS_DATE, NULL, x_last_update_date),
55: decode(X_LAST_UPDATED_BY,FND_API.G_MISS_NUM, NULL,x_last_updated_by)
56: );
57:
58: BEGIN

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

51: decode(x_CURRENT_release_version,FND_API.G_MISS_NUM, NULL, x_CURRENT_RELEASE_VERSION),
52: decode(X_CREATION_DATE,FND_API.G_MISS_DATE, NULL, x_creation_date),
53: decode(X_CREATED_BY,FND_API.G_MISS_NUM, NULL,x_created_by),
54: decode(X_LAST_UPDATE_DATE,FND_API.G_MISS_DATE, NULL, x_last_update_date),
55: decode(X_LAST_UPDATED_BY,FND_API.G_MISS_NUM, NULL,x_last_updated_by)
56: );
57:
58: BEGIN
59: SELECT 'Y' INTO l_multi_plat FROM ASG_PUB_ITEM WHERE ITEM_ID=x_ITEM_ID AND HTML5_OFFLINE='Y';