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

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

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

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

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

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

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

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

46: --
47: l_text:='';
48: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date);
49: l_text:=l_text||'';
50: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
51: l_text:='';
52: l_text:=l_text||fnd_number.number_to_canonical(p_person_id);
53: l_text:=l_text||'';
54: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

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

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

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

54: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
55: l_text:='';
56: l_text:=l_text||fnd_number.number_to_canonical(p_business_group_id);
57: l_text:=l_text||'';
58: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
59: l_text:='';
60: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);
61: l_text:=l_text||'';
62: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

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

58: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
59: l_text:='';
60: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);
61: l_text:=l_text||'';
62: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
63: l_text:='';
64: l_text:=l_text||irc_utilities_pkg.removeTags(p_applicant_number);
65: l_text:=l_text||'';
66: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

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

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

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

66: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
67: l_text:='';
68: l_text:=l_text||fnd_number.number_to_canonical(p_person_type_id);
69: l_text:=l_text||'';
70: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
71: l_text:='';
72: l_text:=l_text||fnd_date.date_to_canonical(p_effective_start_date);
73: l_text:=l_text||'';
74: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

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

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

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

74: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
75: l_text:='';
76: l_text:=l_text||fnd_date.date_to_canonical(p_effective_end_date);
77: l_text:=l_text||'';
78: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
79: l_text:='';
80: if(P_APPL_OVERRIDE_WARNING) then
81: l_text:=l_text||'TRUE';
82: else

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

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

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

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