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.PER_CANCEL_PLACEMENT_BE1 dependencies on DBMS_LOB

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

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

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

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

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

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

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

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

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

53: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
54: l_text:='';
55: l_text:=l_text||fnd_number.number_to_canonical(p_person_id);
56: l_text:=l_text||'';
57: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
58: l_text:='';
59: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date);
60: l_text:=l_text||'';
61: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

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

57: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
58: l_text:='';
59: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date);
60: l_text:=l_text||'';
61: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
62: l_text:='';
63: if(P_SUPERVISOR_WARNING) then
64: l_text:=l_text||'TRUE';
65: else

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

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

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

73: else
74: l_text:=l_text||'FALSE';
75: end if;
76: l_text:=l_text||'';
77: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
78: l_text:='';
79: if(P_EVENT_WARNING) then
80: l_text:=l_text||'TRUE';
81: else

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

81: else
82: l_text:=l_text||'FALSE';
83: end if;
84: l_text:=l_text||'';
85: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
86: l_text:='';
87: if(P_INTERVIEW_WARNING) then
88: l_text:=l_text||'TRUE';
89: else

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

89: else
90: l_text:=l_text||'FALSE';
91: end if;
92: l_text:=l_text||'';
93: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
94: l_text:='';
95: if(P_REVIEW_WARNING) then
96: l_text:=l_text||'TRUE';
97: else

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

97: else
98: l_text:=l_text||'FALSE';
99: end if;
100: l_text:=l_text||'';
101: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
102: l_text:='';
103: if(P_VACANCY_WARNING) then
104: l_text:=l_text||'TRUE';
105: else

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

105: else
106: l_text:=l_text||'FALSE';
107: end if;
108: l_text:=l_text||'';
109: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
110: l_text:='';
111: if(P_REQUISITION_WARNING) then
112: l_text:=l_text||'TRUE';
113: else

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

113: else
114: l_text:=l_text||'FALSE';
115: end if;
116: l_text:=l_text||'';
117: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
118: l_text:='';
119: if(P_BUDGET_WARNING) then
120: l_text:=l_text||'TRUE';
121: else

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

121: else
122: l_text:=l_text||'FALSE';
123: end if;
124: l_text:=l_text||'';
125: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
126: l_text:='';
127: if(P_PAYMENT_WARNING) then
128: l_text:=l_text||'TRUE';
129: else

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

129: else
130: l_text:=l_text||'FALSE';
131: end if;
132: l_text:=l_text||'';
133: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
134: l_text:='';
135: --
136: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
137: --

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

132: l_text:=l_text||'';
133: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
134: l_text:='';
135: --
136: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
137: --
138: -- raise the event with the event data
139: wf_event.raise(p_event_name=>l_event_name
140: ,p_event_key=>l_event_key