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

Line 10026: l_cursor := dbms_sql.open_cursor;

10022: END IF;
10023:
10024:
10025: -- Get cursor handle
10026: l_cursor := dbms_sql.open_cursor;
10027:
10028: l_Exception_Desc := 'Error in Projects Import routine: ' || pa_debug.G_err_stage || ' : ' || SQLERRM;
10029:
10030: -- Associate a sql statement with the cursor.

Line 10048: dbms_sql.parse(l_cursor,l_stmt,dbms_sql.native);

10044: END IF;
10045:
10046: -- parse the sql statement to check for any syntax or symantic errors
10047:
10048: dbms_sql.parse(l_cursor,l_stmt,dbms_sql.native);
10049:
10050: -- before executing the sql statement bind the variables
10051: dbms_sql.bind_variable(l_cursor,':process',
10052: 'Projects Retrieval Process');

Line 10051: dbms_sql.bind_variable(l_cursor,':process',

10047:
10048: dbms_sql.parse(l_cursor,l_stmt,dbms_sql.native);
10049:
10050: -- before executing the sql statement bind the variables
10051: dbms_sql.bind_variable(l_cursor,':process',
10052: 'Projects Retrieval Process');
10053:
10054: dbms_sql.bind_variable(l_cursor,'status',
10055: 'ERRORS');

Line 10054: dbms_sql.bind_variable(l_cursor,'status',

10050: -- before executing the sql statement bind the variables
10051: dbms_sql.bind_variable(l_cursor,':process',
10052: 'Projects Retrieval Process');
10053:
10054: dbms_sql.bind_variable(l_cursor,'status',
10055: 'ERRORS');
10056:
10057: dbms_sql.bind_variable(l_cursor,'Exception_Desc',
10058: l_Exception_Desc);

Line 10057: dbms_sql.bind_variable(l_cursor,'Exception_Desc',

10053:
10054: dbms_sql.bind_variable(l_cursor,'status',
10055: 'ERRORS');
10056:
10057: dbms_sql.bind_variable(l_cursor,'Exception_Desc',
10058: l_Exception_Desc);
10059:
10060:
10061: l_rows := dbms_sql.execute(l_cursor);

Line 10061: l_rows := dbms_sql.execute(l_cursor);

10057: dbms_sql.bind_variable(l_cursor,'Exception_Desc',
10058: l_Exception_Desc);
10059:
10060:
10061: l_rows := dbms_sql.execute(l_cursor);
10062: IF PG_DEBUG = 'Y' THEN
10063: pa_debug.G_err_stage := 'After executing the dynamic sql OTL';
10064: log_message('log_message: ' || pa_debug.G_err_stage,1);
10065: END IF;

Line 10074: dbms_sql.close_cursor(l_cursor);

10070: pa_debug.G_err_stage := 'In excp of the dynamic sql executing OTL';
10071: log_message('log_message: ' || pa_debug.G_err_stage,1);
10072: END IF;
10073:
10074: dbms_sql.close_cursor(l_cursor);
10075: RAISE;
10076:
10077: END;
10078:

Line 10207: l_cursor := dbms_sql.open_cursor;

10203: -- For instance 'PA_SELF_SERVICE_PVT.Upload_SS_Timecard'
10204: IF ( P_program_name IS NOT NULL ) THEN
10205:
10206: -- Get cursor handle
10207: l_cursor := dbms_sql.open_cursor;
10208:
10209: -- Associate a sql statement with the cursor.
10210:
10211: l_stmt := 'BEGIN '||P_program_name||

Line 10220: dbms_sql.parse(l_cursor,l_stmt,dbms_sql.native);

10216: ' END;';
10217:
10218: -- parse the sql statemnt to check for any syntax or symantic errors
10219:
10220: dbms_sql.parse(l_cursor,l_stmt,dbms_sql.native);
10221:
10222: -- before executing the sql statement bind the variables
10223:
10224: dbms_sql.bind_variable(l_cursor,'transaction_source',

Line 10224: dbms_sql.bind_variable(l_cursor,'transaction_source',

10220: dbms_sql.parse(l_cursor,l_stmt,dbms_sql.native);
10221:
10222: -- before executing the sql statement bind the variables
10223:
10224: dbms_sql.bind_variable(l_cursor,'transaction_source',
10225: P_transaction_source);
10226: dbms_sql.bind_variable(l_cursor,'batch',
10227: P_batch);
10228: dbms_sql.bind_variable(l_cursor,'user_id',

Line 10226: dbms_sql.bind_variable(l_cursor,'batch',

10222: -- before executing the sql statement bind the variables
10223:
10224: dbms_sql.bind_variable(l_cursor,'transaction_source',
10225: P_transaction_source);
10226: dbms_sql.bind_variable(l_cursor,'batch',
10227: P_batch);
10228: dbms_sql.bind_variable(l_cursor,'user_id',
10229: P_user_id);
10230: dbms_sql.bind_variable(l_cursor,'xface_id',

Line 10228: dbms_sql.bind_variable(l_cursor,'user_id',

10224: dbms_sql.bind_variable(l_cursor,'transaction_source',
10225: P_transaction_source);
10226: dbms_sql.bind_variable(l_cursor,'batch',
10227: P_batch);
10228: dbms_sql.bind_variable(l_cursor,'user_id',
10229: P_user_id);
10230: dbms_sql.bind_variable(l_cursor,'xface_id',
10231: P_xface_id);
10232:

Line 10230: dbms_sql.bind_variable(l_cursor,'xface_id',

10226: dbms_sql.bind_variable(l_cursor,'batch',
10227: P_batch);
10228: dbms_sql.bind_variable(l_cursor,'user_id',
10229: P_user_id);
10230: dbms_sql.bind_variable(l_cursor,'xface_id',
10231: P_xface_id);
10232:
10233: l_rows := dbms_sql.execute(l_cursor);
10234:

Line 10233: l_rows := dbms_sql.execute(l_cursor);

10229: P_user_id);
10230: dbms_sql.bind_variable(l_cursor,'xface_id',
10231: P_xface_id);
10232:
10233: l_rows := dbms_sql.execute(l_cursor);
10234:
10235: dbms_sql.close_cursor(l_cursor); /* added for the bug12720784 */
10236:
10237: END IF;

Line 10235: dbms_sql.close_cursor(l_cursor); /* added for the bug12720784 */

10231: P_xface_id);
10232:
10233: l_rows := dbms_sql.execute(l_cursor);
10234:
10235: dbms_sql.close_cursor(l_cursor); /* added for the bug12720784 */
10236:
10237: END IF;
10238:
10239: EXCEPTION WHEN others THEN

Line 10240: dbms_sql.close_cursor(l_cursor);

10236:
10237: END IF;
10238:
10239: EXCEPTION WHEN others THEN
10240: dbms_sql.close_cursor(l_cursor);
10241: raise;
10242: END execute_import_extensions;
10243:
10244: PROCEDURE pre_import(P_transaction_source IN VARCHAR2,