106: VALUES
107: ( p_org_id
108: , l_next_value
109: , SYSDATE
110: , fnd_global.LOGIN_ID()
111: , SYSDATE
112: , fnd_global.LOGIN_ID()
113: , fnd_global.LOGIN_ID()
114: );
108: , l_next_value
109: , SYSDATE
110: , fnd_global.LOGIN_ID()
111: , SYSDATE
112: , fnd_global.LOGIN_ID()
113: , fnd_global.LOGIN_ID()
114: );
115:
116: x_return_status := 'S';
109: , SYSDATE
110: , fnd_global.LOGIN_ID()
111: , SYSDATE
112: , fnd_global.LOGIN_ID()
113: , fnd_global.LOGIN_ID()
114: );
115:
116: x_return_status := 'S';
117: ELSIF l_count >= 1
186: THEN
187: UPDATE jmf_gta_batch_numbering
188: SET next_value = p_next_value
189: , last_update_date = SYSDATE
190: , last_updated_by = fnd_global.LOGIN_ID()
191: , last_update_login = fnd_global.LOGIN_ID()
192: WHERE org_id = p_org_id;
193:
194: x_return_status := 'S';
187: UPDATE jmf_gta_batch_numbering
188: SET next_value = p_next_value
189: , last_update_date = SYSDATE
190: , last_updated_by = fnd_global.LOGIN_ID()
191: , last_update_login = fnd_global.LOGIN_ID()
192: WHERE org_id = p_org_id;
193:
194: x_return_status := 'S';
195: ELSE
280: THEN
281: UPDATE jmf_gta_batch_numbering
282: SET next_value = l_next_val + 1
283: , last_update_date = SYSDATE
284: , last_updated_by = fnd_global.LOGIN_ID()
285: , last_update_login = fnd_global.LOGIN_ID()
286: WHERE CURRENT OF c_next_val;
287:
288: COMMIT;
281: UPDATE jmf_gta_batch_numbering
282: SET next_value = l_next_val + 1
283: , last_update_date = SYSDATE
284: , last_updated_by = fnd_global.LOGIN_ID()
285: , last_update_login = fnd_global.LOGIN_ID()
286: WHERE CURRENT OF c_next_val;
287:
288: COMMIT;
289: CLOSE c_next_val;