APPS.HR_LOCATION_BE3 dependencies on DBMS_LOB

Line 34: dbms_lob.createTemporary(l_event_data,false,dbms_lob.call);

30: close get_seq;
31: --
32: -- build the xml data for the event
33: --
34: dbms_lob.createTemporary(l_event_data,false,dbms_lob.call);
35: l_text:='';
36: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
37: l_text:='';
38: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 36: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

32: -- build the xml data for the event
33: --
34: dbms_lob.createTemporary(l_event_data,false,dbms_lob.call);
35: l_text:='';
36: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
37: l_text:='';
38: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
39: --
40: l_text:='';

Line 38: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

34: dbms_lob.createTemporary(l_event_data,false,dbms_lob.call);
35: l_text:='';
36: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
37: l_text:='';
38: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
39: --
40: l_text:='';
41: l_text:=l_text||fnd_number.number_to_canonical(p_location_id);
42: l_text:=l_text||'';

Line 43: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

39: --
40: l_text:='';
41: l_text:=l_text||fnd_number.number_to_canonical(p_location_id);
42: l_text:=l_text||'';
43: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
44: l_text:='';
45: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);
46: l_text:=l_text||'';
47: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 47: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

43: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
44: l_text:='';
45: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);
46: l_text:=l_text||'';
47: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
48: l_text:='';
49: --
50: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
51: --

Line 50: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

46: l_text:=l_text||'';
47: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
48: l_text:='';
49: --
50: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
51: --
52: -- raise the event with the event data
53: wf_event.raise(p_event_name=>l_event_name
54: ,p_event_key=>l_event_key