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

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

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

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

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

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

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

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

47: --
48: l_text:='';
49: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_id);
50: l_text:=l_text||'';
51: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
52: l_text:='';
53: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);
54: l_text:=l_text||'';
55: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

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

51: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
52: l_text:='';
53: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);
54: l_text:=l_text||'';
55: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
56: l_text:='';
57: l_text:=l_text||fnd_date.date_to_canonical(p_actual_termination_date);
58: l_text:=l_text||'';
59: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

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

55: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
56: l_text:='';
57: l_text:=l_text||fnd_date.date_to_canonical(p_actual_termination_date);
58: l_text:=l_text||'';
59: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
60: l_text:='';
61: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_status_type_id);
62: l_text:=l_text||'';
63: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

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

59: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
60: l_text:='';
61: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_status_type_id);
62: l_text:=l_text||'';
63: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
64: l_text:='';
65: l_text:=l_text||fnd_date.date_to_canonical(p_effective_start_date);
66: l_text:=l_text||'';
67: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

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

63: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
64: l_text:='';
65: l_text:=l_text||fnd_date.date_to_canonical(p_effective_start_date);
66: l_text:=l_text||'';
67: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
68: l_text:='';
69: l_text:=l_text||fnd_date.date_to_canonical(p_effective_end_date);
70: l_text:=l_text||'';
71: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

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

67: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
68: l_text:='';
69: l_text:=l_text||fnd_date.date_to_canonical(p_effective_end_date);
70: l_text:=l_text||'';
71: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
72: l_text:='';
73: if(P_ASG_FUTURE_CHANGES_WARNING) then
74: l_text:=l_text||'TRUE';
75: else

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

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

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

79: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
80: l_text:='';
81: l_text:=l_text||irc_utilities_pkg.removeTags(p_entries_changed_warning);
82: l_text:=l_text||'';
83: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
84: l_text:='';
85: if(P_PAY_PROPOSAL_WARNING) then
86: l_text:=l_text||'TRUE';
87: else

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

87: else
88: l_text:=l_text||'FALSE';
89: end if;
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||fnd_number.number_to_canonical(p_business_group_id);
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||fnd_number.number_to_canonical(p_business_group_id);
94: l_text:=l_text||'';
95: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
96: l_text:='';
97: --
98: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
99: --

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

94: l_text:=l_text||'';
95: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
96: l_text:='';
97: --
98: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
99: --
100: if p_effective_start_date is not NULL and
101: p_effective_start_date > trunc(SYSDATE) and
102: fnd_profile.value('HR_DEFER_FD_BE_EVENTS') = 'Y' then