APPS.PA_TRX_IMPORT dependencies on DBMS_SQL

Line 9235: l_cursor := dbms_sql.open_cursor;

9231: END IF;
9232:
9233:
9234: -- Get cursor handle
9235: l_cursor := dbms_sql.open_cursor;
9236:
9237: l_Exception_Desc := 'Error in Projects Import routine: ' || pa_debug.G_err_stage || ' : ' || SQLERRM;
9238:
9239: -- Associate a sql statement with the cursor.

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

9253: END IF;
9254:
9255: -- parse the sql statement to check for any syntax or symantic errors
9256:
9257: dbms_sql.parse(l_cursor,l_stmt,dbms_sql.native);
9258:
9259: -- before executing the sql statement bind the variables
9260: dbms_sql.bind_variable(l_cursor,':process',
9261: 'Projects Retrieval Process');

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

9256:
9257: dbms_sql.parse(l_cursor,l_stmt,dbms_sql.native);
9258:
9259: -- before executing the sql statement bind the variables
9260: dbms_sql.bind_variable(l_cursor,':process',
9261: 'Projects Retrieval Process');
9262:
9263: dbms_sql.bind_variable(l_cursor,'status',
9264: 'ERRORS');

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

9259: -- before executing the sql statement bind the variables
9260: dbms_sql.bind_variable(l_cursor,':process',
9261: 'Projects Retrieval Process');
9262:
9263: dbms_sql.bind_variable(l_cursor,'status',
9264: 'ERRORS');
9265:
9266: dbms_sql.bind_variable(l_cursor,'Exception_Desc',
9267: l_Exception_Desc);

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

9262:
9263: dbms_sql.bind_variable(l_cursor,'status',
9264: 'ERRORS');
9265:
9266: dbms_sql.bind_variable(l_cursor,'Exception_Desc',
9267: l_Exception_Desc);
9268:
9269:
9270: l_rows := dbms_sql.execute(l_cursor);

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

9266: dbms_sql.bind_variable(l_cursor,'Exception_Desc',
9267: l_Exception_Desc);
9268:
9269:
9270: l_rows := dbms_sql.execute(l_cursor);
9271: IF PG_DEBUG = 'Y' THEN
9272: pa_debug.G_err_stage := 'After executing the dynamic sql OTL';
9273: log_message('log_message: ' || pa_debug.G_err_stage,1);
9274: END IF;

Line 9283: dbms_sql.close_cursor(l_cursor);

9279: pa_debug.G_err_stage := 'In excp of the dynamic sql executing OTL';
9280: log_message('log_message: ' || pa_debug.G_err_stage,1);
9281: END IF;
9282:
9283: dbms_sql.close_cursor(l_cursor);
9284: RAISE;
9285:
9286: END;
9287:

Line 9416: l_cursor := dbms_sql.open_cursor;

9412: -- For instance 'PA_SELF_SERVICE_PVT.Upload_SS_Timecard'
9413: IF ( P_program_name IS NOT NULL ) THEN
9414:
9415: -- Get cursor handle
9416: l_cursor := dbms_sql.open_cursor;
9417:
9418: -- Associate a sql statement with the cursor.
9419:
9420: l_stmt := 'BEGIN '||P_program_name||

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

9425: ' END;';
9426:
9427: -- parse the sql statemnt to check for any syntax or symantic errors
9428:
9429: dbms_sql.parse(l_cursor,l_stmt,dbms_sql.native);
9430:
9431: -- before executing the sql statement bind the variables
9432:
9433: dbms_sql.bind_variable(l_cursor,'transaction_source',

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

9429: dbms_sql.parse(l_cursor,l_stmt,dbms_sql.native);
9430:
9431: -- before executing the sql statement bind the variables
9432:
9433: dbms_sql.bind_variable(l_cursor,'transaction_source',
9434: P_transaction_source);
9435: dbms_sql.bind_variable(l_cursor,'batch',
9436: P_batch);
9437: dbms_sql.bind_variable(l_cursor,'user_id',

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

9431: -- before executing the sql statement bind the variables
9432:
9433: dbms_sql.bind_variable(l_cursor,'transaction_source',
9434: P_transaction_source);
9435: dbms_sql.bind_variable(l_cursor,'batch',
9436: P_batch);
9437: dbms_sql.bind_variable(l_cursor,'user_id',
9438: P_user_id);
9439: dbms_sql.bind_variable(l_cursor,'xface_id',

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

9433: dbms_sql.bind_variable(l_cursor,'transaction_source',
9434: P_transaction_source);
9435: dbms_sql.bind_variable(l_cursor,'batch',
9436: P_batch);
9437: dbms_sql.bind_variable(l_cursor,'user_id',
9438: P_user_id);
9439: dbms_sql.bind_variable(l_cursor,'xface_id',
9440: P_xface_id);
9441:

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

9435: dbms_sql.bind_variable(l_cursor,'batch',
9436: P_batch);
9437: dbms_sql.bind_variable(l_cursor,'user_id',
9438: P_user_id);
9439: dbms_sql.bind_variable(l_cursor,'xface_id',
9440: P_xface_id);
9441:
9442: l_rows := dbms_sql.execute(l_cursor);
9443:

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

9438: P_user_id);
9439: dbms_sql.bind_variable(l_cursor,'xface_id',
9440: P_xface_id);
9441:
9442: l_rows := dbms_sql.execute(l_cursor);
9443:
9444: END IF;
9445:
9446: EXCEPTION WHEN others THEN

Line 9447: dbms_sql.close_cursor(l_cursor);

9443:
9444: END IF;
9445:
9446: EXCEPTION WHEN others THEN
9447: dbms_sql.close_cursor(l_cursor);
9448: raise;
9449: END execute_import_extensions;
9450:
9451: PROCEDURE pre_import(P_transaction_source IN VARCHAR2,