173: ,p_object1_type
174: ,p_object2_pk1_value
175: ,p_object2_type
176: ,l_next_number+1
177: ,fnd_global.user_id
178: ,fnd_global.user_id
179: ,sysdate
180: ,sysdate
181: ,fnd_global.user_id
174: ,p_object2_pk1_value
175: ,p_object2_type
176: ,l_next_number+1
177: ,fnd_global.user_id
178: ,fnd_global.user_id
179: ,sysdate
180: ,sysdate
181: ,fnd_global.user_id
182: );
177: ,fnd_global.user_id
178: ,fnd_global.user_id
179: ,sysdate
180: ,sysdate
181: ,fnd_global.user_id
182: );
183:
184:
185: open c;
227: ,object1_type = Nvl(p_object1_type,object1_type)
228: ,object2_pk1_value = Nvl(p_object2_pk1_value,object2_pk1_value)
229: ,object2_type = Nvl(p_object2_type,object2_type)
230: ,next_number = Nvl(p_next_number,next_number)
231: ,LAST_UPDATED_BY = fnd_global.user_id
232: ,LAST_UPDATE_DATE = sysdate
233: ,LAST_UPDATE_LOGIN = fnd_global.login_id
234: where system_number_id = nvl(p_system_number_id,0)
235: OR (object1_pk1_value = p_object1_pk1_value AND
229: ,object2_type = Nvl(p_object2_type,object2_type)
230: ,next_number = Nvl(p_next_number,next_number)
231: ,LAST_UPDATED_BY = fnd_global.user_id
232: ,LAST_UPDATE_DATE = sysdate
233: ,LAST_UPDATE_LOGIN = fnd_global.login_id
234: where system_number_id = nvl(p_system_number_id,0)
235: OR (object1_pk1_value = p_object1_pk1_value AND
236: p_object1_type = p_object1_type AND
237: nvl(object2_pk1_value, 0) = nvl(p_object2_pk1_value,0) AND