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

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

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

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

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

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

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

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

50: --
51: l_text:='';
52: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date);
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_assignment_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_assignment_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||irc_utilities_pkg.removeTags(p_datetrack_mode);
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||irc_utilities_pkg.removeTags(p_datetrack_mode);
61: l_text:=l_text||'';
62: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
63: l_text:='';
64: if(P_LOC_CHANGE_TAX_ISSUES) then
65: l_text:=l_text||'TRUE';
66: else

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

66: else
67: l_text:=l_text||'FALSE';
68: end if;
69: l_text:=l_text||'';
70: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
71: l_text:='';
72: if(P_DELETE_ASG_BUDGETS) then
73: l_text:=l_text||'TRUE';
74: else

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

74: else
75: l_text:=l_text||'FALSE';
76: end if;
77: l_text:=l_text||'';
78: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
79: l_text:='';
80: if(P_ORG_NOW_NO_MANAGER_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: if(P_ELEMENT_SALARY_WARNING) then
89: l_text:=l_text||'TRUE';
90: else

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

90: else
91: l_text:=l_text||'FALSE';
92: end if;
93: l_text:=l_text||'';
94: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
95: l_text:='';
96: if(P_ELEMENT_ENTRIES_WARNING) then
97: l_text:=l_text||'TRUE';
98: else

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

98: else
99: l_text:=l_text||'FALSE';
100: end if;
101: l_text:=l_text||'';
102: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
103: l_text:='';
104: if(P_SPP_WARNING) then
105: l_text:=l_text||'TRUE';
106: else

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

106: else
107: l_text:=l_text||'FALSE';
108: end if;
109: l_text:=l_text||'';
110: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
111: l_text:='';
112: if(P_COST_WARNING) then
113: l_text:=l_text||'TRUE';
114: else

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

114: else
115: l_text:=l_text||'FALSE';
116: end if;
117: l_text:=l_text||'';
118: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
119: l_text:='';
120: if(P_LIFE_EVENTS_EXISTS) then
121: l_text:=l_text||'TRUE';
122: else

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

122: else
123: l_text:=l_text||'FALSE';
124: end if;
125: l_text:=l_text||'';
126: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
127: l_text:='';
128: if(P_COBRA_COVERAGE_ELEMENTS) then
129: l_text:=l_text||'TRUE';
130: else

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

130: else
131: l_text:=l_text||'FALSE';
132: end if;
133: l_text:=l_text||'';
134: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
135: l_text:='';
136: if(P_ASSGT_TERM_ELEMENTS) then
137: l_text:=l_text||'TRUE';
138: else

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

138: else
139: l_text:=l_text||'FALSE';
140: end if;
141: l_text:=l_text||'';
142: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
143: l_text:='';
144: --
145: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
146: --

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

141: l_text:=l_text||'';
142: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
143: l_text:='';
144: --
145: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
146: --
147: -- raise the event with the event data
148: wf_event.raise(p_event_name=>l_event_name
149: ,p_event_key=>l_event_key