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.OZF_VO_DISC_STRUCT_NAME_PKG dependencies on FND_GLOBAL

Line 131: , DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by)

127: px_offr_disc_struct_name_id
128: , p_offer_discount_line_id
129: , DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number)
130: , DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date)
131: , DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by)
132: , DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by)
133: , DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date)
134: , DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login)
135: );

Line 132: , DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by)

128: , p_offer_discount_line_id
129: , DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number)
130: , DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date)
131: , DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by)
132: , DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by)
133: , DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date)
134: , DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login)
135: );
136:

Line 134: , DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login)

130: , DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date)
131: , DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by)
132: , DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by)
133: , DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date)
134: , DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login)
135: );
136:
137: INSERT INTO ozf_offr_disc_struct_name_tl(
138: offr_disc_struct_name_id

Line 153: , DECODE( p_last_updated_by, NULL, FND_GLOBAL.USER_ID, p_last_updated_by)

149: SELECT
150: px_offr_disc_struct_name_id
151: , l.language_code
152: , DECODE( p_last_update_date, to_date(NULL), SYSDATE, p_last_update_date)
153: , DECODE( p_last_updated_by, NULL, FND_GLOBAL.USER_ID, p_last_updated_by)
154: , DECODE( p_creation_date, to_date(NULL), SYSDATE, p_creation_date)
155: , DECODE( p_created_by, NULL, FND_GLOBAL.USER_ID, p_created_by)
156: , DECODE( p_last_update_login, NULL, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login)
157: , USERENV('LANG')

Line 155: , DECODE( p_created_by, NULL, FND_GLOBAL.USER_ID, p_created_by)

151: , l.language_code
152: , DECODE( p_last_update_date, to_date(NULL), SYSDATE, p_last_update_date)
153: , DECODE( p_last_updated_by, NULL, FND_GLOBAL.USER_ID, p_last_updated_by)
154: , DECODE( p_creation_date, to_date(NULL), SYSDATE, p_creation_date)
155: , DECODE( p_created_by, NULL, FND_GLOBAL.USER_ID, p_created_by)
156: , DECODE( p_last_update_login, NULL, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login)
157: , USERENV('LANG')
158: , p_name
159: , p_description

Line 156: , DECODE( p_last_update_login, NULL, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login)

152: , DECODE( p_last_update_date, to_date(NULL), SYSDATE, p_last_update_date)
153: , DECODE( p_last_updated_by, NULL, FND_GLOBAL.USER_ID, p_last_updated_by)
154: , DECODE( p_creation_date, to_date(NULL), SYSDATE, p_creation_date)
155: , DECODE( p_created_by, NULL, FND_GLOBAL.USER_ID, p_created_by)
156: , DECODE( p_last_update_login, NULL, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login)
157: , USERENV('LANG')
158: , p_name
159: , p_description
160: FROM fnd_languages l