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.IRC_DOCUMENT_BE4 dependencies on DBMS_LOB

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

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

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

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

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

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

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

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

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

52: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
53: l_text:='';
54: l_text:=l_text||fnd_number.number_to_canonical(p_document_id);
55: l_text:=l_text||'';
56: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
57: l_text:='';
58: l_text:=l_text||irc_utilities_pkg.removeTags(p_type);
59: l_text:=l_text||'';
60: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

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

56: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
57: l_text:='';
58: l_text:=l_text||irc_utilities_pkg.removeTags(p_type);
59: l_text:=l_text||'';
60: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
61: l_text:='';
62: l_text:=l_text||irc_utilities_pkg.removeTags(p_mime_type);
63: l_text:=l_text||'';
64: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

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

60: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
61: l_text:='';
62: l_text:=l_text||irc_utilities_pkg.removeTags(p_mime_type);
63: l_text:=l_text||'';
64: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
65: l_text:='';
66: l_text:=l_text||irc_utilities_pkg.removeTags(p_file_name);
67: l_text:=l_text||'';
68: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

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

64: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
65: l_text:='';
66: l_text:=l_text||irc_utilities_pkg.removeTags(p_file_name);
67: l_text:=l_text||'';
68: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
69: l_text:='';
70: l_text:=l_text||irc_utilities_pkg.removeTags(p_description);
71: l_text:=l_text||'';
72: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

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

68: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
69: l_text:='';
70: l_text:=l_text||irc_utilities_pkg.removeTags(p_description);
71: l_text:=l_text||'';
72: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
73: l_text:='';
74: l_text:=l_text||fnd_number.number_to_canonical(p_person_id);
75: l_text:=l_text||'';
76: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

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

72: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
73: l_text:='';
74: l_text:=l_text||fnd_number.number_to_canonical(p_person_id);
75: l_text:=l_text||'';
76: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
77: l_text:='';
78: l_text:=l_text||fnd_number.number_to_canonical(p_party_id);
79: l_text:=l_text||'';
80: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

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

76: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
77: l_text:='';
78: l_text:=l_text||fnd_number.number_to_canonical(p_party_id);
79: l_text:=l_text||'';
80: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
81: l_text:='';
82: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_id);
83: l_text:=l_text||'';
84: 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: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
81: l_text:='';
82: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_id);
83: l_text:=l_text||'';
84: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
85: l_text:='';
86: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);
87: l_text:=l_text||'';
88: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

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

84: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
85: l_text:='';
86: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);
87: l_text:=l_text||'';
88: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
89: l_text:='';
90: l_text:=l_text||fnd_date.date_to_canonical(p_end_date);
91: l_text:=l_text||'';
92: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

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

88: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
89: l_text:='';
90: l_text:=l_text||fnd_date.date_to_canonical(p_end_date);
91: l_text:=l_text||'';
92: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
93: l_text:='';
94: --
95: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
96: --

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

91: l_text:=l_text||'';
92: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
93: l_text:='';
94: --
95: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
96: --
97: -- raise the event with the event data
98: wf_event.raise(p_event_name=>l_event_name
99: ,p_event_key=>l_event_key