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_PKG dependencies on FND_API

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

60: LAST_UPDATE_DATE,
61: LAST_UPDATED_BY
62: ) values (
63: x_pub_id,
64: decode(X_NAME,FND_API.G_MISS_CHAR, NULL, x_NAME),
65: decode(X_ENABLED, FND_API.G_MISS_CHAR, NULL, x_ENABLED),
66: 'N',
67: 0,
68: decode(x_CURRENT_release_version,FND_API.G_MISS_NUM, NULL, x_CURRENT_RELEASE_VERSION),

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

61: LAST_UPDATED_BY
62: ) values (
63: x_pub_id,
64: decode(X_NAME,FND_API.G_MISS_CHAR, NULL, x_NAME),
65: decode(X_ENABLED, FND_API.G_MISS_CHAR, NULL, x_ENABLED),
66: 'N',
67: 0,
68: decode(x_CURRENT_release_version,FND_API.G_MISS_NUM, NULL, x_CURRENT_RELEASE_VERSION),
69: decode(X_WRAPPER_NAME,FND_API.G_MISS_CHAR, NULL, x_wrapper_name),

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

64: decode(X_NAME,FND_API.G_MISS_CHAR, NULL, x_NAME),
65: decode(X_ENABLED, FND_API.G_MISS_CHAR, NULL, x_ENABLED),
66: 'N',
67: 0,
68: decode(x_CURRENT_release_version,FND_API.G_MISS_NUM, NULL, x_CURRENT_RELEASE_VERSION),
69: decode(X_WRAPPER_NAME,FND_API.G_MISS_CHAR, NULL, x_wrapper_name),
70: x_device_Type,
71: 'Y',
72: decode(X_NEED_RESOURCEID, FND_API.G_MISS_CHAR, NULL, x_NEED_RESOURCEID),

Line 69: decode(X_WRAPPER_NAME,FND_API.G_MISS_CHAR, NULL, x_wrapper_name),

65: decode(X_ENABLED, FND_API.G_MISS_CHAR, NULL, x_ENABLED),
66: 'N',
67: 0,
68: decode(x_CURRENT_release_version,FND_API.G_MISS_NUM, NULL, x_CURRENT_RELEASE_VERSION),
69: decode(X_WRAPPER_NAME,FND_API.G_MISS_CHAR, NULL, x_wrapper_name),
70: x_device_Type,
71: 'Y',
72: decode(X_NEED_RESOURCEID, FND_API.G_MISS_CHAR, NULL, x_NEED_RESOURCEID),
73: decode(X_CUSTOM, FND_API.G_MISS_CHAR, NULL, x_CUSTOM),

Line 72: decode(X_NEED_RESOURCEID, FND_API.G_MISS_CHAR, NULL, x_NEED_RESOURCEID),

68: decode(x_CURRENT_release_version,FND_API.G_MISS_NUM, NULL, x_CURRENT_RELEASE_VERSION),
69: decode(X_WRAPPER_NAME,FND_API.G_MISS_CHAR, NULL, x_wrapper_name),
70: x_device_Type,
71: 'Y',
72: decode(X_NEED_RESOURCEID, FND_API.G_MISS_CHAR, NULL, x_NEED_RESOURCEID),
73: decode(X_CUSTOM, FND_API.G_MISS_CHAR, NULL, x_CUSTOM),
74: decode(X_SHARED_BY, FND_API.G_MISS_CHAR, NULL, x_SHARED_BY),
75: decode(X_ADDITIONAL_DEVICE_TYPE, FND_API.G_MISS_CHAR, NULL, x_ADDITIONAL_DEVICE_TYPE),
76: decode(X_CREATION_DATE,FND_API.G_MISS_DATE, NULL, x_creation_date),

Line 73: decode(X_CUSTOM, FND_API.G_MISS_CHAR, NULL, x_CUSTOM),

69: decode(X_WRAPPER_NAME,FND_API.G_MISS_CHAR, NULL, x_wrapper_name),
70: x_device_Type,
71: 'Y',
72: decode(X_NEED_RESOURCEID, FND_API.G_MISS_CHAR, NULL, x_NEED_RESOURCEID),
73: decode(X_CUSTOM, FND_API.G_MISS_CHAR, NULL, x_CUSTOM),
74: decode(X_SHARED_BY, FND_API.G_MISS_CHAR, NULL, x_SHARED_BY),
75: decode(X_ADDITIONAL_DEVICE_TYPE, FND_API.G_MISS_CHAR, NULL, x_ADDITIONAL_DEVICE_TYPE),
76: decode(X_CREATION_DATE,FND_API.G_MISS_DATE, NULL, x_creation_date),
77: decode(X_CREATED_BY,FND_API.G_MISS_NUM, NULL,x_created_by),

Line 74: decode(X_SHARED_BY, FND_API.G_MISS_CHAR, NULL, x_SHARED_BY),

70: x_device_Type,
71: 'Y',
72: decode(X_NEED_RESOURCEID, FND_API.G_MISS_CHAR, NULL, x_NEED_RESOURCEID),
73: decode(X_CUSTOM, FND_API.G_MISS_CHAR, NULL, x_CUSTOM),
74: decode(X_SHARED_BY, FND_API.G_MISS_CHAR, NULL, x_SHARED_BY),
75: decode(X_ADDITIONAL_DEVICE_TYPE, FND_API.G_MISS_CHAR, NULL, x_ADDITIONAL_DEVICE_TYPE),
76: decode(X_CREATION_DATE,FND_API.G_MISS_DATE, NULL, x_creation_date),
77: decode(X_CREATED_BY,FND_API.G_MISS_NUM, NULL,x_created_by),
78: decode(X_LAST_UPDATE_DATE,FND_API.G_MISS_DATE, NULL, x_last_update_date),

Line 75: decode(X_ADDITIONAL_DEVICE_TYPE, FND_API.G_MISS_CHAR, NULL, x_ADDITIONAL_DEVICE_TYPE),

71: 'Y',
72: decode(X_NEED_RESOURCEID, FND_API.G_MISS_CHAR, NULL, x_NEED_RESOURCEID),
73: decode(X_CUSTOM, FND_API.G_MISS_CHAR, NULL, x_CUSTOM),
74: decode(X_SHARED_BY, FND_API.G_MISS_CHAR, NULL, x_SHARED_BY),
75: decode(X_ADDITIONAL_DEVICE_TYPE, FND_API.G_MISS_CHAR, NULL, x_ADDITIONAL_DEVICE_TYPE),
76: decode(X_CREATION_DATE,FND_API.G_MISS_DATE, NULL, x_creation_date),
77: decode(X_CREATED_BY,FND_API.G_MISS_NUM, NULL,x_created_by),
78: decode(X_LAST_UPDATE_DATE,FND_API.G_MISS_DATE, NULL, x_last_update_date),
79: decode(X_LAST_UPDATED_BY,FND_API.G_MISS_NUM, NULL,x_last_updated_by)

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

72: decode(X_NEED_RESOURCEID, FND_API.G_MISS_CHAR, NULL, x_NEED_RESOURCEID),
73: decode(X_CUSTOM, FND_API.G_MISS_CHAR, NULL, x_CUSTOM),
74: decode(X_SHARED_BY, FND_API.G_MISS_CHAR, NULL, x_SHARED_BY),
75: decode(X_ADDITIONAL_DEVICE_TYPE, FND_API.G_MISS_CHAR, NULL, x_ADDITIONAL_DEVICE_TYPE),
76: decode(X_CREATION_DATE,FND_API.G_MISS_DATE, NULL, x_creation_date),
77: decode(X_CREATED_BY,FND_API.G_MISS_NUM, NULL,x_created_by),
78: decode(X_LAST_UPDATE_DATE,FND_API.G_MISS_DATE, NULL, x_last_update_date),
79: decode(X_LAST_UPDATED_BY,FND_API.G_MISS_NUM, NULL,x_last_updated_by)
80: );

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

73: decode(X_CUSTOM, FND_API.G_MISS_CHAR, NULL, x_CUSTOM),
74: decode(X_SHARED_BY, FND_API.G_MISS_CHAR, NULL, x_SHARED_BY),
75: decode(X_ADDITIONAL_DEVICE_TYPE, FND_API.G_MISS_CHAR, NULL, x_ADDITIONAL_DEVICE_TYPE),
76: decode(X_CREATION_DATE,FND_API.G_MISS_DATE, NULL, x_creation_date),
77: decode(X_CREATED_BY,FND_API.G_MISS_NUM, NULL,x_created_by),
78: decode(X_LAST_UPDATE_DATE,FND_API.G_MISS_DATE, NULL, x_last_update_date),
79: decode(X_LAST_UPDATED_BY,FND_API.G_MISS_NUM, NULL,x_last_updated_by)
80: );
81:

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

74: decode(X_SHARED_BY, FND_API.G_MISS_CHAR, NULL, x_SHARED_BY),
75: decode(X_ADDITIONAL_DEVICE_TYPE, FND_API.G_MISS_CHAR, NULL, x_ADDITIONAL_DEVICE_TYPE),
76: decode(X_CREATION_DATE,FND_API.G_MISS_DATE, NULL, x_creation_date),
77: decode(X_CREATED_BY,FND_API.G_MISS_NUM, NULL,x_created_by),
78: decode(X_LAST_UPDATE_DATE,FND_API.G_MISS_DATE, NULL, x_last_update_date),
79: decode(X_LAST_UPDATED_BY,FND_API.G_MISS_NUM, NULL,x_last_updated_by)
80: );
81:
82: /*

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

75: decode(X_ADDITIONAL_DEVICE_TYPE, FND_API.G_MISS_CHAR, NULL, x_ADDITIONAL_DEVICE_TYPE),
76: decode(X_CREATION_DATE,FND_API.G_MISS_DATE, NULL, x_creation_date),
77: decode(X_CREATED_BY,FND_API.G_MISS_NUM, NULL,x_created_by),
78: decode(X_LAST_UPDATE_DATE,FND_API.G_MISS_DATE, NULL, x_last_update_date),
79: decode(X_LAST_UPDATED_BY,FND_API.G_MISS_NUM, NULL,x_last_updated_by)
80: );
81:
82: /*
83: open c;