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

Line 338: l_cursor_id:=dbms_sql.open_cursor;

334: l_cursor_id INTEGER;
335: l_dummy_integer INTEGER;
336: l_dummy_varchar2 VARCHAR2(255);
337: BEGIN
338: l_cursor_id:=dbms_sql.open_cursor;
339: dbms_sql.parse(l_cursor_id,p_sql_statement,dbms_sql.v7);
340:
341: BEGIN
342: i:=0;

Line 339: dbms_sql.parse(l_cursor_id,p_sql_statement,dbms_sql.v7);

335: l_dummy_integer INTEGER;
336: l_dummy_varchar2 VARCHAR2(255);
337: BEGIN
338: l_cursor_id:=dbms_sql.open_cursor;
339: dbms_sql.parse(l_cursor_id,p_sql_statement,dbms_sql.v7);
340:
341: BEGIN
342: i:=0;
343: LOOP

Line 346: dbms_sql.bind_variable(l_cursor_id,':' || p_bind_variables(i).name,to_number(p_bind_variables(i).value));

342: i:=0;
343: LOOP
344: i:=i+1;
345: if p_bind_variables(i).datatype='NUMBER' then
346: dbms_sql.bind_variable(l_cursor_id,':' || p_bind_variables(i).name,to_number(p_bind_variables(i).value));
347: elsif p_bind_variables(i).datatype='VARCHAR2' then
348: dbms_sql.bind_variable(l_cursor_id,':' || p_bind_variables(i).name,p_bind_variables(i).value);
349: elsif p_bind_variables(i).datatype='DATE' then
350: dbms_sql.bind_variable(l_cursor_id,':' || p_bind_variables(i).name,fnd_date.canonical_to_date(p_bind_variables(i).value));

Line 348: dbms_sql.bind_variable(l_cursor_id,':' || p_bind_variables(i).name,p_bind_variables(i).value);

344: i:=i+1;
345: if p_bind_variables(i).datatype='NUMBER' then
346: dbms_sql.bind_variable(l_cursor_id,':' || p_bind_variables(i).name,to_number(p_bind_variables(i).value));
347: elsif p_bind_variables(i).datatype='VARCHAR2' then
348: dbms_sql.bind_variable(l_cursor_id,':' || p_bind_variables(i).name,p_bind_variables(i).value);
349: elsif p_bind_variables(i).datatype='DATE' then
350: dbms_sql.bind_variable(l_cursor_id,':' || p_bind_variables(i).name,fnd_date.canonical_to_date(p_bind_variables(i).value));
351: end if;
352: END LOOP;

Line 350: dbms_sql.bind_variable(l_cursor_id,':' || p_bind_variables(i).name,fnd_date.canonical_to_date(p_bind_variables(i).value));

346: dbms_sql.bind_variable(l_cursor_id,':' || p_bind_variables(i).name,to_number(p_bind_variables(i).value));
347: elsif p_bind_variables(i).datatype='VARCHAR2' then
348: dbms_sql.bind_variable(l_cursor_id,':' || p_bind_variables(i).name,p_bind_variables(i).value);
349: elsif p_bind_variables(i).datatype='DATE' then
350: dbms_sql.bind_variable(l_cursor_id,':' || p_bind_variables(i).name,fnd_date.canonical_to_date(p_bind_variables(i).value));
351: end if;
352: END LOOP;
353: EXCEPTION
354: WHEN OTHERS THEN

Line 364: dbms_sql.define_column(l_cursor_id,j,l_dummy_varchar2,255);

360: j:=0;
361: LOOP
362: j:=j+1;
363: l_dummy_varchar2:=p_column_names(j);
364: dbms_sql.define_column(l_cursor_id,j,l_dummy_varchar2,255);
365: END LOOP;
366: EXCEPTION
367: WHEN OTHERS THEN
368: j:=j-1;

Line 372: l_dummy_integer:=dbms_sql.execute(l_cursor_id);

368: j:=j-1;
369: NULL;
370: END;
371:
372: l_dummy_integer:=dbms_sql.execute(l_cursor_id);
373: loop
374: -- dbms_output.put_line(rpad('=',30,'='));
375: l_dummy_integer:=dbms_sql.fetch_rows(l_cursor_id);
376: exit when l_dummy_integer<>1;

Line 375: l_dummy_integer:=dbms_sql.fetch_rows(l_cursor_id);

371:
372: l_dummy_integer:=dbms_sql.execute(l_cursor_id);
373: loop
374: -- dbms_output.put_line(rpad('=',30,'='));
375: l_dummy_integer:=dbms_sql.fetch_rows(l_cursor_id);
376: exit when l_dummy_integer<>1;
377: for i in 1..j loop
378: dbms_sql.column_value(l_cursor_id,i,l_dummy_varchar2);
379: -- dbms_output.put_line(rpad(p_column_names(i),30,' ') || ' = ' || l_dummy_varchar2);

Line 378: dbms_sql.column_value(l_cursor_id,i,l_dummy_varchar2);

374: -- dbms_output.put_line(rpad('=',30,'='));
375: l_dummy_integer:=dbms_sql.fetch_rows(l_cursor_id);
376: exit when l_dummy_integer<>1;
377: for i in 1..j loop
378: dbms_sql.column_value(l_cursor_id,i,l_dummy_varchar2);
379: -- dbms_output.put_line(rpad(p_column_names(i),30,' ') || ' = ' || l_dummy_varchar2);
380: end loop;
381: end loop;
382:

Line 383: dbms_sql.close_cursor(l_cursor_id);

379: -- dbms_output.put_line(rpad(p_column_names(i),30,' ') || ' = ' || l_dummy_varchar2);
380: end loop;
381: end loop;
382:
383: dbms_sql.close_cursor(l_cursor_id);
384: EXCEPTION
385: when others then
386: -- dbms_output.put_line(SQLERRM);
387: dbms_sql.close_cursor(l_cursor_id);

Line 387: dbms_sql.close_cursor(l_cursor_id);

383: dbms_sql.close_cursor(l_cursor_id);
384: EXCEPTION
385: when others then
386: -- dbms_output.put_line(SQLERRM);
387: dbms_sql.close_cursor(l_cursor_id);
388: END dynamic_sql;
389:
390: -----------------------------------------------------
391: -- SET_SPACE_ON_ADDRESSS --