APPS.IBE_MSITE_RESP_PKG dependencies on FND_GLOBAL

Line 81: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,

77: decode(p_sort_order, FND_API.G_MISS_NUM, NULL, p_sort_order),
78: decode(p_group_code, FND_API.G_MISS_CHAR, NULL, p_group_code),
79: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
80: p_creation_date),
81: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
82: NULL, FND_GLOBAL.user_id, p_created_by),
83: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
84: p_last_update_date),
85: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,

Line 82: NULL, FND_GLOBAL.user_id, p_created_by),

78: decode(p_group_code, FND_API.G_MISS_CHAR, NULL, p_group_code),
79: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
80: p_creation_date),
81: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
82: NULL, FND_GLOBAL.user_id, p_created_by),
83: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
84: p_last_update_date),
85: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
86: NULL, FND_GLOBAL.user_id, p_last_updated_by),

Line 85: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,

81: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
82: NULL, FND_GLOBAL.user_id, p_created_by),
83: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
84: p_last_update_date),
85: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
86: NULL, FND_GLOBAL.user_id, p_last_updated_by),
87: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
88: NULL, FND_GLOBAL.login_id, p_last_update_login)
89: );

Line 86: NULL, FND_GLOBAL.user_id, p_last_updated_by),

82: NULL, FND_GLOBAL.user_id, p_created_by),
83: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
84: p_last_update_date),
85: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
86: NULL, FND_GLOBAL.user_id, p_last_updated_by),
87: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
88: NULL, FND_GLOBAL.login_id, p_last_update_login)
89: );
90:

Line 87: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,

83: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
84: p_last_update_date),
85: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
86: NULL, FND_GLOBAL.user_id, p_last_updated_by),
87: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
88: NULL, FND_GLOBAL.login_id, p_last_update_login)
89: );
90:
91: OPEN c;

Line 88: NULL, FND_GLOBAL.login_id, p_last_update_login)

84: p_last_update_date),
85: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
86: NULL, FND_GLOBAL.user_id, p_last_updated_by),
87: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
88: NULL, FND_GLOBAL.login_id, p_last_update_login)
89: );
90:
91: OPEN c;
92: FETCH c INTO x_rowid;

Line 121: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,

117: )
118: SELECT
119: x_msite_resp_id,
120: p_object_version_number,
121: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
122: NULL, FND_GLOBAL.user_id, p_created_by),
123: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate,
124: NULL, sysdate, p_creation_date),
125: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,

Line 122: NULL, FND_GLOBAL.user_id, p_created_by),

118: SELECT
119: x_msite_resp_id,
120: p_object_version_number,
121: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
122: NULL, FND_GLOBAL.user_id, p_created_by),
123: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate,
124: NULL, sysdate, p_creation_date),
125: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
126: NULL, FND_GLOBAL.user_id, p_last_updated_by),

Line 125: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,

121: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
122: NULL, FND_GLOBAL.user_id, p_created_by),
123: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate,
124: NULL, sysdate, p_creation_date),
125: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
126: NULL, FND_GLOBAL.user_id, p_last_updated_by),
127: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate,
128: NULL, sysdate, p_last_update_date),
129: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,

Line 126: NULL, FND_GLOBAL.user_id, p_last_updated_by),

122: NULL, FND_GLOBAL.user_id, p_created_by),
123: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate,
124: NULL, sysdate, p_creation_date),
125: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
126: NULL, FND_GLOBAL.user_id, p_last_updated_by),
127: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate,
128: NULL, sysdate, p_last_update_date),
129: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
130: NULL, FND_GLOBAL.login_id, p_last_update_login),

Line 129: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,

125: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
126: NULL, FND_GLOBAL.user_id, p_last_updated_by),
127: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate,
128: NULL, sysdate, p_last_update_date),
129: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
130: NULL, FND_GLOBAL.login_id, p_last_update_login),
131: p_display_name,
132: L.language_code,
133: userenv('LANG')

Line 130: NULL, FND_GLOBAL.login_id, p_last_update_login),

126: NULL, FND_GLOBAL.user_id, p_last_updated_by),
127: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate,
128: NULL, sysdate, p_last_update_date),
129: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
130: NULL, FND_GLOBAL.login_id, p_last_update_login),
131: p_display_name,
132: L.language_code,
133: userenv('LANG')
134: FROM fnd_languages L

Line 183: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,

179: group_code, p_group_code),
180: last_update_date = decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate,
181: NULL, sysdate, p_last_update_date),
182: last_updated_by = decode(p_last_updated_by, FND_API.G_MISS_NUM,
183: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
184: p_last_updated_by),
185: last_update_login = decode(p_last_update_login, FND_API.G_MISS_NUM,
186: FND_GLOBAL.login_id, NULL, FND_GLOBAL.login_id,
187: p_last_update_login)

Line 186: FND_GLOBAL.login_id, NULL, FND_GLOBAL.login_id,

182: last_updated_by = decode(p_last_updated_by, FND_API.G_MISS_NUM,
183: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
184: p_last_updated_by),
185: last_update_login = decode(p_last_update_login, FND_API.G_MISS_NUM,
186: FND_GLOBAL.login_id, NULL, FND_GLOBAL.login_id,
187: p_last_update_login)
188: WHERE msite_resp_id = p_msite_resp_id;
189: -- AND object_version_number = decode(p_object_version_number,
190: -- FND_API.G_MISS_NUM,

Line 205: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,

201: display_name, p_display_name),
202: last_update_date = decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate,
203: NULL, sysdate, p_last_update_date),
204: last_updated_by = decode(p_last_updated_by, FND_API.G_MISS_NUM,
205: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
206: p_last_updated_by),
207: last_update_login = decode(p_last_update_login, FND_API.G_MISS_NUM,
208: FND_GLOBAL.login_id, NULL, FND_GLOBAL.login_id,
209: p_last_update_login),

Line 208: FND_GLOBAL.login_id, NULL, FND_GLOBAL.login_id,

204: last_updated_by = decode(p_last_updated_by, FND_API.G_MISS_NUM,
205: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
206: p_last_updated_by),
207: last_update_login = decode(p_last_update_login, FND_API.G_MISS_NUM,
208: FND_GLOBAL.login_id, NULL, FND_GLOBAL.login_id,
209: p_last_update_login),
210: source_lang = USERENV('LANG')
211: WHERE msite_resp_id = p_msite_resp_id
212: -- AND object_version_number = decode(p_object_version_number,