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

Line 2217: cur_insert := dbms_sql.open_cursor;

2213: -- Execute the Dynamic SQL Insert Statement
2214:
2215: -- dbms_output.put_line('build dynamic sql');
2216:
2217: cur_insert := dbms_sql.open_cursor;
2218: dbms_sql.parse(cur_insert, g_sql_insert, dbms_sql.v7);
2219:
2220: dbms_sql.bind_variable(cur_insert, 'packet_id', g_packetid);
2221: dbms_sql.bind_variable(cur_insert, 'status_code', l_status);

Line 2218: dbms_sql.parse(cur_insert, g_sql_insert, dbms_sql.v7);

2214:
2215: -- dbms_output.put_line('build dynamic sql');
2216:
2217: cur_insert := dbms_sql.open_cursor;
2218: dbms_sql.parse(cur_insert, g_sql_insert, dbms_sql.v7);
2219:
2220: dbms_sql.bind_variable(cur_insert, 'packet_id', g_packetid);
2221: dbms_sql.bind_variable(cur_insert, 'status_code', l_status);
2222: dbms_sql.bind_variable(cur_insert, 'user_id', g_userid);

Line 2220: dbms_sql.bind_variable(cur_insert, 'packet_id', g_packetid);

2216:
2217: cur_insert := dbms_sql.open_cursor;
2218: dbms_sql.parse(cur_insert, g_sql_insert, dbms_sql.v7);
2219:
2220: dbms_sql.bind_variable(cur_insert, 'packet_id', g_packetid);
2221: dbms_sql.bind_variable(cur_insert, 'status_code', l_status);
2222: dbms_sql.bind_variable(cur_insert, 'user_id', g_userid);
2223: dbms_sql.bind_variable(cur_insert, 'override_period', g_override_period);
2224: dbms_sql.bind_variable(cur_insert, 'object_id', l_objectid);

Line 2221: dbms_sql.bind_variable(cur_insert, 'status_code', l_status);

2217: cur_insert := dbms_sql.open_cursor;
2218: dbms_sql.parse(cur_insert, g_sql_insert, dbms_sql.v7);
2219:
2220: dbms_sql.bind_variable(cur_insert, 'packet_id', g_packetid);
2221: dbms_sql.bind_variable(cur_insert, 'status_code', l_status);
2222: dbms_sql.bind_variable(cur_insert, 'user_id', g_userid);
2223: dbms_sql.bind_variable(cur_insert, 'override_period', g_override_period);
2224: dbms_sql.bind_variable(cur_insert, 'object_id', l_objectid);
2225:

Line 2222: dbms_sql.bind_variable(cur_insert, 'user_id', g_userid);

2218: dbms_sql.parse(cur_insert, g_sql_insert, dbms_sql.v7);
2219:
2220: dbms_sql.bind_variable(cur_insert, 'packet_id', g_packetid);
2221: dbms_sql.bind_variable(cur_insert, 'status_code', l_status);
2222: dbms_sql.bind_variable(cur_insert, 'user_id', g_userid);
2223: dbms_sql.bind_variable(cur_insert, 'override_period', g_override_period);
2224: dbms_sql.bind_variable(cur_insert, 'object_id', l_objectid);
2225:
2226: if INSTR(g_sql_insert, ':recreate_demand', 1) > 0 then

Line 2223: dbms_sql.bind_variable(cur_insert, 'override_period', g_override_period);

2219:
2220: dbms_sql.bind_variable(cur_insert, 'packet_id', g_packetid);
2221: dbms_sql.bind_variable(cur_insert, 'status_code', l_status);
2222: dbms_sql.bind_variable(cur_insert, 'user_id', g_userid);
2223: dbms_sql.bind_variable(cur_insert, 'override_period', g_override_period);
2224: dbms_sql.bind_variable(cur_insert, 'object_id', l_objectid);
2225:
2226: if INSTR(g_sql_insert, ':recreate_demand', 1) > 0 then
2227: dbms_sql.bind_variable(cur_insert, 'recreate_demand', g_recreate_demand);

Line 2224: dbms_sql.bind_variable(cur_insert, 'object_id', l_objectid);

2220: dbms_sql.bind_variable(cur_insert, 'packet_id', g_packetid);
2221: dbms_sql.bind_variable(cur_insert, 'status_code', l_status);
2222: dbms_sql.bind_variable(cur_insert, 'user_id', g_userid);
2223: dbms_sql.bind_variable(cur_insert, 'override_period', g_override_period);
2224: dbms_sql.bind_variable(cur_insert, 'object_id', l_objectid);
2225:
2226: if INSTR(g_sql_insert, ':recreate_demand', 1) > 0 then
2227: dbms_sql.bind_variable(cur_insert, 'recreate_demand', g_recreate_demand);
2228: end if;

Line 2227: dbms_sql.bind_variable(cur_insert, 'recreate_demand', g_recreate_demand);

2223: dbms_sql.bind_variable(cur_insert, 'override_period', g_override_period);
2224: dbms_sql.bind_variable(cur_insert, 'object_id', l_objectid);
2225:
2226: if INSTR(g_sql_insert, ':recreate_demand', 1) > 0 then
2227: dbms_sql.bind_variable(cur_insert, 'recreate_demand', g_recreate_demand);
2228: end if;
2229:
2230: -- dbms_output.put_line('before execute of sql statement'||cur_insert);
2231:

Line 2232: num_insert := dbms_sql.execute(cur_insert);

2228: end if;
2229:
2230: -- dbms_output.put_line('before execute of sql statement'||cur_insert);
2231:
2232: num_insert := dbms_sql.execute(cur_insert);
2233: dbms_sql.close_cursor(cur_insert);
2234:
2235: -- dbms_output.put_line('inserted'||num_insert||' records in gl_bc');
2236:

Line 2233: dbms_sql.close_cursor(cur_insert);

2229:
2230: -- dbms_output.put_line('before execute of sql statement'||cur_insert);
2231:
2232: num_insert := dbms_sql.execute(cur_insert);
2233: dbms_sql.close_cursor(cur_insert);
2234:
2235: -- dbms_output.put_line('inserted'||num_insert||' records in gl_bc');
2236:
2237: -- FRKHAN bug 941171

Line 2258: if dbms_sql.is_open(cur_insert) then

2254: if pkt_id%ISOPEN then
2255: close pkt_id;
2256: end if;
2257:
2258: if dbms_sql.is_open(cur_insert) then
2259: dbms_sql.close_cursor(cur_insert);
2260: end if;
2261:
2262: PO_MESSAGE_S.SQL_ERROR(routine => 'PO_FUNDS_CHECKER',

Line 2259: dbms_sql.close_cursor(cur_insert);

2255: close pkt_id;
2256: end if;
2257:
2258: if dbms_sql.is_open(cur_insert) then
2259: dbms_sql.close_cursor(cur_insert);
2260: end if;
2261:
2262: PO_MESSAGE_S.SQL_ERROR(routine => 'PO_FUNDS_CHECKER',
2263: location => '120',