98: p_start_date_active,
99: decode(p_end_date_active, FND_API.G_MISS_DATE, NULL, p_end_date_active),
100: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
101: p_creation_date),
102: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
103: NULL, FND_GLOBAL.user_id, p_created_by),
104: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
105: p_last_update_date),
106: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
99: decode(p_end_date_active, FND_API.G_MISS_DATE, NULL, p_end_date_active),
100: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
101: p_creation_date),
102: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
103: NULL, FND_GLOBAL.user_id, p_created_by),
104: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
105: p_last_update_date),
106: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
107: NULL, FND_GLOBAL.user_id, p_last_updated_by),
102: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
103: NULL, FND_GLOBAL.user_id, p_created_by),
104: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
105: p_last_update_date),
106: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
107: NULL, FND_GLOBAL.user_id, p_last_updated_by),
108: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
109: NULL, FND_GLOBAL.login_id, p_last_update_login)
110: );
103: NULL, FND_GLOBAL.user_id, p_created_by),
104: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
105: p_last_update_date),
106: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
107: NULL, FND_GLOBAL.user_id, p_last_updated_by),
108: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
109: NULL, FND_GLOBAL.login_id, p_last_update_login)
110: );
111:
104: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
105: p_last_update_date),
106: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
107: NULL, FND_GLOBAL.user_id, p_last_updated_by),
108: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
109: NULL, FND_GLOBAL.login_id, p_last_update_login)
110: );
111:
112: OPEN c;
105: p_last_update_date),
106: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
107: NULL, FND_GLOBAL.user_id, p_last_updated_by),
108: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
109: NULL, FND_GLOBAL.login_id, p_last_update_login)
110: );
111:
112: OPEN c;
113: FETCH c INTO x_rowid;
146: end_date_active, p_end_date_active),
147: last_update_date = decode(p_last_update_date, FND_API.G_MISS_DATE,
148: sysdate, NULL, sysdate, p_last_update_date),
149: last_updated_by = decode(p_last_updated_by, FND_API.G_MISS_NUM,
150: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
151: p_last_updated_by),
152: last_update_login = decode(p_last_update_login, FND_API.G_MISS_NUM,
153: FND_GLOBAL.login_id, NULL,
154: FND_GLOBAL.login_id, p_last_update_login)
149: last_updated_by = decode(p_last_updated_by, FND_API.G_MISS_NUM,
150: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
151: p_last_updated_by),
152: last_update_login = decode(p_last_update_login, FND_API.G_MISS_NUM,
153: FND_GLOBAL.login_id, NULL,
154: FND_GLOBAL.login_id, p_last_update_login)
155: WHERE mini_site_section_item_id = p_mini_site_section_item_id
156: AND object_version_number = decode(p_object_version_number,
157: FND_API.G_MISS_NUM,
150: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
151: p_last_updated_by),
152: last_update_login = decode(p_last_update_login, FND_API.G_MISS_NUM,
153: FND_GLOBAL.login_id, NULL,
154: FND_GLOBAL.login_id, p_last_update_login)
155: WHERE mini_site_section_item_id = p_mini_site_section_item_id
156: AND object_version_number = decode(p_object_version_number,
157: FND_API.G_MISS_NUM,
158: object_version_number,
620: p_section_item_id,
621: p_start_date_active,
622: p_end_date_active,
623: SYSDATE,
624: FND_GLOBAL.user_id,
625: SYSDATE,
626: FND_GLOBAL.user_id,
627: FND_GLOBAL.login_id,
628: l_rowid,
622: p_end_date_active,
623: SYSDATE,
624: FND_GLOBAL.user_id,
625: SYSDATE,
626: FND_GLOBAL.user_id,
627: FND_GLOBAL.login_id,
628: l_rowid,
629: x_mini_site_section_item_id
630: );
623: SYSDATE,
624: FND_GLOBAL.user_id,
625: SYSDATE,
626: FND_GLOBAL.user_id,
627: FND_GLOBAL.login_id,
628: l_rowid,
629: x_mini_site_section_item_id
630: );
631: EXCEPTION
818: p_object_version_number,
819: p_start_date_active,
820: p_end_date_active,
821: SYSDATE,
822: FND_GLOBAL.user_id,
823: FND_GLOBAL.login_id
824: );
825: EXCEPTION
826: WHEN NO_DATA_FOUND THEN
819: p_start_date_active,
820: p_end_date_active,
821: SYSDATE,
822: FND_GLOBAL.user_id,
823: FND_GLOBAL.login_id
824: );
825: EXCEPTION
826: WHEN NO_DATA_FOUND THEN
827: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_MSI_UPDATE_FAIL');