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.PAY_ARCHIVE_CHEQUEWRITER dependencies on DBMS_SQL

Line 206: sql_cur := dbms_sql.open_cursor;

202: BEGIN
203: hr_utility.trace('p_document_type: '||p_document_type);
204: hr_utility.trace('p_legislation_code: '||p_legislation_code);
205: get_xml_statem := 'BEGIN PAY_'||p_legislation_code||'_RULES.get_custom_xml_routine(:lv_document_type, :lv_xml_routine); END;';
206: sql_cur := dbms_sql.open_cursor;
207: dbms_sql.parse(sql_cur
208: ,get_xml_statem
209: ,dbms_sql.v7);
210: dbms_sql.bind_variable(sql_cur, 'lv_document_type', p_document_type, 50);

Line 207: dbms_sql.parse(sql_cur

203: hr_utility.trace('p_document_type: '||p_document_type);
204: hr_utility.trace('p_legislation_code: '||p_legislation_code);
205: get_xml_statem := 'BEGIN PAY_'||p_legislation_code||'_RULES.get_custom_xml_routine(:lv_document_type, :lv_xml_routine); END;';
206: sql_cur := dbms_sql.open_cursor;
207: dbms_sql.parse(sql_cur
208: ,get_xml_statem
209: ,dbms_sql.v7);
210: dbms_sql.bind_variable(sql_cur, 'lv_document_type', p_document_type, 50);
211: dbms_sql.bind_variable(sql_cur, 'lv_xml_routine', lv_custom_xml_code, 50);

Line 209: ,dbms_sql.v7);

205: get_xml_statem := 'BEGIN PAY_'||p_legislation_code||'_RULES.get_custom_xml_routine(:lv_document_type, :lv_xml_routine); END;';
206: sql_cur := dbms_sql.open_cursor;
207: dbms_sql.parse(sql_cur
208: ,get_xml_statem
209: ,dbms_sql.v7);
210: dbms_sql.bind_variable(sql_cur, 'lv_document_type', p_document_type, 50);
211: dbms_sql.bind_variable(sql_cur, 'lv_xml_routine', lv_custom_xml_code, 50);
212: l_rows := dbms_sql.execute(sql_cur);
213: dbms_sql.variable_value(sql_cur, 'lv_xml_routine', lv_custom_xml_code);

Line 210: dbms_sql.bind_variable(sql_cur, 'lv_document_type', p_document_type, 50);

206: sql_cur := dbms_sql.open_cursor;
207: dbms_sql.parse(sql_cur
208: ,get_xml_statem
209: ,dbms_sql.v7);
210: dbms_sql.bind_variable(sql_cur, 'lv_document_type', p_document_type, 50);
211: dbms_sql.bind_variable(sql_cur, 'lv_xml_routine', lv_custom_xml_code, 50);
212: l_rows := dbms_sql.execute(sql_cur);
213: dbms_sql.variable_value(sql_cur, 'lv_xml_routine', lv_custom_xml_code);
214: dbms_sql.close_cursor(sql_cur);

Line 211: dbms_sql.bind_variable(sql_cur, 'lv_xml_routine', lv_custom_xml_code, 50);

207: dbms_sql.parse(sql_cur
208: ,get_xml_statem
209: ,dbms_sql.v7);
210: dbms_sql.bind_variable(sql_cur, 'lv_document_type', p_document_type, 50);
211: dbms_sql.bind_variable(sql_cur, 'lv_xml_routine', lv_custom_xml_code, 50);
212: l_rows := dbms_sql.execute(sql_cur);
213: dbms_sql.variable_value(sql_cur, 'lv_xml_routine', lv_custom_xml_code);
214: dbms_sql.close_cursor(sql_cur);
215: hr_utility.trace('lv_custom_xml_code: '||lv_custom_xml_code);

Line 212: l_rows := dbms_sql.execute(sql_cur);

208: ,get_xml_statem
209: ,dbms_sql.v7);
210: dbms_sql.bind_variable(sql_cur, 'lv_document_type', p_document_type, 50);
211: dbms_sql.bind_variable(sql_cur, 'lv_xml_routine', lv_custom_xml_code, 50);
212: l_rows := dbms_sql.execute(sql_cur);
213: dbms_sql.variable_value(sql_cur, 'lv_xml_routine', lv_custom_xml_code);
214: dbms_sql.close_cursor(sql_cur);
215: hr_utility.trace('lv_custom_xml_code: '||lv_custom_xml_code);
216: RETURN lv_custom_xml_code;

Line 213: dbms_sql.variable_value(sql_cur, 'lv_xml_routine', lv_custom_xml_code);

209: ,dbms_sql.v7);
210: dbms_sql.bind_variable(sql_cur, 'lv_document_type', p_document_type, 50);
211: dbms_sql.bind_variable(sql_cur, 'lv_xml_routine', lv_custom_xml_code, 50);
212: l_rows := dbms_sql.execute(sql_cur);
213: dbms_sql.variable_value(sql_cur, 'lv_xml_routine', lv_custom_xml_code);
214: dbms_sql.close_cursor(sql_cur);
215: hr_utility.trace('lv_custom_xml_code: '||lv_custom_xml_code);
216: RETURN lv_custom_xml_code;
217: Exception

Line 214: dbms_sql.close_cursor(sql_cur);

210: dbms_sql.bind_variable(sql_cur, 'lv_document_type', p_document_type, 50);
211: dbms_sql.bind_variable(sql_cur, 'lv_xml_routine', lv_custom_xml_code, 50);
212: l_rows := dbms_sql.execute(sql_cur);
213: dbms_sql.variable_value(sql_cur, 'lv_xml_routine', lv_custom_xml_code);
214: dbms_sql.close_cursor(sql_cur);
215: hr_utility.trace('lv_custom_xml_code: '||lv_custom_xml_code);
216: RETURN lv_custom_xml_code;
217: Exception
218: WHEN OTHERS THEN

Line 222: IF dbms_sql.IS_OPEN(sql_cur) THEN

218: WHEN OTHERS THEN
219: lv_custom_xml_code := null;
220: hr_utility.trace('lv_custom_xml_code in the exceptions clause: '||lv_custom_xml_code);
221: --
222: IF dbms_sql.IS_OPEN(sql_cur) THEN
223: dbms_sql.close_cursor(sql_cur);
224: END IF;
225: RETURN lv_custom_xml_code;
226: END get_custom_xml;

Line 223: dbms_sql.close_cursor(sql_cur);

219: lv_custom_xml_code := null;
220: hr_utility.trace('lv_custom_xml_code in the exceptions clause: '||lv_custom_xml_code);
221: --
222: IF dbms_sql.IS_OPEN(sql_cur) THEN
223: dbms_sql.close_cursor(sql_cur);
224: END IF;
225: RETURN lv_custom_xml_code;
226: END get_custom_xml;
227: