eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_CANCEL_HIRE_BE1 dependencies on DBMS_LOB

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

39: close get_seq;
40: --
41: -- build the xml data for the event
42: --
43: dbms_lob.createTemporary(l_event_data,false,dbms_lob.call);
44: l_text:='';
45: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
46: l_text:='';
47: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

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

41: -- build the xml data for the event
42: --
43: dbms_lob.createTemporary(l_event_data,false,dbms_lob.call);
44: l_text:='';
45: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
46: l_text:='';
47: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
48: --
49: l_text:='';

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

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

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

48: --
49: l_text:='';
50: l_text:=l_text||fnd_number.number_to_canonical(p_person_id);
51: l_text:=l_text||'';
52: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
53: l_text:='';
54: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date);
55: l_text:=l_text||'';
56: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

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

52: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
53: l_text:='';
54: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date);
55: l_text:=l_text||'';
56: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
57: l_text:='';
58: if(P_SUPERVISOR_WARNING) then
59: l_text:=l_text||'TRUE';
60: else

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

60: else
61: l_text:=l_text||'FALSE';
62: end if;
63: l_text:=l_text||'';
64: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
65: l_text:='';
66: if(P_RECRUITER_WARNING) then
67: l_text:=l_text||'TRUE';
68: else

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

68: else
69: l_text:=l_text||'FALSE';
70: end if;
71: l_text:=l_text||'';
72: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
73: l_text:='';
74: if(P_EVENT_WARNING) then
75: l_text:=l_text||'TRUE';
76: else

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

76: else
77: l_text:=l_text||'FALSE';
78: end if;
79: l_text:=l_text||'';
80: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
81: l_text:='';
82: if(P_INTERVIEW_WARNING) then
83: l_text:=l_text||'TRUE';
84: else

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

84: else
85: l_text:=l_text||'FALSE';
86: end if;
87: l_text:=l_text||'';
88: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
89: l_text:='';
90: if(P_REVIEW_WARNING) then
91: l_text:=l_text||'TRUE';
92: else

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

92: else
93: l_text:=l_text||'FALSE';
94: end if;
95: l_text:=l_text||'';
96: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
97: l_text:='';
98: if(P_VACANCY_WARNING) then
99: l_text:=l_text||'TRUE';
100: else

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

100: else
101: l_text:=l_text||'FALSE';
102: end if;
103: l_text:=l_text||'';
104: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
105: l_text:='';
106: if(P_REQUISITION_WARNING) then
107: l_text:=l_text||'TRUE';
108: else

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

108: else
109: l_text:=l_text||'FALSE';
110: end if;
111: l_text:=l_text||'';
112: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
113: l_text:='';
114: if(P_BUDGET_WARNING) then
115: l_text:=l_text||'TRUE';
116: else

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

116: else
117: l_text:=l_text||'FALSE';
118: end if;
119: l_text:=l_text||'';
120: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
121: l_text:='';
122: if(P_PAYMENT_WARNING) then
123: l_text:=l_text||'TRUE';
124: else

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

124: else
125: l_text:=l_text||'FALSE';
126: end if;
127: l_text:=l_text||'';
128: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
129: l_text:='';
130: --
131: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
132: --

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

127: l_text:=l_text||'';
128: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
129: l_text:='';
130: --
131: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
132: --
133: -- raise the event with the event data
134: wf_event.raise(p_event_name=>l_event_name
135: ,p_event_key=>l_event_key