DBA Data[Home] [Help]

APPS.OZF_OFFER_ADJUSTMENT_PKG dependencies on FND_GLOBAL

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

118: p_list_header_id,
119: p_version,
120: p_budget_adjusted_flag,
121: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
122: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
123: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
124: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
125: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
126: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),

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

120: p_budget_adjusted_flag,
121: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
122: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
123: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
124: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
125: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
126: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
127: p_attribute1,
128: p_attribute2,

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

121: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
122: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
123: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
124: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
125: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
126: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
127: p_attribute1,
128: p_attribute2,
129: p_attribute3,

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

155: SELECT
156: px_offer_adjustment_id,
157: l.language_code,
158: DECODE( p_last_update_date, to_date(NULL), SYSDATE, p_last_update_date),
159: DECODE( p_last_updated_by, NULL, FND_GLOBAL.USER_ID, p_last_updated_by),
160: DECODE( p_creation_date, to_date(NULL), SYSDATE, p_creation_date),
161: DECODE( p_created_by, NULL, FND_GLOBAL.USER_ID, p_created_by),
162: DECODE( p_last_update_login, NULL, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
163: USERENV('LANG'),

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

157: l.language_code,
158: DECODE( p_last_update_date, to_date(NULL), SYSDATE, p_last_update_date),
159: DECODE( p_last_updated_by, NULL, FND_GLOBAL.USER_ID, p_last_updated_by),
160: DECODE( p_creation_date, to_date(NULL), SYSDATE, p_creation_date),
161: DECODE( p_created_by, NULL, FND_GLOBAL.USER_ID, p_created_by),
162: DECODE( p_last_update_login, NULL, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
163: USERENV('LANG'),
164: p_offer_adjustment_name,
165: p_description

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

158: DECODE( p_last_update_date, to_date(NULL), SYSDATE, p_last_update_date),
159: DECODE( p_last_updated_by, NULL, FND_GLOBAL.USER_ID, p_last_updated_by),
160: DECODE( p_creation_date, to_date(NULL), SYSDATE, p_creation_date),
161: DECODE( p_created_by, NULL, FND_GLOBAL.USER_ID, p_created_by),
162: DECODE( p_last_update_login, NULL, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
163: USERENV('LANG'),
164: p_offer_adjustment_name,
165: p_description
166: FROM fnd_languages l