APPS.HR_CONTINGENT_WORKER_BE5 dependencies on DBMS_LOB

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

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

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

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

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

37: dbms_lob.createTemporary(l_event_data,false,dbms_lob.call);
38: l_text:='';
39: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
40: l_text:='';
41: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
42: --
43: l_text:='';
44: if(P_VALIDATE) then
45: l_text:=l_text||'TRUE';

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

46: else
47: l_text:=l_text||'FALSE';
48: end if;
49: l_text:=l_text||'';
50: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
51: l_text:='';
52: l_text:=l_text||fnd_number.number_to_canonical(p_person_id);
53: l_text:=l_text||'';
54: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

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

50: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
51: l_text:='';
52: l_text:=l_text||fnd_number.number_to_canonical(p_person_id);
53: l_text:=l_text||'';
54: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
55: l_text:='';
56: l_text:=l_text||fnd_date.date_to_canonical(p_actual_termination_date);
57: l_text:=l_text||'';
58: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

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

54: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
55: l_text:='';
56: l_text:=l_text||fnd_date.date_to_canonical(p_actual_termination_date);
57: l_text:=l_text||'';
58: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
59: l_text:='';
60: l_text:=l_text||irc_utilities_pkg.removeTags(p_clear_details);
61: l_text:=l_text||'';
62: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

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

58: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
59: l_text:='';
60: l_text:=l_text||irc_utilities_pkg.removeTags(p_clear_details);
61: l_text:=l_text||'';
62: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
63: l_text:='';
64: if(P_FUT_ACTNS_EXIST_WARNING) then
65: l_text:=l_text||'TRUE';
66: else

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

66: else
67: l_text:=l_text||'FALSE';
68: end if;
69: l_text:=l_text||'';
70: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
71: l_text:='';
72: --
73: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
74: --

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

69: l_text:=l_text||'';
70: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
71: l_text:='';
72: --
73: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
74: --
75: if p_actual_termination_date is not NULL and
76: p_actual_termination_date > trunc(SYSDATE) and
77: fnd_profile.value('HR_DEFER_FD_BE_EVENTS') = 'Y' then