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_SUM_STORE dependencies on DBMS_SQL

Line 51: source_cursor := dbms_sql.open_cursor;

47: --
48: hr_utility.set_location('Entering: hr_sum_store.store_data', 10);
49: --
50: p_error := 0; /* Default error parameter to zero to indicate success */
51: source_cursor := dbms_sql.open_cursor;
52: --
53: -- Define column 1 as the count column
54: --
55:

Line 129: -- dbms_sql.parse(source_cursor,p_stmt,dbms_sql.v7);

125: <>
126: begin
127: l_error := false;
128: l_error_mesg := fnd_message.get_string('PER','PER_74874_PARSE_ERROR')||' '||p_item_name;
129: -- dbms_sql.parse(source_cursor,p_stmt,dbms_sql.v7);
130: hr_utility.trace('parse stmt');
131: dbms_sql.parse(source_cursor,l_new_stmt,dbms_sql.v7);
132: hr_utility.trace('complete parse stmt');
133: l_error_mesg := null;

Line 131: dbms_sql.parse(source_cursor,l_new_stmt,dbms_sql.v7);

127: l_error := false;
128: l_error_mesg := fnd_message.get_string('PER','PER_74874_PARSE_ERROR')||' '||p_item_name;
129: -- dbms_sql.parse(source_cursor,p_stmt,dbms_sql.v7);
130: hr_utility.trace('parse stmt');
131: dbms_sql.parse(source_cursor,l_new_stmt,dbms_sql.v7);
132: hr_utility.trace('complete parse stmt');
133: l_error_mesg := null;
134: fnd_message.set_name('PER','PER_74877_DEFINE_COLUMN');
135: fnd_message.set_token('NUM','1');

Line 138: dbms_sql.define_column(source_cursor,1,l_item_value_char,240);

134: fnd_message.set_name('PER','PER_74877_DEFINE_COLUMN');
135: fnd_message.set_token('NUM','1');
136: l_error_mesg := fnd_message.get;
137: If p_debug = 'Y' Then
138: dbms_sql.define_column(source_cursor,1,l_item_value_char,240);
139: Else
140: dbms_sql.define_column(source_cursor,1,l_item_value);
141: End If;
142: l_error_mesg := null;

Line 140: dbms_sql.define_column(source_cursor,1,l_item_value);

136: l_error_mesg := fnd_message.get;
137: If p_debug = 'Y' Then
138: dbms_sql.define_column(source_cursor,1,l_item_value_char,240);
139: Else
140: dbms_sql.define_column(source_cursor,1,l_item_value);
141: End If;
142: l_error_mesg := null;
143: --
144: if p_debug <> 'Y' then

Line 148: dbms_sql.define_column(source_cursor,2,l_item_value2);

144: if p_debug <> 'Y' then
145: if p_count_clause2 is not null then
146: fnd_message.set_token('NUM','2');
147: l_error_mesg := fnd_message.get;
148: dbms_sql.define_column(source_cursor,2,l_item_value2);
149: l_error_mesg := null;
150: --
151: -- Define subsequent columns based on the group by columns
152: --

Line 162: dbms_sql.define_column(source_cursor,j,l_key_value,80);

158: if hrsumrep.ktyTab.count > 0 then
159: for i in hrsumrep.ktyTab.first..hrsumrep.ktyTab.last loop
160: fnd_message.set_token('NUM',to_char(j));
161: l_error_mesg := fnd_message.get;
162: dbms_sql.define_column(source_cursor,j,l_key_value,80);
163: l_error_mesg := null;
164: j := j + 1;
165: end loop;
166: end if;

Line 179: dbms_sql.define_column(source_cursor,j,l_key_value,80);

175: for i in nvl(hrsumrep.ktyTab.first,1)..l_columns_required loop
176: fnd_message.set_token('NUM',to_char(j));
177: l_error_mesg := fnd_message.get;
178: hr_utility.trace('define col');
179: dbms_sql.define_column(source_cursor,j,l_key_value,80);
180: hr_utility.trace('define col2');
181: l_error_mesg := null;
182: j := j + 1;
183: end loop;

Line 188: ignore := dbms_sql.execute(source_cursor);

184: end if;
185: end if;
186: --
187: l_error_mesg := fnd_message.get_string('PER','PER_74875_EXECUTE_ERROR')||' '||p_item_name;
188: ignore := dbms_sql.execute(source_cursor);
189: l_error_mesg := null;
190: --
191: z := 0;
192: loop

Line 193: if dbms_sql.fetch_rows(source_cursor) > 0 then

189: l_error_mesg := null;
190: --
191: z := 0;
192: loop
193: if dbms_sql.fetch_rows(source_cursor) > 0 then
194: fnd_message.set_name('PER','PER_74878_COLUMN_VALUE');
195: fnd_message.set_token('NUM','1');
196: l_error_mesg := fnd_message.get;
197:

Line 200: dbms_sql.column_value(source_cursor,1,l_item_value_char);

196: l_error_mesg := fnd_message.get;
197:
198: if p_debug = 'Y' then
199: hr_utility.trace(' col value');
200: dbms_sql.column_value(source_cursor,1,l_item_value_char);
201: hrsumrep.write_stmt_log(p_stmt => null);
202: hrsumrep.write_stmt_log(p_stmt => '***** PERSON NAME is ' || l_item_value_char);
203: else
204: dbms_sql.column_value(source_cursor,1,l_item_value);

Line 204: dbms_sql.column_value(source_cursor,1,l_item_value);

200: dbms_sql.column_value(source_cursor,1,l_item_value_char);
201: hrsumrep.write_stmt_log(p_stmt => null);
202: hrsumrep.write_stmt_log(p_stmt => '***** PERSON NAME is ' || l_item_value_char);
203: else
204: dbms_sql.column_value(source_cursor,1,l_item_value);
205: end if;
206:
207: l_error_mesg := null;
208:

Line 214: dbms_sql.column_value(source_cursor,2,l_item_value2);

210:
211: if p_count_clause2 is not null then
212: fnd_message.set_token('NUM','2');
213: l_error_mesg := fnd_message.get;
214: dbms_sql.column_value(source_cursor,2,l_item_value2);
215: l_error_mesg := null;
216: end if;
217: --
218: -- Populate the Item Value Row

Line 239: dbms_sql.column_value(source_cursor,j,l_key_value);

235: if hrsumrep.ktyTab.count > 0 then
236: for i in hrsumrep.ktyTab.first..hrsumrep.ktyTab.last loop
237: fnd_message.set_token('NUM',to_char(j));
238: l_error_mesg := fnd_message.get;
239: dbms_sql.column_value(source_cursor,j,l_key_value);
240: l_error_mesg := null;
241: --
242: -- Populate the key value
243: --

Line 292: dbms_sql.column_value(source_cursor,j,l_key_value);

288: l_concat_debug_string := ' ';
289: for i in l_start_index..(l_columns_required-1) loop
290: fnd_message.set_token('NUM',to_char(j));
291: l_error_mesg := fnd_message.get;
292: dbms_sql.column_value(source_cursor,j,l_key_value);
293: l_error_mesg := null;
294: if i < ColNameTab.count then
295: --hrsumrep.write_stmt_log(ColNameTab(i).Col_Name || ' = ' || l_key_value);
296: l_concat_debug_string := l_concat_debug_string || ' ' || ColNameTab(i).Col_Name || ' ' || l_key_value

Line 337: dbms_sql.close_cursor(source_cursor);

333: -- hrsumrep.write_stmt_log(p_stmt => p_stmt);
334: hrsumrep.write_stmt_log(p_stmt => l_new_stmt);
335: end if;
336: end dynamic_block;
337: dbms_sql.close_cursor(source_cursor);
338: end store_data;
339:
340: end hr_sum_store;