DBA Data[Home] [Help]

APPS.IBE_DSP_MSITE_SCT_SECT_PVT dependencies on FND_GLOBAL

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

110: decode(p_sort_order, FND_API.G_MISS_NUM, NULL, p_sort_order),
111: decode(p_concat_ids, FND_API.G_MISS_CHAR, NULL, p_concat_ids),
112: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
113: p_creation_date),
114: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
115: NULL, FND_GLOBAL.user_id, p_created_by),
116: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
117: p_last_update_date),
118: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,

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

111: decode(p_concat_ids, FND_API.G_MISS_CHAR, NULL, p_concat_ids),
112: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
113: p_creation_date),
114: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
115: NULL, FND_GLOBAL.user_id, p_created_by),
116: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
117: p_last_update_date),
118: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
119: NULL, FND_GLOBAL.user_id, p_last_updated_by),

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

114: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
115: NULL, FND_GLOBAL.user_id, p_created_by),
116: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
117: p_last_update_date),
118: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
119: NULL, FND_GLOBAL.user_id, p_last_updated_by),
120: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
121: NULL, FND_GLOBAL.login_id, p_last_update_login)
122: );

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

115: NULL, FND_GLOBAL.user_id, p_created_by),
116: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
117: p_last_update_date),
118: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
119: NULL, FND_GLOBAL.user_id, p_last_updated_by),
120: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
121: NULL, FND_GLOBAL.login_id, p_last_update_login)
122: );
123:

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

116: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
117: p_last_update_date),
118: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
119: NULL, FND_GLOBAL.user_id, p_last_updated_by),
120: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
121: NULL, FND_GLOBAL.login_id, p_last_update_login)
122: );
123:
124: OPEN c;

Line 121: NULL, FND_GLOBAL.login_id, p_last_update_login)

117: p_last_update_date),
118: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
119: NULL, FND_GLOBAL.user_id, p_last_updated_by),
120: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
121: NULL, FND_GLOBAL.login_id, p_last_update_login)
122: );
123:
124: OPEN c;
125: FETCH c INTO x_rowid;

Line 171: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,

167: end_date_active, p_end_date_active),
168: last_update_date = decode(p_last_update_date, FND_API.G_MISS_DATE,
169: sysdate, NULL, sysdate, p_last_update_date),
170: last_updated_by = decode(p_last_updated_by, FND_API.G_MISS_NUM,
171: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
172: p_last_updated_by),
173: last_update_login = decode(p_last_update_login, FND_API.G_MISS_NUM,
174: FND_GLOBAL.login_id, NULL,
175: FND_GLOBAL.login_id, p_last_update_login)

Line 174: FND_GLOBAL.login_id, NULL,

170: last_updated_by = decode(p_last_updated_by, FND_API.G_MISS_NUM,
171: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
172: p_last_updated_by),
173: last_update_login = decode(p_last_update_login, FND_API.G_MISS_NUM,
174: FND_GLOBAL.login_id, NULL,
175: FND_GLOBAL.login_id, p_last_update_login)
176: WHERE mini_site_section_section_id = p_mini_site_section_section_id
177: AND object_version_number = decode(p_object_version_number,
178: FND_API.G_MISS_NUM,

Line 175: FND_GLOBAL.login_id, p_last_update_login)

171: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
172: p_last_updated_by),
173: last_update_login = decode(p_last_update_login, FND_API.G_MISS_NUM,
174: FND_GLOBAL.login_id, NULL,
175: FND_GLOBAL.login_id, p_last_update_login)
176: WHERE mini_site_section_section_id = p_mini_site_section_section_id
177: AND object_version_number = decode(p_object_version_number,
178: FND_API.G_MISS_NUM,
179: object_version_number,

Line 882: FND_GLOBAL.user_id,

878: p_level_number,
879: p_sort_order,
880: p_concat_ids,
881: SYSDATE,
882: FND_GLOBAL.user_id,
883: SYSDATE,
884: FND_GLOBAL.user_id,
885: FND_GLOBAL.login_id,
886: l_rowid,

Line 884: FND_GLOBAL.user_id,

880: p_concat_ids,
881: SYSDATE,
882: FND_GLOBAL.user_id,
883: SYSDATE,
884: FND_GLOBAL.user_id,
885: FND_GLOBAL.login_id,
886: l_rowid,
887: x_mini_site_section_section_id
888: );

Line 885: FND_GLOBAL.login_id,

881: SYSDATE,
882: FND_GLOBAL.user_id,
883: SYSDATE,
884: FND_GLOBAL.user_id,
885: FND_GLOBAL.login_id,
886: l_rowid,
887: x_mini_site_section_section_id
888: );
889: EXCEPTION

Line 1126: FND_GLOBAL.user_id,

1122: p_level_number,
1123: p_sort_order,
1124: p_concat_ids,
1125: SYSDATE,
1126: FND_GLOBAL.user_id,
1127: FND_GLOBAL.login_id
1128: );
1129: EXCEPTION
1130: WHEN NO_DATA_FOUND THEN

Line 1127: FND_GLOBAL.login_id

1123: p_sort_order,
1124: p_concat_ids,
1125: SYSDATE,
1126: FND_GLOBAL.user_id,
1127: FND_GLOBAL.login_id
1128: );
1129: EXCEPTION
1130: WHEN NO_DATA_FOUND THEN
1131: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_MSS_UPDATE_FAIL');