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_ASSIGNMENT_BEO dependencies on DBMS_LOB

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

78: close get_seq;
79: --
80: -- build the xml data for the event
81: --
82: dbms_lob.createTemporary(l_event_data,false,dbms_lob.call);
83: l_text:='';
84: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
85: l_text:='';
86: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

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

80: -- build the xml data for the event
81: --
82: dbms_lob.createTemporary(l_event_data,false,dbms_lob.call);
83: l_text:='';
84: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
85: l_text:='';
86: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
87: --
88: l_text:='';

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

82: dbms_lob.createTemporary(l_event_data,false,dbms_lob.call);
83: l_text:='';
84: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
85: l_text:='';
86: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
87: --
88: l_text:='';
89: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date);
90: l_text:=l_text||'';

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

87: --
88: l_text:='';
89: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date);
90: l_text:=l_text||'';
91: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
92: l_text:='';
93: l_text:=l_text||irc_utilities_pkg.removeTags(p_datetrack_update_mode);
94: l_text:=l_text||'';
95: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

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

91: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
92: l_text:='';
93: l_text:=l_text||irc_utilities_pkg.removeTags(p_datetrack_update_mode);
94: l_text:=l_text||'';
95: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
96: l_text:='';
97: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_id);
98: l_text:=l_text||'';
99: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

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

95: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
96: l_text:='';
97: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_id);
98: l_text:=l_text||'';
99: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
100: l_text:='';
101: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);
102: l_text:=l_text||'';
103: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

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

99: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
100: l_text:='';
101: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);
102: l_text:=l_text||'';
103: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
104: l_text:='';
105: l_text:=l_text||fnd_number.number_to_canonical(p_grade_id);
106: l_text:=l_text||'';
107: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

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

103: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
104: l_text:='';
105: l_text:=l_text||fnd_number.number_to_canonical(p_grade_id);
106: l_text:=l_text||'';
107: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
108: l_text:='';
109: l_text:=l_text||fnd_number.number_to_canonical(p_position_id);
110: l_text:=l_text||'';
111: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

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

107: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
108: l_text:='';
109: l_text:=l_text||fnd_number.number_to_canonical(p_position_id);
110: l_text:=l_text||'';
111: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
112: l_text:='';
113: l_text:=l_text||fnd_number.number_to_canonical(p_job_id);
114: l_text:=l_text||'';
115: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

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

111: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
112: l_text:='';
113: l_text:=l_text||fnd_number.number_to_canonical(p_job_id);
114: l_text:=l_text||'';
115: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
116: l_text:='';
117: l_text:=l_text||fnd_number.number_to_canonical(p_location_id);
118: l_text:=l_text||'';
119: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

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

115: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
116: l_text:='';
117: l_text:=l_text||fnd_number.number_to_canonical(p_location_id);
118: l_text:=l_text||'';
119: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
120: l_text:='';
121: l_text:=l_text||fnd_number.number_to_canonical(p_organization_id);
122: l_text:=l_text||'';
123: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

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

119: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
120: l_text:='';
121: l_text:=l_text||fnd_number.number_to_canonical(p_organization_id);
122: l_text:=l_text||'';
123: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
124: l_text:='';
125: l_text:=l_text||fnd_number.number_to_canonical(p_pay_basis_id);
126: l_text:=l_text||'';
127: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

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

123: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
124: l_text:='';
125: l_text:=l_text||fnd_number.number_to_canonical(p_pay_basis_id);
126: l_text:=l_text||'';
127: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
128: l_text:='';
129: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment1);
130: l_text:=l_text||'';
131: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

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

127: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
128: l_text:='';
129: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment1);
130: l_text:=l_text||'';
131: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
132: l_text:='';
133: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment2);
134: l_text:=l_text||'';
135: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

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

131: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
132: l_text:='';
133: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment2);
134: l_text:=l_text||'';
135: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
136: l_text:='';
137: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment3);
138: l_text:=l_text||'';
139: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

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

135: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
136: l_text:='';
137: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment3);
138: l_text:=l_text||'';
139: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
140: l_text:='';
141: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment4);
142: l_text:=l_text||'';
143: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

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

139: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
140: l_text:='';
141: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment4);
142: l_text:=l_text||'';
143: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
144: l_text:='';
145: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment5);
146: l_text:=l_text||'';
147: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

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

143: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
144: l_text:='';
145: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment5);
146: l_text:=l_text||'';
147: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
148: l_text:='';
149: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment6);
150: l_text:=l_text||'';
151: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

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

147: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
148: l_text:='';
149: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment6);
150: l_text:=l_text||'';
151: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
152: l_text:='';
153: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment7);
154: l_text:=l_text||'';
155: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

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

151: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
152: l_text:='';
153: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment7);
154: l_text:=l_text||'';
155: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
156: l_text:='';
157: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment8);
158: l_text:=l_text||'';
159: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

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

155: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
156: l_text:='';
157: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment8);
158: l_text:=l_text||'';
159: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
160: l_text:='';
161: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment9);
162: l_text:=l_text||'';
163: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

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

159: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
160: l_text:='';
161: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment9);
162: l_text:=l_text||'';
163: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
164: l_text:='';
165: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment10);
166: l_text:=l_text||'';
167: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

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

163: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
164: l_text:='';
165: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment10);
166: l_text:=l_text||'';
167: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
168: l_text:='';
169: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment11);
170: l_text:=l_text||'';
171: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

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

167: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
168: l_text:='';
169: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment11);
170: l_text:=l_text||'';
171: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
172: l_text:='';
173: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment12);
174: l_text:=l_text||'';
175: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

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

171: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
172: l_text:='';
173: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment12);
174: l_text:=l_text||'';
175: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
176: l_text:='';
177: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment13);
178: l_text:=l_text||'';
179: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

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

175: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
176: l_text:='';
177: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment13);
178: l_text:=l_text||'';
179: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
180: l_text:='';
181: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment14);
182: l_text:=l_text||'';
183: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

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

179: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
180: l_text:='';
181: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment14);
182: l_text:=l_text||'';
183: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
184: l_text:='';
185: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment15);
186: l_text:=l_text||'';
187: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

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

183: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
184: l_text:='';
185: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment15);
186: l_text:=l_text||'';
187: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
188: l_text:='';
189: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment16);
190: l_text:=l_text||'';
191: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

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

187: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
188: l_text:='';
189: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment16);
190: l_text:=l_text||'';
191: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
192: l_text:='';
193: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment17);
194: l_text:=l_text||'';
195: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

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

191: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
192: l_text:='';
193: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment17);
194: l_text:=l_text||'';
195: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
196: l_text:='';
197: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment18);
198: l_text:=l_text||'';
199: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

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

195: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
196: l_text:='';
197: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment18);
198: l_text:=l_text||'';
199: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
200: l_text:='';
201: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment19);
202: l_text:=l_text||'';
203: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

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

199: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
200: l_text:='';
201: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment19);
202: l_text:=l_text||'';
203: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
204: l_text:='';
205: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment20);
206: l_text:=l_text||'';
207: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

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

203: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
204: l_text:='';
205: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment20);
206: l_text:=l_text||'';
207: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
208: l_text:='';
209: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment21);
210: l_text:=l_text||'';
211: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

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

207: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
208: l_text:='';
209: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment21);
210: l_text:=l_text||'';
211: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
212: l_text:='';
213: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment22);
214: l_text:=l_text||'';
215: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

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

211: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
212: l_text:='';
213: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment22);
214: l_text:=l_text||'';
215: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
216: l_text:='';
217: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment23);
218: l_text:=l_text||'';
219: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

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

215: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
216: l_text:='';
217: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment23);
218: l_text:=l_text||'';
219: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
220: l_text:='';
221: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment24);
222: l_text:=l_text||'';
223: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

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

219: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
220: l_text:='';
221: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment24);
222: l_text:=l_text||'';
223: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
224: l_text:='';
225: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment25);
226: l_text:=l_text||'';
227: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

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

223: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
224: l_text:='';
225: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment25);
226: l_text:=l_text||'';
227: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
228: l_text:='';
229: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment26);
230: l_text:=l_text||'';
231: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

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

227: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
228: l_text:='';
229: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment26);
230: l_text:=l_text||'';
231: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
232: l_text:='';
233: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment27);
234: l_text:=l_text||'';
235: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

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

231: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
232: l_text:='';
233: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment27);
234: l_text:=l_text||'';
235: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
236: l_text:='';
237: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment28);
238: l_text:=l_text||'';
239: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

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

235: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
236: l_text:='';
237: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment28);
238: l_text:=l_text||'';
239: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
240: l_text:='';
241: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment29);
242: l_text:=l_text||'';
243: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

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

239: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
240: l_text:='';
241: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment29);
242: l_text:=l_text||'';
243: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
244: l_text:='';
245: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment30);
246: l_text:=l_text||'';
247: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

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

243: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
244: l_text:='';
245: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment30);
246: l_text:=l_text||'';
247: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
248: l_text:='';
249: l_text:=l_text||irc_utilities_pkg.removeTags(p_people_group_name);
250: l_text:=l_text||'';
251: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

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

247: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
248: l_text:='';
249: l_text:=l_text||irc_utilities_pkg.removeTags(p_people_group_name);
250: l_text:=l_text||'';
251: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
252: l_text:='';
253: l_text:=l_text||fnd_date.date_to_canonical(p_effective_start_date);
254: l_text:=l_text||'';
255: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

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

251: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
252: l_text:='';
253: l_text:=l_text||fnd_date.date_to_canonical(p_effective_start_date);
254: l_text:=l_text||'';
255: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
256: l_text:='';
257: l_text:=l_text||fnd_date.date_to_canonical(p_effective_end_date);
258: l_text:=l_text||'';
259: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

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

255: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
256: l_text:='';
257: l_text:=l_text||fnd_date.date_to_canonical(p_effective_end_date);
258: l_text:=l_text||'';
259: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
260: l_text:='';
261: l_text:=l_text||fnd_number.number_to_canonical(p_people_group_id);
262: l_text:=l_text||'';
263: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

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

259: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
260: l_text:='';
261: l_text:=l_text||fnd_number.number_to_canonical(p_people_group_id);
262: l_text:=l_text||'';
263: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
264: l_text:='';
265: if(P_ORG_NOW_NO_MANAGER_WARNING) then
266: l_text:=l_text||'TRUE';
267: else

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

267: else
268: l_text:=l_text||'FALSE';
269: end if;
270: l_text:=l_text||'';
271: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
272: l_text:='';
273: if(P_OTHER_MANAGER_WARNING) then
274: l_text:=l_text||'TRUE';
275: else

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

275: else
276: l_text:=l_text||'FALSE';
277: end if;
278: l_text:=l_text||'';
279: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
280: l_text:='';
281: if(P_SPP_DELETE_WARNING) then
282: l_text:=l_text||'TRUE';
283: else

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

283: else
284: l_text:=l_text||'FALSE';
285: end if;
286: l_text:=l_text||'';
287: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
288: l_text:='';
289: l_text:=l_text||irc_utilities_pkg.removeTags(p_entries_changed_warning);
290: l_text:=l_text||'';
291: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

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

287: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
288: l_text:='';
289: l_text:=l_text||irc_utilities_pkg.removeTags(p_entries_changed_warning);
290: l_text:=l_text||'';
291: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
292: l_text:='';
293: if(P_TAX_DISTRICT_CHANGED_WARNING) then
294: l_text:=l_text||'TRUE';
295: else

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

295: else
296: l_text:=l_text||'FALSE';
297: end if;
298: l_text:=l_text||'';
299: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
300: l_text:='';
301: l_text:=l_text||irc_utilities_pkg.removeTags(p_concat_segments);
302: l_text:=l_text||'';
303: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

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

299: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
300: l_text:='';
301: l_text:=l_text||irc_utilities_pkg.removeTags(p_concat_segments);
302: l_text:=l_text||'';
303: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
304: l_text:='';
305: --
306: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
307: --

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

302: l_text:=l_text||'';
303: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
304: l_text:='';
305: --
306: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
307: --
308: if p_effective_start_date is not NULL and
309: p_effective_start_date > trunc(SYSDATE) and
310: fnd_profile.value('HR_DEFER_FD_BE_EVENTS') = 'Y' then