109: decode(p_sort_order, FND_API.G_MISS_NUM, NULL, p_sort_order),
110: decode(p_concat_ids, FND_API.G_MISS_CHAR, NULL, p_concat_ids),
111: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
112: p_creation_date),
113: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
114: NULL, FND_GLOBAL.user_id, p_created_by),
115: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
116: p_last_update_date),
117: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
110: decode(p_concat_ids, FND_API.G_MISS_CHAR, NULL, p_concat_ids),
111: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
112: p_creation_date),
113: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
114: NULL, FND_GLOBAL.user_id, p_created_by),
115: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
116: p_last_update_date),
117: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
118: NULL, FND_GLOBAL.user_id, p_last_updated_by),
113: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
114: NULL, FND_GLOBAL.user_id, p_created_by),
115: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
116: p_last_update_date),
117: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
118: NULL, FND_GLOBAL.user_id, p_last_updated_by),
119: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
120: NULL, FND_GLOBAL.login_id, p_last_update_login)
121: );
114: NULL, FND_GLOBAL.user_id, p_created_by),
115: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
116: p_last_update_date),
117: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
118: NULL, FND_GLOBAL.user_id, p_last_updated_by),
119: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
120: NULL, FND_GLOBAL.login_id, p_last_update_login)
121: );
122:
115: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
116: p_last_update_date),
117: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
118: NULL, FND_GLOBAL.user_id, p_last_updated_by),
119: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
120: NULL, FND_GLOBAL.login_id, p_last_update_login)
121: );
122:
123: OPEN c;
116: p_last_update_date),
117: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
118: NULL, FND_GLOBAL.user_id, p_last_updated_by),
119: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
120: NULL, FND_GLOBAL.login_id, p_last_update_login)
121: );
122:
123: OPEN c;
124: FETCH c INTO x_rowid;
166: end_date_active, p_end_date_active),
167: last_update_date = decode(p_last_update_date, FND_API.G_MISS_DATE,
168: sysdate, NULL, sysdate, p_last_update_date),
169: last_updated_by = decode(p_last_updated_by, FND_API.G_MISS_NUM,
170: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
171: p_last_updated_by),
172: last_update_login = decode(p_last_update_login, FND_API.G_MISS_NUM,
173: FND_GLOBAL.login_id, NULL,
174: FND_GLOBAL.login_id, p_last_update_login)
169: last_updated_by = decode(p_last_updated_by, FND_API.G_MISS_NUM,
170: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
171: p_last_updated_by),
172: last_update_login = decode(p_last_update_login, FND_API.G_MISS_NUM,
173: FND_GLOBAL.login_id, NULL,
174: FND_GLOBAL.login_id, p_last_update_login)
175: WHERE mini_site_section_section_id = p_mini_site_section_section_id
176: AND object_version_number = decode(p_object_version_number,
177: FND_API.G_MISS_NUM,
170: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
171: p_last_updated_by),
172: last_update_login = decode(p_last_update_login, FND_API.G_MISS_NUM,
173: FND_GLOBAL.login_id, NULL,
174: FND_GLOBAL.login_id, p_last_update_login)
175: WHERE mini_site_section_section_id = p_mini_site_section_section_id
176: AND object_version_number = decode(p_object_version_number,
177: FND_API.G_MISS_NUM,
178: object_version_number,
826: p_level_number,
827: p_sort_order,
828: p_concat_ids,
829: SYSDATE,
830: FND_GLOBAL.user_id,
831: SYSDATE,
832: FND_GLOBAL.user_id,
833: FND_GLOBAL.login_id,
834: l_rowid,
828: p_concat_ids,
829: SYSDATE,
830: FND_GLOBAL.user_id,
831: SYSDATE,
832: FND_GLOBAL.user_id,
833: FND_GLOBAL.login_id,
834: l_rowid,
835: x_mini_site_section_section_id
836: );
829: SYSDATE,
830: FND_GLOBAL.user_id,
831: SYSDATE,
832: FND_GLOBAL.user_id,
833: FND_GLOBAL.login_id,
834: l_rowid,
835: x_mini_site_section_section_id
836: );
837: EXCEPTION
1051: p_level_number,
1052: p_sort_order,
1053: p_concat_ids,
1054: SYSDATE,
1055: FND_GLOBAL.user_id,
1056: FND_GLOBAL.login_id
1057: );
1058: EXCEPTION
1059: WHEN NO_DATA_FOUND THEN
1052: p_sort_order,
1053: p_concat_ids,
1054: SYSDATE,
1055: FND_GLOBAL.user_id,
1056: FND_GLOBAL.login_id
1057: );
1058: EXCEPTION
1059: WHEN NO_DATA_FOUND THEN
1060: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_MSS_UPDATE_FAIL');