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

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

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

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

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

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

40: dbms_lob.createTemporary(l_event_data,false,dbms_lob.call);
41: l_text:='';
42: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
43: l_text:='';
44: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
45: --
46: l_text:='';
47: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date);
48: l_text:=l_text||'';

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

45: --
46: l_text:='';
47: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date);
48: l_text:=l_text||'';
49: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
50: l_text:='';
51: l_text:=l_text||irc_utilities_pkg.removeTags(p_datetrack_update_mode);
52: l_text:=l_text||'';
53: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

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

49: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
50: l_text:='';
51: l_text:=l_text||irc_utilities_pkg.removeTags(p_datetrack_update_mode);
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_assignment_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_assignment_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_number.number_to_canonical(p_object_version_number);
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_number.number_to_canonical(p_object_version_number);
60: l_text:=l_text||'';
61: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
62: l_text:='';
63: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_status_type_id);
64: l_text:=l_text||'';
65: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

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

61: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
62: l_text:='';
63: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_status_type_id);
64: l_text:=l_text||'';
65: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
66: l_text:='';
67: l_text:=l_text||irc_utilities_pkg.removeTags(p_change_reason);
68: l_text:=l_text||'';
69: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

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

65: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
66: l_text:='';
67: l_text:=l_text||irc_utilities_pkg.removeTags(p_change_reason);
68: l_text:=l_text||'';
69: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
70: l_text:='';
71: l_text:=l_text||fnd_date.date_to_canonical(p_effective_start_date);
72: l_text:=l_text||'';
73: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

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

69: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
70: l_text:='';
71: l_text:=l_text||fnd_date.date_to_canonical(p_effective_start_date);
72: l_text:=l_text||'';
73: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
74: l_text:='';
75: l_text:=l_text||fnd_date.date_to_canonical(p_effective_end_date);
76: l_text:=l_text||'';
77: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

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

73: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
74: l_text:='';
75: l_text:=l_text||fnd_date.date_to_canonical(p_effective_end_date);
76: l_text:=l_text||'';
77: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
78: l_text:='';
79: --
80: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
81: --

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

76: l_text:=l_text||'';
77: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
78: l_text:='';
79: --
80: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
81: --
82: if p_effective_start_date is not NULL and
83: p_effective_start_date > trunc(SYSDATE) and
84: fnd_profile.value('HR_DEFER_FD_BE_EVENTS') = 'Y' then