105: decode(p_association_reason_code, FND_API.G_MISS_CHAR,
106: NULL, p_association_reason_code),
107: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
108: p_creation_date),
109: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
110: NULL, FND_GLOBAL.user_id, p_created_by),
111: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
112: p_last_update_date),
113: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
106: NULL, p_association_reason_code),
107: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
108: p_creation_date),
109: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
110: NULL, FND_GLOBAL.user_id, p_created_by),
111: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
112: p_last_update_date),
113: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
114: NULL, FND_GLOBAL.user_id, p_last_updated_by),
109: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
110: NULL, FND_GLOBAL.user_id, p_created_by),
111: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
112: p_last_update_date),
113: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
114: NULL, FND_GLOBAL.user_id, p_last_updated_by),
115: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
116: NULL, FND_GLOBAL.login_id, p_last_update_login)
117: );
110: NULL, FND_GLOBAL.user_id, p_created_by),
111: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
112: p_last_update_date),
113: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
114: NULL, FND_GLOBAL.user_id, p_last_updated_by),
115: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
116: NULL, FND_GLOBAL.login_id, p_last_update_login)
117: );
118:
111: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
112: p_last_update_date),
113: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
114: NULL, FND_GLOBAL.user_id, p_last_updated_by),
115: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
116: NULL, FND_GLOBAL.login_id, p_last_update_login)
117: );
118:
119: OPEN c;
112: p_last_update_date),
113: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
114: NULL, FND_GLOBAL.user_id, p_last_updated_by),
115: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
116: NULL, FND_GLOBAL.login_id, p_last_update_login)
117: );
118:
119: OPEN c;
120: FETCH c INTO x_rowid;
160: end_date_active, p_end_date_active),
161: last_update_date = decode(p_last_update_date, FND_API.G_MISS_DATE,
162: sysdate, NULL, sysdate, p_last_update_date),
163: last_updated_by = decode(p_last_updated_by, FND_API.G_MISS_NUM,
164: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
165: p_last_updated_by),
166: last_update_login = decode(p_last_update_login, FND_API.G_MISS_NUM,
167: FND_GLOBAL.login_id, NULL,
168: FND_GLOBAL.login_id, p_last_update_login)
163: last_updated_by = decode(p_last_updated_by, FND_API.G_MISS_NUM,
164: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
165: p_last_updated_by),
166: last_update_login = decode(p_last_update_login, FND_API.G_MISS_NUM,
167: FND_GLOBAL.login_id, NULL,
168: FND_GLOBAL.login_id, p_last_update_login)
169: WHERE section_item_id = p_section_item_id
170: AND object_version_number = decode(p_object_version_number,
171: FND_API.G_MISS_NUM,
164: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
165: p_last_updated_by),
166: last_update_login = decode(p_last_update_login, FND_API.G_MISS_NUM,
167: FND_GLOBAL.login_id, NULL,
168: FND_GLOBAL.login_id, p_last_update_login)
169: WHERE section_item_id = p_section_item_id
170: AND object_version_number = decode(p_object_version_number,
171: FND_API.G_MISS_NUM,
172: object_version_number,
726: p_end_date_active,
727: p_sort_order,
728: p_association_reason_code,
729: SYSDATE,
730: FND_GLOBAL.user_id,
731: SYSDATE,
732: FND_GLOBAL.user_id,
733: FND_GLOBAL.login_id,
734: l_rowid,
728: p_association_reason_code,
729: SYSDATE,
730: FND_GLOBAL.user_id,
731: SYSDATE,
732: FND_GLOBAL.user_id,
733: FND_GLOBAL.login_id,
734: l_rowid,
735: x_section_item_id
736: );
729: SYSDATE,
730: FND_GLOBAL.user_id,
731: SYSDATE,
732: FND_GLOBAL.user_id,
733: FND_GLOBAL.login_id,
734: l_rowid,
735: x_section_item_id
736: );
737: EXCEPTION
940: p_end_date_active,
941: p_sort_order,
942: p_association_reason_code,
943: SYSDATE,
944: FND_GLOBAL.user_id,
945: FND_GLOBAL.login_id
946: );
947: EXCEPTION
948: WHEN NO_DATA_FOUND THEN
941: p_sort_order,
942: p_association_reason_code,
943: SYSDATE,
944: FND_GLOBAL.user_id,
945: FND_GLOBAL.login_id
946: );
947: EXCEPTION
948: WHEN NO_DATA_FOUND THEN
949: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SI_UPDATE_FAIL');