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_BEA 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_number.number_to_canonical(p_assignment_id);
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_number.number_to_canonical(p_assignment_id);
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||fnd_number.number_to_canonical(p_object_version_number);
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||fnd_number.number_to_canonical(p_object_version_number);
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_date.date_to_canonical(p_final_process_date);
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_date.date_to_canonical(p_final_process_date);
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_start_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_start_date);
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_date.date_to_canonical(p_effective_end_date);
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_date.date_to_canonical(p_effective_end_date);
64: l_text:=l_text||'';
65: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
66: l_text:='';
67: if(P_ORG_NOW_NO_MANAGER_WARNING) then
68: l_text:=l_text||'TRUE';
69: else

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

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

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

77: else
78: l_text:=l_text||'FALSE';
79: end if;
80: l_text:=l_text||'';
81: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
82: l_text:='';
83: l_text:=l_text||irc_utilities_pkg.removeTags(p_entries_changed_warning);
84: l_text:=l_text||'';
85: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

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

81: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
82: l_text:='';
83: l_text:=l_text||irc_utilities_pkg.removeTags(p_entries_changed_warning);
84: l_text:=l_text||'';
85: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
86: l_text:='';
87: --
88: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
89: --

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

84: l_text:=l_text||'';
85: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
86: l_text:='';
87: --
88: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
89: --
90: if p_effective_start_date is not NULL and
91: p_effective_start_date > trunc(SYSDATE) and
92: fnd_profile.value('HR_DEFER_FD_BE_EVENTS') = 'Y' then