35: num_attrs_passed integer;
36: c integer;
37: rows_processed integer;
38: status varchar2(30):='NEW';
39: user_id Number := FND_PROFILE.Value('USER_ID');
40: login_id Number := FND_PROFILE.Value('LOGIN_ID');
41: xxx rowid;
42: off_line varchar2(1);
43: on_line integer;
36: c integer;
37: rows_processed integer;
38: status varchar2(30):='NEW';
39: user_id Number := FND_PROFILE.Value('USER_ID');
40: login_id Number := FND_PROFILE.Value('LOGIN_ID');
41: xxx rowid;
42: off_line varchar2(1);
43: on_line integer;
44:
260: p_new_recip number,
261: p_note varchar2 default NULL)
262: is
263: xxx rowid;
264: user_id Number := FND_PROFILE.Value('USER_ID');
265: login_id Number := FND_PROFILE.Value('LOGIN_ID');
266:
267: begin
268: -- Check for valid employee id
261: p_note varchar2 default NULL)
262: is
263: xxx rowid;
264: user_id Number := FND_PROFILE.Value('USER_ID');
265: login_id Number := FND_PROFILE.Value('LOGIN_ID');
266:
267: begin
268: -- Check for valid employee id
269: select rowid into xxx