DBA Data[Home] [Help]

APPS.IBE_DSP_MSITE_SCT_ITEM_PVT dependencies on FND_GLOBAL

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

100: p_start_date_active,
101: decode(p_end_date_active, FND_API.G_MISS_DATE, NULL, p_end_date_active),
102: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
103: p_creation_date),
104: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
105: NULL, FND_GLOBAL.user_id, p_created_by),
106: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
107: p_last_update_date),
108: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,

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

101: decode(p_end_date_active, FND_API.G_MISS_DATE, NULL, p_end_date_active),
102: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
103: p_creation_date),
104: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
105: NULL, FND_GLOBAL.user_id, p_created_by),
106: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
107: p_last_update_date),
108: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
109: NULL, FND_GLOBAL.user_id, p_last_updated_by),

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

104: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
105: NULL, FND_GLOBAL.user_id, p_created_by),
106: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
107: p_last_update_date),
108: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
109: NULL, FND_GLOBAL.user_id, p_last_updated_by),
110: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
111: NULL, FND_GLOBAL.login_id, p_last_update_login)
112: );

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

105: NULL, FND_GLOBAL.user_id, p_created_by),
106: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
107: p_last_update_date),
108: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
109: NULL, FND_GLOBAL.user_id, p_last_updated_by),
110: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
111: NULL, FND_GLOBAL.login_id, p_last_update_login)
112: );
113:

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

106: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
107: p_last_update_date),
108: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
109: NULL, FND_GLOBAL.user_id, p_last_updated_by),
110: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
111: NULL, FND_GLOBAL.login_id, p_last_update_login)
112: );
113:
114: OPEN c;

Line 111: NULL, FND_GLOBAL.login_id, p_last_update_login)

107: p_last_update_date),
108: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
109: NULL, FND_GLOBAL.user_id, p_last_updated_by),
110: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
111: NULL, FND_GLOBAL.login_id, p_last_update_login)
112: );
113:
114: OPEN c;
115: FETCH c INTO x_rowid;

Line 152: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,

148: end_date_active, p_end_date_active),
149: last_update_date = decode(p_last_update_date, FND_API.G_MISS_DATE,
150: sysdate, NULL, sysdate, p_last_update_date),
151: last_updated_by = decode(p_last_updated_by, FND_API.G_MISS_NUM,
152: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
153: p_last_updated_by),
154: last_update_login = decode(p_last_update_login, FND_API.G_MISS_NUM,
155: FND_GLOBAL.login_id, NULL,
156: FND_GLOBAL.login_id, p_last_update_login)

Line 155: FND_GLOBAL.login_id, NULL,

151: last_updated_by = decode(p_last_updated_by, FND_API.G_MISS_NUM,
152: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
153: p_last_updated_by),
154: last_update_login = decode(p_last_update_login, FND_API.G_MISS_NUM,
155: FND_GLOBAL.login_id, NULL,
156: FND_GLOBAL.login_id, p_last_update_login)
157: WHERE mini_site_section_item_id = p_mini_site_section_item_id
158: AND object_version_number = decode(p_object_version_number,
159: FND_API.G_MISS_NUM,

Line 156: FND_GLOBAL.login_id, p_last_update_login)

152: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
153: p_last_updated_by),
154: last_update_login = decode(p_last_update_login, FND_API.G_MISS_NUM,
155: FND_GLOBAL.login_id, NULL,
156: FND_GLOBAL.login_id, p_last_update_login)
157: WHERE mini_site_section_item_id = p_mini_site_section_item_id
158: AND object_version_number = decode(p_object_version_number,
159: FND_API.G_MISS_NUM,
160: object_version_number,

Line 661: FND_GLOBAL.user_id,

657: p_section_item_id,
658: p_start_date_active,
659: p_end_date_active,
660: SYSDATE,
661: FND_GLOBAL.user_id,
662: SYSDATE,
663: FND_GLOBAL.user_id,
664: FND_GLOBAL.login_id,
665: l_rowid,

Line 663: FND_GLOBAL.user_id,

659: p_end_date_active,
660: SYSDATE,
661: FND_GLOBAL.user_id,
662: SYSDATE,
663: FND_GLOBAL.user_id,
664: FND_GLOBAL.login_id,
665: l_rowid,
666: x_mini_site_section_item_id
667: );

Line 664: FND_GLOBAL.login_id,

660: SYSDATE,
661: FND_GLOBAL.user_id,
662: SYSDATE,
663: FND_GLOBAL.user_id,
664: FND_GLOBAL.login_id,
665: l_rowid,
666: x_mini_site_section_item_id
667: );
668: EXCEPTION

Line 878: FND_GLOBAL.user_id,

874: p_object_version_number,
875: p_start_date_active,
876: p_end_date_active,
877: SYSDATE,
878: FND_GLOBAL.user_id,
879: FND_GLOBAL.login_id
880: );
881: EXCEPTION
882: WHEN NO_DATA_FOUND THEN

Line 879: FND_GLOBAL.login_id

875: p_start_date_active,
876: p_end_date_active,
877: SYSDATE,
878: FND_GLOBAL.user_id,
879: FND_GLOBAL.login_id
880: );
881: EXCEPTION
882: WHEN NO_DATA_FOUND THEN
883: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_MSI_UPDATE_FAIL');